[Home] [Help]
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_coveragelevel_rec.coverage_level_code = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_coveragelevel_rec.coverage_level_code IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_code');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_coveragelevel_rec.coverage_level_code = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_coveragelevel_rec.coverage_level_code IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_code');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveragelevel_rec.coverage_level_value IS NULL
31: THEN
25: p_coveragelevel_rec.coverage_level_code IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_code');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveragelevel_rec.coverage_level_value IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_value');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveragelevel_rec.coverage_level_value IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_value');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_coveragelevel_rec.last_update_date IS NULL
36: THEN
30: p_coveragelevel_rec.coverage_level_value IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_value');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_coveragelevel_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_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_coveragelevel_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_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_coveragelevel_rec.last_updated_by IS NULL
41: THEN
35: p_coveragelevel_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_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_coveragelevel_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_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_coveragelevel_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_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coveragelevel_rec.creation_date IS NULL
46: THEN
40: p_coveragelevel_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_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coveragelevel_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_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_coveragelevel_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_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coveragelevel_rec.created_by IS NULL
51: THEN
45: p_coveragelevel_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_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coveragelevel_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_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_coveragelevel_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: ELSIF p_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveragelevel_rec.cp_service_id IS NULL
56: THEN
50: p_coveragelevel_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: ELSIF p_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveragelevel_rec.cp_service_id IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
58: l_return_status := FND_API.G_RET_STS_ERROR;
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveragelevel_rec.cp_service_id IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: END IF;
60: RETURN(l_return_status);
61: END Validate_Item_Attributes;
101: FETCH cs_cp_services_all_pk_csr INTO l_cs_cp_services_all_pk;
102: l_row_notfound := cs_cp_services_all_pk_csr%NOTFOUND;
103: CLOSE cs_cp_services_all_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CP_SERVICE_ID');
106: RAISE item_not_found_error;
107: END IF;
108: END IF;
109: RETURN (l_return_status);
184: END migrate;
185: PROCEDURE insert_row
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
189: p_validation_level IN NUMBER,
190: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
191: x_return_status OUT VARCHAR2,
192: x_msg_count OUT NUMBER,
186: (
187: p_api_version IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
189: p_validation_level IN NUMBER,
190: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
191: x_return_status OUT VARCHAR2,
192: x_msg_count OUT NUMBER,
193: x_msg_data OUT VARCHAR2,
194: p_coveragelevel_rec IN CoverageLevel_Rec_Type := G_MISS_COVERAGELEVEL_REC,
199: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
200: l_coveragelevel_rec CoverageLevel_Rec_Type;
201: l_def_coveragelevel_rec CoverageLevel_Rec_Type;
202: BEGIN
203: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
204: G_PKG_NAME,
205: l_api_version,
206: p_api_version,
207: p_init_msg_list,
304: l_def_coveragelevel_rec.object_version_number);
305: -- Set OUT values
306: x_coverage_level_id := l_def_coveragelevel_rec.coverage_level_id;
307: x_object_version_number := l_def_coveragelevel_rec.OBJECT_VERSION_NUMBER;
308: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
312: (
307: x_object_version_number := l_def_coveragelevel_rec.OBJECT_VERSION_NUMBER;
308: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
309: EXCEPTION
310: WHEN FND_API.G_EXC_ERROR THEN
311: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
312: (
313: l_api_name,
314: G_PKG_NAME,
315: 'FND_API.G_RET_STS_ERROR',
318: '_Pvt'
319: );
320: APP_EXCEPTION.RAISE_EXCEPTION;
321: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
322: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
323: (
324: l_api_name,
325: G_PKG_NAME,
326: 'FND_API.G_RET_STS_UNEXP_ERROR',
328: x_msg_data,
329: '_Pvt'
330: );
331: APP_EXCEPTION.RAISE_EXCEPTION;
332: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
333: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
334: (
335: l_api_name,
336: G_PKG_NAME,
329: '_Pvt'
330: );
331: APP_EXCEPTION.RAISE_EXCEPTION;
332: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
333: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
334: (
335: l_api_name,
336: G_PKG_NAME,
337: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
333: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
334: (
335: l_api_name,
336: G_PKG_NAME,
337: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
338: x_msg_count,
339: x_msg_data,
340: '_Pvt'
341: );
343: END insert_row;
344: PROCEDURE insert_row
345: (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
348: p_validation_level IN NUMBER,
349: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
350: x_return_status OUT VARCHAR2,
351: x_msg_count OUT NUMBER,
345: (
346: p_api_version IN NUMBER,
347: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
348: p_validation_level IN NUMBER,
349: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
350: x_return_status OUT VARCHAR2,
351: x_msg_count OUT NUMBER,
352: x_msg_data OUT VARCHAR2,
353: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := NULL,
381: l_api_version CONSTANT NUMBER := 1;
382: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
383: l_coveragelevel_rec CoverageLevel_Rec_Type;
384: BEGIN
385: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
386: G_PKG_NAME,
387: l_api_version,
388: p_api_version,
389: p_init_msg_list,
430: l_coveragelevel_rec,
431: x_coverage_level_id,
432: x_object_version_number
433: );
434: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
438: (
433: );
434: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
435: EXCEPTION
436: WHEN FND_API.G_EXC_ERROR THEN
437: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
438: (
439: l_api_name,
440: G_PKG_NAME,
441: 'FND_API.G_RET_STS_ERROR',
444: '_Pvt'
445: );
446: APP_EXCEPTION.RAISE_EXCEPTION;
447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
448: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
449: (
450: l_api_name,
451: G_PKG_NAME,
452: 'FND_API.G_RET_STS_UNEXP_ERROR',
454: x_msg_data,
455: '_Pvt'
456: );
457: APP_EXCEPTION.RAISE_EXCEPTION;
458: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
459: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
460: (
461: l_api_name,
462: G_PKG_NAME,
455: '_Pvt'
456: );
457: APP_EXCEPTION.RAISE_EXCEPTION;
458: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
459: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
460: (
461: l_api_name,
462: G_PKG_NAME,
463: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
459: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
460: (
461: l_api_name,
462: G_PKG_NAME,
463: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
464: x_msg_count,
465: x_msg_data,
466: '_Pvt'
467: );
469: END insert_row;
470: Procedure lock_row
471: (
472: p_api_version IN NUMBER,
473: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
474: p_validation_level IN NUMBER,
475: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
476: x_return_status OUT VARCHAR2,
477: x_msg_count OUT NUMBER,
471: (
472: p_api_version IN NUMBER,
473: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
474: p_validation_level IN NUMBER,
475: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
476: x_return_status OUT VARCHAR2,
477: x_msg_count OUT NUMBER,
478: x_msg_data OUT VARCHAR2,
479: p_coverage_level_id IN NUMBER,
501: lc_object_version_number CS_CONTRACT_COV_LEVELS.OBJECT_VERSION_NUMBER%TYPE;
502: l_row_notfound BOOLEAN := FALSE;
503: lc_row_notfound BOOLEAN := FALSE;
504: BEGIN
505: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
506: G_PKG_NAME,
507: l_api_version,
508: p_api_version,
509: p_init_msg_list,
523: WHEN E_Resource_Busy THEN
524: IF (lock_csr%ISOPEN) THEN
525: CLOSE lock_csr;
526: END IF;
527: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
528: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
529: END;
530:
531: IF ( l_row_notfound ) THEN
534: lc_row_notfound := lchk_csr%NOTFOUND;
535: CLOSE lchk_csr;
536: END IF;
537: IF (lc_row_notfound) THEN
538: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF lc_object_version_number > p_object_version_number THEN
541: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
542: RAISE FND_API.G_EXC_ERROR;
537: IF (lc_row_notfound) THEN
538: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
539: RAISE FND_API.G_EXC_ERROR;
540: ELSIF lc_object_version_number > p_object_version_number THEN
541: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF lc_object_version_number <> p_object_version_number THEN
544: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
545: RAISE FND_API.G_EXC_ERROR;
540: ELSIF lc_object_version_number > p_object_version_number THEN
541: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF lc_object_version_number <> p_object_version_number THEN
544: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF lc_object_version_number = -1 THEN
547: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
548: RAISE FND_API.G_EXC_ERROR;
543: ELSIF lc_object_version_number <> p_object_version_number THEN
544: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
545: RAISE FND_API.G_EXC_ERROR;
546: ELSIF lc_object_version_number = -1 THEN
547: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
551: EXCEPTION
546: ELSIF lc_object_version_number = -1 THEN
547: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
548: RAISE FND_API.G_EXC_ERROR;
549: END IF;
550: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
551: EXCEPTION
552: WHEN FND_API.G_EXC_ERROR THEN
553: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
554: (
549: END IF;
550: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
551: EXCEPTION
552: WHEN FND_API.G_EXC_ERROR THEN
553: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
554: (
555: l_api_name,
556: G_PKG_NAME,
557: 'FND_API.G_RET_STS_ERROR',
560: '_Pvt'
561: );
562: APP_EXCEPTION.RAISE_EXCEPTION;
563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
565: (
566: l_api_name,
567: G_PKG_NAME,
568: 'FND_API.G_RET_STS_UNEXP_ERROR',
570: x_msg_data,
571: '_Pvt'
572: );
573: APP_EXCEPTION.RAISE_EXCEPTION;
574: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
575: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
576: (
577: l_api_name,
578: G_PKG_NAME,
571: '_Pvt'
572: );
573: APP_EXCEPTION.RAISE_EXCEPTION;
574: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
575: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
576: (
577: l_api_name,
578: G_PKG_NAME,
579: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
575: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
576: (
577: l_api_name,
578: G_PKG_NAME,
579: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
580: x_msg_count,
581: x_msg_data,
582: '_Pvt'
583: );
585: END lock_row;
586: Procedure update_row
587: (
588: p_api_version IN NUMBER,
589: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
590: p_validation_level IN NUMBER,
591: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
592: x_return_status OUT VARCHAR2,
593: x_msg_count OUT NUMBER,
587: (
588: p_api_version IN NUMBER,
589: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
590: p_validation_level IN NUMBER,
591: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
592: x_return_status OUT VARCHAR2,
593: x_msg_count OUT NUMBER,
594: x_msg_data OUT VARCHAR2,
595: p_coveragelevel_val_rec IN CoverageLevel_Val_Rec_Type := G_MISS_COVERAGELEVEL_VAL_REC,
619: CLOSE cs_contract_coverage1_csr;
620: IF (l_row_notfound) THEN
621: l_return_status := FND_API.G_RET_STS_ERROR;
622: END IF;
623: IF (x_coveragelevel_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
624: THEN
625: x_coveragelevel_rec.coverage_level_id := l_cs_contract_coverage1.coverage_level_id;
626: END IF;
627: IF (x_coveragelevel_rec.coverage_level_code = TAPI_DEV_KIT.G_MISS_CHAR)
623: IF (x_coveragelevel_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
624: THEN
625: x_coveragelevel_rec.coverage_level_id := l_cs_contract_coverage1.coverage_level_id;
626: END IF;
627: IF (x_coveragelevel_rec.coverage_level_code = TAPI_DEV_KIT.G_MISS_CHAR)
628: THEN
629: x_coveragelevel_rec.coverage_level_code := l_cs_contract_coverage1.coverage_level_code;
630: END IF;
631: IF (x_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM)
627: IF (x_coveragelevel_rec.coverage_level_code = TAPI_DEV_KIT.G_MISS_CHAR)
628: THEN
629: x_coveragelevel_rec.coverage_level_code := l_cs_contract_coverage1.coverage_level_code;
630: END IF;
631: IF (x_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM)
632: THEN
633: x_coveragelevel_rec.coverage_level_value := l_cs_contract_coverage1.coverage_level_value;
634: END IF;
635: IF (x_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
631: IF (x_coveragelevel_rec.coverage_level_value = TAPI_DEV_KIT.G_MISS_NUM)
632: THEN
633: x_coveragelevel_rec.coverage_level_value := l_cs_contract_coverage1.coverage_level_value;
634: END IF;
635: IF (x_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
636: THEN
637: x_coveragelevel_rec.last_update_date := l_cs_contract_coverage1.last_update_date;
638: END IF;
639: IF (x_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
635: IF (x_coveragelevel_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
636: THEN
637: x_coveragelevel_rec.last_update_date := l_cs_contract_coverage1.last_update_date;
638: END IF;
639: IF (x_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
640: THEN
641: x_coveragelevel_rec.last_updated_by := l_cs_contract_coverage1.last_updated_by;
642: END IF;
643: IF (x_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
639: IF (x_coveragelevel_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
640: THEN
641: x_coveragelevel_rec.last_updated_by := l_cs_contract_coverage1.last_updated_by;
642: END IF;
643: IF (x_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
644: THEN
645: x_coveragelevel_rec.creation_date := l_cs_contract_coverage1.creation_date;
646: END IF;
647: IF (x_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
643: IF (x_coveragelevel_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
644: THEN
645: x_coveragelevel_rec.creation_date := l_cs_contract_coverage1.creation_date;
646: END IF;
647: IF (x_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
648: THEN
649: x_coveragelevel_rec.created_by := l_cs_contract_coverage1.created_by;
650: END IF;
651: IF (x_coveragelevel_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
647: IF (x_coveragelevel_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
648: THEN
649: x_coveragelevel_rec.created_by := l_cs_contract_coverage1.created_by;
650: END IF;
651: IF (x_coveragelevel_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
652: THEN
653: x_coveragelevel_rec.last_update_login := l_cs_contract_coverage1.last_update_login;
654: END IF;
655: IF (x_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
651: IF (x_coveragelevel_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
652: THEN
653: x_coveragelevel_rec.last_update_login := l_cs_contract_coverage1.last_update_login;
654: END IF;
655: IF (x_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
656: THEN
657: x_coveragelevel_rec.cp_service_id := l_cs_contract_coverage1.cp_service_id;
658: END IF;
659: IF (x_coveragelevel_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
655: IF (x_coveragelevel_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM)
656: THEN
657: x_coveragelevel_rec.cp_service_id := l_cs_contract_coverage1.cp_service_id;
658: END IF;
659: IF (x_coveragelevel_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
660: THEN
661: x_coveragelevel_rec.attribute1 := l_cs_contract_coverage1.attribute1;
662: END IF;
663: IF (x_coveragelevel_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
659: IF (x_coveragelevel_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
660: THEN
661: x_coveragelevel_rec.attribute1 := l_cs_contract_coverage1.attribute1;
662: END IF;
663: IF (x_coveragelevel_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
664: THEN
665: x_coveragelevel_rec.attribute2 := l_cs_contract_coverage1.attribute2;
666: END IF;
667: IF (x_coveragelevel_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
663: IF (x_coveragelevel_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
664: THEN
665: x_coveragelevel_rec.attribute2 := l_cs_contract_coverage1.attribute2;
666: END IF;
667: IF (x_coveragelevel_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
668: THEN
669: x_coveragelevel_rec.attribute3 := l_cs_contract_coverage1.attribute3;
670: END IF;
671: IF (x_coveragelevel_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
667: IF (x_coveragelevel_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
668: THEN
669: x_coveragelevel_rec.attribute3 := l_cs_contract_coverage1.attribute3;
670: END IF;
671: IF (x_coveragelevel_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
672: THEN
673: x_coveragelevel_rec.attribute4 := l_cs_contract_coverage1.attribute4;
674: END IF;
675: IF (x_coveragelevel_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
671: IF (x_coveragelevel_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
672: THEN
673: x_coveragelevel_rec.attribute4 := l_cs_contract_coverage1.attribute4;
674: END IF;
675: IF (x_coveragelevel_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
676: THEN
677: x_coveragelevel_rec.attribute5 := l_cs_contract_coverage1.attribute5;
678: END IF;
679: IF (x_coveragelevel_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
675: IF (x_coveragelevel_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
676: THEN
677: x_coveragelevel_rec.attribute5 := l_cs_contract_coverage1.attribute5;
678: END IF;
679: IF (x_coveragelevel_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
680: THEN
681: x_coveragelevel_rec.attribute6 := l_cs_contract_coverage1.attribute6;
682: END IF;
683: IF (x_coveragelevel_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
679: IF (x_coveragelevel_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
680: THEN
681: x_coveragelevel_rec.attribute6 := l_cs_contract_coverage1.attribute6;
682: END IF;
683: IF (x_coveragelevel_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
684: THEN
685: x_coveragelevel_rec.attribute7 := l_cs_contract_coverage1.attribute7;
686: END IF;
687: IF (x_coveragelevel_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
683: IF (x_coveragelevel_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
684: THEN
685: x_coveragelevel_rec.attribute7 := l_cs_contract_coverage1.attribute7;
686: END IF;
687: IF (x_coveragelevel_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
688: THEN
689: x_coveragelevel_rec.attribute8 := l_cs_contract_coverage1.attribute8;
690: END IF;
691: IF (x_coveragelevel_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
687: IF (x_coveragelevel_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
688: THEN
689: x_coveragelevel_rec.attribute8 := l_cs_contract_coverage1.attribute8;
690: END IF;
691: IF (x_coveragelevel_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
692: THEN
693: x_coveragelevel_rec.attribute9 := l_cs_contract_coverage1.attribute9;
694: END IF;
695: IF (x_coveragelevel_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
691: IF (x_coveragelevel_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
692: THEN
693: x_coveragelevel_rec.attribute9 := l_cs_contract_coverage1.attribute9;
694: END IF;
695: IF (x_coveragelevel_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
696: THEN
697: x_coveragelevel_rec.attribute10 := l_cs_contract_coverage1.attribute10;
698: END IF;
699: IF (x_coveragelevel_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
695: IF (x_coveragelevel_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
696: THEN
697: x_coveragelevel_rec.attribute10 := l_cs_contract_coverage1.attribute10;
698: END IF;
699: IF (x_coveragelevel_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
700: THEN
701: x_coveragelevel_rec.attribute11 := l_cs_contract_coverage1.attribute11;
702: END IF;
703: IF (x_coveragelevel_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
699: IF (x_coveragelevel_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
700: THEN
701: x_coveragelevel_rec.attribute11 := l_cs_contract_coverage1.attribute11;
702: END IF;
703: IF (x_coveragelevel_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
704: THEN
705: x_coveragelevel_rec.attribute12 := l_cs_contract_coverage1.attribute12;
706: END IF;
707: IF (x_coveragelevel_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
703: IF (x_coveragelevel_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
704: THEN
705: x_coveragelevel_rec.attribute12 := l_cs_contract_coverage1.attribute12;
706: END IF;
707: IF (x_coveragelevel_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
708: THEN
709: x_coveragelevel_rec.attribute13 := l_cs_contract_coverage1.attribute13;
710: END IF;
711: IF (x_coveragelevel_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
707: IF (x_coveragelevel_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
708: THEN
709: x_coveragelevel_rec.attribute13 := l_cs_contract_coverage1.attribute13;
710: END IF;
711: IF (x_coveragelevel_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
712: THEN
713: x_coveragelevel_rec.attribute14 := l_cs_contract_coverage1.attribute14;
714: END IF;
715: IF (x_coveragelevel_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
711: IF (x_coveragelevel_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
712: THEN
713: x_coveragelevel_rec.attribute14 := l_cs_contract_coverage1.attribute14;
714: END IF;
715: IF (x_coveragelevel_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
716: THEN
717: x_coveragelevel_rec.attribute15 := l_cs_contract_coverage1.attribute15;
718: END IF;
719: IF (x_coveragelevel_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
715: IF (x_coveragelevel_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
716: THEN
717: x_coveragelevel_rec.attribute15 := l_cs_contract_coverage1.attribute15;
718: END IF;
719: IF (x_coveragelevel_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
720: THEN
721: x_coveragelevel_rec.context := l_cs_contract_coverage1.context;
722: END IF;
723: IF (x_coveragelevel_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
719: IF (x_coveragelevel_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
720: THEN
721: x_coveragelevel_rec.context := l_cs_contract_coverage1.context;
722: END IF;
723: IF (x_coveragelevel_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
724: THEN
725: x_coveragelevel_rec.object_version_number := l_cs_contract_coverage1.object_version_number;
726: END IF;
727: RETURN(l_return_status);
726: END IF;
727: RETURN(l_return_status);
728: END populate_new_record;
729: BEGIN
730: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
731: G_PKG_NAME,
732: l_api_version,
733: p_api_version,
734: p_init_msg_list,
810: WHERE
811: COVERAGE_LEVEL_ID = l_def_coveragelevel_rec.coverage_level_id
812: ;
813: x_object_version_number := l_def_coveragelevel_rec.OBJECT_VERSION_NUMBER;
814: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
813: x_object_version_number := l_def_coveragelevel_rec.OBJECT_VERSION_NUMBER;
814: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
819: l_api_name,
820: G_PKG_NAME,
821: 'FND_API.G_RET_STS_ERROR',
824: '_Pvt'
825: );
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
829: (
830: l_api_name,
831: G_PKG_NAME,
832: 'FND_API.G_RET_STS_UNEXP_ERROR',
834: x_msg_data,
835: '_Pvt'
836: );
837: APP_EXCEPTION.RAISE_EXCEPTION;
838: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
835: '_Pvt'
836: );
837: APP_EXCEPTION.RAISE_EXCEPTION;
838: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
839: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
840: (
841: l_api_name,
842: G_PKG_NAME,
843: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
844: x_msg_count,
845: x_msg_data,
846: '_Pvt'
847: );
849: END update_row;
850: Procedure update_row
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
854: p_validation_level IN NUMBER,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
851: (
852: p_api_version IN NUMBER,
853: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
854: p_validation_level IN NUMBER,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
855: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
856: x_return_status OUT VARCHAR2,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
857: x_msg_count OUT NUMBER,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
858: x_msg_data OUT VARCHAR2,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
859: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
860: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
861: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
862: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
863: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
864: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
865: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
866: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
867: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
868: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
869: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
870: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
871: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
872: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
878: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
879: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
887: l_api_version CONSTANT NUMBER := 1;
880: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_object_version_number OUT NUMBER) IS
886: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
887: l_api_version CONSTANT NUMBER := 1;
888: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
887: l_api_version CONSTANT NUMBER := 1;
888: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
889: l_coveragelevel_rec CoverageLevel_Val_Rec_Type;
890: BEGIN
891: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
892: G_PKG_NAME,
893: l_api_version,
894: p_api_version,
895: p_init_msg_list,
936: x_msg_data,
937: l_coveragelevel_rec,
938: x_object_version_number
939: );
940: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
944: (
939: );
940: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
944: (
945: l_api_name,
946: G_PKG_NAME,
947: 'FND_API.G_RET_STS_ERROR',
950: '_Pvt'
951: );
952: APP_EXCEPTION.RAISE_EXCEPTION;
953: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
954: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
955: (
956: l_api_name,
957: G_PKG_NAME,
958: 'FND_API.G_RET_STS_UNEXP_ERROR',
960: x_msg_data,
961: '_Pvt'
962: );
963: APP_EXCEPTION.RAISE_EXCEPTION;
964: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
965: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,
961: '_Pvt'
962: );
963: APP_EXCEPTION.RAISE_EXCEPTION;
964: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
965: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,
969: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
965: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
966: (
967: l_api_name,
968: G_PKG_NAME,
969: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
970: x_msg_count,
971: x_msg_data,
972: '_Pvt'
973: );
975: END update_row;
976: Procedure delete_row
977: (
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
980: p_validation_level IN NUMBER,
981: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
982: x_return_status OUT VARCHAR2,
983: x_msg_count OUT NUMBER,
977: (
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
980: p_validation_level IN NUMBER,
981: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
982: x_return_status OUT VARCHAR2,
983: x_msg_count OUT NUMBER,
984: x_msg_data OUT VARCHAR2,
985: p_coverage_level_id IN NUMBER) IS
986: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
987: l_api_version CONSTANT NUMBER := 1;
988: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
989: BEGIN
990: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
991: G_PKG_NAME,
992: l_api_version,
993: p_api_version,
994: p_init_msg_list,
1002: DELETE FROM CS_CONTRACT_COV_LEVELS
1003: WHERE
1004: COVERAGE_LEVEL_ID = p_coverage_level_id
1005: ;
1006: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1007: EXCEPTION
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1010: (
1005: ;
1006: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1007: EXCEPTION
1008: WHEN FND_API.G_EXC_ERROR THEN
1009: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1010: (
1011: l_api_name,
1012: G_PKG_NAME,
1013: 'FND_API.G_RET_STS_ERROR',
1016: '_Pvt'
1017: );
1018: APP_EXCEPTION.RAISE_EXCEPTION;
1019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1020: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1021: (
1022: l_api_name,
1023: G_PKG_NAME,
1024: 'FND_API.G_RET_STS_UNEXP_ERROR',
1026: x_msg_data,
1027: '_Pvt'
1028: );
1029: APP_EXCEPTION.RAISE_EXCEPTION;
1030: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1031: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1027: '_Pvt'
1028: );
1029: APP_EXCEPTION.RAISE_EXCEPTION;
1030: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1031: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1031: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1032: (
1033: l_api_name,
1034: G_PKG_NAME,
1035: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1036: x_msg_count,
1037: x_msg_data,
1038: '_Pvt'
1039: );
1041: END delete_row;
1042: PROCEDURE validate_row
1043: (
1044: p_api_version IN NUMBER,
1045: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1046: p_validation_level IN NUMBER,
1047: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1048: x_return_status OUT VARCHAR2,
1049: x_msg_count OUT NUMBER,
1043: (
1044: p_api_version IN NUMBER,
1045: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1046: p_validation_level IN NUMBER,
1047: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1048: x_return_status OUT VARCHAR2,
1049: x_msg_count OUT NUMBER,
1050: x_msg_data OUT VARCHAR2,
1051: p_coveragelevel_val_rec IN CoverageLevel_Val_Rec_Type := G_MISS_COVERAGELEVEL_VAL_REC) IS
1054: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1055: l_coveragelevel_rec CoverageLevel_Rec_Type;
1056: l_def_coveragelevel_rec CoverageLevel_Rec_Type;
1057: BEGIN
1058: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1059: G_PKG_NAME,
1060: l_api_version,
1061: p_api_version,
1062: p_init_msg_list,
1088: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: END IF;
1092: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1096: (
1091: END IF;
1092: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1096: (
1097: l_api_name,
1098: G_PKG_NAME,
1099: 'FND_API.G_RET_STS_ERROR',
1102: '_Pvt'
1103: );
1104: APP_EXCEPTION.RAISE_EXCEPTION;
1105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1106: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1107: (
1108: l_api_name,
1109: G_PKG_NAME,
1110: 'FND_API.G_RET_STS_UNEXP_ERROR',
1112: x_msg_data,
1113: '_Pvt'
1114: );
1115: APP_EXCEPTION.RAISE_EXCEPTION;
1116: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1117: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1113: '_Pvt'
1114: );
1115: APP_EXCEPTION.RAISE_EXCEPTION;
1116: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1117: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1117: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1122: x_msg_count,
1123: x_msg_data,
1124: '_Pvt'
1125: );
1127: END validate_row;
1128: PROCEDURE validate_row
1129: (
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1132: p_validation_level IN NUMBER,
1133: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1134: x_return_status OUT VARCHAR2,
1135: x_msg_count OUT NUMBER,
1129: (
1130: p_api_version IN NUMBER,
1131: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1132: p_validation_level IN NUMBER,
1133: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1134: x_return_status OUT VARCHAR2,
1135: x_msg_count OUT NUMBER,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1133: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1134: x_return_status OUT VARCHAR2,
1135: x_msg_count OUT NUMBER,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1134: x_return_status OUT VARCHAR2,
1135: x_msg_count OUT NUMBER,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1135: x_msg_count OUT NUMBER,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1136: x_msg_data OUT VARCHAR2,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1137: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1138: p_coverage_level_code IN CS_CONTRACT_COV_LEVELS.COVERAGE_LEVEL_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1139: p_coverage_level_value IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1140: p_last_update_date IN CS_CONTRACT_COV_LEVELS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1141: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1142: p_creation_date IN CS_CONTRACT_COV_LEVELS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1143: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1144: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1145: p_cp_service_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1146: p_attribute1 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1147: p_attribute2 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1148: p_attribute3 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1149: p_attribute4 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1150: p_attribute5 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1151: p_attribute6 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1152: p_attribute7 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1153: p_attribute8 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1154: p_attribute9 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1155: p_attribute10 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1156: p_attribute11 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1164: l_api_version CONSTANT NUMBER := 1;
1157: p_attribute12 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1164: l_api_version CONSTANT NUMBER := 1;
1165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1158: p_attribute13 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_attribute14 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_attribute15 IN CS_CONTRACT_COV_LEVELS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_context IN CS_CONTRACT_COV_LEVELS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1163: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1164: l_api_version CONSTANT NUMBER := 1;
1165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1166: l_coveragelevel_rec CoverageLevel_Val_Rec_Type;
1164: l_api_version CONSTANT NUMBER := 1;
1165: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1166: l_coveragelevel_rec CoverageLevel_Val_Rec_Type;
1167: BEGIN
1168: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1169: G_PKG_NAME,
1170: l_api_version,
1171: p_api_version,
1172: p_init_msg_list,
1212: x_msg_count,
1213: x_msg_data,
1214: l_coveragelevel_rec
1215: );
1216: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1217: EXCEPTION
1218: WHEN FND_API.G_EXC_ERROR THEN
1219: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1220: (
1215: );
1216: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1217: EXCEPTION
1218: WHEN FND_API.G_EXC_ERROR THEN
1219: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1220: (
1221: l_api_name,
1222: G_PKG_NAME,
1223: 'FND_API.G_RET_STS_ERROR',
1226: '_Pvt'
1227: );
1228: APP_EXCEPTION.RAISE_EXCEPTION;
1229: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1230: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1231: (
1232: l_api_name,
1233: G_PKG_NAME,
1234: 'FND_API.G_RET_STS_UNEXP_ERROR',
1236: x_msg_data,
1237: '_Pvt'
1238: );
1239: APP_EXCEPTION.RAISE_EXCEPTION;
1240: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1241: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1242: (
1243: l_api_name,
1244: G_PKG_NAME,
1237: '_Pvt'
1238: );
1239: APP_EXCEPTION.RAISE_EXCEPTION;
1240: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1241: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1242: (
1243: l_api_name,
1244: G_PKG_NAME,
1245: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1241: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1242: (
1243: l_api_name,
1244: G_PKG_NAME,
1245: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1246: x_msg_count,
1247: x_msg_data,
1248: '_Pvt'
1249: );