The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure delete_dml(p_rec in ben_pil_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_dml';
delete from ben_per_in_ler
where per_in_ler_id = p_rec.per_in_ler_id;
End delete_dml;
Procedure pre_delete(p_rec in ben_pil_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'pre_delete';
End pre_delete;
Procedure post_delete(
p_effective_date in date,p_rec in ben_pil_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'post_delete';
ben_pil_rkd.after_delete
(
p_per_in_ler_id =>p_rec.per_in_ler_id
,p_per_in_ler_stat_cd_o =>ben_pil_shd.g_old_rec.per_in_ler_stat_cd
,p_prvs_stat_cd_o =>ben_pil_shd.g_old_rec.prvs_stat_cd
,p_lf_evt_ocrd_dt_o =>ben_pil_shd.g_old_rec.lf_evt_ocrd_dt
,p_trgr_table_pk_id_o =>ben_pil_shd.g_old_rec.trgr_table_pk_id
,p_procd_dt_o =>ben_pil_shd.g_old_rec.procd_dt
,p_strtd_dt_o =>ben_pil_shd.g_old_rec.strtd_dt
,p_voidd_dt_o =>ben_pil_shd.g_old_rec.voidd_dt
,p_bckt_dt_o =>ben_pil_shd.g_old_rec.bckt_dt
,p_clsd_dt_o =>ben_pil_shd.g_old_rec.clsd_dt
,p_ntfn_dt_o =>ben_pil_shd.g_old_rec.ntfn_dt
,p_ptnl_ler_for_per_id_o =>ben_pil_shd.g_old_rec.ptnl_ler_for_per_id
,p_bckt_per_in_ler_id_o =>ben_pil_shd.g_old_rec.bckt_per_in_ler_id
,p_ler_id_o =>ben_pil_shd.g_old_rec.ler_id
,p_person_id_o =>ben_pil_shd.g_old_rec.person_id
,p_business_group_id_o =>ben_pil_shd.g_old_rec.business_group_id
,p_ASSIGNMENT_ID_o => ben_pil_shd.g_old_rec.ASSIGNMENT_ID
,p_WS_MGR_ID_o => ben_pil_shd.g_old_rec.WS_MGR_ID
,p_GROUP_PL_ID_o => ben_pil_shd.g_old_rec.GROUP_PL_ID
,p_MGR_OVRID_PERSON_ID_o => ben_pil_shd.g_old_rec.MGR_OVRID_PERSON_ID ,p_MGR_OVRID_DT_o => ben_pil_shd.g_old_rec.MGR_OVRID_DT
,p_pil_attribute_category_o =>ben_pil_shd.g_old_rec.pil_attribute_category
,p_pil_attribute1_o =>ben_pil_shd.g_old_rec.pil_attribute1
,p_pil_attribute2_o =>ben_pil_shd.g_old_rec.pil_attribute2
,p_pil_attribute3_o =>ben_pil_shd.g_old_rec.pil_attribute3
,p_pil_attribute4_o =>ben_pil_shd.g_old_rec.pil_attribute4
,p_pil_attribute5_o =>ben_pil_shd.g_old_rec.pil_attribute5
,p_pil_attribute6_o =>ben_pil_shd.g_old_rec.pil_attribute6
,p_pil_attribute7_o =>ben_pil_shd.g_old_rec.pil_attribute7
,p_pil_attribute8_o =>ben_pil_shd.g_old_rec.pil_attribute8
,p_pil_attribute9_o =>ben_pil_shd.g_old_rec.pil_attribute9
,p_pil_attribute10_o =>ben_pil_shd.g_old_rec.pil_attribute10
,p_pil_attribute11_o =>ben_pil_shd.g_old_rec.pil_attribute11
,p_pil_attribute12_o =>ben_pil_shd.g_old_rec.pil_attribute12
,p_pil_attribute13_o =>ben_pil_shd.g_old_rec.pil_attribute13
,p_pil_attribute14_o =>ben_pil_shd.g_old_rec.pil_attribute14
,p_pil_attribute15_o =>ben_pil_shd.g_old_rec.pil_attribute15
,p_pil_attribute16_o =>ben_pil_shd.g_old_rec.pil_attribute16
,p_pil_attribute17_o =>ben_pil_shd.g_old_rec.pil_attribute17
,p_pil_attribute18_o =>ben_pil_shd.g_old_rec.pil_attribute18
,p_pil_attribute19_o =>ben_pil_shd.g_old_rec.pil_attribute19
,p_pil_attribute20_o =>ben_pil_shd.g_old_rec.pil_attribute20
,p_pil_attribute21_o =>ben_pil_shd.g_old_rec.pil_attribute21
,p_pil_attribute22_o =>ben_pil_shd.g_old_rec.pil_attribute22
,p_pil_attribute23_o =>ben_pil_shd.g_old_rec.pil_attribute23
,p_pil_attribute24_o =>ben_pil_shd.g_old_rec.pil_attribute24
,p_pil_attribute25_o =>ben_pil_shd.g_old_rec.pil_attribute25
,p_pil_attribute26_o =>ben_pil_shd.g_old_rec.pil_attribute26
,p_pil_attribute27_o =>ben_pil_shd.g_old_rec.pil_attribute27
,p_pil_attribute28_o =>ben_pil_shd.g_old_rec.pil_attribute28
,p_pil_attribute29_o =>ben_pil_shd.g_old_rec.pil_attribute29
,p_pil_attribute30_o =>ben_pil_shd.g_old_rec.pil_attribute30
,p_request_id_o =>ben_pil_shd.g_old_rec.request_id
,p_program_application_id_o =>ben_pil_shd.g_old_rec.program_application_id
,p_program_id_o =>ben_pil_shd.g_old_rec.program_id
,p_program_update_date_o =>ben_pil_shd.g_old_rec.program_update_date
,p_object_version_number_o =>ben_pil_shd.g_old_rec.object_version_number
);
End post_delete;
ben_pil_bus.delete_validate(p_rec
,p_effective_date);
pre_delete(p_rec);
delete_dml(p_rec);
post_delete(
p_effective_date,p_rec);