DBA Data[Home] [Help]

APPS.JAI_AR_SUP_TRX_PKG dependencies on JAI_OM_UTILS_PKG

Line 994: 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);

990: OPEN LIST_PRICE(I.INVENTORY_ITEM_ID,AUNIT_CODE,P_NEW_TYPE_ID,FETCH_INV.TRX_DATE);
991: FETCH LIST_PRICE INTO C_LIST_PRICE;
992: CLOSE list_price;
993: ELSIF i.bom_item_type = 1 THEN
994: 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);
995: END IF;
996:
997: v_statement_id := '15';
998:

Line 1158: 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);

1154: ELSIF I.BOM_ITEM_TYPE = 1 THEN
1155:
1156: v_statement_id := '31';
1157:
1158: 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);
1159: END IF;
1160:
1161: v_statement_id := '32';
1162: IF C_LIST_PRICE <> I_UNIT_SELLING_PRICE THEN -- aa1511

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

1309: OR (A_EXISTING_TYPE_ID IS NULL AND V_ASSESABLE_LIST_ID = A_NEW_TYPE_ID)
1310: THEN
1311: IF I.BOM_ITEM_TYPE = 1 THEN
1312: v_statement_id := '50';
1313: jai_om_utils_pkg.get_ato_assessable_value( A_NEW_TYPE_ID,I.INTERFACE_LINE_ATTRIBUTE6, NEW_ASSESS_VALUE);
1314: ELSIF I.BOM_ITEM_TYPE <> 1 THEN
1315: v_statement_id := '51';
1316: OPEN GET_ASSESS_LIST(I.INVENTORY_ITEM_ID,AUNIT_CODE,A_NEW_TYPE_ID,FETCH_INV.TRX_DATE) ;
1317: FETCH GET_ASSESS_LIST INTO NEW_ASSESS_VALUE;