12: ,x_msg_data OUT NOCOPY VARCHAR2
13: )
14: IS
15:
16: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
13: )
14: IS
15:
16: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
14: IS
15:
16: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
15:
16: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
16: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
17: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
18: l_header_rec OE_Order_PUB.Header_Rec_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
19: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
20: l_header_adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
21: l_line_adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
22: l_header_price_att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
23: l_line_price_att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
24: l_header_adj_att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
25: l_line_adj_att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33: l_action_request_tbl OE_Order_PUB.request_tbl_type;
26: l_header_adj_assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33: l_action_request_tbl OE_Order_PUB.request_tbl_type;
34: l_control_rec OE_GLOBALS.Control_Rec_Type;
27: l_line_adj_assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33: l_action_request_tbl OE_Order_PUB.request_tbl_type;
34: l_control_rec OE_GLOBALS.Control_Rec_Type;
35: l_return_status VARCHAR2(30);
28: l_header_scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33: l_action_request_tbl OE_Order_PUB.request_tbl_type;
34: l_control_rec OE_GLOBALS.Control_Rec_Type;
35: l_return_status VARCHAR2(30);
36: l_msg_count NUMBER;
29: l_line_scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
30: l_lot_serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
31: l_header_payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
32: l_line_payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
33: l_action_request_tbl OE_Order_PUB.request_tbl_type;
34: l_control_rec OE_GLOBALS.Control_Rec_Type;
35: l_return_status VARCHAR2(30);
36: l_msg_count NUMBER;
37: l_msg_data VARCHAR2(2000);