APPS.BNE_VIEWERS_PKG dependencies on BNE_VIEWERS_TL

Line 67: insert into BNE_VIEWERS_TL (

63: X_CREATE_DOC_LIST_CODE,
64: X_ENABLED_FLAG
65: );
66:
67: insert into BNE_VIEWERS_TL (
68: APPLICATION_ID,
69: VIEWER_CODE,
70: USER_NAME,
71: CREATED_BY,

Line 93: from BNE_VIEWERS_TL T

89: from FND_LANGUAGES L
90: where L.INSTALLED_FLAG in ('I', 'B')
91: and not exists
92: (select NULL
93: from BNE_VIEWERS_TL T
94: where T.APPLICATION_ID = X_APPLICATION_ID
95: and T.VIEWER_CODE = X_VIEWER_CODE
96: and T.LANGUAGE = L.LANGUAGE_CODE);
97:

Line 137: from BNE_VIEWERS_TL

133:
134: cursor c1 is select
135: USER_NAME,
136: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
137: from BNE_VIEWERS_TL
138: where APPLICATION_ID = X_APPLICATION_ID
139: and VIEWER_CODE = X_VIEWER_CODE
140: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
141: for update of APPLICATION_ID nowait;

Line 218: update BNE_VIEWERS_TL set

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: update BNE_VIEWERS_TL set
219: USER_NAME = X_USER_NAME,
220: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
221: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
222: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 238: delete from BNE_VIEWERS_TL

234: X_APPLICATION_ID in NUMBER,
235: X_VIEWER_CODE in VARCHAR2
236: ) is
237: begin
238: delete from BNE_VIEWERS_TL
239: where APPLICATION_ID = X_APPLICATION_ID
240: and VIEWER_CODE = X_VIEWER_CODE;
241:
242: if (sql%notfound) then

Line 258: delete from BNE_VIEWERS_TL T

254:
255: procedure ADD_LANGUAGE
256: is
257: begin
258: delete from BNE_VIEWERS_TL T
259: where not exists
260: (select NULL
261: from BNE_VIEWERS_B B
262: where B.APPLICATION_ID = T.APPLICATION_ID

Line 266: update BNE_VIEWERS_TL T set (

262: where B.APPLICATION_ID = T.APPLICATION_ID
263: and B.VIEWER_CODE = T.VIEWER_CODE
264: );
265:
266: update BNE_VIEWERS_TL T set (
267: USER_NAME
268: ) = (select
269: B.USER_NAME
270: from BNE_VIEWERS_TL B

Line 270: from BNE_VIEWERS_TL B

266: update BNE_VIEWERS_TL T set (
267: USER_NAME
268: ) = (select
269: B.USER_NAME
270: from BNE_VIEWERS_TL B
271: where B.APPLICATION_ID = T.APPLICATION_ID
272: and B.VIEWER_CODE = T.VIEWER_CODE
273: and B.LANGUAGE = T.SOURCE_LANG)
274: where (

Line 282: from BNE_VIEWERS_TL SUBB, BNE_VIEWERS_TL SUBT

278: ) in (select
279: SUBT.APPLICATION_ID,
280: SUBT.VIEWER_CODE,
281: SUBT.LANGUAGE
282: from BNE_VIEWERS_TL SUBB, BNE_VIEWERS_TL SUBT
283: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
284: and SUBB.VIEWER_CODE = SUBT.VIEWER_CODE
285: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
286: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 289: insert into BNE_VIEWERS_TL (

285: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
286: and (SUBB.USER_NAME <> SUBT.USER_NAME
287: ));
288:
289: insert into BNE_VIEWERS_TL (
290: APPLICATION_ID,
291: VIEWER_CODE,
292: USER_NAME,
293: CREATED_BY,

Line 311: from BNE_VIEWERS_TL B, FND_LANGUAGES L

307: B.LAST_UPDATE_LOGIN,
308: B.LAST_UPDATE_DATE,
309: L.LANGUAGE_CODE,
310: B.SOURCE_LANG
311: from BNE_VIEWERS_TL B, FND_LANGUAGES L
312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL

Line 316: from BNE_VIEWERS_TL T

312: where L.INSTALLED_FLAG in ('I', 'B')
313: and B.LANGUAGE = userenv('LANG')
314: and not exists
315: (select NULL
316: from BNE_VIEWERS_TL T
317: where T.APPLICATION_ID = B.APPLICATION_ID
318: and T.VIEWER_CODE = B.VIEWER_CODE
319: and T.LANGUAGE = L.LANGUAGE_CODE);
320: end ADD_LANGUAGE;

Line 464: from BNE_VIEWERS_TL

460: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
461: begin
462: select LAST_UPDATED_BY, LAST_UPDATE_DATE
463: into db_luby, db_ludate
464: from BNE_VIEWERS_TL
465: where APPLICATION_ID = l_app_id
466: and VIEWER_CODE = x_viewer_code
467: and LANGUAGE = userenv('LANG');
468:

Line 473: update BNE_VIEWERS_TL

469: -- Test for customization and version
470: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
471: db_ludate, x_custom_mode)) then
472:
473: update BNE_VIEWERS_TL
474: set USER_NAME = x_user_name,
475: LAST_UPDATE_DATE = f_ludate,
476: LAST_UPDATED_BY = f_luby,
477: LAST_UPDATE_LOGIN = 0,