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_CONCURRENT_QUEUES

Line 205: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

201: -- Get a manager ID given appl ID and name
202: --
203: FUNCTION manager_id_f(mgr_appl_id number,
204: mgr_name varchar2) return number is
205: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
206: begin
207: select concurrent_queue_id
208: into mgr_id
209: from fnd_concurrent_queues

Line 209: from fnd_concurrent_queues

205: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;
206: begin
207: select concurrent_queue_id
208: into mgr_id
209: from fnd_concurrent_queues
210: where application_id = mgr_appl_id
211: and upper(mgr_name) = upper(concurrent_queue_name);
212:
213: return mgr_id;

Line 423: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;

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;
427: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

Line 424: type_code fnd_concurrent_queues.manager_type%TYPE;

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;
427: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;
428:

Line 429: last_update_login fnd_concurrent_queues.last_update_login%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;
431: l_update_date fnd_concurrent_queues.last_update_date%TYPE
432: := last_update_date_f(last_update_date);
433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE

Line 431: l_update_date fnd_concurrent_queues.last_update_date%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;
431: l_update_date fnd_concurrent_queues.last_update_date%TYPE
432: := last_update_date_f(last_update_date);
433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE
434: := last_updated_by_f(last_updated_by);
435: creation_date fnd_concurrent_queues.creation_date%TYPE

Line 433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE

429: last_update_login fnd_concurrent_queues.last_update_login%TYPE
430: := last_update_login_f;
431: l_update_date fnd_concurrent_queues.last_update_date%TYPE
432: := last_update_date_f(last_update_date);
433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE
434: := last_updated_by_f(last_updated_by);
435: creation_date fnd_concurrent_queues.creation_date%TYPE
436: := creation_date_f(last_update_date);
437: created_by fnd_concurrent_queues.created_by%TYPE

Line 435: creation_date fnd_concurrent_queues.creation_date%TYPE

431: l_update_date fnd_concurrent_queues.last_update_date%TYPE
432: := last_update_date_f(last_update_date);
433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE
434: := last_updated_by_f(last_updated_by);
435: creation_date fnd_concurrent_queues.creation_date%TYPE
436: := creation_date_f(last_update_date);
437: created_by fnd_concurrent_queues.created_by%TYPE
438: := created_by_f(last_updated_by);
439:

Line 437: created_by fnd_concurrent_queues.created_by%TYPE

433: l_updated_by fnd_concurrent_queues.last_updated_by%TYPE
434: := last_updated_by_f(last_updated_by);
435: creation_date fnd_concurrent_queues.creation_date%TYPE
436: := creation_date_f(last_update_date);
437: created_by fnd_concurrent_queues.created_by%TYPE
438: := created_by_f(last_updated_by);
439:
440: begin
441: message_init;

Line 451: select fnd_concurrent_queues_s.nextval

447: check_notnull(library);
448: check_notnull(library_application);
449:
450: /* Get new ID */
451: select fnd_concurrent_queues_s.nextval
452: into mgr_id
453: from sys.dual;
454:
455: mgr_appl_id := application_id_f(application);

Line 533: delete from fnd_concurrent_queues_tl

529: /* Get Library */
530: lib_id := library_id_f(lib_appl_id, library);
531:
532: /* Make sure no bad data in tl table */
533: delete from fnd_concurrent_queues_tl
534: where application_id = mgr_appl_id
535: and language in (select l.language_code
536: from fnd_languages l
537: where l.installed_flag in ('I', 'B'))

Line 542: insert into fnd_concurrent_queues

