APPS.UMX_FGA_UTILS_PKG dependencies on UMX_LSA_ROLE_SET_CRITERIA

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