APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on HR_API

Line 1537: hr_api.mandatory_arg_error(p_api_name => l_proc,

1533: -- BENTMPCM process.
1534: --
1535: -- Check if mandatory arguments have been stipulated
1536: --
1537: hr_api.mandatory_arg_error(p_api_name => l_proc,
1538: p_argument => 'p_business_group_id',
1539: p_argument_value => g_parm.business_group_id);
1540: --
1541: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1541: hr_api.mandatory_arg_error(p_api_name => l_proc,

1537: hr_api.mandatory_arg_error(p_api_name => l_proc,
1538: p_argument => 'p_business_group_id',
1539: p_argument_value => g_parm.business_group_id);
1540: --
1541: hr_api.mandatory_arg_error(p_api_name => l_proc,
1542: p_argument => 'p_effective_date',
1543: p_argument_value => g_parm.effective_date);
1544: --
1545: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1545: hr_api.mandatory_arg_error(p_api_name => l_proc,

1541: hr_api.mandatory_arg_error(p_api_name => l_proc,
1542: p_argument => 'p_effective_date',
1543: p_argument_value => g_parm.effective_date);
1544: --
1545: hr_api.mandatory_arg_error(p_api_name => l_proc,
1546: p_argument => 'p_validate',
1547: p_argument_value => g_parm.validate_flag);
1548: --
1549: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1549: hr_api.mandatory_arg_error(p_api_name => l_proc,

1545: hr_api.mandatory_arg_error(p_api_name => l_proc,
1546: p_argument => 'p_validate',
1547: p_argument_value => g_parm.validate_flag);
1548: --
1549: hr_api.mandatory_arg_error(p_api_name => l_proc,
1550: p_argument => 'p_cm_trgr_typ_cd',
1551: p_argument_value => g_parm.cm_trgr_typ_cd);
1552: --
1553: -- Business Rule Checks

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

3624: and pen.ler_id = nvl(g_parm.ler_id, pen.ler_id)
3625: and pen.business_group_id = g_parm.business_group_id
3626: and g_parm.effective_date between pen.effective_start_date
3627: and pen.effective_end_date
3628: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3629: and pen.prtt_enrt_rslt_stat_cd is null
3630: and pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
3631: and (g_parm.actn_typ_id is null or
3632: pea.actn_typ_id = g_parm.actn_typ_id)

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

3888: (g_parm.pl_nip_id = pen.pl_id))
3889: and pen.sspndd_flag = 'N'
3890: and pen.prtt_enrt_rslt_stat_cd is null
3891: and pen.business_group_id = g_parm.business_group_id
3892: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3893: and g_parm.effective_date between pen.effective_start_date
3894: and pen.effective_end_date
3895: and pen.effective_end_date = hr_api.g_eot;
3896: --

Line 3895: and pen.effective_end_date = hr_api.g_eot;

3891: and pen.business_group_id = g_parm.business_group_id
3892: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3893: and g_parm.effective_date between pen.effective_start_date
3894: and pen.effective_end_date
3895: and pen.effective_end_date = hr_api.g_eot;
3896: --
3897: cursor c_dpnt_enrt(v_person_id number) is
3898: select pen.pgm_id,
3899: pen.pl_id

Line 3903: and pdp.cvg_thru_dt = hr_api.g_eot

3899: pen.pl_id
3900: from ben_prtt_enrt_rslt_f pen,
3901: ben_elig_cvrd_dpnt_f pdp
3902: where pdp.dpnt_person_id = v_person_id
3903: and pdp.cvg_thru_dt = hr_api.g_eot
3904: and g_parm.effective_date between
3905: pdp.effective_start_date and pdp.effective_end_date
3906: and pdp.effective_end_date = hr_api.g_eot
3907: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 3906: and pdp.effective_end_date = hr_api.g_eot

3902: where pdp.dpnt_person_id = v_person_id
3903: and pdp.cvg_thru_dt = hr_api.g_eot
3904: and g_parm.effective_date between
3905: pdp.effective_start_date and pdp.effective_end_date
3906: and pdp.effective_end_date = hr_api.g_eot
3907: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3908: and (g_parm.pgm_id is null or
3909: pen.pgm_id = g_parm.pgm_id)
3910: and ((g_parm.pl_nip_id is null

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

3918: (g_parm.pl_nip_id = pen.pl_id))
3919: and pen.sspndd_flag = 'N'
3920: and pen.prtt_enrt_rslt_stat_cd is null
3921: and pen.business_group_id = g_parm.business_group_id
3922: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3923: and g_parm.effective_date between
3924: pen.effective_start_date and pen.effective_end_date
3925: and pen.effective_end_date = hr_api.g_eot;
3926: --

Line 3925: and pen.effective_end_date = hr_api.g_eot;

3921: and pen.business_group_id = g_parm.business_group_id
3922: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3923: and g_parm.effective_date between
3924: pen.effective_start_date and pen.effective_end_date
3925: and pen.effective_end_date = hr_api.g_eot;
3926: --
3927: l_start_person_action_id number;
3928: l_ending_person_action_id number;
3929: l_range_id number;

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

4280: and (g_parm.pl_nip_id is null and g_parm.plan_in_pgm_flag = 'Y' and pen.pgm_id is not null)
4281: and pen.sspndd_flag = 'N'
4282: and pen.prtt_enrt_rslt_stat_cd is null
4283: and pen.business_group_id = g_parm.business_group_id
4284: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4285: and g_parm.effective_date between pen.effective_start_date and pen.effective_end_date
4286: ))
4287: )
4288: and ((g_parm.organization_id is null and

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

4350: and (g_parm.pl_nip_id = pen.pl_id)
4351: and pen.sspndd_flag = 'N'
4352: and pen.prtt_enrt_rslt_stat_cd is null
4353: and pen.business_group_id = g_parm.business_group_id
4354: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4355: and g_parm.effective_date between pen.effective_start_date and pen.effective_end_date
4356: ))
4357: )
4358: and ((g_parm.organization_id is null and