APPS.BNE_DUPLICATE_PROFILES_PKG dependencies on BNE_DUPLICATE_PROFILES_TL

Line 47: insert into BNE_DUPLICATE_PROFILES_TL (

43: X_LAST_UPDATED_BY,
44: X_LAST_UPDATE_LOGIN
45: );
46:
47: insert into BNE_DUPLICATE_PROFILES_TL (
48: CREATED_BY,
49: CREATION_DATE,
50: LAST_UPDATED_BY,
51: LAST_UPDATE_LOGIN,

Line 73: from BNE_DUPLICATE_PROFILES_TL T

69: from FND_LANGUAGES L
70: where L.INSTALLED_FLAG in ('I', 'B')
71: and not exists
72: (select NULL
73: from BNE_DUPLICATE_PROFILES_TL T
74: where T.APPLICATION_ID = X_APPLICATION_ID
75: and T.DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
76: and T.LANGUAGE = L.LANGUAGE_CODE);
77:

Line 109: from BNE_DUPLICATE_PROFILES_TL

105:
106: cursor c1 is select
107: USER_NAME,
108: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
109: from BNE_DUPLICATE_PROFILES_TL
110: where APPLICATION_ID = X_APPLICATION_ID
111: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE
112: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
113: for update of APPLICATION_ID nowait;

Line 173: update BNE_DUPLICATE_PROFILES_TL set

169: if (sql%notfound) then
170: raise no_data_found;
171: end if;
172:
173: update BNE_DUPLICATE_PROFILES_TL set
174: USER_NAME = X_USER_NAME,
175: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
176: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
177: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 193: delete from BNE_DUPLICATE_PROFILES_TL

189: X_APPLICATION_ID in NUMBER,
190: X_DUP_PROFILE_CODE in VARCHAR2
191: ) is
192: begin
193: delete from BNE_DUPLICATE_PROFILES_TL
194: where APPLICATION_ID = X_APPLICATION_ID
195: and DUP_PROFILE_CODE = X_DUP_PROFILE_CODE;
196:
197: if (sql%notfound) then

Line 213: delete from BNE_DUPLICATE_PROFILES_TL T

209:
210: procedure ADD_LANGUAGE
211: is
212: begin
213: delete from BNE_DUPLICATE_PROFILES_TL T
214: where not exists
215: (select NULL
216: from BNE_DUPLICATE_PROFILES_B B
217: where B.APPLICATION_ID = T.APPLICATION_ID

Line 221: update BNE_DUPLICATE_PROFILES_TL T set (

217: where B.APPLICATION_ID = T.APPLICATION_ID
218: and B.DUP_PROFILE_CODE = T.DUP_PROFILE_CODE
219: );
220:
221: update BNE_DUPLICATE_PROFILES_TL T set (
222: USER_NAME
223: ) = (select
224: B.USER_NAME
225: from BNE_DUPLICATE_PROFILES_TL B

Line 225: from BNE_DUPLICATE_PROFILES_TL B

221: update BNE_DUPLICATE_PROFILES_TL T set (
222: USER_NAME
223: ) = (select
224: B.USER_NAME
225: from BNE_DUPLICATE_PROFILES_TL B
226: where B.APPLICATION_ID = T.APPLICATION_ID
227: and B.DUP_PROFILE_CODE = T.DUP_PROFILE_CODE
228: and B.LANGUAGE = T.SOURCE_LANG)
229: where (

Line 237: from BNE_DUPLICATE_PROFILES_TL SUBB, BNE_DUPLICATE_PROFILES_TL SUBT

233: ) in (select
234: SUBT.APPLICATION_ID,
235: SUBT.DUP_PROFILE_CODE,
236: SUBT.LANGUAGE
237: from BNE_DUPLICATE_PROFILES_TL SUBB, BNE_DUPLICATE_PROFILES_TL SUBT
238: where SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
239: and SUBB.DUP_PROFILE_CODE = SUBT.DUP_PROFILE_CODE
240: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
241: and (SUBB.USER_NAME <> SUBT.USER_NAME

Line 244: insert into BNE_DUPLICATE_PROFILES_TL (

240: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
241: and (SUBB.USER_NAME <> SUBT.USER_NAME
242: ));
243:
244: insert into BNE_DUPLICATE_PROFILES_TL (
245: CREATED_BY,
246: CREATION_DATE,
247: LAST_UPDATED_BY,
248: LAST_UPDATE_LOGIN,

Line 266: from BNE_DUPLICATE_PROFILES_TL B, FND_LANGUAGES L

262: B.DUP_PROFILE_CODE,
263: B.USER_NAME,
264: L.LANGUAGE_CODE,
265: B.SOURCE_LANG
266: from BNE_DUPLICATE_PROFILES_TL B, FND_LANGUAGES L
267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL

Line 271: from BNE_DUPLICATE_PROFILES_TL T

267: where L.INSTALLED_FLAG in ('I', 'B')
268: and B.LANGUAGE = userenv('LANG')
269: and not exists
270: (select NULL
271: from BNE_DUPLICATE_PROFILES_TL T
272: where T.APPLICATION_ID = B.APPLICATION_ID
273: and T.DUP_PROFILE_CODE = B.DUP_PROFILE_CODE
274: and T.LANGUAGE = L.LANGUAGE_CODE);
275: end ADD_LANGUAGE;

Line 316: from BNE_DUPLICATE_PROFILES_TL

312: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
313: begin
314: select LAST_UPDATED_BY, LAST_UPDATE_DATE
315: into db_luby, db_ludate
316: from BNE_DUPLICATE_PROFILES_TL
317: where APPLICATION_ID = l_app_id
318: and DUP_PROFILE_CODE = x_dup_profile_code
319: and LANGUAGE = userenv('LANG');
320:

Line 325: update BNE_DUPLICATE_PROFILES_TL

321: -- Test for customization and version
322: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
323: db_ludate, x_custom_mode)) then
324:
325: update BNE_DUPLICATE_PROFILES_TL
326: set USER_NAME = x_user_name,
327: LAST_UPDATE_DATE = f_ludate,
328: LAST_UPDATED_BY = f_luby,
329: LAST_UPDATE_LOGIN = 0,