8: -- simplify the customization process. It consists of both the pre and
9: -- post processing APIs.
10:
11: PROCEDURE Update_Notice_PRE(
12: p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
9: -- post processing APIs.
10:
11: PROCEDURE Update_Notice_PRE(
12: p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
10:
11: PROCEDURE Update_Notice_PRE(
12: p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
11: PROCEDURE Update_Notice_PRE(
12: p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
12: p_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
13: p_old_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
14: p_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
15: p_old_Header_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
16: p_Header_price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
17: p_old_Header_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
18: p_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
19: p_old_Header_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Att_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
20: p_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
21: p_old_Header_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
22: p_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
23: p_old_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
24: p_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
25: p_old_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
26: p_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
27: p_old_Line_Adj_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
28: p_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
29: p_old_Line_Price_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Price_Att_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
30: p_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
38: p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
31: p_old_Line_Adj_Att_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Att_Tbl_Type,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
38: p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
39: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
32: p_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
38: p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
39: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
33: p_old_Line_Adj_Assoc_tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
38: p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
39: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
34: p_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
35: p_old_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type,
36: p_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
37: p_old_Lot_Serial_tbl IN OUT NOCOPY OE_Order_PUB.Lot_Serial_Tbl_Type,
38: p_action_request_tbl IN OUT NOCOPY OE_Order_PUB.Request_Tbl_Type,
39: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
40: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
41: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: );
43:
44:
45:
46: PROCEDURE Update_Notice_Post(
47: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
44:
45:
46: PROCEDURE Update_Notice_Post(
47: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
45:
46: PROCEDURE Update_Notice_Post(
47: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
46: PROCEDURE Update_Notice_Post(
47: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
47: p_header_rec IN OE_Order_PUB.Header_Rec_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
48: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
49: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
50: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
51: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
52: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
53: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
54: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
55: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
56: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
57: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
58: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
59: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
60: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
61: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
62: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
63: p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
64: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
65: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
73: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
66: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
73: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
67: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
73: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
68: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
73: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
69: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
70: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type,
71: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
72: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type,
73: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type,
74: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
75: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
76: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
77: );