[Home] [Help]
79:
80: /*Bug 5680669 -START-*/
81: select fa.application_short_name,frs.request_set_name
82: into t_app_name, req_set_name
83: from fnd_request_sets_vl frs, fnd_application fa
84: where frs.application_id=appl_id
85: and frs.request_set_id=set_id
86: and frs.application_id=fa.application_id;
87:
108: /* Get info for first stage. */
109: begin
110: select request_set_stage_id, request_set_stage_id, user_stage_name
111: into stage_id, next_stage, request_desc
112: from fnd_request_sets sets,
113: fnd_request_set_stages_vl stages
114: where sets.application_id = appl_id
115: and sets.request_set_id = set_id
116: and stages.set_application_id = sets.application_id
148: critical_outcome := substr(req_data, pos2 + 1);
149: if (runinfo_id = 'C') then
150: begin
151: select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
152: select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
153: where REQUEST_SET_ID = set_id AND application_id = appl_id;
154: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
155: WHERE request_set_id = set_id
156: AND SET_APPLICATION_ID = appl_id;