APPS.BSC_KPIS_PKG dependencies on BSC_KPIS_TL

Line 55: insert into BSC_KPIS_TL (

51: X_IND_GROUP_ID,
52: X_INDICATOR
53: );
54:
55: insert into BSC_KPIS_TL (
56: NAME,
57: HELP,
58: INDICATOR,
59: LANGUAGE,

Line 71: from BSC_KPIS_TL T

67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and not exists
70: (select NULL
71: from BSC_KPIS_TL T
72: where T.INDICATOR = X_INDICATOR
73: and T.LANGUAGE = L.LANGUAGE_CODE);
74:
75: open c;

Line 124: from BSC_KPIS_TL

120: cursor c1 is select
121: NAME,
122: HELP,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from BSC_KPIS_TL
125: where INDICATOR = X_INDICATOR
126: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
127: for update of INDICATOR nowait;
128: begin

Line 210: update BSC_KPIS_TL set

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

Line 226: delete from BSC_KPIS_TL

222: procedure DELETE_ROW (
223: X_INDICATOR in NUMBER
224: ) is
225: begin
226: delete from BSC_KPIS_TL
227: where INDICATOR = X_INDICATOR;
228:
229: if (sql%notfound) then
230: raise no_data_found;

Line 244: delete from BSC_KPIS_TL T

240:
241: procedure ADD_LANGUAGE
242: is
243: begin
244: delete from BSC_KPIS_TL T
245: where not exists
246: (select NULL
247: from BSC_KPIS_B B
248: where B.INDICATOR = T.INDICATOR

Line 251: update BSC_KPIS_TL T set (

247: from BSC_KPIS_B B
248: where B.INDICATOR = T.INDICATOR
249: );
250:
251: update BSC_KPIS_TL T set (
252: NAME,
253: HELP
254: ) = (select
255: B.NAME,

Line 257: from BSC_KPIS_TL B

253: HELP
254: ) = (select
255: B.NAME,
256: B.HELP
257: from BSC_KPIS_TL B
258: where B.INDICATOR = T.INDICATOR
259: and B.LANGUAGE = T.SOURCE_LANG)
260: where (
261: T.INDICATOR,

Line 266: from BSC_KPIS_TL SUBB, BSC_KPIS_TL SUBT

262: T.LANGUAGE
263: ) in (select
264: SUBT.INDICATOR,
265: SUBT.LANGUAGE
266: from BSC_KPIS_TL SUBB, BSC_KPIS_TL SUBT
267: where SUBB.INDICATOR = SUBT.INDICATOR
268: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
269: and (SUBB.NAME <> SUBT.NAME
270: or SUBB.HELP <> SUBT.HELP

Line 273: insert into BSC_KPIS_TL (

269: and (SUBB.NAME <> SUBT.NAME
270: or SUBB.HELP <> SUBT.HELP
271: ));
272:
273: insert into BSC_KPIS_TL (
274: NAME,
275: HELP,
276: INDICATOR,
277: LANGUAGE,

Line 285: from BSC_KPIS_TL B, FND_LANGUAGES L

281: B.HELP,
282: B.INDICATOR,
283: L.LANGUAGE_CODE,
284: B.SOURCE_LANG
285: from BSC_KPIS_TL B, FND_LANGUAGES L
286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL

Line 290: from BSC_KPIS_TL T

286: where L.INSTALLED_FLAG in ('I', 'B')
287: and B.LANGUAGE = userenv('LANG')
288: and not exists
289: (select NULL
290: from BSC_KPIS_TL T
291: where T.INDICATOR = B.INDICATOR
292: and T.LANGUAGE = L.LANGUAGE_CODE);
293: end ADD_LANGUAGE;
294: