[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_timezone_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_timezone_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_timezone_rec.offset_time IS NULL
31: THEN
25: p_timezone_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_timezone_rec.offset_time IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'offset_time');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_timezone_rec.offset_time IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'offset_time');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_timezone_rec.last_update_date IS NULL
36: THEN
30: p_timezone_rec.offset_time IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'offset_time');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_timezone_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_timezone_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_timezone_rec.last_updated_by IS NULL
41: THEN
35: p_timezone_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_timezone_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_timezone_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_timezone_rec.creation_date IS NULL
46: THEN
40: p_timezone_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_timezone_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_timezone_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_timezone_rec.created_by IS NULL
51: THEN
45: p_timezone_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_timezone_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_timezone_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;
154: END migrate;
155: PROCEDURE insert_row
156: (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
159: p_validation_level IN NUMBER,
160: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
161: x_return_status OUT VARCHAR2,
162: x_msg_count OUT NUMBER,
156: (
157: p_api_version IN NUMBER,
158: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
159: p_validation_level IN NUMBER,
160: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
161: x_return_status OUT VARCHAR2,
162: x_msg_count OUT NUMBER,
163: x_msg_data OUT VARCHAR2,
164: p_timezone_rec IN TimeZone_Rec_Type := G_MISS_TIMEZONE_REC,
169: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
170: l_timezone_rec TimeZone_Rec_Type;
171: l_def_timezone_rec TimeZone_Rec_Type;
172: BEGIN
173: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
174: G_PKG_NAME,
175: l_api_version,
176: p_api_version,
177: p_init_msg_list,
280: l_def_timezone_rec.object_version_number);
281: -- Set OUT values
282: x_time_zone_id := l_def_timezone_rec.time_zone_id;
283: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
284: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
288: (
283: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
284: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
288: (
289: l_api_name,
290: G_PKG_NAME,
291: 'FND_API.G_RET_STS_ERROR',
294: '_Pvt'
295: );
296: APP_EXCEPTION.RAISE_EXCEPTION;
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
299: (
300: l_api_name,
301: G_PKG_NAME,
302: 'FND_API.G_RET_STS_UNEXP_ERROR',
304: x_msg_data,
305: '_Pvt'
306: );
307: APP_EXCEPTION.RAISE_EXCEPTION;
308: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
309: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,
305: '_Pvt'
306: );
307: APP_EXCEPTION.RAISE_EXCEPTION;
308: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
309: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,
313: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
309: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,
313: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
314: x_msg_count,
315: x_msg_data,
316: '_Pvt'
317: );
319: END insert_row;
320: PROCEDURE insert_row
321: (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
324: p_validation_level IN NUMBER,
325: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
326: x_return_status OUT VARCHAR2,
327: x_msg_count OUT NUMBER,
321: (
322: p_api_version IN NUMBER,
323: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
324: p_validation_level IN NUMBER,
325: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
326: x_return_status OUT VARCHAR2,
327: x_msg_count OUT NUMBER,
328: x_msg_data OUT VARCHAR2,
329: p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,
360: l_api_version CONSTANT NUMBER := 1;
361: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
362: l_timezone_rec TimeZone_Rec_Type;
363: BEGIN
364: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
365: G_PKG_NAME,
366: l_api_version,
367: p_api_version,
368: p_init_msg_list,
412: l_timezone_rec,
413: x_time_zone_id,
414: x_object_version_number
415: );
416: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
420: (
415: );
416: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
420: (
421: l_api_name,
422: G_PKG_NAME,
423: 'FND_API.G_RET_STS_ERROR',
426: '_Pvt'
427: );
428: APP_EXCEPTION.RAISE_EXCEPTION;
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
431: (
432: l_api_name,
433: G_PKG_NAME,
434: 'FND_API.G_RET_STS_UNEXP_ERROR',
436: x_msg_data,
437: '_Pvt'
438: );
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
441: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
442: (
443: l_api_name,
444: G_PKG_NAME,
437: '_Pvt'
438: );
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
441: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
442: (
443: l_api_name,
444: G_PKG_NAME,
445: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
441: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
442: (
443: l_api_name,
444: G_PKG_NAME,
445: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
446: x_msg_count,
447: x_msg_data,
448: '_Pvt'
449: );
451: END insert_row;
452: Procedure lock_row
453: (
454: p_api_version IN NUMBER,
455: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
456: p_validation_level IN NUMBER,
457: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
458: x_return_status OUT VARCHAR2,
459: x_msg_count OUT NUMBER,
453: (
454: p_api_version IN NUMBER,
455: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
456: p_validation_level IN NUMBER,
457: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
458: x_return_status OUT VARCHAR2,
459: x_msg_count OUT NUMBER,
460: x_msg_data OUT VARCHAR2,
461: p_time_zone_id IN NUMBER,
483: lc_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;
484: l_row_notfound BOOLEAN := FALSE;
485: lc_row_notfound BOOLEAN := FALSE;
486: BEGIN
487: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
488: G_PKG_NAME,
489: l_api_version,
490: p_api_version,
491: p_init_msg_list,
505: WHEN E_Resource_Busy THEN
506: IF (lock_csr%ISOPEN) THEN
507: CLOSE lock_csr;
508: END IF;
509: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
510: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
511: END;
512:
513: IF ( l_row_notfound ) THEN
516: lc_row_notfound := lchk_csr%NOTFOUND;
517: CLOSE lchk_csr;
518: END IF;
519: IF (lc_row_notfound) THEN
520: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF lc_object_version_number > p_object_version_number THEN
523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
519: IF (lc_row_notfound) THEN
520: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF lc_object_version_number > p_object_version_number THEN
523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN
526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
522: ELSIF lc_object_version_number > p_object_version_number THEN
523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN
526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF lc_object_version_number = -1 THEN
529: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
530: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN
526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF lc_object_version_number = -1 THEN
529: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
533: EXCEPTION
528: ELSIF lc_object_version_number = -1 THEN
529: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
536: (
531: END IF;
532: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
536: (
537: l_api_name,
538: G_PKG_NAME,
539: 'FND_API.G_RET_STS_ERROR',
542: '_Pvt'
543: );
544: APP_EXCEPTION.RAISE_EXCEPTION;
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
547: (
548: l_api_name,
549: G_PKG_NAME,
550: 'FND_API.G_RET_STS_UNEXP_ERROR',
552: x_msg_data,
553: '_Pvt'
554: );
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
557: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,
553: '_Pvt'
554: );
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
557: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,
561: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
557: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
558: (
559: l_api_name,
560: G_PKG_NAME,
561: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
562: x_msg_count,
563: x_msg_data,
564: '_Pvt'
565: );
567: END lock_row;
568: Procedure update_row
569: (
570: p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
572: p_validation_level IN NUMBER,
573: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
574: x_return_status OUT VARCHAR2,
575: x_msg_count OUT NUMBER,
569: (
570: p_api_version IN NUMBER,
571: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
572: p_validation_level IN NUMBER,
573: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
574: x_return_status OUT VARCHAR2,
575: x_msg_count OUT NUMBER,
576: x_msg_data OUT VARCHAR2,
577: p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC,
601: CLOSE cs_time_zones_pk_csr;
602: IF (l_row_notfound) THEN
603: l_return_status := FND_API.G_RET_STS_ERROR;
604: END IF;
605: IF (x_timezone_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
606: THEN
607: x_timezone_rec.time_zone_id := l_cs_time_zones_pk.time_zone_id;
608: END IF;
609: IF (x_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
605: IF (x_timezone_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
606: THEN
607: x_timezone_rec.time_zone_id := l_cs_time_zones_pk.time_zone_id;
608: END IF;
609: IF (x_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
610: THEN
611: x_timezone_rec.name := l_cs_time_zones_pk.name;
612: END IF;
613: IF (x_timezone_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
609: IF (x_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
610: THEN
611: x_timezone_rec.name := l_cs_time_zones_pk.name;
612: END IF;
613: IF (x_timezone_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
614: THEN
615: x_timezone_rec.description := l_cs_time_zones_pk.description;
616: END IF;
617: IF (x_timezone_rec.offset_indicator = TAPI_DEV_KIT.G_MISS_CHAR)
613: IF (x_timezone_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
614: THEN
615: x_timezone_rec.description := l_cs_time_zones_pk.description;
616: END IF;
617: IF (x_timezone_rec.offset_indicator = TAPI_DEV_KIT.G_MISS_CHAR)
618: THEN
619: x_timezone_rec.offset_indicator := l_cs_time_zones_pk.offset_indicator;
620: END IF;
621: IF (x_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE)
617: IF (x_timezone_rec.offset_indicator = TAPI_DEV_KIT.G_MISS_CHAR)
618: THEN
619: x_timezone_rec.offset_indicator := l_cs_time_zones_pk.offset_indicator;
620: END IF;
621: IF (x_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE)
622: THEN
623: x_timezone_rec.offset_time := l_cs_time_zones_pk.offset_time;
624: END IF;
625: IF (x_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
621: IF (x_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE)
622: THEN
623: x_timezone_rec.offset_time := l_cs_time_zones_pk.offset_time;
624: END IF;
625: IF (x_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
626: THEN
627: x_timezone_rec.last_update_date := l_cs_time_zones_pk.last_update_date;
628: END IF;
629: IF (x_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
625: IF (x_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
626: THEN
627: x_timezone_rec.last_update_date := l_cs_time_zones_pk.last_update_date;
628: END IF;
629: IF (x_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
630: THEN
631: x_timezone_rec.last_updated_by := l_cs_time_zones_pk.last_updated_by;
632: END IF;
633: IF (x_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
629: IF (x_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
630: THEN
631: x_timezone_rec.last_updated_by := l_cs_time_zones_pk.last_updated_by;
632: END IF;
633: IF (x_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
634: THEN
635: x_timezone_rec.creation_date := l_cs_time_zones_pk.creation_date;
636: END IF;
637: IF (x_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
633: IF (x_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
634: THEN
635: x_timezone_rec.creation_date := l_cs_time_zones_pk.creation_date;
636: END IF;
637: IF (x_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_timezone_rec.created_by := l_cs_time_zones_pk.created_by;
640: END IF;
641: IF (x_timezone_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
637: IF (x_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_timezone_rec.created_by := l_cs_time_zones_pk.created_by;
640: END IF;
641: IF (x_timezone_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
642: THEN
643: x_timezone_rec.last_update_login := l_cs_time_zones_pk.last_update_login;
644: END IF;
645: IF (x_timezone_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
641: IF (x_timezone_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
642: THEN
643: x_timezone_rec.last_update_login := l_cs_time_zones_pk.last_update_login;
644: END IF;
645: IF (x_timezone_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
646: THEN
647: x_timezone_rec.start_date_active := l_cs_time_zones_pk.start_date_active;
648: END IF;
649: IF (x_timezone_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
645: IF (x_timezone_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
646: THEN
647: x_timezone_rec.start_date_active := l_cs_time_zones_pk.start_date_active;
648: END IF;
649: IF (x_timezone_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_timezone_rec.end_date_active := l_cs_time_zones_pk.end_date_active;
652: END IF;
653: IF (x_timezone_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
649: IF (x_timezone_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_timezone_rec.end_date_active := l_cs_time_zones_pk.end_date_active;
652: END IF;
653: IF (x_timezone_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
654: THEN
655: x_timezone_rec.attribute1 := l_cs_time_zones_pk.attribute1;
656: END IF;
657: IF (x_timezone_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
653: IF (x_timezone_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
654: THEN
655: x_timezone_rec.attribute1 := l_cs_time_zones_pk.attribute1;
656: END IF;
657: IF (x_timezone_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
658: THEN
659: x_timezone_rec.attribute2 := l_cs_time_zones_pk.attribute2;
660: END IF;
661: IF (x_timezone_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
657: IF (x_timezone_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
658: THEN
659: x_timezone_rec.attribute2 := l_cs_time_zones_pk.attribute2;
660: END IF;
661: IF (x_timezone_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
662: THEN
663: x_timezone_rec.attribute3 := l_cs_time_zones_pk.attribute3;
664: END IF;
665: IF (x_timezone_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
661: IF (x_timezone_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
662: THEN
663: x_timezone_rec.attribute3 := l_cs_time_zones_pk.attribute3;
664: END IF;
665: IF (x_timezone_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
666: THEN
667: x_timezone_rec.attribute4 := l_cs_time_zones_pk.attribute4;
668: END IF;
669: IF (x_timezone_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
665: IF (x_timezone_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
666: THEN
667: x_timezone_rec.attribute4 := l_cs_time_zones_pk.attribute4;
668: END IF;
669: IF (x_timezone_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_timezone_rec.attribute5 := l_cs_time_zones_pk.attribute5;
672: END IF;
673: IF (x_timezone_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
669: IF (x_timezone_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_timezone_rec.attribute5 := l_cs_time_zones_pk.attribute5;
672: END IF;
673: IF (x_timezone_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_timezone_rec.attribute6 := l_cs_time_zones_pk.attribute6;
676: END IF;
677: IF (x_timezone_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
673: IF (x_timezone_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_timezone_rec.attribute6 := l_cs_time_zones_pk.attribute6;
676: END IF;
677: IF (x_timezone_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_timezone_rec.attribute7 := l_cs_time_zones_pk.attribute7;
680: END IF;
681: IF (x_timezone_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
677: IF (x_timezone_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_timezone_rec.attribute7 := l_cs_time_zones_pk.attribute7;
680: END IF;
681: IF (x_timezone_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_timezone_rec.attribute8 := l_cs_time_zones_pk.attribute8;
684: END IF;
685: IF (x_timezone_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
681: IF (x_timezone_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_timezone_rec.attribute8 := l_cs_time_zones_pk.attribute8;
684: END IF;
685: IF (x_timezone_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_timezone_rec.attribute9 := l_cs_time_zones_pk.attribute9;
688: END IF;
689: IF (x_timezone_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
685: IF (x_timezone_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_timezone_rec.attribute9 := l_cs_time_zones_pk.attribute9;
688: END IF;
689: IF (x_timezone_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_timezone_rec.attribute10 := l_cs_time_zones_pk.attribute10;
692: END IF;
693: IF (x_timezone_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
689: IF (x_timezone_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_timezone_rec.attribute10 := l_cs_time_zones_pk.attribute10;
692: END IF;
693: IF (x_timezone_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_timezone_rec.attribute11 := l_cs_time_zones_pk.attribute11;
696: END IF;
697: IF (x_timezone_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
693: IF (x_timezone_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_timezone_rec.attribute11 := l_cs_time_zones_pk.attribute11;
696: END IF;
697: IF (x_timezone_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_timezone_rec.attribute12 := l_cs_time_zones_pk.attribute12;
700: END IF;
701: IF (x_timezone_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
697: IF (x_timezone_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_timezone_rec.attribute12 := l_cs_time_zones_pk.attribute12;
700: END IF;
701: IF (x_timezone_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_timezone_rec.attribute13 := l_cs_time_zones_pk.attribute13;
704: END IF;
705: IF (x_timezone_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
701: IF (x_timezone_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_timezone_rec.attribute13 := l_cs_time_zones_pk.attribute13;
704: END IF;
705: IF (x_timezone_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_timezone_rec.attribute14 := l_cs_time_zones_pk.attribute14;
708: END IF;
709: IF (x_timezone_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
705: IF (x_timezone_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_timezone_rec.attribute14 := l_cs_time_zones_pk.attribute14;
708: END IF;
709: IF (x_timezone_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_timezone_rec.attribute15 := l_cs_time_zones_pk.attribute15;
712: END IF;
713: IF (x_timezone_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
709: IF (x_timezone_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_timezone_rec.attribute15 := l_cs_time_zones_pk.attribute15;
712: END IF;
713: IF (x_timezone_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_timezone_rec.context := l_cs_time_zones_pk.context;
716: END IF;
717: IF (x_timezone_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
713: IF (x_timezone_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_timezone_rec.context := l_cs_time_zones_pk.context;
716: END IF;
717: IF (x_timezone_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
718: THEN
719: x_timezone_rec.object_version_number := l_cs_time_zones_pk.object_version_number;
720: END IF;
721: RETURN(l_return_status);
720: END IF;
721: RETURN(l_return_status);
722: END populate_new_record;
723: BEGIN
724: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
725: G_PKG_NAME,
726: l_api_version,
727: p_api_version,
728: p_init_msg_list,
807: WHERE
808: TIME_ZONE_ID = l_def_timezone_rec.time_zone_id
809: ;
810: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
811: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
812: EXCEPTION
813: WHEN FND_API.G_EXC_ERROR THEN
814: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
815: (
810: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
811: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
812: EXCEPTION
813: WHEN FND_API.G_EXC_ERROR THEN
814: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
815: (
816: l_api_name,
817: G_PKG_NAME,
818: 'FND_API.G_RET_STS_ERROR',
821: '_Pvt'
822: );
823: APP_EXCEPTION.RAISE_EXCEPTION;
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
826: (
827: l_api_name,
828: G_PKG_NAME,
829: 'FND_API.G_RET_STS_UNEXP_ERROR',
831: x_msg_data,
832: '_Pvt'
833: );
834: APP_EXCEPTION.RAISE_EXCEPTION;
835: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
836: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,
832: '_Pvt'
833: );
834: APP_EXCEPTION.RAISE_EXCEPTION;
835: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
836: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,
840: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
836: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
837: (
838: l_api_name,
839: G_PKG_NAME,
840: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
841: x_msg_count,
842: x_msg_data,
843: '_Pvt'
844: );
846: END update_row;
847: Procedure update_row
848: (
849: p_api_version IN NUMBER,
850: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
851: p_validation_level IN NUMBER,
852: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
853: x_return_status OUT VARCHAR2,
854: x_msg_count OUT NUMBER,
848: (
849: p_api_version IN NUMBER,
850: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
851: p_validation_level IN NUMBER,
852: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
853: x_return_status OUT VARCHAR2,
854: x_msg_count OUT NUMBER,
855: x_msg_data OUT VARCHAR2,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
852: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
853: x_return_status OUT VARCHAR2,
854: x_msg_count OUT NUMBER,
855: x_msg_data OUT VARCHAR2,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
853: x_return_status OUT VARCHAR2,
854: x_msg_count OUT NUMBER,
855: x_msg_data OUT VARCHAR2,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
854: x_msg_count OUT NUMBER,
855: x_msg_data OUT VARCHAR2,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
855: x_msg_data OUT VARCHAR2,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
856: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
862: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
864: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
865: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
887: l_api_version CONSTANT NUMBER := 1;
880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
887: l_api_version CONSTANT NUMBER := 1;
888: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
887: l_api_version CONSTANT NUMBER := 1;
888: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
889: l_timezone_rec TimeZone_Val_Rec_Type;
890: BEGIN
891: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
892: G_PKG_NAME,
893: l_api_version,
894: p_api_version,
895: p_init_msg_list,
939: x_msg_data,
940: l_timezone_rec,
941: x_object_version_number
942: );
943: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
947: (
942: );
943: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
947: (
948: l_api_name,
949: G_PKG_NAME,
950: 'FND_API.G_RET_STS_ERROR',
953: '_Pvt'
954: );
955: APP_EXCEPTION.RAISE_EXCEPTION;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,
961: 'FND_API.G_RET_STS_UNEXP_ERROR',
963: x_msg_data,
964: '_Pvt'
965: );
966: APP_EXCEPTION.RAISE_EXCEPTION;
967: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
968: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
969: (
970: l_api_name,
971: G_PKG_NAME,
964: '_Pvt'
965: );
966: APP_EXCEPTION.RAISE_EXCEPTION;
967: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
968: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
969: (
970: l_api_name,
971: G_PKG_NAME,
972: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
968: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
969: (
970: l_api_name,
971: G_PKG_NAME,
972: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
973: x_msg_count,
974: x_msg_data,
975: '_Pvt'
976: );
978: END update_row;
979: Procedure delete_row
980: (
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
983: p_validation_level IN NUMBER,
984: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
985: x_return_status OUT VARCHAR2,
986: x_msg_count OUT NUMBER,
980: (
981: p_api_version IN NUMBER,
982: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
983: p_validation_level IN NUMBER,
984: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
985: x_return_status OUT VARCHAR2,
986: x_msg_count OUT NUMBER,
987: x_msg_data OUT VARCHAR2,
988: p_time_zone_id IN NUMBER) IS
989: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
990: l_api_version CONSTANT NUMBER := 1;
991: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
992: BEGIN
993: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
994: G_PKG_NAME,
995: l_api_version,
996: p_api_version,
997: p_init_msg_list,
1005: DELETE FROM CS_TIME_ZONES
1006: WHERE
1007: TIME_ZONE_ID = p_time_zone_id
1008: ;
1009: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1013: (
1008: ;
1009: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1013: (
1014: l_api_name,
1015: G_PKG_NAME,
1016: 'FND_API.G_RET_STS_ERROR',
1019: '_Pvt'
1020: );
1021: APP_EXCEPTION.RAISE_EXCEPTION;
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,
1027: 'FND_API.G_RET_STS_UNEXP_ERROR',
1029: x_msg_data,
1030: '_Pvt'
1031: );
1032: APP_EXCEPTION.RAISE_EXCEPTION;
1033: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1034: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1035: (
1036: l_api_name,
1037: G_PKG_NAME,
1030: '_Pvt'
1031: );
1032: APP_EXCEPTION.RAISE_EXCEPTION;
1033: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1034: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1035: (
1036: l_api_name,
1037: G_PKG_NAME,
1038: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1034: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1035: (
1036: l_api_name,
1037: G_PKG_NAME,
1038: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1039: x_msg_count,
1040: x_msg_data,
1041: '_Pvt'
1042: );
1044: END delete_row;
1045: PROCEDURE validate_row
1046: (
1047: p_api_version IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1049: p_validation_level IN NUMBER,
1050: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1051: x_return_status OUT VARCHAR2,
1052: x_msg_count OUT NUMBER,
1046: (
1047: p_api_version IN NUMBER,
1048: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1049: p_validation_level IN NUMBER,
1050: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1051: x_return_status OUT VARCHAR2,
1052: x_msg_count OUT NUMBER,
1053: x_msg_data OUT VARCHAR2,
1054: p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC) IS
1057: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1058: l_timezone_rec TimeZone_Rec_Type;
1059: l_def_timezone_rec TimeZone_Rec_Type;
1060: BEGIN
1061: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1062: G_PKG_NAME,
1063: l_api_version,
1064: p_api_version,
1065: p_init_msg_list,
1091: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1099: (
1094: END IF;
1095: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1099: (
1100: l_api_name,
1101: G_PKG_NAME,
1102: 'FND_API.G_RET_STS_ERROR',
1105: '_Pvt'
1106: );
1107: APP_EXCEPTION.RAISE_EXCEPTION;
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1110: (
1111: l_api_name,
1112: G_PKG_NAME,
1113: 'FND_API.G_RET_STS_UNEXP_ERROR',
1115: x_msg_data,
1116: '_Pvt'
1117: );
1118: APP_EXCEPTION.RAISE_EXCEPTION;
1119: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1120: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,
1116: '_Pvt'
1117: );
1118: APP_EXCEPTION.RAISE_EXCEPTION;
1119: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1120: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,
1124: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1120: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1121: (
1122: l_api_name,
1123: G_PKG_NAME,
1124: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1125: x_msg_count,
1126: x_msg_data,
1127: '_Pvt'
1128: );
1130: END validate_row;
1131: PROCEDURE validate_row
1132: (
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1135: p_validation_level IN NUMBER,
1136: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1137: x_return_status OUT VARCHAR2,
1138: x_msg_count OUT NUMBER,
1132: (
1133: p_api_version IN NUMBER,
1134: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1135: p_validation_level IN NUMBER,
1136: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1137: x_return_status OUT VARCHAR2,
1138: x_msg_count OUT NUMBER,
1139: x_msg_data OUT VARCHAR2,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1136: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1137: x_return_status OUT VARCHAR2,
1138: x_msg_count OUT NUMBER,
1139: x_msg_data OUT VARCHAR2,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1137: x_return_status OUT VARCHAR2,
1138: x_msg_count OUT NUMBER,
1139: x_msg_data OUT VARCHAR2,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1138: x_msg_count OUT NUMBER,
1139: x_msg_data OUT VARCHAR2,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1139: x_msg_data OUT VARCHAR2,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1140: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1170: l_api_version CONSTANT NUMBER := 1;
1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1170: l_api_version CONSTANT NUMBER := 1;
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1170: l_api_version CONSTANT NUMBER := 1;
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1172: l_timezone_rec TimeZone_Val_Rec_Type;
1170: l_api_version CONSTANT NUMBER := 1;
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1172: l_timezone_rec TimeZone_Val_Rec_Type;
1173: BEGIN
1174: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1175: G_PKG_NAME,
1176: l_api_version,
1177: p_api_version,
1178: p_init_msg_list,
1221: x_msg_count,
1222: x_msg_data,
1223: l_timezone_rec
1224: );
1225: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1229: (
1224: );
1225: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1229: (
1230: l_api_name,
1231: G_PKG_NAME,
1232: 'FND_API.G_RET_STS_ERROR',
1235: '_Pvt'
1236: );
1237: APP_EXCEPTION.RAISE_EXCEPTION;
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1241: l_api_name,
1242: G_PKG_NAME,
1243: 'FND_API.G_RET_STS_UNEXP_ERROR',
1245: x_msg_data,
1246: '_Pvt'
1247: );
1248: APP_EXCEPTION.RAISE_EXCEPTION;
1249: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1250: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1246: '_Pvt'
1247: );
1248: APP_EXCEPTION.RAISE_EXCEPTION;
1249: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1250: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1250: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1255: x_msg_count,
1256: x_msg_data,
1257: '_Pvt'
1258: );