APPS.BSC_TAB_VIEWS_PKG dependencies on BSC_TAB_VIEWS_TL

Line 15: SELECT COUNT(*) INTO L_TAB FROM BSC_TAB_VIEWS_TL WHERE TAB_ID = X_TAB_ID AND TAB_VIEW_ID = X_TAB_VIEW_ID;

11: X_LAST_UPDATE_LOGIN IN NUMBER
12: ) IS
13: L_TAB NUMBER := -1;
14: BEGIN
15: SELECT COUNT(*) INTO L_TAB FROM BSC_TAB_VIEWS_TL WHERE TAB_ID = X_TAB_ID AND TAB_VIEW_ID = X_TAB_VIEW_ID;
16: IF (L_TAB > 0) THEN
17: UPDATE BSC_TAB_VIEWS_TL SET
18: NAME = NVL(X_NAME, NAME),
19: HELP = NVL(X_HELP, HELP),

Line 17: UPDATE BSC_TAB_VIEWS_TL SET

13: L_TAB NUMBER := -1;
14: BEGIN
15: SELECT COUNT(*) INTO L_TAB FROM BSC_TAB_VIEWS_TL WHERE TAB_ID = X_TAB_ID AND TAB_VIEW_ID = X_TAB_VIEW_ID;
16: IF (L_TAB > 0) THEN
17: UPDATE BSC_TAB_VIEWS_TL SET
18: NAME = NVL(X_NAME, NAME),
19: HELP = NVL(X_HELP, HELP),
20: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE, SYSDATE),
21: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 71: insert into BSC_TAB_VIEWS_TL (

67: NVL(X_LAST_UPDATE_DATE, SYSDATE),
68: X_LAST_UPDATED_BY ,
69: X_LAST_UPDATE_LOGIN
70: );
71: insert into BSC_TAB_VIEWS_TL (
72: TAB_ID,
73: TAB_VIEW_ID,
74: NAME,
75: HELP,

Line 99: from BSC_TAB_VIEWS_TL T

95: from FND_LANGUAGES L
96: where L.INSTALLED_FLAG in ('I', 'B')
97: and not exists
98: (select NULL
99: from BSC_TAB_VIEWS_TL T
100: where T.TAB_ID = X_TAB_ID
101: and T.TAB_VIEW_ID = X_TAB_VIEW_ID
102: and T.LANGUAGE = L.LANGUAGE_CODE);
103: open c;

Line 132: from BSC_TAB_VIEWS_TL

128: cursor c1 is select
129: NAME,
130: HELP,
131: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
132: from BSC_TAB_VIEWS_TL
133: where TAB_ID = X_TAB_ID
134: and TAB_VIEW_ID = X_TAB_VIEW_ID
135: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
136: for update of TAB_ID nowait;

Line 191: update BSC_TAB_VIEWS_TL set

187: AND LAST_UPDATE_DATE <= NVL(X_LAST_UPDATE_DATE, SYSDATE);
188: if (sql%notfound) then
189: raise no_data_found;
190: end if;
191: update BSC_TAB_VIEWS_TL set
192: NAME = NVL(X_NAME, NAME),
193: HELP = NVL(X_HELP, HELP),
194: SOURCE_LANG = userenv('LANG')
195: where TAB_ID = X_TAB_ID

Line 208: delete from BSC_TAB_VIEWS_TL

204: X_TAB_ID in NUMBER,
205: X_TAB_VIEW_ID in NUMBER
206: ) is
207: begin
208: delete from BSC_TAB_VIEWS_TL
209: where TAB_ID = X_TAB_ID
210: and TAB_VIEW_ID = X_TAB_VIEW_ID;
211: if (sql%notfound) then
212: raise no_data_found;

Line 232: delete from BSC_TAB_VIEWS_TL T

228: SELECT VS.USER#
229: INTO l_user
230: FROM V$SESSION VS WHERE VS.AUDSID =USERENV('SESSIONID');
231:
232: delete from BSC_TAB_VIEWS_TL T
233: where not exists
234: (select NULL
235: from BSC_TAB_VIEWS_B B
236: where B.TAB_ID = T.TAB_ID

Line 240: update BSC_TAB_VIEWS_TL T set (

236: where B.TAB_ID = T.TAB_ID
237: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
238: );
239:
240: update BSC_TAB_VIEWS_TL T set (
241: NAME,
242: HELP
243: ) = (select
244: B.NAME,

Line 246: from BSC_TAB_VIEWS_TL B

242: HELP
243: ) = (select
244: B.NAME,
245: B.HELP
246: from BSC_TAB_VIEWS_TL B
247: where B.TAB_ID = T.TAB_ID
248: and B.TAB_VIEW_ID = T.TAB_VIEW_ID
249: and B.LANGUAGE = T.SOURCE_LANG)
250: where (

Line 258: from BSC_TAB_VIEWS_TL SUBB, BSC_TAB_VIEWS_TL SUBT

254: ) in (select
255: SUBT.TAB_ID,
256: SUBT.TAB_VIEW_ID,
257: SUBT.LANGUAGE
258: from BSC_TAB_VIEWS_TL SUBB, BSC_TAB_VIEWS_TL SUBT
259: where SUBB.TAB_ID = SUBT.TAB_ID
260: and SUBB.TAB_VIEW_ID = SUBT.TAB_VIEW_ID
261: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
262: and (SUBB.NAME <> SUBT.NAME

Line 266: insert into BSC_TAB_VIEWS_TL (

262: and (SUBB.NAME <> SUBT.NAME
263: or SUBB.HELP <> SUBT.HELP
264: ));
265:
266: insert into BSC_TAB_VIEWS_TL (
267: TAB_ID,
268: TAB_VIEW_ID,
269: NAME,
270: HELP,

Line 290: from BSC_TAB_VIEWS_TL B, FND_LANGUAGES L

286: l_user,
287: l_user,
288: L.LANGUAGE_CODE,
289: B.SOURCE_LANG
290: from BSC_TAB_VIEWS_TL B, FND_LANGUAGES L
291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL

Line 295: from BSC_TAB_VIEWS_TL T

291: where L.INSTALLED_FLAG in ('I', 'B')
292: and B.LANGUAGE = userenv('LANG')
293: and not exists
294: (select NULL
295: from BSC_TAB_VIEWS_TL T
296: where T.TAB_ID = B.TAB_ID
297: and T.TAB_VIEW_ID = B.TAB_VIEW_ID
298: and T.LANGUAGE = L.LANGUAGE_CODE);
299: end ADD_LANGUAGE;