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_PROGRAM dependencies on FND_EXECUTABLES

Line 608: fnd_executables.execution_method_code%TYPE;

604: := creation_date_f;
605: created_by fnd_flex_value_sets.created_by%TYPE
606: := created_by_f;
607: execution_method_code_i
608: fnd_executables.execution_method_code%TYPE;
609: argument_method_code_i
610: fnd_concurrent_programs.argument_method_code%TYPE;
611: srs_flag_i VARCHAR2(1);
612: application_id_i fnd_application.application_id%TYPE;

Line 619: executable_id_i fnd_executables.executable_id%TYPE;

615: type_application_id_i fnd_application.application_id%TYPE;
616: concurrent_class_id_i
617: fnd_concurrent_request_class.request_class_id%TYPE;
618: executable_application_id_i fnd_application.application_id%TYPE;
619: executable_id_i fnd_executables.executable_id%TYPE;
620: output_print_style_i fnd_printer_styles.printer_style_name%TYPE;
621: swidth fnd_printer_styles.width%TYPE;
622: slength fnd_printer_styles.length%TYPE;
623: appl_short_name fnd_application.application_short_name%TYPE;

Line 625: mls_function_exe_id_i fnd_executables.executable_id%TYPE;

621: swidth fnd_printer_styles.width%TYPE;
622: slength fnd_printer_styles.length%TYPE;
623: appl_short_name fnd_application.application_short_name%TYPE;
624: mls_function_application_id_i fnd_application.application_id%TYPE;
625: mls_function_exe_id_i fnd_executables.executable_id%TYPE;
626:
627: srs1_i VARCHAR2(1);
628: srs2_i VARCHAR2(1);
629: dummy VARCHAR2(1);

Line 678: FROM fnd_executables

674: /* figure out the executable info */
675: BEGIN
676: SELECT executable_id, execution_method_code
677: INTO executable_id_i, execution_method_code_i
678: FROM fnd_executables
679: WHERE application_id = executable_application_id_i
680: AND fnd_executables.executable_name = executable_short_name;
681: EXCEPTION
682: WHEN no_data_found THEN

Line 680: AND fnd_executables.executable_name = executable_short_name;

676: SELECT executable_id, execution_method_code
677: INTO executable_id_i, execution_method_code_i
678: FROM fnd_executables
679: WHERE application_id = executable_application_id_i
680: AND fnd_executables.executable_name = executable_short_name;
681: EXCEPTION
682: WHEN no_data_found THEN
683: message('Invalid executable short name: '||executable_short_name);
684: message('Application: '||executable_application);

Line 827: FROM fnd_executables

823: /* figure out the executable info */
824: BEGIN
825: SELECT executable_id
826: INTO mls_function_exe_id_i
827: FROM fnd_executables
828: WHERE application_id = mls_function_application_id_i
829: AND fnd_executables.executable_name = mls_function_short_name;
830: EXCEPTION
831: WHEN no_data_found THEN

Line 829: AND fnd_executables.executable_name = mls_function_short_name;

825: SELECT executable_id
826: INTO mls_function_exe_id_i
827: FROM fnd_executables
828: WHERE application_id = mls_function_application_id_i
829: AND fnd_executables.executable_name = mls_function_short_name;
830: EXCEPTION
831: WHEN no_data_found THEN
832: message('Invalid mls function short name: '||mls_function_short_name);
833: message('Application: '||mls_function_application);

Line 1150: last_update_date fnd_executables.last_update_date%TYPE;

1146: execution_file_path IN VARCHAR2 DEFAULT NULL) is
1147: application_id number;
1148: execution_method_code varchar2(1);
1149: executable_id number;
1150: last_update_date fnd_executables.last_update_date%TYPE;
1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;

Line 1151: last_updated_by fnd_executables.last_updated_by%TYPE;

1147: application_id number;
1148: execution_method_code varchar2(1);
1149: executable_id number;
1150: last_update_date fnd_executables.last_update_date%TYPE;
1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;
1155: row_id fnd_executables_vl.row_id%type;

Line 1152: creation_date fnd_executables.creation_date%TYPE;

