[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
29 May 02 Shdas 115.5 Added code to update elig dpnt record
if found eligble.
31-Oct-02 ashrivas 115.6 bug - 2419139. passing in lf_evt_ocrd_dt for
effective date for creating dpnt and removed the
date clause from the c_elig_dpnt cursor
31-Oct-02 ashrivas 115.7 Added Whenever OSError..
04-Dec-02 kmullapu 115.8 Added create_contact_w,update_person_w
NOCOPY changes
21-Jun-03 hnarayan 115.10 bug 3013964 - passed lf_evt_ocrd_dt as null
to dpnt elig process and create_elig_dpnt
if it is less than effective date.
Also added fnd_msg_pub.initialize
31-jul-03 hnarayan 115.11 bug 3042223 - changed create_contact_w
to set contact effective_start_date
based on max(PESD, min(RSD, EFF Dt))
09 Mar 05 vborkar 115.12 Bug 4218944 - Added wrapper procedure
update_contact_w which in turn calls
HR_CONTACT_REL_API.update_contact_relationship
and treats exceptions in more user friendly
manner.
26-May-06 bmanyam 115.13 5100008 - EGD elig_thru_dt is the
date eligibility is lost. Previously the elig_thru_dt
was updated with PDP cvg_thru_dt.
12-Sep-07 vborkar 115.14 6279654 - Called ben_env_object.init to initialize
business_group_id and effective_date in the environment record.
*/
--------------------------------------------------------------------------------+
--
g_package varchar2(80) := 'ben_determine_dpnt_elig_ss';
l_update boolean;
l_update_override boolean;
l_update_change_insert boolean;
select pl_id,
oipl_id,
ptip_id,
business_group_id,
dpnt_cvg_strt_dt_cd,
enrt_cvg_strt_dt_cd,
dpnt_cvg_strt_dt_rl,
elig_per_elctbl_chc_id
from ben_elig_per_elctbl_chc epe
where epe.per_in_ler_id = p_per_in_ler_id
and epe.pgm_id = p_pgm_id
and epe.elctbl_flag = 'Y'
and epe.alws_dpnt_dsgn_flag = 'Y';
select epe.elig_dpnt_id,
epe.object_version_number,
epe.dpnt_inelig_flag
from ben_elig_dpnt epe
where epe.dpnt_person_id = p_dpnt_person_id
and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
select pil.lf_evt_ocrd_dt,
pil.ler_id
from ben_per_in_ler pil,
ben_ler_f ler
where pil.person_id = p_person_id
and pil.business_group_id = l_business_group_id
and pil.per_in_ler_stat_cd = 'STRTD'
and pil.ler_id = ler.ler_id
and ler.typ_cd <> 'COMP'
and p_effective_date
between nvl(ler.effective_start_date,p_effective_date)
and nvl(ler.effective_end_date,p_effective_date)
and pil.per_in_ler_id = p_per_in_ler_id;
select chg.cvg_eff_strt_cd,
chg.cvg_eff_end_cd,
chg.cvg_eff_strt_rl,
chg.cvg_eff_end_rl,
chg.ler_chg_dpnt_cvg_cd,
chg.ler_chg_dpnt_cvg_rl
from ben_ler_chg_dpnt_cvg_f chg
where chg.ler_id = l_per_in_ler.ler_id
and chg.business_group_id = l_business_group_id
and decode(l_level,
'PL',l_pl_id,
'PTIP',l_ptip_id,
'PGM', p_pgm_id) =
decode(l_level,
'PL',chg.pl_id,
'PTIP',chg.ptip_id,
'PGM', chg.pgm_id)
and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
between nvl(chg.effective_start_date,p_effective_date)
and nvl(chg.effective_end_date,p_effective_date);
select pl.dpnt_dsgn_cd,
pl.dpnt_cvg_strt_dt_cd,
pl.dpnt_cvg_strt_dt_rl,
pl.dpnt_cvg_end_dt_cd,
pl.dpnt_cvg_end_dt_rl
from ben_pl_f pl
where pl.pl_id = l_pl_id
and pl.business_group_id = l_business_group_id
and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
between nvl(pl.effective_start_date,p_effective_date)
and nvl(pl.effective_end_date,p_effective_date);
select pgm.dpnt_dsgn_lvl_cd,
pgm.dpnt_dsgn_cd,
pgm.dpnt_cvg_strt_dt_cd,
pgm.dpnt_cvg_strt_dt_rl,
pgm.dpnt_cvg_end_dt_cd,
pgm.dpnt_cvg_end_dt_rl
from ben_pgm_f pgm
where pgm.pgm_id = p_pgm_id
and pgm.business_group_id = l_business_group_id
and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
between nvl(pgm.effective_start_date,p_effective_date)
and nvl(pgm.effective_end_date,p_effective_date);
select ptip.dpnt_dsgn_cd,
ptip.dpnt_cvg_strt_dt_cd,
ptip.dpnt_cvg_strt_dt_rl,
ptip.dpnt_cvg_end_dt_cd,
ptip.dpnt_cvg_end_dt_rl
from ben_ptip_f ptip
where ptip.ptip_id = l_ptip_id
and ptip.business_group_id = l_business_group_id
and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
between nvl(ptip.effective_start_date,p_effective_date)
and nvl(ptip.effective_end_date,p_effective_date);
select pen.prtt_enrt_rslt_id
from ben_prtt_enrt_rslt_f pen
where pen.person_id=p_person_id and
pen.sspndd_flag='N' and
pen.prtt_enrt_rslt_stat_cd is null and
pen.effective_end_date = hr_api.g_eot and
nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)-1 <=
pen.enrt_cvg_thru_dt and
pen.enrt_cvg_strt_dt < pen.effective_end_date
and pen.pl_id = l_pl_id
and pen.pgm_id = p_pgm_id;
select pen.prtt_enrt_rslt_id
from ben_prtt_enrt_rslt_f pen
where pen.person_id=p_person_id and
pen.sspndd_flag='N' and
pen.prtt_enrt_rslt_stat_cd is null and
pen.effective_end_date = hr_api.g_eot and
nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)-1 <=
pen.enrt_cvg_thru_dt and
pen.enrt_cvg_strt_dt < pen.effective_end_date and
pen.oipl_id=l_oipl_id
and pen.pgm_id = p_pgm_id;
select pdp.object_version_number,
pdp.elig_cvrd_dpnt_id,
pdp.effective_start_date,
pdp.cvg_strt_dt,
pdp.effective_end_date
from ben_elig_cvrd_dpnt_f pdp,
ben_per_in_ler pil
where pdp.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
and pdp.business_group_id = l_business_group_id
and pdp.dpnt_person_id = p_contact_person_id
and nvl(l_per_in_ler.lf_evt_ocrd_dt,p_effective_date)
between pdp.effective_start_date and pdp.effective_end_date
and nvl(l_per_in_ler.lf_evt_ocrd_dt, p_effective_date)
between pdp.cvg_strt_dt and nvl(pdp.cvg_thru_dt,hr_api.g_eot)
and pil.per_in_ler_id=pdp.per_in_ler_id
and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
select business_group_id
from per_all_people_f
where person_id = p_person_id
and p_effective_date between effective_start_date and effective_end_date;
he was ineligible.Since he is now eligible again,update elig dpnt record to make it N.
Else if the flag is N, it means he was eligible.Since he is still eligible,do nothing.
If elig dpnt record exists and is now found ineligible after evaluation of elig
profiles then check if the dependent person is covered--determine coverage end date and
update elig covered dependent record.If dpnt_inelig_flag on the elig dpnt record is N ,
which means he was eligible,update the elig dpnt record to set it to Y with the elig rsn cd.
*/
if l_dependent_eligible_flag = 'Y' then
--
if l_elig_dpnt.dpnt_inelig_flag = 'Y' then
--
ben_elig_dpnt_api.update_elig_dpnt(
p_elig_dpnt_id => l_elig_dpnt.elig_dpnt_id
,p_object_version_number => l_elig_dpnt.object_version_number
,p_effective_date => p_effective_date
,p_elig_thru_dt => hr_api.g_eot
,p_dpnt_inelig_flag => 'N'
,p_inelg_rsn_cd => null
);
p_update => l_update,
p_update_override => l_update_override,
p_update_change_insert => l_update_change_insert);
if l_update_override then
--
l_datetrack_mode := hr_api.g_update_override;
elsif l_update then
--
l_datetrack_mode := hr_api.g_update;
ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt
(p_elig_cvrd_dpnt_id => l_elig_cvrd_dpnt_id
,p_effective_start_date => l_pdp_effective_start_date
,p_effective_end_date => l_pdp_effective_end_date
,p_per_in_ler_id => p_per_in_ler_id
,p_cvg_thru_dt => l_cvg_end_dt
,p_object_version_number => l_pdp.object_version_number
,p_effective_date => nvl(l_per_in_ler.lf_evt_ocrd_dt,
p_effective_date)
,p_datetrack_mode => l_datetrack_mode
,p_program_application_id => fnd_global.prog_appl_id
,p_program_id => fnd_global.conc_program_id
,p_request_id => fnd_global.conc_request_id
,p_program_update_date => sysdate
,p_business_group_id => l_business_group_id
,p_multi_row_actn => FALSE
);
ben_elig_dpnt_api.update_elig_dpnt(
p_elig_dpnt_id => l_elig_dpnt.elig_dpnt_id
,p_object_version_number => l_elig_dpnt.object_version_number
,p_effective_date => p_effective_date
,p_elig_thru_dt => l_egd_elig_thru_dt --l_cvg_end_dt -- 5100008
,p_dpnt_inelig_flag => 'Y'
,p_inelg_rsn_cd => l_inelig_rsn_cd
);
select pgm.pgm_id,
pgm.vrfy_fmly_mmbr_cd,
pgm.vrfy_fmly_mmbr_rl
from ben_pgm_f pgm
where pgm.business_group_id = p_business_group_id
and pgm.pgm_stat_cd = 'A'
and p_effective_date
between pgm.effective_start_date and pgm.effective_end_date;
select plip.plip_id,
plip.pl_id,
plip.vrfy_fmly_mmbr_cd,
plip.vrfy_fmly_mmbr_rl
from ben_plip_f plip
where plip.business_group_id = p_business_group_id
and plip.plip_stat_cd = 'A'
and plip.pgm_id = l_pgm_id
and p_effective_date
between plip.effective_start_date and plip.effective_end_date;
select ptip.ptip_id,
ptip.vrfy_fmly_mmbr_cd,
ptip.vrfy_fmly_mmbr_rl
from ben_ptip_f ptip
where ptip.business_group_id = p_business_group_id
and ptip.ptip_stat_cd = 'A'
and ptip.pgm_id = l_pgm_id
and p_effective_date
between ptip.effective_start_date and ptip.effective_end_date;
select pl.pl_id,
pl.vrfy_fmly_mmbr_cd,
pl.vrfy_fmly_mmbr_rl,
pl.per_cvrd_cd
from ben_pl_f pl
where pl.business_group_id = p_business_group_id
and pl.pl_stat_cd = 'A'
and pl.pl_id = l_pl_id
and p_effective_date
between pl.effective_start_date and pl.effective_end_date;
select oipl.oipl_id,
oipl.vrfy_fmly_mmbr_cd,
oipl.vrfy_fmly_mmbr_rl,
oipl.per_cvrd_cd
from ben_oipl_f oipl
where oipl.business_group_id = p_business_group_id
and oipl.oipl_stat_cd = 'A'
and oipl.pl_id = l_pl_id
and p_effective_date
between oipl.effective_start_date and oipl.effective_end_date;
select etpr.elig_to_prte_rsn_id,
etpr.vrfy_fmly_mmbr_cd,
etpr.vrfy_fmly_mmbr_rl
from ben_elig_to_prte_rsn_f etpr
where etpr.business_group_id = p_business_group_id
and etpr.pgm_id = l_pgm_id
and p_effective_date
between etpr.effective_start_date and etpr.effective_end_date;
select etpr.elig_to_prte_rsn_id,
etpr.vrfy_fmly_mmbr_cd,
etpr.vrfy_fmly_mmbr_rl
from ben_elig_to_prte_rsn_f etpr
where etpr.business_group_id = p_business_group_id
and etpr.plip_id = l_plip_id
and p_effective_date
between etpr.effective_start_date and etpr.effective_end_date;
select etpr.elig_to_prte_rsn_id,
etpr.vrfy_fmly_mmbr_cd,
etpr.vrfy_fmly_mmbr_rl
from ben_elig_to_prte_rsn_f etpr
where etpr.business_group_id = p_business_group_id
and etpr.pl_id = l_pl_id
and p_effective_date
between etpr.effective_start_date and etpr.effective_end_date;
select etpr.elig_to_prte_rsn_id,
etpr.vrfy_fmly_mmbr_cd,
etpr.vrfy_fmly_mmbr_rl
from ben_elig_to_prte_rsn_f etpr
where etpr.business_group_id = p_business_group_id
and etpr.ptip_id = l_ptip_id
and p_effective_date
between etpr.effective_start_date and etpr.effective_end_date;
select etpr.elig_to_prte_rsn_id,
etpr.vrfy_fmly_mmbr_cd,
etpr.vrfy_fmly_mmbr_rl
from ben_elig_to_prte_rsn_f etpr
where etpr.business_group_id = p_business_group_id
and etpr.oipl_id = l_oipl_id
and p_effective_date
between etpr.effective_start_date and etpr.effective_end_date;
select per.effective_start_date
from per_all_people_f per
where per.person_id = p_person_id
order by effective_start_date asc ;
procedure update_contact_w
(p_validate in varchar2 default 'N'
,p_effective_date in date
,p_contact_relationship_id in number
,p_contact_type in varchar2 default hr_api.g_varchar2
,p_comments in long default hr_api.g_varchar2
,p_primary_contact_flag in varchar2 default hr_api.g_varchar2
,p_third_party_pay_flag in varchar2 default hr_api.g_varchar2
,p_bondholder_flag in varchar2 default hr_api.g_varchar2
,p_date_start in date default hr_api.g_date
,p_start_life_reason_id in number default hr_api.g_number
,p_date_end in date default hr_api.g_date
,p_end_life_reason_id in number default hr_api.g_number
,p_rltd_per_rsds_w_dsgntr_flag in varchar2 default hr_api.g_varchar2
,p_personal_flag in varchar2 default hr_api.g_varchar2
,p_sequence_number in number default hr_api.g_number
,p_dependent_flag in varchar2 default hr_api.g_varchar2
,p_beneficiary_flag in varchar2 default hr_api.g_varchar2
,p_cont_attribute_category in varchar2 default hr_api.g_varchar2
,p_cont_attribute1 in varchar2 default hr_api.g_varchar2
,p_cont_attribute2 in varchar2 default hr_api.g_varchar2
,p_cont_attribute3 in varchar2 default hr_api.g_varchar2
,p_cont_attribute4 in varchar2 default hr_api.g_varchar2
,p_cont_attribute5 in varchar2 default hr_api.g_varchar2
,p_cont_attribute6 in varchar2 default hr_api.g_varchar2
,p_cont_attribute7 in varchar2 default hr_api.g_varchar2
,p_cont_attribute8 in varchar2 default hr_api.g_varchar2
,p_cont_attribute9 in varchar2 default hr_api.g_varchar2
,p_cont_attribute10 in varchar2 default hr_api.g_varchar2
,p_cont_attribute11 in varchar2 default hr_api.g_varchar2
,p_cont_attribute12 in varchar2 default hr_api.g_varchar2
,p_cont_attribute13 in varchar2 default hr_api.g_varchar2
,p_cont_attribute14 in varchar2 default hr_api.g_varchar2
,p_cont_attribute15 in varchar2 default hr_api.g_varchar2
,p_cont_attribute16 in varchar2 default hr_api.g_varchar2
,p_cont_attribute17 in varchar2 default hr_api.g_varchar2
,p_cont_attribute18 in varchar2 default hr_api.g_varchar2
,p_cont_attribute19 in varchar2 default hr_api.g_varchar2
,p_cont_attribute20 in varchar2 default hr_api.g_varchar2
,p_cont_information_category in varchar2 default hr_api.g_varchar2
,p_cont_information1 in varchar2 default hr_api.g_varchar2
,p_cont_information2 in varchar2 default hr_api.g_varchar2
,p_cont_information3 in varchar2 default hr_api.g_varchar2
,p_cont_information4 in varchar2 default hr_api.g_varchar2
,p_cont_information5 in varchar2 default hr_api.g_varchar2
,p_cont_information6 in varchar2 default hr_api.g_varchar2
,p_cont_information7 in varchar2 default hr_api.g_varchar2
,p_cont_information8 in varchar2 default hr_api.g_varchar2
,p_cont_information9 in varchar2 default hr_api.g_varchar2
,p_cont_information10 in varchar2 default hr_api.g_varchar2
,p_cont_information11 in varchar2 default hr_api.g_varchar2
,p_cont_information12 in varchar2 default hr_api.g_varchar2
,p_cont_information13 in varchar2 default hr_api.g_varchar2
,p_cont_information14 in varchar2 default hr_api.g_varchar2
,p_cont_information15 in varchar2 default hr_api.g_varchar2
,p_cont_information16 in varchar2 default hr_api.g_varchar2
,p_cont_information17 in varchar2 default hr_api.g_varchar2
,p_cont_information18 in varchar2 default hr_api.g_varchar2
,p_cont_information19 in varchar2 default hr_api.g_varchar2
,p_cont_information20 in varchar2 default hr_api.g_varchar2
,p_object_version_number in out nocopy number
,p_return_status out nocopy varchar2
) IS
l_validate boolean :=false;
HR_CONTACT_REL_API.update_contact_relationship
( p_validate => l_validate
,p_effective_date => p_effective_date
,p_contact_relationship_id => p_contact_relationship_id
,p_contact_type => p_contact_type
,p_comments => p_comments
,p_primary_contact_flag => p_primary_contact_flag
,p_third_party_pay_flag => p_third_party_pay_flag
,p_bondholder_flag => p_bondholder_flag
,p_date_start => p_date_start
,p_start_life_reason_id => p_start_life_reason_id
,p_date_end => p_date_end
,p_end_life_reason_id => p_end_life_reason_id
,p_rltd_per_rsds_w_dsgntr_flag => p_rltd_per_rsds_w_dsgntr_flag
,p_personal_flag => p_personal_flag
,p_sequence_number => p_sequence_number
,p_dependent_flag => p_dependent_flag
,p_beneficiary_flag => p_beneficiary_flag
,p_cont_attribute_category => p_cont_attribute_category
,p_cont_attribute1 => p_cont_attribute1
,p_cont_attribute2 => p_cont_attribute2
,p_cont_attribute3 => p_cont_attribute3
,p_cont_attribute4 => p_cont_attribute4
,p_cont_attribute5 => p_cont_attribute5
,p_cont_attribute6 => p_cont_attribute6
,p_cont_attribute7 => p_cont_attribute7
,p_cont_attribute8 => p_cont_attribute8
,p_cont_attribute9 => p_cont_attribute9
,p_cont_attribute10 => p_cont_attribute10
,p_cont_attribute11 => p_cont_attribute11
,p_cont_attribute12 => p_cont_attribute12
,p_cont_attribute13 => p_cont_attribute13
,p_cont_attribute14 => p_cont_attribute14
,p_cont_attribute15 => p_cont_attribute15
,p_cont_attribute16 => p_cont_attribute16
,p_cont_attribute17 => p_cont_attribute17
,p_cont_attribute18 => p_cont_attribute18
,p_cont_attribute19 => p_cont_attribute19
,p_cont_attribute20 => p_cont_attribute20
,p_cont_information_category => p_cont_information_category
,p_cont_information1 => p_cont_information1
,p_cont_information2 => p_cont_information2
,p_cont_information3 => p_cont_information3
,p_cont_information4 => p_cont_information4
,p_cont_information5 => p_cont_information5
,p_cont_information6 => p_cont_information6
,p_cont_information7 => p_cont_information7
,p_cont_information8 => p_cont_information8
,p_cont_information9 => p_cont_information9
,p_cont_information10 => p_cont_information10
,p_cont_information11 => p_cont_information11
,p_cont_information12 => p_cont_information12
,p_cont_information13 => p_cont_information13
,p_cont_information14 => p_cont_information14
,p_cont_information15 => p_cont_information15
,p_cont_information16 => p_cont_information16
,p_cont_information17 => p_cont_information17
,p_cont_information18 => p_cont_information18
,p_cont_information19 => p_cont_information19
,p_cont_information20 => p_cont_information20
,p_object_version_number => p_object_version_number
) ;
END update_contact_w;
procedure update_person_w
(p_validate in varchar2 default 'N'
,p_effective_date in date
,p_datetrack_update_mode in varchar2
,p_person_id in number
,p_object_version_number in out NOCOPY number
,p_person_type_id in number default hr_api.g_number
,p_last_name in varchar2 default hr_api.g_varchar2
,p_applicant_number in varchar2 default hr_api.g_varchar2
,p_comments in varchar2 default hr_api.g_varchar2
,p_date_employee_data_verified in date default hr_api.g_date
,p_date_of_birth in date default hr_api.g_date
,p_email_address in varchar2 default hr_api.g_varchar2
,p_employee_number in out NOCOPY varchar2
,p_expense_check_send_to_addres in varchar2 default hr_api.g_varchar2
,p_first_name in varchar2 default hr_api.g_varchar2
,p_known_as in varchar2 default hr_api.g_varchar2
,p_marital_status in varchar2 default hr_api.g_varchar2
,p_middle_names in varchar2 default hr_api.g_varchar2
,p_nationality in varchar2 default hr_api.g_varchar2
,p_national_identifier in varchar2 default hr_api.g_varchar2
,p_previous_last_name in varchar2 default hr_api.g_varchar2
,p_registered_disabled_flag in varchar2 default hr_api.g_varchar2
,p_sex in varchar2 default hr_api.g_varchar2
,p_title in varchar2 default hr_api.g_varchar2
,p_vendor_id in number default hr_api.g_number
,p_work_telephone in varchar2 default hr_api.g_varchar2
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_attribute21 in varchar2 default hr_api.g_varchar2
,p_attribute22 in varchar2 default hr_api.g_varchar2
,p_attribute23 in varchar2 default hr_api.g_varchar2
,p_attribute24 in varchar2 default hr_api.g_varchar2
,p_attribute25 in varchar2 default hr_api.g_varchar2
,p_attribute26 in varchar2 default hr_api.g_varchar2
,p_attribute27 in varchar2 default hr_api.g_varchar2
,p_attribute28 in varchar2 default hr_api.g_varchar2
,p_attribute29 in varchar2 default hr_api.g_varchar2
,p_attribute30 in varchar2 default hr_api.g_varchar2
,p_per_information_category in varchar2 default hr_api.g_varchar2
,p_per_information1 in varchar2 default hr_api.g_varchar2
,p_per_information2 in varchar2 default hr_api.g_varchar2
,p_per_information3 in varchar2 default hr_api.g_varchar2
,p_per_information4 in varchar2 default hr_api.g_varchar2
,p_per_information5 in varchar2 default hr_api.g_varchar2
,p_per_information6 in varchar2 default hr_api.g_varchar2
,p_per_information7 in varchar2 default hr_api.g_varchar2
,p_per_information8 in varchar2 default hr_api.g_varchar2
,p_per_information9 in varchar2 default hr_api.g_varchar2
,p_per_information10 in varchar2 default hr_api.g_varchar2
,p_per_information11 in varchar2 default hr_api.g_varchar2
,p_per_information12 in varchar2 default hr_api.g_varchar2
,p_per_information13 in varchar2 default hr_api.g_varchar2
,p_per_information14 in varchar2 default hr_api.g_varchar2
,p_per_information15 in varchar2 default hr_api.g_varchar2
,p_per_information16 in varchar2 default hr_api.g_varchar2
,p_per_information17 in varchar2 default hr_api.g_varchar2
,p_per_information18 in varchar2 default hr_api.g_varchar2
,p_per_information19 in varchar2 default hr_api.g_varchar2
,p_per_information20 in varchar2 default hr_api.g_varchar2
,p_per_information21 in varchar2 default hr_api.g_varchar2
,p_per_information22 in varchar2 default hr_api.g_varchar2
,p_per_information23 in varchar2 default hr_api.g_varchar2
,p_per_information24 in varchar2 default hr_api.g_varchar2
,p_per_information25 in varchar2 default hr_api.g_varchar2
,p_per_information26 in varchar2 default hr_api.g_varchar2
,p_per_information27 in varchar2 default hr_api.g_varchar2
,p_per_information28 in varchar2 default hr_api.g_varchar2
,p_per_information29 in varchar2 default hr_api.g_varchar2
,p_per_information30 in varchar2 default hr_api.g_varchar2
,p_date_of_death in date default hr_api.g_date
,p_background_check_status in varchar2 default hr_api.g_varchar2
,p_background_date_check in date default hr_api.g_date
,p_blood_type in varchar2 default hr_api.g_varchar2
,p_correspondence_language in varchar2 default hr_api.g_varchar2
,p_fast_path_employee in varchar2 default hr_api.g_varchar2
,p_fte_capacity in number default hr_api.g_number
,p_hold_applicant_date_until in date default hr_api.g_date
,p_honors in varchar2 default hr_api.g_varchar2
,p_internal_location in varchar2 default hr_api.g_varchar2
,p_last_medical_test_by in varchar2 default hr_api.g_varchar2
,p_last_medical_test_date in date default hr_api.g_date
,p_mailstop in varchar2 default hr_api.g_varchar2
,p_office_number in varchar2 default hr_api.g_varchar2
,p_on_military_service in varchar2 default hr_api.g_varchar2
,p_pre_name_adjunct in varchar2 default hr_api.g_varchar2
,p_projected_start_date in date default hr_api.g_date
,p_rehire_authorizor in varchar2 default hr_api.g_varchar2
,p_rehire_recommendation in varchar2 default hr_api.g_varchar2
,p_resume_exists in varchar2 default hr_api.g_varchar2
,p_resume_last_updated in date default hr_api.g_date
,p_second_passport_exists in varchar2 default hr_api.g_varchar2
,p_student_status in varchar2 default hr_api.g_varchar2
,p_work_schedule in varchar2 default hr_api.g_varchar2
,p_rehire_reason in varchar2 default hr_api.g_varchar2
,p_suffix in varchar2 default hr_api.g_varchar2
,p_benefit_group_id in number default hr_api.g_number
,p_receipt_of_death_cert_date in date default hr_api.g_date
,p_coord_ben_med_pln_no in varchar2 default hr_api.g_varchar2
,p_coord_ben_no_cvg_flag in varchar2 default hr_api.g_varchar2
,p_coord_ben_med_ext_er in varchar2 default hr_api.g_varchar2
,p_coord_ben_med_pl_name in varchar2 default hr_api.g_varchar2
,p_coord_ben_med_insr_crr_name in varchar2 default hr_api.g_varchar2
,p_coord_ben_med_insr_crr_ident in varchar2 default hr_api.g_varchar2
,p_coord_ben_med_cvg_strt_dt in date default hr_api.g_date
,p_coord_ben_med_cvg_end_dt in date default hr_api.g_date
,p_uses_tobacco_flag in varchar2 default hr_api.g_varchar2
,p_dpdnt_adoption_date in date default hr_api.g_date
,p_dpdnt_vlntry_svce_flag in varchar2 default hr_api.g_varchar2
,p_original_date_of_hire in date default hr_api.g_date
,p_adjusted_svc_date in date default hr_api.g_date
,p_town_of_birth in varchar2 default hr_api.g_varchar2
,p_region_of_birth in varchar2 default hr_api.g_varchar2
,p_country_of_birth in varchar2 default hr_api.g_varchar2
,p_global_person_id in varchar2 default hr_api.g_varchar2
,p_party_id in number default hr_api.g_number
,p_npw_number in varchar2 default hr_api.g_varchar2
,p_effective_start_date out NOCOPY date
,p_effective_end_date out NOCOPY date
,p_full_name out NOCOPY varchar2
,p_comment_id out NOCOPY number
,p_name_combination_warning out NOCOPY varchar2
,p_assign_payroll_warning out NOCOPY varchar2
,p_orig_hire_warning out NOCOPY varchar2
,p_return_status out NOCOPY varchar2
) is
l_validate boolean :=false;
hr_person_api.update_person
(p_validate =>l_validate
,p_effective_date =>p_effective_date
,p_datetrack_update_mode =>p_datetrack_update_mode
,p_person_id =>p_person_id
,p_object_version_number =>p_object_version_number
,p_person_type_id =>p_person_type_id
,p_last_name =>p_last_name
,p_applicant_number =>p_applicant_number
,p_comments =>p_comments
,p_date_employee_data_verified =>p_date_employee_data_verified
,p_date_of_birth =>p_date_of_birth
,p_email_address =>p_email_address
,p_employee_number =>p_employee_number
,p_expense_check_send_to_addres =>p_expense_check_send_to_addres
,p_first_name =>p_first_name
,p_known_as =>p_known_as
,p_marital_status =>p_marital_status
,p_middle_names =>p_middle_names
,p_nationality =>p_nationality
,p_national_identifier =>p_national_identifier
,p_previous_last_name =>p_previous_last_name
,p_registered_disabled_flag =>p_registered_disabled_flag
,p_sex =>p_sex
,p_title =>p_title
,p_vendor_id =>p_vendor_id
,p_work_telephone =>p_work_telephone
,p_attribute_category =>p_attribute_category
,p_attribute1 =>p_attribute1
,p_attribute2 =>p_attribute2
,p_attribute3 =>p_attribute3
,p_attribute4 =>p_attribute4
,p_attribute5 =>p_attribute5
,p_attribute6 =>p_attribute6
,p_attribute7 =>p_attribute7
,p_attribute8 =>p_attribute8
,p_attribute9 =>p_attribute9
,p_attribute10 =>p_attribute10
,p_attribute11 =>p_attribute11
,p_attribute12 =>p_attribute12
,p_attribute13 =>p_attribute13
,p_attribute14 =>p_attribute14
,p_attribute15 =>p_attribute15
,p_attribute16 =>p_attribute16
,p_attribute17 =>p_attribute17
,p_attribute18 =>p_attribute18
,p_attribute19 =>p_attribute19
,p_attribute20 =>p_attribute20
,p_attribute21 =>p_attribute21
,p_attribute22 =>p_attribute22
,p_attribute23 =>p_attribute23
,p_attribute24 =>p_attribute24
,p_attribute25 =>p_attribute25
,p_attribute26 =>p_attribute26
,p_attribute27 =>p_attribute27
,p_attribute28 =>p_attribute28
,p_attribute29 =>p_attribute29
,p_attribute30 =>p_attribute30
,p_per_information_category =>p_per_information_category
,p_per_information1 =>p_per_information1
,p_per_information2 =>p_per_information2
,p_per_information3 =>p_per_information3
,p_per_information4 =>p_per_information4
,p_per_information5 =>p_per_information5
,p_per_information6 =>p_per_information6
,p_per_information7 =>p_per_information7
,p_per_information8 =>p_per_information8
,p_per_information9 =>p_per_information9
,p_per_information10 =>p_per_information10
,p_per_information11 =>p_per_information11
,p_per_information12 =>p_per_information12
,p_per_information13 =>p_per_information13
,p_per_information14 =>p_per_information14
,p_per_information15 =>p_per_information15
,p_per_information16 =>p_per_information16
,p_per_information17 =>p_per_information17
,p_per_information18 =>p_per_information18
,p_per_information19 =>p_per_information19
,p_per_information20 =>p_per_information20
,p_per_information21 =>p_per_information21
,p_per_information22 =>p_per_information22
,p_per_information23 =>p_per_information23
,p_per_information24 =>p_per_information24
,p_per_information25 =>p_per_information25
,p_per_information26 =>p_per_information26
,p_per_information27 =>p_per_information27
,p_per_information28 =>p_per_information28
,p_per_information29 =>p_per_information29
,p_per_information30 =>p_per_information30
,p_date_of_death =>p_date_of_death
,p_background_check_status =>p_background_check_status
,p_background_date_check =>p_background_date_check
,p_blood_type =>p_blood_type
,p_correspondence_language =>p_correspondence_language
,p_fast_path_employee =>p_fast_path_employee
,p_fte_capacity =>p_fte_capacity
,p_hold_applicant_date_until =>p_hold_applicant_date_until
,p_honors =>p_honors
,p_internal_location =>p_internal_location
,p_last_medical_test_by =>p_last_medical_test_by
,p_last_medical_test_date =>p_last_medical_test_date
,p_mailstop =>p_mailstop
,p_office_number =>p_office_number
,p_on_military_service =>p_on_military_service
,p_pre_name_adjunct =>p_pre_name_adjunct
,p_projected_start_date =>p_projected_start_date
,p_rehire_authorizor =>p_rehire_authorizor
,p_rehire_recommendation =>p_rehire_recommendation
,p_resume_exists =>p_resume_exists
,p_resume_last_updated =>p_resume_last_updated
,p_second_passport_exists =>p_second_passport_exists
,p_student_status =>p_student_status
,p_work_schedule =>p_work_schedule
,p_rehire_reason =>p_rehire_reason
,p_suffix =>p_suffix
,p_benefit_group_id =>p_benefit_group_id
,p_receipt_of_death_cert_date =>p_receipt_of_death_cert_date
,p_coord_ben_med_pln_no =>p_coord_ben_med_pln_no
,p_coord_ben_no_cvg_flag =>p_coord_ben_no_cvg_flag
,p_coord_ben_med_ext_er =>p_coord_ben_med_ext_er
,p_coord_ben_med_pl_name =>p_coord_ben_med_pl_name
,p_coord_ben_med_insr_crr_name =>p_coord_ben_med_insr_crr_name
,p_coord_ben_med_insr_crr_ident =>p_coord_ben_med_insr_crr_ident
,p_coord_ben_med_cvg_strt_dt =>p_coord_ben_med_cvg_strt_dt
,p_coord_ben_med_cvg_end_dt =>p_coord_ben_med_cvg_end_dt
,p_uses_tobacco_flag =>p_uses_tobacco_flag
,p_dpdnt_adoption_date =>p_dpdnt_adoption_date
,p_dpdnt_vlntry_svce_flag =>p_dpdnt_vlntry_svce_flag
,p_original_date_of_hire =>p_original_date_of_hire
,p_adjusted_svc_date =>p_adjusted_svc_date
,p_town_of_birth =>p_town_of_birth
,p_region_of_birth =>p_region_of_birth
,p_country_of_birth =>p_country_of_birth
,p_global_person_id =>p_global_person_id
,p_party_id =>p_party_id
,p_npw_number =>p_npw_number
,p_effective_start_date =>p_effective_start_date
,p_effective_end_date =>p_effective_end_date
,p_full_name =>p_full_name
,p_comment_id =>p_comment_id
,p_name_combination_warning =>l_name_combination_warning
,p_assign_payroll_warning =>l_assign_payroll_warning
,p_orig_hire_warning =>l_orig_hire_warning
);
END update_person_w;