APPS.BSC_KPI_SUBTITLES_PKG dependencies on BSC_KPI_SUBTITLES_TL

Line 12: cursor C is select ROWID from BSC_KPI_SUBTITLES_TL

8: X_ANALYSIS_OPTION1 in NUMBER,
9: X_ANALYSIS_OPTION2 in NUMBER,
10: X_SUBTITLE in VARCHAR2
11: ) is
12: cursor C is select ROWID from BSC_KPI_SUBTITLES_TL
13: where INDICATOR = X_INDICATOR
14: and CALC_COMB = X_CALC_COMB
15: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
16: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1

Line 21: insert into BSC_KPI_SUBTITLES_TL (

17: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2
18: and LANGUAGE = userenv('LANG')
19: ;
20: begin
21: insert into BSC_KPI_SUBTITLES_TL (
22: INDICATOR,
23: CALC_COMB,
24: ANALYSIS_OPTION0,
25: ANALYSIS_OPTION1,

Line 43: from BSC_KPI_SUBTITLES_TL T

39: from FND_LANGUAGES L
40: where L.INSTALLED_FLAG in ('I', 'B')
41: and not exists
42: (select NULL
43: from BSC_KPI_SUBTITLES_TL T
44: where T.INDICATOR = X_INDICATOR
45: and T.CALC_COMB = X_CALC_COMB
46: and T.ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
47: and T.ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1

Line 72: from BSC_KPI_SUBTITLES_TL

68: ) is
69: cursor c1 is select
70: SUBTITLE,
71: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
72: from BSC_KPI_SUBTITLES_TL
73: where INDICATOR = X_INDICATOR
74: and CALC_COMB = X_CALC_COMB
75: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
76: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1

Line 104: update BSC_KPI_SUBTITLES_TL set

100: X_ANALYSIS_OPTION2 in NUMBER,
101: X_SUBTITLE in VARCHAR2
102: ) is
103: begin
104: update BSC_KPI_SUBTITLES_TL set
105: SUBTITLE = X_SUBTITLE,
106: SOURCE_LANG = userenv('LANG')
107: where INDICATOR = X_INDICATOR
108: and CALC_COMB = X_CALC_COMB

Line 127: delete from BSC_KPI_SUBTITLES_TL

123: X_ANALYSIS_OPTION1 in NUMBER,
124: X_ANALYSIS_OPTION2 in NUMBER
125: ) is
126: begin
127: delete from BSC_KPI_SUBTITLES_TL
128: where INDICATOR = X_INDICATOR
129: and CALC_COMB = X_CALC_COMB
130: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
131: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1

Line 143: update BSC_KPI_SUBTITLES_TL T set (

139:
140: procedure ADD_LANGUAGE
141: is
142: begin
143: update BSC_KPI_SUBTITLES_TL T set (
144: SUBTITLE
145: ) = (select
146: B.SUBTITLE
147: from BSC_KPI_SUBTITLES_TL B

Line 147: from BSC_KPI_SUBTITLES_TL B

143: update BSC_KPI_SUBTITLES_TL T set (
144: SUBTITLE
145: ) = (select
146: B.SUBTITLE
147: from BSC_KPI_SUBTITLES_TL B
148: where B.INDICATOR = T.INDICATOR
149: and B.CALC_COMB = T.CALC_COMB
150: and B.ANALYSIS_OPTION0 = T.ANALYSIS_OPTION0
151: and B.ANALYSIS_OPTION1 = T.ANALYSIS_OPTION1

Line 168: from BSC_KPI_SUBTITLES_TL SUBB, BSC_KPI_SUBTITLES_TL SUBT

164: SUBT.ANALYSIS_OPTION0,
165: SUBT.ANALYSIS_OPTION1,
166: SUBT.ANALYSIS_OPTION2,
167: SUBT.LANGUAGE
168: from BSC_KPI_SUBTITLES_TL SUBB, BSC_KPI_SUBTITLES_TL SUBT
169: where SUBB.INDICATOR = SUBT.INDICATOR
170: and SUBB.CALC_COMB = SUBT.CALC_COMB
171: and SUBB.ANALYSIS_OPTION0 = SUBT.ANALYSIS_OPTION0
172: and SUBB.ANALYSIS_OPTION1 = SUBT.ANALYSIS_OPTION1

Line 178: insert into BSC_KPI_SUBTITLES_TL (

174: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
175: and (SUBB.SUBTITLE <> SUBT.SUBTITLE
176: ));
177:
178: insert into BSC_KPI_SUBTITLES_TL (
179: INDICATOR,
180: CALC_COMB,
181: ANALYSIS_OPTION0,
182: ANALYSIS_OPTION1,

Line 196: from BSC_KPI_SUBTITLES_TL B, FND_LANGUAGES L

192: B.ANALYSIS_OPTION2,
193: B.SUBTITLE,
194: L.LANGUAGE_CODE,
195: B.SOURCE_LANG
196: from BSC_KPI_SUBTITLES_TL B, FND_LANGUAGES L
197: where L.INSTALLED_FLAG in ('I', 'B')
198: and B.LANGUAGE = userenv('LANG')
199: and not exists
200: (select NULL

Line 201: from BSC_KPI_SUBTITLES_TL T

197: where L.INSTALLED_FLAG in ('I', 'B')
198: and B.LANGUAGE = userenv('LANG')
199: and not exists
200: (select NULL
201: from BSC_KPI_SUBTITLES_TL T
202: where T.INDICATOR = B.INDICATOR
203: and T.CALC_COMB = B.CALC_COMB
204: and T.ANALYSIS_OPTION0 = B.ANALYSIS_OPTION0
205: and T.ANALYSIS_OPTION1 = B.ANALYSIS_OPTION1