APPS.BSC_KPI_DIM_LEVELS_PKG dependencies on BSC_KPI_DIM_LEVELS_TL

Line 107: insert into BSC_KPI_DIM_LEVELS_TL (

103: X_USER_LEVEL2,
104: X_USER_LEVEL2_DEFAULT
105: );
106:
107: insert into BSC_KPI_DIM_LEVELS_TL (
108: INDICATOR,
109: DIM_SET_ID,
110: DIM_LEVEL_INDEX,
111: NAME,

Line 131: from BSC_KPI_DIM_LEVELS_TL T

127: from FND_LANGUAGES L
128: where L.INSTALLED_FLAG in ('I', 'B')
129: and not exists
130: (select NULL
131: from BSC_KPI_DIM_LEVELS_TL T
132: where T.INDICATOR = X_INDICATOR
133: and T.DIM_SET_ID = X_DIM_SET_ID
134: and T.DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX
135: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 222: from BSC_KPI_DIM_LEVELS_TL

218: HELP,
219: TOTAL_DISP_NAME,
220: COMP_DISP_NAME,
221: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
222: from BSC_KPI_DIM_LEVELS_TL
223: where INDICATOR = X_INDICATOR
224: and DIM_SET_ID = X_DIM_SET_ID
225: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX
226: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 380: update BSC_KPI_DIM_LEVELS_TL set

376: if (sql%notfound) then
377: raise no_data_found;
378: end if;
379:
380: update BSC_KPI_DIM_LEVELS_TL set
381: NAME = X_NAME,
382: HELP = X_HELP,
383: TOTAL_DISP_NAME = X_TOTAL_DISP_NAME,
384: COMP_DISP_NAME = X_COMP_DISP_NAME,

Line 402: delete from BSC_KPI_DIM_LEVELS_TL

398: X_DIM_SET_ID in NUMBER,
399: X_DIM_LEVEL_INDEX in NUMBER
400: ) is
401: begin
402: delete from BSC_KPI_DIM_LEVELS_TL
403: where INDICATOR = X_INDICATOR
404: and DIM_SET_ID = X_DIM_SET_ID
405: and DIM_LEVEL_INDEX = X_DIM_LEVEL_INDEX;
406:

Line 424: delete from BSC_KPI_DIM_LEVELS_TL T

420:
421: procedure ADD_LANGUAGE
422: is
423: begin
424: delete from BSC_KPI_DIM_LEVELS_TL T
425: where not exists
426: (select NULL
427: from BSC_KPI_DIM_LEVELS_B B
428: where B.INDICATOR = T.INDICATOR

Line 433: update BSC_KPI_DIM_LEVELS_TL T set (

429: and B.DIM_SET_ID = T.DIM_SET_ID
430: and B.DIM_LEVEL_INDEX = T.DIM_LEVEL_INDEX
431: );
432:
433: update BSC_KPI_DIM_LEVELS_TL T set (
434: NAME,
435: HELP,
436: TOTAL_DISP_NAME,
437: COMP_DISP_NAME

Line 443: from BSC_KPI_DIM_LEVELS_TL B

439: B.NAME,
440: B.HELP,
441: B.TOTAL_DISP_NAME,
442: B.COMP_DISP_NAME
443: from BSC_KPI_DIM_LEVELS_TL B
444: where B.INDICATOR = T.INDICATOR
445: and B.DIM_SET_ID = T.DIM_SET_ID
446: and B.DIM_LEVEL_INDEX = T.DIM_LEVEL_INDEX
447: and B.LANGUAGE = T.SOURCE_LANG)

Line 458: from BSC_KPI_DIM_LEVELS_TL SUBB, BSC_KPI_DIM_LEVELS_TL SUBT

454: SUBT.INDICATOR,
455: SUBT.DIM_SET_ID,
456: SUBT.DIM_LEVEL_INDEX,
457: SUBT.LANGUAGE
458: from BSC_KPI_DIM_LEVELS_TL SUBB, BSC_KPI_DIM_LEVELS_TL SUBT
459: where SUBB.INDICATOR = SUBT.INDICATOR
460: and SUBB.DIM_SET_ID = SUBT.DIM_SET_ID
461: and SUBB.DIM_LEVEL_INDEX = SUBT.DIM_LEVEL_INDEX
462: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 473: insert into BSC_KPI_DIM_LEVELS_TL (

469: or (SUBB.COMP_DISP_NAME is null and SUBT.COMP_DISP_NAME is not null)
470: or (SUBB.COMP_DISP_NAME is not null and SUBT.COMP_DISP_NAME is null)
471: ));
472:
473: insert into BSC_KPI_DIM_LEVELS_TL (
474: INDICATOR,
475: DIM_SET_ID,
476: DIM_LEVEL_INDEX,
477: NAME,

Line 493: from BSC_KPI_DIM_LEVELS_TL B, FND_LANGUAGES L

489: B.TOTAL_DISP_NAME,
490: B.COMP_DISP_NAME,
491: L.LANGUAGE_CODE,
492: B.SOURCE_LANG
493: from BSC_KPI_DIM_LEVELS_TL B, FND_LANGUAGES L
494: where L.INSTALLED_FLAG in ('I', 'B')
495: and B.LANGUAGE = userenv('LANG')
496: and not exists
497: (select NULL

Line 498: from BSC_KPI_DIM_LEVELS_TL T

494: where L.INSTALLED_FLAG in ('I', 'B')
495: and B.LANGUAGE = userenv('LANG')
496: and not exists
497: (select NULL
498: from BSC_KPI_DIM_LEVELS_TL T
499: where T.INDICATOR = B.INDICATOR
500: and T.DIM_SET_ID = B.DIM_SET_ID
501: and T.DIM_LEVEL_INDEX = B.DIM_LEVEL_INDEX
502: and T.LANGUAGE = L.LANGUAGE_CODE);