APPS.PQH_TXH_UPD SQL Statements

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

Line: 54

Procedure update_dml
  (p_rec in out nocopy pqh_txh_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 68

  update pqh_ss_transaction_history
    set
     transaction_history_id          = p_rec.transaction_history_id
    ,creator_person_id               = p_rec.creator_person_id
    ,assignment_id                   = p_rec.assignment_id
    ,selected_person_id              = p_rec.selected_person_id
    ,item_type                       = p_rec.item_type
    ,item_key                        = p_rec.item_key
    ,process_name                    = p_rec.process_name
    ,approval_item_type              = p_rec.approval_item_type
    ,approval_item_key               = p_rec.approval_item_key
    ,function_id                     = p_rec.function_id
    ,rptg_grp_id                     = p_rec.rptg_grp_id
    ,plan_id                         = p_rec.plan_id
    ,transaction_group               = p_rec.transaction_group
    ,transaction_identifier          = p_rec.transaction_identifier
    where transaction_history_id = p_rec.transaction_history_id;

Line: 109

End update_dml;

Line: 143

Procedure pre_update
  (p_rec in pqh_txh_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 153

End pre_update;

Line: 187

Procedure post_update
  (p_rec                          in pqh_txh_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 210

End post_update;

Line: 274

  If (p_rec.selected_person_id = hr_api.g_number) then
    p_rec.selected_person_id :=
    pqh_txh_shd.g_old_rec.selected_person_id;

Line: 346

  pqh_txh_bus.update_validate
     (p_rec
     );

Line: 355

  pqh_txh_upd.pre_update(p_rec);

Line: 359

  pqh_txh_upd.update_dml(p_rec);

Line: 363

  pqh_txh_upd.post_update
     (p_rec
     );

Line: 378

  ,p_selected_person_id           in     number    default hr_api.g_number
  ,p_item_type                    in     varchar2  default hr_api.g_varchar2
  ,p_item_key                     in     varchar2  default hr_api.g_varchar2
  ,p_process_name                 in     varchar2  default hr_api.g_varchar2
  ,p_approval_item_type           in     varchar2  default hr_api.g_varchar2
  ,p_approval_item_key            in     varchar2  default hr_api.g_varchar2
  ,p_function_id                  in     number    default hr_api.g_number
  ,p_rptg_grp_id                  in     number    default hr_api.g_number
  ,p_plan_id                      in     number    default hr_api.g_number
  ,p_transaction_group            in     varchar2  default hr_api.g_varchar2
  ,p_transaction_identifier       in     varchar2  default hr_api.g_varchar2
  ) is
--
  l_rec   pqh_txh_shd.g_rec_type;

Line: 405

  ,p_selected_person_id
  ,p_item_type
  ,p_item_key
  ,p_process_name
  ,p_approval_item_type
  ,p_approval_item_key
  ,p_function_id
  ,p_rptg_grp_id
  ,p_plan_id
  ,p_transaction_group
  ,p_transaction_identifier
  );