APPS.UMX_FGA_UTILS_PKG dependencies on FND_GRANTS

Line 12: update fnd_grants set END_DATE = sysdate,

8: bulk_selection_value varchar2(1);
9:
10: procedure endDate_grants(adminRole varchar2) is
11: begin
12: update fnd_grants set END_DATE = sysdate,
13: LAST_UPDATE_DATE = sysdate,
14: LAST_UPDATED_BY = 1000002,
15: LAST_UPDATE_LOGIN = 1000002
16: where grantee_key = adminRole and

Line 25: from fnd_grants fg,

21: /*******************************************************************************************************************************/
22:
23: procedure convert_All_Grants_to_roleSets is
24: cursor adminRoles is select distinct grantee_key
25: from fnd_grants fg,
26: fnd_objects fo
27: --,fnd_menus fm
28: where --fg.menu_id = fm.menu_id and
29: fg.object_id = fo.object_id

Line 48: from fnd_grants fg,

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
52: where fg.menu_id = fm.menu_id

Line 96: from fnd_grants fg,

92: if(cnt<=0) then
93: begin
94: --For all roles
95: select count(*) into cnt
96: from fnd_grants fg,
97: fnd_objects fo
98: --fnd_menus fm,
99: --wf_all_roles_vl wfr
100: where