APPS.BIS_MV_REFRESH dependencies on FND_CONCURRENT

Line 822: from fnd_concurrent_requests a

818:
819: function get_root_req_id(p_prog_request_id number) return number is
820: cursor c_root_req_id is
821: select a.priority_request_id
822: from fnd_concurrent_requests a
823: where a.request_id =
824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );
825: l_root_req_id number;
826: begin

Line 824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );

820: cursor c_root_req_id is
821: select a.priority_request_id
822: from fnd_concurrent_requests a
823: where a.request_id =
824: (select b.parent_request_id from fnd_concurrent_requests b where b.request_id=p_prog_request_id );
825: l_root_req_id number;
826: begin
827: open c_root_req_id;
828: fetch c_root_req_id into l_root_req_id;

Line 1130: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);

1126: close c_mv_log_for_unimpl_mvs;
1127:
1128: ---added for bug 4406144
1129: --compile_mvs; --bug fix 5750596
1130: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);
1131:
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: ROLLBACK;

Line 1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

1136: retcode := sqlcode;
1137: BIS_COLLECTION_UTILITIES.put_line(' ');
1138: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1139: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1140: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1141:
1142: BIS_COLLECTION_UTILITIES.WRAPUP(
1143: FALSE,
1144: 0,

Line 1273: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);

1269: logmsg(' ');
1270: end loop;
1271: close c_mv_log_for_unimpl_mvs;
1272:
1273: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: ROLLBACK;

Line 1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);

1279: retcode := sqlcode;
1280: BIS_COLLECTION_UTILITIES.put_line(' ');
1281: BIS_COLLECTION_UTILITIES.put_line('Error occurred:');
1282: BIS_COLLECTION_UTILITIES.put_line(errbuf);
1283: g_program_status := fnd_concurrent.set_completion_status('ERROR' ,NULL);
1284:
1285: BIS_COLLECTION_UTILITIES.WRAPUP(
1286: FALSE,
1287: 0,

Line 1426: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);

1422:
1423: --- END IF; -- end NOT IS_IMPLEMENTED comment out check for impl flag for bug 4532066
1424: END IF; -- end NOT VALIDATE
1425:
1426: g_program_status := fnd_concurrent.set_completion_status(g_program_status_var ,NULL);
1427:
1428:
1429: BIS_COLLECTION_UTILITIES.WRAPUP(
1430: TRUE, -- status

Line 1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);

1525: ELSE
1526: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs - MV is being refreshed' );
1527: END IF;
1528: BIS_COLLECTION_UTILITIES.put_line('Please run Compiling Invalid MVs when there are no Refresh request-set/programs running');
1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1530: errbuf := 'DBI Refresh Program Running';
1531: WHEN OTHERS THEN
1532: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs '|| sqlerrm);
1533: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);

Line 1533: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);

1529: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1530: errbuf := 'DBI Refresh Program Running';
1531: WHEN OTHERS THEN
1532: BIS_COLLECTION_UTILITIES.put_line('Error in Compiling Invalid MVs '|| sqlerrm);
1533: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
1534: errbuf := sqlerrm;
1535: retcode := sqlcode;
1536: END;
1537: