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

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

350:
351:
352: -- Set the Print options for the FNDRSSUB concurrent program
353:
354: success_failure := fnd_request.set_print_options (
355: rs_printer,
356: rs_print_style,
357: 0,
358: NULL,

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

367: end if;
368:
369: -- Set the request set type before submitting the FNDRSSUB request
370:
371: fnd_request.internal( NULL, 'M' );
372:
373: if ( nvl(incompatibilities_allowed,'N') = 'Y' ) then
374: rs_submission_program := rs_conc_program;
375: rs_program_application := application;

Line 383: P_RS_REQUEST_ID := fnd_request.submit_request(

379: end if;
380:
381: -- Submit concurrent request for request set
382:
383: P_RS_REQUEST_ID := fnd_request.submit_request(
384: rs_program_application,
385: rs_submission_program,
386: user_rs_name,
387: NULL,

Line 719: -- all options from the fnd_request_set_programs

715: raise program_not_found;
716: end if;
717:
718: -- get the request_set_program_id,prog_app_id, conc_prog_id and
719: -- all options from the fnd_request_set_programs
720:
721: begin
722: select request_set_program_id, program_application_id,
723: RSP.concurrent_program_id, RSP.nls_language,

Line 730: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,

726: into rsp_program_id, rsp_prog_app_id,
727: rsp_conc_prog_id, rsp_nls_lang,
728: rsp_nls_territory, rsp_copies, rsp_printer,
729: rsp_style, rsp_save_output_flag
730: from fnd_request_set_programs RSP, fnd_request_set_stages RSS,
731: fnd_concurrent_programs CP
732: where RSP.set_application_id = P_SET_APP_ID
733: and RSP.request_set_id = P_SET_ID
734: and RSP.set_application_id = RSS.set_application_id

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

1388: --
1389: function set_mode (db_trigger IN boolean) return boolean is
1390: begin
1391: P_DB_TRIGGER_MODE := db_trigger;
1392: return (fnd_request.set_mode(db_trigger));
1393: return TRUE;
1394: end;
1395:
1396:

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

1429: -- set_repeat_options
1430: -- Purpose
1431: -- Called before submitting request if the request to be submitted
1432: -- is a repeating request.
1433: -- All the messages are set by fnd_request.set_repeat_options function.
1434: --
1435: -- Arguments
1436: -- repeat_time - Time of day at which it has to be repeated
1437: -- repeat_interval - Frequency at which it has to be repeated

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

1451: return boolean is
1452: success boolean;
1453: begin
1454:
1455: -- Just call the fnd_request.set_repeat_options with the passed parameters
1456:
1457: success := fnd_request.set_repeat_options(repeat_time,
1458: repeat_interval,
1459: repeat_unit,

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

1453: begin
1454:
1455: -- Just call the fnd_request.set_repeat_options with the passed parameters
1456:
1457: success := fnd_request.set_repeat_options(repeat_time,
1458: repeat_interval,
1459: repeat_unit,
1460: repeat_type,
1461: repeat_end_time);

Line 1488: -- Just call the fnd_request.set_increment_dates_option

1484: procedure set_increment_dates_option (increment_dates IN varchar2)
1485: is
1486: begin
1487:
1488: -- Just call the fnd_request.set_increment_dates_option
1489: -- with the passed parameters
1490:
1491: fnd_request.set_increment_dates_option(increment_dates);
1492:

Line 1491: fnd_request.set_increment_dates_option(increment_dates);

1487:
1488: -- Just call the fnd_request.set_increment_dates_option
1489: -- with the passed parameters
1490:
1491: fnd_request.set_increment_dates_option(increment_dates);
1492:
1493: end set_increment_dates_option;
1494:
1495: --

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

1497: -- set_rel_class_options
1498: -- Purpose
1499: -- Called before submitting request if the request to be submitted
1500: -- is using the new scheduler functionality.
1501: -- All the failure messages are from the fnd_request package.
1502: --
1503: -- Arguments
1504: -- application - Application Name of Release Class
1505: -- class_name - (Developer) Name of Release Class

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

1513: return boolean is
1514:
1515: success boolean;
1516: begin
1517: -- just call fnd_request.set_rel_class_options and return the return code
1518: -- set_rel_class_options is with respect to set_request_set function.
1519:
1520: success := fnd_request.set_rel_class_options (
1521: application,

Line 1520: success := fnd_request.set_rel_class_options (

1516: begin
1517: -- just call fnd_request.set_rel_class_options and return the return code
1518: -- set_rel_class_options is with respect to set_request_set function.
1519:
1520: success := fnd_request.set_rel_class_options (
1521: application,
1522: class_name,
1523: cancel_or_hold,
1524: stale_date

Line 2301: FROM fnd_request_set_programs frsp,

2297: template_request_set_name in varchar2)
2298: return varchar2 is
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

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