1148: execution_method_code varchar2(1);
1149: executable_id number;
1150: last_update_date fnd_executables.last_update_date%TYPE;
1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;
1155: row_id fnd_executables_vl.row_id%type;
1156:

Line 1153: created_by fnd_executables.created_by%TYPE;

1149: executable_id number;
1150: last_update_date fnd_executables.last_update_date%TYPE;
1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;
1155: row_id fnd_executables_vl.row_id%type;
1156:
1157: BEGIN

Line 1154: last_update_login fnd_executables.last_update_login%TYPE;

1150: last_update_date fnd_executables.last_update_date%TYPE;
1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;
1155: row_id fnd_executables_vl.row_id%type;
1156:
1157: BEGIN
1158: message_init;

Line 1155: row_id fnd_executables_vl.row_id%type;

1151: last_updated_by fnd_executables.last_updated_by%TYPE;
1152: creation_date fnd_executables.creation_date%TYPE;
1153: created_by fnd_executables.created_by%TYPE;
1154: last_update_login fnd_executables.last_update_login%TYPE;
1155: row_id fnd_executables_vl.row_id%type;
1156:
1157: BEGIN
1158: message_init;
1159:

Line 1221: select fnd_executables_s.nextval into executable_id from sys.dual;

1217: RAISE bad_parameter;
1218: end if;
1219:
1220:
1221: select fnd_executables_s.nextval into executable_id from sys.dual;
1222:
1223: insert into FND_EXECUTABLES (
1224: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
1225: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,

Line 1223: insert into FND_EXECUTABLES (

1219:
1220:
1221: select fnd_executables_s.nextval into executable_id from sys.dual;
1222:
1223: insert into FND_EXECUTABLES (
1224: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
1225: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,
1226: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
1227: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, icon_name, execution_file_path

Line 1235: insert into FND_EXECUTABLES_TL (

1231: creation_date, created_by, last_update_date,
1232: last_updated_by, last_update_login, icon_name, execution_file_path
1233: );
1234:
1235: insert into FND_EXECUTABLES_TL (
1236: APPLICATION_ID, EXECUTABLE_ID, CREATION_DATE,
1237: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
1238: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
1239: LANGUAGE, SOURCE_LANG

Line 1754: fnd_executables.executable_id%TYPE;

1750: application IN VARCHAR2) is
1751: exec_application_id
1752: fnd_application.application_id%TYPE;
1753: exec_id
1754: fnd_executables.executable_id%TYPE;
1755: dummy varchar2(1);
1756:
1757: BEGIN
1758: message_init;

Line 1768: FROM fnd_executables

1764:
1765: BEGIN
1766: SELECT executable_id
1767: INTO exec_id
1768: FROM fnd_executables
1769: WHERE application_id = exec_application_id
1770: AND executable_name = executable_short_name;
1771: EXCEPTION
1772: WHEN no_data_found THEN

Line 1792: delete from fnd_executables_tl

1788: message('Error - Executable is assigned to a concurrent program.');
1789: RAISE bad_parameter;
1790: END;
1791:
1792: delete from fnd_executables_tl
1793: where executable_id = exec_id
1794: and application_id = exec_application_id;
1795:
1796: delete from fnd_executables

Line 1796: delete from fnd_executables

1792: delete from fnd_executables_tl
1793: where executable_id = exec_id
1794: and application_id = exec_application_id;
1795:
1796: delete from fnd_executables
1797: where executable_id = exec_id
1798: and application_id = exec_application_id;
1799:
1800: END delete_executable;

Line 2169: from fnd_executables

2165: exec_application_id := application_id_f(application);
2166:
2167: select 'y'
2168: into dummy
2169: from fnd_executables
2170: where application_id = exec_application_id
2171: and executable_name = executable_short_name;
2172:
2173: return TRUE;

Line 2452: from fnd_concurrent_programs FCP, fnd_executables FE

2448: program_application_id := application_id_f(program_application);
2449:
2450: select NTRUE
2451: into retval
2452: from fnd_concurrent_programs FCP, fnd_executables FE
2453: where FCP.concurrent_program_name = program_short_name
2454: and FCP.application_id = program_application_id
2455: and FCP.mls_executable_app_id is not null
2456: and FCP.mls_executable_id is not null