APPS.CS_CONTRACTLTMPL_PVT dependencies on TAPI_DEV_KIT

Line 24: IF p_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM OR

20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contractltmpl_rec.service_manufacturing_org_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_manufacturing_org_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;

Line 27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_manufacturing_org_id');

23: BEGIN
24: IF p_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contractltmpl_rec.service_manufacturing_org_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_manufacturing_org_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractltmpl_rec.service_inventory_item_id IS NULL
31: THEN

Line 29: ELSIF p_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM OR

25: p_contractltmpl_rec.service_manufacturing_org_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_manufacturing_org_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractltmpl_rec.service_inventory_item_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_inventory_item_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;

Line 32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_inventory_item_id');

28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractltmpl_rec.service_inventory_item_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_inventory_item_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractltmpl_rec.last_update_date IS NULL
36: THEN

Line 34: ELSIF p_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR

30: p_contractltmpl_rec.service_inventory_item_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_inventory_item_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractltmpl_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;

Line 37: 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_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractltmpl_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractltmpl_rec.last_updated_by IS NULL
41: THEN

Line 39: ELSIF p_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR

35: p_contractltmpl_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractltmpl_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;

Line 42: 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_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractltmpl_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractltmpl_rec.creation_date IS NULL
46: THEN

Line 44: ELSIF p_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR

40: p_contractltmpl_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractltmpl_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;

Line 47: 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_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractltmpl_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractltmpl_rec.created_by IS NULL
51: THEN

Line 49: ELSIF p_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR

45: p_contractltmpl_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractltmpl_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;

Line 52: 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: ELSIF p_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractltmpl_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;

Line 105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_ID');

101: FETCH cc_pk_csr INTO l_cc_pk;
102: l_row_notfound := cc_pk_csr%NOTFOUND;
103: CLOSE cc_pk_csr;
104: IF (l_row_notfound) THEN
105: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'COVERAGE_ID');
106: RAISE item_not_found_error;
107: END IF;
108: END IF;
109: IF (p_contractltmpl_rec.CONTRACT_TEMPLATE_ID IS NOT NULL)

Line 116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TEMPLATE_ID');

112: FETCH cs_contract_templates_pk_csr INTO l_cs_contract_templates_pk;
113: l_row_notfound := cs_contract_templates_pk_csr%NOTFOUND;
114: CLOSE cs_contract_templates_pk_csr;
115: IF (l_row_notfound) THEN
116: TAPI_DEV_KIT.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'CONTRACT_TEMPLATE_ID');
117: RAISE item_not_found_error;
118: END IF;
119: END IF;
120: RETURN (l_return_status);

Line 213: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

