A.7.1 Procedure: upd_uoc
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_UOC_ID |
NUMBER(12) |
IN |
P_COL_ARR |
RECORD |
IN |
COL_NAME |
TABLE OF VARCHAR2(255) |
IN |
COL_VALUE |
TABLE OF VARCHAR2(255) |
IN |
P_RESULT |
VARCHAR2 |
OUT |
P_COMMIT_IND |
VARCHAR2 |
IN; DEFAULT ‘Y’ |
Column Name |
Prompt on D.50.12 |
Allowable values |
---|---|---|
COST_VALUE |
Cost Value |
0 – 99999999999.99 |
CURRENCY_CODE |
Currency |
All units in the ‘currency’ unit group |
EVAL_COST_IND |
Eval Cost |
‘Y’, ‘N’ |
JOB_NUMBER |
Account Code |
All account codes defined on A.10.30 |
OC_CODE |
Other Cost |
All other costs defined on P.10.33 |
UNIT_PRICE_TYPE |
Unit Price Type |
NULL, ‘I’, ‘E’, ‘Q’, ‘R’ |
A.7.2 Procedure: upd_uocn
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_UOC_ID |
NUMBER(12) |
IN |
P_NLS_ID |
NUMBER(2) |
IN |
P_COL_ARR |
RECORD |
IN |
COL_NAME |
TABLE OF VARCHAR2(255) |
IN |
COL_VALUE |
TABLE OF VARCHAR2(255) |
IN |
P_RESULT |
VARCHAR2 |
OUT |
P_COMMIT_IND |
VARCHAR2 |
IN; DEFAULT ‘Y’ |
Column Name |
Prompt on D.50.12 |
Allowable values |
---|---|---|
DESCRIPTION |
Description |
|
SHORT_DESC |
Short Desc |
A.7.3 Procedure: ins_uoc
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_TERM_TYPE |
VARCHAR2(3) |
IN |
P_PK_ID |
NUMBER(12) |
IN |
P_COL_ARR |
RECORD |
IN |
COL_NAME |
TABLE OF VARCHAR2(255) |
IN |
COL_VALUE |
TABLE OF VARCHAR2(255) |
IN |
P_RESULT |
VARCHAR2 |
OUT |
P_UOC_ID |
NUMBER(12) |
OUT |
P_COMMIT_IND |
VARCHAR2 |
IN; DEFAULT ‘Y’ |
Column Name |
Prompt on D.50.12 |
Allowable values |
---|---|---|
COST_VALUE |
Cost Value |
0 – 99999999999.99 |
CURRENCY_CODE |
Currency |
All units in the ‘currency’ unit group |
JOB_NUMBER |
Account Code |
All account codes defined on A.10.30 |
OC_CODE |
Other Cost |
All other costs defined on P.10.33 |
UNIT_PRICE_TYPE |
Unit Price Type |
NULL, ‘I’, ‘E’, ‘Q’, ‘R’ |
A.7.4 Procedure: ins_uocn
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_UOC_ID |
NUMBER(12) |
IN |
P_NLS_ID |
NUMBER(2) |
IN |
P_COL_ARR |
RECORD |
IN |
COL_NAME |
TABLE OF VARCHAR2(255) |
IN |
COL_VALUE |
TABLE OF VARCHAR2(255) |
IN |
P_RESULT |
VARCHAR2 |
OUT |
P_COMMIT_IND |
VARCHAR2 |
IN; DEFAULT ‘Y’ |
Column Name |
Prompt on D.50.12 |
Allowable values |
---|---|---|
DESCRIPTION |
Description |
|
SHORT_DESC |
Short Desc |