[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select sspndd_flag
from ben_prtt_enrt_rslt_f perslt
where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and perslt.prtt_enrt_rslt_stat_cd is null
and perslt.business_group_id = p_business_group_id
and p_effective_date between perslt.effective_start_date
and perslt.effective_end_date;
select sspndd_flag
from ben_prtt_enrt_rslt_f perslt
where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and perslt.prtt_enrt_rslt_stat_cd is null
and perslt.business_group_id = p_business_group_id
and p_effective_date between perslt.effective_start_date
and perslt.effective_end_date;
select 'X'
from ben_prtt_enrt_actn_f act,
ben_per_in_ler pil
where act.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and act.per_in_ler_id = pil.per_in_ler_id
and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT')
and act.rqd_flag = 'Y'
and act.cmpltd_dt IS NULL
and act.business_group_id = p_business_group_id
and p_effective_date between act.effective_start_date
and act.effective_end_date;
select person_id
,ler_id
,pgm_id
,pl_id
,pl_typ_id
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and prtt_enrt_rslt_stat_cd is null
and p_effective_date between
effective_start_date and effective_end_date;
select person_id
,ler_id
,pgm_id
,pl_id
,pl_typ_id
,per_in_ler_id
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and prtt_enrt_rslt_stat_cd is null
and p_effective_date between
effective_start_date and effective_end_date;
procedure update_PRTT_ENRT_ACTN
(p_validate in boolean default false
,p_post_rslt_flag in varchar2 default 'N'
,p_prtt_enrt_actn_id in number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_cmpltd_dt in date default hr_api.g_date
,p_due_dt in date default hr_api.g_date
,p_rqd_flag in varchar2 default hr_api.g_varchar2
,p_prtt_enrt_rslt_id in number default hr_api.g_number
,p_per_in_ler_id in number
,p_rslt_object_version_number in out nocopy number
,p_actn_typ_id in number default hr_api.g_number
,p_elig_cvrd_dpnt_id in number default hr_api.g_number
,p_pl_bnf_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_pea_attribute_category in varchar2 default hr_api.g_varchar2
,p_pea_attribute1 in varchar2 default hr_api.g_varchar2
,p_pea_attribute2 in varchar2 default hr_api.g_varchar2
,p_pea_attribute3 in varchar2 default hr_api.g_varchar2
,p_pea_attribute4 in varchar2 default hr_api.g_varchar2
,p_pea_attribute5 in varchar2 default hr_api.g_varchar2
,p_pea_attribute6 in varchar2 default hr_api.g_varchar2
,p_pea_attribute7 in varchar2 default hr_api.g_varchar2
,p_pea_attribute8 in varchar2 default hr_api.g_varchar2
,p_pea_attribute9 in varchar2 default hr_api.g_varchar2
,p_pea_attribute10 in varchar2 default hr_api.g_varchar2
,p_pea_attribute11 in varchar2 default hr_api.g_varchar2
,p_pea_attribute12 in varchar2 default hr_api.g_varchar2
,p_pea_attribute13 in varchar2 default hr_api.g_varchar2
,p_pea_attribute14 in varchar2 default hr_api.g_varchar2
,p_pea_attribute15 in varchar2 default hr_api.g_varchar2
,p_pea_attribute16 in varchar2 default hr_api.g_varchar2
,p_pea_attribute17 in varchar2 default hr_api.g_varchar2
,p_pea_attribute18 in varchar2 default hr_api.g_varchar2
,p_pea_attribute19 in varchar2 default hr_api.g_varchar2
,p_pea_attribute20 in varchar2 default hr_api.g_varchar2
,p_pea_attribute21 in varchar2 default hr_api.g_varchar2
,p_pea_attribute22 in varchar2 default hr_api.g_varchar2
,p_pea_attribute23 in varchar2 default hr_api.g_varchar2
,p_pea_attribute24 in varchar2 default hr_api.g_varchar2
,p_pea_attribute25 in varchar2 default hr_api.g_varchar2
,p_pea_attribute26 in varchar2 default hr_api.g_varchar2
,p_pea_attribute27 in varchar2 default hr_api.g_varchar2
,p_pea_attribute28 in varchar2 default hr_api.g_varchar2
,p_pea_attribute29 in varchar2 default hr_api.g_varchar2
,p_pea_attribute30 in varchar2 default hr_api.g_varchar2
,p_gnrt_cm in boolean default true
,p_object_version_number in out nocopy number
,p_effective_date in date
,p_datetrack_mode in varchar2
) is
--
-- Declare cursors and local variables
--
cursor c_pea is
select pea.effective_start_date,
pea.cmpltd_dt
from ben_prtt_enrt_actn_f pea
where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
and pea.business_group_id = p_business_group_id
and p_effective_date between
pea.effective_start_date and pea.effective_end_date;
select pcm.per_cm_id,
pcm.object_version_number
from ben_per_cm_f pcm
where pcm.prtt_enrt_actn_id = p_prtt_enrt_actn_id
and pcm.business_group_id = p_business_group_id
and p_effective_date between
pcm.effective_start_date and pcm.effective_end_date;
select person_id
,ler_id
,pgm_id
,pl_id
,pl_typ_id
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and prtt_enrt_rslt_stat_cd is null
and p_effective_date between
effective_start_date and effective_end_date;
l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
savepoint update_PRTT_ENRT_ACTN;
ben_PRTT_ENRT_ACTN_bk2.update_PRTT_ENRT_ACTN_b
(
p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_cmpltd_dt => p_cmpltd_dt
,p_due_dt => p_due_dt
,p_rqd_flag => p_rqd_flag
,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
,p_per_in_ler_id => p_per_in_ler_id
,p_actn_typ_id => p_actn_typ_id
,p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id
,p_pl_bnf_id => p_pl_bnf_id
,p_business_group_id => p_business_group_id
,p_pea_attribute_category => p_pea_attribute_category
,p_pea_attribute1 => p_pea_attribute1
,p_pea_attribute2 => p_pea_attribute2
,p_pea_attribute3 => p_pea_attribute3
,p_pea_attribute4 => p_pea_attribute4
,p_pea_attribute5 => p_pea_attribute5
,p_pea_attribute6 => p_pea_attribute6
,p_pea_attribute7 => p_pea_attribute7
,p_pea_attribute8 => p_pea_attribute8
,p_pea_attribute9 => p_pea_attribute9
,p_pea_attribute10 => p_pea_attribute10
,p_pea_attribute11 => p_pea_attribute11
,p_pea_attribute12 => p_pea_attribute12
,p_pea_attribute13 => p_pea_attribute13
,p_pea_attribute14 => p_pea_attribute14
,p_pea_attribute15 => p_pea_attribute15
,p_pea_attribute16 => p_pea_attribute16
,p_pea_attribute17 => p_pea_attribute17
,p_pea_attribute18 => p_pea_attribute18
,p_pea_attribute19 => p_pea_attribute19
,p_pea_attribute20 => p_pea_attribute20
,p_pea_attribute21 => p_pea_attribute21
,p_pea_attribute22 => p_pea_attribute22
,p_pea_attribute23 => p_pea_attribute23
,p_pea_attribute24 => p_pea_attribute24
,p_pea_attribute25 => p_pea_attribute25
,p_pea_attribute26 => p_pea_attribute26
,p_pea_attribute27 => p_pea_attribute27
,p_pea_attribute28 => p_pea_attribute28
,p_pea_attribute29 => p_pea_attribute29
,p_pea_attribute30 => p_pea_attribute30
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'UPDATE_PRTT_ENRT_ACTN'
,p_hook_type => 'BP'
);
ben_PRTT_ENRT_ACTN_bk2.update_PRTT_ENRT_ACTN_a
(
p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_cmpltd_dt => p_cmpltd_dt
,p_due_dt => p_due_dt
,p_rqd_flag => p_rqd_flag
,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
,p_per_in_ler_id => p_per_in_ler_id
,p_actn_typ_id => p_actn_typ_id
,p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id
,p_pl_bnf_id => p_pl_bnf_id
,p_business_group_id => p_business_group_id
,p_pea_attribute_category => p_pea_attribute_category
,p_pea_attribute1 => p_pea_attribute1
,p_pea_attribute2 => p_pea_attribute2
,p_pea_attribute3 => p_pea_attribute3
,p_pea_attribute4 => p_pea_attribute4
,p_pea_attribute5 => p_pea_attribute5
,p_pea_attribute6 => p_pea_attribute6
,p_pea_attribute7 => p_pea_attribute7
,p_pea_attribute8 => p_pea_attribute8
,p_pea_attribute9 => p_pea_attribute9
,p_pea_attribute10 => p_pea_attribute10
,p_pea_attribute11 => p_pea_attribute11
,p_pea_attribute12 => p_pea_attribute12
,p_pea_attribute13 => p_pea_attribute13
,p_pea_attribute14 => p_pea_attribute14
,p_pea_attribute15 => p_pea_attribute15
,p_pea_attribute16 => p_pea_attribute16
,p_pea_attribute17 => p_pea_attribute17
,p_pea_attribute18 => p_pea_attribute18
,p_pea_attribute19 => p_pea_attribute19
,p_pea_attribute20 => p_pea_attribute20
,p_pea_attribute21 => p_pea_attribute21
,p_pea_attribute22 => p_pea_attribute22
,p_pea_attribute23 => p_pea_attribute23
,p_pea_attribute24 => p_pea_attribute24
,p_pea_attribute25 => p_pea_attribute25
,p_pea_attribute26 => p_pea_attribute26
,p_pea_attribute27 => p_pea_attribute27
,p_pea_attribute28 => p_pea_attribute28
,p_pea_attribute29 => p_pea_attribute29
,p_pea_attribute30 => p_pea_attribute30
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'UPDATE_PRTT_ENRT_ACTN'
,p_hook_type => 'AP'
);
ben_per_cm_api.delete_per_cm
(p_per_cm_id => l_pcm.per_cm_id,
p_effective_start_date => l_pcm_effective_start_date,
p_effective_end_date => l_pcm_effective_end_date,
p_object_version_number => l_pcm.object_version_number,
p_effective_date => p_effective_date,
p_datetrack_mode => hr_api.g_zap);
ROLLBACK TO update_PRTT_ENRT_ACTN;
ROLLBACK TO update_PRTT_ENRT_ACTN;
end update_PRTT_ENRT_ACTN;
procedure update_PRTT_ENRT_ACTN
(p_validate in boolean default false
,p_post_rslt_flag in varchar2 default 'N'
,p_prtt_enrt_actn_id in number
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
,p_cmpltd_dt in date default hr_api.g_date
,p_due_dt in date default hr_api.g_date
,p_rqd_flag in varchar2 default hr_api.g_varchar2
,p_prtt_enrt_rslt_id in number default hr_api.g_number
,p_rslt_object_version_number in out nocopy number
,p_actn_typ_id in number default hr_api.g_number
,p_elig_cvrd_dpnt_id in number default hr_api.g_number
,p_pl_bnf_id in number default hr_api.g_number
,p_business_group_id in number default hr_api.g_number
,p_pea_attribute_category in varchar2 default hr_api.g_varchar2
,p_pea_attribute1 in varchar2 default hr_api.g_varchar2
,p_pea_attribute2 in varchar2 default hr_api.g_varchar2
,p_pea_attribute3 in varchar2 default hr_api.g_varchar2
,p_pea_attribute4 in varchar2 default hr_api.g_varchar2
,p_pea_attribute5 in varchar2 default hr_api.g_varchar2
,p_pea_attribute6 in varchar2 default hr_api.g_varchar2
,p_pea_attribute7 in varchar2 default hr_api.g_varchar2
,p_pea_attribute8 in varchar2 default hr_api.g_varchar2
,p_pea_attribute9 in varchar2 default hr_api.g_varchar2
,p_pea_attribute10 in varchar2 default hr_api.g_varchar2
,p_pea_attribute11 in varchar2 default hr_api.g_varchar2
,p_pea_attribute12 in varchar2 default hr_api.g_varchar2
,p_pea_attribute13 in varchar2 default hr_api.g_varchar2
,p_pea_attribute14 in varchar2 default hr_api.g_varchar2
,p_pea_attribute15 in varchar2 default hr_api.g_varchar2
,p_pea_attribute16 in varchar2 default hr_api.g_varchar2
,p_pea_attribute17 in varchar2 default hr_api.g_varchar2
,p_pea_attribute18 in varchar2 default hr_api.g_varchar2
,p_pea_attribute19 in varchar2 default hr_api.g_varchar2
,p_pea_attribute20 in varchar2 default hr_api.g_varchar2
,p_pea_attribute21 in varchar2 default hr_api.g_varchar2
,p_pea_attribute22 in varchar2 default hr_api.g_varchar2
,p_pea_attribute23 in varchar2 default hr_api.g_varchar2
,p_pea_attribute24 in varchar2 default hr_api.g_varchar2
,p_pea_attribute25 in varchar2 default hr_api.g_varchar2
,p_pea_attribute26 in varchar2 default hr_api.g_varchar2
,p_pea_attribute27 in varchar2 default hr_api.g_varchar2
,p_pea_attribute28 in varchar2 default hr_api.g_varchar2
,p_pea_attribute29 in varchar2 default hr_api.g_varchar2
,p_pea_attribute30 in varchar2 default hr_api.g_varchar2
,p_gnrt_cm in boolean default true
,p_object_version_number in out nocopy number
,p_effective_date in date
,p_datetrack_mode in varchar2
) is
--
-- Declare cursors and local variables
--
cursor c_pea is
select pea.effective_start_date,
pea.cmpltd_dt
from ben_prtt_enrt_actn_f pea
where pea.prtt_enrt_actn_id = p_prtt_enrt_actn_id
and pea.business_group_id = p_business_group_id
and p_effective_date between
pea.effective_start_date and pea.effective_end_date;
select pcm.per_cm_id,
pcm.object_version_number
from ben_per_cm_f pcm
where pcm.prtt_enrt_actn_id = p_prtt_enrt_actn_id
and pcm.business_group_id = p_business_group_id
and p_effective_date between
pcm.effective_start_date and pcm.effective_end_date;
select person_id
,ler_id
,pgm_id
,pl_id
,pl_typ_id
,per_in_ler_id
from ben_prtt_enrt_rslt_f
where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
and prtt_enrt_rslt_stat_cd is null
and p_effective_date between
effective_start_date and effective_end_date;
l_proc varchar2(72) := g_package||'update_PRTT_ENRT_ACTN';
savepoint update_PRTT_ENRT_ACTN;
ben_PRTT_ENRT_ACTN_bk2.update_PRTT_ENRT_ACTN_b
(
p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_cmpltd_dt => p_cmpltd_dt
,p_due_dt => p_due_dt
,p_rqd_flag => p_rqd_flag
,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
,p_per_in_ler_id => l_per_in_ler_id
,p_actn_typ_id => p_actn_typ_id
,p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id
,p_pl_bnf_id => p_pl_bnf_id
,p_business_group_id => p_business_group_id
,p_pea_attribute_category => p_pea_attribute_category
,p_pea_attribute1 => p_pea_attribute1
,p_pea_attribute2 => p_pea_attribute2
,p_pea_attribute3 => p_pea_attribute3
,p_pea_attribute4 => p_pea_attribute4
,p_pea_attribute5 => p_pea_attribute5
,p_pea_attribute6 => p_pea_attribute6
,p_pea_attribute7 => p_pea_attribute7
,p_pea_attribute8 => p_pea_attribute8
,p_pea_attribute9 => p_pea_attribute9
,p_pea_attribute10 => p_pea_attribute10
,p_pea_attribute11 => p_pea_attribute11
,p_pea_attribute12 => p_pea_attribute12
,p_pea_attribute13 => p_pea_attribute13
,p_pea_attribute14 => p_pea_attribute14
,p_pea_attribute15 => p_pea_attribute15
,p_pea_attribute16 => p_pea_attribute16
,p_pea_attribute17 => p_pea_attribute17
,p_pea_attribute18 => p_pea_attribute18
,p_pea_attribute19 => p_pea_attribute19
,p_pea_attribute20 => p_pea_attribute20
,p_pea_attribute21 => p_pea_attribute21
,p_pea_attribute22 => p_pea_attribute22
,p_pea_attribute23 => p_pea_attribute23
,p_pea_attribute24 => p_pea_attribute24
,p_pea_attribute25 => p_pea_attribute25
,p_pea_attribute26 => p_pea_attribute26
,p_pea_attribute27 => p_pea_attribute27
,p_pea_attribute28 => p_pea_attribute28
,p_pea_attribute29 => p_pea_attribute29
,p_pea_attribute30 => p_pea_attribute30
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'UPDATE_PRTT_ENRT_ACTN'
,p_hook_type => 'BP'
);
ben_PRTT_ENRT_ACTN_bk2.update_PRTT_ENRT_ACTN_a
(
p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_cmpltd_dt => p_cmpltd_dt
,p_due_dt => p_due_dt
,p_rqd_flag => p_rqd_flag
,p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id
,p_per_in_ler_id => l_per_in_ler_id
,p_actn_typ_id => p_actn_typ_id
,p_elig_cvrd_dpnt_id => p_elig_cvrd_dpnt_id
,p_pl_bnf_id => p_pl_bnf_id
,p_business_group_id => p_business_group_id
,p_pea_attribute_category => p_pea_attribute_category
,p_pea_attribute1 => p_pea_attribute1
,p_pea_attribute2 => p_pea_attribute2
,p_pea_attribute3 => p_pea_attribute3
,p_pea_attribute4 => p_pea_attribute4
,p_pea_attribute5 => p_pea_attribute5
,p_pea_attribute6 => p_pea_attribute6
,p_pea_attribute7 => p_pea_attribute7
,p_pea_attribute8 => p_pea_attribute8
,p_pea_attribute9 => p_pea_attribute9
,p_pea_attribute10 => p_pea_attribute10
,p_pea_attribute11 => p_pea_attribute11
,p_pea_attribute12 => p_pea_attribute12
,p_pea_attribute13 => p_pea_attribute13
,p_pea_attribute14 => p_pea_attribute14
,p_pea_attribute15 => p_pea_attribute15
,p_pea_attribute16 => p_pea_attribute16
,p_pea_attribute17 => p_pea_attribute17
,p_pea_attribute18 => p_pea_attribute18
,p_pea_attribute19 => p_pea_attribute19
,p_pea_attribute20 => p_pea_attribute20
,p_pea_attribute21 => p_pea_attribute21
,p_pea_attribute22 => p_pea_attribute22
,p_pea_attribute23 => p_pea_attribute23
,p_pea_attribute24 => p_pea_attribute24
,p_pea_attribute25 => p_pea_attribute25
,p_pea_attribute26 => p_pea_attribute26
,p_pea_attribute27 => p_pea_attribute27
,p_pea_attribute28 => p_pea_attribute28
,p_pea_attribute29 => p_pea_attribute29
,p_pea_attribute30 => p_pea_attribute30
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode
);
(p_module_name => 'UPDATE_PRTT_ENRT_ACTN'
,p_hook_type => 'AP'
);
ben_per_cm_api.delete_per_cm
(p_per_cm_id => l_pcm.per_cm_id,
p_effective_start_date => l_pcm_effective_start_date,
p_effective_end_date => l_pcm_effective_end_date,
p_object_version_number => l_pcm.object_version_number,
p_effective_date => p_effective_date,
p_datetrack_mode => hr_api.g_zap);
ROLLBACK TO update_PRTT_ENRT_ACTN;
ROLLBACK TO update_PRTT_ENRT_ACTN;
end update_PRTT_ENRT_ACTN;
procedure delete_PRTT_ENRT_ACTN
(p_validate in boolean default false
,p_prtt_enrt_actn_id in number
,p_business_group_id in number
,p_effective_date in date
,p_datetrack_mode in varchar2
,p_object_version_number in out nocopy number
,p_prtt_enrt_rslt_id in number
,p_rslt_object_version_number in out nocopy number
,p_post_rslt_flag in varchar2 default 'N'
,p_unsuspend_enrt_flag in varchar2 default 'Y'
,p_gnrt_cm in boolean default true
,p_effective_start_date out nocopy date
,p_effective_end_date out nocopy date
)
is
--
-- Declare cursors and local variables
--
-- Cursor to find dpnt ctfns.
--
cursor c_dpnt_ctfns
is
select cvrd_dpnt_ctfn_prvdd_id,
object_version_number,
effective_start_date,
effective_end_date
from ben_cvrd_dpnt_ctfn_prvdd_f
where prtt_enrt_actn_id = p_prtt_enrt_actn_id
and business_group_id = p_business_group_id
and p_effective_date between effective_start_date
and effective_end_date;
select pl_bnf_ctfn_prvdd_id,
object_version_number,
effective_start_date,
effective_end_date
from ben_pl_bnf_ctfn_prvdd_f
where prtt_enrt_actn_id = p_prtt_enrt_actn_id
and business_group_id = p_business_group_id
and p_effective_date between effective_start_date
and effective_end_date;
select prtt_enrt_ctfn_prvdd_id,
object_version_number,
effective_start_date,
effective_end_date
from ben_prtt_enrt_ctfn_prvdd_f
where prtt_enrt_actn_id = p_prtt_enrt_actn_id
and business_group_id = p_business_group_id
and p_effective_date between effective_start_date
and effective_end_date;
select per_cm_id,
object_version_number,
effective_start_date,
effective_end_date
from ben_per_cm_f
where prtt_enrt_actn_id = p_prtt_enrt_actn_id
and business_group_id = p_business_group_id
and p_effective_date between effective_start_date
and effective_end_date;
l_proc varchar2(72) := g_package||'delete_PRTT_ENRT_ACTN';
savepoint delete_PRTT_ENRT_ACTN;
ben_PRTT_ENRT_ACTN_bk3.delete_PRTT_ENRT_ACTN_b
(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_object_version_number => p_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode);
(p_module_name => 'DELETE_PRTT_ENRT_ACTN'
,p_hook_type => 'BP');
if p_datetrack_mode = hr_api.g_delete_next_change or p_datetrack_mode = hr_api.g_future_change then
--
ben_pea_del.del
(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode);
ben_PRTT_ENRT_ACTN_bk3.delete_PRTT_ENRT_ACTN_a
(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode);
(p_module_name => 'DELETE_PRTT_ENRT_ACTN'
,p_hook_type => 'AP');
if (p_datetrack_mode = hr_api.g_delete and
l_rec.effective_end_date > p_effective_date) or
p_datetrack_mode <> hr_api.g_delete then
--
ben_cvrd_dpnt_ctfn_prvdd_api.delete_cvrd_dpnt_ctfn_prvdd
(p_validate => FALSE
,p_cvrd_dpnt_ctfn_prvdd_id => l_rec.cvrd_dpnt_ctfn_prvdd_id
,p_effective_start_date => l_rec.effective_start_date
,p_effective_end_date => l_rec.effective_end_date
,p_object_version_number => l_rec.object_version_number
,p_business_group_id => p_business_group_id
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_check_actions => 'N'
,p_called_from => 'bepeaapi' );
if (p_datetrack_mode = hr_api.g_delete and
l_rec.effective_end_date > p_effective_date) or
p_datetrack_mode <> hr_api.g_delete then
--
ben_pl_bnf_ctfn_prvdd_api.delete_pl_bnf_ctfn_prvdd
(p_validate => FALSE
,p_pl_bnf_ctfn_prvdd_id => l_rec.pl_bnf_ctfn_prvdd_id
,p_effective_start_date => l_rec.effective_start_date
,p_effective_end_date => l_rec.effective_end_date
,p_object_version_number => l_rec.object_version_number
,p_business_group_id => p_business_group_id
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_check_actions => 'N');
if (p_datetrack_mode = hr_api.g_delete and
/* l_rec.effective_end_date > p_effective_date) or */
l_rec.effective_end_date >= p_effective_date) or --Bug 8304294
p_datetrack_mode <> hr_api.g_delete then
--
ben_prtt_enrt_ctfn_prvdd_api.delete_prtt_enrt_ctfn_prvdd
(p_validate => FALSE
,p_prtt_enrt_ctfn_prvdd_id => l_rec.prtt_enrt_ctfn_prvdd_id
,p_effective_start_date => l_rec.effective_start_date
,p_effective_end_date => l_rec.effective_end_date
,p_object_version_number => l_rec.object_version_number
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode
,p_check_actions => 'N');
if (p_datetrack_mode = hr_api.g_delete and
l_rec.effective_end_date > p_effective_date) or
p_datetrack_mode <> hr_api.g_delete then
--
/* Bug 12976985: When Life Event is backedout, Participant action item will be reopened in
delete future change mode for the previous LE. But since communication is not end dated,
calling the api in that mode will cause error to be thrown*/
if(p_datetrack_mode = hr_api.g_future_change
and l_rec.effective_end_date = hr_api.g_eot) then
null;
ben_per_cm_api.delete_per_cm
(p_validate => FALSE
,p_per_cm_id => l_rec.per_cm_id
,p_effective_start_date => l_rec.effective_start_date
,p_effective_end_date => l_rec.effective_end_date
,p_object_version_number => l_rec.object_version_number
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode);
if p_datetrack_mode <> hr_api.g_delete_next_change and p_datetrack_mode <> hr_api.g_future_change then
--
ben_pea_del.del
(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => p_effective_date
,p_datetrack_mode => p_datetrack_mode);
ben_PRTT_ENRT_ACTN_bk3.delete_PRTT_ENRT_ACTN_a
(p_prtt_enrt_actn_id => p_prtt_enrt_actn_id
,p_effective_start_date => l_effective_start_date
,p_effective_end_date => l_effective_end_date
,p_object_version_number => l_object_version_number
,p_effective_date => trunc(p_effective_date)
,p_datetrack_mode => p_datetrack_mode);
(p_module_name => 'DELETE_PRTT_ENRT_ACTN'
,p_hook_type => 'AP');
ROLLBACK TO delete_PRTT_ENRT_ACTN;
ROLLBACK TO delete_PRTT_ENRT_ACTN;
end delete_PRTT_ENRT_ACTN;