CIP - Intergraph Smart Materials - 2017 R1 (2.1) - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration 2017 R1 (2.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2017 R1 (2.1)

Below CIPs gives you a provision to change the default logic and implement your own logic in the custom package m_pck_ecosys_custom.

  • get_req_columns: To specify the list of attributes required to send to EcoSys and map them to Smart Materials View Columns (Header). The Ecolname in CIP should have the same name as column name of exposed Requisition Header spreadsheet. The SmatcolName holds the equivalent column name from Smart Materials MVW_ECO_REQ_HEADERS view.

  • get_reqli_columns: To specify the list of attributes required to send to EcoSys and map them to Smart Materials View Columns (Line Items). The Ecolname in CIP should have the same name as column name of exposed Requisition LineItems spreadsheet. The SmatcolName holds the equivalent columns name from Smart Materials MVW_ECO_REQ_LINE_ITEMS view.

  • get_req_li_modifiers: Through this CIP, you can include list of attributes required to identify modified line items and line items which must be nullified (cost and quantity) and sent again. In the default logic below, Currency, CostAccountId, WBSPathId are considered as nullifier columns, that is, change in any of these will nullify the line item and send the line item again. The columns Cost, and Quantity are modifier columns, change in these columns will resend the line item with the changed values.

PROCEDURE get_req_li_modifiers(p_reqli_nullify OUT column_array,p_reqli_modify OUT column_array)

IS

BEGIN

SELECT columns.attr_name BULK COLLECT INTO p_reqli_nullify

FROM (

SELECT 'CURRENCY' attr_name FROM dual

UNION ALL

SELECT 'COSTACCOUNTID' attr_name FROM dual

UNION ALL

SELECT 'WBSPATHID' attr_name FROM dual

)columns;

SELECT columns.attr_name BULK COLLECT INTO p_reqli_modify

FROM (

SELECT 'COST' attr_name FROM dual

UNION ALL

SELECT 'QUANTITY' attr_name FROM dual

)columns;

END get_req_li_modifiers;

You can add additional Attributes, but you should not change the order of Attributes specified in the default logic.