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

Line 256: fn_id fnd_executables.executable_id%TYPE;

252:
253: /* Get a request set stage function ID given appl ID, function_name */
254: FUNCTION function_id_f(fn_appl_id number,
255: name varchar2) return number is
256: fn_id fnd_executables.executable_id%TYPE;
257: BEGIN
258: SELECT executable_id
259: INTO fn_id
260: FROM fnd_executables

Line 260: FROM fnd_executables

256: fn_id fnd_executables.executable_id%TYPE;
257: BEGIN
258: SELECT executable_id
259: INTO fn_id
260: FROM fnd_executables
261: WHERE application_id = fn_appl_id
262: AND executable_name = name;
263:
264: RETURN fn_id;

Line 923: from fnd_executables

919: function_appl_id := application_id_f(function_application);
920: begin
921: select executable_id
922: into function_id
923: from fnd_executables
924: where application_id = function_appl_id
925: and executable_name = function_short_name;
926: exception
927: when no_data_found then

Line 2380: last_update_date fnd_executables.last_update_date%TYPE;

2376: language_code IN VARCHAR2 DEFAULT 'US')
2377: is
2378: application_id number;
2379: executable_id number;
2380: last_update_date fnd_executables.last_update_date%TYPE;
2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;

Line 2381: last_updated_by fnd_executables.last_updated_by%TYPE;

2377: is
2378: application_id number;
2379: executable_id number;
2380: last_update_date fnd_executables.last_update_date%TYPE;
2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;
2385: row_id fnd_executables_vl.row_id%type;

Line 2382: creation_date fnd_executables.creation_date%TYPE;

2378: application_id number;
2379: executable_id number;
2380: last_update_date fnd_executables.last_update_date%TYPE;
2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;
2385: row_id fnd_executables_vl.row_id%type;
2386:

Line 2383: created_by fnd_executables.created_by%TYPE;

2379: executable_id number;
2380: last_update_date fnd_executables.last_update_date%TYPE;
2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;
2385: row_id fnd_executables_vl.row_id%type;
2386:
2387: begin

Line 2384: last_update_login fnd_executables.last_update_login%TYPE;

2380: last_update_date fnd_executables.last_update_date%TYPE;
2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;
2385: row_id fnd_executables_vl.row_id%type;
2386:
2387: begin
2388: message_init;

Line 2385: row_id fnd_executables_vl.row_id%type;

2381: last_updated_by fnd_executables.last_updated_by%TYPE;
2382: creation_date fnd_executables.creation_date%TYPE;
2383: created_by fnd_executables.created_by%TYPE;
2384: last_update_login fnd_executables.last_update_login%TYPE;
2385: row_id fnd_executables_vl.row_id%type;
2386:
2387: begin
2388: message_init;
2389:

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

2398: created_by := created_by_f;
2399: last_update_login := last_update_login_f;
2400: application_id := application_id_f(application);
2401:
2402: select fnd_executables_s.nextval into executable_id from sys.dual;
2403:
2404: insert into FND_EXECUTABLES (
2405: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
2406: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,

Line 2404: insert into FND_EXECUTABLES (

2400: application_id := application_id_f(application);
2401:
2402: select fnd_executables_s.nextval into executable_id from sys.dual;
2403:
2404: insert into FND_EXECUTABLES (
2405: APPLICATION_ID, EXECUTABLE_ID, EXECUTABLE_NAME,
2406: EXECUTION_METHOD_CODE, EXECUTION_FILE_NAME, SUBROUTINE_NAME,
2407: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE,
2408: LAST_UPDATED_BY, LAST_UPDATE_LOGIN, icon_name

Line 2416: insert into FND_EXECUTABLES_TL (

2412: creation_date, created_by, last_update_date,
2413: last_updated_by, last_update_login, icon_name
2414: );
2415:
2416: insert into FND_EXECUTABLES_TL (
2417: APPLICATION_ID, EXECUTABLE_ID, CREATION_DATE,
2418: CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY,
2419: LAST_UPDATE_LOGIN, USER_EXECUTABLE_NAME, DESCRIPTION,
2420: LANGUAGE, SOURCE_LANG

Line 2460: from fnd_executables

2456: exec_application_id := application_id_f(application);
2457:
2458: select 'y'
2459: into dummy
2460: from fnd_executables
2461: where application_id = exec_application_id
2462: and executable_name = function_short_name;
2463:
2464: return TRUE;

Line 2487: fnd_executables.executable_id%TYPE;

2483: application IN VARCHAR2) is
2484: exec_application_id
2485: fnd_application.application_id%TYPE;
2486: exec_id
2487: fnd_executables.executable_id%TYPE;
2488: dummy varchar2(1);
2489:
2490: begin
2491: message_init;

Line 2501: FROM fnd_executables

2497:
2498: BEGIN
2499: SELECT executable_id
2500: INTO exec_id
2501: FROM fnd_executables
2502: WHERE application_id = exec_application_id
2503: AND executable_name = function_short_name;
2504: EXCEPTION
2505: WHEN no_data_found THEN

Line 2530: delete from fnd_executables_tl

2526: delete from fnd_stage_fn_parameters_tl
2527: where function_id = exec_id
2528: and application_id = exec_application_id;
2529:
2530: delete from fnd_executables_tl
2531: where executable_id = exec_id
2532: and application_id = exec_application_id;
2533:
2534: delete from fnd_executables

Line 2534: delete from fnd_executables

2530: delete from fnd_executables_tl
2531: where executable_id = exec_id
2532: and application_id = exec_application_id;
2533:
2534: delete from fnd_executables
2535: where executable_id = exec_id
2536: and application_id = exec_application_id;
2537:
2538: delete from fnd_request_group_units

Line 2739: last_update_date fnd_executables.last_update_date%TYPE;

2735: parameter_short_name IN VARCHAR2,
2736: description IN VARCHAR2 DEFAULT NULL,
2737: language_code IN VARCHAR2 DEFAULT 'US')
2738: is
2739: last_update_date fnd_executables.last_update_date%TYPE;
2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;

Line 2740: last_updated_by fnd_executables.last_updated_by%TYPE;

2736: description IN VARCHAR2 DEFAULT NULL,
2737: language_code IN VARCHAR2 DEFAULT 'US')
2738: is
2739: last_update_date fnd_executables.last_update_date%TYPE;
2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;

Line 2741: creation_date fnd_executables.creation_date%TYPE;

2737: language_code IN VARCHAR2 DEFAULT 'US')
2738: is
2739: last_update_date fnd_executables.last_update_date%TYPE;
2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;
2745: fn_appl_id fnd_application.application_id%TYPE;

