[Home] [Help]
1: Package Body hxc_approval_period_comps_api as
2: /* $Header: hxcapcapi.pkb 120.2 2005/09/23 08:04:10 sechandr noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hxcapcapi.pkb 120.2 2005/09/23 08:04:10 sechandr noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_approval_period_comps_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_period_comps >----------------|
23: -- Declare cursors and local variables
24: --
25:
26: l_proc varchar2(72);
27: l_object_version_number hxc_approval_period_comps.object_version_number%TYPE;
28: l_approval_period_comp_id hxc_approval_period_comps.approval_period_comp_id%TYPE;
29: --
30: Begin
31: --
24: --
25:
26: l_proc varchar2(72);
27: l_object_version_number hxc_approval_period_comps.object_version_number%TYPE;
28: l_approval_period_comp_id hxc_approval_period_comps.approval_period_comp_id%TYPE;
29: --
30: Begin
31: --
32: g_debug:=hr_utility.debug_enabled;
49: --
50: -- Call Before Process User Hook
51: --
52: begin
53: hxc_approval_period_comps_bk_1.create_approval_period_comps_b
54: (p_approval_period_comp_id => p_approval_period_comp_id
55: ,p_object_version_number => p_object_version_number
56: ,p_approval_period_set_id => p_approval_period_set_id
57: ,p_time_recipient_id => p_time_recipient_id
101: --
102: -- Call After Process User Hook
103: --
104: begin
105: hxc_approval_period_comps_bk_1.create_approval_period_comps_a
106: (p_approval_period_comp_id => p_approval_period_comp_id
107: ,p_object_version_number => p_object_version_number
108: ,p_approval_period_set_id => p_approval_period_set_id
109: ,p_time_recipient_id => p_time_recipient_id
188: --
189: -- Declare cursors and local variables
190: --
191: l_proc varchar2(72);
192: l_object_version_number hxc_approval_period_comps.object_version_number%TYPE := p_object_version_number;
193: --
194: Begin
195: --
196: g_debug:=hr_utility.debug_enabled;
209: --
210: -- Call Before Process User Hook
211: --
212: begin
213: hxc_approval_period_comps_bk_1.update_approval_period_comps_b
214: (p_approval_period_comp_id => p_approval_period_comp_id
215: ,p_object_version_number => p_object_version_number
216: ,p_approval_period_set_id => p_approval_period_set_id
217: ,p_time_recipient_id => p_time_recipient_id
257: --
258: -- Call After Process User Hook
259: --
260: begin
261: hxc_approval_period_comps_bk_1.update_approval_period_comps_a
262: (p_approval_period_comp_id => p_approval_period_comp_id
263: ,p_object_version_number => p_object_version_number
264: ,p_recurring_period_id => p_recurring_period_id
265: ,p_approval_period_set_id => p_approval_period_set_id
367: -- Call Before Process User Hook
368: --
369: begin
370: --
371: hxc_approval_period_comps_bk_1.delete_approval_period_comps_b
372: (p_approval_period_comp_id => p_approval_period_comp_id
373: ,p_object_version_number => p_object_version_number
374: );
375: exception
399: -- Call After Process User Hook
400: --
401: begin
402: --
403: hxc_approval_period_comps_bk_1.delete_approval_period_comps_a
404: (p_approval_period_comp_id => p_approval_period_comp_id
405: ,p_object_version_number => p_object_version_number
406: );
407: exception
439: raise;
440: --
441: end delete_approval_period_comps;
442: --
443: end hxc_approval_period_comps_api;