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

Line 1: package body AK_CUSTOM_REGION_ITEMS_PKG as

1: package body AK_CUSTOM_REGION_ITEMS_PKG as
2: /* $Header: AKDCRITB.pls 120.3 2006/01/25 15:31:25 tshort noship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out NOCOPY VARCHAR2,
5: X_CUSTOMIZATION_APPLICATION_ID in NUMBER,

Line 21: cursor C is select ROWID from AK_CUSTOM_REGION_ITEMS

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_DATE in DATE,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from AK_CUSTOM_REGION_ITEMS
22: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
23: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
24: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
25: and REGION_CODE = X_REGION_CODE

Line 30: insert into AK_CUSTOM_REGION_ITEMS (

26: and ATTRIBUTE_APPLICATION_ID = X_ATTRIBUTE_APPLICATION_ID
27: and ATTRIBUTE_CODE = X_ATTRIBUTE_CODE
28: and PROPERTY_NAME = X_PROPERTY_NAME;
29: begin
30: insert into AK_CUSTOM_REGION_ITEMS (
31: CUSTOMIZATION_APPLICATION_ID,
32: CUSTOMIZATION_CODE,
33: REGION_APPLICATION_ID,
34: REGION_CODE,

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 147: from AK_CUSTOM_REGION_ITEMS

143: PROPERTY_NAME,
144: PROPERTY_VARCHAR2_VALUE,
145: PROPERTY_NUMBER_VALUE,
146: PROPERTY_DATE_VALUE
147: from AK_CUSTOM_REGION_ITEMS
148: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
149: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
150: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
151: and 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 253: update AK_CUSTOM_REGION_ITEMS set

249: X_LAST_UPDATE_DATE in DATE,
250: X_LAST_UPDATE_LOGIN in NUMBER
251: ) is
252: begin
253: update AK_CUSTOM_REGION_ITEMS set
254: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID,
255: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE,
256: REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
257: 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 309: delete from AK_CUSTOM_REGION_ITEMS

305: X_ATTRIBUTE_CODE in VARCHAR2,
306: X_PROPERTY_NAME in VARCHAR2
307: ) is
308: begin
309: delete from AK_CUSTOM_REGION_ITEMS
310: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
311: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
312: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
313: and REGION_CODE = X_REGION_CODE

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 348: from AK_CUSTOM_REGION_ITEMS B

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
350: and B.CUSTOMIZATION_CODE = T.CUSTOMIZATION_CODE
351: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
352: and B.REGION_CODE = T.REGION_CODE

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

Line 460: end AK_CUSTOM_REGION_ITEMS_PKG;

456: and T.PROPERTY_NAME is NULL;
457:
458: end ADD_LANGUAGE;
459:
460: end AK_CUSTOM_REGION_ITEMS_PKG;