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_PROVIDER_POOLS dependencies on BEN_BENEFIT_PRVDD_LEDGER_API

Line 1209: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

1205: ;
1206: hr_utility.set_location(l_proc, 60);
1207: if c_old_ledger%notfound then
1208: hr_utility.set_location('val is'||to_char(l_val),12);
1209: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
1210: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
1211: ,p_effective_start_date => l_effective_start_date
1212: ,p_effective_end_date => l_effective_end_date
1213: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1247: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

1243: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
1244: p_base_key_value => l_bnft_prvdd_ldgr_id,
1245: p_mode => l_datetrack_mode);
1246: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),70);
1247: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
1248: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
1249: ,p_effective_start_date => l_effective_start_date
1250: ,p_effective_end_date => l_effective_end_date
1251: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1461: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

1457: --
1458: if not p_calculate_only_mode then
1459: --
1460: if c_old_ledger%notfound then
1461: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
1462: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id
1463: ,p_effective_start_date => l_effective_start_date
1464: ,p_effective_end_date => l_effective_end_date
1465: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1500: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

1496: l_used_val <> l_val then
1497:
1498: hr_utility.set_location('UPDATING LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),51);
1499:
1500: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
1501: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id
1502: ,p_effective_start_date => l_effective_start_date
1503: ,p_effective_end_date => l_effective_end_date
1504: --

Line 1869: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

1865: else
1866:
1867: --nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR') then
1868: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
1869: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1870: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1871: p_effective_start_date => l_effective_start_date,
1872: p_effective_end_date => l_effective_end_date,
1873: p_object_version_number => l_object_version_number,

Line 1910: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

1906: l_datetrack_mode := hr_api.g_delete;
1907: l_effective_date := p_effective_date - 1 ;
1908: end if;
1909: --
1910: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1911: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1912: p_effective_start_date => l_effective_start_date,
1913: p_effective_end_date => l_effective_end_date,
1914: p_object_version_number => l_object_version_number,

Line 2024: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

2020: l_datetrack_mode := hr_api.g_delete;
2021: l_effective_date := p_effective_date - 1 ;
2022: end if;
2023: --
2024: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
2025: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
2026: p_effective_start_date => l_effective_start_date,
2027: p_effective_end_date => l_effective_end_date,
2028: p_object_version_number => l_object_version_number,

Line 2111: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

2107: l_datetrack_mode := hr_api.g_delete;
2108: l_effective_date := p_effective_date - 1 ;
2109: end if;
2110: --
2111: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
2112: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
2113: p_effective_start_date => l_effective_start_date,
2114: p_effective_end_date => l_effective_end_date,
2115: p_object_version_number => l_object_version_number,

Line 2257: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

2253: if ((not l_person_enrolled) or
2254: (nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR' and
2255: l_epe.prtt_enrt_rslt_id is null)) then
2256: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
2257: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
2258: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
2259: p_effective_start_date => l_effective_start_date,
2260: p_effective_end_date => l_effective_end_date,
2261: p_object_version_number => l_object_version_number,

Line 2879: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

2875: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2876: p_base_key_value => l_bnft_prvdd_ldgr_id,
2877: p_mode => l_datetrack_mode);
2878: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),20);
2879: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
2880: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2881: ,p_effective_start_date => l_effective_start_date
2882: ,p_effective_end_date => l_effective_end_date
2883: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2904: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

2900: --
2901: -- create a forfeit row
2902: --
2903: hr_utility.set_location('result_id='||to_char(p_prtt_enrt_rslt_id),35);
2904: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
2905: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2906: ,p_effective_start_date => l_effective_start_date
2907: ,p_effective_end_date => l_effective_end_date
2908: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2953: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

2949: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2950: p_base_key_value => l_bnft_prvdd_ldgr_id,
2951: p_mode => l_datetrack_mode);
2952: hr_utility.set_location('l_cash_recd_val is not null '||to_char(l_bnft_prvdd_ldgr_id),20);
2953: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
2954: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2955: ,p_effective_start_date => l_effective_start_date
2956: ,p_effective_end_date => l_effective_end_date
2957: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2974: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

