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.UMX_FGA_UTILS_PKG dependencies on UMX_LSA_ROLE

Line 47: insert into UMX_LSA_ROLE_SET_ROLES (role_set_id, role_name) select roleSetId, INSTANCE_PK1_VALUE

43: /*******************************************************************************************************************************/
44:
45: procedure copy_grants_to_roleSets(adminRole varchar2, roleSetId number) is
46: begin
47: insert into UMX_LSA_ROLE_SET_ROLES (role_set_id, role_name) select roleSetId, INSTANCE_PK1_VALUE
48: from fnd_grants fg,
49: fnd_objects fo,
50: fnd_menus fm,
51: wf_all_roles_vl wfr

Line 79: roleSetId UMX_LSA_ROLE_SET_ROLES.role_set_id%type;

75: c. Add the roles in the grants to the new role set
76: d. Add the roleSet with Id '0' to the adminRole with all the privilages set except assign and revoke
77: */
78: procedure create_roleSet_from_grants(adminRole varchar2) is
79: roleSetId UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
80: cnt number(6);
81: errm varchar2(300) := '';
82: errcode varchar2(100) := '';
83: begin

Line 85: from UMX_LSA_ROLE_SET_CRITERIA ulrsc,

81: errm varchar2(300) := '';
82: errcode varchar2(100) := '';
83: begin
84: select count(*) into cnt
85: from UMX_LSA_ROLE_SET_CRITERIA ulrsc,
86: UMX_LSA_ROLE ulr
87: where ulr.admin_role = adminRole
88: and ulrsc.role_set_id = ulr.role_Set_Id
89: and ulrsc.role_name = '*'

Line 86: UMX_LSA_ROLE ulr

82: errcode varchar2(100) := '';
83: begin
84: select count(*) into cnt
85: from UMX_LSA_ROLE_SET_CRITERIA ulrsc,
86: UMX_LSA_ROLE ulr
87: where ulr.admin_role = adminRole
88: and ulrsc.role_set_id = ulr.role_Set_Id
89: and ulrsc.role_name = '*'
90: and ulrsc.role_appl = '*'

Line 169: select count(*) into cnt from UMX_LSA_ROLE_GLOBAL_PRIVS where admin_role = adminRole;

165: GLOBALPRIV8 number default 1,
166: GLOBALPRIV9 number default 1) is
167: cnt number(2);
168: begin
169: select count(*) into cnt from UMX_LSA_ROLE_GLOBAL_PRIVS where admin_role = adminRole;
170: if(cnt=0) then
171: insert into UMX_LSA_ROLE_GLOBAL_PRIVS(admin_role,
172: can_Create,
173: GLOBAL_PRIV2 ,

Line 171: insert into UMX_LSA_ROLE_GLOBAL_PRIVS(admin_role,

167: cnt number(2);
168: begin
169: select count(*) into cnt from UMX_LSA_ROLE_GLOBAL_PRIVS where admin_role = adminRole;
170: if(cnt=0) then
171: insert into UMX_LSA_ROLE_GLOBAL_PRIVS(admin_role,
172: can_Create,
173: GLOBAL_PRIV2 ,
174: GLOBAL_PRIV3 ,
175: GLOBAL_PRIV4 ,

Line 192: update UMX_LSA_ROLE_GLOBAL_PRIVS set can_Create = canCreate,

188: GLOBALPRIV7 ,
189: GLOBALPRIV8 ,
190: GLOBALPRIV9 );
191: else
192: update UMX_LSA_ROLE_GLOBAL_PRIVS set can_Create = canCreate,
193: GLOBAL_PRIV2 = GLOBALPRIV2,
194: GLOBAL_PRIV3 = GLOBALPRIV3,
195: GLOBAL_PRIV4 = GLOBALPRIV4,
196: GLOBAL_PRIV5 = GLOBALPRIV5,

Line 228: roleSetId UMX_LSA_ROLE_SET_ROLES.role_set_id%type;

224: PRIVILEGE12 number default 1,
225: PRIVILEGE13 number default 1,
226: PRIVILEGE14 number default 1)
227: is
228: roleSetId UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
229: begin
230: roleSetId := create_roleSet_criteria(null,roleSetName,roleName,roleAapl,roleCat);
231: assign_roleSet_to_adminRole(adminRole,roleSetId,
232: canUpdate,

Line 257: roleSetIdNew UMX_LSA_ROLE_SET_ROLES.role_set_id%type;

253: roleName varchar2 default '%',
254: roleAapl varchar2 default null,
255: roleCat varchar2 default null)
256: return number is
257: roleSetIdNew UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
258: roleSetIdOld UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
259: begin
260: --dbms_output.put_line('In create_roleSet_criteria : '||to_char(roleSetId));
261: if(roleSetId is null) then

Line 258: roleSetIdOld UMX_LSA_ROLE_SET_ROLES.role_set_id%type;

254: roleAapl varchar2 default null,
255: roleCat varchar2 default null)
256: return number is
257: roleSetIdNew UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
258: roleSetIdOld UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
259: begin
260: --dbms_output.put_line('In create_roleSet_criteria : '||to_char(roleSetId));
261: if(roleSetId is null) then
262: select UMX_LSA_ROLE_SET_CRITERIA_S.nextval into roleSetIdNew from dual;

