DBA Data[Home] [Help]

APPS.BEN_DISTRIBUTE_RATES dependencies on BEN_DISTRIBUTE_RATES

Line 1: package body ben_distribute_rates as

1: package body ben_distribute_rates as
2: /* $Header: bendisrt.pkb 120.10.12010000.3 2008/08/14 07:17:21 ubhat ship $ */
3: /*
4: --------------------------------------------------------------------------------
5: Name

Line 52: 21-Apr-00 jcarpent 115.15 Pass more args to ben_distribute_rates

48: on regular_payment_date rather than the
49: period start and end date.(1237278).
50: 05-Apr-00 mmogel 115.14 Added tokens to message calls to make the
51: messages more meaningful to the user
52: 21-Apr-00 jcarpent 115.15 Pass more args to ben_distribute_rates
53: (1205931,4600)
54: 03-May-00 gperry 115.16 Added rounding logic to period_to_annual
55: and annual_to_period. Fixes internal bug
56: 5148.

Line 169: g_package varchar2(80) := 'ben_distribute_rates';

165: -- ==========================================================================================================
166: */
167: --
168: --
169: g_package varchar2(80) := 'ben_distribute_rates';
170: --
171: g_hash_key number := ben_hash_utility.get_hash_key;
172: g_hash_jump number := ben_hash_utility.get_hash_jump;
173: --

Line 445: ben_distribute_rates.decde_bits(

441: ,p_eoy IN DATE
442: ,p_reset IN VARCHAR2
443: ,p_frq_bitmap_no IN NUMBER) is
444: select sum(
445: ben_distribute_rates.decde_bits(
446: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
447: ))
448: from per_time_periods
449: where payroll_id = p_payroll_id

Line 1086: ben_distribute_rates.decde_bits(

1082: ,p_eoy IN DATE
1083: ,p_reset IN VARCHAR2
1084: ,p_frq_bitmap_no IN NUMBER) is
1085: select sum(
1086: ben_distribute_rates.decde_bits(
1087: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
1088: ))
1089: from per_time_periods
1090: where payroll_id = p_payroll_id

Line 4814: l_proc varchar2(200) := 'ben_distribute_rates.convert_rates_w';

4810: --GEVITY
4811: not_supported exception;
4812: l_trace_param varchar2(30);
4813: l_trace_on boolean;
4814: l_proc varchar2(200) := 'ben_distribute_rates.convert_rates_w';
4815:
4816: begin
4817: /*
4818: if p_payroll_id is null then

Line 4868: ben_distribute_rates.periodize_with_rule

4864: IF l_rate_periodization_rl IS NOT NULL THEN
4865: --
4866: l_ann_dummy := p_amount;
4867: --
4868: ben_distribute_rates.periodize_with_rule
4869: (p_formula_id => l_rate_periodization_rl
4870: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
4871: ,p_assignment_id => l_assignment_id
4872: ,p_convert_from_val => l_ann_dummy

Line 4922: ben_distribute_rates.periodize_with_rule

4918: IF l_rate_periodization_rl IS NOT NULL THEN
4919: --
4920: l_cmcd_dummy := p_amount;
4921: --
4922: ben_distribute_rates.periodize_with_rule
4923: (p_formula_id => l_rate_periodization_rl
4924: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
4925: ,p_assignment_id => l_assignment_id
4926: ,p_convert_from_val => l_cmcd_dummy

Line 5004: ben_distribute_rates.periodize_with_rule

5000: IF l_rate_periodization_rl IS NOT NULL THEN
5001: --
5002: l_dfnd_dummy := p_amount;
5003: --
5004: ben_distribute_rates.periodize_with_rule
5005: (p_formula_id => l_rate_periodization_rl
5006: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5007: ,p_assignment_id => l_assignment_id
5008: ,p_convert_from_val => l_dfnd_dummy

Line 5170: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';

5166: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
5167:
5168: l_trace_param varchar2(30);
5169: l_trace_on boolean;
5170: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';
5171: --
5172: BEGIN
5173: -- hr_utility.trace_on(null,'BENDISRT');
5174: l_trace_param := null;

Line 5355: end ben_distribute_rates;

5351: end if;
5352: raise;
5353: END convert_pcr_rates_w;
5354:
5355: end ben_distribute_rates;