APPS.AK_CUSTOMIZATIONS_PKG dependencies on AK_CUSTOMIZATIONS_TL

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 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 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 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 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