APPS.BSC_TABS_PKG dependencies on BSC_TABS_TL

Line 12: UPDATE BSC_TABS_TL SET

8: X_HELP IN VARCHAR2,
9: X_ADDITIONAL_INFO IN VARCHAR2
10: )IS
11: BEGIN
12: UPDATE BSC_TABS_TL SET
13: NAME = NVL(X_NAME, NAME),
14: HELP = NVL(X_HELP, HELP),
15: ADDITIONAL_INFO = NVL(X_ADDITIONAL_INFO, ADDITIONAL_INFO),
16: SOURCE_LANG = USERENV('LANG')

Line 83: INSERT INTO BSC_TABS_TL

79: X_PARENT_TAB_ID,
80: X_OWNER_ID,
81: X_SHORT_NAME
82: );
83: INSERT INTO BSC_TABS_TL
84: (
85: TAB_ID,
86: NAME,
87: HELP,

Line 103: FROM BSC_TABS_TL T

99: WHERE L.INSTALLED_FLAG IN ('I', 'B')
100: AND NOT EXISTS
101: (
102: SELECT NULL
103: FROM BSC_TABS_TL T
104: WHERE T.TAB_ID = X_TAB_ID
105: AND T.LANGUAGE = L.LANGUAGE_CODE
106: );
107: OPEN C;

Line 143: from BSC_TABS_TL

139: cursor c1 is select
140: NAME,
141: HELP,
142: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
143: from BSC_TABS_TL
144: where TAB_ID = X_TAB_ID
145: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
146: for update of TAB_ID nowait;
147: begin

Line 229: UPDATE BSC_TABS_TL

225: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
226: WHERE SHORT_NAME = X_SHORT_NAME
227: AND LAST_UPDATE_DATE < X_LAST_UPDATE_DATE;
228: IF (NOT SQL%NOTFOUND) THEN
229: UPDATE BSC_TABS_TL
230: SET NAME = NVL(X_NAME, NAME),
231: HELP = X_HELP,
232: ADDITIONAL_INFO = X_ADDITIONAL_INFO,
233: SOURCE_LANG = USERENV('LANG')

Line 255: UPDATE BSC_TABS_TL

251: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
252: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
253: WHERE TAB_ID = X_TAB_ID;
254: IF (NOT SQL%NOTFOUND) THEN
255: UPDATE BSC_TABS_TL
256: SET NAME = NVL(X_NAME, NAME),
257: HELP = HELP,
258: ADDITIONAL_INFO = X_ADDITIONAL_INFO,
259: SOURCE_LANG = USERENV('LANG')

Line 272: delete from BSC_TABS_TL

268: procedure DELETE_ROW (
269: X_TAB_ID in NUMBER
270: ) is
271: begin
272: delete from BSC_TABS_TL
273: where TAB_ID = X_TAB_ID;
274:
275: if (sql%notfound) then
276: raise no_data_found;

Line 290: delete from BSC_TABS_TL T

286:
287: procedure ADD_LANGUAGE
288: is
289: begin
290: delete from BSC_TABS_TL T
291: where not exists
292: (select NULL
293: from BSC_TABS_B B
294: where B.TAB_ID = T.TAB_ID

Line 297: update BSC_TABS_TL T set (

293: from BSC_TABS_B B
294: where B.TAB_ID = T.TAB_ID
295: );
296:
297: update BSC_TABS_TL T set (
298: NAME,
299: HELP,
300: ADDITIONAL_INFO
301: ) = (select

Line 305: from BSC_TABS_TL B

301: ) = (select
302: B.NAME,
303: B.HELP,
304: ADDITIONAL_INFO
305: from BSC_TABS_TL B
306: where B.TAB_ID = T.TAB_ID
307: and B.LANGUAGE = T.SOURCE_LANG)
308: where (
309: T.TAB_ID,

Line 314: from BSC_TABS_TL SUBB, BSC_TABS_TL SUBT

310: T.LANGUAGE
311: ) in (select
312: SUBT.TAB_ID,
313: SUBT.LANGUAGE
314: from BSC_TABS_TL SUBB, BSC_TABS_TL SUBT
315: where SUBB.TAB_ID = SUBT.TAB_ID
316: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
317: and (SUBB.NAME <> SUBT.NAME
318: or SUBB.HELP <> SUBT.HELP

Line 325: insert into BSC_TABS_TL (

321: or (SUBB.HELP is not null and SUBT.HELP is null)
322: or (SUBB.ADDITIONAL_INFO is not null and SUBT.ADDITIONAL_INFO is null)
323: ));
324:
325: insert into BSC_TABS_TL (
326: TAB_ID,
327: NAME,
328: HELP,
329: ADDITIONAL_INFO,

Line 339: from BSC_TABS_TL B, FND_LANGUAGES L

335: B.HELP,
336: ADDITIONAL_INFO,
337: L.LANGUAGE_CODE,
338: B.SOURCE_LANG
339: from BSC_TABS_TL B, FND_LANGUAGES L
340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL

Line 344: from BSC_TABS_TL T

340: where L.INSTALLED_FLAG in ('I', 'B')
341: and B.LANGUAGE = userenv('LANG')
342: and not exists
343: (select NULL
344: from BSC_TABS_TL T
345: where T.TAB_ID = B.TAB_ID
346: and T.LANGUAGE = L.LANGUAGE_CODE);
347: end ADD_LANGUAGE;
348: