1 PACKAGE OE_VERSION_HISTORY_UTIL AS
2 /* $Header: OEXHVERS.pls 120.1 2005/09/25 02:45:07 lkxu noship $ */
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 PROCEDURE Create_Version_History
11 (p_header_id IN NUMBER
12 ,p_version_number IN NUMBER
13 ,p_phase_change_flag IN VARCHAR2
14 ,p_changed_attribute IN VARCHAR2 := NULL
15 ,x_return_status IN OUT NOCOPY VARCHAR2);
16
17
18 Procedure Get_Transaction_Version(
19 p_header_id IN NUMBER,
20 p_version_number IN NUMBER := NULL,
21 p_phase_change_flag IN VARCHAR2 := NULL,
22 x_header_rec OUT NOCOPY OE_ORDER_PUB.Header_Rec_Type,
23 x_header_adj_tbl OUT NOCOPY OE_ORDER_PUB.Header_Adj_Tbl_Type,
24 x_header_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Header_Scredit_Tbl_Type,
25 x_line_tbl OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type,
26 x_line_adj_tbl OUT NOCOPY OE_ORDER_PUB.Line_Adj_Tbl_Type,
27 x_line_scredit_tbl OUT NOCOPY OE_ORDER_PUB.Line_Scredit_Tbl_Type,
28 x_return_status OUT NOCOPY VARCHAR2);
29
30
31 -- Query_Rows with version_number to query from history tables
32
33 -- Header Query_Row
34 PROCEDURE Query_Row
35 ( p_header_id IN NUMBER,
36 p_version_number IN NUMBER := NULL,
37 p_phase_change_flag IN VARCHAR2 := NULL,
38 x_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type
39 ) ;
40
41 -- Header Adj Query_Row
42 PROCEDURE Query_Row
43 ( p_price_adjustment_id IN NUMBER
44 , p_version_number IN NUMBER := NULL
45 , p_phase_change_flag IN VARCHAR2 := NULL
46 , x_Header_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Header_Adj_Rec_Type
47 );
48
49 -- Header Adj Query_Rows
50 PROCEDURE Query_Rows
51 ( p_price_adjustment_id IN NUMBER :=
52 FND_API.G_MISS_NUM
53 , p_header_id IN NUMBER :=
54 FND_API.G_MISS_NUM
55 , p_version_number IN NUMBER := NULL
56 , p_phase_change_flag IN VARCHAR2 := NULL
57 , x_Header_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Adj_Tbl_Type
58 );
59
60 -- Header SCredit Query_Row
61 PROCEDURE Query_Row
62 ( p_sales_credit_id IN NUMBER,
63 p_version_number IN NUMBER := NULL,
64 p_phase_change_flag IN VARCHAR2 := NULL,
65 x_Header_Scredit_Rec IN OUT NOCOPY OE_Order_PUB.Header_Scredit_Rec_Type
66 ) ;
67
68 -- Header SCredit Query_Rows
69 PROCEDURE Query_Rows
70 ( p_sales_credit_id IN NUMBER :=
71 FND_API.G_MISS_NUM
72 , p_header_id IN NUMBER :=
73 FND_API.G_MISS_NUM
74 , p_version_number IN NUMBER := NULL
75 , p_phase_change_flag IN VARCHAR2 := NULL
76 , x_Header_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Header_Scredit_tbl_Type
77
78 );
79
80 -- Line Query_Row
81 PROCEDURE Query_Row
82 ( p_line_id IN NUMBER
83 , p_version_number IN NUMBER := NULL
84 , p_phase_change_flag IN VARCHAR2 := NULL
85 , x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
86 );
87
88 -- Line Query_Rows
89 PROCEDURE Query_Rows
90 ( p_line_id IN NUMBER :=
91 FND_API.G_MISS_NUM
92 , p_header_id IN NUMBER :=
93 FND_API.G_MISS_NUM
94 , p_line_set_id IN NUMBER :=
95 FND_API.G_MISS_NUM
96 , p_version_number IN NUMBER := NULL
97 , p_phase_change_flag IN VARCHAR2 := NULL
98 , x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type
99 );
100
101 -- Line Adj Query_Row
102 PROCEDURE Query_Row
103 ( p_price_adjustment_id IN NUMBER
104 , p_version_number IN NUMBER := NULL
105 , p_phase_change_flag IN VARCHAR2 := NULL
106 , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
107 );
108
109 -- Line Adj Query_Rows
110 PROCEDURE Query_Rows
111 ( p_price_adjustment_id IN NUMBER :=
112 FND_API.G_MISS_NUM
113 , p_line_id IN NUMBER :=
114 FND_API.G_MISS_NUM
115 , p_Header_id IN NUMBER :=
116 FND_API.G_MISS_NUM
117 , p_version_number IN NUMBER := NULL
118 , p_phase_change_flag IN VARCHAR2 := NULL
119 , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
120 );
121
122 -- Line Scredit Query_Row
123 PROCEDURE Query_Row
124 ( p_sales_credit_id IN NUMBER
125 , p_version_number IN NUMBER := NULL
126 , p_phase_change_flag IN VARCHAR2 := NULL
127 , x_Line_Scredit_rec IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Rec_Type
128 );
129
130 -- Line Scredit Query_Rows
131 PROCEDURE Query_Rows
132 ( p_sales_credit_id IN NUMBER :=
133 FND_API.G_MISS_NUM
134 , p_line_id IN NUMBER :=
135 FND_API.G_MISS_NUM
136 , p_Header_id IN NUMBER :=
137 FND_API.G_MISS_NUM
138 , p_version_number IN NUMBER := NULL
139 , p_phase_change_flag IN VARCHAR2 := NULL
140 , x_Line_Scredit_tbl IN OUT NOCOPY OE_Order_PUB.Line_Scredit_Tbl_Type
141 );
142
143
144 END OE_VERSION_HISTORY_UTIL;