DBA Data[Home] [Help]

APPS.UMX_FGA_UTILS_PKG dependencies on UMX_LSA_ROLE_GLOBAL_PRIVS

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,