APPS.BSC_TAB_VIEW_KPI_PKG dependencies on BSC_TAB_VIEW_KPI_TL

Line 27: cursor C is select ROWID from BSC_TAB_VIEW_KPI_TL

23: X_LAST_UPDATE_DATE in DATE,
24: X_LAST_UPDATED_BY in NUMBER,
25: X_LAST_UPDATE_LOGIN in NUMBER
26: ) is
27: cursor C is select ROWID from BSC_TAB_VIEW_KPI_TL
28: where TAB_ID = X_TAB_ID
29: and TAB_VIEW_ID = X_TAB_VIEW_ID
30: and INDICATOR = X_INDICATOR
31: and LANGUAGE = userenv('LANG')

Line 34: insert into BSC_TAB_VIEW_KPI_TL (

30: and INDICATOR = X_INDICATOR
31: and LANGUAGE = userenv('LANG')
32: ;
33: begin
34: insert into BSC_TAB_VIEW_KPI_TL (
35: TAB_ID,
36: TAB_VIEW_ID,
37: INDICATOR,
38: TEXT_FLAG,

Line 86: from BSC_TAB_VIEW_KPI_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_TAB_VIEW_KPI_TL T
87: where T.TAB_ID = X_TAB_ID
88: and T.TAB_VIEW_ID = X_TAB_VIEW_ID
89: and T.INDICATOR = X_INDICATOR
90: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 135: from BSC_TAB_VIEW_KPI_TL

131: COLOR_WIDTH,
132: COLOR_HEIGHT,
133: COLOR_SIZE,
134: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
135: from BSC_TAB_VIEW_KPI_TL
136: where TAB_ID = X_TAB_ID
137: and TAB_VIEW_ID = X_TAB_VIEW_ID
138: and INDICATOR = X_INDICATOR
139: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 192: update BSC_TAB_VIEW_KPI_TL set

188: X_LAST_UPDATED_BY in NUMBER,
189: X_LAST_UPDATE_LOGIN in NUMBER
190: ) is
191: begin
192: update BSC_TAB_VIEW_KPI_TL set
193: TEXT_FLAG = X_TEXT_FLAG,
194: LEFT_POSITION = X_LEFT_POSITION,
195: TOP_POSITION = X_TOP_POSITION,
196: WIDTH = X_WIDTH,

Line 226: delete from BSC_TAB_VIEW_KPI_TL

222: X_TAB_VIEW_ID in NUMBER,
223: X_INDICATOR in NUMBER
224: ) is
225: begin
226: delete from BSC_TAB_VIEW_KPI_TL
227: where TAB_ID = X_TAB_ID
228: and TAB_VIEW_ID = X_TAB_VIEW_ID
229: and INDICATOR = X_INDICATOR;
230:

Line 247: update BSC_TAB_VIEW_KPI_TL T set (

243: -- row and it will fail. AUDSID is not PK. After meeting with
244: -- Vinod and Kris and Venu, we should use FNG_GLOBAL.user_id
245: l_user := BSC_APPS.fnd_global_user_id;
246:
247: update BSC_TAB_VIEW_KPI_TL T set (
248: TEXT_FLAG,
249: LEFT_POSITION,
250: TOP_POSITION,
251: WIDTH,

Line 275: from BSC_TAB_VIEW_KPI_TL B

271: B.COLOR_TOP_POSITION,
272: B.COLOR_WIDTH,
273: B.COLOR_HEIGHT,
274: B.COLOR_SIZE
275: from BSC_TAB_VIEW_KPI_TL B
276: where B.TAB_ID = T.TAB_ID
277: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
278: and B.INDICATOR = T.INDICATOR
279: and B.LANGUAGE = T.SOURCE_LANG)

Line 290: from BSC_TAB_VIEW_KPI_TL SUBB, BSC_TAB_VIEW_KPI_TL SUBT

286: SUBT.TAB_ID,
287: SUBT.TAB_VIEW_ID,
288: SUBT.INDICATOR,
289: SUBT.LANGUAGE
290: from BSC_TAB_VIEW_KPI_TL SUBB, BSC_TAB_VIEW_KPI_TL SUBT
291: where SUBB.TAB_ID = SUBT.TAB_ID
292: and SUBB.TAB_VIEW_ID = SUBT.TAB_VIEW_ID
293: and SUBB.INDICATOR = SUBT.INDICATOR
294: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 311: insert into BSC_TAB_VIEW_KPI_TL (

307: or SUBB.COLOR_HEIGHT <> SUBT.COLOR_HEIGHT
308: or SUBB.COLOR_SIZE <> SUBT.COLOR_SIZE
309: ));
310:
311: insert into BSC_TAB_VIEW_KPI_TL (
312: TAB_ID,
313: TAB_VIEW_ID,
314: INDICATOR,
315: TEXT_FLAG,

Line 359: from BSC_TAB_VIEW_KPI_TL B, FND_LANGUAGES L

355: l_user,
356: l_user,
357: L.LANGUAGE_CODE,
358: B.SOURCE_LANG
359: from BSC_TAB_VIEW_KPI_TL B, FND_LANGUAGES L
360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL

Line 364: from BSC_TAB_VIEW_KPI_TL T

360: where L.INSTALLED_FLAG in ('I', 'B')
361: and B.LANGUAGE = userenv('LANG')
362: and not exists
363: (select NULL
364: from BSC_TAB_VIEW_KPI_TL T
365: where T.TAB_ID = B.TAB_ID
366: and T.TAB_VIEW_ID = B.TAB_VIEW_ID
367: and T.INDICATOR = B.INDICATOR
368: and T.LANGUAGE = L.LANGUAGE_CODE);