[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_coverage_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_coverage_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_coverage_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_coverage_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_coverage_rec.template_flag IS NULL
31: THEN
25: p_coverage_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_coverage_rec.template_flag IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'template_flag');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_coverage_rec.template_flag IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'template_flag');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coverage_rec.created_by IS NULL
36: THEN
30: p_coverage_rec.template_flag IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'template_flag');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coverage_rec.created_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coverage_rec.created_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coverage_rec.creation_date IS NULL
41: THEN
35: p_coverage_rec.created_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coverage_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coverage_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coverage_rec.last_update_date IS NULL
46: THEN
40: p_coverage_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coverage_rec.last_update_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coverage_rec.last_update_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coverage_rec.last_updated_by IS NULL
51: THEN
45: p_coverage_rec.last_update_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coverage_rec.last_updated_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coverage_rec.last_updated_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_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 cc_pk_csr INTO l_cc_pk;
97: l_row_notfound := cc_pk_csr%NOTFOUND;
98: CLOSE cc_pk_csr;
99: IF (l_row_notfound) THEN
100: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_TEMPLATE_ID');
101: RAISE item_not_found_error;
102: END IF;
103: END IF;
104: RETURN (l_return_status);
239: END migrate;
240: PROCEDURE insert_row
241: (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
244: p_validation_level IN NUMBER,
245: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
246: x_return_status OUT VARCHAR2,
247: x_msg_count OUT NUMBER,
241: (
242: p_api_version IN NUMBER,
243: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
244: p_validation_level IN NUMBER,
245: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
246: x_return_status OUT VARCHAR2,
247: x_msg_count OUT NUMBER,
248: x_msg_data OUT VARCHAR2,
249: p_coverage_rec IN Coverage_Rec_Type := G_MISS_COVERAGE_REC,
254: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
255: l_coverage_rec Coverage_Rec_Type;
256: l_def_coverage_rec Coverage_Rec_Type;
257: BEGIN
258: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
259: G_PKG_NAME,
260: l_api_version,
261: p_api_version,
262: p_init_msg_list,
419: l_def_coverage_rec.object_version_number);
420: -- Set OUT values
421: x_coverage_id := l_def_coverage_rec.coverage_id;
422: x_object_version_number := l_def_coverage_rec.OBJECT_VERSION_NUMBER;
423: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
427: (
422: x_object_version_number := l_def_coverage_rec.OBJECT_VERSION_NUMBER;
423: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
424: EXCEPTION
425: WHEN FND_API.G_EXC_ERROR THEN
426: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
427: (
428: l_api_name,
429: G_PKG_NAME,
430: 'FND_API.G_RET_STS_ERROR',
433: '_Pvt'
434: );
435: APP_EXCEPTION.RAISE_EXCEPTION;
436: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
437: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
438: (
439: l_api_name,
440: G_PKG_NAME,
441: 'FND_API.G_RET_STS_UNEXP_ERROR',
443: x_msg_data,
444: '_Pvt'
445: );
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
448: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
449: (
450: l_api_name,
451: G_PKG_NAME,
444: '_Pvt'
445: );
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
448: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
449: (
450: l_api_name,
451: G_PKG_NAME,
452: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
448: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
449: (
450: l_api_name,
451: G_PKG_NAME,
452: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
453: x_msg_count,
454: x_msg_data,
455: '_Pvt'
456: );
458: END insert_row;
459: PROCEDURE insert_row
460: (
461: p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
463: p_validation_level IN NUMBER,
464: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
465: x_return_status OUT VARCHAR2,
466: x_msg_count OUT NUMBER,
460: (
461: p_api_version IN NUMBER,
462: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
463: p_validation_level IN NUMBER,
464: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
465: x_return_status OUT VARCHAR2,
466: x_msg_count OUT NUMBER,
467: x_msg_data OUT VARCHAR2,
468: p_coverage_template_id IN NUMBER := NULL,
526: l_api_version CONSTANT NUMBER := 1;
527: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
528: l_coverage_rec Coverage_Rec_Type;
529: BEGIN
530: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
531: G_PKG_NAME,
532: l_api_version,
533: p_api_version,
534: p_init_msg_list,
605: l_coverage_rec,
606: x_coverage_id,
607: x_object_version_number
608: );
609: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN
612: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
613: (
608: );
609: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
610: EXCEPTION
611: WHEN FND_API.G_EXC_ERROR THEN
612: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
613: (
614: l_api_name,
615: G_PKG_NAME,
616: 'FND_API.G_RET_STS_ERROR',
619: '_Pvt'
620: );
621: APP_EXCEPTION.RAISE_EXCEPTION;
622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
623: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
624: (
625: l_api_name,
626: G_PKG_NAME,
627: 'FND_API.G_RET_STS_UNEXP_ERROR',
629: x_msg_data,
630: '_Pvt'
631: );
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
634: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
635: (
636: l_api_name,
637: G_PKG_NAME,
630: '_Pvt'
631: );
632: APP_EXCEPTION.RAISE_EXCEPTION;
633: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
634: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
635: (
636: l_api_name,
637: G_PKG_NAME,
638: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
634: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
635: (
636: l_api_name,
637: G_PKG_NAME,
638: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
639: x_msg_count,
640: x_msg_data,
641: '_Pvt'
642: );
644: END insert_row;
645: Procedure lock_row
646: (
647: p_api_version IN NUMBER,
648: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
649: p_validation_level IN NUMBER,
650: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
651: x_return_status OUT VARCHAR2,
652: x_msg_count OUT NUMBER,
646: (
647: p_api_version IN NUMBER,
648: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
649: p_validation_level IN NUMBER,
650: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
651: x_return_status OUT VARCHAR2,
652: x_msg_count OUT NUMBER,
653: x_msg_data OUT VARCHAR2,
654: p_coverage_id IN NUMBER,
676: lc_object_version_number CS_COVERAGES.OBJECT_VERSION_NUMBER%TYPE;
677: l_row_notfound BOOLEAN := FALSE;
678: lc_row_notfound BOOLEAN := FALSE;
679: BEGIN
680: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
681: G_PKG_NAME,
682: l_api_version,
683: p_api_version,
684: p_init_msg_list,
698: WHEN E_Resource_Busy THEN
699: IF (lock_csr%ISOPEN) THEN
700: CLOSE lock_csr;
701: END IF;
702: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
703: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
704: END;
705:
706: IF ( l_row_notfound ) THEN
709: lc_row_notfound := lchk_csr%NOTFOUND;
710: CLOSE lchk_csr;
711: END IF;
712: IF (lc_row_notfound) THEN
713: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF lc_object_version_number > p_object_version_number THEN
716: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
717: RAISE FND_API.G_EXC_ERROR;
712: IF (lc_row_notfound) THEN
713: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
714: RAISE FND_API.G_EXC_ERROR;
715: ELSIF lc_object_version_number > p_object_version_number THEN
716: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
717: RAISE FND_API.G_EXC_ERROR;
718: ELSIF lc_object_version_number <> p_object_version_number THEN
719: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
720: RAISE FND_API.G_EXC_ERROR;
715: ELSIF lc_object_version_number > p_object_version_number THEN
716: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
717: RAISE FND_API.G_EXC_ERROR;
718: ELSIF lc_object_version_number <> p_object_version_number THEN
719: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF lc_object_version_number = -1 THEN
722: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
723: RAISE FND_API.G_EXC_ERROR;
718: ELSIF lc_object_version_number <> p_object_version_number THEN
719: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
720: RAISE FND_API.G_EXC_ERROR;
721: ELSIF lc_object_version_number = -1 THEN
722: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
726: EXCEPTION
721: ELSIF lc_object_version_number = -1 THEN
722: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
723: RAISE FND_API.G_EXC_ERROR;
724: END IF;
725: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
729: (
724: END IF;
725: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
726: EXCEPTION
727: WHEN FND_API.G_EXC_ERROR THEN
728: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
729: (
730: l_api_name,
731: G_PKG_NAME,
732: 'FND_API.G_RET_STS_ERROR',
735: '_Pvt'
736: );
737: APP_EXCEPTION.RAISE_EXCEPTION;
738: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
739: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
740: (
741: l_api_name,
742: G_PKG_NAME,
743: 'FND_API.G_RET_STS_UNEXP_ERROR',
745: x_msg_data,
746: '_Pvt'
747: );
748: APP_EXCEPTION.RAISE_EXCEPTION;
749: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
750: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,
746: '_Pvt'
747: );
748: APP_EXCEPTION.RAISE_EXCEPTION;
749: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
750: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,
754: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
750: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
751: (
752: l_api_name,
753: G_PKG_NAME,
754: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
755: x_msg_count,
756: x_msg_data,
757: '_Pvt'
758: );
760: END lock_row;
761: Procedure update_row
762: (
763: p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
765: p_validation_level IN NUMBER,
766: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
767: x_return_status OUT VARCHAR2,
768: x_msg_count OUT NUMBER,
762: (
763: p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
765: p_validation_level IN NUMBER,
766: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
767: x_return_status OUT VARCHAR2,
768: x_msg_count OUT NUMBER,
769: x_msg_data OUT VARCHAR2,
770: p_coverage_val_rec IN Coverage_Val_Rec_Type := G_MISS_COVERAGE_VAL_REC,
794: CLOSE cc_pk_csr;
795: IF (l_row_notfound) THEN
796: l_return_status := FND_API.G_RET_STS_ERROR;
797: END IF;
798: IF (x_coverage_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_coverage_rec.coverage_id := l_cc_pk.coverage_id;
801: END IF;
802: IF (x_coverage_rec.coverage_template_id = TAPI_DEV_KIT.G_MISS_NUM)
798: IF (x_coverage_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_coverage_rec.coverage_id := l_cc_pk.coverage_id;
801: END IF;
802: IF (x_coverage_rec.coverage_template_id = TAPI_DEV_KIT.G_MISS_NUM)
803: THEN
804: x_coverage_rec.coverage_template_id := l_cc_pk.coverage_template_id;
805: END IF;
806: IF (x_coverage_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
802: IF (x_coverage_rec.coverage_template_id = TAPI_DEV_KIT.G_MISS_NUM)
803: THEN
804: x_coverage_rec.coverage_template_id := l_cc_pk.coverage_template_id;
805: END IF;
806: IF (x_coverage_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
807: THEN
808: x_coverage_rec.name := l_cc_pk.name;
809: END IF;
810: IF (x_coverage_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
806: IF (x_coverage_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
807: THEN
808: x_coverage_rec.name := l_cc_pk.name;
809: END IF;
810: IF (x_coverage_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
811: THEN
812: x_coverage_rec.description := l_cc_pk.description;
813: END IF;
814: IF (x_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR)
810: IF (x_coverage_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
811: THEN
812: x_coverage_rec.description := l_cc_pk.description;
813: END IF;
814: IF (x_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR)
815: THEN
816: x_coverage_rec.template_flag := l_cc_pk.template_flag;
817: END IF;
818: IF (x_coverage_rec.renewal_terms = TAPI_DEV_KIT.G_MISS_CHAR)
814: IF (x_coverage_rec.template_flag = TAPI_DEV_KIT.G_MISS_CHAR)
815: THEN
816: x_coverage_rec.template_flag := l_cc_pk.template_flag;
817: END IF;
818: IF (x_coverage_rec.renewal_terms = TAPI_DEV_KIT.G_MISS_CHAR)
819: THEN
820: x_coverage_rec.renewal_terms := l_cc_pk.renewal_terms;
821: END IF;
822: IF (x_coverage_rec.termination_terms = TAPI_DEV_KIT.G_MISS_CHAR)
818: IF (x_coverage_rec.renewal_terms = TAPI_DEV_KIT.G_MISS_CHAR)
819: THEN
820: x_coverage_rec.renewal_terms := l_cc_pk.renewal_terms;
821: END IF;
822: IF (x_coverage_rec.termination_terms = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_coverage_rec.termination_terms := l_cc_pk.termination_terms;
825: END IF;
826: IF (x_coverage_rec.max_support_coverage_amt = TAPI_DEV_KIT.G_MISS_NUM)
822: IF (x_coverage_rec.termination_terms = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_coverage_rec.termination_terms := l_cc_pk.termination_terms;
825: END IF;
826: IF (x_coverage_rec.max_support_coverage_amt = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_coverage_rec.max_support_coverage_amt := l_cc_pk.max_support_coverage_amt;
829: END IF;
830: IF (x_coverage_rec.exception_coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
826: IF (x_coverage_rec.max_support_coverage_amt = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_coverage_rec.max_support_coverage_amt := l_cc_pk.max_support_coverage_amt;
829: END IF;
830: IF (x_coverage_rec.exception_coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_coverage_rec.exception_coverage_id := l_cc_pk.exception_coverage_id;
833: END IF;
834: IF (x_coverage_rec.time_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
830: IF (x_coverage_rec.exception_coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_coverage_rec.exception_coverage_id := l_cc_pk.exception_coverage_id;
833: END IF;
834: IF (x_coverage_rec.time_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_coverage_rec.time_billable_percent := l_cc_pk.time_billable_percent;
837: END IF;
838: IF (x_coverage_rec.max_time_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
834: IF (x_coverage_rec.time_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_coverage_rec.time_billable_percent := l_cc_pk.time_billable_percent;
837: END IF;
838: IF (x_coverage_rec.max_time_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
839: THEN
840: x_coverage_rec.max_time_billable_amount := l_cc_pk.max_time_billable_amount;
841: END IF;
842: IF (x_coverage_rec.material_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
838: IF (x_coverage_rec.max_time_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
839: THEN
840: x_coverage_rec.max_time_billable_amount := l_cc_pk.max_time_billable_amount;
841: END IF;
842: IF (x_coverage_rec.material_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
843: THEN
844: x_coverage_rec.material_billable_percent := l_cc_pk.material_billable_percent;
845: END IF;
846: IF (x_coverage_rec.max_material_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
842: IF (x_coverage_rec.material_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
843: THEN
844: x_coverage_rec.material_billable_percent := l_cc_pk.material_billable_percent;
845: END IF;
846: IF (x_coverage_rec.max_material_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
847: THEN
848: x_coverage_rec.max_material_billable_amount := l_cc_pk.max_material_billable_amount;
849: END IF;
850: IF (x_coverage_rec.expense_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
846: IF (x_coverage_rec.max_material_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
847: THEN
848: x_coverage_rec.max_material_billable_amount := l_cc_pk.max_material_billable_amount;
849: END IF;
850: IF (x_coverage_rec.expense_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
851: THEN
852: x_coverage_rec.expense_billable_percent := l_cc_pk.expense_billable_percent;
853: END IF;
854: IF (x_coverage_rec.max_expense_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
850: IF (x_coverage_rec.expense_billable_percent = TAPI_DEV_KIT.G_MISS_NUM)
851: THEN
852: x_coverage_rec.expense_billable_percent := l_cc_pk.expense_billable_percent;
853: END IF;
854: IF (x_coverage_rec.max_expense_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
855: THEN
856: x_coverage_rec.max_expense_billable_amount := l_cc_pk.max_expense_billable_amount;
857: END IF;
858: IF (x_coverage_rec.max_coverage_amount = TAPI_DEV_KIT.G_MISS_NUM)
854: IF (x_coverage_rec.max_expense_billable_amount = TAPI_DEV_KIT.G_MISS_NUM)
855: THEN
856: x_coverage_rec.max_expense_billable_amount := l_cc_pk.max_expense_billable_amount;
857: END IF;
858: IF (x_coverage_rec.max_coverage_amount = TAPI_DEV_KIT.G_MISS_NUM)
859: THEN
860: x_coverage_rec.max_coverage_amount := l_cc_pk.max_coverage_amount;
861: END IF;
862: IF (x_coverage_rec.response_time_period_code = TAPI_DEV_KIT.G_MISS_CHAR)
858: IF (x_coverage_rec.max_coverage_amount = TAPI_DEV_KIT.G_MISS_NUM)
859: THEN
860: x_coverage_rec.max_coverage_amount := l_cc_pk.max_coverage_amount;
861: END IF;
862: IF (x_coverage_rec.response_time_period_code = TAPI_DEV_KIT.G_MISS_CHAR)
863: THEN
864: x_coverage_rec.response_time_period_code := l_cc_pk.response_time_period_code;
865: END IF;
866: IF (x_coverage_rec.response_time_value = TAPI_DEV_KIT.G_MISS_NUM)
862: IF (x_coverage_rec.response_time_period_code = TAPI_DEV_KIT.G_MISS_CHAR)
863: THEN
864: x_coverage_rec.response_time_period_code := l_cc_pk.response_time_period_code;
865: END IF;
866: IF (x_coverage_rec.response_time_value = TAPI_DEV_KIT.G_MISS_NUM)
867: THEN
868: x_coverage_rec.response_time_value := l_cc_pk.response_time_value;
869: END IF;
870: IF (x_coverage_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
866: IF (x_coverage_rec.response_time_value = TAPI_DEV_KIT.G_MISS_NUM)
867: THEN
868: x_coverage_rec.response_time_value := l_cc_pk.response_time_value;
869: END IF;
870: IF (x_coverage_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_coverage_rec.sunday_start_time := l_cc_pk.sunday_start_time;
873: END IF;
874: IF (x_coverage_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
870: IF (x_coverage_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_coverage_rec.sunday_start_time := l_cc_pk.sunday_start_time;
873: END IF;
874: IF (x_coverage_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_coverage_rec.sunday_end_time := l_cc_pk.sunday_end_time;
877: END IF;
878: IF (x_coverage_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
874: IF (x_coverage_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_coverage_rec.sunday_end_time := l_cc_pk.sunday_end_time;
877: END IF;
878: IF (x_coverage_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_coverage_rec.monday_start_time := l_cc_pk.monday_start_time;
881: END IF;
882: IF (x_coverage_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
878: IF (x_coverage_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_coverage_rec.monday_start_time := l_cc_pk.monday_start_time;
881: END IF;
882: IF (x_coverage_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_coverage_rec.monday_end_time := l_cc_pk.monday_end_time;
885: END IF;
886: IF (x_coverage_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
882: IF (x_coverage_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_coverage_rec.monday_end_time := l_cc_pk.monday_end_time;
885: END IF;
886: IF (x_coverage_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_coverage_rec.start_date_active := l_cc_pk.start_date_active;
889: END IF;
890: IF (x_coverage_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
886: IF (x_coverage_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_coverage_rec.start_date_active := l_cc_pk.start_date_active;
889: END IF;
890: IF (x_coverage_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_coverage_rec.tuesday_start_time := l_cc_pk.tuesday_start_time;
893: END IF;
894: IF (x_coverage_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
890: IF (x_coverage_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_coverage_rec.tuesday_start_time := l_cc_pk.tuesday_start_time;
893: END IF;
894: IF (x_coverage_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
895: THEN
896: x_coverage_rec.tuesday_end_time := l_cc_pk.tuesday_end_time;
897: END IF;
898: IF (x_coverage_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
894: IF (x_coverage_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
895: THEN
896: x_coverage_rec.tuesday_end_time := l_cc_pk.tuesday_end_time;
897: END IF;
898: IF (x_coverage_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
899: THEN
900: x_coverage_rec.end_date_active := l_cc_pk.end_date_active;
901: END IF;
902: IF (x_coverage_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
898: IF (x_coverage_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
899: THEN
900: x_coverage_rec.end_date_active := l_cc_pk.end_date_active;
901: END IF;
902: IF (x_coverage_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
903: THEN
904: x_coverage_rec.wednesday_start_time := l_cc_pk.wednesday_start_time;
905: END IF;
906: IF (x_coverage_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
902: IF (x_coverage_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
903: THEN
904: x_coverage_rec.wednesday_start_time := l_cc_pk.wednesday_start_time;
905: END IF;
906: IF (x_coverage_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_coverage_rec.wednesday_end_time := l_cc_pk.wednesday_end_time;
909: END IF;
910: IF (x_coverage_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
906: IF (x_coverage_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_coverage_rec.wednesday_end_time := l_cc_pk.wednesday_end_time;
909: END IF;
910: IF (x_coverage_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
911: THEN
912: x_coverage_rec.thursday_start_time := l_cc_pk.thursday_start_time;
913: END IF;
914: IF (x_coverage_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
910: IF (x_coverage_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
911: THEN
912: x_coverage_rec.thursday_start_time := l_cc_pk.thursday_start_time;
913: END IF;
914: IF (x_coverage_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_coverage_rec.thursday_end_time := l_cc_pk.thursday_end_time;
917: END IF;
918: IF (x_coverage_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
914: IF (x_coverage_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_coverage_rec.thursday_end_time := l_cc_pk.thursday_end_time;
917: END IF;
918: IF (x_coverage_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
919: THEN
920: x_coverage_rec.friday_start_time := l_cc_pk.friday_start_time;
921: END IF;
922: IF (x_coverage_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
918: IF (x_coverage_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
919: THEN
920: x_coverage_rec.friday_start_time := l_cc_pk.friday_start_time;
921: END IF;
922: IF (x_coverage_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
923: THEN
924: x_coverage_rec.friday_end_time := l_cc_pk.friday_end_time;
925: END IF;
926: IF (x_coverage_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
922: IF (x_coverage_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
923: THEN
924: x_coverage_rec.friday_end_time := l_cc_pk.friday_end_time;
925: END IF;
926: IF (x_coverage_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
927: THEN
928: x_coverage_rec.saturday_start_time := l_cc_pk.saturday_start_time;
929: END IF;
930: IF (x_coverage_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
926: IF (x_coverage_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
927: THEN
928: x_coverage_rec.saturday_start_time := l_cc_pk.saturday_start_time;
929: END IF;
930: IF (x_coverage_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
931: THEN
932: x_coverage_rec.saturday_end_time := l_cc_pk.saturday_end_time;
933: END IF;
934: IF (x_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
930: IF (x_coverage_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
931: THEN
932: x_coverage_rec.saturday_end_time := l_cc_pk.saturday_end_time;
933: END IF;
934: IF (x_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
935: THEN
936: x_coverage_rec.created_by := l_cc_pk.created_by;
937: END IF;
938: IF (x_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
934: IF (x_coverage_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
935: THEN
936: x_coverage_rec.created_by := l_cc_pk.created_by;
937: END IF;
938: IF (x_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
939: THEN
940: x_coverage_rec.creation_date := l_cc_pk.creation_date;
941: END IF;
942: IF (x_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
938: IF (x_coverage_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
939: THEN
940: x_coverage_rec.creation_date := l_cc_pk.creation_date;
941: END IF;
942: IF (x_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
943: THEN
944: x_coverage_rec.last_update_date := l_cc_pk.last_update_date;
945: END IF;
946: IF (x_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
942: IF (x_coverage_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
943: THEN
944: x_coverage_rec.last_update_date := l_cc_pk.last_update_date;
945: END IF;
946: IF (x_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
947: THEN
948: x_coverage_rec.last_updated_by := l_cc_pk.last_updated_by;
949: END IF;
950: IF (x_coverage_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
946: IF (x_coverage_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
947: THEN
948: x_coverage_rec.last_updated_by := l_cc_pk.last_updated_by;
949: END IF;
950: IF (x_coverage_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
951: THEN
952: x_coverage_rec.last_update_login := l_cc_pk.last_update_login;
953: END IF;
954: IF (x_coverage_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
950: IF (x_coverage_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
951: THEN
952: x_coverage_rec.last_update_login := l_cc_pk.last_update_login;
953: END IF;
954: IF (x_coverage_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_coverage_rec.attribute3 := l_cc_pk.attribute3;
957: END IF;
958: IF (x_coverage_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
954: IF (x_coverage_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_coverage_rec.attribute3 := l_cc_pk.attribute3;
957: END IF;
958: IF (x_coverage_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_coverage_rec.attribute1 := l_cc_pk.attribute1;
961: END IF;
962: IF (x_coverage_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
958: IF (x_coverage_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_coverage_rec.attribute1 := l_cc_pk.attribute1;
961: END IF;
962: IF (x_coverage_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_coverage_rec.attribute2 := l_cc_pk.attribute2;
965: END IF;
966: IF (x_coverage_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
962: IF (x_coverage_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_coverage_rec.attribute2 := l_cc_pk.attribute2;
965: END IF;
966: IF (x_coverage_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_coverage_rec.attribute4 := l_cc_pk.attribute4;
969: END IF;
970: IF (x_coverage_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
966: IF (x_coverage_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_coverage_rec.attribute4 := l_cc_pk.attribute4;
969: END IF;
970: IF (x_coverage_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_coverage_rec.attribute5 := l_cc_pk.attribute5;
973: END IF;
974: IF (x_coverage_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
970: IF (x_coverage_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_coverage_rec.attribute5 := l_cc_pk.attribute5;
973: END IF;
974: IF (x_coverage_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_coverage_rec.attribute6 := l_cc_pk.attribute6;
977: END IF;
978: IF (x_coverage_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
974: IF (x_coverage_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_coverage_rec.attribute6 := l_cc_pk.attribute6;
977: END IF;
978: IF (x_coverage_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_coverage_rec.attribute7 := l_cc_pk.attribute7;
981: END IF;
982: IF (x_coverage_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
978: IF (x_coverage_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_coverage_rec.attribute7 := l_cc_pk.attribute7;
981: END IF;
982: IF (x_coverage_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_coverage_rec.attribute8 := l_cc_pk.attribute8;
985: END IF;
986: IF (x_coverage_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
982: IF (x_coverage_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_coverage_rec.attribute8 := l_cc_pk.attribute8;
985: END IF;
986: IF (x_coverage_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_coverage_rec.attribute9 := l_cc_pk.attribute9;
989: END IF;
990: IF (x_coverage_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
986: IF (x_coverage_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_coverage_rec.attribute9 := l_cc_pk.attribute9;
989: END IF;
990: IF (x_coverage_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
991: THEN
992: x_coverage_rec.attribute10 := l_cc_pk.attribute10;
993: END IF;
994: IF (x_coverage_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
990: IF (x_coverage_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
991: THEN
992: x_coverage_rec.attribute10 := l_cc_pk.attribute10;
993: END IF;
994: IF (x_coverage_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
995: THEN
996: x_coverage_rec.attribute11 := l_cc_pk.attribute11;
997: END IF;
998: IF (x_coverage_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
994: IF (x_coverage_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
995: THEN
996: x_coverage_rec.attribute11 := l_cc_pk.attribute11;
997: END IF;
998: IF (x_coverage_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
999: THEN
1000: x_coverage_rec.attribute12 := l_cc_pk.attribute12;
1001: END IF;
1002: IF (x_coverage_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
998: IF (x_coverage_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
999: THEN
1000: x_coverage_rec.attribute12 := l_cc_pk.attribute12;
1001: END IF;
1002: IF (x_coverage_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
1003: THEN
1004: x_coverage_rec.attribute13 := l_cc_pk.attribute13;
1005: END IF;
1006: IF (x_coverage_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
1002: IF (x_coverage_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
1003: THEN
1004: x_coverage_rec.attribute13 := l_cc_pk.attribute13;
1005: END IF;
1006: IF (x_coverage_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
1007: THEN
1008: x_coverage_rec.attribute14 := l_cc_pk.attribute14;
1009: END IF;
1010: IF (x_coverage_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
1006: IF (x_coverage_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
1007: THEN
1008: x_coverage_rec.attribute14 := l_cc_pk.attribute14;
1009: END IF;
1010: IF (x_coverage_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
1011: THEN
1012: x_coverage_rec.attribute15 := l_cc_pk.attribute15;
1013: END IF;
1014: IF (x_coverage_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
1010: IF (x_coverage_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
1011: THEN
1012: x_coverage_rec.attribute15 := l_cc_pk.attribute15;
1013: END IF;
1014: IF (x_coverage_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
1015: THEN
1016: x_coverage_rec.context := l_cc_pk.context;
1017: END IF;
1018: IF (x_coverage_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
1014: IF (x_coverage_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
1015: THEN
1016: x_coverage_rec.context := l_cc_pk.context;
1017: END IF;
1018: IF (x_coverage_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
1019: THEN
1020: x_coverage_rec.object_version_number := l_cc_pk.object_version_number;
1021: END IF;
1022: RETURN(l_return_status);
1021: END IF;
1022: RETURN(l_return_status);
1023: END populate_new_record;
1024: BEGIN
1025: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1026: G_PKG_NAME,
1027: l_api_version,
1028: p_api_version,
1029: p_init_msg_list,
1135: WHERE
1136: COVERAGE_ID = l_def_coverage_rec.coverage_id
1137: ;
1138: x_object_version_number := l_def_coverage_rec.OBJECT_VERSION_NUMBER;
1139: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1140: EXCEPTION
1141: WHEN FND_API.G_EXC_ERROR THEN
1142: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1143: (
1138: x_object_version_number := l_def_coverage_rec.OBJECT_VERSION_NUMBER;
1139: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1140: EXCEPTION
1141: WHEN FND_API.G_EXC_ERROR THEN
1142: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1143: (
1144: l_api_name,
1145: G_PKG_NAME,
1146: 'FND_API.G_RET_STS_ERROR',
1149: '_Pvt'
1150: );
1151: APP_EXCEPTION.RAISE_EXCEPTION;
1152: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1153: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1154: (
1155: l_api_name,
1156: G_PKG_NAME,
1157: 'FND_API.G_RET_STS_UNEXP_ERROR',
1159: x_msg_data,
1160: '_Pvt'
1161: );
1162: APP_EXCEPTION.RAISE_EXCEPTION;
1163: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1164: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1165: (
1166: l_api_name,
1167: G_PKG_NAME,
1160: '_Pvt'
1161: );
1162: APP_EXCEPTION.RAISE_EXCEPTION;
1163: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1164: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1165: (
1166: l_api_name,
1167: G_PKG_NAME,
1168: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1164: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1165: (
1166: l_api_name,
1167: G_PKG_NAME,
1168: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1169: x_msg_count,
1170: x_msg_data,
1171: '_Pvt'
1172: );
1174: END update_row;
1175: Procedure update_row
1176: (
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1179: p_validation_level IN NUMBER,
1180: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1181: x_return_status OUT VARCHAR2,
1182: x_msg_count OUT NUMBER,
1176: (
1177: p_api_version IN NUMBER,
1178: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1179: p_validation_level IN NUMBER,
1180: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1181: x_return_status OUT VARCHAR2,
1182: x_msg_count OUT NUMBER,
1183: x_msg_data OUT VARCHAR2,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1181: x_return_status OUT VARCHAR2,
1182: x_msg_count OUT NUMBER,
1183: x_msg_data OUT VARCHAR2,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: x_return_status OUT VARCHAR2,
1182: x_msg_count OUT NUMBER,
1183: x_msg_data OUT VARCHAR2,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: x_msg_count OUT NUMBER,
1183: x_msg_data OUT VARCHAR2,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: x_msg_data OUT VARCHAR2,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1184: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1185: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1186: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1187: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1188: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1189: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1190: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1191: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1194: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1195: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1196: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1197: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1198: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1199: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1200: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1201: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1202: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1203: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1204: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1205: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1206: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1207: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1208: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1209: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1210: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1211: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1212: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1213: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1214: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1215: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1216: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1217: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1219: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1220: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1221: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1222: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1239: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1232: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1239: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: x_object_version_number OUT NUMBER) IS
1233: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1239: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: x_object_version_number OUT NUMBER) IS
1241: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1234: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1239: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: x_object_version_number OUT NUMBER) IS
1241: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1242: l_api_version CONSTANT NUMBER := 1;
1235: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1239: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: x_object_version_number OUT NUMBER) IS
1241: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1242: l_api_version CONSTANT NUMBER := 1;
1243: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1242: l_api_version CONSTANT NUMBER := 1;
1243: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1244: l_coverage_rec Coverage_Val_Rec_Type;
1245: BEGIN
1246: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1247: G_PKG_NAME,
1248: l_api_version,
1249: p_api_version,
1250: p_init_msg_list,
1321: x_msg_data,
1322: l_coverage_rec,
1323: x_object_version_number
1324: );
1325: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1326: EXCEPTION
1327: WHEN FND_API.G_EXC_ERROR THEN
1328: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1329: (
1324: );
1325: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1326: EXCEPTION
1327: WHEN FND_API.G_EXC_ERROR THEN
1328: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1329: (
1330: l_api_name,
1331: G_PKG_NAME,
1332: 'FND_API.G_RET_STS_ERROR',
1335: '_Pvt'
1336: );
1337: APP_EXCEPTION.RAISE_EXCEPTION;
1338: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1339: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1340: (
1341: l_api_name,
1342: G_PKG_NAME,
1343: 'FND_API.G_RET_STS_UNEXP_ERROR',
1345: x_msg_data,
1346: '_Pvt'
1347: );
1348: APP_EXCEPTION.RAISE_EXCEPTION;
1349: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1350: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1351: (
1352: l_api_name,
1353: G_PKG_NAME,
1346: '_Pvt'
1347: );
1348: APP_EXCEPTION.RAISE_EXCEPTION;
1349: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1350: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1351: (
1352: l_api_name,
1353: G_PKG_NAME,
1354: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1350: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1351: (
1352: l_api_name,
1353: G_PKG_NAME,
1354: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1355: x_msg_count,
1356: x_msg_data,
1357: '_Pvt'
1358: );
1360: END update_row;
1361: Procedure delete_row
1362: (
1363: p_api_version IN NUMBER,
1364: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1365: p_validation_level IN NUMBER,
1366: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1367: x_return_status OUT VARCHAR2,
1368: x_msg_count OUT NUMBER,
1362: (
1363: p_api_version IN NUMBER,
1364: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1365: p_validation_level IN NUMBER,
1366: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1367: x_return_status OUT VARCHAR2,
1368: x_msg_count OUT NUMBER,
1369: x_msg_data OUT VARCHAR2,
1370: p_coverage_id IN NUMBER) IS
1371: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1372: l_api_version CONSTANT NUMBER := 1;
1373: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1374: BEGIN
1375: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1376: G_PKG_NAME,
1377: l_api_version,
1378: p_api_version,
1379: p_init_msg_list,
1387: DELETE FROM CS_COVERAGES
1388: WHERE
1389: COVERAGE_ID = p_coverage_id
1390: ;
1391: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1392: EXCEPTION
1393: WHEN FND_API.G_EXC_ERROR THEN
1394: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1395: (
1390: ;
1391: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1392: EXCEPTION
1393: WHEN FND_API.G_EXC_ERROR THEN
1394: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1395: (
1396: l_api_name,
1397: G_PKG_NAME,
1398: 'FND_API.G_RET_STS_ERROR',
1401: '_Pvt'
1402: );
1403: APP_EXCEPTION.RAISE_EXCEPTION;
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1406: (
1407: l_api_name,
1408: G_PKG_NAME,
1409: 'FND_API.G_RET_STS_UNEXP_ERROR',
1411: x_msg_data,
1412: '_Pvt'
1413: );
1414: APP_EXCEPTION.RAISE_EXCEPTION;
1415: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1416: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,
1412: '_Pvt'
1413: );
1414: APP_EXCEPTION.RAISE_EXCEPTION;
1415: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1416: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,
1420: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1416: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,
1420: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1421: x_msg_count,
1422: x_msg_data,
1423: '_Pvt'
1424: );
1426: END delete_row;
1427: PROCEDURE validate_row
1428: (
1429: p_api_version IN NUMBER,
1430: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1431: p_validation_level IN NUMBER,
1432: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1433: x_return_status OUT VARCHAR2,
1434: x_msg_count OUT NUMBER,
1428: (
1429: p_api_version IN NUMBER,
1430: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1431: p_validation_level IN NUMBER,
1432: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1433: x_return_status OUT VARCHAR2,
1434: x_msg_count OUT NUMBER,
1435: x_msg_data OUT VARCHAR2,
1436: p_coverage_val_rec IN Coverage_Val_Rec_Type := G_MISS_COVERAGE_VAL_REC) IS
1439: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1440: l_coverage_rec Coverage_Rec_Type;
1441: l_def_coverage_rec Coverage_Rec_Type;
1442: BEGIN
1443: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1444: G_PKG_NAME,
1445: l_api_version,
1446: p_api_version,
1447: p_init_msg_list,
1473: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476: END IF;
1477: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1478: EXCEPTION
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1481: (
1476: END IF;
1477: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1478: EXCEPTION
1479: WHEN FND_API.G_EXC_ERROR THEN
1480: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1481: (
1482: l_api_name,
1483: G_PKG_NAME,
1484: 'FND_API.G_RET_STS_ERROR',
1487: '_Pvt'
1488: );
1489: APP_EXCEPTION.RAISE_EXCEPTION;
1490: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1491: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1492: (
1493: l_api_name,
1494: G_PKG_NAME,
1495: 'FND_API.G_RET_STS_UNEXP_ERROR',
1497: x_msg_data,
1498: '_Pvt'
1499: );
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1501: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1502: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1503: (
1504: l_api_name,
1505: G_PKG_NAME,
1498: '_Pvt'
1499: );
1500: APP_EXCEPTION.RAISE_EXCEPTION;
1501: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1502: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1503: (
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1502: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1503: (
1504: l_api_name,
1505: G_PKG_NAME,
1506: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1507: x_msg_count,
1508: x_msg_data,
1509: '_Pvt'
1510: );
1512: END validate_row;
1513: PROCEDURE validate_row
1514: (
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1517: p_validation_level IN NUMBER,
1518: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1519: x_return_status OUT VARCHAR2,
1520: x_msg_count OUT NUMBER,
1514: (
1515: p_api_version IN NUMBER,
1516: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1517: p_validation_level IN NUMBER,
1518: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1519: x_return_status OUT VARCHAR2,
1520: x_msg_count OUT NUMBER,
1521: x_msg_data OUT VARCHAR2,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1518: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1519: x_return_status OUT VARCHAR2,
1520: x_msg_count OUT NUMBER,
1521: x_msg_data OUT VARCHAR2,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: x_return_status OUT VARCHAR2,
1520: x_msg_count OUT NUMBER,
1521: x_msg_data OUT VARCHAR2,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: x_msg_count OUT NUMBER,
1521: x_msg_data OUT VARCHAR2,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: x_msg_data OUT VARCHAR2,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1522: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1523: p_coverage_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1524: p_name IN CS_COVERAGES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1525: p_description IN CS_COVERAGES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1526: p_template_flag IN CS_COVERAGES.TEMPLATE_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1527: p_renewal_terms IN CS_COVERAGES.RENEWAL_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1528: p_termination_terms IN CS_COVERAGES.TERMINATION_TERMS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1529: p_max_support_coverage_amt IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1530: p_exception_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1531: p_time_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1532: p_max_time_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1533: p_material_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1534: p_max_material_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1535: p_expense_billable_percent IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1536: p_max_expense_billable_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1537: p_max_coverage_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1538: p_response_time_period_code IN CS_COVERAGES.RESPONSE_TIME_PERIOD_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1539: p_response_time_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1540: p_sunday_start_time IN CS_COVERAGES.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1541: p_sunday_end_time IN CS_COVERAGES.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1542: p_monday_start_time IN CS_COVERAGES.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1543: p_monday_end_time IN CS_COVERAGES.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1544: p_start_date_active IN CS_COVERAGES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1545: p_tuesday_start_time IN CS_COVERAGES.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1546: p_tuesday_end_time IN CS_COVERAGES.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1547: p_end_date_active IN CS_COVERAGES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1548: p_wednesday_start_time IN CS_COVERAGES.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1549: p_wednesday_end_time IN CS_COVERAGES.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1550: p_thursday_start_time IN CS_COVERAGES.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1551: p_thursday_end_time IN CS_COVERAGES.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1552: p_friday_start_time IN CS_COVERAGES.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1553: p_friday_end_time IN CS_COVERAGES.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1554: p_saturday_start_time IN CS_COVERAGES.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1555: p_saturday_end_time IN CS_COVERAGES.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1556: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1557: p_creation_date IN CS_COVERAGES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1558: p_last_update_date IN CS_COVERAGES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1559: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1560: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1561: p_attribute3 IN CS_COVERAGES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1562: p_attribute1 IN CS_COVERAGES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1563: p_attribute2 IN CS_COVERAGES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1564: p_attribute4 IN CS_COVERAGES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1565: p_attribute5 IN CS_COVERAGES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1566: p_attribute6 IN CS_COVERAGES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1567: p_attribute7 IN CS_COVERAGES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1568: p_attribute8 IN CS_COVERAGES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1569: p_attribute9 IN CS_COVERAGES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1577: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1570: p_attribute10 IN CS_COVERAGES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1577: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1578: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1571: p_attribute11 IN CS_COVERAGES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1577: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1578: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1579: l_api_version CONSTANT NUMBER := 1;
1572: p_attribute12 IN CS_COVERAGES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1577: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1578: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1579: l_api_version CONSTANT NUMBER := 1;
1580: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1573: p_attribute13 IN CS_COVERAGES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1574: p_attribute14 IN CS_COVERAGES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1575: p_attribute15 IN CS_COVERAGES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1576: p_context IN CS_COVERAGES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1577: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1578: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1579: l_api_version CONSTANT NUMBER := 1;
1580: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1581: l_coverage_rec Coverage_Val_Rec_Type;
1579: l_api_version CONSTANT NUMBER := 1;
1580: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1581: l_coverage_rec Coverage_Val_Rec_Type;
1582: BEGIN
1583: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1584: G_PKG_NAME,
1585: l_api_version,
1586: p_api_version,
1587: p_init_msg_list,
1657: x_msg_count,
1658: x_msg_data,
1659: l_coverage_rec
1660: );
1661: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1665: (
1660: );
1661: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1662: EXCEPTION
1663: WHEN FND_API.G_EXC_ERROR THEN
1664: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1665: (
1666: l_api_name,
1667: G_PKG_NAME,
1668: 'FND_API.G_RET_STS_ERROR',
1671: '_Pvt'
1672: );
1673: APP_EXCEPTION.RAISE_EXCEPTION;
1674: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1675: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1676: (
1677: l_api_name,
1678: G_PKG_NAME,
1679: 'FND_API.G_RET_STS_UNEXP_ERROR',
1681: x_msg_data,
1682: '_Pvt'
1683: );
1684: APP_EXCEPTION.RAISE_EXCEPTION;
1685: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1686: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1687: (
1688: l_api_name,
1689: G_PKG_NAME,
1682: '_Pvt'
1683: );
1684: APP_EXCEPTION.RAISE_EXCEPTION;
1685: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1686: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1687: (
1688: l_api_name,
1689: G_PKG_NAME,
1690: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1686: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1687: (
1688: l_api_name,
1689: G_PKG_NAME,
1690: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1691: x_msg_count,
1692: x_msg_data,
1693: '_Pvt'
1694: );