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_CONTRACTTMPL_PVT dependencies on CS_CONTRACT_TEMPLATES_S

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

1: PACKAGE BODY CS_CONTRACTTMPL_PVT AS
2: /* $Header: csctcteb.pls 115.1 99/07/16 08:51:38 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_TEMPLATES_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 499: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := NULL,

495: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := NULL,
496: p_created_by IN NUMBER := NULL,
497: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := NULL,
498: p_last_update_login IN NUMBER := NULL,
499: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := NULL,
500: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := NULL,
501: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := NULL,
502: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := NULL,
503: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := NULL,

Line 1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1156: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1478: p_creation_date IN CS_CONTRACT_TEMPLATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1479: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1480: p_auto_renewal_flag IN CS_CONTRACT_TEMPLATES.AUTO_RENEWAL_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1481: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_start_date_active IN CS_CONTRACT_TEMPLATES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_end_date_active IN CS_CONTRACT_TEMPLATES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_attribute1 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1485: p_attribute2 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1486: p_attribute3 IN CS_CONTRACT_TEMPLATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,