A.8.1 Table: m_qs_cecs, Procedure: upd_qc
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_QC_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 |
|
Column Name |
Prompt on P.30.22 |
Allowable values |
|---|---|---|
|
EVALUATION_TEXT |
Evaluation Text |
A.8.2 Table: m_att_vdrs, Procedure: upd_attv
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_ATTV_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 |
|
Column Name |
Prompt on D.40.21 |
Allowable values |
|---|---|---|
|
PROMISE_WEEKS |
PW |
0 – 999 |
A.8.3 Table: m_used_comments, Procedure: ins_uc
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_PK_ID1 |
NUMBER(12) |
IN |
|
P_TABLE_NAME |
VARCHAR2(30) |
IN |
|
P_COL_ARR |
RECORD |
IN |
|
COL_NAME |
TABLE OF VARCHAR2(255) |
IN |
|
COL_VALUE |
TABLE OF VARCHAR2(255) |
IN |
|
P_RESULT |
VARCHAR2 |
OUT |
|
Column Name |
Prompt in D.50.21 |
Allowable values |
|---|---|---|
|
USED_COMMENT |
Comment |
A.8.4 Table: m_att_ppes, Procedure: ins_attp
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_PK_TYPE |
VARCHAR2(5) |
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_ATTP_ID |
NUMBER(12) |
OUT |
|
Column Name |
Prompt on D.50.13 |
Allowable values |
|---|---|---|
|
PPE_CODE |
Prog Pay Event |
All progress payment events defined on P.10.31 |
A.8.5 Table: m_att_terms, Procedure: ins_attt
|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_PK_TYPE |
VARCHAR2(5) |
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 |
|
Column Name |
Prompt on D.20.21 |
Allowable values |
|---|---|---|
|
DESCRIPTION |
Description |
|
|
ORDER_SEQ |
Seq |
0 – 99999 |
|
TERM_PLACEMENT |
Placement |
‘F’, ‘H’ |