[Home] [Help]
PACKAGE: APPS.OKC_TIME_PUB
Source
1 PACKAGE OKC_TIME_PUB AUTHID CURRENT_USER AS
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 --------------------------------------------------------------------------
11 --Global Exception
12 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
13
14 --------------------------------------------------------------------------
15 ---The following procedures cater to handling of OKC_TIME_TPA_RELTV
16 --------------------------------------------------------------------------
17
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,
27 p_tve_id IN NUMBER);
28
29 SUBTYPE talv_rec_type is OKC_TIME_PVT.talv_rec_type;
30 TYPE talv_tbl_type is table of OKC_TIME_PVT.talv_rec_type index by binary_integer;
31
32 g_talv_rec talv_rec_type;
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,
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) ;
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);
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) ;
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);
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) ;
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);
117
118 SUBTYPE talv_evt_rec_type is OKC_TIME_PVT.talv_event_rec_type;
119 TYPE talv_evt_tbl_type is table of OKC_TIME_PVT.talv_event_rec_type index by binary_integer;
120
121 g_talv_evt_rec talv_evt_rec_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,
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) ;
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);
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) ;
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);
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) ;
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);
206
207
208 --------------------------------------------------------------------------
209 ---The following procedures cater to handling of OKC_TIME_TPA_VALUE
210 --------------------------------------------------------------------------
211
212 SUBTYPE tavv_rec_type is OKC_TIME_PVT.tavv_rec_type;
213 TYPE tavv_tbl_type is table of OKC_TIME_PVT.tavv_rec_type index by binary_integer;
214
215 g_tavv_rec tavv_rec_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,
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) ;
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);
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) ;
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);
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) ;
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);
300
301
302 --------------------------------------------------------------------------
303 ---The following procedures cater to handling of OKC_TIME_TPG_DELIMITED
304 --------------------------------------------------------------------------
305
306 SUBTYPE tgdv_ext_rec_type is OKC_TIME_PVT.tgdv_extended_rec_type;
307 TYPE tgdv_ext_tbl_type is table of OKC_TIME_PVT.tgdv_extended_rec_type index by binary_integer;
308
309 g_tgdv_ext_rec tgdv_ext_rec_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) ;
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);
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) ;
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);
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) ;
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);
395
396
397 --------------------------------------------------------------------------
398 ---The following procedures cater to handling of OKC_TIME_TPG_NAMED
399 --------------------------------------------------------------------------
400
401 SUBTYPE tgnv_rec_type is OKC_TIME_PVT.tgnv_rec_type;
402 TYPE tgnv_tbl_type is table of OKC_TIME_PVT.tgnv_rec_type index by binary_integer;
403
404 g_tgnv_rec tgnv_rec_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,
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) ;
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);
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) ;
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);
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) ;
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);
489
490
491 --------------------------------------------------------------------------
492 ---The following procedures cater to handling of OKC_TIME_IA_STARTEND
493 --------------------------------------------------------------------------
494
495 SUBTYPE isev_rec_type is OKC_TIME_PVT.isev_rec_type;
496 TYPE isev_tbl_type is table of OKC_TIME_PVT.isev_rec_type index by binary_integer;
497 SUBTYPE isev_ext_rec_type is OKC_TIME_PVT.isev_extended_rec_type;
498 TYPE isev_ext_tbl_type is table of OKC_TIME_PVT.isev_extended_rec_type index by binary_integer;
499
500 SUBTYPE isev_rel_rec_type is OKC_TIME_PVT.isev_reltv_rec_type;
501 TYPE isev_rel_tbl_type is table of OKC_TIME_PVT.isev_reltv_rec_type index by binary_integer;
502 g_isev_rec isev_rec_type;
503 g_isev_tbl isev_tbl_type;
504 g_isev_ext_rec isev_ext_rec_type;
505 g_isev_ext_tbl isev_ext_tbl_type;
506 g_isev_rel_rec isev_rel_rec_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) ;
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);
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) ;
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) ;
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) ;
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);
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) ;
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);
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) ;
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) ;
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) ;
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);
676
677 --------------------------------------------------------------------------
678 ---The following procedures cater to handling of OKC_TIME_IG_STARTEND
679 --------------------------------------------------------------------------
680
681 SUBTYPE igsv_ext_rec_type is OKC_TIME_PVT.igsv_extended_rec_type;
682 TYPE igsv_ext_tbl_type is table of OKC_TIME_PVT.igsv_extended_rec_type index by binary_integer;
683
684 g_igsv_ext_rec igsv_ext_rec_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) ;
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);
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) ;
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);
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) ;
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);
770
771
772 --------------------------------------------------------------------------
773 ---The following procedures cater to handling of OKC_TIME_CYCLE
774 --------------------------------------------------------------------------
775
776 SUBTYPE cylv_ext_rec_type is OKC_TIME_PVT.cylv_extended_rec_type;
777 TYPE cylv_ext_tbl_type is table of OKC_TIME_PVT.cylv_extended_rec_type index by binary_integer;
778
779 g_cylv_ext_rec cylv_ext_rec_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) ;
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);
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) ;
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);
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) ;
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);
865
866
867 --------------------------------------------------------------------------
868 ---The following procedures cater to handling of OKC_TIME_SPAN
869 --------------------------------------------------------------------------
870
871 SUBTYPE spnv_rec_type is OKC_TIME_PVT.spnv_rec_type;
872 TYPE spnv_tbl_type is table of OKC_TIME_PVT.spnv_rec_type index by binary_integer;
873
874 g_spnv_rec spnv_rec_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) ;
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);
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) ;
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);
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) ;
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);
960
961 --------------------------------------------------------------------------
962 ---The following procedures cater to handling of OKC_TIME_CODE_UNITS
963 --------------------------------------------------------------------------
964
965 SUBTYPE tcuv_rec_type is OKC_TIME_PVT.tcuv_rec_type;
966 TYPE tcuv_tbl_type is table of OKC_TIME_PVT.tcuv_rec_type index by binary_integer;
967
968 g_tcuv_rec tcuv_rec_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) ;
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);
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) ;
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);
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) ;
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);
1054 --------------------------------------------------------------------------
1055 ---The following procedures cater to handling of OKC_RESOLVED_TIMEVALUES
1056 --------------------------------------------------------------------------
1057
1058 SUBTYPE rtvv_rec_type is OKC_TIME_PVT.rtvv_rec_type;
1059 TYPE rtvv_tbl_type is table of OKC_TIME_PVT.rtvv_rec_type index by binary_integer;
1060
1061 g_rtvv_rec rtvv_rec_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) ;
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);
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) ;
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);
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) ;
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);
1147 END OKC_TIME_PUB;