[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE FND_RUN_REQUESTS_INSERT(p_application_id in number,
p_concurrent_program_id in number, p_parent_request_id in number,
p_request_set_program_id in number,
p_set_application_id in number, p_request_set_id in number,
p_printer in varchar2, p_print_style in varchar2,
p_save_output_flag in varchar2, p_number_of_copies in number,
p_nls_language in varchar2, p_nls_territory in varchar2, p_numeric_char in varchar2,
p_argument1 in varchar2, p_argument2 in varchar2, p_argument3 in varchar2,
p_argument4 in varchar2, p_argument5 in varchar2, p_argument6 in varchar2,
p_argument7 in varchar2, p_argument8 in varchar2, p_argument9 in varchar2,
p_argument10 in varchar2, p_argument11 in varchar2, p_argument12 in varchar2,
p_argument13 in varchar2, p_argument14 in varchar2, p_argument15 in varchar2,
p_argument16 in varchar2, p_argument17 in varchar2, p_argument18 in varchar2,
p_argument19 in varchar2, p_argument20 in varchar2, p_argument21 in varchar2,
p_argument22 in varchar2, p_argument23 in varchar2, p_argument24 in varchar2,
p_argument25 in varchar2, p_argument26 in varchar2, p_argument27 in varchar2,
p_argument28 in varchar2, p_argument29 in varchar2, p_argument30 in varchar2,
p_argument31 in varchar2, p_argument32 in varchar2, p_argument33 in varchar2,
p_argument34 in varchar2, p_argument35 in varchar2, p_argument36 in varchar2,
p_argument37 in varchar2, p_argument38 in varchar2, p_argument39 in varchar2,
p_argument40 in varchar2, p_argument41 in varchar2, p_argument42 in varchar2,
p_argument43 in varchar2, p_argument44 in varchar2, p_argument45 in varchar2,
p_argument46 in varchar2, p_argument47 in varchar2, p_argument48 in varchar2,
p_argument49 in varchar2, p_argument50 in varchar2, p_argument51 in varchar2,
p_argument52 in varchar2, p_argument53 in varchar2, p_argument54 in varchar2,
p_argument55 in varchar2, p_argument56 in varchar2, p_argument57 in varchar2,
p_argument58 in varchar2, p_argument59 in varchar2, p_argument60 in varchar2,
p_argument61 in varchar2, p_argument62 in varchar2, p_argument63 in varchar2,
p_argument64 in varchar2, p_argument65 in varchar2, p_argument66 in varchar2,
p_argument67 in varchar2, p_argument68 in varchar2, p_argument69 in varchar2,
p_argument70 in varchar2, p_argument71 in varchar2, p_argument72 in varchar2,
p_argument73 in varchar2, p_argument74 in varchar2, p_argument75 in varchar2,
p_argument76 in varchar2, p_argument77 in varchar2, p_argument78 in varchar2,
p_argument79 in varchar2, p_argument80 in varchar2, p_argument81 in varchar2,
p_argument82 in varchar2, p_argument83 in varchar2, p_argument84 in varchar2,
p_argument85 in varchar2, p_argument86 in varchar2, p_argument87 in varchar2,
p_argument88 in varchar2, p_argument89 in varchar2, p_argument90 in varchar2,
p_argument91 in varchar2, p_argument92 in varchar2, p_argument93 in varchar2,
p_argument94 in varchar2, p_argument95 in varchar2, p_argument96 in varchar2,
p_argument97 in varchar2, p_argument98 in varchar2, p_argument99 in varchar2,
p_argument100 in varchar2) IS
BEGIN
insert into fnd_run_requests
(application_id, concurrent_program_id, parent_request_id,
request_set_program_id,
set_application_id, request_set_id,
printer, print_style, save_output_flag, number_of_copies,
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
(p_application_id, p_concurrent_program_id, p_parent_request_id,
p_request_set_program_id,
p_set_application_id, p_request_set_id,
p_printer, p_print_style, p_save_output_flag, p_number_of_copies,
p_nls_language, p_nls_territory, p_numeric_char,
SUBMIT_OPS_ID,
p_argument1, p_argument2, p_argument3, p_argument4, p_argument5,
p_argument6, p_argument7, p_argument8, p_argument9, p_argument10,
p_argument11, p_argument12, p_argument13, p_argument14, p_argument15,
p_argument16, p_argument17, p_argument18, p_argument19, p_argument20,
p_argument21, p_argument22, p_argument23, p_argument24, p_argument25,
p_argument26, p_argument27, p_argument28, p_argument29, p_argument30,
p_argument31, p_argument32, p_argument33, p_argument34, p_argument35,
p_argument36, p_argument37, p_argument38, p_argument39, p_argument40,
p_argument41, p_argument42, p_argument43, p_argument44, p_argument45,
p_argument46, p_argument47, p_argument48, p_argument49, p_argument50,
p_argument51, p_argument52, p_argument53, p_argument54, p_argument55,
p_argument56, p_argument57, p_argument58, p_argument59, p_argument60,
p_argument61, p_argument62, p_argument63, p_argument64, p_argument65,
p_argument66, p_argument67, p_argument68, p_argument69, p_argument70,
p_argument71, p_argument72, p_argument73, p_argument74, p_argument75,
p_argument76, p_argument77, p_argument78, p_argument79, p_argument80,
p_argument81, p_argument82, p_argument83, p_argument84, p_argument85,
p_argument86, p_argument87, p_argument88, p_argument89, p_argument90,
p_argument91, p_argument92, p_argument93, p_argument94, p_argument95,
p_argument96, p_argument97, p_argument98, p_argument99, p_argument100, P_ORG_ID);
select MLS_EXECUTABLE_ID, MLS_EXECUTABLE_APP_ID into mls_exe_id, mls_exe_app_id
from fnd_concurrent_programs FCP, fnd_application FA
where FCP.CONCURRENT_PROGRAM_NAME = UPPER(program) AND FA.APPLICATION_SHORT_NAME = UPPER(application)
AND FCP.APPLICATION_ID=FA.APPLICATION_ID;
select fcpt.user_concurrent_program_name, fcp.concurrent_program_id, fa.application_id, DECODE(ops_req_mode,
'EXPLICIT', NVL(P_OPS_ID,NVL(fcp.instance_id,fnd_conc_global.ops_inst_num)),
-1), Printer_Name into USER_PROG_NAME, CONC_PROG_ID, CONC_APP_ID, SUBMIT_OPS_ID, FCP_PRINTER
from fnd_concurrent_programs fcp, fnd_concurrent_programs_tl fcpt, fnd_application fa
where fcp.concurrent_program_id=fcpt.concurrent_program_id and fcp.application_id=fcpt.application_id
and fa.application_id=fcp.application_id and fcpt.language = userenv('LANG')
and fcp.concurrent_program_name= upper(program) and fa.application_short_name=UPPER(application);
fnd_run_requests_insert(CONC_APP_ID,
CONC_PROG_ID,
REQ_ID,
0, 0, 0,
NULL, P_PRINT_STYLE,
P_SAVE_OUTPUT,
NULL,
P_LANGUAGE,
P_TERRITORY, P_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);
insert into fnd_run_req_languages
( parent_request_id,
nls_language,
nls_territory,
numeric_characters,
created_by,
creation_date,
last_updated_by,
last_update_date,
last_update_login)
values
( REQ_ID,
curr_nls_lang,
curr_nls_terr,
curr_nls_numchar,
FND_GLOBAL.USER_ID, sysdate, FND_GLOBAL.USER_ID,
sysdate, FND_GLOBAL.CONC_LOGIN_ID);
insert into fnd_run_req_pp_actions
(parent_request_id,
request_set_id,
set_application_id,
request_set_program_id,
action_type,
status_s_flag,
status_w_flag,
status_f_flag,
program_application_id,
program_id,
arguments,
number_of_copies,
sequence,
orig_system,
orig_system_id,
nls_language,
ops_instance)
values
(REQ_ID,
0, 0, 0,
2, on_normal, on_warning, on_error, null, null,
name, null, i,
orig_system, orig_system_id, P_LANGUAGE, SUBMIT_OPS_ID);
insert into fnd_run_req_pp_actions
(parent_request_id,
request_set_id,
set_application_id,
request_set_program_id,
action_type,
status_s_flag,
status_w_flag,
status_f_flag,
program_application_id,
program_id,
sequence,
argument1,
argument2,
argument3,
argument4,
argument5,
nls_language,
ops_instance)
values
(REQ_ID,
0, 0, 0,
6, 'Y', 'N', 'N', CONC_APP_ID, CONC_PROG_ID, i,
P_LAYOUTS(i).template_appl_name,
P_LAYOUTS(i).template_code,
P_LAYOUTS(i).template_language,
P_LAYOUTS(i).template_territory,
P_LAYOUTS(i).output_format,
P_LAYOUTS(i).nls_language,
SUBMIT_OPS_ID);
insert into fnd_run_req_pp_actions
(parent_request_id,
request_set_id,
set_application_id,
request_set_program_id,
action_type,
status_s_flag,
status_w_flag,
status_f_flag,
program_application_id,
program_id,
arguments,
number_of_copies,
sequence,
nls_language,
ops_instance)
values
(REQ_ID,
0, 0, 0,
1, 'Y', 'N', 'N', null, null,
curr_printer, curr_copies, i, curr_lang, SUBMIT_OPS_ID);
select name, orig_system, orig_system_id
from wf_roles
where name = user_name;
Select printer_type
Into printer_typ
From fnd_printer
Where printer_name = printer;
Select 'X'
Into Dummy_fld
From Fnd_Printer_Information
Where Printer_Style = P_PRINT_STYLE
And Printer_Type = printer_typ;
Select printer_type
Into printer_typ
From fnd_printer
Where printer_name = printer;
Select Printer_Style_Name
Into P_PRINT_STYLE
From Fnd_Printer_styles
Where Printer_Style_Name = style;
Select 'X'
Into Dummy_fld
From Fnd_Printer_Information
Where Printer_Style = P_PRINT_STYLE
And Printer_Type = printer_typ;
select nls_language
into dummy_val
from fnd_languages
where nls_language = upper(language);
select count(*)
into dummy_count
from fnd_territories
where nls_territory = upper(territory);
select lookup_code
into dummy_val
from fnd_lookup_values_vl
where lookup_type = 'ICX_NUMERIC_CHARACTERS' and
lookup_code = numeric_characters;