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_TXNBTYPE_PVT dependencies on CS_TXN_BILLING_TYPES

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

1: PACKAGE BODY CS_TXNBTYPE_PVT AS
2: /* $Header: cscttbtb.pls 115.1 99/07/16 08:54:44 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_TXN_BILLING_TYPES_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 260: INSERT INTO CS_TXN_BILLING_TYPES(

256: END IF;
257: END IF;
258: -- Set primary key value
259: l_def_txnbtype_rec.txn_billing_type_id := get_seq_id;
260: INSERT INTO CS_TXN_BILLING_TYPES(
261: txn_billing_type_id,
262: billing_type,
263: transaction_type_id,
264: last_update_date,

Line 360: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := NULL,

356: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
357: x_return_status OUT VARCHAR2,
358: x_msg_count OUT NUMBER,
359: x_msg_data OUT VARCHAR2,
360: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := NULL,
361: p_transaction_type_id IN NUMBER := NULL,
362: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
363: p_last_updated_by IN NUMBER := NULL,
364: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := NULL,

Line 362: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,

358: x_msg_count OUT NUMBER,
359: x_msg_data OUT VARCHAR2,
360: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := NULL,
361: p_transaction_type_id IN NUMBER := NULL,
362: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
363: p_last_updated_by IN NUMBER := NULL,
364: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
365: p_created_by IN NUMBER := NULL,
366: p_last_update_login IN NUMBER := NULL,

Line 364: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := NULL,

360: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := NULL,
361: p_transaction_type_id IN NUMBER := NULL,
362: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
363: p_last_updated_by IN NUMBER := NULL,
364: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := NULL,
365: p_created_by IN NUMBER := NULL,
366: p_last_update_login IN NUMBER := NULL,
367: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,
368: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,

Line 367: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := NULL,

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

Line 368: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := NULL,

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

Line 369: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := NULL,

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

Line 370: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := NULL,

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

Line 371: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := NULL,

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

Line 372: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := NULL,

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

Line 373: p_attribute7 IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := NULL,

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

Line 374: p_attribute8 IN CS_TXN_BILLING_TYPES.ATTRIBUTE8%TYPE := NULL,

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

Line 375: p_attribute9 IN CS_TXN_BILLING_TYPES.ATTRIBUTE9%TYPE := NULL,

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

Line 376: p_attribute10 IN CS_TXN_BILLING_TYPES.ATTRIBUTE10%TYPE := NULL,

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

Line 377: p_attribute11 IN CS_TXN_BILLING_TYPES.ATTRIBUTE11%TYPE := NULL,

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

Line 378: p_attribute12 IN CS_TXN_BILLING_TYPES.ATTRIBUTE12%TYPE := NULL,

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

Line 379: p_attribute13 IN CS_TXN_BILLING_TYPES.ATTRIBUTE13%TYPE := NULL,

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

Line 380: p_attribute14 IN CS_TXN_BILLING_TYPES.ATTRIBUTE14%TYPE := NULL,

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

Line 381: p_attribute15 IN CS_TXN_BILLING_TYPES.ATTRIBUTE15%TYPE := NULL,

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

Line 382: p_context IN CS_TXN_BILLING_TYPES.CONTEXT%TYPE := NULL,

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

Line 490: FROM CS_TXN_BILLING_TYPES

486: E_Resource_Busy EXCEPTION;
487: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
488: CURSOR lock_csr IS
489: SELECT OBJECT_VERSION_NUMBER
490: FROM CS_TXN_BILLING_TYPES
491: WHERE
492: TXN_BILLING_TYPE_ID = p_txn_billing_type_id AND
493: OBJECT_VERSION_NUMBER = p_object_version_number
494: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 498: FROM CS_TXN_BILLING_TYPES

494: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
495:
496: CURSOR lchk_csr IS
497: SELECT OBJECT_VERSION_NUMBER
498: FROM CS_TXN_BILLING_TYPES
499: WHERE
500: TXN_BILLING_TYPE_ID = p_txn_billing_type_id
501: ;
502: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 505: l_object_version_number CS_TXN_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;

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

Line 506: lc_object_version_number CS_TXN_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;

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

Line 611: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS

607: FUNCTION populate_new_record (
608: p_txnbtype_rec IN TxnBType_Rec_Type,
609: x_txnbtype_rec OUT TxnBType_Rec_Type
610: ) RETURN VARCHAR2 IS
611: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
612: SELECT *
613: FROM Cs_Txn_Billing_Types
614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;

Line 613: FROM Cs_Txn_Billing_Types

609: x_txnbtype_rec OUT TxnBType_Rec_Type
610: ) RETURN VARCHAR2 IS
611: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
612: SELECT *
613: FROM Cs_Txn_Billing_Types
614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
616: l_row_notfound BOOLEAN := TRUE;
617: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;

610: ) RETURN VARCHAR2 IS
611: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
612: SELECT *
613: FROM Cs_Txn_Billing_Types
614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
616: l_row_notfound BOOLEAN := TRUE;
617: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
618: BEGIN

Line 615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;

611: CURSOR cs_txn_billing_types_pk_csr (p_txn_billing_type_id IN NUMBER) IS
612: SELECT *
613: FROM Cs_Txn_Billing_Types
614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
616: l_row_notfound BOOLEAN := TRUE;
617: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
618: BEGIN
619: x_txnbtype_rec := p_txnbtype_rec;

Line 621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);

617: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
618: BEGIN
619: x_txnbtype_rec := p_txnbtype_rec;
620: -- Get current database values
621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);
622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
624: CLOSE cs_txn_billing_types_pk_csr;
625: IF (l_row_notfound) THEN

Line 622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;

618: BEGIN
619: x_txnbtype_rec := p_txnbtype_rec;
620: -- Get current database values
621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);
622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
624: CLOSE cs_txn_billing_types_pk_csr;
625: IF (l_row_notfound) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;

Line 623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;

619: x_txnbtype_rec := p_txnbtype_rec;
620: -- Get current database values
621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);
622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
624: CLOSE cs_txn_billing_types_pk_csr;
625: IF (l_row_notfound) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;

Line 624: CLOSE cs_txn_billing_types_pk_csr;

620: -- Get current database values
621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);
622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
624: CLOSE cs_txn_billing_types_pk_csr;
625: IF (l_row_notfound) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: IF (x_txnbtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 630: x_txnbtype_rec.txn_billing_type_id := l_cs_txn_billing_types_pk.txn_billing_type_id;

626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: IF (x_txnbtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
629: THEN
630: x_txnbtype_rec.txn_billing_type_id := l_cs_txn_billing_types_pk.txn_billing_type_id;
631: END IF;
632: IF (x_txnbtype_rec.billing_type = TAPI_DEV_KIT.G_MISS_CHAR)
633: THEN
634: x_txnbtype_rec.billing_type := l_cs_txn_billing_types_pk.billing_type;

Line 634: x_txnbtype_rec.billing_type := l_cs_txn_billing_types_pk.billing_type;

630: x_txnbtype_rec.txn_billing_type_id := l_cs_txn_billing_types_pk.txn_billing_type_id;
631: END IF;
632: IF (x_txnbtype_rec.billing_type = TAPI_DEV_KIT.G_MISS_CHAR)
633: THEN
634: x_txnbtype_rec.billing_type := l_cs_txn_billing_types_pk.billing_type;
635: END IF;
636: IF (x_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM)
637: THEN
638: x_txnbtype_rec.transaction_type_id := l_cs_txn_billing_types_pk.transaction_type_id;

Line 638: x_txnbtype_rec.transaction_type_id := l_cs_txn_billing_types_pk.transaction_type_id;

634: x_txnbtype_rec.billing_type := l_cs_txn_billing_types_pk.billing_type;
635: END IF;
636: IF (x_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM)
637: THEN
638: x_txnbtype_rec.transaction_type_id := l_cs_txn_billing_types_pk.transaction_type_id;
639: END IF;
640: IF (x_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
641: THEN
642: x_txnbtype_rec.last_update_date := l_cs_txn_billing_types_pk.last_update_date;

Line 642: x_txnbtype_rec.last_update_date := l_cs_txn_billing_types_pk.last_update_date;

638: x_txnbtype_rec.transaction_type_id := l_cs_txn_billing_types_pk.transaction_type_id;
639: END IF;
640: IF (x_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
641: THEN
642: x_txnbtype_rec.last_update_date := l_cs_txn_billing_types_pk.last_update_date;
643: END IF;
644: IF (x_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
645: THEN
646: x_txnbtype_rec.last_updated_by := l_cs_txn_billing_types_pk.last_updated_by;

Line 646: x_txnbtype_rec.last_updated_by := l_cs_txn_billing_types_pk.last_updated_by;

642: x_txnbtype_rec.last_update_date := l_cs_txn_billing_types_pk.last_update_date;
643: END IF;
644: IF (x_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
645: THEN
646: x_txnbtype_rec.last_updated_by := l_cs_txn_billing_types_pk.last_updated_by;
647: END IF;
648: IF (x_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
649: THEN
650: x_txnbtype_rec.creation_date := l_cs_txn_billing_types_pk.creation_date;

Line 650: x_txnbtype_rec.creation_date := l_cs_txn_billing_types_pk.creation_date;

646: x_txnbtype_rec.last_updated_by := l_cs_txn_billing_types_pk.last_updated_by;
647: END IF;
648: IF (x_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
649: THEN
650: x_txnbtype_rec.creation_date := l_cs_txn_billing_types_pk.creation_date;
651: END IF;
652: IF (x_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
653: THEN
654: x_txnbtype_rec.created_by := l_cs_txn_billing_types_pk.created_by;

Line 654: x_txnbtype_rec.created_by := l_cs_txn_billing_types_pk.created_by;

650: x_txnbtype_rec.creation_date := l_cs_txn_billing_types_pk.creation_date;
651: END IF;
652: IF (x_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
653: THEN
654: x_txnbtype_rec.created_by := l_cs_txn_billing_types_pk.created_by;
655: END IF;
656: IF (x_txnbtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
657: THEN
658: x_txnbtype_rec.last_update_login := l_cs_txn_billing_types_pk.last_update_login;

Line 658: x_txnbtype_rec.last_update_login := l_cs_txn_billing_types_pk.last_update_login;

654: x_txnbtype_rec.created_by := l_cs_txn_billing_types_pk.created_by;
655: END IF;
656: IF (x_txnbtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
657: THEN
658: x_txnbtype_rec.last_update_login := l_cs_txn_billing_types_pk.last_update_login;
659: END IF;
660: IF (x_txnbtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
661: THEN
662: x_txnbtype_rec.attribute1 := l_cs_txn_billing_types_pk.attribute1;

Line 662: x_txnbtype_rec.attribute1 := l_cs_txn_billing_types_pk.attribute1;

658: x_txnbtype_rec.last_update_login := l_cs_txn_billing_types_pk.last_update_login;
659: END IF;
660: IF (x_txnbtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
661: THEN
662: x_txnbtype_rec.attribute1 := l_cs_txn_billing_types_pk.attribute1;
663: END IF;
664: IF (x_txnbtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
665: THEN
666: x_txnbtype_rec.attribute2 := l_cs_txn_billing_types_pk.attribute2;

Line 666: x_txnbtype_rec.attribute2 := l_cs_txn_billing_types_pk.attribute2;

662: x_txnbtype_rec.attribute1 := l_cs_txn_billing_types_pk.attribute1;
663: END IF;
664: IF (x_txnbtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
665: THEN
666: x_txnbtype_rec.attribute2 := l_cs_txn_billing_types_pk.attribute2;
667: END IF;
668: IF (x_txnbtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
669: THEN
670: x_txnbtype_rec.attribute3 := l_cs_txn_billing_types_pk.attribute3;

Line 670: x_txnbtype_rec.attribute3 := l_cs_txn_billing_types_pk.attribute3;

666: x_txnbtype_rec.attribute2 := l_cs_txn_billing_types_pk.attribute2;
667: END IF;
668: IF (x_txnbtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
669: THEN
670: x_txnbtype_rec.attribute3 := l_cs_txn_billing_types_pk.attribute3;
671: END IF;
672: IF (x_txnbtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
673: THEN
674: x_txnbtype_rec.attribute4 := l_cs_txn_billing_types_pk.attribute4;

Line 674: x_txnbtype_rec.attribute4 := l_cs_txn_billing_types_pk.attribute4;

670: x_txnbtype_rec.attribute3 := l_cs_txn_billing_types_pk.attribute3;
671: END IF;
672: IF (x_txnbtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
673: THEN
674: x_txnbtype_rec.attribute4 := l_cs_txn_billing_types_pk.attribute4;
675: END IF;
676: IF (x_txnbtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
677: THEN
678: x_txnbtype_rec.attribute5 := l_cs_txn_billing_types_pk.attribute5;

Line 678: x_txnbtype_rec.attribute5 := l_cs_txn_billing_types_pk.attribute5;

674: x_txnbtype_rec.attribute4 := l_cs_txn_billing_types_pk.attribute4;
675: END IF;
676: IF (x_txnbtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
677: THEN
678: x_txnbtype_rec.attribute5 := l_cs_txn_billing_types_pk.attribute5;
679: END IF;
680: IF (x_txnbtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
681: THEN
682: x_txnbtype_rec.attribute6 := l_cs_txn_billing_types_pk.attribute6;

Line 682: x_txnbtype_rec.attribute6 := l_cs_txn_billing_types_pk.attribute6;

678: x_txnbtype_rec.attribute5 := l_cs_txn_billing_types_pk.attribute5;
679: END IF;
680: IF (x_txnbtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
681: THEN
682: x_txnbtype_rec.attribute6 := l_cs_txn_billing_types_pk.attribute6;
683: END IF;
684: IF (x_txnbtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
685: THEN
686: x_txnbtype_rec.attribute7 := l_cs_txn_billing_types_pk.attribute7;

Line 686: x_txnbtype_rec.attribute7 := l_cs_txn_billing_types_pk.attribute7;

682: x_txnbtype_rec.attribute6 := l_cs_txn_billing_types_pk.attribute6;
683: END IF;
684: IF (x_txnbtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
685: THEN
686: x_txnbtype_rec.attribute7 := l_cs_txn_billing_types_pk.attribute7;
687: END IF;
688: IF (x_txnbtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
689: THEN
690: x_txnbtype_rec.attribute8 := l_cs_txn_billing_types_pk.attribute8;

Line 690: x_txnbtype_rec.attribute8 := l_cs_txn_billing_types_pk.attribute8;

686: x_txnbtype_rec.attribute7 := l_cs_txn_billing_types_pk.attribute7;
687: END IF;
688: IF (x_txnbtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
689: THEN
690: x_txnbtype_rec.attribute8 := l_cs_txn_billing_types_pk.attribute8;
691: END IF;
692: IF (x_txnbtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
693: THEN
694: x_txnbtype_rec.attribute9 := l_cs_txn_billing_types_pk.attribute9;

Line 694: x_txnbtype_rec.attribute9 := l_cs_txn_billing_types_pk.attribute9;

690: x_txnbtype_rec.attribute8 := l_cs_txn_billing_types_pk.attribute8;
691: END IF;
692: IF (x_txnbtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
693: THEN
694: x_txnbtype_rec.attribute9 := l_cs_txn_billing_types_pk.attribute9;
695: END IF;
696: IF (x_txnbtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_txnbtype_rec.attribute10 := l_cs_txn_billing_types_pk.attribute10;

Line 698: x_txnbtype_rec.attribute10 := l_cs_txn_billing_types_pk.attribute10;

694: x_txnbtype_rec.attribute9 := l_cs_txn_billing_types_pk.attribute9;
695: END IF;
696: IF (x_txnbtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_txnbtype_rec.attribute10 := l_cs_txn_billing_types_pk.attribute10;
699: END IF;
700: IF (x_txnbtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
701: THEN
702: x_txnbtype_rec.attribute11 := l_cs_txn_billing_types_pk.attribute11;

Line 702: x_txnbtype_rec.attribute11 := l_cs_txn_billing_types_pk.attribute11;

698: x_txnbtype_rec.attribute10 := l_cs_txn_billing_types_pk.attribute10;
699: END IF;
700: IF (x_txnbtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
701: THEN
702: x_txnbtype_rec.attribute11 := l_cs_txn_billing_types_pk.attribute11;
703: END IF;
704: IF (x_txnbtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_txnbtype_rec.attribute12 := l_cs_txn_billing_types_pk.attribute12;

Line 706: x_txnbtype_rec.attribute12 := l_cs_txn_billing_types_pk.attribute12;

702: x_txnbtype_rec.attribute11 := l_cs_txn_billing_types_pk.attribute11;
703: END IF;
704: IF (x_txnbtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_txnbtype_rec.attribute12 := l_cs_txn_billing_types_pk.attribute12;
707: END IF;
708: IF (x_txnbtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_txnbtype_rec.attribute13 := l_cs_txn_billing_types_pk.attribute13;

Line 710: x_txnbtype_rec.attribute13 := l_cs_txn_billing_types_pk.attribute13;

706: x_txnbtype_rec.attribute12 := l_cs_txn_billing_types_pk.attribute12;
707: END IF;
708: IF (x_txnbtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_txnbtype_rec.attribute13 := l_cs_txn_billing_types_pk.attribute13;
711: END IF;
712: IF (x_txnbtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
713: THEN
714: x_txnbtype_rec.attribute14 := l_cs_txn_billing_types_pk.attribute14;

Line 714: x_txnbtype_rec.attribute14 := l_cs_txn_billing_types_pk.attribute14;

710: x_txnbtype_rec.attribute13 := l_cs_txn_billing_types_pk.attribute13;
711: END IF;
712: IF (x_txnbtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
713: THEN
714: x_txnbtype_rec.attribute14 := l_cs_txn_billing_types_pk.attribute14;
715: END IF;
716: IF (x_txnbtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
717: THEN
718: x_txnbtype_rec.attribute15 := l_cs_txn_billing_types_pk.attribute15;

Line 718: x_txnbtype_rec.attribute15 := l_cs_txn_billing_types_pk.attribute15;

714: x_txnbtype_rec.attribute14 := l_cs_txn_billing_types_pk.attribute14;
715: END IF;
716: IF (x_txnbtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
717: THEN
718: x_txnbtype_rec.attribute15 := l_cs_txn_billing_types_pk.attribute15;
719: END IF;
720: IF (x_txnbtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
721: THEN
722: x_txnbtype_rec.context := l_cs_txn_billing_types_pk.context;

Line 722: x_txnbtype_rec.context := l_cs_txn_billing_types_pk.context;

718: x_txnbtype_rec.attribute15 := l_cs_txn_billing_types_pk.attribute15;
719: END IF;
720: IF (x_txnbtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
721: THEN
722: x_txnbtype_rec.context := l_cs_txn_billing_types_pk.context;
723: END IF;
724: IF (x_txnbtype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_txnbtype_rec.object_version_number := l_cs_txn_billing_types_pk.object_version_number;

Line 726: x_txnbtype_rec.object_version_number := l_cs_txn_billing_types_pk.object_version_number;

722: x_txnbtype_rec.context := l_cs_txn_billing_types_pk.context;
723: END IF;
724: IF (x_txnbtype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_txnbtype_rec.object_version_number := l_cs_txn_billing_types_pk.object_version_number;
727: END IF;
728: RETURN(l_return_status);
729: END populate_new_record;
730: BEGIN

Line 783: UPDATE CS_TXN_BILLING_TYPES

779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: END IF;
783: UPDATE CS_TXN_BILLING_TYPES
784: SET
785: TXN_BILLING_TYPE_ID = l_def_txnbtype_rec.txn_billing_type_id ,
786: BILLING_TYPE = l_def_txnbtype_rec.billing_type ,
787: TRANSACTION_TYPE_ID = l_def_txnbtype_rec.transaction_type_id ,

Line 860: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

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

858: x_msg_data OUT VARCHAR2,
859: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

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

860: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
868: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 867: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 868: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 869: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 870: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 871: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 872: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 873: p_attribute7 IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 874: p_attribute8 IN CS_TXN_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 875: p_attribute9 IN CS_TXN_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 876: p_attribute10 IN CS_TXN_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 877: p_attribute11 IN CS_TXN_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 878: p_attribute12 IN CS_TXN_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 879: p_attribute13 IN CS_TXN_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 880: p_attribute14 IN CS_TXN_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 881: p_attribute15 IN CS_TXN_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 882: p_context IN CS_TXN_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1000: DELETE FROM CS_TXN_BILLING_TYPES

996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: DELETE FROM CS_TXN_BILLING_TYPES
1001: WHERE
1002: TXN_BILLING_TYPE_ID = p_txn_billing_type_id
1003: ;
1004: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1136: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1132: x_return_status OUT VARCHAR2,
1133: x_msg_count OUT NUMBER,
1134: x_msg_data OUT VARCHAR2,
1135: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1136: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1139: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1138: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1134: x_msg_data OUT VARCHAR2,
1135: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1136: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1139: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1136: p_billing_type IN CS_TXN_BILLING_TYPES.BILLING_TYPE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1137: p_transaction_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_last_update_date IN CS_TXN_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1139: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1139: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1140: p_creation_date IN CS_TXN_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute7 IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1146: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1142: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_attribute2 IN CS_TXN_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_attribute4 IN CS_TXN_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute7 IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute8 IN CS_TXN_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1147: p_attribute5 IN CS_TXN_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1148: p_attribute6 IN CS_TXN_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1149: p_attribute7 IN CS_TXN_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1150: p_attribute8 IN CS_TXN_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1151: p_attribute9 IN CS_TXN_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1152: p_attribute10 IN CS_TXN_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1153: p_attribute11 IN CS_TXN_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1154: p_attribute12 IN CS_TXN_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1155: p_attribute13 IN CS_TXN_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1156: p_attribute14 IN CS_TXN_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1157: p_attribute15 IN CS_TXN_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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

Line 1158: p_context IN CS_TXN_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

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