DBA Data[Home] [Help]

APPS.HZ_IMP_MATCH_RULE_52 dependencies on FND_CONCURRENT

Line 135: FND_CONCURRENT.AF_Commit;

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

Line 138: FND_CONCURRENT.AF_Commit;

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

Line 202: FND_CONCURRENT.AF_Commit;

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

Line 205: FND_CONCURRENT.AF_Commit;

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

Line 263: FND_CONCURRENT.AF_Commit;

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

Line 266: FND_CONCURRENT.AF_Commit;

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

Line 382: FND_CONCURRENT.AF_Commit;

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

Line 385: FND_CONCURRENT.AF_Commit;

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

Line 445: FND_CONCURRENT.AF_Commit;

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

Line 448: FND_CONCURRENT.AF_Commit;

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

Line 508: FND_CONCURRENT.AF_Commit;

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

Line 511: FND_CONCURRENT.AF_Commit;

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

Line 568: FND_CONCURRENT.AF_Commit;

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

Line 571: FND_CONCURRENT.AF_Commit;

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

Line 668: FND_CONCURRENT.AF_Commit;

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

Line 671: FND_CONCURRENT.AF_Commit;

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

Line 792: FND_CONCURRENT.AF_Commit;

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

Line 838: FND_CONCURRENT.AF_Commit;

834: close x_ent_cur;
835: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
836: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
837: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');
838: FND_CONCURRENT.AF_Commit;
839:
840:
841: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
842: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of CONTACTS');

Line 872: FND_CONCURRENT.AF_Commit;

868: close x_ent_cur;
869: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
870: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
871: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');
872: FND_CONCURRENT.AF_Commit;
873:
874:
875: ---------- exception block ---------------
876: EXCEPTION

Line 1417: FND_CONCURRENT.AF_Commit;

1413: having sum(score) >= x_insert_threshold
1414: ;
1415: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted '||SQL%ROWCOUNT);
1416: FND_FILE.put_line(FND_FILE.log,'End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1417: FND_CONCURRENT.AF_Commit;
1418:
1419:
1420: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1421: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of PARTY_SITES');

Line 1465: FND_CONCURRENT.AF_Commit;

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

Line 1501: FND_CONCURRENT.AF_Commit;

1497: close x_ent_cur;
1498: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1499: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1500: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of CONTACTS');
1501: FND_CONCURRENT.AF_Commit;
1502: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1503: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1504: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1505: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1555: FND_CONCURRENT.AF_Commit;

1551: ;
1552: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
1553: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1554: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1555: FND_CONCURRENT.AF_Commit;
1556: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1557: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1558: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1559: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1606: FND_CONCURRENT.AF_Commit;

1602: ;
1603: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
1604: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1605: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1606: FND_CONCURRENT.AF_Commit;
1607: -------------CONTACTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1608: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1609: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACTS');
1610: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1645: FND_CONCURRENT.AF_Commit;

1641: ;
1642: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACTS');
1643: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1644: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1645: FND_CONCURRENT.AF_Commit;
1646:
1647: ---------- exception block ---------------
1648: EXCEPTION
1649: WHEN OTHERS THEN