Line 262: select UMX_LSA_ROLE_SET_CRITERIA_S.nextval into roleSetIdNew from dual;

258: roleSetIdOld UMX_LSA_ROLE_SET_ROLES.role_set_id%type;
259: begin
260: --dbms_output.put_line('In create_roleSet_criteria : '||to_char(roleSetId));
261: if(roleSetId is null) then
262: select UMX_LSA_ROLE_SET_CRITERIA_S.nextval into roleSetIdNew from dual;
263: --dbms_output.put_line('In if(roleSetId is null) : '||to_char(roleSetIdNew));
264: else
265: begin
266: select role_set_id into roleSetIdOld from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = roleSetId;

Line 266: select role_set_id into roleSetIdOld from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = roleSetId;

262: select UMX_LSA_ROLE_SET_CRITERIA_S.nextval into roleSetIdNew from dual;
263: --dbms_output.put_line('In if(roleSetId is null) : '||to_char(roleSetIdNew));
264: else
265: begin
266: select role_set_id into roleSetIdOld from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = roleSetId;
267: update UMX_LSA_ROLE_SET_CRITERIA set role_set_name = roleSetName,
268: role_name = roleName,
269: role_appl = roleAapl,
270: role_cat = roleCat

Line 267: update UMX_LSA_ROLE_SET_CRITERIA set role_set_name = roleSetName,

263: --dbms_output.put_line('In if(roleSetId is null) : '||to_char(roleSetIdNew));
264: else
265: begin
266: select role_set_id into roleSetIdOld from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = roleSetId;
267: update UMX_LSA_ROLE_SET_CRITERIA set role_set_name = roleSetName,
268: role_name = roleName,
269: role_appl = roleAapl,
270: role_cat = roleCat
271: where role_set_id = roleSetId;

