APPS.HR_TRN_UPD SQL Statements

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

Line: 55

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

Line: 67

  update hr_api_transactions
  set
  transaction_id                  = p_rec.transaction_id,
  creator_person_id               = p_rec.creator_person_id,
  transaction_privilege           = p_rec.transaction_privilege,
  product_code                    = p_rec.product_code,
  url                             = p_rec.url,
  status                          = p_rec.status,
  transaction_state               = p_rec.transaction_state,    --ns
  section_display_name            = p_rec.section_display_name,
  function_id                     = p_rec.function_id,
  transaction_ref_table           = p_rec.transaction_ref_table,
  transaction_ref_id              = p_rec.transaction_ref_id,
  transaction_type                = p_rec.transaction_type,
  assignment_id                   = p_rec.assignment_id,
  api_addtnl_info                 = p_rec.api_addtnl_info,
  selected_person_id              = p_rec.selected_person_id,
  item_type                       = p_rec.item_type,
  item_key                        = p_rec.item_key,
  transaction_effective_date      = p_rec.transaction_effective_date,
  process_name                    = p_rec.process_name,
  plan_id                         = p_rec.plan_id,
  rptg_grp_id                     = p_rec.rptg_grp_id,
  effective_date_option           = p_rec.effective_date_option,
  parent_transaction_id           = p_rec.parent_transaction_id,
  relaunch_function               = p_rec.relaunch_function,
  transaction_group               = p_rec.transaction_group,
  transaction_identifier          = p_rec.transaction_identifier,
  transaction_document            = p_rec.transaction_document

  where transaction_id = p_rec.transaction_id;

Line: 124

End update_dml;

Line: 158

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

Line: 166

End pre_update;

Line: 200

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

Line: 208

End post_update;

Line: 344

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

Line: 451

  hr_trn_bus.update_validate(p_rec);

Line: 455

  pre_update(p_rec);

Line: 459

  update_dml(p_rec);

Line: 463

  post_update(p_rec);

Line: 539

  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_transaction_effective_date   in date             default hr_api.g_date,
  p_process_name                 in varchar2         default hr_api.g_varchar2,
  p_plan_id                      in number           default hr_api.g_number,
  p_rptg_grp_id                  in number           default hr_api.g_number,
  p_effective_date_option        in varchar2         default hr_api.g_varchar2,
  p_creator_role                 in varchar2         default hr_api.g_varchar2,
  p_last_update_role             in varchar2         default hr_api.g_varchar2,
  p_parent_transaction_id        in number           default hr_api.g_number,
  p_relaunch_function            in varchar2         default hr_api.g_varchar2,
  p_transaction_group            in varchar2         default hr_api.g_varchar2,
  p_transaction_identifier       in varchar2         default hr_api.g_varchar2,
  p_transaction_document         in clob             default NULL
  ) is
  --
  -- p_plan_id, p_rptg_grp_id, p_effective_date_option added by sanej
--
  l_rec   hr_trn_shd.g_rec_type;

Line: 586

  p_selected_person_id,
  p_item_type,
  p_item_key,
  p_transaction_effective_date,
  p_process_name,
  p_plan_id,
  p_rptg_grp_id,
  p_effective_date_option,
  p_creator_role,
  p_last_update_role,
  p_parent_transaction_id,
  p_relaunch_function,
  p_transaction_group,
  p_transaction_identifier,
  p_transaction_document
  );