60: , x_msg_count OUT NOCOPY NUMBER
61:
62: , x_msg_data OUT NOCOPY VARCHAR2
63:
64: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
61:
62: , x_msg_data OUT NOCOPY VARCHAR2
63:
64: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
62: , x_msg_data OUT NOCOPY VARCHAR2
63:
64: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
63:
64: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
64: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
65: OE_Order_PUB.G_MISS_HEADER_REC
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
66: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
67: OE_Order_PUB.G_MISS_HEADER_REC
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
68: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
69: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
70: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
71: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
72: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
73: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
74: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
75: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
76: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
77: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
78: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
79: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
80: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
81: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
82: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
83: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
84: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
85: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
86: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
87: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
88: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
89: OE_Order_PUB.G_MISS_LINE_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
90: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
91: OE_Order_PUB.G_MISS_LINE_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
92: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
93: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
94: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
95: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
96: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
97: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
98: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
99: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
100: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
101: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
102: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
103: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
104: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
105: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
106: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
107: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
108: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
109: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
110: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
111: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
112: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
113: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
121: OE_Order_PUB.g_miss_request_tbl
114: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
121: OE_Order_PUB.g_miss_request_tbl
122: )
115: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
121: OE_Order_PUB.g_miss_request_tbl
122: )
123: IS
116: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
121: OE_Order_PUB.g_miss_request_tbl
122: )
123: IS
124:
117: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
118: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
119: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
120: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
121: OE_Order_PUB.g_miss_request_tbl
122: )
123: IS
124:
125: l_number NUMBER := 0;
544:
545: PROCEDURE Get_Service_Duration
546: ( x_return_status OUT NOCOPY VARCHAR2
547:
548: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
549: )
550: IS
551: l_return_status VARCHAR2(1);
552: l_init_msg_list VARCHAR2(1);
700:
701: PROCEDURE Get_Service_Attribute
702: ( x_return_status OUT NOCOPY VARCHAR2
703:
704: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
705: )
706: IS
707: l_header_id NUMBER;
708: l_line_id NUMBER;
2692: End Val_Item_Change;
2693:
2694:
2695: PROCEDURE Update_Service_Lines
2696: (p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
2697: x_return_status OUT NOCOPY VARCHAR2
2698:
2699: )
2700: IS
2698:
2699: )
2700: IS
2701:
2702: l_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_referenced_line_rec OE_Order_PUB.Line_Rec_Type;
2704: i pls_integer;
2705: j pls_integer;
2706: k pls_integer;
2699: )
2700: IS
2701:
2702: l_line_rec OE_Order_PUB.Line_Rec_Type;
2703: l_referenced_line_rec OE_Order_PUB.Line_Rec_Type;
2704: i pls_integer;
2705: j pls_integer;
2706: k pls_integer;
2707: l_service_number NUMBER;
2705: j pls_integer;
2706: k pls_integer;
2707: l_service_number NUMBER;
2708:
2709: l_new_line_rec OE_ORDER_PUB.line_rec_type;
2710: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2711: l_line_id NUMBER;
2712: line_not_found BOOLEAN;
2713: l_cascade_request_flag BOOLEAN := FALSE; -- for bug 2366503
2706: k pls_integer;
2707: l_service_number NUMBER;
2708:
2709: l_new_line_rec OE_ORDER_PUB.line_rec_type;
2710: l_old_line_rec OE_ORDER_PUB.line_rec_type;
2711: l_line_id NUMBER;
2712: line_not_found BOOLEAN;
2713: l_cascade_request_flag BOOLEAN := FALSE; -- for bug 2366503
2714:
2846: /* csheu -- added for bug #1533658 */
2847:
2848: Procedure CASCADE_CHANGES
2849: ( p_parent_line_id IN NUMBER,
2850: p_request_rec IN OE_Order_Pub.Request_Rec_Type,
2851: x_return_status OUT NOCOPY VARCHAR2
2852:
2853: )
2854:
2855: IS
2856:
2857: -- process_order in variables
2858: l_control_rec OE_GLOBALS.Control_Rec_Type;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2856:
2857: -- process_order in variables
2858: l_control_rec OE_GLOBALS.Control_Rec_Type;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2857: -- process_order in variables
2858: l_control_rec OE_GLOBALS.Control_Rec_Type;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2858: l_control_rec OE_GLOBALS.Control_Rec_Type;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2866: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2859: l_header_rec OE_Order_PUB.Header_Rec_Type;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2866: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2867: l_line_count NUMBER;
2860: l_line_rec OE_ORDER_PUB.Line_Rec_Type
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2866: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2867: l_line_count NUMBER;
2868:
2861: := OE_ORDER_PUB.G_MISS_LINE_REC;
2862: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type
2863: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2864: l_line_tbl OE_Order_PUB.Line_Tbl_Type
2865: := OE_ORDER_PUB.G_MISS_LINE_TBL;
2866: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2867: l_line_count NUMBER;
2868:
2869:
2874: l_service_period VARCHAR2(10);
2875:
2876:
2877: l_service_reference_line_id NUMBER;
2878: l_parent_line_rec OE_ORDER_PUB.Line_Rec_Type;
2879: child_line_id NUMBER;
2880: l_line_id NUMBER;
2881:
2882: -- to get the line_id for all childern for the model
2971: IF l_debug_level > 0 THEN
2972: oe_debug_pub.add( 'CSH L_LINE_ID = ' || TO_CHAR ( L_LINE_ID ) , 1 ) ;
2973: END IF;
2974: l_line_count := l_line_count + 1;
2975: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
2976: l_line_rec.line_id := l_line_id;
2977: l_line_tbl(l_line_count) := l_line_rec;
2978:
2979: EXCEPTION -- moved from above for 3128684