APPS.HXC_HAN_BUS dependencies on HXC_HAN_BUS

Line 1: Package Body hxc_han_bus as

1: Package Body hxc_han_bus as
2: /* $Header: hxchanrhi.pkb 120.2 2006/07/10 10:09:56 gsirigin noship $ */
3: --
4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |

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

4: -- ----------------------------------------------------------------------------
5: -- | Private Global Definitions |
6: -- ----------------------------------------------------------------------------
7: --
8: g_package varchar2(33) := ' hxc_han_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 159: if (( nvl(hxc_han_bus.g_comp_notification_id, hr_api.g_number)

155: ,p_argument => 'object_version_number'
156: ,p_argument_value => p_object_version_number
157: );
158: --
159: if (( nvl(hxc_han_bus.g_comp_notification_id, hr_api.g_number)
160: = p_comp_notification_id)
161: and ( nvl(hxc_han_bus.g_object_version_number, hr_api.g_number)
162: = p_object_version_number)) then
163: --

Line 161: and ( nvl(hxc_han_bus.g_object_version_number, hr_api.g_number)

157: );
158: --
159: if (( nvl(hxc_han_bus.g_comp_notification_id, hr_api.g_number)
160: = p_comp_notification_id)
161: and ( nvl(hxc_han_bus.g_object_version_number, hr_api.g_number)
162: = p_object_version_number)) then
163: --
164: -- The legislation code has already been found with a previous
165: -- call to this function. Just return the value in the global

Line 168: l_legislation_code := hxc_han_bus.g_legislation_code;

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

Line 196: hxc_han_bus.g_comp_notification_id := p_comp_notification_id;

192: -- Set the global variables so the values are
193: -- available for the next call to this function.
194: --
195: close csr_leg_code;
196: hxc_han_bus.g_comp_notification_id := p_comp_notification_id;
197: hxc_han_bus.g_object_version_number := p_object_version_number;
198: hxc_han_bus.g_legislation_code := l_legislation_code;
199: end if;
200: if g_debug then

Line 197: hxc_han_bus.g_object_version_number := p_object_version_number;

193: -- available for the next call to this function.
194: --
195: close csr_leg_code;
196: hxc_han_bus.g_comp_notification_id := p_comp_notification_id;
197: hxc_han_bus.g_object_version_number := p_object_version_number;
198: hxc_han_bus.g_legislation_code := l_legislation_code;
199: end if;
200: if g_debug then
201: hr_utility.set_location(' Leaving:'|| l_proc, 40);

Line 198: hxc_han_bus.g_legislation_code := l_legislation_code;

194: --
195: close csr_leg_code;
196: hxc_han_bus.g_comp_notification_id := p_comp_notification_id;
197: hxc_han_bus.g_object_version_number := p_object_version_number;
198: hxc_han_bus.g_legislation_code := l_legislation_code;
199: end if;
200: if g_debug then
201: hr_utility.set_location(' Leaving:'|| l_proc, 40);
202: end if;

Line 539: end hxc_han_bus;

535: hr_utility.set_location(' Leaving:'||l_proc, 10);
536: end if;
537: End delete_validate;
538: --
539: end hxc_han_bus;