1 PACKAGE OE_VERSION_HISTORY_UTIL AUTHID CURRENT_USER AS
2 /* $Header: OEXHVERS.pls 120.2.12020000.1 2012/06/26 08:43:35 appldev ship $ */
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_VERSION_HISTORY_UTIL';
5
6 --This boolean is used to prevent multiple calls to the database to
7 --determine the current version
8 G_INTERNAL_QUERY BOOLEAN := FALSE;
9
10 --bug 9503990
11 FUNCTION get_status (p_line_id IN NUMBER, p_flow_status_code IN VARCHAR2) RETURN VARCHAR2;
12
13 PROCEDURE Create_Version_History
14 (p_header_id IN NUMBER
15 ,p_version_number IN NUMBER
16 ,p_phase_change_flag IN VARCHAR2
17 ,p_changed_attribute IN VARCHAR2 := NULL
18 ,x_return_status IN OUT NOCOPY VARCHAR2);
19
20
21 Procedure Get_Transaction_Version(
22 p_header_id IN NUMBER,
23 p_version_number IN NUMBER := NULL,
24 p_phase_change_flag IN VARCHAR2 := NULL,
25 x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
26 x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
27 x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
28 x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
29 x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
30 x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
31 x_return_status OUT NOCOPY VARCHAR2);
32
33
34 -- Query_Rows with version_number to query from history tables
35
36 -- Header Query_Row
37 PROCEDURE Query_Row
38 ( p_header_id IN NUMBER,
39 p_version_number IN NUMBER := NULL,
40 p_phase_change_flag IN VARCHAR2 := NULL,
41 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
42 ) ;
43
44 -- Header Adj Query_Row
45 PROCEDURE Query_Row
46 ( p_price_adjustment_id IN NUMBER
47 , p_version_number IN NUMBER := NULL
48 , p_phase_change_flag IN VARCHAR2 := NULL
49 , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
50 );
51
52 -- Header Adj Query_Rows
53 PROCEDURE Query_Rows
54 ( p_price_adjustment_id IN NUMBER :=
55 FND_API.G_MISS_NUM
56 , p_header_id IN NUMBER :=
57 FND_API.G_MISS_NUM
58 , p_version_number IN NUMBER := NULL
59 , p_phase_change_flag IN VARCHAR2 := NULL
60 , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
61 );
62
63 -- Header SCredit Query_Row
64 PROCEDURE Query_Row
65 ( p_sales_credit_id IN NUMBER,
66 p_version_number IN NUMBER := NULL,
67 p_phase_change_flag IN VARCHAR2 := NULL,
68 x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
69 ) ;
70
71 -- Header SCredit Query_Rows
72 PROCEDURE Query_Rows
73 ( p_sales_credit_id IN NUMBER :=
74 FND_API.G_MISS_NUM
75 , p_header_id IN NUMBER :=
76 FND_API.G_MISS_NUM
77 , p_version_number IN NUMBER := NULL
78 , p_phase_change_flag IN VARCHAR2 := NULL
79 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
80
81 );
82
83 -- Line Query_Row
84 PROCEDURE Query_Row
85 ( p_line_id IN NUMBER
86 , p_version_number IN NUMBER := NULL
87 , p_phase_change_flag IN VARCHAR2 := NULL
88 , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
89 );
90
91 -- Line Query_Rows
92 PROCEDURE Query_Rows
93 ( p_line_id IN NUMBER :=
94 FND_API.G_MISS_NUM
95 , p_header_id IN NUMBER :=
96 FND_API.G_MISS_NUM
97 , p_line_set_id IN NUMBER :=
98 FND_API.G_MISS_NUM
99 , p_version_number IN NUMBER := NULL
100 , p_phase_change_flag IN VARCHAR2 := NULL
101 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
102 );
103
104 -- Line Adj Query_Row
105 PROCEDURE Query_Row
106 ( p_price_adjustment_id IN NUMBER
107 , p_version_number IN NUMBER := NULL
108 , p_phase_change_flag IN VARCHAR2 := NULL
109 , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
110 );
111
112 -- Line Adj Query_Rows
113 PROCEDURE Query_Rows
114 ( p_price_adjustment_id IN NUMBER :=
115 FND_API.G_MISS_NUM
116 , p_line_id IN NUMBER :=
117 FND_API.G_MISS_NUM
118 , p_Header_id IN NUMBER :=
119 FND_API.G_MISS_NUM
120 , p_version_number IN NUMBER := NULL
121 , p_phase_change_flag IN VARCHAR2 := NULL
122 , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
123 );
124
125 -- Line Scredit Query_Row
126 PROCEDURE Query_Row
127 ( p_sales_credit_id IN NUMBER
128 , p_version_number IN NUMBER := NULL
129 , p_phase_change_flag IN VARCHAR2 := NULL
130 , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
131 );
132
133 -- Line Scredit Query_Rows
134 PROCEDURE Query_Rows
135 ( p_sales_credit_id IN NUMBER :=
136 FND_API.G_MISS_NUM
137 , p_line_id IN NUMBER :=
138 FND_API.G_MISS_NUM
139 , p_Header_id IN NUMBER :=
140 FND_API.G_MISS_NUM
141 , p_version_number IN NUMBER := NULL
142 , p_phase_change_flag IN VARCHAR2 := NULL
143 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
144 );
145
146
147 END OE_VERSION_HISTORY_UTIL;