[Home] [Help]
PACKAGE: APPS.OKC_SUBCLASS_PUB
Source
1 Package OKC_SUBCLASS_PUB AS
2 /* $Header: OKCPSCSS.pls 120.0 2005/05/25 22:46:25 appldev noship $ */
3
4 subtype scsv_rec_type is okc_subclass_pvt.scsv_rec_type;
5 subtype scsv_tbl_type is okc_subclass_pvt.scsv_tbl_type;
6 subtype srev_rec_type is okc_subclass_pvt.srev_rec_type;
7 subtype srev_tbl_type is okc_subclass_pvt.srev_tbl_type;
8 subtype srdv_rec_type is okc_subclass_pvt.srdv_rec_type;
9 subtype srdv_tbl_type is okc_subclass_pvt.srdv_tbl_type;
10 subtype rrdv_rec_type is okc_subclass_pvt.rrdv_rec_type;
11 subtype rrdv_tbl_type is okc_subclass_pvt.rrdv_tbl_type;
12 subtype stlv_rec_type is okc_subclass_pvt.stlv_rec_type;
13 subtype stlv_tbl_type is okc_subclass_pvt.stlv_tbl_type;
14 subtype lsrv_rec_type is okc_subclass_pvt.lsrv_rec_type;
15 subtype lsrv_tbl_type is okc_subclass_pvt.lsrv_tbl_type;
16 subtype lrgv_rec_type is okc_subclass_pvt.lrgv_rec_type;
17 subtype lrgv_tbl_type is okc_subclass_pvt.lrgv_tbl_type;
18 subtype srav_rec_type is okc_subclass_pvt.srav_rec_type;
19 subtype srav_tbl_type is okc_subclass_pvt.srav_tbl_type;
20
21 g_scsv_rec scsv_rec_type;
22 g_scsv_tbl scsv_tbl_type;
23 g_srev_rec srev_rec_type;
24 g_srev_tbl srev_tbl_type;
25 g_srdv_rec srdv_rec_type;
26 g_srdv_tbl srdv_tbl_type;
27 g_rrdv_rec rrdv_rec_type;
28 g_rrdv_tbl rrdv_tbl_type;
29 g_stlv_rec stlv_rec_type;
30 g_stlv_tbl stlv_tbl_type;
31 g_lsrv_rec lsrv_rec_type;
32 g_lsrv_tbl lsrv_tbl_type;
33 g_lrgv_rec lrgv_rec_type;
34 g_lrgv_tbl lrgv_tbl_type;
35 g_srav_rec srav_rec_type;
36 g_srav_tbl srav_tbl_type;
37
38 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
39 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
40 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLCODE';
41 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLERRM';
42 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_SUBCLASS_PUB';
43 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
44
45 PROCEDURE add_language;
46
47 PROCEDURE create_subclass(
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_scsv_rec IN scsv_rec_type,
54 x_scsv_rec OUT NOCOPY scsv_rec_type);
55
56 PROCEDURE create_subclass(
57 p_api_version IN NUMBER,
58 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 p_scsv_tbl IN scsv_tbl_type,
63 x_scsv_tbl OUT NOCOPY scsv_tbl_type);
64
65 PROCEDURE update_subclass(
66 p_api_version IN NUMBER,
67 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
68 x_return_status OUT NOCOPY VARCHAR2,
69 x_msg_count OUT NOCOPY NUMBER,
70 x_msg_data OUT NOCOPY VARCHAR2,
71 p_scsv_rec IN scsv_rec_type,
72 x_scsv_rec OUT NOCOPY scsv_rec_type);
73
74 PROCEDURE update_subclass(
75 p_api_version IN NUMBER,
76 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
77 x_return_status OUT NOCOPY VARCHAR2,
78 x_msg_count OUT NOCOPY NUMBER,
79 x_msg_data OUT NOCOPY VARCHAR2,
80 p_scsv_tbl IN scsv_tbl_type,
81 x_scsv_tbl OUT NOCOPY scsv_tbl_type);
82
83 PROCEDURE delete_subclass(
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_scsv_rec IN scsv_rec_type);
90
91 PROCEDURE delete_subclass(
92 p_api_version IN NUMBER,
93 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
94 x_return_status OUT NOCOPY VARCHAR2,
95 x_msg_count OUT NOCOPY NUMBER,
96 x_msg_data OUT NOCOPY VARCHAR2,
97 p_scsv_tbl IN scsv_tbl_type);
98
99 PROCEDURE lock_subclass(
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_scsv_rec IN scsv_rec_type);
106
107 PROCEDURE lock_subclass(
108 p_api_version IN NUMBER,
109 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
110 x_return_status OUT NOCOPY VARCHAR2,
111 x_msg_count OUT NOCOPY NUMBER,
112 x_msg_data OUT NOCOPY VARCHAR2,
113 p_scsv_tbl IN scsv_tbl_type);
114
115 PROCEDURE validate_subclass(
116 p_api_version IN NUMBER,
117 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_scsv_rec IN scsv_rec_type);
122
123 PROCEDURE validate_subclass(
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_scsv_tbl IN scsv_tbl_type);
130
131 PROCEDURE create_subclass_roles(
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_srev_rec IN srev_rec_type,
138 x_srev_rec OUT NOCOPY srev_rec_type);
139
140 PROCEDURE create_subclass_roles(
141 p_api_version IN NUMBER,
142 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
143 x_return_status OUT NOCOPY VARCHAR2,
144 x_msg_count OUT NOCOPY NUMBER,
145 x_msg_data OUT NOCOPY VARCHAR2,
146 p_srev_tbl IN srev_tbl_type,
147 x_srev_tbl OUT NOCOPY srev_tbl_type);
148
149 PROCEDURE update_subclass_roles(
150 p_api_version IN NUMBER,
151 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
152 x_return_status OUT NOCOPY VARCHAR2,
153 x_msg_count OUT NOCOPY NUMBER,
154 x_msg_data OUT NOCOPY VARCHAR2,
155 p_srev_rec IN srev_rec_type,
156 x_srev_rec OUT NOCOPY srev_rec_type);
157
158 PROCEDURE update_subclass_roles(
159 p_api_version IN NUMBER,
160 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
161 x_return_status OUT NOCOPY VARCHAR2,
162 x_msg_count OUT NOCOPY NUMBER,
163 x_msg_data OUT NOCOPY VARCHAR2,
164 p_srev_tbl IN srev_tbl_type,
165 x_srev_tbl OUT NOCOPY srev_tbl_type);
166
167 PROCEDURE delete_subclass_roles(
168 p_api_version IN NUMBER,
169 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
170 x_return_status OUT NOCOPY VARCHAR2,
171 x_msg_count OUT NOCOPY NUMBER,
172 x_msg_data OUT NOCOPY VARCHAR2,
173 p_srev_rec IN srev_rec_type);
174
175 PROCEDURE delete_subclass_roles(
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_srev_tbl IN srev_tbl_type);
182
183 PROCEDURE lock_subclass_roles(
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_srev_rec IN srev_rec_type);
190
191 PROCEDURE lock_subclass_roles(
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_srev_tbl IN srev_tbl_type);
198
199 PROCEDURE validate_subclass_roles(
200 p_api_version IN NUMBER,
201 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
202 x_return_status OUT NOCOPY VARCHAR2,
203 x_msg_count OUT NOCOPY NUMBER,
204 x_msg_data OUT NOCOPY VARCHAR2,
205 p_srev_rec IN srev_rec_type);
206
207 PROCEDURE validate_subclass_roles(
208 p_api_version IN NUMBER,
209 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
210 x_return_status OUT NOCOPY VARCHAR2,
211 x_msg_count OUT NOCOPY NUMBER,
212 x_msg_data OUT NOCOPY VARCHAR2,
213 p_srev_tbl IN srev_tbl_type);
214
215 PROCEDURE create_subclass_rg_defs(
216 p_api_version IN NUMBER,
217 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
218 x_return_status OUT NOCOPY VARCHAR2,
219 x_msg_count OUT NOCOPY NUMBER,
220 x_msg_data OUT NOCOPY VARCHAR2,
221 p_srdv_rec IN srdv_rec_type,
222 x_srdv_rec OUT NOCOPY srdv_rec_type);
223
224 PROCEDURE create_subclass_rg_defs(
225 p_api_version IN NUMBER,
226 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
227 x_return_status OUT NOCOPY VARCHAR2,
228 x_msg_count OUT NOCOPY NUMBER,
229 x_msg_data OUT NOCOPY VARCHAR2,
230 p_srdv_tbl IN srdv_tbl_type,
231 x_srdv_tbl OUT NOCOPY srdv_tbl_type);
232
233 PROCEDURE update_subclass_rg_defs(
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_srdv_rec IN srdv_rec_type,
240 x_srdv_rec OUT NOCOPY srdv_rec_type);
241
242 PROCEDURE update_subclass_rg_defs(
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_srdv_tbl IN srdv_tbl_type,
249 x_srdv_tbl OUT NOCOPY srdv_tbl_type);
250
251 PROCEDURE delete_subclass_rg_defs(
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_srdv_rec IN srdv_rec_type);
258
259 PROCEDURE delete_subclass_rg_defs(
260 p_api_version IN NUMBER,
261 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
262 x_return_status OUT NOCOPY VARCHAR2,
263 x_msg_count OUT NOCOPY NUMBER,
264 x_msg_data OUT NOCOPY VARCHAR2,
265 p_srdv_tbl IN srdv_tbl_type);
266
267 PROCEDURE lock_subclass_rg_defs(
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_srdv_rec IN srdv_rec_type);
274
275 PROCEDURE lock_subclass_rg_defs(
276 p_api_version IN NUMBER,
277 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
278 x_return_status OUT NOCOPY VARCHAR2,
279 x_msg_count OUT NOCOPY NUMBER,
280 x_msg_data OUT NOCOPY VARCHAR2,
281 p_srdv_tbl IN srdv_tbl_type);
282
283 PROCEDURE validate_subclass_rg_defs(
284 p_api_version IN NUMBER,
285 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
286 x_return_status OUT NOCOPY VARCHAR2,
287 x_msg_count OUT NOCOPY NUMBER,
288 x_msg_data OUT NOCOPY VARCHAR2,
289 p_srdv_rec IN srdv_rec_type);
290
291 PROCEDURE validate_subclass_rg_defs(
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
294 x_return_status OUT NOCOPY VARCHAR2,
295 x_msg_count OUT NOCOPY NUMBER,
296 x_msg_data OUT NOCOPY VARCHAR2,
297 p_srdv_tbl IN srdv_tbl_type);
298
299 PROCEDURE create_rg_role_defs(
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_rrdv_rec IN rrdv_rec_type,
306 x_rrdv_rec OUT NOCOPY rrdv_rec_type);
307
308 PROCEDURE create_rg_role_defs(
309 p_api_version IN NUMBER,
310 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_rrdv_tbl IN rrdv_tbl_type,
315 x_rrdv_tbl OUT NOCOPY rrdv_tbl_type);
316
317 PROCEDURE update_rg_role_defs(
318 p_api_version IN NUMBER,
319 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
320 x_return_status OUT NOCOPY VARCHAR2,
321 x_msg_count OUT NOCOPY NUMBER,
322 x_msg_data OUT NOCOPY VARCHAR2,
323 p_rrdv_rec IN rrdv_rec_type,
324 x_rrdv_rec OUT NOCOPY rrdv_rec_type);
325
326 PROCEDURE update_rg_role_defs(
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_rrdv_tbl IN rrdv_tbl_type,
333 x_rrdv_tbl OUT NOCOPY rrdv_tbl_type);
334
335 PROCEDURE delete_rg_role_defs(
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_rrdv_rec IN rrdv_rec_type);
342
343 PROCEDURE delete_rg_role_defs(
344 p_api_version IN NUMBER,
345 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
346 x_return_status OUT NOCOPY VARCHAR2,
347 x_msg_count OUT NOCOPY NUMBER,
348 x_msg_data OUT NOCOPY VARCHAR2,
349 p_rrdv_tbl IN rrdv_tbl_type);
350
351 PROCEDURE lock_rg_role_defs(
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_rrdv_rec IN rrdv_rec_type);
358
359 PROCEDURE lock_rg_role_defs(
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_rrdv_tbl IN rrdv_tbl_type);
366
367 PROCEDURE validate_rg_role_defs(
368 p_api_version IN NUMBER,
369 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
370 x_return_status OUT NOCOPY VARCHAR2,
371 x_msg_count OUT NOCOPY NUMBER,
372 x_msg_data OUT NOCOPY VARCHAR2,
373 p_rrdv_rec IN rrdv_rec_type);
374
375 PROCEDURE validate_rg_role_defs(
376 p_api_version IN NUMBER,
377 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
378 x_return_status OUT NOCOPY VARCHAR2,
379 x_msg_count OUT NOCOPY NUMBER,
380 x_msg_data OUT NOCOPY VARCHAR2,
381 p_rrdv_tbl IN rrdv_tbl_type);
382
383 PROCEDURE create_subclass_top_line(
384 p_api_version IN NUMBER,
385 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
386 x_return_status OUT NOCOPY VARCHAR2,
387 x_msg_count OUT NOCOPY NUMBER,
388 x_msg_data OUT NOCOPY VARCHAR2,
389 p_stlv_rec IN stlv_rec_type,
390 x_stlv_rec OUT NOCOPY stlv_rec_type);
391
392 PROCEDURE create_subclass_top_line(
393 p_api_version IN NUMBER,
394 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
395 x_return_status OUT NOCOPY VARCHAR2,
396 x_msg_count OUT NOCOPY NUMBER,
397 x_msg_data OUT NOCOPY VARCHAR2,
398 p_stlv_tbl IN stlv_tbl_type,
399 x_stlv_tbl OUT NOCOPY stlv_tbl_type);
400
401 PROCEDURE update_subclass_top_line(
402 p_api_version IN NUMBER,
403 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
404 x_return_status OUT NOCOPY VARCHAR2,
405 x_msg_count OUT NOCOPY NUMBER,
406 x_msg_data OUT NOCOPY VARCHAR2,
407 p_stlv_rec IN stlv_rec_type,
408 x_stlv_rec OUT NOCOPY stlv_rec_type);
409
410 PROCEDURE update_subclass_top_line(
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_stlv_tbl IN stlv_tbl_type,
417 x_stlv_tbl OUT NOCOPY stlv_tbl_type);
418
419 PROCEDURE delete_subclass_top_line(
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_stlv_rec IN stlv_rec_type);
426
427 PROCEDURE delete_subclass_top_line(
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_stlv_tbl IN stlv_tbl_type);
434
435 PROCEDURE lock_subclass_top_line(
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_stlv_rec IN stlv_rec_type);
442
443 PROCEDURE lock_subclass_top_line(
444 p_api_version IN NUMBER,
445 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
446 x_return_status OUT NOCOPY VARCHAR2,
447 x_msg_count OUT NOCOPY NUMBER,
448 x_msg_data OUT NOCOPY VARCHAR2,
449 p_stlv_tbl IN stlv_tbl_type);
450
451 PROCEDURE validate_subclass_top_line(
452 p_api_version IN NUMBER,
453 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
454 x_return_status OUT NOCOPY VARCHAR2,
455 x_msg_count OUT NOCOPY NUMBER,
456 x_msg_data OUT NOCOPY VARCHAR2,
457 p_stlv_rec IN stlv_rec_type);
458
459 PROCEDURE validate_subclass_top_line(
460 p_api_version IN NUMBER,
461 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
462 x_return_status OUT NOCOPY VARCHAR2,
463 x_msg_count OUT NOCOPY NUMBER,
464 x_msg_data OUT NOCOPY VARCHAR2,
465 p_stlv_tbl IN stlv_tbl_type);
466
467 PROCEDURE create_line_style_roles(
468 p_api_version IN NUMBER,
469 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_lsrv_rec IN lsrv_rec_type,
474 x_lsrv_rec OUT NOCOPY lsrv_rec_type);
475
476 PROCEDURE create_line_style_roles(
477 p_api_version IN NUMBER,
478 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
479 x_return_status OUT NOCOPY VARCHAR2,
480 x_msg_count OUT NOCOPY NUMBER,
481 x_msg_data OUT NOCOPY VARCHAR2,
482 p_lsrv_tbl IN lsrv_tbl_type,
483 x_lsrv_tbl OUT NOCOPY lsrv_tbl_type);
484
485 PROCEDURE update_line_style_roles(
486 p_api_version IN NUMBER,
487 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
488 x_return_status OUT NOCOPY VARCHAR2,
489 x_msg_count OUT NOCOPY NUMBER,
490 x_msg_data OUT NOCOPY VARCHAR2,
491 p_lsrv_rec IN lsrv_rec_type,
492 x_lsrv_rec OUT NOCOPY lsrv_rec_type);
493
494 PROCEDURE update_line_style_roles(
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_lsrv_tbl IN lsrv_tbl_type,
501 x_lsrv_tbl OUT NOCOPY lsrv_tbl_type);
502
503 PROCEDURE delete_line_style_roles(
504 p_api_version IN NUMBER,
505 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
506 x_return_status OUT NOCOPY VARCHAR2,
507 x_msg_count OUT NOCOPY NUMBER,
508 x_msg_data OUT NOCOPY VARCHAR2,
509 p_lsrv_rec IN lsrv_rec_type);
510
511 PROCEDURE delete_line_style_roles(
512 p_api_version IN NUMBER,
513 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
514 x_return_status OUT NOCOPY VARCHAR2,
515 x_msg_count OUT NOCOPY NUMBER,
516 x_msg_data OUT NOCOPY VARCHAR2,
517 p_lsrv_tbl IN lsrv_tbl_type);
518
519 PROCEDURE lock_line_style_roles(
520 p_api_version IN NUMBER,
521 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
522 x_return_status OUT NOCOPY VARCHAR2,
523 x_msg_count OUT NOCOPY NUMBER,
524 x_msg_data OUT NOCOPY VARCHAR2,
525 p_lsrv_rec IN lsrv_rec_type);
526
527 PROCEDURE lock_line_style_roles(
528 p_api_version IN NUMBER,
529 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
530 x_return_status OUT NOCOPY VARCHAR2,
531 x_msg_count OUT NOCOPY NUMBER,
532 x_msg_data OUT NOCOPY VARCHAR2,
533 p_lsrv_tbl IN lsrv_tbl_type);
534
535 PROCEDURE validate_line_style_roles(
536 p_api_version IN NUMBER,
537 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
538 x_return_status OUT NOCOPY VARCHAR2,
539 x_msg_count OUT NOCOPY NUMBER,
540 x_msg_data OUT NOCOPY VARCHAR2,
541 p_lsrv_rec IN lsrv_rec_type);
542
543 PROCEDURE validate_line_style_roles(
544 p_api_version IN NUMBER,
545 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
546 x_return_status OUT NOCOPY VARCHAR2,
547 x_msg_count OUT NOCOPY NUMBER,
548 x_msg_data OUT NOCOPY VARCHAR2,
549 p_lsrv_tbl IN lsrv_tbl_type);
550
551 PROCEDURE create_lse_rule_groups(
552 p_api_version IN NUMBER,
553 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
554 x_return_status OUT NOCOPY VARCHAR2,
555 x_msg_count OUT NOCOPY NUMBER,
556 x_msg_data OUT NOCOPY VARCHAR2,
557 p_lrgv_rec IN lrgv_rec_type,
558 x_lrgv_rec OUT NOCOPY lrgv_rec_type);
559
560 PROCEDURE create_lse_rule_groups(
561 p_api_version IN NUMBER,
562 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
563 x_return_status OUT NOCOPY VARCHAR2,
564 x_msg_count OUT NOCOPY NUMBER,
565 x_msg_data OUT NOCOPY VARCHAR2,
566 p_lrgv_tbl IN lrgv_tbl_type,
567 x_lrgv_tbl OUT NOCOPY lrgv_tbl_type);
568
569 PROCEDURE update_lse_rule_groups(
570 p_api_version IN NUMBER,
571 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
572 x_return_status OUT NOCOPY VARCHAR2,
573 x_msg_count OUT NOCOPY NUMBER,
574 x_msg_data OUT NOCOPY VARCHAR2,
575 p_lrgv_rec IN lrgv_rec_type,
576 x_lrgv_rec OUT NOCOPY lrgv_rec_type);
577
578 PROCEDURE update_lse_rule_groups(
579 p_api_version IN NUMBER,
580 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
581 x_return_status OUT NOCOPY VARCHAR2,
582 x_msg_count OUT NOCOPY NUMBER,
583 x_msg_data OUT NOCOPY VARCHAR2,
584 p_lrgv_tbl IN lrgv_tbl_type,
585 x_lrgv_tbl OUT NOCOPY lrgv_tbl_type);
586
587 PROCEDURE delete_lse_rule_groups(
588 p_api_version IN NUMBER,
589 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
590 x_return_status OUT NOCOPY VARCHAR2,
591 x_msg_count OUT NOCOPY NUMBER,
592 x_msg_data OUT NOCOPY VARCHAR2,
593 p_lrgv_rec IN lrgv_rec_type);
594
595 PROCEDURE delete_lse_rule_groups(
596 p_api_version IN NUMBER,
597 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
598 x_return_status OUT NOCOPY VARCHAR2,
599 x_msg_count OUT NOCOPY NUMBER,
600 x_msg_data OUT NOCOPY VARCHAR2,
601 p_lrgv_tbl IN lrgv_tbl_type);
602
603 PROCEDURE lock_lse_rule_groups(
604 p_api_version IN NUMBER,
605 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
606 x_return_status OUT NOCOPY VARCHAR2,
607 x_msg_count OUT NOCOPY NUMBER,
608 x_msg_data OUT NOCOPY VARCHAR2,
609 p_lrgv_rec IN lrgv_rec_type);
610
611 PROCEDURE lock_lse_rule_groups(
612 p_api_version IN NUMBER,
613 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
614 x_return_status OUT NOCOPY VARCHAR2,
615 x_msg_count OUT NOCOPY NUMBER,
616 x_msg_data OUT NOCOPY VARCHAR2,
617 p_lrgv_tbl IN lrgv_tbl_type);
618
619 PROCEDURE validate_lse_rule_groups(
620 p_api_version IN NUMBER,
621 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
622 x_return_status OUT NOCOPY VARCHAR2,
623 x_msg_count OUT NOCOPY NUMBER,
624 x_msg_data OUT NOCOPY VARCHAR2,
625 p_lrgv_rec IN lrgv_rec_type);
626
627 PROCEDURE validate_lse_rule_groups(
628 p_api_version IN NUMBER,
629 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
630 x_return_status OUT NOCOPY VARCHAR2,
631 x_msg_count OUT NOCOPY NUMBER,
632 x_msg_data OUT NOCOPY VARCHAR2,
633 p_lrgv_tbl IN lrgv_tbl_type);
634
635 PROCEDURE create_subclass_resps(
636 p_api_version IN NUMBER,
637 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
638 x_return_status OUT NOCOPY VARCHAR2,
639 x_msg_count OUT NOCOPY NUMBER,
640 x_msg_data OUT NOCOPY VARCHAR2,
641 p_srav_rec IN srav_rec_type,
642 x_srav_rec OUT NOCOPY srav_rec_type);
643
644 PROCEDURE create_subclass_resps(
645 p_api_version IN NUMBER,
646 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
647 x_return_status OUT NOCOPY VARCHAR2,
648 x_msg_count OUT NOCOPY NUMBER,
649 x_msg_data OUT NOCOPY VARCHAR2,
650 p_srav_tbl IN srav_tbl_type,
651 x_srav_tbl OUT NOCOPY srav_tbl_type);
652
653 PROCEDURE update_subclass_resps(
654 p_api_version IN NUMBER,
655 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
656 x_return_status OUT NOCOPY VARCHAR2,
657 x_msg_count OUT NOCOPY NUMBER,
658 x_msg_data OUT NOCOPY VARCHAR2,
659 p_srav_rec IN srav_rec_type,
660 x_srav_rec OUT NOCOPY srav_rec_type);
661
662 PROCEDURE update_subclass_resps(
663 p_api_version IN NUMBER,
664 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
665 x_return_status OUT NOCOPY VARCHAR2,
666 x_msg_count OUT NOCOPY NUMBER,
667 x_msg_data OUT NOCOPY VARCHAR2,
668 p_srav_tbl IN srav_tbl_type,
669 x_srav_tbl OUT NOCOPY srav_tbl_type);
670
671 PROCEDURE delete_subclass_resps(
672 p_api_version IN NUMBER,
673 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
674 x_return_status OUT NOCOPY VARCHAR2,
675 x_msg_count OUT NOCOPY NUMBER,
676 x_msg_data OUT NOCOPY VARCHAR2,
677 p_srav_rec IN srav_rec_type);
678
679 PROCEDURE delete_subclass_resps(
680 p_api_version IN NUMBER,
681 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
682 x_return_status OUT NOCOPY VARCHAR2,
683 x_msg_count OUT NOCOPY NUMBER,
684 x_msg_data OUT NOCOPY VARCHAR2,
685 p_srav_tbl IN srav_tbl_type);
686
687 PROCEDURE lock_subclass_resps(
688 p_api_version IN NUMBER,
689 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
690 x_return_status OUT NOCOPY VARCHAR2,
691 x_msg_count OUT NOCOPY NUMBER,
692 x_msg_data OUT NOCOPY VARCHAR2,
693 p_srav_rec IN srav_rec_type);
694
695 PROCEDURE lock_subclass_resps(
696 p_api_version IN NUMBER,
697 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
698 x_return_status OUT NOCOPY VARCHAR2,
699 x_msg_count OUT NOCOPY NUMBER,
700 x_msg_data OUT NOCOPY VARCHAR2,
701 p_srav_tbl IN srav_tbl_type);
702
703 PROCEDURE validate_subclass_resps(
704 p_api_version IN NUMBER,
705 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
706 x_return_status OUT NOCOPY VARCHAR2,
707 x_msg_count OUT NOCOPY NUMBER,
708 x_msg_data OUT NOCOPY VARCHAR2,
709 p_srav_rec IN srav_rec_type);
710
711 PROCEDURE validate_subclass_resps(
712 p_api_version IN NUMBER,
713 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
714 x_return_status OUT NOCOPY VARCHAR2,
715 x_msg_count OUT NOCOPY NUMBER,
716 x_msg_data OUT NOCOPY VARCHAR2,
717 p_srav_tbl IN srav_tbl_type);
718
719 PROCEDURE copy_category(
720 p_api_version IN NUMBER,
721 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
722 x_return_status OUT NOCOPY VARCHAR2,
723 x_msg_count OUT NOCOPY NUMBER,
724 x_msg_data OUT NOCOPY VARCHAR2,
725 p_copy_from_scs_code IN VARCHAR2,
726 p_new_scs_name IN VARCHAR2,
727 p_new_scs_desc IN VARCHAR2,
728 x_scsv_rec OUT NOCOPY scsv_rec_type ) ;
729
730 END okc_subclass_pub;