APPS.PAY_TIME_DEF_USAGE_API SQL Statements

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

Line: 128

procedure delete_time_def_usage
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_time_definition_id            in     number
  ,p_usage_type                    in     varchar2
  ,p_object_version_number         in     number
  )is
  --
  -- Declare cursors and local variables
  --
  l_effective_date      date;

Line: 139

  l_proc                varchar2(72) := g_package||'delete_time_def_usage';

Line: 145

  savepoint delete_time_def_usage;

Line: 156

    pay_time_def_usage_bk3.delete_time_def_usage_b
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_usage_type                    => p_usage_type
      ,p_object_version_number         => p_object_version_number
      );

Line: 165

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

Line: 184

    pay_time_def_usage_bk3.delete_time_def_usage_a
      (p_effective_date                => l_effective_date
      ,p_time_definition_id            => p_time_definition_id
      ,p_usage_type                    => p_usage_type
      ,p_object_version_number         => p_object_version_number
      );

Line: 193

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

Line: 211

    rollback to delete_time_def_usage;

Line: 218

    rollback to delete_time_def_usage;

Line: 222

end delete_time_def_usage;