APPS.HZ_IMP_DQM_STAGE dependencies on FND_CONCURRENT

Line 725: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;

721: x_msg_data VARCHAR2(255);
722:
723: x_dup_batch_id NUMBER;
724: l_state boolean := true;
725: l_sub FND_CONCURRENT.REQUESTS_TAB_TYPE;
726: call_status boolean;
727: l_conc_phase VARCHAR2(80);
728: l_conc_status VARCHAR2(80);
729: l_conc_dev_phase VARCHAR2(30);

Line 789: from fnd_concurrent_requests R

785: -- AFTER ALL THE WORKERS ARE DONE, SEE IF THEY HAVE ALL COMPLETED NORMALLY
786: -- assume that all concurrent dup workers completed normally, unless found otherwise
787: l_workers_completed := TRUE;
788: select request_id BULK COLLECT into l_sub_requests
789: from fnd_concurrent_requests R
790: where parent_request_id = FND_GLOBAL.conc_request_id
791: and (phase_code<>'C' or status_code<>'C');
792: IF l_sub_requests.count > 0 THEN
793: l_workers_completed := FALSE;

Line 828: from fnd_concurrent_requests R

824: -- AFTER ALL THE WORKERS ARE DONE, SEE IF THEY HAVE ALL COMPLETED NORMALLY
825: -- assume that all concurrent dup workers completed normally, unless found otherwise
826: l_workers_completed := TRUE;
827: select request_id BULK COLLECT into l_sub_requests
828: from fnd_concurrent_requests R
829: where parent_request_id = FND_GLOBAL.conc_request_id
830: and (phase_code<>'C' or status_code<>'C');
831: IF l_sub_requests.count > 0 THEN
832: l_workers_completed := FALSE;

Line 2080: l(' FND_CONCURRENT.AF_Commit;');

2076: l(' -- dbms_output.put_line(SubStr(''Error ''||TO_CHAR(SQLCODE)||'': ''||SQLERRM, 1, 255));');
2077: l(' RAISE;');
2078: l(' END ;');
2079: l(' IF l_last_fetch THEN');
2080: l(' FND_CONCURRENT.AF_Commit;');
2081: l(' EXIT;');
2082: l(' END IF;');
2083: l(' FND_CONCURRENT.AF_Commit;');
2084: l(' ');

Line 2083: l(' FND_CONCURRENT.AF_Commit;');

2079: l(' IF l_last_fetch THEN');
2080: l(' FND_CONCURRENT.AF_Commit;');
2081: l(' EXIT;');
2082: l(' END IF;');
2083: l(' FND_CONCURRENT.AF_Commit;');
2084: l(' ');
2085: l(' END LOOP; ');
2086: l(' CLOSE p_party_cur; ');
2087: ELSE

Line 2221: l(' FND_CONCURRENT.AF_Commit; ');

2217: l('-- dbms_output.put_line(SubStr(''Error ''||TO_CHAR(SQLCODE)||'': ''||SQLERRM, 1, 255)); ');
2218: l(' RAISE; ');
2219: l(' END ; ');
2220: l(' IF l_last_fetch THEN ');
2221: l(' FND_CONCURRENT.AF_Commit; ');
2222: l(' EXIT; ');
2223: l(' END IF; ');
2224: l(' FND_CONCURRENT.AF_Commit; ');
2225: l(' ');

Line 2224: l(' FND_CONCURRENT.AF_Commit; ');

2220: l(' IF l_last_fetch THEN ');
2221: l(' FND_CONCURRENT.AF_Commit; ');
2222: l(' EXIT; ');
2223: l(' END IF; ');
2224: l(' FND_CONCURRENT.AF_Commit; ');
2225: l(' ');
2226: l(' END LOOP; ');
2227: l(' CLOSE p_party_cur; ');
2228: ELSE

Line 2398: l(' FND_CONCURRENT.AF_Commit; ');

2394: l(' RAISE; ');
2395: l(' END; ');
2396: l(' ');
2397: l(' IF l_last_fetch THEN ');
2398: l(' FND_CONCURRENT.AF_Commit; ');
2399: l(' EXIT; ');
2400: l(' END IF; ');
2401: l(' FND_CONCURRENT.AF_Commit; ');
2402: l(' ');

Line 2401: l(' FND_CONCURRENT.AF_Commit; ');

2397: l(' IF l_last_fetch THEN ');
2398: l(' FND_CONCURRENT.AF_Commit; ');
2399: l(' EXIT; ');
2400: l(' END IF; ');
2401: l(' FND_CONCURRENT.AF_Commit; ');
2402: l(' ');
2403: l(' END LOOP; ');
2404: l(' CLOSE l_party_site_cur; ');
2405: ELSE

