1: PACKAGE BODY hxc_apc_upload_pkg AS
2: /* $Header: hxcapcupl.pkb 120.2 2005/09/23 08:04:37 sechandr noship $ */
3:
4: ------------------------------------------------------------------------------
5: g_debug boolean := hr_utility.debug_enabled;
6: ------------------------------------------------------------------------------
7: FUNCTION get_approval_period_set_id ( p_approval_period_set_name IN VARCHAR2 ) RETURN NUMBER IS
8:
9: CURSOR csr_get_approval_period_set_id IS
75: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
76: l_owner VARCHAR2(6);
77:
78: BEGIN
79: g_debug:=hr_utility.debug_enabled;
80: if g_debug then
81: hr_utility.set_location ('In load approval period comp row ', 10 );
82: end if;
83:
77:
78: BEGIN
79: g_debug:=hr_utility.debug_enabled;
80: if g_debug then
81: hr_utility.set_location ('In load approval period comp row ', 10 );
82: end if;
83:
84: l_approval_period_set_id := get_approval_period_set_id ( p_approval_period_set_name => p_approval_period_set_name );
85:
83:
84: l_approval_period_set_id := get_approval_period_set_id ( p_approval_period_set_name => p_approval_period_set_name );
85:
86: if g_debug then
87: hr_utility.set_location ('In load approval period comp row ', 20 );
88: end if;
89:
90: l_time_recipient_id := get_time_recipient_id( p_name => p_time_recipient_name );
91:
91:
92: l_recurring_period_id := get_recurring_period_id( p_name => p_recurring_period_name );
93:
94: if g_debug then
95: hr_utility.set_location ('In load approval period comp row ', 30 );
96: end if;
97:
98: SELECT sc.approval_period_comp_id
99: , sc.object_version_number
114: EXCEPTION WHEN NO_DATA_FOUND
115: THEN
116:
117: if g_debug then
118: hr_utility.set_location ('In load approval period comp row ', 40 );
119: end if;
120:
121: hxc_approval_period_comps_api.create_approval_period_comps (
122: p_approval_period_comp_id => l_approval_period_comp_id