APPS.BSC_KPI_ANALYSIS_OPTIONS_PKG dependencies on BSC_KPI_ANALYSIS_OPTIONS_TL

Line 53: insert into BSC_KPI_ANALYSIS_OPTIONS_TL (

49: X_USER_LEVEL2,
50: X_USER_LEVEL2_DEFAULT
51: );
52:
53: insert into BSC_KPI_ANALYSIS_OPTIONS_TL (
54: INDICATOR,
55: ANALYSIS_GROUP_ID,
56: OPTION_ID,
57: PARENT_OPTION_ID,

Line 77: from BSC_KPI_ANALYSIS_OPTIONS_TL T

73: from FND_LANGUAGES L
74: where L.INSTALLED_FLAG in ('I', 'B')
75: and not exists
76: (select NULL
77: from BSC_KPI_ANALYSIS_OPTIONS_TL T
78: where T.INDICATOR = X_INDICATOR
79: and T.ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
80: and T.OPTION_ID = X_OPTION_ID
81: and T.PARENT_OPTION_ID = X_PARENT_OPTION_ID

Line 130: from BSC_KPI_ANALYSIS_OPTIONS_TL

126: cursor c1 is select
127: NAME,
128: HELP,
129: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
130: from BSC_KPI_ANALYSIS_OPTIONS_TL
131: where INDICATOR = X_INDICATOR
132: and ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
133: and OPTION_ID = X_OPTION_ID
134: and PARENT_OPTION_ID = X_PARENT_OPTION_ID

Line 213: update BSC_KPI_ANALYSIS_OPTIONS_TL set

209: if (sql%notfound) then
210: raise no_data_found;
211: end if;
212:
213: update BSC_KPI_ANALYSIS_OPTIONS_TL set
214: NAME = X_NAME,
215: HELP = X_HELP,
216: SOURCE_LANG = userenv('LANG')
217: where INDICATOR = X_INDICATOR

Line 237: delete from BSC_KPI_ANALYSIS_OPTIONS_TL

233: X_PARENT_OPTION_ID in NUMBER,
234: X_GRANDPARENT_OPTION_ID in NUMBER
235: ) is
236: begin
237: delete from BSC_KPI_ANALYSIS_OPTIONS_TL
238: where INDICATOR = X_INDICATOR
239: and ANALYSIS_GROUP_ID = X_ANALYSIS_GROUP_ID
240: and OPTION_ID = X_OPTION_ID
241: and PARENT_OPTION_ID = X_PARENT_OPTION_ID

Line 263: delete from BSC_KPI_ANALYSIS_OPTIONS_TL T

259:
260: procedure ADD_LANGUAGE
261: is
262: begin
263: delete from BSC_KPI_ANALYSIS_OPTIONS_TL T
264: where not exists
265: (select NULL
266: from BSC_KPI_ANALYSIS_OPTIONS_B B
267: where B.INDICATOR = T.INDICATOR

Line 274: update BSC_KPI_ANALYSIS_OPTIONS_TL T set (

270: and B.PARENT_OPTION_ID = T.PARENT_OPTION_ID
271: and B.GRANDPARENT_OPTION_ID = T.GRANDPARENT_OPTION_ID
272: );
273:
274: update BSC_KPI_ANALYSIS_OPTIONS_TL T set (
275: NAME,
276: HELP
277: ) = (select
278: B.NAME,

Line 280: from BSC_KPI_ANALYSIS_OPTIONS_TL B

276: HELP
277: ) = (select
278: B.NAME,
279: B.HELP
280: from BSC_KPI_ANALYSIS_OPTIONS_TL B
281: where B.INDICATOR = T.INDICATOR
282: and B.ANALYSIS_GROUP_ID = T.ANALYSIS_GROUP_ID
283: and B.OPTION_ID = T.OPTION_ID
284: and B.PARENT_OPTION_ID = T.PARENT_OPTION_ID

Line 301: from BSC_KPI_ANALYSIS_OPTIONS_TL SUBB, BSC_KPI_ANALYSIS_OPTIONS_TL SUBT

297: SUBT.OPTION_ID,
298: SUBT.PARENT_OPTION_ID,
299: SUBT.GRANDPARENT_OPTION_ID,
300: SUBT.LANGUAGE
301: from BSC_KPI_ANALYSIS_OPTIONS_TL SUBB, BSC_KPI_ANALYSIS_OPTIONS_TL SUBT
302: where SUBB.INDICATOR = SUBT.INDICATOR
303: and SUBB.ANALYSIS_GROUP_ID = SUBT.ANALYSIS_GROUP_ID
304: and SUBB.OPTION_ID = SUBT.OPTION_ID
305: and SUBB.PARENT_OPTION_ID = SUBT.PARENT_OPTION_ID

Line 312: insert into BSC_KPI_ANALYSIS_OPTIONS_TL (

308: and (SUBB.NAME <> SUBT.NAME
309: or SUBB.HELP <> SUBT.HELP
310: ));
311:
312: insert into BSC_KPI_ANALYSIS_OPTIONS_TL (
313: INDICATOR,
314: ANALYSIS_GROUP_ID,
315: OPTION_ID,
316: PARENT_OPTION_ID,

Line 332: from BSC_KPI_ANALYSIS_OPTIONS_TL B, FND_LANGUAGES L

328: B.NAME,
329: B.HELP,
330: L.LANGUAGE_CODE,
331: B.SOURCE_LANG
332: from BSC_KPI_ANALYSIS_OPTIONS_TL B, FND_LANGUAGES L
333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL

Line 337: from BSC_KPI_ANALYSIS_OPTIONS_TL T

333: where L.INSTALLED_FLAG in ('I', 'B')
334: and B.LANGUAGE = userenv('LANG')
335: and not exists
336: (select NULL
337: from BSC_KPI_ANALYSIS_OPTIONS_TL T
338: where T.INDICATOR = B.INDICATOR
339: and T.ANALYSIS_GROUP_ID = B.ANALYSIS_GROUP_ID
340: and T.OPTION_ID = B.OPTION_ID
341: and T.PARENT_OPTION_ID = B.PARENT_OPTION_ID