DBA Data[Home] [Help]

APPS.HXC_ASC_UPLOAD_PKG dependencies on HR_UTILITY

Line 4: g_debug boolean :=hr_utility.debug_enabled;

1: PACKAGE BODY hxc_asc_upload_pkg AS
2: /* $Header: hxcascupl.pkb 120.2 2005/09/23 10:39:09 sechandr noship $ */
3:
4: g_debug boolean :=hr_utility.debug_enabled;
5:
6: FUNCTION get_application_set_id ( p_application_set_name IN VARCHAR2 ) RETURN NUMBER IS
7:
8: CURSOR csr_get_application_set_id IS

Line 58: g_debug:=hr_utility.debug_enabled;

54: l_ovn hxc_entity_group_comps.object_version_number%TYPE;
55: l_owner VARCHAR2(6);
56:
57: BEGIN
58: g_debug:=hr_utility.debug_enabled;
59: if g_debug then
60: hr_utility.set_location ('In load application set comp row ', 10 );
61: end if;
62:

Line 60: hr_utility.set_location ('In load application set comp row ', 10 );

56:
57: BEGIN
58: g_debug:=hr_utility.debug_enabled;
59: if g_debug then
60: hr_utility.set_location ('In load application set comp row ', 10 );
61: end if;
62:
63: l_application_set_id := get_application_set_id ( p_application_set_name => p_application_set_name );
64:

Line 66: hr_utility.set_location ('In load application set comp row ', 20 );

62:
63: l_application_set_id := get_application_set_id ( p_application_set_name => p_application_set_name );
64:
65: if g_debug then
66: hr_utility.set_location ('In load application set comp row ', 20 );
67: end if;
68:
69: l_time_recipient_id := get_time_recipient_id ( p_name => p_time_recipient_name );
70:

Line 72: hr_utility.set_location ('In load application set comp row ', 30 );

68:
69: l_time_recipient_id := get_time_recipient_id ( p_name => p_time_recipient_name );
70:
71: if g_debug then
72: hr_utility.set_location ('In load application set comp row ', 30 );
73: end if;
74:
75: SELECT sc.application_set_comp_id
76: , sc.object_version_number

Line 94: hr_utility.set_location ('In load application set comp row ', 40 );

90: EXCEPTION WHEN NO_DATA_FOUND
91: THEN
92:
93: if g_debug then
94: hr_utility.set_location ('In load application set comp row ', 40 );
95: end if;
96:
97: hxc_application_set_comp_api.create_application_set_comp (
98: p_application_set_comp_id => l_application_set_comp_id