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_THREAD dependencies on BEN_EXT_UTIL

Line 295: ben_ext_util.write_err

291: end if;
292: --
293: if p_business_group_id is not null then
294: --
295: ben_ext_util.write_err
296: (p_err_num => p_err_num,
297: p_err_name => p_err_name,
298: p_typ_cd => p_typ_cd,
299: p_person_id => p_person_id,

Line 2710: l_from_date := ben_ext_util.calc_ext_date

2706: l_sql_string := l_sql_string || ' xcl.CHG_EFF_DT ' ;
2707: end if ;
2708: end if ;
2709: -- determne the from date
2710: l_from_date := ben_ext_util.calc_ext_date
2711: (p_ext_date_cd => k.val_1,
2712: p_abs_date => p_effective_date,
2713: p_ext_dfn_id => p_ext_dfn_id);
2714:

Line 2743: l_to_date := ben_ext_util.calc_ext_date

2739: ||''',''DD-MM-RRRR HH24:MI:SS'')';
2740: end if;
2741:
2742: elsif k.oper_cd = 'BE' then
2743: l_to_date := ben_ext_util.calc_ext_date
2744: (p_ext_date_cd => k.val_2,
2745: p_abs_date => p_effective_date,
2746: p_ext_dfn_id => p_ext_dfn_id);
2747: if k.crit_typ_cd = 'CAD' then

Line 3716: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,

3712: if l_cad_val1 in ('CHAD','CHED') then
3713: l_cad_date_from := hr_api.g_sot ;
3714: l_cad_date_to := hr_api.g_eot ;
3715: Else
3716: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
3717: p_abs_date => p_effective_date,
3718: p_ext_dfn_id => p_ext_dfn_id);
3719: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,
3720: p_abs_date => p_effective_date,

Line 3719: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,

3715: Else
3716: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
3717: p_abs_date => p_effective_date,
3718: p_ext_dfn_id => p_ext_dfn_id);
3719: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,
3720: p_abs_date => p_effective_date,
3721: p_ext_dfn_id => p_ext_dfn_id);
3722: end if ;
3723:

Line 3730: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,

3726: if l_ced_val1 in ('CHAD','CHED') then
3727: l_cad_date_from := hr_api.g_sot ;
3728: l_cad_date_to := hr_api.g_eot ;
3729: Else
3730: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
3731: p_abs_date => p_effective_date,
3732: p_ext_dfn_id => p_ext_dfn_id);
3733: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,
3734: p_abs_date => p_effective_date,

Line 3733: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,

3729: Else
3730: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
3731: p_abs_date => p_effective_date,
3732: p_ext_dfn_id => p_ext_dfn_id);
3733: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,
3734: p_abs_date => p_effective_date,
3735: p_ext_dfn_id => p_ext_dfn_id);
3736: end if;
3737: end if ;

Line 4330: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,

4326: if l_cad_val1 in ('CHAD','CHED') then
4327: l_cad_date_from := hr_api.g_sot ;
4328: l_cad_date_to := hr_api.g_eot ;
4329: Else
4330: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
4331: p_abs_date => p_effective_date,
4332: p_ext_dfn_id => p_ext_dfn_id);
4333: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,
4334: p_abs_date => p_effective_date,

Line 4333: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,

4329: Else
4330: l_cad_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val1,
4331: p_abs_date => p_effective_date,
4332: p_ext_dfn_id => p_ext_dfn_id);
4333: l_cad_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_cad_val2,
4334: p_abs_date => p_effective_date,
4335: p_ext_dfn_id => p_ext_dfn_id);
4336: end if ;
4337:

Line 4380: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,

4376: if l_ced_val1 in ('CHAD','CHED') then
4377: l_cad_date_from := hr_api.g_sot ;
4378: l_cad_date_to := hr_api.g_eot ;
4379: Else
4380: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
4381: p_abs_date => p_effective_date,
4382: p_ext_dfn_id => p_ext_dfn_id);
4383: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,
4384: p_abs_date => p_effective_date,

Line 4383: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,

4379: Else
4380: l_ced_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val1,
4381: p_abs_date => p_effective_date,
4382: p_ext_dfn_id => p_ext_dfn_id);
4383: l_ced_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_ced_val2,
4384: p_abs_date => p_effective_date,
4385: p_ext_dfn_id => p_ext_dfn_id);
4386:
4387: End if ;

Line 4536: l_mtbsdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val1,

4532: 'xct.crit_typ_cd = ''MTP'') ';
4533: end if;
4534: -- communication tobe send date
4535: if l_mtbsdt_exists = 'Y' and p_data_typ_cd in ('CM') then
4536: l_mtbsdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val1,
4537: p_abs_date => p_effective_date,
4538: p_ext_dfn_id => p_ext_dfn_id);
4539: l_mtbsdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val2,
4540: p_abs_date => p_effective_date,

Line 4539: l_mtbsdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val2,

4535: if l_mtbsdt_exists = 'Y' and p_data_typ_cd in ('CM') then
4536: l_mtbsdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val1,
4537: p_abs_date => p_effective_date,
4538: p_ext_dfn_id => p_ext_dfn_id);
4539: l_mtbsdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_mtbsdt_val2,
4540: p_abs_date => p_effective_date,
4541: p_ext_dfn_id => p_ext_dfn_id);
4542: if l_mtbsdt_exclude = 'N' then
4543: l_dynamic_sql := l_dynamic_sql || ' and pcp.to_be_sent_dt between to_date(''' ||

Line 4555: l_msdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val1,

4551: end if;
4552: end if;
4553: -- communication send date
4554: if l_msdt_exists = 'Y' and p_data_typ_cd in ('CM') then
4555: l_msdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val1,
4556: p_abs_date => p_effective_date,
4557: p_ext_dfn_id => p_ext_dfn_id);
4558: l_msdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val2,
4559: p_abs_date => p_effective_date,

Line 4558: l_msdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val2,

4554: if l_msdt_exists = 'Y' and p_data_typ_cd in ('CM') then
4555: l_msdt_date_from := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val1,
4556: p_abs_date => p_effective_date,
4557: p_ext_dfn_id => p_ext_dfn_id);
4558: l_msdt_date_to := ben_ext_util.calc_ext_date (p_ext_date_cd => l_msdt_val2,
4559: p_abs_date => p_effective_date,
4560: p_ext_dfn_id => p_ext_dfn_id);
4561: if l_msdt_exclude = 'N' then
4562: l_dynamic_sql := l_dynamic_sql || ' and pcp.sent_dt between to_date(''' ||

Line 5719: l_ext_strt_dt := ben_ext_util.calc_ext_date

5715: l_line := 3;
5716: -- Calculate actual extract dates
5717: --
5718: /*
5719: l_ext_strt_dt := ben_ext_util.calc_ext_date
5720: (p_ext_date_cd => l_ext_strt_dt_cd,
5721: p_abs_date => l_effective_date,
5722: p_ext_dfn_id => p_ext_dfn_id
5723: );

Line 5732: l_ext_end_dt := ben_ext_util.calc_ext_date

5728: l_ext_end_dt := l_ext_strt_dt;
5729: --
5730: ELSE
5731: --
5732: l_ext_end_dt := ben_ext_util.calc_ext_date
5733: (p_ext_date_cd => l_ext_end_dt_cd,
5734: p_abs_date => l_effective_date,
5735: p_ext_dfn_id => p_ext_dfn_id
5736: );