DBA Data[Home] [Help]

APPS.XLA_ACCOUNTING_PKG dependencies on XLA_QUEUE_MSG_TYPE

Line 171: | XLA_QUEUE_MSG_TYPE IN APPS SCHEMA |

167: | Bug 3571389. Made changes TO refer TO THE |
168: | XLA_ACCTOUNTING_QTAB queue TABLE IN XLA |
169: | SCHEMA. |
170: | Made changes TO refer TO THE TYPE |
171: | XLA_QUEUE_MSG_TYPE IN APPS SCHEMA |
172: | 01/04/2005 S. Singhania Bug 4364612. WHILE loading xla_events_gt, |
173: | valuation method COLUMN IS populated. |
174: | 05/27/2005 V. Kumar Bug 4339454 Added handle_accounting_hook |
175: | procedure to replace business event by |

Line 4575: l_message xla_queue_msg_type; --SYSTEM.xla_queue_msg_type;

4571: l_children_spawned BOOLEAN := FALSE;
4572: l_unit_count NUMBER := 0;
4573: l_enq_options dbms_aq.enqueue_options_t;
4574: l_msg_prop dbms_aq.message_properties_t;
4575: l_message xla_queue_msg_type; --SYSTEM.xla_queue_msg_type;
4576: l_msgid RAW(16);
4577:
4578: l_event_class_code VARCHAR2(30);
4579: l_unit_size NUMBER := 0;

Line 4841: l_message := xla_queue_msg_type(l_entity_id); --SYSTEM.xla_queue_msg_type(l_entity_id);

4837:
4838: -------------------------------------------------------------------------
4839: -- create a message from the fetched entity ids.
4840: -------------------------------------------------------------------------
4841: l_message := xla_queue_msg_type(l_entity_id); --SYSTEM.xla_queue_msg_type(l_entity_id);
4842:
4843: -------------------------------------------------------------------------
4844: -- enqueue the message in the queue
4845: -------------------------------------------------------------------------

Line 4907: l_conf_message xla_queue_msg_type; -- SYSTEM.xla_queue_msg_type;

4903: (p_msg_count INTEGER)
4904: IS
4905: l_msgid RAW(16);
4906: l_conf_msg_prop dbms_aq.message_properties_t;
4907: l_conf_message xla_queue_msg_type; -- SYSTEM.xla_queue_msg_type;
4908: l_deq_options dbms_aq.dequeue_options_t;
4909: l_msg_count INTEGER;
4910:
4911: l_log_module VARCHAR2(240);

Line 5051: l_message xla_queue_msg_type; -- SYSTEM.xla_queue_msg_type;

5047: l_msg_count2 INTEGER;
5048: l_total_msg_count INTEGER;
5049: l_enq_options dbms_aq.enqueue_options_t;
5050: l_msg_prop dbms_aq.message_properties_t;
5051: l_message xla_queue_msg_type; -- SYSTEM.xla_queue_msg_type;
5052: l_msgid RAW(16);
5053: l_max_processing_order INTEGER;
5054: l_num_level INTEGER;
5055:

Line 5126: l_message := xla_queue_msg_type(NULL); -- SYSTEM.xla_queue_msg_type(NULL);

5122: l_msg_prop.correlation := NULL;
5123: l_msg_prop.exception_queue := NULL;
5124: l_msg_prop.sender_id := NULL;
5125:
5126: l_message := xla_queue_msg_type(NULL); -- SYSTEM.xla_queue_msg_type(NULL);
5127:
5128: IF (C_LEVEL_EVENT >= g_log_level) THEN
5129: trace
5130: (p_msg => 'BEGIN LOOP : enqueue document messges'

Line 6126: --l_message xla_queue_msg_type; --SYSTEM.xla_queue_msg_type;

6122: l_deq_options dbms_aq.dequeue_options_t;
6123: l_enq_options dbms_aq.enqueue_options_t;
6124: l_msg_prop dbms_aq.message_properties_t;
6125: l_msgid RAW(16);
6126: --l_message xla_queue_msg_type; --SYSTEM.xla_queue_msg_type;
6127: l_entity_count NUMBER := 0;
6128: l_event_count NUMBER := 0;
6129: l_dequeue_flag BOOLEAN;
6130:

Line 6733: g_message := xla_queue_msg_type(NULL);

6729: ,p_level => C_LEVEL_EVENT
6730: ,p_module => l_log_module);
6731: END IF;
6732:
6733: g_message := xla_queue_msg_type(NULL);
6734: dbms_aq.enqueue
6735: (g_comp_queue_name
6736: ,l_enq_options
6737: ,l_msg_prop

Line 6824: g_message := xla_queue_msg_type(NULL);

6820: ,p_module => l_log_module);
6821: END IF;
6822: EXCEPTION
6823: WHEN xla_exceptions_pkg.application_exception THEN
6824: g_message := xla_queue_msg_type(NULL);
6825: dbms_aq.enqueue
6826: (g_comp_queue_name
6827: ,l_enq_options
6828: ,l_msg_prop

Line 6837: g_message := xla_queue_msg_type(NULL);

6833: IF SQLCODE = -25228 AND g_conc_hold = 'Y' /* Timeout; queue is likely empty... */
6834: THEN
6835: RAISE;
6836: END IF;
6837: g_message := xla_queue_msg_type(NULL);
6838: dbms_aq.enqueue
6839: (g_comp_queue_name
6840: ,l_enq_options
6841: ,l_msg_prop