[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_billingtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_billingtype_rec.txn_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'txn_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_billingtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_billingtype_rec.txn_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'txn_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_billingtype_rec.coverage_txn_group_id IS NULL
31: THEN
25: p_billingtype_rec.txn_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'txn_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_billingtype_rec.coverage_txn_group_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_txn_group_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_billingtype_rec.coverage_txn_group_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_txn_group_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billingtype_rec.last_update_date IS NULL
36: THEN
30: p_billingtype_rec.coverage_txn_group_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_txn_group_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billingtype_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_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billingtype_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_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billingtype_rec.last_updated_by IS NULL
41: THEN
35: p_billingtype_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_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billingtype_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_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billingtype_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_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billingtype_rec.creation_date IS NULL
46: THEN
40: p_billingtype_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_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billingtype_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_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billingtype_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_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billingtype_rec.created_by IS NULL
51: THEN
45: p_billingtype_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_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billingtype_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_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billingtype_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 cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
102: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
103: CLOSE cs_coverage_txn_groups_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TXN_GROUP_ID');
106: RAISE item_not_found_error;
107: END IF;
108: END IF;
109: IF (p_billingtype_rec.TXN_BILLING_TYPE_ID IS NOT NULL)
112: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
113: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
114: CLOSE cs_txn_billing_types_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TXN_BILLING_TYPE_ID');
117: RAISE item_not_found_error;
118: END IF;
119: END IF;
120: RETURN (l_return_status);
197: END migrate;
198: PROCEDURE insert_row
199: (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
202: p_validation_level IN NUMBER,
203: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
204: x_return_status OUT VARCHAR2,
205: x_msg_count OUT NUMBER,
199: (
200: p_api_version IN NUMBER,
201: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
202: p_validation_level IN NUMBER,
203: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
204: x_return_status OUT VARCHAR2,
205: x_msg_count OUT NUMBER,
206: x_msg_data OUT VARCHAR2,
207: p_billingtype_rec IN BillingType_Rec_Type := G_MISS_BILLINGTYPE_REC,
212: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
213: l_billingtype_rec BillingType_Rec_Type;
214: l_def_billingtype_rec BillingType_Rec_Type;
215: BEGIN
216: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
217: G_PKG_NAME,
218: l_api_version,
219: p_api_version,
220: p_init_msg_list,
319: l_def_billingtype_rec.object_version_number);
320: -- Set OUT values
321: x_coverage_billing_type_id := l_def_billingtype_rec.coverage_billing_type_id;
322: x_object_version_number := l_def_billingtype_rec.OBJECT_VERSION_NUMBER;
323: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
327: (
322: x_object_version_number := l_def_billingtype_rec.OBJECT_VERSION_NUMBER;
323: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
327: (
328: l_api_name,
329: G_PKG_NAME,
330: 'FND_API.G_RET_STS_ERROR',
333: '_Pvt'
334: );
335: APP_EXCEPTION.RAISE_EXCEPTION;
336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
337: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
338: (
339: l_api_name,
340: G_PKG_NAME,
341: 'FND_API.G_RET_STS_UNEXP_ERROR',
343: x_msg_data,
344: '_Pvt'
345: );
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
348: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,
344: '_Pvt'
345: );
346: APP_EXCEPTION.RAISE_EXCEPTION;
347: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
348: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,
352: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
348: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
349: (
350: l_api_name,
351: G_PKG_NAME,
352: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
353: x_msg_count,
354: x_msg_data,
355: '_Pvt'
356: );
358: END insert_row;
359: PROCEDURE insert_row
360: (
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
363: p_validation_level IN NUMBER,
364: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
365: x_return_status OUT VARCHAR2,
366: x_msg_count OUT NUMBER,
360: (
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
363: p_validation_level IN NUMBER,
364: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
365: x_return_status OUT VARCHAR2,
366: x_msg_count OUT NUMBER,
367: x_msg_data OUT VARCHAR2,
368: p_max_percent_per_use IN NUMBER := NULL,
397: l_api_version CONSTANT NUMBER := 1;
398: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
399: l_billingtype_rec BillingType_Rec_Type;
400: BEGIN
401: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
402: G_PKG_NAME,
403: l_api_version,
404: p_api_version,
405: p_init_msg_list,
447: l_billingtype_rec,
448: x_coverage_billing_type_id,
449: x_object_version_number
450: );
451: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
455: (
450: );
451: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
455: (
456: l_api_name,
457: G_PKG_NAME,
458: 'FND_API.G_RET_STS_ERROR',
461: '_Pvt'
462: );
463: APP_EXCEPTION.RAISE_EXCEPTION;
464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
465: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
466: (
467: l_api_name,
468: G_PKG_NAME,
469: 'FND_API.G_RET_STS_UNEXP_ERROR',
471: x_msg_data,
472: '_Pvt'
473: );
474: APP_EXCEPTION.RAISE_EXCEPTION;
475: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
476: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,
472: '_Pvt'
473: );
474: APP_EXCEPTION.RAISE_EXCEPTION;
475: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
476: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,
480: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
476: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
477: (
478: l_api_name,
479: G_PKG_NAME,
480: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
481: x_msg_count,
482: x_msg_data,
483: '_Pvt'
484: );
486: END insert_row;
487: Procedure lock_row
488: (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
491: p_validation_level IN NUMBER,
492: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
493: x_return_status OUT VARCHAR2,
494: x_msg_count OUT NUMBER,
488: (
489: p_api_version IN NUMBER,
490: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
491: p_validation_level IN NUMBER,
492: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
493: x_return_status OUT VARCHAR2,
494: x_msg_count OUT NUMBER,
495: x_msg_data OUT VARCHAR2,
496: p_coverage_billing_type_id IN NUMBER,
518: lc_object_version_number CS_COV_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
519: l_row_notfound BOOLEAN := FALSE;
520: lc_row_notfound BOOLEAN := FALSE;
521: BEGIN
522: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
523: G_PKG_NAME,
524: l_api_version,
525: p_api_version,
526: p_init_msg_list,
540: WHEN E_Resource_Busy THEN
541: IF (lock_csr%ISOPEN) THEN
542: CLOSE lock_csr;
543: END IF;
544: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
545: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
546: END;
547:
548: IF ( l_row_notfound ) THEN
551: lc_row_notfound := lchk_csr%NOTFOUND;
552: CLOSE lchk_csr;
553: END IF;
554: IF (lc_row_notfound) THEN
555: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
556: RAISE FND_API.G_EXC_ERROR;
557: ELSIF lc_object_version_number > p_object_version_number THEN
558: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
559: RAISE FND_API.G_EXC_ERROR;
554: IF (lc_row_notfound) THEN
555: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
556: RAISE FND_API.G_EXC_ERROR;
557: ELSIF lc_object_version_number > p_object_version_number THEN
558: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF lc_object_version_number <> p_object_version_number THEN
561: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
562: RAISE FND_API.G_EXC_ERROR;
557: ELSIF lc_object_version_number > p_object_version_number THEN
558: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
559: RAISE FND_API.G_EXC_ERROR;
560: ELSIF lc_object_version_number <> p_object_version_number THEN
561: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF lc_object_version_number = -1 THEN
564: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
565: RAISE FND_API.G_EXC_ERROR;
560: ELSIF lc_object_version_number <> p_object_version_number THEN
561: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
562: RAISE FND_API.G_EXC_ERROR;
563: ELSIF lc_object_version_number = -1 THEN
564: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
568: EXCEPTION
563: ELSIF lc_object_version_number = -1 THEN
564: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
565: RAISE FND_API.G_EXC_ERROR;
566: END IF;
567: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
568: EXCEPTION
569: WHEN FND_API.G_EXC_ERROR THEN
570: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
571: (
566: END IF;
567: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
568: EXCEPTION
569: WHEN FND_API.G_EXC_ERROR THEN
570: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
571: (
572: l_api_name,
573: G_PKG_NAME,
574: 'FND_API.G_RET_STS_ERROR',
577: '_Pvt'
578: );
579: APP_EXCEPTION.RAISE_EXCEPTION;
580: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
581: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
582: (
583: l_api_name,
584: G_PKG_NAME,
585: 'FND_API.G_RET_STS_UNEXP_ERROR',
587: x_msg_data,
588: '_Pvt'
589: );
590: APP_EXCEPTION.RAISE_EXCEPTION;
591: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
592: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
593: (
594: l_api_name,
595: G_PKG_NAME,
588: '_Pvt'
589: );
590: APP_EXCEPTION.RAISE_EXCEPTION;
591: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
592: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
593: (
594: l_api_name,
595: G_PKG_NAME,
596: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
592: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
593: (
594: l_api_name,
595: G_PKG_NAME,
596: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
597: x_msg_count,
598: x_msg_data,
599: '_Pvt'
600: );
602: END lock_row;
603: Procedure update_row
604: (
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
607: p_validation_level IN NUMBER,
608: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
609: x_return_status OUT VARCHAR2,
610: x_msg_count OUT NUMBER,
604: (
605: p_api_version IN NUMBER,
606: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
607: p_validation_level IN NUMBER,
608: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
609: x_return_status OUT VARCHAR2,
610: x_msg_count OUT NUMBER,
611: x_msg_data OUT VARCHAR2,
612: p_billingtype_val_rec IN BillingType_Val_Rec_Type := G_MISS_BILLINGTYPE_VAL_REC,
636: CLOSE cs_coverage_billing_1_csr;
637: IF (l_row_notfound) THEN
638: l_return_status := FND_API.G_RET_STS_ERROR;
639: END IF;
640: IF (x_billingtype_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
641: THEN
642: x_billingtype_rec.coverage_billing_type_id := l_cs_coverage_billing_types_pk.coverage_billing_type_id;
643: END IF;
644: IF (x_billingtype_rec.max_percent_per_use = TAPI_DEV_KIT.G_MISS_NUM)
640: IF (x_billingtype_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
641: THEN
642: x_billingtype_rec.coverage_billing_type_id := l_cs_coverage_billing_types_pk.coverage_billing_type_id;
643: END IF;
644: IF (x_billingtype_rec.max_percent_per_use = TAPI_DEV_KIT.G_MISS_NUM)
645: THEN
646: x_billingtype_rec.max_percent_per_use := l_cs_coverage_billing_types_pk.max_percent_per_use;
647: END IF;
648: IF (x_billingtype_rec.max_amount_per_use = TAPI_DEV_KIT.G_MISS_NUM)
644: IF (x_billingtype_rec.max_percent_per_use = TAPI_DEV_KIT.G_MISS_NUM)
645: THEN
646: x_billingtype_rec.max_percent_per_use := l_cs_coverage_billing_types_pk.max_percent_per_use;
647: END IF;
648: IF (x_billingtype_rec.max_amount_per_use = TAPI_DEV_KIT.G_MISS_NUM)
649: THEN
650: x_billingtype_rec.max_amount_per_use := l_cs_coverage_billing_types_pk.max_amount_per_use;
651: END IF;
652: IF (x_billingtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
648: IF (x_billingtype_rec.max_amount_per_use = TAPI_DEV_KIT.G_MISS_NUM)
649: THEN
650: x_billingtype_rec.max_amount_per_use := l_cs_coverage_billing_types_pk.max_amount_per_use;
651: END IF;
652: IF (x_billingtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
653: THEN
654: x_billingtype_rec.txn_billing_type_id := l_cs_coverage_billing_types_pk.txn_billing_type_id;
655: END IF;
656: IF (x_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
652: IF (x_billingtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
653: THEN
654: x_billingtype_rec.txn_billing_type_id := l_cs_coverage_billing_types_pk.txn_billing_type_id;
655: END IF;
656: IF (x_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
657: THEN
658: x_billingtype_rec.coverage_txn_group_id := l_cs_coverage_billing_types_pk.coverage_txn_group_id;
659: END IF;
660: IF (x_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
656: IF (x_billingtype_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
657: THEN
658: x_billingtype_rec.coverage_txn_group_id := l_cs_coverage_billing_types_pk.coverage_txn_group_id;
659: END IF;
660: IF (x_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
661: THEN
662: x_billingtype_rec.last_update_date := l_cs_coverage_billing_types_pk.last_update_date;
663: END IF;
664: IF (x_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
660: IF (x_billingtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
661: THEN
662: x_billingtype_rec.last_update_date := l_cs_coverage_billing_types_pk.last_update_date;
663: END IF;
664: IF (x_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
665: THEN
666: x_billingtype_rec.last_updated_by := l_cs_coverage_billing_types_pk.last_updated_by;
667: END IF;
668: IF (x_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
664: IF (x_billingtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
665: THEN
666: x_billingtype_rec.last_updated_by := l_cs_coverage_billing_types_pk.last_updated_by;
667: END IF;
668: IF (x_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
669: THEN
670: x_billingtype_rec.creation_date := l_cs_coverage_billing_types_pk.creation_date;
671: END IF;
672: IF (x_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
668: IF (x_billingtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
669: THEN
670: x_billingtype_rec.creation_date := l_cs_coverage_billing_types_pk.creation_date;
671: END IF;
672: IF (x_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
673: THEN
674: x_billingtype_rec.created_by := l_cs_coverage_billing_types_pk.created_by;
675: END IF;
676: IF (x_billingtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
672: IF (x_billingtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
673: THEN
674: x_billingtype_rec.created_by := l_cs_coverage_billing_types_pk.created_by;
675: END IF;
676: IF (x_billingtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
677: THEN
678: x_billingtype_rec.last_update_login := l_cs_coverage_billing_types_pk.last_update_login;
679: END IF;
680: IF (x_billingtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
676: IF (x_billingtype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
677: THEN
678: x_billingtype_rec.last_update_login := l_cs_coverage_billing_types_pk.last_update_login;
679: END IF;
680: IF (x_billingtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
681: THEN
682: x_billingtype_rec.attribute1 := l_cs_coverage_billing_types_pk.attribute1;
683: END IF;
684: IF (x_billingtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
680: IF (x_billingtype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
681: THEN
682: x_billingtype_rec.attribute1 := l_cs_coverage_billing_types_pk.attribute1;
683: END IF;
684: IF (x_billingtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
685: THEN
686: x_billingtype_rec.attribute2 := l_cs_coverage_billing_types_pk.attribute2;
687: END IF;
688: IF (x_billingtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
684: IF (x_billingtype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
685: THEN
686: x_billingtype_rec.attribute2 := l_cs_coverage_billing_types_pk.attribute2;
687: END IF;
688: IF (x_billingtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
689: THEN
690: x_billingtype_rec.attribute3 := l_cs_coverage_billing_types_pk.attribute3;
691: END IF;
692: IF (x_billingtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
688: IF (x_billingtype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
689: THEN
690: x_billingtype_rec.attribute3 := l_cs_coverage_billing_types_pk.attribute3;
691: END IF;
692: IF (x_billingtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
693: THEN
694: x_billingtype_rec.attribute4 := l_cs_coverage_billing_types_pk.attribute4;
695: END IF;
696: IF (x_billingtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
692: IF (x_billingtype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
693: THEN
694: x_billingtype_rec.attribute4 := l_cs_coverage_billing_types_pk.attribute4;
695: END IF;
696: IF (x_billingtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_billingtype_rec.attribute5 := l_cs_coverage_billing_types_pk.attribute5;
699: END IF;
700: IF (x_billingtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
696: IF (x_billingtype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_billingtype_rec.attribute5 := l_cs_coverage_billing_types_pk.attribute5;
699: END IF;
700: IF (x_billingtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
701: THEN
702: x_billingtype_rec.attribute6 := l_cs_coverage_billing_types_pk.attribute6;
703: END IF;
704: IF (x_billingtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
700: IF (x_billingtype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
701: THEN
702: x_billingtype_rec.attribute6 := l_cs_coverage_billing_types_pk.attribute6;
703: END IF;
704: IF (x_billingtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_billingtype_rec.attribute7 := l_cs_coverage_billing_types_pk.attribute7;
707: END IF;
708: IF (x_billingtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
704: IF (x_billingtype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_billingtype_rec.attribute7 := l_cs_coverage_billing_types_pk.attribute7;
707: END IF;
708: IF (x_billingtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_billingtype_rec.attribute8 := l_cs_coverage_billing_types_pk.attribute8;
711: END IF;
712: IF (x_billingtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
708: IF (x_billingtype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_billingtype_rec.attribute8 := l_cs_coverage_billing_types_pk.attribute8;
711: END IF;
712: IF (x_billingtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
713: THEN
714: x_billingtype_rec.attribute9 := l_cs_coverage_billing_types_pk.attribute9;
715: END IF;
716: IF (x_billingtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
712: IF (x_billingtype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
713: THEN
714: x_billingtype_rec.attribute9 := l_cs_coverage_billing_types_pk.attribute9;
715: END IF;
716: IF (x_billingtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
717: THEN
718: x_billingtype_rec.attribute10 := l_cs_coverage_billing_types_pk.attribute10;
719: END IF;
720: IF (x_billingtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
716: IF (x_billingtype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
717: THEN
718: x_billingtype_rec.attribute10 := l_cs_coverage_billing_types_pk.attribute10;
719: END IF;
720: IF (x_billingtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
721: THEN
722: x_billingtype_rec.attribute11 := l_cs_coverage_billing_types_pk.attribute11;
723: END IF;
724: IF (x_billingtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
720: IF (x_billingtype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
721: THEN
722: x_billingtype_rec.attribute11 := l_cs_coverage_billing_types_pk.attribute11;
723: END IF;
724: IF (x_billingtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
725: THEN
726: x_billingtype_rec.attribute12 := l_cs_coverage_billing_types_pk.attribute12;
727: END IF;
728: IF (x_billingtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
724: IF (x_billingtype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
725: THEN
726: x_billingtype_rec.attribute12 := l_cs_coverage_billing_types_pk.attribute12;
727: END IF;
728: IF (x_billingtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
729: THEN
730: x_billingtype_rec.attribute13 := l_cs_coverage_billing_types_pk.attribute13;
731: END IF;
732: IF (x_billingtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
728: IF (x_billingtype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
729: THEN
730: x_billingtype_rec.attribute13 := l_cs_coverage_billing_types_pk.attribute13;
731: END IF;
732: IF (x_billingtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
733: THEN
734: x_billingtype_rec.attribute14 := l_cs_coverage_billing_types_pk.attribute14;
735: END IF;
736: IF (x_billingtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
732: IF (x_billingtype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
733: THEN
734: x_billingtype_rec.attribute14 := l_cs_coverage_billing_types_pk.attribute14;
735: END IF;
736: IF (x_billingtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
737: THEN
738: x_billingtype_rec.attribute15 := l_cs_coverage_billing_types_pk.attribute15;
739: END IF;
740: IF (x_billingtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
736: IF (x_billingtype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
737: THEN
738: x_billingtype_rec.attribute15 := l_cs_coverage_billing_types_pk.attribute15;
739: END IF;
740: IF (x_billingtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
741: THEN
742: x_billingtype_rec.context := l_cs_coverage_billing_types_pk.context;
743: END IF;
744: IF (x_billingtype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
740: IF (x_billingtype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
741: THEN
742: x_billingtype_rec.context := l_cs_coverage_billing_types_pk.context;
743: END IF;
744: IF (x_billingtype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
745: THEN
746: x_billingtype_rec.object_version_number := l_cs_coverage_billing_types_pk.object_version_number;
747: END IF;
748: RETURN(l_return_status);
747: END IF;
748: RETURN(l_return_status);
749: END populate_new_record;
750: BEGIN
751: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
752: G_PKG_NAME,
753: l_api_version,
754: p_api_version,
755: p_init_msg_list,
832: WHERE
833: COVERAGE_BILLING_TYPE_ID = l_def_billingtype_rec.coverage_billing_type_id
834: ;
835: x_object_version_number := l_def_billingtype_rec.OBJECT_VERSION_NUMBER;
836: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
835: x_object_version_number := l_def_billingtype_rec.OBJECT_VERSION_NUMBER;
836: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
837: EXCEPTION
838: WHEN FND_API.G_EXC_ERROR THEN
839: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'FND_API.G_RET_STS_ERROR',
846: '_Pvt'
847: );
848: APP_EXCEPTION.RAISE_EXCEPTION;
849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
850: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
851: (
852: l_api_name,
853: G_PKG_NAME,
854: 'FND_API.G_RET_STS_UNEXP_ERROR',
856: x_msg_data,
857: '_Pvt'
858: );
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
861: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
862: (
863: l_api_name,
864: G_PKG_NAME,
857: '_Pvt'
858: );
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
861: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
862: (
863: l_api_name,
864: G_PKG_NAME,
865: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
861: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
862: (
863: l_api_name,
864: G_PKG_NAME,
865: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
866: x_msg_count,
867: x_msg_data,
868: '_Pvt'
869: );
871: END update_row;
872: Procedure update_row
873: (
874: p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
876: p_validation_level IN NUMBER,
877: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
878: x_return_status OUT VARCHAR2,
879: x_msg_count OUT NUMBER,
873: (
874: p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
876: p_validation_level IN NUMBER,
877: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
878: x_return_status OUT VARCHAR2,
879: x_msg_count OUT NUMBER,
880: x_msg_data OUT VARCHAR2,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
878: x_return_status OUT VARCHAR2,
879: x_msg_count OUT NUMBER,
880: x_msg_data OUT VARCHAR2,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: x_return_status OUT VARCHAR2,
879: x_msg_count OUT NUMBER,
880: x_msg_data OUT VARCHAR2,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
879: x_msg_count OUT NUMBER,
880: x_msg_data OUT VARCHAR2,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: x_msg_data OUT VARCHAR2,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
900: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
901: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
909: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
902: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
909: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
910: l_api_version CONSTANT NUMBER := 1;
903: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
908: x_object_version_number OUT NUMBER) IS
909: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
910: l_api_version CONSTANT NUMBER := 1;
911: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
910: l_api_version CONSTANT NUMBER := 1;
911: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
912: l_billingtype_rec BillingType_Val_Rec_Type;
913: BEGIN
914: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
915: G_PKG_NAME,
916: l_api_version,
917: p_api_version,
918: p_init_msg_list,
960: x_msg_data,
961: l_billingtype_rec,
962: x_object_version_number
963: );
964: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
967: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
968: (
963: );
964: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
967: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
968: (
969: l_api_name,
970: G_PKG_NAME,
971: 'FND_API.G_RET_STS_ERROR',
974: '_Pvt'
975: );
976: APP_EXCEPTION.RAISE_EXCEPTION;
977: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
978: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
979: (
980: l_api_name,
981: G_PKG_NAME,
982: 'FND_API.G_RET_STS_UNEXP_ERROR',
984: x_msg_data,
985: '_Pvt'
986: );
987: APP_EXCEPTION.RAISE_EXCEPTION;
988: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
989: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,
985: '_Pvt'
986: );
987: APP_EXCEPTION.RAISE_EXCEPTION;
988: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
989: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,
993: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
989: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
990: (
991: l_api_name,
992: G_PKG_NAME,
993: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
994: x_msg_count,
995: x_msg_data,
996: '_Pvt'
997: );
999: END update_row;
1000: Procedure delete_row
1001: (
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1004: p_validation_level IN NUMBER,
1005: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1006: x_return_status OUT VARCHAR2,
1007: x_msg_count OUT NUMBER,
1001: (
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1004: p_validation_level IN NUMBER,
1005: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1006: x_return_status OUT VARCHAR2,
1007: x_msg_count OUT NUMBER,
1008: x_msg_data OUT VARCHAR2,
1009: p_coverage_billing_type_id IN NUMBER) IS
1010: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1011: l_api_version CONSTANT NUMBER := 1;
1012: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1013: BEGIN
1014: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1015: G_PKG_NAME,
1016: l_api_version,
1017: p_api_version,
1018: p_init_msg_list,
1026: DELETE FROM CS_COV_BILLING_TYPES
1027: WHERE
1028: COVERAGE_BILLING_TYPE_ID = p_coverage_billing_type_id
1029: ;
1030: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1034: (
1029: ;
1030: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1031: EXCEPTION
1032: WHEN FND_API.G_EXC_ERROR THEN
1033: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1034: (
1035: l_api_name,
1036: G_PKG_NAME,
1037: 'FND_API.G_RET_STS_ERROR',
1040: '_Pvt'
1041: );
1042: APP_EXCEPTION.RAISE_EXCEPTION;
1043: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1044: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1045: (
1046: l_api_name,
1047: G_PKG_NAME,
1048: 'FND_API.G_RET_STS_UNEXP_ERROR',
1050: x_msg_data,
1051: '_Pvt'
1052: );
1053: APP_EXCEPTION.RAISE_EXCEPTION;
1054: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1055: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1056: (
1057: l_api_name,
1058: G_PKG_NAME,
1051: '_Pvt'
1052: );
1053: APP_EXCEPTION.RAISE_EXCEPTION;
1054: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1055: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1056: (
1057: l_api_name,
1058: G_PKG_NAME,
1059: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1055: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1056: (
1057: l_api_name,
1058: G_PKG_NAME,
1059: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1060: x_msg_count,
1061: x_msg_data,
1062: '_Pvt'
1063: );
1065: END delete_row;
1066: PROCEDURE validate_row
1067: (
1068: p_api_version IN NUMBER,
1069: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1070: p_validation_level IN NUMBER,
1071: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1072: x_return_status OUT VARCHAR2,
1073: x_msg_count OUT NUMBER,
1067: (
1068: p_api_version IN NUMBER,
1069: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1070: p_validation_level IN NUMBER,
1071: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1072: x_return_status OUT VARCHAR2,
1073: x_msg_count OUT NUMBER,
1074: x_msg_data OUT VARCHAR2,
1075: p_billingtype_val_rec IN BillingType_Val_Rec_Type := G_MISS_BILLINGTYPE_VAL_REC) IS
1078: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1079: l_billingtype_rec BillingType_Rec_Type;
1080: l_def_billingtype_rec BillingType_Rec_Type;
1081: BEGIN
1082: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1083: G_PKG_NAME,
1084: l_api_version,
1085: p_api_version,
1086: p_init_msg_list,
1112: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: END IF;
1116: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (
1115: END IF;
1116: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'FND_API.G_RET_STS_ERROR',
1126: '_Pvt'
1127: );
1128: APP_EXCEPTION.RAISE_EXCEPTION;
1129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1130: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1131: (
1132: l_api_name,
1133: G_PKG_NAME,
1134: 'FND_API.G_RET_STS_UNEXP_ERROR',
1136: x_msg_data,
1137: '_Pvt'
1138: );
1139: APP_EXCEPTION.RAISE_EXCEPTION;
1140: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1141: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1137: '_Pvt'
1138: );
1139: APP_EXCEPTION.RAISE_EXCEPTION;
1140: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1141: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1145: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1141: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1142: (
1143: l_api_name,
1144: G_PKG_NAME,
1145: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1146: x_msg_count,
1147: x_msg_data,
1148: '_Pvt'
1149: );
1151: END validate_row;
1152: PROCEDURE validate_row
1153: (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1156: p_validation_level IN NUMBER,
1157: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1158: x_return_status OUT VARCHAR2,
1159: x_msg_count OUT NUMBER,
1153: (
1154: p_api_version IN NUMBER,
1155: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1156: p_validation_level IN NUMBER,
1157: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1158: x_return_status OUT VARCHAR2,
1159: x_msg_count OUT NUMBER,
1160: x_msg_data OUT VARCHAR2,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1158: x_return_status OUT VARCHAR2,
1159: x_msg_count OUT NUMBER,
1160: x_msg_data OUT VARCHAR2,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: x_return_status OUT VARCHAR2,
1159: x_msg_count OUT NUMBER,
1160: x_msg_data OUT VARCHAR2,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1159: x_msg_count OUT NUMBER,
1160: x_msg_data OUT VARCHAR2,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: x_msg_data OUT VARCHAR2,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_max_percent_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_max_amount_per_use IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_txn_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_last_update_date IN CS_COV_BILLING_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_creation_date IN CS_COV_BILLING_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute1 IN CS_COV_BILLING_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute2 IN CS_COV_BILLING_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute3 IN CS_COV_BILLING_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute4 IN CS_COV_BILLING_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute5 IN CS_COV_BILLING_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute6 IN CS_COV_BILLING_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute7 IN CS_COV_BILLING_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute8 IN CS_COV_BILLING_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute9 IN CS_COV_BILLING_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1180: p_attribute10 IN CS_COV_BILLING_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1181: p_attribute11 IN CS_COV_BILLING_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1189: l_api_version CONSTANT NUMBER := 1;
1182: p_attribute12 IN CS_COV_BILLING_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1189: l_api_version CONSTANT NUMBER := 1;
1190: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1183: p_attribute13 IN CS_COV_BILLING_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute14 IN CS_COV_BILLING_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute15 IN CS_COV_BILLING_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_context IN CS_COV_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1188: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1189: l_api_version CONSTANT NUMBER := 1;
1190: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1191: l_billingtype_rec BillingType_Val_Rec_Type;
1189: l_api_version CONSTANT NUMBER := 1;
1190: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1191: l_billingtype_rec BillingType_Val_Rec_Type;
1192: BEGIN
1193: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1194: G_PKG_NAME,
1195: l_api_version,
1196: p_api_version,
1197: p_init_msg_list,
1238: x_msg_count,
1239: x_msg_data,
1240: l_billingtype_rec
1241: );
1242: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1246: (
1241: );
1242: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1243: EXCEPTION
1244: WHEN FND_API.G_EXC_ERROR THEN
1245: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1246: (
1247: l_api_name,
1248: G_PKG_NAME,
1249: 'FND_API.G_RET_STS_ERROR',
1252: '_Pvt'
1253: );
1254: APP_EXCEPTION.RAISE_EXCEPTION;
1255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1256: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1257: (
1258: l_api_name,
1259: G_PKG_NAME,
1260: 'FND_API.G_RET_STS_UNEXP_ERROR',
1262: x_msg_data,
1263: '_Pvt'
1264: );
1265: APP_EXCEPTION.RAISE_EXCEPTION;
1266: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1267: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1263: '_Pvt'
1264: );
1265: APP_EXCEPTION.RAISE_EXCEPTION;
1266: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1267: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1267: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1268: (
1269: l_api_name,
1270: G_PKG_NAME,
1271: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1272: x_msg_count,
1273: x_msg_data,
1274: '_Pvt'
1275: );