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.ONT_IMPLICITCUSTACCEPT_PVT dependencies on OE_ORDER_PUB

Line 13: g_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;

9: G_THRESHOLD NUMBER := 50;
10: --=============================================================================
11: -- PUBLIC VARIABLES
12: --=============================================================================
13: g_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
14: g_cust_query VARCHAR2(15000) := 'SELECT line_id '||
15: ', header_id '||
16: ', item_type_code '||
17: ', flow_status_code '||

Line 217: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878

213: l_revrec_expiration_days NUMBER; --myerrams
214: l_table_loop_index NUMBER := 1;
215: l_query_where_clause VARCHAR2(3000); --myerrams, Bug:5161878
216: l_cust_query VARCHAR2(15000); --myerrams, Bug:5161878
217: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
218: l_expiry_date DATE := SYSDATE; -- bug 8293484
219: l_fulfillment_date DATE; -- bug 8293484
220:
221: -- ======================

Line 358: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878

354: l_sold_to_org_id NUMBER;
355: l_revrec_expiration_days NUMBER;
356: l_table_loop_index NUMBER := 1;
357: l_status BOOLEAN;
358: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
359: l_query_where_clause VARCHAR2(3000); --myerrams, Bug: 5235959
360: l_max_actual_shipment_date DATE; --myerrams, Bug: 5212583
361: l_count NUMBER; --myerrams, Bug: 5212583
362: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

530: -- COMMENT : TODO
531: --=============================================================================
532: PROCEDURE call_process_order_api
533: IS
534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

531: --=============================================================================
532: PROCEDURE call_process_order_api
533: IS
534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

532: PROCEDURE call_process_order_api
533: IS
534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

533: IS
534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

534: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

535: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

536: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

537: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

538: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

539: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

540: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

541: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN

Line 546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

542: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN

Line 547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

543: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
544: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
545: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
546: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
547: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
548: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
549: BEGIN
550: IF l_debug_level > 0 THEN
551: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');