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_CUSTOMIZATIONS_PKG dependencies on AK_CUSTOMIZATIONS

Line 1: package body AK_CUSTOMIZATIONS_PKG as

1: package body AK_CUSTOMIZATIONS_PKG as
2: /* $Header: AKDCUSTB.pls 120.3 2006/01/25 15:56:42 tshort noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 28: cursor C is select ROWID from AK_CUSTOMIZATIONS

24: X_LAST_UPDATE_LOGIN in NUMBER,
25: X_START_DATE_ACTIVE in DATE,
26: X_END_DATE_ACTIVE in DATE
27: ) is
28: cursor C is select ROWID from AK_CUSTOMIZATIONS
29: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
30: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
31: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
32: and REGION_CODE = X_REGION_CODE;

Line 34: insert into AK_CUSTOMIZATIONS (

30: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
31: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
32: and REGION_CODE = X_REGION_CODE;
33: begin
34: insert into AK_CUSTOMIZATIONS (
35: CUSTOMIZATION_APPLICATION_ID,
36: CUSTOMIZATION_CODE,
37: REGION_APPLICATION_ID,
38: REGION_CODE,

Line 84: insert into AK_CUSTOMIZATIONS_TL (

80: raise no_data_found;
81: end if;
82: close C;
83:
84: insert into AK_CUSTOMIZATIONS_TL (
85: CUSTOMIZATION_APPLICATION_ID,
86: CUSTOMIZATION_CODE,
87: REGION_APPLICATION_ID,
88: REGION_CODE,

Line 116: from AK_CUSTOMIZATIONS_TL T

112: from FND_LANGUAGES L
113: where L.INSTALLED_FLAG in ('I', 'B')
114: and not exists
115: (select NULL
116: from AK_CUSTOMIZATIONS_TL T
117: where T.CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
118: and T.CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
119: and T.REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
120: and T.REGION_CODE = X_REGION_CODE

Line 167: from AK_CUSTOMIZATIONS

163: LAST_UPDATE_DATE,
164: LAST_UPDATE_LOGIN,
165: START_DATE_ACTIVE,
166: END_DATE_ACTIVE
167: from AK_CUSTOMIZATIONS
168: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
169: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
170: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
171: and REGION_CODE = X_REGION_CODE

Line 178: from AK_CUSTOMIZATIONS_TL

174:
175: cursor C1 is select
176: NAME,
177: DESCRIPTION
178: from AK_CUSTOMIZATIONS_TL
179: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
180: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
181: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
182: and REGION_CODE = X_REGION_CODE

Line 281: update AK_CUSTOMIZATIONS set

277: X_START_DATE_ACTIVE in DATE,
278: X_END_DATE_ACTIVE in DATE
279: ) is
280: begin
281: update AK_CUSTOMIZATIONS set
282: CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID,
283: CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE,
284: REGION_APPLICATION_ID = X_REGION_APPLICATION_ID,
285: REGION_CODE = X_REGION_CODE,

Line 308: update AK_CUSTOMIZATIONS_TL set

304: if (sql%notfound) then
305: raise no_data_found;
306: end if;
307:
308: update AK_CUSTOMIZATIONS_TL set
309: NAME = X_NAME,
310: DESCRIPTION = X_DESCRIPTION,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
312: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 333: delete from AK_CUSTOMIZATIONS

329: X_REGION_APPLICATION_ID in NUMBER,
330: X_REGION_CODE in VARCHAR2
331: ) is
332: begin
333: delete from AK_CUSTOMIZATIONS
334: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
335: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
336: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
337: and REGION_CODE = X_REGION_CODE;

Line 343: delete from AK_CUSTOMIZATIONS_TL

339: if (sql%notfound) then
340: raise no_data_found;
341: end if;
342:
343: delete from AK_CUSTOMIZATIONS_TL
344: where CUSTOMIZATION_APPLICATION_ID = X_CUSTOMIZATION_APPLICATION_ID
345: and CUSTOMIZATION_CODE = X_CUSTOMIZATION_CODE
346: and REGION_APPLICATION_ID = X_REGION_APPLICATION_ID
347: and REGION_CODE = X_REGION_CODE;

Line 363: delete from AK_CUSTOMIZATIONS_TL T

359: /* as a quick workaround to fix the time-consuming table handler issue */
360: /* Eventually we'll need to turn them into a separate fix_language procedure */
361: /*
362:
363: delete from AK_CUSTOMIZATIONS_TL T
364: where not exists
365: (select NULL
366: from AK_CUSTOMIZATIONS B
367: where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID

Line 366: from AK_CUSTOMIZATIONS B

362:
363: delete from AK_CUSTOMIZATIONS_TL T
364: where not exists
365: (select NULL
366: from AK_CUSTOMIZATIONS B
367: where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID
368: and B.CUSTOMIZATION_CODE = T.CUSTOMIZATION_CODE
369: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
370: and B.REGION_CODE = T.REGION_CODE

Line 373: update AK_CUSTOMIZATIONS_TL T set (

369: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
370: and B.REGION_CODE = T.REGION_CODE
371: );
372:
373: update AK_CUSTOMIZATIONS_TL T set (
374: NAME,
375: DESCRIPTION
376: ) = (select B.NAME,
377: B.DESCRIPTION

Line 378: from AK_CUSTOMIZATIONS_TL B

374: NAME,
375: DESCRIPTION
376: ) = (select B.NAME,
377: B.DESCRIPTION
378: from AK_CUSTOMIZATIONS_TL B
379: where B.CUSTOMIZATION_APPLICATION_ID = T.CUSTOMIZATION_APPLICATION_ID
380: and B.CUSTOMIZATION_CODE = T.CUSTOMIZATION_CODE
381: and B.REGION_APPLICATION_ID = T.REGION_APPLICATION_ID
382: and B.REGION_CODE = T.REGION_CODE

Line 395: from AK_CUSTOMIZATIONS_TL SUBB,

391: SUBT.CUSTOMIZATION_CODE,
392: SUBT.REGION_APPLICATION_ID,
393: SUBT.REGION_CODE,
394: SUBT.LANGUAGE
395: from AK_CUSTOMIZATIONS_TL SUBB,
396: AK_CUSTOMIZATIONS_TL SUBT
397: where SUBB.CUSTOMIZATION_APPLICATION_ID = SUBT.CUSTOMIZATION_APPLICATION_ID
398: and SUBB.CUSTOMIZATION_CODE = SUBT.CUSTOMIZATION_CODE
399: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID

Line 396: AK_CUSTOMIZATIONS_TL SUBT

392: SUBT.REGION_APPLICATION_ID,
393: SUBT.REGION_CODE,
394: SUBT.LANGUAGE
395: from AK_CUSTOMIZATIONS_TL SUBB,
396: AK_CUSTOMIZATIONS_TL SUBT
397: where SUBB.CUSTOMIZATION_APPLICATION_ID = SUBT.CUSTOMIZATION_APPLICATION_ID
398: and SUBB.CUSTOMIZATION_CODE = SUBT.CUSTOMIZATION_CODE
399: and SUBB.REGION_APPLICATION_ID = SUBT.REGION_APPLICATION_ID
400: and SUBB.REGION_CODE = SUBT.REGION_CODE

Line 412: insert /+ append parallel(tt) / into AK_CUSTOMIZATIONS_TL tt (

408: );
409:
410: */
411:
412: insert /*+ append parallel(tt) */ into AK_CUSTOMIZATIONS_TL tt (
413: CUSTOMIZATION_APPLICATION_ID,
414: CUSTOMIZATION_CODE,
415: REGION_APPLICATION_ID,
416: REGION_CODE,

Line 441: from AK_CUSTOMIZATIONS_TL B,

437: B.CREATION_DATE,
438: B.LAST_UPDATED_BY,
439: B.LAST_UPDATE_DATE,
440: B.LAST_UPDATE_LOGIN
441: from AK_CUSTOMIZATIONS_TL B,
442: FND_LANGUAGES L
443: where L.INSTALLED_FLAG in ('I', 'B')
444: and B.LANGUAGE = userenv('LANG')
445: ) v, AK_CUSTOMIZATIONS_TL T

Line 445: ) v, AK_CUSTOMIZATIONS_TL T

441: from AK_CUSTOMIZATIONS_TL B,
442: FND_LANGUAGES L
443: where L.INSTALLED_FLAG in ('I', 'B')
444: and B.LANGUAGE = userenv('LANG')
445: ) v, AK_CUSTOMIZATIONS_TL T
446: where T.CUSTOMIZATION_APPLICATION_ID(+) = v.CUSTOMIZATION_APPLICATION_ID
447: and T.CUSTOMIZATION_CODE(+) = v.CUSTOMIZATION_CODE
448: and T.REGION_APPLICATION_ID(+) = v.REGION_APPLICATION_ID
449: and T.REGION_CODE(+) = v.REGION_CODE

Line 458: end AK_CUSTOMIZATIONS_PKG;

454: and T.REGION_CODE is NULL;
455:
456: end ADD_LANGUAGE;
457:
458: end AK_CUSTOMIZATIONS_PKG;