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.22.12020000.3 2012/07/03 12:30:55 amnaraya 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 202: g_package varchar2(80) := 'ben_distribute_rates';

198: -- ==========================================================================================================
199: */
200: --
201: --
202: g_package varchar2(80) := 'ben_distribute_rates';
203: --
204: g_hash_key number := ben_hash_utility.get_hash_key;
205: g_hash_jump number := ben_hash_utility.get_hash_jump;
206: --

Line 479: ben_distribute_rates.decde_bits(

475: ,p_eoy IN DATE
476: ,p_reset IN VARCHAR2
477: ,p_frq_bitmap_no IN NUMBER) is
478: select sum(
479: ben_distribute_rates.decde_bits(
480: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
481: ))
482: from per_time_periods
483: where payroll_id = p_payroll_id

Line 1126: ben_distribute_rates.decde_bits(

1122: ,p_eoy IN DATE
1123: ,p_reset IN VARCHAR2
1124: ,p_frq_bitmap_no IN NUMBER) is
1125: select sum(
1126: ben_distribute_rates.decde_bits(
1127: bitand(power(2,count(end_date )) -1,p_frq_bitmap_no)
1128: ))
1129: from per_time_periods
1130: where payroll_id = p_payroll_id

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

5145: --GEVITY
5146: not_supported exception;
5147: l_trace_param varchar2(30);
5148: l_trace_on boolean;
5149: l_proc varchar2(200) := 'ben_distribute_rates.convert_rates_w';
5150:
5151: begin
5152: /*
5153: if p_payroll_id is null then

Line 5203: ben_distribute_rates.periodize_with_rule

5199: IF l_rate_periodization_rl IS NOT NULL THEN
5200: --
5201: l_ann_dummy := p_amount;
5202: --
5203: ben_distribute_rates.periodize_with_rule
5204: (p_formula_id => l_rate_periodization_rl
5205: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5206: ,p_assignment_id => l_assignment_id
5207: ,p_convert_from_val => l_ann_dummy

Line 5257: ben_distribute_rates.periodize_with_rule

5253: IF l_rate_periodization_rl IS NOT NULL THEN
5254: --
5255: l_cmcd_dummy := p_amount;
5256: --
5257: ben_distribute_rates.periodize_with_rule
5258: (p_formula_id => l_rate_periodization_rl
5259: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5260: ,p_assignment_id => l_assignment_id
5261: ,p_convert_from_val => l_cmcd_dummy

Line 5355: ben_distribute_rates.periodize_with_rule

5351: IF l_rate_periodization_rl IS NOT NULL THEN
5352: --
5353: l_dfnd_dummy := p_amount;
5354: --
5355: ben_distribute_rates.periodize_with_rule
5356: (p_formula_id => l_rate_periodization_rl
5357: ,p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date)
5358: ,p_assignment_id => l_assignment_id
5359: ,p_convert_from_val => l_dfnd_dummy

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

5517: l_cmcd_perd_cd ben_enrt_rt.cmcd_acty_ref_perd_cd%TYPE;
5518:
5519: l_trace_param varchar2(30);
5520: l_trace_on boolean;
5521: l_proc varchar2(200) := 'ben_distribute_rates.convert_pcr_rates_w';
5522: --
5523: BEGIN
5524: -- hr_utility.trace_on(null,'BENDISRT');
5525: l_trace_param := null;

Line 5706: end ben_distribute_rates;

5702: end if;
5703: raise;
5704: END convert_pcr_rates_w;
5705:
5706: end ben_distribute_rates;