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.PER_QH_POPULATE dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering: '||l_proc,10);

29: and hrl.location_id=p_location_id;
30:
31: begin
32: --
33: hr_utility.set_location('Entering: '||l_proc,10);
34: open csr_location;
35: fetch csr_location into l_location_name;
36: close csr_location;
37: hr_utility.set_location('Leaving: '||l_proc,20);

Line 37: hr_utility.set_location('Leaving: '||l_proc,20);

33: hr_utility.set_location('Entering: '||l_proc,10);
34: open csr_location;
35: fetch csr_location into l_location_name;
36: close csr_location;
37: hr_utility.set_location('Leaving: '||l_proc,20);
38: return l_location_name;
39: end get_location;
40: --
41: -- ----------------------------------------------------------------------------

Line 60: hr_utility.set_location('Entering: '||l_proc,10);

56: and hotl.organization_id=ho.organization_id
57: and hotl.language=userenv('LANG');
58: begin
59: --
60: hr_utility.set_location('Entering: '||l_proc,10);
61: if p_organization_id is not null then
62: open csr_organization;
63: fetch csr_organization into l_organization_name;
64: close csr_organization;

Line 68: hr_utility.set_location('Leaving: '||l_proc,20);

64: close csr_organization;
65: else
66: l_organization_name:=null;
67: end if;
68: hr_utility.set_location('Leaving: '||l_proc,20);
69: return l_organization_name;
70: end get_organization;
71: --
72: -- ----------------------------------------------------------------------------

Line 88: hr_utility.set_location('Entering: '||l_proc,10);

84: from per_jobs_vl
85: where job_id=p_job_id;
86: begin
87: --
88: hr_utility.set_location('Entering: '||l_proc,10);
89: if p_job_id is not null then
90: open csr_job;
91: fetch csr_job into l_job_name;
92: close csr_job;

Line 96: hr_utility.set_location('Leaving: '||l_proc,20);

92: close csr_job;
93: else
94: l_job_name:=null;
95: end if;
96: hr_utility.set_location('Leaving: '||l_proc,20);
97: return l_job_name;
98: end get_job;
99: --
100: -- ----------------------------------------------------------------------------

Line 122: hr_utility.set_location('Entering: '||l_proc,10);

118: -- PMFLETCH - Effective date no longer used, MLS name is always eot value
119: --and p_effective_date between effective_start_date and effective_end_date;
120: begin
121: --
122: hr_utility.set_location('Entering: '||l_proc,10);
123: if p_position_id is not null then
124: open csr_position;
125: fetch csr_position into l_position_name;
126: close csr_position;

Line 130: hr_utility.set_location('Leaving: '||l_proc,20);

126: close csr_position;
127: else
128: l_position_name:=null;
129: end if;
130: hr_utility.set_location('Leaving: '||l_proc,20);
131: return l_position_name;
132: end get_position;
133: --
134: -- ----------------------------------------------------------------------------

Line 154: hr_utility.set_location('Entering: '||l_proc,10);

150: from per_pay_bases ppb
151: where ppb.pay_basis_id=p_pay_basis_id;
152: begin
153: --
154: hr_utility.set_location('Entering: '||l_proc,10);
155: open csr_salary_basis;
156: fetch csr_salary_basis into p_salary_basis,p_pay_basis;
157: close csr_salary_basis;
158: p_pay_basis_meaning:=hr_reports.get_lookup_meaning('PAY_BASIS',p_pay_basis);

Line 159: hr_utility.set_location('Leaving: '||l_proc,20);

155: open csr_salary_basis;
156: fetch csr_salary_basis into p_salary_basis,p_pay_basis;
157: close csr_salary_basis;
158: p_pay_basis_meaning:=hr_reports.get_lookup_meaning('PAY_BASIS',p_pay_basis);
159: hr_utility.set_location('Leaving: '||l_proc,20);
160: end get_salary_basis;
161: --
162: -- ----------------------------------------------------------------------------
163: -- |---------------------------< get_payroll >----------------------------|

Line 180: hr_utility.set_location('Entering: '||l_proc,10);

176: where payroll_id=p_payroll_id
177: and p_effective_date between effective_start_date and effective_end_date;
178: begin
179: --
180: hr_utility.set_location('Entering: '||l_proc,10);
181: open csr_payroll;
182: fetch csr_payroll into l_payroll_name;
183: close csr_payroll;
184: hr_utility.set_location('Leaving: '||l_proc,20);

Line 184: hr_utility.set_location('Leaving: '||l_proc,20);

180: hr_utility.set_location('Entering: '||l_proc,10);
181: open csr_payroll;
182: fetch csr_payroll into l_payroll_name;
183: close csr_payroll;
184: hr_utility.set_location('Leaving: '||l_proc,20);
185: return l_payroll_name;
186: end get_payroll;
187: --
188: -- ----------------------------------------------------------------------------

