[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
RSP.sequence
from fnd_request_sets RS, fnd_request_set_stages RSS,
fnd_concurrent_programs CP, fnd_request_set_programs RSP
where RS.application_id = set_app_id
and RS.request_set_id = set_id
and RSS.set_application_id = RS.application_id
and RSS.request_set_id = RS.request_set_id
and RSP.set_application_id = RSS.set_application_id
and RSP.request_set_id = RSS.request_set_id
and RSP.request_set_stage_id = RSS.request_set_stage_id
and RSP.program_application_id = CP.application_id(+)
and RSP.concurrent_program_id = CP.concurrent_program_id(+)
order by RSP.sequence;
update_failed exception;
select RS.application_id, RS.request_set_id,
allow_constraints_flag, RS.print_together_flag,
RS.owner, RS.printer, RS.print_style,
CP.Concurrent_Program_Name, RS.User_Request_Set_Name
into P_SET_APP_ID, P_SET_ID,
incompatibilities_allowed, print_together,
rs_owner, rs_printer, rs_print_style,
rs_conc_program, user_rs_name
from Fnd_Request_Sets_Vl RS, Fnd_Application A,
Fnd_Concurrent_Programs CP
where
RS.Application_id = A.Application_id
And RS.Request_Set_Name = upper(request_set)
And A.Application_Short_Name = upper(application)
And RS.Start_Date_Active <= sysdate
And nvl(RS.End_Date_Active,sysdate) >= sysdate
And RS.Concurrent_Program_Id = CP.Concurrent_Program_Id(+)
And RS.Application_Id = CP.Application_Id(+);
select phase_code, status_code
into P_PHASE_CODE, P_STATUS_CODE
from fnd_concurrent_requests
where request_id = P_RS_REQUEST_ID;
update fnd_concurrent_requests
set phase_code = 'C', status_code = 'E',
completion_text =
'Errored during request submission using request see APIs '
where request_id = P_RS_REQUEST_ID;
raise update_failed;
when update_failed then
fnd_message.set_name('FND', 'SQL-NO UPDATE');
insert_error exception;
select request_set_program_id, program_application_id,
RSP.concurrent_program_id, RSP.nls_language,
RSP.nls_territory, RSP.number_of_copies, RSP.printer,
RSP.print_style, RSP.save_output_flag
into rsp_program_id, rsp_prog_app_id,
rsp_conc_prog_id, rsp_nls_lang,
rsp_nls_territory, rsp_copies, rsp_printer,
rsp_style, rsp_save_output_flag
from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
fnd_concurrent_programs CP
where RSP.set_application_id = P_SET_APP_ID
and RSP.request_set_id = P_SET_ID
and RSP.set_application_id = RSS.set_application_id
and RSP.request_set_id = RSS.request_set_id
and RSP.request_set_stage_id = RSS.request_set_stage_id
and upper(RSS.stage_name) =
upper( P_SET_PROGRAMS(TAB_INDEX).stage)
and CP.application_id = RSP.program_application_id
and CP.concurrent_program_id = RSP.concurrent_program_id
and upper(CP.concurrent_program_name) =
upper( P_SET_PROGRAMS(TAB_INDEX).program )
and RSP.sequence = P_SET_PROGRAMS(TAB_INDEX).seq;
select substr(userenv('LANGUAGE'),1,
instr(userenv('LANGUAGE'), '_') -1)
into P_LANGUAGE
from dual;
select substr ( userenv('LANGUAGE') ,
instr ( userenv('LANGUAGE') , '_') + 1,
(instr ( userenv('LANGUAGE') , '.') - 1 -
instr ( userenv('LANGUAGE') , '_') ))
into P_TERRITORY
from dual;
Select
Printer_Name, NVL(Output_Print_Style, 'PORTRAIT'),
Required_Style, Minimum_Width,
Minimum_Length,
Execution_Method_Code, Save_Output_Flag, Print_Flag,
Queue_Control_Flag
Into
fcp_printer, print_style, reqrd_flag, minwid,
minlen, execcode, saveout, prtflg,
qctlflg
From Fnd_Concurrent_Programs P
Where P.Application_ID = rsp_prog_app_id
and P.concurrent_program_id = rsp_conc_prog_id;
insert into fnd_run_req_pp_actions
(parent_request_id, request_set_program_id,
set_application_id, request_set_id,
action_type, status_s_flag,
status_w_flag, status_f_flag,
program_application_id, program_id,
arguments, number_of_copies, sequence,ops_instance)
values
(P_RS_REQUEST_ID, rsp_program_id,
P_SET_APP_ID, P_SET_ID,
1, 'Y', 'N', 'N', NULL, NULL, curr_printer,
curr_copies, i, NVL(P_OPS_ID,fnd_conc_global.ops_inst_num));
insert into fnd_run_req_pp_actions
(parent_request_id, request_set_program_id,
set_application_id, request_set_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)
values
(P_RS_REQUEST_ID, rsp_program_id,
P_SET_APP_ID, P_SET_ID, 2,
P_NOTIFICATIONS(i).on_normal, P_NOTIFICATIONS(i).on_warning, P_NOTIFICATIONS(i).on_error,
NULL, NULL, P_NOTIFICATIONS(i).name,
NULL, i,NVL(P_OPS_ID,fnd_conc_global.ops_inst_num),
P_NOTIFICATIONS(i).orig_system,
P_NOTIFICATIONS(i).orig_system_id);
insert into fnd_run_req_pp_actions
(parent_request_id, request_set_program_id,
set_application_id, request_set_id,
action_type, status_s_flag,
status_w_flag, status_f_flag,
program_application_id, program_id,
arguments, number_of_copies, sequence, ops_instance,
argument1, argument2, argument3, argument4, argument5)
values
(P_RS_REQUEST_ID, rsp_program_id,
P_SET_APP_ID, P_SET_ID,
6, 'Y', 'N', 'N', NULL, NULL, NULL,
NULL, 1, NVL(P_OPS_ID, fnd_conc_global.ops_inst_num),
P_TEMPLATE_APPL, P_TEMPLATE_CODE, P_TEMPLATE_LANG,
P_TEMPLATE_TERR, P_OUTPUT_FORMAT);
-- Insert delivery options
if (P_DELIV_OPTS_COUNT > 0) then
for i in 1..P_DELIV_OPTS_COUNT loop
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,argument6,
argument7,argument8,
argument9,argument10,
nls_language,ops_instance)
values
(P_RS_REQUEST_ID,
P_SET_ID, P_SET_APP_ID, rsp_program_id,
decode( P_DELIVERY_OPTIONS(i).argument1, 'B', 8, 7 ),
'Y', 'Y', 'N',
NULL, NULL, i,
P_DELIVERY_OPTIONS(i).argument1,P_DELIVERY_OPTIONS(i).argument2,
P_DELIVERY_OPTIONS(i).argument3,P_DELIVERY_OPTIONS(i).argument4,
P_DELIVERY_OPTIONS(i).argument5,P_DELIVERY_OPTIONS(i).argument6,
P_DELIVERY_OPTIONS(i).argument7,P_DELIVERY_OPTIONS(i).argument8,
P_DELIVERY_OPTIONS(i).argument9,P_DELIVERY_OPTIONS(i).argument10,
P_DELIVERY_OPTIONS(i).lang, -1);
insert
into fnd_run_requests (
application_id, concurrent_program_id,
parent_request_id, request_set_program_id,
set_application_id, request_set_id,
number_of_copies, printer, print_style,
save_output_flag, nls_language, nls_territory, 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,
numeric_characters)
select rsp_prog_app_id, rsp_conc_prog_id,
P_RS_REQUEST_ID, rsp_program_id,
P_SET_APP_ID, P_SET_ID,
tot_copies, fcr_printer, valid_style,
saveout, P_LANGUAGE, P_TERRITORY,
NVL(P_OPS_ID,fnd_conc_global.ops_inst_num),
submit_program.argument1, submit_program.argument2,
submit_program.argument3, submit_program.argument4,
submit_program.argument5, submit_program.argument6,
submit_program.argument7, submit_program.argument8,
submit_program.argument9, submit_program.argument10,
submit_program.argument11, submit_program.argument12,
submit_program.argument13, submit_program.argument14,
submit_program.argument15, submit_program.argument16,
submit_program.argument17, submit_program.argument18,
submit_program.argument19, submit_program.argument20,
submit_program.argument21, submit_program.argument22,
submit_program.argument23, submit_program.argument24,
submit_program.argument25, submit_program.argument26,
submit_program.argument27, submit_program.argument28,
submit_program.argument29, submit_program.argument30,
submit_program.argument31, submit_program.argument32,
submit_program.argument33, submit_program.argument34,
submit_program.argument35, submit_program.argument36,
submit_program.argument37, submit_program.argument38,
submit_program.argument39, submit_program.argument40,
submit_program.argument41, submit_program.argument42,
submit_program.argument43, submit_program.argument44,
submit_program.argument45, submit_program.argument46,
submit_program.argument47, submit_program.argument48,
submit_program.argument49, submit_program.argument50,
submit_program.argument51, submit_program.argument52,
submit_program.argument53, submit_program.argument54,
submit_program.argument55, submit_program.argument56,
submit_program.argument57, submit_program.argument58,
submit_program.argument59, submit_program.argument60,
submit_program.argument61, submit_program.argument62,
submit_program.argument63, submit_program.argument64,
submit_program.argument65, submit_program.argument66,
submit_program.argument67, submit_program.argument68,
submit_program.argument69, submit_program.argument70,
submit_program.argument71, submit_program.argument72,
submit_program.argument73, submit_program.argument74,
submit_program.argument75, submit_program.argument76,
submit_program.argument77, submit_program.argument78,
submit_program.argument79, submit_program.argument80,
submit_program.argument81, submit_program.argument82,
submit_program.argument83, submit_program.argument84,
submit_program.argument85, submit_program.argument86,
submit_program.argument87, submit_program.argument88,
submit_program.argument89, submit_program.argument90,
submit_program.argument91, submit_program.argument92,
submit_program.argument93, submit_program.argument94,
submit_program.argument95, submit_program.argument96,
submit_program.argument97, submit_program.argument98,
submit_program.argument99, submit_program.argument100,
P_ORG_ID,
P_NUMERIC_CHARACTERS
from sys.dual;
raise insert_error;
when insert_error then
fnd_message.set_name ('FND', 'SQL-Generic error');
'ROUTINE', 'SUBMIT_PROGRAM: insert_error2', FALSE);
update_failed exception;
update fnd_concurrent_requests
set phase_code = P_PHASE_CODE,
status_code = Decode(issubreq, 'Y', 'Z', P_STATUS_CODE),
completion_text = '',
is_sub_request = issubreq,
requested_start_date =
Decode (requested_start,
'', (SYSDATE - tz_offset),
Greatest (requested_start,
Decode (par_request_id,
0, (SYSDATE - tz_offset),
To_Date ('01-01-0001',
'DD-MM-YYYY'))))
where request_id = P_RS_REQUEST_ID;
raise update_failed;
when update_failed then
fnd_message.set_name('FND', 'SQL-NO UPDATE');
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 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 count(*)
into c
from wf_roles
where user = name;
select name, orig_system, orig_system_id
from wf_roles
where name = user_name;
select delivery_id
into printer_id
from fnd_cp_ipp_printers
where ipp_printer_name = printer_name;
select count(*)
into cnt
from fnd_cp_ipp_printers
where delivery_id = printer_id;
select delivery_id
into server_id
from fnd_cp_ipp_printers
where ipp_printer_name = server_name;
select count(*)
into cnt
from fnd_cp_ipp_printers
where delivery_id = server_id
and support_fax = 'Y';
select count(*)
into cnt
from fnd_cp_delivery_commands
where delivery_id = custom_id;
select delivery_id
into custom_id
from fnd_cp_delivery_options
where delivery_name = custom_name;
select fcp.concurrent_program_name, frsp.critical
FROM fnd_request_set_programs frsp,
fnd_concurrent_programs_vl fcp,
fnd_request_sets_vl frs,
fnd_application fa
WHERE fa.application_short_name = template_appl_name
AND fa.application_id = frs.application_id
AND frs.request_set_name = template_request_set_name
AND frs.request_set_id = frsp.request_set_id
AND frs.application_id = frsp.set_application_id
AND frsp.program_application_id = fcp.application_id
AND frsp.concurrent_program_id = fcp.concurrent_program_id
AND fcp.srs_flag IN('Y', 'Q')
AND fcp.enabled_flag = 'N'
AND fcp.request_set_flag = 'N';