CIP - Intergraph Smart Materials - 2.3 - Administration & Configuration - Hexagon

Intergraph Smart Materials EcoSys Integration (2.3)

Language
English
Product
Intergraph Smart Materials
Subproduct
EcoSys Integration
Search by Category
Administration & Configuration
Version Smart Materials Web API
2.3

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: Use to map the EcoSys attributes with Smart Materials columns i.e. in CIP, Ecolname is mapped with SmatcolName.

    • The Ecolname in CIP should match with the EcoSys attribute name in RequisitionHeader API and is case sensitive.

    • The SmatcolName in CIP is Smart Materials column name in MVW_ECO_REQ_HEADERS view.

  • get_reqli_columns: Use to map the EcoSys attributes with Smart Materials columns i.e. in CIP, Ecolname is mapped with SmatcolName.

    • The Ecolname in CIP should match with the EcoSys attribute name in RequisitionLineItems API and is case-sensitive.

    • The SmatcolName in CIP is Smart Materials column name in 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.