DBA Data[Home] [Help]

APPS.AMW_SECURITY_UTILS_PVT dependencies on AMW_SECURITY_ROLE_MAPPINGS

Line 35: from amw_security_role_mappings where parent_obj_name = p_parent_obj_name

31: l_default_description constant varchar2(240) := 'Dependant instance set based grant on child object';
32:
33: cursor c is (select parent_role_name, child_obj_name,
34: child_role_name, child_instance_set_id
35: from amw_security_role_mappings where parent_obj_name = p_parent_obj_name
36: and (parent_role_name = p_parent_role or parent_role_name = 'ANY'));
37:
38:
39: type t_c is table of c%rowtype;

Line 43: l_child_role_name amw_security_role_mappings.child_role_name%type;

39: type t_c is table of c%rowtype;
40: t_ctbl t_c;
41:
42: l_start_date date;
43: l_child_role_name amw_security_role_mappings.child_role_name%type;
44:
45:
46: begin
47: