APPS.BSC_TAB_IND_GROUPS_PKG dependencies on BSC_TAB_IND_GROUPS_TL

Line 48: insert into BSC_TAB_IND_GROUPS_TL (

44: X_WIDTH,
45: X_HEIGHT
46: );
47:
48: insert into BSC_TAB_IND_GROUPS_TL (
49: TAB_ID,
50: CSF_ID,
51: IND_GROUP_ID,
52: NAME,

Line 68: from BSC_TAB_IND_GROUPS_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_TAB_IND_GROUPS_TL T
69: where T.TAB_ID = X_TAB_ID
70: and T.CSF_ID = X_CSF_ID
71: and T.IND_GROUP_ID = X_IND_GROUP_ID
72: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 117: from BSC_TAB_IND_GROUPS_TL

113: cursor c1 is select
114: NAME,
115: HELP,
116: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
117: from BSC_TAB_IND_GROUPS_TL
118: where TAB_ID = X_TAB_ID
119: and CSF_ID = X_CSF_ID
120: and IND_GROUP_ID = X_IND_GROUP_ID
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 201: update BSC_TAB_IND_GROUPS_TL set

197: if (sql%notfound) then
198: raise no_data_found;
199: end if;
200:
201: update BSC_TAB_IND_GROUPS_TL set
202: NAME = X_NAME,
203: HELP = X_HELP,
204: SOURCE_LANG = userenv('LANG')
205: where TAB_ID = X_TAB_ID

Line 221: delete from BSC_TAB_IND_GROUPS_TL

217: X_CSF_ID in NUMBER,
218: X_IND_GROUP_ID in NUMBER
219: ) is
220: begin
221: delete from BSC_TAB_IND_GROUPS_TL
222: where TAB_ID = X_TAB_ID
223: and CSF_ID = X_CSF_ID
224: and IND_GROUP_ID = X_IND_GROUP_ID;
225:

Line 243: delete from BSC_TAB_IND_GROUPS_TL T

239:
240: procedure ADD_LANGUAGE
241: is
242: begin
243: delete from BSC_TAB_IND_GROUPS_TL T
244: where not exists
245: (select NULL
246: from BSC_TAB_IND_GROUPS_B B
247: where B.TAB_ID = T.TAB_ID

Line 252: update BSC_TAB_IND_GROUPS_TL T set (

248: and B.CSF_ID = T.CSF_ID
249: and B.IND_GROUP_ID = T.IND_GROUP_ID
250: );
251:
252: update BSC_TAB_IND_GROUPS_TL T set (
253: NAME,
254: HELP
255: ) = (select
256: B.NAME,

Line 258: from BSC_TAB_IND_GROUPS_TL B

254: HELP
255: ) = (select
256: B.NAME,
257: B.HELP
258: from BSC_TAB_IND_GROUPS_TL B
259: where B.TAB_ID = T.TAB_ID
260: and B.CSF_ID = T.CSF_ID
261: and B.IND_GROUP_ID = T.IND_GROUP_ID
262: and B.LANGUAGE = T.SOURCE_LANG)

Line 273: from BSC_TAB_IND_GROUPS_TL SUBB, BSC_TAB_IND_GROUPS_TL SUBT

269: SUBT.TAB_ID,
270: SUBT.CSF_ID,
271: SUBT.IND_GROUP_ID,
272: SUBT.LANGUAGE
273: from BSC_TAB_IND_GROUPS_TL SUBB, BSC_TAB_IND_GROUPS_TL SUBT
274: where SUBB.TAB_ID = SUBT.TAB_ID
275: and SUBB.CSF_ID = SUBT.CSF_ID
276: and SUBB.IND_GROUP_ID = SUBT.IND_GROUP_ID
277: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 286: insert into BSC_TAB_IND_GROUPS_TL (

282: or (SUBB.HELP is null and SUBT.HELP is not null)
283: or (SUBB.HELP is not null and SUBT.HELP is null)
284: ));
285:
286: insert into BSC_TAB_IND_GROUPS_TL (
287: TAB_ID,
288: CSF_ID,
289: IND_GROUP_ID,
290: NAME,

Line 302: from BSC_TAB_IND_GROUPS_TL B, FND_LANGUAGES L

298: B.NAME,
299: B.HELP,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from BSC_TAB_IND_GROUPS_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL

Line 307: from BSC_TAB_IND_GROUPS_TL T

303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL
307: from BSC_TAB_IND_GROUPS_TL T
308: where T.TAB_ID = B.TAB_ID
309: and T.CSF_ID = B.CSF_ID
310: and T.IND_GROUP_ID = B.IND_GROUP_ID
311: and T.LANGUAGE = L.LANGUAGE_CODE);