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 1609: from fnd_object_instance_sets

1605: l_api_name varchar2(30):='get_instance_set_id';
1606: l_set_id number;
1607: begin
1608: select instance_set_id into l_set_id
1609: from fnd_object_instance_sets
1610: where instance_set_name=p_set_name;
1611: return l_set_id;
1612: exception
1613: when no_data_found then

Line 2121: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,

2117: END check_access_exist;
2118:
2119: PROCEDURE check_grant_exists(p_project_role_id in NUMBER,
2120: p_instance_type in fnd_grants.INSTANCE_TYPE%TYPE,
2121: p_instance_set_name in fnd_object_instance_sets.instance_set_name%TYPE,
2122: p_grantee_type in fnd_grants.GRANTEE_TYPE%TYPE,
2123: p_grantee_key in fnd_grants.GRANTEE_KEY%TYPE,
2124: x_instance_set_id out NOCOPY NUMBER, --File.Sql.39 bug 4440895
2125: x_ret_code out NOCOPY VARCHAR2 --File.Sql.39 bug 4440895