eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_XCHG_PKG dependencies on BEN_CWB_XCHG

Line 1: package body BEN_CWB_XCHG_PKG as

1: package body BEN_CWB_XCHG_PKG as
2: /* $Header: bencwbxchg.pkb 120.8.12000000.1 2007/01/19 15:39:41 appldev noship $ */
3: --
4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |

Line 8: g_package varchar2(33):=' ben_cwb_xchg_pkb.'; --Global package name

4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_xchg_pkb.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_xchg_not_found varchar2(1) := 'N'; --global var to chk xchg rate
11: -- --------------------------------------------------------------------------
12: -- |----------------------< insert_into_ben_cwb_xchg >----------------------|

Line 12: -- |----------------------< insert_into_ben_cwb_xchg >----------------------|

8: g_package varchar2(33):=' ben_cwb_xchg_pkb.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_xchg_not_found varchar2(1) := 'N'; --global var to chk xchg rate
11: -- --------------------------------------------------------------------------
12: -- |----------------------< insert_into_ben_cwb_xchg >----------------------|
13: -- --------------------------------------------------------------------------
14: -- Description
15: -- This procedure inserts currency records in the the ben_cwb_xchg table on
16: -- participation process run as well on refresh.

Line 15: -- This procedure inserts currency records in the the ben_cwb_xchg table on

11: -- --------------------------------------------------------------------------
12: -- |----------------------< insert_into_ben_cwb_xchg >----------------------|
13: -- --------------------------------------------------------------------------
14: -- Description
15: -- This procedure inserts currency records in the the ben_cwb_xchg table on
16: -- participation process run as well on refresh.
17: -- Input parameters
18: -- p_group_pl_id : Group Plan Id
19: -- p_lf_evt_ocrd_dt : Life Event Occured Date

Line 22: procedure insert_into_ben_cwb_xchg(p_group_pl_id IN number,

18: -- p_group_pl_id : Group Plan Id
19: -- p_lf_evt_ocrd_dt : Life Event Occured Date
20: -- p_effective_date : Effective Date
21: -- p_refresh_always : Refresh Always flag
22: procedure insert_into_ben_cwb_xchg(p_group_pl_id IN number,
23: p_lf_evt_ocrd_dt IN date,
24: p_effective_date IN date,
25: p_refresh_always IN varchar2 default 'N',
26: p_currency IN varchar2 default null,

Line 196: l_xchg_rec ben_cwb_xchg%rowtype;

192: l_currency varchar2(30);
193: --
194: l_xchg_rate number;
195: --
196: l_xchg_rec ben_cwb_xchg%rowtype;
197: --
198: l_proc varchar2(72) := g_package||'insert_into_ben_cwb_xchg';
199: --
200: begin

Line 198: l_proc varchar2(72) := g_package||'insert_into_ben_cwb_xchg';

194: l_xchg_rate number;
195: --
196: l_xchg_rec ben_cwb_xchg%rowtype;
197: --
198: l_proc varchar2(72) := g_package||'insert_into_ben_cwb_xchg';
199: --
200: begin
201: --
202: if g_debug then

Line 220: delete from ben_cwb_xchg

216: if g_debug then
217: hr_utility.set_location('l_proc'|| l_proc, 20);
218: end if;
219: --
220: delete from ben_cwb_xchg
221: where group_pl_id = p_group_pl_id
222: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
223: --
224: for xchg_rec in csr_xchg_recs_rf(p_group_pl_id, p_lf_evt_ocrd_dt) loop

Line 243: insert into ben_cwb_xchg(

239: g_xchg_not_found := 'Y';
240: end if;
241:
242: --for each new currency records
243: insert into ben_cwb_xchg(
244: group_pl_id
245: ,lf_evt_ocrd_dt
246: ,currency
247: ,xchg_rate)

Line 281: insert into ben_cwb_xchg(

277: ,l_bg_id);
278: --
279: --for each new currency records
280: begin
281: insert into ben_cwb_xchg(
282: group_pl_id
283: ,lf_evt_ocrd_dt
284: ,currency
285: ,xchg_rate)

Line 314: delete from ben_cwb_xchg

310:
311: --
312: --if currency already exists
313: begin
314: delete from ben_cwb_xchg
315: where group_pl_id = p_group_pl_id
316: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
317: and currency = l_currency;
318: exception

Line 326: insert into ben_cwb_xchg(

322:
323: --
324: --for each new currency record
325: begin
326: insert into ben_cwb_xchg(
327: group_pl_id
328: ,lf_evt_ocrd_dt
329: ,currency
330: ,xchg_rate)

Line 348: end; -- of procedure insert_into_ben_cwb_xchg

344: if g_debug then
345: hr_utility.set_location(' Leaving:'|| l_proc, 99);
346: end if;
347: --
348: end; -- of procedure insert_into_ben_cwb_xchg
349: --
350: --
351: -- --------------------------------------------------------------------------
352: -- |---------------------------< refresh_xchg_rates >-----------------------|

Line 355: -- This procedure will refresh the exchange rates in ben_cwb_xchg table on

351: -- --------------------------------------------------------------------------
352: -- |---------------------------< refresh_xchg_rates >-----------------------|
353: -- --------------------------------------------------------------------------
354: -- Description
355: -- This procedure will refresh the exchange rates in ben_cwb_xchg table on
356: -- a given effective date, and, return p_all_xchg_rt_exists as 'N' for any
357: -- rates found to be null.
358: -- Input parameters
359: -- p_group_pl_id : Group Plan Id

Line 383: insert_into_ben_cwb_xchg(p_group_pl_id ,

379: g_xchg_not_found := 'N';
380: --
381:
382: --Calling procedure to refresh exchg rates
383: insert_into_ben_cwb_xchg(p_group_pl_id ,
384: p_lf_evt_ocrd_dt,
385: p_effective_date,
386: p_refresh_always,
387: null ,

Line 408: end BEN_CWB_XCHG_PKG;

404: hr_utility.set_location('Leaving:'|| l_proc, 99);
405: end if;
406: --
407: end; -- of procedure refresh_xchg_rates
408: end BEN_CWB_XCHG_PKG;
409: