DBA Data[Home] [Help]

APPS.OZF_CLAIM_UTILITY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 65

l_access varchar2(1) :='N';  --  F : FULL: User can update sensitive metric data
Line: 101

   l_access :=AMS_access_PVT.check_update_access(
      p_object_id         => P_object_id,
      p_object_type       => P_object_type,
      p_user_or_role_id   => p_user_id,
      p_user_or_role_type => 'USER'
   );
Line: 111

      l_profile_value :=  NVL(fnd_profile.value('OZF_CLAIM_UPDATE_ACCESS'), 'VIEW');
Line: 112

      IF l_profile_value = 'UPDATE' THEN
              x_access := 'R';
Line: 120

      OZF_Utility_PVT.debug_message('user_id='||p_user_id||' update_access is '||l_access);