Line 2742: created_by fnd_executables.created_by%TYPE;

2738: is
2739: last_update_date fnd_executables.last_update_date%TYPE;
2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;
2745: fn_appl_id fnd_application.application_id%TYPE;
2746: fn_id number;

Line 2743: last_update_login fnd_executables.last_update_login%TYPE;

2739: last_update_date fnd_executables.last_update_date%TYPE;
2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;
2745: fn_appl_id fnd_application.application_id%TYPE;
2746: fn_id number;
2747: param_id number;

Line 2744: row_id fnd_executables_vl.row_id%type;

2740: last_updated_by fnd_executables.last_updated_by%TYPE;
2741: creation_date fnd_executables.creation_date%TYPE;
2742: created_by fnd_executables.created_by%TYPE;
2743: last_update_login fnd_executables.last_update_login%TYPE;
2744: row_id fnd_executables_vl.row_id%type;
2745: fn_appl_id fnd_application.application_id%TYPE;
2746: fn_id number;
2747: param_id number;
2748: begin

Line 2900: last_update_date fnd_executables.last_update_date%TYPE;

2896: set_application IN VARCHAR2,
2897: stage IN VARCHAR2,
2898: parameter IN VARCHAR2,
2899: value IN VARCHAR2) is
2900: last_update_date fnd_executables.last_update_date%TYPE;
2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;

Line 2901: last_updated_by fnd_executables.last_updated_by%TYPE;

2897: stage IN VARCHAR2,
2898: parameter IN VARCHAR2,
2899: value IN VARCHAR2) is
2900: last_update_date fnd_executables.last_update_date%TYPE;
2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;
2905: row_id fnd_executables_vl.row_id%type;

Line 2902: creation_date fnd_executables.creation_date%TYPE;

2898: parameter IN VARCHAR2,
2899: value IN VARCHAR2) is
2900: last_update_date fnd_executables.last_update_date%TYPE;
2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;
2905: row_id fnd_executables_vl.row_id%type;
2906: stage_id number;

Line 2903: created_by fnd_executables.created_by%TYPE;

2899: value IN VARCHAR2) is
2900: last_update_date fnd_executables.last_update_date%TYPE;
2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;
2905: row_id fnd_executables_vl.row_id%type;
2906: stage_id number;
2907: param_id number;

Line 2904: last_update_login fnd_executables.last_update_login%TYPE;

2900: last_update_date fnd_executables.last_update_date%TYPE;
2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;
2905: row_id fnd_executables_vl.row_id%type;
2906: stage_id number;
2907: param_id number;
2908: set_id number;

Line 2905: row_id fnd_executables_vl.row_id%type;

2901: last_updated_by fnd_executables.last_updated_by%TYPE;
2902: creation_date fnd_executables.creation_date%TYPE;
2903: created_by fnd_executables.created_by%TYPE;
2904: last_update_login fnd_executables.last_update_login%TYPE;
2905: row_id fnd_executables_vl.row_id%type;
2906: stage_id number;
2907: param_id number;
2908: set_id number;
2909: set_appl_id number;