APPS.BEN_PERSON_DELETE dependencies on HR_API

Line 3157: pen.effective_end_date = hr_api.g_eot and

3153: ben_ler_f ler
3154: WHERE pen.person_id=p_person_id and
3155: pen.prtt_enrt_rslt_stat_cd is null and
3156: -- pen.sspndd_flag='N' and Needs to resolve suspended record also
3157: pen.effective_end_date = hr_api.g_eot and
3158: p_effective_date between pen.enrt_cvg_strt_dt and
3159: pen.enrt_cvg_thru_dt
3160: and ler.ler_id=pen.ler_id
3161: AND pen.business_group_id = ler.business_group_id

Line 3203: ecd.effective_end_date = hr_api.g_eot

3199: pil.person_id=p_person_id and
3200: pil.per_in_ler_id = ecd.per_in_ler_id and
3201: pil.business_group_id = ecd.business_group_id and
3202: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and
3203: ecd.effective_end_date = hr_api.g_eot
3204: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3205: pen.prtt_enrt_rslt_stat_cd is null
3206: AND pil.ler_id = ler.ler_id
3207: AND pil.business_group_id = ler.business_group_id

Line 3225: ecd.effective_end_date = hr_api.g_eot

3221: ben_prtt_enrt_rslt_f pen
3222: WHERE
3223: ecd.dpnt_person_id = p_person_id and
3224: p_effective_date between ecd.cvg_strt_dt and cvg_thru_dt and
3225: ecd.effective_end_date = hr_api.g_eot
3226: and pil.per_in_ler_id = ecd.per_in_ler_id
3227: and pil.business_group_id = ecd.business_group_id
3228: and ecd.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3229: pen.prtt_enrt_rslt_stat_cd is null

Line 3248: pbn.effective_end_date = hr_api.g_eot

3244: ben_prtt_enrt_rslt_f pen
3245: WHERE
3246: pbn.bnf_person_id = p_person_id and
3247: p_effective_date between pbn.dsgn_strt_dt and pbn.dsgn_thru_dt and
3248: pbn.effective_end_date = hr_api.g_eot
3249: and pbn.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id and
3250: pen.prtt_enrt_rslt_stat_cd is null
3251: and pil.per_in_ler_id=pbn.per_in_ler_id
3252: AND pil.business_group_id = pbn.business_group_id

Line 3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);

3470: ben_batch_utils.g_audit_flag := true;
3471:
3472: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
3473:
3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);
3475: hr_api.mandatory_arg_error
3476: (p_api_name => l_proc
3477: ,p_argument => 'p_person_id'
3478: ,p_argument_value => p_person_id);

Line 3475: hr_api.mandatory_arg_error

3471:
3472: l_effective_date := trunc(fnd_date.canonical_to_date(p_effective_date));
3473:
3474: hr_utility.set_location ('hr_api.mandatory_arg_error',100);
3475: hr_api.mandatory_arg_error
3476: (p_api_name => l_proc
3477: ,p_argument => 'p_person_id'
3478: ,p_argument_value => p_person_id);
3479:

Line 3560: ,p_datetrack_delete_mode => hr_api.g_zap

3556: hr_utility.set_location('l_ele_rec.esd '||l_ele_rec.esd,60);
3557: ben_batch_utils.write(p_text => ' Deleting Element Entry '||l_ele_rec.ele_entry_id);
3558: py_element_entry_api.delete_element_entry
3559: (p_validate => l_validate
3560: ,p_datetrack_delete_mode => hr_api.g_zap
3561: ,p_effective_date => l_ele_rec.esd
3562: ,p_element_entry_id => l_ele_rec.ele_entry_id
3563: ,p_object_version_number => l_ele_rec.ovn
3564: ,p_effective_start_date => l_effective_start_date