APPS.AMW_SECURITY_UTILS_PVT dependencies on FND_GRANTS

Line 26: l_grant_guid fnd_grants.grant_guid%type;

22: l_api_name constant varchar2(30) := 'give_dependant_grants';
23:
24:
25:
26: l_grant_guid fnd_grants.grant_guid%type;
27:
28:
29:
30: l_default_name constant varchar2(80) := 'AMW_AUTOMATIC_DEPENDANT_GRANT';

Line 69: fnd_grants_pkg.grant_function(p_api_version => g_api_version,

65: l_child_role_name := t_ctbl(ctr).child_role_name;
66: end if;
67:
68:
69: fnd_grants_pkg.grant_function(p_api_version => g_api_version,
70: p_menu_name => l_child_role_name,
71: p_object_name => t_ctbl(ctr).child_obj_name,
72: p_instance_type => 'SET',
73: p_instance_set_id => t_ctbl(ctr).child_instance_set_id,

Line 123: l_grant_guid fnd_grants.grant_guid%type;

119: l_start_date date;
120:
121:
122:
123: l_grant_guid fnd_grants.grant_guid%type;
124: type t_guid is table of fnd_grants.grant_guid%type;
125: guid_tbl t_guid;
126:
127: cursor c_guid

Line 124: type t_guid is table of fnd_grants.grant_guid%type;

120:
121:
122:
123: l_grant_guid fnd_grants.grant_guid%type;
124: type t_guid is table of fnd_grants.grant_guid%type;
125: guid_tbl t_guid;
126:
127: cursor c_guid
128: is select grant_guid from fnd_grants where

Line 128: is select grant_guid from fnd_grants where

124: type t_guid is table of fnd_grants.grant_guid%type;
125: guid_tbl t_guid;
126:
127: cursor c_guid
128: is select grant_guid from fnd_grants where
129: parameter10 = p_grant_guid;
130:
131:
132:

Line 153: fnd_grants_pkg.update_grant(p_api_version => g_api_version,

149: if guid_tbl.exists(1) then
150: for i in guid_tbl.first .. guid_tbl.last loop
151:
152:
153: fnd_grants_pkg.update_grant(p_api_version => g_api_version,
154: p_grant_guid => guid_tbl(i),
155: p_start_date => l_start_date,
156: p_end_date => p_new_end_date,
157: x_success => x_success);

Line 176: l_grant_guid fnd_grants.grant_guid%type;

172: is
173: l_api_name constant varchar2(30) := 'revoke_dependant_grants';
174:
175:
176: l_grant_guid fnd_grants.grant_guid%type;
177: type t_guid is table of fnd_grants.grant_guid%type;
178: guid_tbl t_guid;
179:
180: cursor c_guid

Line 177: type t_guid is table of fnd_grants.grant_guid%type;

173: l_api_name constant varchar2(30) := 'revoke_dependant_grants';
174:
175:
176: l_grant_guid fnd_grants.grant_guid%type;
177: type t_guid is table of fnd_grants.grant_guid%type;
178: guid_tbl t_guid;
179:
180: cursor c_guid
181: is select grant_guid from fnd_grants where

Line 181: is select grant_guid from fnd_grants where

177: type t_guid is table of fnd_grants.grant_guid%type;
178: guid_tbl t_guid;
179:
180: cursor c_guid
181: is select grant_guid from fnd_grants where
182: parameter10 = p_grant_guid;
183:
184:
185: begin

Line 195: fnd_grants_pkg.revoke_grant(p_api_version => g_api_version,

191: if guid_tbl.exists(1) then
192: for i in guid_tbl.first .. guid_tbl.last loop
193:
194:
195: fnd_grants_pkg.revoke_grant(p_api_version => g_api_version,
196: p_grant_guid => guid_tbl(i),
197: x_success => x_success,
198: x_errorcode => x_errorcode);
199: