APPS.BIS_TRUNCATE_EMPTY_MV_LOG_PKG dependencies on FND_CONCURRENT

Line 18: from bis_request_set_objects bis, fnd_request_sets fnd , fnd_concurrent_requests cr

14: return number
15: IS
16: CURSOR rs_running IS
17: select distinct bis.request_set_name Name, cr.phase_code Phase, cr.request_id request, cr.requested_start_date s_date
18: from bis_request_set_objects bis, fnd_request_sets fnd , fnd_concurrent_requests cr
19: where bis.request_set_name = fnd.request_set_name
20: and bis.set_app_id = fnd.application_id
21: and cr.phase_code = 'R'
22: and to_char(fnd.application_id) = cr.argument1

Line 29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj

25: rs_running_rec rs_running%rowtype;
26:
27: CURSOR mv_refresh_prog IS
28: SELECT obj.object_name Name, req.request_id request
29: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req, bis_obj_properties obj
30: WHERE (prog.concurrent_program_name = 'BIS_MV_REFRESH_STANDALONE' OR prog.concurrent_program_name = 'BIS_MV_REFRESH')
31: AND prog.application_id = 191
32: AND prog.concurrent_program_id = req.concurrent_program_id
33: AND req.phase_code = 'R'

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

89: RETURN prog_running;
90: EXCEPTION
91: WHEN OTHERS THEN
92: BIS_COLLECTION_UTILITIES.put_line('Error in Check_Refresh_Prog_running '|| sqlerrm);
93: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
94: END;
95:
96:
97: /****************************************************************************

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

219: ELSE
220: BIS_COLLECTION_UTILITIES.put_line('Error in Truncate Empty MV Logs - MV is being refreshed' );
221: END IF;
222: BIS_COLLECTION_UTILITIES.put_line('Please run Truncate Empty MV Logs when there are no Refresh request-set/programs running');
223: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
224: errbuf := 'DBI Refresh Program Running';
225: WHEN OTHERS THEN
226: BIS_COLLECTION_UTILITIES.put_line('Error in Truncate Empty MV Logs '|| sqlerrm);
227: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);

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

223: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
224: errbuf := 'DBI Refresh Program Running';
225: WHEN OTHERS THEN
226: BIS_COLLECTION_UTILITIES.put_line('Error in Truncate Empty MV Logs '|| sqlerrm);
227: l_program_status := fnd_concurrent.set_completion_status('Error' ,NULL);
228: errbuf := sqlerrm;
229: retcode := sqlcode;
230: END;
231: