eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_DOCUMENTS_API SQL Statements

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

Line: 34


select effective_start_date,effective_end_date,short_name,document_name,
file_id,formula_id,object_version_number,document_category,lob_code,language,territory
from pqh_documents_f
where document_id = p_document_id
and p_effective_date between effective_start_date and effective_end_date;

Line: 54


    pqh_documents_api.update_document
    (p_validate             => false
    ,p_effective_date       => p_effective_date+1
    ,p_datetrack_mode       => hr_api.g_update
    ,p_short_name           => l_short_name
    ,p_document_name        => l_document_name
    ,p_file_id              => l_file_id
    ,p_formula_id           => l_formula_id
    ,p_enable_flag          => l_enable_flag
    ,p_document_id          =>  p_document_id
    ,p_document_category    =>  l_document_category
    ,p_object_version_number => p_object_version_number
    ,p_effective_start_date  => l_effective_start_date
    ,p_effective_end_date    => l_effective_end_date
    /* Added for XDO */
    ,p_lob_code              => l_lob_code
    ,p_language              => l_language
    ,p_territory             => l_territory
     );

Line: 296


procedure update_print_document
  (p_validate                       in     boolean  default false
  ,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
  /* Added for XDO changes */
  ,p_lob_code                       in     varchar2
  ,p_language                       in     varchar2
  ,p_territory                      in     varchar2
  ) is
 --
  -- Declare cursors and local variables
  --

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

Line: 330


  savepoint UPDATE_PRINT_DOCUMENT;

Line: 338


    PQH_DOCUMENTS_BK2.update_print_document_b
    (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_id                => p_document_id
    ,p_document_category          => p_document_category
    ,p_object_version_number      => p_object_version_number
    /* Added for XDO changes */
    ,p_lob_code                   => p_lob_code
    ,p_language                   => p_language
    ,p_territory                  => p_territory
    );

Line: 357


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

Line: 389


    PQH_DOCUMENTS_BK2.update_print_document_a
    (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_id                => p_document_id
    ,p_document_category          => p_document_category
    ,p_object_version_number      => p_object_version_number
    ,p_effective_start_date       => l_effective_start_date
    ,p_effective_end_date         => l_effective_end_date
    /* Added for XDO changes */
    ,p_lob_code                   => p_lob_code
    ,p_language                   => p_language
    ,p_territory                  => p_territory
    );

Line: 410


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

Line: 435


    rollback to UPDATE_PRINT_DOCUMENT;

Line: 456


    rollback to UPDATE_PRINT_DOCUMENT;

Line: 459


end update_print_document;

Line: 462


procedure update_document
  (p_validate                       in     boolean  default false
  ,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
  /* Added for XDO changes */
  ,p_lob_code                       in     varchar2
  ,p_language                       in     varchar2
  ,p_territory                      in     varchar2
  ) is

begin
update_print_document
  (p_validate                       => p_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_id                    => p_document_id
  ,p_document_category              => p_document_category
  ,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: 503


end update_document;

Line: 535


procedure delete_print_document
  (p_validate                       in     boolean  default false
  ,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
  )
  is
    --
    -- Declare cursors and local variables
    --

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

Line: 559


    savepoint DELETE_PRINT_DOCUMENT;

Line: 568


   PQH_DOCUMENTS_BK3.delete_print_document_b
    (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
    );

Line: 577


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

Line: 599


   PQH_DOCUMENTS_BK3.delete_print_document_a
       (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      => l_effective_start_date
       ,p_effective_end_date        => l_effective_end_date
    );

Line: 610


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

Line: 633


      rollback to DELETE_PRINT_DOCUMENT;

Line: 652


      rollback to DELETE_PRINT_DOCUMENT;

Line: 656


 end delete_print_document;

Line: 659


procedure delete_document
  (p_validate                       in     boolean  default false
  ,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
  ) is

begin

 if ( p_datetrack_mode = hr_api.g_delete) then
    create_dummy_rec(
       p_document_id => p_document_id,
       p_object_version_number => p_object_version_number,
       p_effective_date        => p_effective_date);

Line: 677


    delete_print_document
      (p_validate                       => p_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: 688


end delete_document;