|
Argument Name |
Type |
In/Out |
|---|---|---|
|
P_US_ID |
NUMBER(12) |
IN |
|
P_QS_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 |
|---|---|---|
|
CONFIRM_RFQ_RECV_IND |
Conf RFQ Recvd |
‘Y’, ‘N’ |
|
CURRENCY_CODE |
Currency |
All units in the ‘currency’ unit group |
|
DISCOUNT_PERCENT |
Discount % |
0 – 999.99 |
|
ESCALATION_DAYS |
Validity |
0 –999 |
|
ESCALATION_NOTICE |
Escalation Notice |
|
|
ESCALATION_PERCENT |
Escalation % |
0 – 999.99 |
|
INTEREST_RATE |
Interest Rate |
0 – 999.99 |
|
NO_BID_IND |
No Bid |
‘Y’, ‘N’ |
|
QUOTE_DATE |
Quote Date |
|
|
QUOTE_RECV_BY |
Quote Recv By |
All Smart Materials users |
|
QUOTE_RECV_DATE |
Quote Recv Date |
|
|
QUOTE_REF_NUMBER |
Quote Ref Number |
|
|
RESTOCKING_PERCENT |
Restocking % |
0 – 999.99 |
|
SEND_TO_SUPP_DATE |
Issue Date |
|
|
VOL_CODE |
Volume Unit |
All units in the ’volume’ unit group |
|
WEIGHT_CODE |
Weight Unit |
All units in the ’weight’ unit group |