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_DOC_UPD SQL Statements

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

Line: 57


Procedure dt_update_dml
  (p_rec                   in out NOCOPY pqh_doc_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'dt_update_dml';

Line: 87


    update  pqh_documents_f
    set
     document_id                          = p_rec.document_id
    ,short_name                           = p_rec.short_name
    ,document_name                        = p_rec.document_name
    ,file_id                              = p_rec.file_id
    ,enable_flag                          = p_rec.enable_flag
    ,last_updated_by                       = p_rec.last_update_by
    ,object_version_number                = p_rec.object_version_number
    ,formula_id                           = p_rec.formula_id
    ,document_category                    = p_rec.document_category
    /* Added for XDO changes */
    ,lob_code                             = p_rec.lob_code
    ,language                             = p_rec.language
    ,territory                            = p_rec.territory
    where   document_id = p_rec.document_id
    and     effective_start_date = p_validation_start_date
    and     effective_end_date   = p_validation_end_date;

Line: 129


End dt_update_dml;

Line: 162


Procedure update_dml
  (p_rec                      in out NOCOPY pqh_doc_shd.g_rec_type
  ,p_effective_date           in date
  ,p_datetrack_mode           in varchar2
  ,p_validation_start_date    in date
  ,p_validation_end_date      in date
  ) is
--
  l_proc        varchar2(72) := g_package||'update_dml';

Line: 175


  pqh_doc_upd.dt_update_dml
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => p_datetrack_mode
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date   => p_validation_end_date
    );

Line: 184


End update_dml;

Line: 229


Procedure dt_pre_update
  (p_rec                     in out NOCOPY     pqh_doc_shd.g_rec_type
  ,p_effective_date          in date
  ,p_datetrack_mode          in varchar2
  ,p_validation_start_date   in date
  ,p_validation_end_date     in date
  ) is
--
  l_proc                 varchar2(72) := g_package||'dt_pre_update';

Line: 255


    If (p_datetrack_mode = hr_api.g_update_override) then
      --
      -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
      -- delete any future rows
      --
      pqh_doc_del.delete_dml
        (p_rec                   => p_rec
        ,p_effective_date        => p_effective_date
        ,p_datetrack_mode        => p_datetrack_mode
        ,p_validation_start_date => p_validation_start_date
        ,p_validation_end_date   => p_validation_end_date
        );

Line: 271


    pqh_doc_ins.insert_dml
      (p_rec                    => p_rec
      ,p_effective_date         => p_effective_date
      ,p_datetrack_mode         => p_datetrack_mode
      ,p_validation_start_date  => p_validation_start_date
      ,p_validation_end_date    => p_validation_end_date
      );

Line: 280


End dt_pre_update;

Line: 314


Procedure pre_update
  (p_rec                   in out NOCOPY pqh_doc_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'pre_update';

Line: 329


  dt_pre_update
    (p_rec                   => p_rec
    ,p_effective_date        => p_effective_date
    ,p_datetrack_mode        => p_datetrack_mode
    ,p_validation_start_date => p_validation_start_date
    ,p_validation_end_date   => p_validation_end_date
    );

Line: 338


End pre_update;

Line: 372


Procedure post_update
  (p_rec                   in pqh_doc_shd.g_rec_type
  ,p_effective_date        in date
  ,p_datetrack_mode        in varchar2
  ,p_validation_start_date in date
  ,p_validation_end_date   in date
  ) is
--
  l_proc        varchar2(72) := g_package||'post_update';

Line: 386


    pqh_doc_rku.after_update
      (p_effective_date
      => p_effective_date
      ,p_datetrack_mode
      => p_datetrack_mode
      ,p_validation_start_date
      => p_validation_start_date
      ,p_validation_end_date
      => p_validation_end_date
      ,p_document_id
      => p_rec.document_id
      ,p_effective_start_date
      => p_rec.effective_start_date
      ,p_effective_end_date
      => p_rec.effective_end_date
      ,p_short_name
      => p_rec.short_name
      ,p_document_name
      => p_rec.document_name
      ,p_file_id
      => p_rec.file_id
      ,p_document_category
      => p_rec.document_category
      ,p_enable_flag
      => p_rec.enable_flag
      ,p_last_update_by
      => p_rec.last_update_by
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_formula_id
      => p_rec.formula_id
      /* Added for XDO Changes. */
      ,p_lob_code
      => p_rec.lob_code
      ,p_language
      => p_rec.language
      ,p_territory
      => p_rec.territory
      ,p_effective_start_date_o
      => pqh_doc_shd.g_old_rec.effective_start_date
      ,p_effective_end_date_o
      => pqh_doc_shd.g_old_rec.effective_end_date
      ,p_short_name_o
      => pqh_doc_shd.g_old_rec.short_name
      ,p_document_name_o
      => pqh_doc_shd.g_old_rec.document_name
      ,p_file_id_o
      => pqh_doc_shd.g_old_rec.file_id
      ,p_enable_flag_o
      => pqh_doc_shd.g_old_rec.enable_flag
      ,p_last_update_by_o
      => pqh_doc_shd.g_old_rec.last_update_by
      ,p_object_version_number_o
      => pqh_doc_shd.g_old_rec.object_version_number
      ,p_formula_id_o
      => pqh_doc_shd.g_old_rec.formula_id
      ,p_document_category_o
      => pqh_doc_shd.g_old_rec.document_category
      /* Added for XDO Changes. */
      ,p_lob_code_o
      => pqh_doc_shd.g_old_rec.lob_code
      ,p_language_o
      => pqh_doc_shd.g_old_rec.language
      ,p_territory_o
      => pqh_doc_shd.g_old_rec.territory
      );

Line: 464


End post_update;

Line: 536


  If (p_rec.last_update_by = hr_api.g_number) then
    p_rec.last_update_by :=
    pqh_doc_shd.g_old_rec.last_update_by;

Line: 603


  pqh_doc_bus.update_validate
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );

Line: 616


  pre_update
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );

Line: 626


  update_dml
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date                  => l_validation_end_date
    );

Line: 636


  post_update
    (p_rec                              => p_rec
    ,p_effective_date                   => p_effective_date
    ,p_datetrack_mode                   => p_datetrack_mode
    ,p_validation_start_date            => l_validation_start_date
    ,p_validation_end_date              => l_validation_end_date
    );

Line: 661


  ,p_last_update_by               in     number    default hr_api.g_number
  ,p_document_category            in     varchar2  default hr_api.g_varchar2
  ,p_effective_start_date            out NOCOPY date
  ,p_effective_end_date              out NOCOPY date
  /* Added for XDO changes */
  ,p_lob_code                     in     varchar2  default hr_api.g_varchar2
  ,p_language                     in     varchar2  default hr_api.g_varchar2
  ,p_territory                    in     varchar2  default hr_api.g_varchar2
  ) is
--
  l_rec         pqh_doc_shd.g_rec_type;

Line: 689


    ,p_last_update_by
    ,p_object_version_number
    ,p_formula_id
    ,p_document_category
    /* Added for XDO changes */
    ,p_lob_code
    ,p_language
    ,p_territory
    );