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_CONTRACTSTATS_PVT dependencies on CS_CONTRACT_STATUSES

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

1: PACKAGE BODY CS_CONTRACTSTATS_PVT AS
2: /* $Header: csctcstb.pls 115.1 99/07/16 08:51:26 porting ship $ */
3: FUNCTION get_seq_id RETURN NUMBER IS
4: CURSOR get_seq_id_csr IS
5: SELECT CS_CONTRACT_STATUSES_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 231: INSERT INTO CS_CONTRACT_STATUSES(

227: END IF;
228: END IF;
229: -- Set primary key value
230: l_def_contractstats_rec.contract_status_id := get_seq_id;
231: INSERT INTO CS_CONTRACT_STATUSES(
232: contract_status_id,
233: name,
234: description,
235: validate_contract,

Line 349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,

345: p_commit IN VARCHAR2 := TAPI_DEV_KIT.G_FALSE,
346: x_return_status OUT VARCHAR2,
347: x_msg_count OUT NUMBER,
348: x_msg_data OUT VARCHAR2,
349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,

Line 350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,

346: x_return_status OUT VARCHAR2,
347: x_msg_count OUT NUMBER,
348: x_msg_data OUT VARCHAR2,
349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,

Line 351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,

347: x_msg_count OUT NUMBER,
348: x_msg_data OUT VARCHAR2,
349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,

Line 353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,

349: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := NULL,
350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,

Line 354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,

350: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := NULL,
351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,

Line 355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,

351: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := NULL,
352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
359: p_last_updated_by IN NUMBER := NULL,

Line 356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,

352: p_status_level IN NUMBER := NULL,
353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,

Line 357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,

353: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := NULL,
354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,

Line 358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,

354: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := NULL,
355: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := NULL,
356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,

Line 360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,

356: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := NULL,
357: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := NULL,
358: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := NULL,
359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,

Line 363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,

359: p_last_updated_by IN NUMBER := NULL,
360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,

Line 364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,

360: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := NULL,
361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,

Line 365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,

361: p_created_by IN NUMBER := NULL,
362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,

Line 366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,

362: p_last_update_login IN NUMBER := NULL,
363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,

Line 367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,

363: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := NULL,
364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,

Line 368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,

364: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := NULL,
365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,

Line 369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,

365: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := NULL,
366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,

Line 370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,

366: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := NULL,
367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,

Line 371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,

367: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := NULL,
368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,

Line 372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,

368: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := NULL,
369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,

Line 373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,

369: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := NULL,
370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,

Line 374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,

370: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := NULL,
371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,

Line 375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,

371: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := NULL,
372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,

Line 376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,

372: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := NULL,
373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,

Line 377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,

373: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := NULL,
374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
381: p_object_version_number IN NUMBER := NULL,

Line 378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,

374: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := NULL,
375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
381: p_object_version_number IN NUMBER := NULL,
382: x_contract_status_id OUT NUMBER,

Line 379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,

375: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := NULL,
376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
381: p_object_version_number IN NUMBER := NULL,
382: x_contract_status_id OUT NUMBER,
383: x_object_version_number OUT NUMBER) IS

Line 380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,

376: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := NULL,
377: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := NULL,
378: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := NULL,
379: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := NULL,
380: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := NULL,
381: p_object_version_number IN NUMBER := NULL,
382: x_contract_status_id OUT NUMBER,
383: x_object_version_number OUT NUMBER) IS
384: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';

Line 497: FROM CS_CONTRACT_STATUSES

493: E_Resource_Busy EXCEPTION;
494: PRAGMA EXCEPTION_INIT(E_Resource_Busy, -00054);
495: CURSOR lock_csr IS
496: SELECT OBJECT_VERSION_NUMBER
497: FROM CS_CONTRACT_STATUSES
498: WHERE
499: CONTRACT_STATUS_ID = p_contract_status_id AND
500: OBJECT_VERSION_NUMBER = p_object_version_number
501: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;

Line 505: FROM CS_CONTRACT_STATUSES

501: FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
502:
503: CURSOR lchk_csr IS
504: SELECT OBJECT_VERSION_NUMBER
505: FROM CS_CONTRACT_STATUSES
506: WHERE
507: CONTRACT_STATUS_ID = p_contract_status_id
508: ;
509: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';

Line 512: l_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;

508: ;
509: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
510: l_api_version CONSTANT NUMBER := 1;
511: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
512: l_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;
513: lc_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;
514: l_row_notfound BOOLEAN := FALSE;
515: lc_row_notfound BOOLEAN := FALSE;
516: BEGIN

Line 513: lc_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;

509: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
510: l_api_version CONSTANT NUMBER := 1;
511: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
512: l_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;
513: lc_object_version_number CS_CONTRACT_STATUSES.OBJECT_VERSION_NUMBER%TYPE;
514: l_row_notfound BOOLEAN := FALSE;
515: lc_row_notfound BOOLEAN := FALSE;
516: BEGIN
517: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 620: FROM Cs_Contract_Statuses

616: x_contractstats_rec OUT ContractStats_Rec_Type
617: ) RETURN VARCHAR2 IS
618: CURSOR cs_contracts_statuses_pk_csr (p_contract_status_id IN NUMBER) IS
619: SELECT *
620: FROM Cs_Contract_Statuses
621: WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;
622: l_cs_contracts_statuses_pk cs_contracts_statuses_pk_csr%ROWTYPE;
623: l_row_notfound BOOLEAN := TRUE;
624: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 621: WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;

