A.4 Table: m_po_headers, Package: m_api_poh - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming

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’) or only project suppliers (ZP_PROJSUP = ‘Y’); in any case, only suppliers allowed for 'PO & Inquiry' (P.20.01) and the status of which is approved (P.20.01) are valid
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’) or only project suppliers (ZP_PROJSUP = ‘Y’);not applicable for orders of ‘CO'; in any case, only suppliers allowed for 'PO & Inquiry' (P.20.01) and the status of which is approved (P.20.01) are valid
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

A.4 Table: m_po_headers, Package: m_api_poh - Intergraph Smart Materials - Version 2020 (10.0) - Customization & Programming - Hexagon

Intergraph Smart Materials Classic API Configuration (2020)