DBA Data[Home] [Help]

APPS.BEN_PROVIDER_POOLS dependencies on BEN_BENEFIT_PRVDD_LEDGER_API

Line 1191: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

1187: ;
1188: hr_utility.set_location(l_proc, 60);
1189: if c_old_ledger%notfound then
1190: hr_utility.set_location('val is'||to_char(l_val),12);
1191: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
1192: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
1193: ,p_effective_start_date => l_effective_start_date
1194: ,p_effective_end_date => l_effective_end_date
1195: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1229: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

1225: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
1226: p_base_key_value => l_bnft_prvdd_ldgr_id,
1227: p_mode => l_datetrack_mode);
1228: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),70);
1229: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
1230: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
1231: ,p_effective_start_date => l_effective_start_date
1232: ,p_effective_end_date => l_effective_end_date
1233: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1442: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

1438: --
1439: if not p_calculate_only_mode then
1440: --
1441: if c_old_ledger%notfound then
1442: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
1443: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id
1444: ,p_effective_start_date => l_effective_start_date
1445: ,p_effective_end_date => l_effective_end_date
1446: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 1481: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

1477: l_used_val <> l_val then
1478:
1479: hr_utility.set_location('UPDATING LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),51);
1480:
1481: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
1482: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id
1483: ,p_effective_start_date => l_effective_start_date
1484: ,p_effective_end_date => l_effective_end_date
1485: --

Line 1809: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

1805: else
1806:
1807: --nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR') then
1808: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
1809: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1810: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1811: p_effective_start_date => l_effective_start_date,
1812: p_effective_end_date => l_effective_end_date,
1813: p_object_version_number => l_object_version_number,

Line 1893: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

1889: l_datetrack_mode := hr_api.g_delete;
1890: l_effective_date := p_effective_date - 1 ;
1891: end if;
1892: --
1893: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1894: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1895: p_effective_start_date => l_effective_start_date,
1896: p_effective_end_date => l_effective_end_date,
1897: p_object_version_number => l_object_version_number,

Line 1980: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

1976: l_datetrack_mode := hr_api.g_delete;
1977: l_effective_date := p_effective_date - 1 ;
1978: end if;
1979: --
1980: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1981: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1982: p_effective_start_date => l_effective_start_date,
1983: p_effective_end_date => l_effective_end_date,
1984: p_object_version_number => l_object_version_number,

Line 2126: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

2122: if ((not l_person_enrolled) or
2123: (nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR' and
2124: l_epe.prtt_enrt_rslt_id is null)) then
2125: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
2126: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
2127: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
2128: p_effective_start_date => l_effective_start_date,
2129: p_effective_end_date => l_effective_end_date,
2130: p_object_version_number => l_object_version_number,

Line 2748: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

2744: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2745: p_base_key_value => l_bnft_prvdd_ldgr_id,
2746: p_mode => l_datetrack_mode);
2747: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),20);
2748: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
2749: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2750: ,p_effective_start_date => l_effective_start_date
2751: ,p_effective_end_date => l_effective_end_date
2752: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2773: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

2769: --
2770: -- create a forfeit row
2771: --
2772: hr_utility.set_location('result_id='||to_char(p_prtt_enrt_rslt_id),35);
2773: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
2774: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2775: ,p_effective_start_date => l_effective_start_date
2776: ,p_effective_end_date => l_effective_end_date
2777: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2822: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

2818: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
2819: p_base_key_value => l_bnft_prvdd_ldgr_id,
2820: p_mode => l_datetrack_mode);
2821: hr_utility.set_location('l_cash_recd_val is not null '||to_char(l_bnft_prvdd_ldgr_id),20);
2822: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
2823: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2824: ,p_effective_start_date => l_effective_start_date
2825: ,p_effective_end_date => l_effective_end_date
2826: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 2843: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

2839: );
2840: --
2841: else
2842: hr_utility.set_location('CR NULL ='||to_char(p_prtt_enrt_rslt_id),35);
2843: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
2844: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
2845: ,p_effective_start_date => l_effective_start_date
2846: ,p_effective_end_date => l_effective_end_date
2847: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3199: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

