DBA Data[Home] [Help]

APPS.HXC_RRC_UPLOAD_PKG dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_rrc_upload_pkg AS
2: /* $Header: hxcrrcupl.pkb 120.2 2005/09/23 06:19:35 nissharm noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: FUNCTION get_retrieval_rule_group_id ( p_retrieval_rule_group_name IN VARCHAR2 ) RETURN NUMBER IS
7:
8: CURSOR csr_get_rtr_group_id IS

Line 58: g_debug := hr_utility.debug_enabled;

54: l_owner VARCHAR2(6);
55:
56: BEGIN
57:
58: g_debug := hr_utility.debug_enabled;
59:
60: if g_debug then
61: hr_utility.set_location ('In load retrieval rule comp row ', 10 );
62: end if;

Line 61: hr_utility.set_location ('In load retrieval rule comp row ', 10 );

57:
58: g_debug := hr_utility.debug_enabled;
59:
60: if g_debug then
61: hr_utility.set_location ('In load retrieval rule comp row ', 10 );
62: end if;
63:
64: l_retrieval_rule_group_id := get_retrieval_rule_group_id ( p_retrieval_rule_group_name =>
65: p_retrieval_rule_group_name );

Line 68: hr_utility.set_location ('In load retrieval rule comp row ', 20 );

64: l_retrieval_rule_group_id := get_retrieval_rule_group_id ( p_retrieval_rule_group_name =>
65: p_retrieval_rule_group_name );
66:
67: if g_debug then
68: hr_utility.set_location ('In load retrieval rule comp row ', 20 );
69: end if;
70:
71: l_retrieval_rule_id := get_retrieval_rule_id( p_name => p_retrieval_rule_name );
72:

Line 74: hr_utility.set_location ('In load retrieval rule comp row ', 30 );

70:
71: l_retrieval_rule_id := get_retrieval_rule_id( p_name => p_retrieval_rule_name );
72:
73: if g_debug then
74: hr_utility.set_location ('In load retrieval rule comp row ', 30 );
75: end if;
76:
77: SELECT rrc.retrieval_rule_group_comp_id
78: , rrc.object_version_number

Line 96: hr_utility.set_location ('In load retrieval rule comp row ', 40 );

92: EXCEPTION WHEN NO_DATA_FOUND
93: THEN
94:
95: if g_debug then
96: hr_utility.set_location ('In load retrieval rule comp row ', 40 );
97: end if;
98:
99: hxc_ret_rule_grp_comp_api.create_ret_rule_grp_comp (
100: p_ret_rule_grp_comp_id => l_rtr_group_comp_id