APPS.BNE_INTERFACES_PKG dependencies on BNE_INTERFACES_TL

Line 65: insert into BNE_INTERFACES_TL (

61: X_LAST_UPDATED_BY,
62: X_LAST_UPDATE_LOGIN
63: );
64:
65: insert into BNE_INTERFACES_TL (
66: APPLICATION_ID,
67: INTERFACE_CODE,
68: USER_NAME,
69: CREATED_BY,

Line 91: from BNE_INTERFACES_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_INTERFACES_TL T
92: where T.APPLICATION_ID = X_APPLICATION_ID
93: and T.INTERFACE_CODE = X_INTERFACE_CODE
94: and T.LANGUAGE = L.LANGUAGE_CODE);
95:

Line 139: from BNE_INTERFACES_TL

135:
136: cursor c1 is select
137: USER_NAME,
138: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
139: from BNE_INTERFACES_TL
140: where APPLICATION_ID = X_APPLICATION_ID
141: and INTERFACE_CODE = X_INTERFACE_CODE
142: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
143: for update of APPLICATION_ID nowait;

Line 225: update BNE_INTERFACES_TL set

221: if (sql%notfound) then
222: raise no_data_found;
223: end if;
224:
225: update BNE_INTERFACES_TL set
226: USER_NAME = X_USER_NAME,
227: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
228: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
229: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 245: delete from BNE_INTERFACES_TL

241: X_APPLICATION_ID in NUMBER,
242: X_INTERFACE_CODE in VARCHAR2
243: ) is
244: begin
245: delete from BNE_INTERFACES_TL
246: where APPLICATION_ID = X_APPLICATION_ID
247: and INTERFACE_CODE = X_INTERFACE_CODE;
248:
249: if (sql%notfound) then

Line 265: delete from BNE_INTERFACES_TL T

261:
262: procedure ADD_LANGUAGE
263: is
264: begin
265: delete from BNE_INTERFACES_TL T
266: where not exists
267: (select NULL
268: from BNE_INTERFACES_B B
269: where B.APPLICATION_ID = T.APPLICATION_ID

Line 273: update BNE_INTERFACES_TL T set (

269: where B.APPLICATION_ID = T.APPLICATION_ID
270: and B.INTERFACE_CODE = T.INTERFACE_CODE
271: );
272:
273: update BNE_INTERFACES_TL T set (
274: USER_NAME
275: ) = (select
276: B.USER_NAME
277: from BNE_INTERFACES_TL B

Line 277: from BNE_INTERFACES_TL B

273: update BNE_INTERFACES_TL T set (
274: USER_NAME
275: ) = (select
276: B.USER_NAME
277: from BNE_INTERFACES_TL B
278: where B.APPLICATION_ID = T.APPLICATION_ID
279: and B.INTERFACE_CODE = T.INTERFACE_CODE
280: and B.LANGUAGE = T.SOURCE_LANG)
281: where (

Line 289: from BNE_INTERFACES_TL SUBB, BNE_INTERFACES_TL SUBT

285: ) in (select
286: SUBT.APPLICATION_ID,
287: SUBT.INTERFACE_CODE,
288: SUBT.LANGUAGE
289: from BNE_INTERFACES_TL SUBB, BNE_INTERFACES_TL SUBT
290: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
291: and SUBB.INTERFACE_CODE = SUBT.INTERFACE_CODE
292: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
293: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 296: insert into BNE_INTERFACES_TL (

292: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
293: and (SUBB.USER_NAME <> SUBT.USER_NAME
294: ));
295:
296: insert into BNE_INTERFACES_TL (
297: APPLICATION_ID,
298: INTERFACE_CODE,
299: USER_NAME,
300: CREATED_BY,

Line 318: from BNE_INTERFACES_TL B, FND_LANGUAGES L

314: B.LAST_UPDATE_LOGIN,
315: B.LAST_UPDATE_DATE,
316: L.LANGUAGE_CODE,
317: B.SOURCE_LANG
318: from BNE_INTERFACES_TL B, FND_LANGUAGES L
319: where L.INSTALLED_FLAG in ('I', 'B')
320: and B.LANGUAGE = userenv('LANG')
321: and not exists
322: (select NULL

Line 323: from BNE_INTERFACES_TL T

319: where L.INSTALLED_FLAG in ('I', 'B')
320: and B.LANGUAGE = userenv('LANG')
321: and not exists
322: (select NULL
323: from BNE_INTERFACES_TL T
324: where T.APPLICATION_ID = B.APPLICATION_ID
325: and T.INTERFACE_CODE = B.INTERFACE_CODE
326: and T.LANGUAGE = L.LANGUAGE_CODE);
327: end ADD_LANGUAGE;

Line 369: from BNE_INTERFACES_TL

365: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
366: begin
367: select LAST_UPDATED_BY, LAST_UPDATE_DATE
368: into db_luby, db_ludate
369: from BNE_INTERFACES_TL
370: where APPLICATION_ID = l_app_id
371: and INTERFACE_CODE = x_interface_code
372: and LANGUAGE = userenv('LANG');
373:

Line 378: update BNE_INTERFACES_TL

374: -- Test for customization and version
375: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
376: db_ludate, x_custom_mode)) then
377:
378: update BNE_INTERFACES_TL
379: set USER_NAME = x_user_name,
380: LAST_UPDATE_DATE = f_ludate,
381: LAST_UPDATED_BY = f_luby,
382: LAST_UPDATE_LOGIN = 0,