DBA Data[Home] [Help]

APPS.FND_PROGRAM dependencies on FND_EXECUTABLES

Line 605: fnd_executables.execution_method_code%TYPE;

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

Line 616: executable_id_i fnd_executables.executable_id%TYPE;

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

Line 622: mls_function_exe_id_i fnd_executables.executable_id%TYPE;

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

Line 675: FROM fnd_executables

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

Line 677: AND fnd_executables.executable_name = executable_short_name;

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

Line 824: FROM fnd_executables

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

Line 826: AND fnd_executables.executable_name = mls_function_short_name;

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

Line 1147: last_update_date fnd_executables.last_update_date%TYPE;

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

Line 1148: last_updated_by fnd_executables.last_updated_by%TYPE;

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

Line 1149: creation_date fnd_executables.creation_date%TYPE;

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

Line 1150: created_by fnd_executables.created_by%TYPE;

1146: executable_id number;
1147: last_update_date fnd_executables.last_update_date%TYPE;
1148: last_updated_by fnd_executables.last_updated_by%TYPE;
1149: creation_date fnd_executables.creation_date%TYPE;
1150: created_by fnd_executables.created_by%TYPE;
1151: last_update_login fnd_executables.last_update_login%TYPE;
1152: row_id fnd_executables_vl.row_id%type;
1153:
1154: BEGIN

Line 1151: last_update_login fnd_executables.last_update_login%TYPE;

1147: last_update_date fnd_executables.last_update_date%TYPE;
1148: last_updated_by fnd_executables.last_updated_by%TYPE;
1149: creation_date fnd_executables.creation_date%TYPE;
1150: created_by fnd_executables.created_by%TYPE;
1151: last_update_login fnd_executables.last_update_login%TYPE;
1152: row_id fnd_executables_vl.row_id%type;
1153:
1154: BEGIN
1155: message_init;

Line 1152: row_id fnd_executables_vl.row_id%type;

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

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

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

Line 1220: insert into FND_EXECUTABLES (

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

Line 1232: insert into FND_EXECUTABLES_TL (

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

Line 1751: fnd_executables.executable_id%TYPE;

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

Line 1765: FROM fnd_executables

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

Line 1789: delete from fnd_executables_tl

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

Line 1793: delete from fnd_executables

1789: delete from fnd_executables_tl
1790: where executable_id = exec_id
1791: and application_id = exec_application_id;
1792:
1793: delete from fnd_executables
1794: where executable_id = exec_id
1795: and application_id = exec_application_id;
1796:
1797: END delete_executable;

Line 2166: from fnd_executables

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