36: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2(2000)
37: --
38: -- UPDATE_NOTICE specific IN Parameters:
39: --
40: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
37: --
38: -- UPDATE_NOTICE specific IN Parameters:
39: --
40: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
38: -- UPDATE_NOTICE specific IN Parameters:
39: --
40: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
39: --
40: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
40: -- p_header_rec IN OE_Order_PUB.Header_Rec_Type OPTIONAL
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
41: -- Default := OE_Order_PUB.G_MISS_HEADER_REC
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
42: -- p_old_header_rec IN OE_Order_PUB.Header_Rec_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
43: -- Default := OE_ORDER_PUB.G_MISS_HEADER_REC
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
44: -- p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
45: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
46: -- p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
47: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
48: -- p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
49: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
50: -- p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
51: -- Default := OE_ORDER_PUB.G_MISS_HEADER_PRICE_ATT_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
52: -- p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
53: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
54: -- p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
55: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ATT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
56: -- p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
57: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
58: -- p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
59: -- Default := OE_ORDER_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
60: -- p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
61: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
62: -- p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
63: -- Default := OE_ORDER_PUB.G_MISS_HEADER_SCREDIT_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
64: -- p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
65: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
66: -- p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
67: -- Default := OE_ORDER_PUB.G_MISS_LINE_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
68: -- p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
69: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
70: -- p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
71: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
72: -- p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
73: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
74: -- p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
75: -- Default := OE_ORDER_PUB.G_MISS_LINE_PRICE_ATT_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
76: -- p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
77: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
78: -- p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
79: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ATT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
80: -- p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
81: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
82: -- p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
83: -- Default := OE_ORDER_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
84: -- p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
85: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
93: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
86: -- p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
93: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
94: --
87: -- Default := OE_ORDER_PUB.G_MISS_LINE_SCREDIT_TBL
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
93: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
94: --
95: -- p_app_short_name IN VARCHAR2(30) := NULL ,
88: -- p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
93: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
94: --
95: -- p_app_short_name IN VARCHAR2(30) := NULL ,
96: -- p_queue_type IN VARCHAR2(30) := 'OF_QUEUE'
89: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
90: -- p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type
91: -- Default := OE_ORDER_PUB.G_MISS_LOT_SERIAL_TBL
92: -- p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type
93: -- Default := OE_ORDER_PUB.G_MISS_REQUEST_TBL
94: --
95: -- p_app_short_name IN VARCHAR2(30) := NULL ,
96: -- p_queue_type IN VARCHAR2(30) := 'OF_QUEUE'
97: --
112: p_commit IN VARCHAR2 := FND_API.G_FALSE,
113: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
114: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
114: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
115: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
116: p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_REC,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
118: p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_REC,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
120: p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
122: p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
124: p_Header_price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
126: p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
128: p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
130: p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
131: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
132: p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
134: p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
135: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
136: p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
138: p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
139: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
140: p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
142: p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
144: p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
146: p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
148: p_Line_price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
150: p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
152: p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
154: p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
156: p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
158: p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
160: p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
169: OE_Order_PUB.G_MISS_REQUEST_TBL,
162: p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
169: OE_Order_PUB.G_MISS_REQUEST_TBL,
170: p_app_short_name IN VARCHAR2 := NULL,
163: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
169: OE_Order_PUB.G_MISS_REQUEST_TBL,
170: p_app_short_name IN VARCHAR2 := NULL,
171: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
164: p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
169: OE_Order_PUB.G_MISS_REQUEST_TBL,
170: p_app_short_name IN VARCHAR2 := NULL,
171: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
172: )
165: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
166: p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
167: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
168: p_action_request_tbl IN OE_Order_PUB.Request_Tbl_Type :=
169: OE_Order_PUB.G_MISS_REQUEST_TBL,
170: p_app_short_name IN VARCHAR2 := NULL,
171: p_queue_type IN VARCHAR2 := 'OF_QUEUE'
172: )
173: IS
354: END UPDATE_NOTICE;
355:
356: PROCEDURE ASO_Header_Rec_To_Type
357: (
358: p_header_rec IN OE_Order_PUB.Header_Rec_Type ,
359: x_header_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Type
360: )
361: IS
362: BEGIN
510: END ASO_Header_Rec_To_Type;
511:
512: PROCEDURE ASO_Header_Adj_Tbl_To_Var
513: (
514: p_header_adj_tbl_type IN OE_Order_PUB.Header_Adj_Tbl_Type,
515: x_header_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Var_Type
516: )
517: IS
518: l_header_adj_type SYSTEM.ASO_Header_Adj_Type;
604:
605:
606: PROCEDURE ASO_Header_Adj_Assoc_Tbl_T_Var
607: (
608: p_header_adj_assoc_tbl_type IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
609: x_header_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Assoc_Var_Type
610: )
611: IS
612: l_header_adj_assoc_type SYSTEM.ASO_Header_Adj_Assoc_Type;
652: END ASO_Header_Adj_Assoc_Tbl_T_Var;
653:
654: PROCEDURE ASO_Header_Adj_Att_Tbl_To_Var
655: (
656: p_header_adj_att_tbl_type IN OE_Order_PUB.Header_Adj_Att_Tbl_Type,
657: x_header_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Adj_Att_Var_Type
658: )
659: IS
660: l_header_adj_att_type SYSTEM.ASO_Header_Adj_Att_Type;
703: END ASO_Header_Adj_Att_Tbl_To_Var;
704:
705: PROCEDURE ASO_Header_Price_Tbl_To_Var
706: (
707: p_header_price_att_tbl_type IN OE_Order_PUB.Header_Price_Att_Tbl_Type,
708: x_header_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Price_Att_Var_Type
709: )
710: IS
711: l_header_price_att_type SYSTEM.ASO_Header_Price_Att_Type;
866:
867:
868: PROCEDURE ASO_Header_Scredit_Tbl_To_Var
869: (
870: p_header_scredit_tbl_type IN OE_Order_PUB.Header_Scredit_Tbl_Type,
871: x_header_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Header_Scredit_Var_Type
872: )
873: IS
874: l_header_scredit_type SYSTEM.ASO_Header_Scredit_Type;
929: END ASO_Header_Scredit_Tbl_To_Var;
930:
931: PROCEDURE ASO_Line_Tbl_To_Var
932: (
933: p_line_tbl_type IN OE_Order_PUB.Line_Tbl_Type,
934: x_line_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Var_Type
935: )
936: IS
937: l_line_type SYSTEM.ASO_Line_Type;
1273: END ASO_Line_Tbl_To_Var;
1274:
1275: PROCEDURE ASO_Line_Adj_Tbl_To_Var
1276: (
1277: p_line_adj_tbl_type IN OE_Order_PUB.Line_Adj_Tbl_Type ,
1278: x_line_adj_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Var_Type
1279: )
1280: IS
1281: l_line_adj_type SYSTEM.ASO_Line_Adj_Type;
1366: END ASO_Line_Adj_Tbl_To_Var;
1367:
1368: PROCEDURE ASO_Line_Adj_Assoc_Tbl_To_Var
1369: (
1370: p_line_adj_assoc_tbl_type IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1371: x_line_adj_assoc_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Assoc_Var_Type
1372: )
1373: IS
1374: l_line_adj_assoc_type SYSTEM.ASO_Line_Adj_Assoc_Type;
1413:
1414:
1415: PROCEDURE ASO_Line_Adj_Att_Tbl_To_Var
1416: (
1417: p_line_adj_att_tbl_type IN OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1418: x_line_adj_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Adj_Att_Var_Type
1419: )
1420: IS
1421: l_line_adj_att_type SYSTEM.ASO_Line_Adj_Att_Type;
1464: END ASO_Line_Adj_Att_Tbl_To_Var;
1465:
1466: PROCEDURE ASO_Line_Price_Att_Tbl_To_Var
1467: (
1468: p_line_price_att_tbl_type IN OE_Order_PUB.Line_Price_Att_Tbl_Type,
1469: x_line_price_att_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Price_Att_Var_Type
1470: )
1471: IS
1472: l_line_price_att_type SYSTEM.ASO_Line_Price_Att_Type;
1630: END ASO_Line_Price_Att_Tbl_To_Var;
1631:
1632: PROCEDURE ASO_Line_Scredit_Tbl_To_Var
1633: (
1634: p_line_scredit_tbl_type IN OE_Order_PUB.Line_Scredit_Tbl_Type,
1635: x_line_scredit_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Line_Scredit_Var_Type
1636: )
1637: IS
1638: l_line_scredit_type SYSTEM.ASO_Line_Scredit_Type;
1696:
1697:
1698: PROCEDURE ASO_Lot_Serial_Tbl_To_Var
1699: (
1700: p_lot_serial_tbl_type IN OE_Order_PUB.Lot_Serial_Tbl_Type,
1701: x_lot_serial_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Lot_Serial_Var_Type)
1702: IS
1703: l_lot_serial_type SYSTEM.ASO_Lot_Serial_Type;
1704: i NUMBER;
1760: END ASO_Lot_Serial_Tbl_To_Var;
1761:
1762: PROCEDURE ASO_Request_Tbl_To_Var
1763: (
1764: p_request_tbl_type IN OE_Order_PUB.Request_Tbl_Type,
1765: x_request_var_type OUT NOCOPY /* file.sql.39 change */ SYSTEM.ASO_Request_Var_Type
1766: )
1767: IS
1768: l_request_type SYSTEM.ASO_Request_Type;