APPS.PER_BIL_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from hr_summary
  where id_value = p_rec.id_value;

Line: 78

End delete_dml;

Line: 112

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

Line: 120

End pre_delete;

Line: 154

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

Line: 167

    per_bil_rkd.after_delete
      (
  p_id_value                      =>p_rec.id_value
 ,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: 207

End post_delete;

Line: 232

  per_bil_bus.delete_validate(p_rec);

Line: 236

  pre_delete(p_rec);

Line: 240

  delete_dml(p_rec);

Line: 244

  post_delete(p_rec);