eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_SECURITY_GROUPS_PKG dependencies on FND_SECURITY_GROUPS_TL

Line 125: from fnd_security_groups_tl

121:
122: begin
123: select LAST_UPDATED_BY, LAST_UPDATE_DATE
124: into db_luby, db_ludate
125: from fnd_security_groups_tl
126: where security_group_id = (select security_group_id
127: from fnd_security_groups
128: where security_group_key = X_SECURITY_GROUP_KEY)
129: and LANGUAGE = userenv('LANG');

Line 133: update fnd_security_groups_tl set

129: and LANGUAGE = userenv('LANG');
130:
131: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
132: db_ludate, X_CUSTOM_MODE)) then
133: update fnd_security_groups_tl set
134: security_group_name = nvl(X_SECURITY_GROUP_NAME, security_group_name),
135: description = nvl(X_DESCRIPTION, description),
136: source_lang = userenv('LANG'),
137: last_update_date = f_ludate,

Line 189: insert into FND_SECURITY_GROUPS_TL (

185:
186: -- Added for Function Security Cache Invalidation Project
187: fnd_function_security_cache.insert_secgrp(X_SECURITY_GROUP_ID);
188:
189: insert into FND_SECURITY_GROUPS_TL (
190: SECURITY_GROUP_ID,
191: SECURITY_GROUP_NAME,
192: DESCRIPTION,
193: CREATED_BY,

Line 215: from FND_SECURITY_GROUPS_TL T

211: from FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and not exists
214: (select NULL
215: from FND_SECURITY_GROUPS_TL T
216: where T.SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
217: and T.LANGUAGE = L.LANGUAGE_CODE);
218:
219: -- Bug3813798 Moved this call to happen after the translation table

Line 254: from FND_SECURITY_GROUPS_TL

250: cursor c1 is select
251: SECURITY_GROUP_NAME,
252: DESCRIPTION,
253: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
254: from FND_SECURITY_GROUPS_TL
255: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
256: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
257: for update of SECURITY_GROUP_ID nowait;
258: begin

Line 306: from FND_SECURITY_GROUPS_TL

302: begin
303: -- Get the old Security_Group_Name from the d/b for the current session
304: select SECURITY_GROUP_NAME
305: into p_security_group_name
306: from FND_SECURITY_GROUPS_TL
307: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
308: and LANGUAGE = userenv('LANG');
309:
310: exception

Line 332: update FND_SECURITY_GROUPS_TL set

328: fnd_function_security_cache.update_secgrp(X_SECURITY_GROUP_ID);
329:
330: end if;
331:
332: update FND_SECURITY_GROUPS_TL set
333: SECURITY_GROUP_NAME = X_SECURITY_GROUP_NAME,
334: DESCRIPTION = X_DESCRIPTION,
335: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
336: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 377: delete from FND_SECURITY_GROUPS_TL

373: procedure DELETE_ROW (
374: X_SECURITY_GROUP_ID in NUMBER
375: ) is
376: begin
377: delete from FND_SECURITY_GROUPS_TL
378: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID;
379:
380: if (sql%notfound) then
381: raise no_data_found;

Line 406: delete from FND_SECURITY_GROUPS_TL T

402: /* as a quick workaround to fix the time-consuming table handler issue */
403: /* Eventually we'll need to turn them into a separate fix_language procedure */
404: /*
405:
406: delete from FND_SECURITY_GROUPS_TL T
407: where not exists
408: (select NULL
409: from FND_SECURITY_GROUPS B
410: where B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID

Line 413: update FND_SECURITY_GROUPS_TL T set (

409: from FND_SECURITY_GROUPS B
410: where B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
411: );
412:
413: update FND_SECURITY_GROUPS_TL T set (
414: SECURITY_GROUP_NAME,
415: DESCRIPTION
416: ) = (select
417: B.SECURITY_GROUP_NAME,

Line 419: from FND_SECURITY_GROUPS_TL B

415: DESCRIPTION
416: ) = (select
417: B.SECURITY_GROUP_NAME,
418: B.DESCRIPTION
419: from FND_SECURITY_GROUPS_TL B
420: where B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
421: and B.LANGUAGE = T.SOURCE_LANG)
422: where (
423: T.SECURITY_GROUP_ID,

Line 428: from FND_SECURITY_GROUPS_TL SUBB, FND_SECURITY_GROUPS_TL SUBT

424: T.LANGUAGE
425: ) in (select
426: SUBT.SECURITY_GROUP_ID,
427: SUBT.LANGUAGE
428: from FND_SECURITY_GROUPS_TL SUBB, FND_SECURITY_GROUPS_TL SUBT
429: where SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
430: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
431: and (SUBB.SECURITY_GROUP_NAME <> SUBT.SECURITY_GROUP_NAME
432: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 438: insert into FND_SECURITY_GROUPS_TL (

434: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
435: ));
436: */
437:
438: insert into FND_SECURITY_GROUPS_TL (
439: SECURITY_GROUP_ID,
440: SECURITY_GROUP_NAME,
441: DESCRIPTION,
442: CREATED_BY,

Line 460: from FND_SECURITY_GROUPS_TL B, FND_LANGUAGES L

456: B.LAST_UPDATE_DATE,
457: B.LAST_UPDATE_LOGIN,
458: L.LANGUAGE_CODE,
459: B.SOURCE_LANG
460: from FND_SECURITY_GROUPS_TL B, FND_LANGUAGES L
461: where L.INSTALLED_FLAG in ('I', 'B')
462: and B.LANGUAGE = userenv('LANG')
463: and not exists
464: (select NULL

Line 465: from FND_SECURITY_GROUPS_TL T

461: where L.INSTALLED_FLAG in ('I', 'B')
462: and B.LANGUAGE = userenv('LANG')
463: and not exists
464: (select NULL
465: from FND_SECURITY_GROUPS_TL T
466: where T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
467: and T.LANGUAGE = L.LANGUAGE_CODE);
468: end ADD_LANGUAGE;
469: