2: /* $Header: OKCPTVES.pls 120.0 2005/05/25 22:30:17 appldev noship $ */
3: --------------------------------------------------------------------------
4: -- Global Variables
5: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TIME_PUB';
6: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
10: --------------------------------------------------------------------------
18: PROCEDURE ADD_LANGUAGE;
19:
20: PROCEDURE DELETE_TIMEVALUES_N_TASKS(
21: p_api_version IN NUMBER,
22: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,
26: p_chr_id IN NUMBER DEFAULT NULL,
33: g_talv_tbl talv_tbl_type;
34:
35: PROCEDURE CREATE_TPA_RELTV(
36: p_api_version IN NUMBER,
37: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_talv_rec IN talv_rec_type,
41: p_talv_rec IN talv_rec_type,
42: x_talv_rec OUT NOCOPY talv_rec_type) ;
43: PROCEDURE CREATE_TPA_RELTV(
44: p_api_version IN NUMBER,
45: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
46: x_return_status OUT NOCOPY VARCHAR2,
47: x_msg_count OUT NOCOPY NUMBER,
48: x_msg_data OUT NOCOPY VARCHAR2,
49: p_talv_tbl IN talv_tbl_type,
50: x_talv_tbl OUT NOCOPY talv_tbl_type);
51:
52: PROCEDURE UPDATE_TPA_RELTV(
53: p_api_version IN NUMBER,
54: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
55: x_return_status OUT NOCOPY VARCHAR2,
56: x_msg_count OUT NOCOPY NUMBER,
57: x_msg_data OUT NOCOPY VARCHAR2,
58: p_talv_rec IN talv_rec_type,
59: x_talv_rec OUT NOCOPY talv_rec_type) ;
60:
61: PROCEDURE UPDATE_TPA_RELTV(
62: p_api_version IN NUMBER,
63: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_talv_tbl IN talv_tbl_type,
68: x_talv_tbl OUT NOCOPY talv_tbl_type) ;
69:
70: PROCEDURE DELETE_TPA_RELTV(
71: p_api_version IN NUMBER,
72: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
73: x_return_status OUT NOCOPY VARCHAR2,
74: x_msg_count OUT NOCOPY NUMBER,
75: x_msg_data OUT NOCOPY VARCHAR2,
76: p_talv_rec IN talv_rec_type) ;
76: p_talv_rec IN talv_rec_type) ;
77:
78: PROCEDURE DELETE_TPA_RELTV(
79: p_api_version IN NUMBER,
80: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
81: x_return_status OUT NOCOPY VARCHAR2,
82: x_msg_count OUT NOCOPY NUMBER,
83: x_msg_data OUT NOCOPY VARCHAR2,
84: p_talv_tbl IN talv_tbl_type);
84: p_talv_tbl IN talv_tbl_type);
85:
86: PROCEDURE LOCK_TPA_RELTV(
87: p_api_version IN NUMBER,
88: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
89: x_return_status OUT NOCOPY VARCHAR2,
90: x_msg_count OUT NOCOPY NUMBER,
91: x_msg_data OUT NOCOPY VARCHAR2,
92: p_talv_rec IN talv_rec_type) ;
92: p_talv_rec IN talv_rec_type) ;
93:
94: PROCEDURE LOCK_TPA_RELTV(
95: p_api_version IN NUMBER,
96: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_talv_tbl IN talv_tbl_type);
100: p_talv_tbl IN talv_tbl_type);
101:
102: PROCEDURE VALID_TPA_RELTV(
103: p_api_version IN NUMBER,
104: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,
108: p_talv_rec IN talv_rec_type) ;
108: p_talv_rec IN talv_rec_type) ;
109:
110: PROCEDURE VALID_TPA_RELTV(
111: p_api_version IN NUMBER,
112: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: p_talv_tbl IN talv_tbl_type);
122: g_talv_evt_tbl talv_evt_tbl_type;
123:
124: PROCEDURE CREATE_TPA_RELTV(
125: p_api_version IN NUMBER,
126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
127: x_return_status OUT NOCOPY VARCHAR2,
128: x_msg_count OUT NOCOPY NUMBER,
129: x_msg_data OUT NOCOPY VARCHAR2,
130: p_talv_evt_rec IN talv_evt_rec_type,
130: p_talv_evt_rec IN talv_evt_rec_type,
131: x_talv_evt_rec OUT NOCOPY talv_evt_rec_type) ;
132: PROCEDURE CREATE_TPA_RELTV(
133: p_api_version IN NUMBER,
134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
135: x_return_status OUT NOCOPY VARCHAR2,
136: x_msg_count OUT NOCOPY NUMBER,
137: x_msg_data OUT NOCOPY VARCHAR2,
138: p_talv_evt_tbl IN talv_evt_tbl_type,
139: x_talv_evt_tbl OUT NOCOPY talv_evt_tbl_type);
140:
141: PROCEDURE UPDATE_TPA_RELTV(
142: p_api_version IN NUMBER,
143: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
144: x_return_status OUT NOCOPY VARCHAR2,
145: x_msg_count OUT NOCOPY NUMBER,
146: x_msg_data OUT NOCOPY VARCHAR2,
147: p_talv_evt_rec IN talv_evt_rec_type,
148: x_talv_evt_rec OUT NOCOPY talv_evt_rec_type) ;
149:
150: PROCEDURE UPDATE_TPA_RELTV(
151: p_api_version IN NUMBER,
152: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
153: x_return_status OUT NOCOPY VARCHAR2,
154: x_msg_count OUT NOCOPY NUMBER,
155: x_msg_data OUT NOCOPY VARCHAR2,
156: p_talv_evt_tbl IN talv_evt_tbl_type,
157: x_talv_evt_tbl OUT NOCOPY talv_evt_tbl_type) ;
158:
159: PROCEDURE DELETE_TPA_RELTV(
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_talv_evt_rec IN talv_evt_rec_type) ;
165: p_talv_evt_rec IN talv_evt_rec_type) ;
166:
167: PROCEDURE DELETE_TPA_RELTV(
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_talv_evt_tbl IN talv_evt_tbl_type);
173: p_talv_evt_tbl IN talv_evt_tbl_type);
174:
175: PROCEDURE LOCK_TPA_RELTV(
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_talv_evt_rec IN talv_evt_rec_type) ;
181: p_talv_evt_rec IN talv_evt_rec_type) ;
182:
183: PROCEDURE LOCK_TPA_RELTV(
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_talv_evt_tbl IN talv_evt_tbl_type);
189: p_talv_evt_tbl IN talv_evt_tbl_type);
190:
191: PROCEDURE VALID_TPA_RELTV(
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_talv_evt_rec IN talv_evt_rec_type) ;
197: p_talv_evt_rec IN talv_evt_rec_type) ;
198:
199: PROCEDURE VALID_TPA_RELTV(
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_talv_evt_tbl IN talv_evt_tbl_type);
216: g_tavv_tbl tavv_tbl_type;
217:
218: PROCEDURE CREATE_TPA_VALUE(
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_tavv_rec IN tavv_rec_type,
224: p_tavv_rec IN tavv_rec_type,
225: x_tavv_rec OUT NOCOPY tavv_rec_type) ;
226: PROCEDURE CREATE_TPA_VALUE(
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
229: x_return_status OUT NOCOPY VARCHAR2,
230: x_msg_count OUT NOCOPY NUMBER,
231: x_msg_data OUT NOCOPY VARCHAR2,
232: p_tavv_tbl IN tavv_tbl_type,
233: x_tavv_tbl OUT NOCOPY tavv_tbl_type);
234:
235: PROCEDURE UPDATE_TPA_VALUE(
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_tavv_rec IN tavv_rec_type,
242: x_tavv_rec OUT NOCOPY tavv_rec_type) ;
243:
244: PROCEDURE UPDATE_TPA_VALUE(
245: p_api_version IN NUMBER,
246: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
247: x_return_status OUT NOCOPY VARCHAR2,
248: x_msg_count OUT NOCOPY NUMBER,
249: x_msg_data OUT NOCOPY VARCHAR2,
250: p_tavv_tbl IN tavv_tbl_type,
251: x_tavv_tbl OUT NOCOPY tavv_tbl_type) ;
252:
253: PROCEDURE DELETE_TPA_VALUE(
254: p_api_version IN NUMBER,
255: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
256: x_return_status OUT NOCOPY VARCHAR2,
257: x_msg_count OUT NOCOPY NUMBER,
258: x_msg_data OUT NOCOPY VARCHAR2,
259: p_tavv_rec IN tavv_rec_type) ;
259: p_tavv_rec IN tavv_rec_type) ;
260:
261: PROCEDURE DELETE_TPA_VALUE(
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
264: x_return_status OUT NOCOPY VARCHAR2,
265: x_msg_count OUT NOCOPY NUMBER,
266: x_msg_data OUT NOCOPY VARCHAR2,
267: p_tavv_tbl IN tavv_tbl_type);
267: p_tavv_tbl IN tavv_tbl_type);
268:
269: PROCEDURE LOCK_TPA_VALUE(
270: p_api_version IN NUMBER,
271: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
272: x_return_status OUT NOCOPY VARCHAR2,
273: x_msg_count OUT NOCOPY NUMBER,
274: x_msg_data OUT NOCOPY VARCHAR2,
275: p_tavv_rec IN tavv_rec_type) ;
275: p_tavv_rec IN tavv_rec_type) ;
276:
277: PROCEDURE LOCK_TPA_VALUE(
278: p_api_version IN NUMBER,
279: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
280: x_return_status OUT NOCOPY VARCHAR2,
281: x_msg_count OUT NOCOPY NUMBER,
282: x_msg_data OUT NOCOPY VARCHAR2,
283: p_tavv_tbl IN tavv_tbl_type);
283: p_tavv_tbl IN tavv_tbl_type);
284:
285: PROCEDURE VALID_TPA_VALUE(
286: p_api_version IN NUMBER,
287: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
288: x_return_status OUT NOCOPY VARCHAR2,
289: x_msg_count OUT NOCOPY NUMBER,
290: x_msg_data OUT NOCOPY VARCHAR2,
291: p_tavv_rec IN tavv_rec_type) ;
291: p_tavv_rec IN tavv_rec_type) ;
292:
293: PROCEDURE VALID_TPA_VALUE(
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_tavv_tbl IN tavv_tbl_type);
310: g_tgdv_ext_tbl tgdv_ext_tbl_type;
311:
312: PROCEDURE CREATE_TPG_DELIMITED(
313: p_api_version IN NUMBER,
314: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
315: x_return_status OUT NOCOPY VARCHAR2,
316: x_msg_count OUT NOCOPY NUMBER,
317: x_msg_data OUT NOCOPY VARCHAR2,
318: p_tgdv_ext_rec IN tgdv_ext_rec_type,
319: x_tgdv_ext_rec OUT NOCOPY tgdv_ext_rec_type) ;
320:
321: PROCEDURE CREATE_TPG_DELIMITED(
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
324: x_return_status OUT NOCOPY VARCHAR2,
325: x_msg_count OUT NOCOPY NUMBER,
326: x_msg_data OUT NOCOPY VARCHAR2,
327: p_tgdv_ext_tbl IN tgdv_ext_tbl_type,
328: x_tgdv_ext_tbl OUT NOCOPY tgdv_ext_tbl_type) ;
329:
330: PROCEDURE UPDATE_TPG_DELIMITED(
331: p_api_version IN NUMBER,
332: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
333: x_return_status OUT NOCOPY VARCHAR2,
334: x_msg_count OUT NOCOPY NUMBER,
335: x_msg_data OUT NOCOPY VARCHAR2,
336: p_tgdv_ext_rec IN tgdv_ext_rec_type,
337: x_tgdv_ext_rec OUT NOCOPY tgdv_ext_rec_type) ;
338:
339: PROCEDURE UPDATE_TPG_DELIMITED(
340: p_api_version IN NUMBER,
341: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
342: x_return_status OUT NOCOPY VARCHAR2,
343: x_msg_count OUT NOCOPY NUMBER,
344: x_msg_data OUT NOCOPY VARCHAR2,
345: p_tgdv_ext_tbl IN tgdv_ext_tbl_type,
346: x_tgdv_ext_tbl OUT NOCOPY tgdv_ext_tbl_type) ;
347:
348: PROCEDURE DELETE_TPG_DELIMITED(
349: p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
351: x_return_status OUT NOCOPY VARCHAR2,
352: x_msg_count OUT NOCOPY NUMBER,
353: x_msg_data OUT NOCOPY VARCHAR2,
354: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
354: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
355:
356: PROCEDURE DELETE_TPG_DELIMITED(
357: p_api_version IN NUMBER,
358: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
359: x_return_status OUT NOCOPY VARCHAR2,
360: x_msg_count OUT NOCOPY NUMBER,
361: x_msg_data OUT NOCOPY VARCHAR2,
362: p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
362: p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
363:
364: PROCEDURE LOCK_TPG_DELIMITED(
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
367: x_return_status OUT NOCOPY VARCHAR2,
368: x_msg_count OUT NOCOPY NUMBER,
369: x_msg_data OUT NOCOPY VARCHAR2,
370: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
370: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
371:
372: PROCEDURE LOCK_TPG_DELIMITED(
373: p_api_version IN NUMBER,
374: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
375: x_return_status OUT NOCOPY VARCHAR2,
376: x_msg_count OUT NOCOPY NUMBER,
377: x_msg_data OUT NOCOPY VARCHAR2,
378: p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
378: p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
379:
380: PROCEDURE VALID_TPG_DELIMITED(
381: p_api_version IN NUMBER,
382: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
383: x_return_status OUT NOCOPY VARCHAR2,
384: x_msg_count OUT NOCOPY NUMBER,
385: x_msg_data OUT NOCOPY VARCHAR2,
386: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
386: p_tgdv_ext_rec IN tgdv_ext_rec_type) ;
387:
388: PROCEDURE VALID_TPG_DELIMITED(
389: p_api_version IN NUMBER,
390: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
391: x_return_status OUT NOCOPY VARCHAR2,
392: x_msg_count OUT NOCOPY NUMBER,
393: x_msg_data OUT NOCOPY VARCHAR2,
394: p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
405: g_tgnv_tbl tgnv_tbl_type;
406:
407: PROCEDURE CREATE_TPG_NAMED(
408: p_api_version IN NUMBER,
409: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
410: x_return_status OUT NOCOPY VARCHAR2,
411: x_msg_count OUT NOCOPY NUMBER,
412: x_msg_data OUT NOCOPY VARCHAR2,
413: p_tgnv_rec IN tgnv_rec_type,
413: p_tgnv_rec IN tgnv_rec_type,
414: x_tgnv_rec OUT NOCOPY tgnv_rec_type) ;
415: PROCEDURE CREATE_TPG_NAMED(
416: p_api_version IN NUMBER,
417: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,
421: p_tgnv_tbl IN tgnv_tbl_type,
422: x_tgnv_tbl OUT NOCOPY tgnv_tbl_type);
423:
424: PROCEDURE UPDATE_TPG_NAMED(
425: p_api_version IN NUMBER,
426: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
427: x_return_status OUT NOCOPY VARCHAR2,
428: x_msg_count OUT NOCOPY NUMBER,
429: x_msg_data OUT NOCOPY VARCHAR2,
430: p_tgnv_rec IN tgnv_rec_type,
431: x_tgnv_rec OUT NOCOPY tgnv_rec_type) ;
432:
433: PROCEDURE UPDATE_TPG_NAMED(
434: p_api_version IN NUMBER,
435: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
436: x_return_status OUT NOCOPY VARCHAR2,
437: x_msg_count OUT NOCOPY NUMBER,
438: x_msg_data OUT NOCOPY VARCHAR2,
439: p_tgnv_tbl IN tgnv_tbl_type,
440: x_tgnv_tbl OUT NOCOPY tgnv_tbl_type) ;
441:
442: PROCEDURE DELETE_TPG_NAMED(
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
445: x_return_status OUT NOCOPY VARCHAR2,
446: x_msg_count OUT NOCOPY NUMBER,
447: x_msg_data OUT NOCOPY VARCHAR2,
448: p_tgnv_rec IN tgnv_rec_type) ;
448: p_tgnv_rec IN tgnv_rec_type) ;
449:
450: PROCEDURE DELETE_TPG_NAMED(
451: p_api_version IN NUMBER,
452: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
453: x_return_status OUT NOCOPY VARCHAR2,
454: x_msg_count OUT NOCOPY NUMBER,
455: x_msg_data OUT NOCOPY VARCHAR2,
456: p_tgnv_tbl IN tgnv_tbl_type);
456: p_tgnv_tbl IN tgnv_tbl_type);
457:
458: PROCEDURE LOCK_TPG_NAMED(
459: p_api_version IN NUMBER,
460: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
464: p_tgnv_rec IN tgnv_rec_type) ;
464: p_tgnv_rec IN tgnv_rec_type) ;
465:
466: PROCEDURE LOCK_TPG_NAMED(
467: p_api_version IN NUMBER,
468: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
469: x_return_status OUT NOCOPY VARCHAR2,
470: x_msg_count OUT NOCOPY NUMBER,
471: x_msg_data OUT NOCOPY VARCHAR2,
472: p_tgnv_tbl IN tgnv_tbl_type);
472: p_tgnv_tbl IN tgnv_tbl_type);
473:
474: PROCEDURE VALID_TPG_NAMED(
475: p_api_version IN NUMBER,
476: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
477: x_return_status OUT NOCOPY VARCHAR2,
478: x_msg_count OUT NOCOPY NUMBER,
479: x_msg_data OUT NOCOPY VARCHAR2,
480: p_tgnv_rec IN tgnv_rec_type) ;
480: p_tgnv_rec IN tgnv_rec_type) ;
481:
482: PROCEDURE VALID_TPG_NAMED(
483: p_api_version IN NUMBER,
484: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
485: x_return_status OUT NOCOPY VARCHAR2,
486: x_msg_count OUT NOCOPY NUMBER,
487: x_msg_data OUT NOCOPY VARCHAR2,
488: p_tgnv_tbl IN tgnv_tbl_type);
507: g_isev_rel_tbl isev_rel_tbl_type;
508:
509: PROCEDURE CREATE_IA_STARTEND(
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
512: x_return_status OUT NOCOPY VARCHAR2,
513: x_msg_count OUT NOCOPY NUMBER,
514: x_msg_data OUT NOCOPY VARCHAR2,
515: p_isev_ext_rec IN isev_ext_rec_type,
516: x_isev_ext_rec OUT NOCOPY isev_ext_rec_type) ;
517:
518: PROCEDURE CREATE_IA_STARTEND(
519: p_api_version IN NUMBER,
520: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
521: x_return_status OUT NOCOPY VARCHAR2,
522: x_msg_count OUT NOCOPY NUMBER,
523: x_msg_data OUT NOCOPY VARCHAR2,
524: p_isev_ext_tbl IN isev_ext_tbl_type,
525: x_isev_ext_tbl OUT NOCOPY isev_ext_tbl_type) ;
526:
527: PROCEDURE UPDATE_IA_STARTEND(
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_isev_ext_rec IN isev_ext_rec_type,
534: x_isev_ext_rec OUT NOCOPY isev_ext_rec_type) ;
535:
536: PROCEDURE UPDATE_IA_STARTEND(
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_isev_ext_tbl IN isev_ext_tbl_type,
543: x_isev_ext_tbl OUT NOCOPY isev_ext_tbl_type) ;
544:
545: PROCEDURE DELETE_IA_STARTEND(
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_isev_ext_rec IN isev_ext_rec_type) ;
551: p_isev_ext_rec IN isev_ext_rec_type) ;
552:
553: PROCEDURE DELETE_IA_STARTEND(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
556: x_return_status OUT NOCOPY VARCHAR2,
557: x_msg_count OUT NOCOPY NUMBER,
558: x_msg_data OUT NOCOPY VARCHAR2,
559: p_isev_ext_tbl IN isev_ext_tbl_type);
559: p_isev_ext_tbl IN isev_ext_tbl_type);
560:
561: PROCEDURE LOCK_IA_STARTEND(
562: p_api_version IN NUMBER,
563: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
564: x_return_status OUT NOCOPY VARCHAR2,
565: x_msg_count OUT NOCOPY NUMBER,
566: x_msg_data OUT NOCOPY VARCHAR2,
567: p_isev_ext_rec IN isev_ext_rec_type) ;
567: p_isev_ext_rec IN isev_ext_rec_type) ;
568:
569: PROCEDURE LOCK_IA_STARTEND(
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_isev_ext_tbl IN isev_ext_tbl_type) ;
575: p_isev_ext_tbl IN isev_ext_tbl_type) ;
576:
577: PROCEDURE VALID_IA_STARTEND(
578: p_api_version IN NUMBER,
579: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
580: x_return_status OUT NOCOPY VARCHAR2,
581: x_msg_count OUT NOCOPY NUMBER,
582: x_msg_data OUT NOCOPY VARCHAR2,
583: p_isev_ext_rec IN isev_ext_rec_type) ;
583: p_isev_ext_rec IN isev_ext_rec_type) ;
584:
585: PROCEDURE VALID_IA_STARTEND(
586: p_api_version IN NUMBER,
587: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
588: x_return_status OUT NOCOPY VARCHAR2,
589: x_msg_count OUT NOCOPY NUMBER,
590: x_msg_data OUT NOCOPY VARCHAR2,
591: p_isev_ext_tbl IN isev_ext_tbl_type);
591: p_isev_ext_tbl IN isev_ext_tbl_type);
592:
593: PROCEDURE CREATE_IA_STARTEND(
594: p_api_version IN NUMBER,
595: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
596: x_return_status OUT NOCOPY VARCHAR2,
597: x_msg_count OUT NOCOPY NUMBER,
598: x_msg_data OUT NOCOPY VARCHAR2,
599: p_isev_rel_rec IN isev_rel_rec_type,
600: x_isev_rel_rec OUT NOCOPY isev_rel_rec_type) ;
601:
602: PROCEDURE CREATE_IA_STARTEND(
603: p_api_version IN NUMBER,
604: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
605: x_return_status OUT NOCOPY VARCHAR2,
606: x_msg_count OUT NOCOPY NUMBER,
607: x_msg_data OUT NOCOPY VARCHAR2,
608: p_isev_rel_tbl IN isev_rel_tbl_type,
609: x_isev_rel_tbl OUT NOCOPY isev_rel_tbl_type) ;
610:
611: PROCEDURE UPDATE_IA_STARTEND(
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_isev_rel_rec IN isev_rel_rec_type,
618: x_isev_rel_rec OUT NOCOPY isev_rel_rec_type) ;
619:
620: PROCEDURE UPDATE_IA_STARTEND(
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_isev_rel_tbl IN isev_rel_tbl_type,
627: x_isev_rel_tbl OUT NOCOPY isev_rel_tbl_type) ;
628:
629: PROCEDURE DELETE_IA_STARTEND(
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_isev_rel_rec IN isev_rel_rec_type) ;
635: p_isev_rel_rec IN isev_rel_rec_type) ;
636:
637: PROCEDURE DELETE_IA_STARTEND(
638: p_api_version IN NUMBER,
639: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
640: x_return_status OUT NOCOPY VARCHAR2,
641: x_msg_count OUT NOCOPY NUMBER,
642: x_msg_data OUT NOCOPY VARCHAR2,
643: p_isev_rel_tbl IN isev_rel_tbl_type);
643: p_isev_rel_tbl IN isev_rel_tbl_type);
644:
645: PROCEDURE LOCK_IA_STARTEND(
646: p_api_version IN NUMBER,
647: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
648: x_return_status OUT NOCOPY VARCHAR2,
649: x_msg_count OUT NOCOPY NUMBER,
650: x_msg_data OUT NOCOPY VARCHAR2,
651: p_isev_rel_rec IN isev_rel_rec_type) ;
651: p_isev_rel_rec IN isev_rel_rec_type) ;
652:
653: PROCEDURE LOCK_IA_STARTEND(
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_isev_rel_tbl IN isev_rel_tbl_type) ;
659: p_isev_rel_tbl IN isev_rel_tbl_type) ;
660:
661: PROCEDURE VALID_IA_STARTEND(
662: p_api_version IN NUMBER,
663: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
664: x_return_status OUT NOCOPY VARCHAR2,
665: x_msg_count OUT NOCOPY NUMBER,
666: x_msg_data OUT NOCOPY VARCHAR2,
667: p_isev_rel_rec IN isev_rel_rec_type) ;
667: p_isev_rel_rec IN isev_rel_rec_type) ;
668:
669: PROCEDURE VALID_IA_STARTEND(
670: p_api_version IN NUMBER,
671: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
672: x_return_status OUT NOCOPY VARCHAR2,
673: x_msg_count OUT NOCOPY NUMBER,
674: x_msg_data OUT NOCOPY VARCHAR2,
675: p_isev_rel_tbl IN isev_rel_tbl_type);
685: g_igsv_ext_tbl igsv_ext_tbl_type;
686:
687: PROCEDURE CREATE_IG_STARTEND(
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_igsv_ext_rec IN igsv_ext_rec_type,
694: x_igsv_ext_rec OUT NOCOPY igsv_ext_rec_type) ;
695:
696: PROCEDURE CREATE_IG_STARTEND(
697: p_api_version IN NUMBER,
698: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
699: x_return_status OUT NOCOPY VARCHAR2,
700: x_msg_count OUT NOCOPY NUMBER,
701: x_msg_data OUT NOCOPY VARCHAR2,
702: p_igsv_ext_tbl IN igsv_ext_tbl_type,
703: x_igsv_ext_tbl OUT NOCOPY igsv_ext_tbl_type) ;
704:
705: PROCEDURE UPDATE_IG_STARTEND(
706: p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
708: x_return_status OUT NOCOPY VARCHAR2,
709: x_msg_count OUT NOCOPY NUMBER,
710: x_msg_data OUT NOCOPY VARCHAR2,
711: p_igsv_ext_rec IN igsv_ext_rec_type,
712: x_igsv_ext_rec OUT NOCOPY igsv_ext_rec_type) ;
713:
714: PROCEDURE UPDATE_IG_STARTEND(
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
717: x_return_status OUT NOCOPY VARCHAR2,
718: x_msg_count OUT NOCOPY NUMBER,
719: x_msg_data OUT NOCOPY VARCHAR2,
720: p_igsv_ext_tbl IN igsv_ext_tbl_type,
721: x_igsv_ext_tbl OUT NOCOPY igsv_ext_tbl_type) ;
722:
723: PROCEDURE DELETE_IG_STARTEND(
724: p_api_version IN NUMBER,
725: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
726: x_return_status OUT NOCOPY VARCHAR2,
727: x_msg_count OUT NOCOPY NUMBER,
728: x_msg_data OUT NOCOPY VARCHAR2,
729: p_igsv_ext_rec IN igsv_ext_rec_type) ;
729: p_igsv_ext_rec IN igsv_ext_rec_type) ;
730:
731: PROCEDURE DELETE_IG_STARTEND(
732: p_api_version IN NUMBER,
733: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
734: x_return_status OUT NOCOPY VARCHAR2,
735: x_msg_count OUT NOCOPY NUMBER,
736: x_msg_data OUT NOCOPY VARCHAR2,
737: p_igsv_ext_tbl IN igsv_ext_tbl_type);
737: p_igsv_ext_tbl IN igsv_ext_tbl_type);
738:
739: PROCEDURE LOCK_IG_STARTEND(
740: p_api_version IN NUMBER,
741: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
742: x_return_status OUT NOCOPY VARCHAR2,
743: x_msg_count OUT NOCOPY NUMBER,
744: x_msg_data OUT NOCOPY VARCHAR2,
745: p_igsv_ext_rec IN igsv_ext_rec_type) ;
745: p_igsv_ext_rec IN igsv_ext_rec_type) ;
746:
747: PROCEDURE LOCK_IG_STARTEND(
748: p_api_version IN NUMBER,
749: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
750: x_return_status OUT NOCOPY VARCHAR2,
751: x_msg_count OUT NOCOPY NUMBER,
752: x_msg_data OUT NOCOPY VARCHAR2,
753: p_igsv_ext_tbl IN igsv_ext_tbl_type);
753: p_igsv_ext_tbl IN igsv_ext_tbl_type);
754:
755: PROCEDURE VALID_IG_STARTEND(
756: p_api_version IN NUMBER,
757: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
758: x_return_status OUT NOCOPY VARCHAR2,
759: x_msg_count OUT NOCOPY NUMBER,
760: x_msg_data OUT NOCOPY VARCHAR2,
761: p_igsv_ext_rec IN igsv_ext_rec_type) ;
761: p_igsv_ext_rec IN igsv_ext_rec_type) ;
762:
763: PROCEDURE VALID_IG_STARTEND(
764: p_api_version IN NUMBER,
765: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
766: x_return_status OUT NOCOPY VARCHAR2,
767: x_msg_count OUT NOCOPY NUMBER,
768: x_msg_data OUT NOCOPY VARCHAR2,
769: p_igsv_ext_tbl IN igsv_ext_tbl_type);
780: g_cylv_ext_tbl cylv_ext_tbl_type;
781:
782: PROCEDURE CREATE_CYCLE(
783: p_api_version IN NUMBER,
784: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
785: x_return_status OUT NOCOPY VARCHAR2,
786: x_msg_count OUT NOCOPY NUMBER,
787: x_msg_data OUT NOCOPY VARCHAR2,
788: p_cylv_ext_rec IN cylv_ext_rec_type,
789: x_cylv_ext_rec OUT NOCOPY cylv_ext_rec_type) ;
790:
791: PROCEDURE CREATE_CYCLE(
792: p_api_version IN NUMBER,
793: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2,
797: p_cylv_ext_tbl IN cylv_ext_tbl_type,
798: x_cylv_ext_tbl OUT NOCOPY cylv_ext_tbl_type) ;
799:
800: PROCEDURE UPDATE_CYCLE(
801: p_api_version IN NUMBER,
802: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
803: x_return_status OUT NOCOPY VARCHAR2,
804: x_msg_count OUT NOCOPY NUMBER,
805: x_msg_data OUT NOCOPY VARCHAR2,
806: p_cylv_ext_rec IN cylv_ext_rec_type,
807: x_cylv_ext_rec OUT NOCOPY cylv_ext_rec_type) ;
808:
809: PROCEDURE UPDATE_CYCLE(
810: p_api_version IN NUMBER,
811: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
812: x_return_status OUT NOCOPY VARCHAR2,
813: x_msg_count OUT NOCOPY NUMBER,
814: x_msg_data OUT NOCOPY VARCHAR2,
815: p_cylv_ext_tbl IN cylv_ext_tbl_type,
816: x_cylv_ext_tbl OUT NOCOPY cylv_ext_tbl_type) ;
817:
818: PROCEDURE DELETE_CYCLE(
819: p_api_version IN NUMBER,
820: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
821: x_return_status OUT NOCOPY VARCHAR2,
822: x_msg_count OUT NOCOPY NUMBER,
823: x_msg_data OUT NOCOPY VARCHAR2,
824: p_cylv_ext_rec IN cylv_ext_rec_type) ;
824: p_cylv_ext_rec IN cylv_ext_rec_type) ;
825:
826: PROCEDURE DELETE_CYCLE(
827: p_api_version IN NUMBER,
828: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
829: x_return_status OUT NOCOPY VARCHAR2,
830: x_msg_count OUT NOCOPY NUMBER,
831: x_msg_data OUT NOCOPY VARCHAR2,
832: p_cylv_ext_tbl IN cylv_ext_tbl_type);
832: p_cylv_ext_tbl IN cylv_ext_tbl_type);
833:
834: PROCEDURE LOCK_CYCLE(
835: p_api_version IN NUMBER,
836: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
837: x_return_status OUT NOCOPY VARCHAR2,
838: x_msg_count OUT NOCOPY NUMBER,
839: x_msg_data OUT NOCOPY VARCHAR2,
840: p_cylv_ext_rec IN cylv_ext_rec_type) ;
840: p_cylv_ext_rec IN cylv_ext_rec_type) ;
841:
842: PROCEDURE LOCK_CYCLE(
843: p_api_version IN NUMBER,
844: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
845: x_return_status OUT NOCOPY VARCHAR2,
846: x_msg_count OUT NOCOPY NUMBER,
847: x_msg_data OUT NOCOPY VARCHAR2,
848: p_cylv_ext_tbl IN cylv_ext_tbl_type);
848: p_cylv_ext_tbl IN cylv_ext_tbl_type);
849:
850: PROCEDURE VALID_CYCLE(
851: p_api_version IN NUMBER,
852: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
853: x_return_status OUT NOCOPY VARCHAR2,
854: x_msg_count OUT NOCOPY NUMBER,
855: x_msg_data OUT NOCOPY VARCHAR2,
856: p_cylv_ext_rec IN cylv_ext_rec_type) ;
856: p_cylv_ext_rec IN cylv_ext_rec_type) ;
857:
858: PROCEDURE VALID_CYCLE(
859: p_api_version IN NUMBER,
860: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
861: x_return_status OUT NOCOPY VARCHAR2,
862: x_msg_count OUT NOCOPY NUMBER,
863: x_msg_data OUT NOCOPY VARCHAR2,
864: p_cylv_ext_tbl IN cylv_ext_tbl_type);
875: g_spnv_tbl spnv_tbl_type;
876:
877: PROCEDURE CREATE_SPAN(
878: p_api_version IN NUMBER,
879: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
880: x_return_status OUT NOCOPY VARCHAR2,
881: x_msg_count OUT NOCOPY NUMBER,
882: x_msg_data OUT NOCOPY VARCHAR2,
883: p_spnv_rec IN spnv_rec_type,
884: x_spnv_rec OUT NOCOPY spnv_rec_type) ;
885:
886: PROCEDURE CREATE_SPAN(
887: p_api_version IN NUMBER,
888: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
889: x_return_status OUT NOCOPY VARCHAR2,
890: x_msg_count OUT NOCOPY NUMBER,
891: x_msg_data OUT NOCOPY VARCHAR2,
892: p_spnv_tbl IN spnv_tbl_type,
893: x_spnv_tbl OUT NOCOPY spnv_tbl_type) ;
894:
895: PROCEDURE UPDATE_SPAN(
896: p_api_version IN NUMBER,
897: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
898: x_return_status OUT NOCOPY VARCHAR2,
899: x_msg_count OUT NOCOPY NUMBER,
900: x_msg_data OUT NOCOPY VARCHAR2,
901: p_spnv_rec IN spnv_rec_type,
902: x_spnv_rec OUT NOCOPY spnv_rec_type) ;
903:
904: PROCEDURE UPDATE_SPAN(
905: p_api_version IN NUMBER,
906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
907: x_return_status OUT NOCOPY VARCHAR2,
908: x_msg_count OUT NOCOPY NUMBER,
909: x_msg_data OUT NOCOPY VARCHAR2,
910: p_spnv_tbl IN spnv_tbl_type,
911: x_spnv_tbl OUT NOCOPY spnv_tbl_type) ;
912:
913: PROCEDURE DELETE_SPAN(
914: p_api_version IN NUMBER,
915: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
916: x_return_status OUT NOCOPY VARCHAR2,
917: x_msg_count OUT NOCOPY NUMBER,
918: x_msg_data OUT NOCOPY VARCHAR2,
919: p_spnv_rec IN spnv_rec_type) ;
919: p_spnv_rec IN spnv_rec_type) ;
920:
921: PROCEDURE DELETE_SPAN(
922: p_api_version IN NUMBER,
923: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
924: x_return_status OUT NOCOPY VARCHAR2,
925: x_msg_count OUT NOCOPY NUMBER,
926: x_msg_data OUT NOCOPY VARCHAR2,
927: p_spnv_tbl IN spnv_tbl_type);
927: p_spnv_tbl IN spnv_tbl_type);
928:
929: PROCEDURE LOCK_SPAN(
930: p_api_version IN NUMBER,
931: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
932: x_return_status OUT NOCOPY VARCHAR2,
933: x_msg_count OUT NOCOPY NUMBER,
934: x_msg_data OUT NOCOPY VARCHAR2,
935: p_spnv_rec IN spnv_rec_type) ;
935: p_spnv_rec IN spnv_rec_type) ;
936:
937: PROCEDURE LOCK_SPAN(
938: p_api_version IN NUMBER,
939: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
940: x_return_status OUT NOCOPY VARCHAR2,
941: x_msg_count OUT NOCOPY NUMBER,
942: x_msg_data OUT NOCOPY VARCHAR2,
943: p_spnv_tbl IN spnv_tbl_type);
943: p_spnv_tbl IN spnv_tbl_type);
944:
945: PROCEDURE VALID_SPAN(
946: p_api_version IN NUMBER,
947: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
948: x_return_status OUT NOCOPY VARCHAR2,
949: x_msg_count OUT NOCOPY NUMBER,
950: x_msg_data OUT NOCOPY VARCHAR2,
951: p_spnv_rec IN spnv_rec_type) ;
951: p_spnv_rec IN spnv_rec_type) ;
952:
953: PROCEDURE VALID_SPAN(
954: p_api_version IN NUMBER,
955: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
956: x_return_status OUT NOCOPY VARCHAR2,
957: x_msg_count OUT NOCOPY NUMBER,
958: x_msg_data OUT NOCOPY VARCHAR2,
959: p_spnv_tbl IN spnv_tbl_type);
969: g_tcuv_tbl tcuv_tbl_type;
970:
971: PROCEDURE CREATE_TIME_CODE_UNITS(
972: p_api_version IN NUMBER,
973: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
974: x_return_status OUT NOCOPY VARCHAR2,
975: x_msg_count OUT NOCOPY NUMBER,
976: x_msg_data OUT NOCOPY VARCHAR2,
977: p_tcuv_rec IN tcuv_rec_type,
978: x_tcuv_rec OUT NOCOPY tcuv_rec_type) ;
979:
980: PROCEDURE CREATE_TIME_CODE_UNITS(
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
983: x_return_status OUT NOCOPY VARCHAR2,
984: x_msg_count OUT NOCOPY NUMBER,
985: x_msg_data OUT NOCOPY VARCHAR2,
986: p_tcuv_tbl IN tcuv_tbl_type,
987: x_tcuv_tbl OUT NOCOPY tcuv_tbl_type) ;
988:
989: PROCEDURE UPDATE_TIME_CODE_UNITS(
990: p_api_version IN NUMBER,
991: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
992: x_return_status OUT NOCOPY VARCHAR2,
993: x_msg_count OUT NOCOPY NUMBER,
994: x_msg_data OUT NOCOPY VARCHAR2,
995: p_tcuv_rec IN tcuv_rec_type,
996: x_tcuv_rec OUT NOCOPY tcuv_rec_type) ;
997:
998: PROCEDURE UPDATE_TIME_CODE_UNITS(
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1001: x_return_status OUT NOCOPY VARCHAR2,
1002: x_msg_count OUT NOCOPY NUMBER,
1003: x_msg_data OUT NOCOPY VARCHAR2,
1004: p_tcuv_tbl IN tcuv_tbl_type,
1005: x_tcuv_tbl OUT NOCOPY tcuv_tbl_type) ;
1006:
1007: PROCEDURE DELETE_TIME_CODE_UNITS(
1008: p_api_version IN NUMBER,
1009: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1010: x_return_status OUT NOCOPY VARCHAR2,
1011: x_msg_count OUT NOCOPY NUMBER,
1012: x_msg_data OUT NOCOPY VARCHAR2,
1013: p_tcuv_rec IN tcuv_rec_type) ;
1013: p_tcuv_rec IN tcuv_rec_type) ;
1014:
1015: PROCEDURE DELETE_TIME_CODE_UNITS(
1016: p_api_version IN NUMBER,
1017: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1018: x_return_status OUT NOCOPY VARCHAR2,
1019: x_msg_count OUT NOCOPY NUMBER,
1020: x_msg_data OUT NOCOPY VARCHAR2,
1021: p_tcuv_tbl IN tcuv_tbl_type);
1021: p_tcuv_tbl IN tcuv_tbl_type);
1022:
1023: PROCEDURE LOCK_TIME_CODE_UNITS(
1024: p_api_version IN NUMBER,
1025: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1026: x_return_status OUT NOCOPY VARCHAR2,
1027: x_msg_count OUT NOCOPY NUMBER,
1028: x_msg_data OUT NOCOPY VARCHAR2,
1029: p_tcuv_rec IN tcuv_rec_type) ;
1029: p_tcuv_rec IN tcuv_rec_type) ;
1030:
1031: PROCEDURE LOCK_TIME_CODE_UNITS(
1032: p_api_version IN NUMBER,
1033: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1034: x_return_status OUT NOCOPY VARCHAR2,
1035: x_msg_count OUT NOCOPY NUMBER,
1036: x_msg_data OUT NOCOPY VARCHAR2,
1037: p_tcuv_tbl IN tcuv_tbl_type);
1037: p_tcuv_tbl IN tcuv_tbl_type);
1038:
1039: PROCEDURE VALID_TIME_CODE_UNITS(
1040: p_api_version IN NUMBER,
1041: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1042: x_return_status OUT NOCOPY VARCHAR2,
1043: x_msg_count OUT NOCOPY NUMBER,
1044: x_msg_data OUT NOCOPY VARCHAR2,
1045: p_tcuv_rec IN tcuv_rec_type) ;
1045: p_tcuv_rec IN tcuv_rec_type) ;
1046:
1047: PROCEDURE VALID_TIME_CODE_UNITS(
1048: p_api_version IN NUMBER,
1049: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1050: x_return_status OUT NOCOPY VARCHAR2,
1051: x_msg_count OUT NOCOPY NUMBER,
1052: x_msg_data OUT NOCOPY VARCHAR2,
1053: p_tcuv_tbl IN tcuv_tbl_type);
1062: g_rtvv_tbl rtvv_tbl_type;
1063:
1064: PROCEDURE CREATE_RESOLVED_TIMEVALUES(
1065: p_api_version IN NUMBER,
1066: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1067: x_return_status OUT NOCOPY VARCHAR2,
1068: x_msg_count OUT NOCOPY NUMBER,
1069: x_msg_data OUT NOCOPY VARCHAR2,
1070: p_rtvv_rec IN rtvv_rec_type,
1071: x_rtvv_rec OUT NOCOPY rtvv_rec_type) ;
1072:
1073: PROCEDURE CREATE_RESOLVED_TIMEVALUES(
1074: p_api_version IN NUMBER,
1075: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1076: x_return_status OUT NOCOPY VARCHAR2,
1077: x_msg_count OUT NOCOPY NUMBER,
1078: x_msg_data OUT NOCOPY VARCHAR2,
1079: p_rtvv_tbl IN rtvv_tbl_type,
1080: x_rtvv_tbl OUT NOCOPY rtvv_tbl_type) ;
1081:
1082: PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
1083: p_api_version IN NUMBER,
1084: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1085: x_return_status OUT NOCOPY VARCHAR2,
1086: x_msg_count OUT NOCOPY NUMBER,
1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_rtvv_rec IN rtvv_rec_type,
1089: x_rtvv_rec OUT NOCOPY rtvv_rec_type) ;
1090:
1091: PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
1092: p_api_version IN NUMBER,
1093: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1094: x_return_status OUT NOCOPY VARCHAR2,
1095: x_msg_count OUT NOCOPY NUMBER,
1096: x_msg_data OUT NOCOPY VARCHAR2,
1097: p_rtvv_tbl IN rtvv_tbl_type,
1098: x_rtvv_tbl OUT NOCOPY rtvv_tbl_type) ;
1099:
1100: PROCEDURE DELETE_RESOLVED_TIMEVALUES(
1101: p_api_version IN NUMBER,
1102: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1103: x_return_status OUT NOCOPY VARCHAR2,
1104: x_msg_count OUT NOCOPY NUMBER,
1105: x_msg_data OUT NOCOPY VARCHAR2,
1106: p_rtvv_rec IN rtvv_rec_type) ;
1106: p_rtvv_rec IN rtvv_rec_type) ;
1107:
1108: PROCEDURE DELETE_RESOLVED_TIMEVALUES(
1109: p_api_version IN NUMBER,
1110: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1111: x_return_status OUT NOCOPY VARCHAR2,
1112: x_msg_count OUT NOCOPY NUMBER,
1113: x_msg_data OUT NOCOPY VARCHAR2,
1114: p_rtvv_tbl IN rtvv_tbl_type);
1114: p_rtvv_tbl IN rtvv_tbl_type);
1115:
1116: PROCEDURE LOCK_RESOLVED_TIMEVALUES(
1117: p_api_version IN NUMBER,
1118: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1119: x_return_status OUT NOCOPY VARCHAR2,
1120: x_msg_count OUT NOCOPY NUMBER,
1121: x_msg_data OUT NOCOPY VARCHAR2,
1122: p_rtvv_rec IN rtvv_rec_type) ;
1122: p_rtvv_rec IN rtvv_rec_type) ;
1123:
1124: PROCEDURE LOCK_RESOLVED_TIMEVALUES(
1125: p_api_version IN NUMBER,
1126: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1127: x_return_status OUT NOCOPY VARCHAR2,
1128: x_msg_count OUT NOCOPY NUMBER,
1129: x_msg_data OUT NOCOPY VARCHAR2,
1130: p_rtvv_tbl IN rtvv_tbl_type);
1130: p_rtvv_tbl IN rtvv_tbl_type);
1131:
1132: PROCEDURE VALID_RESOLVED_TIMEVALUES(
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1135: x_return_status OUT NOCOPY VARCHAR2,
1136: x_msg_count OUT NOCOPY NUMBER,
1137: x_msg_data OUT NOCOPY VARCHAR2,
1138: p_rtvv_rec IN rtvv_rec_type) ;
1138: p_rtvv_rec IN rtvv_rec_type) ;
1139:
1140: PROCEDURE VALID_RESOLVED_TIMEVALUES(
1141: p_api_version IN NUMBER,
1142: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,
1146: p_rtvv_tbl IN rtvv_tbl_type);