DBA Data[Home] [Help]

APPS.HXC_APC_UPLOAD_PKG dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

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

Line 79: g_debug:=hr_utility.debug_enabled;

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:

Line 81: hr_utility.set_location ('In load approval period comp row ', 10 );

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:

Line 87: hr_utility.set_location ('In load approval period comp row ', 20 );

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:

Line 95: hr_utility.set_location ('In load approval period comp row ', 30 );

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

Line 118: hr_utility.set_location ('In load approval period comp row ', 40 );

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