[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_billrate_rec.coverage_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_billrate_rec.coverage_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_billrate_rec.rate_type_code IS NULL
31: THEN
25: p_billrate_rec.coverage_billing_type_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_billing_type_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_billrate_rec.rate_type_code IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rate_type_code');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_billrate_rec.rate_type_code IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rate_type_code');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billrate_rec.last_update_date IS NULL
36: THEN
30: p_billrate_rec.rate_type_code IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rate_type_code');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billrate_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_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billrate_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_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billrate_rec.last_updated_by IS NULL
41: THEN
35: p_billrate_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_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billrate_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_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billrate_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_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billrate_rec.creation_date IS NULL
46: THEN
40: p_billrate_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_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billrate_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_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billrate_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_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billrate_rec.created_by IS NULL
51: THEN
45: p_billrate_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_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billrate_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_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billrate_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;
96: FETCH cs_coverage_billing_1_csr INTO l_cs_coverage_billing_types_pk;
97: l_row_notfound := cs_coverage_billing_1_csr%NOTFOUND;
98: CLOSE cs_coverage_billing_1_csr;
99: IF (l_row_notfound) THEN
100: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_BILLING_TYPE_ID');
101: RAISE item_not_found_error;
102: END IF;
103: END IF;
104: RETURN (l_return_status);
183: END migrate;
184: PROCEDURE insert_row
185: (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
188: p_validation_level IN NUMBER,
189: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
190: x_return_status OUT VARCHAR2,
191: x_msg_count OUT NUMBER,
185: (
186: p_api_version IN NUMBER,
187: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
188: p_validation_level IN NUMBER,
189: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
190: x_return_status OUT VARCHAR2,
191: x_msg_count OUT NUMBER,
192: x_msg_data OUT VARCHAR2,
193: p_billrate_rec IN BillRate_Rec_Type := G_MISS_BILLRATE_REC,
198: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
199: l_billrate_rec BillRate_Rec_Type;
200: l_def_billrate_rec BillRate_Rec_Type;
201: BEGIN
202: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
203: G_PKG_NAME,
204: l_api_version,
205: p_api_version,
206: p_init_msg_list,
307: l_def_billrate_rec.object_version_number);
308: -- Set OUT values
309: x_coverage_bill_rate_id := l_def_billrate_rec.coverage_bill_rate_id;
310: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
311: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
315: (
310: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
311: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
315: (
316: l_api_name,
317: G_PKG_NAME,
318: 'FND_API.G_RET_STS_ERROR',
321: '_Pvt'
322: );
323: APP_EXCEPTION.RAISE_EXCEPTION;
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
326: (
327: l_api_name,
328: G_PKG_NAME,
329: 'FND_API.G_RET_STS_UNEXP_ERROR',
331: x_msg_data,
332: '_Pvt'
333: );
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
336: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
337: (
338: l_api_name,
339: G_PKG_NAME,
332: '_Pvt'
333: );
334: APP_EXCEPTION.RAISE_EXCEPTION;
335: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
336: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
337: (
338: l_api_name,
339: G_PKG_NAME,
340: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
336: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
337: (
338: l_api_name,
339: G_PKG_NAME,
340: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
341: x_msg_count,
342: x_msg_data,
343: '_Pvt'
344: );
346: END insert_row;
347: PROCEDURE insert_row
348: (
349: p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
351: p_validation_level IN NUMBER,
352: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
353: x_return_status OUT VARCHAR2,
354: x_msg_count OUT NUMBER,
348: (
349: p_api_version IN NUMBER,
350: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
351: p_validation_level IN NUMBER,
352: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
353: x_return_status OUT VARCHAR2,
354: x_msg_count OUT NUMBER,
355: x_msg_data OUT VARCHAR2,
356: p_coverage_billing_type_id IN NUMBER := NULL,
386: l_api_version CONSTANT NUMBER := 1;
387: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
388: l_billrate_rec BillRate_Rec_Type;
389: BEGIN
390: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
391: G_PKG_NAME,
392: l_api_version,
393: p_api_version,
394: p_init_msg_list,
437: l_billrate_rec,
438: x_coverage_bill_rate_id,
439: x_object_version_number
440: );
441: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
445: (
440: );
441: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
445: (
446: l_api_name,
447: G_PKG_NAME,
448: 'FND_API.G_RET_STS_ERROR',
451: '_Pvt'
452: );
453: APP_EXCEPTION.RAISE_EXCEPTION;
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
456: (
457: l_api_name,
458: G_PKG_NAME,
459: 'FND_API.G_RET_STS_UNEXP_ERROR',
461: x_msg_data,
462: '_Pvt'
463: );
464: APP_EXCEPTION.RAISE_EXCEPTION;
465: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
466: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
467: (
468: l_api_name,
469: G_PKG_NAME,
462: '_Pvt'
463: );
464: APP_EXCEPTION.RAISE_EXCEPTION;
465: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
466: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
467: (
468: l_api_name,
469: G_PKG_NAME,
470: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
466: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
467: (
468: l_api_name,
469: G_PKG_NAME,
470: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
471: x_msg_count,
472: x_msg_data,
473: '_Pvt'
474: );
476: END insert_row;
477: Procedure lock_row
478: (
479: p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
481: p_validation_level IN NUMBER,
482: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
483: x_return_status OUT VARCHAR2,
484: x_msg_count OUT NUMBER,
478: (
479: p_api_version IN NUMBER,
480: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
481: p_validation_level IN NUMBER,
482: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
483: x_return_status OUT VARCHAR2,
484: x_msg_count OUT NUMBER,
485: x_msg_data OUT VARCHAR2,
486: p_coverage_bill_rate_id IN NUMBER,
508: lc_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
509: l_row_notfound BOOLEAN := FALSE;
510: lc_row_notfound BOOLEAN := FALSE;
511: BEGIN
512: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
513: G_PKG_NAME,
514: l_api_version,
515: p_api_version,
516: p_init_msg_list,
530: WHEN E_Resource_Busy THEN
531: IF (lock_csr%ISOPEN) THEN
532: CLOSE lock_csr;
533: END IF;
534: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
535: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
536: END;
537:
538: IF ( l_row_notfound ) THEN
541: lc_row_notfound := lchk_csr%NOTFOUND;
542: CLOSE lchk_csr;
543: END IF;
544: IF (lc_row_notfound) THEN
545: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
546: RAISE FND_API.G_EXC_ERROR;
547: ELSIF lc_object_version_number > p_object_version_number THEN
548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
544: IF (lc_row_notfound) THEN
545: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
546: RAISE FND_API.G_EXC_ERROR;
547: ELSIF lc_object_version_number > p_object_version_number THEN
548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN
551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
547: ELSIF lc_object_version_number > p_object_version_number THEN
548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN
551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF lc_object_version_number = -1 THEN
554: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
555: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN
551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF lc_object_version_number = -1 THEN
554: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
558: EXCEPTION
553: ELSIF lc_object_version_number = -1 THEN
554: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
561: (
556: END IF;
557: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,
564: 'FND_API.G_RET_STS_ERROR',
567: '_Pvt'
568: );
569: APP_EXCEPTION.RAISE_EXCEPTION;
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
572: (
573: l_api_name,
574: G_PKG_NAME,
575: 'FND_API.G_RET_STS_UNEXP_ERROR',
577: x_msg_data,
578: '_Pvt'
579: );
580: APP_EXCEPTION.RAISE_EXCEPTION;
581: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
582: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
583: (
584: l_api_name,
585: G_PKG_NAME,
578: '_Pvt'
579: );
580: APP_EXCEPTION.RAISE_EXCEPTION;
581: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
582: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
583: (
584: l_api_name,
585: G_PKG_NAME,
586: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
582: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
583: (
584: l_api_name,
585: G_PKG_NAME,
586: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
587: x_msg_count,
588: x_msg_data,
589: '_Pvt'
590: );
592: END lock_row;
593: Procedure update_row
594: (
595: p_api_version IN NUMBER,
596: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
597: p_validation_level IN NUMBER,
598: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
599: x_return_status OUT VARCHAR2,
600: x_msg_count OUT NUMBER,
594: (
595: p_api_version IN NUMBER,
596: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
597: p_validation_level IN NUMBER,
598: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
599: x_return_status OUT VARCHAR2,
600: x_msg_count OUT NUMBER,
601: x_msg_data OUT VARCHAR2,
602: p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC,
626: CLOSE cs_coverage_bill_rates_pk_csr;
627: IF (l_row_notfound) THEN
628: l_return_status := FND_API.G_RET_STS_ERROR;
629: END IF;
630: IF (x_billrate_rec.coverage_bill_rate_id = TAPI_DEV_KIT.G_MISS_NUM)
631: THEN
632: x_billrate_rec.coverage_bill_rate_id := l_cs_coverage_bill_rates_pk.coverage_bill_rate_id;
633: END IF;
634: IF (x_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
630: IF (x_billrate_rec.coverage_bill_rate_id = TAPI_DEV_KIT.G_MISS_NUM)
631: THEN
632: x_billrate_rec.coverage_bill_rate_id := l_cs_coverage_bill_rates_pk.coverage_bill_rate_id;
633: END IF;
634: IF (x_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
635: THEN
636: x_billrate_rec.coverage_billing_type_id := l_cs_coverage_bill_rates_pk.coverage_billing_type_id;
637: END IF;
638: IF (x_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR)
634: IF (x_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
635: THEN
636: x_billrate_rec.coverage_billing_type_id := l_cs_coverage_bill_rates_pk.coverage_billing_type_id;
637: END IF;
638: IF (x_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR)
639: THEN
640: x_billrate_rec.rate_type_code := l_cs_coverage_bill_rates_pk.rate_type_code;
641: END IF;
642: IF (x_billrate_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)
638: IF (x_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR)
639: THEN
640: x_billrate_rec.rate_type_code := l_cs_coverage_bill_rates_pk.rate_type_code;
641: END IF;
642: IF (x_billrate_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)
643: THEN
644: x_billrate_rec.unit_of_measure_code := l_cs_coverage_bill_rates_pk.unit_of_measure_code;
645: END IF;
646: IF (x_billrate_rec.flat_rate = TAPI_DEV_KIT.G_MISS_NUM)
642: IF (x_billrate_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)
643: THEN
644: x_billrate_rec.unit_of_measure_code := l_cs_coverage_bill_rates_pk.unit_of_measure_code;
645: END IF;
646: IF (x_billrate_rec.flat_rate = TAPI_DEV_KIT.G_MISS_NUM)
647: THEN
648: x_billrate_rec.flat_rate := l_cs_coverage_bill_rates_pk.flat_rate;
649: END IF;
650: IF (x_billrate_rec.percent_rate = TAPI_DEV_KIT.G_MISS_NUM)
646: IF (x_billrate_rec.flat_rate = TAPI_DEV_KIT.G_MISS_NUM)
647: THEN
648: x_billrate_rec.flat_rate := l_cs_coverage_bill_rates_pk.flat_rate;
649: END IF;
650: IF (x_billrate_rec.percent_rate = TAPI_DEV_KIT.G_MISS_NUM)
651: THEN
652: x_billrate_rec.percent_rate := l_cs_coverage_bill_rates_pk.percent_rate;
653: END IF;
654: IF (x_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
650: IF (x_billrate_rec.percent_rate = TAPI_DEV_KIT.G_MISS_NUM)
651: THEN
652: x_billrate_rec.percent_rate := l_cs_coverage_bill_rates_pk.percent_rate;
653: END IF;
654: IF (x_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
655: THEN
656: x_billrate_rec.last_update_date := l_cs_coverage_bill_rates_pk.last_update_date;
657: END IF;
658: IF (x_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
654: IF (x_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
655: THEN
656: x_billrate_rec.last_update_date := l_cs_coverage_bill_rates_pk.last_update_date;
657: END IF;
658: IF (x_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
659: THEN
660: x_billrate_rec.last_updated_by := l_cs_coverage_bill_rates_pk.last_updated_by;
661: END IF;
662: IF (x_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
658: IF (x_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
659: THEN
660: x_billrate_rec.last_updated_by := l_cs_coverage_bill_rates_pk.last_updated_by;
661: END IF;
662: IF (x_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
663: THEN
664: x_billrate_rec.creation_date := l_cs_coverage_bill_rates_pk.creation_date;
665: END IF;
666: IF (x_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
662: IF (x_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
663: THEN
664: x_billrate_rec.creation_date := l_cs_coverage_bill_rates_pk.creation_date;
665: END IF;
666: IF (x_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
667: THEN
668: x_billrate_rec.created_by := l_cs_coverage_bill_rates_pk.created_by;
669: END IF;
670: IF (x_billrate_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
666: IF (x_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
667: THEN
668: x_billrate_rec.created_by := l_cs_coverage_bill_rates_pk.created_by;
669: END IF;
670: IF (x_billrate_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
671: THEN
672: x_billrate_rec.last_update_login := l_cs_coverage_bill_rates_pk.last_update_login;
673: END IF;
674: IF (x_billrate_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
670: IF (x_billrate_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
671: THEN
672: x_billrate_rec.last_update_login := l_cs_coverage_bill_rates_pk.last_update_login;
673: END IF;
674: IF (x_billrate_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
675: THEN
676: x_billrate_rec.attribute1 := l_cs_coverage_bill_rates_pk.attribute1;
677: END IF;
678: IF (x_billrate_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
674: IF (x_billrate_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
675: THEN
676: x_billrate_rec.attribute1 := l_cs_coverage_bill_rates_pk.attribute1;
677: END IF;
678: IF (x_billrate_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
679: THEN
680: x_billrate_rec.attribute2 := l_cs_coverage_bill_rates_pk.attribute2;
681: END IF;
682: IF (x_billrate_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
678: IF (x_billrate_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
679: THEN
680: x_billrate_rec.attribute2 := l_cs_coverage_bill_rates_pk.attribute2;
681: END IF;
682: IF (x_billrate_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
683: THEN
684: x_billrate_rec.attribute3 := l_cs_coverage_bill_rates_pk.attribute3;
685: END IF;
686: IF (x_billrate_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
682: IF (x_billrate_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
683: THEN
684: x_billrate_rec.attribute3 := l_cs_coverage_bill_rates_pk.attribute3;
685: END IF;
686: IF (x_billrate_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
687: THEN
688: x_billrate_rec.attribute4 := l_cs_coverage_bill_rates_pk.attribute4;
689: END IF;
690: IF (x_billrate_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
686: IF (x_billrate_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
687: THEN
688: x_billrate_rec.attribute4 := l_cs_coverage_bill_rates_pk.attribute4;
689: END IF;
690: IF (x_billrate_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
691: THEN
692: x_billrate_rec.attribute5 := l_cs_coverage_bill_rates_pk.attribute5;
693: END IF;
694: IF (x_billrate_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
690: IF (x_billrate_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
691: THEN
692: x_billrate_rec.attribute5 := l_cs_coverage_bill_rates_pk.attribute5;
693: END IF;
694: IF (x_billrate_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
695: THEN
696: x_billrate_rec.attribute6 := l_cs_coverage_bill_rates_pk.attribute6;
697: END IF;
698: IF (x_billrate_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
694: IF (x_billrate_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
695: THEN
696: x_billrate_rec.attribute6 := l_cs_coverage_bill_rates_pk.attribute6;
697: END IF;
698: IF (x_billrate_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
699: THEN
700: x_billrate_rec.attribute7 := l_cs_coverage_bill_rates_pk.attribute7;
701: END IF;
702: IF (x_billrate_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
698: IF (x_billrate_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
699: THEN
700: x_billrate_rec.attribute7 := l_cs_coverage_bill_rates_pk.attribute7;
701: END IF;
702: IF (x_billrate_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
703: THEN
704: x_billrate_rec.attribute8 := l_cs_coverage_bill_rates_pk.attribute8;
705: END IF;
706: IF (x_billrate_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
702: IF (x_billrate_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
703: THEN
704: x_billrate_rec.attribute8 := l_cs_coverage_bill_rates_pk.attribute8;
705: END IF;
706: IF (x_billrate_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
707: THEN
708: x_billrate_rec.attribute9 := l_cs_coverage_bill_rates_pk.attribute9;
709: END IF;
710: IF (x_billrate_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
706: IF (x_billrate_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
707: THEN
708: x_billrate_rec.attribute9 := l_cs_coverage_bill_rates_pk.attribute9;
709: END IF;
710: IF (x_billrate_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
711: THEN
712: x_billrate_rec.attribute10 := l_cs_coverage_bill_rates_pk.attribute10;
713: END IF;
714: IF (x_billrate_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
710: IF (x_billrate_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
711: THEN
712: x_billrate_rec.attribute10 := l_cs_coverage_bill_rates_pk.attribute10;
713: END IF;
714: IF (x_billrate_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
715: THEN
716: x_billrate_rec.attribute11 := l_cs_coverage_bill_rates_pk.attribute11;
717: END IF;
718: IF (x_billrate_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
714: IF (x_billrate_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
715: THEN
716: x_billrate_rec.attribute11 := l_cs_coverage_bill_rates_pk.attribute11;
717: END IF;
718: IF (x_billrate_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
719: THEN
720: x_billrate_rec.attribute12 := l_cs_coverage_bill_rates_pk.attribute12;
721: END IF;
722: IF (x_billrate_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
718: IF (x_billrate_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
719: THEN
720: x_billrate_rec.attribute12 := l_cs_coverage_bill_rates_pk.attribute12;
721: END IF;
722: IF (x_billrate_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
723: THEN
724: x_billrate_rec.attribute13 := l_cs_coverage_bill_rates_pk.attribute13;
725: END IF;
726: IF (x_billrate_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
722: IF (x_billrate_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
723: THEN
724: x_billrate_rec.attribute13 := l_cs_coverage_bill_rates_pk.attribute13;
725: END IF;
726: IF (x_billrate_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
727: THEN
728: x_billrate_rec.attribute14 := l_cs_coverage_bill_rates_pk.attribute14;
729: END IF;
730: IF (x_billrate_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
726: IF (x_billrate_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
727: THEN
728: x_billrate_rec.attribute14 := l_cs_coverage_bill_rates_pk.attribute14;
729: END IF;
730: IF (x_billrate_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
731: THEN
732: x_billrate_rec.attribute15 := l_cs_coverage_bill_rates_pk.attribute15;
733: END IF;
734: IF (x_billrate_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
730: IF (x_billrate_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
731: THEN
732: x_billrate_rec.attribute15 := l_cs_coverage_bill_rates_pk.attribute15;
733: END IF;
734: IF (x_billrate_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
735: THEN
736: x_billrate_rec.context := l_cs_coverage_bill_rates_pk.context;
737: END IF;
738: IF (x_billrate_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
734: IF (x_billrate_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
735: THEN
736: x_billrate_rec.context := l_cs_coverage_bill_rates_pk.context;
737: END IF;
738: IF (x_billrate_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
739: THEN
740: x_billrate_rec.object_version_number := l_cs_coverage_bill_rates_pk.object_version_number;
741: END IF;
742: RETURN(l_return_status);
741: END IF;
742: RETURN(l_return_status);
743: END populate_new_record;
744: BEGIN
745: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
746: G_PKG_NAME,
747: l_api_version,
748: p_api_version,
749: p_init_msg_list,
827: WHERE
828: COVERAGE_BILL_RATE_ID = l_def_billrate_rec.coverage_bill_rate_id
829: ;
830: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
831: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
835: (
830: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
831: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
835: (
836: l_api_name,
837: G_PKG_NAME,
838: 'FND_API.G_RET_STS_ERROR',
841: '_Pvt'
842: );
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,
849: 'FND_API.G_RET_STS_UNEXP_ERROR',
851: x_msg_data,
852: '_Pvt'
853: );
854: APP_EXCEPTION.RAISE_EXCEPTION;
855: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
856: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,
852: '_Pvt'
853: );
854: APP_EXCEPTION.RAISE_EXCEPTION;
855: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
856: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,
860: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
856: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
857: (
858: l_api_name,
859: G_PKG_NAME,
860: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
861: x_msg_count,
862: x_msg_data,
863: '_Pvt'
864: );
866: END update_row;
867: Procedure update_row
868: (
869: p_api_version IN NUMBER,
870: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
871: p_validation_level IN NUMBER,
872: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
873: x_return_status OUT VARCHAR2,
874: x_msg_count OUT NUMBER,
868: (
869: p_api_version IN NUMBER,
870: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
871: p_validation_level IN NUMBER,
872: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
873: x_return_status OUT VARCHAR2,
874: x_msg_count OUT NUMBER,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
873: x_return_status OUT VARCHAR2,
874: x_msg_count OUT NUMBER,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
873: x_return_status OUT VARCHAR2,
874: x_msg_count OUT NUMBER,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
874: x_msg_count OUT NUMBER,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
875: x_msg_data OUT VARCHAR2,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
876: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
877: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
878: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
897: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
898: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
906: l_api_version CONSTANT NUMBER := 1;
899: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
906: l_api_version CONSTANT NUMBER := 1;
907: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
906: l_api_version CONSTANT NUMBER := 1;
907: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
908: l_billrate_rec BillRate_Val_Rec_Type;
909: BEGIN
910: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
911: G_PKG_NAME,
912: l_api_version,
913: p_api_version,
914: p_init_msg_list,
957: x_msg_data,
958: l_billrate_rec,
959: x_object_version_number
960: );
961: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
965: (
960: );
961: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'FND_API.G_RET_STS_ERROR',
971: '_Pvt'
972: );
973: APP_EXCEPTION.RAISE_EXCEPTION;
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'FND_API.G_RET_STS_UNEXP_ERROR',
981: x_msg_data,
982: '_Pvt'
983: );
984: APP_EXCEPTION.RAISE_EXCEPTION;
985: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
986: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
982: '_Pvt'
983: );
984: APP_EXCEPTION.RAISE_EXCEPTION;
985: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
986: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
990: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
986: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
987: (
988: l_api_name,
989: G_PKG_NAME,
990: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
991: x_msg_count,
992: x_msg_data,
993: '_Pvt'
994: );
996: END update_row;
997: Procedure delete_row
998: (
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1001: p_validation_level IN NUMBER,
1002: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1003: x_return_status OUT VARCHAR2,
1004: x_msg_count OUT NUMBER,
998: (
999: p_api_version IN NUMBER,
1000: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1001: p_validation_level IN NUMBER,
1002: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1003: x_return_status OUT VARCHAR2,
1004: x_msg_count OUT NUMBER,
1005: x_msg_data OUT VARCHAR2,
1006: p_coverage_bill_rate_id IN NUMBER) IS
1007: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1008: l_api_version CONSTANT NUMBER := 1;
1009: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1010: BEGIN
1011: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1012: G_PKG_NAME,
1013: l_api_version,
1014: p_api_version,
1015: p_init_msg_list,
1023: DELETE FROM CS_COV_BILL_RATES
1024: WHERE
1025: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
1026: ;
1027: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1031: (
1026: ;
1027: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1031: (
1032: l_api_name,
1033: G_PKG_NAME,
1034: 'FND_API.G_RET_STS_ERROR',
1037: '_Pvt'
1038: );
1039: APP_EXCEPTION.RAISE_EXCEPTION;
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'FND_API.G_RET_STS_UNEXP_ERROR',
1047: x_msg_data,
1048: '_Pvt'
1049: );
1050: APP_EXCEPTION.RAISE_EXCEPTION;
1051: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1052: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1053: (
1054: l_api_name,
1055: G_PKG_NAME,
1048: '_Pvt'
1049: );
1050: APP_EXCEPTION.RAISE_EXCEPTION;
1051: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1052: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1053: (
1054: l_api_name,
1055: G_PKG_NAME,
1056: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1052: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1053: (
1054: l_api_name,
1055: G_PKG_NAME,
1056: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1057: x_msg_count,
1058: x_msg_data,
1059: '_Pvt'
1060: );
1062: END delete_row;
1063: PROCEDURE validate_row
1064: (
1065: p_api_version IN NUMBER,
1066: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1067: p_validation_level IN NUMBER,
1068: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1069: x_return_status OUT VARCHAR2,
1070: x_msg_count OUT NUMBER,
1064: (
1065: p_api_version IN NUMBER,
1066: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1067: p_validation_level IN NUMBER,
1068: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1069: x_return_status OUT VARCHAR2,
1070: x_msg_count OUT NUMBER,
1071: x_msg_data OUT VARCHAR2,
1072: p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC) IS
1075: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1076: l_billrate_rec BillRate_Rec_Type;
1077: l_def_billrate_rec BillRate_Rec_Type;
1078: BEGIN
1079: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1080: G_PKG_NAME,
1081: l_api_version,
1082: p_api_version,
1083: p_init_msg_list,
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: END IF;
1113: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1112: END IF;
1113: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'FND_API.G_RET_STS_ERROR',
1123: '_Pvt'
1124: );
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'FND_API.G_RET_STS_UNEXP_ERROR',
1133: x_msg_data,
1134: '_Pvt'
1135: );
1136: APP_EXCEPTION.RAISE_EXCEPTION;
1137: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1138: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1139: (
1140: l_api_name,
1141: G_PKG_NAME,
1134: '_Pvt'
1135: );
1136: APP_EXCEPTION.RAISE_EXCEPTION;
1137: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1138: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1139: (
1140: l_api_name,
1141: G_PKG_NAME,
1142: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1138: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1139: (
1140: l_api_name,
1141: G_PKG_NAME,
1142: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1143: x_msg_count,
1144: x_msg_data,
1145: '_Pvt'
1146: );
1148: END validate_row;
1149: PROCEDURE validate_row
1150: (
1151: p_api_version IN NUMBER,
1152: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1153: p_validation_level IN NUMBER,
1154: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1155: x_return_status OUT VARCHAR2,
1156: x_msg_count OUT NUMBER,
1150: (
1151: p_api_version IN NUMBER,
1152: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1153: p_validation_level IN NUMBER,
1154: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1155: x_return_status OUT VARCHAR2,
1156: x_msg_count OUT NUMBER,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1155: x_return_status OUT VARCHAR2,
1156: x_msg_count OUT NUMBER,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1155: x_return_status OUT VARCHAR2,
1156: x_msg_count OUT NUMBER,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: x_msg_count OUT NUMBER,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: x_msg_data OUT VARCHAR2,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1158: p_coverage_bill_rate_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1159: p_coverage_billing_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_rate_type_code IN CS_COV_BILL_RATES.RATE_TYPE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_unit_of_measure_code IN CS_COV_BILL_RATES.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_flat_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_percent_rate IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_last_update_date IN CS_COV_BILL_RATES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_creation_date IN CS_COV_BILL_RATES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute1 IN CS_COV_BILL_RATES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute2 IN CS_COV_BILL_RATES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute3 IN CS_COV_BILL_RATES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute4 IN CS_COV_BILL_RATES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute5 IN CS_COV_BILL_RATES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute6 IN CS_COV_BILL_RATES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute7 IN CS_COV_BILL_RATES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute8 IN CS_COV_BILL_RATES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute9 IN CS_COV_BILL_RATES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1178: p_attribute10 IN CS_COV_BILL_RATES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1179: p_attribute11 IN CS_COV_BILL_RATES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;
1180: p_attribute12 IN CS_COV_BILL_RATES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1181: p_attribute13 IN CS_COV_BILL_RATES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute14 IN CS_COV_BILL_RATES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute15 IN CS_COV_BILL_RATES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1189: l_billrate_rec BillRate_Val_Rec_Type;
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1189: l_billrate_rec BillRate_Val_Rec_Type;
1190: BEGIN
1191: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1192: G_PKG_NAME,
1193: l_api_version,
1194: p_api_version,
1195: p_init_msg_list,
1237: x_msg_count,
1238: x_msg_data,
1239: l_billrate_rec
1240: );
1241: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1245: (
1240: );
1241: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_ERROR THEN
1244: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'FND_API.G_RET_STS_ERROR',
1251: '_Pvt'
1252: );
1253: APP_EXCEPTION.RAISE_EXCEPTION;
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,
1259: 'FND_API.G_RET_STS_UNEXP_ERROR',
1261: x_msg_data,
1262: '_Pvt'
1263: );
1264: APP_EXCEPTION.RAISE_EXCEPTION;
1265: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1266: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1267: (
1268: l_api_name,
1269: G_PKG_NAME,
1262: '_Pvt'
1263: );
1264: APP_EXCEPTION.RAISE_EXCEPTION;
1265: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1266: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1267: (
1268: l_api_name,
1269: G_PKG_NAME,
1270: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1266: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1267: (
1268: l_api_name,
1269: G_PKG_NAME,
1270: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1271: x_msg_count,
1272: x_msg_data,
1273: '_Pvt'
1274: );