DBA Data[Home] [Help]

APPS.AMW_LOAD_PROC_DATA dependencies on AMW_OWNER_ROLES_V

Line 1995: from amw_owner_roles_v

1991: ---check how many owners with the specified Role are already there
1992: ---for the chosen Process
1993: select count(party_name)
1994: into l_count_owners
1995: from amw_owner_roles_v
1996: where role_name=p_role_name
1997: and pk1_value=to_char(p_pk1_value);
1998: exception
1999: when no_data_found then

Line 2010: from amw_owner_roles_v

2006: ---grant and add owner in the main API above
2007: if(l_count_owners = 1)then
2008: select grant_guid
2009: into l_grant_guid
2010: from amw_owner_roles_v
2011: where role_name=p_role_name
2012: and pk1_value=to_char(p_pk1_value);
2013:
2014: amw_security_pub.REVOKE_GRANT(