DBA Data[Home] [Help]

APPS.CS_CONTRACTSTATS_PVT dependencies on CS_CONTRACT_STATUSES_S

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

1: PACKAGE BODY CS_CONTRACTSTATS_PVT AS
2: /* $Header: csctcstb.pls 115.1 99/07/16 08:51:26 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_STATUSES_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 363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,

359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,

Line 926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,