APPS.UMX_FGA_UTILS_PKG dependencies on UMX_LSA_ROLE_SET_CRITERIA_S

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