eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TIMEZONE_PVT dependencies on CS_TIME_ZONES

Line 5: SELECT CS_TIME_ZONES_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_TIMEZONE_PVT AS
2: /* $Header: cscttzob.pls 115.1 99/07/16 08:55:09 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_TIME_ZONES_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 221: INSERT INTO CS_TIME_ZONES(

217: END IF;
218: END IF;
219: -- Set primary key value
220: l_def_timezone_rec.time_zone_id := get_seq_id;
221: INSERT INTO CS_TIME_ZONES(
222: time_zone_id,
223: name,
224: description,
225: offset_indicator,

Line 329: p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,

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,
330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,

Line 330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,

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,
330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
334: p_last_updated_by IN NUMBER := NULL,

Line 331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,

327: x_msg_count OUT NUMBER,
328: x_msg_data OUT VARCHAR2,
329: p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,
330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
334: p_last_updated_by IN NUMBER := NULL,
335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,

Line 332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,

328: x_msg_data OUT VARCHAR2,
329: p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,
330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
334: p_last_updated_by IN NUMBER := NULL,
335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
336: p_created_by IN NUMBER := NULL,

Line 333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,

329: p_name IN CS_TIME_ZONES.NAME%TYPE := NULL,
330: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := NULL,
331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
334: p_last_updated_by IN NUMBER := NULL,
335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
336: p_created_by IN NUMBER := NULL,
337: p_last_update_login IN NUMBER := NULL,

Line 335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,

331: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := NULL,
332: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%TYPE := NULL,
333: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := NULL,
334: p_last_updated_by IN NUMBER := NULL,
335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
336: p_created_by IN NUMBER := NULL,
337: p_last_update_login IN NUMBER := NULL,
338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,

Line 338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,

334: p_last_updated_by IN NUMBER := NULL,
335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
336: p_created_by IN NUMBER := NULL,
337: p_last_update_login IN NUMBER := NULL,
338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,

Line 339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,

335: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%TYPE := NULL,
336: p_created_by IN NUMBER := NULL,
337: p_last_update_login IN NUMBER := NULL,
338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,

Line 340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,

336: p_created_by IN NUMBER := NULL,
337: p_last_update_login IN NUMBER := NULL,
338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,

Line 341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,

337: p_last_update_login IN NUMBER := NULL,
338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,

Line 342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,

338: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%TYPE := NULL,
339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,

Line 343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,

339: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := NULL,
340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,

Line 344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,

340: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%TYPE := NULL,
341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,

Line 345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,

341: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%TYPE := NULL,
342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,

Line 346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,

342: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := NULL,
343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,

Line 347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,

343: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%TYPE := NULL,
344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,

Line 348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,

344: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%TYPE := NULL,
345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,

Line 349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,

345: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%TYPE := NULL,
346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,

Line 350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,

346: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%TYPE := NULL,
347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,

Line 351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,

347: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%TYPE := NULL,
348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,

Line 352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,

348: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%TYPE := NULL,
349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,
356: p_object_version_number IN NUMBER := NULL,

Line 353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,

349: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%TYPE := NULL,
350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,
356: p_object_version_number IN NUMBER := NULL,
357: x_time_zone_id OUT NUMBER,

Line 354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,

350: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%TYPE := NULL,
351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,
356: p_object_version_number IN NUMBER := NULL,
357: x_time_zone_id OUT NUMBER,
358: x_object_version_number OUT NUMBER) IS

Line 355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,

351: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%TYPE := NULL,
352: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%TYPE := NULL,
353: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%TYPE := NULL,
354: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%TYPE := NULL,
355: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := NULL,
356: p_object_version_number IN NUMBER := NULL,
357: x_time_zone_id OUT NUMBER,
358: x_object_version_number OUT NUMBER) IS
359: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 467: FROM CS_TIME_ZONES

463: E_Resource_Busy EXCEPTION;
464: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
465: CURSOR lock_csr IS
466: SELECT OBJECT_VERSION_NUMBER
467: FROM CS_TIME_ZONES
468: WHERE
469: TIME_ZONE_ID = p_time_zone_id AND
470: OBJECT_VERSION_NUMBER = p_object_version_number
471: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 475: FROM CS_TIME_ZONES

471: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
472:
473: CURSOR lchk_csr IS
474: SELECT OBJECT_VERSION_NUMBER
475: FROM CS_TIME_ZONES
476: WHERE
477: TIME_ZONE_ID = p_time_zone_id
478: ;
479: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 482: l_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;

478: ;
479: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
480: l_api_version CONSTANT NUMBER := 1;
481: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
482: l_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;
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

Line 483: lc_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;

479: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
480: l_api_version CONSTANT NUMBER := 1;
481: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
482: l_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;
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,

Line 588: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS

584: FUNCTION populate_new_record (
585: p_timezone_rec IN TimeZone_Rec_Type,
586: x_timezone_rec OUT TimeZone_Rec_Type
587: ) RETURN VARCHAR2 IS
588: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
589: SELECT *
590: FROM Cs_Time_Zones
591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;

Line 590: FROM Cs_Time_Zones

586: x_timezone_rec OUT TimeZone_Rec_Type
587: ) RETURN VARCHAR2 IS
588: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
589: SELECT *
590: FROM Cs_Time_Zones
591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
593: l_row_notfound BOOLEAN := TRUE;
594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;

587: ) RETURN VARCHAR2 IS
588: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
589: SELECT *
590: FROM Cs_Time_Zones
591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
593: l_row_notfound BOOLEAN := TRUE;
594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
595: BEGIN

Line 592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;

588: CURSOR cs_time_zones_pk_csr (p_time_zone_id IN NUMBER) IS
589: SELECT *
590: FROM Cs_Time_Zones
591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
593: l_row_notfound BOOLEAN := TRUE;
594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
595: BEGIN
596: x_timezone_rec := p_timezone_rec;

Line 598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);

594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
595: BEGIN
596: x_timezone_rec := p_timezone_rec;
597: -- Get current database values
598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);
599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
601: CLOSE cs_time_zones_pk_csr;
602: IF (l_row_notfound) THEN

Line 599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;

595: BEGIN
596: x_timezone_rec := p_timezone_rec;
597: -- Get current database values
598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);
599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
601: CLOSE cs_time_zones_pk_csr;
602: IF (l_row_notfound) THEN
603: l_return_status := FND_API.G_RET_STS_ERROR;

Line 600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;

596: x_timezone_rec := p_timezone_rec;
597: -- Get current database values
598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);
599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
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;

Line 601: CLOSE cs_time_zones_pk_csr;

597: -- Get current database values
598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);
599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
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)

Line 607: x_timezone_rec.time_zone_id := l_cs_time_zones_pk.time_zone_id;

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)
610: THEN
611: x_timezone_rec.name := l_cs_time_zones_pk.name;

Line 611: x_timezone_rec.name := l_cs_time_zones_pk.name;

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)
614: THEN
615: x_timezone_rec.description := l_cs_time_zones_pk.description;

Line 615: x_timezone_rec.description := l_cs_time_zones_pk.description;

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)
618: THEN
619: x_timezone_rec.offset_indicator := l_cs_time_zones_pk.offset_indicator;

Line 619: x_timezone_rec.offset_indicator := l_cs_time_zones_pk.offset_indicator;

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)
622: THEN
623: x_timezone_rec.offset_time := l_cs_time_zones_pk.offset_time;

Line 623: x_timezone_rec.offset_time := l_cs_time_zones_pk.offset_time;

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)
626: THEN
627: x_timezone_rec.last_update_date := l_cs_time_zones_pk.last_update_date;

Line 627: x_timezone_rec.last_update_date := l_cs_time_zones_pk.last_update_date;

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)
630: THEN
631: x_timezone_rec.last_updated_by := l_cs_time_zones_pk.last_updated_by;

Line 631: x_timezone_rec.last_updated_by := l_cs_time_zones_pk.last_updated_by;

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)
634: THEN
635: x_timezone_rec.creation_date := l_cs_time_zones_pk.creation_date;

Line 635: x_timezone_rec.creation_date := l_cs_time_zones_pk.creation_date;

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)
638: THEN
639: x_timezone_rec.created_by := l_cs_time_zones_pk.created_by;

Line 639: x_timezone_rec.created_by := l_cs_time_zones_pk.created_by;

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)
642: THEN
643: x_timezone_rec.last_update_login := l_cs_time_zones_pk.last_update_login;

Line 643: x_timezone_rec.last_update_login := l_cs_time_zones_pk.last_update_login;

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)
646: THEN
647: x_timezone_rec.start_date_active := l_cs_time_zones_pk.start_date_active;

Line 647: x_timezone_rec.start_date_active := l_cs_time_zones_pk.start_date_active;

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)
650: THEN
651: x_timezone_rec.end_date_active := l_cs_time_zones_pk.end_date_active;

Line 651: x_timezone_rec.end_date_active := l_cs_time_zones_pk.end_date_active;

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)
654: THEN
655: x_timezone_rec.attribute1 := l_cs_time_zones_pk.attribute1;

Line 655: x_timezone_rec.attribute1 := l_cs_time_zones_pk.attribute1;

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)
658: THEN
659: x_timezone_rec.attribute2 := l_cs_time_zones_pk.attribute2;

Line 659: x_timezone_rec.attribute2 := l_cs_time_zones_pk.attribute2;

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)
662: THEN
663: x_timezone_rec.attribute3 := l_cs_time_zones_pk.attribute3;

Line 663: x_timezone_rec.attribute3 := l_cs_time_zones_pk.attribute3;

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)
666: THEN
667: x_timezone_rec.attribute4 := l_cs_time_zones_pk.attribute4;

Line 667: x_timezone_rec.attribute4 := l_cs_time_zones_pk.attribute4;

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)
670: THEN
671: x_timezone_rec.attribute5 := l_cs_time_zones_pk.attribute5;

Line 671: x_timezone_rec.attribute5 := l_cs_time_zones_pk.attribute5;

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)
674: THEN
675: x_timezone_rec.attribute6 := l_cs_time_zones_pk.attribute6;

Line 675: x_timezone_rec.attribute6 := l_cs_time_zones_pk.attribute6;

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)
678: THEN
679: x_timezone_rec.attribute7 := l_cs_time_zones_pk.attribute7;

Line 679: x_timezone_rec.attribute7 := l_cs_time_zones_pk.attribute7;

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)
682: THEN
683: x_timezone_rec.attribute8 := l_cs_time_zones_pk.attribute8;

Line 683: x_timezone_rec.attribute8 := l_cs_time_zones_pk.attribute8;

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)
686: THEN
687: x_timezone_rec.attribute9 := l_cs_time_zones_pk.attribute9;

Line 687: x_timezone_rec.attribute9 := l_cs_time_zones_pk.attribute9;

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)
690: THEN
691: x_timezone_rec.attribute10 := l_cs_time_zones_pk.attribute10;

Line 691: x_timezone_rec.attribute10 := l_cs_time_zones_pk.attribute10;

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)
694: THEN
695: x_timezone_rec.attribute11 := l_cs_time_zones_pk.attribute11;

Line 695: x_timezone_rec.attribute11 := l_cs_time_zones_pk.attribute11;

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)
698: THEN
699: x_timezone_rec.attribute12 := l_cs_time_zones_pk.attribute12;

Line 699: x_timezone_rec.attribute12 := l_cs_time_zones_pk.attribute12;

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)
702: THEN
703: x_timezone_rec.attribute13 := l_cs_time_zones_pk.attribute13;

Line 703: x_timezone_rec.attribute13 := l_cs_time_zones_pk.attribute13;

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)
706: THEN
707: x_timezone_rec.attribute14 := l_cs_time_zones_pk.attribute14;

Line 707: x_timezone_rec.attribute14 := l_cs_time_zones_pk.attribute14;

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)
710: THEN
711: x_timezone_rec.attribute15 := l_cs_time_zones_pk.attribute15;

Line 711: x_timezone_rec.attribute15 := l_cs_time_zones_pk.attribute15;

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)
714: THEN
715: x_timezone_rec.context := l_cs_time_zones_pk.context;

Line 715: x_timezone_rec.context := l_cs_time_zones_pk.context;

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)
718: THEN
719: x_timezone_rec.object_version_number := l_cs_time_zones_pk.object_version_number;

Line 719: x_timezone_rec.object_version_number := l_cs_time_zones_pk.object_version_number;

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);
722: END populate_new_record;
723: BEGIN

Line 776: UPDATE CS_TIME_ZONES

772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;
776: UPDATE CS_TIME_ZONES
777: SET
778: TIME_ZONE_ID = l_def_timezone_rec.time_zone_id ,
779: NAME = l_def_timezone_rec.name ,
780: DESCRIPTION = l_def_timezone_rec.description ,

Line 857: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 858: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 859: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 860: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%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,

Line 861: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,

Line 863: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%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,

Line 866: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%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,
870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 867: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,

Line 868: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%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,

Line 869: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%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,

Line 870: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%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,

Line 871: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%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,

Line 872: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%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,

Line 873: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%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,

Line 874: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%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,

Line 875: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%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,

Line 876: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%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,

Line 877: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%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,

Line 878: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%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,

Line 879: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%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,

Line 880: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%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,

Line 881: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%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,
885: x_object_version_number OUT NUMBER) IS

Line 882: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%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
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 883: p_context IN CS_TIME_ZONES.CONTEXT%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';
887: l_api_version CONSTANT NUMBER := 1;

Line 1005: DELETE FROM CS_TIME_ZONES

1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
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);

Line 1141: p_name IN CS_TIME_ZONES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 1142: p_description IN CS_TIME_ZONES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 1143: p_offset_indicator IN CS_TIME_ZONES.OFFSET_INDICATOR%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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,

Line 1144: p_offset_time IN CS_TIME_ZONES.OFFSET_TIME%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,

Line 1145: p_last_update_date IN CS_TIME_ZONES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,

Line 1147: p_creation_date IN CS_TIME_ZONES.CREATION_DATE%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,

Line 1150: p_start_date_active IN CS_TIME_ZONES.START_DATE_ACTIVE%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,
1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1151: p_end_date_active IN CS_TIME_ZONES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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,

Line 1152: p_attribute1 IN CS_TIME_ZONES.ATTRIBUTE1%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,

Line 1153: p_attribute2 IN CS_TIME_ZONES.ATTRIBUTE2%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,

Line 1154: p_attribute3 IN CS_TIME_ZONES.ATTRIBUTE3%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,

Line 1155: p_attribute4 IN CS_TIME_ZONES.ATTRIBUTE4%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,

Line 1156: p_attribute5 IN CS_TIME_ZONES.ATTRIBUTE5%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,

Line 1157: p_attribute6 IN CS_TIME_ZONES.ATTRIBUTE6%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,

Line 1158: p_attribute7 IN CS_TIME_ZONES.ATTRIBUTE7%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,

Line 1159: p_attribute8 IN CS_TIME_ZONES.ATTRIBUTE8%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,

Line 1160: p_attribute9 IN CS_TIME_ZONES.ATTRIBUTE9%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,

Line 1161: p_attribute10 IN CS_TIME_ZONES.ATTRIBUTE10%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,

Line 1162: p_attribute11 IN CS_TIME_ZONES.ATTRIBUTE11%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,

Line 1163: p_attribute12 IN CS_TIME_ZONES.ATTRIBUTE12%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,

Line 1164: p_attribute13 IN CS_TIME_ZONES.ATTRIBUTE13%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

Line 1165: p_attribute14 IN CS_TIME_ZONES.ATTRIBUTE14%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
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1166: p_attribute15 IN CS_TIME_ZONES.ATTRIBUTE15%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';
1170: l_api_version CONSTANT NUMBER := 1;

Line 1167: p_context IN CS_TIME_ZONES.CONTEXT%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;
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;