APPS.HXC_ALIAS_DEFINITIONS_API dependencies on HXC_ALIAS_DEFINITIONS

Line 1: Package Body hxc_alias_definitions_api as

1: Package Body hxc_alias_definitions_api as
2: /* $Header: hxchadapi.pkb 120.2 2005/09/23 08:09:15 sechandr noship $ */
3: --
4: -- Package Variables
5: --

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

2: /* $Header: hxchadapi.pkb 120.2 2005/09/23 08:09:15 sechandr noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_alias_definitions_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_alias_definition >------------------------|

Line 32: l_object_version_number hxc_alias_definitions.object_version_number%TYPE;

28: -- Declare cursors and local variables
29: --
30:
31: l_proc varchar2(72);
32: l_object_version_number hxc_alias_definitions.object_version_number%TYPE;
33: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
34: l_language_code hxc_alias_definitions_tl.language%TYPE;
35:
36: begin

Line 33: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;

29: --
30:
31: l_proc varchar2(72);
32: l_object_version_number hxc_alias_definitions.object_version_number%TYPE;
33: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
34: l_language_code hxc_alias_definitions_tl.language%TYPE;
35:
36: begin
37: g_debug:=hr_utility.debug_enabled;

Line 34: l_language_code hxc_alias_definitions_tl.language%TYPE;

30:
31: l_proc varchar2(72);
32: l_object_version_number hxc_alias_definitions.object_version_number%TYPE;
33: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
34: l_language_code hxc_alias_definitions_tl.language%TYPE;
35:
36: begin
37: g_debug:=hr_utility.debug_enabled;
38: if g_debug then

Line 65: hxc_alias_definitions_bk_1.create_alias_definition_b

61: hr_utility.set_location('Entering:'|| l_proc, 20);
62: end if;
63: --
64: begin
65: hxc_alias_definitions_bk_1.create_alias_definition_b
66: (p_alias_definition_name => p_alias_definition_name
67: ,p_alias_context_code => p_alias_context_code
68: ,p_business_group_id => p_business_group_id
69: ,p_legislation_code => p_legislation_code

Line 133: hxc_alias_definitions_bk_1.create_alias_definition_a

129: hr_utility.set_location(l_proc, 50);
130: end if;
131: --
132: begin
133: hxc_alias_definitions_bk_1.create_alias_definition_a
134: (p_alias_definition_id => l_alias_definition_id
135: ,p_alias_definition_name => p_alias_definition_name
136: ,p_alias_context_code => p_alias_context_code
137: ,p_business_group_id => p_business_group_id

Line 220: l_object_version_number hxc_alias_definitions.object_version_number%TYPE := p_object_version_number;

216: -- Declare cursors and local variables
217: --
218:
219: l_proc varchar2(72);
220: l_object_version_number hxc_alias_definitions.object_version_number%TYPE := p_object_version_number;
221: l_language_code hxc_alias_definitions_tl.language%TYPE;
222:
223: begin
224: g_debug:=hr_utility.debug_enabled;

Line 221: l_language_code hxc_alias_definitions_tl.language%TYPE;

217: --
218:
219: l_proc varchar2(72);
220: l_object_version_number hxc_alias_definitions.object_version_number%TYPE := p_object_version_number;
221: l_language_code hxc_alias_definitions_tl.language%TYPE;
222:
223: begin
224: g_debug:=hr_utility.debug_enabled;
225: if g_debug then

Line 253: hxc_alias_definitions_bk_1.update_alias_definition_b

249: hr_utility.set_location('Entering:'|| l_proc, 20);
250: end if;
251: --
252: begin
253: hxc_alias_definitions_bk_1.update_alias_definition_b
254: (p_alias_definition_id => p_alias_definition_id
255: ,p_alias_definition_name => p_alias_definition_name
256: ,p_alias_context_code => p_alias_context_code
257: ,p_business_group_id => p_business_group_id

Line 323: hxc_alias_definitions_bk_1.update_alias_definition_a

319: hr_utility.set_location(l_proc, 50);
320: end if;
321: --
322: begin
323: hxc_alias_definitions_bk_1.update_alias_definition_a
324: (p_alias_definition_id => p_alias_definition_id
325: ,p_alias_definition_name => p_alias_definition_name
326: ,p_alias_context_code => p_alias_context_code
327: ,p_business_group_id => p_business_group_id

Line 423: hxc_alias_definitions_bk_1.delete_alias_definition_b

419: hr_utility.set_location('Entering:'|| l_proc, 20);
420: end if;
421: --
422: begin
423: hxc_alias_definitions_bk_1.delete_alias_definition_b
424: (p_alias_definition_id => p_alias_definition_id
425: ,p_object_version_number => p_object_version_number
426: );
427: exception

Line 469: hxc_alias_definitions_bk_1.delete_alias_definition_a

465: hr_utility.set_location(l_proc, 50);
466: end if;
467: --
468: begin
469: hxc_alias_definitions_bk_1.delete_alias_definition_a
470: (p_alias_definition_id => p_alias_definition_id
471: ,p_object_version_number => p_object_version_number
472: );
473: exception

Line 519: end hxc_alias_definitions_api;

515: end if;
516: raise;
517: end delete_alias_definition;
518: --
519: end hxc_alias_definitions_api;