Procedure UPD_PO_VDR_DOC - Intergraph Smart Materials - Version 10.1 - Help - Hexagon

Intergraph Smart Materials Classic Help

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.1

After the login environment is set successfully, this procedure must be executed for the purchase order or order line item with the VDR assigned. For proper identification of the document, it is required to pass the SmartPlant Foundation document UID and corresponding version UID.

Each call to this interface is a single transaction and is committed to the database or rolled back in case of an error.

The SET_LOGIN_ENV procedure must be called each time this procedure is executed.

Procedure Parameters

Parameter

Description

p_ proj_id

Identifies a valid Smart Materials project.

p_poh_id

Number (12,0). Smart Materials internal purchase order ID.

p_poli_id

Number (12,0). Smart Materials internal purchase order line item ID.

p_v_id

Number (12,0). Smart Materials internal VDR ID.

p_spf_uid

Character (128). Document UID from SmartPlant Foundation.

p_spf_version_uid

Character (128). Document version UID from SmartPlant Foundation.

P_doc_status

Character (10). Status values as defined on P.10.71 VDR Approval Codes.

P_approve_date

Character (12). Date for the corresponding field.

Update Results

After the sample script is executed, the document status fields are updated as displayed in the picture below.

Status updates are customizable; see SET_VDR_APPROVAL procedure in the M_PCK_INT_CUSTOM CIP package. For more information, see Customer-installed procedure (CIP) Tasks.