DBA Data[Home] [Help]

APPS.PAY_AU_XMLPUB_REPORTS dependencies on FND_CONCURRENT_PROGRAMS

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 179: cursor get_attribute_order(l_appl_id fnd_concurrent_programs.application_id%type

175: from fnd_conc_request_arguments
176: where request_id = p_conc_request_id;
177:
178:
179: cursor get_attribute_order(l_appl_id fnd_concurrent_programs.application_id%type
180: ,l_conc_prog_name fnd_concurrent_programs.concurrent_program_name%type)
181: is
182: select to_number(substr(application_column_name, 10)) num,
183: end_user_column_name

Line 180: ,l_conc_prog_name fnd_concurrent_programs.concurrent_program_name%type)

176: where request_id = p_conc_request_id;
177:
178:
179: cursor get_attribute_order(l_appl_id fnd_concurrent_programs.application_id%type
180: ,l_conc_prog_name fnd_concurrent_programs.concurrent_program_name%type)
181: is
182: select to_number(substr(application_column_name, 10)) num,
183: end_user_column_name
184: from fnd_descr_flex_column_usages

Line 199: l_srs_flag fnd_concurrent_programs.srs_flag%type;

195:
196: TYPE char_tab_type is TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
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;

Line 200: l_conc_program_name fnd_concurrent_programs.concurrent_program_name%type;

196: TYPE char_tab_type is TABLE OF VARCHAR2(240) INDEX BY BINARY_INTEGER;
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: