20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_coveredprd_rec.customer_product_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'customer_product_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_coveredprd_rec.customer_product_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'customer_product_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveredprd_rec.contract_amount IS NULL
31: THEN
25: p_coveredprd_rec.customer_product_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'customer_product_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveredprd_rec.contract_amount IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_amount');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_coveredprd_rec.contract_amount IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_amount');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coveredprd_rec.coverage_level_id IS NULL
36: THEN
30: p_coveredprd_rec.contract_amount IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'contract_amount');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coveredprd_rec.coverage_level_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_coveredprd_rec.coverage_level_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coveredprd_rec.last_update_date IS NULL
41: THEN
35: p_coveredprd_rec.coverage_level_id IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_level_id');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coveredprd_rec.last_update_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_coveredprd_rec.last_update_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_coveredprd_rec.last_updated_by IS NULL
46: THEN
40: p_coveredprd_rec.last_update_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_coveredprd_rec.last_updated_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_coveredprd_rec.last_updated_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_coveredprd_rec.creation_date IS NULL
51: THEN
45: p_coveredprd_rec.last_updated_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_coveredprd_rec.creation_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_coveredprd_rec.creation_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveredprd_rec.created_by IS NULL
56: THEN
50: p_coveredprd_rec.creation_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveredprd_rec.created_by IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
58: l_return_status := FND_API.G_RET_STS_ERROR;
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_coveredprd_rec.created_by IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: END IF;
60: RETURN(l_return_status);
61: END Validate_Item_Attributes;
106: FETCH cs_contract_coverage1_csr INTO l_cs_contract_coverage1;
107: l_row_notfound := cs_contract_coverage1_csr%NOTFOUND;
108: CLOSE cs_contract_coverage1_csr;
109: IF (l_row_notfound) THEN
110: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_LEVEL_ID');
111: RAISE item_not_found_error;
112: END IF;
113: END IF;
114: IF (p_coveredprd_rec.CUSTOMER_PRODUCT_ID IS NOT NULL)
117: FETCH ccpall_pk_csr INTO l_ccpall_pk;
118: l_row_notfound := ccpall_pk_csr%NOTFOUND;
119: CLOSE ccpall_pk_csr;
120: IF (l_row_notfound) THEN
121: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CUSTOMER_PRODUCT_ID');
122: RAISE item_not_found_error;
123: END IF;
124: END IF;
125: RETURN (l_return_status);
202: END migrate;
203: PROCEDURE insert_row
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
207: p_validation_level IN NUMBER,
208: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,
204: (
205: p_api_version IN NUMBER,
206: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
207: p_validation_level IN NUMBER,
208: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
209: x_return_status OUT VARCHAR2,
210: x_msg_count OUT NUMBER,
211: x_msg_data OUT VARCHAR2,
212: p_coveredprd_rec IN CoveredPrd_Rec_Type := G_MISS_COVEREDPRD_REC,
217: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
218: l_coveredprd_rec CoveredPrd_Rec_Type;
219: l_def_coveredprd_rec CoveredPrd_Rec_Type;
220: BEGIN
221: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
222: G_PKG_NAME,
223: l_api_version,
224: p_api_version,
225: p_init_msg_list,
324: l_def_coveredprd_rec.object_version_number);
325: -- Set OUT values
326: x_covered_product_id := l_def_coveredprd_rec.covered_product_id;
327: x_object_version_number := l_def_coveredprd_rec.OBJECT_VERSION_NUMBER;
328: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
332: (
327: x_object_version_number := l_def_coveredprd_rec.OBJECT_VERSION_NUMBER;
328: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
329: EXCEPTION
330: WHEN FND_API.G_EXC_ERROR THEN
331: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
332: (
333: l_api_name,
334: G_PKG_NAME,
335: 'FND_API.G_RET_STS_ERROR',
338: '_Pvt'
339: );
340: APP_EXCEPTION.RAISE_EXCEPTION;
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
343: (
344: l_api_name,
345: G_PKG_NAME,
346: 'FND_API.G_RET_STS_UNEXP_ERROR',
348: x_msg_data,
349: '_Pvt'
350: );
351: APP_EXCEPTION.RAISE_EXCEPTION;
352: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
353: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
354: (
355: l_api_name,
356: G_PKG_NAME,
349: '_Pvt'
350: );
351: APP_EXCEPTION.RAISE_EXCEPTION;
352: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
353: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
354: (
355: l_api_name,
356: G_PKG_NAME,
357: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
353: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
354: (
355: l_api_name,
356: G_PKG_NAME,
357: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
358: x_msg_count,
359: x_msg_data,
360: '_Pvt'
361: );
363: END insert_row;
364: PROCEDURE insert_row
365: (
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
368: p_validation_level IN NUMBER,
369: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
370: x_return_status OUT VARCHAR2,
371: x_msg_count OUT NUMBER,
365: (
366: p_api_version IN NUMBER,
367: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
368: p_validation_level IN NUMBER,
369: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
370: x_return_status OUT VARCHAR2,
371: x_msg_count OUT NUMBER,
372: x_msg_data OUT VARCHAR2,
373: p_customer_product_id IN NUMBER := NULL,
402: l_api_version CONSTANT NUMBER := 1;
403: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
404: l_coveredprd_rec CoveredPrd_Rec_Type;
405: BEGIN
406: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
407: G_PKG_NAME,
408: l_api_version,
409: p_api_version,
410: p_init_msg_list,
452: l_coveredprd_rec,
453: x_covered_product_id,
454: x_object_version_number
455: );
456: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
460: (
455: );
456: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
457: EXCEPTION
458: WHEN FND_API.G_EXC_ERROR THEN
459: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
460: (
461: l_api_name,
462: G_PKG_NAME,
463: 'FND_API.G_RET_STS_ERROR',
466: '_Pvt'
467: );
468: APP_EXCEPTION.RAISE_EXCEPTION;
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
471: (
472: l_api_name,
473: G_PKG_NAME,
474: 'FND_API.G_RET_STS_UNEXP_ERROR',
476: x_msg_data,
477: '_Pvt'
478: );
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
481: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
482: (
483: l_api_name,
484: G_PKG_NAME,
477: '_Pvt'
478: );
479: APP_EXCEPTION.RAISE_EXCEPTION;
480: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
481: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
482: (
483: l_api_name,
484: G_PKG_NAME,
485: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
481: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
482: (
483: l_api_name,
484: G_PKG_NAME,
485: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
486: x_msg_count,
487: x_msg_data,
488: '_Pvt'
489: );
491: END insert_row;
492: Procedure lock_row
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
496: p_validation_level IN NUMBER,
497: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
498: x_return_status OUT VARCHAR2,
499: x_msg_count OUT NUMBER,
493: (
494: p_api_version IN NUMBER,
495: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
496: p_validation_level IN NUMBER,
497: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
498: x_return_status OUT VARCHAR2,
499: x_msg_count OUT NUMBER,
500: x_msg_data OUT VARCHAR2,
501: p_covered_product_id IN NUMBER,
523: lc_object_version_number CS_COVERED_PRODUCTS.OBJECT_VERSION_NUMBER%TYPE;
524: l_row_notfound BOOLEAN := FALSE;
525: lc_row_notfound BOOLEAN := FALSE;
526: BEGIN
527: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
528: G_PKG_NAME,
529: l_api_version,
530: p_api_version,
531: p_init_msg_list,
545: WHEN E_Resource_Busy THEN
546: IF (lock_csr%ISOPEN) THEN
547: CLOSE lock_csr;
548: END IF;
549: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
550: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
551: END;
552:
553: IF ( l_row_notfound ) THEN
556: lc_row_notfound := lchk_csr%NOTFOUND;
557: CLOSE lchk_csr;
558: END IF;
559: IF (lc_row_notfound) THEN
560: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
561: RAISE FND_API.G_EXC_ERROR;
562: ELSIF lc_object_version_number > p_object_version_number THEN
563: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
564: RAISE FND_API.G_EXC_ERROR;
559: IF (lc_row_notfound) THEN
560: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
561: RAISE FND_API.G_EXC_ERROR;
562: ELSIF lc_object_version_number > p_object_version_number THEN
563: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF lc_object_version_number <> p_object_version_number THEN
566: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
567: RAISE FND_API.G_EXC_ERROR;
562: ELSIF lc_object_version_number > p_object_version_number THEN
563: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
564: RAISE FND_API.G_EXC_ERROR;
565: ELSIF lc_object_version_number <> p_object_version_number THEN
566: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
567: RAISE FND_API.G_EXC_ERROR;
568: ELSIF lc_object_version_number = -1 THEN
569: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
570: RAISE FND_API.G_EXC_ERROR;
565: ELSIF lc_object_version_number <> p_object_version_number THEN
566: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
567: RAISE FND_API.G_EXC_ERROR;
568: ELSIF lc_object_version_number = -1 THEN
569: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
573: EXCEPTION
568: ELSIF lc_object_version_number = -1 THEN
569: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
570: RAISE FND_API.G_EXC_ERROR;
571: END IF;
572: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
573: EXCEPTION
574: WHEN FND_API.G_EXC_ERROR THEN
575: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
576: (
571: END IF;
572: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
573: EXCEPTION
574: WHEN FND_API.G_EXC_ERROR THEN
575: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
576: (
577: l_api_name,
578: G_PKG_NAME,
579: 'FND_API.G_RET_STS_ERROR',
582: '_Pvt'
583: );
584: APP_EXCEPTION.RAISE_EXCEPTION;
585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
586: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
587: (
588: l_api_name,
589: G_PKG_NAME,
590: 'FND_API.G_RET_STS_UNEXP_ERROR',
592: x_msg_data,
593: '_Pvt'
594: );
595: APP_EXCEPTION.RAISE_EXCEPTION;
596: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
597: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
598: (
599: l_api_name,
600: G_PKG_NAME,
593: '_Pvt'
594: );
595: APP_EXCEPTION.RAISE_EXCEPTION;
596: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
597: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
598: (
599: l_api_name,
600: G_PKG_NAME,
601: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
597: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
598: (
599: l_api_name,
600: G_PKG_NAME,
601: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
602: x_msg_count,
603: x_msg_data,
604: '_Pvt'
605: );
607: END lock_row;
608: Procedure update_row
609: (
610: p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
612: p_validation_level IN NUMBER,
613: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
614: x_return_status OUT VARCHAR2,
615: x_msg_count OUT NUMBER,
609: (
610: p_api_version IN NUMBER,
611: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
612: p_validation_level IN NUMBER,
613: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
614: x_return_status OUT VARCHAR2,
615: x_msg_count OUT NUMBER,
616: x_msg_data OUT VARCHAR2,
617: p_coveredprd_val_rec IN CoveredPrd_Val_Rec_Type := G_MISS_COVEREDPRD_VAL_REC,
641: CLOSE cs_covered_products_pk_csr;
642: IF (l_row_notfound) THEN
643: l_return_status := FND_API.G_RET_STS_ERROR;
644: END IF;
645: IF (x_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_coveredprd_rec.customer_product_id := l_cs_covered_products_pk.customer_product_id;
648: END IF;
649: IF (x_coveredprd_rec.covered_product_id = TAPI_DEV_KIT.G_MISS_NUM)
645: IF (x_coveredprd_rec.customer_product_id = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_coveredprd_rec.customer_product_id := l_cs_covered_products_pk.customer_product_id;
648: END IF;
649: IF (x_coveredprd_rec.covered_product_id = TAPI_DEV_KIT.G_MISS_NUM)
650: THEN
651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;
652: END IF;
653: IF (x_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
649: IF (x_coveredprd_rec.covered_product_id = TAPI_DEV_KIT.G_MISS_NUM)
650: THEN
651: x_coveredprd_rec.covered_product_id := l_cs_covered_products_pk.covered_product_id;
652: END IF;
653: IF (x_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;
656: END IF;
657: IF (x_coveredprd_rec.list_price = TAPI_DEV_KIT.G_MISS_NUM)
653: IF (x_coveredprd_rec.contract_amount = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_coveredprd_rec.contract_amount := l_cs_covered_products_pk.contract_amount;
656: END IF;
657: IF (x_coveredprd_rec.list_price = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;
660: END IF;
661: IF (x_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
657: IF (x_coveredprd_rec.list_price = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_coveredprd_rec.list_price := l_cs_covered_products_pk.list_price;
660: END IF;
661: IF (x_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
662: THEN
663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;
664: END IF;
665: IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
661: IF (x_coveredprd_rec.coverage_level_id = TAPI_DEV_KIT.G_MISS_NUM)
662: THEN
663: x_coveredprd_rec.coverage_level_id := l_cs_covered_products_pk.coverage_level_id;
664: END IF;
665: IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;
668: END IF;
669: IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
665: IF (x_coveredprd_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_coveredprd_rec.last_update_date := l_cs_covered_products_pk.last_update_date;
668: END IF;
669: IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
670: THEN
671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;
672: END IF;
673: IF (x_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
669: IF (x_coveredprd_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
670: THEN
671: x_coveredprd_rec.last_updated_by := l_cs_covered_products_pk.last_updated_by;
672: END IF;
673: IF (x_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
674: THEN
675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;
676: END IF;
677: IF (x_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
673: IF (x_coveredprd_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
674: THEN
675: x_coveredprd_rec.creation_date := l_cs_covered_products_pk.creation_date;
676: END IF;
677: IF (x_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
678: THEN
679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;
680: END IF;
681: IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
677: IF (x_coveredprd_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
678: THEN
679: x_coveredprd_rec.created_by := l_cs_covered_products_pk.created_by;
680: END IF;
681: IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
682: THEN
683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;
684: END IF;
685: IF (x_coveredprd_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
681: IF (x_coveredprd_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
682: THEN
683: x_coveredprd_rec.last_update_login := l_cs_covered_products_pk.last_update_login;
684: END IF;
685: IF (x_coveredprd_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;
688: END IF;
689: IF (x_coveredprd_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
685: IF (x_coveredprd_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_coveredprd_rec.attribute1 := l_cs_covered_products_pk.attribute1;
688: END IF;
689: IF (x_coveredprd_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;
692: END IF;
693: IF (x_coveredprd_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
689: IF (x_coveredprd_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_coveredprd_rec.attribute2 := l_cs_covered_products_pk.attribute2;
692: END IF;
693: IF (x_coveredprd_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;
696: END IF;
697: IF (x_coveredprd_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
693: IF (x_coveredprd_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_coveredprd_rec.attribute3 := l_cs_covered_products_pk.attribute3;
696: END IF;
697: IF (x_coveredprd_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;
700: END IF;
701: IF (x_coveredprd_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
697: IF (x_coveredprd_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_coveredprd_rec.attribute4 := l_cs_covered_products_pk.attribute4;
700: END IF;
701: IF (x_coveredprd_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;
704: END IF;
705: IF (x_coveredprd_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
701: IF (x_coveredprd_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_coveredprd_rec.attribute5 := l_cs_covered_products_pk.attribute5;
704: END IF;
705: IF (x_coveredprd_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;
708: END IF;
709: IF (x_coveredprd_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
705: IF (x_coveredprd_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_coveredprd_rec.attribute6 := l_cs_covered_products_pk.attribute6;
708: END IF;
709: IF (x_coveredprd_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;
712: END IF;
713: IF (x_coveredprd_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
709: IF (x_coveredprd_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_coveredprd_rec.attribute7 := l_cs_covered_products_pk.attribute7;
712: END IF;
713: IF (x_coveredprd_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;
716: END IF;
717: IF (x_coveredprd_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
713: IF (x_coveredprd_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_coveredprd_rec.attribute8 := l_cs_covered_products_pk.attribute8;
716: END IF;
717: IF (x_coveredprd_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;
720: END IF;
721: IF (x_coveredprd_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
717: IF (x_coveredprd_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_coveredprd_rec.attribute9 := l_cs_covered_products_pk.attribute9;
720: END IF;
721: IF (x_coveredprd_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;
724: END IF;
725: IF (x_coveredprd_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
721: IF (x_coveredprd_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_coveredprd_rec.attribute10 := l_cs_covered_products_pk.attribute10;
724: END IF;
725: IF (x_coveredprd_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;
728: END IF;
729: IF (x_coveredprd_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
725: IF (x_coveredprd_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_coveredprd_rec.attribute11 := l_cs_covered_products_pk.attribute11;
728: END IF;
729: IF (x_coveredprd_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;
732: END IF;
733: IF (x_coveredprd_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
729: IF (x_coveredprd_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_coveredprd_rec.attribute12 := l_cs_covered_products_pk.attribute12;
732: END IF;
733: IF (x_coveredprd_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
734: THEN
735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;
736: END IF;
737: IF (x_coveredprd_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
733: IF (x_coveredprd_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
734: THEN
735: x_coveredprd_rec.attribute13 := l_cs_covered_products_pk.attribute13;
736: END IF;
737: IF (x_coveredprd_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
738: THEN
739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;
740: END IF;
741: IF (x_coveredprd_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
737: IF (x_coveredprd_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
738: THEN
739: x_coveredprd_rec.attribute14 := l_cs_covered_products_pk.attribute14;
740: END IF;
741: IF (x_coveredprd_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
742: THEN
743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;
744: END IF;
745: IF (x_coveredprd_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
741: IF (x_coveredprd_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
742: THEN
743: x_coveredprd_rec.attribute15 := l_cs_covered_products_pk.attribute15;
744: END IF;
745: IF (x_coveredprd_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
746: THEN
747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;
748: END IF;
749: IF (x_coveredprd_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
745: IF (x_coveredprd_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
746: THEN
747: x_coveredprd_rec.context := l_cs_covered_products_pk.context;
748: END IF;
749: IF (x_coveredprd_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
750: THEN
751: x_coveredprd_rec.object_version_number := l_cs_covered_products_pk.object_version_number;
752: END IF;
753: RETURN(l_return_status);
752: END IF;
753: RETURN(l_return_status);
754: END populate_new_record;
755: BEGIN
756: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
757: G_PKG_NAME,
758: l_api_version,
759: p_api_version,
760: p_init_msg_list,
837: WHERE
838: COVERED_PRODUCT_ID = l_def_coveredprd_rec.covered_product_id
839: ;
840: x_object_version_number := l_def_coveredprd_rec.OBJECT_VERSION_NUMBER;
841: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
842: EXCEPTION
843: WHEN FND_API.G_EXC_ERROR THEN
844: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
845: (
840: x_object_version_number := l_def_coveredprd_rec.OBJECT_VERSION_NUMBER;
841: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
842: EXCEPTION
843: WHEN FND_API.G_EXC_ERROR THEN
844: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
845: (
846: l_api_name,
847: G_PKG_NAME,
848: 'FND_API.G_RET_STS_ERROR',
851: '_Pvt'
852: );
853: APP_EXCEPTION.RAISE_EXCEPTION;
854: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
855: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
856: (
857: l_api_name,
858: G_PKG_NAME,
859: 'FND_API.G_RET_STS_UNEXP_ERROR',
861: x_msg_data,
862: '_Pvt'
863: );
864: APP_EXCEPTION.RAISE_EXCEPTION;
865: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
866: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,
862: '_Pvt'
863: );
864: APP_EXCEPTION.RAISE_EXCEPTION;
865: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
866: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,
870: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
866: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
867: (
868: l_api_name,
869: G_PKG_NAME,
870: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
871: x_msg_count,
872: x_msg_data,
873: '_Pvt'
874: );
876: END update_row;
877: Procedure update_row
878: (
879: p_api_version IN NUMBER,
880: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
881: p_validation_level IN NUMBER,
882: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
883: x_return_status OUT VARCHAR2,
884: x_msg_count OUT NUMBER,
878: (
879: p_api_version IN NUMBER,
880: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
881: p_validation_level IN NUMBER,
882: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
883: x_return_status OUT VARCHAR2,
884: x_msg_count OUT NUMBER,
885: x_msg_data OUT VARCHAR2,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
882: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
883: x_return_status OUT VARCHAR2,
884: x_msg_count OUT NUMBER,
885: x_msg_data OUT VARCHAR2,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
883: x_return_status OUT VARCHAR2,
884: x_msg_count OUT NUMBER,
885: x_msg_data OUT VARCHAR2,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
884: x_msg_count OUT NUMBER,
885: x_msg_data OUT VARCHAR2,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
885: x_msg_data OUT VARCHAR2,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
886: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
887: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
888: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
899: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
900: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
901: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
902: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
903: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
904: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
905: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
906: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
914: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
907: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
914: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
915: l_api_version CONSTANT NUMBER := 1;
908: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
909: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
910: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
911: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
912: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
913: x_object_version_number OUT NUMBER) IS
914: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
915: l_api_version CONSTANT NUMBER := 1;
916: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
915: l_api_version CONSTANT NUMBER := 1;
916: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
917: l_coveredprd_rec CoveredPrd_Val_Rec_Type;
918: BEGIN
919: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
920: G_PKG_NAME,
921: l_api_version,
922: p_api_version,
923: p_init_msg_list,
965: x_msg_data,
966: l_coveredprd_rec,
967: x_object_version_number
968: );
969: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
973: (
968: );
969: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
970: EXCEPTION
971: WHEN FND_API.G_EXC_ERROR THEN
972: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
973: (
974: l_api_name,
975: G_PKG_NAME,
976: 'FND_API.G_RET_STS_ERROR',
979: '_Pvt'
980: );
981: APP_EXCEPTION.RAISE_EXCEPTION;
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
983: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
984: (
985: l_api_name,
986: G_PKG_NAME,
987: 'FND_API.G_RET_STS_UNEXP_ERROR',
989: x_msg_data,
990: '_Pvt'
991: );
992: APP_EXCEPTION.RAISE_EXCEPTION;
993: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
994: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
995: (
996: l_api_name,
997: G_PKG_NAME,
990: '_Pvt'
991: );
992: APP_EXCEPTION.RAISE_EXCEPTION;
993: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
994: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
995: (
996: l_api_name,
997: G_PKG_NAME,
998: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
994: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
995: (
996: l_api_name,
997: G_PKG_NAME,
998: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
999: x_msg_count,
1000: x_msg_data,
1001: '_Pvt'
1002: );
1004: END update_row;
1005: Procedure delete_row
1006: (
1007: p_api_version IN NUMBER,
1008: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1009: p_validation_level IN NUMBER,
1010: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1011: x_return_status OUT VARCHAR2,
1012: x_msg_count OUT NUMBER,
1006: (
1007: p_api_version IN NUMBER,
1008: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1009: p_validation_level IN NUMBER,
1010: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1011: x_return_status OUT VARCHAR2,
1012: x_msg_count OUT NUMBER,
1013: x_msg_data OUT VARCHAR2,
1014: p_covered_product_id IN NUMBER) IS
1015: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1016: l_api_version CONSTANT NUMBER := 1;
1017: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1018: BEGIN
1019: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1020: G_PKG_NAME,
1021: l_api_version,
1022: p_api_version,
1023: p_init_msg_list,
1031: DELETE FROM CS_COVERED_PRODUCTS
1032: WHERE
1033: COVERED_PRODUCT_ID = p_covered_product_id
1034: ;
1035: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1036: EXCEPTION
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1039: (
1034: ;
1035: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1036: EXCEPTION
1037: WHEN FND_API.G_EXC_ERROR THEN
1038: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1039: (
1040: l_api_name,
1041: G_PKG_NAME,
1042: 'FND_API.G_RET_STS_ERROR',
1045: '_Pvt'
1046: );
1047: APP_EXCEPTION.RAISE_EXCEPTION;
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1050: (
1051: l_api_name,
1052: G_PKG_NAME,
1053: 'FND_API.G_RET_STS_UNEXP_ERROR',
1055: x_msg_data,
1056: '_Pvt'
1057: );
1058: APP_EXCEPTION.RAISE_EXCEPTION;
1059: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1060: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1061: (
1062: l_api_name,
1063: G_PKG_NAME,
1056: '_Pvt'
1057: );
1058: APP_EXCEPTION.RAISE_EXCEPTION;
1059: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1060: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1061: (
1062: l_api_name,
1063: G_PKG_NAME,
1064: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1060: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1061: (
1062: l_api_name,
1063: G_PKG_NAME,
1064: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1065: x_msg_count,
1066: x_msg_data,
1067: '_Pvt'
1068: );
1070: END delete_row;
1071: PROCEDURE validate_row
1072: (
1073: p_api_version IN NUMBER,
1074: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1075: p_validation_level IN NUMBER,
1076: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1077: x_return_status OUT VARCHAR2,
1078: x_msg_count OUT NUMBER,
1072: (
1073: p_api_version IN NUMBER,
1074: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1075: p_validation_level IN NUMBER,
1076: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1077: x_return_status OUT VARCHAR2,
1078: x_msg_count OUT NUMBER,
1079: x_msg_data OUT VARCHAR2,
1080: p_coveredprd_val_rec IN CoveredPrd_Val_Rec_Type := G_MISS_COVEREDPRD_VAL_REC) IS
1083: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1084: l_coveredprd_rec CoveredPrd_Rec_Type;
1085: l_def_coveredprd_rec CoveredPrd_Rec_Type;
1086: BEGIN
1087: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1088: G_PKG_NAME,
1089: l_api_version,
1090: p_api_version,
1091: p_init_msg_list,
1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;
1121: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1122: EXCEPTION
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1125: (
1120: END IF;
1121: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1122: EXCEPTION
1123: WHEN FND_API.G_EXC_ERROR THEN
1124: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1125: (
1126: l_api_name,
1127: G_PKG_NAME,
1128: 'FND_API.G_RET_STS_ERROR',
1131: '_Pvt'
1132: );
1133: APP_EXCEPTION.RAISE_EXCEPTION;
1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1135: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1136: (
1137: l_api_name,
1138: G_PKG_NAME,
1139: 'FND_API.G_RET_STS_UNEXP_ERROR',
1141: x_msg_data,
1142: '_Pvt'
1143: );
1144: APP_EXCEPTION.RAISE_EXCEPTION;
1145: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1146: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1147: (
1148: l_api_name,
1149: G_PKG_NAME,
1142: '_Pvt'
1143: );
1144: APP_EXCEPTION.RAISE_EXCEPTION;
1145: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1146: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1147: (
1148: l_api_name,
1149: G_PKG_NAME,
1150: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1146: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1147: (
1148: l_api_name,
1149: G_PKG_NAME,
1150: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1151: x_msg_count,
1152: x_msg_data,
1153: '_Pvt'
1154: );
1156: END validate_row;
1157: PROCEDURE validate_row
1158: (
1159: p_api_version IN NUMBER,
1160: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1161: p_validation_level IN NUMBER,
1162: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1163: x_return_status OUT VARCHAR2,
1164: x_msg_count OUT NUMBER,
1158: (
1159: p_api_version IN NUMBER,
1160: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1161: p_validation_level IN NUMBER,
1162: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1163: x_return_status OUT VARCHAR2,
1164: x_msg_count OUT NUMBER,
1165: x_msg_data OUT VARCHAR2,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1163: x_return_status OUT VARCHAR2,
1164: x_msg_count OUT NUMBER,
1165: x_msg_data OUT VARCHAR2,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1163: x_return_status OUT VARCHAR2,
1164: x_msg_count OUT NUMBER,
1165: x_msg_data OUT VARCHAR2,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: x_msg_count OUT NUMBER,
1165: x_msg_data OUT VARCHAR2,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1165: x_msg_data OUT VARCHAR2,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1166: p_customer_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1167: p_covered_product_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1168: p_contract_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_list_price IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_coverage_level_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_last_update_date IN CS_COVERED_PRODUCTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_creation_date IN CS_COVERED_PRODUCTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute1 IN CS_COVERED_PRODUCTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute2 IN CS_COVERED_PRODUCTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute3 IN CS_COVERED_PRODUCTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_attribute4 IN CS_COVERED_PRODUCTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_attribute5 IN CS_COVERED_PRODUCTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1181: p_attribute6 IN CS_COVERED_PRODUCTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1182: p_attribute7 IN CS_COVERED_PRODUCTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1183: p_attribute8 IN CS_COVERED_PRODUCTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1184: p_attribute9 IN CS_COVERED_PRODUCTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1185: p_attribute10 IN CS_COVERED_PRODUCTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1186: p_attribute11 IN CS_COVERED_PRODUCTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1194: l_api_version CONSTANT NUMBER := 1;
1187: p_attribute12 IN CS_COVERED_PRODUCTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1194: l_api_version CONSTANT NUMBER := 1;
1195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1188: p_attribute13 IN CS_COVERED_PRODUCTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1189: p_attribute14 IN CS_COVERED_PRODUCTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1190: p_attribute15 IN CS_COVERED_PRODUCTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1191: p_context IN CS_COVERED_PRODUCTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1192: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1193: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1194: l_api_version CONSTANT NUMBER := 1;
1195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1196: l_coveredprd_rec CoveredPrd_Val_Rec_Type;
1194: l_api_version CONSTANT NUMBER := 1;
1195: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1196: l_coveredprd_rec CoveredPrd_Val_Rec_Type;
1197: BEGIN
1198: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1199: G_PKG_NAME,
1200: l_api_version,
1201: p_api_version,
1202: p_init_msg_list,
1243: x_msg_count,
1244: x_msg_data,
1245: l_coveredprd_rec
1246: );
1247: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1248: EXCEPTION
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1246: );
1247: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1248: EXCEPTION
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'FND_API.G_RET_STS_ERROR',
1257: '_Pvt'
1258: );
1259: APP_EXCEPTION.RAISE_EXCEPTION;
1260: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1261: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1262: (
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'FND_API.G_RET_STS_UNEXP_ERROR',
1267: x_msg_data,
1268: '_Pvt'
1269: );
1270: APP_EXCEPTION.RAISE_EXCEPTION;
1271: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1272: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1273: (
1274: l_api_name,
1275: G_PKG_NAME,
1268: '_Pvt'
1269: );
1270: APP_EXCEPTION.RAISE_EXCEPTION;
1271: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1272: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1273: (
1274: l_api_name,
1275: G_PKG_NAME,
1276: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1272: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1273: (
1274: l_api_name,
1275: G_PKG_NAME,
1276: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1277: x_msg_count,
1278: x_msg_data,
1279: '_Pvt'
1280: );