APPS.BSC_KPI_ANALYSIS_MEASURES_PKG dependencies on BSC_KPI_ANALYSIS_MEASURES_TL

Line 62: insert into BSC_KPI_ANALYSIS_MEASURES_TL (

58: X_ANALYSIS_OPTION0,
59: X_ANALYSIS_OPTION1
60: );
61:
62: insert into BSC_KPI_ANALYSIS_MEASURES_TL (
63: INDICATOR,
64: ANALYSIS_OPTION0,
65: ANALYSIS_OPTION1,
66: ANALYSIS_OPTION2,

Line 86: from BSC_KPI_ANALYSIS_MEASURES_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from BSC_KPI_ANALYSIS_MEASURES_TL T
87: where T.INDICATOR = X_INDICATOR
88: and T.ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
89: and T.ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
90: and T.ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 145: from BSC_KPI_ANALYSIS_MEASURES_TL

141: cursor c1 is select
142: NAME,
143: HELP,
144: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
145: from BSC_KPI_ANALYSIS_MEASURES_TL
146: where INDICATOR = X_INDICATOR
147: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
148: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
149: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 248: update BSC_KPI_ANALYSIS_MEASURES_TL set

244: if (sql%notfound) then
245: raise no_data_found;
246: end if;
247:
248: update BSC_KPI_ANALYSIS_MEASURES_TL set
249: NAME = X_NAME,
250: HELP = X_HELP,
251: SOURCE_LANG = userenv('LANG')
252: where INDICATOR = X_INDICATOR

Line 272: delete from BSC_KPI_ANALYSIS_MEASURES_TL

268: X_ANALYSIS_OPTION2 in NUMBER,
269: X_SERIES_ID in NUMBER
270: ) is
271: begin
272: delete from BSC_KPI_ANALYSIS_MEASURES_TL
273: where INDICATOR = X_INDICATOR
274: and ANALYSIS_OPTION0 = X_ANALYSIS_OPTION0
275: and ANALYSIS_OPTION1 = X_ANALYSIS_OPTION1
276: and ANALYSIS_OPTION2 = X_ANALYSIS_OPTION2

Line 298: delete from BSC_KPI_ANALYSIS_MEASURES_TL T

294:
295: procedure ADD_LANGUAGE
296: is
297: begin
298: delete from BSC_KPI_ANALYSIS_MEASURES_TL T
299: where not exists
300: (select NULL
301: from BSC_KPI_ANALYSIS_MEASURES_B B
302: where B.INDICATOR = T.INDICATOR

Line 309: update BSC_KPI_ANALYSIS_MEASURES_TL T set (

305: and B.ANALYSIS_OPTION2 = T.ANALYSIS_OPTION2
306: and B.SERIES_ID = T.SERIES_ID
307: );
308:
309: update BSC_KPI_ANALYSIS_MEASURES_TL T set (
310: NAME,
311: HELP
312: ) = (select
313: B.NAME,

Line 315: from BSC_KPI_ANALYSIS_MEASURES_TL B

311: HELP
312: ) = (select
313: B.NAME,
314: B.HELP
315: from BSC_KPI_ANALYSIS_MEASURES_TL B
316: where B.INDICATOR = T.INDICATOR
317: and B.ANALYSIS_OPTION0 = T.ANALYSIS_OPTION0
318: and B.ANALYSIS_OPTION1 = T.ANALYSIS_OPTION1
319: and B.ANALYSIS_OPTION2 = T.ANALYSIS_OPTION2

Line 336: from BSC_KPI_ANALYSIS_MEASURES_TL SUBB, BSC_KPI_ANALYSIS_MEASURES_TL SUBT

332: SUBT.ANALYSIS_OPTION1,
333: SUBT.ANALYSIS_OPTION2,
334: SUBT.SERIES_ID,
335: SUBT.LANGUAGE
336: from BSC_KPI_ANALYSIS_MEASURES_TL SUBB, BSC_KPI_ANALYSIS_MEASURES_TL SUBT
337: where SUBB.INDICATOR = SUBT.INDICATOR
338: and SUBB.ANALYSIS_OPTION0 = SUBT.ANALYSIS_OPTION0
339: and SUBB.ANALYSIS_OPTION1 = SUBT.ANALYSIS_OPTION1
340: and SUBB.ANALYSIS_OPTION2 = SUBT.ANALYSIS_OPTION2

Line 347: insert into BSC_KPI_ANALYSIS_MEASURES_TL (

343: and (SUBB.NAME <> SUBT.NAME
344: or SUBB.HELP <> SUBT.HELP
345: ));
346:
347: insert into BSC_KPI_ANALYSIS_MEASURES_TL (
348: INDICATOR,
349: ANALYSIS_OPTION0,
350: ANALYSIS_OPTION1,
351: ANALYSIS_OPTION2,

Line 367: from BSC_KPI_ANALYSIS_MEASURES_TL B, FND_LANGUAGES L

363: B.NAME,
364: B.HELP,
365: L.LANGUAGE_CODE,
366: B.SOURCE_LANG
367: from BSC_KPI_ANALYSIS_MEASURES_TL B, FND_LANGUAGES L
368: where L.INSTALLED_FLAG in ('I', 'B')
369: and B.LANGUAGE = userenv('LANG')
370: and not exists
371: (select NULL

Line 372: from BSC_KPI_ANALYSIS_MEASURES_TL T

368: where L.INSTALLED_FLAG in ('I', 'B')
369: and B.LANGUAGE = userenv('LANG')
370: and not exists
371: (select NULL
372: from BSC_KPI_ANALYSIS_MEASURES_TL T
373: where T.INDICATOR = B.INDICATOR
374: and T.ANALYSIS_OPTION0 = B.ANALYSIS_OPTION0
375: and T.ANALYSIS_OPTION1 = B.ANALYSIS_OPTION1
376: and T.ANALYSIS_OPTION2 = B.ANALYSIS_OPTION2