DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_50 dependencies on FND_CONCURRENT

Line 134: FND_CONCURRENT.AF_Commit;

130: -- dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
131: RAISE;
132: END ;
133: IF l_last_fetch THEN
134: FND_CONCURRENT.AF_Commit;
135: EXIT;
136: END IF;
137: FND_CONCURRENT.AF_Commit;
138:

Line 137: FND_CONCURRENT.AF_Commit;

133: IF l_last_fetch THEN
134: FND_CONCURRENT.AF_Commit;
135: EXIT;
136: END IF;
137: FND_CONCURRENT.AF_Commit;
138:
139: END LOOP;
140: CLOSE p_party_cur;
141: END pop_parties;

Line 201: FND_CONCURRENT.AF_Commit;

197: RAISE;
198: END;
199:
200: IF l_last_fetch THEN
201: FND_CONCURRENT.AF_Commit;
202: EXIT;
203: END IF;
204: FND_CONCURRENT.AF_Commit;
205:

Line 204: FND_CONCURRENT.AF_Commit;

200: IF l_last_fetch THEN
201: FND_CONCURRENT.AF_Commit;
202: EXIT;
203: END IF;
204: FND_CONCURRENT.AF_Commit;
205:
206: END LOOP;
207: CLOSE l_party_site_cur;
208: END pop_party_sites;

Line 262: FND_CONCURRENT.AF_Commit;

258: RAISE;
259: END;
260:
261: IF l_last_fetch THEN
262: FND_CONCURRENT.AF_Commit;
263: EXIT;
264: END IF;
265: FND_CONCURRENT.AF_Commit;
266:

Line 265: FND_CONCURRENT.AF_Commit;

261: IF l_last_fetch THEN
262: FND_CONCURRENT.AF_Commit;
263: EXIT;
264: END IF;
265: FND_CONCURRENT.AF_Commit;
266:
267: END LOOP;
268: CLOSE l_cp_cur;
269: END pop_cp;

Line 381: FND_CONCURRENT.AF_Commit;

377: RAISE;
378: END;
379:
380: IF l_last_fetch THEN
381: FND_CONCURRENT.AF_Commit;
382: EXIT;
383: END IF;
384: FND_CONCURRENT.AF_Commit;
385:

Line 384: FND_CONCURRENT.AF_Commit;

380: IF l_last_fetch THEN
381: FND_CONCURRENT.AF_Commit;
382: EXIT;
383: END IF;
384: FND_CONCURRENT.AF_Commit;
385:
386: END LOOP;
387: CLOSE l_contact_cur ;
388: END pop_contacts;

Line 444: FND_CONCURRENT.AF_Commit;

440: -- dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
441: RAISE;
442: END ;
443: IF l_last_fetch THEN
444: FND_CONCURRENT.AF_Commit;
445: EXIT;
446: END IF;
447: FND_CONCURRENT.AF_Commit;
448:

Line 447: FND_CONCURRENT.AF_Commit;

443: IF l_last_fetch THEN
444: FND_CONCURRENT.AF_Commit;
445: EXIT;
446: END IF;
447: FND_CONCURRENT.AF_Commit;
448:
449: END LOOP;
450: CLOSE p_party_cur;
451: END pop_parties_int;

Line 507: FND_CONCURRENT.AF_Commit;

503: RAISE;
504: END;
505:
506: IF l_last_fetch THEN
507: FND_CONCURRENT.AF_Commit;
508: EXIT;
509: END IF;
510: FND_CONCURRENT.AF_Commit;
511:

Line 510: FND_CONCURRENT.AF_Commit;

506: IF l_last_fetch THEN
507: FND_CONCURRENT.AF_Commit;
508: EXIT;
509: END IF;
510: FND_CONCURRENT.AF_Commit;
511:
512: END LOOP;
513: CLOSE l_party_site_cur;
514: END pop_party_sites_int;

Line 567: FND_CONCURRENT.AF_Commit;

563: RAISE;
564: END;
565:
566: IF l_last_fetch THEN
567: FND_CONCURRENT.AF_Commit;
568: EXIT;
569: END IF;
570: FND_CONCURRENT.AF_Commit;
571:

Line 570: FND_CONCURRENT.AF_Commit;

566: IF l_last_fetch THEN
567: FND_CONCURRENT.AF_Commit;
568: EXIT;
569: END IF;
570: FND_CONCURRENT.AF_Commit;
571:
572: END LOOP;
573: CLOSE l_cp_cur ;
574:

Line 667: FND_CONCURRENT.AF_Commit;

663: RAISE;
664: END;
665:
666: IF l_last_fetch THEN
667: FND_CONCURRENT.AF_Commit;
668: EXIT;
669: END IF;
670: FND_CONCURRENT.AF_Commit;
671:

Line 670: FND_CONCURRENT.AF_Commit;

666: IF l_last_fetch THEN
667: FND_CONCURRENT.AF_Commit;
668: EXIT;
669: END IF;
670: FND_CONCURRENT.AF_Commit;
671:
672: END LOOP;
673: CLOSE l_contact_cur ;
674: END pop_contacts_int;

Line 789: FND_CONCURRENT.AF_Commit;

785: ;
786: inserted_duplicates := (SQL%ROWCOUNT);
787: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted '||SQL%ROWCOUNT);
788: FND_FILE.put_line(FND_FILE.log,'End time of insert '||to_char(sysdate,'hh24:mi:ss'));
789: FND_CONCURRENT.AF_Commit;
790:
791:
792: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
793: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of CONTACT_POINTS');

Line 828: FND_CONCURRENT.AF_Commit;

824: close x_ent_cur;
825: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
826: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
827: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');
828: FND_CONCURRENT.AF_Commit;
829:
830:
831: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
832: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of CONTACTS');

Line 862: FND_CONCURRENT.AF_Commit;

858: close x_ent_cur;
859: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
860: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
861: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');
862: FND_CONCURRENT.AF_Commit;
863:
864:
865: ---------- exception block ---------------
866: EXCEPTION

Line 1386: FND_CONCURRENT.AF_Commit;

1382: having sum(score) >= x_insert_threshold
1383: ;
1384: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted '||SQL%ROWCOUNT);
1385: FND_FILE.put_line(FND_FILE.log,'End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1386: FND_CONCURRENT.AF_Commit;
1387:
1388:
1389: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1390: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of CONTACT_POINTS');

Line 1428: FND_CONCURRENT.AF_Commit;

1424: close x_ent_cur;
1425: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1426: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1427: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACT_POINTS');
1428: FND_CONCURRENT.AF_Commit;
1429:
1430:
1431: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1432: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of CONTACTS');

Line 1464: FND_CONCURRENT.AF_Commit;

1460: close x_ent_cur;
1461: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1462: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1463: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');
1464: FND_CONCURRENT.AF_Commit;
1465: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1466: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1467: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1468: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1515: FND_CONCURRENT.AF_Commit;

1511: ;
1512: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
1513: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1514: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1515: FND_CONCURRENT.AF_Commit;
1516: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1517: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1518: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1519: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1560: FND_CONCURRENT.AF_Commit;

1556: ;
1557: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
1558: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1559: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1560: FND_CONCURRENT.AF_Commit;
1561: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1562: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1563: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1564: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1599: FND_CONCURRENT.AF_Commit;

1595: ;
1596: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACTS');
1597: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1598: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1599: FND_CONCURRENT.AF_Commit;
1600:
1601: ---------- exception block ---------------
1602: EXCEPTION
1603: WHEN OTHERS THEN