APPS.BNE_STYLESHEETS_PKG dependencies on BNE_STYLESHEETS_TL

Line 51: insert into BNE_STYLESHEETS_TL (

47: X_LAST_UPDATE_LOGIN,
48: X_IMAGE_FILE_NAME
49: );
50:
51: insert into BNE_STYLESHEETS_TL (
52: APPLICATION_ID,
53: STYLESHEET_CODE,
54: USER_NAME,
55: DESCRIPTION,

Line 79: from BNE_STYLESHEETS_TL T

75: from FND_LANGUAGES L
76: where L.INSTALLED_FLAG in ('I', 'B')
77: and not exists
78: (select NULL
79: from BNE_STYLESHEETS_TL T
80: where T.APPLICATION_ID = X_APPLICATION_ID
81: and T.STYLESHEET_CODE = X_STYLESHEET_CODE
82: and T.LANGUAGE = L.LANGUAGE_CODE);
83:

Line 118: from BNE_STYLESHEETS_TL

114:
115: cursor c1 is select
116: USER_NAME, DESCRIPTION,
117: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
118: from BNE_STYLESHEETS_TL
119: where APPLICATION_ID = X_APPLICATION_ID
120: and STYLESHEET_CODE = X_STYLESHEET_CODE
121: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
122: for update of APPLICATION_ID nowait;

Line 191: update BNE_STYLESHEETS_TL set

187: if (sql%notfound) then
188: raise no_data_found;
189: end if;
190:
191: update BNE_STYLESHEETS_TL set
192: USER_NAME = X_USER_NAME,
193: DESCRIPTION = X_DESCRIPTION,
194: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
195: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 212: delete from BNE_STYLESHEETS_TL

208: X_APPLICATION_ID in NUMBER,
209: X_STYLESHEET_CODE in VARCHAR2
210: ) is
211: begin
212: delete from BNE_STYLESHEETS_TL
213: where APPLICATION_ID = X_APPLICATION_ID
214: and STYLESHEET_CODE = X_STYLESHEET_CODE;
215:
216: if (sql%notfound) then

Line 232: delete from BNE_STYLESHEETS_TL T

228:
229: procedure ADD_LANGUAGE
230: is
231: begin
232: delete from BNE_STYLESHEETS_TL T
233: where not exists
234: (select NULL
235: from BNE_STYLESHEETS_B B
236: where B.APPLICATION_ID = T.APPLICATION_ID

Line 240: update BNE_STYLESHEETS_TL T set (

236: where B.APPLICATION_ID = T.APPLICATION_ID
237: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
238: );
239:
240: update BNE_STYLESHEETS_TL T set (
241: USER_NAME, DESCRIPTION
242: ) = (select
243: B.USER_NAME,
244: B.DESCRIPTION

Line 245: from BNE_STYLESHEETS_TL B

241: USER_NAME, DESCRIPTION
242: ) = (select
243: B.USER_NAME,
244: B.DESCRIPTION
245: from BNE_STYLESHEETS_TL B
246: where B.APPLICATION_ID = T.APPLICATION_ID
247: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
248: and B.LANGUAGE = T.SOURCE_LANG)
249: where (

Line 257: from BNE_STYLESHEETS_TL SUBB, BNE_STYLESHEETS_TL SUBT

253: ) in (select
254: SUBT.APPLICATION_ID,
255: SUBT.STYLESHEET_CODE,
256: SUBT.LANGUAGE
257: from BNE_STYLESHEETS_TL SUBB, BNE_STYLESHEETS_TL SUBT
258: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
259: and SUBB.STYLESHEET_CODE = SUBT.STYLESHEET_CODE
260: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
261: and (SUBB.USER_NAME <> SUBT.USER_NAME)

Line 265: insert into BNE_STYLESHEETS_TL (

261: and (SUBB.USER_NAME <> SUBT.USER_NAME)
262: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
263: ));
264:
265: insert into BNE_STYLESHEETS_TL (
266: APPLICATION_ID,
267: STYLESHEET_CODE,
268: USER_NAME,
269: DESCRIPTION,

Line 289: from BNE_STYLESHEETS_TL B, FND_LANGUAGES L

285: B.LAST_UPDATE_LOGIN,
286: B.LAST_UPDATE_DATE,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from BNE_STYLESHEETS_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from BNE_STYLESHEETS_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from BNE_STYLESHEETS_TL T
295: where T.APPLICATION_ID = B.APPLICATION_ID
296: and T.STYLESHEET_CODE = B.STYLESHEET_CODE
297: and T.LANGUAGE = L.LANGUAGE_CODE);
298: end ADD_LANGUAGE;

Line 434: from BNE_STYLESHEETS_TL

430: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
431: begin
432: select LAST_UPDATED_BY, LAST_UPDATE_DATE
433: into db_luby, db_ludate
434: from BNE_STYLESHEETS_TL
435: where APPLICATION_ID = l_app_id
436: and STYLESHEET_CODE = x_stylesheet_code
437: and LANGUAGE = userenv('LANG');
438:

Line 443: update BNE_STYLESHEETS_TL

439: -- Test for customization and version
440: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
441: db_ludate, x_custom_mode)) then
442:
443: update BNE_STYLESHEETS_TL
444: set USER_NAME = x_user_name,
445: DESCRIPTION = x_description,
446: LAST_UPDATE_DATE = f_ludate,
447: LAST_UPDATED_BY = f_luby,