APPS.BSC_SYS_DATASETS_PKG dependencies on BSC_SYS_DATASETS_TL

Line 48: insert into BSC_SYS_DATASETS_TL (

44: X_LAST_UPDATED_BY ,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into BSC_SYS_DATASETS_TL (
49: DATASET_ID,
50: NAME,
51: HELP,
52: LANGUAGE,

Line 64: from BSC_SYS_DATASETS_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from BSC_SYS_DATASETS_TL T
65: where T.DATASET_ID = X_DATASET_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: end INSERT_ROW;

Line 76: update BSC_SYS_DATASETS_TL set

72: X_NAME in VARCHAR2,
73: X_HELP in VARCHAR2)
74: is
75: begin
76: update BSC_SYS_DATASETS_TL set
77: NAME = NVL(X_NAME,NAME),
78: HELP = NVL(X_HELP, HELP),
79: SOURCE_LANG = userenv('LANG')
80: where

Line 112: from BSC_SYS_DATASETS_TL

108: cursor c1 is select
109: NAME,
110: HELP,
111: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
112: from BSC_SYS_DATASETS_TL
113: where DATASET_ID = X_DATASET_ID
114: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
115: for update of DATASET_ID nowait;
116: begin

Line 189: update BSC_SYS_DATASETS_TL set

185: if (sql%notfound) then
186: raise no_data_found;
187: end if;
188:
189: update BSC_SYS_DATASETS_TL set
190: NAME = X_NAME,
191: HELP = X_HELP,
192: SOURCE_LANG = userenv('LANG')
193: where DATASET_ID = X_DATASET_ID

Line 205: delete from BSC_SYS_DATASETS_TL

201: procedure DELETE_ROW (
202: X_DATASET_ID in NUMBER
203: ) is
204: begin
205: delete from BSC_SYS_DATASETS_TL
206: where DATASET_ID = X_DATASET_ID;
207:
208: if (sql%notfound) then
209: raise no_data_found;

Line 223: delete from BSC_SYS_DATASETS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from BSC_SYS_DATASETS_TL T
224: where not exists
225: (select NULL
226: from BSC_SYS_DATASETS_B B
227: where B.DATASET_ID = T.DATASET_ID

Line 230: update BSC_SYS_DATASETS_TL T set (

226: from BSC_SYS_DATASETS_B B
227: where B.DATASET_ID = T.DATASET_ID
228: );
229:
230: update BSC_SYS_DATASETS_TL T set (
231: NAME,
232: HELP,Y_AXIS_TITLE
233: ) = (select
234: B.NAME,

Line 236: from BSC_SYS_DATASETS_TL B

232: HELP,Y_AXIS_TITLE
233: ) = (select
234: B.NAME,
235: B.HELP,B.Y_AXIS_TITLE
236: from BSC_SYS_DATASETS_TL B
237: where B.DATASET_ID = T.DATASET_ID
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (
240: T.DATASET_ID,

Line 245: from BSC_SYS_DATASETS_TL SUBB, BSC_SYS_DATASETS_TL SUBT

241: T.LANGUAGE
242: ) in (select
243: SUBT.DATASET_ID,
244: SUBT.LANGUAGE
245: from BSC_SYS_DATASETS_TL SUBB, BSC_SYS_DATASETS_TL SUBT
246: where SUBB.DATASET_ID = SUBT.DATASET_ID
247: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
248: and (SUBB.NAME <> SUBT.NAME
249: or SUBB.HELP <> SUBT.HELP or SUBB.Y_AXIS_TITLE <> SUBT.Y_AXIS_TITLE

Line 252: insert into BSC_SYS_DATASETS_TL (

248: and (SUBB.NAME <> SUBT.NAME
249: or SUBB.HELP <> SUBT.HELP or SUBB.Y_AXIS_TITLE <> SUBT.Y_AXIS_TITLE
250: ));
251:
252: insert into BSC_SYS_DATASETS_TL (
253: DATASET_ID,
254: NAME,
255: HELP,
256: Y_AXIS_TITLE,

Line 266: from BSC_SYS_DATASETS_TL B, FND_LANGUAGES L

262: B.HELP,
263: B.Y_AXIS_TITLE,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from BSC_SYS_DATASETS_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from BSC_SYS_DATASETS_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from BSC_SYS_DATASETS_TL T
272: where T.DATASET_ID = B.DATASET_ID
273: and T.LANGUAGE = L.LANGUAGE_CODE);
274: end ADD_LANGUAGE;
275: