1 Package ben_determine_rate_chg as
2 /* $Header: benrtchg.pkh 120.0.12000000.1 2007/01/19 18:55:46 appldev noship $ */
3 --------------------------------------------------------------------------------
4 /*
5 +==============================================================================+
6 | Copyright (c) 1997 Oracle Corporation |
7 | Redwood Shores, California, USA |
8 | All rights reserved. |
9 +==============================================================================+
10 Name:
11 Determine rate/benefit changes.
12 Purpose:
13 This process determines what rate or benefit amount have changed and updates
14 prtt_enrt_rslt
15 History:
16 Date Who Version What?
17 ---- --- ------- -----
18 25 Oct 98 T Guy 115.0 Created.
19 22 Jan 99 T Guy 115.1 Added p_lf_evt_cord_dt parm
20 09 Mar 99 G Perry 115.2 IS to AS.
21 30 Dec 99 maagrawa 115.3 Added parameter business_group_id.
22 05 Jan 01 kmahendr 115.4 Added parameter per_in_ler_id
23 26 Jun 01 ikasire 115.5 bug 1849019 added two new procedures
24 prv_delete and get_rate_codes to
25 handle ENTRBL rate start date codes.
26 17 Aug 01 kmahendr 115.6 Added parameter p_mode to prv_delete
27 25 Sep 01 kmahendr 115.7 Added parameter p_mode to main
28 20 Mar 02 kmahendr 115.8 Added dbdrv lines.
29 11-dec-2002 hmani 115.9 NoCopy changes
30 22 Apr 03 kmahendr 115.10 New function Determine_change_in_flex added - bug#2908231
31 */
32 --------------------------------------------------------------------------------
33 --
34 --
35 PROCEDURE main
36 (p_effective_date in date,
37 p_lf_evt_ocrd_dt in date,
38 p_business_group_id in number,
39 p_person_id in number,
40 p_per_in_ler_id in number,
41 p_mode in varchar2 default null);
42 --
43 -- ben_determine_rate_chg.prv_delete
44 procedure prv_delete
45 (p_prtt_rt_val_id in number ,
46 p_enrt_rt_id in number,
47 p_rt_val in number,
48 p_rt_strt_dt in date,
49 p_business_group_id in number,
50 p_prtt_enrt_rslt_id in number,
51 p_person_id in number,
52 p_effective_date in date,
53 p_mode in varchar2 default 'NEW'
54 );
55 --
56 -- This is a wrapper to get rt_end_dt_cd and rt_srt_dt_cd from forms.
57 --
58 procedure get_rate_codes
59 (p_business_group_id in number
60 ,p_elig_per_elctbl_chc_id in number
61 ,p_rt_strt_dt_cd out nocopy varchar2
62 ,p_rt_end_dt_cd out nocopy varchar2
63 ,p_acty_base_rt_id in number
64 ,p_effective_date in date);
65 --
66 function Determine_change_in_flex
67 (p_prtt_enrt_rslt_id number,
68 p_per_in_ler_id number,
69 p_effective_date date)
70 return boolean;
71 --
72 end ben_determine_rate_chg;
73