APPS.BNE_CONTENTS_PKG dependencies on BNE_CONTENTS_TL

Line 59: insert into BNE_CONTENTS_TL (

55: X_LAST_UPDATE_LOGIN,
56: X_ONCE_ONLY_DOWNLOAD_FLAG
57: );
58:
59: insert into BNE_CONTENTS_TL (
60: CONTENT_CODE,
61: USER_NAME,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,

Line 85: from BNE_CONTENTS_TL T

81: from FND_LANGUAGES L
82: where L.INSTALLED_FLAG in ('I', 'B')
83: and not exists
84: (select NULL
85: from BNE_CONTENTS_TL T
86: where T.APPLICATION_ID = X_APPLICATION_ID
87: and T.CONTENT_CODE = X_CONTENT_CODE
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:

Line 129: from BNE_CONTENTS_TL

125:
126: cursor c1 is select
127: USER_NAME,
128: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
129: from BNE_CONTENTS_TL
130: where APPLICATION_ID = X_APPLICATION_ID
131: and CONTENT_CODE = X_CONTENT_CODE
132: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
133: for update of APPLICATION_ID nowait;

Line 209: update BNE_CONTENTS_TL set

205: if (sql%notfound) then
206: raise no_data_found;
207: end if;
208:
209: update BNE_CONTENTS_TL set
210: USER_NAME = X_USER_NAME,
211: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
212: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
213: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 229: delete from BNE_CONTENTS_TL

225: X_APPLICATION_ID in NUMBER,
226: X_CONTENT_CODE in VARCHAR2
227: ) is
228: begin
229: delete from BNE_CONTENTS_TL
230: where APPLICATION_ID = X_APPLICATION_ID
231: and CONTENT_CODE = X_CONTENT_CODE;
232:
233: if (sql%notfound) then

Line 249: delete from BNE_CONTENTS_TL T

245:
246: procedure ADD_LANGUAGE
247: is
248: begin
249: delete from BNE_CONTENTS_TL T
250: where not exists
251: (select NULL
252: from BNE_CONTENTS_B B
253: where B.APPLICATION_ID = T.APPLICATION_ID

Line 257: update BNE_CONTENTS_TL T set (

253: where B.APPLICATION_ID = T.APPLICATION_ID
254: and B.CONTENT_CODE = T.CONTENT_CODE
255: );
256:
257: update BNE_CONTENTS_TL T set (
258: USER_NAME
259: ) = (select
260: B.USER_NAME
261: from BNE_CONTENTS_TL B

Line 261: from BNE_CONTENTS_TL B

257: update BNE_CONTENTS_TL T set (
258: USER_NAME
259: ) = (select
260: B.USER_NAME
261: from BNE_CONTENTS_TL B
262: where B.APPLICATION_ID = T.APPLICATION_ID
263: and B.CONTENT_CODE = T.CONTENT_CODE
264: and B.LANGUAGE = T.SOURCE_LANG)
265: where (

Line 273: from BNE_CONTENTS_TL SUBB, BNE_CONTENTS_TL SUBT

269: ) in (select
270: SUBT.APPLICATION_ID,
271: SUBT.CONTENT_CODE,
272: SUBT.LANGUAGE
273: from BNE_CONTENTS_TL SUBB, BNE_CONTENTS_TL SUBT
274: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
275: and SUBB.CONTENT_CODE = SUBT.CONTENT_CODE
276: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
277: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 280: insert into BNE_CONTENTS_TL (

276: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
277: and (SUBB.USER_NAME <> SUBT.USER_NAME
278: ));
279:
280: insert into BNE_CONTENTS_TL (
281: CONTENT_CODE,
282: USER_NAME,
283: LAST_UPDATE_DATE,
284: LAST_UPDATED_BY,

Line 302: from BNE_CONTENTS_TL B, FND_LANGUAGES L

298: B.LAST_UPDATE_LOGIN,
299: B.APPLICATION_ID,
300: L.LANGUAGE_CODE,
301: B.SOURCE_LANG
302: from BNE_CONTENTS_TL B, FND_LANGUAGES L
303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL

Line 307: from BNE_CONTENTS_TL T

303: where L.INSTALLED_FLAG in ('I', 'B')
304: and B.LANGUAGE = userenv('LANG')
305: and not exists
306: (select NULL
307: from BNE_CONTENTS_TL T
308: where T.APPLICATION_ID = B.APPLICATION_ID
309: and T.CONTENT_CODE = B.CONTENT_CODE
310: and T.LANGUAGE = L.LANGUAGE_CODE);
311: end ADD_LANGUAGE;

Line 352: from BNE_CONTENTS_TL

348: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
349: begin
350: select LAST_UPDATED_BY, LAST_UPDATE_DATE
351: into db_luby, db_ludate
352: from BNE_CONTENTS_TL
353: where APPLICATION_ID = l_app_id
354: and CONTENT_CODE = x_content_code
355: and LANGUAGE = userenv('LANG');
356:

Line 361: update BNE_CONTENTS_TL

357: -- Test for customization and version
358: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
359: db_ludate, x_custom_mode)) then
360:
361: update BNE_CONTENTS_TL
362: set USER_NAME = x_user_name,
363: LAST_UPDATE_DATE = f_ludate,
364: LAST_UPDATED_BY = f_luby,
365: LAST_UPDATE_LOGIN = 0,