Line 2544: l(' FND_CONCURRENT.AF_Commit; ');

2540: l(' RAISE; ');
2541: l(' END; ');
2542: l(' ');
2543: l(' IF l_last_fetch THEN ');
2544: l(' FND_CONCURRENT.AF_Commit; ');
2545: l(' EXIT; ');
2546: l(' END IF; ');
2547: l(' FND_CONCURRENT.AF_Commit; ');
2548: l(' ');

Line 2547: l(' FND_CONCURRENT.AF_Commit; ');

2543: l(' IF l_last_fetch THEN ');
2544: l(' FND_CONCURRENT.AF_Commit; ');
2545: l(' EXIT; ');
2546: l(' END IF; ');
2547: l(' FND_CONCURRENT.AF_Commit; ');
2548: l(' ');
2549: l(' END LOOP; ');
2550: l(' CLOSE l_party_site_cur; ');
2551: ELSE

Line 3013: l(' FND_CONCURRENT.AF_Commit; ');

3009: l(' RAISE; ');
3010: l(' END; ');
3011: l(' ');
3012: l(' IF l_last_fetch THEN ');
3013: l(' FND_CONCURRENT.AF_Commit; ');
3014: l(' EXIT; ');
3015: l(' END IF; ');
3016: l(' FND_CONCURRENT.AF_Commit; ');
3017: l(' ');

Line 3016: l(' FND_CONCURRENT.AF_Commit; ');

3012: l(' IF l_last_fetch THEN ');
3013: l(' FND_CONCURRENT.AF_Commit; ');
3014: l(' EXIT; ');
3015: l(' END IF; ');
3016: l(' FND_CONCURRENT.AF_Commit; ');
3017: l(' ');
3018: l(' END LOOP; ');
3019: l(' CLOSE l_contact_cur ; ');
3020: ELSE

Line 3134: l(' FND_CONCURRENT.AF_Commit; ');

3130: l(' RAISE; ');
3131: l(' END; ');
3132: l(' ');
3133: l(' IF l_last_fetch THEN ');
3134: l(' FND_CONCURRENT.AF_Commit; ');
3135: l(' EXIT; ');
3136: l(' END IF; ');
3137: l(' FND_CONCURRENT.AF_Commit; ');
3138: l(' ');

Line 3137: l(' FND_CONCURRENT.AF_Commit; ');

3133: l(' IF l_last_fetch THEN ');
3134: l(' FND_CONCURRENT.AF_Commit; ');
3135: l(' EXIT; ');
3136: l(' END IF; ');
3137: l(' FND_CONCURRENT.AF_Commit; ');
3138: l(' ');
3139: l(' END LOOP; ');
3140: l(' CLOSE l_contact_cur ; ');
3141: ELSE

Line 3288: l(' FND_CONCURRENT.AF_Commit; ');

3284: l(' RAISE; ');
3285: l(' END; ');
3286: l(' ');
3287: l(' IF l_last_fetch THEN ');
3288: l(' FND_CONCURRENT.AF_Commit; ');
3289: l(' EXIT; ');
3290: l(' END IF; ');
3291: l(' FND_CONCURRENT.AF_Commit; ');
3292: l(' ');

Line 3291: l(' FND_CONCURRENT.AF_Commit; ');

3287: l(' IF l_last_fetch THEN ');
3288: l(' FND_CONCURRENT.AF_Commit; ');
3289: l(' EXIT; ');
3290: l(' END IF; ');
3291: l(' FND_CONCURRENT.AF_Commit; ');
3292: l(' ');
3293: l(' END LOOP; ');
3294: l(' CLOSE l_cp_cur; ');
3295: ELSE

Line 3430: l(' FND_CONCURRENT.AF_Commit; ');

3426: l(' RAISE; ');
3427: l(' END; ');
3428: l(' ');
3429: l(' IF l_last_fetch THEN ');
3430: l(' FND_CONCURRENT.AF_Commit; ');
3431: l(' EXIT; ');
3432: l(' END IF; ');
3433: l(' FND_CONCURRENT.AF_Commit; ');
3434: l(' ');

Line 3433: l(' FND_CONCURRENT.AF_Commit; ');

3429: l(' IF l_last_fetch THEN ');
3430: l(' FND_CONCURRENT.AF_Commit; ');
3431: l(' EXIT; ');
3432: l(' END IF; ');
3433: l(' FND_CONCURRENT.AF_Commit; ');
3434: l(' ');
3435: l(' END LOOP; ');
3436: l(' CLOSE l_cp_cur ; ');
3437: l(' ');