APPS.PAY_AU_XMLPUB_REPORTS dependencies on FND_CONCURRENT_REQUESTS

Line 44: FROM fnd_concurrent_requests fcr

40: SELECT printer,
41: print_style,
42: decode(save_output_flag, 'Y', 'TRUE', 'N', 'FALSE') save_output
43: ,number_of_copies
44: FROM fnd_concurrent_requests fcr
45: WHERE fcr.request_id = c_request_id;
46:
47: rec_print_options csr_get_print_options%ROWTYPE;
48:

Line 141: cursor get_argument_values(p_conc_request_id fnd_concurrent_requests.request_id%type)

137: is
138: l_count number;
139: l_procedure varchar2(50);
140:
141: cursor get_argument_values(p_conc_request_id fnd_concurrent_requests.request_id%type)
142: is
143: select
144: p.srs_flag, p.concurrent_program_name, r.program_application_id,
145: r.argument1, r.argument2, r.argument3, r.argument4,

Line 152: from fnd_concurrent_requests r, fnd_concurrent_programs p

148: r.argument13, r.argument14, r.argument15, r.argument16,
149: r.argument17, r.argument18, r.argument19, r.argument20,
150: r.argument21, r.argument22, r.argument23, r.argument24,
151: r.argument25, r.number_of_arguments,r.request_date
152: from fnd_concurrent_requests r, fnd_concurrent_programs p
153: where r.request_id = p_conc_request_id
154: and r.concurrent_program_id = p.concurrent_program_id
155: and r.program_application_id = p.application_id;
156:

Line 157: cursor get_all_arguments(p_conc_request_id fnd_concurrent_requests.request_id%type)

153: where r.request_id = p_conc_request_id
154: and r.concurrent_program_id = p.concurrent_program_id
155: and r.program_application_id = p.application_id;
156:
157: cursor get_all_arguments(p_conc_request_id fnd_concurrent_requests.request_id%type)
158: is
159: select
160: Argument26, Argument27, Argument28, Argument29, Argument30,
161: Argument31, Argument32, Argument33, Argument34, Argument35,

Line 201: l_prog_appl_id fnd_concurrent_requests.program_application_id%type;

197: l_argument_row char_tab_type;
198:
199: l_srs_flag fnd_concurrent_programs.srs_flag%type;
200: l_conc_program_name fnd_concurrent_programs.concurrent_program_name%type;
201: l_prog_appl_id fnd_concurrent_requests.program_application_id%type;
202: l_number_of_arg fnd_concurrent_requests.number_of_arguments%type;
203: l_request_date fnd_concurrent_requests.request_date%type;
204:
205:

Line 202: l_number_of_arg fnd_concurrent_requests.number_of_arguments%type;

198:
199: l_srs_flag fnd_concurrent_programs.srs_flag%type;
200: l_conc_program_name fnd_concurrent_programs.concurrent_program_name%type;
201: l_prog_appl_id fnd_concurrent_requests.program_application_id%type;
202: l_number_of_arg fnd_concurrent_requests.number_of_arguments%type;
203: l_request_date fnd_concurrent_requests.request_date%type;
204:
205:
206: begin

Line 203: l_request_date fnd_concurrent_requests.request_date%type;

199: l_srs_flag fnd_concurrent_programs.srs_flag%type;
200: l_conc_program_name fnd_concurrent_programs.concurrent_program_name%type;
201: l_prog_appl_id fnd_concurrent_requests.program_application_id%type;
202: l_number_of_arg fnd_concurrent_requests.number_of_arguments%type;
203: l_request_date fnd_concurrent_requests.request_date%type;
204:
205:
206: begin
207: