APPS.OKS_CVP_PVT dependencies on FND_LOOKUP_VALUES

Line 3446: v_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ;

3442: l_api_version CONSTANT NUMBER := 1;
3443: l_api_name CONSTANT VARCHAR2(30) := 'V_MIGRATE_COVTYPES';
3444: l_api_name2 CONSTANT VARCHAR2(30) := 'V_MIGRATE_COVTYPES_LANG';
3445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3446: v_code FND_LOOKUP_VALUES.LOOKUP_CODE%TYPE ;
3447: v_exist BOOLEAN;
3448: v_sourcelang_null BOOLEAN :=FALSE;
3449: v_source_lang VARCHAR2(4);
3450: v_lang VARCHAR2(30);

Line 3460: FROM FND_LOOKUP_VALUES F

3456: F.CREATED_BY, F.CREATION_DATE,F.START_DATE_ACTIVE , F.END_DATE_ACTIVE,
3457: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,ATTRIBUTE5, ATTRIBUTE6,
3458: ATTRIBUTE7, ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
3459: ATTRIBUTE13, ATTRIBUTE14,ATTRIBUTE15
3460: FROM FND_LOOKUP_VALUES F
3461: WHERE F.LOOKUP_TYPE = 'OKSCVETYPE';
3462:
3463:
3464: CURSOR CUR_CHECK_EXISTS_B(v_code VARCHAR2) IS

Line 3702: delete FND_LOOKUP_VALUES

3698:
3699: BEGIN
3700:
3701: BEGIN
3702: delete FND_LOOKUP_VALUES
3703: where lookup_code in
3704: (SELECT code FROM oks_cov_types_v)
3705: and lookup_type = 'OKSCVETYPE';
3706: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

Line 3724: and not exists (SELECT 'x' from FND_LOOKUP_VALUES

3720: END;
3721: BEGIN
3722: delete from FND_LOOKUP_TYPES_TL
3723: where LOOKUP_TYPE = 'OKSCVETYPE'
3724: and not exists (SELECT 'x' from FND_LOOKUP_VALUES
3725: WHERE lookup_type = 'OKSCVETYPE');
3726: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
3727:
3728: EXCEPTION

Line 3745: and not exists (SELECT 'x' from FND_LOOKUP_VALUES

3741: END;
3742: BEGIN
3743: delete from FND_LOOKUP_TYPES
3744: where LOOKUP_TYPE = 'OKSCVETYPE'
3745: and not exists (SELECT 'x' from FND_LOOKUP_VALUES
3746: WHERE lookup_type = 'OKSCVETYPE');
3747:
3748: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
3749: EXCEPTION

Line 3785: update FND_LOOKUP_VALUES

3781: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3782: --BEGIN
3783: BEGIN
3784:
3785: update FND_LOOKUP_VALUES
3786: set END_DATE_ACTIVE = sysdate-1
3787: where lookup_code in
3788: (SELECT code FROM oks_cov_types_v)
3789: and lookup_type = 'OKSCVETYPE';