DBA Data[Home] [Help]

APPS.BEN_CWB_PERSON_GROUPS_API dependencies on BEN_CWB_PERSON_GROUPS

Line 1: Package Body BEN_CWB_PERSON_GROUPS_API as

1: Package Body BEN_CWB_PERSON_GROUPS_API as
2: /* $Header: becpgapi.pkb 120.5.12000000.1 2007/01/19 02:23:07 appldev noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: becpgapi.pkb 120.5.12000000.1 2007/01/19 02:23:07 appldev noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' BEN_CWB_PERSON_GROUPS_API.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: cursor csr_grps(v_group_per_in_ler_id number
10: ,v_group_pl_id number

Line 13: from ben_cwb_person_groups

9: cursor csr_grps(v_group_per_in_ler_id number
10: ,v_group_pl_id number
11: ,v_group_oipl_id number) is
12: select *
13: from ben_cwb_person_groups
14: where group_per_in_ler_id = v_group_per_in_ler_id
15: and group_pl_id = v_group_pl_id
16: and group_oipl_id = v_group_oipl_id;
17: --

Line 77: ben_cwb_person_groups_bk1.create_group_budget_b

73: --
74: -- Call Before Process User Hook
75: --
76: begin
77: ben_cwb_person_groups_bk1.create_group_budget_b
78: (p_group_per_in_ler_id => p_group_per_in_ler_id
79: ,p_group_pl_id => p_group_pl_id
80: ,p_group_oipl_id => p_group_oipl_id
81: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 169: ben_cwb_person_groups_bk1.create_group_budget_a

165: --
166: -- Call After Process User Hook
167: --
168: begin
169: ben_cwb_person_groups_bk1.create_group_budget_a
170: (p_group_per_in_ler_id => p_group_per_in_ler_id
171: ,p_group_pl_id => p_group_pl_id
172: ,p_group_oipl_id => p_group_oipl_id
173: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 387: -- update the summary table after updating the ben_cwb_person_groups.

383: -- |---------------------< update_group_budget_summary >---------------------|
384: -- --------------------------------------------------------------------------
385: -- Description
386: -- This is an internal procedure called only by update_group_budget to
387: -- update the summary table after updating the ben_cwb_person_groups.
388: --
389: procedure update_group_budget_summary
390: (p_grp_bdgt_old csr_grps%rowtype
391: ,p_dist_bdgt_val number

Line 1058: from ben_cwb_person_groups grp

1054: ,rsrv_mn_val
1055: ,rsrv_mx_val
1056: ,rsrv_incr_val
1057: ,group_per_in_ler_id
1058: from ben_cwb_person_groups grp
1059: where group_per_in_ler_id = p_group_per_in_ler_id
1060: and group_pl_id = p_group_pl_id
1061: and group_oipl_id = p_group_oipl_id;
1062: --

Line 1089: ben_cwb_person_groups_bk2.update_group_budget_b

1085: --
1086: -- Call Before Process User Hook
1087: --
1088: begin
1089: ben_cwb_person_groups_bk2.update_group_budget_b
1090: (p_group_per_in_ler_id => p_group_per_in_ler_id
1091: ,p_group_pl_id => p_group_pl_id
1092: ,p_group_oipl_id => p_group_oipl_id
1093: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 1294: ben_cwb_person_groups_bk2.update_group_budget_a

1290: --
1291: -- Call After Process User Hook
1292: --
1293: begin
1294: ben_cwb_person_groups_bk2.update_group_budget_a
1295: (p_group_per_in_ler_id => p_group_per_in_ler_id
1296: ,p_group_pl_id => p_group_pl_id
1297: ,p_group_oipl_id => p_group_oipl_id
1298: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt

Line 1435: BEN_CWB_PERSON_GROUPS_BK3.delete_group_budget_b

1431: --
1432: -- Call Before Process User Hook
1433: --
1434: begin
1435: BEN_CWB_PERSON_GROUPS_BK3.delete_group_budget_b
1436: (p_group_per_in_ler_id => p_group_per_in_ler_id
1437: ,p_group_pl_id => p_group_pl_id
1438: ,p_group_oipl_id => p_group_oipl_id
1439: ,p_object_version_number => l_object_version_number

Line 1465: ben_cwb_person_groups_bk3.delete_group_budget_a

1461: --
1462: -- Call After Process User Hook
1463: --
1464: begin
1465: ben_cwb_person_groups_bk3.delete_group_budget_a
1466: (p_group_per_in_ler_id => p_group_per_in_ler_id
1467: ,p_group_pl_id => p_group_pl_id
1468: ,p_group_oipl_id => p_group_oipl_id
1469: ,p_object_version_number => l_object_version_number

Line 1526: end ben_cwb_person_groups_api;

1522: raise;
1523: end delete_group_budget;
1524: --
1525: --
1526: end ben_cwb_person_groups_api;