APPS.IRC_LOCATION_CRITERIA_VAL_API SQL Statements

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

Line: 123

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

Line: 137

  savepoint DELETE_LOCATION_CRITERIA;

Line: 142

    IRC_LOCATION_CRITERIA_VAL_BK2.DELETE_LOCATION_CRITERIA_B
      (p_location_criteria_value_id    => p_location_criteria_value_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 149

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

Line: 167

    IRC_LOCATION_CRITERIA_VAL_BK2.DELETE_LOCATION_CRITERIA_A
      (p_location_criteria_value_id    => p_location_criteria_value_id
      ,p_object_version_number         => p_object_version_number
      );

Line: 174

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

Line: 194

    rollback to DELETE_LOCATION_CRITERIA;

Line: 205

    rollback to DELETE_LOCATION_CRITERIA;

Line: 212

end DELETE_LOCATION_CRITERIA;