DBA Data[Home] [Help]

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