[Home] [Help]
PACKAGE: APPS.OKC_CONDITIONS_PUB
Source
1 package okc_conditions_pub as
2 /* $Header: OKCPCNHS.pls 120.0 2005/05/25 18:58:27 appldev noship $ */
3
4 -- complex entity object subtype definitions
5 subtype cnhv_rec_type is okc_conditions_pvt.cnhv_rec_type;
6 subtype cnhv_tbl_type is okc_conditions_pvt.cnhv_tbl_type;
7 subtype cnlv_rec_type is okc_conditions_pvt.cnlv_rec_type;
8 subtype cnlv_tbl_type is okc_conditions_pvt.cnlv_tbl_type;
9 subtype coev_rec_type is okc_conditions_pvt.coev_rec_type;
10 subtype coev_tbl_type is okc_conditions_pvt.coev_tbl_type;
11 subtype aavv_rec_type is okc_conditions_pvt.aavv_rec_type;
12 subtype aavv_tbl_type is okc_conditions_pvt.aavv_tbl_type;
13 subtype aalv_rec_type is okc_conditions_pvt.aalv_rec_type;
14 subtype aalv_tbl_type is okc_conditions_pvt.aalv_tbl_type;
15 subtype fepv_rec_type is okc_conditions_pvt.fepv_rec_type;
16 subtype fepv_tbl_type is okc_conditions_pvt.fepv_tbl_type;
17
18 ---------------------------------------------------------------------------------------
19 -- GLOBAL VARIABLES
20 ---------------------------------------------------------------------------------------
21 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_CONDITIONS_PUB';
22 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
23 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
24 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
25 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
26
27 g_cnhv_rec okc_conditions_pvt.cnhv_rec_type;
28 g_cnhv_tbl okc_conditions_pvt.cnhv_tbl_type;
29 g_cnlv_rec okc_conditions_pvt.cnlv_rec_type;
30 g_cnlv_tbl okc_conditions_pvt.cnlv_tbl_type;
31 g_coev_rec okc_conditions_pvt.coev_rec_type;
32 g_coev_tbl okc_conditions_pvt.coev_tbl_type;
33 g_aavv_rec okc_conditions_pvt.aavv_rec_type;
34 g_aavv_tbl okc_conditions_pvt.aavv_tbl_type;
35 g_aalv_rec okc_conditions_pvt.aalv_rec_type;
36 g_aalv_tbl okc_conditions_pvt.aalv_tbl_type;
37 g_fepv_rec okc_conditions_pvt.fepv_rec_type;
38 g_fepv_tbl okc_conditions_pvt.fepv_tbl_type;
39 ---------------------------------------------------------------------------------------
40 --Global Exception
41 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
42
43 --Public procedure declarations
44
45 PROCEDURE add_language;
46
47 --Object type procedure for insert
48 PROCEDURE create_cond_hdrs(
49 p_api_version IN NUMBER,
50 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
51 x_return_status OUT NOCOPY VARCHAR2,
52 x_msg_count OUT NOCOPY NUMBER,
53 x_msg_data OUT NOCOPY VARCHAR2,
54 p_cnhv_rec IN cnhv_rec_type,
55 p_cnlv_tbl IN cnlv_tbl_type,
56 x_cnhv_rec OUT NOCOPY cnhv_rec_type,
57 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
58
59 --Object type procedure for update
60 PROCEDURE update_cond_hdrs(
61 p_api_version IN NUMBER,
62 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
63 x_return_status OUT NOCOPY VARCHAR2,
64 x_msg_count OUT NOCOPY NUMBER,
65 x_msg_data OUT NOCOPY VARCHAR2,
66 p_cnhv_rec IN cnhv_rec_type,
67 p_cnlv_tbl IN cnlv_tbl_type,
68 x_cnhv_rec OUT NOCOPY cnhv_rec_type,
69 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
70
71 --Object type procedure for validate
72 PROCEDURE validate_cond_hdrs(
73 p_api_version IN NUMBER,
74 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_cnhv_rec IN cnhv_rec_type,
79 p_cnlv_tbl IN cnlv_tbl_type);
80
81 --Procedures for condition Headers
82
83 PROCEDURE create_cond_hdrs(
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_cnhv_tbl IN cnhv_tbl_type,
90 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
91
92 PROCEDURE create_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
99 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
100
101 PROCEDURE lock_cond_hdrs(
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_cnhv_tbl IN cnhv_tbl_type);
108
109 PROCEDURE lock_cond_hdrs(
110 p_api_version IN NUMBER,
111 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
112 x_return_status OUT NOCOPY VARCHAR2,
113 x_msg_count OUT NOCOPY NUMBER,
114 x_msg_data OUT NOCOPY VARCHAR2,
115 p_cnhv_rec IN cnhv_rec_type);
116
117 PROCEDURE update_cond_hdrs(
118 p_api_version IN NUMBER,
119 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
120 x_return_status OUT NOCOPY VARCHAR2,
121 x_msg_count OUT NOCOPY NUMBER,
122 x_msg_data OUT NOCOPY VARCHAR2,
123 p_cnhv_tbl IN cnhv_tbl_type,
124 x_cnhv_tbl OUT NOCOPY cnhv_tbl_type);
125
126 PROCEDURE update_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type,
133 x_cnhv_rec OUT NOCOPY cnhv_rec_type);
134
135 PROCEDURE delete_cond_hdrs(
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_cnhv_tbl IN cnhv_tbl_type);
142
143 PROCEDURE delete_cond_hdrs(
144 p_api_version IN NUMBER,
145 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
146 x_return_status OUT NOCOPY VARCHAR2,
147 x_msg_count OUT NOCOPY NUMBER,
148 x_msg_data OUT NOCOPY VARCHAR2,
149 p_cnhv_rec IN cnhv_rec_type);
150
151 PROCEDURE validate_cond_hdrs(
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
154 x_return_status OUT NOCOPY VARCHAR2,
155 x_msg_count OUT NOCOPY NUMBER,
156 x_msg_data OUT NOCOPY VARCHAR2,
157 p_cnhv_tbl IN cnhv_tbl_type);
158
159 PROCEDURE validate_cond_hdrs(
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_cnhv_rec IN cnhv_rec_type);
166
167 --Procedures for Condition Lines
168
169 PROCEDURE create_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type,
176 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
177
178 PROCEDURE create_cond_lines(
179 p_api_version IN NUMBER,
180 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_cnlv_rec IN cnlv_rec_type,
185 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
186
187 PROCEDURE lock_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type);
194
195 PROCEDURE lock_cond_lines(
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_cnlv_rec IN cnlv_rec_type);
202
203 PROCEDURE update_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type,
210 x_cnlv_tbl OUT NOCOPY cnlv_tbl_type);
211
212 PROCEDURE update_cond_lines(
213 p_api_version IN NUMBER,
214 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
215 x_return_status OUT NOCOPY VARCHAR2,
216 x_msg_count OUT NOCOPY NUMBER,
217 x_msg_data OUT NOCOPY VARCHAR2,
218 p_cnlv_rec IN cnlv_rec_type,
219 x_cnlv_rec OUT NOCOPY cnlv_rec_type);
220
221 PROCEDURE delete_cond_lines(
222 p_api_version IN NUMBER,
223 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
224 x_return_status OUT NOCOPY VARCHAR2,
225 x_msg_count OUT NOCOPY NUMBER,
226 x_msg_data OUT NOCOPY VARCHAR2,
227 p_cnlv_rec IN cnlv_rec_type);
228
229 PROCEDURE delete_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type);
236
237 PROCEDURE validate_cond_lines(
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_cnlv_tbl IN cnlv_tbl_type);
244
245 PROCEDURE validate_cond_lines(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
248 x_return_status OUT NOCOPY VARCHAR2,
249 x_msg_count OUT NOCOPY NUMBER,
250 x_msg_data OUT NOCOPY VARCHAR2,
251 p_cnlv_rec IN cnlv_rec_type);
252
253 --Procedures for Condition Occurrence
254
255 PROCEDURE create_cond_occurs(
256 p_api_version IN NUMBER,
257 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
258 x_return_status OUT NOCOPY VARCHAR2,
259 x_msg_count OUT NOCOPY NUMBER,
260 x_msg_data OUT NOCOPY VARCHAR2,
261 p_coev_tbl IN coev_tbl_type,
262 x_coev_tbl OUT NOCOPY coev_tbl_type);
263
264 PROCEDURE create_cond_occurs(
265 p_api_version IN NUMBER,
266 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_msg_count OUT NOCOPY NUMBER,
269 x_msg_data OUT NOCOPY VARCHAR2,
270 p_coev_rec IN coev_rec_type,
271 x_coev_rec OUT NOCOPY coev_rec_type);
272
273 PROCEDURE delete_cond_occurs(
274 p_api_version IN NUMBER,
275 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
276 x_return_status OUT NOCOPY VARCHAR2,
277 x_msg_count OUT NOCOPY NUMBER,
278 x_msg_data OUT NOCOPY VARCHAR2,
279 p_coev_rec IN coev_rec_type);
280
281 PROCEDURE delete_cond_occurs(
282 p_api_version IN NUMBER,
283 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
284 x_return_status OUT NOCOPY VARCHAR2,
285 x_msg_count OUT NOCOPY NUMBER,
286 x_msg_data OUT NOCOPY VARCHAR2,
287 p_coev_tbl IN coev_tbl_type);
288
289 PROCEDURE validate_cond_occurs(
290 p_api_version IN NUMBER,
291 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
292 x_return_status OUT NOCOPY VARCHAR2,
293 x_msg_count OUT NOCOPY NUMBER,
294 x_msg_data OUT NOCOPY VARCHAR2,
295 p_coev_tbl IN coev_tbl_type);
296
297 PROCEDURE validate_cond_occurs(
298 p_api_version IN NUMBER,
299 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
300 x_return_status OUT NOCOPY VARCHAR2,
301 x_msg_count OUT NOCOPY NUMBER,
302 x_msg_data OUT NOCOPY VARCHAR2,
303 p_coev_rec IN coev_rec_type);
304
305 --Procedures for Action Attribute Values
306
307 PROCEDURE create_act_att_vals(
308 p_api_version IN NUMBER,
309 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
310 x_return_status OUT NOCOPY VARCHAR2,
311 x_msg_count OUT NOCOPY NUMBER,
312 x_msg_data OUT NOCOPY VARCHAR2,
313 p_aavv_tbl IN aavv_tbl_type,
314 x_aavv_tbl OUT NOCOPY aavv_tbl_type);
315
316 PROCEDURE create_act_att_vals(
317 p_api_version IN NUMBER,
318 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
319 x_return_status OUT NOCOPY VARCHAR2,
320 x_msg_count OUT NOCOPY NUMBER,
321 x_msg_data OUT NOCOPY VARCHAR2,
322 p_aavv_rec IN aavv_rec_type,
323 x_aavv_rec OUT NOCOPY aavv_rec_type);
324
325 PROCEDURE delete_act_att_vals(
326 p_api_version IN NUMBER,
327 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
328 x_return_status OUT NOCOPY VARCHAR2,
329 x_msg_count OUT NOCOPY NUMBER,
330 x_msg_data OUT NOCOPY VARCHAR2,
331 p_aavv_rec IN aavv_rec_type);
332
333 PROCEDURE delete_act_att_vals(
334 p_api_version IN NUMBER,
335 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
336 x_return_status OUT NOCOPY VARCHAR2,
337 x_msg_count OUT NOCOPY NUMBER,
338 x_msg_data OUT NOCOPY VARCHAR2,
339 p_aavv_tbl IN aavv_tbl_type);
340
341 PROCEDURE validate_act_att_vals(
342 p_api_version IN NUMBER,
343 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
344 x_return_status OUT NOCOPY VARCHAR2,
345 x_msg_count OUT NOCOPY NUMBER,
346 x_msg_data OUT NOCOPY VARCHAR2,
347 p_aavv_tbl IN aavv_tbl_type);
348
349 PROCEDURE validate_act_att_vals(
350 p_api_version IN NUMBER,
351 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
352 x_return_status OUT NOCOPY VARCHAR2,
353 x_msg_count OUT NOCOPY NUMBER,
354 x_msg_data OUT NOCOPY VARCHAR2,
355 p_aavv_rec IN aavv_rec_type);
356
357 --Procedures for Action Attribute Lookups
358
359 PROCEDURE create_act_att_lkps(
360 p_api_version IN NUMBER,
361 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
362 x_return_status OUT NOCOPY VARCHAR2,
363 x_msg_count OUT NOCOPY NUMBER,
364 x_msg_data OUT NOCOPY VARCHAR2,
365 p_aalv_tbl IN aalv_tbl_type,
366 x_aalv_tbl OUT NOCOPY aalv_tbl_type);
367
368 PROCEDURE create_act_att_lkps(
369 p_api_version IN NUMBER,
370 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
371 x_return_status OUT NOCOPY VARCHAR2,
372 x_msg_count OUT NOCOPY NUMBER,
373 x_msg_data OUT NOCOPY VARCHAR2,
374 p_aalv_rec IN aalv_rec_type,
375 x_aalv_rec OUT NOCOPY aalv_rec_type);
376
377 PROCEDURE lock_act_att_lkps(
378 p_api_version IN NUMBER,
379 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
380 x_return_status OUT NOCOPY VARCHAR2,
381 x_msg_count OUT NOCOPY NUMBER,
382 x_msg_data OUT NOCOPY VARCHAR2,
383 p_aalv_tbl IN aalv_tbl_type);
384
385 PROCEDURE lock_act_att_lkps(
386 p_api_version IN NUMBER,
387 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
388 x_return_status OUT NOCOPY VARCHAR2,
389 x_msg_count OUT NOCOPY NUMBER,
390 x_msg_data OUT NOCOPY VARCHAR2,
391 p_aalv_rec IN aalv_rec_type);
392
393 PROCEDURE update_act_att_lkps(
394 p_api_version IN NUMBER,
395 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
396 x_return_status OUT NOCOPY VARCHAR2,
397 x_msg_count OUT NOCOPY NUMBER,
398 x_msg_data OUT NOCOPY VARCHAR2,
399 p_aalv_tbl IN aalv_tbl_type,
400 x_aalv_tbl OUT NOCOPY aalv_tbl_type);
401
402 PROCEDURE update_act_att_lkps(
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_aalv_rec IN aalv_rec_type,
409 x_aalv_rec OUT NOCOPY aalv_rec_type);
410
411 PROCEDURE delete_act_att_lkps(
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_aalv_rec IN aalv_rec_type);
418
419 PROCEDURE delete_act_att_lkps(
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_aalv_tbl IN aalv_tbl_type);
426
427 PROCEDURE validate_act_att_lkps(
428 p_api_version IN NUMBER,
429 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
430 x_return_status OUT NOCOPY VARCHAR2,
431 x_msg_count OUT NOCOPY NUMBER,
432 x_msg_data OUT NOCOPY VARCHAR2,
433 p_aalv_tbl IN aalv_tbl_type);
434
435 PROCEDURE validate_act_att_lkps(
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_aalv_rec IN aalv_rec_type);
442
443 --Procedures for Function Expression Parameters
444
445 PROCEDURE create_func_exprs(
446 p_api_version IN NUMBER,
447 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
448 x_return_status OUT NOCOPY VARCHAR2,
449 x_msg_count OUT NOCOPY NUMBER,
450 x_msg_data OUT NOCOPY VARCHAR2,
451 p_fepv_tbl IN fepv_tbl_type,
452 x_fepv_tbl OUT NOCOPY fepv_tbl_type);
453
454 PROCEDURE create_func_exprs(
455 p_api_version IN NUMBER,
456 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
457 x_return_status OUT NOCOPY VARCHAR2,
458 x_msg_count OUT NOCOPY NUMBER,
459 x_msg_data OUT NOCOPY VARCHAR2,
460 p_fepv_rec IN fepv_rec_type,
461 x_fepv_rec OUT NOCOPY fepv_rec_type);
462
463 PROCEDURE lock_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
471 PROCEDURE lock_func_exprs(
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_fepv_rec IN fepv_rec_type);
478
479 PROCEDURE update_func_exprs(
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_fepv_tbl IN fepv_tbl_type,
486 x_fepv_tbl OUT NOCOPY fepv_tbl_type);
487
488 PROCEDURE update_func_exprs(
489 p_api_version IN NUMBER,
490 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
491 x_return_status OUT NOCOPY VARCHAR2,
492 x_msg_count OUT NOCOPY NUMBER,
493 x_msg_data OUT NOCOPY VARCHAR2,
494 p_fepv_rec IN fepv_rec_type,
495 x_fepv_rec OUT NOCOPY fepv_rec_type);
496
497 PROCEDURE delete_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_rec IN fepv_rec_type);
504
505 PROCEDURE delete_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_tbl IN fepv_tbl_type);
512
513 PROCEDURE validate_func_exprs(
514 p_api_version IN NUMBER,
515 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
516 x_return_status OUT NOCOPY VARCHAR2,
517 x_msg_count OUT NOCOPY NUMBER,
518 x_msg_data OUT NOCOPY VARCHAR2,
519 p_fepv_tbl IN fepv_tbl_type);
520
521 PROCEDURE validate_func_exprs(
522 p_api_version IN NUMBER,
523 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
524 x_return_status OUT NOCOPY VARCHAR2,
525 x_msg_count OUT NOCOPY NUMBER,
526 x_msg_data OUT NOCOPY VARCHAR2,
527 p_fepv_rec IN fepv_rec_type);
528
529 PROCEDURE valid_condition_lines(
530 p_cnh_id IN okc_condition_headers_b.id%TYPE,
531 x_string OUT NOCOPY VARCHAR2,
532 x_valid_flag OUT NOCOPY VARCHAR2);
533
534 END okc_conditions_pub;