25: */
26: G_ORDER_NUMBER NUMBER;
27: G_ORIG_SYS_DOCUMENT_REF VARCHAR2(50);
28: PROCEDURE Reserve_Inventory (
29: p_header_rec IN OE_Order_Pub.Header_Rec_Type
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
26: G_ORDER_NUMBER NUMBER;
27: G_ORIG_SYS_DOCUMENT_REF VARCHAR2(50);
28: PROCEDURE Reserve_Inventory (
29: p_header_rec IN OE_Order_Pub.Header_Rec_Type
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
27: G_ORIG_SYS_DOCUMENT_REF VARCHAR2(50);
28: PROCEDURE Reserve_Inventory (
29: p_header_rec IN OE_Order_Pub.Header_Rec_Type
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
35: ,p_return_status OUT NOCOPY VARCHAR2
28: PROCEDURE Reserve_Inventory (
29: p_header_rec IN OE_Order_Pub.Header_Rec_Type
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
35: ,p_return_status OUT NOCOPY VARCHAR2
36:
29: p_header_rec IN OE_Order_Pub.Header_Rec_Type
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
35: ,p_return_status OUT NOCOPY VARCHAR2
36:
37: ) IS
30: ,p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_Tbl_Type
32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type
33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
35: ,p_return_status OUT NOCOPY VARCHAR2
36:
37: ) IS
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_Type
35: ,p_return_status OUT NOCOPY VARCHAR2
36:
37: ) IS
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
35: ,p_return_status OUT NOCOPY VARCHAR2
36:
37: ) IS
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
36:
37: ) IS
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
44:
37: ) IS
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
44:
45: mtl_res_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
38: l_header_rec OE_Order_Pub.Header_Rec_Type;
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
44:
45: mtl_res_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
46:
39: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
40: l_reservation_tbl OE_Order_Pub.Reservation_Tbl_Type;
41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;
42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_Type;
43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_Type;
44:
45: mtl_res_rec INV_RESERVATION_GLOBAL.mtl_reservation_rec_type;
46:
47: l_mtl_sales_order_id NUMBER;