[Home] [Help]
PACKAGE: APPS.OKC_TIME_PVT
Source
1 PACKAGE OKC_TIME_PVT AS
2 /* $Header: OKCCTVES.pls 120.0 2005/05/25 18:54:57 appldev noship $ */
3 --------------------------------------------------------------------------
4 -- Global Variables
5 G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
6 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
7 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_TIME_PVT';
8 G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
9 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
10 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
11 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
12 G_DATE_ERROR CONSTANT varchar2(200) := 'Start Date > End Date';
13 --------------------------------------------------------------------------
14 --Global Exception
15 G_EXCEPTION_HALT_PROCEEDING EXCEPTION;
16
17 --------------------------------------------------------------------------
18 ---The following procedures cater to handling of OKC_TIME_TPA_RELTV
19 --------------------------------------------------------------------------
20
21 PROCEDURE ADD_LANGUAGE;
22
23 PROCEDURE DELETE_TIMEVALUES_N_TASKS(
24 p_api_version IN NUMBER,
25 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
26 x_return_status OUT NOCOPY VARCHAR2,
27 x_msg_count OUT NOCOPY NUMBER,
28 x_msg_data OUT NOCOPY VARCHAR2,
29 p_chr_id IN NUMBER DEFAULT NULL,
30 p_tve_id IN NUMBER);
31
32 SUBTYPE talv_rec_type is okc_tal_pvt.talv_rec_type;
33
34 PROCEDURE CREATE_TPA_RELTV(
35 p_api_version IN NUMBER,
36 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
37 x_return_status OUT NOCOPY VARCHAR2,
38 x_msg_count OUT NOCOPY NUMBER,
39 x_msg_data OUT NOCOPY VARCHAR2,
40 p_talv_rec IN talv_rec_type,
41 x_talv_rec OUT NOCOPY talv_rec_type) ;
42 PROCEDURE UPDATE_TPA_RELTV(
43 p_api_version IN NUMBER,
44 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_talv_rec IN talv_rec_type,
49 x_talv_rec OUT NOCOPY talv_rec_type) ;
50
51 PROCEDURE DELETE_TPA_RELTV(
52 p_api_version IN NUMBER,
53 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
54 x_return_status OUT NOCOPY VARCHAR2,
55 x_msg_count OUT NOCOPY NUMBER,
56 x_msg_data OUT NOCOPY VARCHAR2,
57 p_talv_rec IN talv_rec_type);
58
59 PROCEDURE LOCK_TPA_RELTV(
60 p_api_version IN NUMBER,
61 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_talv_rec IN talv_rec_type);
66
67 PROCEDURE VALID_TPA_RELTV(
68 p_api_version IN NUMBER,
69 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
70 x_return_status OUT NOCOPY VARCHAR2,
71 x_msg_count OUT NOCOPY NUMBER,
72 x_msg_data OUT NOCOPY VARCHAR2,
73 p_talv_rec IN talv_rec_type);
74
75 TYPE talv_event_rec_type IS RECORD (
76 id NUMBER := OKC_API.G_MISS_NUM,
77 object_version_number NUMBER := OKC_API.G_MISS_NUM,
78 --Bug 3122962
79 sfwt_flag OKC_TIME_TPA_RELATIVE_V.SFWT_FLAG%TYPE := 'N',
80 spn_id NUMBER := OKC_API.G_MISS_NUM,
81 cnh_id NUMBER := OKC_API.G_MISS_NUM,
82 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
83 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
84 tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
85 uom_code OKC_TIME_TPA_RELATIVE_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
86 description OKC_TIME_TPA_RELATIVE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
87 short_description OKC_TIME_TPA_RELATIVE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
88 comments OKC_TIME_TPA_RELATIVE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
89 duration NUMBER := OKC_API.G_MISS_NUM,
90 operator OKC_TIME_TPA_RELATIVE_V.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
91 before_after OKC_TIME_TPA_RELATIVE_V.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
92 attribute_category OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
93 attribute1 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
94 attribute2 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
95 attribute3 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
96 attribute4 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
97 attribute5 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
98 attribute6 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
99 attribute7 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
100 attribute8 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
101 attribute9 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
102 attribute10 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
103 attribute11 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
104 attribute12 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
105 attribute13 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
106 attribute14 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
107 attribute15 OKC_TIME_TPA_RELATIVE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
108 created_by NUMBER := OKC_API.G_MISS_NUM,
109 creation_date OKC_TIME_TPA_RELATIVE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
110 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
111 last_update_date OKC_TIME_TPA_RELATIVE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
112 last_update_login NUMBER := OKC_API.G_MISS_NUM,
113 tze_id NUMBER := OKC_API.G_MISS_NUM);
114
115 PROCEDURE CREATE_TPA_RELTV(
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_talv_evt_rec IN talv_event_rec_type,
122 x_talv_evt_rec OUT NOCOPY talv_event_rec_type) ;
123 PROCEDURE UPDATE_TPA_RELTV(
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_talv_evt_rec IN talv_event_rec_type,
130 x_talv_evt_rec OUT NOCOPY talv_event_rec_type) ;
131
132 PROCEDURE DELETE_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_rec IN talv_event_rec_type);
139
140 PROCEDURE LOCK_TPA_RELTV(
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_talv_evt_rec IN talv_event_rec_type);
147
148 PROCEDURE VALID_TPA_RELTV(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
151 x_return_status OUT NOCOPY VARCHAR2,
152 x_msg_count OUT NOCOPY NUMBER,
153 x_msg_data OUT NOCOPY VARCHAR2,
154 p_talv_evt_rec IN talv_event_rec_type);
155
156 --------------------------------------------------------------------------
157 ---The following procedures cater to handling of OKC_TIME_TPA_VALUE
158 --------------------------------------------------------------------------
159
160 SUBTYPE tavv_rec_type is okc_tav_pvt.tavv_rec_type;
161
162 PROCEDURE CREATE_TPA_VALUE(
163 p_api_version IN NUMBER,
164 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
165 x_return_status OUT NOCOPY VARCHAR2,
166 x_msg_count OUT NOCOPY NUMBER,
167 x_msg_data OUT NOCOPY VARCHAR2,
168 p_tavv_rec IN tavv_rec_type,
169 x_tavv_rec OUT NOCOPY tavv_rec_type) ;
170 PROCEDURE UPDATE_TPA_VALUE(
171 p_api_version IN NUMBER,
172 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
173 x_return_status OUT NOCOPY VARCHAR2,
174 x_msg_count OUT NOCOPY NUMBER,
175 x_msg_data OUT NOCOPY VARCHAR2,
176 p_tavv_rec IN tavv_rec_type,
177 x_tavv_rec OUT NOCOPY tavv_rec_type) ;
178
179 PROCEDURE DELETE_TPA_VALUE(
180 p_api_version IN NUMBER,
181 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
182 x_return_status OUT NOCOPY VARCHAR2,
183 x_msg_count OUT NOCOPY NUMBER,
184 x_msg_data OUT NOCOPY VARCHAR2,
185 p_tavv_rec IN tavv_rec_type);
186
187 PROCEDURE LOCK_TPA_VALUE(
188 p_api_version IN NUMBER,
189 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
190 x_return_status OUT NOCOPY VARCHAR2,
191 x_msg_count OUT NOCOPY NUMBER,
192 x_msg_data OUT NOCOPY VARCHAR2,
193 p_tavv_rec IN tavv_rec_type);
194
195 PROCEDURE VALID_TPA_VALUE(
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
198 x_return_status OUT NOCOPY VARCHAR2,
199 x_msg_count OUT NOCOPY NUMBER,
200 x_msg_data OUT NOCOPY VARCHAR2,
201 p_tavv_rec IN tavv_rec_type);
202
203
204 --------------------------------------------------------------------------
205 ---The following procedures cater to handling of OKC_TIME_TPG_DELIMITED
206 --------------------------------------------------------------------------
207
208 SUBTYPE tgdv_rec_type is okc_tgd_pvt.tgdv_rec_type;
209
210 TYPE tgdv_extended_rec_type IS RECORD (
211 id NUMBER := OKC_API.G_MISS_NUM,
212 object_version_number NUMBER := OKC_API.G_MISS_NUM,
213 --Bug 3122962
214 sfwt_flag OKC_TIME_TPG_DELIMITED_V.SFWT_FLAG%TYPE := 'N',
215 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
216 limited_start_date DATE := OKC_API.G_MISS_DATE,
217 limited_end_date DATE := OKC_API.G_MISS_DATE,
218 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
219 description OKC_TIME_TPG_DELIMITED_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
220 short_description OKC_TIME_TPG_DELIMITED_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
221 comments OKC_TIME_TPG_DELIMITED_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
222 month NUMBER := OKC_API.G_MISS_NUM,
223 day NUMBER := OKC_API.G_MISS_NUM,
224 day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
225 hour NUMBER := OKC_API.G_MISS_NUM,
226 minute NUMBER := OKC_API.G_MISS_NUM,
227 second NUMBER := OKC_API.G_MISS_NUM,
228 nth NUMBER := OKC_API.G_MISS_NUM,
229 attribute_category OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
230 attribute1 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
231 attribute2 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
232 attribute3 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
233 attribute4 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
234 attribute5 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
235 attribute6 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
236 attribute7 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
237 attribute8 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
238 attribute9 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
239 attribute10 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
240 attribute11 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
241 attribute12 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
242 attribute13 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
243 attribute14 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
244 attribute15 OKC_TIME_TPG_DELIMITED_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
245 created_by NUMBER := OKC_API.G_MISS_NUM,
246 creation_date OKC_TIME_TPG_DELIMITED_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
247 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
248 last_update_date OKC_TIME_TPG_DELIMITED_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
249 last_update_login NUMBER := OKC_API.G_MISS_NUM,
250 tze_id NUMBER := OKC_API.G_MISS_NUM);
251
252 PROCEDURE CREATE_TPG_DELIMITED(
253 p_api_version IN NUMBER,
254 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
255 x_return_status OUT NOCOPY VARCHAR2,
256 x_msg_count OUT NOCOPY NUMBER,
257 x_msg_data OUT NOCOPY VARCHAR2,
258 p_tgdv_ext_rec IN tgdv_extended_rec_type,
259 x_tgdv_ext_rec OUT NOCOPY tgdv_extended_rec_type) ;
260
261 PROCEDURE UPDATE_TPG_DELIMITED(
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_tgdv_ext_rec IN tgdv_extended_rec_type,
268 x_tgdv_ext_rec OUT NOCOPY tgdv_extended_rec_type) ;
269
270 PROCEDURE DELETE_TPG_DELIMITED(
271 p_api_version IN NUMBER,
272 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
273 x_return_status OUT NOCOPY VARCHAR2,
274 x_msg_count OUT NOCOPY NUMBER,
275 x_msg_data OUT NOCOPY VARCHAR2,
276 p_tgdv_ext_rec IN tgdv_extended_rec_type) ;
277
278 PROCEDURE LOCK_TPG_DELIMITED(
279 p_api_version IN NUMBER,
280 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
281 x_return_status OUT NOCOPY VARCHAR2,
282 x_msg_count OUT NOCOPY NUMBER,
283 x_msg_data OUT NOCOPY VARCHAR2,
284 p_tgdv_ext_rec IN tgdv_extended_rec_type) ;
285
286 PROCEDURE VALID_TPG_DELIMITED(
287 p_api_version IN NUMBER,
288 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
289 x_return_status OUT NOCOPY VARCHAR2,
290 x_msg_count OUT NOCOPY NUMBER,
291 x_msg_data OUT NOCOPY VARCHAR2,
292 p_tgdv_ext_rec IN tgdv_extended_rec_type) ;
293
294
295 --------------------------------------------------------------------------
296 ---The following procedures cater to handling of OKC_TIME_TPG_NAMED
297 --------------------------------------------------------------------------
298
299 SUBTYPE tgnv_rec_type is okc_tgn_pvt.tgnv_rec_type;
300
301 PROCEDURE CREATE_TPG_NAMED(
302 p_api_version IN NUMBER,
303 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304 x_return_status OUT NOCOPY VARCHAR2,
305 x_msg_count OUT NOCOPY NUMBER,
306 x_msg_data OUT NOCOPY VARCHAR2,
307 p_tgnv_rec IN tgnv_rec_type,
308 x_tgnv_rec OUT NOCOPY tgnv_rec_type) ;
309 PROCEDURE UPDATE_TPG_NAMED(
310 p_api_version IN NUMBER,
311 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
312 x_return_status OUT NOCOPY VARCHAR2,
313 x_msg_count OUT NOCOPY NUMBER,
314 x_msg_data OUT NOCOPY VARCHAR2,
315 p_tgnv_rec IN tgnv_rec_type,
316 x_tgnv_rec OUT NOCOPY tgnv_rec_type) ;
317
318 PROCEDURE DELETE_TPG_NAMED(
319 p_api_version IN NUMBER,
320 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
321 x_return_status OUT NOCOPY VARCHAR2,
322 x_msg_count OUT NOCOPY NUMBER,
323 x_msg_data OUT NOCOPY VARCHAR2,
324 p_tgnv_rec IN tgnv_rec_type);
325
326 PROCEDURE LOCK_TPG_NAMED(
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_tgnv_rec IN tgnv_rec_type);
333
334 PROCEDURE VALID_TPG_NAMED(
335 p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
337 x_return_status OUT NOCOPY VARCHAR2,
338 x_msg_count OUT NOCOPY NUMBER,
339 x_msg_data OUT NOCOPY VARCHAR2,
340 p_tgnv_rec IN tgnv_rec_type);
341
342
343 --------------------------------------------------------------------------
344 ---The following procedures cater to handling of OKC_TIME_IA_STARTEND
345 --------------------------------------------------------------------------
346
347 SUBTYPE isev_rec_type is okc_ise_pvt.isev_rec_type;
348
349 TYPE isev_extended_rec_type IS RECORD (
350 id NUMBER := OKC_API.G_MISS_NUM,
351 object_version_number NUMBER := OKC_API.G_MISS_NUM,
352 --Bug 3122962
353 sfwt_flag OKC_TIME_IA_STARTEND_V.SFWT_FLAG%TYPE := 'N',
354 spn_id NUMBER := OKC_API.G_MISS_NUM,
355 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
356 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
357 tve_id_started NUMBER := OKC_API.G_MISS_NUM,
358 tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
359 duration NUMBER := OKC_API.G_MISS_NUM,
360 uom_code OKC_TIME_IA_STARTEND_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
361 before_after OKC_TIME_IA_STARTEND_V.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
362 description OKC_TIME_IA_STARTEND_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
363 short_description OKC_TIME_IA_STARTEND_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
364 comments OKC_TIME_IA_STARTEND_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
365 operator OKC_TIME_IA_STARTEND_V.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
366 attribute_category OKC_TIME_IA_STARTEND_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
367 attribute1 OKC_TIME_IA_STARTEND_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
368 attribute2 OKC_TIME_IA_STARTEND_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
369 attribute3 OKC_TIME_IA_STARTEND_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
370 attribute4 OKC_TIME_IA_STARTEND_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
371 attribute5 OKC_TIME_IA_STARTEND_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
372 attribute6 OKC_TIME_IA_STARTEND_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
373 attribute7 OKC_TIME_IA_STARTEND_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
374 attribute8 OKC_TIME_IA_STARTEND_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
375 attribute9 OKC_TIME_IA_STARTEND_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
376 attribute10 OKC_TIME_IA_STARTEND_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
377 attribute11 OKC_TIME_IA_STARTEND_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
378 attribute12 OKC_TIME_IA_STARTEND_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
379 attribute13 OKC_TIME_IA_STARTEND_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
380 attribute14 OKC_TIME_IA_STARTEND_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
381 attribute15 OKC_TIME_IA_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
382 created_by NUMBER := OKC_API.G_MISS_NUM,
383 creation_date OKC_TIME_IA_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
384 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
385 last_update_date OKC_TIME_IA_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
386 last_update_login NUMBER := OKC_API.G_MISS_NUM,
387 start_date DATE := OKC_API.G_MISS_DATE,
388 end_date DATE := OKC_API.G_MISS_DATE,
389 tze_id NUMBER := OKC_API.G_MISS_NUM);
390
391 TYPE isev_reltv_rec_type IS RECORD (
392 id NUMBER := OKC_API.G_MISS_NUM,
393 object_version_number NUMBER := OKC_API.G_MISS_NUM,
394 --Bug 3122962
395 sfwt_flag OKC_TIME_IA_STARTEND_V.SFWT_FLAG%TYPE := 'N',
396 spn_id NUMBER := OKC_API.G_MISS_NUM,
397 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
398 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
399 tve_id_started NUMBER := OKC_API.G_MISS_NUM,
400 tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
401 duration NUMBER := OKC_API.G_MISS_NUM,
402 uom_code OKC_TIME_IA_STARTEND_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
403 before_after OKC_TIME_IA_STARTEND_V.BEFORE_AFTER%TYPE := OKC_API.G_MISS_CHAR,
404 description OKC_TIME_IA_STARTEND_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
405 short_description OKC_TIME_IA_STARTEND_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
406 comments OKC_TIME_IA_STARTEND_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
407 operator OKC_TIME_IA_STARTEND_V.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
408 attribute_category OKC_TIME_IA_STARTEND_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
409 attribute1 OKC_TIME_IA_STARTEND_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
410 attribute2 OKC_TIME_IA_STARTEND_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
411 attribute3 OKC_TIME_IA_STARTEND_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
412 attribute4 OKC_TIME_IA_STARTEND_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
413 attribute5 OKC_TIME_IA_STARTEND_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
414 attribute6 OKC_TIME_IA_STARTEND_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
415 attribute7 OKC_TIME_IA_STARTEND_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
416 attribute8 OKC_TIME_IA_STARTEND_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
417 attribute9 OKC_TIME_IA_STARTEND_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
418 attribute10 OKC_TIME_IA_STARTEND_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
419 attribute11 OKC_TIME_IA_STARTEND_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
420 attribute12 OKC_TIME_IA_STARTEND_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
421 attribute13 OKC_TIME_IA_STARTEND_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
422 attribute14 OKC_TIME_IA_STARTEND_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
423 attribute15 OKC_TIME_IA_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
424 created_by NUMBER := OKC_API.G_MISS_NUM,
425 creation_date OKC_TIME_IA_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
426 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
427 last_update_date OKC_TIME_IA_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
428 last_update_login NUMBER := OKC_API.G_MISS_NUM,
429 start_tve_id_offset NUMBER := OKC_API.G_MISS_NUM,
430 start_parent_date DATE := OKC_API.G_MISS_DATE,
431 start_uom_code OKC_TIME_TPA_RELATIVE_V.uom_code%TYPE := OKC_API.G_MISS_CHAR,
432 start_duration NUMBER := OKC_API.G_MISS_NUM,
433 start_operator OKC_TIME_TPA_RELATIVE_V.OPERATOR%TYPE := OKC_API.G_MISS_CHAR,
434 end_date DATE := OKC_API.G_MISS_DATE,
435 tze_id NUMBER := OKC_API.G_MISS_NUM);
436
437 PROCEDURE CREATE_IA_STARTEND(
438 p_api_version IN NUMBER,
439 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
440 x_return_status OUT NOCOPY VARCHAR2,
441 x_msg_count OUT NOCOPY NUMBER,
442 x_msg_data OUT NOCOPY VARCHAR2,
443 p_isev_ext_rec IN isev_extended_rec_type,
444 x_isev_ext_rec OUT NOCOPY isev_extended_rec_type) ;
445 PROCEDURE UPDATE_IA_STARTEND(
446 p_api_version IN NUMBER,
447 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
448 x_return_status OUT NOCOPY VARCHAR2,
449 x_msg_count OUT NOCOPY NUMBER,
450 x_msg_data OUT NOCOPY VARCHAR2,
451 p_isev_ext_rec IN isev_extended_rec_type,
452 x_isev_ext_rec OUT NOCOPY isev_extended_rec_type) ;
453 PROCEDURE DELETE_IA_STARTEND(
454 p_api_version IN NUMBER,
455 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
456 x_return_status OUT NOCOPY VARCHAR2,
457 x_msg_count OUT NOCOPY NUMBER,
458 x_msg_data OUT NOCOPY VARCHAR2,
459 p_isev_ext_rec IN isev_extended_rec_type);
460
461 PROCEDURE LOCK_IA_STARTEND(
462 p_api_version IN NUMBER,
463 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
464 x_return_status OUT NOCOPY VARCHAR2,
465 x_msg_count OUT NOCOPY NUMBER,
466 x_msg_data OUT NOCOPY VARCHAR2,
467 p_isev_ext_rec IN isev_extended_rec_type);
468
469 PROCEDURE VALID_IA_STARTEND(
470 p_api_version IN NUMBER,
471 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
472 x_return_status OUT NOCOPY VARCHAR2,
473 x_msg_count OUT NOCOPY NUMBER,
474 x_msg_data OUT NOCOPY VARCHAR2,
475 p_isev_ext_rec IN isev_extended_rec_type) ;
476
477 PROCEDURE CREATE_IA_STARTEND(
478 p_api_version IN NUMBER,
479 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
480 x_return_status OUT NOCOPY VARCHAR2,
481 x_msg_count OUT NOCOPY NUMBER,
482 x_msg_data OUT NOCOPY VARCHAR2,
483 p_isev_rel_rec IN isev_reltv_rec_type,
484 x_isev_rel_rec OUT NOCOPY isev_reltv_rec_type) ;
485 PROCEDURE UPDATE_IA_STARTEND(
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_isev_rel_rec IN isev_reltv_rec_type,
492 x_isev_rel_rec OUT NOCOPY isev_reltv_rec_type) ;
493 PROCEDURE DELETE_IA_STARTEND(
494 p_api_version IN NUMBER,
495 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
496 x_return_status OUT NOCOPY VARCHAR2,
497 x_msg_count OUT NOCOPY NUMBER,
498 x_msg_data OUT NOCOPY VARCHAR2,
499 p_isev_rel_rec IN isev_reltv_rec_type);
500
501 PROCEDURE LOCK_IA_STARTEND(
502 p_api_version IN NUMBER,
503 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
504 x_return_status OUT NOCOPY VARCHAR2,
505 x_msg_count OUT NOCOPY NUMBER,
506 x_msg_data OUT NOCOPY VARCHAR2,
507 p_isev_rel_rec IN isev_reltv_rec_type);
508
509 PROCEDURE VALID_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_rel_rec IN isev_reltv_rec_type) ;
516
517 --------------------------------------------------------------------------
518 ---The following procedures cater to handling of OKC_TIME_IG_STARTEND
519 --------------------------------------------------------------------------
520
521 SUBTYPE igsv_rec_type is okc_igs_pvt.igsv_rec_type;
522
523 TYPE igsv_extended_rec_type IS RECORD (
524 id NUMBER := OKC_API.G_MISS_NUM,
525 object_version_number NUMBER := OKC_API.G_MISS_NUM,
526 --Bug 3122962
527 sfwt_flag OKC_TIME_IG_STARTEND_V.SFWT_FLAG%TYPE := 'N',
528 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
529 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
530 tve_id_started NUMBER := OKC_API.G_MISS_NUM,
531 tve_id_ended NUMBER := OKC_API.G_MISS_NUM,
532 description OKC_TIME_IG_STARTEND_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
533 short_description OKC_TIME_IG_STARTEND_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
534 comments OKC_TIME_IG_STARTEND_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
535 attribute_category OKC_TIME_IG_STARTEND_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
536 attribute1 OKC_TIME_IG_STARTEND_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
537 attribute2 OKC_TIME_IG_STARTEND_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
538 attribute3 OKC_TIME_IG_STARTEND_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
539 attribute4 OKC_TIME_IG_STARTEND_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
540 attribute5 OKC_TIME_IG_STARTEND_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
541 attribute6 OKC_TIME_IG_STARTEND_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
542 attribute7 OKC_TIME_IG_STARTEND_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
543 attribute8 OKC_TIME_IG_STARTEND_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
544 attribute9 OKC_TIME_IG_STARTEND_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
545 attribute10 OKC_TIME_IG_STARTEND_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
546 attribute11 OKC_TIME_IG_STARTEND_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
547 attribute12 OKC_TIME_IG_STARTEND_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
548 attribute13 OKC_TIME_IG_STARTEND_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
549 attribute14 OKC_TIME_IG_STARTEND_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
550 attribute15 OKC_TIME_IG_STARTEND_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
551 created_by NUMBER := OKC_API.G_MISS_NUM,
552 creation_date OKC_TIME_IG_STARTEND_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
553 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
554 last_update_date OKC_TIME_IG_STARTEND_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
555 last_update_login NUMBER := OKC_API.G_MISS_NUM,
556 start_month NUMBER := OKC_API.G_MISS_NUM,
557 start_day NUMBER := OKC_API.G_MISS_NUM,
558 start_day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
559 start_hour NUMBER := OKC_API.G_MISS_NUM,
560 start_minute NUMBER := OKC_API.G_MISS_NUM,
561 start_second NUMBER := OKC_API.G_MISS_NUM,
562 start_nth NUMBER := OKC_API.G_MISS_NUM,
563 end_month NUMBER := OKC_API.G_MISS_NUM,
564 end_day NUMBER := OKC_API.G_MISS_NUM,
565 end_day_of_week OKC_TIME_TPG_DELIMITED_V.DAY_OF_WEEK%TYPE := OKC_API.G_MISS_CHAR,
566 end_hour NUMBER := OKC_API.G_MISS_NUM,
567 end_minute NUMBER := OKC_API.G_MISS_NUM,
568 end_second NUMBER := OKC_API.G_MISS_NUM,
569 end_nth NUMBER := OKC_API.G_MISS_NUM,
570 tze_id NUMBER := OKC_API.G_MISS_NUM);
571
572 PROCEDURE CREATE_IG_STARTEND(
573 p_api_version IN NUMBER,
574 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
575 x_return_status OUT NOCOPY VARCHAR2,
576 x_msg_count OUT NOCOPY NUMBER,
577 x_msg_data OUT NOCOPY VARCHAR2,
578 p_igsv_ext_rec IN igsv_extended_rec_type,
579 x_igsv_ext_rec OUT NOCOPY igsv_extended_rec_type) ;
580
581 PROCEDURE UPDATE_IG_STARTEND(
582 p_api_version IN NUMBER,
583 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
584 x_return_status OUT NOCOPY VARCHAR2,
585 x_msg_count OUT NOCOPY NUMBER,
586 x_msg_data OUT NOCOPY VARCHAR2,
587 p_igsv_ext_rec IN igsv_extended_rec_type,
588 x_igsv_ext_rec OUT NOCOPY igsv_extended_rec_type);
589
590 PROCEDURE DELETE_IG_STARTEND(
591 p_api_version IN NUMBER,
592 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
593 x_return_status OUT NOCOPY VARCHAR2,
594 x_msg_count OUT NOCOPY NUMBER,
595 x_msg_data OUT NOCOPY VARCHAR2,
596 p_igsv_ext_rec IN igsv_extended_rec_type) ;
597
598 PROCEDURE LOCK_IG_STARTEND(
599 p_api_version IN NUMBER,
600 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
601 x_return_status OUT NOCOPY VARCHAR2,
602 x_msg_count OUT NOCOPY NUMBER,
603 x_msg_data OUT NOCOPY VARCHAR2,
604 p_igsv_ext_rec IN igsv_extended_rec_type) ;
605
606 PROCEDURE VALID_IG_STARTEND(
607 p_api_version IN NUMBER,
608 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
609 x_return_status OUT NOCOPY VARCHAR2,
610 x_msg_count OUT NOCOPY NUMBER,
611 x_msg_data OUT NOCOPY VARCHAR2,
612 p_igsv_ext_rec IN igsv_extended_rec_type) ;
613
614 --------------------------------------------------------------------------
615 ---The following procedures cater to handling of OKC_TIME_CYCLE
616 --------------------------------------------------------------------------
617
618 SUBTYPE cylv_rec_type is okc_cyl_pvt.cylv_rec_type;
619 TYPE cylv_extended_rec_type IS RECORD (
620 id NUMBER := OKC_API.G_MISS_NUM,
621 object_version_number NUMBER := OKC_API.G_MISS_NUM,
622 --Bug 3122962
623 sfwt_flag OKC_TIME_CYCLE_V.SFWT_FLAG%TYPE := 'N',
624 spn_id NUMBER := OKC_API.G_MISS_NUM,
625 tve_id_limited NUMBER := OKC_API.G_MISS_NUM,
626 limited_start_date DATE := OKC_API.G_MISS_DATE,
627 limited_end_date DATE := OKC_API.G_MISS_DATE,
628 tze_id NUMBER := OKC_API.G_MISS_NUM,
629 dnz_chr_id NUMBER := OKC_API.G_MISS_NUM,
630 uom_code OKC_SPAN_V.uom_code%TYPE,
631 duration OKC_SPAN_V.DURATION%TYPE,
632 active_yn OKC_SPAN_V.ACTIVE_YN%TYPE,
633 description OKC_TIME_CYCLE_V.DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
634 short_description OKC_TIME_CYCLE_V.SHORT_DESCRIPTION%TYPE := OKC_API.G_MISS_CHAR,
635 comments OKC_TIME_CYCLE_V.COMMENTS%TYPE := OKC_API.G_MISS_CHAR,
636 name OKC_TIME_CYCLE_V.NAME%TYPE := OKC_API.G_MISS_CHAR,
637 interval_yn OKC_TIME_CYCLE_V.INTERVAL_YN%TYPE := OKC_API.G_MISS_CHAR,
638 attribute_category OKC_TIME_CYCLE_V.ATTRIBUTE_CATEGORY%TYPE := OKC_API.G_MISS_CHAR,
639 attribute1 OKC_TIME_CYCLE_V.ATTRIBUTE1%TYPE := OKC_API.G_MISS_CHAR,
640 attribute2 OKC_TIME_CYCLE_V.ATTRIBUTE2%TYPE := OKC_API.G_MISS_CHAR,
641 attribute3 OKC_TIME_CYCLE_V.ATTRIBUTE3%TYPE := OKC_API.G_MISS_CHAR,
642 attribute4 OKC_TIME_CYCLE_V.ATTRIBUTE4%TYPE := OKC_API.G_MISS_CHAR,
643 attribute5 OKC_TIME_CYCLE_V.ATTRIBUTE5%TYPE := OKC_API.G_MISS_CHAR,
644 attribute6 OKC_TIME_CYCLE_V.ATTRIBUTE6%TYPE := OKC_API.G_MISS_CHAR,
645 attribute7 OKC_TIME_CYCLE_V.ATTRIBUTE7%TYPE := OKC_API.G_MISS_CHAR,
646 attribute8 OKC_TIME_CYCLE_V.ATTRIBUTE8%TYPE := OKC_API.G_MISS_CHAR,
647 attribute9 OKC_TIME_CYCLE_V.ATTRIBUTE9%TYPE := OKC_API.G_MISS_CHAR,
648 attribute10 OKC_TIME_CYCLE_V.ATTRIBUTE10%TYPE := OKC_API.G_MISS_CHAR,
649 attribute11 OKC_TIME_CYCLE_V.ATTRIBUTE11%TYPE := OKC_API.G_MISS_CHAR,
650 attribute12 OKC_TIME_CYCLE_V.ATTRIBUTE12%TYPE := OKC_API.G_MISS_CHAR,
651 attribute13 OKC_TIME_CYCLE_V.ATTRIBUTE13%TYPE := OKC_API.G_MISS_CHAR,
652 attribute14 OKC_TIME_CYCLE_V.ATTRIBUTE14%TYPE := OKC_API.G_MISS_CHAR,
653 attribute15 OKC_TIME_CYCLE_V.ATTRIBUTE15%TYPE := OKC_API.G_MISS_CHAR,
654 created_by NUMBER := OKC_API.G_MISS_NUM,
655 creation_date OKC_TIME_CYCLE_V.CREATION_DATE%TYPE := OKC_API.G_MISS_DATE,
656 last_updated_by NUMBER := OKC_API.G_MISS_NUM,
657 last_update_date OKC_TIME_CYCLE_V.LAST_UPDATE_DATE%TYPE := OKC_API.G_MISS_DATE,
658 last_update_login NUMBER := OKC_API.G_MISS_NUM);
659
660 PROCEDURE CREATE_CYCLE(
661 p_api_version IN NUMBER,
662 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
663 x_return_status OUT NOCOPY VARCHAR2,
664 x_msg_count OUT NOCOPY NUMBER,
665 x_msg_data OUT NOCOPY VARCHAR2,
666 p_cylv_ext_rec IN cylv_extended_rec_type,
667 x_cylv_ext_rec OUT NOCOPY cylv_extended_rec_type) ;
668
669 PROCEDURE UPDATE_CYCLE(
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_cylv_ext_rec IN cylv_extended_rec_type,
676 x_cylv_ext_rec OUT NOCOPY cylv_extended_rec_type) ;
677
678 PROCEDURE DELETE_CYCLE(
679 p_api_version IN NUMBER,
680 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
681 x_return_status OUT NOCOPY VARCHAR2,
682 x_msg_count OUT NOCOPY NUMBER,
683 x_msg_data OUT NOCOPY VARCHAR2,
684 p_cylv_ext_rec IN cylv_extended_rec_type) ;
685
686 PROCEDURE LOCK_CYCLE(
687 p_api_version IN NUMBER,
688 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
689 x_return_status OUT NOCOPY VARCHAR2,
690 x_msg_count OUT NOCOPY NUMBER,
691 x_msg_data OUT NOCOPY VARCHAR2,
692 p_cylv_ext_rec IN cylv_extended_rec_type) ;
693
694 PROCEDURE VALID_CYCLE(
695 p_api_version IN NUMBER,
696 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
697 x_return_status OUT NOCOPY VARCHAR2,
698 x_msg_count OUT NOCOPY NUMBER,
699 x_msg_data OUT NOCOPY VARCHAR2,
700 p_cylv_ext_rec IN cylv_extended_rec_type) ;
701
702
703 --------------------------------------------------------------------------
704 ---The following procedures cater to handling of OKC_TIME_SPAN
705 --------------------------------------------------------------------------
706
707 SUBTYPE spnv_rec_type is okc_spn_pvt.spnv_rec_type;
708
709 PROCEDURE CREATE_SPAN(
710 p_api_version IN NUMBER,
711 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
712 x_return_status OUT NOCOPY VARCHAR2,
713 x_msg_count OUT NOCOPY NUMBER,
714 x_msg_data OUT NOCOPY VARCHAR2,
715 p_spnv_rec IN spnv_rec_type,
716 x_spnv_rec OUT NOCOPY spnv_rec_type) ;
717
718 PROCEDURE UPDATE_SPAN(
719 p_api_version IN NUMBER,
720 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
721 x_return_status OUT NOCOPY VARCHAR2,
722 x_msg_count OUT NOCOPY NUMBER,
723 x_msg_data OUT NOCOPY VARCHAR2,
724 p_spnv_rec IN spnv_rec_type,
725 x_spnv_rec OUT NOCOPY spnv_rec_type) ;
726
727 PROCEDURE DELETE_SPAN(
728 p_api_version IN NUMBER,
729 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
730 x_return_status OUT NOCOPY VARCHAR2,
731 x_msg_count OUT NOCOPY NUMBER,
732 x_msg_data OUT NOCOPY VARCHAR2,
733 p_spnv_rec IN spnv_rec_type) ;
734
735 PROCEDURE LOCK_SPAN(
736 p_api_version IN NUMBER,
737 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
738 x_return_status OUT NOCOPY VARCHAR2,
739 x_msg_count OUT NOCOPY NUMBER,
740 x_msg_data OUT NOCOPY VARCHAR2,
741 p_spnv_rec IN spnv_rec_type) ;
742
743 PROCEDURE VALID_SPAN(
744 p_api_version IN NUMBER,
745 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
746 x_return_status OUT NOCOPY VARCHAR2,
747 x_msg_count OUT NOCOPY NUMBER,
748 x_msg_data OUT NOCOPY VARCHAR2,
749 p_spnv_rec IN spnv_rec_type) ;
750
751 --------------------------------------------------------------------------
752 ---The following procedures cater to handling of OKC_TIME_CODE_UNITS
753 --------------------------------------------------------------------------
754
755 SUBTYPE tcuv_rec_type is okc_tcu_pvt.tcuv_rec_type;
756
757 PROCEDURE CREATE_TIME_CODE_UNITS(
758 p_api_version IN NUMBER,
759 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
760 x_return_status OUT NOCOPY VARCHAR2,
761 x_msg_count OUT NOCOPY NUMBER,
762 x_msg_data OUT NOCOPY VARCHAR2,
763 p_tcuv_rec IN tcuv_rec_type,
764 x_tcuv_rec OUT NOCOPY tcuv_rec_type) ;
765
766 PROCEDURE UPDATE_TIME_CODE_UNITS(
767 p_api_version IN NUMBER,
768 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
769 x_return_status OUT NOCOPY VARCHAR2,
770 x_msg_count OUT NOCOPY NUMBER,
771 x_msg_data OUT NOCOPY VARCHAR2,
772 p_tcuv_rec IN tcuv_rec_type,
773 x_tcuv_rec OUT NOCOPY tcuv_rec_type) ;
774
775 PROCEDURE DELETE_TIME_CODE_UNITS(
776 p_api_version IN NUMBER,
777 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
778 x_return_status OUT NOCOPY VARCHAR2,
779 x_msg_count OUT NOCOPY NUMBER,
780 x_msg_data OUT NOCOPY VARCHAR2,
781 p_tcuv_rec IN tcuv_rec_type) ;
782
783 PROCEDURE LOCK_TIME_CODE_UNITS(
784 p_api_version IN NUMBER,
785 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
786 x_return_status OUT NOCOPY VARCHAR2,
787 x_msg_count OUT NOCOPY NUMBER,
788 x_msg_data OUT NOCOPY VARCHAR2,
789 p_tcuv_rec IN tcuv_rec_type) ;
790
791 PROCEDURE VALID_TIME_CODE_UNITS(
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_tcuv_rec IN tcuv_rec_type) ;
798
799 --------------------------------------------------------------------------
800 ---The following procedures cater to handling of OKC_RESOLVED_TIMEVALUES
801 --------------------------------------------------------------------------
802
803 SUBTYPE rtvv_rec_type is okc_rtv_pvt.rtvv_rec_type;
804
805 PROCEDURE CREATE_RESOLVED_TIMEVALUES(
806 p_api_version IN NUMBER,
807 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
808 x_return_status OUT NOCOPY VARCHAR2,
809 x_msg_count OUT NOCOPY NUMBER,
810 x_msg_data OUT NOCOPY VARCHAR2,
811 p_rtvv_rec IN rtvv_rec_type,
812 x_rtvv_rec OUT NOCOPY rtvv_rec_type) ;
813
814 PROCEDURE UPDATE_RESOLVED_TIMEVALUES(
815 p_api_version IN NUMBER,
816 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
817 x_return_status OUT NOCOPY VARCHAR2,
818 x_msg_count OUT NOCOPY NUMBER,
819 x_msg_data OUT NOCOPY VARCHAR2,
820 p_rtvv_rec IN rtvv_rec_type,
821 x_rtvv_rec OUT NOCOPY rtvv_rec_type) ;
822
823 PROCEDURE DELETE_RESOLVED_TIMEVALUES(
824 p_api_version IN NUMBER,
825 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
826 x_return_status OUT NOCOPY VARCHAR2,
827 x_msg_count OUT NOCOPY NUMBER,
828 x_msg_data OUT NOCOPY VARCHAR2,
829 p_rtvv_rec IN rtvv_rec_type) ;
830
831 PROCEDURE LOCK_RESOLVED_TIMEVALUES(
832 p_api_version IN NUMBER,
833 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
834 x_return_status OUT NOCOPY VARCHAR2,
835 x_msg_count OUT NOCOPY NUMBER,
836 x_msg_data OUT NOCOPY VARCHAR2,
837 p_rtvv_rec IN rtvv_rec_type) ;
838
839 PROCEDURE VALID_RESOLVED_TIMEVALUES(
840 p_api_version IN NUMBER,
841 p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
842 x_return_status OUT NOCOPY VARCHAR2,
843 x_msg_count OUT NOCOPY NUMBER,
844 x_msg_data OUT NOCOPY VARCHAR2,
845 p_rtvv_rec IN rtvv_rec_type) ;
846
847 ---------------------------------------------------------------
848 -- Procedure for mass insert in OKC_TIMEVALUES _B and TL tables
849 ---------------------------------------------------------------
850 TYPE igsv_ext_tbl_type is table of igsv_extended_rec_type index by binary_integer;
851 PROCEDURE INSERT_IGS_ROW_UPG(p_igsv_ext_tbl IN igsv_ext_tbl_type);
852 TYPE tgdv_ext_tbl_type is table of tgdv_extended_rec_type index by binary_integer;
853 PROCEDURE INSERT_TGD_ROW_UPG(p_tgdv_ext_tbl IN tgdv_ext_tbl_type);
854 TYPE isev_ext_tbl_type is table of isev_extended_rec_type index by binary_integer;
855 PROCEDURE INSERT_ISE_ROW_UPG(p_isev_ext_tbl IN isev_ext_tbl_type);
856 TYPE isev_rel_tbl_type is table of isev_reltv_rec_type index by binary_integer;
857 PROCEDURE INSERT_ISE_ROW_UPG(p_isev_rel_tbl IN isev_rel_tbl_type);
858 END OKC_TIME_PVT;