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_COVERAGELEVEL_PVT dependencies on CS_CONTRACT_COV_LEVELS

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

1: PACKAGE BODY CS_COVERAGELEVEL_PVT AS
2: /* $Header: csctcleb.pls 115.1 99/07/16 08:49:53 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_COV_LEVELS_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 251: INSERT INTO CS_CONTRACT_COV_LEVELS(

247: END IF;
248: END IF;
249: -- Set primary key value
250: l_def_coveragelevel_rec.coverage_level_id := get_seq_id;
251: INSERT INTO CS_CONTRACT_COV_LEVELS(
252: coverage_level_id,
253: coverage_level_code,
254: coverage_level_value,
255: last_update_date,

Line 353: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,

349: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
350: x_return_status OUT VARCHAR2,
351: x_msg_count OUT NUMBER,
352: x_msg_data OUT VARCHAR2,
353: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
354: p_coverage_level_value IN NUMBER := NULL,
355: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,
356: p_last_updated_by IN NUMBER := NULL,
357: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,

Line 355: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,

351: x_msg_count OUT NUMBER,
352: x_msg_data OUT VARCHAR2,
353: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
354: p_coverage_level_value IN NUMBER := NULL,
355: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,
356: p_last_updated_by IN NUMBER := NULL,
357: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,
358: p_created_by IN NUMBER := NULL,
359: p_last_update_login IN NUMBER := NULL,

Line 357: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,

353: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
354: p_coverage_level_value IN NUMBER := NULL,
355: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := NULL,
356: p_last_updated_by IN NUMBER := NULL,
357: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,
358: p_created_by IN NUMBER := NULL,
359: p_last_update_login IN NUMBER := NULL,
360: p_cp_service_id IN NUMBER := NULL,
361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,

Line 361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,

357: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := NULL,
358: p_created_by IN NUMBER := NULL,
359: p_last_update_login IN NUMBER := NULL,
360: p_cp_service_id IN NUMBER := NULL,
361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,

Line 362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,

358: p_created_by IN NUMBER := NULL,
359: p_last_update_login IN NUMBER := NULL,
360: p_cp_service_id IN NUMBER := NULL,
361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,

Line 363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,

359: p_last_update_login IN NUMBER := NULL,
360: p_cp_service_id IN NUMBER := NULL,
361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,

Line 364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,

360: p_cp_service_id IN NUMBER := NULL,
361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,

Line 365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,

361: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,

Line 366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,

362: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,

Line 367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,

363: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,

Line 368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,

364: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,

Line 369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,

365: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,

Line 370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,

366: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,

Line 371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,

367: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,

Line 372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,

368: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,

Line 373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,

369: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,

Line 374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,

370: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_coverage_level_id OUT NUMBER,

Line 375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,

371: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_coverage_level_id OUT NUMBER,
379: x_object_version_number OUT NUMBER) IS

Line 376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,

372: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_coverage_level_id OUT NUMBER,
379: x_object_version_number OUT NUMBER) IS
380: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 485: FROM CS_CONTRACT_COV_LEVELS

481: E_Resource_Busy EXCEPTION;
482: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
483: CURSOR lock_csr IS
484: SELECT OBJECT_VERSION_NUMBER
485: FROM CS_CONTRACT_COV_LEVELS
486: WHERE
487: COVERAGE_LEVEL_ID = p_coverage_level_id AND
488: OBJECT_VERSION_NUMBER = p_object_version_number
489: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 493: FROM CS_CONTRACT_COV_LEVELS

489: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
490:
491: CURSOR lchk_csr IS
492: SELECT OBJECT_VERSION_NUMBER
493: FROM CS_CONTRACT_COV_LEVELS
494: WHERE
495: COVERAGE_LEVEL_ID = p_coverage_level_id
496: ;
497: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 500: l_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;

496: ;
497: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
498: l_api_version CONSTANT NUMBER := 1;
499: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
500: l_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
501: lc_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
502: l_row_notfound BOOLEAN := FALSE;
503: lc_row_notfound BOOLEAN := FALSE;
504: BEGIN

Line 501: lc_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;

497: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
498: l_api_version CONSTANT NUMBER := 1;
499: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
500: l_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
501: lc_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
502: l_row_notfound BOOLEAN := FALSE;
503: lc_row_notfound BOOLEAN := FALSE;
504: BEGIN
505: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 608: FROM Cs_Contract_Cov_Levels

604: x_coveragelevel_rec OUT CoverageLevel_Rec_Type
605: ) RETURN VARCHAR2 IS
606: CURSOR cs_contract_coverage1_csr (p_coverage_level_id IN NUMBER) IS
607: SELECT *
608: FROM Cs_Contract_Cov_Levels
609: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;
610: l_cs_contract_coverage1 cs_contract_coverage1_csr%ROWTYPE;
611: l_row_notfound BOOLEAN := TRUE;
612: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 609: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;

605: ) RETURN VARCHAR2 IS
606: CURSOR cs_contract_coverage1_csr (p_coverage_level_id IN NUMBER) IS
607: SELECT *
608: FROM Cs_Contract_Cov_Levels
609: WHERE cs_contract_cov_levels.coverage_level_id = p_coverage_level_id;
610: l_cs_contract_coverage1 cs_contract_coverage1_csr%ROWTYPE;
611: l_row_notfound BOOLEAN := TRUE;
612: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
613: BEGIN

Line 782: UPDATE CS_CONTRACT_COV_LEVELS

778: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
779: RAISE FND_API.G_EXC_ERROR;
780: END IF;
781: END IF;
782: UPDATE CS_CONTRACT_COV_LEVELS
783: SET
784: COVERAGE_LEVEL_ID = l_def_coveragelevel_rec.coverage_level_id ,
785: COVERAGE_LEVEL_CODE = l_def_coveragelevel_rec.coverage_level_code ,
786: COVERAGE_LEVEL_VALUE = l_def_coveragelevel_rec.coverage_level_value ,

Line 860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS

Line 882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
887: l_api_version CONSTANT NUMBER := 1;

Line 1002: DELETE FROM CS_CONTRACT_COV_LEVELS

998: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
999: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1000: RAISE FND_API.G_EXC_ERROR;
1001: END IF;
1002: DELETE FROM CS_CONTRACT_COV_LEVELS
1003: WHERE
1004: COVERAGE_LEVEL_ID = p_coverage_level_id
1005: ;
1006: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1134: x_return_status OUT VARCHAR2,
1135: x_msg_count OUT NUMBER,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1164: l_api_version CONSTANT NUMBER := 1;

Line 1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1164: l_api_version CONSTANT NUMBER := 1;
1165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;