1: Package OE_SERVICE_UTIL AUTHID CURRENT_USER As
2: /* $Header: OEXUSVCS.pls 120.0.12010000.1 2008/07/25 07:57:52 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SERVICE_UTIL';
5: G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
2: /* $Header: OEXUSVCS.pls 120.0.12010000.1 2008/07/25 07:57:52 appldev ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SERVICE_UTIL';
5: G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SERVICE_UTIL';
5: G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_SERVICE_UTIL';
5: G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
5: G_Header_Rec OE_Order_Pub.Header_Rec_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
6: OE_Order_PUB.G_MISS_HEADER_REC;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
7: G_old_header_rec OE_Order_PUB.Header_Rec_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
8: OE_Order_PUB.G_MISS_HEADER_REC;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
9: G_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
10: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
11: G_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
12: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
13: G_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
14: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
15: G_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
16: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
17: G_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
18: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
19: G_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
20: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
21: G_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
22: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
23: G_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
24: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
25: G_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
26: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
27: G_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
28: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
29: G_line_tbl OE_Order_PUB.Line_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
30: OE_Order_PUB.G_MISS_LINE_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
31: G_old_line_tbl OE_Order_PUB.Line_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
32: OE_Order_PUB.G_MISS_LINE_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
33: G_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
34: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
35: G_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
36: OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
37: G_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
38: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
39: G_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
40: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
41: G_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
42: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
43: G_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
44: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
45: G_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
46: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
47: G_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
48: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
49: G_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
50: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
51: G_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
52: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
53: G_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
54: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
62: OE_Order_PUB.g_miss_request_tbl;
55: G_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type :=
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
62: OE_Order_PUB.g_miss_request_tbl;
63:
56: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
62: OE_Order_PUB.g_miss_request_tbl;
63:
64: -- Following Table will be used for the Records Group for Customer Product
57: G_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
62: OE_Order_PUB.g_miss_request_tbl;
63:
64: -- Following Table will be used for the Records Group for Customer Product
65: -- lchen add reference_number, current_serial_number to fix bug 1529961 4/5/01
58: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
59: G_old_Lot_Serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
60: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL;
61: G_action_request_tbl OE_Order_PUB.request_tbl_type :=
62: OE_Order_PUB.g_miss_request_tbl;
63:
64: -- Following Table will be used for the Records Group for Customer Product
65: -- lchen add reference_number, current_serial_number to fix bug 1529961 4/5/01
66: Type srv_cust_prod_rec IS RECORD(
102: OE_GLOBALS.G_MISS_CONTROL_REC
103: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
105: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
103: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
104: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
105: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
104: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
105: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
105: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
106: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
106: , p_header_rec IN OE_Order_PUB.Header_Rec_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
107: OE_Order_PUB.G_MISS_HEADER_REC
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
108: , p_old_header_rec IN OE_Order_PUB.Header_Rec_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
109: OE_Order_PUB.G_MISS_HEADER_REC
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
110: , p_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
111: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
112: , p_old_Header_Adj_tbl IN OE_Order_PUB.Header_Adj_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
113: OE_Order_PUB.G_MISS_HEADER_ADJ_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
114: , p_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
115: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
116: , p_old_Header_Price_Att_tbl IN OE_Order_PUB.Header_Price_Att_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
117: OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
118: , p_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
119: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
120: , p_old_Header_Adj_Att_tbl IN OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
121: OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
122: , p_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
123: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
124: , p_old_Header_Adj_Assoc_tbl IN OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
125: OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
126: , p_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
127: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
128: , p_old_Header_Scredit_tbl IN OE_Order_PUB.Header_Scredit_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
129: OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
130: , p_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
131: OE_Order_PUB.G_MISS_LINE_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
132: , p_old_line_tbl IN OE_Order_PUB.Line_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
133: OE_Order_PUB.G_MISS_LINE_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
134: , p_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
135: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
136: , p_old_Line_Adj_tbl IN OE_Order_PUB.Line_Adj_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
137: OE_Order_PUB.G_MISS_LINE_ADJ_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
138: , p_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
139: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
140: , p_old_Line_Price_Att_tbl IN OE_Order_PUB.Line_Price_Att_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
141: OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
142: , p_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
143: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
144: , p_old_Line_Adj_Att_tbl IN OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
145: OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
146: , p_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
147: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
148: , p_old_Line_Adj_Assoc_tbl IN OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
149: OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
150: , p_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
151: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
152: , p_old_Line_Scredit_tbl IN OE_Order_PUB.Line_Scredit_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
153: OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
154: , p_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
155: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
163: OE_Order_PUB.g_miss_request_tbl
156: , p_old_Lot_Serial_tbl IN OE_Order_PUB.Lot_Serial_Tbl_Type :=
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
163: OE_Order_PUB.g_miss_request_tbl
164: );
157: OE_Order_PUB.G_MISS_LOT_SERIAL_TBL
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
163: OE_Order_PUB.g_miss_request_tbl
164: );
165:
158: , p_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
163: OE_Order_PUB.g_miss_request_tbl
164: );
165:
166: -- Procedure to Check for the availability of the CRM APIS
159: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
160: , p_old_Lot_Serial_val_tbl IN OE_Order_PUB.Lot_Serial_Val_Tbl_Type :=
161: OE_Order_PUB.G_MISS_LOT_SERIAL_VAL_TBL
162: , p_action_request_tbl IN OE_Order_PUB.request_tbl_type :=
163: OE_Order_PUB.g_miss_request_tbl
164: );
165:
166: -- Procedure to Check for the availability of the CRM APIS
167:
176: --
177:
178: PROCEDURE Get_Service_Duration
179: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
181: );
182:
183: -- Procedure : Get_Service_Attribute
184: --
184: --
185:
186: PROCEDURE Get_Service_Attribute
187: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
188: , p_x_line_rec IN OUT NOCOPY OE_ORDER_PUB.Line_Rec_Type
189: );
190:
191: -- Procedure : Get_Service_Duration Overloaded for Form
192: --
267: p_scope in VARCHAR2,
268: p_result OUT NOCOPY /* file.sql.39 change */ NUMBER );
269:
270: PROCEDURE Update_Service_Lines
271: ( p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type
272: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273: );
274:
275:
275:
276: /* added for bug 1533658 */
277: Procedure CASCADE_CHANGES
278: ( p_parent_line_id IN NUMBER,
279: p_request_rec IN OE_Order_Pub.Request_Rec_Type,
280: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
281: );
282:
283: /* Added for 1799820 */