DBA Data[Home] [Help]

APPS.BIS_CREATE_REQUESTSET dependencies on FND_CONCURRENT_REQUESTS

Line 3632: fnd_concurrent_requests req

3628: select
3629: req.argument1,
3630: req.argument2
3631: from
3632: fnd_concurrent_requests req
3633: where
3634: req.request_id = p_req_id ;
3635:
3636: CURSOR mv_log_truncate_running IS

Line 3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req

3634: req.request_id = p_req_id ;
3635:
3636: CURSOR mv_log_truncate_running IS
3637: SELECT req.request_id REQUEST, req.phase_code Phase, requested_start_date s_date
3638: FROM fnd_concurrent_programs prog, fnd_concurrent_requests req
3639: WHERE prog.CONCURRENT_PROGRAM_NAME = 'BIS_BIA_TRUNCATE_EMPTY_MV_LOGS'
3640: AND req.concurrent_program_id = prog.concurrent_program_id
3641: AND req.program_application_id = prog.application_id
3642: AND req.phase_code = 'R';

Line 4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs

4511: FUNCTION is_history_collect_on(p_root_request_id IN NUMBER) RETURN BOOLEAN
4512: IS
4513: CURSOR c_request_set_details IS
4514: SELECT rs.request_set_name
4515: FROM fnd_concurrent_requests cr, fnd_request_sets rs
4516: WHERE cr.request_id = p_root_request_id
4517: AND rs.application_id = cr.argument1
4518: AND rs.request_set_id = cr.argument2;
4519: l_request_set_name VARCHAR2(1000);