APPS.HR_DOCUMENT_TYPES_API SQL Statements

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

Line: 28

  ,p_program_update_date            in     date     default sysdate
  ,p_document_type_id               out nocopy number
  ,p_object_version_number          out nocopy number
  ) IS
  -- Declare cursors and local variables
  --
    l_proc			varchar2(72) := g_package||'create_document_type';

Line: 65

      ,p_program_update_date           => p_program_update_date
  );

Line: 106

      ,p_program_update_date           => p_program_update_date
      ,p_document_type_id              => l_document_type_id
      ,p_object_version_number         => l_object_version_number
  );

Line: 149

      ,p_program_update_date           => p_program_update_date
      ,p_object_version_number         => l_document_type_id
);

Line: 207

procedure update_document_type(
  p_validate                     in     boolean  default false
 ,p_effective_date               in     date     default sysdate
 ,p_language_code                IN     VARCHAR2  DEFAULT hr_api.userenv_lang
 ,p_description                  in     varchar2
 ,p_document_type                in     varchar2
 ,p_document_type_id             in     number
 ,p_object_version_number        in out nocopy number
 ,p_category_code                in     varchar2
 ,p_active_inactive_flag         in     varchar2
 ,p_multiple_occurences_flag     in     varchar2
 ,p_legislation_code             in     varchar2  default hr_api.g_varchar2
 ,p_authorization_required       in     varchar2
 ,p_sub_category_code            in     varchar2  default hr_api.g_varchar2
 ,p_warning_period               in     number    default hr_api.g_number
 ,p_request_id                   in     number    default hr_api.g_number
 ,p_program_application_id       in     number    default hr_api.g_number
 ,p_program_id                   in     number    default hr_api.g_number
 ,p_program_update_date          in     date      default hr_api.g_date
) IS
--
--
  -- Declare cursors and local variables
  --
  l_proc                  varchar2(72) := g_package||'update_document_type';

Line: 240

  savepoint update_document_type;

Line: 245

    hr_document_types_bk2.update_document_type_b(
          p_effective_date                => p_effective_date
         ,p_category_code                 => p_category_code
         ,p_document_type                 => p_document_type
         ,p_language_code                 => p_language_code
         ,p_description                   => p_description
         ,p_active_inactive_flag          => p_active_inactive_flag
         ,p_multiple_occurences_flag      => p_multiple_occurences_flag
         ,p_authorization_required        => p_authorization_required
         ,p_sub_category_code             => p_sub_category_code
         ,p_legislation_code              => p_legislation_code
         ,p_warning_period                => p_warning_period
         ,p_request_id                    => p_request_id
         ,p_program_application_id        => p_program_application_id
         ,p_program_id                    => p_program_id
         ,p_program_update_date           => p_program_update_date
         ,p_document_type_id              => p_document_type_id
         ,p_object_version_number         => p_object_version_number
);

Line: 267

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

Line: 295

         ,p_program_update_date           => p_program_update_date
         ,p_document_type_id              => p_document_type_id
         ,p_object_version_number         => p_object_version_number
         );

Line: 313

    hr_document_types_bk2.update_document_type_a(
           p_effective_date                => p_effective_date
          ,p_category_code                 => p_category_code
          ,p_document_type                 => p_document_type
          ,p_language_code                 => p_language_code
          ,p_description                   => p_description
          ,p_active_inactive_flag          => p_active_inactive_flag
          ,p_multiple_occurences_flag      => p_multiple_occurences_flag
          ,p_authorization_required        => p_authorization_required
          ,p_sub_category_code             => p_sub_category_code
          ,p_legislation_code              => p_legislation_code
          ,p_warning_period                => p_warning_period
          ,p_request_id                    => p_request_id
          ,p_program_application_id        => p_program_application_id
          ,p_program_id                    => p_program_id
          ,p_program_update_date           => p_program_update_date
          ,p_document_type_id              => p_document_type_id
          ,p_object_version_number         => p_object_version_number
    );

Line: 335

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

Line: 355

        ROLLBACK TO update_document_type;

Line: 369

        ROLLBACK TO update_document_type;

Line: 377

    end update_document_type;

Line: 384

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

Line: 399

  savepoint delete_document_type;

Line: 404

    hr_document_types_bk3.delete_document_type_b
      (p_document_type_id           => p_document_type_id,
       p_object_version_number      => p_object_version_number
      );

Line: 411

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

Line: 436

    hr_document_types_bk3.delete_document_type_a
      (p_document_type_id          => p_document_type_id,
       p_object_version_number     => p_object_version_number
      );

Line: 443

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

Line: 463

    ROLLBACK TO delete_person_extra_info;

Line: 471

    ROLLBACK TO delete_document_type;

Line: 475

end delete_document_type;