209: END migrate;
210: PROCEDURE insert_row
211: (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
214: p_validation_level IN NUMBER,
215: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
216: x_return_status OUT VARCHAR2,
217: x_msg_count OUT NUMBER,

Line 215: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

211: (
212: p_api_version IN NUMBER,
213: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
214: p_validation_level IN NUMBER,
215: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
216: x_return_status OUT VARCHAR2,
217: x_msg_count OUT NUMBER,
218: x_msg_data OUT VARCHAR2,
219: p_contractltmpl_rec IN ContractLTmpl_Rec_Type := G_MISS_CONTRACTLTMPL_REC,

Line 228: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
225: l_contractltmpl_rec ContractLTmpl_Rec_Type;
226: l_def_contractltmpl_rec ContractLTmpl_Rec_Type;
227: BEGIN
228: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
229: G_PKG_NAME,
230: l_api_version,
231: p_api_version,
232: p_init_msg_list,

Line 347: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

343: l_def_contractltmpl_rec.object_version_number);
344: -- Set OUT values
345: x_contract_line_template_id := l_def_contractltmpl_rec.contract_line_template_id;
346: x_object_version_number := l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER;
347: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
351: (

Line 350: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

346: x_object_version_number := l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER;
347: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
351: (
352: l_api_name,
353: G_PKG_NAME,
354: 'FND_API.G_RET_STS_ERROR',

Line 361: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

357: '_Pvt'
358: );
359: APP_EXCEPTION.RAISE_EXCEPTION;
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
362: (
363: l_api_name,
364: G_PKG_NAME,
365: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 371: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

367: x_msg_data,
368: '_Pvt'
369: );
370: APP_EXCEPTION.RAISE_EXCEPTION;
371: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
372: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
373: (
374: l_api_name,
375: G_PKG_NAME,

Line 372: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

368: '_Pvt'
369: );
370: APP_EXCEPTION.RAISE_EXCEPTION;
371: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
372: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
373: (
374: l_api_name,
375: G_PKG_NAME,
376: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 376: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

372: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
373: (
374: l_api_name,
375: G_PKG_NAME,
376: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
377: x_msg_count,
378: x_msg_data,
379: '_Pvt'
380: );

Line 386: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

382: END insert_row;
383: PROCEDURE insert_row
384: (
385: p_api_version IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
387: p_validation_level IN NUMBER,
388: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
389: x_return_status OUT VARCHAR2,
390: x_msg_count OUT NUMBER,

Line 388: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

384: (
385: p_api_version IN NUMBER,
386: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
387: p_validation_level IN NUMBER,
388: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
389: x_return_status OUT VARCHAR2,
390: x_msg_count OUT NUMBER,
391: x_msg_data OUT VARCHAR2,
392: p_contract_template_id IN NUMBER := NULL,

Line 431: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

427: l_api_version CONSTANT NUMBER := 1;
428: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
429: l_contractltmpl_rec ContractLTmpl_Rec_Type;
430: BEGIN
431: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
432: G_PKG_NAME,
433: l_api_version,
434: p_api_version,
435: p_init_msg_list,

Line 487: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

483: l_contractltmpl_rec,
484: x_contract_line_template_id,
485: x_object_version_number
486: );
487: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
491: (

Line 490: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

486: );
487: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,
494: 'FND_API.G_RET_STS_ERROR',

Line 501: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

497: '_Pvt'
498: );
499: APP_EXCEPTION.RAISE_EXCEPTION;
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
502: (
503: l_api_name,
504: G_PKG_NAME,
505: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 511: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

507: x_msg_data,
508: '_Pvt'
509: );
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
512: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,

Line 512: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

508: '_Pvt'
509: );
510: APP_EXCEPTION.RAISE_EXCEPTION;
511: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
512: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 516: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

512: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
513: (
514: l_api_name,
515: G_PKG_NAME,
516: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
517: x_msg_count,
518: x_msg_data,
519: '_Pvt'
520: );

Line 526: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

522: END insert_row;
523: Procedure lock_row
524: (
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
527: p_validation_level IN NUMBER,
528: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
529: x_return_status OUT VARCHAR2,
530: x_msg_count OUT NUMBER,

Line 528: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

524: (
525: p_api_version IN NUMBER,
526: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
527: p_validation_level IN NUMBER,
528: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
529: x_return_status OUT VARCHAR2,
530: x_msg_count OUT NUMBER,
531: x_msg_data OUT VARCHAR2,
532: p_contract_line_template_id IN NUMBER,

Line 558: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

554: lc_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;
555: l_row_notfound BOOLEAN := FALSE;
556: lc_row_notfound BOOLEAN := FALSE;
557: BEGIN
558: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
559: G_PKG_NAME,
560: l_api_version,
561: p_api_version,
562: p_init_msg_list,

Line 580: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

576: WHEN E_Resource_Busy THEN
577: IF (lock_csr%ISOPEN) THEN
578: CLOSE lock_csr;
579: END IF;
580: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
581: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
582: END;
583:
584: IF ( l_row_notfound ) THEN

Line 591: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

587: lc_row_notfound := lchk_csr%NOTFOUND;
588: CLOSE lchk_csr;
589: END IF;
590: IF (lc_row_notfound) THEN
591: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF lc_object_version_number > p_object_version_number THEN
594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;

Line 594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

590: IF (lc_row_notfound) THEN
591: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF lc_object_version_number > p_object_version_number THEN
594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF lc_object_version_number <> p_object_version_number THEN
597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;

Line 597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

593: ELSIF lc_object_version_number > p_object_version_number THEN
594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF lc_object_version_number <> p_object_version_number THEN
597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF lc_object_version_number = -1 THEN
600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
601: RAISE FND_API.G_EXC_ERROR;

Line 600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

596: ELSIF lc_object_version_number <> p_object_version_number THEN
597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF lc_object_version_number = -1 THEN
600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
604: EXCEPTION

Line 603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

599: ELSIF lc_object_version_number = -1 THEN
600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
607: (

Line 606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

602: END IF;
603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
607: (
608: l_api_name,
609: G_PKG_NAME,
610: 'FND_API.G_RET_STS_ERROR',

Line 617: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

613: '_Pvt'
614: );
615: APP_EXCEPTION.RAISE_EXCEPTION;
616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
617: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
618: (
619: l_api_name,
620: G_PKG_NAME,
621: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 627: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

623: x_msg_data,
624: '_Pvt'
625: );
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,

Line 628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

624: '_Pvt'
625: );
626: APP_EXCEPTION.RAISE_EXCEPTION;
627: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 632: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

628: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
629: (
630: l_api_name,
631: G_PKG_NAME,
632: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
633: x_msg_count,
634: x_msg_data,
635: '_Pvt'
636: );

Line 642: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

638: END lock_row;
639: Procedure update_row
640: (
641: p_api_version IN NUMBER,
642: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
643: p_validation_level IN NUMBER,
644: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
645: x_return_status OUT VARCHAR2,
646: x_msg_count OUT NUMBER,

Line 644: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

640: (
641: p_api_version IN NUMBER,
642: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
643: p_validation_level IN NUMBER,
644: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
645: x_return_status OUT VARCHAR2,
646: x_msg_count OUT NUMBER,
647: x_msg_data OUT VARCHAR2,
648: p_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC,

Line 676: IF (x_contractltmpl_rec.contract_line_template_id = TAPI_DEV_KIT.G_MISS_NUM)

672: CLOSE cs_contract_line_tem1_csr;
673: IF (l_row_notfound) THEN
674: l_return_status := FND_API.G_RET_STS_ERROR;
675: END IF;
676: IF (x_contractltmpl_rec.contract_line_template_id = TAPI_DEV_KIT.G_MISS_NUM)
677: THEN
678: x_contractltmpl_rec.contract_line_template_id := l_cs_contract_line_tem1.contract_line_template_id;
679: END IF;
680: IF (x_contractltmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 680: IF (x_contractltmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)

676: IF (x_contractltmpl_rec.contract_line_template_id = TAPI_DEV_KIT.G_MISS_NUM)
677: THEN
678: x_contractltmpl_rec.contract_line_template_id := l_cs_contract_line_tem1.contract_line_template_id;
679: END IF;
680: IF (x_contractltmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)
681: THEN
682: x_contractltmpl_rec.contract_template_id := l_cs_contract_line_tem1.contract_template_id;
683: END IF;
684: IF (x_contractltmpl_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 684: IF (x_contractltmpl_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)

680: IF (x_contractltmpl_rec.contract_template_id = TAPI_DEV_KIT.G_MISS_NUM)
681: THEN
682: x_contractltmpl_rec.contract_template_id := l_cs_contract_line_tem1.contract_template_id;
683: END IF;
684: IF (x_contractltmpl_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
685: THEN
686: x_contractltmpl_rec.coverage_id := l_cs_contract_line_tem1.coverage_id;
687: END IF;
688: IF (x_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 688: IF (x_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)

684: IF (x_contractltmpl_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM)
685: THEN
686: x_contractltmpl_rec.coverage_id := l_cs_contract_line_tem1.coverage_id;
687: END IF;
688: IF (x_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
689: THEN
690: x_contractltmpl_rec.service_manufacturing_org_id := l_cs_contract_line_tem1.service_manufacturing_org_id;
691: END IF;
692: IF (x_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 692: IF (x_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM)

688: IF (x_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM)
689: THEN
690: x_contractltmpl_rec.service_manufacturing_org_id := l_cs_contract_line_tem1.service_manufacturing_org_id;
691: END IF;
692: IF (x_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM)
693: THEN
694: x_contractltmpl_rec.service_inventory_item_id := l_cs_contract_line_tem1.service_inventory_item_id;
695: END IF;
696: IF (x_contractltmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)

Line 696: IF (x_contractltmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)

692: IF (x_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM)
693: THEN
694: x_contractltmpl_rec.service_inventory_item_id := l_cs_contract_line_tem1.service_inventory_item_id;
695: END IF;
696: IF (x_contractltmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_contractltmpl_rec.workflow := l_cs_contract_line_tem1.workflow;
699: END IF;
700: IF (x_contractltmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)

Line 700: IF (x_contractltmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)

696: IF (x_contractltmpl_rec.workflow = TAPI_DEV_KIT.G_MISS_CHAR)
697: THEN
698: x_contractltmpl_rec.workflow := l_cs_contract_line_tem1.workflow;
699: END IF;
700: IF (x_contractltmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)
701: THEN
702: x_contractltmpl_rec.duration := l_cs_contract_line_tem1.duration;
703: END IF;
704: IF (x_contractltmpl_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)

Line 704: IF (x_contractltmpl_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)

700: IF (x_contractltmpl_rec.duration = TAPI_DEV_KIT.G_MISS_NUM)
701: THEN
702: x_contractltmpl_rec.duration := l_cs_contract_line_tem1.duration;
703: END IF;
704: IF (x_contractltmpl_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_contractltmpl_rec.unit_of_measure_code := l_cs_contract_line_tem1.unit_of_measure_code;
707: END IF;
708: IF (x_contractltmpl_rec.original_system_reference = TAPI_DEV_KIT.G_MISS_CHAR)

Line 708: IF (x_contractltmpl_rec.original_system_reference = TAPI_DEV_KIT.G_MISS_CHAR)

704: IF (x_contractltmpl_rec.unit_of_measure_code = TAPI_DEV_KIT.G_MISS_CHAR)
705: THEN
706: x_contractltmpl_rec.unit_of_measure_code := l_cs_contract_line_tem1.unit_of_measure_code;
707: END IF;
708: IF (x_contractltmpl_rec.original_system_reference = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_contractltmpl_rec.original_system_reference := l_cs_contract_line_tem1.original_system_reference;
711: END IF;
712: IF (x_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 712: IF (x_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)

708: IF (x_contractltmpl_rec.original_system_reference = TAPI_DEV_KIT.G_MISS_CHAR)
709: THEN
710: x_contractltmpl_rec.original_system_reference := l_cs_contract_line_tem1.original_system_reference;
711: END IF;
712: IF (x_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
713: THEN
714: x_contractltmpl_rec.last_update_date := l_cs_contract_line_tem1.last_update_date;
715: END IF;
716: IF (x_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 716: IF (x_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)

712: IF (x_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
713: THEN
714: x_contractltmpl_rec.last_update_date := l_cs_contract_line_tem1.last_update_date;
715: END IF;
716: IF (x_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractltmpl_rec.last_updated_by := l_cs_contract_line_tem1.last_updated_by;
719: END IF;
720: IF (x_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

Line 720: IF (x_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)

716: IF (x_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
717: THEN
718: x_contractltmpl_rec.last_updated_by := l_cs_contract_line_tem1.last_updated_by;
719: END IF;
720: IF (x_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
721: THEN
722: x_contractltmpl_rec.creation_date := l_cs_contract_line_tem1.creation_date;
723: END IF;
724: IF (x_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

Line 724: IF (x_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)

720: IF (x_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
721: THEN
722: x_contractltmpl_rec.creation_date := l_cs_contract_line_tem1.creation_date;
723: END IF;
724: IF (x_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractltmpl_rec.created_by := l_cs_contract_line_tem1.created_by;
727: END IF;
728: IF (x_contractltmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

Line 728: IF (x_contractltmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)

724: IF (x_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
725: THEN
726: x_contractltmpl_rec.created_by := l_cs_contract_line_tem1.created_by;
727: END IF;
728: IF (x_contractltmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractltmpl_rec.last_update_login := l_cs_contract_line_tem1.last_update_login;
731: END IF;
732: IF (x_contractltmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 732: IF (x_contractltmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)

728: IF (x_contractltmpl_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
729: THEN
730: x_contractltmpl_rec.last_update_login := l_cs_contract_line_tem1.last_update_login;
731: END IF;
732: IF (x_contractltmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractltmpl_rec.start_date_active := l_cs_contract_line_tem1.start_date_active;
735: END IF;
736: IF (x_contractltmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

Line 736: IF (x_contractltmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)

732: IF (x_contractltmpl_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
733: THEN
734: x_contractltmpl_rec.start_date_active := l_cs_contract_line_tem1.start_date_active;
735: END IF;
736: IF (x_contractltmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
737: THEN
738: x_contractltmpl_rec.end_date_active := l_cs_contract_line_tem1.end_date_active;
739: END IF;
740: IF (x_contractltmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 740: IF (x_contractltmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)

736: IF (x_contractltmpl_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
737: THEN
738: x_contractltmpl_rec.end_date_active := l_cs_contract_line_tem1.end_date_active;
739: END IF;
740: IF (x_contractltmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
741: THEN
742: x_contractltmpl_rec.attribute1 := l_cs_contract_line_tem1.attribute1;
743: END IF;
744: IF (x_contractltmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 744: IF (x_contractltmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)

740: IF (x_contractltmpl_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
741: THEN
742: x_contractltmpl_rec.attribute1 := l_cs_contract_line_tem1.attribute1;
743: END IF;
744: IF (x_contractltmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractltmpl_rec.attribute2 := l_cs_contract_line_tem1.attribute2;
747: END IF;
748: IF (x_contractltmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 748: IF (x_contractltmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)

744: IF (x_contractltmpl_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
745: THEN
746: x_contractltmpl_rec.attribute2 := l_cs_contract_line_tem1.attribute2;
747: END IF;
748: IF (x_contractltmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
749: THEN
750: x_contractltmpl_rec.attribute3 := l_cs_contract_line_tem1.attribute3;
751: END IF;
752: IF (x_contractltmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 752: IF (x_contractltmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)

748: IF (x_contractltmpl_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
749: THEN
750: x_contractltmpl_rec.attribute3 := l_cs_contract_line_tem1.attribute3;
751: END IF;
752: IF (x_contractltmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractltmpl_rec.attribute4 := l_cs_contract_line_tem1.attribute4;
755: END IF;
756: IF (x_contractltmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 756: IF (x_contractltmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)

752: IF (x_contractltmpl_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
753: THEN
754: x_contractltmpl_rec.attribute4 := l_cs_contract_line_tem1.attribute4;
755: END IF;
756: IF (x_contractltmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
757: THEN
758: x_contractltmpl_rec.attribute5 := l_cs_contract_line_tem1.attribute5;
759: END IF;
760: IF (x_contractltmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 760: IF (x_contractltmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)

756: IF (x_contractltmpl_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
757: THEN
758: x_contractltmpl_rec.attribute5 := l_cs_contract_line_tem1.attribute5;
759: END IF;
760: IF (x_contractltmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
761: THEN
762: x_contractltmpl_rec.attribute6 := l_cs_contract_line_tem1.attribute6;
763: END IF;
764: IF (x_contractltmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 764: IF (x_contractltmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)

760: IF (x_contractltmpl_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
761: THEN
762: x_contractltmpl_rec.attribute6 := l_cs_contract_line_tem1.attribute6;
763: END IF;
764: IF (x_contractltmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
765: THEN
766: x_contractltmpl_rec.attribute7 := l_cs_contract_line_tem1.attribute7;
767: END IF;
768: IF (x_contractltmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 768: IF (x_contractltmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)

764: IF (x_contractltmpl_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
765: THEN
766: x_contractltmpl_rec.attribute7 := l_cs_contract_line_tem1.attribute7;
767: END IF;
768: IF (x_contractltmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
769: THEN
770: x_contractltmpl_rec.attribute8 := l_cs_contract_line_tem1.attribute8;
771: END IF;
772: IF (x_contractltmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 772: IF (x_contractltmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)

768: IF (x_contractltmpl_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
769: THEN
770: x_contractltmpl_rec.attribute8 := l_cs_contract_line_tem1.attribute8;
771: END IF;
772: IF (x_contractltmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
773: THEN
774: x_contractltmpl_rec.attribute9 := l_cs_contract_line_tem1.attribute9;
775: END IF;
776: IF (x_contractltmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 776: IF (x_contractltmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)

772: IF (x_contractltmpl_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
773: THEN
774: x_contractltmpl_rec.attribute9 := l_cs_contract_line_tem1.attribute9;
775: END IF;
776: IF (x_contractltmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
777: THEN
778: x_contractltmpl_rec.attribute10 := l_cs_contract_line_tem1.attribute10;
779: END IF;
780: IF (x_contractltmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 780: IF (x_contractltmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)

776: IF (x_contractltmpl_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
777: THEN
778: x_contractltmpl_rec.attribute10 := l_cs_contract_line_tem1.attribute10;
779: END IF;
780: IF (x_contractltmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractltmpl_rec.attribute11 := l_cs_contract_line_tem1.attribute11;
783: END IF;
784: IF (x_contractltmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 784: IF (x_contractltmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)

780: IF (x_contractltmpl_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
781: THEN
782: x_contractltmpl_rec.attribute11 := l_cs_contract_line_tem1.attribute11;
783: END IF;
784: IF (x_contractltmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractltmpl_rec.attribute12 := l_cs_contract_line_tem1.attribute12;
787: END IF;
788: IF (x_contractltmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 788: IF (x_contractltmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)

784: IF (x_contractltmpl_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
785: THEN
786: x_contractltmpl_rec.attribute12 := l_cs_contract_line_tem1.attribute12;
787: END IF;
788: IF (x_contractltmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractltmpl_rec.attribute13 := l_cs_contract_line_tem1.attribute13;
791: END IF;
792: IF (x_contractltmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 792: IF (x_contractltmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)

788: IF (x_contractltmpl_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
789: THEN
790: x_contractltmpl_rec.attribute13 := l_cs_contract_line_tem1.attribute13;
791: END IF;
792: IF (x_contractltmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractltmpl_rec.attribute14 := l_cs_contract_line_tem1.attribute14;
795: END IF;
796: IF (x_contractltmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

Line 796: IF (x_contractltmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)

792: IF (x_contractltmpl_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
793: THEN
794: x_contractltmpl_rec.attribute14 := l_cs_contract_line_tem1.attribute14;
795: END IF;
796: IF (x_contractltmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractltmpl_rec.attribute15 := l_cs_contract_line_tem1.attribute15;
799: END IF;
800: IF (x_contractltmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

Line 800: IF (x_contractltmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)

796: IF (x_contractltmpl_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
797: THEN
798: x_contractltmpl_rec.attribute15 := l_cs_contract_line_tem1.attribute15;
799: END IF;
800: IF (x_contractltmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractltmpl_rec.context := l_cs_contract_line_tem1.context;
803: END IF;
804: IF (x_contractltmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

Line 804: IF (x_contractltmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)

800: IF (x_contractltmpl_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
801: THEN
802: x_contractltmpl_rec.context := l_cs_contract_line_tem1.context;
803: END IF;
804: IF (x_contractltmpl_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
805: THEN
806: x_contractltmpl_rec.object_version_number := l_cs_contract_line_tem1.object_version_number;
807: END IF;
808: RETURN(l_return_status);

Line 811: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

807: END IF;
808: RETURN(l_return_status);
809: END populate_new_record;
810: BEGIN
811: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
812: G_PKG_NAME,
813: l_api_version,
814: p_api_version,
815: p_init_msg_list,

Line 902: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

898: WHERE
899: CONTRACT_LINE_TEMPLATE_ID = l_def_contractltmpl_rec.contract_line_template_id
900: ;
901: x_object_version_number := l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER;
902: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
906: (

Line 905: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

901: x_object_version_number := l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER;
902: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,
909: 'FND_API.G_RET_STS_ERROR',

Line 916: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

912: '_Pvt'
913: );
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,
920: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 926: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

922: x_msg_data,
923: '_Pvt'
924: );
925: APP_EXCEPTION.RAISE_EXCEPTION;
926: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
927: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
928: (
929: l_api_name,
930: G_PKG_NAME,

Line 927: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

923: '_Pvt'
924: );
925: APP_EXCEPTION.RAISE_EXCEPTION;
926: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
927: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
928: (
929: l_api_name,
930: G_PKG_NAME,
931: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 931: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

927: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
928: (
929: l_api_name,
930: G_PKG_NAME,
931: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
932: x_msg_count,
933: x_msg_data,
934: '_Pvt'
935: );

Line 941: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

937: END update_row;
938: Procedure update_row
939: (
940: p_api_version IN NUMBER,
941: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
942: p_validation_level IN NUMBER,
943: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
944: x_return_status OUT VARCHAR2,
945: x_msg_count OUT NUMBER,

Line 943: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

939: (
940: p_api_version IN NUMBER,
941: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
942: p_validation_level IN NUMBER,
943: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
944: x_return_status OUT VARCHAR2,
945: x_msg_count OUT NUMBER,
946: x_msg_data OUT VARCHAR2,
947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

943: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
944: x_return_status OUT VARCHAR2,
945: x_msg_count OUT NUMBER,
946: x_msg_data OUT VARCHAR2,
947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

944: x_return_status OUT VARCHAR2,
945: x_msg_count OUT NUMBER,
946: x_msg_data OUT VARCHAR2,
947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

945: x_msg_count OUT NUMBER,
946: x_msg_data OUT VARCHAR2,
947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

946: x_msg_data OUT VARCHAR2,
947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

947: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

948: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

949: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

950: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

951: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

952: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

953: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

954: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

955: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

956: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

957: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

958: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

959: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

960: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

961: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

962: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

963: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

964: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

965: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

966: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

967: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

968: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

969: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

970: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

971: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

972: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: x_object_version_number OUT NUMBER) IS

Line 977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

973: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: x_object_version_number OUT NUMBER) IS
981: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

974: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: x_object_version_number OUT NUMBER) IS
981: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
982: l_api_version CONSTANT NUMBER := 1;

Line 979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

975: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
976: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
977: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
978: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: x_object_version_number OUT NUMBER) IS
981: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
982: l_api_version CONSTANT NUMBER := 1;
983: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 986: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

982: l_api_version CONSTANT NUMBER := 1;
983: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
984: l_contractltmpl_rec ContractLTmpl_Val_Rec_Type;
985: BEGIN
986: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
987: G_PKG_NAME,
988: l_api_version,
989: p_api_version,
990: p_init_msg_list,

Line 1042: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1038: x_msg_data,
1039: l_contractltmpl_rec,
1040: x_object_version_number
1041: );
1042: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1046: (

Line 1045: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1041: );
1042: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1046: (
1047: l_api_name,
1048: G_PKG_NAME,
1049: 'FND_API.G_RET_STS_ERROR',

Line 1056: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1052: '_Pvt'
1053: );
1054: APP_EXCEPTION.RAISE_EXCEPTION;
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1057: (
1058: l_api_name,
1059: G_PKG_NAME,
1060: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1066: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1062: x_msg_data,
1063: '_Pvt'
1064: );
1065: APP_EXCEPTION.RAISE_EXCEPTION;
1066: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1067: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,

Line 1067: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1063: '_Pvt'
1064: );
1065: APP_EXCEPTION.RAISE_EXCEPTION;
1066: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1067: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1071: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1067: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1068: (
1069: l_api_name,
1070: G_PKG_NAME,
1071: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1072: x_msg_count,
1073: x_msg_data,
1074: '_Pvt'
1075: );

Line 1081: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1077: END update_row;
1078: Procedure delete_row
1079: (
1080: p_api_version IN NUMBER,
1081: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1082: p_validation_level IN NUMBER,
1083: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1084: x_return_status OUT VARCHAR2,
1085: x_msg_count OUT NUMBER,

Line 1083: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1079: (
1080: p_api_version IN NUMBER,
1081: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1082: p_validation_level IN NUMBER,
1083: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1084: x_return_status OUT VARCHAR2,
1085: x_msg_count OUT NUMBER,
1086: x_msg_data OUT VARCHAR2,
1087: p_contract_line_template_id IN NUMBER) IS

Line 1092: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1088: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1089: l_api_version CONSTANT NUMBER := 1;
1090: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1091: BEGIN
1092: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1093: G_PKG_NAME,
1094: l_api_version,
1095: p_api_version,
1096: p_init_msg_list,

Line 1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1104: DELETE FROM CS_CONTRACT_LINE_TPLTS
1105: WHERE
1106: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
1107: ;
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: (

Line 1111: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1107: ;
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',

Line 1122: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

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',

Line 1132: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

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,

Line 1133: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

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',

Line 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: );

Line 1147: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1143: END delete_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,

Line 1149: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

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_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC) IS

Line 1160: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1156: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1157: l_contractltmpl_rec ContractLTmpl_Rec_Type;
1158: l_def_contractltmpl_rec ContractLTmpl_Rec_Type;
1159: BEGIN
1160: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1161: G_PKG_NAME,
1162: l_api_version,
1163: p_api_version,
1164: p_init_msg_list,

Line 1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: END IF;
1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1195: EXCEPTION
1196: WHEN FND_API.G_EXC_ERROR THEN
1197: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1198: (

Line 1197: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1193: END IF;
1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1195: EXCEPTION
1196: WHEN FND_API.G_EXC_ERROR THEN
1197: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1198: (
1199: l_api_name,
1200: G_PKG_NAME,
1201: 'FND_API.G_RET_STS_ERROR',

Line 1208: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1204: '_Pvt'
1205: );
1206: APP_EXCEPTION.RAISE_EXCEPTION;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1209: (
1210: l_api_name,
1211: G_PKG_NAME,
1212: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1218: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1214: x_msg_data,
1215: '_Pvt'
1216: );
1217: APP_EXCEPTION.RAISE_EXCEPTION;
1218: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1219: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1220: (
1221: l_api_name,
1222: G_PKG_NAME,

Line 1219: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1215: '_Pvt'
1216: );
1217: APP_EXCEPTION.RAISE_EXCEPTION;
1218: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1219: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1220: (
1221: l_api_name,
1222: G_PKG_NAME,
1223: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1223: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1219: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1220: (
1221: l_api_name,
1222: G_PKG_NAME,
1223: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1224: x_msg_count,
1225: x_msg_data,
1226: '_Pvt'
1227: );

Line 1233: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1229: END validate_row;
1230: PROCEDURE validate_row
1231: (
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1234: p_validation_level IN NUMBER,
1235: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1236: x_return_status OUT VARCHAR2,
1237: x_msg_count OUT NUMBER,

Line 1235: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,

1231: (
1232: p_api_version IN NUMBER,
1233: p_init_msg_list IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1234: p_validation_level IN NUMBER,
1235: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1236: x_return_status OUT VARCHAR2,
1237: x_msg_count OUT NUMBER,
1238: x_msg_data OUT VARCHAR2,
1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1235: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
1236: x_return_status OUT VARCHAR2,
1237: x_msg_count OUT NUMBER,
1238: x_msg_data OUT VARCHAR2,
1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1236: x_return_status OUT VARCHAR2,
1237: x_msg_count OUT NUMBER,
1238: x_msg_data OUT VARCHAR2,
1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1237: x_msg_count OUT NUMBER,
1238: x_msg_data OUT VARCHAR2,
1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1238: x_msg_data OUT VARCHAR2,
1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1239: p_contract_line_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1240: p_contract_template_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1241: p_coverage_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1242: p_service_manufacturing_org_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1243: p_service_inventory_item_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1244: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1245: p_duration IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1246: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1247: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

1248: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1249: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1250: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1251: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1252: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1253: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1254: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1255: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1256: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1257: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1258: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1259: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1260: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1261: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1262: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1263: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1264: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1272: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1265: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1272: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1273: l_api_version CONSTANT NUMBER := 1;

Line 1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1266: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1272: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

1267: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1268: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1269: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1272: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1275: l_contractltmpl_rec ContractLTmpl_Val_Rec_Type;

Line 1277: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

1273: l_api_version CONSTANT NUMBER := 1;
1274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1275: l_contractltmpl_rec ContractLTmpl_Val_Rec_Type;
1276: BEGIN
1277: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1278: G_PKG_NAME,
1279: l_api_version,
1280: p_api_version,
1281: p_init_msg_list,

Line 1332: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

1328: x_msg_count,
1329: x_msg_data,
1330: l_contractltmpl_rec
1331: );
1332: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1336: (

Line 1335: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1331: );
1332: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'FND_API.G_RET_STS_ERROR',

Line 1346: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1342: '_Pvt'
1343: );
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1346: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1347: (
1348: l_api_name,
1349: G_PKG_NAME,
1350: 'FND_API.G_RET_STS_UNEXP_ERROR',

Line 1356: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN

1352: x_msg_data,
1353: '_Pvt'
1354: );
1355: APP_EXCEPTION.RAISE_EXCEPTION;
1356: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1357: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1358: (
1359: l_api_name,
1360: G_PKG_NAME,

Line 1357: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS

1353: '_Pvt'
1354: );
1355: APP_EXCEPTION.RAISE_EXCEPTION;
1356: WHEN TAPI_DEV_KIT.G_EXC_DUP_VAL_ON_INDEX THEN
1357: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1358: (
1359: l_api_name,
1360: G_PKG_NAME,
1361: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

Line 1361: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',

1357: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1358: (
1359: l_api_name,
1360: G_PKG_NAME,
1361: 'TAPI_DEV_KIT.G_RET_STS_DUP_VAL_ON_INDEX',
1362: x_msg_count,
1363: x_msg_data,
1364: '_Pvt'
1365: );