eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SUBMIT dependencies on FND_REQUEST

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 207: fnd_concurrent_programs CP, fnd_request_set_programs RSP

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
211: and RSS.request_set_id = RS.request_set_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 328: success_failure := fnd_request.set_print_options (

324:
325:
326: -- Set the Print options for the FNDRSSUB concurrent program
327:
328: success_failure := fnd_request.set_print_options (
329: rs_printer,
330: rs_print_style,
331: 0,
332: NULL,

Line 345: fnd_request.internal( NULL, 'M' );

341: end if;
342:
343: -- Set the request set type before submitting the FNDRSSUB request
344:
345: fnd_request.internal( NULL, 'M' );
346:
347: if ( nvl(incompatibilities_allowed,'N') = 'Y' ) then
348: rs_submission_program := rs_conc_program;
349: rs_program_application := application;

Line 357: P_RS_REQUEST_ID := fnd_request.submit_request(

353: end if;
354:
355: -- Submit concurrent request for request set
356:
357: P_RS_REQUEST_ID := fnd_request.submit_request(
358: rs_program_application,
359: rs_submission_program,
360: user_rs_name,
361: NULL,

Line 693: -- all options from the fnd_request_set_programs

689: raise program_not_found;
690: end if;
691:
692: -- get the request_set_program_id,prog_app_id, conc_prog_id and
693: -- all options from the fnd_request_set_programs
694:
695: begin
696: select request_set_program_id, program_application_id,
697: RSP.concurrent_program_id, RSP.nls_language,

Line 704: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,

700: into rsp_program_id, rsp_prog_app_id,
701: rsp_conc_prog_id, rsp_nls_lang,
702: rsp_nls_territory, rsp_copies, rsp_printer,
703: rsp_style, rsp_save_output_flag
704: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
705: fnd_concurrent_programs CP
706: where RSP.set_application_id = P_SET_APP_ID
707: and RSP.request_set_id = P_SET_ID
708: and RSP.set_application_id = RSS.set_application_id

Line 1338: return (fnd_request.set_mode(db_trigger));

1334: --
1335: function set_mode (db_trigger IN boolean) return boolean is
1336: begin
1337: P_DB_TRIGGER_MODE := db_trigger;
1338: return (fnd_request.set_mode(db_trigger));
1339: return TRUE;
1340: end;
1341:
1342:

Line 1379: -- All the messages are set by fnd_request.set_repeat_options function.

1375: -- set_repeat_options
1376: -- Purpose
1377: -- Called before submitting request if the request to be submitted
1378: -- is a repeating request.
1379: -- All the messages are set by fnd_request.set_repeat_options function.
1380: --
1381: -- Arguments
1382: -- repeat_time - Time of day at which it has to be repeated
1383: -- repeat_interval - Frequency at which it has to be repeated

Line 1401: -- Just call the fnd_request.set_repeat_options with the passed parameters

1397: return boolean is
1398: success boolean;
1399: begin
1400:
1401: -- Just call the fnd_request.set_repeat_options with the passed parameters
1402:
1403: success := fnd_request.set_repeat_options(repeat_time,
1404: repeat_interval,
1405: repeat_unit,

Line 1403: success := fnd_request.set_repeat_options(repeat_time,

1399: begin
1400:
1401: -- Just call the fnd_request.set_repeat_options with the passed parameters
1402:
1403: success := fnd_request.set_repeat_options(repeat_time,
1404: repeat_interval,
1405: repeat_unit,
1406: repeat_type,
1407: repeat_end_time);

Line 1425: -- All the failure messages are from the fnd_request package.

1421: -- set_rel_class_options
1422: -- Purpose
1423: -- Called before submitting request if the request to be submitted
1424: -- is using the new scheduler functionality.
1425: -- All the failure messages are from the fnd_request package.
1426: --
1427: -- Arguments
1428: -- application - Application Name of Release Class
1429: -- class_name - (Developer) Name of Release Class

Line 1441: -- just call fnd_request.set_rel_class_options and return the return code

1437: return boolean is
1438:
1439: success boolean;
1440: begin
1441: -- just call fnd_request.set_rel_class_options and return the return code
1442: -- set_rel_class_options is with respect to set_request_set function.
1443:
1444: success := fnd_request.set_rel_class_options (
1445: application,

Line 1444: success := fnd_request.set_rel_class_options (

1440: begin
1441: -- just call fnd_request.set_rel_class_options and return the return code
1442: -- set_rel_class_options is with respect to set_request_set function.
1443:
1444: success := fnd_request.set_rel_class_options (
1445: application,
1446: class_name,
1447: cancel_or_hold,
1448: stale_date

Line 1854: FROM fnd_request_set_programs frsp,

1850: template_request_set_name in varchar2)
1851: return varchar2 is
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

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