APPS.PQH_DOCUMENTS_SWI SQL Statements

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

Line: 145

PROCEDURE delete_document
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_document_id                  in     number
  ,p_object_version_number        in out NOCOPY number
  ,p_effective_start_date            out NOCOPY date
  ,p_effective_end_date              out NOCOPY date
  ,p_return_status                   out NOCOPY varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 163

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

Line: 169

  savepoint delete_document_swi;

Line: 190

  pqh_documents_api.delete_print_document
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_document_id                  => p_document_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    );

Line: 221

    rollback to delete_document_swi;

Line: 238

    rollback to delete_document_swi;

Line: 251

end delete_document;

Line: 255

PROCEDURE update_document
  (p_validate                     in     number    default hr_api.g_false_num
  ,p_effective_date               in     date
  ,p_datetrack_mode               in     varchar2
  ,p_short_name                   in     varchar2  default hr_api.g_varchar2
  ,p_document_name                in     varchar2  default hr_api.g_varchar2
  ,p_file_id                      in     number    default hr_api.g_number
  ,p_formula_id                   in     number    default hr_api.g_number
  ,p_enable_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_document_category            in     varchar2  default hr_api.g_varchar2
  ,p_document_id                  in     number
  ,p_object_version_number        in out NOCOPY number
  ,p_effective_start_date            out NOCOPY date
  ,p_effective_end_date              out NOCOPY date
  ,p_return_status                   out NOCOPY varchar2
  /* Added for XDO changes */
  ,p_lob_code                     in     varchar2
  ,p_language                     in     varchar2
  ,p_territory                    in     varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 283

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

Line: 286

Select file_id exisiting_file_id
from pqh_documents_f
where document_id = p_document_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 293

Select document_attribute_id , object_version_number ,effective_start_date
from pqh_document_attributes_f
where document_id =p_document_id
and effective_start_date > p_effective_date
and document_attribute_id NOT IN (select document_attribute_id
from pqh_document_attributes_f
where document_id =p_document_id
and p_effective_date between effective_start_date and effective_end_date);

Line: 304

Select document_attribute_id , object_version_number
from pqh_document_attributes_f
where document_id =p_document_id
and effective_start_date > p_effective_date
and document_attribute_id IN (select document_attribute_id
from pqh_document_attributes_f
where document_id =p_document_id
and p_effective_date between effective_start_date and effective_end_date);

Line: 315

Select document_attribute_id, object_version_number,effective_start_date
from pqh_document_attributes_f
where document_id = p_document_id
and p_effective_date between effective_start_date and effective_end_date
and effective_end_date = hr_general.end_of_time;

Line: 336

  savepoint update_document_swi;

Line: 380

       pqh_document_attributes_swi.delete_document_attribute
       (
       p_validate => p_validate,
       p_effective_date => l_rec.effective_start_date,
       p_datetrack_mode => 'ZAP' ,
       p_document_attribute_id => l_document_attribute_id,
       p_object_version_number =>  l_ovn ,
       p_effective_start_date => l_esd,
       p_effective_end_date => l_esd,
       p_return_status  => l_return_status
       );

Line: 397

       pqh_document_attributes_swi.delete_document_attribute
       (
       p_validate => p_validate,
       p_effective_date => p_effective_date,
       p_datetrack_mode => 'DELETE' ,
       p_document_attribute_id => l_document_attribute_id,
       p_object_version_number =>  l_ovn ,
       p_effective_start_date => l_esd,
       p_effective_end_date => l_esd,
       p_return_status  => l_return_status
       );

Line: 419

   	 pqh_document_attributes_swi.delete_document_attribute
   	 (
   	 p_validate => p_validate,
   	 p_effective_date => p_effective_date,
   	 p_datetrack_mode => 'ZAP' ,
   	 p_document_attribute_id => l_document_attribute_id,
   	 p_object_version_number =>  l_ovn ,
   	 p_effective_start_date => l_esd,
   	 p_effective_end_date => l_esd,
   	 p_return_status  => l_return_status
   	 );

Line: 431

    	 pqh_document_attributes_swi.delete_document_attribute
       	 (
       	 p_validate => p_validate,
       	 p_effective_date => p_effective_date-1,
       	 p_datetrack_mode => 'DELETE' ,
       	 p_document_attribute_id => l_document_attribute_id,
       	 p_object_version_number =>  l_ovn ,
       	 p_effective_start_date => l_esd,
       	 p_effective_end_date => l_esd,
       	 p_return_status  => l_return_status
   	 );

Line: 452

  pqh_documents_api.update_print_document
    (p_validate                     => l_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => p_datetrack_mode
    ,p_short_name                   => p_short_name
    ,p_document_name                => p_document_name
    ,p_file_id                      => p_file_id
    ,p_formula_id                   => p_formula_id
    ,p_enable_flag                  => p_enable_flag
    ,p_document_category            => p_document_category
    ,p_document_id                  => p_document_id
    ,p_object_version_number        => p_object_version_number
    ,p_effective_start_date         => p_effective_start_date
    ,p_effective_end_date           => p_effective_end_date
    /* Added for XDO changes */
    ,p_lob_code                     => p_lob_code
    ,p_language                     => p_language
    ,p_territory                    => p_territory
    );

Line: 493

    rollback to update_document_swi;

Line: 510

    rollback to update_document_swi;

Line: 523

end update_document;