Line 206: hr_utility.set_location('Entering: '||l_proc,10);

202: where person_id=p_person_id
203: and p_effective_date between effective_start_date and effective_end_date;
204: begin
205: --
206: hr_utility.set_location('Entering: '||l_proc,10);
207: open csr_full_name;
208: fetch csr_full_name into l_full_name;
209: close csr_full_name;
210: hr_utility.set_location('Leaving: '||l_proc,20);

Line 210: hr_utility.set_location('Leaving: '||l_proc,20);

206: hr_utility.set_location('Entering: '||l_proc,10);
207: open csr_full_name;
208: fetch csr_full_name into l_full_name;
209: close csr_full_name;
210: hr_utility.set_location('Leaving: '||l_proc,20);
211: return l_full_name;
212: end get_full_name;
213: --
214: -- ----------------------------------------------------------------------------

Line 233: hr_utility.set_location('Entering: '||l_proc,10);

229: and business_group_id = p_business_group_id;
230:
231: begin
232: --
233: hr_utility.set_location('Entering: '||l_proc,10);
234: open csr_super_assgn_num;
235: fetch csr_super_assgn_num into l_super_assgn_num;
236: close csr_super_assgn_num;
237: hr_utility.set_location('Leaving: '||l_proc,20);

Line 237: hr_utility.set_location('Leaving: '||l_proc,20);

233: hr_utility.set_location('Entering: '||l_proc,10);
234: open csr_super_assgn_num;
235: fetch csr_super_assgn_num into l_super_assgn_num;
236: close csr_super_assgn_num;
237: hr_utility.set_location('Leaving: '||l_proc,20);
238: return l_super_assgn_num;
239: end get_supervisor_assgn_number;
240: --
241: --

Line 258: hr_utility.set_location('Entering: '||l_proc,10);

254: from per_grades_vl
255: where grade_id=p_grade_id;
256: begin
257: --
258: hr_utility.set_location('Entering: '||l_proc,10);
259: open csr_grade;
260: fetch csr_grade into l_grade_name;
261: close csr_grade;
262: hr_utility.set_location('Leaving: '||l_proc,20);

Line 262: hr_utility.set_location('Leaving: '||l_proc,20);

258: hr_utility.set_location('Entering: '||l_proc,10);
259: open csr_grade;
260: fetch csr_grade into l_grade_name;
261: close csr_grade;
262: hr_utility.set_location('Leaving: '||l_proc,20);
263: return l_grade_name;
264: end get_grade;
265: --
266: --

Line 287: hr_utility.set_location('Entering: '||l_proc,10);

283: between effective_start_date and effective_end_date;
284: --
285: begin
286: --
287: hr_utility.set_location('Entering: '||l_proc,10);
288: open csr_grade_ladder;
289: fetch csr_grade_ladder into l_grade_ladder_name;
290: close csr_grade_ladder;
291: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);

Line 291: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);

287: hr_utility.set_location('Entering: '||l_proc,10);
288: open csr_grade_ladder;
289: fetch csr_grade_ladder into l_grade_ladder_name;
290: close csr_grade_ladder;
291: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);
292: hr_utility.set_location('Leaving: '||l_proc,20);
293: return l_grade_ladder_name;
294: end get_grade_ladder;
295: --

Line 292: hr_utility.set_location('Leaving: '||l_proc,20);

288: open csr_grade_ladder;
289: fetch csr_grade_ladder into l_grade_ladder_name;
290: close csr_grade_ladder;
291: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);
292: hr_utility.set_location('Leaving: '||l_proc,20);
293: return l_grade_ladder_name;
294: end get_grade_ladder;
295: --
296: --

Line 340: hr_utility.set_location('Entering: '||l_proc,10);

336: from hr_all_organization_units
337: where organization_id=p_business_group_id;
338: --
339: begin
340: hr_utility.set_location('Entering: '||l_proc,10);
341: --
342: if p_defaulting in ('C','S') then
343: open get_work_day_information;
344: fetch get_work_day_information into

Line 356: hr_utility.set_location(l_proc,20);

352: else
353: close get_work_day_information;
354: end if;
355: --
356: hr_utility.set_location(l_proc,20);
357: open get_gre_information;
358: fetch get_gre_information into p_gre;
359: close get_gre_information;
360: --

Line 361: hr_utility.set_location(l_proc,30);

357: open get_gre_information;
358: fetch get_gre_information into p_gre;
359: close get_gre_information;
360: --
361: hr_utility.set_location(l_proc,30);
362: open get_loc;
363: fetch get_loc into l_location_id;
364: if get_loc%found then
365: close get_loc;

Line 376: hr_utility.set_location('Leaving: '||l_proc,50);

