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_CONTRACTLTMPL_PVT dependencies on CS_CONTRACT_LINE_TPLTS_S

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

1: PACKAGE BODY CS_CONTRACTLTMPL_PVT AS
2: /* $Header: csctcltb.pls 115.1 99/07/16 08:50:05 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_LINE_TPLTS_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 405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,

401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,

Line 961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,