[Home] [Help]
PACKAGE: APPS.PER_QH_FIND_QUERY
Source
1 PACKAGE per_qh_find_query AUTHID CURRENT_USER as
2 /* $Header: peqhfndq.pkh 120.1 2005/12/29 05:34:28 rvarshne noship $ */
3
4 type findrec is RECORD
5 (person_id per_all_people_f.person_id%type
6 ,business_group_name per_business_groups.name%type
7 ,per_effective_start_date per_all_people_f.effective_start_date%type
8 ,per_effective_end_date per_all_people_f.effective_end_date%type
9 ,person_type varchar2(240)
10 ,system_person_type per_person_types.system_person_type%type
11 ,last_name per_all_people_f.last_name%type
12 ,start_date per_all_people_f.start_date%type
13 ,applicant_number per_all_people_f.applicant_number%type
14 ,background_chk_stat_meaning hr_lookups.meaning%type
15 ,background_date_check per_all_people_f.background_date_check%type
16 ,blood_type_meaning hr_lookups.meaning%type
17 ,corr_lang_meaning hr_lookups.meaning%type
18 ,date_employee_data_verified per_all_people_f.date_employee_data_verified%type
19 ,date_of_birth per_all_people_f.date_of_birth%type
20 ,email_address per_all_people_f.email_address%type
21 ,employee_number per_all_people_f.employee_number%type
22 ,expnse_chk_send_addr_meaning hr_lookups.meaning%type
23 ,first_name per_all_people_f.first_name%type
24 ,per_fte_capacity per_all_people_f.fte_capacity%type
25 ,full_name per_all_people_f.full_name%type
26 --CWK
27 ,npw_number per_all_people_f.npw_number%type
28 ,project_title per_all_assignments_f.project_title%type
29 ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type
30 ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type
31 ,vendor_name po_vendors.vendor_name%type
32 ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE
33 ,po_header_num po_headers_all.segment1%TYPE
34 ,po_line_num po_lines_all.line_num%TYPE
35 --
36 ,hold_applicant_date_until per_all_people_f.hold_applicant_date_until%type
37 ,honors per_all_people_f.honors%type
38 ,internal_location per_all_people_f.internal_location%type
39 ,known_as per_all_people_f.known_as%type
40 ,last_medical_test_by per_all_people_f.last_medical_test_by%type
41 ,last_medical_test_date per_all_people_f.last_medical_test_date%type
42 ,mailstop per_all_people_f.mailstop%type
43 ,marital_status_meaning hr_lookups.meaning%type
44 ,middle_names per_all_people_f.middle_names%type
45 ,nationality_meaning hr_lookups.meaning%type
46 ,national_identifier per_all_people_f.national_identifier%type
47 ,office_number per_all_people_f.office_number%type
48 ,on_military_service_meaning hr_lookups.meaning%type
49 ,pre_name_adjunct per_all_people_f.pre_name_adjunct%type
50 ,previous_last_name per_all_people_f.previous_last_name%type
51 ,rehire_recommendation per_all_people_f.rehire_recommendation%type
52 ,resume_exists_meaning hr_lookups.meaning%type
53 ,resume_last_updated per_all_people_f.resume_last_updated%type
54 -- Bug 3037019
55 ,registered_disabled_flag hr_lookups.meaning%type
56 ,secnd_passport_exsts_meaning hr_lookups.meaning%type
57 ,sex_meaning hr_lookups.meaning%type
58 ,student_status_meaning hr_lookups.meaning%type
59 ,suffix per_all_people_f.suffix%type
60 ,title_meaning hr_lookups.meaning%type
61 ,work_schedule_meaning hr_lookups.meaning%type
62 ,coord_ben_med_pln_no per_all_people_f.coord_ben_med_pln_no%type
63 ,cord_ben_no_cvg_flag_meaning hr_lookups.meaning%type
64 ,dpdnt_adoption_date per_all_people_f.dpdnt_adoption_date%type
65 ,dpdnt_vlntry_svc_flg_meaning hr_lookups.meaning%type
66 ,receipt_of_death_cert_date per_all_people_f.receipt_of_death_cert_date%type
67 ,uses_tobacco_meaning hr_lookups.meaning%type
68 ,benefit_group ben_benfts_grp.name%type
69 /* These fields are no longer used because they may change
70 context on a row by row basis, making them meaningless in a table
71
72 ,attribute_category per_all_people_f.attribute_category%type
73 ,attribute1 per_all_people_f.attribute1%type
74 ,attribute1_v varchar2(150)
75 ,attribute1_m varchar2(150)
76 ,attribute2 per_all_people_f.attribute2%type
77 ,attribute2_v varchar2(150)
78 ,attribute2_m varchar2(150)
79 ,attribute3 per_all_people_f.attribute3%type
80 ,attribute3_v varchar2(150)
81 ,attribute3_m varchar2(150)
82 ,attribute4 per_all_people_f.attribute4%type
83 ,attribute4_v varchar2(150)
84 ,attribute4_m varchar2(150)
85 ,attribute5 per_all_people_f.attribute5%type
86 ,attribute5_v varchar2(150)
87 ,attribute5_m varchar2(150)
88 ,attribute6 per_all_people_f.attribute6%type
89 ,attribute6_v varchar2(150)
90 ,attribute6_m varchar2(150)
91 ,attribute7 per_all_people_f.attribute7%type
92 ,attribute7_v varchar2(150)
93 ,attribute7_m varchar2(150)
94 ,attribute8 per_all_people_f.attribute8%type
95 ,attribute8_v varchar2(150)
96 ,attribute8_m varchar2(150)
97 ,attribute9 per_all_people_f.attribute9%type
98 ,attribute9_v varchar2(150)
99 ,attribute9_m varchar2(150)
100 ,attribute10 per_all_people_f.attribute10%type
101 ,attribute10_v varchar2(150)
102 ,attribute10_m varchar2(150)
103 ,attribute11 per_all_people_f.attribute11%type
104 ,attribute11_v varchar2(150)
105 ,attribute11_m varchar2(150)
106 ,attribute12 per_all_people_f.attribute12%type
107 ,attribute12_v varchar2(150)
108 ,attribute12_m varchar2(150)
109 ,attribute13 per_all_people_f.attribute13%type
110 ,attribute13_v varchar2(150)
111 ,attribute13_m varchar2(150)
112 ,attribute14 per_all_people_f.attribute14%type
113 ,attribute14_v varchar2(150)
114 ,attribute14_m varchar2(150)
115 ,attribute15 per_all_people_f.attribute15%type
116 ,attribute15_v varchar2(150)
117 ,attribute15_m varchar2(150)
118 ,attribute16 per_all_people_f.attribute16%type
119 ,attribute16_v varchar2(150)
120 ,attribute16_m varchar2(150)
121 ,attribute17 per_all_people_f.attribute17%type
122 ,attribute17_v varchar2(150)
123 ,attribute17_m varchar2(150)
124 ,attribute18 per_all_people_f.attribute18%type
125 ,attribute18_v varchar2(150)
126 ,attribute18_m varchar2(150)
127 ,attribute19 per_all_people_f.attribute19%type
128 ,attribute19_v varchar2(150)
129 ,attribute19_m varchar2(150)
130 ,attribute20 per_all_people_f.attribute20%type
131 ,attribute20_v varchar2(150)
132 ,attribute20_m varchar2(150)
133 ,attribute21 per_all_people_f.attribute21%type
134 ,attribute21_v varchar2(150)
135 ,attribute21_m varchar2(150)
136 ,attribute22 per_all_people_f.attribute22%type
137 ,attribute22_v varchar2(150)
138 ,attribute22_m varchar2(150)
139 ,attribute23 per_all_people_f.attribute23%type
140 ,attribute23_v varchar2(150)
141 ,attribute23_m varchar2(150)
142 ,attribute24 per_all_people_f.attribute24%type
143 ,attribute24_v varchar2(150)
144 ,attribute24_m varchar2(150)
145 ,attribute25 per_all_people_f.attribute25%type
146 ,attribute25_v varchar2(150)
147 ,attribute25_m varchar2(150)
148 ,attribute26 per_all_people_f.attribute26%type
149 ,attribute26_v varchar2(150)
150 ,attribute26_m varchar2(150)
151 ,attribute27 per_all_people_f.attribute27%type
152 ,attribute27_v varchar2(150)
153 ,attribute27_m varchar2(150)
154 ,attribute28 per_all_people_f.attribute28%type
155 ,attribute28_v varchar2(150)
156 ,attribute28_m varchar2(150)
157 ,attribute29 per_all_people_f.attribute29%type
158 ,attribute29_v varchar2(150)
159 ,attribute29_m varchar2(150)
160 ,attribute30 per_all_people_f.attribute30%type
161 ,attribute30_v varchar2(150)
162 ,attribute30_m varchar2(150)
163 */
164 ,per_information_category per_all_people_f.per_information_category%type
165 ,per_information1 per_all_people_f.attribute1%type
166 ,per_information1_v varchar2(150)
167 ,per_information1_m varchar2(150)
168 ,per_information2 per_all_people_f.attribute2%type
169 ,per_information2_v varchar2(150)
170 ,per_information2_m varchar2(150)
171 ,per_information3 per_all_people_f.attribute3%type
172 ,per_information3_v varchar2(150)
173 ,per_information3_m varchar2(150)
174 ,per_information4 per_all_people_f.attribute4%type
175 ,per_information4_v varchar2(150)
176 ,per_information4_m varchar2(150)
177 ,per_information5 per_all_people_f.attribute5%type
178 ,per_information5_v varchar2(150)
179 ,per_information5_m varchar2(150)
180 ,per_information6 per_all_people_f.attribute6%type
181 ,per_information6_v varchar2(150)
182 ,per_information6_m varchar2(150)
183 ,per_information7 per_all_people_f.attribute7%type
184 ,per_information7_v varchar2(150)
185 ,per_information7_m varchar2(150)
186 ,per_information8 per_all_people_f.attribute8%type
187 ,per_information8_v varchar2(150)
188 ,per_information8_m varchar2(150)
189 ,per_information9 per_all_people_f.attribute9%type
190 ,per_information9_v varchar2(150)
191 ,per_information9_m varchar2(150)
192 ,per_information10 per_all_people_f.attribute10%type
193 ,per_information10_v varchar2(150)
194 ,per_information10_m varchar2(150)
195 ,per_information11 per_all_people_f.attribute11%type
196 ,per_information11_v varchar2(150)
197 ,per_information11_m varchar2(150)
198 ,per_information12 per_all_people_f.attribute12%type
199 ,per_information12_v varchar2(150)
200 ,per_information12_m varchar2(150)
201 ,per_information13 per_all_people_f.attribute13%type
202 ,per_information13_v varchar2(150)
203 ,per_information13_m varchar2(150)
204 ,per_information14 per_all_people_f.attribute14%type
205 ,per_information14_v varchar2(150)
206 ,per_information14_m varchar2(150)
207 ,per_information15 per_all_people_f.attribute15%type
208 ,per_information15_v varchar2(150)
209 ,per_information15_m varchar2(150)
210 ,per_information16 per_all_people_f.attribute16%type
211 ,per_information16_v varchar2(150)
212 ,per_information16_m varchar2(150)
213 ,per_information17 per_all_people_f.attribute17%type
214 ,per_information17_v varchar2(150)
215 ,per_information17_m varchar2(150)
216 ,per_information18 per_all_people_f.attribute18%type
217 ,per_information18_v varchar2(150)
218 ,per_information18_m varchar2(150)
219 ,per_information19 per_all_people_f.attribute19%type
220 ,per_information19_v varchar2(150)
221 ,per_information19_m varchar2(150)
222 ,per_information20 per_all_people_f.attribute20%type
223 ,per_information20_v varchar2(150)
224 ,per_information20_m varchar2(150)
225 ,per_information21 per_all_people_f.attribute21%type
226 ,per_information21_v varchar2(150)
227 ,per_information21_m varchar2(150)
228 ,per_information22 per_all_people_f.attribute22%type
229 ,per_information22_v varchar2(150)
230 ,per_information22_m varchar2(150)
231 ,per_information23 per_all_people_f.attribute23%type
232 ,per_information23_v varchar2(150)
233 ,per_information23_m varchar2(150)
234 ,per_information24 per_all_people_f.attribute24%type
235 ,per_information24_v varchar2(150)
236 ,per_information24_m varchar2(150)
237 ,per_information25 per_all_people_f.attribute25%type
238 ,per_information25_v varchar2(150)
239 ,per_information25_m varchar2(150)
240 ,per_information26 per_all_people_f.attribute26%type
241 ,per_information26_v varchar2(150)
242 ,per_information26_m varchar2(150)
243 ,per_information27 per_all_people_f.attribute27%type
244 ,per_information27_v varchar2(150)
245 ,per_information27_m varchar2(150)
246 ,per_information28 per_all_people_f.attribute28%type
247 ,per_information28_v varchar2(150)
248 ,per_information28_m varchar2(150)
249 ,per_information29 per_all_people_f.attribute29%type
250 ,per_information29_v varchar2(150)
251 ,per_information29_m varchar2(150)
252 ,per_information30 per_all_people_f.attribute30%type
253 ,per_information30_v varchar2(150)
254 ,per_information30_m varchar2(150)
255 ,date_of_death per_all_people_f.date_of_death%type
256 ,hire_date per_periods_of_service.date_start%type
257 ,projected_hire_date per_applications.projected_hire_date%type
258 ,assignment_id per_all_assignments_f.assignment_id%type
259 ,asg_effective_start_date per_all_assignments_f.effective_start_date%type
260 ,asg_effective_end_date per_all_assignments_f.effective_end_date%type
261 ,recruiter per_all_people_f.full_name%type
262 ,grade per_grades.name%type
263 ,grade_ladder ben_pgm_f.name%type
264 ,position hr_all_positions_f.name%type
265 ,job per_jobs.name%type
266 ,assignment_status_type per_assignment_status_types.user_status%type
267 ,system_status per_assignment_status_types.per_system_status%type
268 ,payroll pay_all_payrolls_f.payroll_name%type
269 ,location hr_locations.location_code%type
270 ,person_referred_by per_all_people_f.full_name%type
271 ,supervisor per_all_people_f.full_name%type
272 ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type
273 ,recruitment_activity per_recruitment_activities.name%type
274 ,source_organization hr_all_organization_units.name%type
275 ,organization hr_all_organization_units.name%type
276 ,pgp_segment1 pay_people_groups.segment1%type
277 ,pgp_segment1_v varchar2(150)
278 ,pgp_segment1_m varchar2(150)
279 ,pgp_segment2 pay_people_groups.segment2%type
280 ,pgp_segment2_v varchar2(150)
281 ,pgp_segment2_m varchar2(150)
282 ,pgp_segment3 pay_people_groups.segment3%type
283 ,pgp_segment3_v varchar2(150)
284 ,pgp_segment3_m varchar2(150)
285 ,pgp_segment4 pay_people_groups.segment4%type
286 ,pgp_segment4_v varchar2(150)
287 ,pgp_segment4_m varchar2(150)
288 ,pgp_segment5 pay_people_groups.segment5%type
289 ,pgp_segment5_v varchar2(150)
290 ,pgp_segment5_m varchar2(150)
291 ,pgp_segment6 pay_people_groups.segment6%type
292 ,pgp_segment6_v varchar2(150)
293 ,pgp_segment6_m varchar2(150)
294 ,pgp_segment7 pay_people_groups.segment7%type
295 ,pgp_segment7_v varchar2(150)
296 ,pgp_segment7_m varchar2(150)
297 ,pgp_segment8 pay_people_groups.segment8%type
298 ,pgp_segment8_v varchar2(150)
299 ,pgp_segment8_m varchar2(150)
300 ,pgp_segment9 pay_people_groups.segment9%type
301 ,pgp_segment9_v varchar2(150)
302 ,pgp_segment9_m varchar2(150)
303 ,pgp_segment10 pay_people_groups.segment10%type
304 ,pgp_segment10_v varchar2(150)
305 ,pgp_segment10_m varchar2(150)
306 ,pgp_segment11 pay_people_groups.segment11%type
307 ,pgp_segment11_v varchar2(150)
308 ,pgp_segment11_m varchar2(150)
309 ,pgp_segment12 pay_people_groups.segment12%type
310 ,pgp_segment12_v varchar2(150)
311 ,pgp_segment12_m varchar2(150)
312 ,pgp_segment13 pay_people_groups.segment13%type
313 ,pgp_segment13_v varchar2(150)
314 ,pgp_segment13_m varchar2(150)
315 ,pgp_segment14 pay_people_groups.segment14%type
316 ,pgp_segment14_v varchar2(150)
317 ,pgp_segment14_m varchar2(150)
318 ,pgp_segment15 pay_people_groups.segment15%type
319 ,pgp_segment15_v varchar2(150)
320 ,pgp_segment15_m varchar2(150)
321 ,pgp_segment16 pay_people_groups.segment16%type
322 ,pgp_segment16_v varchar2(150)
323 ,pgp_segment16_m varchar2(150)
324 ,pgp_segment17 pay_people_groups.segment17%type
325 ,pgp_segment17_v varchar2(150)
326 ,pgp_segment17_m varchar2(150)
327 ,pgp_segment18 pay_people_groups.segment18%type
328 ,pgp_segment18_v varchar2(150)
329 ,pgp_segment18_m varchar2(150)
330 ,pgp_segment19 pay_people_groups.segment19%type
331 ,pgp_segment19_v varchar2(150)
332 ,pgp_segment19_m varchar2(150)
333 ,pgp_segment20 pay_people_groups.segment20%type
334 ,pgp_segment20_v varchar2(150)
335 ,pgp_segment20_m varchar2(150)
336 ,pgp_segment21 pay_people_groups.segment21%type
337 ,pgp_segment21_v varchar2(150)
338 ,pgp_segment21_m varchar2(150)
339 ,pgp_segment22 pay_people_groups.segment22%type
340 ,pgp_segment22_v varchar2(150)
341 ,pgp_segment22_m varchar2(150)
342 ,pgp_segment23 pay_people_groups.segment23%type
343 ,pgp_segment23_v varchar2(150)
344 ,pgp_segment23_m varchar2(150)
345 ,pgp_segment24 pay_people_groups.segment24%type
346 ,pgp_segment24_v varchar2(150)
347 ,pgp_segment24_m varchar2(150)
348 ,pgp_segment25 pay_people_groups.segment25%type
349 ,pgp_segment25_v varchar2(150)
350 ,pgp_segment25_m varchar2(150)
351 ,pgp_segment26 pay_people_groups.segment26%type
352 ,pgp_segment26_v varchar2(150)
353 ,pgp_segment26_m varchar2(150)
354 ,pgp_segment27 pay_people_groups.segment27%type
355 ,pgp_segment27_v varchar2(150)
356 ,pgp_segment27_m varchar2(150)
357 ,pgp_segment28 pay_people_groups.segment28%type
358 ,pgp_segment28_v varchar2(150)
359 ,pgp_segment28_m varchar2(150)
360 ,pgp_segment29 pay_people_groups.segment29%type
361 ,pgp_segment29_v varchar2(150)
362 ,pgp_segment29_m varchar2(150)
363 ,pgp_segment30 pay_people_groups.segment30%type
364 ,pgp_segment30_v varchar2(150)
365 ,pgp_segment30_m varchar2(150)
366 ,people_group_id per_all_assignments_f.people_group_id%type
367 ,scl_segment1 hr_soft_coding_keyflex.segment1%type
368 ,scl_segment1_v varchar2(150)
369 ,scl_segment1_m varchar2(150)
370 ,scl_segment2 hr_soft_coding_keyflex.segment2%type
371 ,scl_segment2_v varchar2(150)
372 ,scl_segment2_m varchar2(150)
373 ,scl_segment3 hr_soft_coding_keyflex.segment3%type
374 ,scl_segment3_v varchar2(150)
375 ,scl_segment3_m varchar2(150)
376 ,scl_segment4 hr_soft_coding_keyflex.segment4%type
377 ,scl_segment4_v varchar2(150)
378 ,scl_segment4_m varchar2(150)
379 ,scl_segment5 hr_soft_coding_keyflex.segment5%type
380 ,scl_segment5_v varchar2(150)
381 ,scl_segment5_m varchar2(150)
382 ,scl_segment6 hr_soft_coding_keyflex.segment6%type
383 ,scl_segment6_v varchar2(150)
384 ,scl_segment6_m varchar2(150)
385 ,scl_segment7 hr_soft_coding_keyflex.segment7%type
386 ,scl_segment7_v varchar2(150)
387 ,scl_segment7_m varchar2(150)
388 ,scl_segment8 hr_soft_coding_keyflex.segment8%type
389 ,scl_segment8_v varchar2(150)
390 ,scl_segment8_m varchar2(150)
391 ,scl_segment9 hr_soft_coding_keyflex.segment9%type
392 ,scl_segment9_v varchar2(150)
393 ,scl_segment9_m varchar2(150)
394 ,scl_segment10 hr_soft_coding_keyflex.segment10%type
395 ,scl_segment10_v varchar2(150)
396 ,scl_segment10_m varchar2(150)
397 ,scl_segment11 hr_soft_coding_keyflex.segment11%type
398 ,scl_segment11_v varchar2(150)
399 ,scl_segment11_m varchar2(150)
400 ,scl_segment12 hr_soft_coding_keyflex.segment12%type
401 ,scl_segment12_v varchar2(150)
402 ,scl_segment12_m varchar2(150)
403 ,scl_segment13 hr_soft_coding_keyflex.segment13%type
404 ,scl_segment13_v varchar2(150)
405 ,scl_segment13_m varchar2(150)
406 ,scl_segment14 hr_soft_coding_keyflex.segment14%type
407 ,scl_segment14_v varchar2(150)
408 ,scl_segment14_m varchar2(150)
409 ,scl_segment15 hr_soft_coding_keyflex.segment15%type
410 ,scl_segment15_v varchar2(150)
411 ,scl_segment15_m varchar2(150)
412 ,scl_segment16 hr_soft_coding_keyflex.segment16%type
413 ,scl_segment16_v varchar2(150)
414 ,scl_segment16_m varchar2(150)
415 ,scl_segment17 hr_soft_coding_keyflex.segment17%type
416 ,scl_segment17_v varchar2(150)
417 ,scl_segment17_m varchar2(150)
418 ,scl_segment18 hr_soft_coding_keyflex.segment18%type
419 ,scl_segment18_v varchar2(150)
420 ,scl_segment18_m varchar2(150)
421 ,scl_segment19 hr_soft_coding_keyflex.segment19%type
422 ,scl_segment19_v varchar2(150)
423 ,scl_segment19_m varchar2(150)
424 ,scl_segment20 hr_soft_coding_keyflex.segment20%type
425 ,scl_segment20_v varchar2(150)
426 ,scl_segment20_m varchar2(150)
427 ,scl_segment21 hr_soft_coding_keyflex.segment21%type
428 ,scl_segment21_v varchar2(150)
429 ,scl_segment21_m varchar2(150)
430 ,scl_segment22 hr_soft_coding_keyflex.segment22%type
431 ,scl_segment22_v varchar2(150)
432 ,scl_segment22_m varchar2(150)
433 ,scl_segment23 hr_soft_coding_keyflex.segment23%type
434 ,scl_segment23_v varchar2(150)
435 ,scl_segment23_m varchar2(150)
436 ,scl_segment24 hr_soft_coding_keyflex.segment24%type
437 ,scl_segment24_v varchar2(150)
438 ,scl_segment24_m varchar2(150)
439 ,scl_segment25 hr_soft_coding_keyflex.segment25%type
440 ,scl_segment25_v varchar2(150)
441 ,scl_segment25_m varchar2(150)
442 ,scl_segment26 hr_soft_coding_keyflex.segment26%type
443 ,scl_segment26_v varchar2(150)
444 ,scl_segment26_m varchar2(150)
445 ,scl_segment27 hr_soft_coding_keyflex.segment27%type
446 ,scl_segment27_v varchar2(150)
447 ,scl_segment27_m varchar2(150)
448 ,scl_segment28 hr_soft_coding_keyflex.segment28%type
449 ,scl_segment28_v varchar2(150)
450 ,scl_segment28_m varchar2(150)
451 ,scl_segment29 hr_soft_coding_keyflex.segment29%type
452 ,scl_segment29_v varchar2(150)
453 ,scl_segment29_m varchar2(150)
454 ,scl_segment30 hr_soft_coding_keyflex.segment30%type
455 ,scl_segment30_v varchar2(150)
456 ,scl_segment30_m varchar2(150)
457 ,soft_coding_keyflex_id per_all_assignments_f.soft_coding_keyflex_id%type
458 ,vacancy per_vacancies.name%type
459 ,requisition per_requisitions.name%type default null
460 ,salary_basis per_pay_bases.name%type
461 ,pay_basis per_pay_bases.pay_basis%type
462 ,assignment_sequence per_all_assignments_f.assignment_sequence%type
463 ,assignment_type per_all_assignments_f.assignment_type%type
464 ,asg_primary_flag per_all_assignments_f.primary_flag%type
465 ,assignment_number per_all_assignments_f.assignment_number%type
466 ,date_probation_end per_all_assignments_f.date_probation_end%type
467 ,default_code_comb_id per_all_assignments_f.default_code_comb_id%type
468 ,employment_category_meaning hr_lookups.meaning%type
469 ,frequency_meaning hr_lookups.meaning%type
470 ,normal_hours per_all_assignments_f.normal_hours%type
471 ,probation_period per_all_assignments_f.probation_period%type
472 ,probation_unit_meaning hr_lookups.meaning%type
473 ,time_normal_finish per_all_assignments_f.time_normal_finish%type
474 ,time_normal_start per_all_assignments_f.time_normal_start%type
475 /* These fields are no longer used because they may change
476 context on a row by row basis, making them meaningless in a table
477
478 ,ass_attribute_category per_all_assignments_f.ass_attribute_category%type
479 ,ass_attribute1 per_all_assignments_f.ass_attribute1%type
480 ,ass_attribute1_v varchar2(150)
481 ,ass_attribute1_m varchar2(150)
482 ,ass_attribute2 per_all_assignments_f.ass_attribute2%type
483 ,ass_attribute2_v varchar2(150)
484 ,ass_attribute2_m varchar2(150)
485 ,ass_attribute3 per_all_assignments_f.ass_attribute3%type
486 ,ass_attribute3_v varchar2(150)
487 ,ass_attribute3_m varchar2(150)
488 ,ass_attribute4 per_all_assignments_f.ass_attribute4%type
489 ,ass_attribute4_v varchar2(150)
490 ,ass_attribute4_m varchar2(150)
491 ,ass_attribute5 per_all_assignments_f.ass_attribute5%type
492 ,ass_attribute5_v varchar2(150)
493 ,ass_attribute5_m varchar2(150)
494 ,ass_attribute6 per_all_assignments_f.ass_attribute6%type
495 ,ass_attribute6_v varchar2(150)
496 ,ass_attribute6_m varchar2(150)
497 ,ass_attribute7 per_all_assignments_f.ass_attribute7%type
498 ,ass_attribute7_v varchar2(150)
499 ,ass_attribute7_m varchar2(150)
500 ,ass_attribute8 per_all_assignments_f.ass_attribute8%type
501 ,ass_attribute8_v varchar2(150)
502 ,ass_attribute8_m varchar2(150)
503 ,ass_attribute9 per_all_assignments_f.ass_attribute9%type
504 ,ass_attribute9_v varchar2(150)
505 ,ass_attribute9_m varchar2(150)
506 ,ass_attribute10 per_all_assignments_f.ass_attribute10%type
507 ,ass_attribute10_v varchar2(150)
508 ,ass_attribute10_m varchar2(150)
509 ,ass_attribute11 per_all_assignments_f.ass_attribute11%type
510 ,ass_attribute11_v varchar2(150)
511 ,ass_attribute11_m varchar2(150)
512 ,ass_attribute12 per_all_assignments_f.ass_attribute12%type
513 ,ass_attribute12_v varchar2(150)
514 ,ass_attribute12_m varchar2(150)
515 ,ass_attribute13 per_all_assignments_f.ass_attribute13%type
516 ,ass_attribute13_v varchar2(150)
517 ,ass_attribute13_m varchar2(150)
518 ,ass_attribute14 per_all_assignments_f.ass_attribute14%type
519 ,ass_attribute14_v varchar2(150)
520 ,ass_attribute14_m varchar2(150)
521 ,ass_attribute15 per_all_assignments_f.ass_attribute15%type
522 ,ass_attribute15_v varchar2(150)
523 ,ass_attribute15_m varchar2(150)
524 ,ass_attribute16 per_all_assignments_f.ass_attribute16%type
525 ,ass_attribute16_v varchar2(150)
526 ,ass_attribute16_m varchar2(150)
527 ,ass_attribute17 per_all_assignments_f.ass_attribute17%type
528 ,ass_attribute17_v varchar2(150)
529 ,ass_attribute17_m varchar2(150)
530 ,ass_attribute18 per_all_assignments_f.ass_attribute18%type
531 ,ass_attribute18_v varchar2(150)
532 ,ass_attribute18_m varchar2(150)
533 ,ass_attribute19 per_all_assignments_f.ass_attribute19%type
534 ,ass_attribute19_v varchar2(150)
535 ,ass_attribute19_m varchar2(150)
536 ,ass_attribute20 per_all_assignments_f.ass_attribute20%type
537 ,ass_attribute20_v varchar2(150)
538 ,ass_attribute20_m varchar2(150)
539 ,ass_attribute21 per_all_assignments_f.ass_attribute21%type
540 ,ass_attribute21_v varchar2(150)
541 ,ass_attribute21_m varchar2(150)
542 ,ass_attribute22 per_all_assignments_f.ass_attribute22%type
543 ,ass_attribute22_v varchar2(150)
544 ,ass_attribute22_m varchar2(150)
545 ,ass_attribute23 per_all_assignments_f.ass_attribute23%type
546 ,ass_attribute23_v varchar2(150)
547 ,ass_attribute23_m varchar2(150)
548 ,ass_attribute24 per_all_assignments_f.ass_attribute24%type
549 ,ass_attribute24_v varchar2(150)
550 ,ass_attribute24_m varchar2(150)
551 ,ass_attribute25 per_all_assignments_f.ass_attribute25%type
552 ,ass_attribute25_v varchar2(150)
553 ,ass_attribute25_m varchar2(150)
554 ,ass_attribute26 per_all_assignments_f.ass_attribute26%type
555 ,ass_attribute26_v varchar2(150)
556 ,ass_attribute26_m varchar2(150)
557 ,ass_attribute27 per_all_assignments_f.ass_attribute27%type
558 ,ass_attribute27_v varchar2(150)
559 ,ass_attribute27_m varchar2(150)
560 ,ass_attribute28 per_all_assignments_f.ass_attribute28%type
561 ,ass_attribute28_v varchar2(150)
562 ,ass_attribute28_m varchar2(150)
563 ,ass_attribute29 per_all_assignments_f.ass_attribute29%type
564 ,ass_attribute29_v varchar2(150)
565 ,ass_attribute29_m varchar2(150)
566 ,ass_attribute30 per_all_assignments_f.ass_attribute30%type
567 ,ass_attribute30_v varchar2(150)
568 ,ass_attribute30_m varchar2(150)
569 */
570 ,bargaining_unit_code_meaning hr_lookups.meaning%type
571 ,labour_union_member_flag per_all_assignments_f.labour_union_member_flag%type
572 ,hourly_salaried_meaning hr_lookups.meaning%type
573 ,special_ceiling_step number
574 ,special_ceiling_point per_spinal_points.spinal_point%type
575 ,change_reason_meaning hr_lookups.meaning%type
576 ,internal_address_line per_all_assignments_f.internal_address_line%type
577 ,manager_flag per_all_assignments_f.manager_flag%type
578 ,perf_review_period per_all_assignments_f.perf_review_period%type
579 ,perf_rev_period_freq_meaning hr_lookups.meaning%type
580 ,sal_review_period per_all_assignments_f.sal_review_period%type
581 ,sal_rev_period_freq_meaning hr_lookups.meaning%type
582 ,source_type_meaning hr_lookups.meaning%type
583 ,contract per_contracts_f.reference%type
584 ,collective_agreement per_collective_agreements.name%type
585 ,cagr_id_flex_name fnd_id_flex_structures_v.id_flex_structure_name%type
586 ,cagr_grade varchar2(1)
587 ,establishment hr_leg_establishments_v.name%type);
588
589 type findtab is table of findrec
590 index by binary_integer;
591
592 procedure findquery(resultset IN OUT NOCOPY findtab
593 ,p_effective_date date
594 ,business_group_id per_all_people_f.business_group_id%type
595 ,business_group_name per_business_groups.name%type default null
596 ,person_id per_all_people_f.person_id%type default null
597 ,person_type per_person_types.user_person_type%type default null
598 ,system_person_type per_person_types.system_person_type%type default null
599 ,person_type_id per_all_people_f.person_type_id%type default null
600 ,last_name per_all_people_f.last_name%type default null
601 ,start_date per_all_people_f.start_date%type default null
602 ,hire_date per_periods_of_service.date_start%type default null
603 ,applicant_number per_all_people_f.applicant_number%type default null
604 ,date_of_birth per_all_people_f.date_of_birth%type default null
605 ,email_address per_all_people_f.email_address%type default null
606 ,employee_number per_all_people_f.employee_number%type default null
607 --CWK
608 ,npw_number per_all_people_f.npw_number%type default null
609 ,project_title per_all_assignments_f.project_title%type default null
610 ,vendor_id per_all_assignments_f.vendor_id%type default null
611 ,vendor_name po_vendors.vendor_name%type default null
612 ,vendor_employee_number per_all_assignments_f.vendor_employee_number%type default null
613 ,vendor_assignment_number per_all_assignments_f.vendor_assignment_number%type default null
614 ,vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE default null
615 ,vendor_site_id po_vendor_sites_all.vendor_site_id%TYPE default null
616 ,po_header_num po_headers_all.segment1%TYPE default null
617 ,po_header_id po_headers_all.po_header_id%TYPE default null
618 ,po_line_num po_lines_all.line_num%TYPE default null
619 ,po_line_id po_lines_all.po_line_id%TYPE default null
620 --
621 ,first_name per_all_people_f.first_name%type default null
622 ,full_name per_all_people_f.full_name%type default null
623 ,title per_all_people_f.title%type
624 ,middle_names per_all_people_f.middle_names%type
625 ,nationality_meaning hr_lookups.meaning%type default null
626 ,nationality per_all_people_f.nationality%type default null
627 ,national_identifier per_all_people_f.national_identifier%type default null
628 -- Bug 3037019
629 ,registered_disabled_flag hr_lookups.meaning%type default null
630 ,registered_disabled per_all_people_f.registered_disabled_flag%type default null
631 ,sex_meaning hr_lookups.meaning%type default null
632 ,sex per_all_people_f.sex%type default null
633 ,benefit_group ben_benfts_grp.name%type default null
634 ,benefit_group_id per_all_people_f.benefit_group_id%type default null
635 ,grade per_grades.name%type default null
636 ,grade_id per_all_assignments_f.grade_id%type default null
637 ,grade_ladder ben_pgm_f.name%type default null
638 ,grade_ladder_pgm_id per_all_assignments_f.grade_ladder_pgm_id%type default null
639 ,position hr_all_positions_f.name%type default null
640 ,position_id per_all_assignments_f.position_id%type default null
641 ,job per_jobs.name%type default null
642 ,job_id per_all_assignments_f.job_id%type default null
643 ,assignment_status_type per_assignment_status_types.user_status%type default null
644 ,assignment_status_type_id per_all_assignments_f.assignment_status_type_id%type default null
645 ,payroll pay_all_payrolls_f.payroll_name%type default null
646 ,payroll_id per_all_assignments_f.payroll_id%type default null
647 ,location hr_locations.location_code%type default null
648 ,location_id per_all_assignments_f.location_id%type default null
649 ,supervisor per_all_people_f.full_name%type default null
650 ,supervisor_id per_all_assignments_f.supervisor_id%type default null
651 ,supervisor_assignment_number per_assignments_v.supervisor_assignment_number%type default null
652 ,supervisor_assignment_id per_all_assignments_f.supervisor_assignment_id%type default null
653 ,recruitment_activity per_recruitment_activities.name%type default null
654 ,recruitment_activity_id per_all_assignments_f.recruitment_activity_id%type default null
655 ,organization hr_all_organization_units.name%type default null
656 ,organization_id per_all_assignments_f.organization_id%type default null
657 ,people_group pay_people_groups.group_name%type default null
658 ,people_group_id per_all_assignments_f.people_group_id%type default null
659 ,vacancy per_vacancies.name%type default null
660 ,vacancy_id per_all_assignments_f.vacancy_id%type default null
661 ,requisition per_requisitions.name%type default null
662 ,requisition_id per_requisitions.requisition_id%type default null
663 ,salary_basis per_pay_bases.name%type default null
664 ,pay_basis_id per_all_assignments_f.pay_basis_id%type default null
665 ,bargaining_unit_code_meaning hr_lookups.meaning%type default null
666 ,bargaining_unit_code per_all_assignments_f.bargaining_unit_code%type default null
667 ,employment_category_meaning hr_lookups.meaning%type default null
668 ,employment_category per_all_assignments_f.employment_category%type default null
669 ,establishment hr_leg_establishments_v.name%type default null
670 ,establishment_id hr_leg_establishments_v.organization_id%type default null
671 ,projected_hire_date per_applications.projected_hire_date%type default null
672 ,secure varchar2 default null
673 ,field1_name varchar2 default null
674 ,field1_condition_code varchar2 default null
675 ,field1_value varchar2 default null
676 ,field2_name varchar2 default null
677 ,field2_condition_code varchar2 default null
678 ,field2_value varchar2 default null
679 ,field3_name varchar2 default null
680 ,field3_condition_code varchar2 default null
681 ,field3_value varchar2 default null
682 ,field4_name varchar2 default null
683 ,field4_condition_code varchar2 default null
684 ,field4_value varchar2 default null
685 ,field5_name varchar2 default null
686 ,field5_condition_code varchar2 default null
687 ,field5_value varchar2 default null
688 ,p_fetch_details boolean default true
689 ,p_customized_restriction_id number default null
690 ,p_employees_allowed boolean default false
691 ,p_applicants_allowed boolean default false
692 ,p_cwk_allowed boolean default false
693 ,select_stmt out nocopy varchar2);
694
695
696 procedure findsave(
697 query_id in number
698 ,business_group_id in per_all_people_f.business_group_id%type
699 ,business_group_name in per_business_groups.name%type
700 ,person_id in per_all_people_f.person_id%type default null
701 ,person_type in per_person_types.user_person_type%type default null
702 ,system_person_type in per_person_types.system_person_type%type default null
703 ,person_type_id in per_all_people_f.person_type_id%type default null
704 ,last_name in per_all_people_f.last_name%type default null
705 ,start_date in per_all_people_f.start_date%type default null
706 ,hire_date in per_periods_of_service.date_start%type default null
707 ,applicant_number in per_all_people_f.applicant_number%type default null
708 ,date_of_birth in per_all_people_f.date_of_birth%type default null
709 ,email_address in per_all_people_f.email_address%type default null
710 ,employee_number in per_all_people_f.employee_number%type default null
711 --CWK
712 ,npw_number in per_all_people_f.npw_number%type default null
713 ,project_title in per_all_assignments_f.project_title%type default null
714 ,vendor_id in per_all_assignments_f.vendor_id%type default null
715 ,vendor_name in po_vendors.vendor_name%type default null
716 ,vendor_employee_number in per_all_assignments_f.vendor_employee_number%type default null
717 ,vendor_assignment_number in per_all_assignments_f.vendor_assignment_number%type default null
718 ,vendor_site_code in po_vendor_sites_all.vendor_site_code%TYPE default null
719 ,vendor_site_id in po_vendor_sites_all.vendor_site_id%TYPE default null
720 ,po_header_num in po_headers_all.segment1%TYPE default null
721 ,po_header_id in po_headers_all.po_header_id%TYPE default null
722 ,po_line_num in po_lines_all.line_num%TYPE default null
723 ,po_line_id in po_lines_all.po_line_id%TYPE default null
724 --
725 ,first_name in per_all_people_f.first_name%type default null
726 ,full_name in per_all_people_f.full_name%type default null
727 ,title per_all_people_f.title%type
728 ,middle_names per_all_people_f.middle_names%type
729 ,nationality_meaning in hr_lookups.meaning%type default null
730 ,nationality in per_all_people_f.nationality%type default null
731 ,national_identifier in per_all_people_f.national_identifier%type default null
732 -- Bug 3037019
733 ,registered_disabled_flag in hr_lookups.meaning%type default null
734 ,registered_disabled in per_all_people_f.registered_disabled_flag%type default null
735 ,sex_meaning in hr_lookups.meaning%type default null
736 ,sex in per_all_people_f.sex%type default null
737 ,benefit_group in ben_benfts_grp.name%type default null
738 ,benefit_group_id in per_all_people_f.benefit_group_id%type default null
739 ,grade in per_grades.name%type default null
740 ,grade_id in per_all_assignments_f.grade_id%type default null
741 ,grade_ladder in ben_pgm_f.name%type default null
742 ,grade_ladder_pgm_id in per_all_assignments_f.grade_ladder_pgm_id%type default null
743 ,position in hr_all_positions_f.name%type default null
744 ,position_id in per_all_assignments_f.position_id%type default null
745 ,job in per_jobs.name%type default null
746 ,job_id in per_all_assignments_f.job_id%type default null
747 ,assignment_status_type in per_assignment_status_types.user_status%type default null
748 ,assignment_status_type_id in per_all_assignments_f.assignment_status_type_id%type default null
749 ,payroll in pay_all_payrolls_f.payroll_name%type default null
750 ,payroll_id in per_all_assignments_f.payroll_id%type default null
751 ,location in hr_locations.location_code%type default null
752 ,location_id in per_all_assignments_f.location_id%type default null
753 ,supervisor in per_all_people_f.full_name%type default null
754 ,supervisor_id in per_all_assignments_f.supervisor_id%type default null
755 ,supervisor_assignment_number in per_assignments_v.supervisor_assignment_number%type default null
756 ,supervisor_assignment_id in per_all_assignments_f.supervisor_assignment_id%type default null
757 ,recruitment_activity in per_recruitment_activities.name%type default null
758 ,recruitment_activity_id in per_all_assignments_f.recruitment_activity_id%type default null
759 ,organization in hr_all_organization_units.name%type default null
760 ,organization_id in per_all_assignments_f.organization_id%type default null
761 ,people_group in pay_people_groups.group_name%type default null
762 ,people_group_id in per_all_assignments_f.people_group_id%type default null
763 ,vacancy in per_vacancies.name%type default null
764 ,vacancy_id in per_all_assignments_f.vacancy_id%type default null
765 ,requisition in per_requisitions.name%type default null
766 ,requisition_id in per_requisitions.requisition_id%type default null
767 ,salary_basis in per_pay_bases.name%type default null
768 ,pay_basis_id in per_all_assignments_f.pay_basis_id%type default null
769 ,bargaining_unit_code_meaning in hr_lookups.meaning%type default null
770 ,bargaining_unit_code in per_all_assignments_f.bargaining_unit_code%type default null
771 ,employment_category_meaning in hr_lookups.meaning%type default null
772 ,employment_category in per_all_assignments_f.employment_category%type default null
773 ,establishment in hr_leg_establishments_v.name%type default null
774 ,establishment_id in hr_leg_establishments_v.organization_id%type default null
775 ,projected_hire_date in per_applications.projected_hire_date%type default null
776 ,secure in varchar2 default null
777 ,field1_name in varchar2 default null
778 ,field1_condition_code in varchar2 default null
779 ,field1_value in varchar2 default null
780 ,field2_name in varchar2 default null
781 ,field2_condition_code in varchar2 default null
782 ,field2_value in varchar2 default null
783 ,field3_name in varchar2 default null
784 ,field3_condition_code in varchar2 default null
785 ,field3_value in varchar2 default null
786 ,field4_name in varchar2 default null
787 ,field4_condition_code in varchar2 default null
788 ,field4_value in varchar2 default null
789 ,field5_name in varchar2 default null
790 ,field5_condition_code in varchar2 default null
791 ,field5_value in varchar2 default null
792 );
793
794 procedure findretrieve
795 (p_query_id in number
796 ,p_effective_date in date
797 ,p_customized_restriction_id in number default null
798 ,p_employees_allowed in boolean default false
799 ,p_applicants_allowed in boolean default false
800 ,p_cwk_allowed in boolean default false
801 ,p_people_tab out nocopy findtab
802 );
803
804 end per_qh_find_query;