[Home] [Help]
PACKAGE: APPS.OKC_RULE_PUB
Source
1 PACKAGE OKC_RULE_PUB AS
2 /* $Header: OKCPRULS.pls 120.0 2005/05/30 04:10:35 appldev noship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL DATASTRUCTURES, needed for Public API's only
6 ---------------------------------------------------------------------------
7 G_MISS_CLOB CLOB;
8
9 -- complex entity object subtype definitions
10 subtype rulv_rec_type is OKC_RULE_PVT.rulv_rec_type;
11 subtype rulv_tbl_type is OKC_RULE_PVT.rulv_tbl_type;
12 subtype rgpv_rec_type is OKC_RULE_PVT.rgpv_rec_type;
13 subtype rgpv_tbl_type is OKC_RULE_PVT.rgpv_tbl_type;
14 subtype rmpv_rec_type is OKC_RULE_PVT.rmpv_rec_type;
15 subtype rmpv_tbl_type is OKC_RULE_PVT.rmpv_tbl_type;
16 subtype ctiv_rec_type is OKC_RULE_PVT.ctiv_rec_type;
17 subtype ctiv_tbl_type is OKC_RULE_PVT.ctiv_tbl_type;
18 subtype rilv_rec_type is OKC_RULE_PVT.rilv_rec_type;
19 subtype rilv_tbl_type is OKC_RULE_PVT.rilv_tbl_type;
20
21 ---------------------------------------------------------------------------
22 -- GLOBAL MESSAGE CONSTANTS
23 ---------------------------------------------------------------------------
24 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
25 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
26 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
27 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
28 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
29 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
30 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
31 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
32 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
33 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
34 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
35 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
36 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
37 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
38
39 ------------------------------------------------------------------------------------
40 -- GLOBAL EXCEPTION
41 ---------------------------------------------------------------------------
42 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
43
44 -- GLOBAL VARIABLES
45 ---------------------------------------------------------------------------
46 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_RULE_PUB';
47 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
48
49 g_rulv_rec rulv_rec_type;
50 g_rgpv_rec rgpv_rec_type;
51 g_rmpv_rec rmpv_rec_type;
52 g_ctiv_rec ctiv_rec_type;
53 g_rilv_rec rilv_rec_type;
54
55 -- public procedure declarations
56
57 PROCEDURE create_rule(
58 p_api_version IN NUMBER,
59 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
60 x_return_status OUT NOCOPY VARCHAR2,
61 x_msg_count OUT NOCOPY NUMBER,
62 x_msg_data OUT NOCOPY VARCHAR2,
63 p_rulv_rec IN rulv_rec_type,
64 x_rulv_rec OUT NOCOPY rulv_rec_type,
65 p_euro_conv_yn IN VARCHAR2);
66
67 PROCEDURE create_rule(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_rulv_rec IN rulv_rec_type,
74 x_rulv_rec OUT NOCOPY rulv_rec_type);
75
76 PROCEDURE create_rule(
77 p_api_version IN NUMBER,
78 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
79 x_return_status OUT NOCOPY VARCHAR2,
80 x_msg_count OUT NOCOPY NUMBER,
81 x_msg_data OUT NOCOPY VARCHAR2,
82 p_rulv_tbl IN rulv_tbl_type,
83 x_rulv_tbl OUT NOCOPY rulv_tbl_type,
84 p_euro_conv_yn IN VARCHAR2);
85
86 PROCEDURE create_rule(
87 p_api_version IN NUMBER,
88 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89 x_return_status OUT NOCOPY VARCHAR2,
90 x_msg_count OUT NOCOPY NUMBER,
91 x_msg_data OUT NOCOPY VARCHAR2,
92 p_rulv_tbl IN rulv_tbl_type,
93 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
94
95 PROCEDURE update_rule(
96 p_api_version IN NUMBER,
97 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
98 x_return_status OUT NOCOPY VARCHAR2,
99 x_msg_count OUT NOCOPY NUMBER,
100 x_msg_data OUT NOCOPY VARCHAR2,
101 p_rulv_rec IN rulv_rec_type,
102 x_rulv_rec OUT NOCOPY rulv_rec_type);
103
104 PROCEDURE update_rule(
105 p_api_version IN NUMBER,
106 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
107 x_return_status OUT NOCOPY VARCHAR2,
108 x_msg_count OUT NOCOPY NUMBER,
109 x_msg_data OUT NOCOPY VARCHAR2,
110 p_rulv_tbl IN rulv_tbl_type,
111 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
112
113 PROCEDURE validate_rule(
114 p_api_version IN NUMBER,
115 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_msg_count OUT NOCOPY NUMBER,
118 x_msg_data OUT NOCOPY VARCHAR2,
119 p_rulv_rec IN rulv_rec_type);
120
121 PROCEDURE validate_rule(
122 p_api_version IN NUMBER,
123 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
124 x_return_status OUT NOCOPY VARCHAR2,
125 x_msg_count OUT NOCOPY NUMBER,
126 x_msg_data OUT NOCOPY VARCHAR2,
127 p_rulv_tbl IN rulv_tbl_type);
128
129 PROCEDURE delete_rule(
130 p_api_version IN NUMBER,
131 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
132 x_return_status OUT NOCOPY VARCHAR2,
133 x_msg_count OUT NOCOPY NUMBER,
134 x_msg_data OUT NOCOPY VARCHAR2,
135 p_rulv_rec IN rulv_rec_type);
136
137 PROCEDURE delete_rule(
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_rulv_tbl IN rulv_tbl_type);
144
145 PROCEDURE lock_rule(
146 p_api_version IN NUMBER,
147 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
148 x_return_status OUT NOCOPY VARCHAR2,
149 x_msg_count OUT NOCOPY NUMBER,
150 x_msg_data OUT NOCOPY VARCHAR2,
151 p_rulv_rec IN rulv_rec_type);
152
153 PROCEDURE lock_rule(
154 p_api_version IN NUMBER,
155 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
156 x_return_status OUT NOCOPY VARCHAR2,
157 x_msg_count OUT NOCOPY NUMBER,
158 x_msg_data OUT NOCOPY VARCHAR2,
159 p_rulv_tbl IN rulv_tbl_type);
160
161 PROCEDURE create_rule_group(
162 p_api_version IN NUMBER,
163 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
164 x_return_status OUT NOCOPY VARCHAR2,
165 x_msg_count OUT NOCOPY NUMBER,
166 x_msg_data OUT NOCOPY VARCHAR2,
167 p_rgpv_rec IN rgpv_rec_type,
168 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
169
170 PROCEDURE create_rule_group(
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_rgpv_tbl IN rgpv_tbl_type,
177 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
178
179 PROCEDURE update_rule_group(
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_rgpv_rec IN rgpv_rec_type,
186 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
187
188 PROCEDURE update_rule_group(
189 p_api_version IN NUMBER,
190 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
191 x_return_status OUT NOCOPY VARCHAR2,
192 x_msg_count OUT NOCOPY NUMBER,
193 x_msg_data OUT NOCOPY VARCHAR2,
194 p_rgpv_tbl IN rgpv_tbl_type,
195 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
196
197 PROCEDURE delete_rule_group(
198 p_api_version IN NUMBER,
199 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
200 x_return_status OUT NOCOPY VARCHAR2,
201 x_msg_count OUT NOCOPY NUMBER,
202 x_msg_data OUT NOCOPY VARCHAR2,
203 p_rgpv_rec IN rgpv_rec_type);
204
205 PROCEDURE delete_rule_group(
206 p_api_version IN NUMBER,
207 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
208 x_return_status OUT NOCOPY VARCHAR2,
209 x_msg_count OUT NOCOPY NUMBER,
210 x_msg_data OUT NOCOPY VARCHAR2,
211 p_rgpv_tbl IN rgpv_tbl_type);
212
213 PROCEDURE lock_rule_group(
214 p_api_version IN NUMBER,
215 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
216 x_return_status OUT NOCOPY VARCHAR2,
217 x_msg_count OUT NOCOPY NUMBER,
218 x_msg_data OUT NOCOPY VARCHAR2,
219 p_rgpv_rec IN rgpv_rec_type);
220
221 PROCEDURE lock_rule_group(
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_rgpv_tbl IN rgpv_tbl_type);
228
229 PROCEDURE validate_rule_group(
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_rgpv_rec IN rgpv_rec_type);
236
237 PROCEDURE validate_rule_group(
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_rgpv_tbl IN rgpv_tbl_type);
244
245 PROCEDURE create_rg_mode_pty_role(
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_rmpv_rec IN rmpv_rec_type,
252 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
253
254 PROCEDURE create_rg_mode_pty_role(
255 p_api_version IN NUMBER,
256 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
257 x_return_status OUT NOCOPY VARCHAR2,
258 x_msg_count OUT NOCOPY NUMBER,
259 x_msg_data OUT NOCOPY VARCHAR2,
260 p_rmpv_tbl IN rmpv_tbl_type,
261 x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
262
263 PROCEDURE update_rg_mode_pty_role(
264 p_api_version IN NUMBER,
265 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
266 x_return_status OUT NOCOPY VARCHAR2,
267 x_msg_count OUT NOCOPY NUMBER,
268 x_msg_data OUT NOCOPY VARCHAR2,
269 p_rmpv_rec IN rmpv_rec_type,
270 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
271
272 PROCEDURE update_rg_mode_pty_role(
273 p_api_version IN NUMBER,
274 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
275 x_return_status OUT NOCOPY VARCHAR2,
276 x_msg_count OUT NOCOPY NUMBER,
277 x_msg_data OUT NOCOPY VARCHAR2,
278 p_rmpv_tbl IN rmpv_tbl_type,
279 x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
280
281 PROCEDURE delete_rg_mode_pty_role(
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_rmpv_rec IN rmpv_rec_type);
288
289 PROCEDURE delete_rg_mode_pty_role(
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_rmpv_tbl IN rmpv_tbl_type);
296
297 PROCEDURE lock_rg_mode_pty_role(
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_rmpv_rec IN rmpv_rec_type);
304
305 PROCEDURE lock_rg_mode_pty_role(
306 p_api_version IN NUMBER,
307 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
308 x_return_status OUT NOCOPY VARCHAR2,
309 x_msg_count OUT NOCOPY NUMBER,
310 x_msg_data OUT NOCOPY VARCHAR2,
311 p_rmpv_tbl IN rmpv_tbl_type);
312
313 PROCEDURE validate_rg_mode_pty_role(
314 p_api_version IN NUMBER,
315 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
316 x_return_status OUT NOCOPY VARCHAR2,
317 x_msg_count OUT NOCOPY NUMBER,
318 x_msg_data OUT NOCOPY VARCHAR2,
319 p_rmpv_rec IN rmpv_rec_type);
320
321 PROCEDURE validate_rg_mode_pty_role(
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_rmpv_tbl IN rmpv_tbl_type);
328
329 PROCEDURE create_cover_time(
330 p_api_version IN NUMBER,
331 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2,
335 p_ctiv_rec IN ctiv_rec_type,
336 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
337
338 PROCEDURE create_cover_time(
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_ctiv_tbl IN ctiv_tbl_type,
345 x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
346
347 PROCEDURE update_cover_time(
348 p_api_version IN NUMBER,
349 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
350 x_return_status OUT NOCOPY VARCHAR2,
351 x_msg_count OUT NOCOPY NUMBER,
352 x_msg_data OUT NOCOPY VARCHAR2,
353 p_ctiv_rec IN ctiv_rec_type,
354 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
355
356 PROCEDURE update_cover_time(
357 p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
359 x_return_status OUT NOCOPY VARCHAR2,
360 x_msg_count OUT NOCOPY NUMBER,
361 x_msg_data OUT NOCOPY VARCHAR2,
362 p_ctiv_tbl IN ctiv_tbl_type,
363 x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
364
365 PROCEDURE delete_cover_time(
366 p_api_version IN NUMBER,
367 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
368 x_return_status OUT NOCOPY VARCHAR2,
369 x_msg_count OUT NOCOPY NUMBER,
370 x_msg_data OUT NOCOPY VARCHAR2,
371 p_ctiv_rec IN ctiv_rec_type);
372
373 PROCEDURE delete_cover_time(
374 p_api_version IN NUMBER,
375 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_ctiv_tbl IN ctiv_tbl_type);
380
381 PROCEDURE lock_cover_time(
382 p_api_version IN NUMBER,
383 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
384 x_return_status OUT NOCOPY VARCHAR2,
385 x_msg_count OUT NOCOPY NUMBER,
386 x_msg_data OUT NOCOPY VARCHAR2,
387 p_ctiv_rec IN ctiv_rec_type);
388
389 PROCEDURE lock_cover_time(
390 p_api_version IN NUMBER,
391 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
392 x_return_status OUT NOCOPY VARCHAR2,
393 x_msg_count OUT NOCOPY NUMBER,
394 x_msg_data OUT NOCOPY VARCHAR2,
395 p_ctiv_tbl IN ctiv_tbl_type);
396
397 PROCEDURE validate_cover_time(
398 p_api_version IN NUMBER,
399 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400 x_return_status OUT NOCOPY VARCHAR2,
401 x_msg_count OUT NOCOPY NUMBER,
402 x_msg_data OUT NOCOPY VARCHAR2,
403 p_ctiv_rec IN ctiv_rec_type);
404
405 PROCEDURE validate_cover_time(
406 p_api_version IN NUMBER,
407 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
408 x_return_status OUT NOCOPY VARCHAR2,
409 x_msg_count OUT NOCOPY NUMBER,
410 x_msg_data OUT NOCOPY VARCHAR2,
411 p_ctiv_tbl IN ctiv_tbl_type);
412
413 PROCEDURE create_react_interval(
414 p_api_version IN NUMBER,
415 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
416 x_return_status OUT NOCOPY VARCHAR2,
417 x_msg_count OUT NOCOPY NUMBER,
418 x_msg_data OUT NOCOPY VARCHAR2,
419 p_rilv_rec IN rilv_rec_type,
420 x_rilv_rec OUT NOCOPY rilv_rec_type);
421
422 PROCEDURE create_react_interval(
423 p_api_version IN NUMBER,
424 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
425 x_return_status OUT NOCOPY VARCHAR2,
426 x_msg_count OUT NOCOPY NUMBER,
427 x_msg_data OUT NOCOPY VARCHAR2,
428 p_rilv_tbl IN rilv_tbl_type,
429 x_rilv_tbl OUT NOCOPY rilv_tbl_type);
430
431 PROCEDURE update_react_interval(
432 p_api_version IN NUMBER,
433 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
434 x_return_status OUT NOCOPY VARCHAR2,
435 x_msg_count OUT NOCOPY NUMBER,
436 x_msg_data OUT NOCOPY VARCHAR2,
437 p_rilv_rec IN rilv_rec_type,
438 x_rilv_rec OUT NOCOPY rilv_rec_type);
439
440 PROCEDURE update_react_interval(
441 p_api_version IN NUMBER,
442 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
443 x_return_status OUT NOCOPY VARCHAR2,
444 x_msg_count OUT NOCOPY NUMBER,
445 x_msg_data OUT NOCOPY VARCHAR2,
446 p_rilv_tbl IN rilv_tbl_type,
447 x_rilv_tbl OUT NOCOPY rilv_tbl_type);
448
449 PROCEDURE delete_react_interval(
450 p_api_version IN NUMBER,
451 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
452 x_return_status OUT NOCOPY VARCHAR2,
453 x_msg_count OUT NOCOPY NUMBER,
454 x_msg_data OUT NOCOPY VARCHAR2,
455 p_rilv_rec IN rilv_rec_type);
456
457 PROCEDURE delete_react_interval(
458 p_api_version IN NUMBER,
459 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460 x_return_status OUT NOCOPY VARCHAR2,
461 x_msg_count OUT NOCOPY NUMBER,
462 x_msg_data OUT NOCOPY VARCHAR2,
463 p_rilv_tbl IN rilv_tbl_type);
464
465 PROCEDURE lock_react_interval(
466 p_api_version IN NUMBER,
467 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
468 x_return_status OUT NOCOPY VARCHAR2,
469 x_msg_count OUT NOCOPY NUMBER,
470 x_msg_data OUT NOCOPY VARCHAR2,
471 p_rilv_rec IN rilv_rec_type);
472
473 PROCEDURE lock_react_interval(
474 p_api_version IN NUMBER,
475 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
476 x_return_status OUT NOCOPY VARCHAR2,
477 x_msg_count OUT NOCOPY NUMBER,
478 x_msg_data OUT NOCOPY VARCHAR2,
479 p_rilv_tbl IN rilv_tbl_type);
480
481 PROCEDURE validate_react_interval(
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_rilv_rec IN rilv_rec_type);
488
489 PROCEDURE validate_react_interval(
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_rilv_tbl IN rilv_tbl_type);
496
497 PROCEDURE add_language;
498
499 function rule_meaning(p_rle_code varchar2) return varchar2;
500
501 function get_new_code
502 (p_rgd_code in varchar2, p_rdf_code in varchar2, p_intent varchar2, p_number number)
503 return varchar2;
504
505 --
506 -- (select 'object_code' object_code,id1,id2,name value,description
507 -- from 'from_table'
508 -- where 'where_clause')
509 --
510 function get_object_sql(p_object_code in varchar2,p_clause_yn in varchar2) return varchar2;
511 function get_object_sql(p_object_code in varchar2,p_cpl_id in number) return varchar2;
512 function get_object_sql(p_object_code in varchar2,p_id in number, p_rule VARCHAR2, p_ncol NUMBER) return varchar2;
513 function get_object_sql(p_object_code in varchar2) return varchar2;
514
515 function get_object_val
516 (p_object_code in varchar2, p_object_id1 in varchar2, p_object_id2 in varchar2)
517 return varchar2;
518
519 function get_object_dsc
520 (p_object_code in varchar2, p_object_id1 in varchar2, p_object_id2 in varchar2)
521 return varchar2;
522
523 procedure get_object_ids(
524 p_value in varchar2,
525 p_sql in varchar2,
526 x_object_code out nocopy varchar2,
527 x_id1 out nocopy varchar2,
528 x_id2 out nocopy varchar2,
529 x_desc out nocopy varchar2
530 );
531
532 procedure get_object_ids(
533 p_value in varchar2,
534 p_desc in varchar2,
535 p_sql in varchar2,
536 x_object_code out nocopy varchar2,
537 x_id1 out nocopy varchar2,
538 x_id2 out nocopy varchar2,
539 x_desc out nocopy varchar2
540 );
541
542 --
543 -- (select id, value, meaning description
544 -- from 'application_table_name'
545 -- where 'additional_where_clause' --get rid of where and order by)
546 --
547 function get_flex_sql(p_rdf_code in varchar2, p_col_name in varchar2,p_clause_yn in varchar2) return varchar2;
548 function get_flex_sql(p_rdf_code in varchar2, p_col_name in varchar2) return varchar2;
549
550 function get_flex_val(p_rdf_code in varchar2, p_col_name in varchar2, p_id in varchar2)
551 return varchar2;
552
553 function get_flex_dsc(p_rdf_code in varchar2, p_col_name in varchar2, p_id in varchar2)
554 return varchar2;
555
556 procedure get_flex_ids(
557 p_value varchar2,
558 p_sql in varchar2,
559 x_id out nocopy varchar2,
560 x_desc out nocopy varchar2
561 );
562 procedure get_flex_ids(
563 p_value varchar2,
564 p_desc varchar2,
565 p_sql in varchar2,
566 x_id out nocopy varchar2,
567 x_desc out nocopy varchar2
568 );
569
570 function euro_YN(rle_code varchar2, p_chr_id number) return varchar2;
571
572 function gen_comments return varchar2;
573
574 procedure no_comments;
575
576 function euro_yn(auth_org_id number) return varchar2;
577
578 procedure issue_savepoint (sp varchar2);
579 procedure rollback_savepoint (sp varchar2);
580
581 procedure initialize(x out nocopy rulv_tbl_type);
582 procedure initialize(x out nocopy rgpv_tbl_type);
583 procedure initialize(x out nocopy rmpv_tbl_type);
584
585 --
586 -- function get_contact
587 --
588 -- returns HZ_PARTIES related contacts points
589 -- otherwise (or if not found) returns contact description
590 -- through jtf_objects_vl
591 --
592 -- all parameters are regular jtf_objects related
593 --
594
595 function get_contact(
596 p_object_code in varchar2,
597 p_object_id1 in varchar2,
598 p_object_id2 in varchar2
599 )
600 return varchar2;
601
602 END OKC_RULE_PUB;