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 240: hr_utility.set_location('Entering: '||l_proc,10);

236: -- and business_group_id = p_business_group_id;
237:
238: begin
239: --
240: hr_utility.set_location('Entering: '||l_proc,10);
241: open csr_super_assgn_num;
242: fetch csr_super_assgn_num into l_super_assgn_num;
243: close csr_super_assgn_num;
244: hr_utility.set_location('Leaving: '||l_proc,20);

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

240: hr_utility.set_location('Entering: '||l_proc,10);
241: open csr_super_assgn_num;
242: fetch csr_super_assgn_num into l_super_assgn_num;
243: close csr_super_assgn_num;
244: hr_utility.set_location('Leaving: '||l_proc,20);
245: return l_super_assgn_num;
246: end get_supervisor_assgn_number;
247: --
248: --

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

261: from per_grades_vl
262: where grade_id=p_grade_id;
263: begin
264: --
265: hr_utility.set_location('Entering: '||l_proc,10);
266: open csr_grade;
267: fetch csr_grade into l_grade_name;
268: close csr_grade;
269: hr_utility.set_location('Leaving: '||l_proc,20);

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

265: hr_utility.set_location('Entering: '||l_proc,10);
266: open csr_grade;
267: fetch csr_grade into l_grade_name;
268: close csr_grade;
269: hr_utility.set_location('Leaving: '||l_proc,20);
270: return l_grade_name;
271: end get_grade;
272: --
273: --

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

290: between effective_start_date and effective_end_date;
291: --
292: begin
293: --
294: hr_utility.set_location('Entering: '||l_proc,10);
295: open csr_grade_ladder;
296: fetch csr_grade_ladder into l_grade_ladder_name;
297: close csr_grade_ladder;
298: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);

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

294: hr_utility.set_location('Entering: '||l_proc,10);
295: open csr_grade_ladder;
296: fetch csr_grade_ladder into l_grade_ladder_name;
297: close csr_grade_ladder;
298: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);
299: hr_utility.set_location('Leaving: '||l_proc,20);
300: return l_grade_ladder_name;
301: end get_grade_ladder;
302: --

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

295: open csr_grade_ladder;
296: fetch csr_grade_ladder into l_grade_ladder_name;
297: close csr_grade_ladder;
298: hr_utility.trace('l_grade_ladder_name : ' || l_grade_ladder_name);
299: hr_utility.set_location('Leaving: '||l_proc,20);
300: return l_grade_ladder_name;
301: end get_grade_ladder;
302: --
303: --

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

343: from hr_all_organization_units
344: where organization_id=p_business_group_id;
345: --
346: begin
347: hr_utility.set_location('Entering: '||l_proc,10);
348: --
349: if p_defaulting in ('C','S') then
350: open get_work_day_information;
351: fetch get_work_day_information into

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

359: else
360: close get_work_day_information;
361: end if;
362: --
363: hr_utility.set_location(l_proc,20);
364: open get_gre_information;
365: fetch get_gre_information into p_gre;
366: close get_gre_information;
367: --

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

364: open get_gre_information;
365: fetch get_gre_information into p_gre;
366: close get_gre_information;
367: --
368: hr_utility.set_location(l_proc,30);
369: open get_loc;
370: fetch get_loc into l_location_id;
371: if get_loc%found then
372: close get_loc;

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

379: end if;
380: --
381: p_frequency_meaning:=hr_reports.get_lookup_meaning('FREQUENCY',p_frequency);
382: p_location:=get_location(l_location_id);
383: hr_utility.set_location('Leaving: '||l_proc,50);
384: end get_bg_defaults;
385: --
386: -- ----------------------------------------------------------------------------
387: -- |--------------------------< get_pos_defaults >----------------------------|

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

472: where vacancy_id=p_vacancy_id
473: and p_effective_date between date_from and nvl(date_to,p_effective_date);
474: --
475: begin
476: hr_utility.set_location('Entering: '||l_proc,10);
477: --
478: if p_vacancy_id is not null then
479: open get_vac;
480: fetch get_vac into l_position_id;

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

507: ,l_grade_id
508: ,l_bargaining_unit;
509: --
510: close get_pos_defs;
511: hr_utility.set_location(l_pay_basis_id||l_proc,20);
512: p_organization_id:=l_organization_id;
513: p_job_id:=l_job_id;
514: --
515: if p_time_normal_start is null then

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

619: get_salary_basis(p_pay_basis_id
620: ,p_pay_basis
621: ,p_pay_basis_meaning
622: ,p_salary_basis);
623: hr_utility.set_location(p_pay_basis_id||p_salary_basis||l_proc,45);
624:
625: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
626: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
627: p_grade:=get_grade(p_grade_id);

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

625: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
626: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
627: p_grade:=get_grade(p_grade_id);
628: p_bargaining_unit_meaning:=hr_reports.get_lookup_meaning('BARGAINING_UNIT_CODE',p_bargaining_unit);
629: hr_utility.set_location('Leaving: '||l_proc,50);
630: end get_pos_defaults;
631: --
632: -- ----------------------------------------------------------------------------
633: -- |--------------------------< get_org_defaults >----------------------------|

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

716: and effective_end_date;
717: --
718: --
719: begin
720: hr_utility.set_location('Entering: '||l_proc,10);
721: --
722: open get_vac;
723: fetch get_vac into l_organization_id;
724: close get_vac;

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

766: else
767: close get_work_day_information;
768: end if;
769: --
770: hr_utility.set_location(l_proc,20);
771: open get_loc;
772: fetch get_loc into l_location_id;
773: if get_loc%found then
774: close get_loc;

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

778: else
779: close get_loc;
780: end if;
781: --
782: hr_utility.set_location(l_proc,30);
783: open get_org_information;
784: fetch get_org_information into
785: p_payroll_id
786: ,l_supervisor_id

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

817: ,p_pay_basis_meaning
818: ,p_salary_basis);
819: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
820: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
821: hr_utility.set_location('Leaving: '||l_proc,50);
822: end get_org_defaults;
823: --
824: -- ----------------------------------------------------------------------------
825: -- |--------------------------< get_vac_defaults >----------------------------|

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

940: and p_effective_date between effective_start_date
941: and effective_end_date;
942: --
943: begin
944: hr_utility.set_location('Entering: '||l_proc,10);
945: --
946: l_old_position_id:=p_position_id;
947: --
948: if p_defaulting in ('C','S') then

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

1038:
1039: else
1040: close get_vac_details;
1041: end if;
1042: hr_utility.set_location(l_proc,20);
1043: open get_pgp(p_people_group_id);
1044: fetch get_pgp into l_pgp_rec;
1045: if get_pgp%found then
1046: close get_pgp;

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

1078: close get_pgp;
1079: end if;
1080: end if;
1081: --
1082: hr_utility.set_location(l_proc,30);
1083: if p_defaulting='C'
1084: and l_position_id is not null
1085: and l_position_id <> nvl(l_old_position_id,hr_api.g_number) then
1086: get_pos_defaults

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

1130: ,p_pay_basis_meaning
1131: ,p_salary_basis);
1132: p_supervisor:=get_full_name(p_supervisor_id,p_effective_date);
1133: p_payroll:=get_payroll(p_payroll_id,p_effective_date);
1134: hr_utility.set_location('Leaving: '||l_proc,50);
1135: end get_vac_defaults;
1136:
1137: end per_qh_populate;