[Home] [Help]
PACKAGE: APPS.OKC_CONTRACT_PUB
Source
1 PACKAGE OKC_CONTRACT_PUB AUTHID CURRENT_USER AS
2 /* $Header: OKCPCHRS.pls 120.3 2005/07/19 05:11:29 maanand noship $ */
3
4 -- Define record/table type for the amount manipulations in Authoring form
5 TYPE Price_Table_Record IS RECORD (
6 ID NUMBER,
7 CLE_ID NUMBER,
8 LEVEL NUMBER,
9 AMOUNT NUMBER,
10 EXT_AMOUNT NUMBER,
11 NGT_AMOUNT NUMBER,
12 PRICED_YN VARCHAR2(1)
13 );
14
15 TYPE Price_Table_Type IS TABLE OF Price_Table_Record
16 INDEX BY BINARY_INTEGER;
17
18 subtype chrv_rec_type is okc_contract_pvt.chrv_rec_type;
19 subtype chrv_tbl_type is okc_contract_pvt.chrv_tbl_type;
20 subtype clev_rec_type is okc_contract_pvt.clev_rec_type;
21 subtype clev_tbl_type is okc_contract_pvt.clev_tbl_type;
22 subtype cacv_rec_type is okc_contract_pvt.cacv_rec_type;
23 subtype cacv_tbl_type is okc_contract_pvt.cacv_tbl_type;
24 subtype cpsv_rec_type is okc_contract_pvt.cpsv_rec_type;
25 subtype cpsv_tbl_type is okc_contract_pvt.cpsv_tbl_type;
26 subtype gvev_rec_type is okc_contract_pvt.gvev_rec_type;
27 subtype gvev_tbl_type is okc_contract_pvt.gvev_tbl_type;
28 subtype cvmv_rec_type is okc_contract_pvt.cvmv_rec_type;
29 subtype cvmv_tbl_type is okc_contract_pvt.cvmv_tbl_type;
30 subtype control_rec_type is okc_util.okc_control_rec_type;
31
32 -- Global variables for user hooks
33 g_pkg_name CONSTANT VARCHAR2(200) := 'OKC_CONTRACT_PUB';
34 g_app_name CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
35
36 g_chrv_rec chrv_rec_type;
37 g_chrv_tbl chrv_tbl_type;
38 g_clev_rec clev_rec_type;
39 g_clev_tbl clev_tbl_type;
40 g_cacv_rec cacv_rec_type;
41 g_cacv_tbl cacv_tbl_type;
42 g_cpsv_rec cpsv_rec_type;
43 g_cpsv_tbl cpsv_tbl_type;
44 g_gvev_rec gvev_rec_type;
45 g_gvev_tbl gvev_tbl_type;
46
47 PROCEDURE create_contract_header(
48 p_api_version IN NUMBER,
49 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
50 x_return_status OUT NOCOPY VARCHAR2,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2,
53 p_chrv_rec IN chrv_rec_type,
54 x_chrv_rec OUT NOCOPY chrv_rec_type,
55 p_check_access IN VARCHAR2 DEFAULT 'N');
56
57
58 PROCEDURE create_contract_header(
59 p_api_version IN NUMBER,
60 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
61 x_return_status OUT NOCOPY VARCHAR2,
62 x_msg_count OUT NOCOPY NUMBER,
63 x_msg_data OUT NOCOPY VARCHAR2,
64 p_chrv_tbl IN chrv_tbl_type,
65 x_chrv_tbl OUT NOCOPY chrv_tbl_type,
66 p_check_access IN VARCHAR2 DEFAULT 'N');
67
68 PROCEDURE update_contract_header(
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_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 p_chrv_rec IN chrv_rec_type,
76 x_chrv_rec OUT NOCOPY chrv_rec_type);
77
78 PROCEDURE update_contract_header(
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_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
85 p_chrv_tbl IN chrv_tbl_type,
86 x_chrv_tbl OUT NOCOPY chrv_tbl_type);
87
88 PROCEDURE update_contract_header(
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_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
95 p_chrv_rec IN chrv_rec_type,
96 p_control_rec IN control_rec_type,
97 x_chrv_rec OUT NOCOPY chrv_rec_type);
98
99 PROCEDURE update_contract_header(
100 p_api_version IN NUMBER,
101 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
102 x_return_status OUT NOCOPY VARCHAR2,
103 x_msg_count OUT NOCOPY NUMBER,
104 x_msg_data OUT NOCOPY VARCHAR2,
105 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
106 p_chrv_tbl IN chrv_tbl_type,
107 p_control_rec IN control_rec_type,
108 x_chrv_tbl OUT NOCOPY chrv_tbl_type);
109
110 PROCEDURE delete_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_rec IN chrv_rec_type);
117
118 PROCEDURE delete_contract_header(
119 p_api_version IN NUMBER,
120 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
121 x_return_status OUT NOCOPY VARCHAR2,
122 x_msg_count OUT NOCOPY NUMBER,
123 x_msg_data OUT NOCOPY VARCHAR2,
124 p_chrv_tbl IN chrv_tbl_type);
125
126 PROCEDURE lock_contract_header(
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_chrv_rec IN chrv_rec_type);
133
134 PROCEDURE lock_contract_header(
135 p_api_version IN NUMBER,
136 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137 x_return_status OUT NOCOPY VARCHAR2,
138 x_msg_count OUT NOCOPY NUMBER,
139 x_msg_data OUT NOCOPY VARCHAR2,
140 p_chrv_tbl IN chrv_tbl_type);
141
142 PROCEDURE validate_contract_header(
143 p_api_version IN NUMBER,
144 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
145 x_return_status OUT NOCOPY VARCHAR2,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2,
148 p_chrv_rec IN chrv_rec_type);
149
150 PROCEDURE validate_contract_header(
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_chrv_tbl IN chrv_tbl_type);
157
158 -- The p_restricted_update i sdefaulted to 'F' as it is added
159 -- in a later stage and not to error out current create_contract_line
160 -- calls from forms
161 --
162 PROCEDURE create_contract_line(
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_restricted_update IN VARCHAR2 DEFAULT 'F',
169 p_clev_rec IN clev_rec_type,
170 x_clev_rec OUT NOCOPY clev_rec_type);
171
172 PROCEDURE create_contract_line(
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_restricted_update IN VARCHAR2 DEFAULT 'F',
179 p_clev_tbl IN clev_tbl_type,
180 x_clev_tbl OUT NOCOPY clev_tbl_type);
181
182 PROCEDURE update_contract_line(
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_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
189 p_clev_rec IN clev_rec_type,
190 x_clev_rec OUT NOCOPY clev_rec_type);
191
192 PROCEDURE update_contract_line(
193 p_api_version IN NUMBER,
194 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
195 x_return_status OUT NOCOPY VARCHAR2,
196 x_msg_count OUT NOCOPY NUMBER,
197 x_msg_data OUT NOCOPY VARCHAR2,
198 p_restricted_update IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
199 p_clev_tbl IN clev_tbl_type,
200 x_clev_tbl OUT NOCOPY clev_tbl_type);
201
202 PROCEDURE delete_contract_line(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
205 x_return_status OUT NOCOPY VARCHAR2,
206 x_msg_count OUT NOCOPY NUMBER,
207 x_msg_data OUT NOCOPY VARCHAR2,
208 p_clev_rec IN clev_rec_type);
209
210 PROCEDURE delete_contract_line(
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_clev_tbl IN clev_tbl_type);
217
218 PROCEDURE delete_contract_line(
219 p_api_version IN NUMBER,
220 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
221 x_return_status OUT NOCOPY VARCHAR2,
222 x_msg_count OUT NOCOPY NUMBER,
223 x_msg_data OUT NOCOPY VARCHAR2,
224 p_line_id IN NUMBER);
225
226 PROCEDURE lock_contract_line(
227 p_api_version IN NUMBER,
228 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229 x_return_status OUT NOCOPY VARCHAR2,
230 x_msg_count OUT NOCOPY NUMBER,
231 x_msg_data OUT NOCOPY VARCHAR2,
232 p_clev_rec IN clev_rec_type);
233
234 PROCEDURE lock_contract_line(
235 p_api_version IN NUMBER,
236 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
237 x_return_status OUT NOCOPY VARCHAR2,
238 x_msg_count OUT NOCOPY NUMBER,
239 x_msg_data OUT NOCOPY VARCHAR2,
240 p_clev_tbl IN clev_tbl_type);
241
242 PROCEDURE validate_contract_line(
243 p_api_version IN NUMBER,
244 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
245 x_return_status OUT NOCOPY VARCHAR2,
246 x_msg_count OUT NOCOPY NUMBER,
247 x_msg_data OUT NOCOPY VARCHAR2,
248 p_clev_rec IN clev_rec_type);
249
250 PROCEDURE validate_contract_line(
251 p_api_version IN NUMBER,
252 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_clev_tbl IN clev_tbl_type);
257
258 PROCEDURE create_governance(
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_gvev_rec IN gvev_rec_type,
265 x_gvev_rec OUT NOCOPY gvev_rec_type);
266
267 PROCEDURE create_governance(
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_gvev_tbl IN gvev_tbl_type,
274 x_gvev_tbl OUT NOCOPY gvev_tbl_type);
275
276 PROCEDURE update_governance(
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_gvev_rec IN gvev_rec_type,
283 x_gvev_rec OUT NOCOPY gvev_rec_type);
284
285 PROCEDURE update_governance(
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_gvev_tbl IN gvev_tbl_type,
292 x_gvev_tbl OUT NOCOPY gvev_tbl_type);
293
294 PROCEDURE delete_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 gvev_rec_type);
301
302 PROCEDURE delete_governance(
303 p_api_version IN NUMBER,
304 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
305 x_return_status OUT NOCOPY VARCHAR2,
306 x_msg_count OUT NOCOPY NUMBER,
307 x_msg_data OUT NOCOPY VARCHAR2,
308 p_gvev_tbl IN gvev_tbl_type);
309
310 PROCEDURE lock_governance(
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 p_gvev_rec IN gvev_rec_type);
317
318 PROCEDURE lock_governance(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_gvev_tbl IN gvev_tbl_type);
325
326 PROCEDURE validate_governance(
327 p_api_version IN NUMBER,
328 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
329 x_return_status OUT NOCOPY VARCHAR2,
330 x_msg_count OUT NOCOPY NUMBER,
331 x_msg_data OUT NOCOPY VARCHAR2,
332 p_gvev_rec IN gvev_rec_type);
333
334 PROCEDURE validate_governance(
335 p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
337 x_return_status OUT NOCOPY VARCHAR2,
338 x_msg_count OUT NOCOPY NUMBER,
339 x_msg_data OUT NOCOPY VARCHAR2,
340 p_gvev_tbl IN gvev_tbl_type);
341
342 PROCEDURE create_contract_process(
343 p_api_version IN NUMBER,
344 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
345 x_return_status OUT NOCOPY VARCHAR2,
346 x_msg_count OUT NOCOPY NUMBER,
347 x_msg_data OUT NOCOPY VARCHAR2,
348 p_cpsv_rec IN cpsv_rec_type,
349 x_cpsv_rec OUT NOCOPY cpsv_rec_type);
350
351 PROCEDURE create_contract_process(
352 p_api_version IN NUMBER,
353 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2,
357 p_cpsv_tbl IN cpsv_tbl_type,
358 x_cpsv_tbl OUT NOCOPY cpsv_tbl_type);
359
360 PROCEDURE update_contract_process(
361 p_api_version IN NUMBER,
362 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
363 x_return_status OUT NOCOPY VARCHAR2,
364 x_msg_count OUT NOCOPY NUMBER,
365 x_msg_data OUT NOCOPY VARCHAR2,
366 p_cpsv_rec IN cpsv_rec_type,
367 x_cpsv_rec OUT NOCOPY cpsv_rec_type);
368
369 PROCEDURE update_contract_process(
370 p_api_version IN NUMBER,
371 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
372 x_return_status OUT NOCOPY VARCHAR2,
373 x_msg_count OUT NOCOPY NUMBER,
374 x_msg_data OUT NOCOPY VARCHAR2,
375 p_cpsv_tbl IN cpsv_tbl_type,
376 x_cpsv_tbl OUT NOCOPY cpsv_tbl_type);
377
378 PROCEDURE delete_contract_process(
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_cpsv_rec IN cpsv_rec_type);
385
386 PROCEDURE delete_contract_process(
387 p_api_version IN NUMBER,
388 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
389 x_return_status OUT NOCOPY VARCHAR2,
390 x_msg_count OUT NOCOPY NUMBER,
391 x_msg_data OUT NOCOPY VARCHAR2,
392 p_cpsv_tbl IN cpsv_tbl_type);
393
394 PROCEDURE lock_contract_process(
395 p_api_version IN NUMBER,
396 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
397 x_return_status OUT NOCOPY VARCHAR2,
398 x_msg_count OUT NOCOPY NUMBER,
399 x_msg_data OUT NOCOPY VARCHAR2,
400 p_cpsv_rec IN cpsv_rec_type);
401
402 PROCEDURE lock_contract_process(
403 p_api_version IN NUMBER,
404 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
405 x_return_status OUT NOCOPY VARCHAR2,
406 x_msg_count OUT NOCOPY NUMBER,
407 x_msg_data OUT NOCOPY VARCHAR2,
408 p_cpsv_tbl IN cpsv_tbl_type);
409
410 PROCEDURE validate_contract_process(
411 p_api_version IN NUMBER,
412 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
413 x_return_status OUT NOCOPY VARCHAR2,
414 x_msg_count OUT NOCOPY NUMBER,
415 x_msg_data OUT NOCOPY VARCHAR2,
416 p_cpsv_rec IN cpsv_rec_type);
417
418 PROCEDURE validate_contract_process(
419 p_api_version IN NUMBER,
420 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
421 x_return_status OUT NOCOPY VARCHAR2,
422 x_msg_count OUT NOCOPY NUMBER,
423 x_msg_data OUT NOCOPY VARCHAR2,
424 p_cpsv_tbl IN cpsv_tbl_type);
425
426 PROCEDURE create_contract_access(
427 p_api_version IN NUMBER,
428 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
429 x_return_status OUT NOCOPY VARCHAR2,
430 x_msg_count OUT NOCOPY NUMBER,
431 x_msg_data OUT NOCOPY VARCHAR2,
432 p_cacv_rec IN cacv_rec_type,
433 x_cacv_rec OUT NOCOPY cacv_rec_type);
434
435 PROCEDURE create_contract_access(
436 p_api_version IN NUMBER,
437 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
438 x_return_status OUT NOCOPY VARCHAR2,
439 x_msg_count OUT NOCOPY NUMBER,
440 x_msg_data OUT NOCOPY VARCHAR2,
441 p_cacv_tbl IN cacv_tbl_type,
442 x_cacv_tbl OUT NOCOPY cacv_tbl_type);
443
444 PROCEDURE update_contract_access(
445 p_api_version IN NUMBER,
446 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
447 x_return_status OUT NOCOPY VARCHAR2,
448 x_msg_count OUT NOCOPY NUMBER,
449 x_msg_data OUT NOCOPY VARCHAR2,
450 p_cacv_rec IN cacv_rec_type,
451 x_cacv_rec OUT NOCOPY cacv_rec_type);
452
453 PROCEDURE update_contract_access(
454 p_api_version IN NUMBER,
455 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
456 x_return_status OUT NOCOPY VARCHAR2,
457 x_msg_count OUT NOCOPY NUMBER,
458 x_msg_data OUT NOCOPY VARCHAR2,
459 p_cacv_tbl IN cacv_tbl_type,
460 x_cacv_tbl OUT NOCOPY cacv_tbl_type);
461
462 PROCEDURE delete_contract_access(
463 p_api_version IN NUMBER,
464 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
465 x_return_status OUT NOCOPY VARCHAR2,
466 x_msg_count OUT NOCOPY NUMBER,
467 x_msg_data OUT NOCOPY VARCHAR2,
468 p_cacv_rec IN cacv_rec_type);
469
470 PROCEDURE delete_contract_access(
471 p_api_version IN NUMBER,
472 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
473 x_return_status OUT NOCOPY VARCHAR2,
474 x_msg_count OUT NOCOPY NUMBER,
475 x_msg_data OUT NOCOPY VARCHAR2,
476 p_cacv_tbl IN cacv_tbl_type);
477
478 PROCEDURE lock_contract_access(
479 p_api_version IN NUMBER,
480 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
481 x_return_status OUT NOCOPY VARCHAR2,
482 x_msg_count OUT NOCOPY NUMBER,
483 x_msg_data OUT NOCOPY VARCHAR2,
484 p_cacv_rec IN cacv_rec_type);
485
486 PROCEDURE lock_contract_access(
487 p_api_version IN NUMBER,
488 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
489 x_return_status OUT NOCOPY VARCHAR2,
490 x_msg_count OUT NOCOPY NUMBER,
491 x_msg_data OUT NOCOPY VARCHAR2,
492 p_cacv_tbl IN cacv_tbl_type);
493
494 PROCEDURE validate_contract_access(
495 p_api_version IN NUMBER,
496 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
497 x_return_status OUT NOCOPY VARCHAR2,
498 x_msg_count OUT NOCOPY NUMBER,
499 x_msg_data OUT NOCOPY VARCHAR2,
500 p_cacv_rec IN cacv_rec_type);
501
502 PROCEDURE validate_contract_access(
503 p_api_version IN NUMBER,
504 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
505 x_return_status OUT NOCOPY VARCHAR2,
506 x_msg_count OUT NOCOPY NUMBER,
507 x_msg_data OUT NOCOPY VARCHAR2,
508 p_cacv_tbl IN cacv_tbl_type);
509
510 PROCEDURE add_language;
511
512 PROCEDURE Get_Active_Process (
513 p_api_version IN NUMBER,
514 p_init_msg_list IN VARCHAR2,
515 x_return_status OUT NOCOPY VARCHAR2,
516 x_msg_count OUT NOCOPY NUMBER,
517 x_msg_data OUT NOCOPY VARCHAR2,
518 p_contract_number IN VARCHAR2,
519 p_contract_number_modifier IN VARCHAR2,
520 x_wf_name OUT NOCOPY VARCHAR2,
521 x_wf_process_name OUT NOCOPY VARCHAR2,
522 x_package_name OUT NOCOPY VARCHAR2,
523 x_procedure_name OUT NOCOPY VARCHAR2,
524 x_usage OUT NOCOPY VARCHAR2);
525
526 FUNCTION Update_Allowed(p_chr_id IN NUMBER) RETURN VARCHAR2;
527 PROCEDURE Initialize(x_chrv_tbl OUT NOCOPY chrv_tbl_type);
528 PROCEDURE Initialize(x_clev_tbl OUT NOCOPY clev_tbl_type);
529 PROCEDURE Initialize(x_cpsv_tbl OUT NOCOPY cpsv_tbl_type);
530 PROCEDURE Initialize(x_cacv_tbl OUT NOCOPY cacv_tbl_type);
531 PROCEDURE Initialize(x_gvev_tbl OUT NOCOPY gvev_tbl_type);
532 PROCEDURE Initialize(x_cvmv_tbl OUT NOCOPY cvmv_tbl_type);
533
534 FUNCTION Increment_Minor_Version(p_chr_id IN NUMBER) RETURN VARCHAR2;
535
536 -- Added for Bug.No.1789860 Function Get_concat_line_nos added in OKC_CONTRACT_PVT
537 FUNCTION Get_concat_line_no(p_cle_id IN NUMBER, x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2;
538
539 -- GCHADHA --
540 -- FIX FOR BUG 4314347 --
541
542 PROCEDURE UPDATE_LINES(p_id in number,
543 p_sts_code in varchar2,
544 p_new_ste_code in VARCHAR2,
545 p_old_ste_code in VARCHAR2,
546 p_ste_code in VARCHAR2,
547 x_return_status OUT NOCOPY BOOLEAN);
548
549 -- END GCHADHA --
550
551
552 END OKC_CONTRACT_PUB;