APPS.BNE_LAYOUTS_PKG dependencies on BNE_LAYOUTS_TL

Line 74: insert into BNE_LAYOUTS_TL (

70: X_CREATE_DOC_LIST_APP_ID,
71: X_CREATE_DOC_LIST_CODE
72: );
73:
74: insert into BNE_LAYOUTS_TL (
75: APPLICATION_ID,
76: LAYOUT_CODE,
77: USER_NAME,
78: CREATED_BY,

Line 100: from BNE_LAYOUTS_TL T

96: from FND_LANGUAGES L
97: where L.INSTALLED_FLAG in ('I', 'B')
98: and not exists
99: (select NULL
100: from BNE_LAYOUTS_TL T
101: where T.APPLICATION_ID = X_APPLICATION_ID
102: and T.LAYOUT_CODE = X_LAYOUT_CODE
103: and T.LANGUAGE = L.LANGUAGE_CODE);
104:

Line 154: from BNE_LAYOUTS_TL

150:
151: cursor c1 is select
152: USER_NAME,
153: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
154: from BNE_LAYOUTS_TL
155: where APPLICATION_ID = X_APPLICATION_ID
156: and LAYOUT_CODE = X_LAYOUT_CODE
157: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
158: for update of APPLICATION_ID nowait;

Line 252: update BNE_LAYOUTS_TL set

248: if (sql%notfound) then
249: raise no_data_found;
250: end if;
251:
252: update BNE_LAYOUTS_TL set
253: USER_NAME = X_USER_NAME,
254: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
255: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
256: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 272: delete from BNE_LAYOUTS_TL

268: X_APPLICATION_ID in NUMBER,
269: X_LAYOUT_CODE in VARCHAR2
270: ) is
271: begin
272: delete from BNE_LAYOUTS_TL
273: where APPLICATION_ID = X_APPLICATION_ID
274: and LAYOUT_CODE = X_LAYOUT_CODE;
275:
276: if (sql%notfound) then

Line 292: delete from BNE_LAYOUTS_TL T

288:
289: procedure ADD_LANGUAGE
290: is
291: begin
292: delete from BNE_LAYOUTS_TL T
293: where not exists
294: (select NULL
295: from BNE_LAYOUTS_B B
296: where B.APPLICATION_ID = T.APPLICATION_ID

Line 300: update BNE_LAYOUTS_TL T set (

296: where B.APPLICATION_ID = T.APPLICATION_ID
297: and B.LAYOUT_CODE = T.LAYOUT_CODE
298: );
299:
300: update BNE_LAYOUTS_TL T set (
301: USER_NAME
302: ) = (select
303: B.USER_NAME
304: from BNE_LAYOUTS_TL B

Line 304: from BNE_LAYOUTS_TL B

300: update BNE_LAYOUTS_TL T set (
301: USER_NAME
302: ) = (select
303: B.USER_NAME
304: from BNE_LAYOUTS_TL B
305: where B.APPLICATION_ID = T.APPLICATION_ID
306: and B.LAYOUT_CODE = T.LAYOUT_CODE
307: and B.LANGUAGE = T.SOURCE_LANG)
308: where (

Line 316: from BNE_LAYOUTS_TL SUBB, BNE_LAYOUTS_TL SUBT

312: ) in (select
313: SUBT.APPLICATION_ID,
314: SUBT.LAYOUT_CODE,
315: SUBT.LANGUAGE
316: from BNE_LAYOUTS_TL SUBB, BNE_LAYOUTS_TL SUBT
317: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
318: and SUBB.LAYOUT_CODE = SUBT.LAYOUT_CODE
319: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
320: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 323: insert into BNE_LAYOUTS_TL (

319: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
320: and (SUBB.USER_NAME <> SUBT.USER_NAME
321: ));
322:
323: insert into BNE_LAYOUTS_TL (
324: APPLICATION_ID,
325: LAYOUT_CODE,
326: USER_NAME,
327: CREATED_BY,

Line 345: from BNE_LAYOUTS_TL B, FND_LANGUAGES L

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

Line 350: from BNE_LAYOUTS_TL T

346: where L.INSTALLED_FLAG in ('I', 'B')
347: and B.LANGUAGE = userenv('LANG')
348: and not exists
349: (select NULL
350: from BNE_LAYOUTS_TL T
351: where T.APPLICATION_ID = B.APPLICATION_ID
352: and T.LAYOUT_CODE = B.LAYOUT_CODE
353: and T.LANGUAGE = L.LANGUAGE_CODE);
354: end ADD_LANGUAGE;

Line 396: from BNE_LAYOUTS_TL

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

Line 405: update BNE_LAYOUTS_TL

401: -- Test for customization and version
402: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
403: db_ludate, x_custom_mode)) then
404:
405: update BNE_LAYOUTS_TL
406: set USER_NAME = x_user_name,
407: LAST_UPDATE_DATE = f_ludate,
408: LAST_UPDATED_BY = f_luby,
409: LAST_UPDATE_LOGIN = 0,