APPS.BEN_CWB_PL_DSGN_PKG dependencies on BEN_CWB_PL_DSGN

Line 1: package body BEN_CWB_PL_DSGN_PKG as

1: package body BEN_CWB_PL_DSGN_PKG as
2: /* $Header: bencwbpl.pkb 120.3.12000000.1 2007/01/19 15:29:25 appldev noship $ */
3: --
4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- --------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_pl_dsgn_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- --------------------------------------------------------------------------
12: -- |------------------------< get_opt_ordr_in_grp >-------------------------|

Line 440: from ben_cwb_pl_dsgn dsgn

436: and bg.business_group_id = pl.business_group_id
437: and pl.nip_pl_uom = cur.currency_code (+)
438: -- Refresh that local/group plan only if no rows exist for the plan.
439: and not exists (select 'Y'
440: from ben_cwb_pl_dsgn dsgn
441: where dsgn.group_pl_id = p_group_pl_id
442: and dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
443: and dsgn.pl_id = pl.pl_id);
444:

Line 616: delete from ben_cwb_pl_dsgn

612: hr_utility.set_location('l_proc'|| l_proc, 17);
613: end if;
614: --
615: -- refresh. delete plans and oipls from the pl_dsgn
616: delete from ben_cwb_pl_dsgn
617: where group_pl_id = p_group_pl_id
618: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
619: --
620: end if;

Line 701: insert into ben_cwb_pl_dsgn

697: -- Increment the count
698: l_opt_count := l_opt_count + 1;
699: l_oipl_ordr_num := get_opt_ordr_in_grp(oipl.group_opt_id);
700: --
701: insert into ben_cwb_pl_dsgn
702: (pl_id
703: ,lf_evt_ocrd_dt
704: ,oipl_id
705: ,effective_date

Line 836: insert into ben_cwb_pl_dsgn

832: hr_utility.set_location(l_proc, 60);
833: end if;
834: --
835: --insert the plan row
836: insert into ben_cwb_pl_dsgn
837: (pl_id
838: ,lf_evt_ocrd_dt
839: ,oipl_id
840: ,effective_date

Line 1003: -- This procedure deletes the ben_cwb_pl_dsgn table when no cwb data exists.

999: -- --------------------------------------------------------------------------
1000: -- |--------------------------< delete_pl_dsgn >----------------------------|
1001: -- --------------------------------------------------------------------------
1002: -- Description
1003: -- This procedure deletes the ben_cwb_pl_dsgn table when no cwb data exists.
1004: -- Input parameters
1005: -- p_group_pl_id : Group Plan Id
1006: -- p_lf_evt_ocrd_dt : Life Event Occured Date
1007: --

Line 1026: delete ben_cwb_pl_dsgn pl

1022: fetch c_data_exists into l_data_exists;
1023: close c_data_exists;
1024:
1025: if l_data_exists is null then
1026: delete ben_cwb_pl_dsgn pl
1027: where pl.group_pl_id = p_group_pl_id
1028: and pl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
1029: end if;
1030:

Line 1033: end ben_cwb_pl_dsgn_pkg;

1029: end if;
1030:
1031: end delete_pl_dsgn;
1032:
1033: end ben_cwb_pl_dsgn_pkg;
1034: