[Home] [Help]
PACKAGE BODY: APPS.PQH_PTX_SHD
Source
1 Package Body pqh_ptx_shd as
2 /* $Header: pqptxrhi.pkb 120.1 2008/01/31 09:40:13 brsinha noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- | Private Global Definitions |
6 -- ----------------------------------------------------------------------------
7 --
8 g_package varchar2(33) := ' pqh_ptx_shd.'; -- Global package name
9 --
10 --
11 -- ----------------------------------------------------------------------------
12 -- |---------------------------< constraint_error >---------------------------|
13 -- ----------------------------------------------------------------------------
14 Procedure constraint_error
15 (p_constraint_name in all_constraints.constraint_name%TYPE) Is
16 --
17 l_proc varchar2(72) := g_package||'constraint_error';
18 --
19 Begin
20 hr_utility.set_location('Entering:'||l_proc, 5);
21 --
22 If (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK11') Then
23 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
24 hr_utility.set_message_token('PROCEDURE', l_proc);
25 hr_utility.set_message_token('STEP','5');
26 hr_utility.raise_error;
27 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK12') Then
28 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
29 hr_utility.set_message_token('PROCEDURE', l_proc);
30 hr_utility.set_message_token('STEP','10');
31 hr_utility.raise_error;
32 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK4') Then
33 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
34 hr_utility.set_message_token('PROCEDURE', l_proc);
35 hr_utility.set_message_token('STEP','15');
36 hr_utility.raise_error;
37 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK5') Then
38 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
39 hr_utility.set_message_token('PROCEDURE', l_proc);
40 hr_utility.set_message_token('STEP','20');
41 hr_utility.raise_error;
42 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK6') Then
43 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
44 hr_utility.set_message_token('PROCEDURE', l_proc);
45 hr_utility.set_message_token('STEP','25');
46 hr_utility.raise_error;
47 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK8') Then
48 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
49 hr_utility.set_message_token('PROCEDURE', l_proc);
50 hr_utility.set_message_token('STEP','30');
51 hr_utility.raise_error;
52 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_FK9') Then
53 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
54 hr_utility.set_message_token('PROCEDURE', l_proc);
55 hr_utility.set_message_token('STEP','35');
56 hr_utility.raise_error;
57 ElsIf (p_constraint_name = 'PQH_POSITION_TRANSACTIONS_PK') Then
58 hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
59 hr_utility.set_message_token('PROCEDURE', l_proc);
60 hr_utility.set_message_token('STEP','40');
61 hr_utility.raise_error;
62 Else
63 hr_utility.set_message(801, 'HR_7877_API_INVALID_CONSTRAINT');
64 hr_utility.set_message_token('PROCEDURE', l_proc);
65 hr_utility.set_message_token('CONSTRAINT_NAME', p_constraint_name);
66 hr_utility.raise_error;
67 End If;
68 --
69 hr_utility.set_location(' Leaving:'||l_proc, 10);
70 End constraint_error;
71 --
72 -- ----------------------------------------------------------------------------
73 -- |-----------------------------< api_updating >-----------------------------|
74 -- ----------------------------------------------------------------------------
75 Function api_updating
76 (
77 p_position_transaction_id in number,
78 p_object_version_number in number
79 ) Return Boolean Is
80 --
81 --
82 -- Cursor selects the 'current' row from the HR Schema
83 --
84 Cursor C_Sel1 is
85 select
86 position_transaction_id,
87 action_date,
88 position_id,
89 availability_status_id,
90 business_group_id,
91 entry_step_id,
92 entry_grade_rule_id,
93 job_id,
94 location_id,
95 organization_id,
96 pay_freq_payroll_id,
97 position_definition_id,
98 prior_position_id,
99 relief_position_id,
100 entry_grade_id,
101 successor_position_id,
102 supervisor_position_id,
103 amendment_date,
104 amendment_recommendation,
105 amendment_ref_number,
106 avail_status_prop_end_date,
107 bargaining_unit_cd,
108 comments,
109 country1,
110 country2,
111 country3,
112 current_job_prop_end_date,
113 current_org_prop_end_date,
114 date_effective,
115 date_end,
116 earliest_hire_date,
117 fill_by_date,
118 frequency,
119 fte,
120 fte_capacity,
121 location1,
122 location2,
123 location3,
124 max_persons,
125 name,
126 other_requirements,
127 overlap_period,
128 overlap_unit_cd,
129 passport_required,
130 pay_term_end_day_cd,
131 pay_term_end_month_cd,
132 permanent_temporary_flag,
133 permit_recruitment_flag,
134 position_type,
135 posting_description,
136 probation_period,
137 probation_period_unit_cd,
138 relocate_domestically,
139 relocate_internationally,
140 replacement_required_flag,
141 review_flag,
142 seasonal_flag,
143 security_requirements,
144 service_minimum,
145 term_start_day_cd,
146 term_start_month_cd,
147 time_normal_finish,
148 time_normal_start,
149 transaction_status,
150 travel_required,
151 working_hours,
152 works_council_approval_flag,
153 work_any_country,
154 work_any_location,
155 work_period_type_cd,
156 work_schedule,
157 work_duration,
158 work_term_end_day_cd,
159 work_term_end_month_cd,
160 proposed_fte_for_layoff,
161 proposed_date_for_layoff,
162 information1,
163 information2,
164 information3,
165 information4,
166 information5,
167 information6,
168 information7,
169 information8,
170 information9,
171 information10,
172 information11,
173 information12,
174 information13,
175 information14,
176 information15,
177 information16,
178 information17,
179 information18,
180 information19,
181 information20,
182 information21,
183 information22,
184 information23,
185 information24,
186 information25,
187 information26,
188 information27,
189 information28,
190 information29,
191 information30,
192 information_category,
193 attribute1,
194 attribute2,
195 attribute3,
196 attribute4,
197 attribute5,
198 attribute6,
199 attribute7,
200 attribute8,
201 attribute9,
202 attribute10,
203 attribute11,
204 attribute12,
205 attribute13,
206 attribute14,
207 attribute15,
208 attribute16,
209 attribute17,
210 attribute18,
211 attribute19,
212 attribute20,
213 attribute21,
214 attribute22,
215 attribute23,
216 attribute24,
217 attribute25,
218 attribute26,
219 attribute27,
220 attribute28,
221 attribute29,
222 attribute30,
223 attribute_category,
224 object_version_number,
225 pay_basis_id,
226 supervisor_id,
227 wf_transaction_category_id
228 from pqh_position_transactions
229 where position_transaction_id = p_position_transaction_id;
230 --
231 l_proc varchar2(72) := g_package||'api_updating';
232 l_fct_ret boolean;
233 --
234 Begin
235 hr_utility.set_location('Entering:'||l_proc, 5);
236 --
237 If (
238 p_position_transaction_id is null and
239 p_object_version_number is null
240 ) Then
241 --
242 -- One of the primary key arguments is null therefore we must
243 -- set the returning function value to false
244 --
245 l_fct_ret := false;
246 Else
247 If (
248 p_position_transaction_id = g_old_rec.position_transaction_id and
249 p_object_version_number = g_old_rec.object_version_number
250 ) Then
251 hr_utility.set_location(l_proc, 10);
252 --
253 -- The g_old_rec is current therefore we must
254 -- set the returning function to true
255 --
256 l_fct_ret := true;
257 Else
258 --
259 -- Select the current row into g_old_rec
260 --
261 Open C_Sel1;
262 Fetch C_Sel1 Into g_old_rec;
263 If C_Sel1%notfound Then
264 Close C_Sel1;
265 --
266 -- The primary key is invalid therefore we must error
267 --
268 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
269 hr_utility.raise_error;
270 End If;
271 Close C_Sel1;
272 If (p_object_version_number <> g_old_rec.object_version_number) Then
273 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
274 hr_utility.raise_error;
275 End If;
276 hr_utility.set_location(l_proc, 15);
277 l_fct_ret := true;
278 End If;
279 End If;
280 hr_utility.set_location(' Leaving:'||l_proc, 20);
281 Return (l_fct_ret);
282 --
283 End api_updating;
284 --
285 -- ----------------------------------------------------------------------------
286 -- |---------------------------------< lck >----------------------------------|
287 -- ----------------------------------------------------------------------------
288 Procedure lck
289 (
290 p_position_transaction_id in number,
291 p_object_version_number in number
292 ) is
293 --
294 -- Cursor selects the 'current' row from the HR Schema
295 --
296 Cursor C_Sel1 is
297 select position_transaction_id,
298 action_date,
299 position_id,
300 availability_status_id,
301 business_group_id,
302 entry_step_id,
303 entry_grade_rule_id,
304 job_id,
305 location_id,
306 organization_id,
307 pay_freq_payroll_id,
308 position_definition_id,
309 prior_position_id,
310 relief_position_id,
311 entry_grade_id,
312 successor_position_id,
313 supervisor_position_id,
314 amendment_date,
315 amendment_recommendation,
316 amendment_ref_number,
317 avail_status_prop_end_date,
318 bargaining_unit_cd,
319 comments,
320 country1,
321 country2,
322 country3,
323 current_job_prop_end_date,
324 current_org_prop_end_date,
325 date_effective,
326 date_end,
327 earliest_hire_date,
328 fill_by_date,
329 frequency,
330 fte,
331 fte_capacity,
332 location1,
333 location2,
334 location3,
335 max_persons,
336 name,
337 other_requirements,
338 overlap_period,
339 overlap_unit_cd,
340 passport_required,
341 pay_term_end_day_cd,
342 pay_term_end_month_cd,
343 permanent_temporary_flag,
344 permit_recruitment_flag,
345 position_type,
346 posting_description,
347 probation_period,
348 probation_period_unit_cd,
349 relocate_domestically,
350 relocate_internationally,
351 replacement_required_flag,
352 review_flag,
353 seasonal_flag,
354 security_requirements,
355 service_minimum,
356 term_start_day_cd,
357 term_start_month_cd,
358 time_normal_finish,
359 time_normal_start,
360 transaction_status,
361 travel_required,
362 working_hours,
363 works_council_approval_flag,
364 work_any_country,
365 work_any_location,
366 work_period_type_cd,
367 work_schedule,
368 work_duration,
369 work_term_end_day_cd,
370 work_term_end_month_cd,
371 proposed_fte_for_layoff,
372 proposed_date_for_layoff,
373 information1,
374 information2,
375 information3,
376 information4,
377 information5,
378 information6,
379 information7,
380 information8,
381 information9,
382 information10,
383 information11,
384 information12,
385 information13,
386 information14,
387 information15,
388 information16,
389 information17,
390 information18,
391 information19,
392 information20,
393 information21,
394 information22,
395 information23,
396 information24,
397 information25,
398 information26,
399 information27,
400 information28,
401 information29,
402 information30,
403 information_category,
404 attribute1,
405 attribute2,
406 attribute3,
407 attribute4,
408 attribute5,
409 attribute6,
410 attribute7,
411 attribute8,
412 attribute9,
413 attribute10,
414 attribute11,
415 attribute12,
416 attribute13,
417 attribute14,
418 attribute15,
419 attribute16,
420 attribute17,
421 attribute18,
422 attribute19,
423 attribute20,
424 attribute21,
425 attribute22,
426 attribute23,
427 attribute24,
428 attribute25,
429 attribute26,
430 attribute27,
431 attribute28,
432 attribute29,
433 attribute30,
434 attribute_category,
435 object_version_number,
436 pay_basis_id,
437 supervisor_id,
438 wf_transaction_category_id
439 from pqh_position_transactions
440 where position_transaction_id = p_position_transaction_id
441 for update nowait;
442 --
443 l_proc varchar2(72) := g_package||'lck';
444 --
445 Begin
446 hr_utility.set_location('Entering:'||l_proc, 5);
447 --
448 -- Add any mandatory argument checking here:
449 -- Example:
450 -- hr_api.mandatory_arg_error
451 -- (p_api_name => l_proc,
452 -- p_argument => 'object_version_number',
453 -- p_argument_value => p_object_version_number);
454 --
455 Open C_Sel1;
456 Fetch C_Sel1 Into g_old_rec;
457 If C_Sel1%notfound then
458 Close C_Sel1;
459 --
460 -- The primary key is invalid therefore we must error
461 --
462 hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
463 hr_utility.raise_error;
464 End If;
465 Close C_Sel1;
466 If (p_object_version_number <> g_old_rec.object_version_number) Then
467 hr_utility.set_message(801, 'HR_7155_OBJECT_INVALID');
468 hr_utility.raise_error;
469 End If;
470 --
471 hr_utility.set_location(' Leaving:'||l_proc, 10);
472 --
473 -- We need to trap the ORA LOCK exception
474 --
475 Exception
476 When HR_Api.Object_Locked then
477 --
478 -- The object is locked therefore we need to supply a meaningful
479 -- error message.
480 --
481 hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
482 hr_utility.set_message_token('TABLE_NAME', 'pqh_position_transactions');
483 hr_utility.raise_error;
484 End lck;
485 --
486 -- ----------------------------------------------------------------------------
487 -- |-----------------------------< convert_args >-----------------------------|
488 -- ----------------------------------------------------------------------------
489 Function convert_args
490 (
491 p_position_transaction_id in number,
492 p_action_date in date,
493 p_position_id in number,
494 p_availability_status_id in number,
495 p_business_group_id in number,
496 p_entry_step_id in number,
497 p_entry_grade_rule_id in number,
498 p_job_id in number,
499 p_location_id in number,
500 p_organization_id in number,
501 p_pay_freq_payroll_id in number,
502 p_position_definition_id in number,
503 p_prior_position_id in number,
504 p_relief_position_id in number,
505 p_entry_grade_id in number,
506 p_successor_position_id in number,
507 p_supervisor_position_id in number,
508 p_amendment_date in date,
509 p_amendment_recommendation in varchar2,
510 p_amendment_ref_number in varchar2,
511 p_avail_status_prop_end_date in date,
512 p_bargaining_unit_cd in varchar2,
513 p_comments in varchar2,
514 p_country1 in varchar2,
515 p_country2 in varchar2,
516 p_country3 in varchar2,
517 p_current_job_prop_end_date in date,
518 p_current_org_prop_end_date in date,
519 p_date_effective in date,
520 p_date_end in date,
521 p_earliest_hire_date in date,
522 p_fill_by_date in date,
523 p_frequency in varchar2,
524 p_fte in number,
525 p_fte_capacity in varchar2,
526 p_location1 in varchar2,
527 p_location2 in varchar2,
528 p_location3 in varchar2,
529 p_max_persons in number,
530 p_name in varchar2,
531 p_other_requirements in varchar2,
532 p_overlap_period in number,
533 p_overlap_unit_cd in varchar2,
534 p_passport_required in varchar2,
535 p_pay_term_end_day_cd in varchar2,
536 p_pay_term_end_month_cd in varchar2,
537 p_permanent_temporary_flag in varchar2,
538 p_permit_recruitment_flag in varchar2,
539 p_position_type in varchar2,
540 p_posting_description in varchar2,
541 p_probation_period in number,
542 p_probation_period_unit_cd in varchar2,
543 p_relocate_domestically in varchar2,
544 p_relocate_internationally in varchar2,
545 p_replacement_required_flag in varchar2,
546 p_review_flag in varchar2,
547 p_seasonal_flag in varchar2,
548 p_security_requirements in varchar2,
549 p_service_minimum in varchar2,
550 p_term_start_day_cd in varchar2,
551 p_term_start_month_cd in varchar2,
552 p_time_normal_finish in varchar2,
553 p_time_normal_start in varchar2,
554 p_transaction_status in varchar2,
555 p_travel_required in varchar2,
556 p_working_hours in number,
557 p_works_council_approval_flag in varchar2,
558 p_work_any_country in varchar2,
559 p_work_any_location in varchar2,
560 p_work_period_type_cd in varchar2,
561 p_work_schedule in varchar2,
562 p_work_duration in varchar2,
563 p_work_term_end_day_cd in varchar2,
564 p_work_term_end_month_cd in varchar2,
565 p_proposed_fte_for_layoff in number,
566 p_proposed_date_for_layoff in date,
567 p_information1 in varchar2,
568 p_information2 in varchar2,
569 p_information3 in varchar2,
570 p_information4 in varchar2,
571 p_information5 in varchar2,
572 p_information6 in varchar2,
573 p_information7 in varchar2,
574 p_information8 in varchar2,
575 p_information9 in varchar2,
576 p_information10 in varchar2,
577 p_information11 in varchar2,
578 p_information12 in varchar2,
579 p_information13 in varchar2,
580 p_information14 in varchar2,
581 p_information15 in varchar2,
582 p_information16 in varchar2,
583 p_information17 in varchar2,
584 p_information18 in varchar2,
585 p_information19 in varchar2,
586 p_information20 in varchar2,
587 p_information21 in varchar2,
588 p_information22 in varchar2,
589 p_information23 in varchar2,
590 p_information24 in varchar2,
591 p_information25 in varchar2,
592 p_information26 in varchar2,
593 p_information27 in varchar2,
594 p_information28 in varchar2,
595 p_information29 in varchar2,
596 p_information30 in varchar2,
597 p_information_category in varchar2,
598 p_attribute1 in varchar2,
599 p_attribute2 in varchar2,
600 p_attribute3 in varchar2,
601 p_attribute4 in varchar2,
602 p_attribute5 in varchar2,
603 p_attribute6 in varchar2,
604 p_attribute7 in varchar2,
605 p_attribute8 in varchar2,
606 p_attribute9 in varchar2,
607 p_attribute10 in varchar2,
608 p_attribute11 in varchar2,
609 p_attribute12 in varchar2,
610 p_attribute13 in varchar2,
611 p_attribute14 in varchar2,
612 p_attribute15 in varchar2,
613 p_attribute16 in varchar2,
614 p_attribute17 in varchar2,
615 p_attribute18 in varchar2,
616 p_attribute19 in varchar2,
617 p_attribute20 in varchar2,
618 p_attribute21 in varchar2,
619 p_attribute22 in varchar2,
620 p_attribute23 in varchar2,
621 p_attribute24 in varchar2,
622 p_attribute25 in varchar2,
623 p_attribute26 in varchar2,
624 p_attribute27 in varchar2,
625 p_attribute28 in varchar2,
626 p_attribute29 in varchar2,
627 p_attribute30 in varchar2,
628 p_attribute_category in varchar2,
629 p_object_version_number in number,
630 p_pay_basis_id in number,
631 p_supervisor_id in number,
632 p_wf_transaction_category_id in number
633 )
634 Return g_rec_type is
635 --
636 l_rec g_rec_type;
637 l_proc varchar2(72) := g_package||'convert_args';
638 --
639 Begin
640 --
641 hr_utility.set_location('Entering:'||l_proc, 5);
642 --
643 -- Convert arguments into local l_rec structure.
644 --
645 l_rec.position_transaction_id := p_position_transaction_id;
646 l_rec.action_date := p_action_date;
647 l_rec.position_id := p_position_id;
648 l_rec.availability_status_id := p_availability_status_id;
649 l_rec.business_group_id := p_business_group_id;
650 l_rec.entry_step_id := p_entry_step_id;
651 l_rec.entry_grade_rule_id := p_entry_grade_rule_id;
652 l_rec.job_id := p_job_id;
653 l_rec.location_id := p_location_id;
654 l_rec.organization_id := p_organization_id;
655 l_rec.pay_freq_payroll_id := p_pay_freq_payroll_id;
656 l_rec.position_definition_id := p_position_definition_id;
657 l_rec.prior_position_id := p_prior_position_id;
658 l_rec.relief_position_id := p_relief_position_id;
659 l_rec.entry_grade_id := p_entry_grade_id;
660 l_rec.successor_position_id := p_successor_position_id;
661 l_rec.supervisor_position_id := p_supervisor_position_id;
662 l_rec.amendment_date := p_amendment_date;
663 l_rec.amendment_recommendation := p_amendment_recommendation;
664 l_rec.amendment_ref_number := p_amendment_ref_number;
665 l_rec.avail_status_prop_end_date := p_avail_status_prop_end_date;
666 l_rec.bargaining_unit_cd := p_bargaining_unit_cd;
667 l_rec.comments := p_comments;
668 l_rec.country1 := p_country1;
669 l_rec.country2 := p_country2;
670 l_rec.country3 := p_country3;
671 l_rec.current_job_prop_end_date := p_current_job_prop_end_date;
672 l_rec.current_org_prop_end_date := p_current_org_prop_end_date;
673 l_rec.date_effective := p_date_effective;
674 l_rec.date_end := p_date_end;
675 l_rec.earliest_hire_date := p_earliest_hire_date;
676 l_rec.fill_by_date := p_fill_by_date;
680 l_rec.location1 := p_location1;
677 l_rec.frequency := p_frequency;
678 l_rec.fte := p_fte;
679 l_rec.fte_capacity := p_fte_capacity;
681 l_rec.location2 := p_location2;
682 l_rec.location3 := p_location3;
683 l_rec.max_persons := p_max_persons;
684 l_rec.name := p_name;
685 l_rec.other_requirements := p_other_requirements;
686 l_rec.overlap_period := p_overlap_period;
687 l_rec.overlap_unit_cd := p_overlap_unit_cd;
688 l_rec.passport_required := p_passport_required;
689 l_rec.pay_term_end_day_cd := p_pay_term_end_day_cd;
690 l_rec.pay_term_end_month_cd := p_pay_term_end_month_cd;
691 l_rec.permanent_temporary_flag := p_permanent_temporary_flag;
692 l_rec.permit_recruitment_flag := p_permit_recruitment_flag;
693 l_rec.position_type := p_position_type;
694 l_rec.posting_description := p_posting_description;
695 l_rec.probation_period := p_probation_period;
696 l_rec.probation_period_unit_cd := p_probation_period_unit_cd;
697 l_rec.relocate_domestically := p_relocate_domestically;
698 l_rec.relocate_internationally := p_relocate_internationally;
699 l_rec.replacement_required_flag := p_replacement_required_flag;
700 l_rec.review_flag := p_review_flag;
701 l_rec.seasonal_flag := p_seasonal_flag;
702 l_rec.security_requirements := p_security_requirements;
703 l_rec.service_minimum := p_service_minimum;
704 l_rec.term_start_day_cd := p_term_start_day_cd;
705 l_rec.term_start_month_cd := p_term_start_month_cd;
706 l_rec.time_normal_finish := p_time_normal_finish;
707 l_rec.time_normal_start := p_time_normal_start;
708 l_rec.transaction_status := p_transaction_status;
709 l_rec.travel_required := p_travel_required;
710 l_rec.working_hours := p_working_hours;
711 l_rec.works_council_approval_flag := p_works_council_approval_flag;
712 l_rec.work_any_country := p_work_any_country;
713 l_rec.work_any_location := p_work_any_location;
714 l_rec.work_period_type_cd := p_work_period_type_cd;
715 l_rec.work_schedule := p_work_schedule;
716 l_rec.work_duration := p_work_duration;
717 l_rec.work_term_end_day_cd := p_work_term_end_day_cd;
718 l_rec.work_term_end_month_cd := p_work_term_end_month_cd;
719 l_rec.proposed_fte_for_layoff := p_proposed_fte_for_layoff;
720 l_rec.proposed_date_for_layoff := p_proposed_date_for_layoff;
721 l_rec.information1 := p_information1;
722 l_rec.information2 := p_information2;
723 l_rec.information3 := p_information3;
724 l_rec.information4 := p_information4;
725 l_rec.information5 := p_information5;
726 l_rec.information6 := p_information6;
727 l_rec.information7 := p_information7;
728 l_rec.information8 := p_information8;
729 l_rec.information9 := p_information9;
730 l_rec.information10 := p_information10;
731 l_rec.information11 := p_information11;
732 l_rec.information12 := p_information12;
733 l_rec.information13 := p_information13;
734 l_rec.information14 := p_information14;
735 l_rec.information15 := p_information15;
736 l_rec.information16 := p_information16;
737 l_rec.information17 := p_information17;
738 l_rec.information18 := p_information18;
739 l_rec.information19 := p_information19;
740 l_rec.information20 := p_information20;
741 l_rec.information21 := p_information21;
742 l_rec.information22 := p_information22;
743 l_rec.information23 := p_information23;
744 l_rec.information24 := p_information24;
745 l_rec.information25 := p_information25;
746 l_rec.information26 := p_information26;
747 l_rec.information27 := p_information27;
748 l_rec.information28 := p_information28;
749 l_rec.information29 := p_information29;
750 l_rec.information30 := p_information30;
751 l_rec.information_category := p_information_category;
752 l_rec.attribute1 := p_attribute1;
753 l_rec.attribute2 := p_attribute2;
754 l_rec.attribute3 := p_attribute3;
755 l_rec.attribute4 := p_attribute4;
756 l_rec.attribute5 := p_attribute5;
757 l_rec.attribute6 := p_attribute6;
758 l_rec.attribute7 := p_attribute7;
759 l_rec.attribute8 := p_attribute8;
760 l_rec.attribute9 := p_attribute9;
761 l_rec.attribute10 := p_attribute10;
762 l_rec.attribute11 := p_attribute11;
763 l_rec.attribute12 := p_attribute12;
764 l_rec.attribute13 := p_attribute13;
765 l_rec.attribute14 := p_attribute14;
766 l_rec.attribute15 := p_attribute15;
767 l_rec.attribute16 := p_attribute16;
768 l_rec.attribute17 := p_attribute17;
769 l_rec.attribute18 := p_attribute18;
770 l_rec.attribute19 := p_attribute19;
771 l_rec.attribute20 := p_attribute20;
772 l_rec.attribute21 := p_attribute21;
773 l_rec.attribute22 := p_attribute22;
774 l_rec.attribute23 := p_attribute23;
775 l_rec.attribute24 := p_attribute24;
776 l_rec.attribute25 := p_attribute25;
777 l_rec.attribute26 := p_attribute26;
778 l_rec.attribute27 := p_attribute27;
779 l_rec.attribute28 := p_attribute28;
780 l_rec.attribute29 := p_attribute29;
781 l_rec.attribute30 := p_attribute30;
782 l_rec.attribute_category := p_attribute_category;
783 l_rec.object_version_number := p_object_version_number;
784 l_rec.pay_basis_id := p_pay_basis_id;
785 l_rec.supervisor_id := p_supervisor_id;
786 l_rec.wf_transaction_category_id := p_wf_transaction_category_id;
787 --
788 -- Return the plsql record structure.
789 --
790 hr_utility.set_location(' Leaving:'||l_proc, 10);
791 Return(l_rec);
792 --
793 End convert_args;
794 --
795 end pqh_ptx_shd;