APPS.BNE_COMPONENTS_PKG dependencies on BNE_COMPONENTS_TL

Line 50: insert into BNE_COMPONENTS_TL (

46: X_LAST_UPDATED_BY,
47: X_LAST_UPDATE_LOGIN
48: );
49:
50: insert into BNE_COMPONENTS_TL (
51: LAST_UPDATED_BY,
52: LAST_UPDATE_LOGIN,
53: LAST_UPDATE_DATE,
54: APPLICATION_ID,

Line 76: from BNE_COMPONENTS_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_COMPONENTS_TL T
77: where T.APPLICATION_ID = X_APPLICATION_ID
78: and T.COMPONENT_CODE = X_COMPONENT_CODE
79: and T.LANGUAGE = L.LANGUAGE_CODE);
80:

Line 114: from BNE_COMPONENTS_TL

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

Line 183: update BNE_COMPONENTS_TL set

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: update BNE_COMPONENTS_TL set
184: USER_NAME = X_USER_NAME,
185: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
186: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
187: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 203: delete from BNE_COMPONENTS_TL

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

Line 223: delete from BNE_COMPONENTS_TL T

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

Line 231: update BNE_COMPONENTS_TL T set (

227: where B.APPLICATION_ID = T.APPLICATION_ID
228: and B.COMPONENT_CODE = T.COMPONENT_CODE
229: );
230:
231: update BNE_COMPONENTS_TL T set (
232: USER_NAME
233: ) = (select
234: B.USER_NAME
235: from BNE_COMPONENTS_TL B

Line 235: from BNE_COMPONENTS_TL B

231: update BNE_COMPONENTS_TL T set (
232: USER_NAME
233: ) = (select
234: B.USER_NAME
235: from BNE_COMPONENTS_TL B
236: where B.APPLICATION_ID = T.APPLICATION_ID
237: and B.COMPONENT_CODE = T.COMPONENT_CODE
238: and B.LANGUAGE = T.SOURCE_LANG)
239: where (

Line 247: from BNE_COMPONENTS_TL SUBB, BNE_COMPONENTS_TL SUBT

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

Line 254: insert into BNE_COMPONENTS_TL (

250: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
251: and (SUBB.USER_NAME <> SUBT.USER_NAME
252: ));
253:
254: insert into BNE_COMPONENTS_TL (
255: LAST_UPDATED_BY,
256: LAST_UPDATE_LOGIN,
257: LAST_UPDATE_DATE,
258: APPLICATION_ID,

Line 276: from BNE_COMPONENTS_TL B, FND_LANGUAGES L

272: B.CREATED_BY,
273: B.CREATION_DATE,
274: L.LANGUAGE_CODE,
275: B.SOURCE_LANG
276: from BNE_COMPONENTS_TL B, FND_LANGUAGES L
277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL

Line 281: from BNE_COMPONENTS_TL T

277: where L.INSTALLED_FLAG in ('I', 'B')
278: and B.LANGUAGE = userenv('LANG')
279: and not exists
280: (select NULL
281: from BNE_COMPONENTS_TL T
282: where T.APPLICATION_ID = B.APPLICATION_ID
283: and T.COMPONENT_CODE = B.COMPONENT_CODE
284: and T.LANGUAGE = L.LANGUAGE_CODE);
285: end ADD_LANGUAGE;

Line 418: from BNE_COMPONENTS_TL

414: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
415: begin
416: select LAST_UPDATED_BY, LAST_UPDATE_DATE
417: into db_luby, db_ludate
418: from BNE_COMPONENTS_TL
419: where APPLICATION_ID = l_app_id
420: and COMPONENT_CODE = x_component_code
421: and LANGUAGE = userenv('LANG');
422:

Line 427: update BNE_COMPONENTS_TL

423: -- Test for customization and version
424: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
425: db_ludate, x_custom_mode)) then
426:
427: update BNE_COMPONENTS_TL
428: set USER_NAME = x_user_name,
429: LAST_UPDATE_DATE = f_ludate,
430: LAST_UPDATED_BY = f_luby,
431: LAST_UPDATE_LOGIN = 0,