2970: );
2971: --
2972: else
2973: hr_utility.set_location('CR NULL ='||to_char(p_prtt_enrt_rslt_id),35);
2974: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
2975: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2976: ,p_effective_start_date => l_effective_start_date
2977: ,p_effective_end_date => l_effective_end_date
2978: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3024: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3020: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3021: p_base_key_value => l_bnft_prvdd_ldgr_id,
3022: p_mode => l_datetrack_mode);
3023: hr_utility.set_location('l_cash_recd_val is not null '||to_char(l_bnft_prvdd_ldgr_id),20.1);
3024: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3025: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3026: ,p_effective_start_date => l_effective_start_date
3027: ,p_effective_end_date => l_effective_end_date
3028: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3378: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

3374: if c_old_ledger%notfound
3375: and not p_calculate_only_mode
3376: then
3377: hr_utility.set_location('insert cash row', 290);
3378: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
3379: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3380: ,p_effective_start_date => l_effective_start_date
3381: ,p_effective_end_date => l_effective_end_date
3382: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3416: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3412: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3413: p_base_key_value => l_bnft_prvdd_ldgr_id,
3414: p_mode => l_datetrack_mode);
3415: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),340);
3416: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3417: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3418: ,p_effective_start_date => l_effective_start_date
3419: ,p_effective_end_date => l_effective_end_date
3420: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3943: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3939: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3940: p_base_key_value => l_bnft_prvdd_ldgr_id,
3941: p_mode => l_datetrack_mode);
3942: l_balance := 0;
3943: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3944: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3945: ,p_effective_start_date => l_effective_start_date
3946: ,p_effective_end_date => l_effective_end_date
3947: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 3986: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

3982: hr_utility.set_location(l_proc, 80);
3983: if c_old_ledger%notfound then
3984: hr_utility.set_location(l_proc, 90);
3985: l_rollover_diff_total:=l_rollover_diff_total+l_balance;
3986: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
3987: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3988: ,p_effective_start_date => l_effective_start_date
3989: ,p_effective_end_date => l_effective_end_date
3990: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 4023: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

4019: p_base_key_value => l_bnft_prvdd_ldgr_id,
4020: p_mode => l_datetrack_mode);
4021: hr_utility.set_location('UPDATING LDGR ID='||to_char(l_bnft_prvdd_ldgr_id),120);
4022: l_rollover_diff_total:=l_rollover_diff_total+l_balance-l_old_rlovr_val;
4023: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
4024: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
4025: ,p_effective_start_date => l_effective_start_date
4026: ,p_effective_end_date => l_effective_end_date
4027: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 5523: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

5519: l_effective_date := p_effective_date -1;
5520: --
5521: end if;
5522: --
5523: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
5524: p_validate => false,
5525: p_bnft_prvdd_ldgr_id => l_bpl_rec.bnft_prvdd_ldgr_id,
5526: p_effective_start_date => l_effective_start_date,
5527: p_effective_end_date => l_effective_end_date,

Line 5958: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

5954: --
5955: if c_prv%found then
5956: --
5957: l_rollover_diff_total:=l_rollover_diff_total+l_balance;
5958: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
5959: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
5960: ,p_effective_start_date => l_effective_start_date
5961: ,p_effective_end_date => l_effective_end_date
5962: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 6015: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

6011: p_base_key_value => l_bnft_prvdd_ldgr_id,
6012: p_mode => l_datetrack_mode);
6013: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),120);
6014: l_rollover_diff_total:=l_rollover_diff_total+l_balance-l_old_rlovr_val;
6015: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
6016: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
6017: ,p_effective_start_date => l_effective_start_date
6018: ,p_effective_end_date => l_effective_end_date
6019: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 7028: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

7024: end loop;
7025: close c_bpl_esd;
7026: --
7027: --
7028: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
7029: p_validate => false,
7030: p_bnft_prvdd_ldgr_id => l_dbt_bpl_rec.bnft_prvdd_ldgr_id,
7031: p_effective_start_date => l_effective_start_date,
7032: p_effective_end_date => l_effective_end_date,