DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_OM_UTILS_PKG

Line 1095: jai_om_utils_pkg.get_ato_pricelist_value(P_NEW_TYPE_ID,AUNIT_CODE,I.INVENTORY_ITEM_ID, I.INTERFACE_LINE_ATTRIBUTE6, C_LIST_PRICE);

1091: OPEN LIST_PRICE(I.INVENTORY_ITEM_ID,AUNIT_CODE,P_NEW_TYPE_ID,FETCH_INV.TRX_DATE);
1092: FETCH LIST_PRICE INTO C_LIST_PRICE;
1093: CLOSE list_price;
1094: ELSIF i.bom_item_type = 1 THEN
1095: jai_om_utils_pkg.get_ato_pricelist_value(P_NEW_TYPE_ID,AUNIT_CODE,I.INVENTORY_ITEM_ID, I.INTERFACE_LINE_ATTRIBUTE6, C_LIST_PRICE);
1096: END IF;
1097:
1098: v_statement_id := '15';
1099:

Line 1269: jai_om_utils_pkg.get_ato_pricelist_value(I_NEW_TYPE_ID,AUNIT_CODE,I.INVENTORY_ITEM_ID, I.INTERFACE_LINE_ATTRIBUTE6,C_LIST_PRICE);

1265: ELSIF I.BOM_ITEM_TYPE = 1 THEN
1266:
1267: v_statement_id := '31';
1268:
1269: jai_om_utils_pkg.get_ato_pricelist_value(I_NEW_TYPE_ID,AUNIT_CODE,I.INVENTORY_ITEM_ID, I.INTERFACE_LINE_ATTRIBUTE6,C_LIST_PRICE);
1270: END IF;
1271:
1272: v_statement_id := '32';
1273: IF C_LIST_PRICE <> I_UNIT_SELLING_PRICE THEN -- aa1511

Line 1431: jai_om_utils_pkg.get_ato_assessable_value( A_NEW_TYPE_ID,I.INTERFACE_LINE_ATTRIBUTE6, NEW_ASSESS_VALUE);

1427: OR (A_EXISTING_TYPE_ID IS NULL AND V_ASSESABLE_LIST_ID = A_NEW_TYPE_ID)
1428: THEN
1429: IF I.BOM_ITEM_TYPE = 1 THEN
1430: v_statement_id := '50';
1431: jai_om_utils_pkg.get_ato_assessable_value( A_NEW_TYPE_ID,I.INTERFACE_LINE_ATTRIBUTE6, NEW_ASSESS_VALUE);
1432: ELSIF I.BOM_ITEM_TYPE <> 1 THEN
1433: v_statement_id := '51';
1434: OPEN GET_ASSESS_LIST(I.INVENTORY_ITEM_ID,AUNIT_CODE,A_NEW_TYPE_ID,FETCH_INV.TRX_DATE) ;
1435: FETCH GET_ASSESS_LIST INTO NEW_ASSESS_VALUE;