APPS.BSC_SYS_DIM_LEVELS_PKG dependencies on BSC_SYS_DIM_LEVELS_TL

Line 48: insert into BSC_SYS_DIM_LEVELS_TL (

44: X_USER_KEY_SIZE,
45: X_DISP_KEY_SIZE
46: );
47:
48: insert into BSC_SYS_DIM_LEVELS_TL (
49: DIM_LEVEL_ID,
50: NAME,
51: HELP,
52: TOTAL_DISP_NAME,

Line 68: from BSC_SYS_DIM_LEVELS_TL T

64: from FND_LANGUAGES L
65: where L.INSTALLED_FLAG in ('I', 'B')
66: and not exists
67: (select NULL
68: from BSC_SYS_DIM_LEVELS_TL T
69: where T.DIM_LEVEL_ID = X_DIM_LEVEL_ID
70: and T.LANGUAGE = L.LANGUAGE_CODE);
71:
72: open c;

Line 119: from BSC_SYS_DIM_LEVELS_TL

115: HELP,
116: TOTAL_DISP_NAME,
117: COMP_DISP_NAME,
118: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
119: from BSC_SYS_DIM_LEVELS_TL
120: where DIM_LEVEL_ID = X_DIM_LEVEL_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of DIM_LEVEL_ID nowait;
123: begin

Line 200: update BSC_SYS_DIM_LEVELS_TL set

196: if (sql%notfound) then
197: raise no_data_found;
198: end if;
199:
200: update BSC_SYS_DIM_LEVELS_TL set
201: NAME = X_NAME,
202: HELP = X_HELP,
203: TOTAL_DISP_NAME = X_TOTAL_DISP_NAME,
204: COMP_DISP_NAME = X_COMP_DISP_NAME,

Line 218: delete from BSC_SYS_DIM_LEVELS_TL

214: procedure DELETE_ROW (
215: X_DIM_LEVEL_ID in NUMBER
216: ) is
217: begin
218: delete from BSC_SYS_DIM_LEVELS_TL
219: where DIM_LEVEL_ID = X_DIM_LEVEL_ID;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 236: delete from BSC_SYS_DIM_LEVELS_TL T

232:
233: procedure ADD_LANGUAGE
234: is
235: begin
236: delete from BSC_SYS_DIM_LEVELS_TL T
237: where not exists
238: (select NULL
239: from BSC_SYS_DIM_LEVELS_B B
240: where B.DIM_LEVEL_ID = T.DIM_LEVEL_ID

Line 243: update BSC_SYS_DIM_LEVELS_TL T set (

239: from BSC_SYS_DIM_LEVELS_B B
240: where B.DIM_LEVEL_ID = T.DIM_LEVEL_ID
241: );
242:
243: update BSC_SYS_DIM_LEVELS_TL T set (
244: NAME,
245: HELP,
246: TOTAL_DISP_NAME,
247: COMP_DISP_NAME

Line 253: from BSC_SYS_DIM_LEVELS_TL B

249: B.NAME,
250: B.HELP,
251: B.TOTAL_DISP_NAME,
252: B.COMP_DISP_NAME
253: from BSC_SYS_DIM_LEVELS_TL B
254: where B.DIM_LEVEL_ID = T.DIM_LEVEL_ID
255: and B.LANGUAGE = T.SOURCE_LANG)
256: where (
257: T.DIM_LEVEL_ID,

Line 262: from BSC_SYS_DIM_LEVELS_TL SUBB, BSC_SYS_DIM_LEVELS_TL SUBT

258: T.LANGUAGE
259: ) in (select
260: SUBT.DIM_LEVEL_ID,
261: SUBT.LANGUAGE
262: from BSC_SYS_DIM_LEVELS_TL SUBB, BSC_SYS_DIM_LEVELS_TL SUBT
263: where SUBB.DIM_LEVEL_ID = SUBT.DIM_LEVEL_ID
264: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
265: and (SUBB.NAME <> SUBT.NAME
266: or SUBB.HELP <> SUBT.HELP

Line 275: insert into BSC_SYS_DIM_LEVELS_TL (

271: or (SUBB.COMP_DISP_NAME is null and SUBT.COMP_DISP_NAME is not null)
272: or (SUBB.COMP_DISP_NAME is not null and SUBT.COMP_DISP_NAME is null)
273: ));
274:
275: insert into BSC_SYS_DIM_LEVELS_TL (
276: DIM_LEVEL_ID,
277: NAME,
278: HELP,
279: TOTAL_DISP_NAME,

Line 291: from BSC_SYS_DIM_LEVELS_TL B, FND_LANGUAGES L

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

Line 296: from BSC_SYS_DIM_LEVELS_TL T

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