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 309: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;

305: IF l_line_rec.source_document_type_id = 10 THEN
306: -- This is an internal order line. We need to give
307: -- a different demand source type for these lines.
308: l_rsv_rec.demand_source_type_id :=
309: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
310: -- intenal order
311: ELSE
312: l_rsv_rec.demand_source_type_id :=
313: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

Line 313: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry

309: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_INTERNAL_ORD;
310: -- intenal order
311: ELSE
312: l_rsv_rec.demand_source_type_id :=
313: INV_RESERVATION_GLOBAL.G_SOURCE_TYPE_OE; -- order entry
314: END IF;
315:
316: -- Get demand_source_header_id from mtl_sales_orders
317:

Line 454: p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES,

450: x_return_status => l_return_status,
451: x_msg_count => l_msg_count,
452: x_msg_data => l_msg_data,
453: p_query_input => l_rsv_rec,
454: p_cancel_order_mode => INV_RESERVATION_GLOBAL.G_CANCEL_ORDER_YES,
455: x_mtl_reservation_tbl => l_rsv_tbl,
456: x_mtl_reservation_tbl_count => l_count,
457: x_error_code => l_x_error_code,
458: p_lock_records => l_lock_records,