538: and (concurrent_queue_name = short_name
539: or user_concurrent_queue_name = manager);
540:
541: /* Do the insert */
542: insert into fnd_concurrent_queues
543: (application_id, concurrent_queue_id, concurrent_queue_name,
544: processor_application_id, concurrent_processor_id,
545: running_processes, max_processes, creation_date, created_by,
546: last_update_date, last_updated_by, last_update_login,

Line 559: insert into FND_CONCURRENT_QUEUES_TL (

555: cache_size, 'E', type_code,
556: primary_node, secondary_node, primary_queue, secondary_queue,
557: dg_id, 'Y');
558:
559: insert into FND_CONCURRENT_QUEUES_TL (
560: user_concurrent_queue_name, application_id, concurrent_queue_id,
561: concurrent_queue_name, creation_date, created_by,
562: last_update_date, last_updated_by, last_update_login,
563: description, language, source_lang

Line 573: from FND_CONCURRENT_QUEUES_TL T

569: from FND_LANGUAGES L
570: where L.INSTALLED_FLAG in ('I', 'B')
571: and not exists
572: (select NULL
573: from FND_CONCURRENT_QUEUES_TL T
574: where T.APPLICATION_ID = mgr_appl_id
575: and T.CONCURRENT_QUEUE_ID = mgr_id
576: and T.LANGUAGE = L.LANGUAGE_CODE);
577:

Line 810: update fnd_concurrent_queues

806: mgr_appl_id := application_id_f(application);
807: si_id := manager_id_f(mgr_appl_id, short_name);
808: svc_id := service_id_f(service_handle);
809:
810: update fnd_concurrent_queues
811: set manager_type = svc_id
812: where APPLICATION_ID = mgr_appl_id
813: and CONCURRENT_QUEUE_ID = si_id;
814:

Line 845: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;

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;
849: lib_id fnd_concurrent_processors.concurrent_processor_id%TYPE;

Line 850: mgr_type fnd_concurrent_queues.manager_type%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
853: := last_update_login_f;
854: l_update_date fnd_concurrent_queue_size.last_update_date%TYPE

Line 887: from fnd_concurrent_queues

883:
884: /* Check type */
885: select manager_type
886: into mgr_type
887: from fnd_concurrent_queues
888: where application_id = mgr_appl_id
889: and concurrent_queue_id = mgr_id;
890:
891: if (mgr_type = 0) then

Line 971: last_update_login fnd_concurrent_queues.last_update_login%TYPE

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
972: := last_update_login_f;
973: last_update_date fnd_concurrent_queues.last_update_date%TYPE
974: := last_update_date_f;
975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE

Line 973: last_update_date fnd_concurrent_queues.last_update_date%TYPE

969: type_code fnd_concurrent_processors.library_type%type;
970:
971: last_update_login fnd_concurrent_queues.last_update_login%TYPE
972: := last_update_login_f;
973: last_update_date fnd_concurrent_queues.last_update_date%TYPE
974: := last_update_date_f;
975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
976: := last_updated_by_f;
977: creation_date fnd_concurrent_queues.creation_date%TYPE

Line 975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE

971: last_update_login fnd_concurrent_queues.last_update_login%TYPE
972: := last_update_login_f;
973: last_update_date fnd_concurrent_queues.last_update_date%TYPE
974: := last_update_date_f;
975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
976: := last_updated_by_f;
977: creation_date fnd_concurrent_queues.creation_date%TYPE
978: := creation_date_f;
979: created_by fnd_concurrent_queues.created_by%TYPE

Line 977: creation_date fnd_concurrent_queues.creation_date%TYPE

973: last_update_date fnd_concurrent_queues.last_update_date%TYPE
974: := last_update_date_f;
975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
976: := last_updated_by_f;
977: creation_date fnd_concurrent_queues.creation_date%TYPE
978: := creation_date_f;
979: created_by fnd_concurrent_queues.created_by%TYPE
980: := created_by_f;
981: begin

Line 979: created_by fnd_concurrent_queues.created_by%TYPE

975: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
976: := last_updated_by_f;
977: creation_date fnd_concurrent_queues.creation_date%TYPE
978: := creation_date_f;
979: created_by fnd_concurrent_queues.created_by%TYPE
980: := created_by_f;
981: begin
982: message_init;
983:

Line 1044: last_update_login fnd_concurrent_queues.last_update_login%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;
1046: last_update_date fnd_concurrent_queues.last_update_date%TYPE
1047: := last_update_date_f;
1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE

Line 1046: last_update_date fnd_concurrent_queues.last_update_date%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;
1046: last_update_date fnd_concurrent_queues.last_update_date%TYPE
1047: := last_update_date_f;
1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
1049: := last_updated_by_f;
1050: creation_date fnd_concurrent_queues.creation_date%TYPE

Line 1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE

1044: last_update_login fnd_concurrent_queues.last_update_login%TYPE
1045: := last_update_login_f;
1046: last_update_date fnd_concurrent_queues.last_update_date%TYPE
1047: := last_update_date_f;
1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
1049: := last_updated_by_f;
1050: creation_date fnd_concurrent_queues.creation_date%TYPE
1051: := creation_date_f;
1052: created_by fnd_concurrent_queues.created_by%TYPE

Line 1050: creation_date fnd_concurrent_queues.creation_date%TYPE

1046: last_update_date fnd_concurrent_queues.last_update_date%TYPE
1047: := last_update_date_f;
1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
1049: := last_updated_by_f;
1050: creation_date fnd_concurrent_queues.creation_date%TYPE
1051: := creation_date_f;
1052: created_by fnd_concurrent_queues.created_by%TYPE
1053: := created_by_f;
1054: begin

Line 1052: created_by fnd_concurrent_queues.created_by%TYPE

1048: last_updated_by fnd_concurrent_queues.last_updated_by%TYPE
1049: := last_updated_by_f;
1050: creation_date fnd_concurrent_queues.creation_date%TYPE
1051: := creation_date_f;
1052: created_by fnd_concurrent_queues.created_by%TYPE
1053: := created_by_f;
1054: begin
1055: message_init;
1056:

Line 1108: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

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;
1112: type_appl_id fnd_application.application_id%TYPE;

Line 1113: mgr_type fnd_concurrent_queues.manager_type%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;
1117: l_update_date fnd_concurrent_queue_content.last_update_date%TYPE

Line 1151: from fnd_concurrent_queues

1147:
1148: /* Check manager type */
1149: select manager_type
1150: into mgr_type
1151: from fnd_concurrent_queues
1152: where application_id = mgr_appl_id
1153: and concurrent_queue_id = mgr_id;
1154:
1155: if (mgr_type <> 1) then

Line 1241: from fnd_concurrent_queues

1237: mgr_appl_id := application_id_f(application);
1238:
1239: select 'Y'
1240: into dummy
1241: from fnd_concurrent_queues
1242: where application_id = mgr_appl_id
1243: and concurrent_queue_name = manager_short_name;
1244:
1245: return TRUE;

Line 1296: mgr_id fnd_concurrent_queues.concurrent_queue_id%TYPE;

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;
1300:

Line 1440: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

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;
1444: obj_appl_id fnd_application.application_id%TYPE;

Line 1445: mgr_type fnd_concurrent_queues.manager_type%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;
1449:

Line 1541: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

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;
1545: pmon varchar2(10);

Line 1582: delete from fnd_concurrent_queues_tl

1578: where queue_application_id = mgr_appl_id
1579: and concurrent_queue_id = mgr_id;
1580:
1581: /* TL tables */
1582: delete from fnd_concurrent_queues_tl
1583: where concurrent_queue_id = mgr_id
1584: and application_id = mgr_appl_id;
1585:
1586: /* Manager */

Line 1587: delete from fnd_concurrent_queues

1583: where concurrent_queue_id = mgr_id
1584: and application_id = mgr_appl_id;
1585:
1586: /* Manager */
1587: delete from fnd_concurrent_queues
1588: where concurrent_queue_id = mgr_id
1589: and application_id = mgr_appl_id;
1590:
1591: end delete_manager;

Line 1627: from fnd_concurrent_queues

1623:
1624: /* Check if in use */
1625: select count(*)
1626: into i
1627: from fnd_concurrent_queues
1628: where concurrent_processor_id = lib_id
1629: and processor_application_id = lib_appl_id;
1630:
1631: if ( i > 0 ) then

Line 1666: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

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:
1670: BEGIN

Line 1695: from fnd_concurrent_queues

1691: select 1 into dummy
1692: from sys.dual
1693: where not exists
1694: (select 1
1695: from fnd_concurrent_queues
1696: where concurrent_queue_id = manager_id);
1697: exception
1698: when no_data_found then
1699: message('ID '|| to_char(manager_id) || ' is already in use.');

Line 1722: update fnd_concurrent_queues_tl

1718: where queue_application_id = mgr_appl_id
1719: and concurrent_queue_id = mgr_id;
1720:
1721: /* TL tables */
1722: update fnd_concurrent_queues_tl
1723: set concurrent_queue_id = manager_id
1724: where application_id = mgr_appl_id
1725: and concurrent_queue_id = mgr_id;
1726:

Line 1728: update fnd_concurrent_queues

1724: where application_id = mgr_appl_id
1725: and concurrent_queue_id = mgr_id;
1726:
1727: /* manager */
1728: update fnd_concurrent_queues
1729: set concurrent_queue_id = manager_id
1730: where application_id = mgr_appl_id
1731: and concurrent_queue_id = mgr_id;
1732:

Line 1756: mgr_id fnd_concurrent_queues.concurrent_queue_id%type;

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:
1760: BEGIN

Line 1795: update fnd_concurrent_queues

1791: end if;
1792:
1793: /* Update */
1794: if (snode = fnd_api.g_miss_char) then /* No secondary */
1795: update fnd_concurrent_queues
1796: set node_name = pnode
1797: where concurrent_queue_id = mgr_id
1798: and application_id = mgr_appl_id;
1799:

Line 1801: update fnd_concurrent_queues

1797: where concurrent_queue_id = mgr_id
1798: and application_id = mgr_appl_id;
1799:
1800: elsif (pnode = fnd_api.g_miss_char) then /* No primary */
1801: update fnd_concurrent_queues
1802: set node_name2 = snode
1803: where concurrent_queue_id = mgr_id
1804: and application_id = mgr_appl_id;
1805:

Line 1807: update fnd_concurrent_queues

1803: where concurrent_queue_id = mgr_id
1804: and application_id = mgr_appl_id;
1805:
1806: else /* primary and secondary */
1807: update fnd_concurrent_queues
1808: set node_name = pnode,
1809: node_name2 = snode
1810: where concurrent_queue_id = mgr_id
1811: and application_id = mgr_appl_id;