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_QUEUE_CONTENT

Line 300: -- Get a Type (Object) ID from FND_CONCURRENT_QUEUE_CONTENT

296: -- Function
297: -- GET_SPECIALIZATION_TYPE_ID
298: --
299: -- Purpose
300: -- Get a Type (Object) ID from FND_CONCURRENT_QUEUE_CONTENT
301: -- (fcqc.TYPE_ID) given the Object's Name, Application ID, and
302: -- Lookup Code
303: --
304: -- Arguments:

Line 1109: action_code fnd_concurrent_queue_content.include_flag%type;

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;
1113: mgr_type fnd_concurrent_queues.manager_type%TYPE;

Line 1110: type_code fnd_concurrent_queue_content.type_code%type;

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;
1113: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1114:

Line 1111: type_id fnd_concurrent_queue_content.type_id%type;

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;
1113: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1114:
1115: last_update_login fnd_concurrent_queue_content.last_update_login%TYPE

Line 1115: last_update_login fnd_concurrent_queue_content.last_update_login%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
1118: := last_update_date_f(last_update_date);
1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE

Line 1117: l_update_date fnd_concurrent_queue_content.last_update_date%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
1118: := last_update_date_f(last_update_date);
1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE
1120: := last_updated_by_f(last_updated_by);
1121: creation_date fnd_concurrent_queue_content.creation_date%TYPE

Line 1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE

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
1118: := last_update_date_f(last_update_date);
1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE
1120: := last_updated_by_f(last_updated_by);
1121: creation_date fnd_concurrent_queue_content.creation_date%TYPE
1122: := creation_date_f(last_update_date);
1123: created_by fnd_concurrent_queue_content.created_by%TYPE

Line 1121: creation_date fnd_concurrent_queue_content.creation_date%TYPE

1117: l_update_date fnd_concurrent_queue_content.last_update_date%TYPE
1118: := last_update_date_f(last_update_date);
1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE
1120: := last_updated_by_f(last_updated_by);
1121: creation_date fnd_concurrent_queue_content.creation_date%TYPE
1122: := creation_date_f(last_update_date);
1123: created_by fnd_concurrent_queue_content.created_by%TYPE
1124: := created_by_f(last_updated_by);
1125:

Line 1123: created_by fnd_concurrent_queue_content.created_by%TYPE

1119: l_updated_by fnd_concurrent_queue_content.last_updated_by%TYPE
1120: := last_updated_by_f(last_updated_by);
1121: creation_date fnd_concurrent_queue_content.creation_date%TYPE
1122: := creation_date_f(last_update_date);
1123: created_by fnd_concurrent_queue_content.created_by%TYPE
1124: := created_by_f(last_updated_by);
1125:
1126: begin
1127: message_init;

Line 1207: insert into fnd_concurrent_queue_content

1203: type_id := get_specialization_type_id(object_name,
1204: type_appl_id,
1205: type_code);
1206:
1207: insert into fnd_concurrent_queue_content
1208: (queue_application_id, concurrent_queue_id, type_code,
1209: type_application_id, type_id, last_update_date,
1210: last_updated_by, creation_date, created_by,
1211: last_update_login, include_flag)

Line 1441: action_code fnd_concurrent_queue_content.include_flag%type;

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

Line 1442: obj_code fnd_concurrent_queue_content.type_code%type;

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;
1445: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1446: dummy varchar2(4);

Line 1443: obj_id fnd_concurrent_queue_content.type_id%type;

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;
1445: mgr_type fnd_concurrent_queues.manager_type%TYPE;
1446: dummy varchar2(4);
1447: begin

Line 1506: from fnd_concurrent_queue_content

1502: obj_code);
1503:
1504: select 'Y'
1505: into dummy
1506: from fnd_concurrent_queue_content
1507: where concurrent_queue_id = mgr_id
1508: and queue_application_id = mgr_appl_id
1509: and type_code = obj_code
1510: and ((obj_id is null and type_id is null)

Line 1572: delete from fnd_concurrent_queue_content

1568: /* and fnd_concurrent_processes. */
1569: /* ------------------------------------------------------------ */
1570:
1571: /* Specialization Rules */
1572: delete from fnd_concurrent_queue_content
1573: where concurrent_queue_id = mgr_id
1574: and queue_application_id = mgr_appl_id;
1575:
1576: /* Work Shifts */

Line 1716: update fnd_concurrent_queue_content

1712: where queue_application_id = mgr_appl_id
1713: and concurrent_queue_id = mgr_id;
1714:
1715: /* Process data */
1716: update fnd_concurrent_queue_content
1717: set concurrent_queue_id = manager_id
1718: where queue_application_id = mgr_appl_id
1719: and concurrent_queue_id = mgr_id;
1720: