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 |