Line 280: insert into UMX_LSA_ROLE_SET_CRITERIA (role_set_id,

276: roleSetIdNew := roleSetId;
277: --dbms_output.put_line('In no_data_found : '||to_char(roleSetIdNew));
278: end;
279: end if;
280: insert into UMX_LSA_ROLE_SET_CRITERIA (role_set_id,
281: role_set_name,
282: role_name,
283: role_appl,
284: role_cat)

Line 316: from UMX_LSA_ROLE

312: is
313: cnt number(10);
314: begin
315: select count(*) into cnt
316: from UMX_LSA_ROLE
317: where admin_role = adminRole
318: and role_set_id = roleSetId;
319: if(cnt=0) then
320: insert into UMX_LSA_ROLE(admin_role, role_set_id,

Line 320: insert into UMX_LSA_ROLE(admin_role, role_set_id,

316: from UMX_LSA_ROLE
317: where admin_role = adminRole
318: and role_set_id = roleSetId;
319: if(cnt=0) then
320: insert into UMX_LSA_ROLE(admin_role, role_set_id,
321: can_update,
322: CAN_CREATE_GRANT,
323: can_alter_hierarchy,
324: can_assign,

Line 351: update UMX_LSA_ROLE set can_update = canUpdate,

347: PRIV12,
348: PRIV13,
349: PRIV14);
350: else
351: update UMX_LSA_ROLE set can_update = canUpdate,
352: CAN_CREATE_GRANT = canManageGrants,
353: can_alter_hierarchy = canAlterHierarchy,
354: can_assign = canAssign,
355: can_revoke = canRevoke,

Line 376: from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = 0;

372: procedure create_all_roles_roleset is
373: cnt number(2);
374: BEGIN
375: select count(*) into cnt
376: from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = 0;
377: EXCEPTION
378: when NO_DATA_FOUND then
379: insert into UMX_LSA_ROLE_SET_CRITERIA(role_set_id,
380: role_set_name,

Line 379: insert into UMX_LSA_ROLE_SET_CRITERIA(role_set_id,

375: select count(*) into cnt
376: from UMX_LSA_ROLE_SET_CRITERIA where role_set_id = 0;
377: EXCEPTION
378: when NO_DATA_FOUND then
379: insert into UMX_LSA_ROLE_SET_CRITERIA(role_set_id,
380: role_set_name,
381: role_name,
382: role_appl,
383: role_cat)

Line 392: insert into umx_lsa_role_set_roles (role_set_id,

388: /*******************************************************************************************************************************/
389:
390: procedure bulk_add_all(p_role_set_id varchar2) is
391: begin
392: insert into umx_lsa_role_set_roles (role_set_id,
393: role_name,
394: CREATED_BY,
395: CREATION_DATE,
396: LAST_UPDATED_BY,

Line 410: umx_lsa_role_set_criteria ulrsc

406: fnd_global.login_id
407: from WF_LOCAL_ROLES wlr,
408: WF_LOCAL_ROLES_TL wlrt,
409: FND_LOOKUP_ASSIGNMENTS cat,
410: umx_lsa_role_set_criteria ulrsc
411: where cat.OBJ_NAME(+) = 'UMX_ACCESS_ROLE'
412: and nvl(cat.LOOKUP_CODE,'%') like ulrsc.role_cat
413: and wlr.name = cat.INSTANCE_PK1_VALUE(+)
414: and cat.INSTANCE_PK2_VALUE is null

Line 429: and not exists (select role_name from UMX_LSA_ROLE_SET_ROLES

425: and wlr.orig_system_id = wlrt.orig_system_id (+)
426: and wlr.name = wlrt.name (+)
427: and wlr.partition_id = wlrt.partition_id (+)
428: and wlrt.language (+) = userenv('LANG')
429: and not exists (select role_name from UMX_LSA_ROLE_SET_ROLES
430: where role_set_id = p_role_set_id
431: and role_name = wlr.name);
432: end;
433:

Line 439: insert into umx_lsa_role_set_roles (role_set_id,

435: /*******************************************************************************************************************************/
436:
437: procedure bulk_add_all_for_new(p_role_set_id varchar2, p_role_name varchar2, p_role_appl varchar2, p_role_cat varchar2) is
438: begin
439: insert into umx_lsa_role_set_roles (role_set_id,
440: role_name,
441: CREATED_BY,
442: CREATION_DATE,
443: LAST_UPDATED_BY,

Line 474: delete from umx_lsa_role_set_roles where role_set_id = p_role_set_id;

470: /*******************************************************************************************************************************/
471:
472: procedure bulk_remove_all(p_role_set_id varchar2) is
473: begin
474: delete from umx_lsa_role_set_roles where role_set_id = p_role_set_id;
475: end;
476: /*******************************************************************************************************************************/
477: /*******************************************************************************************************************************/
478:

Line 481: delete from umx_lsa_role_set_roles

477: /*******************************************************************************************************************************/
478:
479: procedure delete_role_Set(p_role_set_id varchar2,p_admin_role varchar2) is
480: begin
481: delete from umx_lsa_role_set_roles
482: where role_set_id = p_role_set_id;
483:
484: if(p_role_set_id <> 0) then
485: delete from umx_lsa_role_set_criteria

Line 485: delete from umx_lsa_role_set_criteria

481: delete from umx_lsa_role_set_roles
482: where role_set_id = p_role_set_id;
483:
484: if(p_role_set_id <> 0) then
485: delete from umx_lsa_role_set_criteria
486: where role_set_id = p_role_set_id;
487: end if;
488:
489: if(p_admin_role is not null) then

Line 490: delete from umx_lsa_role

486: where role_set_id = p_role_set_id;
487: end if;
488:
489: if(p_admin_role is not null) then
490: delete from umx_lsa_role
491: where role_set_id = p_role_set_id and admin_role = p_admin_role;
492: else
493: delete from umx_lsa_role
494: where role_set_id = p_role_set_id;

Line 493: delete from umx_lsa_role

489: if(p_admin_role is not null) then
490: delete from umx_lsa_role
491: where role_set_id = p_role_set_id and admin_role = p_admin_role;
492: else
493: delete from umx_lsa_role
494: where role_set_id = p_role_set_id;
495: end if;
496: end;
497: /*******************************************************************************************************************************/