[Home] [Help]
132: lkp.language,
133: lkp.meaning,
134: lkp.meaning,
135: lkp.source_lang
136: from fnd_lookup_values lkp
137: where lkp.lookup_type = 'ACTIVITY_CATEGORY'
138: and lkp.lookup_code = 'INCLASS'
139: and lkp.security_group_id = 0 -- added for bug#4116886
140: and lkp.view_application_id = 3; -- added for bug#4116886
2467: begin
2468: -- Migrates User defined lookup codes defined under 'FREQUENCY' to 'OTA_DURATION_UNITS'
2469: --
2470: begin
2471: Insert into FND_LOOKUP_VALUES
2472: (LOOKUP_TYPE,LANGUAGE,LOOKUP_CODE,MEANING,DESCRIPTION,ENABLED_FLAG,START_DATE_ACTIVE,
2473: END_DATE_ACTIVE,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_LOGIN,LAST_UPDATE_DATE,SOURCE_LANG,
2474: SECURITY_GROUP_ID,VIEW_APPLICATION_ID,TERRITORY_CODE,ATTRIBUTE_CATEGORY,ATTRIBUTE1,ATTRIBUTE2,ATTRIBUTE3,
2475: ATTRIBUTE4,ATTRIBUTE5,ATTRIBUTE6,ATTRIBUTE7,ATTRIBUTE8,ATTRIBUTE9,ATTRIBUTE10,ATTRIBUTE11,ATTRIBUTE12,
2478: lkp.END_DATE_ACTIVE,lkp.CREATED_BY,lkp.CREATION_DATE,lkp.LAST_UPDATED_BY,lkp.LAST_UPDATE_LOGIN,lkp.LAST_UPDATE_DATE,lkp.SOURCE_LANG,
2479: lkp.SECURITY_GROUP_ID,lkp.VIEW_APPLICATION_ID,lkp.TERRITORY_CODE,lkp.ATTRIBUTE_CATEGORY,lkp.ATTRIBUTE1,lkp.ATTRIBUTE2,lkp.ATTRIBUTE3,
2480: lkp.ATTRIBUTE4,lkp.ATTRIBUTE5,lkp.ATTRIBUTE6,lkp.ATTRIBUTE7,lkp.ATTRIBUTE8,lkp.ATTRIBUTE9,lkp.ATTRIBUTE10,lkp.ATTRIBUTE11,lkp.ATTRIBUTE12,
2481: lkp.ATTRIBUTE13,lkp.ATTRIBUTE14,lkp.ATTRIBUTE15,TAG
2482: From Fnd_Lookup_values lkp
2483: Where lkp.Lookup_type = 'FREQUENCY'
2484: and lkp.created_by not in (1,2)
2485: and (lkp.Lookup_code,lkp.language)
2486: not in (Select flk.Lookup_code,flk.language from Fnd_lookup_values flk
2482: From Fnd_Lookup_values lkp
2483: Where lkp.Lookup_type = 'FREQUENCY'
2484: and lkp.created_by not in (1,2)
2485: and (lkp.Lookup_code,lkp.language)
2486: not in (Select flk.Lookup_code,flk.language from Fnd_lookup_values flk
2487: Where flk.Lookup_type = 'OTA_DURATION_UNITS') ;
2488: Exception
2489: when others then
2490: l_err_code := SQLCODE;