DBA Data[Home] [Help]

APPS.CS_CONTRACTTYPE_PVT dependencies on CS_CONTRACT_TYPES_S

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

1: PACKAGE BODY CS_CONTRACTTYPE_PVT AS
2: /* $Header: csctctyb.pls 115.1 99/07/16 08:51:48 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_TYPES_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 359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,

355: p_last_updated_by IN NUMBER := NULL,
356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,

Line 880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,