APPS.PER_BIL_UPD SQL Statements

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

Line: 54

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

Line: 69

  update hr_summary
  set
  type                              = p_rec.type,
  business_group_id                 = p_rec.business_group_id,
  object_version_number             = p_rec.object_version_number,
  id_value                          = p_rec.id_value,
  fk_value1                         = p_rec.fk_value1,
  fk_value2                         = p_rec.fk_value2,
  fk_value3                         = p_rec.fk_value3,
  text_value1                       = p_rec.text_value1,
  text_value2                       = p_rec.text_value2,
  text_value3                       = p_rec.text_value3,
  text_value4                       = p_rec.text_value4,
  text_value5                       = p_rec.text_value5,
  text_value6                       = p_rec.text_value6,
  text_value7                       = p_rec.text_value7,
  num_value1                        = p_rec.num_value1,
  num_value2                        = p_rec.num_value2,
  num_value3                        = p_rec.num_value3,
  date_value1                       = p_rec.date_value1,
  date_value2                       = p_rec.date_value2,
  date_value3                       = p_rec.date_value3
  where id_value = p_rec.id_value;

Line: 116

End update_dml;

Line: 150

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

Line: 158

End pre_update;

Line: 192

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

Line: 205

    per_bil_rku.after_update
      (
  p_type                          =>p_rec.type
 ,p_business_group_id             =>p_rec.business_group_id
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_id_value                      =>p_rec.id_value
 ,p_fk_value1                     =>p_rec.fk_value1
 ,p_fk_value2                     =>p_rec.fk_value2
 ,p_fk_value3                     =>p_rec.fk_value3
 ,p_text_value1                   =>p_rec.text_value1
 ,p_text_value2                   =>p_rec.text_value2
 ,p_text_value3                   =>p_rec.text_value3
 ,p_text_value4                   =>p_rec.text_value4
 ,p_text_value5                   =>p_rec.text_value5
 ,p_text_value6                   =>p_rec.text_value6
 ,p_text_value7                   =>p_rec.text_value7
 ,p_num_value1                    =>p_rec.num_value1
 ,p_num_value2                    =>p_rec.num_value2
 ,p_num_value3                    =>p_rec.num_value3
 ,p_date_value1                   =>p_rec.date_value1
 ,p_date_value2                   =>p_rec.date_value2
 ,p_date_value3                   =>p_rec.date_value3
 ,p_type_o                        =>per_bil_shd.g_old_rec.type
 ,p_business_group_id_o           =>per_bil_shd.g_old_rec.business_group_id
 ,p_object_version_number_o       =>per_bil_shd.g_old_rec.object_version_number
 ,p_fk_value1_o                   =>per_bil_shd.g_old_rec.fk_value1
 ,p_fk_value2_o                   =>per_bil_shd.g_old_rec.fk_value2
 ,p_fk_value3_o                   =>per_bil_shd.g_old_rec.fk_value3
 ,p_text_value1_o                 =>per_bil_shd.g_old_rec.text_value1
 ,p_text_value2_o                 =>per_bil_shd.g_old_rec.text_value2
 ,p_text_value3_o                 =>per_bil_shd.g_old_rec.text_value3
 ,p_text_value4_o                 =>per_bil_shd.g_old_rec.text_value4
 ,p_text_value5_o                 =>per_bil_shd.g_old_rec.text_value5
 ,p_text_value6_o                 =>per_bil_shd.g_old_rec.text_value6
 ,p_text_value7_o                 =>per_bil_shd.g_old_rec.text_value7
 ,p_num_value1_o                  =>per_bil_shd.g_old_rec.num_value1
 ,p_num_value2_o                  =>per_bil_shd.g_old_rec.num_value2
 ,p_num_value3_o                  =>per_bil_shd.g_old_rec.num_value3
 ,p_date_value1_o                 =>per_bil_shd.g_old_rec.date_value1
 ,p_date_value2_o                 =>per_bil_shd.g_old_rec.date_value2
 ,p_date_value3_o                 =>per_bil_shd.g_old_rec.date_value3
      );

Line: 265

End post_update;

Line: 429

  per_bil_bus.update_validate(p_rec);

Line: 433

  pre_update(p_rec);

Line: 437

  update_dml(p_rec);

Line: 441

  post_update(p_rec);