APPS.BEN_CLS_UNRESOLVED_ACTN_ITEM dependencies on HR_API

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

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

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

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

Line 684: and pen1.effective_end_date = hr_api.g_eot

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

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

681: and ( pen.effective_end_date = hr_api.g_eot or --Bug 4398840
682: not exists (select 'x' from ben_prtt_enrt_rslt_f pen1 -- to exclude the ended result
683: where pen1.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
684: and pen1.effective_end_date = hr_api.g_eot
685: and pen1.enrt_cvg_thru_dt <> hr_api.g_eot
686: )
687: )
688: and pen.effective_end_date >= pen.enrt_cvg_strt_dt;
689: --

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

805: -------------------------------------------------------------------------------
806: --
807: cursor c_actn_min (c_prtt_enrt_rslt_id number)
808: is
809: select min(nvl(b.due_dt,hr_api.g_eot)) due_dt
810: from ben_prtt_enrt_actn_f b,
811: ben_per_in_ler pil
812: where b.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
813: and b.business_group_id = p_business_group_id

Line 1109: ,p_datetrack_mode => hr_api.g_delete

1105: ,p_effective_start_date => l_process_rec(i).effective_start_date
1106: ,p_effective_end_date => l_process_rec(i).effective_end_date
1107: ,p_object_version_number => l_process_rec(i).object_version_number
1108: ,p_effective_date => p_effective_date
1109: ,p_datetrack_mode => hr_api.g_delete
1110: ,p_multi_row_validate => TRUE
1111: ,p_source => 'benuneai');
1112: --
1113: /*Bug 10145083: If the Suspended result is deleted, set the action code to 'D'*/

Line 1220: ,p_datetrack_mode => hr_api.g_delete

1216: remove_prtt_actn
1217: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1218: ,p_business_group_id => p_business_group_id
1219: ,p_effective_date => p_effective_date
1220: ,p_datetrack_mode => hr_api.g_delete
1221: ,p_object_version_number => l_reca.object_version_number
1222: ,p_prtt_enrt_rslt_id => l_dump_number
1223: ,p_rslt_object_version_number => l_dump_number
1224: ,p_unsuspend_enrt_flag => 'N'

Line 1350: ,p_datetrack_mode => hr_api.g_delete

1346: remove_prtt_actn
1347: (p_prtt_enrt_actn_id => l_reca.prtt_enrt_actn_id
1348: ,p_business_group_id => p_business_group_id
1349: ,p_effective_date => p_effective_date
1350: ,p_datetrack_mode => hr_api.g_delete
1351: ,p_object_version_number => l_reca.object_version_number
1352: ,p_prtt_enrt_rslt_id => l_dump_number
1353: ,p_rslt_object_version_number => l_dump_number
1354: ,p_unsuspend_enrt_flag => 'N'

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

1874: where pen.business_group_id = p_business_group_id
1875: and pen.business_group_id = actn.business_group_id
1876: and pen.prtt_enrt_rslt_stat_cd is null
1877: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
1878: and nvl(pen.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1879: and nvl(actn.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1880: and actn.cmpltd_dt is null
1881: and (p_person_id is null or
1882: pen.person_id = p_person_id)

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

1875: and pen.business_group_id = actn.business_group_id
1876: and pen.prtt_enrt_rslt_stat_cd is null
1877: and pen.prtt_enrt_rslt_id = actn.prtt_enrt_rslt_id
1878: and nvl(pen.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1879: and nvl(actn.effective_end_date,hr_api.g_eot) = hr_api.g_eot
1880: and actn.cmpltd_dt is null
1881: and (p_person_id is null or
1882: pen.person_id = p_person_id)
1883: and (p_location_id is null or

Line 1943: hr_api.mandatory_arg_error(p_api_name => l_proc

1939: p_commit => l_commit);
1940: --
1941: -- Make sure all the mandatory input parameters are not null
1942: --
1943: hr_api.mandatory_arg_error(p_api_name => l_proc
1944: ,p_argument => 'p_effective_date'
1945: ,p_argument_value => l_effective_date
1946: );
1947: --