1 PACKAGE OKL_AR_EXTENSION_PVT AS
2 /* $Header: OKLCRXHS.pls 120.1 2007/08/06 13:49:55 prasjain noship $ */
3
4 SUBTYPE rxhv_rec_type IS okl_rxh_pvt.rxhv_rec_type;
5 SUBTYPE rxhv_tbl_type IS okl_rxh_pvt.rxhv_tbl_type;
6
7 SUBTYPE rxlv_rec_type IS okl_rxl_pvt.rxlv_rec_type;
8 SUBTYPE rxlv_tbl_type IS okl_rxl_pvt.rxlv_tbl_type;
9 -- Start : PRASJAIN : Bug# 6268782
10 SUBTYPE rxh_rec_type IS okl_rxh_pvt.rxh_rec_type;
11 SUBTYPE rxhl_tbl_type IS okl_rxh_pvt.rxhl_tbl_type;
12
13 SUBTYPE rxl_rec_type IS okl_rxl_pvt.rxl_rec_type;
14 SUBTYPE rxll_tbl_type IS okl_rxl_pvt.rxll_tbl_type;
15 -- End : PRASJAIN : Bug# 6268782
16 ------------------------------------------------------------------------------
17 -- Global Variables
18 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_AR_EXTENSION_PVT';
19 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
20 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
21 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
22 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
23 ------------------------------------------------------------------------------
24 --Global Exception
25 ------------------------------------------------------------------------------
26 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
27 ------------------------------------------------------------------------------
28
29 --Object type procedure for insert
30 PROCEDURE create_rxh_extension(
31 p_api_version IN NUMBER
32 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
33 ,x_return_status OUT NOCOPY VARCHAR2
34 ,x_msg_count OUT NOCOPY NUMBER
35 ,x_msg_data OUT NOCOPY VARCHAR2
36 ,p_rxhv_rec IN rxhv_rec_type
37 ,p_rxlv_tbl IN rxlv_tbl_type
38 ,x_rxhv_rec OUT NOCOPY rxhv_rec_type
39 ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type
40 );
41
42 --Object type procedure for update
43 PROCEDURE update_rxh_extension(
44 p_api_version IN NUMBER
45 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
46 ,x_return_status OUT NOCOPY VARCHAR2
47 ,x_msg_count OUT NOCOPY NUMBER
48 ,x_msg_data OUT NOCOPY VARCHAR2
49 ,p_rxhv_rec IN rxhv_rec_type
50 ,p_rxlv_tbl IN rxlv_tbl_type
51 ,x_rxhv_rec OUT NOCOPY rxhv_rec_type
52 ,x_rxlv_tbl OUT NOCOPY rxlv_tbl_type
53 );
54
55 --Object type procedure for validate
56 PROCEDURE validate_rxh_extension(
57 p_api_version IN NUMBER
58 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
59 ,x_return_status OUT NOCOPY VARCHAR2
60 ,x_msg_count OUT NOCOPY NUMBER
61 ,x_msg_data OUT NOCOPY VARCHAR2
62 ,p_rxhv_rec IN rxhv_rec_type
63 ,p_rxlv_tbl IN rxlv_tbl_type
64 );
65
66
67 --Object type procedure for create
68 PROCEDURE create_rxh_extension(
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_count OUT NOCOPY NUMBER,
73 x_msg_data OUT NOCOPY VARCHAR2,
74 p_rxhv_tbl IN rxhv_tbl_type,
75 x_rxhv_tbl OUT NOCOPY rxhv_tbl_type);
76
77 --Object type procedure for create
78 PROCEDURE create_rxh_extension(
79 p_api_version IN NUMBER,
80 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81 x_return_status OUT NOCOPY VARCHAR2,
82 x_msg_count OUT NOCOPY NUMBER,
83 x_msg_data OUT NOCOPY VARCHAR2,
84 p_rxhv_rec IN rxhv_rec_type,
85 x_rxhv_rec OUT NOCOPY rxhv_rec_type);
86
87 --Object type procedure for lock
88 PROCEDURE lock_rxh_extension(
89 p_api_version IN NUMBER,
90 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_msg_count OUT NOCOPY NUMBER,
93 x_msg_data OUT NOCOPY VARCHAR2,
94 p_rxhv_tbl IN rxhv_tbl_type);
95
96 --Object type procedure for lock
97 PROCEDURE lock_rxh_extension(
98 p_api_version IN NUMBER,
99 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
100 x_return_status OUT NOCOPY VARCHAR2,
101 x_msg_count OUT NOCOPY NUMBER,
102 x_msg_data OUT NOCOPY VARCHAR2,
103 p_rxhv_rec IN rxhv_rec_type);
104
105 --Object type procedure for update
106 PROCEDURE update_rxh_extension(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
109 x_return_status OUT NOCOPY VARCHAR2,
110 x_msg_count OUT NOCOPY NUMBER,
111 x_msg_data OUT NOCOPY VARCHAR2,
112 p_rxhv_tbl IN rxhv_tbl_type,
113 x_rxhv_tbl OUT NOCOPY rxhv_tbl_type);
114
115 --Object type procedure for update
116 PROCEDURE update_rxh_extension(
117 p_api_version IN NUMBER,
118 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
119 x_return_status OUT NOCOPY VARCHAR2,
120 x_msg_count OUT NOCOPY NUMBER,
121 x_msg_data OUT NOCOPY VARCHAR2,
122 p_rxhv_rec IN rxhv_rec_type,
123 x_rxhv_rec OUT NOCOPY rxhv_rec_type);
124
125 --Object type procedure for delete
126 PROCEDURE delete_rxh_extension(
127 p_api_version IN NUMBER,
128 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
129 x_return_status OUT NOCOPY VARCHAR2,
130 x_msg_count OUT NOCOPY NUMBER,
131 x_msg_data OUT NOCOPY VARCHAR2,
132 p_rxhv_tbl IN rxhv_tbl_type);
133
134 --Object type procedure for delete
135 PROCEDURE delete_rxh_extension(
136 p_api_version IN NUMBER,
137 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
138 x_return_status OUT NOCOPY VARCHAR2,
139 x_msg_count OUT NOCOPY NUMBER,
140 x_msg_data OUT NOCOPY VARCHAR2,
141 p_rxhv_rec IN rxhv_rec_type);
142
143 --Object type procedure for validate
144 PROCEDURE validate_rxh_extension(
145 p_api_version IN NUMBER,
146 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
147 x_return_status OUT NOCOPY VARCHAR2,
148 x_msg_count OUT NOCOPY NUMBER,
149 x_msg_data OUT NOCOPY VARCHAR2,
150 p_rxhv_tbl IN rxhv_tbl_type);
151
152 --Object type procedure for validate
153 PROCEDURE validate_rxh_extension(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_rxhv_rec IN rxhv_rec_type);
160
161 --Object type procedure for create
162 PROCEDURE create_rxl_extension(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_rxlv_tbl IN rxlv_tbl_type,
169 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
170
171 --Object type procedure for create
172 PROCEDURE create_rxl_extension(
173 p_api_version IN NUMBER,
174 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
175 x_return_status OUT NOCOPY VARCHAR2,
176 x_msg_count OUT NOCOPY NUMBER,
177 x_msg_data OUT NOCOPY VARCHAR2,
178 p_rxlv_rec IN rxlv_rec_type,
179 x_rxlv_rec OUT NOCOPY rxlv_rec_type);
180
181 --Object type procedure for lock
182 PROCEDURE lock_rxl_extension(
183 p_api_version IN NUMBER,
184 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
185 x_return_status OUT NOCOPY VARCHAR2,
186 x_msg_count OUT NOCOPY NUMBER,
187 x_msg_data OUT NOCOPY VARCHAR2,
188 p_rxlv_tbl IN rxlv_tbl_type);
189
190 --Object type procedure for lock
191 PROCEDURE lock_rxl_extension(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
194 x_return_status OUT NOCOPY VARCHAR2,
195 x_msg_count OUT NOCOPY NUMBER,
196 x_msg_data OUT NOCOPY VARCHAR2,
197 p_rxlv_rec IN rxlv_rec_type);
198
199 --Object type procedure for update
200 PROCEDURE update_rxl_extension(
201 p_api_version IN NUMBER,
202 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
203 x_return_status OUT NOCOPY VARCHAR2,
204 x_msg_count OUT NOCOPY NUMBER,
205 x_msg_data OUT NOCOPY VARCHAR2,
206 p_rxlv_tbl IN rxlv_tbl_type,
207 x_rxlv_tbl OUT NOCOPY rxlv_tbl_type);
208
209 --Object type procedure for update
210 PROCEDURE update_rxl_extension(
211 p_api_version IN NUMBER,
212 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
213 x_return_status OUT NOCOPY VARCHAR2,
214 x_msg_count OUT NOCOPY NUMBER,
215 x_msg_data OUT NOCOPY VARCHAR2,
216 p_rxlv_rec IN rxlv_rec_type,
217 x_rxlv_rec OUT NOCOPY rxlv_rec_type);
218
219 --Object type procedure for delete
220 PROCEDURE delete_rxl_extension(
221 p_api_version IN NUMBER,
222 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223 x_return_status OUT NOCOPY VARCHAR2,
224 x_msg_count OUT NOCOPY NUMBER,
225 x_msg_data OUT NOCOPY VARCHAR2,
226 p_rxlv_tbl IN rxlv_tbl_type);
227
228 --Object type procedure for delete
229 PROCEDURE delete_rxl_extension(
230 p_api_version IN NUMBER,
231 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
232 x_return_status OUT NOCOPY VARCHAR2,
233 x_msg_count OUT NOCOPY NUMBER,
234 x_msg_data OUT NOCOPY VARCHAR2,
235 p_rxlv_rec IN rxlv_rec_type);
236
237 --Object type procedure for validate
238 PROCEDURE validate_rxl_extension(
239 p_api_version IN NUMBER,
240 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
241 x_return_status OUT NOCOPY VARCHAR2,
242 x_msg_count OUT NOCOPY NUMBER,
243 x_msg_data OUT NOCOPY VARCHAR2,
244 p_rxlv_tbl IN rxlv_tbl_type);
245
246 --Object type procedure for validate
247 PROCEDURE validate_rxl_extension(
248 p_api_version IN NUMBER,
249 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
250 x_return_status OUT NOCOPY VARCHAR2,
251 x_msg_count OUT NOCOPY NUMBER,
252 x_msg_data OUT NOCOPY VARCHAR2,
253 p_rxlv_rec IN rxlv_rec_type);
254
255 --Object type procedure for insert
256 --Added for Bug# 6268782 : PRASJAIN
257 PROCEDURE create_rxh_extension(
258 p_api_version IN NUMBER
259 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
260 ,x_return_status OUT NOCOPY VARCHAR2
261 ,x_msg_count OUT NOCOPY NUMBER
262 ,x_msg_data OUT NOCOPY VARCHAR2
263 ,p_rxh_rec IN rxh_rec_type
264 ,p_rxhl_tbl IN rxhl_tbl_type
265 ,x_rxh_rec OUT NOCOPY rxh_rec_type
266 ,x_rxhl_tbl OUT NOCOPY rxhl_tbl_type);
267
268 --Object type procedure for insert
269 --Added for Bug# 6268782 : PRASJAIN
270 PROCEDURE create_rxl_extension(
271 p_api_version IN NUMBER
272 ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
273 ,x_return_status OUT NOCOPY VARCHAR2
274 ,x_msg_count OUT NOCOPY NUMBER
275 ,x_msg_data OUT NOCOPY VARCHAR2
276 ,p_rxl_rec IN rxl_rec_type
277 ,p_rxll_tbl IN rxll_tbl_type
278 ,x_rxl_rec OUT NOCOPY rxl_rec_type
279 ,x_rxll_tbl OUT NOCOPY rxll_tbl_type);
280 END OKL_AR_EXTENSION_PVT;