DBA Data[Home] [Help]

APPS.HXC_HAT_BUS dependencies on HXC_HAT_BUS

Line 1: Package Body hxc_hat_bus as

1: Package Body hxc_hat_bus as
2: /* $Header: hxchatrhi.pkb 120.2 2005/09/23 10:41:13 sechandr noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_hat_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 124: if ( nvl(hxc_hat_bus.g_alias_type_id, hr_api.g_number)

120: ,p_argument => 'alias_type_id'
121: ,p_argument_value => p_alias_type_id
122: );
123: --
124: if ( nvl(hxc_hat_bus.g_alias_type_id, hr_api.g_number)
125: = p_alias_type_id) then
126: --
127: -- The legislation code has already been found with a previous
128: -- call to this function. Just return the value in the global

Line 131: l_legislation_code := hxc_hat_bus.g_legislation_code;

127: -- The legislation code has already been found with a previous
128: -- call to this function. Just return the value in the global
129: -- variable.
130: --
131: l_legislation_code := hxc_hat_bus.g_legislation_code;
132: if g_debug then
133: hr_utility.set_location(l_proc, 20);
134: end if;
135: else

Line 159: hxc_hat_bus.g_alias_type_id := p_alias_type_id;

155: -- Set the global variables so the values are
156: -- available for the next call to this function.
157: --
158: close csr_leg_code;
159: hxc_hat_bus.g_alias_type_id := p_alias_type_id;
160: hxc_hat_bus.g_legislation_code := l_legislation_code;
161: end if;
162: if g_debug then
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 160: hxc_hat_bus.g_legislation_code := l_legislation_code;

156: -- available for the next call to this function.
157: --
158: close csr_leg_code;
159: hxc_hat_bus.g_alias_type_id := p_alias_type_id;
160: hxc_hat_bus.g_legislation_code := l_legislation_code;
161: end if;
162: if g_debug then
163: hr_utility.set_location(' Leaving:'|| l_proc, 40);
164: end if;

Line 399: end hxc_hat_bus;

395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: end if;
397: End delete_validate;
398: --
399: end hxc_hat_bus;