APPS.BSC_KPI_DEFAULTS_PKG dependencies on BSC_KPI_DEFAULTS_TL

Line 87: insert into BSC_KPI_DEFAULTS_TL (

83: X_DIM_LEVEL7_VALUE,
84: X_DIM_LEVEL8_VALUE
85: );
86:
87: insert into BSC_KPI_DEFAULTS_TL (
88: TAB_ID,
89: INDICATOR,
90: ANALYSIS_OPTION0_NAME,
91: ANALYSIS_OPTION1_NAME,

Line 143: from BSC_KPI_DEFAULTS_TL T

139: from FND_LANGUAGES L
140: where L.INSTALLED_FLAG in ('I', 'B')
141: and not exists
142: (select NULL
143: from BSC_KPI_DEFAULTS_TL T
144: where T.TAB_ID = X_TAB_ID
145: and T.INDICATOR = X_INDICATOR
146: and T.LANGUAGE = L.LANGUAGE_CODE);
147:

Line 243: from BSC_KPI_DEFAULTS_TL

239: DIM_LEVEL6_TEXT,
240: DIM_LEVEL7_TEXT,
241: DIM_LEVEL8_TEXT,
242: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
243: from BSC_KPI_DEFAULTS_TL
244: where TAB_ID = X_TAB_ID
245: and INDICATOR = X_INDICATOR
246: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
247: for update of TAB_ID nowait;

Line 413: update BSC_KPI_DEFAULTS_TL set

409: if (sql%notfound) then
410: raise no_data_found;
411: end if;
412:
413: update BSC_KPI_DEFAULTS_TL set
414: ANALYSIS_OPTION0_NAME = X_ANALYSIS_OPTION0_NAME,
415: ANALYSIS_OPTION1_NAME = X_ANALYSIS_OPTION1_NAME,
416: ANALYSIS_OPTION2_NAME = X_ANALYSIS_OPTION2_NAME,
417: PERIOD_NAME = X_PERIOD_NAME,

Line 450: delete from BSC_KPI_DEFAULTS_TL

446: X_TAB_ID in NUMBER,
447: X_INDICATOR in NUMBER
448: ) is
449: begin
450: delete from BSC_KPI_DEFAULTS_TL
451: where TAB_ID = X_TAB_ID
452: and INDICATOR = X_INDICATOR;
453:
454: if (sql%notfound) then

Line 470: delete from BSC_KPI_DEFAULTS_TL T

466:
467: procedure ADD_LANGUAGE
468: is
469: begin
470: delete from BSC_KPI_DEFAULTS_TL T
471: where not exists
472: (select NULL
473: from BSC_KPI_DEFAULTS_B B
474: where B.TAB_ID = T.TAB_ID

Line 478: update BSC_KPI_DEFAULTS_TL T set (

474: where B.TAB_ID = T.TAB_ID
475: and B.INDICATOR = T.INDICATOR
476: );
477:
478: update BSC_KPI_DEFAULTS_TL T set (
479: ANALYSIS_OPTION0_NAME,
480: ANALYSIS_OPTION1_NAME,
481: ANALYSIS_OPTION2_NAME,
482: PERIOD_NAME,

Line 522: from BSC_KPI_DEFAULTS_TL B

518: B.DIM_LEVEL5_TEXT,
519: B.DIM_LEVEL6_TEXT,
520: B.DIM_LEVEL7_TEXT,
521: B.DIM_LEVEL8_TEXT
522: from BSC_KPI_DEFAULTS_TL B
523: where B.TAB_ID = T.TAB_ID
524: and B.INDICATOR = T.INDICATOR
525: and B.LANGUAGE = T.SOURCE_LANG)
526: where (

Line 534: from BSC_KPI_DEFAULTS_TL SUBB, BSC_KPI_DEFAULTS_TL SUBT

530: ) in (select
531: SUBT.TAB_ID,
532: SUBT.INDICATOR,
533: SUBT.LANGUAGE
534: from BSC_KPI_DEFAULTS_TL SUBB, BSC_KPI_DEFAULTS_TL SUBT
535: where SUBB.TAB_ID = SUBT.TAB_ID
536: and SUBB.INDICATOR = SUBT.INDICATOR
537: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
538: and (SUBB.ANALYSIS_OPTION0_NAME <> SUBT.ANALYSIS_OPTION0_NAME

Line 603: insert into BSC_KPI_DEFAULTS_TL (

599: or (SUBB.DIM_LEVEL8_TEXT is null and SUBT.DIM_LEVEL8_TEXT is not null)
600: or (SUBB.DIM_LEVEL8_TEXT is not null and SUBT.DIM_LEVEL8_TEXT is null)
601: ));
602:
603: insert into BSC_KPI_DEFAULTS_TL (
604: TAB_ID,
605: INDICATOR,
606: ANALYSIS_OPTION0_NAME,
607: ANALYSIS_OPTION1_NAME,

Line 655: from BSC_KPI_DEFAULTS_TL B, FND_LANGUAGES L

651: B.DIM_LEVEL7_TEXT,
652: B.DIM_LEVEL8_TEXT,
653: L.LANGUAGE_CODE,
654: B.SOURCE_LANG
655: from BSC_KPI_DEFAULTS_TL B, FND_LANGUAGES L
656: where L.INSTALLED_FLAG in ('I', 'B')
657: and B.LANGUAGE = userenv('LANG')
658: and not exists
659: (select NULL

Line 660: from BSC_KPI_DEFAULTS_TL T

656: where L.INSTALLED_FLAG in ('I', 'B')
657: and B.LANGUAGE = userenv('LANG')
658: and not exists
659: (select NULL
660: from BSC_KPI_DEFAULTS_TL T
661: where T.TAB_ID = B.TAB_ID
662: and T.INDICATOR = B.INDICATOR
663: and T.LANGUAGE = L.LANGUAGE_CODE);
664: end ADD_LANGUAGE;