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_MANAGER dependencies on FND_APPLICATION

Line 127: RETURN fnd_application.application_id%TYPE

123: --
124: -- get the application id, given the name (or short name)
125: --
126: FUNCTION application_id_f(application_name_in IN VARCHAR2)
127: RETURN fnd_application.application_id%TYPE
128: IS
129: application_id_ret fnd_application.application_id%TYPE;
130: BEGIN
131: IF(application_name_in IS NULL) THEN

Line 129: application_id_ret fnd_application.application_id%TYPE;

125: --
126: FUNCTION application_id_f(application_name_in IN VARCHAR2)
127: RETURN fnd_application.application_id%TYPE
128: IS
129: application_id_ret fnd_application.application_id%TYPE;
130: BEGIN
131: IF(application_name_in IS NULL) THEN
132: message('A null application_name was specified.');
133: RAISE bad_parameter;

Line 138: FROM fnd_application

134: END IF;
135: /* Check the short name first. */
136: SELECT application_id
137: INTO application_id_ret
138: FROM fnd_application
139: WHERE upper(application_short_name) = upper(application_name_in);
140: RETURN application_id_ret;
141: EXCEPTION
142: WHEN no_data_found THEN /* Try the translated name. */

Line 146: FROM fnd_application_tl

142: WHEN no_data_found THEN /* Try the translated name. */
143: BEGIN
144: SELECT application_id
145: INTO application_id_ret
146: FROM fnd_application_tl
147: WHERE upper(application_name) = upper(application_name_in)
148: AND rownum = 1;
149: RETURN application_id_ret;
150: EXCEPTION

Line 422: mgr_appl_id fnd_application.application_id%TYPE;

418: last_update_date IN DATE DEFAULT NULL,
419: last_updated_by IN NUMBER DEFAULT NULL
420: ) is
421:
422: mgr_appl_id fnd_application.application_id%TYPE;
423: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
424: type_code fnd_concurrent_queues.manager_type%TYPE;
425: dg_id fnd_data_groups.data_group_id%TYPE;
426: lib_appl_id fnd_application.application_id%TYPE;

Line 426: lib_appl_id fnd_application.application_id%TYPE;

422: mgr_appl_id fnd_application.application_id%TYPE;
423: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
424: type_code fnd_concurrent_queues.manager_type%TYPE;
425: dg_id fnd_data_groups.data_group_id%TYPE;
426: lib_appl_id fnd_application.application_id%TYPE;
427: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
428:
429: last_update_login fnd_concurrent_queues.last_update_login%TYPE
430: := last_update_login_f;

Line 710: from FND_APPLICATION

706: if (CARTRIDGE_APPLICATION is not NULL) then
707: begin
708: select APPLICATION_ID
709: into cart_appl_id
710: from FND_APPLICATION
711: where APPLICATION_SHORT_NAME = CARTRIDGE_APPLICATION;
712: exception
713: when others then
714: cart_appl_id := 0;

Line 844: mgr_appl_id fnd_application.application_id%TYPE;

840: svc_params in VARCHAR2 DEFAULT NULL,
841: last_update_date IN DATE DEFAULT NULL,
842: last_updated_by IN VARCHAR2 DEFAULT NULL) is
843:
844: mgr_appl_id fnd_application.application_id%TYPE;
845: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
846: ws_id fnd_concurrent_time_periods.concurrent_time_period_id%TYPE;
847: dg_id fnd_data_groups.data_group_id%TYPE;
848: lib_appl_id fnd_application.application_id%TYPE;

Line 848: lib_appl_id fnd_application.application_id%TYPE;

844: mgr_appl_id fnd_application.application_id%TYPE;
845: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
846: ws_id fnd_concurrent_time_periods.concurrent_time_period_id%TYPE;
847: dg_id fnd_data_groups.data_group_id%TYPE;
848: lib_appl_id fnd_application.application_id%TYPE;
849: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
850: mgr_type fnd_concurrent_queues.manager_type%TYPE;
851:
852: last_update_login fnd_concurrent_queue_size.last_update_login%TYPE

Line 967: lib_appl_id fnd_application.application_id%TYPE;

963: application IN VARCHAR2,
964: description IN VARCHAR2 DEFAULT NULL,
965: type IN VARCHAR2) is
966:
967: lib_appl_id fnd_application.application_id%TYPE;
968: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
969: type_code fnd_concurrent_processors.library_type%type;
970:
971: last_update_login fnd_concurrent_queues.last_update_login%TYPE

Line 1039: lib_appl_id fnd_application.application_id%TYPE;

1035: library_application IN VARCHAR2,
1036: program IN VARCHAR2,
1037: program_application IN VARCHAR2)
1038: is
1039: lib_appl_id fnd_application.application_id%TYPE;
1040: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1041: prg_appl_id fnd_application.application_id%TYPE;
1042: prg_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1043:

Line 1041: prg_appl_id fnd_application.application_id%TYPE;

1037: program_application IN VARCHAR2)
1038: is
1039: lib_appl_id fnd_application.application_id%TYPE;
1040: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1041: prg_appl_id fnd_application.application_id%TYPE;
1042: prg_id fnd_concurrent_programs.concurrent_program_id%TYPE;
1043:
1044: last_update_login fnd_concurrent_queues.last_update_login%TYPE
1045: := last_update_login_f;

Line 1107: mgr_appl_id fnd_application.application_id%TYPE;

