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_CONTRACTTYPE_PVT dependencies on CS_CONTRACT_TYPES

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

1: PACKAGE BODY CS_CONTRACTTYPE_PVT AS
2: /* $Header: csctctyb.pls 115.1 99/07/16 08:51:48 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_TYPES_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 245: INSERT INTO CS_CONTRACT_TYPES(

241: END IF;
242: END IF;
243: -- Set primary key value
244: l_def_contracttype_rec.contract_type_id := get_seq_id;
245: INSERT INTO CS_CONTRACT_TYPES(
246: contract_type_id,
247: name,
248: description,
249: cust_trx_type_id,

Line 351: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := NULL,

347: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
348: x_return_status OUT VARCHAR2,
349: x_msg_count OUT NUMBER,
350: x_msg_data OUT VARCHAR2,
351: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := NULL,
352: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,
353: p_cust_trx_type_id IN NUMBER := NULL,
354: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
355: p_last_updated_by IN NUMBER := NULL,

Line 352: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,

348: x_return_status OUT VARCHAR2,
349: x_msg_count OUT NUMBER,
350: x_msg_data OUT VARCHAR2,
351: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := NULL,
352: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,
353: p_cust_trx_type_id IN NUMBER := NULL,
354: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
355: p_last_updated_by IN NUMBER := NULL,
356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,

Line 354: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,

350: x_msg_data OUT VARCHAR2,
351: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := NULL,
352: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,
353: p_cust_trx_type_id IN NUMBER := NULL,
354: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
355: p_last_updated_by IN NUMBER := NULL,
356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,

Line 356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,

352: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := NULL,
353: p_cust_trx_type_id IN NUMBER := NULL,
354: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := NULL,
355: p_last_updated_by IN NUMBER := NULL,
356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,

Line 359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,

355: p_last_updated_by IN NUMBER := NULL,
356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,

Line 360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,

356: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := NULL,
357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,

Line 361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,

357: p_created_by IN NUMBER := NULL,
358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,

Line 362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,

358: p_last_update_login IN NUMBER := NULL,
359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,

Line 363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,

359: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := NULL,
360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,

Line 364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,

360: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := NULL,
361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,

Line 365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,

361: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := NULL,
362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,

Line 366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,

362: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := NULL,
363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,

Line 367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,

363: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := NULL,
364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,

Line 368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,

364: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := NULL,
365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,

Line 369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,

365: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := NULL,
366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,

Line 370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,

366: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := NULL,
367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,

Line 371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,

367: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := NULL,
368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,

Line 372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,

368: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := NULL,
369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,

Line 373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,

369: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := NULL,
370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,

Line 374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,

370: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := NULL,
371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_contract_type_id OUT NUMBER,

Line 375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,

371: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := NULL,
372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_contract_type_id OUT NUMBER,
379: x_object_version_number OUT NUMBER) IS

Line 376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,

372: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := NULL,
373: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := NULL,
374: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := NULL,
375: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := NULL,
376: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := NULL,
377: p_object_version_number IN NUMBER := NULL,
378: x_contract_type_id OUT NUMBER,
379: x_object_version_number OUT NUMBER) IS
380: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 487: FROM CS_CONTRACT_TYPES

483: E_Resource_Busy EXCEPTION;
484: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
485: CURSOR lock_csr IS
486: SELECT OBJECT_VERSION_NUMBER
487: FROM CS_CONTRACT_TYPES
488: WHERE
489: CONTRACT_TYPE_ID = p_contract_type_id AND
490: OBJECT_VERSION_NUMBER = p_object_version_number
491: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 495: FROM CS_CONTRACT_TYPES

491: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
492:
493: CURSOR lchk_csr IS
494: SELECT OBJECT_VERSION_NUMBER
495: FROM CS_CONTRACT_TYPES
496: WHERE
497: CONTRACT_TYPE_ID = p_contract_type_id
498: ;
499: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 502: l_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;

498: ;
499: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
500: l_api_version CONSTANT NUMBER := 1;
501: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
502: l_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
503: lc_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
504: l_row_notfound BOOLEAN := FALSE;
505: lc_row_notfound BOOLEAN := FALSE;
506: BEGIN

Line 503: lc_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;

499: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
500: l_api_version CONSTANT NUMBER := 1;
501: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
502: l_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
503: lc_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
504: l_row_notfound BOOLEAN := FALSE;
505: lc_row_notfound BOOLEAN := FALSE;
506: BEGIN
507: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 608: CURSOR cs_contract_types_pk_csr (p_contract_type_id IN NUMBER) IS

604: FUNCTION populate_new_record (
605: p_contracttype_rec IN ContractType_Rec_Type,
606: x_contracttype_rec OUT ContractType_Rec_Type
607: ) RETURN VARCHAR2 IS
608: CURSOR cs_contract_types_pk_csr (p_contract_type_id IN NUMBER) IS
609: SELECT *
610: FROM Cs_Contract_Types
611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;
612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;

Line 610: FROM Cs_Contract_Types

606: x_contracttype_rec OUT ContractType_Rec_Type
607: ) RETURN VARCHAR2 IS
608: CURSOR cs_contract_types_pk_csr (p_contract_type_id IN NUMBER) IS
609: SELECT *
610: FROM Cs_Contract_Types
611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;
612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;
613: l_row_notfound BOOLEAN := TRUE;
614: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;

607: ) RETURN VARCHAR2 IS
608: CURSOR cs_contract_types_pk_csr (p_contract_type_id IN NUMBER) IS
609: SELECT *
610: FROM Cs_Contract_Types
611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;
612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;
613: l_row_notfound BOOLEAN := TRUE;
614: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
615: BEGIN

Line 612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;

608: CURSOR cs_contract_types_pk_csr (p_contract_type_id IN NUMBER) IS
609: SELECT *
610: FROM Cs_Contract_Types
611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;
612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;
613: l_row_notfound BOOLEAN := TRUE;
614: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
615: BEGIN
616: x_contracttype_rec := p_contracttype_rec;

Line 618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);

614: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
615: BEGIN
616: x_contracttype_rec := p_contracttype_rec;
617: -- Get current database values
618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);
619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN

Line 619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;

615: BEGIN
616: x_contracttype_rec := p_contracttype_rec;
617: -- Get current database values
618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);
619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;

Line 620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;

616: x_contracttype_rec := p_contracttype_rec;
617: -- Get current database values
618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);
619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;

Line 621: CLOSE cs_contract_types_pk_csr;

617: -- Get current database values
618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);
619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625: IF (x_contracttype_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)

Line 627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;

623: l_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625: IF (x_contracttype_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
626: THEN
627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;
628: END IF;
629: IF (x_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
630: THEN
631: x_contracttype_rec.name := l_cs_contract_types_pk.name;

Line 631: x_contracttype_rec.name := l_cs_contract_types_pk.name;

627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;
628: END IF;
629: IF (x_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR)
630: THEN
631: x_contracttype_rec.name := l_cs_contract_types_pk.name;
632: END IF;
633: IF (x_contracttype_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
634: THEN
635: x_contracttype_rec.description := l_cs_contract_types_pk.description;

Line 635: x_contracttype_rec.description := l_cs_contract_types_pk.description;

631: x_contracttype_rec.name := l_cs_contract_types_pk.name;
632: END IF;
633: IF (x_contracttype_rec.description = TAPI_DEV_KIT.G_MISS_CHAR)
634: THEN
635: x_contracttype_rec.description := l_cs_contract_types_pk.description;
636: END IF;
637: IF (x_contracttype_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;

Line 639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;

635: x_contracttype_rec.description := l_cs_contract_types_pk.description;
636: END IF;
637: IF (x_contracttype_rec.cust_trx_type_id = TAPI_DEV_KIT.G_MISS_NUM)
638: THEN
639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;
640: END IF;
641: IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
642: THEN
643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;

Line 643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;

639: x_contracttype_rec.cust_trx_type_id := l_cs_contract_types_pk.cust_trx_type_id;
640: END IF;
641: IF (x_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE)
642: THEN
643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;
644: END IF;
645: IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;

Line 647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;

643: x_contracttype_rec.last_update_date := l_cs_contract_types_pk.last_update_date;
644: END IF;
645: IF (x_contracttype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM)
646: THEN
647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;
648: END IF;
649: IF (x_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;

Line 651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;

647: x_contracttype_rec.last_updated_by := l_cs_contract_types_pk.last_updated_by;
648: END IF;
649: IF (x_contracttype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE)
650: THEN
651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;
652: END IF;
653: IF (x_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;

Line 655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;

651: x_contracttype_rec.creation_date := l_cs_contract_types_pk.creation_date;
652: END IF;
653: IF (x_contracttype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM)
654: THEN
655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;
656: END IF;
657: IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;

Line 659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;

655: x_contracttype_rec.created_by := l_cs_contract_types_pk.created_by;
656: END IF;
657: IF (x_contracttype_rec.last_update_login = TAPI_DEV_KIT.G_MISS_NUM)
658: THEN
659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;
660: END IF;
661: IF (x_contracttype_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
662: THEN
663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;

Line 663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;

659: x_contracttype_rec.last_update_login := l_cs_contract_types_pk.last_update_login;
660: END IF;
661: IF (x_contracttype_rec.start_date_active = TAPI_DEV_KIT.G_MISS_DATE)
662: THEN
663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;
664: END IF;
665: IF (x_contracttype_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;

Line 667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;

663: x_contracttype_rec.start_date_active := l_cs_contract_types_pk.start_date_active;
664: END IF;
665: IF (x_contracttype_rec.end_date_active = TAPI_DEV_KIT.G_MISS_DATE)
666: THEN
667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;
668: END IF;
669: IF (x_contracttype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;

Line 671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;

667: x_contracttype_rec.end_date_active := l_cs_contract_types_pk.end_date_active;
668: END IF;
669: IF (x_contracttype_rec.attribute1 = TAPI_DEV_KIT.G_MISS_CHAR)
670: THEN
671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;
672: END IF;
673: IF (x_contracttype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;

Line 675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;

671: x_contracttype_rec.attribute1 := l_cs_contract_types_pk.attribute1;
672: END IF;
673: IF (x_contracttype_rec.attribute2 = TAPI_DEV_KIT.G_MISS_CHAR)
674: THEN
675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;
676: END IF;
677: IF (x_contracttype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;

Line 679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;

675: x_contracttype_rec.attribute2 := l_cs_contract_types_pk.attribute2;
676: END IF;
677: IF (x_contracttype_rec.attribute3 = TAPI_DEV_KIT.G_MISS_CHAR)
678: THEN
679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;
680: END IF;
681: IF (x_contracttype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;

Line 683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;

679: x_contracttype_rec.attribute3 := l_cs_contract_types_pk.attribute3;
680: END IF;
681: IF (x_contracttype_rec.attribute4 = TAPI_DEV_KIT.G_MISS_CHAR)
682: THEN
683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;
684: END IF;
685: IF (x_contracttype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;

Line 687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;

683: x_contracttype_rec.attribute4 := l_cs_contract_types_pk.attribute4;
684: END IF;
685: IF (x_contracttype_rec.attribute5 = TAPI_DEV_KIT.G_MISS_CHAR)
686: THEN
687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;
688: END IF;
689: IF (x_contracttype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;

Line 691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;

687: x_contracttype_rec.attribute5 := l_cs_contract_types_pk.attribute5;
688: END IF;
689: IF (x_contracttype_rec.attribute6 = TAPI_DEV_KIT.G_MISS_CHAR)
690: THEN
691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;
692: END IF;
693: IF (x_contracttype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;

Line 695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;

691: x_contracttype_rec.attribute6 := l_cs_contract_types_pk.attribute6;
692: END IF;
693: IF (x_contracttype_rec.attribute7 = TAPI_DEV_KIT.G_MISS_CHAR)
694: THEN
695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;
696: END IF;
697: IF (x_contracttype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;

Line 699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;

695: x_contracttype_rec.attribute7 := l_cs_contract_types_pk.attribute7;
696: END IF;
697: IF (x_contracttype_rec.attribute8 = TAPI_DEV_KIT.G_MISS_CHAR)
698: THEN
699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;
700: END IF;
701: IF (x_contracttype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;

Line 703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;

699: x_contracttype_rec.attribute8 := l_cs_contract_types_pk.attribute8;
700: END IF;
701: IF (x_contracttype_rec.attribute9 = TAPI_DEV_KIT.G_MISS_CHAR)
702: THEN
703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;
704: END IF;
705: IF (x_contracttype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;

Line 707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;

703: x_contracttype_rec.attribute9 := l_cs_contract_types_pk.attribute9;
704: END IF;
705: IF (x_contracttype_rec.attribute10 = TAPI_DEV_KIT.G_MISS_CHAR)
706: THEN
707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;
708: END IF;
709: IF (x_contracttype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;

Line 711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;

707: x_contracttype_rec.attribute10 := l_cs_contract_types_pk.attribute10;
708: END IF;
709: IF (x_contracttype_rec.attribute11 = TAPI_DEV_KIT.G_MISS_CHAR)
710: THEN
711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;
712: END IF;
713: IF (x_contracttype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;

Line 715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;

711: x_contracttype_rec.attribute11 := l_cs_contract_types_pk.attribute11;
712: END IF;
713: IF (x_contracttype_rec.attribute12 = TAPI_DEV_KIT.G_MISS_CHAR)
714: THEN
715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;
716: END IF;
717: IF (x_contracttype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;

Line 719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;

715: x_contracttype_rec.attribute12 := l_cs_contract_types_pk.attribute12;
716: END IF;
717: IF (x_contracttype_rec.attribute13 = TAPI_DEV_KIT.G_MISS_CHAR)
718: THEN
719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;
720: END IF;
721: IF (x_contracttype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;

Line 723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;

719: x_contracttype_rec.attribute13 := l_cs_contract_types_pk.attribute13;
720: END IF;
721: IF (x_contracttype_rec.attribute14 = TAPI_DEV_KIT.G_MISS_CHAR)
722: THEN
723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;
724: END IF;
725: IF (x_contracttype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;

Line 727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;

723: x_contracttype_rec.attribute14 := l_cs_contract_types_pk.attribute14;
724: END IF;
725: IF (x_contracttype_rec.attribute15 = TAPI_DEV_KIT.G_MISS_CHAR)
726: THEN
727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;
728: END IF;
729: IF (x_contracttype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_contracttype_rec.context := l_cs_contract_types_pk.context;

Line 731: x_contracttype_rec.context := l_cs_contract_types_pk.context;

727: x_contracttype_rec.attribute15 := l_cs_contract_types_pk.attribute15;
728: END IF;
729: IF (x_contracttype_rec.context = TAPI_DEV_KIT.G_MISS_CHAR)
730: THEN
731: x_contracttype_rec.context := l_cs_contract_types_pk.context;
732: END IF;
733: IF (x_contracttype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
734: THEN
735: x_contracttype_rec.object_version_number := l_cs_contract_types_pk.object_version_number;

Line 735: x_contracttype_rec.object_version_number := l_cs_contract_types_pk.object_version_number;

731: x_contracttype_rec.context := l_cs_contract_types_pk.context;
732: END IF;
733: IF (x_contracttype_rec.object_version_number = TAPI_DEV_KIT.G_MISS_NUM)
734: THEN
735: x_contracttype_rec.object_version_number := l_cs_contract_types_pk.object_version_number;
736: END IF;
737: RETURN(l_return_status);
738: END populate_new_record;
739: BEGIN

Line 792: UPDATE CS_CONTRACT_TYPES

788: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791: END IF;
792: UPDATE CS_CONTRACT_TYPES
793: SET
794: CONTRACT_TYPE_ID = l_def_contracttype_rec.contract_type_id ,
795: NAME = l_def_contracttype_rec.name ,
796: DESCRIPTION = l_def_contracttype_rec.description ,

Line 872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

868: x_return_status OUT VARCHAR2,
869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

869: x_msg_count OUT NUMBER,
870: x_msg_data OUT VARCHAR2,
871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

871: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
872: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

873: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
874: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
875: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

876: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

877: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

878: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

879: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

880: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

881: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

882: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

883: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

884: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

885: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

886: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

887: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

888: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

889: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

890: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

891: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS

Line 896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

892: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

893: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
894: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
895: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
896: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
897: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
901: l_api_version CONSTANT NUMBER := 1;

Line 1018: DELETE FROM CS_CONTRACT_TYPES

1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: DELETE FROM CS_CONTRACT_TYPES
1019: WHERE
1020: CONTRACT_TYPE_ID = p_contract_type_id
1021: ;
1022: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1150: x_return_status OUT VARCHAR2,
1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1151: x_msg_count OUT NUMBER,
1152: x_msg_data OUT VARCHAR2,
1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1153: p_contract_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1154: p_name IN CS_CONTRACT_TYPES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1155: p_description IN CS_CONTRACT_TYPES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1156: p_cust_trx_type_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1157: p_last_update_date IN CS_CONTRACT_TYPES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1158: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1159: p_creation_date IN CS_CONTRACT_TYPES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1160: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1161: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1162: p_start_date_active IN CS_CONTRACT_TYPES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1163: p_end_date_active IN CS_CONTRACT_TYPES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1164: p_attribute1 IN CS_CONTRACT_TYPES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1165: p_attribute2 IN CS_CONTRACT_TYPES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1166: p_attribute3 IN CS_CONTRACT_TYPES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1167: p_attribute4 IN CS_CONTRACT_TYPES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1168: p_attribute5 IN CS_CONTRACT_TYPES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1169: p_attribute6 IN CS_CONTRACT_TYPES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1170: p_attribute7 IN CS_CONTRACT_TYPES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1171: p_attribute8 IN CS_CONTRACT_TYPES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1172: p_attribute9 IN CS_CONTRACT_TYPES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1173: p_attribute10 IN CS_CONTRACT_TYPES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1174: p_attribute11 IN CS_CONTRACT_TYPES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;

Line 1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1175: p_attribute12 IN CS_CONTRACT_TYPES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1176: p_attribute13 IN CS_CONTRACT_TYPES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1177: p_attribute14 IN CS_CONTRACT_TYPES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1178: p_attribute15 IN CS_CONTRACT_TYPES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;