DBA Data[Home] [Help]

PACKAGE: APPS.OKC_SUBCLASS_PVT

Source


1 Package OKC_SUBCLASS_PVT AS
2 /* $Header: OKCCSCSS.pls 120.0 2005/05/26 09:57:05 appldev noship $ */
3 
4  subtype scsv_rec_type is okc_scs_pvt.scsv_rec_type;
5  subtype scsv_tbl_type is okc_scs_pvt.scsv_tbl_type;
6  subtype srev_rec_type is okc_sre_pvt.srev_rec_type;
7  subtype srev_tbl_type is okc_sre_pvt.srev_tbl_type;
8  subtype srdv_rec_type is okc_srd_pvt.srdv_rec_type;
9  subtype srdv_tbl_type is okc_srd_pvt.srdv_tbl_type;
10  subtype rrdv_rec_type is okc_rrd_pvt.rrdv_rec_type;
11  subtype rrdv_tbl_type is okc_rrd_pvt.rrdv_tbl_type;
12  subtype stlv_rec_type is okc_stl_pvt.stlv_rec_type;
13  subtype stlv_tbl_type is okc_stl_pvt.stlv_tbl_type;
14  subtype lsrv_rec_type is okc_lsr_pvt.lsrv_rec_type;
15  subtype lsrv_tbl_type is okc_lsr_pvt.lsrv_tbl_type;
16  subtype lrgv_rec_type is okc_lrg_pvt.lrgv_rec_type;
17  subtype lrgv_tbl_type is okc_lrg_pvt.lrgv_tbl_type;
18  subtype srav_rec_type is okc_sra_pvt.srav_rec_type;
19  subtype srav_tbl_type is okc_sra_pvt.srav_tbl_type;
20 
21  PROCEDURE add_language;
22 
23  PROCEDURE create_subclass(
24     p_api_version                  IN NUMBER,
25     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
26     x_return_status                OUT NOCOPY VARCHAR2,
27     x_msg_count                    OUT NOCOPY NUMBER,
28     x_msg_data                     OUT NOCOPY VARCHAR2,
29     p_scsv_rec                     IN scsv_rec_type,
30     x_scsv_rec                     OUT NOCOPY scsv_rec_type);
31 
32  PROCEDURE create_subclass(
33     p_api_version                  IN NUMBER,
34     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
35     x_return_status                OUT NOCOPY VARCHAR2,
36     x_msg_count                    OUT NOCOPY NUMBER,
37     x_msg_data                     OUT NOCOPY VARCHAR2,
38     p_scsv_tbl                     IN  scsv_tbl_type,
39     x_scsv_tbl                     OUT NOCOPY scsv_tbl_type);
40 
41  PROCEDURE update_subclass(
42     p_api_version                  IN NUMBER,
43     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
44     x_return_status                OUT NOCOPY VARCHAR2,
45     x_msg_count                    OUT NOCOPY NUMBER,
46     x_msg_data                     OUT NOCOPY VARCHAR2,
47     p_scsv_rec                     IN scsv_rec_type,
48     x_scsv_rec                     OUT NOCOPY scsv_rec_type);
49 
50  PROCEDURE update_subclass(
51     p_api_version                  IN NUMBER,
52     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
53     x_return_status                OUT NOCOPY VARCHAR2,
54     x_msg_count                    OUT NOCOPY NUMBER,
55     x_msg_data                     OUT NOCOPY VARCHAR2,
56     p_scsv_tbl                     IN  scsv_tbl_type,
57     x_scsv_tbl                     OUT NOCOPY scsv_tbl_type);
58 
59  PROCEDURE delete_subclass(
60     p_api_version                  IN NUMBER,
61     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62     x_return_status                OUT NOCOPY VARCHAR2,
63     x_msg_count                    OUT NOCOPY NUMBER,
64     x_msg_data                     OUT NOCOPY VARCHAR2,
65     p_scsv_rec                     IN scsv_rec_type);
66 
67  PROCEDURE delete_subclass(
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_scsv_tbl                     IN  scsv_tbl_type);
74 
75  PROCEDURE lock_subclass(
76     p_api_version                  IN NUMBER,
77     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78     x_return_status                OUT NOCOPY VARCHAR2,
79     x_msg_count                    OUT NOCOPY NUMBER,
80     x_msg_data                     OUT NOCOPY VARCHAR2,
81     p_scsv_rec                     IN scsv_rec_type);
82 
83  PROCEDURE lock_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_tbl                     IN  scsv_tbl_type);
90 
91  PROCEDURE validate_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_rec                     IN scsv_rec_type);
98 
99  PROCEDURE validate_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_tbl                     IN  scsv_tbl_type);
106 
107  PROCEDURE create_subclass_roles(
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_srev_rec                     IN srev_rec_type,
114     x_srev_rec                     OUT NOCOPY srev_rec_type);
115 
116  PROCEDURE create_subclass_roles(
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_srev_tbl                     IN  srev_tbl_type,
123     x_srev_tbl                     OUT NOCOPY srev_tbl_type);
124 
125  PROCEDURE update_subclass_roles(
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_srev_rec                     IN srev_rec_type,
132     x_srev_rec                     OUT NOCOPY srev_rec_type);
133 
134  PROCEDURE update_subclass_roles(
135     p_api_version                  IN NUMBER,
136     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
137     x_return_status                OUT NOCOPY VARCHAR2,
138     x_msg_count                    OUT NOCOPY NUMBER,
139     x_msg_data                     OUT NOCOPY VARCHAR2,
140     p_srev_tbl                     IN  srev_tbl_type,
141     x_srev_tbl                     OUT NOCOPY srev_tbl_type);
142 
143  PROCEDURE delete_subclass_roles(
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_srev_rec                     IN srev_rec_type);
150 
151  PROCEDURE delete_subclass_roles(
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_srev_tbl                     IN  srev_tbl_type);
158 
159  PROCEDURE lock_subclass_roles(
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_srev_rec                     IN srev_rec_type);
166 
167  PROCEDURE lock_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_tbl                     IN  srev_tbl_type);
174 
175  PROCEDURE validate_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_rec                     IN srev_rec_type);
182 
183  PROCEDURE validate_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_tbl                     IN  srev_tbl_type);
190 
191  PROCEDURE create_subclass_rg_defs(
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_srdv_rec                     IN srdv_rec_type,
198     x_srdv_rec                     OUT NOCOPY srdv_rec_type);
199 
200  PROCEDURE create_subclass_rg_defs(
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_srdv_tbl                     IN  srdv_tbl_type,
207     x_srdv_tbl                     OUT NOCOPY srdv_tbl_type);
208 
209  PROCEDURE update_subclass_rg_defs(
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_srdv_rec                     IN srdv_rec_type,
216     x_srdv_rec                     OUT NOCOPY srdv_rec_type);
217 
218  PROCEDURE update_subclass_rg_defs(
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_srdv_tbl                     IN  srdv_tbl_type,
225     x_srdv_tbl                     OUT NOCOPY srdv_tbl_type);
226 
227  PROCEDURE delete_subclass_rg_defs(
228     p_api_version                  IN NUMBER,
229     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
230     x_return_status                OUT NOCOPY VARCHAR2,
231     x_msg_count                    OUT NOCOPY NUMBER,
232     x_msg_data                     OUT NOCOPY VARCHAR2,
233     p_srdv_rec                     IN srdv_rec_type);
234 
235  PROCEDURE delete_subclass_rg_defs(
236     p_api_version                  IN NUMBER,
237     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
238     x_return_status                OUT NOCOPY VARCHAR2,
239     x_msg_count                    OUT NOCOPY NUMBER,
240     x_msg_data                     OUT NOCOPY VARCHAR2,
241     p_srdv_tbl                     IN  srdv_tbl_type);
242 
243  PROCEDURE lock_subclass_rg_defs(
244     p_api_version                  IN NUMBER,
245     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
246     x_return_status                OUT NOCOPY VARCHAR2,
247     x_msg_count                    OUT NOCOPY NUMBER,
248     x_msg_data                     OUT NOCOPY VARCHAR2,
249     p_srdv_rec                     IN srdv_rec_type);
250 
251  PROCEDURE lock_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_tbl                     IN  srdv_tbl_type);
258 
259  PROCEDURE validate_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_rec                     IN srdv_rec_type);
266 
267  PROCEDURE validate_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_tbl                     IN  srdv_tbl_type);
274 
275  PROCEDURE create_rg_role_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_rrdv_rec                     IN rrdv_rec_type,
282     x_rrdv_rec                     OUT NOCOPY rrdv_rec_type);
283 
284  PROCEDURE create_rg_role_defs(
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_rrdv_tbl                     IN  rrdv_tbl_type,
291     x_rrdv_tbl                     OUT NOCOPY rrdv_tbl_type);
292 
293  PROCEDURE update_rg_role_defs(
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_rrdv_rec                     IN rrdv_rec_type,
300     x_rrdv_rec                     OUT NOCOPY rrdv_rec_type);
301 
302  PROCEDURE update_rg_role_defs(
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_rrdv_tbl                     IN  rrdv_tbl_type,
309     x_rrdv_tbl                     OUT NOCOPY rrdv_tbl_type);
310 
311  PROCEDURE delete_rg_role_defs(
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_rrdv_rec                     IN rrdv_rec_type);
318 
319  PROCEDURE delete_rg_role_defs(
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_rrdv_tbl                     IN  rrdv_tbl_type);
326 
327  PROCEDURE lock_rg_role_defs(
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_rrdv_rec                     IN rrdv_rec_type);
334 
335  PROCEDURE lock_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_tbl                     IN  rrdv_tbl_type);
342 
343  PROCEDURE validate_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_rec                     IN rrdv_rec_type);
350 
351  PROCEDURE validate_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_tbl                     IN  rrdv_tbl_type);
358 
359  PROCEDURE create_subclass_top_line(
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_stlv_rec                     IN stlv_rec_type,
366     x_stlv_rec                     OUT NOCOPY stlv_rec_type);
367 
368  PROCEDURE create_subclass_top_line(
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_stlv_tbl                     IN  stlv_tbl_type,
375     x_stlv_tbl                     OUT NOCOPY stlv_tbl_type);
376 
377  PROCEDURE update_subclass_top_line(
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_stlv_rec                     IN stlv_rec_type,
384     x_stlv_rec                     OUT NOCOPY stlv_rec_type);
385 
386  PROCEDURE update_subclass_top_line(
387     p_api_version                  IN NUMBER,
388     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
389     x_return_status                OUT NOCOPY VARCHAR2,
390     x_msg_count                    OUT NOCOPY NUMBER,
391     x_msg_data                     OUT NOCOPY VARCHAR2,
392     p_stlv_tbl                     IN  stlv_tbl_type,
393     x_stlv_tbl                     OUT NOCOPY stlv_tbl_type);
394 
395  PROCEDURE delete_subclass_top_line(
396     p_api_version                  IN NUMBER,
397     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
398     x_return_status                OUT NOCOPY VARCHAR2,
399     x_msg_count                    OUT NOCOPY NUMBER,
400     x_msg_data                     OUT NOCOPY VARCHAR2,
401     p_stlv_rec                     IN stlv_rec_type);
402 
403  PROCEDURE delete_subclass_top_line(
404     p_api_version                  IN NUMBER,
405     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
406     x_return_status                OUT NOCOPY VARCHAR2,
407     x_msg_count                    OUT NOCOPY NUMBER,
408     x_msg_data                     OUT NOCOPY VARCHAR2,
409     p_stlv_tbl                     IN  stlv_tbl_type);
410 
411  PROCEDURE lock_subclass_top_line(
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_stlv_rec                     IN stlv_rec_type);
418 
419  PROCEDURE lock_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_tbl                     IN  stlv_tbl_type);
426 
427  PROCEDURE validate_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_rec                     IN stlv_rec_type);
434 
435  PROCEDURE validate_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_tbl                     IN  stlv_tbl_type);
442 
443  PROCEDURE create_line_style_roles(
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_lsrv_rec                     IN lsrv_rec_type,
450     x_lsrv_rec                     OUT NOCOPY lsrv_rec_type);
451 
452  PROCEDURE create_line_style_roles(
453     p_api_version                  IN NUMBER,
454     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
455     x_return_status                OUT NOCOPY VARCHAR2,
456     x_msg_count                    OUT NOCOPY NUMBER,
457     x_msg_data                     OUT NOCOPY VARCHAR2,
458     p_lsrv_tbl                     IN  lsrv_tbl_type,
459     x_lsrv_tbl                     OUT NOCOPY lsrv_tbl_type);
460 
461  PROCEDURE update_line_style_roles(
462     p_api_version                  IN NUMBER,
463     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
464     x_return_status                OUT NOCOPY VARCHAR2,
465     x_msg_count                    OUT NOCOPY NUMBER,
466     x_msg_data                     OUT NOCOPY VARCHAR2,
467     p_lsrv_rec                     IN lsrv_rec_type,
468     x_lsrv_rec                     OUT NOCOPY lsrv_rec_type);
469 
470  PROCEDURE update_line_style_roles(
471     p_api_version                  IN NUMBER,
472     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
473     x_return_status                OUT NOCOPY VARCHAR2,
474     x_msg_count                    OUT NOCOPY NUMBER,
475     x_msg_data                     OUT NOCOPY VARCHAR2,
476     p_lsrv_tbl                     IN  lsrv_tbl_type,
477     x_lsrv_tbl                     OUT NOCOPY lsrv_tbl_type);
478 
479  PROCEDURE delete_line_style_roles(
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_lsrv_rec                     IN lsrv_rec_type);
486 
487  PROCEDURE delete_line_style_roles(
488     p_api_version                  IN NUMBER,
489     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
490     x_return_status                OUT NOCOPY VARCHAR2,
491     x_msg_count                    OUT NOCOPY NUMBER,
492     x_msg_data                     OUT NOCOPY VARCHAR2,
493     p_lsrv_tbl                     IN  lsrv_tbl_type);
494 
495  PROCEDURE lock_line_style_roles(
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_lsrv_rec                     IN lsrv_rec_type);
502 
503  PROCEDURE lock_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_tbl                     IN  lsrv_tbl_type);
510 
511  PROCEDURE validate_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_rec                     IN lsrv_rec_type);
518 
519  PROCEDURE validate_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_tbl                     IN  lsrv_tbl_type);
526 
527  PROCEDURE create_lse_rule_groups(
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_lrgv_rec                     IN lrgv_rec_type,
534     x_lrgv_rec                     OUT NOCOPY lrgv_rec_type);
535 
536  PROCEDURE create_lse_rule_groups(
537     p_api_version                  IN NUMBER,
538     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
539     x_return_status                OUT NOCOPY VARCHAR2,
540     x_msg_count                    OUT NOCOPY NUMBER,
541     x_msg_data                     OUT NOCOPY VARCHAR2,
542     p_lrgv_tbl                     IN  lrgv_tbl_type,
543     x_lrgv_tbl                     OUT NOCOPY lrgv_tbl_type);
544 
545  PROCEDURE update_lse_rule_groups(
546     p_api_version                  IN NUMBER,
547     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
548     x_return_status                OUT NOCOPY VARCHAR2,
549     x_msg_count                    OUT NOCOPY NUMBER,
550     x_msg_data                     OUT NOCOPY VARCHAR2,
551     p_lrgv_rec                     IN lrgv_rec_type,
552     x_lrgv_rec                     OUT NOCOPY lrgv_rec_type);
553 
554  PROCEDURE update_lse_rule_groups(
555     p_api_version                  IN NUMBER,
556     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
557     x_return_status                OUT NOCOPY VARCHAR2,
558     x_msg_count                    OUT NOCOPY NUMBER,
559     x_msg_data                     OUT NOCOPY VARCHAR2,
560     p_lrgv_tbl                     IN  lrgv_tbl_type,
561     x_lrgv_tbl                     OUT NOCOPY lrgv_tbl_type);
562 
563  PROCEDURE delete_lse_rule_groups(
564     p_api_version                  IN NUMBER,
565     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
566     x_return_status                OUT NOCOPY VARCHAR2,
567     x_msg_count                    OUT NOCOPY NUMBER,
568     x_msg_data                     OUT NOCOPY VARCHAR2,
569     p_lrgv_rec                     IN lrgv_rec_type);
570 
571  PROCEDURE delete_lse_rule_groups(
572     p_api_version                  IN NUMBER,
573     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
574     x_return_status                OUT NOCOPY VARCHAR2,
575     x_msg_count                    OUT NOCOPY NUMBER,
576     x_msg_data                     OUT NOCOPY VARCHAR2,
577     p_lrgv_tbl                     IN  lrgv_tbl_type);
578 
579  PROCEDURE lock_lse_rule_groups(
580     p_api_version                  IN NUMBER,
581     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
582     x_return_status                OUT NOCOPY VARCHAR2,
583     x_msg_count                    OUT NOCOPY NUMBER,
584     x_msg_data                     OUT NOCOPY VARCHAR2,
585     p_lrgv_rec                     IN lrgv_rec_type);
586 
587  PROCEDURE lock_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_tbl                     IN  lrgv_tbl_type);
594 
595  PROCEDURE validate_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_rec                     IN lrgv_rec_type);
602 
603  PROCEDURE validate_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_tbl                     IN  lrgv_tbl_type);
610 
611  PROCEDURE create_subclass_resps(
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_srav_rec                     IN srav_rec_type,
618     x_srav_rec                     OUT NOCOPY srav_rec_type);
619 
620  PROCEDURE create_subclass_resps(
621     p_api_version                  IN NUMBER,
622     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
623     x_return_status                OUT NOCOPY VARCHAR2,
624     x_msg_count                    OUT NOCOPY NUMBER,
625     x_msg_data                     OUT NOCOPY VARCHAR2,
626     p_srav_tbl                     IN  srav_tbl_type,
627     x_srav_tbl                     OUT NOCOPY srav_tbl_type);
628 
629  PROCEDURE update_subclass_resps(
630     p_api_version                  IN NUMBER,
631     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
632     x_return_status                OUT NOCOPY VARCHAR2,
633     x_msg_count                    OUT NOCOPY NUMBER,
634     x_msg_data                     OUT NOCOPY VARCHAR2,
635     p_srav_rec                     IN srav_rec_type,
636     x_srav_rec                     OUT NOCOPY srav_rec_type);
637 
638  PROCEDURE update_subclass_resps(
639     p_api_version                  IN NUMBER,
640     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
641     x_return_status                OUT NOCOPY VARCHAR2,
642     x_msg_count                    OUT NOCOPY NUMBER,
643     x_msg_data                     OUT NOCOPY VARCHAR2,
644     p_srav_tbl                     IN  srav_tbl_type,
645     x_srav_tbl                     OUT NOCOPY srav_tbl_type);
646 
647  PROCEDURE delete_subclass_resps(
648     p_api_version                  IN NUMBER,
649     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
650     x_return_status                OUT NOCOPY VARCHAR2,
651     x_msg_count                    OUT NOCOPY NUMBER,
652     x_msg_data                     OUT NOCOPY VARCHAR2,
653     p_srav_rec                     IN srav_rec_type);
654 
655  PROCEDURE delete_subclass_resps(
656     p_api_version                  IN NUMBER,
657     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
658     x_return_status                OUT NOCOPY VARCHAR2,
659     x_msg_count                    OUT NOCOPY NUMBER,
660     x_msg_data                     OUT NOCOPY VARCHAR2,
661     p_srav_tbl                     IN  srav_tbl_type);
662 
663  PROCEDURE lock_subclass_resps(
664     p_api_version                  IN NUMBER,
665     p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
666     x_return_status                OUT NOCOPY VARCHAR2,
667     x_msg_count                    OUT NOCOPY NUMBER,
668     x_msg_data                     OUT NOCOPY VARCHAR2,
669     p_srav_rec                     IN srav_rec_type);
670 
671  PROCEDURE lock_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_tbl                     IN  srav_tbl_type);
678 
679  PROCEDURE validate_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_rec                     IN srav_rec_type);
686 
687  PROCEDURE validate_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_tbl                     IN  srav_tbl_type);
694 
695 /*
696 ------------------------------------------------------------------------
697 | This API will copy One category to another one.                      |
698 |                                                                      |
699 |This will copy all the category related informations from foll. views |
700 |                     OKC_SUBCLASSES_V                                 |
701 |                     OKC_SUBCLASS_ROLES_V                             |
702 |                     OKC_SUBCLASS_RG_DEFS_V                           |
703 |                     OKC_RG_ROLE_DEFS_V                               |
704 |                     OKC_SUBCLASS_TOP_LINE_V                          |
705 |                     OKC_LINE_STYLE_ROLES_V                           |
706 |                     OKC_LSE_ROLE_GROUPS_V                            |
707 |                     OKC_SUBCLASS_RESPS_V                             |
708 |                     OKC_ASSENST_V  -- Status and Operation           |
709 |                                                                      |
710 |In parameters :                                                       |
711 |p_copy_from_scs_code ==> Category to be copied.                       |
712 |p_new_scs_name       ==> Name of new category                         |
713 |p_new_scs_desc       ==> Desc of new category                         |
714 |                                                                      |
715 |Out Parameter :                                                       |
716 |x_scsv_rec           ==> New subclass Record                          |
717 |                                                                      |
718 ------------------------------------------------------------------------
719 */
720 PROCEDURE copy_category(
721 	 p_api_version                  IN NUMBER,
722 	 p_init_msg_list                IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
723 	 x_return_status                OUT NOCOPY VARCHAR2,
724 	 x_msg_count                    OUT NOCOPY NUMBER,
725 	 x_msg_data                     OUT NOCOPY VARCHAR2,
726 	 p_copy_from_scs_code           IN VARCHAR2,
727 	 p_new_scs_name                 IN VARCHAR2,
728 	 p_new_scs_desc                 IN VARCHAR2,
729          x_scsv_rec                     OUT NOCOPY scsv_rec_type);
730 
731 END okc_subclass_pvt;