DBA Data[Home] [Help]

APPS.PER_VGR_DEL SQL Statements

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

Line: 51

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

  delete from per_valid_grades
  where valid_grade_id = p_rec.valid_grade_id;
Line: 78

End delete_dml;
Line: 112

Procedure pre_delete(p_rec in per_vgr_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_vgr_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';
Line: 163

    per_vgr_rkd.after_delete
    (
     p_valid_grade_id               =>p_rec.valid_grade_id
    ,p_business_group_id_o          =>per_vgr_shd.g_old_rec.business_group_id
    ,p_grade_id_o                   =>per_vgr_shd.g_old_rec.grade_id
    ,p_date_from_o                  =>per_vgr_shd.g_old_rec.date_from
    ,p_comments_o                   =>per_vgr_shd.g_old_rec.comments
    ,p_date_to_o                    =>per_vgr_shd.g_old_rec.date_to
    ,p_job_id_o                     =>per_vgr_shd.g_old_rec.job_id
    ,p_position_id_o                =>per_vgr_shd.g_old_rec.position_id
    ,p_request_id_o                 =>per_vgr_shd.g_old_rec.request_id
    ,p_program_application_id_o     =>per_vgr_shd.g_old_rec.program_application_id
    ,p_program_id_o 		    =>per_vgr_shd.g_old_rec.program_id
    ,p_program_update_date_o        =>per_vgr_shd.g_old_rec.program_update_date
    ,p_attribute_category_o         =>per_vgr_shd.g_old_rec.attribute_category
    ,p_attribute1_o                 =>per_vgr_shd.g_old_rec.attribute1
    ,p_attribute2_o                 =>per_vgr_shd.g_old_rec.attribute2
    ,p_attribute3_o                 =>per_vgr_shd.g_old_rec.attribute3
    ,p_attribute4_o                 =>per_vgr_shd.g_old_rec.attribute4
    ,p_attribute5_o                 =>per_vgr_shd.g_old_rec.attribute5
    ,p_attribute6_o                 =>per_vgr_shd.g_old_rec.attribute6
    ,p_attribute7_o                 =>per_vgr_shd.g_old_rec.attribute7
    ,p_attribute8_o                 =>per_vgr_shd.g_old_rec.attribute8
    ,p_attribute9_o                 =>per_vgr_shd.g_old_rec.attribute9
    ,p_attribute10_o                =>per_vgr_shd.g_old_rec.attribute10
    ,p_attribute11_o                =>per_vgr_shd.g_old_rec.attribute11
    ,p_attribute12_o                =>per_vgr_shd.g_old_rec.attribute12
    ,p_attribute13_o                =>per_vgr_shd.g_old_rec.attribute13
    ,p_attribute14_o                =>per_vgr_shd.g_old_rec.attribute14
    ,p_attribute15_o                =>per_vgr_shd.g_old_rec.attribute15
    ,p_attribute16_o                =>per_vgr_shd.g_old_rec.attribute16
    ,p_attribute17_o                =>per_vgr_shd.g_old_rec.attribute17
    ,p_attribute18_o                =>per_vgr_shd.g_old_rec.attribute18
    ,p_attribute19_o                =>per_vgr_shd.g_old_rec.attribute19
    ,p_attribute20_o                =>per_vgr_shd.g_old_rec.attribute20
    ,p_object_version_number_o      =>per_vgr_shd.g_old_rec.object_version_number
     );
Line: 209

End post_delete;
Line: 244

  per_vgr_bus.delete_validate(p_rec);
Line: 248

  pre_delete(p_rec);
Line: 252

  delete_dml(p_rec);
Line: 256

  post_delete(p_rec);