APPS.XNP_TIMER_MGR dependencies on DBMS_AQ

Line 536: my_enqueue_options dbms_aq.enqueue_options_t ;

532:
533: IS
534: l_message system.xnp_message_type ;
535: l_msg_id XNP_MSGS.MSG_ID%TYPE ;
536: my_enqueue_options dbms_aq.enqueue_options_t ;
537: message_properties dbms_aq.message_properties_t ;
538: message_handle RAW(16) ;
539:
540:

Line 537: message_properties dbms_aq.message_properties_t ;

533: IS
534: l_message system.xnp_message_type ;
535: l_msg_id XNP_MSGS.MSG_ID%TYPE ;
536: my_enqueue_options dbms_aq.enqueue_options_t ;
537: message_properties dbms_aq.message_properties_t ;
538: message_handle RAW(16) ;
539:
540:
541: l_feedback VARCHAR2(4000) := NULL ;

Line 552: -- my_enqueue_options.visibility := DBMS_AQ.IMMEDIATE ;

548: -- adabholk 03/2001
549: -- Perfomance Changes
550: -- Changed incorrect enqueue option at the time of performance changes
551:
552: -- my_enqueue_options.visibility := DBMS_AQ.IMMEDIATE ;
553: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;
554:
555: l_message := system.xnp_message_type(p_msg_header.message_id) ;
556:

Line 553: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;

549: -- Perfomance Changes
550: -- Changed incorrect enqueue option at the time of performance changes
551:
552: -- my_enqueue_options.visibility := DBMS_AQ.IMMEDIATE ;
553: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;
554:
555: l_message := system.xnp_message_type(p_msg_header.message_id) ;
556:
557: DBMS_AQ.ENQUEUE (

Line 557: DBMS_AQ.ENQUEUE (

553: my_enqueue_options.visibility := DBMS_AQ.ON_COMMIT ;
554:
555: l_message := system.xnp_message_type(p_msg_header.message_id) ;
556:
557: DBMS_AQ.ENQUEUE (
558: queue_name => xnp_event.c_inbound_msg_q ,
559: enqueue_options => my_enqueue_options,
560: message_properties => message_properties,
561: payload => l_message,