DBA Data[Home] [Help]

APPS.OE_INV_IFACE_PVT dependencies on INV_RESERVATION_GLOBAL

Line 38: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;

34: l_line_rec OE_Order_Pub.Line_Rec_Type;
35: l_sales_order_id NUMBER;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(4000);
38: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
39: l_rsv_tbl INV_RESERVATION_GLOBAL.mtl_reservation_tbl_type;
40: l_count NUMBER;
41: l_x_error_code NUMBER;
42: l_lock_records VARCHAR2(1);

Line 39: l_rsv_tbl INV_RESERVATION_GLOBAL.mtl_reservation_tbl_type;

35: l_sales_order_id NUMBER;
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(4000);
38: l_rsv_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
39: l_rsv_tbl INV_RESERVATION_GLOBAL.mtl_reservation_tbl_type;
40: l_count NUMBER;
41: l_x_error_code NUMBER;
42: l_lock_records VARCHAR2(1);
43: l_sort_by_req_date NUMBER;

Line 115: l_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE;

111: l_primary_uom VARCHAR2(3);
112:
113: --ER 8419373 Start
114: l_serial VARCHAR2(1);
115: l_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE;
116: l_serial_tbl_count NUMBER;
117: l_input_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE; --always empty
118: l_serial_transaction_temp_id NUMBER;
119: l_rsv_serial_count NUMBER; --Bug 13690325

Line 117: l_input_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE; --always empty

113: --ER 8419373 Start
114: l_serial VARCHAR2(1);
115: l_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE;
116: l_serial_tbl_count NUMBER;
117: l_input_serial_number_tbl INV_RESERVATION_GLOBAL.RSV_SERIAL_NUMBER_TABLE; --always empty
118: l_serial_transaction_temp_id NUMBER;
119: l_rsv_serial_count NUMBER; --Bug 13690325
120: --ER 8419373 End
121:

Line 528: --, p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no

524: , x_msg_data => l_msg_data
525: , p_query_input => l_rsv_rec
526: , p_lock_records => l_lock_records
527: , p_sort_by_req_date => l_sort_by_req_date
528: --, p_cancel_order_mode IN NUMBER DEFAULT inv_reservation_global.g_cancel_order_no
529: , p_serial_number_table => l_input_serial_number_tbl
530: , x_mtl_reservation_tbl => l_rsv_tbl
531: , x_mtl_reservation_tbl_count => l_count
532: , x_serial_number_table => l_serial_number_tbl