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_BILLRATE_PVT dependencies on CS_COV_BILL_RATES

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

1: PACKAGE BODY CS_BILLRATE_PVT AS
2: /* $Header: csctcbrb.pls 115.1 99/07/16 08:49:23 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COV_BILL_RATES_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 250: INSERT INTO CS_COV_BILL_RATES(

246: END IF;
247: END IF;
248: -- Set primary key value
249: l_def_billrate_rec.coverage_bill_rate_id := get_seq_id;
250: INSERT INTO CS_COV_BILL_RATES(
251: coverage_bill_rate_id,
252: coverage_billing_type_id,
253: rate_type_code,
254: unit_of_measure_code,

Line 357: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,

353: x_return_status OUT VARCHAR2,
354: x_msg_count OUT NUMBER,
355: x_msg_data OUT VARCHAR2,
356: p_coverage_billing_type_id IN NUMBER := NULL,
357: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
358: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
359: p_flat_rate IN NUMBER := NULL,
360: p_percent_rate IN NUMBER := NULL,
361: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,

Line 358: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,

354: x_msg_count OUT NUMBER,
355: x_msg_data OUT VARCHAR2,
356: p_coverage_billing_type_id IN NUMBER := NULL,
357: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
358: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
359: p_flat_rate IN NUMBER := NULL,
360: p_percent_rate IN NUMBER := NULL,
361: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
362: p_last_updated_by IN NUMBER := NULL,

Line 361: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,

357: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := NULL,
358: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := NULL,
359: p_flat_rate IN NUMBER := NULL,
360: p_percent_rate IN NUMBER := NULL,
361: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
362: p_last_updated_by IN NUMBER := NULL,
363: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
364: p_created_by IN NUMBER := NULL,
365: p_last_update_login IN NUMBER := NULL,

Line 363: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,

359: p_flat_rate IN NUMBER := NULL,
360: p_percent_rate IN NUMBER := NULL,
361: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := NULL,
362: p_last_updated_by IN NUMBER := NULL,
363: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
364: p_created_by IN NUMBER := NULL,
365: p_last_update_login IN NUMBER := NULL,
366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,

Line 366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,

362: p_last_updated_by IN NUMBER := NULL,
363: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
364: p_created_by IN NUMBER := NULL,
365: p_last_update_login IN NUMBER := NULL,
366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,

Line 367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,

363: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := NULL,
364: p_created_by IN NUMBER := NULL,
365: p_last_update_login IN NUMBER := NULL,
366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,

Line 368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,

364: p_created_by IN NUMBER := NULL,
365: p_last_update_login IN NUMBER := NULL,
366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,

Line 369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,

365: p_last_update_login IN NUMBER := NULL,
366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,

Line 370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,

366: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := NULL,
367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,

Line 371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,

367: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := NULL,
368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,

Line 372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,

368: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := NULL,
369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,

Line 373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,

369: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := NULL,
370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,

Line 374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,

370: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := NULL,
371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,

Line 375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,

371: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := NULL,
372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,

Line 376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,

372: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := NULL,
373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,

Line 377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,

373: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := NULL,
374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,

Line 378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,

374: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := NULL,
375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
382: p_object_version_number IN NUMBER := NULL,

Line 379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,

375: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := NULL,
376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
382: p_object_version_number IN NUMBER := NULL,
383: x_coverage_bill_rate_id OUT NUMBER,

Line 380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,

376: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := NULL,
377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
382: p_object_version_number IN NUMBER := NULL,
383: x_coverage_bill_rate_id OUT NUMBER,
384: x_object_version_number OUT NUMBER) IS

Line 381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,

377: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := NULL,
378: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := NULL,
379: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := NULL,
380: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := NULL,
381: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := NULL,
382: p_object_version_number IN NUMBER := NULL,
383: x_coverage_bill_rate_id OUT NUMBER,
384: x_object_version_number OUT NUMBER) IS
385: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 492: FROM CS_COV_BILL_RATES

488: E_Resource_Busy EXCEPTION;
489: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
490: CURSOR lock_csr IS
491: SELECT OBJECT_VERSION_NUMBER
492: FROM CS_COV_BILL_RATES
493: WHERE
494: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id AND
495: OBJECT_VERSION_NUMBER = p_object_version_number
496: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 500: FROM CS_COV_BILL_RATES

496: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
497:
498: CURSOR lchk_csr IS
499: SELECT OBJECT_VERSION_NUMBER
500: FROM CS_COV_BILL_RATES
501: WHERE
502: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
503: ;
504: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 507: l_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;

503: ;
504: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
505: l_api_version CONSTANT NUMBER := 1;
506: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
507: l_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
508: lc_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
509: l_row_notfound BOOLEAN := FALSE;
510: lc_row_notfound BOOLEAN := FALSE;
511: BEGIN

Line 508: lc_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;

504: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
505: l_api_version CONSTANT NUMBER := 1;
506: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
507: l_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
508: lc_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
509: l_row_notfound BOOLEAN := FALSE;
510: lc_row_notfound BOOLEAN := FALSE;
511: BEGIN
512: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 615: FROM Cs_Cov_Bill_Rates

611: x_billrate_rec OUT BillRate_Rec_Type
612: ) RETURN VARCHAR2 IS
613: CURSOR cs_coverage_bill_rates_pk_csr (p_coverage_bill_rate_id IN NUMBER) IS
614: SELECT *
615: FROM Cs_Cov_Bill_Rates
616: WHERE cs_cov_bill_rates.coverage_bill_rate_id = p_coverage_bill_rate_id;
617: l_cs_coverage_bill_rates_pk cs_coverage_bill_rates_pk_csr%ROWTYPE;
618: l_row_notfound BOOLEAN := TRUE;
619: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 616: WHERE cs_cov_bill_rates.coverage_bill_rate_id = p_coverage_bill_rate_id;

612: ) RETURN VARCHAR2 IS
613: CURSOR cs_coverage_bill_rates_pk_csr (p_coverage_bill_rate_id IN NUMBER) IS
614: SELECT *
615: FROM Cs_Cov_Bill_Rates
616: WHERE cs_cov_bill_rates.coverage_bill_rate_id = p_coverage_bill_rate_id;
617: l_cs_coverage_bill_rates_pk cs_coverage_bill_rates_pk_csr%ROWTYPE;
618: l_row_notfound BOOLEAN := TRUE;
619: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
620: BEGIN

Line 797: UPDATE CS_COV_BILL_RATES

793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;
797: UPDATE CS_COV_BILL_RATES
798: SET
799: COVERAGE_BILL_RATE_ID = l_def_billrate_rec.coverage_bill_rate_id ,
800: COVERAGE_BILLING_TYPE_ID = l_def_billrate_rec.coverage_billing_type_id ,
801: RATE_TYPE_CODE = l_def_billrate_rec.rate_type_code ,

Line 878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

874: x_msg_count OUT NUMBER,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS

Line 901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
906: l_api_version CONSTANT NUMBER := 1;

Line 1023: DELETE FROM CS_COV_BILL_RATES

1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: DELETE FROM CS_COV_BILL_RATES
1024: WHERE
1025: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
1026: ;
1027: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1156: x_msg_count OUT NUMBER,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;

Line 1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;