DBA Data[Home] [Help]

APPS.CS_TIMEZONE_PVT dependencies on CS_TIME_ZONES_S

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 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 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 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,