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_CONTRACTBILLING_PVT dependencies on CS_CONTRACTS_BILLING

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

1: PACKAGE BODY CS_CONTRACTBILLING_PVT AS
2: /* $Header: csctcbpb.pls 115.1 99/07/16 08:49:13 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACTS_BILLING_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 292: INSERT INTO CS_CONTRACTS_BILLING(

288: END IF;
289: END IF;
290: -- Set primary key value
291: l_def_contractbilling_rec.contract_billing_id := get_seq_id;
292: INSERT INTO CS_CONTRACTS_BILLING(
293: contract_billing_id,
294: header_id,
295: order_number,
296: line_id,

Line 420: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,

416: p_line_id IN NUMBER := NULL,
417: p_cp_service_id IN NUMBER := NULL,
418: p_contract_id IN NUMBER := NULL,
419: p_cust_trx_type_id IN NUMBER := NULL,
420: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
421: p_trx_number IN NUMBER := NULL,
422: p_trx_amount IN NUMBER := NULL,
423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,

Line 423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,

419: p_cust_trx_type_id IN NUMBER := NULL,
420: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
421: p_trx_number IN NUMBER := NULL,
422: p_trx_amount IN NUMBER := NULL,
423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
427: p_last_updated_by IN NUMBER := NULL,

Line 424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,

420: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := NULL,
421: p_trx_number IN NUMBER := NULL,
422: p_trx_amount IN NUMBER := NULL,
423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
427: p_last_updated_by IN NUMBER := NULL,
428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,

Line 425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,

421: p_trx_number IN NUMBER := NULL,
422: p_trx_amount IN NUMBER := NULL,
423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
427: p_last_updated_by IN NUMBER := NULL,
428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
429: p_created_by IN NUMBER := NULL,

Line 426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,

422: p_trx_amount IN NUMBER := NULL,
423: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := NULL,
424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
427: p_last_updated_by IN NUMBER := NULL,
428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
429: p_created_by IN NUMBER := NULL,
430: p_last_update_login IN NUMBER := NULL,

Line 428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,

424: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := NULL,
425: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := NULL,
426: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := NULL,
427: p_last_updated_by IN NUMBER := NULL,
428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
429: p_created_by IN NUMBER := NULL,
430: p_last_update_login IN NUMBER := NULL,
431: p_trx_pre_tax_amount IN NUMBER := NULL,
432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,

Line 432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,

428: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := NULL,
429: p_created_by IN NUMBER := NULL,
430: p_last_update_login IN NUMBER := NULL,
431: p_trx_pre_tax_amount IN NUMBER := NULL,
432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,

Line 433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,

429: p_created_by IN NUMBER := NULL,
430: p_last_update_login IN NUMBER := NULL,
431: p_trx_pre_tax_amount IN NUMBER := NULL,
432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,

Line 434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,

430: p_last_update_login IN NUMBER := NULL,
431: p_trx_pre_tax_amount IN NUMBER := NULL,
432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,

Line 435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,

431: p_trx_pre_tax_amount IN NUMBER := NULL,
432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,

Line 436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,

432: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := NULL,
433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,

Line 437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,

433: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := NULL,
434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,

Line 438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,

434: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := NULL,
435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,

Line 439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,

435: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := NULL,
436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,

Line 440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,

436: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := NULL,
437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,

Line 441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,

437: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := NULL,
438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,

Line 442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,

438: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := NULL,
439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,

Line 443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,

439: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := NULL,
440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,

Line 444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,

440: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := NULL,
441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
448: p_object_version_number IN NUMBER := NULL,

Line 445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,

441: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := NULL,
442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
448: p_object_version_number IN NUMBER := NULL,
449: x_contract_billing_id OUT NUMBER,

Line 446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,

442: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := NULL,
443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
448: p_object_version_number IN NUMBER := NULL,
449: x_contract_billing_id OUT NUMBER,
450: x_object_version_number OUT NUMBER) IS

Line 447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,

443: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := NULL,
444: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := NULL,
445: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := NULL,
446: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := NULL,
447: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := NULL,
448: p_object_version_number IN NUMBER := NULL,
449: x_contract_billing_id OUT NUMBER,
450: x_object_version_number OUT NUMBER) IS
451: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 566: FROM CS_CONTRACTS_BILLING

562: E_Resource_Busy EXCEPTION;
563: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
564: CURSOR lock_csr IS
565: SELECT OBJECT_VERSION_NUMBER
566: FROM CS_CONTRACTS_BILLING
567: WHERE
568: CONTRACT_BILLING_ID = p_contract_billing_id AND
569: OBJECT_VERSION_NUMBER = p_object_version_number
570: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 574: FROM CS_CONTRACTS_BILLING

570: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
571:
572: CURSOR lchk_csr IS
573: SELECT OBJECT_VERSION_NUMBER
574: FROM CS_CONTRACTS_BILLING
575: WHERE
576: CONTRACT_BILLING_ID = p_contract_billing_id
577: ;
578: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 581: l_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;

577: ;
578: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
579: l_api_version CONSTANT NUMBER := 1;
580: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
581: l_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;
582: lc_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;
583: l_row_notfound BOOLEAN := FALSE;
584: lc_row_notfound BOOLEAN := FALSE;
585: BEGIN

Line 582: lc_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;

578: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
579: l_api_version CONSTANT NUMBER := 1;
580: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
581: l_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;
582: lc_object_version_number CS_CONTRACTS_BILLING.OBJECT_VERSION_NUMBER%TYPE;
583: l_row_notfound BOOLEAN := FALSE;
584: lc_row_notfound BOOLEAN := FALSE;
585: BEGIN
586: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 687: CURSOR cs_contracts_billing_pk_csr (p_contract_billing_id IN NUMBER) IS

683: FUNCTION populate_new_record (
684: p_contractbilling_rec IN ContractBilling_Rec_Type,
685: x_contractbilling_rec OUT ContractBilling_Rec_Type
686: ) RETURN VARCHAR2 IS
687: CURSOR cs_contracts_billing_pk_csr (p_contract_billing_id IN NUMBER) IS
688: SELECT *
689: FROM Cs_Contracts_Billing
690: WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;
691: l_cs_contracts_billing_pk cs_contracts_billing_pk_csr%ROWTYPE;

Line 689: FROM Cs_Contracts_Billing

685: x_contractbilling_rec OUT ContractBilling_Rec_Type
686: ) RETURN VARCHAR2 IS
687: CURSOR cs_contracts_billing_pk_csr (p_contract_billing_id IN NUMBER) IS
688: SELECT *
689: FROM Cs_Contracts_Billing
690: WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;
691: l_cs_contracts_billing_pk cs_contracts_billing_pk_csr%ROWTYPE;
692: l_row_notfound BOOLEAN := TRUE;
693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 690: WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;

686: ) RETURN VARCHAR2 IS
687: CURSOR cs_contracts_billing_pk_csr (p_contract_billing_id IN NUMBER) IS
688: SELECT *
689: FROM Cs_Contracts_Billing
690: WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;
691: l_cs_contracts_billing_pk cs_contracts_billing_pk_csr%ROWTYPE;
692: l_row_notfound BOOLEAN := TRUE;
693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
694: BEGIN

Line 691: l_cs_contracts_billing_pk cs_contracts_billing_pk_csr%ROWTYPE;

687: CURSOR cs_contracts_billing_pk_csr (p_contract_billing_id IN NUMBER) IS
688: SELECT *
689: FROM Cs_Contracts_Billing
690: WHERE cs_contracts_billing.contract_billing_id = p_contract_billing_id;
691: l_cs_contracts_billing_pk cs_contracts_billing_pk_csr%ROWTYPE;
692: l_row_notfound BOOLEAN := TRUE;
693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
694: BEGIN
695: x_contractbilling_rec := p_contractbilling_rec;

Line 697: OPEN cs_contracts_billing_pk_csr (p_contractbilling_rec.contract_billing_id);

693: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
694: BEGIN
695: x_contractbilling_rec := p_contractbilling_rec;
696: -- Get current database values
697: OPEN cs_contracts_billing_pk_csr (p_contractbilling_rec.contract_billing_id);
698: FETCH cs_contracts_billing_pk_csr INTO l_cs_contracts_billing_pk;
699: l_row_notfound := cs_contracts_billing_pk_csr%NOTFOUND;
700: CLOSE cs_contracts_billing_pk_csr;
701: IF (l_row_notfound) THEN

Line 698: FETCH cs_contracts_billing_pk_csr INTO l_cs_contracts_billing_pk;

694: BEGIN
695: x_contractbilling_rec := p_contractbilling_rec;
696: -- Get current database values
697: OPEN cs_contracts_billing_pk_csr (p_contractbilling_rec.contract_billing_id);
698: FETCH cs_contracts_billing_pk_csr INTO l_cs_contracts_billing_pk;
699: l_row_notfound := cs_contracts_billing_pk_csr%NOTFOUND;
700: CLOSE cs_contracts_billing_pk_csr;
701: IF (l_row_notfound) THEN
702: l_return_status := FND_API.G_RET_STS_ERROR;

Line 699: l_row_notfound := cs_contracts_billing_pk_csr%NOTFOUND;

695: x_contractbilling_rec := p_contractbilling_rec;
696: -- Get current database values
697: OPEN cs_contracts_billing_pk_csr (p_contractbilling_rec.contract_billing_id);
698: FETCH cs_contracts_billing_pk_csr INTO l_cs_contracts_billing_pk;
699: l_row_notfound := cs_contracts_billing_pk_csr%NOTFOUND;
700: CLOSE cs_contracts_billing_pk_csr;
701: IF (l_row_notfound) THEN
702: l_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;

Line 700: CLOSE cs_contracts_billing_pk_csr;

696: -- Get current database values
697: OPEN cs_contracts_billing_pk_csr (p_contractbilling_rec.contract_billing_id);
698: FETCH cs_contracts_billing_pk_csr INTO l_cs_contracts_billing_pk;
699: l_row_notfound := cs_contracts_billing_pk_csr%NOTFOUND;
700: CLOSE cs_contracts_billing_pk_csr;
701: IF (l_row_notfound) THEN
702: l_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: IF (x_contractbilling_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 706: x_contractbilling_rec.contract_billing_id := l_cs_contracts_billing_pk.contract_billing_id;

702: l_return_status := FND_API.G_RET_STS_ERROR;
703: END IF;
704: IF (x_contractbilling_rec.contract_billing_id = TAPI_DEV_KIT.G_MISS_NUM)
705: THEN
706: x_contractbilling_rec.contract_billing_id := l_cs_contracts_billing_pk.contract_billing_id;
707: END IF;
708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)
709: THEN
710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;

Line 710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;

706: x_contractbilling_rec.contract_billing_id := l_cs_contracts_billing_pk.contract_billing_id;
707: END IF;
708: IF (x_contractbilling_rec.header_id = TAPI_DEV_KIT.G_MISS_NUM)
709: THEN
710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;
711: END IF;
712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)
713: THEN
714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;

Line 714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;

710: x_contractbilling_rec.header_id := l_cs_contracts_billing_pk.header_id;
711: END IF;
712: IF (x_contractbilling_rec.order_number = TAPI_DEV_KIT.G_MISS_NUM)
713: THEN
714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;
715: END IF;
716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;

Line 718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;

714: x_contractbilling_rec.order_number := l_cs_contracts_billing_pk.order_number;
715: END IF;
716: IF (x_contractbilling_rec.line_id = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;
719: END IF;
720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
721: THEN
722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;

Line 722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;

718: x_contractbilling_rec.line_id := l_cs_contracts_billing_pk.line_id;
719: END IF;
720: IF (x_contractbilling_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
721: THEN
722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;
723: END IF;
724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;

Line 726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;

722: x_contractbilling_rec.cp_service_id := l_cs_contracts_billing_pk.cp_service_id;
723: END IF;
724: IF (x_contractbilling_rec.contract_id = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;
727: END IF;
728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;

Line 730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;

726: x_contractbilling_rec.contract_id := l_cs_contracts_billing_pk.contract_id;
727: END IF;
728: IF (x_contractbilling_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;
731: END IF;
732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;

Line 734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;

730: x_contractbilling_rec.cust_trx_type_id := l_cs_contracts_billing_pk.cust_trx_type_id;
731: END IF;
732: IF (x_contractbilling_rec.trx_date = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;
735: END IF;
736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)
737: THEN
738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;

Line 738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;

734: x_contractbilling_rec.trx_date := l_cs_contracts_billing_pk.trx_date;
735: END IF;
736: IF (x_contractbilling_rec.trx_number = TAPI_DEV_KIT.G_MISS_NUM)
737: THEN
738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;
739: END IF;
740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
741: THEN
742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;

Line 742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;

738: x_contractbilling_rec.trx_number := l_cs_contracts_billing_pk.trx_number;
739: END IF;
740: IF (x_contractbilling_rec.trx_amount = TAPI_DEV_KIT.G_MISS_NUM)
741: THEN
742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;
743: END IF;
744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;

Line 746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;

742: x_contractbilling_rec.trx_amount := l_cs_contracts_billing_pk.trx_amount;
743: END IF;
744: IF (x_contractbilling_rec.trx_class = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;
747: END IF;
748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)
749: THEN
750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;

Line 750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;

746: x_contractbilling_rec.trx_class := l_cs_contracts_billing_pk.trx_class;
747: END IF;
748: IF (x_contractbilling_rec.billed_until_date = TAPI_DEV_KIT.G_MISS_DATE)
749: THEN
750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;
751: END IF;
752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;

Line 754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;

750: x_contractbilling_rec.billed_until_date := l_cs_contracts_billing_pk.billed_until_date;
751: END IF;
752: IF (x_contractbilling_rec.currency_code = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;
755: END IF;
756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
757: THEN
758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;

Line 758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;

754: x_contractbilling_rec.currency_code := l_cs_contracts_billing_pk.currency_code;
755: END IF;
756: IF (x_contractbilling_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
757: THEN
758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;
759: END IF;
760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
761: THEN
762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;

Line 762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;

758: x_contractbilling_rec.last_update_date := l_cs_contracts_billing_pk.last_update_date;
759: END IF;
760: IF (x_contractbilling_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
761: THEN
762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;
763: END IF;
764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
765: THEN
766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;

Line 766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;

762: x_contractbilling_rec.last_updated_by := l_cs_contracts_billing_pk.last_updated_by;
763: END IF;
764: IF (x_contractbilling_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
765: THEN
766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;
767: END IF;
768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
769: THEN
770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;

Line 770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;

766: x_contractbilling_rec.creation_date := l_cs_contracts_billing_pk.creation_date;
767: END IF;
768: IF (x_contractbilling_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
769: THEN
770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;
771: END IF;
772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
773: THEN
774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;

Line 774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;

770: x_contractbilling_rec.created_by := l_cs_contracts_billing_pk.created_by;
771: END IF;
772: IF (x_contractbilling_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
773: THEN
774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;
775: END IF;
776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)
777: THEN
778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;

Line 778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;

774: x_contractbilling_rec.last_update_login := l_cs_contracts_billing_pk.last_update_login;
775: END IF;
776: IF (x_contractbilling_rec.trx_pre_tax_amount = TAPI_DEV_KIT.G_MISS_NUM)
777: THEN
778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;
779: END IF;
780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;

Line 782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;

778: x_contractbilling_rec.trx_pre_tax_amount := l_cs_contracts_billing_pk.trx_pre_tax_amount;
779: END IF;
780: IF (x_contractbilling_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;
783: END IF;
784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;

Line 786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;

782: x_contractbilling_rec.attribute1 := l_cs_contracts_billing_pk.attribute1;
783: END IF;
784: IF (x_contractbilling_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;
787: END IF;
788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;

Line 790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;

786: x_contractbilling_rec.attribute2 := l_cs_contracts_billing_pk.attribute2;
787: END IF;
788: IF (x_contractbilling_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;
791: END IF;
792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;

Line 794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;

790: x_contractbilling_rec.attribute3 := l_cs_contracts_billing_pk.attribute3;
791: END IF;
792: IF (x_contractbilling_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;
795: END IF;
796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;

Line 798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;

794: x_contractbilling_rec.attribute4 := l_cs_contracts_billing_pk.attribute4;
795: END IF;
796: IF (x_contractbilling_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;
799: END IF;
800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;

Line 802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;

798: x_contractbilling_rec.attribute5 := l_cs_contracts_billing_pk.attribute5;
799: END IF;
800: IF (x_contractbilling_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;
803: END IF;
804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
805: THEN
806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;

Line 806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;

802: x_contractbilling_rec.attribute6 := l_cs_contracts_billing_pk.attribute6;
803: END IF;
804: IF (x_contractbilling_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
805: THEN
806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;
807: END IF;
808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
809: THEN
810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;

Line 810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;

806: x_contractbilling_rec.attribute7 := l_cs_contracts_billing_pk.attribute7;
807: END IF;
808: IF (x_contractbilling_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
809: THEN
810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;
811: END IF;
812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
813: THEN
814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;

Line 814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;

810: x_contractbilling_rec.attribute8 := l_cs_contracts_billing_pk.attribute8;
811: END IF;
812: IF (x_contractbilling_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
813: THEN
814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;
815: END IF;
816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
817: THEN
818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;

Line 818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;

814: x_contractbilling_rec.attribute9 := l_cs_contracts_billing_pk.attribute9;
815: END IF;
816: IF (x_contractbilling_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
817: THEN
818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;
819: END IF;
820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
821: THEN
822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;

Line 822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;

818: x_contractbilling_rec.attribute10 := l_cs_contracts_billing_pk.attribute10;
819: END IF;
820: IF (x_contractbilling_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
821: THEN
822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;
823: END IF;
824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
825: THEN
826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;

Line 826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;

822: x_contractbilling_rec.attribute11 := l_cs_contracts_billing_pk.attribute11;
823: END IF;
824: IF (x_contractbilling_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
825: THEN
826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;
827: END IF;
828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
829: THEN
830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;

Line 830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;

826: x_contractbilling_rec.attribute12 := l_cs_contracts_billing_pk.attribute12;
827: END IF;
828: IF (x_contractbilling_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
829: THEN
830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;
831: END IF;
832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
833: THEN
834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;

Line 834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;

830: x_contractbilling_rec.attribute13 := l_cs_contracts_billing_pk.attribute13;
831: END IF;
832: IF (x_contractbilling_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
833: THEN
834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;
835: END IF;
836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
837: THEN
838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;

Line 838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;

834: x_contractbilling_rec.attribute14 := l_cs_contracts_billing_pk.attribute14;
835: END IF;
836: IF (x_contractbilling_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
837: THEN
838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;
839: END IF;
840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
841: THEN
842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;

Line 842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;

838: x_contractbilling_rec.attribute15 := l_cs_contracts_billing_pk.attribute15;
839: END IF;
840: IF (x_contractbilling_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
841: THEN
842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;
843: END IF;
844: IF (x_contractbilling_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
845: THEN
846: x_contractbilling_rec.object_version_number := l_cs_contracts_billing_pk.object_version_number;

Line 846: x_contractbilling_rec.object_version_number := l_cs_contracts_billing_pk.object_version_number;

842: x_contractbilling_rec.context := l_cs_contracts_billing_pk.context;
843: END IF;
844: IF (x_contractbilling_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
845: THEN
846: x_contractbilling_rec.object_version_number := l_cs_contracts_billing_pk.object_version_number;
847: END IF;
848: RETURN(l_return_status);
849: END populate_new_record;
850: BEGIN

Line 903: UPDATE CS_CONTRACTS_BILLING

899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: END IF;
903: UPDATE CS_CONTRACTS_BILLING
904: SET
905: CONTRACT_BILLING_ID = l_def_contractbilling_rec.contract_billing_id ,
906: HEADER_ID = l_def_contractbilling_rec.header_id ,
907: ORDER_NUMBER = l_def_contractbilling_rec.order_number ,

Line 997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

993: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
994: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
995: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

996: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

997: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

998: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

999: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1000: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1001: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1002: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1003: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1004: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1005: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1006: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1007: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1008: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1009: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1010: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1011: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1012: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1013: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1014: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1015: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1016: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1017: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1018: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS

Line 1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1019: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS
1027: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1020: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1021: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1022: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1023: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1024: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1025: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1026: x_object_version_number OUT NUMBER) IS
1027: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1028: l_api_version CONSTANT NUMBER := 1;

Line 1153: DELETE FROM CS_CONTRACTS_BILLING

1149: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1150: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1151: RAISE FND_API.G_EXC_ERROR;
1152: END IF;
1153: DELETE FROM CS_CONTRACTS_BILLING
1154: WHERE
1155: CONTRACT_BILLING_ID = p_contract_billing_id
1156: ;
1157: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1291: p_line_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1292: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1293: p_contract_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1294: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1295: p_trx_date IN CS_CONTRACTS_BILLING.TRX_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1296: p_trx_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1297: p_trx_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1298: p_trx_class IN CS_CONTRACTS_BILLING.TRX_CLASS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1299: p_billed_until_date IN CS_CONTRACTS_BILLING.BILLED_UNTIL_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1300: p_currency_code IN CS_CONTRACTS_BILLING.CURRENCY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1301: p_last_update_date IN CS_CONTRACTS_BILLING.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1302: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1303: p_creation_date IN CS_CONTRACTS_BILLING.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1304: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1305: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1306: p_trx_pre_tax_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1307: p_attribute1 IN CS_CONTRACTS_BILLING.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1308: p_attribute2 IN CS_CONTRACTS_BILLING.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1309: p_attribute3 IN CS_CONTRACTS_BILLING.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1310: p_attribute4 IN CS_CONTRACTS_BILLING.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1311: p_attribute5 IN CS_CONTRACTS_BILLING.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1312: p_attribute6 IN CS_CONTRACTS_BILLING.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1313: p_attribute7 IN CS_CONTRACTS_BILLING.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1314: p_attribute8 IN CS_CONTRACTS_BILLING.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1315: p_attribute9 IN CS_CONTRACTS_BILLING.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1316: p_attribute10 IN CS_CONTRACTS_BILLING.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1317: p_attribute11 IN CS_CONTRACTS_BILLING.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1325: l_api_version CONSTANT NUMBER := 1;

Line 1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1318: p_attribute12 IN CS_CONTRACTS_BILLING.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1319: p_attribute13 IN CS_CONTRACTS_BILLING.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1320: p_attribute14 IN CS_CONTRACTS_BILLING.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1321: p_attribute15 IN CS_CONTRACTS_BILLING.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1322: p_context IN CS_CONTRACTS_BILLING.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1323: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1324: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1325: l_api_version CONSTANT NUMBER := 1;
1326: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;