1: PACKAGE BODY CS_BILLINGTYPE_PVT AS
2: /* $Header: csctcbtb.pls 115.1 99/07/16 08:49:33 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COV_BILLING_TYPES_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;
260: END IF;
261: END IF;
262: -- Set primary key value
263: l_def_billingtype_rec.coverage_billing_type_id := get_seq_id;
264: INSERT INTO CS_COV_BILLING_TYPES(
265: coverage_billing_type_id,
266: max_percent_per_use,
267: max_amount_per_use,
268: txn_billing_type_id,
368: p_max_percent_per_use IN NUMBER := NULL,
369: p_max_amount_per_use IN NUMBER := NULL,
370: p_txn_billing_type_id IN NUMBER := NULL,
371: p_coverage_txn_group_id IN NUMBER := NULL,
372: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
373: p_last_updated_by IN NUMBER := NULL,
374: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
375: p_created_by IN NUMBER := NULL,
376: p_last_update_login IN NUMBER := NULL,
370: p_txn_billing_type_id IN NUMBER := NULL,
371: p_coverage_txn_group_id IN NUMBER := NULL,
372: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
373: p_last_updated_by IN NUMBER := NULL,
374: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
375: p_created_by IN NUMBER := NULL,
376: p_last_update_login IN NUMBER := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
373: p_last_updated_by IN NUMBER := NULL,
374: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
375: p_created_by IN NUMBER := NULL,
376: p_last_update_login IN NUMBER := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
374: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
375: p_created_by IN NUMBER := NULL,
376: p_last_update_login IN NUMBER := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
375: p_created_by IN NUMBER := NULL,
376: p_last_update_login IN NUMBER := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
376: p_last_update_login IN NUMBER := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
377: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
378: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
379: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
380: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
381: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
382: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
383: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
384: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
392: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
385: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
392: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
393: p_object_version_number IN NUMBER := NULL,
386: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
392: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
393: p_object_version_number IN NUMBER := NULL,
394: x_coverage_billing_type_id OUT NUMBER,
387: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
392: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
393: p_object_version_number IN NUMBER := NULL,
394: x_coverage_billing_type_id OUT NUMBER,
395: x_object_version_number OUT NUMBER) IS
388: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,
389: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,
390: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,
391: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,
392: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := NULL,
393: p_object_version_number IN NUMBER := NULL,
394: x_coverage_billing_type_id OUT NUMBER,
395: x_object_version_number OUT NUMBER) IS
396: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
498: E_Resource_Busy EXCEPTION;
499: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
500: CURSOR lock_csr IS
501: SELECT OBJECT_VERSION_NUMBER
502: FROM CS_COV_BILLING_TYPES
503: WHERE
504: COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id AND
505: OBJECT_VERSION_NUMBER = p_object_version_number
506: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
506: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
507:
508: CURSOR lchk_csr IS
509: SELECT OBJECT_VERSION_NUMBER
510: FROM CS_COV_BILLING_TYPES
511: WHERE
512: COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id
513: ;
514: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
513: ;
514: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
515: l_api_version CONSTANT NUMBER := 1;
516: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
517: l_object_version_number CS_COV_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
518: lc_object_version_number CS_COV_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
519: l_row_notfound BOOLEAN := FALSE;
520: lc_row_notfound BOOLEAN := FALSE;
521: BEGIN
514: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
515: l_api_version CONSTANT NUMBER := 1;
516: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
517: l_object_version_number CS_COV_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
518: lc_object_version_number CS_COV_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
519: l_row_notfound BOOLEAN := FALSE;
520: lc_row_notfound BOOLEAN := FALSE;
521: BEGIN
522: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
621: x_billingtype_rec OUT BillingType_Rec_Type
622: ) RETURN VARCHAR2 IS
623: CURSOR cs_coverage_billing_1_csr (p_coverage_billing_type_id IN NUMBER) IS
624: SELECT *
625: FROM Cs_Cov_Billing_Types
626: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;
627: l_cs_coverage_billing_types_pk cs_coverage_billing_1_csr%ROWTYPE;
628: l_row_notfound BOOLEAN := TRUE;
629: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
622: ) RETURN VARCHAR2 IS
623: CURSOR cs_coverage_billing_1_csr (p_coverage_billing_type_id IN NUMBER) IS
624: SELECT *
625: FROM Cs_Cov_Billing_Types
626: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;
627: l_cs_coverage_billing_types_pk cs_coverage_billing_1_csr%ROWTYPE;
628: l_row_notfound BOOLEAN := TRUE;
629: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
630: BEGIN
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;
803: UPDATE CS_COV_BILLING_TYPES
804: SET
805: COVERAGE_BILLING_TYPE_ID = l_def_billingtype_rec.coverage_billing_type_id ,
806: MAX_PERCENT_PER_USE = l_def_billingtype_rec.max_percent_per_use ,
807: MAX_AMOUNT_PER_USE = l_def_billingtype_rec.max_amount_per_use ,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
909: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
909: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
910: l_api_version CONSTANT NUMBER := 1;
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1024: RAISE FND_API.G_EXC_ERROR;
1025: END IF;
1026: DELETE FROM CS_COV_BILLING_TYPES
1027: WHERE
1028: COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id
1029: ;
1030: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1189: l_api_version CONSTANT NUMBER := 1;
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1189: l_api_version CONSTANT NUMBER := 1;
1190: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;