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.AK_CUSTOM_REGION_ITEMS_PKG dependencies on AK_CUSTOM_REGION_ITEMS_TL

Line 72: insert into AK_CUSTOM_REGION_ITEMS_TL (

68: raise no_data_found;
69: end if;
70: close C;
71:
72: insert into AK_CUSTOM_REGION_ITEMS_TL (
73: CUSTOMIZATION_APPLICATION_ID,
74: CUSTOMIZATION_CODE,
75: REGION_APPLICATION_ID,
76: REGION_CODE,

Line 108: from AK_CUSTOM_REGION_ITEMS_TL T

104: from FND_LANGUAGES L
105: where L.INSTALLED_FLAG in ('I', 'B')
106: and not exists
107: (select NULL
108: from AK_CUSTOM_REGION_ITEMS_TL T
109: where T.CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
110: and T.CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
111: and T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
112: and T.REGION_CODE = X_REGION_CODE

Line 160: from AK_CUSTOM_REGION_ITEMS_TL

156: recinfo C%rowtype;
157:
158: cursor C1 is select
159: PROPERTY_VARCHAR2_VALUE
160: from AK_CUSTOM_REGION_ITEMS_TL
161: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
162: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
163: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
164: and REGION_CODE = X_REGION_CODE

Line 279: update AK_CUSTOM_REGION_ITEMS_TL set

275: if (sql%notfound) then
276: raise no_data_found;
277: end if;
278:
279: update AK_CUSTOM_REGION_ITEMS_TL set
280: PROPERTY_VARCHAR2_VALUE = X_PROPERTY_VARCHAR2_VALUE,
281: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
282: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
283: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 322: delete from AK_CUSTOM_REGION_ITEMS_TL

318: if (sql%notfound) then
319: raise no_data_found;
320: end if;
321:
322: delete from AK_CUSTOM_REGION_ITEMS_TL
323: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
324: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
325: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
326: and REGION_CODE = X_REGION_CODE

Line 345: delete from AK_CUSTOM_REGION_ITEMS_TL T

341: /* The following delete and update statements are commented out */
342: /* as a quick workaround to fix the time-consuming table handler issue */
343: /* Eventually we'll need to turn them into a separate fix_language procedure */
344: /*
345: delete from AK_CUSTOM_REGION_ITEMS_TL T
346: where not exists
347: (select NULL
348: from AK_CUSTOM_REGION_ITEMS B
349: where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID

Line 358: update AK_CUSTOM_REGION_ITEMS_TL T set (

354: and B.ATTRIBUTE_CODE = T.ATTRIBUTE_CODE
355: and B.PROPERTY_NAME = T.PROPERTY_NAME
356: );
357:
358: update AK_CUSTOM_REGION_ITEMS_TL T set (
359: PROPERTY_VARCHAR2_VALUE
360: ) = (select
361: B.PROPERTY_VARCHAR2_VALUE
362: from AK_CUSTOM_REGION_ITEMS_TL B

Line 362: from AK_CUSTOM_REGION_ITEMS_TL B

358: update AK_CUSTOM_REGION_ITEMS_TL T set (
359: PROPERTY_VARCHAR2_VALUE
360: ) = (select
361: B.PROPERTY_VARCHAR2_VALUE
362: from AK_CUSTOM_REGION_ITEMS_TL B
363: where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID
364: and B.CUSTOMIZATION_CODE = T.CUSTOMIZATION_CODE
365: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
366: and B.REGION_CODE = T.REGION_CODE

Line 388: from AK_CUSTOM_REGION_ITEMS_TL SUBB,

384: SUBT.ATTRIBUTE_APPLICATION_ID,
385: SUBT.ATTRIBUTE_CODE,
386: SUBT.PROPERTY_NAME,
387: SUBT.LANGUAGE
388: from AK_CUSTOM_REGION_ITEMS_TL SUBB,
389: AK_CUSTOM_REGION_ITEMS_TL SUBT
390: where SUBB.CUSTOMIZATION_APPLICATION_ID = SUBT.CUSTOMIZATION_APPLICATION_ID
391: and SUBB.CUSTOMIZATION_CODE = SUBT.CUSTOMIZATION_CODE
392: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID

Line 389: AK_CUSTOM_REGION_ITEMS_TL SUBT

385: SUBT.ATTRIBUTE_CODE,
386: SUBT.PROPERTY_NAME,
387: SUBT.LANGUAGE
388: from AK_CUSTOM_REGION_ITEMS_TL SUBB,
389: AK_CUSTOM_REGION_ITEMS_TL SUBT
390: where SUBB.CUSTOMIZATION_APPLICATION_ID = SUBT.CUSTOMIZATION_APPLICATION_ID
391: and SUBB.CUSTOMIZATION_CODE = SUBT.CUSTOMIZATION_CODE
392: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
393: and SUBB.REGION_CODE = SUBT.REGION_CODE

Line 404: insert /+ append parallel(tt) / into AK_CUSTOM_REGION_ITEMS_TL tt (

400: or (SUBB.PROPERTY_VARCHAR2_VALUE is not null and SUBT.PROPERTY_VARCHAR2_VALUE is null))
401: );
402: */
403:
404: insert /*+ append parallel(tt) */ into AK_CUSTOM_REGION_ITEMS_TL tt (
405: CUSTOMIZATION_APPLICATION_ID,
406: CUSTOMIZATION_CODE,
407: REGION_APPLICATION_ID,
408: REGION_CODE,

Line 437: from AK_CUSTOM_REGION_ITEMS_TL B,

433: B.CREATION_DATE,
434: B.LAST_UPDATED_BY,
435: B.LAST_UPDATE_DATE,
436: B.LAST_UPDATE_LOGIN
437: from AK_CUSTOM_REGION_ITEMS_TL B,
438: FND_LANGUAGES L
439: where L.INSTALLED_FLAG in ('I', 'B')
440: and B.LANGUAGE = userenv('LANG')
441: ) v, AK_CUSTOM_REGION_ITEMS_TL t

Line 441: ) v, AK_CUSTOM_REGION_ITEMS_TL t

437: from AK_CUSTOM_REGION_ITEMS_TL B,
438: FND_LANGUAGES L
439: where L.INSTALLED_FLAG in ('I', 'B')
440: and B.LANGUAGE = userenv('LANG')
441: ) v, AK_CUSTOM_REGION_ITEMS_TL t
442: where T.CUSTOMIZATION_APPLICATION_ID(+) = v.CUSTOMIZATION_APPLICATION_ID
443: and T.CUSTOMIZATION_CODE(+) = v.CUSTOMIZATION_CODE
444: and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
445: and T.REGION_CODE(+) = v.REGION_CODE