DBA Data[Home] [Help]

APPS.OKC_SUBCLASS_PUB dependencies on OKC_API

Line 43: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

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(

Line 49: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 58: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 67: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 76: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 85: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 93: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 101: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 109: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 125: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 133: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 151: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 160: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 169: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 177: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 185: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 193: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 201: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 209: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 217: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 226: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 235: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 244: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 253: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 261: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 269: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 277: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 285: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 293: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 301: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 319: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 328: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 337: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 345: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 353: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 361: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 369: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 377: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 385: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 394: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 403: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 412: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 429: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 437: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 445: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 453: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 461: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 469: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 478: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 487: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 496: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 505: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 513: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 521: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 529: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 537: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 545: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 553: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 562: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 571: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 580: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 589: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 605: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 613: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 621: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 629: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 637: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 646: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 655: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 664: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,

Line 673: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 681: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 689: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 705: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 713: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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);

Line 721: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

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,