APPS.BIS_COLL_RS_HISTORY dependencies on FND_CONCURRENT_REQUESTS

Line 64: fnd_concurrent_requests req

60: req.phase_code phase_code,
61: req.completion_text Completion_text
62: from bis_rs_run_history rs,
63: fnd_request_set_stages stg,
64: fnd_concurrent_requests req
65: where rs.request_id = l_root_request_id
66: and rs.request_set_id = stg.request_set_id
67: and req.argument3 = stg.request_set_stage_id
68: and req.parent_request_id = rs.request_id ;

Line 80: from fnd_concurrent_requests req,

76: req.request_id Request_id ,
77: req.CONCURRENT_PROGRAM_ID program_id,
78: req.argument1 obj_owner,
79: req.argument2 obj_name
80: from fnd_concurrent_requests req,
81: bis_rs_stage_run_history stg
82: where stg.set_request_id = l_root_request_id
83: and stg.request_id = req.parent_request_id ;
84:

Line 93: from fnd_concurrent_requests req,

89: req.request_id Request_id ,
90: req.parent_request_id parent_request_id,
91: req.CONCURRENT_PROGRAM_ID program_id,
92: prog.STAGE_REQUEST_ID stage_req_id
93: from fnd_concurrent_requests req,
94: BIS_RS_PROG_RUN_HISTORY prog
95: where --(req.parent_request_id is not null) and
96: req.parent_request_id = prog.request_id
97: and (instr(l_parent_request_ids,to_char(req.parent_request_id)||',') <> 0);

Line 461: from fnd_concurrent_requests req, fnd_concurrent_programs prog

457: actual_start_date,
458: actual_completion_date,
459: completion_text,
460: concurrent_program_name
461: from fnd_concurrent_requests req, fnd_concurrent_programs prog
462: where request_id = x_request_id and req.concurrent_program_id = prog.concurrent_program_id
463: and req.program_application_id = prog.application_id;
464:
465: req_details_rec request_details%rowtype;

Line 753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;

749: IS
750: l_refresh_mode varchar2(30);
751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is

Line 754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;

750: l_refresh_mode varchar2(30);
751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests

Line 755: l_completion_text fnd_concurrent_requests.completion_text%type;

751: l_force_full_refresh varchar2(30);
752: l_request_set_id number;
753: l_rs_phase_code fnd_concurrent_requests.PHASE_CODE%type;
754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests
759: where request_id = p_root_req_id;

Line 758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests

754: l_rs_status_code fnd_concurrent_requests.STATUS_CODE%type;
755: l_completion_text fnd_concurrent_requests.completion_text%type;
756:
757: cursor request_set_details is
758: select PHASE_CODE ,STATUS_CODE,completion_text from fnd_concurrent_requests
759: where request_id = p_root_req_id;
760:
761: BEGIN
762: l_refresh_mode :=

Line 888: fnd_concurrent_requests req

884: req.argument2,
885: req.status_code,
886: req.phase_code
887: from
888: fnd_concurrent_requests req
889: where
890: req.request_id = p_req_id
891: and req.argument4 is null;
892:

Line 900: l_status_code fnd_concurrent_requests.status_code%type;

896: where application_id = p_request_set_appl_id and request_set_id = p_request_set_id;
897:
898: get_rs_details_rec get_rs_details%rowtype;
899:
900: l_status_code fnd_concurrent_requests.status_code%type;
901: l_phase_code fnd_concurrent_requests.phase_code%type;
902:
903: BEGIN
904:

Line 901: l_phase_code fnd_concurrent_requests.phase_code%type;

897:
898: get_rs_details_rec get_rs_details%rowtype;
899:
900: l_status_code fnd_concurrent_requests.status_code%type;
901: l_phase_code fnd_concurrent_requests.phase_code%type;
902:
903: BEGIN
904:
905: open is_req_valid(p_root_request_id);

Line 1005: fnd_concurrent_requests

1001: phase_code,
1002: status_code,
1003: completion_text
1004: from
1005: fnd_concurrent_requests
1006: where
1007: request_id =req_no and
1008: phase_code ='C' and
1009: status_code ='X';