APPS.OE_LOTS_ACK_UTIL dependencies on OE_ORDER_PUB

Line 9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type

5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lots_Ack_Util';
7:
8: PROCEDURE Insert_Row
9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type

Line 10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type

6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Lots_Ack_Util';
7:
8: PROCEDURE Insert_Row
9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type

Line 11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type

7:
8: PROCEDURE Insert_Row
9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
15: , p_reject_order IN VARCHAR2

Line 12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type

8: PROCEDURE Insert_Row
9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
15: , p_reject_order IN VARCHAR2
16: , x_return_status OUT NOCOPY VARCHAR2

Line 13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type

9: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
15: , p_reject_order IN VARCHAR2
16: , x_return_status OUT NOCOPY VARCHAR2
17:

Line 14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type

10: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
11: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
12: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
13: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
14: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
15: , p_reject_order IN VARCHAR2
16: , x_return_status OUT NOCOPY VARCHAR2
17:
18: )

Line 21: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;

17:
18: )
19: IS
20: l_return_status VARCHAR2(1);
21: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
22: l_lot_serial_val_rec OE_Order_Pub.Lot_Serial_Val_Rec_Type;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --

Line 22: l_lot_serial_val_rec OE_Order_Pub.Lot_Serial_Val_Rec_Type;

18: )
19: IS
20: l_return_status VARCHAR2(1);
21: l_lot_serial_rec OE_Order_Pub.Lot_Serial_Rec_Type;
22: l_lot_serial_val_rec OE_Order_Pub.Lot_Serial_Val_Rec_Type;
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN