[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select NVL(resub_count, 1), REQUESTED_START_DATE, NUMBER_OF_ARGUMENTS,
r.RESUBMIT_INTERVAL, r.RESUBMIT_INTERVAL_UNIT_CODE,
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,
INCREMENT_DATES, RELEASE_CLASS_APP_ID, r.RELEASE_CLASS_ID,
CONCURRENT_PROGRAM_NAME, APPLICATION_SHORT_NAME,
RELEASE_CLASS_NAME, CLASS_TYPE, INCREMENT_PROC
into P_count, old_req_start, P_nargs,
P_rsub_int, P_rsub_int_unit_code,
p_args(1), p_args(2), p_args(3), p_args(4), p_args(5), p_args(6), p_args(7),
p_args(8), p_args(9), p_args(10), p_args(11), p_args(12), p_args(13), p_args(14),
p_args(15), p_args(16), p_args(17), p_args(18), p_args(19), p_args(20),
p_args(21), p_args(22), p_args(23), p_args(24), p_args(25),
P_increment_flag, P_sch_app_id, P_sch_id,
prog_name, prog_app_name,
P_sch_name,P_sch_type,P_inc_proc
from fnd_concurrent_requests r,
fnd_concurrent_programs p,
fnd_application a,
fnd_conc_release_classes c
where r.request_id = req_id
and r.concurrent_program_id = p.concurrent_program_id
and r.program_application_id = p.application_id
and r.program_application_id = a.application_id
and c.RELEASE_CLASS_ID = r.RELEASE_CLASS_ID
and r.RELEASE_CLASS_APP_ID = c.APPLICATION_ID;
select
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
into p_args(26), p_args(27), p_args(28), p_args(29), p_args(30),
p_args(31), p_args(32), p_args(33), p_args(34), p_args(35),
p_args(36), p_args(37), p_args(38), p_args(39), p_args(40),
p_args(41), p_args(42), p_args(43), p_args(44), p_args(45),
p_args(46), p_args(47), p_args(48), p_args(49), p_args(50),
p_args(51), p_args(52), p_args(53), p_args(54), p_args(55),
p_args(56), p_args(57), p_args(58), p_args(59), p_args(60),
p_args(61), p_args(62), p_args(63), p_args(64), p_args(65),
p_args(66), p_args(67), p_args(68), p_args(69), p_args(70),
p_args(71), p_args(72), p_args(73), p_args(74), p_args(75),
p_args(76), p_args(77), p_args(78), p_args(79), p_args(80),
p_args(81), p_args(82), p_args(83), p_args(84), p_args(85),
p_args(86), p_args(87), p_args(88), p_args(89), p_args(90),
p_args(91), p_args(92), p_args(93), p_args(94), p_args(95),
p_args(96), p_args(97), p_args(98), p_args(99), p_args(100)
from Fnd_Conc_Request_Arguments
where Request_Id = req_id;
UPDATE FND_CONCURRENT_REQUESTS
SET Argument_Text = argtxt2, NUMBER_OF_ARGUMENTS = P_nargs,
ARGUMENT1 = p_args(1), ARGUMENT2 = p_args(2), ARGUMENT3 = p_args(3), ARGUMENT4 = p_args(4),
ARGUMENT5 = p_args(5), ARGUMENT6 = p_args(6), ARGUMENT7 = p_args(7), ARGUMENT8 = p_args(8),
ARGUMENT9 = p_args(9), ARGUMENT10 = p_args(10), ARGUMENT11 = p_args(11),
ARGUMENT12 = p_args(12), ARGUMENT13 = p_args(13), ARGUMENT14 = p_args(14),
ARGUMENT15 = p_args(15), ARGUMENT16 = p_args(16), ARGUMENT17 = p_args(17),
ARGUMENT18 = p_args(18), ARGUMENT19 = p_args(19), ARGUMENT20 = p_args(20),
ARGUMENT21 = p_args(21), ARGUMENT22 = p_args(22),
ARGUMENT23 = p_args(23), ARGUMENT24 = p_args(24), ARGUMENT25 = p_args(25)
WHERE REQUEST_ID = new_req_id;
Update Fnd_Conc_Request_Arguments
Set Argument26 = p_args(26), Argument27 = p_args(27), Argument28 = p_args(28),
Argument29 = p_args(29), Argument30 = p_args(30), Argument31 = p_args(31),
Argument32 = p_args(32), Argument33 = p_args(33), Argument34 = p_args(34),
Argument35 = p_args(35), Argument36 = p_args(36), Argument37 = p_args(37),
Argument38 = p_args(38), Argument39 = p_args(39), Argument40 = p_args(40),
Argument41 = p_args(41), Argument42 = p_args(42), Argument43 = p_args(43),
Argument44 = p_args(44), Argument45 = p_args(45), Argument46 = p_args(46),
Argument47 = p_args(47), Argument48 = p_args(48), Argument49 = p_args(49),
Argument50 = p_args(50), Argument51 = p_args(51), Argument52 = p_args(52),
Argument53 = p_args(53), Argument54 = p_args(54), Argument55 = p_args(55),
Argument56 = p_args(56), Argument57 = p_args(57), Argument58 = p_args(58),
Argument59 = p_args(59), Argument60 = p_args(60), Argument61 = p_args(61),
Argument62 = p_args(62), Argument63 = p_args(63), Argument64 = p_args(64),
Argument65 = p_args(65), Argument66 = p_args(66), Argument67 = p_args(67),
Argument68 = p_args(68), Argument69 = p_args(69), Argument70 = p_args(70),
Argument71 = p_args(71), Argument72 = p_args(72), Argument73 = p_args(73),
Argument74 = p_args(74), Argument75 = p_args(75), Argument76 = p_args(76),
Argument77 = p_args(77), Argument78 = p_args(78), Argument79 = p_args(79),
Argument80 = p_args(80), Argument81 = p_args(81), Argument82 = p_args(82),
Argument83 = p_args(83), Argument84 = p_args(84), Argument85 = p_args(85),
Argument86 = p_args(86), Argument87 = p_args(87), Argument88 = p_args(88),
Argument89 = p_args(89), Argument90 = p_args(90), Argument91 = p_args(91),
Argument92 = p_args(92), Argument93 = p_args(93), Argument94 = p_args(94),
Argument95 = p_args(95), Argument96 = p_args(96), Argument97 = p_args(97),
Argument98 = p_args(98), Argument99 = p_args(99), Argument100 = p_args(100)
where Request_Id=new_req_id;
select request_type
into typ
from fnd_concurrent_requests
where request_id = req_id;
select r.application_id, r.concurrent_program_id,
r.request_set_program_id, r.set_application_id, r.request_set_id,
r.print_style, r.save_output_flag, r.nls_language, r.nls_territory,
r.numeric_characters, r.ops_instance,
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,
concurrent_program_name, application_short_name, increment_proc, org_id
from fnd_run_requests r,
fnd_concurrent_programs p,
fnd_application a
where r.parent_request_id = req_id
and r.concurrent_program_id = p.concurrent_program_id
and r.application_id = p.application_id
and r.application_id = a.application_id;
select NVL(resub_count, 1), REQUESTED_START_DATE,
r.RESUBMIT_INTERVAL, r.RESUBMIT_INTERVAL_UNIT_CODE,
INCREMENT_DATES, RELEASE_CLASS_APP_ID, r.RELEASE_CLASS_ID,
RELEASE_CLASS_NAME, CLASS_TYPE
into P_count, old_req_start,
P_rsub_int, P_rsub_int_unit_code,
P_increment_flag, P_sch_app_id, P_sch_id,
P_sch_name, P_sch_type
from fnd_concurrent_requests r,
fnd_conc_release_classes c
where r.request_id = req_id
and c.RELEASE_CLASS_ID = r.RELEASE_CLASS_ID
and r.RELEASE_CLASS_APP_ID = c.APPLICATION_ID;
insert into fnd_run_requests (application_id, concurrent_program_id,
parent_request_id, request_set_program_id,
set_application_id, request_set_id,
print_style, save_output_flag,
nls_language, nls_territory, numeric_characters, ops_instance,
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, org_id)
VALUES(v_app_id, v_prog_id, new_req_id, v_rsp_id,
v_set_app_id, v_set_id,
v_print_style, v_save_flag, v_nls_lang, v_nls_terr,
v_num_char, v_ops_instance,
p_args(1), p_args(2), p_args(3), p_args(4), p_args(5),
p_args(6), p_args(7), p_args(8), p_args(9), p_args(10),
p_args(11), p_args(12), p_args(13), p_args(14), p_args(15),
p_args(16), p_args(17), p_args(18), p_args(19), p_args(20),
p_args(21), p_args(22), p_args(23), p_args(24), p_args(25),
p_args(26), p_args(27), p_args(28), p_args(29), p_args(30),
p_args(31), p_args(32), p_args(33), p_args(34), p_args(35),
p_args(36), p_args(37), p_args(38), p_args(39), p_args(40),
p_args(41), p_args(42), p_args(43), p_args(44), p_args(45),
p_args(46), p_args(47), p_args(48), p_args(49), p_args(50),
p_args(51), p_args(52), p_args(53), p_args(54), p_args(55),
p_args(56), p_args(57), p_args(58), p_args(59), p_args(60),
p_args(61), p_args(62), p_args(63), p_args(64), p_args(65),
p_args(66), p_args(67), p_args(68), p_args(69), p_args(70),
p_args(71), p_args(72), p_args(73), p_args(74), p_args(75),
p_args(76), p_args(77), p_args(78), p_args(79), p_args(80),
p_args(81), p_args(82), p_args(83), p_args(84), p_args(85),
p_args(86), p_args(87), p_args(88), p_args(89), p_args(90),
p_args(91), p_args(92), p_args(93), p_args(94), p_args(95),
p_args(96), p_args(97), p_args(98), p_args(99), p_args(100),
v_org_id);
insert into fnd_run_req_pp_actions (
request_set_program_id, request_set_id,
set_application_id,
parent_request_id,action_type,status_s_flag,
status_w_flag,status_f_flag,
program_application_id,program_id,arguments,
number_of_copies,sequence,ops_instance,
orig_system,orig_system_id,nls_language,
argument1,argument2,argument3,argument4,argument5,
argument6,argument7,argument8,argument9,argument10)
select request_set_program_id, request_set_id,
set_application_id,
new_req_id, action_type,status_s_flag,
status_w_flag,status_f_flag,
program_application_id,program_id,arguments,
number_of_copies,sequence,ops_instance,
orig_system,orig_system_id,nls_language,
argument1,argument2,argument3,argument4,argument5,
argument6,argument7,argument8,argument9,argument10
from fnd_run_req_pp_actions
where parent_request_id = req_id
and request_set_program_id = v_rsp_id;
select nvl(increment_dates, 'N')
into P_increment_flag
from fnd_concurrent_requests
where request_id = req_id;