[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
rset_last_updated_date date;
select fa.application_short_name,frs.request_set_name
into t_app_name, req_set_name
from fnd_request_sets_vl frs, fnd_application fa
where frs.application_id=appl_id
and frs.request_set_id=set_id
and frs.application_id=fa.application_id;
update FND_CONCURRENT_REQUESTS set RUN_NUMBER = 1 where request_id = conc_req_id;
select request_set_stage_id, request_set_stage_id, user_stage_name
into stage_id, next_stage, request_desc
from fnd_request_sets sets,
fnd_request_set_stages_vl stages
where sets.application_id = appl_id
and sets.request_set_id = set_id
and stages.set_application_id = sets.application_id
and stages.request_set_id = sets.request_set_id
and sets.start_stage = stages.request_set_stage_id;
select REQUEST_DATE into req_request_date from FND_CONCURRENT_REQUESTS where REQUEST_ID = conc_req_id;
select LAST_UPDATE_DATE into rset_last_updated_date from FND_REQUEST_SETS sets
where REQUEST_SET_ID = set_id AND application_id = appl_id;
SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_stages
WHERE request_set_id = set_id
AND SET_APPLICATION_ID = appl_id;
IF( tmpDate > rset_last_updated_date) THEN
rset_last_updated_date := tmpDate;
SELECT max(last_update_date) INTO tmpDate FROM fnd_request_set_programs
WHERE request_set_id = set_id AND set_application_id = appl_id;
IF( tmpDate > rset_last_updated_date) THEN
rset_last_updated_date := tmpDate;
if( rset_last_updated_date > req_request_date ) then
errbuf := gen_error('FNDRSSUB', SQLCODE, 'Request Set Definition Changed');
SELECT run_number INTO current_run_number FROM fnd_concurrent_requests WHERE request_id = conc_req_id;
select count(r.request_set_program_id) INTO tmp_number
from fnd_run_requests r,
fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
where r.parent_request_id = conc_req_id
and fcr1.parent_request_id = fcr2.request_id
and fcr1.concurrent_program_id = r.concurrent_program_id
and r.request_id = fcr1.request_id
and fcr1.status_code = 'E'
and fcr2.parent_request_id = conc_req_id
and fcr2.run_number = current_run_number
and error_stage_id = to_number(fcr2.argument3)
AND r.request_set_program_id IS NOT NULL
AND r.request_set_program_id NOT IN
(
SELECT REQUEST_SET_PROGRAM_ID FROM FND_REQUEST_SET_PROGRAMS WHERE SET_APPLICATION_ID = appl_id
AND REQUEST_SET_ID = set_id AND REQUEST_SET_STAGE_ID = error_stage_id
);
update FND_CONCURRENT_REQUESTS set RUN_NUMBER = RUN_NUMBER + 1, COMPLETION_TEXT = null where request_id = conc_req_id;
select request_set_stage_id, user_stage_name
into next_stage, request_desc
from fnd_request_set_stages_vl stages
where stages.set_application_id = appl_id
and stages.request_set_id = set_id
and stages.request_set_stage_id = stage_id;
select decode(status_code, 'C', 'S', 'G', 'W', 'E')
into current_outcome
from fnd_concurrent_requests
where request_id = req_id;
select decode(current_outcome, 'S', success_link, 'W', warning_link, error_link), critical, user_stage_name
into next_stage, is_critical, user_stage_name
from fnd_request_set_stages_vl
where request_set_id = set_id
and set_application_id = appl_id
and request_set_stage_id = stage_id;
/* update the error stage id in this run */
if( current_outcome = 'E' and error_stage_id is null ) then
error_stage_id := stage_id;
/* Update critical_outcome if necessary */
/* new code added to check the outcome of all the stages
if we have more than one critical stages then
considering the 'worst' critical stage outcome as set outcome
bug 3785411
*/
/* Bug10116616: Added the condition previous_outcome = 'W' to
consider the previous warning outcome */
if (is_critical = 'Y') then
previous_outcome := substr(critical_outcome, 1, 1);
select meaning
into outcome_meaning
from fnd_lookups
where lookup_type = 'CP_SET_OUTCOME'
and lookup_code = current_outcome;
Select user_stage_name
into request_desc
from fnd_request_set_stages_vl
where request_set_id = set_id
and set_application_id = appl_id
and request_set_stage_id = next_stage;
update fnd_concurrent_requests set RUN_NUMBER =
(select RUN_NUMBER from fnd_concurrent_requests where request_id = conc_req_id)
where request_id = req_id;
select sp.critical,
sp.sequence,
a.application_short_name,
cp.concurrent_program_name,
r.request_set_program_id,
r.application_id,
r.concurrent_program_id,
r.number_of_copies,
r.printer,
r.print_style,
r.save_output_flag,
r.nls_language,
r.nls_territory,
/* NLS Project */
r.numeric_characters,
argument1, argument2, argument3, argument4, argument5,
argument6, argument7, argument8, argument9, argument10,
argument11, argument12, argument13, argument14, argument15,
argument16, argument17, argument18, argument19, argument20,
argument21, argument22, argument23, argument24, argument25,
argument26, argument27, argument28, argument29, argument30,
argument31, argument32, argument33, argument34, argument35,
argument36, argument37, argument38, argument39, argument40,
argument41, argument42, argument43, argument44, argument45,
argument46, argument47, argument48, argument49, argument50,
argument51, argument52, argument53, argument54, argument55,
argument56, argument57, argument58, argument59, argument60,
argument61, argument62, argument63, argument64, argument65,
argument66, argument67, argument68, argument69, argument70,
argument71, argument72, argument73, argument74, argument75,
argument76, argument77, argument78, argument79, argument80,
argument81, argument82, argument83, argument84, argument85,
argument86, argument87, argument88, argument89, argument90,
argument91, argument92, argument93, argument94, argument95,
argument96, argument97, argument98, argument99, argument100, r.org_id
from fnd_request_set_programs sp, fnd_run_requests r,
fnd_concurrent_programs cp, fnd_application a
where sp.set_application_id = appl_id
and sp.request_set_id = set_id
and sp.request_set_stage_id = stage_id
and sp.request_set_program_id = r.request_set_program_id
and sp.set_application_id = r.set_application_id
and sp.request_set_id = r.request_set_id
and r.parent_request_id = parent_id
and a.application_id = r.application_id
and cp.application_id = r.application_id
and cp.concurrent_program_id = r.concurrent_program_id
order by sp.sequence;
select sp.critical,
sp.sequence,
a.application_short_name,
cp.concurrent_program_name,
r.request_set_program_id,
r.application_id,
r.concurrent_program_id,
r.number_of_copies,
r.printer,
r.print_style,
r.save_output_flag,
r.nls_language,
r.nls_territory,
/* NLS Project */
r.numeric_characters,
r.argument1, r.argument2, r.argument3, r.argument4, r.argument5,
r.argument6, r.argument7, r.argument8, r.argument9, r.argument10,
r.argument11, r.argument12, r.argument13, r.argument14, r.argument15,
r.argument16, r.argument17, r.argument18, r.argument19, r.argument20,
r.argument21, r.argument22, r.argument23, r.argument24, r.argument25,
r.argument26, r.argument27, r.argument28, r.argument29, r.argument30,
r.argument31, r.argument32, r.argument33, r.argument34, r.argument35,
r.argument36, r.argument37, r.argument38, r.argument39, r.argument40,
r.argument41, r.argument42, r.argument43, r.argument44, r.argument45,
r.argument46, r.argument47, r.argument48, r.argument49, r.argument50,
r.argument51, r.argument52, r.argument53, r.argument54, r.argument55,
r.argument56, r.argument57, r.argument58, r.argument59, r.argument60,
r.argument61, r.argument62, r.argument63, r.argument64, r.argument65,
r.argument66, r.argument67, r.argument68, r.argument69, r.argument70,
r.argument71, r.argument72, r.argument73, r.argument74, r.argument75,
r.argument76, r.argument77, r.argument78, r.argument79, r.argument80,
r.argument81, r.argument82, r.argument83, r.argument84, r.argument85,
r.argument86, r.argument87, r.argument88, r.argument89, r.argument90,
r.argument91, r.argument92, r.argument93, r.argument94, r.argument95,
r.argument96, r.argument97, r.argument98, r.argument99, r.argument100, r.org_id
from fnd_request_set_programs sp, fnd_run_requests r,
fnd_concurrent_programs cp, fnd_application a, fnd_concurrent_requests fcr1, fnd_concurrent_requests fcr2
where sp.set_application_id = appl_id
and sp.request_set_id = set_id
and sp.request_set_stage_id = stage_id
and sp.request_set_program_id = r.request_set_program_id
and sp.set_application_id = r.set_application_id
and sp.request_set_id = r.request_set_id
and r.parent_request_id = parent_id
and a.application_id = r.application_id
and cp.application_id = r.application_id
and cp.concurrent_program_id = r.concurrent_program_id
and fcr1.parent_request_id = fcr2.request_id
and fcr1.concurrent_program_id = r.concurrent_program_id
and r.request_id = fcr1.request_id
and fcr1.status_code = 'E'
and fcr2.parent_request_id = parent_id
and fcr2.run_number = current_run_number - 1
and stage_id = to_number(fcr2.argument3)
order by sp.sequence;
select decode(status_code, 'C', 'S', 'G', 'W', 'E') outcome
from fnd_concurrent_requests
where parent_request_id = req_id
and critical = 'Y';
select arguments printer, number_of_copies
from fnd_run_req_pp_actions
where parent_request_id = parent_req_id
and request_set_program_id = set_program_id
and action_type = 1
order by sequence;
select arguments notify
from fnd_run_req_pp_actions
where parent_request_id = parent_req_id
and request_set_program_id = set_program_id
and action_type = 2
order by sequence;
select argument1, argument2, argument3, argument4, argument5
from fnd_run_req_pp_actions
where parent_request_id = parent_req_id
and request_set_program_id = set_program_id
and action_type = 6
order by sequence;
select argument1, argument2, argument3, argument4, argument5,
argument6, argument7, argument8, argument9, argument10
from fnd_run_req_pp_actions
where parent_request_id = parent_req_id
and request_set_program_id = set_program_id
and action_type in (7, 8)
order by sequence;
select outcome, execution_file_name,
s.set_application_id, s.request_set_id, s.request_set_stage_id,
s.function_id, s.function_application_id
into hardwired_outcome, funct,
g_set_appl_id, g_set_id, g_stage_id,
g_function_id, g_function_appl_id
from fnd_request_set_stages s, fnd_executables e
where s.set_application_id = appl_id
and s.request_set_id = set_id
and s.request_set_stage_id = stage_id
and e.executable_id(+) = s.function_id
and e.application_id(+) = s.function_application_id;
select run_number into run_number_var from fnd_concurrent_requests where request_id = parent_id;
UPDATE fnd_run_requests
SET request_id = req_id
WHERE request_set_program_id = req.request_set_program_id
AND application_id = req.application_id
AND concurrent_program_id = req.concurrent_program_id
AND parent_request_id = parent_id
AND set_application_id = appl_id
AND request_set_id = set_id;
UPDATE fnd_concurrent_requests
SET RUN_NUMBER = run_number_var
WHERE request_id = req_id;
select meaning
into outcome_meaning
from fnd_lookups
where lookup_type = 'CP_SET_OUTCOME'
and lookup_code = current_outcome;
select value into val
from fnd_stage_fn_parameters_vl p, fnd_stage_fn_parameter_values v
where v.set_application_id = g_set_appl_id
and v.request_set_id = g_set_id
and v.request_set_stage_id = g_stage_id
and v.function_id = g_function_id
and v.function_application_id =g_function_appl_id
and v.parameter_id = p.parameter_id
and p.parameter_name = name
and p.function_id = v.function_id
and p.application_id = v.function_application_id;