APPS.BSC_USER_PARAMETERS_PKG dependencies on BSC_USER_PARAMETERS_TL

Line 98: insert into BSC_USER_PARAMETERS_TL (

94: X_LAST_UPDATED_BY,
95: X_LAST_UPDATE_LOGIN
96: );
97:
98: insert into BSC_USER_PARAMETERS_TL (
99: PARAM_LIST_ID,
100: TITLE,
101: CREATION_DATE,
102: CREATED_BY,

Line 122: from BSC_USER_PARAMETERS_TL T

118: from FND_LANGUAGES L
119: where L.INSTALLED_FLAG in ('I', 'B')
120: and not exists
121: (select NULL
122: from BSC_USER_PARAMETERS_TL T
123: where T.PARAM_LIST_ID = l_param_list_id
124: and T.LANGUAGE = L.LANGUAGE_CODE);
125:
126: open c;

Line 193: update BSC_USER_PARAMETERS_TL set

189: if (sql%notfound) then
190: raise no_data_found;
191: end if;
192:
193: update BSC_USER_PARAMETERS_TL set
194: TITLE = X_TITLE,
195: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
196: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
197: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 220: delete from BSC_USER_PARAMETERS_TL

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: delete from BSC_USER_PARAMETERS_TL
221: where PARAM_LIST_ID = X_PARAM_LIST_ID;
222:
223: if (sql%notfound) then
224: raise no_data_found;

Line 232: delete from BSC_USER_PARAMETERS_TL T

228:
229: procedure ADD_LANGUAGE
230: is
231: begin
232: delete from BSC_USER_PARAMETERS_TL T
233: where not exists
234: (select NULL
235: from BSC_USER_PARAMETERS_B B
236: where B.PARAM_LIST_ID = T.PARAM_LIST_ID

Line 239: update BSC_USER_PARAMETERS_TL T set (

235: from BSC_USER_PARAMETERS_B B
236: where B.PARAM_LIST_ID = T.PARAM_LIST_ID
237: );
238:
239: update BSC_USER_PARAMETERS_TL T set (
240: TITLE
241: ) = (select
242: B.TITLE
243: from BSC_USER_PARAMETERS_TL B

Line 243: from BSC_USER_PARAMETERS_TL B

239: update BSC_USER_PARAMETERS_TL T set (
240: TITLE
241: ) = (select
242: B.TITLE
243: from BSC_USER_PARAMETERS_TL B
244: where B.PARAM_LIST_ID = T.PARAM_LIST_ID
245: and B.LANGUAGE = T.SOURCE_LANG)
246: where (
247: T.PARAM_LIST_ID,

Line 252: from BSC_USER_PARAMETERS_TL SUBB, BSC_USER_PARAMETERS_TL SUBT

248: T.LANGUAGE
249: ) in (select
250: SUBT.PARAM_LIST_ID,
251: SUBT.LANGUAGE
252: from BSC_USER_PARAMETERS_TL SUBB, BSC_USER_PARAMETERS_TL SUBT
253: where SUBB.PARAM_LIST_ID = SUBT.PARAM_LIST_ID
254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.TITLE <> SUBT.TITLE)
256: );

Line 258: insert into BSC_USER_PARAMETERS_TL (

254: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
255: and (SUBB.TITLE <> SUBT.TITLE)
256: );
257:
258: insert into BSC_USER_PARAMETERS_TL (
259: PARAM_LIST_ID,
260: TITLE,
261: CREATION_DATE,
262: CREATED_BY,

Line 278: from BSC_USER_PARAMETERS_TL B, FND_LANGUAGES L

274: B.LAST_UPDATED_BY,
275: B.LAST_UPDATE_LOGIN,
276: L.LANGUAGE_CODE,
277: B.SOURCE_LANG
278: from BSC_USER_PARAMETERS_TL B, FND_LANGUAGES L
279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL

Line 283: from BSC_USER_PARAMETERS_TL T

279: where L.INSTALLED_FLAG in ('I', 'B')
280: and B.LANGUAGE = userenv('LANG')
281: and not exists
282: (select NULL
283: from BSC_USER_PARAMETERS_TL T
284: where T.PARAM_LIST_ID = B.PARAM_LIST_ID
285: and T.LANGUAGE = L.LANGUAGE_CODE);
286: end ADD_LANGUAGE;
287:

Line 297: update BSC_USER_PARAMETERS_TL set

293: X_CUSTOM_MODE in VARCHAR2
294: ) is
295: begin
296: if (X_CUSTOM_MODE = 'FORCE') then
297: update BSC_USER_PARAMETERS_TL set
298: TITLE = X_TITLE,
299: LAST_UPDATE_DATE = sysdate,
300: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
301: LAST_UPDATE_LOGIN = 0,

Line 306: update BSC_USER_PARAMETERS_TL set

302: SOURCE_LANG = userenv('LANG')
303: where PARAM_LIST_ID = X_PARAM_LIST_ID
304: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
305: else
306: update BSC_USER_PARAMETERS_TL set
307: TITLE = X_TITLE,
308: LAST_UPDATE_DATE = sysdate,
309: LAST_UPDATED_BY = decode(X_OWNER, 'SEED', 1, 0),
310: LAST_UPDATE_LOGIN = 0,