APPS.HZ_IMP_MATCH_RULE_51 dependencies on FND_CONCURRENT

Line 121: FND_CONCURRENT.AF_Commit;

117: -- dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
118: RAISE;
119: END ;
120: IF l_last_fetch THEN
121: FND_CONCURRENT.AF_Commit;
122: EXIT;
123: END IF;
124: FND_CONCURRENT.AF_Commit;
125:

Line 124: FND_CONCURRENT.AF_Commit;

120: IF l_last_fetch THEN
121: FND_CONCURRENT.AF_Commit;
122: EXIT;
123: END IF;
124: FND_CONCURRENT.AF_Commit;
125:
126: END LOOP;
127: CLOSE p_party_cur;
128: END pop_parties;

Line 188: FND_CONCURRENT.AF_Commit;

184: RAISE;
185: END;
186:
187: IF l_last_fetch THEN
188: FND_CONCURRENT.AF_Commit;
189: EXIT;
190: END IF;
191: FND_CONCURRENT.AF_Commit;
192:

Line 191: FND_CONCURRENT.AF_Commit;

187: IF l_last_fetch THEN
188: FND_CONCURRENT.AF_Commit;
189: EXIT;
190: END IF;
191: FND_CONCURRENT.AF_Commit;
192:
193: END LOOP;
194: CLOSE l_party_site_cur;
195: END pop_party_sites;

Line 248: FND_CONCURRENT.AF_Commit;

244: RAISE;
245: END;
246:
247: IF l_last_fetch THEN
248: FND_CONCURRENT.AF_Commit;
249: EXIT;
250: END IF;
251: FND_CONCURRENT.AF_Commit;
252:

Line 251: FND_CONCURRENT.AF_Commit;

247: IF l_last_fetch THEN
248: FND_CONCURRENT.AF_Commit;
249: EXIT;
250: END IF;
251: FND_CONCURRENT.AF_Commit;
252:
253: END LOOP;
254: CLOSE l_cp_cur;
255: END pop_cp;

Line 347: FND_CONCURRENT.AF_Commit;

343: -- dbms_output.put_line(SubStr('Error '||TO_CHAR(SQLCODE)||': '||SQLERRM, 1, 255));
344: RAISE;
345: END ;
346: IF l_last_fetch THEN
347: FND_CONCURRENT.AF_Commit;
348: EXIT;
349: END IF;
350: FND_CONCURRENT.AF_Commit;
351:

Line 350: FND_CONCURRENT.AF_Commit;

346: IF l_last_fetch THEN
347: FND_CONCURRENT.AF_Commit;
348: EXIT;
349: END IF;
350: FND_CONCURRENT.AF_Commit;
351:
352: END LOOP;
353: CLOSE p_party_cur;
354: END pop_parties_int;

Line 410: FND_CONCURRENT.AF_Commit;

406: RAISE;
407: END;
408:
409: IF l_last_fetch THEN
410: FND_CONCURRENT.AF_Commit;
411: EXIT;
412: END IF;
413: FND_CONCURRENT.AF_Commit;
414:

Line 413: FND_CONCURRENT.AF_Commit;

409: IF l_last_fetch THEN
410: FND_CONCURRENT.AF_Commit;
411: EXIT;
412: END IF;
413: FND_CONCURRENT.AF_Commit;
414:
415: END LOOP;
416: CLOSE l_party_site_cur;
417: END pop_party_sites_int;

Line 469: FND_CONCURRENT.AF_Commit;

465: RAISE;
466: END;
467:
468: IF l_last_fetch THEN
469: FND_CONCURRENT.AF_Commit;
470: EXIT;
471: END IF;
472: FND_CONCURRENT.AF_Commit;
473:

Line 472: FND_CONCURRENT.AF_Commit;

468: IF l_last_fetch THEN
469: FND_CONCURRENT.AF_Commit;
470: EXIT;
471: END IF;
472: FND_CONCURRENT.AF_Commit;
473:
474: END LOOP;
475: CLOSE l_cp_cur ;
476:

Line 608: FND_CONCURRENT.AF_Commit;

604: ;
605: inserted_duplicates := (SQL%ROWCOUNT);
606: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted '||SQL%ROWCOUNT);
607: FND_FILE.put_line(FND_FILE.log,'End time of insert '||to_char(sysdate,'hh24:mi:ss'));
608: FND_CONCURRENT.AF_Commit;
609:
610:
611: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
612: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of PARTY_SITES');

Line 654: FND_CONCURRENT.AF_Commit;

650: close x_ent_cur;
651: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
652: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
653: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');
654: FND_CONCURRENT.AF_Commit;
655:
656:
657: ---------- exception block ---------------
658: EXCEPTION

Line 1073: FND_CONCURRENT.AF_Commit;

1069: having sum(score) >= x_insert_threshold
1070: ;
1071: FND_FILE.put_line(FND_FILE.log,'Number of parties inserted '||SQL%ROWCOUNT);
1072: FND_FILE.put_line(FND_FILE.log,'End time of insert '||to_char(sysdate,'hh24:mi:ss'));
1073: FND_CONCURRENT.AF_Commit;
1074:
1075:
1076: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1077: FND_FILE.put_line(FND_FILE.log,'Beginning update of Parties on the basis of PARTY_SITES');

Line 1121: FND_CONCURRENT.AF_Commit;

1117: close x_ent_cur;
1118: FND_FILE.put_line(FND_FILE.log,'Number of parties updated '||SQL%ROWCOUNT);
1119: FND_FILE.put_line(FND_FILE.log,'End time to update '||to_char(sysdate,'hh24:mi:ss'));
1120: FND_FILE.put_line(FND_FILE.log,'Ending update of Parties on the basis of PARTY_SITES');
1121: FND_CONCURRENT.AF_Commit;
1122: -------------CONTACT_POINTS LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1123: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1124: FND_FILE.put_line(FND_FILE.log,'Beginning insert of CONTACT_POINTS');
1125: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1166: FND_CONCURRENT.AF_Commit;

1162: ;
1163: FND_FILE.put_line(FND_FILE.log,'Ending insert of CONTACT_POINTS');
1164: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1165: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1166: FND_CONCURRENT.AF_Commit;
1167: -------------PARTY_SITES LEVEL DUPLICATE IDENTIFICATION BEGINS ------------------------
1168: FND_FILE.put_line(FND_FILE.log,'------------------------------------------------');
1169: FND_FILE.put_line(FND_FILE.log,'Beginning insert of PARTY_SITES');
1170: FND_FILE.put_line(FND_FILE.log,'Start time of insert '||to_char(sysdate,'hh24:mi:ss'));

Line 1217: FND_CONCURRENT.AF_Commit;

1213: ;
1214: FND_FILE.put_line(FND_FILE.log,'Ending insert of PARTY_SITES');
1215: FND_FILE.put_line(FND_FILE.log,'Number of records inserted '||SQL%ROWCOUNT);
1216: FND_FILE.put_line(FND_FILE.log,'End time to insert '||to_char(sysdate,'hh24:mi:ss'));
1217: FND_CONCURRENT.AF_Commit;
1218:
1219: ---------- exception block ---------------
1220: EXCEPTION
1221: WHEN OTHERS THEN