178: l_employee_number per_people_f.employee_number%TYPE;
179: l_assignment_number per_assignments_f.assignment_number%TYPE;
180: begin
181:
182: --hr_utility.trace_on(1,'pg');
183:
184: l_heading := '
193: l_employee_number,
194: l_assignment_number;
195: close cur_header2;
196:
197: hr_utility.trace('l_full_name = ' || l_full_name);
198: hr_utility.trace('l_employee_number = ' || l_employee_number);
199: hr_utility.trace('l_assignment_number = ' || l_assignment_number);
200:
201: l_header2 := '
194: l_assignment_number;
195: close cur_header2;
196:
197: hr_utility.trace('l_full_name = ' || l_full_name);
198: hr_utility.trace('l_employee_number = ' || l_employee_number);
199: hr_utility.trace('l_assignment_number = ' || l_assignment_number);
200:
201: l_header2 := '
195: close cur_header2;
196:
197: hr_utility.trace('l_full_name = ' || l_full_name);
198: hr_utility.trace('l_employee_number = ' || l_employee_number);
199: hr_utility.trace('l_assignment_number = ' || l_assignment_number);
200:
201: l_header2 := '