A.4.1 Procedure: upd_poh
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_POH_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 P.50.07 |
Allowable values |
---|---|---|
BUYER |
Buyer |
All Smart Materials users with the ‘BUYER’ privilege (in the current project) |
CCP_CODE |
Contact |
Any supplier’s employee defined on A.10.29 |
CLIENT_PO_NUMBER |
Client PO Num |
|
COMMENTS_SETTLED_IND |
Comments Settled |
‘Y’, ‘N’ |
CY_CODE |
Country Code |
All countries defined on A.10.34 |
EV_CODE |
Exped. View |
All views defined on P.10.71 |
EXPEDITER |
Expediter |
All Smart Materials users with the ‘EXPEDITER’ privilege (in the current project) |
EXPED_ILV_CODE |
Exp Level |
All expediting levels defined on P.10.55 |
ILV_CODE |
Insp Level |
All inspection levels defined on P.10.55 |
JOB_NUMBER |
Account Code |
All account codes defined on A.10.30 |
LAST_CONTACT_DATE |
Last Contact (P.70. 71) |
Any valid date |
MANUFACTURER |
Manufacturer |
|
NEXT_CONTACT_DATE |
Next Contact (P.70. 71) |
Any valid date |
ORG_ETA_SITE_DATE |
ETA Site |
Any valid date |
PERFORMANCE_SCORE |
Perf Score |
|
PO_ISSUE_DATE |
Issued |
Any valid date |
PO_NUMBER |
PO Number |
|
POINT_OF_ORIGIN |
Point of Origin |
|
READY_FOR_APPROVAL_IND |
Ready for Approval |
‘Y’, ‘N’ |
RECV_ACKNOWLEDGE_DATE |
Recv Acknow |
Any valid date |
SUP_CODE |
Supplier |
Depending on the ZP_PROJSUP project default, either all suppliers (ZP_PROJSUP = ‘N’)
|
TECH_EVAL_COMP_DATE |
Tech Eval Comp Date |
Any valid date |
TRAFFIC |
Traffic |
All Smart Materials users with the ‘TRAFFIC’ privilege (in the current project) |
A.4.2 Procedure: ins_poh
Use this procedure to insert orders of types ‘PO’ and ‘MP’. Change orders (type ‘CO’) can only be created for (manual) purchase orders, not for blanket orders or notices of commitment. Manual POs referencing a blanket order cannot be created.
If you want to create a change order, only the ORDER_TYPE and PARENT_ORDER columns are mandatory. All other values are copied from the referenced, previous order. But if any of the other fields are to be changed, you can pass them to the procedure, and they are placed on the new change order.
The primary key of the newly created order is returned to the calling program (p_poh_id parameter).
Argument Name |
Type |
In/Out |
---|---|---|
P_US_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_POH_ID |
NUMBER(12) |
OUT |
P_COMMIT_IND |
VARCHAR2 |
IN; DEFAULT ‘Y’ |
Column Name |
Prompt in P.50.07 |
Allowable values |
---|---|---|
BUYER |
Buyer |
All Smart Materials users with the ‘BUYER’ privilege (in the current project) |
CCP_CODE |
Contact |
Any supplier’s employee defined on A.10.29 |
CLIENT_PO_NUMBER |
Client PO Num |
|
CURRENCY_CODE |
Currency |
All units in the ‘currency’ unit group; only valid for ‘PO’, ‘MP’ |
CY_CODE |
Country Code |
All countries defined on A.10.34 |
EV_CODE |
Exped. View |
All views defined on P.10.71 |
EXPEDITER |
Expediter |
All Smart Materials users with the ‘EXPEDITER’ privilege (in the current project) |
EXPED_ILV_CODE |
Exp Level |
All expediting levels defined on P.10.55 |
ILV_CODE |
Insp Level |
All inspection levels defined on P.10.55 |
ISSUED_BY |
Issued by |
All origins defined on A.10.33; only for ‘PO’, ‘MP’ |
JOB_NUMBER |
Account Code |
All account codes defined on A.10.30 |
ORDER_TYPE |
Type |
‘PO’, ‘MP’, ‘CO’ |
ORIGIN |
Origin |
All origins defined on A.10.33; only for ‘PO’, ‘MP’ |
ORG_ETA_SITE_DATE |
ETA Site |
Any valid date |
PARENT_ORDER |
Primary key of any approved order of types ‘PO’, ‘MP’; mandatory field when inserting a change order |
|
PO_NUMBER |
PO Number |
|
POINT_OF_ORIGIN |
Point of Origin |
|
RM_CODE |
Routing Method |
All routing methods defined on P.10.53; only for ‘PO’, ‘MP’ |
SUP_CODE |
Supplier |
Depending on the ZP_PROJSUP project default, either all suppliers (ZP_PROJSUP = ‘N’)
|
TRAFFIC |
Traffic |
All Smart Materials users with the ‘TRAFFIC’ privilege (in the current project) |
A.4.3 Procedure: upd_nls
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_POH_ID |
NUMBER(12) |
IN |
P_NLS_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 in P.50.07 |
Allowable values |
---|---|---|
DESCRIPTION |
Description |
|
SHORT_DESC |
Short Desc |
A.4.4 Procedure: ins_nls
Argument Name |
Type |
In/Out |
---|---|---|
P_US_ID |
NUMBER(12) |
IN |
P_POH_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 P.50.07 |
Allowable values |
---|---|---|
DESCRIPTION |
Description |
|
NLS_ID |
Nls |
All languages defined on A.10.01 Languages |
SHORT_DESC |
Short Desc |