DBA Data[Home] [Help]

APPS.POS_BULKLOAD_ENTITIES dependencies on HZ_IMP_PARTIES_INT

Line 1318: DELETE FROM HZ_IMP_PARTIES_INT

1314: l_retcode varchar2(2000);
1315:
1316: BEGIN
1317:
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

Line 1320: Write_Conclog('HZ_IMP_PARTIES_INT Completed');

1316: BEGIN
1317:
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');

Line 1327: INTO HZ_IMP_PARTIES_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: (
1329: BATCH_ID,
1330: PARTY_ORIG_SYSTEM,
1331: PARTY_ORIG_SYSTEM_REFERENCE,

Line 1366: DELETE FROM HZ_IMP_PARTIES_INT

1362: P_PARTY_ORIG_SYSTEM,
1363: P_PARTY_ORIG_SYSTEM_REFERENCE
1364: );
1365:
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

Line 1368: Write_Conclog('HZ_IMP_PARTIES_INT Completed');

1364: );
1365:
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');