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