[Home] [Help]
PACKAGE: APPS.OKL_RULE_PUB
Source
1 PACKAGE okl_rule_pub AUTHID CURRENT_USER AS
2 /* $Header: OKLPRULS.pls 115.8 2004/02/03 18:17:23 avsingh noship $ */
3
4 TYPE rulv_rec_type IS RECORD (
5 id NUMBER := OKC_API.G_MISS_NUM,
6 object_version_number NUMBER := OKC_API.G_MISS_NUM,
7 sfwt_flag OKC_RULES_V.SFWT_FLAG%TYPE := OKC_API.G_MISS_CHAR,
8 object1_id1 OKC_RULES_V.OBJECT1_ID1%TYPE := OKC_API.G_MISS_CHAR,
9 object2_id1 OKC_RULES_V.OBJECT2_ID1%TYPE := OKC_API.G_MISS_CHAR,
10 object3_id1 OKC_RULES_V.OBJECT3_ID1%TYPE := OKC_API.G_MISS_CHAR,
11 object1_id2 OKC_RULES_V.OBJECT1_ID2%TYPE := OKC_API.G_MISS_CHAR,
12 object2_id2 OKC_RULES_V.OBJECT2_ID2%TYPE := OKC_API.G_MISS_CHAR,
13 object3_id2 OKC_RULES_V.OBJECT3_ID2%TYPE := OKC_API.G_MISS_CHAR,
14 jtot_object1_code OKC_RULES_V.JTOT_OBJECT1_CODE%TYPE := OKC_API.G_MISS_CHAR,
15 jtot_object2_code OKC_RULES_V.JTOT_OBJECT2_CODE%TYPE := OKC_API.G_MISS_CHAR,
16 jtot_object3_code OKC_RULES_V.JTOT_OBJECT3_CODE%TYPE := OKC_API.G_MISS_CHAR,
17 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
18 rgp_id NUMBER := OKC_API.G_MISS_NUM,
19 priority NUMBER := OKC_API.G_MISS_NUM,
20 std_template_yn OKC_RULES_V.STD_TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
21 comments OKC_RULES_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
22 warn_yn OKC_RULES_V.WARN_YN%TYPE := OKC_API.G_MISS_CHAR,
23 attribute_category OKC_RULES_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
24 attribute1 OKC_RULES_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
25 attribute2 OKC_RULES_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
26 attribute3 OKC_RULES_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
27 attribute4 OKC_RULES_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
28 attribute5 OKC_RULES_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
29 attribute6 OKC_RULES_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
30 attribute7 OKC_RULES_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
31 attribute8 OKC_RULES_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
32 attribute9 OKC_RULES_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
33 attribute10 OKC_RULES_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
34 attribute11 OKC_RULES_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
35 attribute12 OKC_RULES_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
36 attribute13 OKC_RULES_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
37 attribute14 OKC_RULES_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
38 attribute15 OKC_RULES_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
39 created_by NUMBER := OKC_API.G_MISS_NUM,
40 creation_date OKC_RULES_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
41 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
42 last_update_date OKC_RULES_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
43 last_update_login NUMBER := OKC_API.G_MISS_NUM,
44 --text OKC_RULES_V.TEXT%TYPE := NULL,
45 rule_information_category OKC_RULES_V.RULE_INFORMATION_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
46 rule_information1 OKC_RULES_V.RULE_INFORMATION1%TYPE := OKC_API.G_MISS_CHAR,
47 rule_information2 OKC_RULES_V.RULE_INFORMATION2%TYPE := OKC_API.G_MISS_CHAR,
48 rule_information3 OKC_RULES_V.RULE_INFORMATION3%TYPE := OKC_API.G_MISS_CHAR,
49 rule_information4 OKC_RULES_V.RULE_INFORMATION4%TYPE := OKC_API.G_MISS_CHAR,
50 rule_information5 OKC_RULES_V.RULE_INFORMATION5%TYPE := OKC_API.G_MISS_CHAR,
51 rule_information6 OKC_RULES_V.RULE_INFORMATION6%TYPE := OKC_API.G_MISS_CHAR,
52 rule_information7 OKC_RULES_V.RULE_INFORMATION7%TYPE := OKC_API.G_MISS_CHAR,
53 rule_information8 OKC_RULES_V.RULE_INFORMATION8%TYPE := OKC_API.G_MISS_CHAR,
54 rule_information9 OKC_RULES_V.RULE_INFORMATION9%TYPE := OKC_API.G_MISS_CHAR,
55 rule_information10 OKC_RULES_V.RULE_INFORMATION10%TYPE := OKC_API.G_MISS_CHAR,
56 rule_information11 OKC_RULES_V.RULE_INFORMATION11%TYPE := OKC_API.G_MISS_CHAR,
57 rule_information12 OKC_RULES_V.RULE_INFORMATION12%TYPE := OKC_API.G_MISS_CHAR,
58 rule_information13 OKC_RULES_V.RULE_INFORMATION13%TYPE := OKC_API.G_MISS_CHAR,
59 rule_information14 OKC_RULES_V.RULE_INFORMATION14%TYPE := OKC_API.G_MISS_CHAR,
60 rule_information15 OKC_RULES_V.RULE_INFORMATION15%TYPE := OKC_API.G_MISS_CHAR,
61 template_yn OKC_RULES_B.TEMPLATE_YN%TYPE := OKC_API.G_MISS_CHAR,
62 ans_set_jtot_object_code OKC_RULES_B.ans_set_jtot_object_code%TYPE := OKC_API.G_MISS_CHAR,
63 ans_set_jtot_object_id1 OKC_RULES_B.ans_set_jtot_object_id1%TYPE := OKC_API.G_MISS_CHAR,
64 ans_set_jtot_object_id2 OKC_RULES_B.ans_set_jtot_object_id2%TYPE := OKC_API.G_MISS_CHAR,
65 display_sequence NUMBER:= OKC_API.G_MISS_NUM
66 );
67
68 g_miss_rulv_rec rulv_rec_type;
69
70 TYPE rulv_tbl_type IS TABLE OF rulv_rec_type INDEX BY BINARY_INTEGER;
71 subtype rgpv_rec_type is okl_okc_migration_pvt.rgpv_rec_type;
72 subtype rgpv_tbl_type is okl_okc_migration_pvt.rgpv_tbl_type;
73 subtype rmpv_rec_type is okl_okc_migration_pvt.rmpv_rec_type;
74 subtype rmpv_tbl_type is okl_okc_migration_pvt.rmpv_tbl_type;
75 -- subtype ctiv_rec_type is OKC_CTI_PVT.ctiv_rec_type;
76 -- subtype ctiv_tbl_type is OKC_CTI_PVT.ctiv_tbl_type;
77 -- subtype rilv_rec_type is OKC_RIL_PVT.rilv_rec_type;
78 -- subtype rilv_tbl_type is OKC_RIL_PVT.rilv_tbl_type;
79
80 ---------------------------------------------------------------------------
81 -- GLOBAL MESSAGE CONSTANTS
82 ---------------------------------------------------------------------------
83 G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
84 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := OKC_API.G_FORM_UNABLE_TO_RESERVE_REC;
85 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_DELETED;
86 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := OKC_API.G_FORM_RECORD_CHANGED;
87 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := OKC_API.G_RECORD_LOGICALLY_DELETED;
88 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_REQUIRED_VALUE;
89 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
90 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
91 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
92 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;
93 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
94 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
95 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
96 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKC_UPPERCASE_REQUIRED';
97
98 ------------------------------------------------------------------------------------
99 -- GLOBAL EXCEPTION
100 ---------------------------------------------------------------------------
101 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
102
103 -- GLOBAL VARIABLES
104 ---------------------------------------------------------------------------
105 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_RULE_PUB';
106 G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
107
108 g_rulv_rec rulv_rec_type;
109 g_rgpv_rec rgpv_rec_type;
110 g_rmpv_rec rmpv_rec_type;
111 --g_ctiv_rec ctiv_rec_type;
112 --g_rilv_rec rilv_rec_type;
113
114
115 -- public procedure declarations
116 PROCEDURE create_rule(
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_rulv_rec IN rulv_rec_type,
123 x_rulv_rec OUT NOCOPY rulv_rec_type,
124 p_euro_conv_yn IN VARCHAR2);
125 PROCEDURE create_rule(
126 p_api_version IN NUMBER,
127 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
128 x_return_status OUT NOCOPY VARCHAR2,
129 x_msg_count OUT NOCOPY NUMBER,
130 x_msg_data OUT NOCOPY VARCHAR2,
131 p_rulv_rec IN rulv_rec_type,
132 x_rulv_rec OUT NOCOPY rulv_rec_type);
133 PROCEDURE create_rule(
134 p_api_version IN NUMBER,
135 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
136 x_return_status OUT NOCOPY VARCHAR2,
137 x_msg_count OUT NOCOPY NUMBER,
138 x_msg_data OUT NOCOPY VARCHAR2,
139 p_rulv_tbl IN rulv_tbl_type,
140 x_rulv_tbl OUT NOCOPY rulv_tbl_type,
141 p_euro_conv_yn IN VARCHAR2);
142 PROCEDURE create_rule(
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_rulv_tbl IN rulv_tbl_type,
149 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
150 PROCEDURE update_rule(
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_rulv_rec IN rulv_rec_type,
157 x_rulv_rec OUT NOCOPY rulv_rec_type);
158
159 --Bug# 3388812 : overloaded for LLAP to introduce p_edit_mode
160 PROCEDURE update_rule(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
163 x_return_status OUT NOCOPY VARCHAR2,
164 x_msg_count OUT NOCOPY NUMBER,
165 x_msg_data OUT NOCOPY VARCHAR2,
166 p_rulv_rec IN rulv_rec_type,
167 p_edit_mode IN VARCHAR2,
168 x_rulv_rec OUT NOCOPY rulv_rec_type);
169
170 PROCEDURE update_rule(
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_rulv_tbl IN rulv_tbl_type,
177 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
178
179 --Bug# 3388812 : overloaded for LLAP to introduce p_edit_mode
180 PROCEDURE update_rule(
181 p_api_version IN NUMBER,
182 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
183 x_return_status OUT NOCOPY VARCHAR2,
184 x_msg_count OUT NOCOPY NUMBER,
185 x_msg_data OUT NOCOPY VARCHAR2,
186 p_rulv_tbl IN rulv_tbl_type,
187 p_edit_mode IN VARCHAR2,
188 x_rulv_tbl OUT NOCOPY rulv_tbl_type);
189
190 PROCEDURE validate_rule(
191 p_api_version IN NUMBER,
192 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
193 x_return_status OUT NOCOPY VARCHAR2,
194 x_msg_count OUT NOCOPY NUMBER,
195 x_msg_data OUT NOCOPY VARCHAR2,
196 p_rulv_rec IN rulv_rec_type);
197 PROCEDURE validate_rule(
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_rulv_tbl IN rulv_tbl_type);
204 PROCEDURE delete_rule(
205 p_api_version IN NUMBER,
206 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
207 x_return_status OUT NOCOPY VARCHAR2,
208 x_msg_count OUT NOCOPY NUMBER,
209 x_msg_data OUT NOCOPY VARCHAR2,
210 p_rulv_rec IN rulv_rec_type);
211 PROCEDURE delete_rule(
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_rulv_tbl IN rulv_tbl_type);
218 PROCEDURE lock_rule(
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_rulv_rec IN rulv_rec_type);
225 PROCEDURE lock_rule(
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_rulv_tbl IN rulv_tbl_type);
232 PROCEDURE create_rule_group(
233 p_api_version IN NUMBER,
234 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_rgpv_rec IN rgpv_rec_type,
239 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
240 PROCEDURE create_rule_group(
241 p_api_version IN NUMBER,
242 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
243 x_return_status OUT NOCOPY VARCHAR2,
244 x_msg_count OUT NOCOPY NUMBER,
245 x_msg_data OUT NOCOPY VARCHAR2,
246 p_rgpv_tbl IN rgpv_tbl_type,
247 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
248 PROCEDURE update_rule_group(
249 p_api_version IN NUMBER,
250 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
251 x_return_status OUT NOCOPY VARCHAR2,
252 x_msg_count OUT NOCOPY NUMBER,
253 x_msg_data OUT NOCOPY VARCHAR2,
254 p_rgpv_rec IN rgpv_rec_type,
255 x_rgpv_rec OUT NOCOPY rgpv_rec_type);
256 PROCEDURE update_rule_group(
257 p_api_version IN NUMBER,
258 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
259 x_return_status OUT NOCOPY VARCHAR2,
260 x_msg_count OUT NOCOPY NUMBER,
261 x_msg_data OUT NOCOPY VARCHAR2,
262 p_rgpv_tbl IN rgpv_tbl_type,
263 x_rgpv_tbl OUT NOCOPY rgpv_tbl_type);
264 PROCEDURE delete_rule_group(
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_rgpv_rec IN rgpv_rec_type);
271 PROCEDURE delete_rule_group(
272 p_api_version IN NUMBER,
273 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_rgpv_tbl IN rgpv_tbl_type);
278 PROCEDURE lock_rule_group(
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_rgpv_rec IN rgpv_rec_type);
285 PROCEDURE lock_rule_group(
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_rgpv_tbl IN rgpv_tbl_type);
292 PROCEDURE validate_rule_group(
293 p_api_version IN NUMBER,
294 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_rgpv_rec IN rgpv_rec_type);
299 PROCEDURE validate_rule_group(
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
302 x_return_status OUT NOCOPY VARCHAR2,
303 x_msg_count OUT NOCOPY NUMBER,
304 x_msg_data OUT NOCOPY VARCHAR2,
305 p_rgpv_tbl IN rgpv_tbl_type);
306 PROCEDURE create_rg_mode_pty_role(
307 p_api_version IN NUMBER,
308 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_rmpv_rec IN rmpv_rec_type,
313 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
314 PROCEDURE create_rg_mode_pty_role(
315 p_api_version IN NUMBER,
316 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
317 x_return_status OUT NOCOPY VARCHAR2,
318 x_msg_count OUT NOCOPY NUMBER,
319 x_msg_data OUT NOCOPY VARCHAR2,
320 p_rmpv_tbl IN rmpv_tbl_type,
321 x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
322 PROCEDURE update_rg_mode_pty_role(
323 p_api_version IN NUMBER,
324 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
325 x_return_status OUT NOCOPY VARCHAR2,
326 x_msg_count OUT NOCOPY NUMBER,
327 x_msg_data OUT NOCOPY VARCHAR2,
328 p_rmpv_rec IN rmpv_rec_type,
329 x_rmpv_rec OUT NOCOPY rmpv_rec_type);
330 PROCEDURE update_rg_mode_pty_role(
331 p_api_version IN NUMBER,
332 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333 x_return_status OUT NOCOPY VARCHAR2,
334 x_msg_count OUT NOCOPY NUMBER,
335 x_msg_data OUT NOCOPY VARCHAR2,
336 p_rmpv_tbl IN rmpv_tbl_type,
337 x_rmpv_tbl OUT NOCOPY rmpv_tbl_type);
338 PROCEDURE delete_rg_mode_pty_role(
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_rmpv_rec IN rmpv_rec_type);
345 PROCEDURE delete_rg_mode_pty_role(
346 p_api_version IN NUMBER,
347 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
348 x_return_status OUT NOCOPY VARCHAR2,
349 x_msg_count OUT NOCOPY NUMBER,
350 x_msg_data OUT NOCOPY VARCHAR2,
351 p_rmpv_tbl IN rmpv_tbl_type);
352 PROCEDURE lock_rg_mode_pty_role(
353 p_api_version IN NUMBER,
354 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
355 x_return_status OUT NOCOPY VARCHAR2,
356 x_msg_count OUT NOCOPY NUMBER,
357 x_msg_data OUT NOCOPY VARCHAR2,
358 p_rmpv_rec IN rmpv_rec_type);
359 PROCEDURE lock_rg_mode_pty_role(
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_rmpv_tbl IN rmpv_tbl_type);
366 PROCEDURE validate_rg_mode_pty_role(
367 p_api_version IN NUMBER,
368 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
369 x_return_status OUT NOCOPY VARCHAR2,
370 x_msg_count OUT NOCOPY NUMBER,
371 x_msg_data OUT NOCOPY VARCHAR2,
372 p_rmpv_rec IN rmpv_rec_type);
373 PROCEDURE validate_rg_mode_pty_role(
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_rmpv_tbl IN rmpv_tbl_type);
380 /***********commented as OKL do not need to use these************/
381 /*
382 PROCEDURE create_cover_time(
383 p_api_version IN NUMBER,
384 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
385 x_return_status OUT NOCOPY VARCHAR2,
386 x_msg_count OUT NOCOPY NUMBER,
387 x_msg_data OUT NOCOPY VARCHAR2,
388 p_ctiv_rec IN ctiv_rec_type,
389 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
390 PROCEDURE create_cover_time(
391 p_api_version IN NUMBER,
392 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
393 x_return_status OUT NOCOPY VARCHAR2,
394 x_msg_count OUT NOCOPY NUMBER,
395 x_msg_data OUT NOCOPY VARCHAR2,
396 p_ctiv_tbl IN ctiv_tbl_type,
397 x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
398 PROCEDURE update_cover_time(
399 p_api_version IN NUMBER,
400 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
401 x_return_status OUT NOCOPY VARCHAR2,
402 x_msg_count OUT NOCOPY NUMBER,
403 x_msg_data OUT NOCOPY VARCHAR2,
404 p_ctiv_rec IN ctiv_rec_type,
405 x_ctiv_rec OUT NOCOPY ctiv_rec_type);
406 PROCEDURE update_cover_time(
407 p_api_version IN NUMBER,
408 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2,
412 p_ctiv_tbl IN ctiv_tbl_type,
413 x_ctiv_tbl OUT NOCOPY ctiv_tbl_type);
414 PROCEDURE delete_cover_time(
415 p_api_version IN NUMBER,
416 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
417 x_return_status OUT NOCOPY VARCHAR2,
418 x_msg_count OUT NOCOPY NUMBER,
419 x_msg_data OUT NOCOPY VARCHAR2,
420 p_ctiv_rec IN ctiv_rec_type);
421 PROCEDURE delete_cover_time(
422 p_api_version IN NUMBER,
423 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
424 x_return_status OUT NOCOPY VARCHAR2,
425 x_msg_count OUT NOCOPY NUMBER,
426 x_msg_data OUT NOCOPY VARCHAR2,
427 p_ctiv_tbl IN ctiv_tbl_type);
428 PROCEDURE lock_cover_time(
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_ctiv_rec IN ctiv_rec_type);
435 PROCEDURE lock_cover_time(
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_ctiv_tbl IN ctiv_tbl_type);
442 PROCEDURE validate_cover_time(
443 p_api_version IN NUMBER,
444 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
445 x_return_status OUT NOCOPY VARCHAR2,
446 x_msg_count OUT NOCOPY NUMBER,
447 x_msg_data OUT NOCOPY VARCHAR2,
448 p_ctiv_rec IN ctiv_rec_type);
449 PROCEDURE validate_cover_time(
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_ctiv_tbl IN ctiv_tbl_type);
456 PROCEDURE create_react_interval(
457 p_api_version IN NUMBER,
458 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
459 x_return_status OUT NOCOPY VARCHAR2,
460 x_msg_count OUT NOCOPY NUMBER,
461 x_msg_data OUT NOCOPY VARCHAR2,
462 p_rilv_rec IN rilv_rec_type,
463 x_rilv_rec OUT NOCOPY rilv_rec_type);
464 PROCEDURE create_react_interval(
465 p_api_version IN NUMBER,
466 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
467 x_return_status OUT NOCOPY VARCHAR2,
468 x_msg_count OUT NOCOPY NUMBER,
469 x_msg_data OUT NOCOPY VARCHAR2,
470 p_rilv_tbl IN rilv_tbl_type,
471 x_rilv_tbl OUT NOCOPY rilv_tbl_type);
472 PROCEDURE update_react_interval(
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_rilv_rec IN rilv_rec_type,
479 x_rilv_rec OUT NOCOPY rilv_rec_type);
480 PROCEDURE update_react_interval(
481 p_api_version IN NUMBER,
482 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
483 x_return_status OUT NOCOPY VARCHAR2,
484 x_msg_count OUT NOCOPY NUMBER,
485 x_msg_data OUT NOCOPY VARCHAR2,
486 p_rilv_tbl IN rilv_tbl_type,
487 x_rilv_tbl OUT NOCOPY rilv_tbl_type);
488 PROCEDURE delete_react_interval(
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_rilv_rec IN rilv_rec_type);
495 PROCEDURE delete_react_interval(
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_rilv_tbl IN rilv_tbl_type);
502 PROCEDURE lock_react_interval(
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_rilv_rec IN rilv_rec_type);
509 PROCEDURE lock_react_interval(
510 p_api_version IN NUMBER,
511 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
512 x_return_status OUT NOCOPY VARCHAR2,
513 x_msg_count OUT NOCOPY NUMBER,
514 x_msg_data OUT NOCOPY VARCHAR2,
515 p_rilv_tbl IN rilv_tbl_type);
516 PROCEDURE validate_react_interval(
517 p_api_version IN NUMBER,
518 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
519 x_return_status OUT NOCOPY VARCHAR2,
520 x_msg_count OUT NOCOPY NUMBER,
521 x_msg_data OUT NOCOPY VARCHAR2,
522 p_rilv_rec IN rilv_rec_type);
523 PROCEDURE validate_react_interval(
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_rilv_tbl IN rilv_tbl_type);
530 */
531 PROCEDURE add_language;
532 function rule_meaning(p_rle_code varchar2) return varchar2;
533 function get_new_code
534 (p_rgd_code in varchar2, p_rdf_code in varchar2, p_intent varchar2, p_number number)
535 return varchar2;
536 --
537 -- (select 'object_code' object_code,id1,id2,name value,description
538 -- from 'from_table'
539 -- where 'where_clause')
540 --
541 function get_object_sql(p_object_code in varchar2,p_clause_yn in varchar2) return varchar2;
542 function get_object_sql(p_object_code in varchar2,p_cpl_id in number) return varchar2;
543 function get_object_sql(p_object_code in varchar2) return varchar2;
544 function get_object_val
545 (p_object_code in varchar2, p_object_id1 in varchar2, p_object_id2 in varchar2)
546 return varchar2;
547 function get_object_dsc
548 (p_object_code in varchar2, p_object_id1 in varchar2, p_object_id2 in varchar2)
549 return varchar2;
550 procedure get_object_ids(
551 p_value in varchar2,
552 p_sql in varchar2,
553 x_object_code out nocopy varchar2,
554 x_id1 out nocopy varchar2,
555 x_id2 out nocopy varchar2,
556 x_desc out nocopy varchar2
557 );
558 procedure get_object_ids(
559 p_value in varchar2,
560 p_desc in varchar2,
561 p_sql in varchar2,
562 x_object_code out nocopy varchar2,
563 x_id1 out nocopy varchar2,
564 x_id2 out nocopy varchar2,
565 x_desc out nocopy varchar2
566 );
567 --
568 -- (select id, value, meaning description
569 -- from 'application_table_name'
570 -- where 'additional_where_clause' --get rid of where and order by)
571 --
572 function get_flex_sql(p_rdf_code in varchar2, p_col_name in varchar2,p_clause_yn in varchar2) return varchar2;
573 function get_flex_sql(p_rdf_code in varchar2, p_col_name in varchar2) return varchar2;
574 function get_flex_val(p_rdf_code in varchar2, p_col_name in varchar2, p_id in varchar2)
575 return varchar2;
576 function get_flex_dsc(p_rdf_code in varchar2, p_col_name in varchar2, p_id in varchar2)
577 return varchar2;
578 procedure get_flex_ids(
579 p_value varchar2,
580 p_sql in varchar2,
581 x_id out nocopy varchar2,
582 x_desc out nocopy varchar2
583 );
584 procedure get_flex_ids(
585 p_value varchar2,
586 p_desc varchar2,
587 p_sql in varchar2,
588 x_id out nocopy varchar2,
589 x_desc out nocopy varchar2
590 );
591 function euro_YN(rle_code varchar2, p_chr_id number) return varchar2;
592 function gen_comments return varchar2;
593 procedure no_comments;
594 function euro_yn(auth_org_id number) return varchar2;
595 END OKL_RULE_PUB;