APPS.BEN_CPG_BUS dependencies on BEN_CPG_BUS

Line 1: Package Body ben_cpg_bus as

1: Package Body ben_cpg_bus as
2: /* $Header: becpgrhi.pkb 120.0 2005/05/28 01:13 appldev noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' ben_cpg_bus.'; -- Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- The following two global variables are only to be
12: -- used by the return_legislation_code function.

Line 182: if (( nvl(ben_cpg_bus.g_group_per_in_ler_id, hr_api.g_number)

178: ,p_argument => 'group_oipl_id'
179: ,p_argument_value => p_group_oipl_id
180: );
181: --
182: if (( nvl(ben_cpg_bus.g_group_per_in_ler_id, hr_api.g_number)
183: = p_group_per_in_ler_id)
184: and ( nvl(ben_cpg_bus.g_group_pl_id, hr_api.g_number)
185: = p_group_pl_id)
186: and ( nvl(ben_cpg_bus.g_group_oipl_id, hr_api.g_number)

Line 184: and ( nvl(ben_cpg_bus.g_group_pl_id, hr_api.g_number)

180: );
181: --
182: if (( nvl(ben_cpg_bus.g_group_per_in_ler_id, hr_api.g_number)
183: = p_group_per_in_ler_id)
184: and ( nvl(ben_cpg_bus.g_group_pl_id, hr_api.g_number)
185: = p_group_pl_id)
186: and ( nvl(ben_cpg_bus.g_group_oipl_id, hr_api.g_number)
187: = p_group_oipl_id)) then
188: --

Line 186: and ( nvl(ben_cpg_bus.g_group_oipl_id, hr_api.g_number)

182: if (( nvl(ben_cpg_bus.g_group_per_in_ler_id, hr_api.g_number)
183: = p_group_per_in_ler_id)
184: and ( nvl(ben_cpg_bus.g_group_pl_id, hr_api.g_number)
185: = p_group_pl_id)
186: and ( nvl(ben_cpg_bus.g_group_oipl_id, hr_api.g_number)
187: = p_group_oipl_id)) then
188: --
189: -- The legislation code has already been found with a previous
190: -- call to this function. Just return the value in the global

Line 193: l_legislation_code := ben_cpg_bus.g_legislation_code;

189: -- The legislation code has already been found with a previous
190: -- call to this function. Just return the value in the global
191: -- variable.
192: --
193: l_legislation_code := ben_cpg_bus.g_legislation_code;
194: if g_debug then
195: hr_utility.set_location(l_proc, 20);
196: end if;
197: else

Line 221: ben_cpg_bus.g_group_per_in_ler_id := p_group_per_in_ler_id;

217: -- Set the global variables so the values are
218: -- available for the next call to this function.
219: --
220: close csr_leg_code;
221: ben_cpg_bus.g_group_per_in_ler_id := p_group_per_in_ler_id;
222: ben_cpg_bus.g_group_pl_id := p_group_pl_id;
223: ben_cpg_bus.g_group_oipl_id := p_group_oipl_id;
224: ben_cpg_bus.g_legislation_code := l_legislation_code;
225: end if;

Line 222: ben_cpg_bus.g_group_pl_id := p_group_pl_id;

218: -- available for the next call to this function.
219: --
220: close csr_leg_code;
221: ben_cpg_bus.g_group_per_in_ler_id := p_group_per_in_ler_id;
222: ben_cpg_bus.g_group_pl_id := p_group_pl_id;
223: ben_cpg_bus.g_group_oipl_id := p_group_oipl_id;
224: ben_cpg_bus.g_legislation_code := l_legislation_code;
225: end if;
226: if g_debug then

Line 223: ben_cpg_bus.g_group_oipl_id := p_group_oipl_id;

219: --
220: close csr_leg_code;
221: ben_cpg_bus.g_group_per_in_ler_id := p_group_per_in_ler_id;
222: ben_cpg_bus.g_group_pl_id := p_group_pl_id;
223: ben_cpg_bus.g_group_oipl_id := p_group_oipl_id;
224: ben_cpg_bus.g_legislation_code := l_legislation_code;
225: end if;
226: if g_debug then
227: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 224: ben_cpg_bus.g_legislation_code := l_legislation_code;

220: close csr_leg_code;
221: ben_cpg_bus.g_group_per_in_ler_id := p_group_per_in_ler_id;
222: ben_cpg_bus.g_group_pl_id := p_group_pl_id;
223: ben_cpg_bus.g_group_oipl_id := p_group_oipl_id;
224: ben_cpg_bus.g_legislation_code := l_legislation_code;
225: end if;
226: if g_debug then
227: hr_utility.set_location(' Leaving:'|| l_proc, 40);
228: end if;

Line 380: end ben_cpg_bus;

376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: end if;
378: End delete_validate;
379: --
380: end ben_cpg_bus;