APPS.UMX_FGA_UTILS_PKG dependencies on UMX_LSA_ROLE_SET_ROLES

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 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 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 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