DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_RESERVE_PVT dependencies on OE_ORDER_PUB

Line 29: p_header_rec IN OE_Order_Pub.Header_Rec_Type

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

Line 30: ,p_line_tbl IN OE_Order_Pub.Line_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

Line 31: ,p_reservation_tbl IN OE_Order_Pub.Reservation_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

Line 32: ,p_header_val_rec IN OE_Order_Pub.Header_Val_Rec_Type

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:

Line 33: ,p_line_val_tbl IN OE_Order_Pub.Line_Val_Tbl_Type

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

Line 34: ,p_reservation_val_tbl IN OE_Order_Pub.Reservation_Val_Tbl_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
38: l_header_rec OE_Order_Pub.Header_Rec_Type;

Line 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;

Line 39: l_line_tbl OE_Order_Pub.Line_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;

Line 40: l_reservation_tbl OE_Order_Pub.Reservation_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:

Line 41: l_header_val_rec OE_Order_Pub.Header_Val_Rec_Type;

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;

Line 42: l_line_val_tbl OE_Order_Pub.Line_Val_Tbl_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:

Line 43: l_reservation_val_tbl OE_Order_Pub.Reservation_Val_Tbl_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:
47: l_mtl_sales_order_id NUMBER;