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_EXT_PERSON dependencies on BEN_EXT_EVALUATE_INCLUSION

Line 337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );

333: --if the assignment to use code is not defined then use
334: -- empl, benefit,applicant order
335:
336: if g_debug then
337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );
338: end if;
339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then
340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;
341: if g_debug then

Line 339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then

335:
336: if g_debug then
337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );
338: end if;
339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then
340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;
341: if g_debug then
342: hr_utility.set_location('order by user '|| l_asg_to_use_cd, 99 );
343: end if;

Line 340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;

336: if g_debug then
337: hr_utility.set_location('rqd '|| ben_ext_evaluate_inclusion.g_asg_to_use_rqd, 99 );
338: end if;
339: if ben_ext_evaluate_inclusion.g_asg_to_use_rqd = 'Y' then
340: l_asg_to_use_cd := ben_ext_evaluate_inclusion.g_asg_to_use_list(1) ;
341: if g_debug then
342: hr_utility.set_location('order by user '|| l_asg_to_use_cd, 99 );
343: end if;
344: end if ;

Line 3175: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3171: l_include := 'Y';
3172: --
3173: if p_ext_crit_prfl_id is not null THEN
3174: --
3175: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3176: (p_person_id => p_person_id,
3177: p_postal_code => g_prim_postal_code,
3178: p_org_id => g_employee_organization_id,
3179: p_loc_id => g_location_id,

Line 3305: ben_ext_evaluate_inclusion.evaluate_change_log_incl

3301: l_include := 'Y';
3302: --
3303: if p_ext_crit_prfl_id is not null THEN
3304: --
3305: ben_ext_evaluate_inclusion.evaluate_change_log_incl
3306: (p_chg_evt_cd => g_chg_evt_cd,
3307: p_chg_evt_source => g_chg_evt_source,
3308: p_chg_eff_dt => g_chg_eff_dt,
3309: p_chg_actl_dt => g_chg_actl_dt,

Line 3327: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3323: ) ;
3324: --
3325: if p_ext_crit_prfl_id is not null THEN
3326: --
3327: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3328: (p_person_id => p_person_id,
3329: p_postal_code => g_prim_postal_code,
3330: p_org_id => g_employee_organization_id,
3331: p_loc_id => g_location_id,

Line 3482: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and

3478: l_pay_evt_srno := 1 ;
3479:
3480: --- determine the adv dates only one for a process
3481:
3482: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3483: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3484: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3485:
3486: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );

Line 3483: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and

3479:
3480: --- determine the adv dates only one for a process
3481:
3482: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3483: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3484: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3485:
3486: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3487: if g_pay_adv_date_mode is null then

Line 3484: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then

3480: --- determine the adv dates only one for a process
3481:
3482: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3483: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3484: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3485:
3486: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3487: if g_pay_adv_date_mode is null then
3488: hr_utility.set_location('pay adv condition exisit withoutot other criteria' , 66 );

Line 3540: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and

3536: l_pay_proration_changes.delete ;
3537: l_pay_pro_type_tab.delete ;
3538:
3539:
3540: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3541: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3542: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3543:
3544:

Line 3541: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and

3537: l_pay_pro_type_tab.delete ;
3538:
3539:
3540: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3541: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3542: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3543:
3544:
3545:

Line 3542: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then

3538:
3539:
3540: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3541: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3542: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3543:
3544:
3545:
3546:

Line 3742: if l_chg_actl_strt_dt is not null and ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'Y' then

3738:
3739:
3740: Begin
3741:
3742: if l_chg_actl_strt_dt is not null and ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'Y' then
3743: -- call the interpreter in actual date mode
3744: -- as per my understanding from PQP - ram
3745: -- since the actual date has the time stamp , the time stamp play the role in extracting info
3746: -- so the from date is truncated and to date is extended to the last second of the day

Line 3911: ben_ext_evaluate_inclusion.evaluate_change_log_incl

3907: l_include := 'Y';
3908: --
3909: if p_ext_crit_prfl_id is not null THEN
3910: --
3911: ben_ext_evaluate_inclusion.evaluate_change_log_incl
3912: (p_chg_evt_cd => g_chg_evt_cd,
3913: p_chg_evt_source => g_chg_evt_source,
3914: p_chg_eff_dt => trunc(g_chg_eff_dt),
3915: p_chg_actl_dt => trunc(g_chg_actl_dt) ,

Line 3937: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3933: ) ;
3934: --
3935: if p_ext_crit_prfl_id is not null THEN
3936: --
3937: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3938: (p_person_id => p_person_id,
3939: p_postal_code => g_prim_postal_code,
3940: p_org_id => g_employee_organization_id,
3941: p_loc_id => g_location_id,

Line 4133: ben_ext_evaluate_inclusion.evaluate_comm_incl

4129: l_include := 'Y';
4130: --
4131: if p_ext_crit_prfl_id is not null THEN
4132: --
4133: ben_ext_evaluate_inclusion.evaluate_comm_incl
4134: (p_cm_typ_id => g_cm_type_id,
4135: p_last_update_date => g_cm_last_update_date,
4136: p_pvdd_last_update_date => g_cm_pvdd_last_update_date,
4137: p_sent_dt => g_cm_sent_dt,

Line 4155: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

4151: --
4152: --
4153: if p_ext_crit_prfl_id is not null THEN
4154: --
4155: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
4156: (p_person_id => p_person_id,
4157: p_postal_code => g_prim_postal_code,
4158: p_org_id => g_employee_organization_id,
4159: p_loc_id => g_location_id,

Line 4258: ben_ext_evaluate_inclusion.evaluate_cwb_incl

4254: l_include := 'Y';
4255: --
4256: if p_ext_crit_prfl_id is not null THEN
4257: --
4258: ben_ext_evaluate_inclusion.evaluate_cwb_incl
4259: (p_group_pl_id => l_cwb.group_pl_id ,
4260: p_lf_evt_ocrd_dt => g_CWB_LE_DT ,
4261: p_include => l_include ,
4262: p_effective_date => p_effective_date )

Line 4281: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

4277: --
4278: --
4279: if p_ext_crit_prfl_id is not null THEN
4280: --
4281: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
4282: (p_person_id => p_person_id,
4283: p_postal_code => g_prim_postal_code,
4284: p_org_id => g_employee_organization_id,
4285: p_loc_id => g_location_id,