eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_ACCRUAL_ENGINE dependencies on DBMS_AQ

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

4234: l_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;
4238: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
4239: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
4240:
4241: BEGIN
4242: -- Standard Start of process savepoint

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

4235: l_old_lot_serial_tbl oe_order_pub.lot_serial_tbl_type;
4236: l_action_request_tbl oe_order_pub.request_tbl_type;
4237: l_index NUMBER;
4238: l_mode VARCHAR2(30):= DBMS_AQ.BROWSE;
4239: l_navigation VARCHAR2 (30) := DBMS_AQ.FIRST_MESSAGE;
4240:
4241: BEGIN
4242: -- Standard Start of process savepoint
4243: -- Start looping to check for messages in the queue

Line 4358: l_navigation := DBMS_AQ.NEXT_MESSAGE;

4354: -- Check return status of functional process,
4355: -- rollback to undo processing
4356: -- if not success write the error message to the log file
4357: IF NOT (l_return_status = fnd_api.g_ret_sts_success) THEN
4358: l_navigation := DBMS_AQ.NEXT_MESSAGE;
4359: ROLLBACK TO get_excep_loop_savepoint;
4360: --x_retcode := 1;
4361: x_errbuf := l_msg_data;
4362: END IF;

Line 4375: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,

4371: x_return_status=> l_return_status,
4372: x_msg_count=> l_msg_count,
4373: x_msg_data=> l_msg_data,
4374: p_app_short_name=> 'OZF', -- need to be resolved , wether it is AMS or OZF
4375: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,
4376: p_navigation => DBMS_AQ.FIRST_MESSAGE,
4377: x_no_more_messages=> l_no_more_messages,
4378: x_header_rec=> l_header_rec,
4379: x_old_header_rec=> l_old_header_rec,

Line 4376: p_navigation => DBMS_AQ.FIRST_MESSAGE,

4372: x_msg_count=> l_msg_count,
4373: x_msg_data=> l_msg_data,
4374: p_app_short_name=> 'OZF', -- need to be resolved , wether it is AMS or OZF
4375: p_dequeue_mode => DBMS_AQ.REMOVE_NODATA,
4376: p_navigation => DBMS_AQ.FIRST_MESSAGE,
4377: x_no_more_messages=> l_no_more_messages,
4378: x_header_rec=> l_header_rec,
4379: x_old_header_rec=> l_old_header_rec,
4380: x_header_adj_tbl=> l_header_adj_tbl,

Line 4407: l_navigation := DBMS_AQ.FIRST_MESSAGE ;

4403: x_old_lot_serial_tbl=> l_old_lot_serial_tbl,
4404: x_action_request_tbl=> l_action_request_tbl
4405: );
4406:
4407: l_navigation := DBMS_AQ.FIRST_MESSAGE ;
4408: COMMIT;
4409: x_retcode := 0;
4410: ELSE
4411: ozf_utility_pvt.write_conc_log;