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_COVEREDPRD_PVT dependencies on CS_COVERED_PRODUCTS

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

1: PACKAGE BODY CS_COVEREDPRD_PVT AS
2: /* $Header: csctcprb.pls 115.1 99/07/16 08:50:50 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_COVERED_PRODUCTS_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 269: INSERT INTO CS_COVERED_PRODUCTS(

265: END IF;
266: END IF;
267: -- Set primary key value
268: l_def_coveredprd_rec.covered_product_id := get_seq_id;
269: INSERT INTO CS_COVERED_PRODUCTS(
270: customer_product_id,
271: covered_product_id,
272: contract_amount,
273: list_price,

Line 377: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := NULL,

373: p_customer_product_id IN NUMBER := NULL,
374: p_contract_amount IN NUMBER := NULL,
375: p_list_price IN NUMBER := NULL,
376: p_coverage_level_id IN NUMBER := NULL,
377: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := NULL,
378: p_last_updated_by IN NUMBER := NULL,
379: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := NULL,
380: p_created_by IN NUMBER := NULL,
381: p_last_update_login IN NUMBER := NULL,

Line 379: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := NULL,

375: p_list_price IN NUMBER := NULL,
376: p_coverage_level_id IN NUMBER := NULL,
377: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := NULL,
378: p_last_updated_by IN NUMBER := NULL,
379: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := NULL,
380: p_created_by IN NUMBER := NULL,
381: p_last_update_login IN NUMBER := NULL,
382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,

Line 382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,

378: p_last_updated_by IN NUMBER := NULL,
379: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := NULL,
380: p_created_by IN NUMBER := NULL,
381: p_last_update_login IN NUMBER := NULL,
382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,

Line 383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,

379: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := NULL,
380: p_created_by IN NUMBER := NULL,
381: p_last_update_login IN NUMBER := NULL,
382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,

Line 384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,

380: p_created_by IN NUMBER := NULL,
381: p_last_update_login IN NUMBER := NULL,
382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,

Line 385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,

381: p_last_update_login IN NUMBER := NULL,
382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,

Line 386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,

382: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := NULL,
383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,

Line 387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,

383: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := NULL,
384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,

Line 388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,

384: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := NULL,
385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,

Line 389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,

385: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := NULL,
386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,

Line 390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,

386: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := NULL,
387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,

Line 391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,

387: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := NULL,
388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,

Line 392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,

388: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := NULL,
389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,

Line 393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,

389: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := NULL,
390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,
397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,

Line 394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,

390: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := NULL,
391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,
397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,
398: p_object_version_number IN NUMBER := NULL,

Line 395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,

391: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := NULL,
392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,
397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,
398: p_object_version_number IN NUMBER := NULL,
399: x_covered_product_id OUT NUMBER,

Line 396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,

392: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := NULL,
393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,
397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,
398: p_object_version_number IN NUMBER := NULL,
399: x_covered_product_id OUT NUMBER,
400: x_object_version_number OUT NUMBER) IS

Line 397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,

393: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := NULL,
394: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := NULL,
395: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := NULL,
396: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := NULL,
397: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := NULL,
398: p_object_version_number IN NUMBER := NULL,
399: x_covered_product_id OUT NUMBER,
400: x_object_version_number OUT NUMBER) IS
401: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 507: FROM CS_COVERED_PRODUCTS

503: E_Resource_Busy EXCEPTION;
504: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
505: CURSOR lock_csr IS
506: SELECT OBJECT_VERSION_NUMBER
507: FROM CS_COVERED_PRODUCTS
508: WHERE
509: COVERED_PRODUCT_ID = p_covered_product_id AND
510: OBJECT_VERSION_NUMBER = p_object_version_number
511: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 515: FROM CS_COVERED_PRODUCTS

511: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
512:
513: CURSOR lchk_csr IS
514: SELECT OBJECT_VERSION_NUMBER
515: FROM CS_COVERED_PRODUCTS
516: WHERE
517: COVERED_PRODUCT_ID = p_covered_product_id
518: ;
519: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 522: l_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;

518: ;
519: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
520: l_api_version CONSTANT NUMBER := 1;
521: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
522: l_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;
523: lc_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;
524: l_row_notfound BOOLEAN := FALSE;
525: lc_row_notfound BOOLEAN := FALSE;
526: BEGIN

Line 523: lc_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;

519: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
520: l_api_version CONSTANT NUMBER := 1;
521: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
522: l_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;
523: lc_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;
524: l_row_notfound BOOLEAN := FALSE;
525: lc_row_notfound BOOLEAN := FALSE;
526: BEGIN
527: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 628: CURSOR cs_covered_products_pk_csr (p_covered_product_id IN NUMBER) IS

624: FUNCTION populate_new_record (
625: p_coveredprd_rec IN CoveredPrd_Rec_Type,
626: x_coveredprd_rec OUT CoveredPrd_Rec_Type
627: ) RETURN VARCHAR2 IS
628: CURSOR cs_covered_products_pk_csr (p_covered_product_id IN NUMBER) IS
629: SELECT *
630: FROM Cs_Covered_Products
631: WHERE cs_covered_products.covered_product_id = p_covered_product_id;
632: l_cs_covered_products_pk cs_covered_products_pk_csr%ROWTYPE;

Line 630: FROM Cs_Covered_Products

626: x_coveredprd_rec OUT CoveredPrd_Rec_Type
627: ) RETURN VARCHAR2 IS
628: CURSOR cs_covered_products_pk_csr (p_covered_product_id IN NUMBER) IS
629: SELECT *
630: FROM Cs_Covered_Products
631: WHERE cs_covered_products.covered_product_id = p_covered_product_id;
632: l_cs_covered_products_pk cs_covered_products_pk_csr%ROWTYPE;
633: l_row_notfound BOOLEAN := TRUE;
634: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 631: WHERE cs_covered_products.covered_product_id = p_covered_product_id;

627: ) RETURN VARCHAR2 IS
628: CURSOR cs_covered_products_pk_csr (p_covered_product_id IN NUMBER) IS
629: SELECT *
630: FROM Cs_Covered_Products
631: WHERE cs_covered_products.covered_product_id = p_covered_product_id;
632: l_cs_covered_products_pk cs_covered_products_pk_csr%ROWTYPE;
633: l_row_notfound BOOLEAN := TRUE;
634: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
635: BEGIN

Line 632: l_cs_covered_products_pk cs_covered_products_pk_csr%ROWTYPE;

628: CURSOR cs_covered_products_pk_csr (p_covered_product_id IN NUMBER) IS
629: SELECT *
630: FROM Cs_Covered_Products
631: WHERE cs_covered_products.covered_product_id = p_covered_product_id;
632: l_cs_covered_products_pk cs_covered_products_pk_csr%ROWTYPE;
633: l_row_notfound BOOLEAN := TRUE;
634: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
635: BEGIN
636: x_coveredprd_rec := p_coveredprd_rec;

Line 638: OPEN cs_covered_products_pk_csr (p_coveredprd_rec.covered_product_id);

634: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
635: BEGIN
636: x_coveredprd_rec := p_coveredprd_rec;
637: -- Get current database values
638: OPEN cs_covered_products_pk_csr (p_coveredprd_rec.covered_product_id);
639: FETCH cs_covered_products_pk_csr INTO l_cs_covered_products_pk;
640: l_row_notfound := cs_covered_products_pk_csr%NOTFOUND;
641: CLOSE cs_covered_products_pk_csr;
642: IF (l_row_notfound) THEN

Line 639: FETCH cs_covered_products_pk_csr INTO l_cs_covered_products_pk;

635: BEGIN
636: x_coveredprd_rec := p_coveredprd_rec;
637: -- Get current database values
638: OPEN cs_covered_products_pk_csr (p_coveredprd_rec.covered_product_id);
639: FETCH cs_covered_products_pk_csr INTO l_cs_covered_products_pk;
640: l_row_notfound := cs_covered_products_pk_csr%NOTFOUND;
641: CLOSE cs_covered_products_pk_csr;
642: IF (l_row_notfound) THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;

Line 640: l_row_notfound := cs_covered_products_pk_csr%NOTFOUND;

636: x_coveredprd_rec := p_coveredprd_rec;
637: -- Get current database values
638: OPEN cs_covered_products_pk_csr (p_coveredprd_rec.covered_product_id);
639: FETCH cs_covered_products_pk_csr INTO l_cs_covered_products_pk;
640: l_row_notfound := cs_covered_products_pk_csr%NOTFOUND;
641: CLOSE cs_covered_products_pk_csr;
642: IF (l_row_notfound) THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;

Line 641: CLOSE cs_covered_products_pk_csr;

637: -- Get current database values
638: OPEN cs_covered_products_pk_csr (p_coveredprd_rec.covered_product_id);
639: FETCH cs_covered_products_pk_csr INTO l_cs_covered_products_pk;
640: l_row_notfound := cs_covered_products_pk_csr%NOTFOUND;
641: CLOSE cs_covered_products_pk_csr;
642: IF (l_row_notfound) THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: IF (x_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 647: x_coveredprd_rec.customer_product_id := l_cs_covered_products_pk.customer_product_id;

643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: IF (x_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_coveredprd_rec.customer_product_id := l_cs_covered_products_pk.customer_product_id;
648: END IF;
649: IF (x_coveredprd_rec.covered_product_id = TAPI_DEV_KIT.G_MISS_NUM)
650: THEN
651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;

Line 651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;

647: x_coveredprd_rec.customer_product_id := l_cs_covered_products_pk.customer_product_id;
648: END IF;
649: IF (x_coveredprd_rec.covered_product_id = TAPI_DEV_KIT.G_MISS_NUM)
650: THEN
651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;
652: END IF;
653: IF (x_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;

Line 655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;

651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;
652: END IF;
653: IF (x_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;
656: END IF;
657: IF (x_coveredprd_rec.list_price = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;

Line 659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;

655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;
656: END IF;
657: IF (x_coveredprd_rec.list_price = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;
660: END IF;
661: IF (x_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
662: THEN
663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;

Line 663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;

659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;
660: END IF;
661: IF (x_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
662: THEN
663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;
664: END IF;
665: IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;

Line 667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;

663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;
664: END IF;
665: IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;
668: END IF;
669: IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
670: THEN
671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;

Line 671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;

667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;
668: END IF;
669: IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
670: THEN
671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;
672: END IF;
673: IF (x_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
674: THEN
675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;

Line 675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;

671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;
672: END IF;
673: IF (x_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
674: THEN
675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;
676: END IF;
677: IF (x_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
678: THEN
679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;

Line 679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;

675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;
676: END IF;
677: IF (x_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
678: THEN
679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;
680: END IF;
681: IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
682: THEN
683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;

Line 683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;

679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;
680: END IF;
681: IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
682: THEN
683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;
684: END IF;
685: IF (x_coveredprd_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;

Line 687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;

683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;
684: END IF;
685: IF (x_coveredprd_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;
688: END IF;
689: IF (x_coveredprd_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;

Line 691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;

687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;
688: END IF;
689: IF (x_coveredprd_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;
692: END IF;
693: IF (x_coveredprd_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;

Line 695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;

691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;
692: END IF;
693: IF (x_coveredprd_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;
696: END IF;
697: IF (x_coveredprd_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;

Line 699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;

695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;
696: END IF;
697: IF (x_coveredprd_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;
700: END IF;
701: IF (x_coveredprd_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;

Line 703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;

699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;
700: END IF;
701: IF (x_coveredprd_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;
704: END IF;
705: IF (x_coveredprd_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;

Line 707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;

703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;
704: END IF;
705: IF (x_coveredprd_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;
708: END IF;
709: IF (x_coveredprd_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;

Line 711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;

707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;
708: END IF;
709: IF (x_coveredprd_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;
712: END IF;
713: IF (x_coveredprd_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;

Line 715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;

711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;
712: END IF;
713: IF (x_coveredprd_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;
716: END IF;
717: IF (x_coveredprd_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;

Line 719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;

715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;
716: END IF;
717: IF (x_coveredprd_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;
720: END IF;
721: IF (x_coveredprd_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;

Line 723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;

719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;
720: END IF;
721: IF (x_coveredprd_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;
724: END IF;
725: IF (x_coveredprd_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;

Line 727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;

723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;
724: END IF;
725: IF (x_coveredprd_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;
728: END IF;
729: IF (x_coveredprd_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;

Line 731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;

727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;
728: END IF;
729: IF (x_coveredprd_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;
732: END IF;
733: IF (x_coveredprd_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
734: THEN
735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;

Line 735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;

731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;
732: END IF;
733: IF (x_coveredprd_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
734: THEN
735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;
736: END IF;
737: IF (x_coveredprd_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
738: THEN
739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;

Line 739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;

735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;
736: END IF;
737: IF (x_coveredprd_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
738: THEN
739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;
740: END IF;
741: IF (x_coveredprd_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
742: THEN
743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;

Line 743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;

739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;
740: END IF;
741: IF (x_coveredprd_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
742: THEN
743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;
744: END IF;
745: IF (x_coveredprd_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
746: THEN
747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;

Line 747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;

743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;
744: END IF;
745: IF (x_coveredprd_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
746: THEN
747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;
748: END IF;
749: IF (x_coveredprd_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
750: THEN
751: x_coveredprd_rec.object_version_number := l_cs_covered_products_pk.object_version_number;

Line 751: x_coveredprd_rec.object_version_number := l_cs_covered_products_pk.object_version_number;

747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;
748: END IF;
749: IF (x_coveredprd_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
750: THEN
751: x_coveredprd_rec.object_version_number := l_cs_covered_products_pk.object_version_number;
752: END IF;
753: RETURN(l_return_status);
754: END populate_new_record;
755: BEGIN

Line 808: UPDATE CS_COVERED_PRODUCTS

804: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
805: RAISE FND_API.G_EXC_ERROR;
806: END IF;
807: END IF;
808: UPDATE CS_COVERED_PRODUCTS
809: SET
810: CUSTOMER_PRODUCT_ID = l_def_coveredprd_rec.customer_product_id ,
811: COVERED_PRODUCT_ID = l_def_coveredprd_rec.covered_product_id ,
812: CONTRACT_AMOUNT = l_def_coveredprd_rec.contract_amount ,

Line 891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS

Line 910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
914: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
914: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
915: l_api_version CONSTANT NUMBER := 1;

Line 1031: DELETE FROM CS_COVERED_PRODUCTS

1027: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1028: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1029: RAISE FND_API.G_EXC_ERROR;
1030: END IF;
1031: DELETE FROM CS_COVERED_PRODUCTS
1032: WHERE
1033: COVERED_PRODUCT_ID = p_covered_product_id
1034: ;
1035: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1194: l_api_version CONSTANT NUMBER := 1;

Line 1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1194: l_api_version CONSTANT NUMBER := 1;
1195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;