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