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 3209: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3205: l_include := 'Y';
3206: --
3207: if p_ext_crit_prfl_id is not null THEN
3208: --
3209: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3210: (p_person_id => p_person_id,
3211: p_postal_code => g_prim_postal_code,
3212: p_org_id => g_employee_organization_id,
3213: p_loc_id => g_location_id,

Line 3339: ben_ext_evaluate_inclusion.evaluate_change_log_incl

3335: l_include := 'Y';
3336: --
3337: if p_ext_crit_prfl_id is not null THEN
3338: --
3339: ben_ext_evaluate_inclusion.evaluate_change_log_incl
3340: (p_chg_evt_cd => g_chg_evt_cd,
3341: p_chg_evt_source => g_chg_evt_source,
3342: p_chg_eff_dt => g_chg_eff_dt,
3343: p_chg_actl_dt => g_chg_actl_dt,

Line 3361: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3357: ) ;
3358: --
3359: if p_ext_crit_prfl_id is not null THEN
3360: --
3361: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3362: (p_person_id => p_person_id,
3363: p_postal_code => g_prim_postal_code,
3364: p_org_id => g_employee_organization_id,
3365: p_loc_id => g_location_id,

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

3512: l_pay_evt_srno := 1 ;
3513:
3514: --- determine the adv dates only one for a process
3515:
3516: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3517: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3519:
3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );

Line 3517: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and

3513:
3514: --- determine the adv dates only one for a process
3515:
3516: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3517: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3519:
3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3521: if g_pay_adv_date_mode is null then

Line 3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then

3514: --- determine the adv dates only one for a process
3515:
3516: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3517: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3518: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3519:
3520: hr_utility.set_location('pay adv condition mode ' ||g_pay_adv_date_mode , 66 );
3521: if g_pay_adv_date_mode is null then
3522: hr_utility.set_location('pay adv condition exisit withoutot other criteria' , 66 );

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

3570: l_pay_proration_changes.delete ;
3571: l_pay_pro_type_tab.delete ;
3572:
3573:
3574: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3575: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3576: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3577:
3578:

Line 3575: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and

3571: l_pay_pro_type_tab.delete ;
3572:
3573:
3574: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3575: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3576: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3577:
3578:
3579:

Line 3576: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then

3572:
3573:
3574: If ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'N' and
3575: ben_ext_evaluate_inclusion.g_chg_eff_dt_incl_rqd = 'N' and
3576: ben_ext_evaluate_inclusion.g_cmbn_incl_rqd = 'Y' then
3577:
3578:
3579:
3580:

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

3772:
3773:
3774: Begin
3775:
3776: if l_chg_actl_strt_dt is not null and ben_ext_evaluate_inclusion.g_chg_actl_dt_incl_rqd = 'Y' then
3777: -- call the interpreter in actual date mode
3778: -- as per my understanding from PQP - ram
3779: -- since the actual date has the time stamp , the time stamp play the role in extracting info
3780: -- so the from date is truncated and to date is extended to the last second of the day

Line 3945: ben_ext_evaluate_inclusion.evaluate_change_log_incl

3941: l_include := 'Y';
3942: --
3943: if p_ext_crit_prfl_id is not null THEN
3944: --
3945: ben_ext_evaluate_inclusion.evaluate_change_log_incl
3946: (p_chg_evt_cd => g_chg_evt_cd,
3947: p_chg_evt_source => g_chg_evt_source,
3948: p_chg_eff_dt => trunc(g_chg_eff_dt),
3949: p_chg_actl_dt => trunc(g_chg_actl_dt) ,

Line 3971: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

3967: ) ;
3968: --
3969: if p_ext_crit_prfl_id is not null THEN
3970: --
3971: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
3972: (p_person_id => p_person_id,
3973: p_postal_code => g_prim_postal_code,
3974: p_org_id => g_employee_organization_id,
3975: p_loc_id => g_location_id,

Line 4168: ben_ext_evaluate_inclusion.evaluate_comm_incl

4164: l_include := 'Y';
4165: --
4166: if p_ext_crit_prfl_id is not null THEN
4167: --
4168: ben_ext_evaluate_inclusion.evaluate_comm_incl
4169: (p_cm_typ_id => g_cm_type_id,
4170: p_last_update_date => g_cm_last_update_date,
4171: p_pvdd_last_update_date => g_cm_pvdd_last_update_date,
4172: p_sent_dt => g_cm_sent_dt,

Line 4190: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

4186: --
4187: --
4188: if p_ext_crit_prfl_id is not null THEN
4189: --
4190: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
4191: (p_person_id => p_person_id,
4192: p_postal_code => g_prim_postal_code,
4193: p_org_id => g_employee_organization_id,
4194: p_loc_id => g_location_id,

Line 4293: ben_ext_evaluate_inclusion.evaluate_cwb_incl

4289: l_include := 'Y';
4290: --
4291: if p_ext_crit_prfl_id is not null THEN
4292: --
4293: ben_ext_evaluate_inclusion.evaluate_cwb_incl
4294: (p_group_pl_id => l_cwb.group_pl_id ,
4295: p_lf_evt_ocrd_dt => g_CWB_LE_DT ,
4296: p_include => l_include ,
4297: p_effective_date => p_effective_date )

Line 4316: ben_ext_evaluate_inclusion.Evaluate_Person_Incl

4312: --
4313: --
4314: if p_ext_crit_prfl_id is not null THEN
4315: --
4316: ben_ext_evaluate_inclusion.Evaluate_Person_Incl
4317: (p_person_id => p_person_id,
4318: p_postal_code => g_prim_postal_code,
4319: p_org_id => g_employee_organization_id,
4320: p_loc_id => g_location_id,