APPS.BNE_MAPPINGS_PKG dependencies on BNE_MAPPINGS_TL

Line 56: insert into BNE_MAPPINGS_TL (

52: X_LAST_UPDATED_BY,
53: X_LAST_UPDATE_LOGIN
54: );
55:
56: insert into BNE_MAPPINGS_TL (
57: LAST_UPDATED_BY,
58: LAST_UPDATE_LOGIN,
59: LAST_UPDATE_DATE,
60: APPLICATION_ID,

Line 82: from BNE_MAPPINGS_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from BNE_MAPPINGS_TL T
83: where T.APPLICATION_ID = X_APPLICATION_ID
84: and T.MAPPING_CODE = X_MAPPING_CODE
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:

Line 124: from BNE_MAPPINGS_TL

120:
121: cursor c1 is select
122: USER_NAME,
123: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
124: from BNE_MAPPINGS_TL
125: where APPLICATION_ID = X_APPLICATION_ID
126: and MAPPING_CODE = X_MAPPING_CODE
127: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
128: for update of APPLICATION_ID nowait;

Line 199: update BNE_MAPPINGS_TL set

195: if (sql%notfound) then
196: raise no_data_found;
197: end if;
198:
199: update BNE_MAPPINGS_TL set
200: USER_NAME = X_USER_NAME,
201: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
202: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
203: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 219: delete from BNE_MAPPINGS_TL

215: X_APPLICATION_ID in NUMBER,
216: X_MAPPING_CODE in VARCHAR2
217: ) is
218: begin
219: delete from BNE_MAPPINGS_TL
220: where APPLICATION_ID = X_APPLICATION_ID
221: and MAPPING_CODE = X_MAPPING_CODE;
222:
223: if (sql%notfound) then

Line 239: delete from BNE_MAPPINGS_TL T

235:
236: procedure ADD_LANGUAGE
237: is
238: begin
239: delete from BNE_MAPPINGS_TL T
240: where not exists
241: (select NULL
242: from BNE_MAPPINGS_B B
243: where B.APPLICATION_ID = T.APPLICATION_ID

Line 247: update BNE_MAPPINGS_TL T set (

243: where B.APPLICATION_ID = T.APPLICATION_ID
244: and B.MAPPING_CODE = T.MAPPING_CODE
245: );
246:
247: update BNE_MAPPINGS_TL T set (
248: USER_NAME
249: ) = (select
250: B.USER_NAME
251: from BNE_MAPPINGS_TL B

Line 251: from BNE_MAPPINGS_TL B

247: update BNE_MAPPINGS_TL T set (
248: USER_NAME
249: ) = (select
250: B.USER_NAME
251: from BNE_MAPPINGS_TL B
252: where B.APPLICATION_ID = T.APPLICATION_ID
253: and B.MAPPING_CODE = T.MAPPING_CODE
254: and B.LANGUAGE = T.SOURCE_LANG)
255: where (

Line 263: from BNE_MAPPINGS_TL SUBB, BNE_MAPPINGS_TL SUBT

259: ) in (select
260: SUBT.APPLICATION_ID,
261: SUBT.MAPPING_CODE,
262: SUBT.LANGUAGE
263: from BNE_MAPPINGS_TL SUBB, BNE_MAPPINGS_TL SUBT
264: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
265: and SUBB.MAPPING_CODE = SUBT.MAPPING_CODE
266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 270: insert into BNE_MAPPINGS_TL (

266: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
267: and (SUBB.USER_NAME <> SUBT.USER_NAME
268: ));
269:
270: insert into BNE_MAPPINGS_TL (
271: LAST_UPDATED_BY,
272: LAST_UPDATE_LOGIN,
273: LAST_UPDATE_DATE,
274: APPLICATION_ID,

Line 292: from BNE_MAPPINGS_TL B, FND_LANGUAGES L

288: B.CREATED_BY,
289: B.CREATION_DATE,
290: L.LANGUAGE_CODE,
291: B.SOURCE_LANG
292: from BNE_MAPPINGS_TL B, FND_LANGUAGES L
293: where L.INSTALLED_FLAG in ('I', 'B')
294: and B.LANGUAGE = userenv('LANG')
295: and not exists
296: (select NULL

Line 297: from BNE_MAPPINGS_TL T

293: where L.INSTALLED_FLAG in ('I', 'B')
294: and B.LANGUAGE = userenv('LANG')
295: and not exists
296: (select NULL
297: from BNE_MAPPINGS_TL T
298: where T.APPLICATION_ID = B.APPLICATION_ID
299: and T.MAPPING_CODE = B.MAPPING_CODE
300: and T.LANGUAGE = L.LANGUAGE_CODE);
301: end ADD_LANGUAGE;

Line 343: from BNE_MAPPINGS_TL

339: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
340: begin
341: select LAST_UPDATED_BY, LAST_UPDATE_DATE
342: into db_luby, db_ludate
343: from BNE_MAPPINGS_TL
344: where APPLICATION_ID = l_app_id
345: and MAPPING_CODE = x_mapping_code
346: and LANGUAGE = userenv('LANG');
347:

Line 352: update BNE_MAPPINGS_TL

348: -- Test for customization and version
349: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
350: db_ludate, x_custom_mode)) then
351:
352: update BNE_MAPPINGS_TL
353: set USER_NAME = x_user_name,
354: LAST_UPDATE_DATE = f_ludate,
355: LAST_UPDATED_BY = f_luby,
356: LAST_UPDATE_LOGIN = 0,