DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_MATRIX dependencies on HR_UTILITY

Line 13: g_debug boolean := hr_utility.debug_enabled;

9: --
10: TYPE node_tbl_typ IS TABLE OF varchar2(1) INDEX BY binary_integer;
11: g_node_tbl node_tbl_typ ;
12:
13: g_debug boolean := hr_utility.debug_enabled;
14: g_package varchar2(33) := 'ben_evaluate_rate_matrix.';
15: --
16: -- ----------------------------------------------------------------------------
17: -- | Procedure Definitions |

Line 83: g_debug := hr_utility.debug_enabled;

79: l_proc varchar2(61) := g_package||'determine_rate';
80:
81: begin
82:
83: g_debug := hr_utility.debug_enabled;
84:
85: if g_debug then
86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);

Line 86: hr_utility.set_location('Entering :'||l_proc,5);

82:
83: g_debug := hr_utility.debug_enabled;
84:
85: if g_debug then
86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);
88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);
89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);
90: hr_utility.set_location('p_effective_date '||p_effective_date,5);

Line 87: hr_utility.set_location('p_person_id '||p_person_id,5);

83: g_debug := hr_utility.debug_enabled;
84:
85: if g_debug then
86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);
88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);
89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);
90: hr_utility.set_location('p_effective_date '||p_effective_date,5);
91: end if;

Line 88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);

84:
85: if g_debug then
86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);
88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);
89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);
90: hr_utility.set_location('p_effective_date '||p_effective_date,5);
91: end if;
92:

Line 89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);

85: if g_debug then
86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);
88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);
89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);
90: hr_utility.set_location('p_effective_date '||p_effective_date,5);
91: end if;
92:
93: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 90: hr_utility.set_location('p_effective_date '||p_effective_date,5);

86: hr_utility.set_location('Entering :'||l_proc,5);
87: hr_utility.set_location('p_person_id '||p_person_id,5);
88: hr_utility.set_location('p_assignment_id '||p_assignment_id,5);
89: hr_utility.set_location('p_criteria_rate_defn_id '||p_criteria_rate_defn_id,5);
90: hr_utility.set_location('p_effective_date '||p_effective_date,5);
91: end if;
92:
93: hr_api.mandatory_arg_error(p_api_name => l_proc,
94: p_argument => 'effective_date',

Line 114: hr_utility.set_location('l_mtx_pl_id '||l_mtx_pl_id,5);

110: if c_pl%notfound then
111: exit;
112: end if;
113:
114: hr_utility.set_location('l_mtx_pl_id '||l_mtx_pl_id,5);
115:
116: open c_rate_matrix(l_mtx_pl_id);
117: loop
118: fetch c_rate_matrix into l_rate_matrix_rec;

Line 124: hr_utility.set_location(lpad('+',(l_rate_matrix_rec.level-1),'+')||l_rate_matrix_rec.node_name,10);

120: exit;
121: end if;
122:
123: if g_debug then
124: hr_utility.set_location(lpad('+',(l_rate_matrix_rec.level-1),'+')||l_rate_matrix_rec.node_name,10);
125: hr_utility.set_location('elp id '||l_rate_matrix_rec.eligy_prfl_id,10);
126: hr_utility.set_location('pl id '||l_rate_matrix_rec.pl_id,10);
127: hr_utility.set_location('bg id '||l_rate_matrix_rec.business_group_id,10);
128: end if;

Line 125: hr_utility.set_location('elp id '||l_rate_matrix_rec.eligy_prfl_id,10);

121: end if;
122:
123: if g_debug then
124: hr_utility.set_location(lpad('+',(l_rate_matrix_rec.level-1),'+')||l_rate_matrix_rec.node_name,10);
125: hr_utility.set_location('elp id '||l_rate_matrix_rec.eligy_prfl_id,10);
126: hr_utility.set_location('pl id '||l_rate_matrix_rec.pl_id,10);
127: hr_utility.set_location('bg id '||l_rate_matrix_rec.business_group_id,10);
128: end if;
129:

Line 126: hr_utility.set_location('pl id '||l_rate_matrix_rec.pl_id,10);

122:
123: if g_debug then
124: hr_utility.set_location(lpad('+',(l_rate_matrix_rec.level-1),'+')||l_rate_matrix_rec.node_name,10);
125: hr_utility.set_location('elp id '||l_rate_matrix_rec.eligy_prfl_id,10);
126: hr_utility.set_location('pl id '||l_rate_matrix_rec.pl_id,10);
127: hr_utility.set_location('bg id '||l_rate_matrix_rec.business_group_id,10);
128: end if;
129:
130: l_parent_eligible := 'N';

Line 127: hr_utility.set_location('bg id '||l_rate_matrix_rec.business_group_id,10);

123: if g_debug then
124: hr_utility.set_location(lpad('+',(l_rate_matrix_rec.level-1),'+')||l_rate_matrix_rec.node_name,10);
125: hr_utility.set_location('elp id '||l_rate_matrix_rec.eligy_prfl_id,10);
126: hr_utility.set_location('pl id '||l_rate_matrix_rec.pl_id,10);
127: hr_utility.set_location('bg id '||l_rate_matrix_rec.business_group_id,10);
128: end if;
129:
130: l_parent_eligible := 'N';
131: l_node_eligible := 'N';

Line 180: hr_utility.set_location('Leaving :'||l_proc,5);

176: end loop;
177: close c_pl;
178:
179: if g_debug then
180: hr_utility.set_location('Leaving :'||l_proc,5);
181: end if;
182:
183: end determine_rate;
184: