1 package BEN_CWB_XCHG_PKG as
2 /* $Header: bencwbxchg.pkh 120.2 2006/03/15 10:47 ddeb noship $ */
3 -- --------------------------------------------------------------------------
4 -- |--------------------< insert_into_ben_cwb_xchg >------------------------|
5 -- --------------------------------------------------------------------------
6 -- Description
7 -- This procedure contains calls for inserting records into xchg table once
8 -- benmingle has run, and also to upsert on refresh. If no value is passed for
9 -- effective_date, then lf_evt_ocrd_dt will be considered as the effective_date.
10 --
11 procedure insert_into_ben_cwb_xchg(p_group_pl_id IN number,
12 p_lf_evt_ocrd_dt IN date,
13 p_effective_date IN date,
14 p_refresh_always IN varchar2 default 'N',
15 p_currency IN varchar2 default null,
16 p_xchg_rate IN number default null);
17 -- --------------------------------------------------------------------------
18 -- |--------------------< refresh_xchg_rates >------------------------------|
19 -- --------------------------------------------------------------------------
20 -- Description
21 -- This procedure will refresh the exchange rates in ben_cwb_xchg table on
22 -- a given effective date, and, return p_all_xchg_rt_exists as 'N' for any
23 -- rates found to be null.
24 -- Input parameters
25 -- p_group_pl_id : Group Plan Id
26 -- p_lf_evt_ocrd_dt : Life Event Occured Date
27 -- p_effective_date : Effective Date
28 -- p_refresh_always : Refresh Always flag
29 -- p_all_xchg_rt_exists : All Exchange Rates Exists
30 --
31 procedure refresh_xchg_rates(p_group_pl_id IN number,
32 p_lf_evt_ocrd_dt IN date,
33 p_effective_date IN date,
34 p_refresh_always IN varchar2 default 'N',
35 p_all_xchg_rt_exists IN OUT NOCOPY varchar2);
36
37 end BEN_CWB_XCHG_PKG;
38