[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_txnbtype_rec.billing_type = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_txnbtype_rec.billing_type IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billing_type');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_txnbtype_rec.billing_type = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_txnbtype_rec.billing_type IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billing_type');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txnbtype_rec.transaction_type_id IS NULL
31: THEN
25: p_txnbtype_rec.billing_type IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'billing_type');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txnbtype_rec.transaction_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txnbtype_rec.transaction_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txnbtype_rec.last_update_date IS NULL
36: THEN
30: p_txnbtype_rec.transaction_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txnbtype_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txnbtype_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txnbtype_rec.last_updated_by IS NULL
41: THEN
35: p_txnbtype_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txnbtype_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txnbtype_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txnbtype_rec.creation_date IS NULL
46: THEN
40: p_txnbtype_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txnbtype_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txnbtype_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txnbtype_rec.created_by IS NULL
51: THEN
45: p_txnbtype_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txnbtype_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txnbtype_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;
101: FETCH cl_pk_csr INTO l_cl_pk;
102: l_row_notfound := cl_pk_csr%NOTFOUND;
103: CLOSE cl_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BILLING_TYPE');
106: RAISE item_not_found_error;
107: END IF;
108: END IF;
109: IF (p_txnbtype_rec.TRANSACTION_TYPE_ID IS NOT NULL)
112: FETCH ctt_pk_csr INTO l_ctt_pk;
113: l_row_notfound := ctt_pk_csr%NOTFOUND;
114: CLOSE ctt_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TRANSACTION_TYPE_ID');
117: RAISE item_not_found_error;
118: END IF;
119: END IF;
120: RETURN (l_return_status);
193: END migrate;
194: PROCEDURE insert_row
195: (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
198: p_validation_level IN NUMBER,
199: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
200: x_return_status OUT VARCHAR2,
201: x_msg_count OUT NUMBER,
195: (
196: p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
198: p_validation_level IN NUMBER,
199: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
200: x_return_status OUT VARCHAR2,
201: x_msg_count OUT NUMBER,
202: x_msg_data OUT VARCHAR2,
203: p_txnbtype_rec IN TxnBType_Rec_Type := G_MISS_TXNBTYPE_REC,
208: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
209: l_txnbtype_rec TxnBType_Rec_Type;
210: l_def_txnbtype_rec TxnBType_Rec_Type;
211: BEGIN
212: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
213: G_PKG_NAME,
214: l_api_version,
215: p_api_version,
216: p_init_msg_list,
311: l_def_txnbtype_rec.object_version_number);
312: -- Set OUT values
313: x_txn_billing_type_id := l_def_txnbtype_rec.txn_billing_type_id;
314: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
315: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
319: (
314: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
315: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
319: (
320: l_api_name,
321: G_PKG_NAME,
322: 'FND_API.G_RET_STS_ERROR',
325: '_Pvt'
326: );
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,
333: 'FND_API.G_RET_STS_UNEXP_ERROR',
335: x_msg_data,
336: '_Pvt'
337: );
338: APP_EXCEPTION.RAISE_EXCEPTION;
339: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
340: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
341: (
342: l_api_name,
343: G_PKG_NAME,
336: '_Pvt'
337: );
338: APP_EXCEPTION.RAISE_EXCEPTION;
339: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
340: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
341: (
342: l_api_name,
343: G_PKG_NAME,
344: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
340: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
341: (
342: l_api_name,
343: G_PKG_NAME,
344: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
345: x_msg_count,
346: x_msg_data,
347: '_Pvt'
348: );
350: END insert_row;
351: PROCEDURE insert_row
352: (
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
355: p_validation_level IN NUMBER,
356: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
357: x_return_status OUT VARCHAR2,
358: x_msg_count OUT NUMBER,
352: (
353: p_api_version IN NUMBER,
354: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
355: p_validation_level IN NUMBER,
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,
387: l_api_version CONSTANT NUMBER := 1;
388: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
389: l_txnbtype_rec TxnBType_Rec_Type;
390: BEGIN
391: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
392: G_PKG_NAME,
393: l_api_version,
394: p_api_version,
395: p_init_msg_list,
435: l_txnbtype_rec,
436: x_txn_billing_type_id,
437: x_object_version_number
438: );
439: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
443: (
438: );
439: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
443: (
444: l_api_name,
445: G_PKG_NAME,
446: 'FND_API.G_RET_STS_ERROR',
449: '_Pvt'
450: );
451: APP_EXCEPTION.RAISE_EXCEPTION;
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
454: (
455: l_api_name,
456: G_PKG_NAME,
457: 'FND_API.G_RET_STS_UNEXP_ERROR',
459: x_msg_data,
460: '_Pvt'
461: );
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
464: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
465: (
466: l_api_name,
467: G_PKG_NAME,
460: '_Pvt'
461: );
462: APP_EXCEPTION.RAISE_EXCEPTION;
463: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
464: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
465: (
466: l_api_name,
467: G_PKG_NAME,
468: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
464: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
465: (
466: l_api_name,
467: G_PKG_NAME,
468: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
469: x_msg_count,
470: x_msg_data,
471: '_Pvt'
472: );
474: END insert_row;
475: Procedure lock_row
476: (
477: p_api_version IN NUMBER,
478: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
479: p_validation_level IN NUMBER,
480: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
481: x_return_status OUT VARCHAR2,
482: x_msg_count OUT NUMBER,
476: (
477: p_api_version IN NUMBER,
478: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
479: p_validation_level IN NUMBER,
480: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
481: x_return_status OUT VARCHAR2,
482: x_msg_count OUT NUMBER,
483: x_msg_data OUT VARCHAR2,
484: p_txn_billing_type_id IN NUMBER,
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,
511: G_PKG_NAME,
512: l_api_version,
513: p_api_version,
514: p_init_msg_list,
528: WHEN E_Resource_Busy THEN
529: IF (lock_csr%ISOPEN) THEN
530: CLOSE lock_csr;
531: END IF;
532: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
533: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
534: END;
535:
536: IF ( l_row_notfound ) THEN
539: lc_row_notfound := lchk_csr%NOTFOUND;
540: CLOSE lchk_csr;
541: END IF;
542: IF (lc_row_notfound) THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number > p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
542: IF (lc_row_notfound) THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number > p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number <> p_object_version_number THEN
549: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
550: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number > p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number <> p_object_version_number THEN
549: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
550: RAISE FND_API.G_EXC_ERROR;
551: ELSIF lc_object_version_number = -1 THEN
552: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
553: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number <> p_object_version_number THEN
549: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
550: RAISE FND_API.G_EXC_ERROR;
551: ELSIF lc_object_version_number = -1 THEN
552: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
556: EXCEPTION
551: ELSIF lc_object_version_number = -1 THEN
552: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
553: RAISE FND_API.G_EXC_ERROR;
554: END IF;
555: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
559: (
554: END IF;
555: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
556: EXCEPTION
557: WHEN FND_API.G_EXC_ERROR THEN
558: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
559: (
560: l_api_name,
561: G_PKG_NAME,
562: 'FND_API.G_RET_STS_ERROR',
565: '_Pvt'
566: );
567: APP_EXCEPTION.RAISE_EXCEPTION;
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
570: (
571: l_api_name,
572: G_PKG_NAME,
573: 'FND_API.G_RET_STS_UNEXP_ERROR',
575: x_msg_data,
576: '_Pvt'
577: );
578: APP_EXCEPTION.RAISE_EXCEPTION;
579: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
580: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
581: (
582: l_api_name,
583: G_PKG_NAME,
576: '_Pvt'
577: );
578: APP_EXCEPTION.RAISE_EXCEPTION;
579: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
580: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
581: (
582: l_api_name,
583: G_PKG_NAME,
584: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
580: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
581: (
582: l_api_name,
583: G_PKG_NAME,
584: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
585: x_msg_count,
586: x_msg_data,
587: '_Pvt'
588: );
590: END lock_row;
591: Procedure update_row
592: (
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
595: p_validation_level IN NUMBER,
596: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
597: x_return_status OUT VARCHAR2,
598: x_msg_count OUT NUMBER,
592: (
593: p_api_version IN NUMBER,
594: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
595: p_validation_level IN NUMBER,
596: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
597: x_return_status OUT VARCHAR2,
598: x_msg_count OUT NUMBER,
599: x_msg_data OUT VARCHAR2,
600: p_txnbtype_val_rec IN TxnBType_Val_Rec_Type := G_MISS_TXNBTYPE_VAL_REC,
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)
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)
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;
635: END IF;
636: IF (x_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM)
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;
639: END IF;
640: IF (x_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
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;
643: END IF;
644: IF (x_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
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;
647: END IF;
648: IF (x_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
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;
651: END IF;
652: IF (x_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
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;
655: END IF;
656: IF (x_txnbtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
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;
659: END IF;
660: IF (x_txnbtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
663: END IF;
664: IF (x_txnbtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
667: END IF;
668: IF (x_txnbtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
671: END IF;
672: IF (x_txnbtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
675: END IF;
676: IF (x_txnbtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
679: END IF;
680: IF (x_txnbtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
683: END IF;
684: IF (x_txnbtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
687: END IF;
688: IF (x_txnbtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
691: END IF;
692: IF (x_txnbtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
695: END IF;
696: IF (x_txnbtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
699: END IF;
700: IF (x_txnbtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
703: END IF;
704: IF (x_txnbtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
707: END IF;
708: IF (x_txnbtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
711: END IF;
712: IF (x_txnbtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
715: END IF;
716: IF (x_txnbtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
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;
719: END IF;
720: IF (x_txnbtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
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;
723: END IF;
724: IF (x_txnbtype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
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;
727: END IF;
728: RETURN(l_return_status);
727: END IF;
728: RETURN(l_return_status);
729: END populate_new_record;
730: BEGIN
731: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
732: G_PKG_NAME,
733: l_api_version,
734: p_api_version,
735: p_init_msg_list,
810: WHERE
811: TXN_BILLING_TYPE_ID = l_def_txnbtype_rec.txn_billing_type_id
812: ;
813: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
814: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
813: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
814: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
819: l_api_name,
820: G_PKG_NAME,
821: 'FND_API.G_RET_STS_ERROR',
824: '_Pvt'
825: );
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
829: (
830: l_api_name,
831: G_PKG_NAME,
832: 'FND_API.G_RET_STS_UNEXP_ERROR',
834: x_msg_data,
835: '_Pvt'
836: );
837: APP_EXCEPTION.RAISE_EXCEPTION;
838: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
835: '_Pvt'
836: );
837: APP_EXCEPTION.RAISE_EXCEPTION;
838: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
844: x_msg_count,
845: x_msg_data,
846: '_Pvt'
847: );
849: END update_row;
850: Procedure update_row
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
854: p_validation_level IN NUMBER,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
854: p_validation_level IN NUMBER,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
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,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
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,
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,
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,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
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,
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,
867: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
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,
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,
869: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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';
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;
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;
887: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
886: l_api_version CONSTANT NUMBER := 1;
887: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
888: l_txnbtype_rec TxnBType_Val_Rec_Type;
889: BEGIN
890: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
891: G_PKG_NAME,
892: l_api_version,
893: p_api_version,
894: p_init_msg_list,
934: x_msg_data,
935: l_txnbtype_rec,
936: x_object_version_number
937: );
938: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
942: (
937: );
938: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
942: (
943: l_api_name,
944: G_PKG_NAME,
945: 'FND_API.G_RET_STS_ERROR',
948: '_Pvt'
949: );
950: APP_EXCEPTION.RAISE_EXCEPTION;
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
953: (
954: l_api_name,
955: G_PKG_NAME,
956: 'FND_API.G_RET_STS_UNEXP_ERROR',
958: x_msg_data,
959: '_Pvt'
960: );
961: APP_EXCEPTION.RAISE_EXCEPTION;
962: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
963: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
959: '_Pvt'
960: );
961: APP_EXCEPTION.RAISE_EXCEPTION;
962: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
963: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
963: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
964: (
965: l_api_name,
966: G_PKG_NAME,
967: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
968: x_msg_count,
969: x_msg_data,
970: '_Pvt'
971: );
973: END update_row;
974: Procedure delete_row
975: (
976: p_api_version IN NUMBER,
977: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
978: p_validation_level IN NUMBER,
979: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
980: x_return_status OUT VARCHAR2,
981: x_msg_count OUT NUMBER,
975: (
976: p_api_version IN NUMBER,
977: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
978: p_validation_level IN NUMBER,
979: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
980: x_return_status OUT VARCHAR2,
981: x_msg_count OUT NUMBER,
982: x_msg_data OUT VARCHAR2,
983: p_txn_billing_type_id IN NUMBER) IS
984: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
985: l_api_version CONSTANT NUMBER := 1;
986: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
987: BEGIN
988: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
989: G_PKG_NAME,
990: l_api_version,
991: p_api_version,
992: p_init_msg_list,
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);
1005: EXCEPTION
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1008: (
1003: ;
1004: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1005: EXCEPTION
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1008: (
1009: l_api_name,
1010: G_PKG_NAME,
1011: 'FND_API.G_RET_STS_ERROR',
1014: '_Pvt'
1015: );
1016: APP_EXCEPTION.RAISE_EXCEPTION;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1019: (
1020: l_api_name,
1021: G_PKG_NAME,
1022: 'FND_API.G_RET_STS_UNEXP_ERROR',
1024: x_msg_data,
1025: '_Pvt'
1026: );
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1028: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1029: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1030: (
1031: l_api_name,
1032: G_PKG_NAME,
1025: '_Pvt'
1026: );
1027: APP_EXCEPTION.RAISE_EXCEPTION;
1028: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1029: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1030: (
1031: l_api_name,
1032: G_PKG_NAME,
1033: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1029: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1030: (
1031: l_api_name,
1032: G_PKG_NAME,
1033: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1034: x_msg_count,
1035: x_msg_data,
1036: '_Pvt'
1037: );
1039: END delete_row;
1040: PROCEDURE validate_row
1041: (
1042: p_api_version IN NUMBER,
1043: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1044: p_validation_level IN NUMBER,
1045: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1046: x_return_status OUT VARCHAR2,
1047: x_msg_count OUT NUMBER,
1041: (
1042: p_api_version IN NUMBER,
1043: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1044: p_validation_level IN NUMBER,
1045: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1046: x_return_status OUT VARCHAR2,
1047: x_msg_count OUT NUMBER,
1048: x_msg_data OUT VARCHAR2,
1049: p_txnbtype_val_rec IN TxnBType_Val_Rec_Type := G_MISS_TXNBTYPE_VAL_REC) IS
1052: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1053: l_txnbtype_rec TxnBType_Rec_Type;
1054: l_def_txnbtype_rec TxnBType_Rec_Type;
1055: BEGIN
1056: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1057: G_PKG_NAME,
1058: l_api_version,
1059: p_api_version,
1060: p_init_msg_list,
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: END IF;
1090: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1094: (
1089: END IF;
1090: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1094: (
1095: l_api_name,
1096: G_PKG_NAME,
1097: 'FND_API.G_RET_STS_ERROR',
1100: '_Pvt'
1101: );
1102: APP_EXCEPTION.RAISE_EXCEPTION;
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1105: (
1106: l_api_name,
1107: G_PKG_NAME,
1108: 'FND_API.G_RET_STS_UNEXP_ERROR',
1110: x_msg_data,
1111: '_Pvt'
1112: );
1113: APP_EXCEPTION.RAISE_EXCEPTION;
1114: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1115: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1116: (
1117: l_api_name,
1118: G_PKG_NAME,
1111: '_Pvt'
1112: );
1113: APP_EXCEPTION.RAISE_EXCEPTION;
1114: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1115: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1116: (
1117: l_api_name,
1118: G_PKG_NAME,
1119: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1115: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1116: (
1117: l_api_name,
1118: G_PKG_NAME,
1119: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1120: x_msg_count,
1121: x_msg_data,
1122: '_Pvt'
1123: );
1125: END validate_row;
1126: PROCEDURE validate_row
1127: (
1128: p_api_version IN NUMBER,
1129: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1130: p_validation_level IN NUMBER,
1131: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1132: x_return_status OUT VARCHAR2,
1133: x_msg_count OUT NUMBER,
1127: (
1128: p_api_version IN NUMBER,
1129: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1130: p_validation_level IN NUMBER,
1131: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
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,
1131: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
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,
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,
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,
1141: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
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,
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,
1143: p_attribute1 IN CS_TXN_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
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,
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,
1145: p_attribute3 IN CS_TXN_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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,
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
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';
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;
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;
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;
1163: l_txnbtype_rec TxnBType_Val_Rec_Type;
1161: l_api_version CONSTANT NUMBER := 1;
1162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1163: l_txnbtype_rec TxnBType_Val_Rec_Type;
1164: BEGIN
1165: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1166: G_PKG_NAME,
1167: l_api_version,
1168: p_api_version,
1169: p_init_msg_list,
1208: x_msg_count,
1209: x_msg_data,
1210: l_txnbtype_rec
1211: );
1212: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1216: (
1211: );
1212: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1216: (
1217: l_api_name,
1218: G_PKG_NAME,
1219: 'FND_API.G_RET_STS_ERROR',
1222: '_Pvt'
1223: );
1224: APP_EXCEPTION.RAISE_EXCEPTION;
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1227: (
1228: l_api_name,
1229: G_PKG_NAME,
1230: 'FND_API.G_RET_STS_UNEXP_ERROR',
1232: x_msg_data,
1233: '_Pvt'
1234: );
1235: APP_EXCEPTION.RAISE_EXCEPTION;
1236: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1237: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1238: (
1239: l_api_name,
1240: G_PKG_NAME,
1233: '_Pvt'
1234: );
1235: APP_EXCEPTION.RAISE_EXCEPTION;
1236: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1237: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1238: (
1239: l_api_name,
1240: G_PKG_NAME,
1241: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1237: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1238: (
1239: l_api_name,
1240: G_PKG_NAME,
1241: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1242: x_msg_count,
1243: x_msg_data,
1244: '_Pvt'
1245: );