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

Line 1: package body FND_SECURITY_GROUPS_PKG as

1: package body FND_SECURITY_GROUPS_PKG as
2: /* $Header: AFSCGRPB.pls 120.2 2006/02/13 01:55:15 stadepal ship $ */
3:
4:
5: -- Overloaded. This is the obsolete old version.

Line 13: fnd_security_groups_pkg.LOAD_ROW (

9: X_SECURITY_GROUP_NAME in VARCHAR2,
10: X_DESCRIPTION in VARCHAR2) is
11: begin
12:
13: fnd_security_groups_pkg.LOAD_ROW (
14: X_SECURITY_GROUP_KEY => X_SECURITY_GROUP_KEY,
15: X_OWNER => X_OWNER,
16: X_SECURITY_GROUP_NAME => X_SECURITY_GROUP_NAME,
17: X_DESCRIPTION => X_DESCRIPTION,

Line 49: from fnd_security_groups

45:
46: begin
47: select security_group_id,LAST_UPDATED_BY, LAST_UPDATE_DATE
48: into sgroup_id, db_luby, db_ludate
49: from fnd_security_groups
50: where security_group_key = X_SECURITY_GROUP_KEY;
51:
52: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
53: db_ludate, X_CUSTOM_MODE)) then

Line 54: fnd_security_groups_pkg.UPDATE_ROW (

50: where security_group_key = X_SECURITY_GROUP_KEY;
51:
52: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
53: db_ludate, X_CUSTOM_MODE)) then
54: fnd_security_groups_pkg.UPDATE_ROW (
55: X_SECURITY_GROUP_ID => sgroup_id,
56: X_SECURITY_GROUP_KEY => X_SECURITY_GROUP_KEY,
57: X_SECURITY_GROUP_NAME => X_SECURITY_GROUP_NAME,
58: X_DESCRIPTION => X_DESCRIPTION,

Line 66: select fnd_security_groups_s.nextval into sgroup_id from dual;

62: end if;
63: exception
64: when NO_DATA_FOUND then
65:
66: select fnd_security_groups_s.nextval into sgroup_id from dual;
67:
68: fnd_security_groups_pkg.INSERT_ROW (
69: X_ROWID => row_id,
70: X_SECURITY_GROUP_ID => sgroup_id,

Line 68: fnd_security_groups_pkg.INSERT_ROW (

64: when NO_DATA_FOUND then
65:
66: select fnd_security_groups_s.nextval into sgroup_id from dual;
67:
68: fnd_security_groups_pkg.INSERT_ROW (
69: X_ROWID => row_id,
70: X_SECURITY_GROUP_ID => sgroup_id,
71: X_SECURITY_GROUP_KEY => X_SECURITY_GROUP_KEY,
72: X_SECURITY_GROUP_NAME => X_SECURITY_GROUP_NAME,

Line 90: FND_SECURITY_GROUPS_PKG.translate_row(

86: X_SECURITY_GROUP_NAME in VARCHAR2,
87: X_DESCRIPTION in VARCHAR2) is
88: begin
89:
90: FND_SECURITY_GROUPS_PKG.translate_row(
91: x_security_group_key => x_security_group_key,
92: x_owner => x_owner,
93: x_security_group_name => x_security_group_name,
94: x_description => x_description,

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 127: from fnd_security_groups

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');
130:
131: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

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 141: from fnd_security_groups

137: last_update_date = f_ludate,
138: last_updated_by = f_luby,
139: last_update_login = 0
140: where security_group_id = (select security_group_id
141: from fnd_security_groups
142: where security_group_key = X_SECURITY_GROUP_KEY)
143: and userenv('LANG') in (language, source_lang);
144: end if;
145: exception

Line 164: cursor C is select ROWID from FND_SECURITY_GROUPS

160: X_LAST_UPDATE_DATE in DATE,
161: X_LAST_UPDATED_BY in NUMBER,
162: X_LAST_UPDATE_LOGIN in NUMBER
163: ) is
164: cursor C is select ROWID from FND_SECURITY_GROUPS
165: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
166: ;
167: begin
168: insert into FND_SECURITY_GROUPS (

Line 168: insert into FND_SECURITY_GROUPS (

164: cursor C is select ROWID from FND_SECURITY_GROUPS
165: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
166: ;
167: begin
168: insert into FND_SECURITY_GROUPS (
169: SECURITY_GROUP_ID,
170: SECURITY_GROUP_KEY,
171: CREATION_DATE,
172: CREATED_BY,

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 245: from FND_SECURITY_GROUPS

241: X_DESCRIPTION in VARCHAR2
242: ) is
243: cursor c is select
244: SECURITY_GROUP_KEY
245: from FND_SECURITY_GROUPS
246: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
247: for update of SECURITY_GROUP_ID nowait;
248: recinfo c%rowtype;
249:

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 315: update FND_SECURITY_GROUPS set

311: when no_data_found then
312: raise no_data_found;
313: end;
314:
315: update FND_SECURITY_GROUPS set
316: SECURITY_GROUP_KEY = X_SECURITY_GROUP_KEY,
317: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
318: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
319: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

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 384: delete from FND_SECURITY_GROUPS

380: if (sql%notfound) then
381: raise no_data_found;
382: end if;
383:
384: delete from FND_SECURITY_GROUPS
385: where SECURITY_GROUP_ID = X_SECURITY_GROUP_ID;
386:
387: if (sql%notfound) then
388: 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 409: from FND_SECURITY_GROUPS B

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
411: );
412:
413: update FND_SECURITY_GROUPS_TL T set (

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:

Line 470: end FND_SECURITY_GROUPS_PKG;

466: where T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
467: and T.LANGUAGE = L.LANGUAGE_CODE);
468: end ADD_LANGUAGE;
469:
470: end FND_SECURITY_GROUPS_PKG;