APPS.PER_APL_DEL SQL Statements

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

Line: 51

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

Line: 62

  delete from per_applications
  where application_id = p_rec.application_id;

Line: 78

End delete_dml;

Line: 112

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

Line: 163

    per_apl_rkd.after_delete
      (p_application_id               => p_rec.application_id
      ,p_business_group_id_o
          => per_apl_shd.g_old_rec.business_group_id
      ,p_person_id_o
          => per_apl_shd.g_old_rec.person_id
      ,p_date_received_o
          => per_apl_shd.g_old_rec.date_received
      ,p_comments_o
          => per_apl_shd.g_old_rec.comments
      ,p_current_employer_o
          => per_apl_shd.g_old_rec.current_employer
      ,p_date_end_o
          => per_apl_shd.g_old_rec.date_end
      ,p_projected_hire_date_o
          => per_apl_shd.g_old_rec.projected_hire_date
      ,p_successful_flag_o
          => per_apl_shd.g_old_rec.successful_flag
      ,p_termination_reason_o
          => per_apl_shd.g_old_rec.termination_reason
      ,p_request_id_o
          => per_apl_shd.g_old_rec.request_id
      ,p_program_application_id_o
          => per_apl_shd.g_old_rec.program_application_id
      ,p_program_id_o
          => per_apl_shd.g_old_rec.program_id
      ,p_program_update_date_o
          => per_apl_shd.g_old_rec.program_update_date
      ,p_appl_attribute_category_o
          => per_apl_shd.g_old_rec.appl_attribute_category
      ,p_appl_attribute1_o
          => per_apl_shd.g_old_rec.appl_attribute1
      ,p_appl_attribute2_o
          => per_apl_shd.g_old_rec.appl_attribute2
      ,p_appl_attribute3_o
          => per_apl_shd.g_old_rec.appl_attribute3
      ,p_appl_attribute4_o
          => per_apl_shd.g_old_rec.appl_attribute4
      ,p_appl_attribute5_o
          => per_apl_shd.g_old_rec.appl_attribute5
      ,p_appl_attribute6_o
          => per_apl_shd.g_old_rec.appl_attribute6
      ,p_appl_attribute7_o
          => per_apl_shd.g_old_rec.appl_attribute7
      ,p_appl_attribute8_o
          => per_apl_shd.g_old_rec.appl_attribute8
      ,p_appl_attribute9_o
          => per_apl_shd.g_old_rec.appl_attribute9
      ,p_appl_attribute10_o
          => per_apl_shd.g_old_rec.appl_attribute10
      ,p_appl_attribute11_o
          => per_apl_shd.g_old_rec.appl_attribute11
      ,p_appl_attribute12_o
          => per_apl_shd.g_old_rec.appl_attribute12
      ,p_appl_attribute13_o
          => per_apl_shd.g_old_rec.appl_attribute13
      ,p_appl_attribute14_o
          => per_apl_shd.g_old_rec.appl_attribute14
      ,p_appl_attribute15_o
          => per_apl_shd.g_old_rec.appl_attribute15
      ,p_appl_attribute16_o
          => per_apl_shd.g_old_rec.appl_attribute16
      ,p_appl_attribute17_o
          => per_apl_shd.g_old_rec.appl_attribute17
      ,p_appl_attribute18_o
          => per_apl_shd.g_old_rec.appl_attribute18
      ,p_appl_attribute19_o
          => per_apl_shd.g_old_rec.appl_attribute19
      ,p_appl_attribute20_o
          => per_apl_shd.g_old_rec.appl_attribute20
      ,p_object_version_number_o
          => per_apl_shd.g_old_rec.object_version_number
      );

Line: 246

End post_delete;

Line: 281

  per_apl_bus.delete_validate(p_rec);

Line: 289

  pre_delete(p_rec);

Line: 293

  delete_dml(p_rec);

Line: 297

  post_delete(p_rec);