1 package BEN_CWB_PL_DSGN_PKG AUTHID CURRENT_USER as
2 /* $Header: bencwbpl.pkh 120.0 2005/05/28 04:00:19 appldev noship $ */
3 --
4 -- --------------------------------------------------------------------------
5 -- |---------------------------< get_actual_flag >---------------------------|
6 -- --------------------------------------------------------------------------
7 --
8 -- This function checks whether the given plan is an actual plan or part of
9 -- a group plan.
10 --
11 function get_actual_flag(p_pl_id number
12 ,p_group_pl_id number
13 ,p_effective_date date)
14 return varchar2;
15 --
16 -- --------------------------------------------------------------------------
17 -- |----------------------------< get_exchg_rate >---------------------------|
18 -- --------------------------------------------------------------------------
19 -- Description
20 -- This procedure computes the exchange reate between the from_currency and
21 -- to_currency by calling hr_currency_pkg. If no exchange rate information is
22 -- found, '1' will returned.
23 function get_exchg_rate(p_from_currency varchar2
24 ,p_to_currency varchar2
25 ,p_effective_date date
26 ,p_business_group_id number)
27 return number;
28 --
29 -- --------------------------------------------------------------------------
30 -- |--------------------------< refresh_pl_dsgn >----------------------------|
31 -- --------------------------------------------------------------------------
32 -- Description
33 -- This procedure refreshes the ben_cwb_pl_dsgn table.
34 -- Input parameters
35 -- p_group_pl_id : Group Plan Id
36 -- p_lf_evt_ocrd_dt : Life Event Occured Date
37 -- p_effective_date : Effective date. This will be used while fetching the
38 -- data from date tracked tables, if the data_freeze_date in ben_enrt_perd
39 -- is null.
40 --
41 procedure refresh_pl_dsgn(p_group_pl_id in number
42 ,p_lf_evt_ocrd_dt in date
43 ,p_effective_date in date
44 ,p_refresh_always in varchar2 default 'N');
45
46 --
47 -- --------------------------------------------------------------------------
48 -- |--------------------------< delete_pl_dsgn >----------------------------|
49 -- --------------------------------------------------------------------------
50 -- Description
51 -- This procedure deletes the ben_cwb_pl_dsgn table when no cwb data exists.
52 -- Input parameters
53 -- p_group_pl_id : Group Plan Id
54 -- p_lf_evt_ocrd_dt : Life Event Occured Date
55 --
56 procedure delete_pl_dsgn(p_group_pl_id in number
57 ,p_lf_evt_ocrd_dt in date);
58 end BEN_CWB_PL_DSGN_PKG;
59