APPS.PQH_DOC_SHD SQL Statements

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

Line: 58

    select
     document_id
    ,effective_start_date
    ,effective_end_date
    ,short_name
    ,document_name
    ,file_id
    ,enable_flag
    ,last_updated_by
    ,object_version_number
    ,formula_id
    ,document_category
    /* Added for XDO changes */
    ,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: 136

  ,p_update                 out NOCOPY boolean
  ,p_update_override        out NOCOPY boolean
  ,p_update_change_insert   out NOCOPY boolean
  ) is
--
  l_proc        varchar2(72) := g_package||'find_dt_upd_modes';

Line: 154

    ,p_update                => p_update
    ,p_update_override       => p_update_override
    ,p_update_change_insert  => p_update_change_insert
    );

Line: 169

  ,p_delete                out NOCOPY boolean
  ,p_future_change         out NOCOPY boolean
  ,p_delete_next_change    out NOCOPY boolean
  ) is
  --
  l_proc                varchar2(72)    := g_package||'find_dt_del_modes';

Line: 188

   ,p_delete                        => p_delete
   ,p_future_change                 => p_future_change
   ,p_delete_next_change            => p_delete_next_change
   );

Line: 230

  update  pqh_documents_f t
  set     t.effective_end_date    = p_new_effective_end_date
    ,     t.object_version_number = l_object_version_number
  where   t.document_id        = p_base_key_value
  and     p_effective_date
  between t.effective_start_date and t.effective_end_date;

Line: 269

    select
     document_id
    ,effective_start_date
    ,effective_end_date
    ,short_name
    ,document_name
    ,file_id
    ,enable_flag
    ,last_updated_by
    ,object_version_number
    ,formula_id
    ,document_category
    /* Added for XDO changes */
    ,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
    for update nowait;

Line: 321

  If (p_datetrack_mode <> hr_api.g_insert) then
    --
    -- We must select and lock the current row.
    --
    Open  C_Sel1;

Line: 402

  ,p_last_update_by                 in number
  ,p_object_version_number          in number
  ,p_formula_id                     in number
  ,p_document_category              in varchar2
  /* Added for XDO changes */
  ,p_lob_code                       in varchar2
  ,p_language                       in varchar2
  ,p_territory                      in varchar2
  )
  Return g_rec_type is
--
  l_rec   g_rec_type;

Line: 426

  l_rec.last_update_by                   := p_last_update_by;