APPS.OZF_ACCRUAL_ENGINE dependencies on DBMS_AQ

Line 5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;

5362: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;
5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
5367: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
5368:
5369: BEGIN
5370: -- Standard Start of process savepoint

Line 5367: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;

5363: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
5364: l_action_request_tbl oe_order_pub.request_tbl_type;
5365: l_index NUMBER;
5366: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
5367: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
5368:
5369: BEGIN
5370: -- Standard Start of process savepoint
5371: -- Start looping to check for messages in the queue

Line 5486: l_navigation := DBMS_AQ.NEXT_MESSAGE;

5482: -- Check return status of functional process,
5483: -- rollback to undo processing
5484: -- if not success write the error message to the log file
5485: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
5486: l_navigation := DBMS_AQ.NEXT_MESSAGE;
5487: ROLLBACK TO get_excep_loop_savepoint;
5488: --x_retcode := 1;
5489: x_errbuf := l_msg_data;
5490: END IF;

Line 5503: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,

5499: x_return_status=> l_return_status,
5500: x_msg_count=> l_msg_count,
5501: x_msg_data=> l_msg_data,
5502: p_app_short_name=> 'OZF', -- need to be resolved , wether it is AMS or OZF
5503: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,
5504: p_navigation => DBMS_AQ.FIRST_MESSAGE,
5505: x_no_more_messages=> l_no_more_messages,
5506: x_header_rec=> l_header_rec,
5507: x_old_header_rec=> l_old_header_rec,

Line 5504: p_navigation => DBMS_AQ.FIRST_MESSAGE,

5500: x_msg_count=> l_msg_count,
5501: x_msg_data=> l_msg_data,
5502: p_app_short_name=> 'OZF', -- need to be resolved , wether it is AMS or OZF
5503: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,
5504: p_navigation => DBMS_AQ.FIRST_MESSAGE,
5505: x_no_more_messages=> l_no_more_messages,
5506: x_header_rec=> l_header_rec,
5507: x_old_header_rec=> l_old_header_rec,
5508: x_header_adj_tbl=> l_header_adj_tbl,

Line 5544: l_navigation := DBMS_AQ.FIRST_MESSAGE ;

5540: END IF;
5541: ozf_utility_pvt.write_conc_log('again exception happened');
5542: RETURN;
5543: ELSE
5544: l_navigation := DBMS_AQ.FIRST_MESSAGE ;
5545: COMMIT;
5546: x_retcode := 0;
5547: END IF;
5548: ELSE