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
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');
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,
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
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');