APPS.AME_APPROVER_TYPE_API SQL Statements

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

Line: 141

procedure delete_ame_approver_type
  (p_validate                   in      boolean  default false
  ,p_approver_type_id           in      number
  ,p_object_version_number      in out  nocopy   number
  ,p_start_date                    out  nocopy   date
  ,p_end_date                      out  nocopy   date
  ) is
  --
  -- Declare cursors and local variables
  --
  cursor attribute_cur(p_approver_type_id in number,
                           p_effective_date in date) is
    select attribute_id, object_version_number
      from ame_attributes
      where
        approver_type_id = p_approver_type_id
        and p_effective_date
        between start_date and nvl(end_date - ame_util.oneSecond, p_effective_date);

Line: 160

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

Line: 193

  savepoint delete_ame_approver_type;

Line: 201

    ame_approver_type_bk2.delete_ame_approver_type_b
      (p_approver_type_id        => p_approver_type_id
      ,p_object_version_number   => p_object_version_number
      );

Line: 208

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

Line: 218

                 ,p_datetrack_mode        => hr_api.g_delete
                 ,p_object_version_number => l_apt_object_version_number
                 ,p_effective_date        => sysdate
                 ,p_start_date            => l_apt_start_date
                 ,p_end_date              => l_apt_end_date
                 );

Line: 228

     ame_approver_type_bk2.delete_ame_approver_type_a
      (p_approver_type_id        => p_approver_type_id
      ,p_object_version_number   => l_apt_object_version_number
      ,p_start_date              => l_apt_start_date
      ,p_end_date                => l_apt_end_date
      );

Line: 236

        hr_api.cannot_find_prog_unit_error(p_module_name => 'delete_ame_approver_type'
                                          ,p_hook_type   => 'AP'
                                          );

Line: 254

    ROLLBACK TO delete_ame_approver_type;

Line: 269

    ROLLBACK TO delete_ame_approver_type;

Line: 274

end delete_ame_approver_type;