20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttype_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
23: BEGIN
24: IF p_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttype_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_contracttype_rec.last_update_date IS NULL
31: THEN
25: p_contracttype_rec.name IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'name');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_contracttype_rec.last_update_date IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
33: l_return_status := FND_API.G_RET_STS_ERROR;
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_contracttype_rec.last_update_date IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttype_rec.last_updated_by IS NULL
36: THEN
30: p_contracttype_rec.last_update_date IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttype_rec.last_updated_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
35: p_contracttype_rec.last_updated_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_contracttype_rec.creation_date IS NULL
41: THEN
35: p_contracttype_rec.last_updated_by IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_contracttype_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
40: p_contracttype_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttype_rec.created_by IS NULL
46: THEN
40: p_contracttype_rec.creation_date IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttype_rec.created_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_contracttype_rec.created_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: END IF;
50: RETURN(l_return_status);
51: END Validate_Item_Attributes;
91: FETCH ra_cust_trx_types_pk_csr INTO l_ra_cust_trx_types_pk;
92: l_row_notfound := ra_cust_trx_types_pk_csr%NOTFOUND;
93: CLOSE ra_cust_trx_types_pk_csr;
94: IF (l_row_notfound) THEN
95: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CUST_TRX_TYPE_ID');
96: RAISE item_not_found_error;
97: END IF;
98: END IF;
99: RETURN (l_return_status);
178: END migrate;
179: PROCEDURE insert_row
180: (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
183: p_validation_level IN NUMBER,
184: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
185: x_return_status OUT VARCHAR2,
186: x_msg_count OUT NUMBER,
180: (
181: p_api_version IN NUMBER,
182: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
183: p_validation_level IN NUMBER,
184: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
185: x_return_status OUT VARCHAR2,
186: x_msg_count OUT NUMBER,
187: x_msg_data OUT VARCHAR2,
188: p_contracttype_rec IN ContractType_Rec_Type := G_MISS_CONTRACTTYPE_REC,
193: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
194: l_contracttype_rec ContractType_Rec_Type;
195: l_def_contracttype_rec ContractType_Rec_Type;
196: BEGIN
197: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
198: G_PKG_NAME,
199: l_api_version,
200: p_api_version,
201: p_init_msg_list,
302: l_def_contracttype_rec.object_version_number);
303: -- Set OUT values
304: x_contract_type_id := l_def_contracttype_rec.contract_type_id;
305: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
306: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
305: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
306: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,
313: 'FND_API.G_RET_STS_ERROR',
316: '_Pvt'
317: );
318: APP_EXCEPTION.RAISE_EXCEPTION;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
321: (
322: l_api_name,
323: G_PKG_NAME,
324: 'FND_API.G_RET_STS_UNEXP_ERROR',
326: x_msg_data,
327: '_Pvt'
328: );
329: APP_EXCEPTION.RAISE_EXCEPTION;
330: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
331: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
332: (
333: l_api_name,
334: G_PKG_NAME,
327: '_Pvt'
328: );
329: APP_EXCEPTION.RAISE_EXCEPTION;
330: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
331: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
332: (
333: l_api_name,
334: G_PKG_NAME,
335: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
331: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
332: (
333: l_api_name,
334: G_PKG_NAME,
335: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
336: x_msg_count,
337: x_msg_data,
338: '_Pvt'
339: );
341: END insert_row;
342: PROCEDURE insert_row
343: (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
346: p_validation_level IN NUMBER,
347: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
348: x_return_status OUT VARCHAR2,
349: x_msg_count OUT NUMBER,
343: (
344: p_api_version IN NUMBER,
345: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
346: p_validation_level IN NUMBER,
347: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
348: x_return_status OUT VARCHAR2,
349: x_msg_count OUT NUMBER,
350: x_msg_data OUT VARCHAR2,
351: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := NULL,
381: l_api_version CONSTANT NUMBER := 1;
382: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
383: l_contracttype_rec ContractType_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,
432: l_contracttype_rec,
433: x_contract_type_id,
434: x_object_version_number
435: );
436: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
440: (
435: );
436: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
440: (
441: l_api_name,
442: G_PKG_NAME,
443: 'FND_API.G_RET_STS_ERROR',
446: '_Pvt'
447: );
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
451: (
452: l_api_name,
453: G_PKG_NAME,
454: 'FND_API.G_RET_STS_UNEXP_ERROR',
456: x_msg_data,
457: '_Pvt'
458: );
459: APP_EXCEPTION.RAISE_EXCEPTION;
460: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
461: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
462: (
463: l_api_name,
464: G_PKG_NAME,
457: '_Pvt'
458: );
459: APP_EXCEPTION.RAISE_EXCEPTION;
460: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
461: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
462: (
463: l_api_name,
464: G_PKG_NAME,
465: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
461: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
462: (
463: l_api_name,
464: G_PKG_NAME,
465: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
466: x_msg_count,
467: x_msg_data,
468: '_Pvt'
469: );
471: END insert_row;
472: Procedure lock_row
473: (
474: p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
476: p_validation_level IN NUMBER,
477: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
478: x_return_status OUT VARCHAR2,
479: x_msg_count OUT NUMBER,
473: (
474: p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
476: p_validation_level IN NUMBER,
477: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
478: x_return_status OUT VARCHAR2,
479: x_msg_count OUT NUMBER,
480: x_msg_data OUT VARCHAR2,
481: p_contract_type_id IN NUMBER,
503: lc_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
504: l_row_notfound BOOLEAN := FALSE;
505: lc_row_notfound BOOLEAN := FALSE;
506: BEGIN
507: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
508: G_PKG_NAME,
509: l_api_version,
510: p_api_version,
511: p_init_msg_list,
525: WHEN E_Resource_Busy THEN
526: IF (lock_csr%ISOPEN) THEN
527: CLOSE lock_csr;
528: END IF;
529: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
530: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
531: END;
532:
533: IF ( l_row_notfound ) THEN
536: lc_row_notfound := lchk_csr%NOTFOUND;
537: CLOSE lchk_csr;
538: END IF;
539: IF (lc_row_notfound) THEN
540: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
541: RAISE FND_API.G_EXC_ERROR;
542: ELSIF lc_object_version_number > p_object_version_number THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
539: IF (lc_row_notfound) THEN
540: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
541: RAISE FND_API.G_EXC_ERROR;
542: ELSIF lc_object_version_number > p_object_version_number THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
542: ELSIF lc_object_version_number > p_object_version_number THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number = -1 THEN
549: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
550: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number = -1 THEN
549: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
553: EXCEPTION
548: ELSIF lc_object_version_number = -1 THEN
549: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
556: (
551: END IF;
552: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
556: (
557: l_api_name,
558: G_PKG_NAME,
559: 'FND_API.G_RET_STS_ERROR',
562: '_Pvt'
563: );
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
567: (
568: l_api_name,
569: G_PKG_NAME,
570: 'FND_API.G_RET_STS_UNEXP_ERROR',
572: x_msg_data,
573: '_Pvt'
574: );
575: APP_EXCEPTION.RAISE_EXCEPTION;
576: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
577: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
578: (
579: l_api_name,
580: G_PKG_NAME,
573: '_Pvt'
574: );
575: APP_EXCEPTION.RAISE_EXCEPTION;
576: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
577: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
578: (
579: l_api_name,
580: G_PKG_NAME,
581: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
577: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
578: (
579: l_api_name,
580: G_PKG_NAME,
581: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
582: x_msg_count,
583: x_msg_data,
584: '_Pvt'
585: );
587: END lock_row;
588: Procedure update_row
589: (
590: p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
592: p_validation_level IN NUMBER,
593: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
594: x_return_status OUT VARCHAR2,
595: x_msg_count OUT NUMBER,
589: (
590: p_api_version IN NUMBER,
591: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
592: p_validation_level IN NUMBER,
593: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
594: x_return_status OUT VARCHAR2,
595: x_msg_count OUT NUMBER,
596: x_msg_data OUT VARCHAR2,
597: p_contracttype_val_rec IN ContractType_Val_Rec_Type := G_MISS_CONTRACTTYPE_VAL_REC,
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625: IF (x_contracttype_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
626: THEN
627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;
628: END IF;
629: IF (x_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
625: IF (x_contracttype_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
626: THEN
627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;
628: END IF;
629: IF (x_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
630: THEN
631: x_contracttype_rec.name := l_cs_contract_types_pk.name;
632: END IF;
633: IF (x_contracttype_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
629: IF (x_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
630: THEN
631: x_contracttype_rec.name := l_cs_contract_types_pk.name;
632: END IF;
633: IF (x_contracttype_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
634: THEN
635: x_contracttype_rec.description := l_cs_contract_types_pk.description;
636: END IF;
637: IF (x_contracttype_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
633: IF (x_contracttype_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
634: THEN
635: x_contracttype_rec.description := l_cs_contract_types_pk.description;
636: END IF;
637: IF (x_contracttype_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;
640: END IF;
641: IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
637: IF (x_contracttype_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;
640: END IF;
641: IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
642: THEN
643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;
644: END IF;
645: IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
641: IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
642: THEN
643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;
644: END IF;
645: IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;
648: END IF;
649: IF (x_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
645: IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;
648: END IF;
649: IF (x_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;
652: END IF;
653: IF (x_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
649: IF (x_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;
652: END IF;
653: IF (x_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;
656: END IF;
657: IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
653: IF (x_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;
656: END IF;
657: IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;
660: END IF;
661: IF (x_contracttype_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
657: IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;
660: END IF;
661: IF (x_contracttype_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
662: THEN
663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;
664: END IF;
665: IF (x_contracttype_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
661: IF (x_contracttype_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
662: THEN
663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;
664: END IF;
665: IF (x_contracttype_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;
668: END IF;
669: IF (x_contracttype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
665: IF (x_contracttype_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;
668: END IF;
669: IF (x_contracttype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;
672: END IF;
673: IF (x_contracttype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
669: IF (x_contracttype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;
672: END IF;
673: IF (x_contracttype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;
676: END IF;
677: IF (x_contracttype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
673: IF (x_contracttype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;
676: END IF;
677: IF (x_contracttype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;
680: END IF;
681: IF (x_contracttype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
677: IF (x_contracttype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;
680: END IF;
681: IF (x_contracttype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;
684: END IF;
685: IF (x_contracttype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
681: IF (x_contracttype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;
684: END IF;
685: IF (x_contracttype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;
688: END IF;
689: IF (x_contracttype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
685: IF (x_contracttype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;
688: END IF;
689: IF (x_contracttype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;
692: END IF;
693: IF (x_contracttype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
689: IF (x_contracttype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;
692: END IF;
693: IF (x_contracttype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;
696: END IF;
697: IF (x_contracttype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
693: IF (x_contracttype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;
696: END IF;
697: IF (x_contracttype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;
700: END IF;
701: IF (x_contracttype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
697: IF (x_contracttype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;
700: END IF;
701: IF (x_contracttype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;
704: END IF;
705: IF (x_contracttype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
701: IF (x_contracttype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;
704: END IF;
705: IF (x_contracttype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;
708: END IF;
709: IF (x_contracttype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
705: IF (x_contracttype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;
708: END IF;
709: IF (x_contracttype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;
712: END IF;
713: IF (x_contracttype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
709: IF (x_contracttype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;
712: END IF;
713: IF (x_contracttype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;
716: END IF;
717: IF (x_contracttype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
713: IF (x_contracttype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;
716: END IF;
717: IF (x_contracttype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;
720: END IF;
721: IF (x_contracttype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
717: IF (x_contracttype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;
720: END IF;
721: IF (x_contracttype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;
724: END IF;
725: IF (x_contracttype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
721: IF (x_contracttype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;
724: END IF;
725: IF (x_contracttype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;
728: END IF;
729: IF (x_contracttype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
725: IF (x_contracttype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;
728: END IF;
729: IF (x_contracttype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_contracttype_rec.context := l_cs_contract_types_pk.context;
732: END IF;
733: IF (x_contracttype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
729: IF (x_contracttype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_contracttype_rec.context := l_cs_contract_types_pk.context;
732: END IF;
733: IF (x_contracttype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
734: THEN
735: x_contracttype_rec.object_version_number := l_cs_contract_types_pk.object_version_number;
736: END IF;
737: RETURN(l_return_status);
736: END IF;
737: RETURN(l_return_status);
738: END populate_new_record;
739: BEGIN
740: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
741: G_PKG_NAME,
742: l_api_version,
743: p_api_version,
744: p_init_msg_list,
822: WHERE
823: CONTRACT_TYPE_ID = l_def_contracttype_rec.contract_type_id
824: ;
825: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
826: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
830: (
825: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
826: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,
833: 'FND_API.G_RET_STS_ERROR',
836: '_Pvt'
837: );
838: APP_EXCEPTION.RAISE_EXCEPTION;
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,
844: 'FND_API.G_RET_STS_UNEXP_ERROR',
846: x_msg_data,
847: '_Pvt'
848: );
849: APP_EXCEPTION.RAISE_EXCEPTION;
850: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
851: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
852: (
853: l_api_name,
854: G_PKG_NAME,
847: '_Pvt'
848: );
849: APP_EXCEPTION.RAISE_EXCEPTION;
850: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
851: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
852: (
853: l_api_name,
854: G_PKG_NAME,
855: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
851: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
852: (
853: l_api_name,
854: G_PKG_NAME,
855: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
856: x_msg_count,
857: x_msg_data,
858: '_Pvt'
859: );
861: END update_row;
862: Procedure update_row
863: (
864: p_api_version IN NUMBER,
865: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
866: p_validation_level IN NUMBER,
867: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
868: x_return_status OUT VARCHAR2,
869: x_msg_count OUT NUMBER,
863: (
864: p_api_version IN NUMBER,
865: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
866: p_validation_level IN NUMBER,
867: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
868: x_return_status OUT VARCHAR2,
869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
867: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
868: x_return_status OUT VARCHAR2,
869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
868: x_return_status OUT VARCHAR2,
869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
901: l_api_version CONSTANT NUMBER := 1;
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
901: l_api_version CONSTANT NUMBER := 1;
902: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
901: l_api_version CONSTANT NUMBER := 1;
902: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
903: l_contracttype_rec ContractType_Val_Rec_Type;
904: BEGIN
905: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
906: G_PKG_NAME,
907: l_api_version,
908: p_api_version,
909: p_init_msg_list,
952: x_msg_data,
953: l_contracttype_rec,
954: x_object_version_number
955: );
956: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
957: EXCEPTION
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
960: (
955: );
956: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
957: EXCEPTION
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
960: (
961: l_api_name,
962: G_PKG_NAME,
963: 'FND_API.G_RET_STS_ERROR',
966: '_Pvt'
967: );
968: APP_EXCEPTION.RAISE_EXCEPTION;
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'FND_API.G_RET_STS_UNEXP_ERROR',
976: x_msg_data,
977: '_Pvt'
978: );
979: APP_EXCEPTION.RAISE_EXCEPTION;
980: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
981: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
977: '_Pvt'
978: );
979: APP_EXCEPTION.RAISE_EXCEPTION;
980: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
981: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
981: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
982: (
983: l_api_name,
984: G_PKG_NAME,
985: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
986: x_msg_count,
987: x_msg_data,
988: '_Pvt'
989: );
991: END update_row;
992: Procedure delete_row
993: (
994: p_api_version IN NUMBER,
995: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
996: p_validation_level IN NUMBER,
997: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
998: x_return_status OUT VARCHAR2,
999: x_msg_count OUT NUMBER,
993: (
994: p_api_version IN NUMBER,
995: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
996: p_validation_level IN NUMBER,
997: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
998: x_return_status OUT VARCHAR2,
999: x_msg_count OUT NUMBER,
1000: x_msg_data OUT VARCHAR2,
1001: p_contract_type_id IN NUMBER) IS
1002: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1003: l_api_version CONSTANT NUMBER := 1;
1004: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1005: BEGIN
1006: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1007: G_PKG_NAME,
1008: l_api_version,
1009: p_api_version,
1010: p_init_msg_list,
1018: DELETE FROM CS_CONTRACT_TYPES
1019: WHERE
1020: CONTRACT_TYPE_ID = p_contract_type_id
1021: ;
1022: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1023: EXCEPTION
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1026: (
1021: ;
1022: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1023: EXCEPTION
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1026: (
1027: l_api_name,
1028: G_PKG_NAME,
1029: 'FND_API.G_RET_STS_ERROR',
1032: '_Pvt'
1033: );
1034: APP_EXCEPTION.RAISE_EXCEPTION;
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1037: (
1038: l_api_name,
1039: G_PKG_NAME,
1040: 'FND_API.G_RET_STS_UNEXP_ERROR',
1042: x_msg_data,
1043: '_Pvt'
1044: );
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1047: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1043: '_Pvt'
1044: );
1045: APP_EXCEPTION.RAISE_EXCEPTION;
1046: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1047: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1047: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1052: x_msg_count,
1053: x_msg_data,
1054: '_Pvt'
1055: );
1057: END delete_row;
1058: PROCEDURE validate_row
1059: (
1060: p_api_version IN NUMBER,
1061: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1062: p_validation_level IN NUMBER,
1063: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1064: x_return_status OUT VARCHAR2,
1065: x_msg_count OUT NUMBER,
1059: (
1060: p_api_version IN NUMBER,
1061: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1062: p_validation_level IN NUMBER,
1063: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1064: x_return_status OUT VARCHAR2,
1065: x_msg_count OUT NUMBER,
1066: x_msg_data OUT VARCHAR2,
1067: p_contracttype_val_rec IN ContractType_Val_Rec_Type := G_MISS_CONTRACTTYPE_VAL_REC) IS
1070: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1071: l_contracttype_rec ContractType_Rec_Type;
1072: l_def_contracttype_rec ContractType_Rec_Type;
1073: BEGIN
1074: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1075: G_PKG_NAME,
1076: l_api_version,
1077: p_api_version,
1078: p_init_msg_list,
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: END IF;
1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1107: END IF;
1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,
1115: 'FND_API.G_RET_STS_ERROR',
1118: '_Pvt'
1119: );
1120: APP_EXCEPTION.RAISE_EXCEPTION;
1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1122: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1123: (
1124: l_api_name,
1125: G_PKG_NAME,
1126: 'FND_API.G_RET_STS_UNEXP_ERROR',
1128: x_msg_data,
1129: '_Pvt'
1130: );
1131: APP_EXCEPTION.RAISE_EXCEPTION;
1132: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1133: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1134: (
1135: l_api_name,
1136: G_PKG_NAME,
1129: '_Pvt'
1130: );
1131: APP_EXCEPTION.RAISE_EXCEPTION;
1132: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1133: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1134: (
1135: l_api_name,
1136: G_PKG_NAME,
1137: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1133: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1134: (
1135: l_api_name,
1136: G_PKG_NAME,
1137: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1138: x_msg_count,
1139: x_msg_data,
1140: '_Pvt'
1141: );
1143: END validate_row;
1144: PROCEDURE validate_row
1145: (
1146: p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1148: p_validation_level IN NUMBER,
1149: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1150: x_return_status OUT VARCHAR2,
1151: x_msg_count OUT NUMBER,
1145: (
1146: p_api_version IN NUMBER,
1147: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1148: p_validation_level IN NUMBER,
1149: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1150: x_return_status OUT VARCHAR2,
1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1149: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1150: x_return_status OUT VARCHAR2,
1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1150: x_return_status OUT VARCHAR2,
1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1184: l_contracttype_rec ContractType_Val_Rec_Type;
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1184: l_contracttype_rec ContractType_Val_Rec_Type;
1185: BEGIN
1186: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1187: G_PKG_NAME,
1188: l_api_version,
1189: p_api_version,
1190: p_init_msg_list,
1232: x_msg_count,
1233: x_msg_data,
1234: l_contracttype_rec
1235: );
1236: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1237: EXCEPTION
1238: WHEN FND_API.G_EXC_ERROR THEN
1239: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1235: );
1236: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1237: EXCEPTION
1238: WHEN FND_API.G_EXC_ERROR THEN
1239: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1241: l_api_name,
1242: G_PKG_NAME,
1243: 'FND_API.G_RET_STS_ERROR',
1246: '_Pvt'
1247: );
1248: APP_EXCEPTION.RAISE_EXCEPTION;
1249: WHEN FND_API.G_EXC_UNEXPECTED_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_UNEXP_ERROR',
1256: x_msg_data,
1257: '_Pvt'
1258: );
1259: APP_EXCEPTION.RAISE_EXCEPTION;
1260: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1261: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1262: (
1263: l_api_name,
1264: G_PKG_NAME,
1257: '_Pvt'
1258: );
1259: APP_EXCEPTION.RAISE_EXCEPTION;
1260: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1261: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1262: (
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1261: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1262: (
1263: l_api_name,
1264: G_PKG_NAME,
1265: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1266: x_msg_count,
1267: x_msg_data,
1268: '_Pvt'
1269: );