APPS.BNE_PARAM_LISTS_PKG dependencies on BNE_PARAM_LISTS_TL

Line 59: insert into BNE_PARAM_LISTS_TL (

55: X_LAST_UPDATED_BY,
56: X_LAST_UPDATE_LOGIN
57: );
58:
59: insert into BNE_PARAM_LISTS_TL (
60: APPLICATION_ID,
61: PARAM_LIST_CODE,
62: USER_NAME,
63: USER_TIP,

Line 91: from BNE_PARAM_LISTS_TL T

87: from FND_LANGUAGES L
88: where L.INSTALLED_FLAG in ('I', 'B')
89: and not exists
90: (select NULL
91: from BNE_PARAM_LISTS_TL T
92: where T.APPLICATION_ID = X_APPLICATION_ID
93: and T.PARAM_LIST_CODE = X_PARAM_LIST_CODE
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95:

Line 139: from BNE_PARAM_LISTS_TL

135: PROMPT_LEFT,
136: PROMPT_ABOVE,
137: USER_NAME,
138: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
139: from BNE_PARAM_LISTS_TL
140: where APPLICATION_ID = X_APPLICATION_ID
141: and PARAM_LIST_CODE = X_PARAM_LIST_CODE
142: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
143: for update of APPLICATION_ID nowait;

Line 225: update BNE_PARAM_LISTS_TL set

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: update BNE_PARAM_LISTS_TL set
226: USER_TIP = X_USER_TIP,
227: PROMPT_LEFT = X_PROMPT_LEFT,
228: PROMPT_ABOVE = X_PROMPT_ABOVE,
229: USER_NAME = X_USER_NAME,

Line 248: delete from BNE_PARAM_LISTS_TL

244: X_APPLICATION_ID in NUMBER,
245: X_PARAM_LIST_CODE in VARCHAR2
246: ) is
247: begin
248: delete from BNE_PARAM_LISTS_TL
249: where APPLICATION_ID = X_APPLICATION_ID
250: and PARAM_LIST_CODE = X_PARAM_LIST_CODE;
251:
252: if (sql%notfound) then

Line 268: delete from BNE_PARAM_LISTS_TL T

264:
265: procedure ADD_LANGUAGE
266: is
267: begin
268: delete from BNE_PARAM_LISTS_TL T
269: where not exists
270: (select NULL
271: from BNE_PARAM_LISTS_B B
272: where B.APPLICATION_ID = T.APPLICATION_ID

Line 276: update BNE_PARAM_LISTS_TL T set (

272: where B.APPLICATION_ID = T.APPLICATION_ID
273: and B.PARAM_LIST_CODE = T.PARAM_LIST_CODE
274: );
275:
276: update BNE_PARAM_LISTS_TL T set (
277: USER_TIP,
278: PROMPT_LEFT,
279: PROMPT_ABOVE,
280: USER_NAME

Line 286: from BNE_PARAM_LISTS_TL B

282: B.USER_TIP,
283: B.PROMPT_LEFT,
284: B.PROMPT_ABOVE,
285: B.USER_NAME
286: from BNE_PARAM_LISTS_TL B
287: where B.APPLICATION_ID = T.APPLICATION_ID
288: and B.PARAM_LIST_CODE = T.PARAM_LIST_CODE
289: and B.LANGUAGE = T.SOURCE_LANG)
290: where (

Line 298: from BNE_PARAM_LISTS_TL SUBB, BNE_PARAM_LISTS_TL SUBT

294: ) in (select
295: SUBT.APPLICATION_ID,
296: SUBT.PARAM_LIST_CODE,
297: SUBT.LANGUAGE
298: from BNE_PARAM_LISTS_TL SUBB, BNE_PARAM_LISTS_TL SUBT
299: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
300: and SUBB.PARAM_LIST_CODE = SUBT.PARAM_LIST_CODE
301: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
302: and (SUBB.USER_TIP <> SUBT.USER_TIP

Line 314: insert into BNE_PARAM_LISTS_TL (

310: or (SUBB.PROMPT_ABOVE is not null and SUBT.PROMPT_ABOVE is null)
311: or SUBB.USER_NAME <> SUBT.USER_NAME
312: ));
313:
314: insert into BNE_PARAM_LISTS_TL (
315: APPLICATION_ID,
316: PARAM_LIST_CODE,
317: USER_NAME,
318: USER_TIP,

Line 342: from BNE_PARAM_LISTS_TL B, FND_LANGUAGES L

338: B.LAST_UPDATE_DATE,
339: B.LAST_UPDATE_LOGIN,
340: L.LANGUAGE_CODE,
341: B.SOURCE_LANG
342: from BNE_PARAM_LISTS_TL B, FND_LANGUAGES L
343: where L.INSTALLED_FLAG in ('I', 'B')
344: and B.LANGUAGE = userenv('LANG')
345: and not exists
346: (select NULL

Line 347: from BNE_PARAM_LISTS_TL T

343: where L.INSTALLED_FLAG in ('I', 'B')
344: and B.LANGUAGE = userenv('LANG')
345: and not exists
346: (select NULL
347: from BNE_PARAM_LISTS_TL T
348: where T.APPLICATION_ID = B.APPLICATION_ID
349: and T.PARAM_LIST_CODE = B.PARAM_LIST_CODE
350: and T.LANGUAGE = L.LANGUAGE_CODE);
351: end ADD_LANGUAGE;

Line 395: from BNE_PARAM_LISTS_TL

391: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
392: begin
393: select LAST_UPDATED_BY, LAST_UPDATE_DATE
394: into db_luby, db_ludate
395: from BNE_PARAM_LISTS_TL
396: where APPLICATION_ID = l_app_id
397: and PARAM_LIST_CODE = x_param_list_code
398: and LANGUAGE = userenv('LANG');
399:

Line 404: update BNE_PARAM_LISTS_TL

400: -- Test for customization and version
401: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
402: db_ludate, x_custom_mode)) then
403:
404: update BNE_PARAM_LISTS_TL
405: set USER_TIP = x_user_tip,
406: PROMPT_LEFT = x_prompt_left,
407: PROMPT_ABOVE = x_prompt_above,
408: USER_NAME = x_user_name,