1: Package Body hxc_approval_styles_api as
2: /* $Header: hxchasapi.pkb 120.3 2006/06/08 14:58:58 gsirigin noship $ */
3: --
4: -- Package Variables
5: --
2: /* $Header: hxchasapi.pkb 120.3 2006/06/08 14:58:58 gsirigin noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_approval_styles_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_approval_styles >----------------------|
27: -- Declare cursors and local variables
28: --
29:
30: l_proc varchar2(72);
31: l_object_version_number hxc_approval_styles.object_version_number%TYPE;
32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
33: --
34: Begin
35: --
28: --
29:
30: l_proc varchar2(72);
31: l_object_version_number hxc_approval_styles.object_version_number%TYPE;
32: l_approval_style_id hxc_approval_styles.approval_style_id%TYPE;
33: --
34: Begin
35: --
36: g_debug:=hr_utility.debug_enabled;
53: --
54: -- Call Before Process User Hook
55: --
56: begin
57: hxc_approval_styles_bk_1.create_approval_styles_b
58: (p_approval_style_id => p_approval_style_id
59: ,p_object_version_number => p_object_version_number
60: ,p_name => p_name
61: ,p_business_group_id => p_business_group_id
112: --
113: -- Call After Process User Hook
114: --
115: begin
116: hxc_approval_styles_bk_1.create_approval_styles_a
117: (p_approval_style_id => p_approval_style_id
118: ,p_object_version_number => p_object_version_number
119: ,p_name => p_name
120: ,p_business_group_id => p_business_group_id
207: --
208: -- Declare cursors and local variables
209: --
210: l_proc varchar2(72);
211: l_object_version_number hxc_approval_styles.object_version_number%TYPE := p_object_version_number;
212: --
213: Begin
214: --
215: g_debug:=hr_utility.debug_enabled;
228: --
229: -- Call Before Process User Hook
230: --
231: begin
232: hxc_approval_styles_bk_1.update_approval_styles_b
233: (p_approval_style_id => p_approval_style_id
234: ,p_object_version_number => p_object_version_number
235: ,p_name => p_name
236: ,p_business_group_id => p_business_group_id
276: --
277: -- Call After Process User Hook
278: --
279: begin
280: hxc_approval_styles_bk_1.update_approval_styles_a
281: (p_approval_style_id => p_approval_style_id
282: ,p_object_version_number => p_object_version_number
283: ,p_name => p_name
284: ,p_business_group_id => p_business_group_id
379: -- Call Before Process User Hook
380: --
381: begin
382: --
383: hxc_approval_styles_bk_1.delete_approval_styles_b
384: (p_approval_style_id => p_approval_style_id
385: ,p_object_version_number => p_object_version_number
386: );
387: exception
411: -- Call After Process User Hook
412: --
413: begin
414: --
415: hxc_approval_styles_bk_1.delete_approval_styles_a
416: (p_approval_style_id => p_approval_style_id
417: ,p_object_version_number => p_object_version_number
418: );
419: exception
451: raise;
452: --
453: end delete_approval_styles;
454: --
455: end hxc_approval_styles_api;