APPS.FND_MANAGER dependencies on FND_CONCURRENT_QUEUE_SIZE

Line 852: last_update_login fnd_concurrent_queue_size.last_update_login%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
855: := last_update_date_f(last_update_date);
856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE

Line 854: l_update_date fnd_concurrent_queue_size.last_update_date%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
855: := last_update_date_f(last_update_date);
856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE
857: := last_updated_by_f(last_updated_by);
858: creation_date fnd_concurrent_queue_size.creation_date%TYPE

Line 856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE

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
855: := last_update_date_f(last_update_date);
856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE
857: := last_updated_by_f(last_updated_by);
858: creation_date fnd_concurrent_queue_size.creation_date%TYPE
859: := creation_date_f(last_update_date);
860: created_by fnd_concurrent_queue_size.created_by%TYPE

Line 858: creation_date fnd_concurrent_queue_size.creation_date%TYPE

854: l_update_date fnd_concurrent_queue_size.last_update_date%TYPE
855: := last_update_date_f(last_update_date);
856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE
857: := last_updated_by_f(last_updated_by);
858: creation_date fnd_concurrent_queue_size.creation_date%TYPE
859: := creation_date_f(last_update_date);
860: created_by fnd_concurrent_queue_size.created_by%TYPE
861: := created_by_f(last_updated_by);
862: begin

Line 860: created_by fnd_concurrent_queue_size.created_by%TYPE

856: l_updated_by fnd_concurrent_queue_size.last_updated_by%TYPE
857: := last_updated_by_f(last_updated_by);
858: creation_date fnd_concurrent_queue_size.creation_date%TYPE
859: := creation_date_f(last_update_date);
860: created_by fnd_concurrent_queue_size.created_by%TYPE
861: := created_by_f(last_updated_by);
862: begin
863: message_init;
864:

Line 934: insert into fnd_concurrent_queue_size

930: raise bad_parameter;
931: end if;
932:
933: /* do the insert */
934: insert into fnd_concurrent_queue_size
935: (queue_application_id, concurrent_queue_id,
936: period_application_id, concurrent_time_period_id,
937: last_update_date, last_updated_by, creation_date,
938: last_update_login, created_by, min_processes, sleep_seconds,

Line 1307: from fnd_concurrent_queue_size qs,

1303:
1304: if (work_shift_id is null) then
1305: select 'Y'
1306: into dummy
1307: from fnd_concurrent_queue_size qs,
1308: fnd_concurrent_time_periods tp
1309: where tp.concurrent_time_period_name = work_shift
1310: and tp.application_id = 0
1311: and tp.concurrent_time_period_id = qs.concurrent_time_period_id

Line 1318: from fnd_concurrent_queue_size

1314: and rownum = 1;
1315: else
1316: select 'Y'
1317: into dummy
1318: from fnd_concurrent_queue_size
1319: where work_shift_id = concurrent_time_period_id
1320: and concurrent_queue_id = mgr_id
1321: and queue_application_id = mgr_appl_id
1322: and rownum = 1;

Line 1577: delete from fnd_concurrent_queue_size

1573: where concurrent_queue_id = mgr_id
1574: and queue_application_id = mgr_appl_id;
1575:
1576: /* Work Shifts */
1577: delete from fnd_concurrent_queue_size
1578: where queue_application_id = mgr_appl_id
1579: and concurrent_queue_id = mgr_id;
1580:
1581: /* TL tables */

Line 1710: update fnd_concurrent_queue_size

1706: where queue_application_id = mgr_appl_id
1707: and concurrent_queue_id = mgr_id;
1708:
1709: /* Work Shifts */
1710: update fnd_concurrent_queue_size
1711: set concurrent_queue_id = manager_id
1712: where queue_application_id = mgr_appl_id
1713: and concurrent_queue_id = mgr_id;
1714: