[Home] [Help]
PACKAGE: APPS.OKC_CONDITIONS_PVT
Source
1 package okc_conditions_pvt as
2 /* $Header: OKCCCNHS.pls 120.0 2005/05/25 18:00:18 appldev noship $ */
3
4 subtype cnhv_rec_type is okc_cnh_pvt.cnhv_rec_type;
5 subtype cnhv_tbl_type is okc_cnh_pvt.cnhv_tbl_type;
6 subtype cnlv_rec_type is okc_cnl_pvt.cnlv_rec_type;
7 subtype cnlv_tbl_type is okc_cnl_pvt.cnlv_tbl_type;
8 subtype coev_rec_type is okc_coe_pvt.coev_rec_type;
9 subtype coev_tbl_type is okc_coe_pvt.coev_tbl_type;
10 subtype aavv_rec_type is okc_aav_pvt.aavv_rec_type;
11 subtype aavv_tbl_type is okc_aav_pvt.aavv_tbl_type;
12 subtype aalv_rec_type is okc_aal_pvt.aalv_rec_type;
13 subtype aalv_tbl_type is okc_aal_pvt.aalv_tbl_type;
14 subtype fepv_rec_type is okc_fep_pvt.fepv_rec_type;
15 subtype fepv_tbl_type is okc_fep_pvt.fepv_tbl_type;
16 subtype ocev_rec_type is okc_oce_pvt.ocev_rec_type;
17 subtype ocev_tbl_type is okc_oce_pvt.ocev_tbl_type;
18 subtype oatv_rec_type is okc_oat_pvt.oatv_rec_type;
19 subtype oatv_tbl_type is okc_oat_pvt.oatv_tbl_type;
20
21 ------------------------------------------------------------------------------
22 -- Global Variables
23 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITIONS_PVT';
24 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
25 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
26 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
27 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
28 ------------------------------------------------------------------------------
29 --Global Exception
30 ------------------------------------------------------------------------------
31 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
32 ------------------------------------------------------------------------------
33
34 PROCEDURE ADD_LANGUAGE;
35
36 --Object type procedure for insert
37 PROCEDURE create_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
44 p_cnlv_tbl IN cnlv_tbl_type,
45 x_cnhv_rec OUT NOCOPY cnhv_rec_type,
46 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
47
48 --Object type procedure for update
49 PROCEDURE update_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
56 p_cnlv_tbl IN cnlv_tbl_type,
57 x_cnhv_rec OUT NOCOPY cnhv_rec_type,
58 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
59
60 --Object type procedure for validate
61 PROCEDURE validate_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
68 p_cnlv_tbl IN cnlv_tbl_type);
69
70 --Procedures for Condition Headers
71 PROCEDURE create_cond_hdrs(
72 p_api_version IN NUMBER,
73 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
74 x_return_status OUT NOCOPY VARCHAR2,
75 x_msg_count OUT NOCOPY NUMBER,
76 x_msg_data OUT NOCOPY VARCHAR2,
77 p_cnhv_tbl IN cnhv_tbl_type,
78 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
79
80 PROCEDURE create_cond_hdrs(
81 p_api_version IN NUMBER,
82 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
83 x_return_status OUT NOCOPY VARCHAR2,
84 x_msg_count OUT NOCOPY NUMBER,
85 x_msg_data OUT NOCOPY VARCHAR2,
86 p_cnhv_rec IN cnhv_rec_type,
87 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
88
89 PROCEDURE lock_cond_hdrs(
90 p_api_version IN NUMBER,
91 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_cnhv_tbl IN cnhv_tbl_type);
96
97 PROCEDURE lock_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type);
104
105 PROCEDURE update_cond_hdrs(
106 p_api_version IN NUMBER,
107 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
108 x_return_status OUT NOCOPY VARCHAR2,
109 x_msg_count OUT NOCOPY NUMBER,
110 x_msg_data OUT NOCOPY VARCHAR2,
111 p_cnhv_tbl IN cnhv_tbl_type,
112 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
113
114 PROCEDURE update_cond_hdrs(
115 p_api_version IN NUMBER,
116 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
117 x_return_status OUT NOCOPY VARCHAR2,
118 x_msg_count OUT NOCOPY NUMBER,
119 x_msg_data OUT NOCOPY VARCHAR2,
120 p_cnhv_rec IN cnhv_rec_type,
121 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
122
123 PROCEDURE delete_cond_hdrs(
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_msg_count OUT NOCOPY NUMBER,
128 x_msg_data OUT NOCOPY VARCHAR2,
129 p_cnhv_tbl IN cnhv_tbl_type);
130
131 PROCEDURE delete_cond_hdrs(
132 p_api_version IN NUMBER,
133 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
134 x_return_status OUT NOCOPY VARCHAR2,
135 x_msg_count OUT NOCOPY NUMBER,
136 x_msg_data OUT NOCOPY VARCHAR2,
137 p_cnhv_rec IN cnhv_rec_type);
138
139 PROCEDURE validate_cond_hdrs(
140 p_api_version IN NUMBER,
141 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
142 x_return_status OUT NOCOPY VARCHAR2,
143 x_msg_count OUT NOCOPY NUMBER,
144 x_msg_data OUT NOCOPY VARCHAR2,
145 p_cnhv_tbl IN cnhv_tbl_type);
146
147 PROCEDURE validate_cond_hdrs(
148 p_api_version IN NUMBER,
149 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_msg_count OUT NOCOPY NUMBER,
152 x_msg_data OUT NOCOPY VARCHAR2,
153 p_cnhv_rec IN cnhv_rec_type);
154
155
156 --Procedures for Condition Lines
157 PROCEDURE create_cond_lines(
158 p_api_version IN NUMBER,
159 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
160 x_return_status OUT NOCOPY VARCHAR2,
161 x_msg_count OUT NOCOPY NUMBER,
162 x_msg_data OUT NOCOPY VARCHAR2,
163 p_cnlv_tbl IN cnlv_tbl_type,
164 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
165
166 PROCEDURE create_cond_lines(
167 p_api_version IN NUMBER,
168 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
169 x_return_status OUT NOCOPY VARCHAR2,
170 x_msg_count OUT NOCOPY NUMBER,
171 x_msg_data OUT NOCOPY VARCHAR2,
172 p_cnlv_rec IN cnlv_rec_type,
173 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
174
175 PROCEDURE lock_cond_lines(
176 p_api_version IN NUMBER,
177 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
178 x_return_status OUT NOCOPY VARCHAR2,
179 x_msg_count OUT NOCOPY NUMBER,
180 x_msg_data OUT NOCOPY VARCHAR2,
181 p_cnlv_tbl IN cnlv_tbl_type);
182
183 PROCEDURE lock_cond_lines(
184 p_api_version IN NUMBER,
185 p_init_msg_list IN VARCHAR2 DEFAULT OKC_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_cnlv_rec IN cnlv_rec_type);
190
191 PROCEDURE update_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type,
198 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
199
200 PROCEDURE update_cond_lines(
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_cnlv_rec IN cnlv_rec_type,
207 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
208
209 PROCEDURE delete_cond_lines(
210 p_api_version IN NUMBER,
211 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
212 x_return_status OUT NOCOPY VARCHAR2,
213 x_msg_count OUT NOCOPY NUMBER,
214 x_msg_data OUT NOCOPY VARCHAR2,
215 p_cnlv_rec IN cnlv_rec_type);
216
217 PROCEDURE delete_cond_lines(
218 p_api_version IN NUMBER,
219 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_cnlv_tbl IN cnlv_tbl_type);
224
225 PROCEDURE validate_cond_lines(
226 p_api_version IN NUMBER,
227 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
228 x_return_status OUT NOCOPY VARCHAR2,
229 x_msg_count OUT NOCOPY NUMBER,
230 x_msg_data OUT NOCOPY VARCHAR2,
231 p_cnlv_tbl IN cnlv_tbl_type);
232
233 PROCEDURE validate_cond_lines(
234 p_api_version IN NUMBER,
235 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
236 x_return_status OUT NOCOPY VARCHAR2,
237 x_msg_count OUT NOCOPY NUMBER,
238 x_msg_data OUT NOCOPY VARCHAR2,
239 p_cnlv_rec IN cnlv_rec_type);
240
241 --Procedures for Condition Occurrences
242 PROCEDURE create_cond_occurs(
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_coev_tbl IN coev_tbl_type,
249 x_coev_tbl OUT NOCOPY coev_tbl_type);
250
251 PROCEDURE create_cond_occurs(
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_coev_rec IN coev_rec_type,
258 x_coev_rec OUT NOCOPY coev_rec_type);
259
260 PROCEDURE delete_cond_occurs(
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_coev_rec IN coev_rec_type);
267
268 PROCEDURE delete_cond_occurs(
269 p_api_version IN NUMBER,
270 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
271 x_return_status OUT NOCOPY VARCHAR2,
272 x_msg_count OUT NOCOPY NUMBER,
273 x_msg_data OUT NOCOPY VARCHAR2,
274 p_coev_tbl IN coev_tbl_type);
275
276 PROCEDURE validate_cond_occurs(
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_coev_tbl IN coev_tbl_type);
283
284 PROCEDURE validate_cond_occurs(
285 p_api_version IN NUMBER,
286 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
287 x_return_status OUT NOCOPY VARCHAR2,
288 x_msg_count OUT NOCOPY NUMBER,
289 x_msg_data OUT NOCOPY VARCHAR2,
290 p_coev_rec IN coev_rec_type);
291
292 --Procedures for Action Attribute Values
293 PROCEDURE create_act_att_vals(
294 p_api_version IN NUMBER,
295 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
296 x_return_status OUT NOCOPY VARCHAR2,
297 x_msg_count OUT NOCOPY NUMBER,
298 x_msg_data OUT NOCOPY VARCHAR2,
299 p_aavv_tbl IN aavv_tbl_type,
300 x_aavv_tbl OUT NOCOPY aavv_tbl_type);
301
302 PROCEDURE create_act_att_vals(
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_aavv_rec IN aavv_rec_type,
309 x_aavv_rec OUT NOCOPY aavv_rec_type);
310
311 PROCEDURE delete_act_att_vals(
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_aavv_rec IN aavv_rec_type);
318
319 PROCEDURE delete_act_att_vals(
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_aavv_tbl IN aavv_tbl_type);
326
327 PROCEDURE validate_act_att_vals(
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_aavv_tbl IN aavv_tbl_type);
334
335 PROCEDURE validate_act_att_vals(
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_aavv_rec IN aavv_rec_type);
342
343 --Procedures for Action Attribute Lookups
344 PROCEDURE create_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type,
351 x_aalv_tbl OUT NOCOPY aalv_tbl_type);
352
353 PROCEDURE create_act_att_lkps(
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_aalv_rec IN aalv_rec_type,
360 x_aalv_rec OUT NOCOPY aalv_rec_type);
361
362 PROCEDURE lock_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type);
369
370 PROCEDURE lock_act_att_lkps(
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_aalv_rec IN aalv_rec_type);
377
378 PROCEDURE update_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type,
385 x_aalv_tbl OUT NOCOPY aalv_tbl_type);
386
387 PROCEDURE update_act_att_lkps(
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_aalv_rec IN aalv_rec_type,
394 x_aalv_rec OUT NOCOPY aalv_rec_type);
395
396 PROCEDURE delete_act_att_lkps(
397 p_api_version IN NUMBER,
398 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
399 x_return_status OUT NOCOPY VARCHAR2,
400 x_msg_count OUT NOCOPY NUMBER,
401 x_msg_data OUT NOCOPY VARCHAR2,
402 p_aalv_rec IN aalv_rec_type);
403
404 PROCEDURE delete_act_att_lkps(
405 p_api_version IN NUMBER,
406 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
407 x_return_status OUT NOCOPY VARCHAR2,
408 x_msg_count OUT NOCOPY NUMBER,
409 x_msg_data OUT NOCOPY VARCHAR2,
410 p_aalv_tbl IN aalv_tbl_type);
411
412 PROCEDURE validate_act_att_lkps(
413 p_api_version IN NUMBER,
414 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
415 x_return_status OUT NOCOPY VARCHAR2,
416 x_msg_count OUT NOCOPY NUMBER,
417 x_msg_data OUT NOCOPY VARCHAR2,
418 p_aalv_tbl IN aalv_tbl_type);
419
420 PROCEDURE validate_act_att_lkps(
421 p_api_version IN NUMBER,
422 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
423 x_return_status OUT NOCOPY VARCHAR2,
424 x_msg_count OUT NOCOPY NUMBER,
425 x_msg_data OUT NOCOPY VARCHAR2,
426 p_aalv_rec IN aalv_rec_type);
427
428 --Procedures for Function Expression Parameters
429 PROCEDURE create_func_exprs(
430 p_api_version IN NUMBER,
431 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
432 x_return_status OUT NOCOPY VARCHAR2,
433 x_msg_count OUT NOCOPY NUMBER,
434 x_msg_data OUT NOCOPY VARCHAR2,
435 p_fepv_tbl IN fepv_tbl_type,
436 x_fepv_tbl OUT NOCOPY fepv_tbl_type);
437
438 PROCEDURE create_func_exprs(
439 p_api_version IN NUMBER,
440 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
441 x_return_status OUT NOCOPY VARCHAR2,
442 x_msg_count OUT NOCOPY NUMBER,
443 x_msg_data OUT NOCOPY VARCHAR2,
444 p_fepv_rec IN fepv_rec_type,
445 x_fepv_rec OUT NOCOPY fepv_rec_type);
446
447 PROCEDURE lock_func_exprs(
448 p_api_version IN NUMBER,
449 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
450 x_return_status OUT NOCOPY VARCHAR2,
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2,
453 p_fepv_tbl IN fepv_tbl_type);
454
455 PROCEDURE lock_func_exprs(
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_fepv_rec IN fepv_rec_type);
462
463 PROCEDURE update_func_exprs(
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_fepv_tbl IN fepv_tbl_type,
470 x_fepv_tbl OUT NOCOPY fepv_tbl_type);
471
472 PROCEDURE update_func_exprs(
473 p_api_version IN NUMBER,
474 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
475 x_return_status OUT NOCOPY VARCHAR2,
476 x_msg_count OUT NOCOPY NUMBER,
477 x_msg_data OUT NOCOPY VARCHAR2,
478 p_fepv_rec IN fepv_rec_type,
479 x_fepv_rec OUT NOCOPY fepv_rec_type);
480
481 PROCEDURE delete_func_exprs(
482 p_api_version IN NUMBER,
483 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
484 x_return_status OUT NOCOPY VARCHAR2,
485 x_msg_count OUT NOCOPY NUMBER,
486 x_msg_data OUT NOCOPY VARCHAR2,
487 p_fepv_rec IN fepv_rec_type);
488
489 PROCEDURE delete_func_exprs(
490 p_api_version IN NUMBER,
491 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
492 x_return_status OUT NOCOPY VARCHAR2,
493 x_msg_count OUT NOCOPY NUMBER,
494 x_msg_data OUT NOCOPY VARCHAR2,
495 p_fepv_tbl IN fepv_tbl_type);
496
497 PROCEDURE validate_func_exprs(
498 p_api_version IN NUMBER,
499 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
500 x_return_status OUT NOCOPY VARCHAR2,
501 x_msg_count OUT NOCOPY NUMBER,
502 x_msg_data OUT NOCOPY VARCHAR2,
503 p_fepv_tbl IN fepv_tbl_type);
504
505 PROCEDURE validate_func_exprs(
506 p_api_version IN NUMBER,
507 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
508 x_return_status OUT NOCOPY VARCHAR2,
509 x_msg_count OUT NOCOPY NUMBER,
510 x_msg_data OUT NOCOPY VARCHAR2,
511 p_fepv_rec IN fepv_rec_type);
512
513 PROCEDURE valid_condition_lines(
514 p_cnh_id IN okc_condition_headers_b.id%TYPE,
515 x_string OUT NOCOPY VARCHAR2,
516 x_valid_flag OUT NOCOPY VARCHAR2);
517
518 END okc_conditions_pvt;
519