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 200: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878

196: l_revrec_expiration_days NUMBER; --myerrams
197: l_table_loop_index NUMBER := 1;
198: l_query_where_clause VARCHAR2(3000); --myerrams, Bug:5161878
199: l_cust_query VARCHAR2(15000); --myerrams, Bug:5161878
200: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
201:
202: -- ======================
203: -- Dynamic Cursor Variable
204: -- =======================

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

306: l_sold_to_org_id NUMBER;
307: l_revrec_expiration_days NUMBER;
308: l_table_loop_index NUMBER := 1;
309: l_status BOOLEAN;
310: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type; --myerrams, Bug:5161878
311: l_query_where_clause VARCHAR2(3000); --myerrams, Bug: 5235959
312: l_max_actual_shipment_date DATE; --myerrams, Bug: 5212583
313: l_count NUMBER; --myerrams, Bug: 5212583
314: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;

449: -- COMMENT : TODO
450: --=============================================================================
451: PROCEDURE call_process_order_api
452: IS
453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

Line 454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

450: --=============================================================================
451: PROCEDURE call_process_order_api
452: IS
453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;

451: PROCEDURE call_process_order_api
452: IS
453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

Line 456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;

452: IS
453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

Line 457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;

453: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

Line 458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

454: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

Line 459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;

455: l_header_price_att_out_tbl OE_ORDER_PUB.Header_Price_Att_Tbl_Type;
456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

Line 460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;

456: l_header_adj_att_out_tbl OE_ORDER_PUB.Header_Adj_Att_Tbl_Type;
457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;

457: l_header_adj_assoc_out_tbl OE_ORDER_PUB.Header_Adj_Assoc_Tbl_Type;
458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;

458: l_header_scredit_out_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

Line 463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;

459: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

460: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: BEGIN

Line 465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

461: l_line_price_att_out_tbl OE_ORDER_PUB.Line_Price_Att_Tbl_Type;
462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: BEGIN
469: IF l_debug_level > 0 THEN

Line 466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;

462: l_line_adj_att_out_tbl OE_ORDER_PUB.Line_Adj_Att_Tbl_Type;
463: l_line_adj_assoc_out_tbl OE_ORDER_PUB.Line_Adj_Assoc_Tbl_Type;
464: l_line_scredit_out_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
465: l_lot_serial_out_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
466: l_action_request_out_tbl OE_Order_PUB.Request_Tbl_Type;
467: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
468: BEGIN
469: IF l_debug_level > 0 THEN
470: oe_debug_pub.add('Implicit Acceptance: Before call to Process Order API');