APPS.POS_BULKLOAD_ENTITIES dependencies on AP_SUPPLIERS

Line 227: FROM AP_Suppliers AP,

223: --AND process_status = G_PS_TO_BE_PROCESSED;
224:
225: CURSOR c_party_site (c_party_id IN NUMBER, c_address_name iN VARCHAR) IS
226: SELECT PS.Party_Site_ID
227: FROM AP_Suppliers AP,
228: HZ_PARTY_SITES PS
229: WHERE AP.Party_ID = PS.Party_ID
230: AND AP.Party_ID = c_Party_ID
231: AND PS.STATUS = 'A'

Line 237: FROM AP_Suppliers AP,

233: AND rownum < 2;
234:
235: CURSOR c_supplier_site (c_party_id IN NUMBER, c_party_site_id IN NUMBER, c_vendor_site_code IN VARCHAR) IS
236: SELECT SS.Vendor_Site_ID
237: FROM AP_Suppliers AP,
238: AP_SUPPLIER_SITES_ALL SS,
239: HZ_PARTY_SITES PS
240: WHERE AP.Party_ID = PS.Party_ID
241: AND AP.Party_ID = c_Party_ID

Line 350: FROM AP_Suppliers AP,

346: AND rownum < 2;
347:
348: CURSOR c_party_site (c_party_id IN NUMBER) IS
349: SELECT PS.Party_Site_ID
350: FROM AP_Suppliers AP,
351: HZ_PARTY_SITES PS
352: WHERE AP.Party_ID = PS.Party_ID
353: AND AP.Party_ID = p_Party_ID
354: AND PS.STATUS = 'A'

Line 360: FROM AP_Suppliers AP,

356:
357: CURSOR c_supplier_site (c_party_id IN NUMBER) IS
358: SELECT SS.Party_Site_ID,
359: SS.Vendor_Site_ID
360: FROM AP_Suppliers AP,
361: AP_SUPPLIER_SITES_ALL SS,
362: HZ_PARTY_SITES PS
363: WHERE AP.Party_ID = PS.Party_ID
364: AND AP.Party_ID = p_Party_ID

Line 1322: DELETE FROM Ap_Suppliers_Int

1318: DELETE FROM HZ_IMP_PARTIES_INT
1319: WHERE batch_id = p_batch_id;
1320: Write_Conclog('HZ_IMP_PARTIES_INT Completed');
1321:
1322: DELETE FROM Ap_Suppliers_Int
1323: WHERE sdh_BATCH_ID = P_BATCH_ID;
1324: Write_Conclog('Ap_Suppliers_Int Completed');
1325:
1326: INSERT

Line 1324: Write_Conclog('Ap_Suppliers_Int Completed');

1320: Write_Conclog('HZ_IMP_PARTIES_INT Completed');
1321:
1322: DELETE FROM Ap_Suppliers_Int
1323: WHERE sdh_BATCH_ID = P_BATCH_ID;
1324: Write_Conclog('Ap_Suppliers_Int Completed');
1325:
1326: INSERT
1327: INTO HZ_IMP_PARTIES_INT
1328: (

Line 1351: INSERT INTO AP_SUPPLIERS_INT

1347: P_PERSON_LAST_NAME,
1348: sysdate
1349: );
1350:
1351: INSERT INTO AP_SUPPLIERS_INT
1352: (VENDOR_INTERFACE_ID,
1353: VENDOR_NAME,
1354: SDH_BATCH_ID ,
1355: PARTY_ORIG_SYSTEM ,

Line 1370: DELETE FROM Ap_Suppliers_Int

1366: DELETE FROM HZ_IMP_PARTIES_INT
1367: WHERE batch_id = p_batch_id;
1368: Write_Conclog('HZ_IMP_PARTIES_INT Completed');
1369:
1370: DELETE FROM Ap_Suppliers_Int
1371: WHERE SDH_BATCH_ID = P_BATCH_ID;
1372: WRITE_CONCLOG('Ap_Suppliers_Int Completed');
1373:
1374: ERRBUF := l_errbuf;

Line 1372: WRITE_CONCLOG('Ap_Suppliers_Int Completed');

1368: Write_Conclog('HZ_IMP_PARTIES_INT Completed');
1369:
1370: DELETE FROM Ap_Suppliers_Int
1371: WHERE SDH_BATCH_ID = P_BATCH_ID;
1372: WRITE_CONCLOG('Ap_Suppliers_Int Completed');
1373:
1374: ERRBUF := l_errbuf;
1375: RETCODE := 'S';
1376: Write_Conclog('INSERT PARTY CHANGES ');