DBA Data[Home] [Help]

APPS.PA_SECURITY_PVT dependencies on FND_OBJECT_INSTANCE_SETS

Line 13: G_project_roles_ins_set_name FND_OBJECT_INSTANCE_SETS.instance_set_name%TYPE := 'PA_PROJECT_ROLES';

9: G_debug_flag varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
10: G_source_type_id NUMBER;
11: G_project_system_status_code VARCHAR2(30) := '';
12: G_project_roles_ins_set_id NUMBER;
13: G_project_roles_ins_set_name FND_OBJECT_INSTANCE_SETS.instance_set_name%TYPE := 'PA_PROJECT_ROLES';
14:
15: l_api_version number :=1.0;
16: l_errorcode number;
17:

Line 1620: from fnd_object_instance_sets

1616: l_api_name varchar2(30):='get_instance_set_id';
1617: l_set_id number;
1618: begin
1619: select instance_set_id into l_set_id
1620: from fnd_object_instance_sets
1621: where instance_set_name=p_set_name;
1622: return l_set_id;
1623: exception
1624: when no_data_found then

Line 2132: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,

2128: END check_access_exist;
2129:
2130: PROCEDURE check_grant_exists(p_project_role_id in NUMBER,
2131: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,
2132: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,
2133: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,
2134: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,
2135: x_instance_set_id out NOCOPY NUMBER, --File.Sql.39 bug 4440895
2136: x_ret_code out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895