[Home] [Help]
PACKAGE: APPS.OKL_CONTRACT_PVT
Source
1 PACKAGE OKL_CONTRACT_PVT AUTHID CURRENT_USER AS
2 /* $Header: OKLCKHRS.pls 120.1 2005/06/29 16:53:29 apaul noship $ */
3
4 subtype khrv_rec_type is OKL_KHR_pvt.khrv_rec_type;
5 subtype khrv_tbl_type is OKL_KHR_pvt.khrv_tbl_type;
6 subtype klev_rec_type is okl_kle_pvt.klev_rec_type;
7 subtype klev_tbl_type is okl_kle_pvt.klev_tbl_type;
8
9 TYPE hdr_tbl_type IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
10 -- GLOBAL VARIABLES
11
12 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_PVT';
13 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
14
15 PROCEDURE create_contract_header(
16 p_api_version IN NUMBER,
17 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18 x_return_status OUT NOCOPY VARCHAR2,
19 x_msg_count OUT NOCOPY NUMBER,
20 x_msg_data OUT NOCOPY VARCHAR2,
21 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
22 p_khrv_rec IN khrv_rec_type,
23 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
24 x_khrv_rec OUT NOCOPY khrv_rec_type);
25
26 PROCEDURE create_contract_header(
27 p_api_version IN NUMBER,
28 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
29 x_return_status OUT NOCOPY VARCHAR2,
30 x_msg_count OUT NOCOPY NUMBER,
31 x_msg_data OUT NOCOPY VARCHAR2,
32 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
33 p_khrv_tbl IN khrv_tbl_type,
34 x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
35 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
36
37 PROCEDURE update_contract_header(
38 p_api_version IN NUMBER,
39 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
40 x_return_status OUT NOCOPY VARCHAR2,
41 x_msg_count OUT NOCOPY NUMBER,
42 x_msg_data OUT NOCOPY VARCHAR2,
43 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
45 p_khrv_rec IN khrv_rec_type,
46 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
47 x_khrv_rec OUT NOCOPY khrv_rec_type);
48
49 PROCEDURE update_contract_header(
50 p_api_version IN NUMBER,
51 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52 x_return_status OUT NOCOPY VARCHAR2,
53 x_msg_count OUT NOCOPY NUMBER,
54 x_msg_data OUT NOCOPY VARCHAR2,
55 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
56 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
57 p_khrv_tbl IN khrv_tbl_type,
58 x_chrv_tbl OUT NOCOPY okl_okc_migration_pvt.chrv_tbl_type,
59 x_khrv_tbl OUT NOCOPY khrv_tbl_type);
60
61 PROCEDURE update_contract_header(
62 p_api_version IN NUMBER,
63 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64 x_return_status OUT NOCOPY VARCHAR2,
65 x_msg_count OUT NOCOPY NUMBER,
66 x_msg_data OUT NOCOPY VARCHAR2,
67 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
69 p_khrv_rec IN khrv_rec_type,
70 p_edit_mode IN VARCHAR2,
71 x_chrv_rec OUT NOCOPY okl_okc_migration_pvt.chrv_rec_type,
72 x_khrv_rec OUT NOCOPY khrv_rec_type);
73
74
75 PROCEDURE delete_contract(
76 p_api_version IN NUMBER,
77 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_contract_id IN okc_k_headers_b.id%type);
82
83 PROCEDURE delete_contract_header(
84 p_api_version IN NUMBER,
85 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
86 x_return_status OUT NOCOPY VARCHAR2,
87 x_msg_count OUT NOCOPY NUMBER,
88 x_msg_data OUT NOCOPY VARCHAR2,
89 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
90 p_khrv_rec IN khrv_rec_type);
91
92 PROCEDURE delete_contract_header(
93 p_api_version IN NUMBER,
94 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
99 p_khrv_tbl IN khrv_tbl_type);
100
101 PROCEDURE lock_contract_header(
102 p_api_version IN NUMBER,
103 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
104 x_return_status OUT NOCOPY VARCHAR2,
105 x_msg_count OUT NOCOPY NUMBER,
106 x_msg_data OUT NOCOPY VARCHAR2,
107 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
108 p_khrv_rec IN khrv_rec_type);
109
110 PROCEDURE lock_contract_header(
111 p_api_version IN NUMBER,
112 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113 x_return_status OUT NOCOPY VARCHAR2,
114 x_msg_count OUT NOCOPY NUMBER,
115 x_msg_data OUT NOCOPY VARCHAR2,
116 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
117 p_khrv_tbl IN khrv_tbl_type);
118
119 PROCEDURE validate_contract_header(
120 p_api_version IN NUMBER,
121 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125 p_chrv_rec IN okl_okc_migration_pvt.chrv_rec_type,
126 p_khrv_rec IN khrv_rec_type);
127
128 PROCEDURE validate_contract_header(
129 p_api_version IN NUMBER,
130 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
131 x_return_status OUT NOCOPY VARCHAR2,
132 x_msg_count OUT NOCOPY NUMBER,
133 x_msg_data OUT NOCOPY VARCHAR2,
134 p_chrv_tbl IN okl_okc_migration_pvt.chrv_tbl_type,
135 p_khrv_tbl IN khrv_tbl_type);
136
137 PROCEDURE create_contract_line(
138 p_api_version IN NUMBER,
139 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
144 p_klev_rec IN klev_rec_type,
145 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
146 x_klev_rec OUT NOCOPY klev_rec_type);
147
148 PROCEDURE create_contract_line(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
155 p_klev_tbl IN klev_tbl_type,
156 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
157 x_klev_tbl OUT NOCOPY klev_tbl_type);
158
159 PROCEDURE update_contract_line(
160 p_api_version IN NUMBER,
161 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
166 p_klev_rec IN klev_rec_type,
167 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
168 x_klev_rec OUT NOCOPY klev_rec_type);
169
170 PROCEDURE update_contract_line(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
177 p_klev_tbl IN klev_tbl_type,
178 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
179 x_klev_tbl OUT NOCOPY klev_tbl_type);
180 ------------------------
181 --Bug# 2525554 start
182 ------------------------
183 PROCEDURE update_contract_line(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
190 p_klev_rec IN klev_rec_type,
191 p_edit_mode IN VARCHAR2,
192 x_clev_rec OUT NOCOPY okl_okc_migration_pvt.clev_rec_type,
193 x_klev_rec OUT NOCOPY klev_rec_type);
194
195 PROCEDURE update_contract_line(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
202 p_klev_tbl IN klev_tbl_type,
203 p_edit_mode IN VARCHAR2,
204 x_clev_tbl OUT NOCOPY okl_okc_migration_pvt.clev_tbl_type,
205 x_klev_tbl OUT NOCOPY klev_tbl_type);
206
207 ------------------------
208 --Bug# 2525554 end
209 ------------------------
210
211 PROCEDURE delete_contract_line(
212 p_api_version IN NUMBER,
213 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
218 p_klev_rec IN klev_rec_type);
219
220 PROCEDURE delete_contract_line(
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_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
227 p_klev_tbl IN klev_tbl_type);
228
229 PROCEDURE delete_contract_line(
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_line_id IN NUMBER);
236
237 PROCEDURE delete_contract_line(
238 p_api_version IN NUMBER,
239 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
240 x_return_status OUT NOCOPY VARCHAR2,
241 x_msg_count OUT NOCOPY NUMBER,
242 x_msg_data OUT NOCOPY VARCHAR2,
243 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
244 p_klev_rec IN klev_rec_type,
245 p_delete_cascade_yn IN VARCHAR2);
246
247 PROCEDURE delete_contract_line(
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_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
254 p_klev_tbl IN klev_tbl_type,
255 p_delete_cascade_yn IN varchar2);
256
257
258 PROCEDURE lock_contract_line(
259 p_api_version IN NUMBER,
260 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2,
264 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
265 p_klev_rec IN klev_rec_type);
266
267 PROCEDURE lock_contract_line(
268 p_api_version IN NUMBER,
269 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
270 x_return_status OUT NOCOPY VARCHAR2,
271 x_msg_count OUT NOCOPY NUMBER,
272 x_msg_data OUT NOCOPY VARCHAR2,
273 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
274 p_klev_tbl IN klev_tbl_type);
275
276 PROCEDURE validate_contract_line(
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
279 x_return_status OUT NOCOPY VARCHAR2,
280 x_msg_count OUT NOCOPY NUMBER,
281 x_msg_data OUT NOCOPY VARCHAR2,
282 p_clev_rec IN okl_okc_migration_pvt.clev_rec_type,
283 p_klev_rec IN klev_rec_type);
284
285 PROCEDURE validate_contract_line(
286 p_api_version IN NUMBER,
287 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288 x_return_status OUT NOCOPY VARCHAR2,
289 x_msg_count OUT NOCOPY NUMBER,
290 x_msg_data OUT NOCOPY VARCHAR2,
291 p_clev_tbl IN okl_okc_migration_pvt.clev_tbl_type,
292 p_klev_tbl IN klev_tbl_type);
293
294 PROCEDURE create_governance(
295 p_api_version IN NUMBER,
296 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
297 x_return_status OUT NOCOPY VARCHAR2,
298 x_msg_count OUT NOCOPY NUMBER,
299 x_msg_data OUT NOCOPY VARCHAR2,
300 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
301 x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type);
302
303 PROCEDURE create_governance(
304 p_api_version IN NUMBER,
305 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
306 x_return_status OUT NOCOPY VARCHAR2,
307 x_msg_count OUT NOCOPY NUMBER,
308 x_msg_data OUT NOCOPY VARCHAR2,
309 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
310 x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type);
311
312 PROCEDURE update_governance(
313 p_api_version IN NUMBER,
314 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type,
319 x_gvev_rec OUT NOCOPY okl_okc_migration_pvt.gvev_rec_type);
320
321 PROCEDURE update_governance(
322 p_api_version IN NUMBER,
323 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324 x_return_status OUT NOCOPY VARCHAR2,
325 x_msg_count OUT NOCOPY NUMBER,
326 x_msg_data OUT NOCOPY VARCHAR2,
327 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type,
328 x_gvev_tbl OUT NOCOPY okl_okc_migration_pvt.gvev_tbl_type);
329
330 PROCEDURE delete_governance(
331 p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
337
338 PROCEDURE delete_governance(
339 p_api_version IN NUMBER,
340 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
341 x_return_status OUT NOCOPY VARCHAR2,
342 x_msg_count OUT NOCOPY NUMBER,
343 x_msg_data OUT NOCOPY VARCHAR2,
344 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
345
346 PROCEDURE lock_governance(
347 p_api_version IN NUMBER,
348 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
349 x_return_status OUT NOCOPY VARCHAR2,
350 x_msg_count OUT NOCOPY NUMBER,
351 x_msg_data OUT NOCOPY VARCHAR2,
352 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
353
354 PROCEDURE lock_governance(
355 p_api_version IN NUMBER,
356 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
357 x_return_status OUT NOCOPY VARCHAR2,
358 x_msg_count OUT NOCOPY NUMBER,
359 x_msg_data OUT NOCOPY VARCHAR2,
360 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
361
362 PROCEDURE validate_governance(
363 p_api_version IN NUMBER,
364 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_gvev_rec IN okl_okc_migration_pvt.gvev_rec_type);
369
370 PROCEDURE validate_governance(
371 p_api_version IN NUMBER,
372 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
373 x_return_status OUT NOCOPY VARCHAR2,
374 x_msg_count OUT NOCOPY NUMBER,
375 x_msg_data OUT NOCOPY VARCHAR2,
376 p_gvev_tbl IN okl_okc_migration_pvt.gvev_tbl_type);
377
378 Procedure get_contract_header_info(
379 p_api_version IN NUMBER,
380 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
381 x_return_status OUT NOCOPY VARCHAR2,
382 x_msg_count OUT NOCOPY NUMBER,
383 x_msg_data OUT NOCOPY VARCHAR2,
384 p_chr_id IN NUMBER,
385 p_chr_id_old IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
386 p_orgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
387 p_custId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
388 p_invOrgId IN NUMBER DEFAULT OKL_API.G_MISS_NUM,
389 p_oldOKL_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
390 p_oldOKC_STATUS IN VARCHAR2 DEFAULT OKL_API.G_MISS_CHAR,
391 x_hdr_tbl OUT NOCOPY hdr_tbl_type);
392 /*
393 FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
394 */
395 END OKL_CONTRACT_PVT;