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_PL_DSGN_API dependencies on BEN_CWB_PL_DSGN

Line 1: Package Body ben_cwb_pl_dsgn_api as

1: Package Body ben_cwb_pl_dsgn_api as
2: /* $Header: becpdapi.pkb 120.4.12020000.3 2013/01/02 07:11:42 kmsuresh ship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := ' BEN_CWB_PL_DSGN_API.';

2: /* $Header: becpdapi.pkb 120.4.12020000.3 2013/01/02 07:11:42 kmsuresh ship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PL_DSGN_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: --
10: -- ----------------------------------------------------------------------------

Line 125: ben_cwb_pl_dsgn_bk1.create_plan_or_option_b

121: --
122: -- Call Before Process User Hook
123: --
124: begin
125: ben_cwb_pl_dsgn_bk1.create_plan_or_option_b
126: (p_pl_id => p_pl_id
127: ,p_oipl_id => p_oipl_id
128: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
129: ,p_effective_date => p_effective_date

Line 331: ben_cwb_pl_dsgn_bk1.create_plan_or_option_a

327: --
328: -- Call After Process User Hook
329: --
330: begin
331: ben_cwb_pl_dsgn_bk1.create_plan_or_option_a
332: (p_pl_id => p_pl_id
333: ,p_oipl_id => p_oipl_id
334: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
335: ,p_effective_date => p_effective_date

Line 514: from ben_cwb_pl_dsgn

510: -- cursor to fetch the local plans of a group plan
511: cursor csr_plans(p_group_pl_id number
512: ,p_lf_evt_ocrd_dt date) is
513: select pl_id
514: from ben_cwb_pl_dsgn
515: where group_pl_id = p_group_pl_id
516: and pl_id <> group_pl_id -- Exclude group plan
517: and oipl_id = -1
518: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 524: from ben_cwb_pl_dsgn

520: -- cursor to fetch the options of a plan
521: cursor csr_options(p_pl_id number
522: ,p_lf_evt_ocrd_dt date) is
523: select oipl_id
524: from ben_cwb_pl_dsgn
525: where pl_id = p_pl_id
526: and oipl_id <> -1 -- Exclude Plans
527: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
528:

Line 534: from ben_cwb_pl_dsgn

530: cursor csr_grp_pl_local_options(p_group_pl_id number
531: ,p_lf_evt_ocrd_dt date) is
532: select pl_id
533: ,oipl_id
534: from ben_cwb_pl_dsgn
535: where group_pl_id = p_group_pl_id
536: and oipl_id <> -1 -- Exclude Plans
537: and pl_id <> p_group_pl_id -- Exclude Group Options
538: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line 546: from ben_cwb_pl_dsgn

542: ,p_group_oipl_id number
543: ,p_lf_evt_ocrd_dt date) is
544: select pl_id
545: ,oipl_id
546: from ben_cwb_pl_dsgn
547: where group_pl_id = p_group_pl_id
548: and oipl_id <> -1 -- Exclude Plans
549: and pl_id <> p_group_pl_id -- Exclude Group Options
550: and group_oipl_id = p_group_oipl_id

Line 607: from ben_cwb_pl_dsgn

603: end if;
604: --
605: select object_version_number
606: into l_ovn
607: from ben_cwb_pl_dsgn
608: where pl_id = pl.pl_id
609: and oipl_id = -1
610: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
611: --

Line 653: from ben_cwb_pl_dsgn

649: end if;
650: --
651: select object_version_number
652: into l_ovn
653: from ben_cwb_pl_dsgn
654: where pl_id = p_pl_id
655: and oipl_id = oipl.oipl_id
656: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
657: --

Line 687: from ben_cwb_pl_dsgn

683: for opt in csr_grp_pl_local_options(p_pl_id, p_lf_evt_ocrd_dt)
684: loop
685: select object_version_number
686: into l_ovn
687: from ben_cwb_pl_dsgn
688: where pl_id = opt.pl_id
689: and oipl_id = opt.oipl_id
690: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
691: --

Line 720: from ben_cwb_pl_dsgn

716: for oipl in csr_options(p_pl_id, p_lf_evt_ocrd_dt)
717: loop
718: select object_version_number
719: into l_ovn
720: from ben_cwb_pl_dsgn
721: where pl_id = p_pl_id
722: and oipl_id = oipl.oipl_id
723: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
724: --

Line 763: from ben_cwb_pl_dsgn

759: ,p_lf_evt_ocrd_dt)
760: loop
761: select object_version_number
762: into l_ovn
763: from ben_cwb_pl_dsgn
764: where pl_id = opt.pl_id
765: and oipl_id = opt.oipl_id
766: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
767: --

Line 919: ben_cwb_pl_dsgn_bk2.update_plan_or_option_b

915: --
916: -- Call Before Process User Hook
917: --
918: begin
919: ben_cwb_pl_dsgn_bk2.update_plan_or_option_b
920: (p_pl_id => p_pl_id
921: ,p_oipl_id => p_oipl_id
922: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
923: ,p_effective_date => p_effective_date

Line 1135: ben_cwb_pl_dsgn_bk2.update_plan_or_option_a

1131: --
1132: -- Call After Process User Hook
1133: --
1134: begin
1135: ben_cwb_pl_dsgn_bk2.update_plan_or_option_a
1136: (p_pl_id => p_pl_id
1137: ,p_oipl_id => p_oipl_id
1138: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1139: ,p_effective_date => p_effective_date

Line 1354: BEN_CWB_PL_DSGN_BK3.delete_plan_or_option_b

1350: --
1351: -- Call Before Process User Hook
1352: --
1353: begin
1354: BEN_CWB_PL_DSGN_BK3.delete_plan_or_option_b
1355: (p_pl_id => p_pl_id
1356: ,p_oipl_id => p_oipl_id
1357: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1358: ,p_object_version_number => l_object_version_number

Line 1384: ben_cwb_pl_dsgn_bk3.delete_plan_or_option_a

1380: --
1381: -- Call After Process User Hook
1382: --
1383: begin
1384: ben_cwb_pl_dsgn_bk3.delete_plan_or_option_a
1385: (p_pl_id => p_pl_id
1386: ,p_oipl_id => p_oipl_id
1387: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1388: ,p_object_version_number => l_object_version_number

Line 1433: end ben_cwb_pl_dsgn_api;

1429: end if;
1430: raise;
1431: end delete_plan_or_option;
1432: --
1433: end ben_cwb_pl_dsgn_api;