1103: object_name in VARCHAR2 DEFAULT NULL,
1104: object_application in VARCHAR2 DEFAULT NULL,
1105: last_update_date in DATE DEFAULT NULL,
1106: last_updated_by in NUMBER DEFAULT NULL) is
1107: mgr_appl_id fnd_application.application_id%TYPE;
1108: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1109: action_code fnd_concurrent_queue_content.include_flag%type;
1110: type_code fnd_concurrent_queue_content.type_code%type;
1111: type_id fnd_concurrent_queue_content.type_id%type;

Line 1112: type_appl_id fnd_application.application_id%TYPE;

1108: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1109: action_code fnd_concurrent_queue_content.include_flag%type;
1110: type_code fnd_concurrent_queue_content.type_code%type;
1111: type_id fnd_concurrent_queue_content.type_id%type;
1112: type_appl_id fnd_application.application_id%TYPE;
1113: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1114:
1115: last_update_login fnd_concurrent_queue_content.last_update_login%TYPE
1116: := last_update_login_f;

Line 1232: mgr_appl_id fnd_application.application_id%TYPE;

1228: --
1229: FUNCTION manager_exists(manager_short_name IN VARCHAR2,
1230: application IN VARCHAR2)
1231: RETURN BOOLEAN is
1232: mgr_appl_id fnd_application.application_id%TYPE;
1233: dummy varchar2(4);
1234: begin
1235: message_init;
1236:

Line 1295: mgr_appl_id fnd_application.application_id%TYPE;

1291: manager_application IN VARCHAR2,
1292: work_shift IN VARCHAR2 DEFAULT NULL,
1293: work_shift_id IN NUMBER DEFAULT NULL)
1294: RETURN BOOLEAN is
1295: mgr_appl_id fnd_application.application_id%TYPE;
1296: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;
1297: dummy varchar2(4);
1298: begin
1299: message_init;

Line 1346: lib_appl_id fnd_application.application_id%TYPE;

1342: --
1343: FUNCTION library_exists(library IN VARCHAR2,
1344: application IN VARCHAR2)
1345: RETURN BOOLEAN is
1346: lib_appl_id fnd_application.application_id%TYPE;
1347: dummy varchar2(4);
1348: begin
1349: message_init;
1350:

Line 1384: lib_appl_id fnd_application.application_id%TYPE;

1380: library_application IN VARCHAR2,
1381: program IN VARCHAR2,
1382: program_application IN VARCHAR2)
1383: RETURN BOOLEAN is
1384: lib_appl_id fnd_application.application_id%TYPE;
1385: prg_appl_id fnd_application.application_id%TYPE;
1386: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1387: dummy varchar2(4);
1388: begin

Line 1385: prg_appl_id fnd_application.application_id%TYPE;

1381: program IN VARCHAR2,
1382: program_application IN VARCHAR2)
1383: RETURN BOOLEAN is
1384: lib_appl_id fnd_application.application_id%TYPE;
1385: prg_appl_id fnd_application.application_id%TYPE;
1386: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1387: dummy varchar2(4);
1388: begin
1389: message_init;

Line 1439: mgr_appl_id fnd_application.application_id%TYPE;

1435: object_name in VARCHAR2 DEFAULT NULL,
1436: object_application in VARCHAR2 DEFAULT NULL)
1437: return boolean is
1438:
1439: mgr_appl_id fnd_application.application_id%TYPE;
1440: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1441: action_code fnd_concurrent_queue_content.include_flag%type;
1442: obj_code fnd_concurrent_queue_content.type_code%type;
1443: obj_id fnd_concurrent_queue_content.type_id%type;

Line 1444: obj_appl_id fnd_application.application_id%TYPE;

1440: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1441: action_code fnd_concurrent_queue_content.include_flag%type;
1442: obj_code fnd_concurrent_queue_content.type_code%type;
1443: obj_id fnd_concurrent_queue_content.type_id%type;
1444: obj_appl_id fnd_application.application_id%TYPE;
1445: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1446: dummy varchar2(4);
1447: begin
1448: message_init;

Line 1540: mgr_appl_id fnd_application.application_id%TYPE;

1536: --
1537: PROCEDURE delete_manager (manager_short_name IN VARCHAR2,
1538: application IN VARCHAR2) is
1539:
1540: mgr_appl_id fnd_application.application_id%TYPE;
1541: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1542:
1543: targetp number := 0;
1544: activep number := 0;

Line 1607: lib_appl_id fnd_application.application_id%TYPE;

1603: --
1604: PROCEDURE delete_library(library IN VARCHAR2,
1605: application IN VARCHAR2) is
1606:
1607: lib_appl_id fnd_application.application_id%TYPE;
1608: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
1609:
1610: i number;
1611: begin

Line 1665: mgr_appl_id fnd_application.application_id%TYPE;

1661: PROCEDURE standardize (manager_short_name IN VARCHAR2,
1662: application IN VARCHAR2,
1663: manager_id IN number) is
1664:
1665: mgr_appl_id fnd_application.application_id%TYPE;
1666: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1667:
1668: dummy number;
1669:

Line 1755: mgr_appl_id fnd_application.application_id%TYPE;

1751: application IN VARCHAR2,
1752: primary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char,
1753: secondary_node IN VARCHAR2 DEFAULT fnd_api.g_miss_char) IS
1754:
1755: mgr_appl_id fnd_application.application_id%TYPE;
1756: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
1757: pnode varchar2(31);
1758: snode varchar2(31);
1759: