APPS.HXC_INLINE_NOTIF_UTILS_PKG dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: c_end_of_time_string CONSTANT VARCHAR2(19) := '4712/12/31 00:00:00';
5: c_new_get_type CONSTANT VARCHAR2(3) := 'NEW';
6: c_old_get_type CONSTANT VARCHAR2(3) := 'OLD';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9:
10: type context_details is record
11: (context fnd_descr_flex_contexts.descriptive_flex_context_code%type,
12: block_id hxc_time_building_blocks.time_building_block_id%type,

Line 63: hr_utility.trace(' p_context '||p_context);

59: l_flex_valuset_id VARCHAR2(150);
60:
61: BEGIN
62: if g_debug then
63: hr_utility.trace(' p_context '||p_context);
64: hr_utility.trace(' p_det_bb_id '||p_det_bb_id);
65: hr_utility.trace(' p_det_bb_ovn '||p_det_bb_ovn);
66: end if;
67:

Line 64: hr_utility.trace(' p_det_bb_id '||p_det_bb_id);

60:
61: BEGIN
62: if g_debug then
63: hr_utility.trace(' p_context '||p_context);
64: hr_utility.trace(' p_det_bb_id '||p_det_bb_id);
65: hr_utility.trace(' p_det_bb_ovn '||p_det_bb_ovn);
66: end if;
67:
68: l_query := ' select hta.'||p_column||fnd_global.local_chr('10');

Line 65: hr_utility.trace(' p_det_bb_ovn '||p_det_bb_ovn);

61: BEGIN
62: if g_debug then
63: hr_utility.trace(' p_context '||p_context);
64: hr_utility.trace(' p_det_bb_id '||p_det_bb_id);
65: hr_utility.trace(' p_det_bb_ovn '||p_det_bb_ovn);
66: end if;
67:
68: l_query := ' select hta.'||p_column||fnd_global.local_chr('10');
69:

Line 116: hr_utility.trace(' l_id '||l_id);

112: OPEN flex_cr FOR l_query USING p_det_bb_id,p_det_bb_ovn,p_context;
113: FETCH flex_cr INTO l_id;
114:
115: if g_debug then
116: hr_utility.trace(' l_id '||l_id);
117: end if;
118:
119: IF (flex_cr%found) THEN
120: CLOSE flex_cr;

Line 127: hr_utility.trace(' l_flex_valuset_id '||l_flex_valuset_id);

123: IF (p_context like 'PAEXPITDFF%') THEN
124: OPEN cur_flex_value_set(p_context,p_column);
125: FETCH cur_flex_value_set INTO l_flex_valuset_id;
126: if g_debug then
127: hr_utility.trace(' l_flex_valuset_id '||l_flex_valuset_id);
128: end if;
129: IF (cur_flex_value_set%found) and (l_flex_valuset_id is not null)
130: and (l_id is not null)
131: THEN

Line 621: g_debug := hr_utility.debug_enabled;

617: and htbb.approval_status = hxc_timecard.c_submitted_status;
618:
619: BEGIN
620:
621: g_debug := hr_utility.debug_enabled;
622:
623: l_day_detail_array := p_day_detail_array;
624:
625: if p_tk_audit ='YES' then