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.