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 297: ben_ext_util.write_err

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

Line 2712: l_from_date := ben_ext_util.calc_ext_date

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

Line 2745: l_to_date := ben_ext_util.calc_ext_date

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5725: l_ext_strt_dt := ben_ext_util.calc_ext_date

5721: l_line := 3;
5722: -- Calculate actual extract dates
5723: --
5724: /*
5725: l_ext_strt_dt := ben_ext_util.calc_ext_date
5726: (p_ext_date_cd => l_ext_strt_dt_cd,
5727: p_abs_date => l_effective_date,
5728: p_ext_dfn_id => p_ext_dfn_id
5729: );

Line 5738: l_ext_end_dt := ben_ext_util.calc_ext_date

5734: l_ext_end_dt := l_ext_strt_dt;
5735: --
5736: ELSE
5737: --
5738: l_ext_end_dt := ben_ext_util.calc_ext_date
5739: (p_ext_date_cd => l_ext_end_dt_cd,
5740: p_abs_date => l_effective_date,
5741: p_ext_dfn_id => p_ext_dfn_id
5742: );