DBA Data[Home] [Help]

APPS.BEN_EFC_ADJUSTMENTS dependencies on BEN_EFC_ADJUSTMENTS

Line 1: package body ben_efc_adjustments as

1: package body ben_efc_adjustments as
2: /* $Header: beefcadj.pkb 115.27 2003/02/14 01:58:10 kmahendr noship $ */
3: --
4: /*
5: +==============================================================================+

Line 47: g_package varchar2(50) := 'ben_efc_adjustments.';

43: */
44: --
45: -- Globals.
46: --
47: g_package varchar2(50) := 'ben_efc_adjustments.';
48: --
49: procedure DetectAppError
50: (p_sqlerrm in varchar2
51: ,p_abr_rt_mlt_cd in varchar2 default null

Line 1250: ben_efc_adjustments.DetectRoundInfo

1246: ,'CONVADJVAL>50%'
1247: )
1248: then
1249: --
1250: ben_efc_adjustments.DetectRoundInfo
1251: (p_rndg_cd => null
1252: ,p_rndg_rl => null
1253: ,p_old_val => p_preconv_val
1254: ,p_new_val => l_postconv_val

Line 1741: ben_efc_adjustments.DetectBCOLRowInfo

1737: end loop;
1738: --
1739: -- Detect comp object list information
1740: --
1741: ben_efc_adjustments.DetectBCOLRowInfo
1742: (p_comp_obj_tree_row => l_comp_obj_tree_row
1743: ,p_effective_date => l_efc_row.lf_evt_ocrd_dt
1744: ,p_business_group_id => l_efc_row.business_group_id
1745: --

Line 1905: ben_efc_adjustments.DetectWhoInfo

1901: -- WHO checks
1902: --
1903: if l_faterr_code is null then
1904: --
1905: ben_efc_adjustments.DetectWhoInfo
1906: (p_creation_date => l_efc_row.creation_date
1907: ,p_last_update_date => l_efc_row.last_update_date
1908: ,p_object_version_number => l_efc_row.object_version_number
1909: --

Line 2334: ben_efc_adjustments.DetectWhoInfo

2330: l_faterr_code := null;
2331: --
2332: -- WHO checks
2333: --
2334: ben_efc_adjustments.DetectWhoInfo
2335: (p_creation_date => l_efc_row.creation_date
2336: ,p_last_update_date => l_efc_row.last_update_date
2337: ,p_object_version_number => l_efc_row.object_version_number
2338: ,p_who_counts => l_who_counts

Line 2437: ben_efc_adjustments.DetectBCOLRowInfo

2433: end loop;
2434: --
2435: -- Detect comp object list information
2436: --
2437: ben_efc_adjustments.DetectBCOLRowInfo
2438: (p_comp_obj_tree_row => l_comp_obj_tree_row
2439: ,p_effective_date => l_efc_row.lf_evt_ocrd_dt
2440: ,p_business_group_id => l_efc_row.business_group_id
2441: --

Line 3131: ben_efc_adjustments.DetectInvAsg

3127: if l_faterr_code is null then
3128: --
3129: -- Check that the assignment is valid
3130: --
3131: ben_efc_adjustments.DetectInvAsg
3132: (p_person_id => l_efc_row.person_id
3133: ,p_eff_date => l_efc_row.lf_evt_ocrd_dt
3134: --
3135: ,p_perasg => l_perasg

Line 3625: ben_efc_adjustments.DetectVAPROInfo

3621: l_currepe_row.per_in_ler_id := l_efc_row.per_in_ler_id;
3622: l_currepe_row.ler_id := l_efc_row.ler_id;
3623: l_currepe_row.business_group_id := l_efc_row.business_group_id;
3624: --
3625: ben_efc_adjustments.DetectVAPROInfo
3626: (p_currepe_row => l_currepe_row
3627: --
3628: ,p_lf_evt_ocrd_dt => l_efc_row.lf_evt_ocrd_dt
3629: ,p_last_update_date => l_efc_row.last_update_date

Line 3658: ben_efc_adjustments.DetectRoundInfo

3654: then
3655: --
3656: -- Check rounding
3657: --
3658: ben_efc_adjustments.DetectRoundInfo
3659: (p_rndg_cd => null
3660: ,p_rndg_rl => null
3661: ,p_old_val => l_old_val1
3662: ,p_new_val => l_new_val1

Line 3727: ben_efc_adjustments.DetectWhoInfo

3723: if l_faterr_code is null then
3724: --
3725: -- WHO checks
3726: --
3727: ben_efc_adjustments.DetectWhoInfo
3728: (p_creation_date => l_efc_row.creation_date
3729: ,p_last_update_date => l_efc_row.last_update_date
3730: ,p_object_version_number => l_efc_row.object_version_number
3731: ,p_who_counts => l_who_counts

Line 4161: ben_efc_adjustments.DetectEPEENBInfo

4157: if l_faterr_code is null then
4158: --
4159: -- Detect EPE or ENB Info
4160: --
4161: ben_efc_adjustments.DetectEPEENBInfo
4162: (p_elig_per_elctbl_chc_id => l_efc_row.elig_per_elctbl_chc_id
4163: ,p_enrt_bnft_id => l_efc_row.enrt_bnft_id
4164: --
4165: ,p_detect_mode => 'EPEINFO'

Line 4312: ben_efc_adjustments.DetectVAPROInfo

4308: if l_faterr_code is null then
4309: --
4310: -- Validate vapro information
4311: --
4312: ben_efc_adjustments.DetectVAPROInfo
4313: (p_currepe_row => l_currepe_row
4314: --
4315: ,p_lf_evt_ocrd_dt => l_currepe_row.lf_evt_ocrd_dt
4316: ,p_last_update_date => l_efc_row.last_update_date

Line 4357: ben_efc_adjustments.DetectWhoInfo

4353: end if;
4354: --
4355: if l_faterr_code is null then
4356: --
4357: ben_efc_adjustments.DetectWhoInfo
4358: (p_creation_date => l_efc_row.creation_date
4359: ,p_last_update_date => l_efc_row.last_update_date
4360: ,p_object_version_number => l_efc_row.object_version_number
4361: --

Line 4468: ben_efc_adjustments.insert_validation_exceptions

4464: -- Write exceptions down to the table
4465: --
4466: if l_efc_batch then
4467: --
4468: ben_efc_adjustments.insert_validation_exceptions
4469: (p_val_set => g_epr_fatal_error_val_set
4470: ,p_efc_action_id => p_action_id
4471: ,p_ent_scode => 'EPR'
4472: ,p_exception_type => null

Line 4953: ben_efc_adjustments.DetectEPEENBInfo

4949: then
4950: --
4951: -- Detect EPE or ENB Info
4952: --
4953: ben_efc_adjustments.DetectEPEENBInfo
4954: (p_elig_per_elctbl_chc_id => l_efc_row.elig_per_elctbl_chc_id
4955: ,p_enrt_bnft_id => l_efc_row.enrt_bnft_id
4956: --
4957: ,p_currpil_row => l_currpil_row

Line 5085: ben_efc_adjustments.DetectInvAsg

5081: -- Check primary assignment information for comp related calcs
5082: --
5083: if l_faterr_code is null then
5084: --
5085: ben_efc_adjustments.DetectInvAsg
5086: (p_person_id => l_person_id
5087: ,p_eff_date => l_lf_evt_ocrd_dt
5088: --
5089: ,p_perasg => l_perasg

Line 5171: ben_efc_adjustments.DetectEPEENBInfo

5167: ben_distribute_rates.clear_down_cache;
5168: --
5169: -- Detect EPE or ENB Info
5170: --
5171: ben_efc_adjustments.DetectEPEENBInfo
5172: (p_elig_per_elctbl_chc_id => l_efc_row.elig_per_elctbl_chc_id
5173: ,p_enrt_bnft_id => l_efc_row.enrt_bnft_id
5174: --
5175: ,p_detect_mode => 'EPEINFO'

Line 5495: ben_efc_adjustments.DetectConvInfo

5491: */
5492: end if;
5493: --
5494: /*
5495: ben_efc_adjustments.DetectConvInfo
5496: (p_ncucurr_code => l_preconvdets.uom
5497: ,p_new_val => l_new_val1
5498: ,p_preconv_val => l_preconv_val
5499: --

Line 5521: ben_efc_adjustments.DetectRoundInfo

5517: -- Check for hard coded rounding code
5518: --
5519: if l_faterr_code is null then
5520: --
5521: ben_efc_adjustments.DetectRoundInfo
5522: (p_rndg_cd => l_abrdets.rndg_cd
5523: ,p_rndg_rl => l_abrdets.rndg_rl
5524: ,p_old_val => l_old_val1
5525: ,p_new_val => l_new_val1

Line 5552: ben_efc_adjustments.DetectVAPROInfo

5548: then
5549: --
5550: -- Validate vapro
5551: --
5552: ben_efc_adjustments.DetectVAPROInfo
5553: (p_currepe_row => l_currepe_row
5554: --
5555: ,p_lf_evt_ocrd_dt => l_lf_evt_ocrd_dt
5556: ,p_last_update_date => l_efc_row.last_update_date

Line 5593: ben_efc_adjustments.DetectWhoInfo

5589: end if;
5590: --
5591: if l_faterr_code is null then
5592: --
5593: ben_efc_adjustments.DetectWhoInfo
5594: (p_creation_date => l_efc_row.creation_date
5595: ,p_last_update_date => l_efc_row.last_update_date
5596: ,p_object_version_number => l_efc_row.object_version_number
5597: --

Line 5664: ben_efc_adjustments.DetectAppError

5660: --
5661: exception
5662: when others then
5663: --
5664: ben_efc_adjustments.DetectAppError
5665: (p_sqlerrm => SQLERRM
5666: ,p_abr_rt_mlt_cd => l_abrdets.rt_mlt_cd
5667: ,p_abr_val => l_abrdets.val
5668: ,p_abr_entr_val_at_enrt_flag => l_abrdets.entr_val_at_enrt_flag

Line 5759: ben_efc_adjustments.insert_validation_exceptions

5755: -- Write exceptions down to the table
5756: --
5757: if l_efc_batch then
5758: --
5759: ben_efc_adjustments.insert_validation_exceptions
5760: (p_val_set => g_ecr_failed_adj_val_set
5761: ,p_efc_action_id => p_action_id
5762: ,p_ent_scode => 'ECR'
5763: ,p_exception_type => 'AF'

Line 5766: ben_efc_adjustments.insert_validation_exceptions

5762: ,p_ent_scode => 'ECR'
5763: ,p_exception_type => 'AF'
5764: );
5765: --
5766: ben_efc_adjustments.insert_validation_exceptions
5767: (p_val_set => g_ecr_fatal_error_val_set
5768: ,p_efc_action_id => p_action_id
5769: ,p_ent_scode => 'ECR'
5770: ,p_exception_type => null

Line 5831: end ben_efc_adjustments;

5827: p_adjustment_counts.rcoerr_count := l_rcoerr_count;
5828: --
5829: end ecr_adjustments;
5830: --
5831: end ben_efc_adjustments;