eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_SPP_WI_DATA dependencies on HR_UTILITY

Line 153: hr_utility.set_location(p_placement_id,191);

149: l_effective_start_date date;
150: l_org_name varchar2(60);
151:
152: begin
153: hr_utility.set_location(p_placement_id,191);
154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);

Line 154: hr_utility.set_location(p_assignment_id,191);

150: l_org_name varchar2(60);
151:
152: begin
153: hr_utility.set_location(p_placement_id,191);
154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);
158: hr_utility.set_location(p_spinal_point_id,191);

Line 155: hr_utility.set_location(p_effective_date,191);

151:
152: begin
153: hr_utility.set_location(p_placement_id,191);
154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);
158: hr_utility.set_location(p_spinal_point_id,191);
159:

Line 156: hr_utility.set_location(p_parent_spine_id,191);

152: begin
153: hr_utility.set_location(p_placement_id,191);
154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);
158: hr_utility.set_location(p_spinal_point_id,191);
159:
160: select distinct substr(pap.full_name,1,60) ,paa.assignment_number,substr(org.name,1,60)

Line 157: hr_utility.set_location(p_step_id,191);

153: hr_utility.set_location(p_placement_id,191);
154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);
158: hr_utility.set_location(p_spinal_point_id,191);
159:
160: select distinct substr(pap.full_name,1,60) ,paa.assignment_number,substr(org.name,1,60)
161: into l_full_name ,l_assignment_number,l_org_name

Line 158: hr_utility.set_location(p_spinal_point_id,191);

154: hr_utility.set_location(p_assignment_id,191);
155: hr_utility.set_location(p_effective_date,191);
156: hr_utility.set_location(p_parent_spine_id,191);
157: hr_utility.set_location(p_step_id,191);
158: hr_utility.set_location(p_spinal_point_id,191);
159:
160: select distinct substr(pap.full_name,1,60) ,paa.assignment_number,substr(org.name,1,60)
161: into l_full_name ,l_assignment_number,l_org_name
162: from per_all_people_f pap,

Line 176: hr_utility.set_location(' Pay scale name',121);

172:
173: --
174: -- get the pay scale name
175: --
176: hr_utility.set_location(' Pay scale name',121);
177: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);
178: select substr(pps.name,1,30)
179: into l_pay_scale
180: from per_parent_spines pps

Line 177: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);

173: --
174: -- get the pay scale name
175: --
176: hr_utility.set_location(' Pay scale name',121);
177: hr_utility.set_location('parent_spine_id'||p_parent_spine_id,121);
178: select substr(pps.name,1,30)
179: into l_pay_scale
180: from per_parent_spines pps
181: where pps.parent_spine_id = p_parent_spine_id;

Line 186: hr_utility.set_location('grade name',122);

182:
183: --
184: -- get the grade name
185: --
186: hr_utility.set_location('grade name',122);
187: select substr(pg.name,1,30)
188: into l_grade_name
189: from per_grades_vl pg,
190: per_spinal_point_steps_f sps,

Line 228: hr_utility.set_location('spinal points',123);

224:
225: --
226: -- get the old and new spinal points
227: --
228: hr_utility.set_location('spinal points',123);
229: select substr(psp1.spinal_point,1,30),
230: substr(psp2.spinal_point,1,30),
231: psp1.spinal_point_id,
232: psp2.spinal_point_id

Line 255: hr_utility.set_location('l_old_spinal_point:'||l_old_spinal_point,124);

251: and sps2.effective_end_date;
252:
253: end if;
254:
255: hr_utility.set_location('l_old_spinal_point:'||l_old_spinal_point,124);
256: hr_utility.set_location('l_new_spinal_point:'||l_new_spinal_point,124);
257: hr_utility.set_location('l_old_spinal_point_id:'||l_old_spinal_point_id,124);
258:
259: open csr_point_values(l_old_spinal_point_id,l_new_spinal_point_id);

Line 256: hr_utility.set_location('l_new_spinal_point:'||l_new_spinal_point,124);

252:
253: end if;
254:
255: hr_utility.set_location('l_old_spinal_point:'||l_old_spinal_point,124);
256: hr_utility.set_location('l_new_spinal_point:'||l_new_spinal_point,124);
257: hr_utility.set_location('l_old_spinal_point_id:'||l_old_spinal_point_id,124);
258:
259: open csr_point_values(l_old_spinal_point_id,l_new_spinal_point_id);
260: fetch csr_point_values into l_old_value,l_new_value;

Line 257: hr_utility.set_location('l_old_spinal_point_id:'||l_old_spinal_point_id,124);

253: end if;
254:
255: hr_utility.set_location('l_old_spinal_point:'||l_old_spinal_point,124);
256: hr_utility.set_location('l_new_spinal_point:'||l_new_spinal_point,124);
257: hr_utility.set_location('l_old_spinal_point_id:'||l_old_spinal_point_id,124);
258:
259: open csr_point_values(l_old_spinal_point_id,l_new_spinal_point_id);
260: fetch csr_point_values into l_old_value,l_new_value;
261: if csr_point_values%notfound then