1: PACKAGE OE_Lots_Ack_Util AUTHID CURRENT_USER AS
2: /* $Header: OEXUSAKS.pls 120.0 2005/06/01 00:59:31 appldev noship $ */
3:
4: PROCEDURE Insert_Row
5: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
2: /* $Header: OEXUSAKS.pls 120.0 2005/06/01 00:59:31 appldev noship $ */
3:
4: PROCEDURE Insert_Row
5: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
10: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
3:
4: PROCEDURE Insert_Row
5: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
10: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
11: , p_reject_order IN VARCHAR2
4: PROCEDURE Insert_Row
5: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
10: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
11: , p_reject_order IN VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
5: ( p_line_tbl IN OE_Order_Pub.Line_Tbl_Type
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
10: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
11: , p_reject_order IN VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13:
6: , p_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
7: , p_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
8: , p_old_line_tbl IN OE_Order_Pub.Line_Tbl_type
9: , p_old_lot_serial_tbl IN OE_Order_Pub.Lot_Serial_Tbl_Type
10: , p_old_lot_serial_val_tbl IN OE_Order_Pub.Lot_Serial_Val_Tbl_Type
11: , p_reject_order IN VARCHAR2
12: , x_return_status OUT NOCOPY VARCHAR2
13:
14: );