APPS.WSH_DELIVERY_DETAILS_ACTIONS dependencies on INV_RESERVATION_GLOBAL

Line 107: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;

103: )
104:
105:
106: IS
107: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
108: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
109: l_msg_count NUMBER;
110: l_msg_data VARCHAR2(3000);
111: l_rsv_id NUMBER;

Line 108: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;

104:
105:
106: IS
107: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
108: l_rsv_new_rec inv_reservation_global.mtl_reservation_rec_type;
109: l_msg_count NUMBER;
110: l_msg_data VARCHAR2(3000);
111: l_rsv_id NUMBER;
112: l_return_status VARCHAR2(1);

Line 117: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;

113: l_reserve_msg_count NUMBER := 0;
114: l_reserve_msg_data VARCHAR2(4000) := NULL;
115: l_reserve_message VARCHAR2(4000) := NULL;
116: l_reserve_status VARCHAR2(1);
117: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
118: l_count NUMBER;
119: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
120: l_qty_to_unreserve NUMBER;
121: l_sales_order_id NUMBER := NULL;

Line 119: l_dummy_sn inv_reservation_global.serial_number_tbl_type;

115: l_reserve_message VARCHAR2(4000) := NULL;
116: l_reserve_status VARCHAR2(1);
117: l_rsv_tbl inv_reservation_global.mtl_reservation_tbl_type;
118: l_count NUMBER;
119: l_dummy_sn inv_reservation_global.serial_number_tbl_type;
120: l_qty_to_unreserve NUMBER;
121: l_sales_order_id NUMBER := NULL;
122: l_x_error_code NUMBER;
123: l_lock_records VARCHAR2(1);

Line 317: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

313: IF l_line_rec.source_document_type_id = 10 THEN
314: -- This is an internal order line. We need to give
315: -- a different demand source type for these lines.
316: l_rsv_rec.demand_source_type_id :=
317: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
318: -- intenal order
319: ELSE
320: l_rsv_rec.demand_source_type_id :=
321: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

Line 321: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

317: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
318: -- intenal order
319: ELSE
320: l_rsv_rec.demand_source_type_id :=
321: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
322: END IF;
323:
324: -- Get demand_source_header_id from mtl_sales_orders
325:

Line 488: p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES,

484: x_return_status => l_return_status,
485: x_msg_count => l_msg_count,
486: x_msg_data => l_msg_data,
487: p_query_input => l_rsv_rec,
488: p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES,
489: x_mtl_reservation_tbl => l_rsv_tbl,
490: x_mtl_reservation_tbl_count => l_count,
491: x_error_code => l_x_error_code,
492: p_lock_records => l_lock_records,