[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_txngrp_rec.coverage_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_txngrp_rec.coverage_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
25: p_txngrp_rec.coverage_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'business_process_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'business_process_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'business_process_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txngrp_rec.creation_date IS NULL
46: THEN
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txngrp_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txngrp_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txngrp_rec.created_by IS NULL
51: THEN
45: p_txngrp_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txngrp_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txngrp_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;
106: FETCH cc_pk_csr INTO l_cc_pk;
107: l_row_notfound := cc_pk_csr%NOTFOUND;
108: CLOSE cc_pk_csr;
109: IF (l_row_notfound) THEN
110: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_ID');
111: RAISE item_not_found_error;
112: END IF;
113: END IF;
114: IF (p_txngrp_rec.BUSINESS_PROCESS_ID IS NOT NULL)
117: FETCH csbp_pk_csr INTO l_csbp_pk;
118: l_row_notfound := csbp_pk_csr%NOTFOUND;
119: CLOSE csbp_pk_csr;
120: IF (l_row_notfound) THEN
121: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'BUSINESS_PROCESS_ID');
122: RAISE item_not_found_error;
123: END IF;
124: END IF;
125: IF (p_txngrp_rec.TIME_ZONE_ID IS NOT NULL)
128: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
129: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
130: CLOSE cs_time_zones_pk_csr;
131: IF (l_row_notfound) THEN
132: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'TIME_ZONE_ID');
133: RAISE item_not_found_error;
134: END IF;
135: END IF;
136: RETURN (l_return_status);
259: END migrate;
260: PROCEDURE insert_row
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
264: p_validation_level IN NUMBER,
265: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
266: x_return_status OUT VARCHAR2,
267: x_msg_count OUT NUMBER,
261: (
262: p_api_version IN NUMBER,
263: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
264: p_validation_level IN NUMBER,
265: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
266: x_return_status OUT VARCHAR2,
267: x_msg_count OUT NUMBER,
268: x_msg_data OUT VARCHAR2,
269: p_txngrp_rec IN TxnGrp_Rec_Type := G_MISS_TXNGRP_REC,
274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
275: l_txngrp_rec TxnGrp_Rec_Type;
276: l_def_txngrp_rec TxnGrp_Rec_Type;
277: BEGIN
278: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
279: G_PKG_NAME,
280: l_api_version,
281: p_api_version,
282: p_init_msg_list,
427: l_def_txngrp_rec.object_version_number);
428: -- Set OUT values
429: x_coverage_txn_group_id := l_def_txngrp_rec.coverage_txn_group_id;
430: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
435: (
430: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
435: (
436: l_api_name,
437: G_PKG_NAME,
438: 'FND_API.G_RET_STS_ERROR',
441: '_Pvt'
442: );
443: APP_EXCEPTION.RAISE_EXCEPTION;
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
446: (
447: l_api_name,
448: G_PKG_NAME,
449: 'FND_API.G_RET_STS_UNEXP_ERROR',
451: x_msg_data,
452: '_Pvt'
453: );
454: APP_EXCEPTION.RAISE_EXCEPTION;
455: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
457: (
458: l_api_name,
459: G_PKG_NAME,
452: '_Pvt'
453: );
454: APP_EXCEPTION.RAISE_EXCEPTION;
455: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
457: (
458: l_api_name,
459: G_PKG_NAME,
460: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
457: (
458: l_api_name,
459: G_PKG_NAME,
460: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
461: x_msg_count,
462: x_msg_data,
463: '_Pvt'
464: );
466: END insert_row;
467: PROCEDURE insert_row
468: (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
471: p_validation_level IN NUMBER,
472: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
473: x_return_status OUT VARCHAR2,
474: x_msg_count OUT NUMBER,
468: (
469: p_api_version IN NUMBER,
470: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
471: p_validation_level IN NUMBER,
472: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
473: x_return_status OUT VARCHAR2,
474: x_msg_count OUT NUMBER,
475: x_msg_data OUT VARCHAR2,
476: p_offset_duration IN NUMBER := NULL,
528: l_api_version CONSTANT NUMBER := 1;
529: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
530: l_txngrp_rec TxnGrp_Rec_Type;
531: BEGIN
532: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
533: G_PKG_NAME,
534: l_api_version,
535: p_api_version,
536: p_init_msg_list,
601: l_txngrp_rec,
602: x_coverage_txn_group_id,
603: x_object_version_number
604: );
605: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
609: (
604: );
605: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
609: (
610: l_api_name,
611: G_PKG_NAME,
612: 'FND_API.G_RET_STS_ERROR',
615: '_Pvt'
616: );
617: APP_EXCEPTION.RAISE_EXCEPTION;
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
620: (
621: l_api_name,
622: G_PKG_NAME,
623: 'FND_API.G_RET_STS_UNEXP_ERROR',
625: x_msg_data,
626: '_Pvt'
627: );
628: APP_EXCEPTION.RAISE_EXCEPTION;
629: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
630: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,
626: '_Pvt'
627: );
628: APP_EXCEPTION.RAISE_EXCEPTION;
629: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
630: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,
634: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
630: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
631: (
632: l_api_name,
633: G_PKG_NAME,
634: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
635: x_msg_count,
636: x_msg_data,
637: '_Pvt'
638: );
640: END insert_row;
641: Procedure lock_row
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
645: p_validation_level IN NUMBER,
646: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
647: x_return_status OUT VARCHAR2,
648: x_msg_count OUT NUMBER,
642: (
643: p_api_version IN NUMBER,
644: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
645: p_validation_level IN NUMBER,
646: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
647: x_return_status OUT VARCHAR2,
648: x_msg_count OUT NUMBER,
649: x_msg_data OUT VARCHAR2,
650: p_coverage_txn_group_id IN NUMBER,
672: lc_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
673: l_row_notfound BOOLEAN := FALSE;
674: lc_row_notfound BOOLEAN := FALSE;
675: BEGIN
676: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
677: G_PKG_NAME,
678: l_api_version,
679: p_api_version,
680: p_init_msg_list,
694: WHEN E_Resource_Busy THEN
695: IF (lock_csr%ISOPEN) THEN
696: CLOSE lock_csr;
697: END IF;
698: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
699: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
700: END;
701:
702: IF ( l_row_notfound ) THEN
705: lc_row_notfound := lchk_csr%NOTFOUND;
706: CLOSE lchk_csr;
707: END IF;
708: IF (lc_row_notfound) THEN
709: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF lc_object_version_number > p_object_version_number THEN
712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
708: IF (lc_row_notfound) THEN
709: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF lc_object_version_number > p_object_version_number THEN
712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN
715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
711: ELSIF lc_object_version_number > p_object_version_number THEN
712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN
715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF lc_object_version_number = -1 THEN
718: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
719: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN
715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF lc_object_version_number = -1 THEN
718: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
722: EXCEPTION
717: ELSIF lc_object_version_number = -1 THEN
718: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
720: END IF;
721: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,
728: 'FND_API.G_RET_STS_ERROR',
731: '_Pvt'
732: );
733: APP_EXCEPTION.RAISE_EXCEPTION;
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
735: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
736: (
737: l_api_name,
738: G_PKG_NAME,
739: 'FND_API.G_RET_STS_UNEXP_ERROR',
741: x_msg_data,
742: '_Pvt'
743: );
744: APP_EXCEPTION.RAISE_EXCEPTION;
745: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
746: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
747: (
748: l_api_name,
749: G_PKG_NAME,
742: '_Pvt'
743: );
744: APP_EXCEPTION.RAISE_EXCEPTION;
745: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
746: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
747: (
748: l_api_name,
749: G_PKG_NAME,
750: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
746: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
747: (
748: l_api_name,
749: G_PKG_NAME,
750: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
751: x_msg_count,
752: x_msg_data,
753: '_Pvt'
754: );
756: END lock_row;
757: Procedure update_row
758: (
759: p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
761: p_validation_level IN NUMBER,
762: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
763: x_return_status OUT VARCHAR2,
764: x_msg_count OUT NUMBER,
758: (
759: p_api_version IN NUMBER,
760: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
761: p_validation_level IN NUMBER,
762: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
763: x_return_status OUT VARCHAR2,
764: x_msg_count OUT NUMBER,
765: x_msg_data OUT VARCHAR2,
766: p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC,
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN
792: l_return_status := FND_API.G_RET_STS_ERROR;
793: END IF;
794: IF (x_txngrp_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
795: THEN
796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;
797: END IF;
798: IF (x_txngrp_rec.offset_duration = TAPI_DEV_KIT.G_MISS_NUM)
794: IF (x_txngrp_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
795: THEN
796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;
797: END IF;
798: IF (x_txngrp_rec.offset_duration = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;
801: END IF;
802: IF (x_txngrp_rec.offset_period = TAPI_DEV_KIT.G_MISS_CHAR)
798: IF (x_txngrp_rec.offset_duration = TAPI_DEV_KIT.G_MISS_NUM)
799: THEN
800: x_txngrp_rec.offset_duration := l_cs_coverage_txn_groups_pk.offset_duration;
801: END IF;
802: IF (x_txngrp_rec.offset_period = TAPI_DEV_KIT.G_MISS_CHAR)
803: THEN
804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;
805: END IF;
806: IF (x_txngrp_rec.coverage_start_date = TAPI_DEV_KIT.G_MISS_DATE)
802: IF (x_txngrp_rec.offset_period = TAPI_DEV_KIT.G_MISS_CHAR)
803: THEN
804: x_txngrp_rec.offset_period := l_cs_coverage_txn_groups_pk.offset_period;
805: END IF;
806: IF (x_txngrp_rec.coverage_start_date = TAPI_DEV_KIT.G_MISS_DATE)
807: THEN
808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;
809: END IF;
810: IF (x_txngrp_rec.coverage_end_date = TAPI_DEV_KIT.G_MISS_DATE)
806: IF (x_txngrp_rec.coverage_start_date = TAPI_DEV_KIT.G_MISS_DATE)
807: THEN
808: x_txngrp_rec.coverage_start_date := l_cs_coverage_txn_groups_pk.coverage_start_date;
809: END IF;
810: IF (x_txngrp_rec.coverage_end_date = TAPI_DEV_KIT.G_MISS_DATE)
811: THEN
812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;
813: END IF;
814: IF (x_txngrp_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
810: IF (x_txngrp_rec.coverage_end_date = TAPI_DEV_KIT.G_MISS_DATE)
811: THEN
812: x_txngrp_rec.coverage_end_date := l_cs_coverage_txn_groups_pk.coverage_end_date;
813: END IF;
814: IF (x_txngrp_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
815: THEN
816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;
817: END IF;
818: IF (x_txngrp_rec.manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
814: IF (x_txngrp_rec.price_list_id = TAPI_DEV_KIT.G_MISS_NUM)
815: THEN
816: x_txngrp_rec.price_list_id := l_cs_coverage_txn_groups_pk.price_list_id;
817: END IF;
818: IF (x_txngrp_rec.manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
819: THEN
820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;
821: END IF;
822: IF (x_txngrp_rec.subinventory_code = TAPI_DEV_KIT.G_MISS_CHAR)
818: IF (x_txngrp_rec.manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
819: THEN
820: x_txngrp_rec.manufacturing_org_id := l_cs_coverage_txn_groups_pk.manufacturing_org_id;
821: END IF;
822: IF (x_txngrp_rec.subinventory_code = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;
825: END IF;
826: IF (x_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
822: IF (x_txngrp_rec.subinventory_code = TAPI_DEV_KIT.G_MISS_CHAR)
823: THEN
824: x_txngrp_rec.subinventory_code := l_cs_coverage_txn_groups_pk.subinventory_code;
825: END IF;
826: IF (x_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;
829: END IF;
830: IF (x_txngrp_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
826: IF (x_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
827: THEN
828: x_txngrp_rec.coverage_id := l_cs_coverage_txn_groups_pk.coverage_id;
829: END IF;
830: IF (x_txngrp_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;
833: END IF;
834: IF (x_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM)
830: IF (x_txngrp_rec.discount_id = TAPI_DEV_KIT.G_MISS_NUM)
831: THEN
832: x_txngrp_rec.discount_id := l_cs_coverage_txn_groups_pk.discount_id;
833: END IF;
834: IF (x_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;
837: END IF;
838: IF (x_txngrp_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
834: IF (x_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM)
835: THEN
836: x_txngrp_rec.business_process_id := l_cs_coverage_txn_groups_pk.business_process_id;
837: END IF;
838: IF (x_txngrp_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
839: THEN
840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;
841: END IF;
842: IF (x_txngrp_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
838: IF (x_txngrp_rec.sunday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
839: THEN
840: x_txngrp_rec.sunday_end_time := l_cs_coverage_txn_groups_pk.sunday_end_time;
841: END IF;
842: IF (x_txngrp_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
843: THEN
844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;
845: END IF;
846: IF (x_txngrp_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
842: IF (x_txngrp_rec.sunday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
843: THEN
844: x_txngrp_rec.sunday_start_time := l_cs_coverage_txn_groups_pk.sunday_start_time;
845: END IF;
846: IF (x_txngrp_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
847: THEN
848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;
849: END IF;
850: IF (x_txngrp_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
846: IF (x_txngrp_rec.monday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
847: THEN
848: x_txngrp_rec.monday_start_time := l_cs_coverage_txn_groups_pk.monday_start_time;
849: END IF;
850: IF (x_txngrp_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
851: THEN
852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;
853: END IF;
854: IF (x_txngrp_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
850: IF (x_txngrp_rec.monday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
851: THEN
852: x_txngrp_rec.monday_end_time := l_cs_coverage_txn_groups_pk.monday_end_time;
853: END IF;
854: IF (x_txngrp_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
855: THEN
856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;
857: END IF;
858: IF (x_txngrp_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
854: IF (x_txngrp_rec.tuesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
855: THEN
856: x_txngrp_rec.tuesday_start_time := l_cs_coverage_txn_groups_pk.tuesday_start_time;
857: END IF;
858: IF (x_txngrp_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
859: THEN
860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;
861: END IF;
862: IF (x_txngrp_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
858: IF (x_txngrp_rec.tuesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
859: THEN
860: x_txngrp_rec.tuesday_end_time := l_cs_coverage_txn_groups_pk.tuesday_end_time;
861: END IF;
862: IF (x_txngrp_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
863: THEN
864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;
865: END IF;
866: IF (x_txngrp_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
862: IF (x_txngrp_rec.wednesday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
863: THEN
864: x_txngrp_rec.wednesday_start_time := l_cs_coverage_txn_groups_pk.wednesday_start_time;
865: END IF;
866: IF (x_txngrp_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
867: THEN
868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;
869: END IF;
870: IF (x_txngrp_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
866: IF (x_txngrp_rec.wednesday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
867: THEN
868: x_txngrp_rec.wednesday_end_time := l_cs_coverage_txn_groups_pk.wednesday_end_time;
869: END IF;
870: IF (x_txngrp_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;
873: END IF;
874: IF (x_txngrp_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
870: IF (x_txngrp_rec.thursday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
871: THEN
872: x_txngrp_rec.thursday_start_time := l_cs_coverage_txn_groups_pk.thursday_start_time;
873: END IF;
874: IF (x_txngrp_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;
877: END IF;
878: IF (x_txngrp_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
874: IF (x_txngrp_rec.thursday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
875: THEN
876: x_txngrp_rec.thursday_end_time := l_cs_coverage_txn_groups_pk.thursday_end_time;
877: END IF;
878: IF (x_txngrp_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;
881: END IF;
882: IF (x_txngrp_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
878: IF (x_txngrp_rec.friday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
879: THEN
880: x_txngrp_rec.friday_start_time := l_cs_coverage_txn_groups_pk.friday_start_time;
881: END IF;
882: IF (x_txngrp_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;
885: END IF;
886: IF (x_txngrp_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
882: IF (x_txngrp_rec.friday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
883: THEN
884: x_txngrp_rec.friday_end_time := l_cs_coverage_txn_groups_pk.friday_end_time;
885: END IF;
886: IF (x_txngrp_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;
889: END IF;
890: IF (x_txngrp_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
886: IF (x_txngrp_rec.saturday_start_time = TAPI_DEV_KIT.G_MISS_DATE)
887: THEN
888: x_txngrp_rec.saturday_start_time := l_cs_coverage_txn_groups_pk.saturday_start_time;
889: END IF;
890: IF (x_txngrp_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;
893: END IF;
894: IF (x_txngrp_rec.preferred_engineer1 = TAPI_DEV_KIT.G_MISS_CHAR)
890: IF (x_txngrp_rec.saturday_end_time = TAPI_DEV_KIT.G_MISS_DATE)
891: THEN
892: x_txngrp_rec.saturday_end_time := l_cs_coverage_txn_groups_pk.saturday_end_time;
893: END IF;
894: IF (x_txngrp_rec.preferred_engineer1 = TAPI_DEV_KIT.G_MISS_CHAR)
895: THEN
896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;
897: END IF;
898: IF (x_txngrp_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
894: IF (x_txngrp_rec.preferred_engineer1 = TAPI_DEV_KIT.G_MISS_CHAR)
895: THEN
896: x_txngrp_rec.preferred_engineer1 := l_cs_coverage_txn_groups_pk.preferred_engineer1;
897: END IF;
898: IF (x_txngrp_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
899: THEN
900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;
901: END IF;
902: IF (x_txngrp_rec.preferred_engineer2 = TAPI_DEV_KIT.G_MISS_CHAR)
898: IF (x_txngrp_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
899: THEN
900: x_txngrp_rec.time_zone_id := l_cs_coverage_txn_groups_pk.time_zone_id;
901: END IF;
902: IF (x_txngrp_rec.preferred_engineer2 = TAPI_DEV_KIT.G_MISS_CHAR)
903: THEN
904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;
905: END IF;
906: IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
902: IF (x_txngrp_rec.preferred_engineer2 = TAPI_DEV_KIT.G_MISS_CHAR)
903: THEN
904: x_txngrp_rec.preferred_engineer2 := l_cs_coverage_txn_groups_pk.preferred_engineer2;
905: END IF;
906: IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;
909: END IF;
910: IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
906: IF (x_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
907: THEN
908: x_txngrp_rec.last_update_date := l_cs_coverage_txn_groups_pk.last_update_date;
909: END IF;
910: IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
911: THEN
912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;
913: END IF;
914: IF (x_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
910: IF (x_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
911: THEN
912: x_txngrp_rec.last_updated_by := l_cs_coverage_txn_groups_pk.last_updated_by;
913: END IF;
914: IF (x_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;
917: END IF;
918: IF (x_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
914: IF (x_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
915: THEN
916: x_txngrp_rec.creation_date := l_cs_coverage_txn_groups_pk.creation_date;
917: END IF;
918: IF (x_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
919: THEN
920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;
921: END IF;
922: IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
918: IF (x_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
919: THEN
920: x_txngrp_rec.created_by := l_cs_coverage_txn_groups_pk.created_by;
921: END IF;
922: IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
923: THEN
924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;
925: END IF;
926: IF (x_txngrp_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
922: IF (x_txngrp_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
923: THEN
924: x_txngrp_rec.last_update_login := l_cs_coverage_txn_groups_pk.last_update_login;
925: END IF;
926: IF (x_txngrp_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
927: THEN
928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;
929: END IF;
930: IF (x_txngrp_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
926: IF (x_txngrp_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
927: THEN
928: x_txngrp_rec.attribute1 := l_cs_coverage_txn_groups_pk.attribute1;
929: END IF;
930: IF (x_txngrp_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
931: THEN
932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;
933: END IF;
934: IF (x_txngrp_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
930: IF (x_txngrp_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
931: THEN
932: x_txngrp_rec.attribute2 := l_cs_coverage_txn_groups_pk.attribute2;
933: END IF;
934: IF (x_txngrp_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
935: THEN
936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;
937: END IF;
938: IF (x_txngrp_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
934: IF (x_txngrp_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
935: THEN
936: x_txngrp_rec.attribute3 := l_cs_coverage_txn_groups_pk.attribute3;
937: END IF;
938: IF (x_txngrp_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
939: THEN
940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;
941: END IF;
942: IF (x_txngrp_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
938: IF (x_txngrp_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
939: THEN
940: x_txngrp_rec.attribute4 := l_cs_coverage_txn_groups_pk.attribute4;
941: END IF;
942: IF (x_txngrp_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
943: THEN
944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;
945: END IF;
946: IF (x_txngrp_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
942: IF (x_txngrp_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
943: THEN
944: x_txngrp_rec.attribute5 := l_cs_coverage_txn_groups_pk.attribute5;
945: END IF;
946: IF (x_txngrp_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
947: THEN
948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;
949: END IF;
950: IF (x_txngrp_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
946: IF (x_txngrp_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
947: THEN
948: x_txngrp_rec.attribute6 := l_cs_coverage_txn_groups_pk.attribute6;
949: END IF;
950: IF (x_txngrp_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
951: THEN
952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;
953: END IF;
954: IF (x_txngrp_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
950: IF (x_txngrp_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
951: THEN
952: x_txngrp_rec.attribute7 := l_cs_coverage_txn_groups_pk.attribute7;
953: END IF;
954: IF (x_txngrp_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;
957: END IF;
958: IF (x_txngrp_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
954: IF (x_txngrp_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
955: THEN
956: x_txngrp_rec.attribute8 := l_cs_coverage_txn_groups_pk.attribute8;
957: END IF;
958: IF (x_txngrp_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;
961: END IF;
962: IF (x_txngrp_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
958: IF (x_txngrp_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
959: THEN
960: x_txngrp_rec.attribute9 := l_cs_coverage_txn_groups_pk.attribute9;
961: END IF;
962: IF (x_txngrp_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;
965: END IF;
966: IF (x_txngrp_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
962: IF (x_txngrp_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
963: THEN
964: x_txngrp_rec.attribute10 := l_cs_coverage_txn_groups_pk.attribute10;
965: END IF;
966: IF (x_txngrp_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;
969: END IF;
970: IF (x_txngrp_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
966: IF (x_txngrp_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
967: THEN
968: x_txngrp_rec.attribute11 := l_cs_coverage_txn_groups_pk.attribute11;
969: END IF;
970: IF (x_txngrp_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;
973: END IF;
974: IF (x_txngrp_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
970: IF (x_txngrp_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
971: THEN
972: x_txngrp_rec.attribute12 := l_cs_coverage_txn_groups_pk.attribute12;
973: END IF;
974: IF (x_txngrp_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;
977: END IF;
978: IF (x_txngrp_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
974: IF (x_txngrp_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
975: THEN
976: x_txngrp_rec.attribute13 := l_cs_coverage_txn_groups_pk.attribute13;
977: END IF;
978: IF (x_txngrp_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;
981: END IF;
982: IF (x_txngrp_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
978: IF (x_txngrp_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
979: THEN
980: x_txngrp_rec.attribute14 := l_cs_coverage_txn_groups_pk.attribute14;
981: END IF;
982: IF (x_txngrp_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;
985: END IF;
986: IF (x_txngrp_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
982: IF (x_txngrp_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
983: THEN
984: x_txngrp_rec.attribute15 := l_cs_coverage_txn_groups_pk.attribute15;
985: END IF;
986: IF (x_txngrp_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;
989: END IF;
990: IF (x_txngrp_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
986: IF (x_txngrp_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
987: THEN
988: x_txngrp_rec.context := l_cs_coverage_txn_groups_pk.context;
989: END IF;
990: IF (x_txngrp_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
991: THEN
992: x_txngrp_rec.object_version_number := l_cs_coverage_txn_groups_pk.object_version_number;
993: END IF;
994: RETURN(l_return_status);
993: END IF;
994: RETURN(l_return_status);
995: END populate_new_record;
996: BEGIN
997: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
998: G_PKG_NAME,
999: l_api_version,
1000: p_api_version,
1001: p_init_msg_list,
1101: WHERE
1102: COVERAGE_TXN_GROUP_ID = l_def_txngrp_rec.coverage_txn_group_id
1103: ;
1104: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
1105: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1106: EXCEPTION
1107: WHEN FND_API.G_EXC_ERROR THEN
1108: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1109: (
1104: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
1105: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1106: EXCEPTION
1107: WHEN FND_API.G_EXC_ERROR THEN
1108: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1109: (
1110: l_api_name,
1111: G_PKG_NAME,
1112: 'FND_API.G_RET_STS_ERROR',
1115: '_Pvt'
1116: );
1117: APP_EXCEPTION.RAISE_EXCEPTION;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'FND_API.G_RET_STS_UNEXP_ERROR',
1125: x_msg_data,
1126: '_Pvt'
1127: );
1128: APP_EXCEPTION.RAISE_EXCEPTION;
1129: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1130: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1131: (
1132: l_api_name,
1133: G_PKG_NAME,
1126: '_Pvt'
1127: );
1128: APP_EXCEPTION.RAISE_EXCEPTION;
1129: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1130: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1131: (
1132: l_api_name,
1133: G_PKG_NAME,
1134: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1130: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1131: (
1132: l_api_name,
1133: G_PKG_NAME,
1134: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1135: x_msg_count,
1136: x_msg_data,
1137: '_Pvt'
1138: );
1140: END update_row;
1141: Procedure update_row
1142: (
1143: p_api_version IN NUMBER,
1144: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1145: p_validation_level IN NUMBER,
1146: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1147: x_return_status OUT VARCHAR2,
1148: x_msg_count OUT NUMBER,
1142: (
1143: p_api_version IN NUMBER,
1144: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1145: p_validation_level IN NUMBER,
1146: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1147: x_return_status OUT VARCHAR2,
1148: x_msg_count OUT NUMBER,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1147: x_return_status OUT VARCHAR2,
1148: x_msg_count OUT NUMBER,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1147: x_return_status OUT VARCHAR2,
1148: x_msg_count OUT NUMBER,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1148: x_msg_count OUT NUMBER,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: x_msg_data OUT VARCHAR2,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1152: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1154: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1156: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1157: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1159: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1161: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1162: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1165: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1167: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1171: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1172: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1173: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1174: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1192: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1193: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1194: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1202: l_api_version CONSTANT NUMBER := 1;
1195: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1196: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1197: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1198: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1202: l_api_version CONSTANT NUMBER := 1;
1203: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1202: l_api_version CONSTANT NUMBER := 1;
1203: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1204: l_txngrp_rec TxnGrp_Val_Rec_Type;
1205: BEGIN
1206: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1207: G_PKG_NAME,
1208: l_api_version,
1209: p_api_version,
1210: p_init_msg_list,
1275: x_msg_data,
1276: l_txngrp_rec,
1277: x_object_version_number
1278: );
1279: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1280: EXCEPTION
1281: WHEN FND_API.G_EXC_ERROR THEN
1282: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1283: (
1278: );
1279: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1280: EXCEPTION
1281: WHEN FND_API.G_EXC_ERROR THEN
1282: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1283: (
1284: l_api_name,
1285: G_PKG_NAME,
1286: 'FND_API.G_RET_STS_ERROR',
1289: '_Pvt'
1290: );
1291: APP_EXCEPTION.RAISE_EXCEPTION;
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'FND_API.G_RET_STS_UNEXP_ERROR',
1299: x_msg_data,
1300: '_Pvt'
1301: );
1302: APP_EXCEPTION.RAISE_EXCEPTION;
1303: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1304: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1305: (
1306: l_api_name,
1307: G_PKG_NAME,
1300: '_Pvt'
1301: );
1302: APP_EXCEPTION.RAISE_EXCEPTION;
1303: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1304: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1305: (
1306: l_api_name,
1307: G_PKG_NAME,
1308: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1304: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1305: (
1306: l_api_name,
1307: G_PKG_NAME,
1308: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1309: x_msg_count,
1310: x_msg_data,
1311: '_Pvt'
1312: );
1314: END update_row;
1315: Procedure delete_row
1316: (
1317: p_api_version IN NUMBER,
1318: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1319: p_validation_level IN NUMBER,
1320: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1321: x_return_status OUT VARCHAR2,
1322: x_msg_count OUT NUMBER,
1316: (
1317: p_api_version IN NUMBER,
1318: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1319: p_validation_level IN NUMBER,
1320: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1321: x_return_status OUT VARCHAR2,
1322: x_msg_count OUT NUMBER,
1323: x_msg_data OUT VARCHAR2,
1324: p_coverage_txn_group_id IN NUMBER) IS
1325: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1326: l_api_version CONSTANT NUMBER := 1;
1327: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1328: BEGIN
1329: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1330: G_PKG_NAME,
1331: l_api_version,
1332: p_api_version,
1333: p_init_msg_list,
1341: DELETE FROM CS_COVERAGE_TXN_GROUPS
1342: WHERE
1343: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
1344: ;
1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1349: (
1344: ;
1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1349: (
1350: l_api_name,
1351: G_PKG_NAME,
1352: 'FND_API.G_RET_STS_ERROR',
1355: '_Pvt'
1356: );
1357: APP_EXCEPTION.RAISE_EXCEPTION;
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1360: (
1361: l_api_name,
1362: G_PKG_NAME,
1363: 'FND_API.G_RET_STS_UNEXP_ERROR',
1365: x_msg_data,
1366: '_Pvt'
1367: );
1368: APP_EXCEPTION.RAISE_EXCEPTION;
1369: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1370: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1371: (
1372: l_api_name,
1373: G_PKG_NAME,
1366: '_Pvt'
1367: );
1368: APP_EXCEPTION.RAISE_EXCEPTION;
1369: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1370: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1371: (
1372: l_api_name,
1373: G_PKG_NAME,
1374: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1370: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1371: (
1372: l_api_name,
1373: G_PKG_NAME,
1374: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1375: x_msg_count,
1376: x_msg_data,
1377: '_Pvt'
1378: );
1380: END delete_row;
1381: PROCEDURE validate_row
1382: (
1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1385: p_validation_level IN NUMBER,
1386: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1387: x_return_status OUT VARCHAR2,
1388: x_msg_count OUT NUMBER,
1382: (
1383: p_api_version IN NUMBER,
1384: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1385: p_validation_level IN NUMBER,
1386: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1387: x_return_status OUT VARCHAR2,
1388: x_msg_count OUT NUMBER,
1389: x_msg_data OUT VARCHAR2,
1390: p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC) IS
1393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1394: l_txngrp_rec TxnGrp_Rec_Type;
1395: l_def_txngrp_rec TxnGrp_Rec_Type;
1396: BEGIN
1397: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1398: G_PKG_NAME,
1399: l_api_version,
1400: p_api_version,
1401: p_init_msg_list,
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN FND_API.G_EXC_ERROR THEN
1434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1435: (
1430: END IF;
1431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN FND_API.G_EXC_ERROR THEN
1434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,
1438: 'FND_API.G_RET_STS_ERROR',
1441: '_Pvt'
1442: );
1443: APP_EXCEPTION.RAISE_EXCEPTION;
1444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1446: (
1447: l_api_name,
1448: G_PKG_NAME,
1449: 'FND_API.G_RET_STS_UNEXP_ERROR',
1451: x_msg_data,
1452: '_Pvt'
1453: );
1454: APP_EXCEPTION.RAISE_EXCEPTION;
1455: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1457: (
1458: l_api_name,
1459: G_PKG_NAME,
1452: '_Pvt'
1453: );
1454: APP_EXCEPTION.RAISE_EXCEPTION;
1455: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1457: (
1458: l_api_name,
1459: G_PKG_NAME,
1460: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1456: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1457: (
1458: l_api_name,
1459: G_PKG_NAME,
1460: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1461: x_msg_count,
1462: x_msg_data,
1463: '_Pvt'
1464: );
1466: END validate_row;
1467: PROCEDURE validate_row
1468: (
1469: p_api_version IN NUMBER,
1470: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1471: p_validation_level IN NUMBER,
1472: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1473: x_return_status OUT VARCHAR2,
1474: x_msg_count OUT NUMBER,
1468: (
1469: p_api_version IN NUMBER,
1470: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1471: p_validation_level IN NUMBER,
1472: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1473: x_return_status OUT VARCHAR2,
1474: x_msg_count OUT NUMBER,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1472: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1473: x_return_status OUT VARCHAR2,
1474: x_msg_count OUT NUMBER,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1473: x_return_status OUT VARCHAR2,
1474: x_msg_count OUT NUMBER,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1474: x_msg_count OUT NUMBER,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1475: x_msg_data OUT VARCHAR2,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1476: p_coverage_txn_group_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1477: p_offset_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1478: p_offset_period IN CS_COVERAGE_TXN_GROUPS.OFFSET_PERIOD%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1479: p_coverage_start_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_START_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1480: p_coverage_end_date IN CS_COVERAGE_TXN_GROUPS.COVERAGE_END_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1481: p_price_list_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1482: p_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1483: p_subinventory_code IN CS_COVERAGE_TXN_GROUPS.SUBINVENTORY_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1484: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1485: p_discount_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1486: p_business_process_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1487: p_sunday_end_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1488: p_sunday_start_time IN CS_COVERAGE_TXN_GROUPS.SUNDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1489: p_monday_start_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1490: p_monday_end_time IN CS_COVERAGE_TXN_GROUPS.MONDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1491: p_tuesday_start_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1492: p_tuesday_end_time IN CS_COVERAGE_TXN_GROUPS.TUESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1493: p_wednesday_start_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1494: p_wednesday_end_time IN CS_COVERAGE_TXN_GROUPS.WEDNESDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1495: p_thursday_start_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1496: p_thursday_end_time IN CS_COVERAGE_TXN_GROUPS.THURSDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1497: p_friday_start_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1498: p_friday_end_time IN CS_COVERAGE_TXN_GROUPS.FRIDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1499: p_saturday_start_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_START_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1500: p_saturday_end_time IN CS_COVERAGE_TXN_GROUPS.SATURDAY_END_TIME%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1501: p_preferred_engineer1 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1502: p_time_zone_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1503: p_preferred_engineer2 IN CS_COVERAGE_TXN_GROUPS.PREFERRED_ENGINEER2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1504: p_last_update_date IN CS_COVERAGE_TXN_GROUPS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1505: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1506: p_creation_date IN CS_COVERAGE_TXN_GROUPS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1507: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1508: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1509: p_attribute1 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1510: p_attribute2 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1511: p_attribute3 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1512: p_attribute4 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1513: p_attribute5 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1514: p_attribute6 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1515: p_attribute7 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1516: p_attribute8 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1517: p_attribute9 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1518: p_attribute10 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1519: p_attribute11 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;
1520: p_attribute12 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;
1528: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1521: p_attribute13 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1522: p_attribute14 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1523: p_attribute15 IN CS_COVERAGE_TXN_GROUPS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;
1528: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1529: l_txngrp_rec TxnGrp_Val_Rec_Type;
1527: l_api_version CONSTANT NUMBER := 1;
1528: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1529: l_txngrp_rec TxnGrp_Val_Rec_Type;
1530: BEGIN
1531: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1532: G_PKG_NAME,
1533: l_api_version,
1534: p_api_version,
1535: p_init_msg_list,
1599: x_msg_count,
1600: x_msg_data,
1601: l_txngrp_rec
1602: );
1603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1607: (
1602: );
1603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,
1610: 'FND_API.G_RET_STS_ERROR',
1613: '_Pvt'
1614: );
1615: APP_EXCEPTION.RAISE_EXCEPTION;
1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1617: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,
1621: 'FND_API.G_RET_STS_UNEXP_ERROR',
1623: x_msg_data,
1624: '_Pvt'
1625: );
1626: APP_EXCEPTION.RAISE_EXCEPTION;
1627: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1629: (
1630: l_api_name,
1631: G_PKG_NAME,
1624: '_Pvt'
1625: );
1626: APP_EXCEPTION.RAISE_EXCEPTION;
1627: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1629: (
1630: l_api_name,
1631: G_PKG_NAME,
1632: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1629: (
1630: l_api_name,
1631: G_PKG_NAME,
1632: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1633: x_msg_count,
1634: x_msg_data,
1635: '_Pvt'
1636: );