APPS.FND_REQUEST_SET dependencies on FND_REQUEST_SET_STAGES

Line 112: fnd_request_set_stages_vl stages

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
116: and stages.request_set_id = sets.request_set_id

Line 153: SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages

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;
156: IF( tmpDate > rset_last_updated_date) THEN
157: rset_last_updated_date := tmpDate;

Line 212: from fnd_request_set_stages_vl stages

208: stage_id := error_stage_id;
209: error_stage_id := null;
210: select request_set_stage_id, user_stage_name
211: into next_stage, request_desc
212: from fnd_request_set_stages_vl stages
213: where stages.set_application_id = appl_id
214: and stages.request_set_id = set_id
215: and stages.request_set_stage_id = stage_id;
216: exception

Line 244: from fnd_request_set_stages_vl

240: /* Get Next Stage and Critical info*/
241: begin
242: select decode(current_outcome, 'S', success_link, 'W', warning_link, error_link), critical, user_stage_name
243: into next_stage, is_critical, user_stage_name
244: from fnd_request_set_stages_vl
245: where request_set_id = set_id
246: and set_application_id = appl_id
247: and request_set_stage_id = stage_id;
248: exception

Line 323: from fnd_request_set_stages_vl

319: /* Get next stage */
320: begin
321: Select user_stage_name
322: into request_desc
323: from fnd_request_set_stages_vl
324: where request_set_id = set_id
325: and set_application_id = appl_id
326: and request_set_stage_id = next_stage;
327: exception

Line 577: from fnd_request_set_stages s, fnd_executables e

573: s.function_id, s.function_application_id
574: into hardwired_outcome, funct,
575: g_set_appl_id, g_set_id, g_stage_id,
576: g_function_id, g_function_appl_id
577: from fnd_request_set_stages s, fnd_executables e
578: where s.set_application_id = appl_id
579: and s.request_set_id = set_id
580: and s.request_set_stage_id = stage_id
581: and e.executable_id(+) = s.function_id