APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on HR_API

Line 673: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot

669: where pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
670: and pea.cmpltd_dt is null
671: and p_effective_date between pea.effective_start_date
672: and pea.effective_end_date)
673: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
674: and p_effective_date between pen.effective_start_date
675: and pen.effective_end_date -1
676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result

Line 676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840

672: and pea.effective_end_date)
673: and nvl(pen.enrt_cvg_thru_dt,hr_api.g_eot) = hr_api.g_eot
674: and p_effective_date between pen.effective_start_date
675: and pen.effective_end_date -1
676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result
678: where pen1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
679: and pen1.effective_end_date = hr_api.g_eot
680: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot

Line 679: and pen1.effective_end_date = hr_api.g_eot

675: and pen.effective_end_date -1
676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result
678: where pen1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
679: and pen1.effective_end_date = hr_api.g_eot
680: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot
681: )
682: )
683: and pen.effective_end_date >= pen.enrt_cvg_strt_dt;

Line 680: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot

676: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
677: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result
678: where pen1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
679: and pen1.effective_end_date = hr_api.g_eot
680: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot
681: )
682: )
683: and pen.effective_end_date >= pen.enrt_cvg_strt_dt;
684: --

Line 716: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt

712: -- Get minimum due date of all open, required actions for a result
713: --
714: cursor c_actn_min (c_prtt_enrt_rslt_id number)
715: is
716: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
717: from ben_prtt_enrt_actn_f b,
718: ben_per_in_ler pil
719: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
720: and b.business_group_id = p_business_group_id

Line 972: ,p_datetrack_mode => hr_api.g_delete

968: ,p_effective_start_date => l_process_rec(i).effective_start_date
969: ,p_effective_end_date => l_process_rec(i).effective_end_date
970: ,p_object_version_number => l_process_rec(i).object_version_number
971: ,p_effective_date => p_effective_date
972: ,p_datetrack_mode => hr_api.g_delete
973: ,p_multi_row_validate => TRUE
974: ,p_source => 'benuneai');
975: --
976: If (p_audit_log = 'Y')then

Line 1080: ,p_datetrack_mode => hr_api.g_delete

1076: remove_prtt_actn
1077: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1078: ,p_business_group_id => p_business_group_id
1079: ,p_effective_date => p_effective_date
1080: ,p_datetrack_mode => hr_api.g_delete
1081: ,p_object_version_number => l_reca.object_version_number
1082: ,p_prtt_enrt_rslt_id => l_dump_number
1083: ,p_rslt_object_version_number => l_dump_number
1084: ,p_unsuspend_enrt_flag => 'N'

Line 1210: ,p_datetrack_mode => hr_api.g_delete

1206: remove_prtt_actn
1207: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1208: ,p_business_group_id => p_business_group_id
1209: ,p_effective_date => p_effective_date
1210: ,p_datetrack_mode => hr_api.g_delete
1211: ,p_object_version_number => l_reca.object_version_number
1212: ,p_prtt_enrt_rslt_id => l_dump_number
1213: ,p_rslt_object_version_number => l_dump_number
1214: ,p_unsuspend_enrt_flag => 'N'

Line 1738: and nvl(pen.effective_end_date,hr_api.g_eot) = hr_api.g_eot

1734: where pen.business_group_id = p_business_group_id
1735: and pen.business_group_id = actn.business_group_id
1736: and pen.prtt_enrt_rslt_stat_cd is null
1737: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
1738: and nvl(pen.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1739: and nvl(actn.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1740: and actn.cmpltd_dt is null
1741: and (p_person_id is null or
1742: pen.person_id = p_person_id)

Line 1739: and nvl(actn.effective_end_date,hr_api.g_eot) = hr_api.g_eot

1735: and pen.business_group_id = actn.business_group_id
1736: and pen.prtt_enrt_rslt_stat_cd is null
1737: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
1738: and nvl(pen.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1739: and nvl(actn.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1740: and actn.cmpltd_dt is null
1741: and (p_person_id is null or
1742: pen.person_id = p_person_id)
1743: and (p_location_id is null or

Line 1803: hr_api.mandatory_arg_error(p_api_name => l_proc

1799: p_commit => l_commit);
1800: --
1801: -- Make sure all the mandatory input parameters are not null
1802: --
1803: hr_api.mandatory_arg_error(p_api_name => l_proc
1804: ,p_argument => 'p_effective_date'
1805: ,p_argument_value => l_effective_date
1806: );
1807: --