3195: if c_old_ledger%notfound
3196: and not p_calculate_only_mode
3197: then
3198: hr_utility.set_location('insert cash row', 290);
3199: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
3200: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3201: ,p_effective_start_date => l_effective_start_date
3202: ,p_effective_end_date => l_effective_end_date
3203: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3237: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3233: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3234: p_base_key_value => l_bnft_prvdd_ldgr_id,
3235: p_mode => l_datetrack_mode);
3236: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),340);
3237: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3238: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3239: ,p_effective_start_date => l_effective_start_date
3240: ,p_effective_end_date => l_effective_end_date
3241: ,p_prtt_ro_of_unusd_amt_flag => 'N'

Line 3764: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3760: p_base_key_column => 'BNFT_PRVDD_LDGR_ID',
3761: p_base_key_value => l_bnft_prvdd_ldgr_id,
3762: p_mode => l_datetrack_mode);
3763: l_balance := 0;
3764: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3765: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3766: ,p_effective_start_date => l_effective_start_date
3767: ,p_effective_end_date => l_effective_end_date
3768: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 3807: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

3803: hr_utility.set_location(l_proc, 80);
3804: if c_old_ledger%notfound then
3805: hr_utility.set_location(l_proc, 90);
3806: l_rollover_diff_total:=l_rollover_diff_total+l_balance;
3807: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
3808: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3809: ,p_effective_start_date => l_effective_start_date
3810: ,p_effective_end_date => l_effective_end_date
3811: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 3844: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

3840: p_base_key_value => l_bnft_prvdd_ldgr_id,
3841: p_mode => l_datetrack_mode);
3842: hr_utility.set_location('UPDATING LDGR ID='||to_char(l_bnft_prvdd_ldgr_id),120);
3843: l_rollover_diff_total:=l_rollover_diff_total+l_balance-l_old_rlovr_val;
3844: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
3845: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
3846: ,p_effective_start_date => l_effective_start_date
3847: ,p_effective_end_date => l_effective_end_date
3848: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 5346: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

5342: l_effective_date := p_effective_date -1;
5343: --
5344: end if;
5345: --
5346: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
5347: p_validate => false,
5348: p_bnft_prvdd_ldgr_id => l_bpl_rec.bnft_prvdd_ldgr_id,
5349: p_effective_start_date => l_effective_start_date,
5350: p_effective_end_date => l_effective_end_date,

Line 5781: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (

5777: --
5778: if c_prv%found then
5779: --
5780: l_rollover_diff_total:=l_rollover_diff_total+l_balance;
5781: ben_Benefit_Prvdd_Ledger_api.create_Benefit_Prvdd_Ledger (
5782: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
5783: ,p_effective_start_date => l_effective_start_date
5784: ,p_effective_end_date => l_effective_end_date
5785: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 5838: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (

5834: p_base_key_value => l_bnft_prvdd_ldgr_id,
5835: p_mode => l_datetrack_mode);
5836: hr_utility.set_location('UPDATING LEDGER ID='||to_char(l_bnft_prvdd_ldgr_id),120);
5837: l_rollover_diff_total:=l_rollover_diff_total+l_balance-l_old_rlovr_val;
5838: ben_Benefit_Prvdd_Ledger_api.update_Benefit_Prvdd_Ledger (
5839: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id
5840: ,p_effective_start_date => l_effective_start_date
5841: ,p_effective_end_date => l_effective_end_date
5842: ,p_prtt_ro_of_unusd_amt_flag => 'Y'

Line 6844: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

6840: end loop;
6841: close c_bpl_esd;
6842: --
6843: --
6844: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
6845: p_validate => false,
6846: p_bnft_prvdd_ldgr_id => l_dbt_bpl_rec.bnft_prvdd_ldgr_id,
6847: p_effective_start_date => l_effective_start_date,
6848: p_effective_end_date => l_effective_end_date,