32: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
33: --
34: -- UPDATE_NOTICE specific IN Parameters:
35: --
36: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
33: --
34: -- UPDATE_NOTICE specific IN Parameters:
35: --
36: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
34: -- UPDATE_NOTICE specific IN Parameters:
35: --
36: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
35: --
36: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
36: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
37: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
38: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
39: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
40: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
41: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
42: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
44: -- p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
46: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
48: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
50: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
52: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
54: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
56: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
58: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
60: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
62: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
64: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
66: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
68: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
70: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
72: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
74: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
76: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
78: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
80: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
82: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
90: --
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
90: --
91: -- p_app_short_name IN VARCHAR2(30) := NULL ,
84: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
90: --
91: -- p_app_short_name IN VARCHAR2(30) := NULL ,
92: -- p_queue_type IN VARCHAR2(30) := 'ASO_OF_Q'
85: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
86: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
88: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
90: --
91: -- p_app_short_name IN VARCHAR2(30) := NULL ,
92: -- p_queue_type IN VARCHAR2(30) := 'ASO_OF_Q'
93: --
107: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
108: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
109: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
108: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
109: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
109: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
110: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
111: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
112: OE_Order_PUB.G_MISS_HEADER_REC,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
113: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
114: OE_Order_PUB.G_MISS_HEADER_REC,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
115: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
116: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
117: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
118: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
119: p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
120: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
121: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
122: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
123: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
124: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
125: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
126: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
127: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
128: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
129: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
130: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
131: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
132: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
133: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
134: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
135: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
136: OE_Order_PUB.G_MISS_LINE_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
137: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
138: OE_Order_PUB.G_MISS_LINE_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
139: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
140: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
141: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
142: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
143: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
144: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
145: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
146: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
147: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
148: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
149: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
150: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
151: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
152: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
153: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
154: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
155: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
156: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164: OE_Order_PUB.G_MISS_REQUEST_TBL,
157: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164: OE_Order_PUB.G_MISS_REQUEST_TBL,
165: p_app_short_name IN VARCHAR2 := NULL ,
158: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164: OE_Order_PUB.G_MISS_REQUEST_TBL,
165: p_app_short_name IN VARCHAR2 := NULL ,
166: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
159: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164: OE_Order_PUB.G_MISS_REQUEST_TBL,
165: p_app_short_name IN VARCHAR2 := NULL ,
166: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
167: );
160: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
161: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
162: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
163: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
164: OE_Order_PUB.G_MISS_REQUEST_TBL,
165: p_app_short_name IN VARCHAR2 := NULL ,
166: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
167: );
168:
167: );
168:
169: PROCEDURE ASO_Header_Rec_To_Type
170: (
171: p_header_rec IN OE_Order_PUB.Header_Rec_Type ,
172: x_header_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Type
173: );
174:
175: PROCEDURE ASO_Header_Adj_Tbl_To_Var
173: );
174:
175: PROCEDURE ASO_Header_Adj_Tbl_To_Var
176: (
177: p_header_adj_tbl_type IN OE_Order_PUB.Header_Adj_Tbl_Type,
178: x_header_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Var_Type
179: );
180:
181: PROCEDURE ASO_Header_Adj_Assoc_Tbl_T_Var
179: );
180:
181: PROCEDURE ASO_Header_Adj_Assoc_Tbl_T_Var
182: (
183: p_header_adj_assoc_tbl_type IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
184: x_header_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Assoc_Var_Type
185: );
186:
187: PROCEDURE ASO_Header_Adj_Att_Tbl_To_Var
185: );
186:
187: PROCEDURE ASO_Header_Adj_Att_Tbl_To_Var
188: (
189: p_header_adj_att_tbl_type IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
190: x_header_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Att_Var_Type
191: );
192:
193: PROCEDURE ASO_Header_Price_Tbl_To_Var
191: );
192:
193: PROCEDURE ASO_Header_Price_Tbl_To_Var
194: (
195: p_header_price_att_tbl_type IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
196: x_header_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Price_Att_Var_Type
197: );
198:
199: PROCEDURE ASO_Header_Scredit_Tbl_To_Var
197: );
198:
199: PROCEDURE ASO_Header_Scredit_Tbl_To_Var
200: (
201: p_header_scredit_tbl_type IN OE_Order_PUB.Header_Scredit_Tbl_Type,
202: x_header_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Scredit_Var_Type
203: );
204:
205: PROCEDURE ASO_Line_Tbl_To_Var
203: );
204:
205: PROCEDURE ASO_Line_Tbl_To_Var
206: (
207: p_line_tbl_type IN OE_Order_PUB.Line_Tbl_Type,
208: x_line_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Var_Type
209: );
210:
211: PROCEDURE ASO_Line_Adj_Tbl_To_Var
209: );
210:
211: PROCEDURE ASO_Line_Adj_Tbl_To_Var
212: (
213: p_line_adj_tbl_type IN OE_Order_PUB.Line_Adj_Tbl_Type,
214: x_line_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Var_Type
215: );
216:
217: PROCEDURE ASO_Line_Adj_Assoc_Tbl_To_Var
215: );
216:
217: PROCEDURE ASO_Line_Adj_Assoc_Tbl_To_Var
218: (
219: p_line_adj_assoc_tbl_type IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
220: x_line_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Assoc_Var_Type
221: );
222:
223: PROCEDURE ASO_Line_Adj_Att_Tbl_To_Var
221: );
222:
223: PROCEDURE ASO_Line_Adj_Att_Tbl_To_Var
224: (
225: p_line_adj_att_tbl_type IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
226: x_line_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Att_Var_Type
227: );
228:
229: PROCEDURE ASO_Line_Price_Att_Tbl_To_Var
227: );
228:
229: PROCEDURE ASO_Line_Price_Att_Tbl_To_Var
230: (
231: p_line_price_att_tbl_type IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
232: x_line_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Price_Att_Var_Type
233: );
234:
235: PROCEDURE ASO_Line_Scredit_Tbl_To_Var
233: );
234:
235: PROCEDURE ASO_Line_Scredit_Tbl_To_Var
236: (
237: p_line_scredit_tbl_type IN OE_Order_PUB.Line_Scredit_Tbl_Type,
238: x_line_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Scredit_Var_Type
239: );
240:
241: PROCEDURE ASO_Lot_Serial_Tbl_To_Var
239: );
240:
241: PROCEDURE ASO_Lot_Serial_Tbl_To_Var
242: (
243: p_lot_serial_tbl_type IN OE_Order_PUB.Lot_Serial_Tbl_Type,
244: x_lot_serial_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Lot_Serial_Var_Type
245: );
246:
247: PROCEDURE ASO_Request_Tbl_To_Var
245: );
246:
247: PROCEDURE ASO_Request_Tbl_To_Var
248: (
249: p_request_tbl_type IN OE_Order_PUB.Request_Tbl_Type,
250: x_request_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Request_Var_Type
251: );
252:
253: PROCEDURE ASO_Order_Feedback_ENQ