DBA Data[Home] [Help]

APPS.HXC_LKR_BUS dependencies on HXC_LKR_BUS

Line 1: Package Body hxc_lkr_bus as

1: Package Body hxc_lkr_bus as
2: /* $Header: hxclockrulesrhi.pkb 120.2 2005/09/23 07:58:43 nissharm noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

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

Line 156: if (( nvl(hxc_lkr_bus.g_locker_type_owner_id, hr_api.g_number)

152: ,p_argument => 'locker_type_requestor_id'
153: ,p_argument_value => p_locker_type_requestor_id
154: );
155: --
156: if (( nvl(hxc_lkr_bus.g_locker_type_owner_id, hr_api.g_number)
157: = p_locker_type_owner_id)
158: and ( nvl(hxc_lkr_bus.g_locker_type_requestor_id, hr_api.g_number)
159: = p_locker_type_requestor_id)) then
160: --

Line 158: and ( nvl(hxc_lkr_bus.g_locker_type_requestor_id, hr_api.g_number)

154: );
155: --
156: if (( nvl(hxc_lkr_bus.g_locker_type_owner_id, hr_api.g_number)
157: = p_locker_type_owner_id)
158: and ( nvl(hxc_lkr_bus.g_locker_type_requestor_id, hr_api.g_number)
159: = p_locker_type_requestor_id)) then
160: --
161: -- The legislation code has already been found with a previous
162: -- call to this function. Just return the value in the global

Line 165: l_legislation_code := hxc_lkr_bus.g_legislation_code;

161: -- The legislation code has already been found with a previous
162: -- call to this function. Just return the value in the global
163: -- variable.
164: --
165: l_legislation_code := hxc_lkr_bus.g_legislation_code;
166: if g_debug then
167: hr_utility.set_location(l_proc, 20);
168: end if;
169: else

Line 193: hxc_lkr_bus.g_locker_type_owner_id := p_locker_type_owner_id;

189: -- Set the global variables so the values are
190: -- available for the next call to this function.
191: --
192: close csr_leg_code;
193: hxc_lkr_bus.g_locker_type_owner_id := p_locker_type_owner_id;
194: hxc_lkr_bus.g_locker_type_requestor_id := p_locker_type_requestor_id;
195: hxc_lkr_bus.g_legislation_code := l_legislation_code;
196: end if;
197: if g_debug then

Line 194: hxc_lkr_bus.g_locker_type_requestor_id := p_locker_type_requestor_id;

190: -- available for the next call to this function.
191: --
192: close csr_leg_code;
193: hxc_lkr_bus.g_locker_type_owner_id := p_locker_type_owner_id;
194: hxc_lkr_bus.g_locker_type_requestor_id := p_locker_type_requestor_id;
195: hxc_lkr_bus.g_legislation_code := l_legislation_code;
196: end if;
197: if g_debug then
198: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 195: hxc_lkr_bus.g_legislation_code := l_legislation_code;

191: --
192: close csr_leg_code;
193: hxc_lkr_bus.g_locker_type_owner_id := p_locker_type_owner_id;
194: hxc_lkr_bus.g_locker_type_requestor_id := p_locker_type_requestor_id;
195: hxc_lkr_bus.g_legislation_code := l_legislation_code;
196: end if;
197: if g_debug then
198: hr_utility.set_location(' Leaving:'|| l_proc, 40);
199: end if;

Line 445: end hxc_lkr_bus;

441: hr_utility.set_location(' Leaving:'||l_proc, 10);
442: end if;
443: End delete_validate;
444: --
445: end hxc_lkr_bus;