DBA Data[Home] [Help]

APPS.HXC_APPROVAL_PERIOD_SETS_API dependencies on HXC_APPROVAL_PERIOD_SETS

Line 1: Package Body hxc_approval_period_sets_api as

1: Package Body hxc_approval_period_sets_api as
2: /* $Header: hxcaprpsapi.pkb 120.2 2005/09/23 08:04:54 sechandr noship $ */
3: --
4: -- Package Variables
5: --

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

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

Line 25: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE;

21: -- Declare cursors and local variables
22: --
23:
24: l_proc varchar2(72);
25: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE;
26: l_approval_period_set_id hxc_approval_period_sets.approval_period_set_id%TYPE;
27: --
28: Begin
29: --

Line 26: l_approval_period_set_id hxc_approval_period_sets.approval_period_set_id%TYPE;

22: --
23:
24: l_proc varchar2(72);
25: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE;
26: l_approval_period_set_id hxc_approval_period_sets.approval_period_set_id%TYPE;
27: --
28: Begin
29: --
30: g_debug:=hr_utility.debug_enabled;

Line 50: hxc_approval_period_sets_bk_1.create_approval_period_sets_b

46: --
47: -- Call Before Process User Hook
48: --
49: begin
50: hxc_approval_period_sets_bk_1.create_approval_period_sets_b
51: (p_approval_period_set_id => p_approval_period_set_id
52: ,p_object_version_number => p_object_version_number
53: ,p_name => p_name
54: -- ,p_effective_date => p_effective_date

Line 97: hxc_approval_period_sets_bk_1.create_approval_period_sets_a

93: --
94: -- Call After Process User Hook
95: --
96: begin
97: hxc_approval_period_sets_bk_1.create_approval_period_sets_a
98: (p_approval_period_set_id => p_approval_period_set_id
99: ,p_object_version_number => p_object_version_number
100: ,p_name => p_name
101: -- ,p_effective_date => p_effective_date

Line 180: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE := p_object_version_number;

176: --
177: -- Declare cursors and local variables
178: --
179: l_proc varchar2(72);
180: l_object_version_number hxc_approval_period_sets.object_version_number%TYPE := p_object_version_number;
181: --
182: Begin
183: g_debug:=hr_utility.debug_enabled;
184: --

Line 201: hxc_approval_period_sets_bk_1.update_approval_period_sets_b

197: --
198: -- Call Before Process User Hook
199: --
200: begin
201: hxc_approval_period_sets_bk_1.update_approval_period_sets_b
202: (p_approval_period_set_id => p_approval_period_set_id
203: ,p_object_version_number => p_object_version_number
204: ,p_name => p_name
205: -- ,p_effective_date => p_effective_date

Line 237: hxc_approval_period_sets_bk_1.update_approval_period_sets_a

233: --
234: -- Call After Process User Hook
235: --
236: begin
237: hxc_approval_period_sets_bk_1.update_approval_period_sets_a
238: (p_approval_period_set_id => p_approval_period_set_id
239: ,p_object_version_number => p_object_version_number
240: ,p_name => p_name
241: -- ,p_effective_date => p_effective_date

Line 334: hxc_approval_period_sets_bk_1.delete_approval_period_sets_b

330: -- Call Before Process User Hook
331: --
332: begin
333: --
334: hxc_approval_period_sets_bk_1.delete_approval_period_sets_b
335: (p_approval_period_set_id => p_approval_period_set_id
336: ,p_object_version_number => p_object_version_number
337: );
338: exception

Line 366: hxc_approval_period_sets_bk_1.delete_approval_period_sets_a

362: -- Call After Process User Hook
363: --
364: begin
365: --
366: hxc_approval_period_sets_bk_1.delete_approval_period_sets_a
367: (p_approval_period_set_id => p_approval_period_set_id
368: ,p_object_version_number => p_object_version_number
369: );
370: exception

Line 406: end hxc_approval_period_sets_api;

402: raise;
403: --
404: end delete_approval_period_sets;
405: --
406: end hxc_approval_period_sets_api;