APPS.PQH_TCA_UPD SQL Statements

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

Line: 48

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

Line: 62

  update pqh_txn_category_attributes
  set
  txn_category_attribute_id         = p_rec.txn_category_attribute_id,
  attribute_id                      = p_rec.attribute_id,
  transaction_category_id           = p_rec.transaction_category_id,
  value_set_id                      = p_rec.value_set_id,
  object_version_number             = p_rec.object_version_number,
  transaction_table_route_id        = p_rec.transaction_table_route_id,
  form_column_name                  = p_rec.form_column_name,
  identifier_flag                   = p_rec.identifier_flag,
  list_identifying_flag             = p_rec.list_identifying_flag,
  member_identifying_flag           = p_rec.member_identifying_flag,
  refresh_flag                      = p_rec.refresh_flag,
  select_flag                       = p_rec.select_flag,
  value_style_cd                    = p_rec.value_style_cd
  where txn_category_attribute_id = p_rec.txn_category_attribute_id;

Line: 97

End update_dml;

Line: 131

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

Line: 139

End pre_update;

Line: 173

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

Line: 186

    pqh_tca_rku.after_update
      (
  p_txn_category_attribute_id     =>p_rec.txn_category_attribute_id
 ,p_attribute_id                  =>p_rec.attribute_id
 ,p_transaction_category_id       =>p_rec.transaction_category_id
 ,p_value_set_id                  =>p_rec.value_set_id
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_transaction_table_route_id    =>p_rec.transaction_table_route_id
 ,p_form_column_name              =>p_rec.form_column_name
 ,p_identifier_flag               =>p_rec.identifier_flag
 ,p_list_identifying_flag         =>p_rec.list_identifying_flag
 ,p_member_identifying_flag       =>p_rec.member_identifying_flag
 ,p_refresh_flag                  =>p_rec.refresh_flag
 ,p_select_flag                   =>p_rec.select_flag
 ,p_value_style_cd                =>p_rec.value_style_cd
 ,p_effective_date                =>p_effective_date
 ,p_attribute_id_o                =>pqh_tca_shd.g_old_rec.attribute_id
 ,p_transaction_category_id_o     =>pqh_tca_shd.g_old_rec.transaction_category_id
 ,p_value_set_id_o                =>pqh_tca_shd.g_old_rec.value_set_id
 ,p_object_version_number_o       =>pqh_tca_shd.g_old_rec.object_version_number
 ,p_transaction_table_route_id_o  =>pqh_tca_shd.g_old_rec.transaction_table_route_id
 ,p_form_column_name_o            =>pqh_tca_shd.g_old_rec.form_column_name
 ,p_identifier_flag_o             =>pqh_tca_shd.g_old_rec.identifier_flag
 ,p_list_identifying_flag_o       =>pqh_tca_shd.g_old_rec.list_identifying_flag
 ,p_member_identifying_flag_o     =>pqh_tca_shd.g_old_rec.member_identifying_flag
 ,p_refresh_flag_o                =>pqh_tca_shd.g_old_rec.refresh_flag
 ,p_select_flag_o                =>pqh_tca_shd.g_old_rec.select_flag
 ,p_value_style_cd_o              =>pqh_tca_shd.g_old_rec.value_style_cd
      );

Line: 230

End post_update;

Line: 324

  If (p_rec.select_flag = hr_api.g_varchar2) then
    p_rec.select_flag :=
    pqh_tca_shd.g_old_rec.select_flag;

Line: 344

  p_delete_attr_ranges_flag in varchar2
  ) is
--
  l_proc  varchar2(72) := g_package||'upd';

Line: 367

  pqh_tca_bus.update_validate(p_rec
  ,p_effective_date,p_delete_attr_ranges_flag);

Line: 372

  pre_update(p_rec);

Line: 376

  update_dml(p_rec);

Line: 380

  post_update(
p_effective_date,p_rec);

Line: 401

  p_select_flag                  in varchar2         default hr_api.g_varchar2,
  p_value_style_cd               in varchar2         default hr_api.g_varchar2
  ,p_delete_attr_ranges_flag      in varchar2         default hr_api.g_varchar2
  ) is
--
  l_rec	  pqh_tca_shd.g_rec_type;

Line: 429

  p_select_flag,
  p_value_style_cd
  );

Line: 438

    p_effective_date,l_rec,p_delete_attr_ranges_flag);