DBA Data[Home] [Help]

APPS.HXC_ALIAS_VALUES_API dependencies on HXC_ALIAS_VALUES

Line 1: Package Body hxc_alias_values_api as

1: Package Body hxc_alias_values_api as
2: /* $Header: hxchavapi.pkb 120.2 2005/09/23 10:41:26 sechandr noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 60: l_object_version_number hxc_alias_values.object_version_number%TYPE;

56: -- Declare cursors and local variables
57: --
58:
59: l_proc varchar2(72);
60: l_object_version_number hxc_alias_values.object_version_number%TYPE;
61: l_alias_value_id hxc_alias_values.alias_value_id%TYPE;
62: l_language_code hxc_alias_definitions_tl.language%TYPE;
63:
64: begin

Line 61: l_alias_value_id hxc_alias_values.alias_value_id%TYPE;

57: --
58:
59: l_proc varchar2(72);
60: l_object_version_number hxc_alias_values.object_version_number%TYPE;
61: l_alias_value_id hxc_alias_values.alias_value_id%TYPE;
62: l_language_code hxc_alias_definitions_tl.language%TYPE;
63:
64: begin
65: g_debug:=hr_utility.debug_enabled;

Line 89: hxc_alias_values_bk_1.create_alias_value_b

85: --
86: -- Call Before Process User Hook
87: --
88: begin
89: hxc_alias_values_bk_1.create_alias_value_b
90: (p_alias_value_name => p_alias_value_name
91: ,p_date_from => p_date_from
92: ,p_date_to => p_date_to
93: ,p_alias_definition_id => p_alias_definition_id

Line 204: hxc_alias_values_bk_1.create_alias_value_a

200: --
201: -- Call After Process User Hook
202: --
203: begin
204: hxc_alias_values_bk_1.create_alias_value_a
205: (p_alias_value_id => l_alias_value_id
206: ,p_alias_value_name => p_alias_value_name
207: ,p_date_from => p_date_from
208: ,p_date_to => p_date_to

Line 346: l_object_version_number hxc_alias_values.object_version_number%TYPE := p_object_version_number;

342: -- Declare cursors and local variables
343: --
344:
345: l_proc varchar2(72);
346: l_object_version_number hxc_alias_values.object_version_number%TYPE := p_object_version_number;
347: l_language_code hxc_alias_definitions_tl.language%TYPE;
348:
349: begin
350: g_debug:=hr_utility.debug_enabled;

Line 375: hxc_alias_values_bk_1.update_alias_value_b

371: --
372: -- Call Before Process User Hook
373: --
374: begin
375: hxc_alias_values_bk_1.update_alias_value_b
376: (p_alias_value_id => p_alias_value_id
377: ,p_alias_value_name => p_alias_value_name
378: ,p_date_from => p_date_from
379: ,p_date_to => p_date_to

Line 492: hxc_alias_values_bk_1.update_alias_value_a

488: --
489: -- Call After Process User Hook
490: --
491: begin
492: hxc_alias_values_bk_1.update_alias_value_a
493: (p_alias_value_id => p_alias_value_id
494: ,p_alias_value_name => p_alias_value_name
495: ,p_date_from => p_date_from
496: ,p_date_to => p_date_to

Line 618: hxc_alias_values_bk_1.delete_alias_value_b

614: hr_utility.set_location('Entering:'|| l_proc, 20);
615: end if;
616: --
617: begin
618: hxc_alias_values_bk_1.delete_alias_value_b
619: (p_alias_value_id => p_alias_value_id
620: ,p_object_version_number => p_object_version_number
621: );
622: exception

Line 667: hxc_alias_values_bk_1.delete_alias_value_a

663: hr_utility.set_location(l_proc, 50);
664: end if;
665: --
666: begin
667: hxc_alias_values_bk_1.delete_alias_value_a
668: (p_alias_value_id => p_alias_value_id
669: ,p_object_version_number => p_object_version_number
670: );
671: exception

Line 717: end hxc_alias_values_api;

713: end if;
714: raise;
715: end delete_alias_value;
716: --
717: end hxc_alias_values_api;