APPS.BNE_STYLESHEETS_PKG dependencies on BNE_STYLESHEETS_TL

Line 48: insert into BNE_STYLESHEETS_TL (

44: X_LAST_UPDATED_BY,
45: X_LAST_UPDATE_LOGIN
46: );
47:
48: insert into BNE_STYLESHEETS_TL (
49: APPLICATION_ID,
50: STYLESHEET_CODE,
51: USER_NAME,
52: DESCRIPTION,

Line 76: from BNE_STYLESHEETS_TL T

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

Line 113: from BNE_STYLESHEETS_TL

109:
110: cursor c1 is select
111: USER_NAME, DESCRIPTION,
112: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
113: from BNE_STYLESHEETS_TL
114: where APPLICATION_ID = X_APPLICATION_ID
115: and STYLESHEET_CODE = X_STYLESHEET_CODE
116: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
117: for update of APPLICATION_ID nowait;

Line 182: update BNE_STYLESHEETS_TL set

178: if (sql%notfound) then
179: raise no_data_found;
180: end if;
181:
182: update BNE_STYLESHEETS_TL set
183: USER_NAME = X_USER_NAME,
184: DESCRIPTION = X_DESCRIPTION,
185: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 203: delete from BNE_STYLESHEETS_TL

199: X_APPLICATION_ID in NUMBER,
200: X_STYLESHEET_CODE in VARCHAR2
201: ) is
202: begin
203: delete from BNE_STYLESHEETS_TL
204: where APPLICATION_ID = X_APPLICATION_ID
205: and STYLESHEET_CODE = X_STYLESHEET_CODE;
206:
207: if (sql%notfound) then

Line 223: delete from BNE_STYLESHEETS_TL T

219:
220: procedure ADD_LANGUAGE
221: is
222: begin
223: delete from BNE_STYLESHEETS_TL T
224: where not exists
225: (select NULL
226: from BNE_STYLESHEETS_B B
227: where B.APPLICATION_ID = T.APPLICATION_ID

Line 231: update BNE_STYLESHEETS_TL T set (

227: where B.APPLICATION_ID = T.APPLICATION_ID
228: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
229: );
230:
231: update BNE_STYLESHEETS_TL T set (
232: USER_NAME, DESCRIPTION
233: ) = (select
234: B.USER_NAME,
235: B.DESCRIPTION

Line 236: from BNE_STYLESHEETS_TL B

232: USER_NAME, DESCRIPTION
233: ) = (select
234: B.USER_NAME,
235: B.DESCRIPTION
236: from BNE_STYLESHEETS_TL B
237: where B.APPLICATION_ID = T.APPLICATION_ID
238: and B.STYLESHEET_CODE = T.STYLESHEET_CODE
239: and B.LANGUAGE = T.SOURCE_LANG)
240: where (

Line 248: from BNE_STYLESHEETS_TL SUBB, BNE_STYLESHEETS_TL SUBT

244: ) in (select
245: SUBT.APPLICATION_ID,
246: SUBT.STYLESHEET_CODE,
247: SUBT.LANGUAGE
248: from BNE_STYLESHEETS_TL SUBB, BNE_STYLESHEETS_TL SUBT
249: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
250: and SUBB.STYLESHEET_CODE = SUBT.STYLESHEET_CODE
251: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
252: and (SUBB.USER_NAME <> SUBT.USER_NAME)

Line 256: insert into BNE_STYLESHEETS_TL (

252: and (SUBB.USER_NAME <> SUBT.USER_NAME)
253: and (SUBB.DESCRIPTION <> SUBT.DESCRIPTION
254: ));
255:
256: insert into BNE_STYLESHEETS_TL (
257: APPLICATION_ID,
258: STYLESHEET_CODE,
259: USER_NAME,
260: DESCRIPTION,

Line 280: from BNE_STYLESHEETS_TL B, FND_LANGUAGES L

276: B.LAST_UPDATE_LOGIN,
277: B.LAST_UPDATE_DATE,
278: L.LANGUAGE_CODE,
279: B.SOURCE_LANG
280: from BNE_STYLESHEETS_TL B, FND_LANGUAGES L
281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL

Line 285: from BNE_STYLESHEETS_TL T

281: where L.INSTALLED_FLAG in ('I', 'B')
282: and B.LANGUAGE = userenv('LANG')
283: and not exists
284: (select NULL
285: from BNE_STYLESHEETS_TL T
286: where T.APPLICATION_ID = B.APPLICATION_ID
287: and T.STYLESHEET_CODE = B.STYLESHEET_CODE
288: and T.LANGUAGE = L.LANGUAGE_CODE);
289: end ADD_LANGUAGE;

Line 422: from BNE_STYLESHEETS_TL

418: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
419: begin
420: select LAST_UPDATED_BY, LAST_UPDATE_DATE
421: into db_luby, db_ludate
422: from BNE_STYLESHEETS_TL
423: where APPLICATION_ID = l_app_id
424: and STYLESHEET_CODE = x_stylesheet_code
425: and LANGUAGE = userenv('LANG');
426:

Line 431: update BNE_STYLESHEETS_TL

427: -- Test for customization and version
428: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
429: db_ludate, x_custom_mode)) then
430:
431: update BNE_STYLESHEETS_TL
432: set USER_NAME = x_user_name,
433: DESCRIPTION = x_description,
434: LAST_UPDATE_DATE = f_ludate,
435: LAST_UPDATED_BY = f_luby,