eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_SECURITY_PVT dependencies on FND_GRANTS

Line 118: ---Revoke_grant deletes a specific record in fnd_grants, which has the unique combination of

114: --p_party_id,p_source_type,p_start_date
115:
116: ---Procedure Description:
117: ---Update_role only updates the start date and end date
118: ---Revoke_grant deletes a specific record in fnd_grants, which has the unique combination of
119: ---p_role_name,p_object_name,p_object_key_type,p_object_key,p_party_id,p_source_type,p_start_date
120: ---Revoke_role deletes the records in fnd_grants , which have the combintion of
121: ---p_role_name,p_object_name,,p_object_key_type,p_object_key,p_party_id,p_source_type.
122: ---no matter what the start_date is.

Line 120: ---Revoke_role deletes the records in fnd_grants , which have the combintion of

116: ---Procedure Description:
117: ---Update_role only updates the start date and end date
118: ---Revoke_grant deletes a specific record in fnd_grants, which has the unique combination of
119: ---p_role_name,p_object_name,p_object_key_type,p_object_key,p_party_id,p_source_type,p_start_date
120: ---Revoke_role deletes the records in fnd_grants , which have the combintion of
121: ---p_role_name,p_object_name,,p_object_key_type,p_object_key,p_party_id,p_source_type.
122: ---no matter what the start_date is.
123: PROCEDURE grant_org_authority
124: (

Line 246: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'

242:
243: FUNCTION get_proj_role_name(p_project_role_id in number) return varchar2;
244: Function get_party_id return number;
245: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
246: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
247: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
248: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
249: ,p_party_id IN NUMBER
250: ) RETURN BOOLEAN;

Line 248: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE

244: Function get_party_id return number;
245: FUNCTION is_role_exists ( p_object_name IN FND_OBJECTS.OBJ_NAME%TYPE
246: ,p_object_key_type IN FND_GRANTS.INSTANCE_TYPE%TYPE DEFAULT 'INSTANCE'
247: ,p_role_id IN FND_MENUS.MENU_ID%TYPE
248: ,p_object_key IN FND_GRANTS.INSTANCE_PK1_VALUE%TYPE
249: ,p_party_id IN NUMBER
250: ) RETURN BOOLEAN;
251:
252: --------FUNCTION check_user_privilege

Line 281: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,

277: FUNCTION get_resource_type_id return NUMBER;
278: FUNCTION get_project_system_status_code return VARCHAR2;
279:
280: PROCEDURE check_grant_exists(p_project_role_id in NUMBER,
281: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,
282: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,
283: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,
284: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,
285: x_instance_set_id out NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 283: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,

279:
280: PROCEDURE check_grant_exists(p_project_role_id in NUMBER,
281: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,
282: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,
283: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,
284: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,
285: x_instance_set_id out NOCOPY NUMBER, --File.Sql.39 bug 4440895
286: x_ret_code out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
287: );

Line 284: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,

280: PROCEDURE check_grant_exists(p_project_role_id in NUMBER,
281: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,
282: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,
283: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,
284: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,
285: x_instance_set_id out NOCOPY NUMBER, --File.Sql.39 bug 4440895
286: x_ret_code out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
287: );
288: