eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CONTRACTLTMPL_PVT dependencies on CS_CONTRACT_LINE_TPLTS

Line 5: SELECT CS_CONTRACT_LINE_TPLTS_S.nextval FROM SYS.DUAL;

1: PACKAGE BODY CS_CONTRACTLTMPL_PVT AS
2: /* $Header: csctcltb.pls 115.1 99/07/16 08:50:05 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_LINE_TPLTS_S.nextval FROM SYS.DUAL;
6: l_seq_id NUMBER := 0;
7: BEGIN
8: OPEN get_seq_id_csr;
9: FETCH get_seq_id_csr INTO l_seq_id;

Line 276: INSERT INTO CS_CONTRACT_LINE_TPLTS(

272: END IF;
273: END IF;
274: -- Set primary key value
275: l_def_contractltmpl_rec.contract_line_template_id := get_seq_id;
276: INSERT INTO CS_CONTRACT_LINE_TPLTS(
277: contract_line_template_id,
278: contract_template_id,
279: coverage_id,
280: service_manufacturing_org_id,

Line 396: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,

392: p_contract_template_id IN NUMBER := NULL,
393: p_coverage_id IN NUMBER := NULL,
394: p_service_manufacturing_org_id IN NUMBER := NULL,
395: p_service_inventory_item_id IN NUMBER := NULL,
396: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
397: p_duration IN NUMBER := NULL,
398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,

Line 398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,

394: p_service_manufacturing_org_id IN NUMBER := NULL,
395: p_service_inventory_item_id IN NUMBER := NULL,
396: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
397: p_duration IN NUMBER := NULL,
398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,

Line 399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,

395: p_service_inventory_item_id IN NUMBER := NULL,
396: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
397: p_duration IN NUMBER := NULL,
398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,

Line 400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,

396: p_workflow IN CS_CONTRACT_LINE_TPLTS.WORKFLOW%TYPE := NULL,
397: p_duration IN NUMBER := NULL,
398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,

Line 402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,

398: p_unit_of_measure_code IN CS_CONTRACT_LINE_TPLTS.UNIT_OF_MEASURE_CODE%TYPE := NULL,
399: p_original_system_reference IN CS_CONTRACT_LINE_TPLTS.ORIGINAL_SYSTEM_REFERENCE%TYPE := NULL,
400: p_last_update_date IN CS_CONTRACT_LINE_TPLTS.LAST_UPDATE_DATE%TYPE := NULL,
401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,

Line 405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,

401: p_last_updated_by IN NUMBER := NULL,
402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,

Line 406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,

402: p_creation_date IN CS_CONTRACT_LINE_TPLTS.CREATION_DATE%TYPE := NULL,
403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,

Line 407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,

403: p_created_by IN NUMBER := NULL,
404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,

Line 408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,

404: p_last_update_login IN NUMBER := NULL,
405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,

Line 409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,

405: p_start_date_active IN CS_CONTRACT_LINE_TPLTS.START_DATE_ACTIVE%TYPE := NULL,
406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,

Line 410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,

406: p_end_date_active IN CS_CONTRACT_LINE_TPLTS.END_DATE_ACTIVE%TYPE := NULL,
407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,

Line 411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,

407: p_attribute1 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE1%TYPE := NULL,
408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,

Line 412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,

408: p_attribute2 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE2%TYPE := NULL,
409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,

Line 413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,

409: p_attribute3 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE3%TYPE := NULL,
410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,

Line 414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,

410: p_attribute4 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE4%TYPE := NULL,
411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,

Line 415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,

411: p_attribute5 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE5%TYPE := NULL,
412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,

Line 416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,

412: p_attribute6 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE6%TYPE := NULL,
413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,

Line 417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,

413: p_attribute7 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE7%TYPE := NULL,
414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,

Line 418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,

414: p_attribute8 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE8%TYPE := NULL,
415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,

Line 419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,

415: p_attribute9 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE9%TYPE := NULL,
416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
423: p_object_version_number IN NUMBER := NULL,

Line 420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,

416: p_attribute10 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE10%TYPE := NULL,
417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
423: p_object_version_number IN NUMBER := NULL,
424: x_contract_line_template_id OUT NUMBER,

Line 421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,

417: p_attribute11 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE11%TYPE := NULL,
418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
423: p_object_version_number IN NUMBER := NULL,
424: x_contract_line_template_id OUT NUMBER,
425: x_object_version_number OUT NUMBER) IS

Line 422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,

418: p_attribute12 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE12%TYPE := NULL,
419: p_attribute13 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE13%TYPE := NULL,
420: p_attribute14 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE14%TYPE := NULL,
421: p_attribute15 IN CS_CONTRACT_LINE_TPLTS.ATTRIBUTE15%TYPE := NULL,
422: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := NULL,
423: p_object_version_number IN NUMBER := NULL,
424: x_contract_line_template_id OUT NUMBER,
425: x_object_version_number OUT NUMBER) IS
426: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 538: FROM CS_CONTRACT_LINE_TPLTS

534: E_Resource_Busy EXCEPTION;
535: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
536: CURSOR lock_csr IS
537: SELECT OBJECT_VERSION_NUMBER
538: FROM CS_CONTRACT_LINE_TPLTS
539: WHERE
540: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id AND
541: OBJECT_VERSION_NUMBER = p_object_version_number
542: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 546: FROM CS_CONTRACT_LINE_TPLTS

542: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
543:
544: CURSOR lchk_csr IS
545: SELECT OBJECT_VERSION_NUMBER
546: FROM CS_CONTRACT_LINE_TPLTS
547: WHERE
548: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
549: ;
550: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 553: l_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;

549: ;
550: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
551: l_api_version CONSTANT NUMBER := 1;
552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
553: l_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;
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

Line 554: lc_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;

550: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
551: l_api_version CONSTANT NUMBER := 1;
552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
553: l_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;
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,

Line 661: FROM Cs_Contract_Line_Tplts

657: x_contractltmpl_rec OUT ContractLTmpl_Rec_Type
658: ) RETURN VARCHAR2 IS
659: CURSOR cs_contract_line_tem1_csr (p_contract_line_template_id IN NUMBER) IS
660: SELECT *
661: FROM Cs_Contract_Line_Tplts
662: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;
663: l_cs_contract_line_tem1 cs_contract_line_tem1_csr%ROWTYPE;
664: l_row_notfound BOOLEAN := TRUE;
665: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 662: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;

658: ) RETURN VARCHAR2 IS
659: CURSOR cs_contract_line_tem1_csr (p_contract_line_template_id IN NUMBER) IS
660: SELECT *
661: FROM Cs_Contract_Line_Tplts
662: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;
663: l_cs_contract_line_tem1 cs_contract_line_tem1_csr%ROWTYPE;
664: l_row_notfound BOOLEAN := TRUE;
665: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
666: BEGIN

Line 863: UPDATE CS_CONTRACT_LINE_TPLTS

859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: END IF;
863: UPDATE CS_CONTRACT_LINE_TPLTS
864: SET
865: CONTRACT_LINE_TEMPLATE_ID = l_def_contractltmpl_rec.contract_line_template_id ,
866: CONTRACT_TEMPLATE_ID = l_def_contractltmpl_rec.contract_template_id ,
867: COVERAGE_ID = l_def_contractltmpl_rec.coverage_id ,

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 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 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 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 1104: DELETE FROM CS_CONTRACT_LINE_TPLTS

1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
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);

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 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 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 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;