372: end if;
373: --
374: p_frequency_meaning:=hr_reports.get_lookup_meaning('FREQUENCY',p_frequency);
375: p_location:=get_location(l_location_id);
376: hr_utility.set_location('Leaving: '||l_proc,50);
377: end get_bg_defaults;
378: --
379: -- ----------------------------------------------------------------------------
380: -- |--------------------------< get_pos_defaults >----------------------------|

Line 469: hr_utility.set_location('Entering: '||l_proc,10);

465: where vacancy_id=p_vacancy_id
466: and p_effective_date between date_from and nvl(date_to,p_effective_date);
467: --
468: begin
469: hr_utility.set_location('Entering: '||l_proc,10);
470: --
471: if p_vacancy_id is not null then
472: open get_vac;
473: fetch get_vac into l_position_id;

Line 504: hr_utility.set_location(l_pay_basis_id||l_proc,20);

500: ,l_grade_id
501: ,l_bargaining_unit;
502: --
503: close get_pos_defs;
504: hr_utility.set_location(l_pay_basis_id||l_proc,20);
505: p_organization_id:=l_organization_id;
506: p_job_id:=l_job_id;
507: --
508: if p_time_normal_start is null then

Line 616: hr_utility.set_location(p_pay_basis_id||p_salary_basis||l_proc,45);

612: get_salary_basis(p_pay_basis_id
613: ,p_pay_basis
614: ,p_pay_basis_meaning
615: ,p_salary_basis);
616: hr_utility.set_location(p_pay_basis_id||p_salary_basis||l_proc,45);
617:
618: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
619: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
620: p_grade:=get_grade(p_grade_id);

Line 622: hr_utility.set_location('Leaving: '||l_proc,50);

618: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
619: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
620: p_grade:=get_grade(p_grade_id);
621: p_bargaining_unit_meaning:=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',p_bargaining_unit);
622: hr_utility.set_location('Leaving: '||l_proc,50);
623: end get_pos_defaults;
624: --
625: -- ----------------------------------------------------------------------------
626: -- |--------------------------< get_org_defaults >----------------------------|

Line 713: hr_utility.set_location('Entering: '||l_proc,10);

709: and effective_end_date;
710: --
711: --
712: begin
713: hr_utility.set_location('Entering: '||l_proc,10);
714: --
715: open get_vac;
716: fetch get_vac into l_organization_id;
717: close get_vac;

Line 763: hr_utility.set_location(l_proc,20);

759: else
760: close get_work_day_information;
761: end if;
762: --
763: hr_utility.set_location(l_proc,20);
764: open get_loc;
765: fetch get_loc into l_location_id;
766: if get_loc%found then
767: close get_loc;

Line 775: hr_utility.set_location(l_proc,30);

771: else
772: close get_loc;
773: end if;
774: --
775: hr_utility.set_location(l_proc,30);
776: open get_org_information;
777: fetch get_org_information into
778: p_payroll_id
779: ,l_supervisor_id

Line 814: hr_utility.set_location('Leaving: '||l_proc,50);

810: ,p_pay_basis_meaning
811: ,p_salary_basis);
812: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
813: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
814: hr_utility.set_location('Leaving: '||l_proc,50);
815: end get_org_defaults;
816: --
817: -- ----------------------------------------------------------------------------
818: -- |--------------------------< get_vac_defaults >----------------------------|

Line 937: hr_utility.set_location('Entering: '||l_proc,10);

933: and p_effective_date between effective_start_date
934: and effective_end_date;
935: --
936: begin
937: hr_utility.set_location('Entering: '||l_proc,10);
938: --
939: l_old_position_id:=p_position_id;
940: --
941: if p_defaulting in ('C','S') then

Line 1035: hr_utility.set_location(l_proc,20);

1031:
1032: else
1033: close get_vac_details;
1034: end if;
1035: hr_utility.set_location(l_proc,20);
1036: open get_pgp(p_people_group_id);
1037: fetch get_pgp into l_pgp_rec;
1038: if get_pgp%found then
1039: close get_pgp;

Line 1075: hr_utility.set_location(l_proc,30);

1071: close get_pgp;
1072: end if;
1073: end if;
1074: --
1075: hr_utility.set_location(l_proc,30);
1076: if p_defaulting='C'
1077: and l_position_id is not null
1078: and l_position_id <> nvl(l_old_position_id,hr_api.g_number) then
1079: get_pos_defaults

Line 1127: hr_utility.set_location('Leaving: '||l_proc,50);

1123: ,p_pay_basis_meaning
1124: ,p_salary_basis);
1125: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
1126: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
1127: hr_utility.set_location('Leaving: '||l_proc,50);
1128: end get_vac_defaults;
1129:
1130: end per_qh_populate;