eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on HR_API

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

1587: -- BENTMPCM process.
1588: --
1589: -- Check if mandatory arguments have been stipulated
1590: --
1591: hr_api.mandatory_arg_error(p_api_name => l_proc,
1592: p_argument => 'p_business_group_id',
1593: p_argument_value => g_parm.business_group_id);
1594: --
1595: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1591: hr_api.mandatory_arg_error(p_api_name => l_proc,
1592: p_argument => 'p_business_group_id',
1593: p_argument_value => g_parm.business_group_id);
1594: --
1595: hr_api.mandatory_arg_error(p_api_name => l_proc,
1596: p_argument => 'p_effective_date',
1597: p_argument_value => g_parm.effective_date);
1598: --
1599: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1595: hr_api.mandatory_arg_error(p_api_name => l_proc,
1596: p_argument => 'p_effective_date',
1597: p_argument_value => g_parm.effective_date);
1598: --
1599: hr_api.mandatory_arg_error(p_api_name => l_proc,
1600: p_argument => 'p_validate',
1601: p_argument_value => g_parm.validate_flag);
1602: --
1603: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1599: hr_api.mandatory_arg_error(p_api_name => l_proc,
1600: p_argument => 'p_validate',
1601: p_argument_value => g_parm.validate_flag);
1602: --
1603: hr_api.mandatory_arg_error(p_api_name => l_proc,
1604: p_argument => 'p_cm_trgr_typ_cd',
1605: p_argument_value => g_parm.cm_trgr_typ_cd);
1606: --
1607: -- Business Rule Checks

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

3682: and pen.ler_id = nvl(g_parm.ler_id, pen.ler_id)
3683: and pen.business_group_id = g_parm.business_group_id
3684: and g_parm.effective_date between pen.effective_start_date
3685: and pen.effective_end_date
3686: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3687: and pen.prtt_enrt_rslt_stat_cd is null
3688: and pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
3689: and (g_parm.actn_typ_id is null or
3690: pea.actn_typ_id = g_parm.actn_typ_id)

Line 3951: /* and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot

3947: and pen.sspndd_flag = 'N'
3948: and pen.prtt_enrt_rslt_stat_cd is null
3949: and pen.business_group_id = g_parm.business_group_id
3950: /* Bug 12414987: Check whether Participant is covered or not as of g_parm.effective_date */
3951: /* and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3952: and g_parm.effective_date between pen.effective_start_date
3953: and pen.effective_end_date
3954: and pen.effective_end_date = hr_api.g_eot*/
3955: and g_parm.effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt

Line 3954: and pen.effective_end_date = hr_api.g_eot*/

3950: /* Bug 12414987: Check whether Participant is covered or not as of g_parm.effective_date */
3951: /* and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3952: and g_parm.effective_date between pen.effective_start_date
3953: and pen.effective_end_date
3954: and pen.effective_end_date = hr_api.g_eot*/
3955: and g_parm.effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
3956: and pen.enrt_cvg_thru_dt <= pen.effective_end_date;
3957: --
3958: cursor c_dpnt_enrt(v_person_id number) is

Line 3964: and pdp.cvg_thru_dt = hr_api.g_eot

3960: pen.pl_id
3961: from ben_prtt_enrt_rslt_f pen,
3962: ben_elig_cvrd_dpnt_f pdp
3963: where pdp.dpnt_person_id = v_person_id
3964: and pdp.cvg_thru_dt = hr_api.g_eot
3965: and g_parm.effective_date between
3966: pdp.effective_start_date and pdp.effective_end_date
3967: and pdp.effective_end_date = hr_api.g_eot
3968: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 3967: and pdp.effective_end_date = hr_api.g_eot

3963: where pdp.dpnt_person_id = v_person_id
3964: and pdp.cvg_thru_dt = hr_api.g_eot
3965: and g_parm.effective_date between
3966: pdp.effective_start_date and pdp.effective_end_date
3967: and pdp.effective_end_date = hr_api.g_eot
3968: and pdp.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3969: and (g_parm.pgm_id is null or
3970: pen.pgm_id = g_parm.pgm_id)
3971: and ((g_parm.pl_nip_id is null

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

3979: (g_parm.pl_nip_id = pen.pl_id))
3980: and pen.sspndd_flag = 'N'
3981: and pen.prtt_enrt_rslt_stat_cd is null
3982: and pen.business_group_id = g_parm.business_group_id
3983: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3984: and g_parm.effective_date between
3985: pen.effective_start_date and pen.effective_end_date
3986: and pen.effective_end_date = hr_api.g_eot;
3987: --

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

3982: and pen.business_group_id = g_parm.business_group_id
3983: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
3984: and g_parm.effective_date between
3985: pen.effective_start_date and pen.effective_end_date
3986: and pen.effective_end_date = hr_api.g_eot;
3987: --
3988: l_start_person_action_id number;
3989: l_ending_person_action_id number;
3990: l_range_id number;

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

4342: and pen.sspndd_flag = 'N'
4343: and pen.prtt_enrt_rslt_stat_cd is null
4344: and pen.business_group_id = g_parm.business_group_id
4345: /* Bug 12414987: Check whether Participant is covered or not as of g_parm.effective_date */
4346: --and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4347: --and g_parm.effective_date between pen.effective_start_date and pen.effective_end_date
4348: and g_parm.effective_date between pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
4349: and pen.enrt_cvg_thru_dt <= pen.effective_end_date
4350:

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

4415: and (g_parm.pl_nip_id = pen.pl_id)
4416: and pen.sspndd_flag = 'N'
4417: and pen.prtt_enrt_rslt_stat_cd is null
4418: and pen.business_group_id = g_parm.business_group_id
4419: and nvl(pen.enrt_cvg_thru_dt, hr_api.g_eot) = hr_api.g_eot
4420: and g_parm.effective_date between pen.effective_start_date and pen.effective_end_date
4421: ))
4422: )
4423: and ((g_parm.organization_id is null and