APPS.PAY_SE_SOE dependencies on HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY pay_se_soe as
2: /* $Header: pysesoer.pkb 120.0 2005/05/29 08:37:54 appldev noship $ */
3: --
4: l_sql long;
5: g_debug boolean := hr_utility.debug_enabled;
6: g_max_action number;
7: g_min_action number;
8:
9: --

Line 21: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);

17: begin
18: --
19: --
20: if g_debug then
21: hr_utility.set_location('Entering pay_soe_glb.getElements', 10);
22: end if;
23: --
24: l_sql :=
25: 'select /*+ ORDERED */ nvl(ettl.reporting_name,et.element_type_id) COL01

Line 73: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);

69: order by nvl(ettl.reporting_name,ettl.element_name)';
70: --
71: --
72: if g_debug then
73: hr_utility.set_location('Leaving pay_soe_glb.getElements', 20);
74: end if;
75: --
76: return l_sql;
77: --

Line 89: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);

85: function getInformation(p_assignment_action_id number
86: ,p_element_set_name varchar2) return long is
87: begin
88: --
89: hr_utility.trace('in getInformation' || p_element_set_name || p_assignment_action_id);
90: l_sql :=
91: 'select distinct ettl.element_name COL01
92: , nvl(ettl.reporting_name, ettl.element_name) COL02 -- for BUG 3880887
93: , ivtl.name COL03

Line 156: hr_utility.trace('Entering elements1');

152: Text
153: ------------------------------------------------------------------------ */
154: function Elements1(p_assignment_action_id number) return long is
155: begin
156: hr_utility.trace('Entering elements1');
157: return getElements(p_assignment_action_id
158: ,pay_soe_util.getConfig('ELEMENTS1'));
159: hr_utility.trace('Leaving Elements1');
160: end Elements1;

Line 159: hr_utility.trace('Leaving Elements1');

155: begin
156: hr_utility.trace('Entering elements1');
157: return getElements(p_assignment_action_id
158: ,pay_soe_util.getConfig('ELEMENTS1'));
159: hr_utility.trace('Leaving Elements1');
160: end Elements1;
161: --
162: /* ---------------------------------------------------------------------
163: Function : Elements2

Line 181: hr_utility.trace('in Information1');

177: Text
178: ------------------------------------------------------------------------ */
179: function Information1(p_assignment_action_id number) return long is
180: begin
181: hr_utility.trace('in Information1');
182: return getInformation(p_assignment_action_id
183: ,pay_soe_util.getConfig('INFORMATION1'));
184: end Information1;
185: --