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.12010000.2 2010/02/02 11:51:13 sgnanama ship $ */
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 626: delete from ben_cwb_pl_dsgn

622: hr_utility.set_location('l_proc'|| l_proc, 17);
623: end if;
624: --
625: -- refresh. delete plans and oipls from the pl_dsgn
626: delete from ben_cwb_pl_dsgn
627: where group_pl_id = p_group_pl_id
628: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
629: --
630: end if;

Line 711: insert into ben_cwb_pl_dsgn

707: -- Increment the count
708: l_opt_count := l_opt_count + 1;
709: l_oipl_ordr_num := get_opt_ordr_in_grp(oipl.group_opt_id);
710: --
711: insert into ben_cwb_pl_dsgn
712: (pl_id
713: ,lf_evt_ocrd_dt
714: ,oipl_id
715: ,effective_date

Line 846: insert into ben_cwb_pl_dsgn

842: hr_utility.set_location(l_proc, 60);
843: end if;
844: --
845: --insert the plan row
846: insert into ben_cwb_pl_dsgn
847: (pl_id
848: ,lf_evt_ocrd_dt
849: ,oipl_id
850: ,effective_date

Line 1005: update ben_cwb_pl_dsgn set

1001: --
1002:
1003: -- ER:8369634
1004: for l_grp_plan_extra_info in csr_grp_plan_extra_info loop
1005: update ben_cwb_pl_dsgn set
1006: post_zero_salary_increase = l_grp_plan_extra_info.post_zero_salary_increase,
1007: show_appraisals_n_days = l_grp_plan_extra_info.show_appraisals_n_days
1008: where pl_id = p_group_pl_id
1009: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt

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

1020: -- --------------------------------------------------------------------------
1021: -- |--------------------------< delete_pl_dsgn >----------------------------|
1022: -- --------------------------------------------------------------------------
1023: -- Description
1024: -- This procedure deletes the ben_cwb_pl_dsgn table when no cwb data exists.
1025: -- Input parameters
1026: -- p_group_pl_id : Group Plan Id
1027: -- p_lf_evt_ocrd_dt : Life Event Occured Date
1028: --

Line 1047: delete ben_cwb_pl_dsgn pl

1043: fetch c_data_exists into l_data_exists;
1044: close c_data_exists;
1045:
1046: if l_data_exists is null then
1047: delete ben_cwb_pl_dsgn pl
1048: where pl.group_pl_id = p_group_pl_id
1049: and pl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
1050: end if;
1051:

Line 1054: end ben_cwb_pl_dsgn_pkg;

1050: end if;
1051:
1052: end delete_pl_dsgn;
1053:
1054: end ben_cwb_pl_dsgn_pkg;
1055: