APPS.FND_SUBMIT dependencies on FND_REQUEST_SETS

Line 212: rs_application_id Fnd_Request_Sets.Application_id%TYPE;

208: incompatibilities_allowed varchar2(1);
209: print_together varchar2(1);
210: rs_printer varchar2(30);
211: rs_print_style varchar2(30);
212: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
213: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
214: rs_owner Fnd_Request_Sets.Owner%TYPE;
215: rs_conc_program varchar2(30);
216: par_request_id number;

Line 213: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;

209: print_together varchar2(1);
210: rs_printer varchar2(30);
211: rs_print_style varchar2(30);
212: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
213: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
214: rs_owner Fnd_Request_Sets.Owner%TYPE;
215: rs_conc_program varchar2(30);
216: par_request_id number;
217: sub_request boolean := FALSE;

Line 214: rs_owner Fnd_Request_Sets.Owner%TYPE;

210: rs_printer varchar2(30);
211: rs_print_style varchar2(30);
212: rs_application_id Fnd_Request_Sets.Application_id%TYPE;
213: rs_id Fnd_Request_Sets.Request_Set_Id%TYPE;
214: rs_owner Fnd_Request_Sets.Owner%TYPE;
215: rs_conc_program varchar2(30);
216: par_request_id number;
217: sub_request boolean := FALSE;
218: success_failure boolean;

Line 232: from fnd_request_sets RS, fnd_request_set_stages RSS,

228:
229: cursor set_programs( set_app_id number, set_id number) is
230: select CP.concurrent_program_name, CP.enabled_flag, RSS.stage_name,
231: RSP.sequence
232: from fnd_request_sets RS, fnd_request_set_stages RSS,
233: fnd_concurrent_programs CP, fnd_request_set_programs RSP
234: where RS.application_id = set_app_id
235: and RS.request_set_id = set_id
236: and RSS.set_application_id = RS.application_id

Line 295: from Fnd_Request_Sets_Vl RS, Fnd_Application A,

291: into P_SET_APP_ID, P_SET_ID,
292: incompatibilities_allowed, print_together,
293: rs_owner, rs_printer, rs_print_style,
294: rs_conc_program, user_rs_name
295: from Fnd_Request_Sets_Vl RS, Fnd_Application A,
296: Fnd_Concurrent_Programs CP
297: where
298: RS.Application_id = A.Application_id
299: And RS.Request_Set_Name = upper(request_set)

Line 2303: fnd_request_sets_vl frs,

2299: cursor program_cursor is
2300: select fcp.concurrent_program_name, frsp.critical
2301: FROM fnd_request_set_programs frsp,
2302: fnd_concurrent_programs_vl fcp,
2303: fnd_request_sets_vl frs,
2304: fnd_application fa
2305: WHERE fa.application_short_name = template_appl_name
2306: AND fa.application_id = frs.application_id
2307: AND frs.request_set_name = template_request_set_name