617: ) RETURN VARCHAR2 IS
618: CURSOR cs_contracts_statuses_pk_csr (p_contract_status_id IN NUMBER) IS
619: SELECT *
620: FROM Cs_Contract_Statuses
621: WHERE cs_contract_statuses.contract_status_id = p_contract_status_id;
622: l_cs_contracts_statuses_pk cs_contracts_statuses_pk_csr%ROWTYPE;
623: l_row_notfound BOOLEAN := TRUE;
624: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
625: BEGIN

Line 826: UPDATE CS_CONTRACT_STATUSES

822: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
823: RAISE FND_API.G_EXC_ERROR;
824: END IF;
825: END IF;
826: UPDATE CS_CONTRACT_STATUSES
827: SET
828: CONTRACT_STATUS_ID = l_def_contractstats_rec.contract_status_id ,
829: NAME = l_def_contractstats_rec.name ,
830: DESCRIPTION = l_def_contractstats_rec.description ,

Line 912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

910: x_msg_data OUT VARCHAR2,
911: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

912: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

913: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

914: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

915: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

916: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

917: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
918: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

919: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
920: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
921: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

922: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

923: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

924: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

925: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

926: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

927: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

928: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

929: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

930: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

931: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

932: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

933: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

934: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

935: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

936: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

937: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS

Line 942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

938: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS
946: l_api_name CONSTANT VARCHAR2(30) := 'update_row';

Line 943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

939: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
940: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
941: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
942: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
943: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
944: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
945: x_object_version_number OUT NUMBER) IS
946: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
947: l_api_version CONSTANT NUMBER := 1;

Line 1070: DELETE FROM CS_CONTRACT_STATUSES

1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: DELETE FROM CS_CONTRACT_STATUSES
1071: WHERE
1072: CONTRACT_STATUS_ID = p_contract_status_id
1073: ;
1074: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1202: x_return_status OUT VARCHAR2,
1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1203: x_msg_count OUT NUMBER,
1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1204: x_msg_data OUT VARCHAR2,
1205: p_contract_status_id IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1206: p_name IN CS_CONTRACT_STATUSES.NAME%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1207: p_description IN CS_CONTRACT_STATUSES.DESCRIPTION%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1208: p_validate_contract IN CS_CONTRACT_STATUSES.VALIDATE_CONTRACT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1209: p_status_level IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1210: p_eligible_for_invoicing IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_INVOICING%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1211: p_update_allowed IN CS_CONTRACT_STATUSES.UPDATE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1212: p_eligible_for_entitlements IN CS_CONTRACT_STATUSES.ELIGIBLE_FOR_ENTITLEMENTS%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,

Line 1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1213: p_terminated_flag IN CS_CONTRACT_STATUSES.TERMINATED_FLAG%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1214: p_delete_allowed IN CS_CONTRACT_STATUSES.DELETE_ALLOWED%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1215: p_last_update_date IN CS_CONTRACT_STATUSES.LAST_UPDATE_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

Line 1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1216: p_last_updated_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,

1217: p_creation_date IN CS_CONTRACT_STATUSES.CREATION_DATE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1218: p_created_by IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1219: p_last_update_login IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1220: p_start_date_active IN CS_CONTRACT_STATUSES.START_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1221: p_end_date_active IN CS_CONTRACT_STATUSES.END_DATE_ACTIVE%TYPE := TAPI_DEV_KIT.G_MISS_DATE,
1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1222: p_attribute1 IN CS_CONTRACT_STATUSES.ATTRIBUTE1%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1223: p_attribute2 IN CS_CONTRACT_STATUSES.ATTRIBUTE2%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1224: p_attribute3 IN CS_CONTRACT_STATUSES.ATTRIBUTE3%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1225: p_attribute4 IN CS_CONTRACT_STATUSES.ATTRIBUTE4%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1226: p_attribute5 IN CS_CONTRACT_STATUSES.ATTRIBUTE5%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1227: p_attribute6 IN CS_CONTRACT_STATUSES.ATTRIBUTE6%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1228: p_attribute7 IN CS_CONTRACT_STATUSES.ATTRIBUTE7%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1229: p_attribute8 IN CS_CONTRACT_STATUSES.ATTRIBUTE8%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

Line 1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1230: p_attribute9 IN CS_CONTRACT_STATUSES.ATTRIBUTE9%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS

Line 1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1231: p_attribute10 IN CS_CONTRACT_STATUSES.ATTRIBUTE10%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';

Line 1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1232: p_attribute11 IN CS_CONTRACT_STATUSES.ATTRIBUTE11%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1240: l_api_version CONSTANT NUMBER := 1;

Line 1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,

1233: p_attribute12 IN CS_CONTRACT_STATUSES.ATTRIBUTE12%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1234: p_attribute13 IN CS_CONTRACT_STATUSES.ATTRIBUTE13%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1235: p_attribute14 IN CS_CONTRACT_STATUSES.ATTRIBUTE14%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1236: p_attribute15 IN CS_CONTRACT_STATUSES.ATTRIBUTE15%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1237: p_context IN CS_CONTRACT_STATUSES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1238: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1239: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1240: l_api_version CONSTANT NUMBER := 1;
1241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;