APPS.FND_SUBMIT dependencies on FND_REQUEST_SETS

Line 186: rs_application_id Fnd_Request_Sets.Application_id%TYPE;

182: incompatibilities_allowed varchar2(1);
183: print_together varchar2(1);
184: rs_printer varchar2(30);
185: rs_print_style varchar2(30);
186: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
187: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
188: rs_owner Fnd_Request_Sets.Owner%TYPE;
189: rs_conc_program varchar2(30);
190: par_request_id number;

Line 187: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;

183: print_together varchar2(1);
184: rs_printer varchar2(30);
185: rs_print_style varchar2(30);
186: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
187: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
188: rs_owner Fnd_Request_Sets.Owner%TYPE;
189: rs_conc_program varchar2(30);
190: par_request_id number;
191: sub_request boolean := FALSE;

Line 188: rs_owner Fnd_Request_Sets.Owner%TYPE;

184: rs_printer varchar2(30);
185: rs_print_style varchar2(30);
186: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
187: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
188: rs_owner Fnd_Request_Sets.Owner%TYPE;
189: rs_conc_program varchar2(30);
190: par_request_id number;
191: sub_request boolean := FALSE;
192: success_failure boolean;

Line 206: from fnd_request_sets RS, fnd_request_set_stages RSS,

202:
203: cursor set_programs( set_app_id number, set_id number) is
204: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
205: RSP.sequence
206: from fnd_request_sets RS, fnd_request_set_stages RSS,
207: fnd_concurrent_programs CP, fnd_request_set_programs RSP
208: where RS.application_id = set_app_id
209: and RS.request_set_id = set_id
210: and RSS.set_application_id = RS.application_id

Line 269: from Fnd_Request_Sets_Vl RS, Fnd_Application A,

265: into P_SET_APP_ID, P_SET_ID,
266: incompatibilities_allowed, print_together,
267: rs_owner, rs_printer, rs_print_style,
268: rs_conc_program, user_rs_name
269: from Fnd_Request_Sets_Vl RS, Fnd_Application A,
270: Fnd_Concurrent_Programs CP
271: where
272: RS.Application_id = A.Application_id
273: And RS.Request_Set_Name = upper(request_set)

Line 1856: fnd_request_sets_vl frs,

1852: cursor program_cursor is
1853: select fcp.concurrent_program_name, frsp.critical
1854: FROM fnd_request_set_programs frsp,
1855: fnd_concurrent_programs_vl fcp,
1856: fnd_request_sets_vl frs,
1857: fnd_application fa
1858: WHERE fa.application_short_name = template_appl_name
1859: AND fa.application_id = frs.application_id
1860: AND frs.request_set_name = template_request_set_name