[Home] [Help]
PACKAGE: APPS.OKC_CONTRACT_PVT
Source
1 PACKAGE OKC_CONTRACT_PVT AS
2 /* $Header: OKCCCHRS.pls 120.4 2005/11/15 03:29:29 maanand noship $ */
3
4 subtype chrv_rec_type is okc_chr_pvt.chrv_rec_type;
5 subtype chrv_tbl_type is okc_chr_pvt.chrv_tbl_type;
6 subtype clev_rec_type is okc_cle_pvt.clev_rec_type;
7 subtype clev_tbl_type is okc_cle_pvt.clev_tbl_type;
8 subtype cacv_rec_type is okc_cac_pvt.cacv_rec_type;
9 subtype cacv_tbl_type is okc_cac_pvt.cacv_tbl_type;
10 subtype cpsv_rec_type is okc_cps_pvt.cpsv_rec_type;
11 subtype cpsv_tbl_type is okc_cps_pvt.cpsv_tbl_type;
12 subtype gvev_rec_type is okc_gve_pvt.gvev_rec_type;
13 subtype gvev_tbl_type is okc_gve_pvt.gvev_tbl_type;
14 subtype cvmv_rec_type is okc_cvm_pvt.cvmv_rec_type;
15 subtype cvmv_tbl_type is okc_cvm_pvt.cvmv_tbl_type;
16 subtype control_rec_type is okc_util.okc_control_rec_type;
17
18 ---------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ---------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PVT';
22 ---------------------------------------------------------------------------
23
24 PROCEDURE GENERATE_CONTRACT_NUMBER(
25 p_scs_code IN VARCHAR2,
26 p_modifier IN VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_contract_number IN OUT NOCOPY OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE);
29
30 FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2;
31
32 PROCEDURE create_contract_header(
33 p_api_version IN NUMBER,
34 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35 x_return_status OUT NOCOPY VARCHAR2,
36 x_msg_count OUT NOCOPY NUMBER,
37 x_msg_data OUT NOCOPY VARCHAR2,
38 p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
39 x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type,
40 p_check_access IN VARCHAR2 DEFAULT 'N');
41
42 PROCEDURE create_contract_header(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
49 x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type,
50 p_check_access IN VARCHAR2 DEFAULT 'N');
51
52 PROCEDURE update_contract_header(
53 p_api_version IN NUMBER,
54 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55 x_return_status OUT NOCOPY VARCHAR2,
56 x_msg_count OUT NOCOPY NUMBER,
57 x_msg_data OUT NOCOPY VARCHAR2,
58 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
60 x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type);
61
62
63 PROCEDURE update_contract_header(
64 p_api_version IN NUMBER,
65 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
66 x_return_status OUT NOCOPY VARCHAR2,
67 x_msg_count OUT NOCOPY NUMBER,
68 x_msg_data OUT NOCOPY VARCHAR2,
69 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type,
71 x_chrv_tbl OUT NOCOPY OKC_CHR_PVT.chrv_tbl_type);
72
73 PROCEDURE update_contract_header(
74 p_api_version IN NUMBER,
75 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
76 x_return_status OUT NOCOPY VARCHAR2,
77 x_msg_count OUT NOCOPY NUMBER,
78 x_msg_data OUT NOCOPY VARCHAR2,
79 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
80 p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type,
81 p_control_rec IN control_rec_type,
82 x_chrv_rec OUT NOCOPY OKC_CHR_PVT.chrv_rec_type);
83
84 PROCEDURE delete_contract_header(
85 p_api_version IN NUMBER,
86 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
87 x_return_status OUT NOCOPY VARCHAR2,
88 x_msg_count OUT NOCOPY NUMBER,
89 x_msg_data OUT NOCOPY VARCHAR2,
90 p_chrv_rec IN OKC_CHR_PVT.chrv_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 OKC_CHR_PVT.chrv_tbl_type);
99
100 PROCEDURE lock_contract_header(
101 p_api_version IN NUMBER,
102 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
103 x_return_status OUT NOCOPY VARCHAR2,
104 x_msg_count OUT NOCOPY NUMBER,
105 x_msg_data OUT NOCOPY VARCHAR2,
106 p_chrv_rec IN OKC_CHR_PVT.chrv_rec_type);
107
108 PROCEDURE lock_contract_header(
109 p_api_version IN NUMBER,
110 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
111 x_return_status OUT NOCOPY VARCHAR2,
112 x_msg_count OUT NOCOPY NUMBER,
113 x_msg_data OUT NOCOPY VARCHAR2,
114 p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type);
115
116 PROCEDURE validate_contract_header(
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_chrv_rec IN OKC_CHR_PVT.chrv_rec_type);
123
124 PROCEDURE validate_contract_header(
125 p_api_version IN NUMBER,
126 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_chrv_tbl IN OKC_CHR_PVT.chrv_tbl_type);
131
132 PROCEDURE create_ancestry(
133 p_api_version IN NUMBER,
134 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_clev_rec IN OKC_CLE_PVT.clev_rec_type);
139
140 PROCEDURE create_contract_line(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_restricted_update IN VARCHAR2 DEFAULT 'F',
147 p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
148 x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type);
149
150 PROCEDURE create_contract_line(
151 p_api_version IN NUMBER,
152 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153 x_return_status OUT NOCOPY VARCHAR2,
154 x_msg_count OUT NOCOPY NUMBER,
155 x_msg_data OUT NOCOPY VARCHAR2,
156 p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
157 x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_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_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
166 p_clev_rec IN OKC_CLE_PVT.clev_rec_type,
167 x_clev_rec OUT NOCOPY OKC_CLE_PVT.clev_rec_type);
168
169 PROCEDURE update_contract_line(
170 p_api_version IN NUMBER,
171 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
172 x_return_status OUT NOCOPY VARCHAR2,
173 x_msg_count OUT NOCOPY NUMBER,
174 x_msg_data OUT NOCOPY VARCHAR2,
175 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
176 p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type,
177 x_clev_tbl OUT NOCOPY OKC_CLE_PVT.clev_tbl_type);
178
179 PROCEDURE delete_contract_line(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type);
186
187 PROCEDURE delete_contract_line(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_clev_rec IN OKC_CLE_PVT.clev_rec_type);
194
195 PROCEDURE delete_contract_line(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_line_id IN NUMBER);
202
203 PROCEDURE force_delete_contract_line(
204 p_api_version IN NUMBER,
205 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
206 x_return_status OUT NOCOPY VARCHAR2,
207 x_msg_count OUT NOCOPY NUMBER,
208 x_msg_data OUT NOCOPY VARCHAR2,
209 p_line_id IN NUMBER);
210
211 PROCEDURE delete_ancestry(
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_cle_id IN NUMBER);
218
219 PROCEDURE lock_contract_line(
220 p_api_version IN NUMBER,
221 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
222 x_return_status OUT NOCOPY VARCHAR2,
223 x_msg_count OUT NOCOPY NUMBER,
224 x_msg_data OUT NOCOPY VARCHAR2,
225 p_clev_rec IN OKC_CLE_PVT.clev_rec_type);
226
227 PROCEDURE lock_contract_line(
228 p_api_version IN NUMBER,
229 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233 p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type);
234
235 PROCEDURE validate_contract_line(
236 p_api_version IN NUMBER,
237 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238 x_return_status OUT NOCOPY VARCHAR2,
239 x_msg_count OUT NOCOPY NUMBER,
240 x_msg_data OUT NOCOPY VARCHAR2,
241 p_clev_rec IN OKC_CLE_PVT.clev_rec_type);
242
243 PROCEDURE validate_contract_line(
244 p_api_version IN NUMBER,
245 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246 x_return_status OUT NOCOPY VARCHAR2,
247 x_msg_count OUT NOCOPY NUMBER,
248 x_msg_data OUT NOCOPY VARCHAR2,
249 p_clev_tbl IN OKC_CLE_PVT.clev_tbl_type);
250
251 PROCEDURE create_governance(
252 p_api_version IN NUMBER,
253 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
254 x_return_status OUT NOCOPY VARCHAR2,
255 x_msg_count OUT NOCOPY NUMBER,
256 x_msg_data OUT NOCOPY VARCHAR2,
257 p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
258 x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type);
259
260 PROCEDURE create_governance(
261 p_api_version IN NUMBER,
262 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
263 x_return_status OUT NOCOPY VARCHAR2,
264 x_msg_count OUT NOCOPY NUMBER,
265 x_msg_data OUT NOCOPY VARCHAR2,
266 p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
267 x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type);
268
269 PROCEDURE update_governance(
270 p_api_version IN NUMBER,
271 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272 x_return_status OUT NOCOPY VARCHAR2,
273 x_msg_count OUT NOCOPY NUMBER,
274 x_msg_data OUT NOCOPY VARCHAR2,
275 p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type,
276 x_gvev_rec OUT NOCOPY OKC_GVE_PVT.gvev_rec_type);
277
278 PROCEDURE update_governance(
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type,
285 x_gvev_tbl OUT NOCOPY OKC_GVE_PVT.gvev_tbl_type);
286
287 PROCEDURE delete_governance(
288 p_api_version IN NUMBER,
289 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
290 x_return_status OUT NOCOPY VARCHAR2,
291 x_msg_count OUT NOCOPY NUMBER,
292 x_msg_data OUT NOCOPY VARCHAR2,
293 p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type);
294
295 PROCEDURE delete_governance(
296 p_api_version IN NUMBER,
297 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
298 x_return_status OUT NOCOPY VARCHAR2,
299 x_msg_count OUT NOCOPY NUMBER,
300 x_msg_data OUT NOCOPY VARCHAR2,
301 p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type);
302
303 PROCEDURE lock_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_rec IN OKC_GVE_PVT.gvev_rec_type);
310
311 PROCEDURE lock_governance(
312 p_api_version IN NUMBER,
313 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
314 x_return_status OUT NOCOPY VARCHAR2,
315 x_msg_count OUT NOCOPY NUMBER,
316 x_msg_data OUT NOCOPY VARCHAR2,
317 p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type);
318
319 PROCEDURE validate_governance(
320 p_api_version IN NUMBER,
321 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
322 x_return_status OUT NOCOPY VARCHAR2,
323 x_msg_count OUT NOCOPY NUMBER,
324 x_msg_data OUT NOCOPY VARCHAR2,
325 p_gvev_rec IN OKC_GVE_PVT.gvev_rec_type);
326
327 PROCEDURE validate_governance(
328 p_api_version IN NUMBER,
329 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
330 x_return_status OUT NOCOPY VARCHAR2,
331 x_msg_count OUT NOCOPY NUMBER,
332 x_msg_data OUT NOCOPY VARCHAR2,
333 p_gvev_tbl IN OKC_GVE_PVT.gvev_tbl_type);
334
335 PROCEDURE create_contract_process(
336 p_api_version IN NUMBER,
337 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
342 x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type);
343
344 PROCEDURE create_contract_process(
345 p_api_version IN NUMBER,
346 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
347 x_return_status OUT NOCOPY VARCHAR2,
348 x_msg_count OUT NOCOPY NUMBER,
349 x_msg_data OUT NOCOPY VARCHAR2,
350 p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
351 x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type);
352
353 PROCEDURE update_contract_process(
354 p_api_version IN NUMBER,
355 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
356 x_return_status OUT NOCOPY VARCHAR2,
357 x_msg_count OUT NOCOPY NUMBER,
358 x_msg_data OUT NOCOPY VARCHAR2,
359 p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type,
360 x_cpsv_rec OUT NOCOPY OKC_CPS_PVT.cpsv_rec_type);
361
362 PROCEDURE update_contract_process(
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_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type,
369 x_cpsv_tbl OUT NOCOPY OKC_CPS_PVT.cpsv_tbl_type);
370
371 PROCEDURE delete_contract_process(
372 p_api_version IN NUMBER,
373 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
374 x_return_status OUT NOCOPY VARCHAR2,
375 x_msg_count OUT NOCOPY NUMBER,
376 x_msg_data OUT NOCOPY VARCHAR2,
377 p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type);
378
379 PROCEDURE delete_contract_process(
380 p_api_version IN NUMBER,
381 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
382 x_return_status OUT NOCOPY VARCHAR2,
383 x_msg_count OUT NOCOPY NUMBER,
384 x_msg_data OUT NOCOPY VARCHAR2,
385 p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type);
386
387 PROCEDURE lock_contract_process(
388 p_api_version IN NUMBER,
389 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
390 x_return_status OUT NOCOPY VARCHAR2,
391 x_msg_count OUT NOCOPY NUMBER,
392 x_msg_data OUT NOCOPY VARCHAR2,
393 p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type);
394
395 PROCEDURE lock_contract_process(
396 p_api_version IN NUMBER,
397 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
398 x_return_status OUT NOCOPY VARCHAR2,
399 x_msg_count OUT NOCOPY NUMBER,
400 x_msg_data OUT NOCOPY VARCHAR2,
401 p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type);
402
403 PROCEDURE validate_contract_process(
404 p_api_version IN NUMBER,
405 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
406 x_return_status OUT NOCOPY VARCHAR2,
407 x_msg_count OUT NOCOPY NUMBER,
408 x_msg_data OUT NOCOPY VARCHAR2,
409 p_cpsv_rec IN OKC_CPS_PVT.cpsv_rec_type);
410
411 PROCEDURE validate_contract_process(
412 p_api_version IN NUMBER,
413 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
414 x_return_status OUT NOCOPY VARCHAR2,
415 x_msg_count OUT NOCOPY NUMBER,
416 x_msg_data OUT NOCOPY VARCHAR2,
417 p_cpsv_tbl IN OKC_CPS_PVT.cpsv_tbl_type);
418
419 PROCEDURE create_contract_access(
420 p_api_version IN NUMBER,
421 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
422 x_return_status OUT NOCOPY VARCHAR2,
423 x_msg_count OUT NOCOPY NUMBER,
424 x_msg_data OUT NOCOPY VARCHAR2,
425 p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
426 x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type);
427
428 PROCEDURE create_contract_access(
429 p_api_version IN NUMBER,
430 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
431 x_return_status OUT NOCOPY VARCHAR2,
432 x_msg_count OUT NOCOPY NUMBER,
433 x_msg_data OUT NOCOPY VARCHAR2,
434 p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
435 x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type);
436
437 PROCEDURE update_contract_access(
438 p_api_version IN NUMBER,
439 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
440 x_return_status OUT NOCOPY VARCHAR2,
441 x_msg_count OUT NOCOPY NUMBER,
442 x_msg_data OUT NOCOPY VARCHAR2,
443 p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type,
444 x_cacv_rec OUT NOCOPY OKC_CAC_PVT.cacv_rec_type);
445
446 PROCEDURE update_contract_access(
447 p_api_version IN NUMBER,
448 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
449 x_return_status OUT NOCOPY VARCHAR2,
450 x_msg_count OUT NOCOPY NUMBER,
451 x_msg_data OUT NOCOPY VARCHAR2,
452 p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type,
453 x_cacv_tbl OUT NOCOPY OKC_CAC_PVT.cacv_tbl_type);
454
455 PROCEDURE delete_contract_access(
456 p_api_version IN NUMBER,
457 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
458 x_return_status OUT NOCOPY VARCHAR2,
459 x_msg_count OUT NOCOPY NUMBER,
460 x_msg_data OUT NOCOPY VARCHAR2,
461 p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type);
462
463 PROCEDURE delete_contract_access(
464 p_api_version IN NUMBER,
465 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
466 x_return_status OUT NOCOPY VARCHAR2,
467 x_msg_count OUT NOCOPY NUMBER,
468 x_msg_data OUT NOCOPY VARCHAR2,
469 p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type);
470
471 PROCEDURE lock_contract_access(
472 p_api_version IN NUMBER,
473 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
474 x_return_status OUT NOCOPY VARCHAR2,
475 x_msg_count OUT NOCOPY NUMBER,
476 x_msg_data OUT NOCOPY VARCHAR2,
477 p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type);
478
479 PROCEDURE lock_contract_access(
480 p_api_version IN NUMBER,
481 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
482 x_return_status OUT NOCOPY VARCHAR2,
483 x_msg_count OUT NOCOPY NUMBER,
484 x_msg_data OUT NOCOPY VARCHAR2,
485 p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type);
486
487 PROCEDURE validate_contract_access(
488 p_api_version IN NUMBER,
489 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
490 x_return_status OUT NOCOPY VARCHAR2,
491 x_msg_count OUT NOCOPY NUMBER,
492 x_msg_data OUT NOCOPY VARCHAR2,
493 p_cacv_rec IN OKC_CAC_PVT.cacv_rec_type);
494
495 PROCEDURE validate_contract_access(
496 p_api_version IN NUMBER,
497 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
498 x_return_status OUT NOCOPY VARCHAR2,
499 x_msg_count OUT NOCOPY NUMBER,
500 x_msg_data OUT NOCOPY VARCHAR2,
501 p_cacv_tbl IN OKC_CAC_PVT.cacv_tbl_type);
502
503 PROCEDURE add_language;
504
505 PROCEDURE Get_Active_Process (
506 p_api_version IN NUMBER,
507 p_init_msg_list IN VARCHAR2,
508 x_return_status OUT NOCOPY VARCHAR2,
509 x_msg_count OUT NOCOPY NUMBER,
510 x_msg_data OUT NOCOPY VARCHAR2,
511 p_contract_number IN VARCHAR2,
512 p_contract_number_modifier IN VARCHAR2,
513 x_wf_name OUT NOCOPY VARCHAR2,
514 x_wf_process_name OUT NOCOPY VARCHAR2,
515 x_package_name OUT NOCOPY VARCHAR2,
516 x_procedure_name OUT NOCOPY VARCHAR2,
517 x_usage OUT NOCOPY VARCHAR2);
518
519 FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
520
521 --added by smhanda for renew and status related changes
522
523 PROCEDURE CLEAN_REN_LINKS(
524 p_api_version IN NUMBER,
525 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
526 x_return_status OUT NOCOPY VARCHAR2,
527 x_msg_count OUT NOCOPY NUMBER,
528 x_msg_data OUT NOCOPY VARCHAR2,
529 p_target_chr_id IN number,
530 clean_relink_flag IN VARCHAR2 DEFAULT 'CLEAN');
531
532 /*
533 PROCEDURE CLEAN_REN_COPY(
534 p_api_version IN NUMBER,
535 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
536 x_return_status OUT NOCOPY VARCHAR2,
537 x_msg_count OUT NOCOPY NUMBER,
538 x_msg_data OUT NOCOPY VARCHAR2,
539 p_chr_id IN number);
540 */
541
542 PROCEDURE RELINK_RENEW(
543 p_api_version IN NUMBER,
544 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
545 x_return_status OUT NOCOPY VARCHAR2,
546 x_msg_count OUT NOCOPY NUMBER,
547 x_msg_data OUT NOCOPY VARCHAR2,
548 p_target_chr_id IN number);
549
550 --end added by smhanda
551
552 FUNCTION Is_Process_Active(p_chr_id IN NUMBER) RETURN VARCHAR2;
553
554 --For Bug.No.1789860, Function Get_concat_line_no is added.
555
556 FUNCTIOn Get_concat_line_no(p_cle_id IN NUMBER,
557 x_return_status OUT NOCOPY VARCHAR2)
558 RETURN VARCHAR2;
559
560
561 --[llc] Update Contract Amount
562
563 /*
564 The Header and Line Amounts should be updated when Change Status action is taken
565 at the header/line/subline level. This is to ensure that the calualated amounts
566 (price_negotiated, cancelled_amount, estimated_amount) ignores cancelled lines/sublines.
567
568 A new procedure Update_Contract_Amount is define which is called
569 when cancel actions is taken at header/line/subline level.
570
571 */
572
573 PROCEDURE UPDATE_CONTRACT_AMOUNT (
574 p_api_version IN NUMBER,
575 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
576 p_id IN NUMBER,
577 p_from_ste_code IN VARCHAR2,
578 p_to_ste_code IN VARCHAR2,
579 p_cle_id IN NUMBER,
580 x_return_status OUT NOCOPY VARCHAR2,
581 x_msg_count OUT NOCOPY NUMBER,
582 x_msg_data OUT NOCOPY VARCHAR2 );
583
584
585 --[llc] Cancellation Amount Calculation
586
587 /*
588 These functions [ Get_hdr_cancelled_amount() and Get_line_cancelled_amount() ]
589 calculates the cancelled amounts for a contract or a contract line.
590 Cancellation amount is exclusive of the tax amount.
591
592 These functions are defined to be called from post_query of oks_headers and oks_lines respectively.
593 This will populate the appropriate fields on the form.
594 */
595
596
597 FUNCTION Get_hdr_cancelled_amount (p_id in Number) RETURN NUMBER;
598
599 FUNCTION Get_line_cancelled_amount (p_cle_id in Number, p_id in Number) RETURN NUMBER;
600
601
602 --[llc] Procedure to clear/relink renewal links
603
604 Procedure Line_Renewal_links (
605 p_api_version IN NUMBER,
606 x_return_status OUT NOCOPY VARCHAR2,
607 x_msg_count OUT NOCOPY NUMBER,
608 x_msg_data OUT NOCOPY VARCHAR2,
609 p_target_chr_id IN NUMBER ,
610 p_target_line_id IN NUMBER ,
611 clean_relink_flag IN VARCHAR2 default 'CLEAN');
612
613
614
615 END OKC_CONTRACT_PVT;