APPS.IRC_PROF_AREA_CRITERIA_VAL_API SQL Statements

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

Line: 132

procedure DELETE_PROF_AREA_CRITERIA
  (p_validate                      in     boolean  default false
  ,p_prof_area_criteria_value_id   in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                varchar2(72) := g_package||'DELETE_PROF_AREA_CRITERIA';

Line: 146

  savepoint DELETE_PROF_AREA_CRITERIA;

Line: 151

    IRC_PROF_AREA_CRITERIA_VAL_BK2.DELETE_PROF_AREA_CRITERIA_B
      (p_prof_area_criteria_value_id   => p_prof_area_criteria_value_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 158

        (p_module_name => 'DELETE_PROF_AREA_CRITERIA'
        ,p_hook_type   => 'BP'
        );

Line: 176

    IRC_PROF_AREA_CRITERIA_VAL_BK2.DELETE_PROF_AREA_CRITERIA_A
      (p_prof_area_criteria_value_id   => p_prof_area_criteria_value_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 183

        (p_module_name => 'DELETE_PROF_AREA_CRITERIA'
        ,p_hook_type   => 'AP'
        );

Line: 203

    rollback to DELETE_PROF_AREA_CRITERIA;

Line: 214

    rollback to DELETE_PROF_AREA_CRITERIA;

Line: 221

end DELETE_PROF_AREA_CRITERIA;