DBA Data[Home] [Help]

APPS.XDP_FQUEUE_TOOLS dependencies on XDP_PENDING_ORDER_QTAB

Line 10: FROM xdp_pending_order_qtab;

6: BEGIN
7: IF queued_id = 'XDP_PENDING_ORDER_QUEUE' THEN
8: SELECT count(1)
9: INTO entries_number
10: FROM xdp_pending_order_qtab;
11: ELSIF queued_id = 'XDP_ORDER_PROC_QUEUE' THEN
12: SELECT count(1)
13: INTO entries_number
14: FROM XDP_ORDER_PROCESSOR_qtab;

Line 60: FROM xdp_pending_order_qtab;

56: BEGIN
57: IF queued_id = 'XDP_PENDING_ORDER_QUEUE' THEN
58: SELECT max(ENQ_TIME)
59: INTO entry_date
60: FROM xdp_pending_order_qtab;
61: ELSIF queued_id = 'XDP_ORDER_PROC_QUEUE' THEN
62: SELECT max(ENQ_TIME)
63: INTO entry_date
64: FROM XDP_ORDER_PROCESSOR_qtab;