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.PQH_PTE_UPD dependencies on HR_API

Line 127: When hr_api.check_integrity_violated Then

123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 10);
125: --
126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: pqh_pte_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then

Line 130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

126: Exception
127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: pqh_pte_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 131: When hr_api.parent_integrity_violated Then

127: When hr_api.check_integrity_violated Then
128: -- A check constraint has been violated
129: pqh_pte_shd.constraint_error
130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then

Line 134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

130: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: pqh_pte_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 135: When hr_api.unique_integrity_violated Then

131: When hr_api.parent_integrity_violated Then
132: -- Parent integrity has been violated
133: pqh_pte_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: pqh_pte_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then

Line 138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: pqh_pte_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When Others Then
140: Raise;
141: End update_dml;
142: --

Line 348: when hr_api.cannot_find_prog_unit then

344: );
345: --
346: exception
347: --
348: when hr_api.cannot_find_prog_unit then
349: --
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'pqh_ptx_extra_info'
352: ,p_hook_type => 'AU');

Line 350: hr_api.cannot_find_prog_unit_error

346: exception
347: --
348: when hr_api.cannot_find_prog_unit then
349: --
350: hr_api.cannot_find_prog_unit_error
351: (p_module_name => 'pqh_ptx_extra_info'
352: ,p_hook_type => 'AU');
353: --
354: end;

Line 418: If (p_rec.information_type = hr_api.g_varchar2) then

414: -- p_rec plsql record structure
415: -- to see if a system default is being used. If a system default
416: -- is being used then we must set to the 'current' argument value.
417: --
418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pqh_pte_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.position_transaction_id = hr_api.g_number) then

Line 422: If (p_rec.position_transaction_id = hr_api.g_number) then

418: If (p_rec.information_type = hr_api.g_varchar2) then
419: p_rec.information_type :=
420: pqh_pte_shd.g_old_rec.information_type;
421: End If;
422: If (p_rec.position_transaction_id = hr_api.g_number) then
423: p_rec.position_transaction_id :=
424: pqh_pte_shd.g_old_rec.position_transaction_id;
425: End If;
426: If (p_rec.position_extra_info_id = hr_api.g_number) then

Line 426: If (p_rec.position_extra_info_id = hr_api.g_number) then

422: If (p_rec.position_transaction_id = hr_api.g_number) then
423: p_rec.position_transaction_id :=
424: pqh_pte_shd.g_old_rec.position_transaction_id;
425: End If;
426: If (p_rec.position_extra_info_id = hr_api.g_number) then
427: p_rec.position_extra_info_id :=
428: pqh_pte_shd.g_old_rec.position_extra_info_id;
429: End If;
430: If (p_rec.information_category = hr_api.g_varchar2) then

Line 430: If (p_rec.information_category = hr_api.g_varchar2) then

426: If (p_rec.position_extra_info_id = hr_api.g_number) then
427: p_rec.position_extra_info_id :=
428: pqh_pte_shd.g_old_rec.position_extra_info_id;
429: End If;
430: If (p_rec.information_category = hr_api.g_varchar2) then
431: p_rec.information_category :=
432: pqh_pte_shd.g_old_rec.information_category;
433: End If;
434: If (p_rec.information1 = hr_api.g_varchar2) then

Line 434: If (p_rec.information1 = hr_api.g_varchar2) then

430: If (p_rec.information_category = hr_api.g_varchar2) then
431: p_rec.information_category :=
432: pqh_pte_shd.g_old_rec.information_category;
433: End If;
434: If (p_rec.information1 = hr_api.g_varchar2) then
435: p_rec.information1 :=
436: pqh_pte_shd.g_old_rec.information1;
437: End If;
438: If (p_rec.information2 = hr_api.g_varchar2) then

Line 438: If (p_rec.information2 = hr_api.g_varchar2) then

434: If (p_rec.information1 = hr_api.g_varchar2) then
435: p_rec.information1 :=
436: pqh_pte_shd.g_old_rec.information1;
437: End If;
438: If (p_rec.information2 = hr_api.g_varchar2) then
439: p_rec.information2 :=
440: pqh_pte_shd.g_old_rec.information2;
441: End If;
442: If (p_rec.information3 = hr_api.g_varchar2) then

Line 442: If (p_rec.information3 = hr_api.g_varchar2) then

438: If (p_rec.information2 = hr_api.g_varchar2) then
439: p_rec.information2 :=
440: pqh_pte_shd.g_old_rec.information2;
441: End If;
442: If (p_rec.information3 = hr_api.g_varchar2) then
443: p_rec.information3 :=
444: pqh_pte_shd.g_old_rec.information3;
445: End If;
446: If (p_rec.information4 = hr_api.g_varchar2) then

Line 446: If (p_rec.information4 = hr_api.g_varchar2) then

442: If (p_rec.information3 = hr_api.g_varchar2) then
443: p_rec.information3 :=
444: pqh_pte_shd.g_old_rec.information3;
445: End If;
446: If (p_rec.information4 = hr_api.g_varchar2) then
447: p_rec.information4 :=
448: pqh_pte_shd.g_old_rec.information4;
449: End If;
450: If (p_rec.information5 = hr_api.g_varchar2) then

Line 450: If (p_rec.information5 = hr_api.g_varchar2) then

446: If (p_rec.information4 = hr_api.g_varchar2) then
447: p_rec.information4 :=
448: pqh_pte_shd.g_old_rec.information4;
449: End If;
450: If (p_rec.information5 = hr_api.g_varchar2) then
451: p_rec.information5 :=
452: pqh_pte_shd.g_old_rec.information5;
453: End If;
454: If (p_rec.information6 = hr_api.g_varchar2) then

Line 454: If (p_rec.information6 = hr_api.g_varchar2) then

450: If (p_rec.information5 = hr_api.g_varchar2) then
451: p_rec.information5 :=
452: pqh_pte_shd.g_old_rec.information5;
453: End If;
454: If (p_rec.information6 = hr_api.g_varchar2) then
455: p_rec.information6 :=
456: pqh_pte_shd.g_old_rec.information6;
457: End If;
458: If (p_rec.information7 = hr_api.g_varchar2) then

Line 458: If (p_rec.information7 = hr_api.g_varchar2) then

454: If (p_rec.information6 = hr_api.g_varchar2) then
455: p_rec.information6 :=
456: pqh_pte_shd.g_old_rec.information6;
457: End If;
458: If (p_rec.information7 = hr_api.g_varchar2) then
459: p_rec.information7 :=
460: pqh_pte_shd.g_old_rec.information7;
461: End If;
462: If (p_rec.information8 = hr_api.g_varchar2) then

Line 462: If (p_rec.information8 = hr_api.g_varchar2) then

458: If (p_rec.information7 = hr_api.g_varchar2) then
459: p_rec.information7 :=
460: pqh_pte_shd.g_old_rec.information7;
461: End If;
462: If (p_rec.information8 = hr_api.g_varchar2) then
463: p_rec.information8 :=
464: pqh_pte_shd.g_old_rec.information8;
465: End If;
466: If (p_rec.information9 = hr_api.g_varchar2) then

Line 466: If (p_rec.information9 = hr_api.g_varchar2) then

462: If (p_rec.information8 = hr_api.g_varchar2) then
463: p_rec.information8 :=
464: pqh_pte_shd.g_old_rec.information8;
465: End If;
466: If (p_rec.information9 = hr_api.g_varchar2) then
467: p_rec.information9 :=
468: pqh_pte_shd.g_old_rec.information9;
469: End If;
470: If (p_rec.information10 = hr_api.g_varchar2) then

Line 470: If (p_rec.information10 = hr_api.g_varchar2) then

466: If (p_rec.information9 = hr_api.g_varchar2) then
467: p_rec.information9 :=
468: pqh_pte_shd.g_old_rec.information9;
469: End If;
470: If (p_rec.information10 = hr_api.g_varchar2) then
471: p_rec.information10 :=
472: pqh_pte_shd.g_old_rec.information10;
473: End If;
474: If (p_rec.information11 = hr_api.g_varchar2) then

Line 474: If (p_rec.information11 = hr_api.g_varchar2) then

470: If (p_rec.information10 = hr_api.g_varchar2) then
471: p_rec.information10 :=
472: pqh_pte_shd.g_old_rec.information10;
473: End If;
474: If (p_rec.information11 = hr_api.g_varchar2) then
475: p_rec.information11 :=
476: pqh_pte_shd.g_old_rec.information11;
477: End If;
478: If (p_rec.information12 = hr_api.g_varchar2) then

Line 478: If (p_rec.information12 = hr_api.g_varchar2) then

474: If (p_rec.information11 = hr_api.g_varchar2) then
475: p_rec.information11 :=
476: pqh_pte_shd.g_old_rec.information11;
477: End If;
478: If (p_rec.information12 = hr_api.g_varchar2) then
479: p_rec.information12 :=
480: pqh_pte_shd.g_old_rec.information12;
481: End If;
482: If (p_rec.information13 = hr_api.g_varchar2) then

Line 482: If (p_rec.information13 = hr_api.g_varchar2) then

478: If (p_rec.information12 = hr_api.g_varchar2) then
479: p_rec.information12 :=
480: pqh_pte_shd.g_old_rec.information12;
481: End If;
482: If (p_rec.information13 = hr_api.g_varchar2) then
483: p_rec.information13 :=
484: pqh_pte_shd.g_old_rec.information13;
485: End If;
486: If (p_rec.information14 = hr_api.g_varchar2) then

Line 486: If (p_rec.information14 = hr_api.g_varchar2) then

482: If (p_rec.information13 = hr_api.g_varchar2) then
483: p_rec.information13 :=
484: pqh_pte_shd.g_old_rec.information13;
485: End If;
486: If (p_rec.information14 = hr_api.g_varchar2) then
487: p_rec.information14 :=
488: pqh_pte_shd.g_old_rec.information14;
489: End If;
490: If (p_rec.information15 = hr_api.g_varchar2) then

Line 490: If (p_rec.information15 = hr_api.g_varchar2) then

486: If (p_rec.information14 = hr_api.g_varchar2) then
487: p_rec.information14 :=
488: pqh_pte_shd.g_old_rec.information14;
489: End If;
490: If (p_rec.information15 = hr_api.g_varchar2) then
491: p_rec.information15 :=
492: pqh_pte_shd.g_old_rec.information15;
493: End If;
494: If (p_rec.information16 = hr_api.g_varchar2) then

Line 494: If (p_rec.information16 = hr_api.g_varchar2) then

490: If (p_rec.information15 = hr_api.g_varchar2) then
491: p_rec.information15 :=
492: pqh_pte_shd.g_old_rec.information15;
493: End If;
494: If (p_rec.information16 = hr_api.g_varchar2) then
495: p_rec.information16 :=
496: pqh_pte_shd.g_old_rec.information16;
497: End If;
498: If (p_rec.information17 = hr_api.g_varchar2) then

Line 498: If (p_rec.information17 = hr_api.g_varchar2) then

494: If (p_rec.information16 = hr_api.g_varchar2) then
495: p_rec.information16 :=
496: pqh_pte_shd.g_old_rec.information16;
497: End If;
498: If (p_rec.information17 = hr_api.g_varchar2) then
499: p_rec.information17 :=
500: pqh_pte_shd.g_old_rec.information17;
501: End If;
502: If (p_rec.information18 = hr_api.g_varchar2) then

Line 502: If (p_rec.information18 = hr_api.g_varchar2) then

498: If (p_rec.information17 = hr_api.g_varchar2) then
499: p_rec.information17 :=
500: pqh_pte_shd.g_old_rec.information17;
501: End If;
502: If (p_rec.information18 = hr_api.g_varchar2) then
503: p_rec.information18 :=
504: pqh_pte_shd.g_old_rec.information18;
505: End If;
506: If (p_rec.information19 = hr_api.g_varchar2) then

Line 506: If (p_rec.information19 = hr_api.g_varchar2) then

502: If (p_rec.information18 = hr_api.g_varchar2) then
503: p_rec.information18 :=
504: pqh_pte_shd.g_old_rec.information18;
505: End If;
506: If (p_rec.information19 = hr_api.g_varchar2) then
507: p_rec.information19 :=
508: pqh_pte_shd.g_old_rec.information19;
509: End If;
510: If (p_rec.information20 = hr_api.g_varchar2) then

Line 510: If (p_rec.information20 = hr_api.g_varchar2) then

506: If (p_rec.information19 = hr_api.g_varchar2) then
507: p_rec.information19 :=
508: pqh_pte_shd.g_old_rec.information19;
509: End If;
510: If (p_rec.information20 = hr_api.g_varchar2) then
511: p_rec.information20 :=
512: pqh_pte_shd.g_old_rec.information20;
513: End If;
514: If (p_rec.information21 = hr_api.g_varchar2) then

Line 514: If (p_rec.information21 = hr_api.g_varchar2) then

510: If (p_rec.information20 = hr_api.g_varchar2) then
511: p_rec.information20 :=
512: pqh_pte_shd.g_old_rec.information20;
513: End If;
514: If (p_rec.information21 = hr_api.g_varchar2) then
515: p_rec.information21 :=
516: pqh_pte_shd.g_old_rec.information21;
517: End If;
518: If (p_rec.information22 = hr_api.g_varchar2) then

Line 518: If (p_rec.information22 = hr_api.g_varchar2) then

514: If (p_rec.information21 = hr_api.g_varchar2) then
515: p_rec.information21 :=
516: pqh_pte_shd.g_old_rec.information21;
517: End If;
518: If (p_rec.information22 = hr_api.g_varchar2) then
519: p_rec.information22 :=
520: pqh_pte_shd.g_old_rec.information22;
521: End If;
522: If (p_rec.information23 = hr_api.g_varchar2) then

Line 522: If (p_rec.information23 = hr_api.g_varchar2) then

518: If (p_rec.information22 = hr_api.g_varchar2) then
519: p_rec.information22 :=
520: pqh_pte_shd.g_old_rec.information22;
521: End If;
522: If (p_rec.information23 = hr_api.g_varchar2) then
523: p_rec.information23 :=
524: pqh_pte_shd.g_old_rec.information23;
525: End If;
526: If (p_rec.information24 = hr_api.g_varchar2) then

Line 526: If (p_rec.information24 = hr_api.g_varchar2) then

522: If (p_rec.information23 = hr_api.g_varchar2) then
523: p_rec.information23 :=
524: pqh_pte_shd.g_old_rec.information23;
525: End If;
526: If (p_rec.information24 = hr_api.g_varchar2) then
527: p_rec.information24 :=
528: pqh_pte_shd.g_old_rec.information24;
529: End If;
530: If (p_rec.information25 = hr_api.g_varchar2) then

Line 530: If (p_rec.information25 = hr_api.g_varchar2) then

526: If (p_rec.information24 = hr_api.g_varchar2) then
527: p_rec.information24 :=
528: pqh_pte_shd.g_old_rec.information24;
529: End If;
530: If (p_rec.information25 = hr_api.g_varchar2) then
531: p_rec.information25 :=
532: pqh_pte_shd.g_old_rec.information25;
533: End If;
534: If (p_rec.information26 = hr_api.g_varchar2) then

Line 534: If (p_rec.information26 = hr_api.g_varchar2) then

530: If (p_rec.information25 = hr_api.g_varchar2) then
531: p_rec.information25 :=
532: pqh_pte_shd.g_old_rec.information25;
533: End If;
534: If (p_rec.information26 = hr_api.g_varchar2) then
535: p_rec.information26 :=
536: pqh_pte_shd.g_old_rec.information26;
537: End If;
538: If (p_rec.information27 = hr_api.g_varchar2) then

Line 538: If (p_rec.information27 = hr_api.g_varchar2) then

534: If (p_rec.information26 = hr_api.g_varchar2) then
535: p_rec.information26 :=
536: pqh_pte_shd.g_old_rec.information26;
537: End If;
538: If (p_rec.information27 = hr_api.g_varchar2) then
539: p_rec.information27 :=
540: pqh_pte_shd.g_old_rec.information27;
541: End If;
542: If (p_rec.information28 = hr_api.g_varchar2) then

Line 542: If (p_rec.information28 = hr_api.g_varchar2) then

538: If (p_rec.information27 = hr_api.g_varchar2) then
539: p_rec.information27 :=
540: pqh_pte_shd.g_old_rec.information27;
541: End If;
542: If (p_rec.information28 = hr_api.g_varchar2) then
543: p_rec.information28 :=
544: pqh_pte_shd.g_old_rec.information28;
545: End If;
546: If (p_rec.information29 = hr_api.g_varchar2) then

Line 546: If (p_rec.information29 = hr_api.g_varchar2) then

542: If (p_rec.information28 = hr_api.g_varchar2) then
543: p_rec.information28 :=
544: pqh_pte_shd.g_old_rec.information28;
545: End If;
546: If (p_rec.information29 = hr_api.g_varchar2) then
547: p_rec.information29 :=
548: pqh_pte_shd.g_old_rec.information29;
549: End If;
550: If (p_rec.information30 = hr_api.g_varchar2) then

Line 550: If (p_rec.information30 = hr_api.g_varchar2) then

546: If (p_rec.information29 = hr_api.g_varchar2) then
547: p_rec.information29 :=
548: pqh_pte_shd.g_old_rec.information29;
549: End If;
550: If (p_rec.information30 = hr_api.g_varchar2) then
551: p_rec.information30 :=
552: pqh_pte_shd.g_old_rec.information30;
553: End If;
554: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 554: If (p_rec.attribute_category = hr_api.g_varchar2) then

550: If (p_rec.information30 = hr_api.g_varchar2) then
551: p_rec.information30 :=
552: pqh_pte_shd.g_old_rec.information30;
553: End If;
554: If (p_rec.attribute_category = hr_api.g_varchar2) then
555: p_rec.attribute_category :=
556: pqh_pte_shd.g_old_rec.attribute_category;
557: End If;
558: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 558: If (p_rec.attribute1 = hr_api.g_varchar2) then

554: If (p_rec.attribute_category = hr_api.g_varchar2) then
555: p_rec.attribute_category :=
556: pqh_pte_shd.g_old_rec.attribute_category;
557: End If;
558: If (p_rec.attribute1 = hr_api.g_varchar2) then
559: p_rec.attribute1 :=
560: pqh_pte_shd.g_old_rec.attribute1;
561: End If;
562: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 562: If (p_rec.attribute2 = hr_api.g_varchar2) then

558: If (p_rec.attribute1 = hr_api.g_varchar2) then
559: p_rec.attribute1 :=
560: pqh_pte_shd.g_old_rec.attribute1;
561: End If;
562: If (p_rec.attribute2 = hr_api.g_varchar2) then
563: p_rec.attribute2 :=
564: pqh_pte_shd.g_old_rec.attribute2;
565: End If;
566: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 566: If (p_rec.attribute3 = hr_api.g_varchar2) then

562: If (p_rec.attribute2 = hr_api.g_varchar2) then
563: p_rec.attribute2 :=
564: pqh_pte_shd.g_old_rec.attribute2;
565: End If;
566: If (p_rec.attribute3 = hr_api.g_varchar2) then
567: p_rec.attribute3 :=
568: pqh_pte_shd.g_old_rec.attribute3;
569: End If;
570: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 570: If (p_rec.attribute4 = hr_api.g_varchar2) then

566: If (p_rec.attribute3 = hr_api.g_varchar2) then
567: p_rec.attribute3 :=
568: pqh_pte_shd.g_old_rec.attribute3;
569: End If;
570: If (p_rec.attribute4 = hr_api.g_varchar2) then
571: p_rec.attribute4 :=
572: pqh_pte_shd.g_old_rec.attribute4;
573: End If;
574: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 574: If (p_rec.attribute5 = hr_api.g_varchar2) then

570: If (p_rec.attribute4 = hr_api.g_varchar2) then
571: p_rec.attribute4 :=
572: pqh_pte_shd.g_old_rec.attribute4;
573: End If;
574: If (p_rec.attribute5 = hr_api.g_varchar2) then
575: p_rec.attribute5 :=
576: pqh_pte_shd.g_old_rec.attribute5;
577: End If;
578: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 578: If (p_rec.attribute6 = hr_api.g_varchar2) then

574: If (p_rec.attribute5 = hr_api.g_varchar2) then
575: p_rec.attribute5 :=
576: pqh_pte_shd.g_old_rec.attribute5;
577: End If;
578: If (p_rec.attribute6 = hr_api.g_varchar2) then
579: p_rec.attribute6 :=
580: pqh_pte_shd.g_old_rec.attribute6;
581: End If;
582: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 582: If (p_rec.attribute7 = hr_api.g_varchar2) then

578: If (p_rec.attribute6 = hr_api.g_varchar2) then
579: p_rec.attribute6 :=
580: pqh_pte_shd.g_old_rec.attribute6;
581: End If;
582: If (p_rec.attribute7 = hr_api.g_varchar2) then
583: p_rec.attribute7 :=
584: pqh_pte_shd.g_old_rec.attribute7;
585: End If;
586: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 586: If (p_rec.attribute8 = hr_api.g_varchar2) then

582: If (p_rec.attribute7 = hr_api.g_varchar2) then
583: p_rec.attribute7 :=
584: pqh_pte_shd.g_old_rec.attribute7;
585: End If;
586: If (p_rec.attribute8 = hr_api.g_varchar2) then
587: p_rec.attribute8 :=
588: pqh_pte_shd.g_old_rec.attribute8;
589: End If;
590: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 590: If (p_rec.attribute9 = hr_api.g_varchar2) then

586: If (p_rec.attribute8 = hr_api.g_varchar2) then
587: p_rec.attribute8 :=
588: pqh_pte_shd.g_old_rec.attribute8;
589: End If;
590: If (p_rec.attribute9 = hr_api.g_varchar2) then
591: p_rec.attribute9 :=
592: pqh_pte_shd.g_old_rec.attribute9;
593: End If;
594: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 594: If (p_rec.attribute10 = hr_api.g_varchar2) then

590: If (p_rec.attribute9 = hr_api.g_varchar2) then
591: p_rec.attribute9 :=
592: pqh_pte_shd.g_old_rec.attribute9;
593: End If;
594: If (p_rec.attribute10 = hr_api.g_varchar2) then
595: p_rec.attribute10 :=
596: pqh_pte_shd.g_old_rec.attribute10;
597: End If;
598: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 598: If (p_rec.attribute11 = hr_api.g_varchar2) then

594: If (p_rec.attribute10 = hr_api.g_varchar2) then
595: p_rec.attribute10 :=
596: pqh_pte_shd.g_old_rec.attribute10;
597: End If;
598: If (p_rec.attribute11 = hr_api.g_varchar2) then
599: p_rec.attribute11 :=
600: pqh_pte_shd.g_old_rec.attribute11;
601: End If;
602: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 602: If (p_rec.attribute12 = hr_api.g_varchar2) then

598: If (p_rec.attribute11 = hr_api.g_varchar2) then
599: p_rec.attribute11 :=
600: pqh_pte_shd.g_old_rec.attribute11;
601: End If;
602: If (p_rec.attribute12 = hr_api.g_varchar2) then
603: p_rec.attribute12 :=
604: pqh_pte_shd.g_old_rec.attribute12;
605: End If;
606: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 606: If (p_rec.attribute13 = hr_api.g_varchar2) then

602: If (p_rec.attribute12 = hr_api.g_varchar2) then
603: p_rec.attribute12 :=
604: pqh_pte_shd.g_old_rec.attribute12;
605: End If;
606: If (p_rec.attribute13 = hr_api.g_varchar2) then
607: p_rec.attribute13 :=
608: pqh_pte_shd.g_old_rec.attribute13;
609: End If;
610: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 610: If (p_rec.attribute14 = hr_api.g_varchar2) then

606: If (p_rec.attribute13 = hr_api.g_varchar2) then
607: p_rec.attribute13 :=
608: pqh_pte_shd.g_old_rec.attribute13;
609: End If;
610: If (p_rec.attribute14 = hr_api.g_varchar2) then
611: p_rec.attribute14 :=
612: pqh_pte_shd.g_old_rec.attribute14;
613: End If;
614: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 614: If (p_rec.attribute15 = hr_api.g_varchar2) then

610: If (p_rec.attribute14 = hr_api.g_varchar2) then
611: p_rec.attribute14 :=
612: pqh_pte_shd.g_old_rec.attribute14;
613: End If;
614: If (p_rec.attribute15 = hr_api.g_varchar2) then
615: p_rec.attribute15 :=
616: pqh_pte_shd.g_old_rec.attribute15;
617: End If;
618: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 618: If (p_rec.attribute16 = hr_api.g_varchar2) then

614: If (p_rec.attribute15 = hr_api.g_varchar2) then
615: p_rec.attribute15 :=
616: pqh_pte_shd.g_old_rec.attribute15;
617: End If;
618: If (p_rec.attribute16 = hr_api.g_varchar2) then
619: p_rec.attribute16 :=
620: pqh_pte_shd.g_old_rec.attribute16;
621: End If;
622: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 622: If (p_rec.attribute17 = hr_api.g_varchar2) then

618: If (p_rec.attribute16 = hr_api.g_varchar2) then
619: p_rec.attribute16 :=
620: pqh_pte_shd.g_old_rec.attribute16;
621: End If;
622: If (p_rec.attribute17 = hr_api.g_varchar2) then
623: p_rec.attribute17 :=
624: pqh_pte_shd.g_old_rec.attribute17;
625: End If;
626: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 626: If (p_rec.attribute18 = hr_api.g_varchar2) then

622: If (p_rec.attribute17 = hr_api.g_varchar2) then
623: p_rec.attribute17 :=
624: pqh_pte_shd.g_old_rec.attribute17;
625: End If;
626: If (p_rec.attribute18 = hr_api.g_varchar2) then
627: p_rec.attribute18 :=
628: pqh_pte_shd.g_old_rec.attribute18;
629: End If;
630: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 630: If (p_rec.attribute19 = hr_api.g_varchar2) then

626: If (p_rec.attribute18 = hr_api.g_varchar2) then
627: p_rec.attribute18 :=
628: pqh_pte_shd.g_old_rec.attribute18;
629: End If;
630: If (p_rec.attribute19 = hr_api.g_varchar2) then
631: p_rec.attribute19 :=
632: pqh_pte_shd.g_old_rec.attribute19;
633: End If;
634: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 634: If (p_rec.attribute20 = hr_api.g_varchar2) then

630: If (p_rec.attribute19 = hr_api.g_varchar2) then
631: p_rec.attribute19 :=
632: pqh_pte_shd.g_old_rec.attribute19;
633: End If;
634: If (p_rec.attribute20 = hr_api.g_varchar2) then
635: p_rec.attribute20 :=
636: pqh_pte_shd.g_old_rec.attribute20;
637: End If;
638:

Line 693: p_information_type in varchar2 default hr_api.g_varchar2,

689: -- ----------------------------------------------------------------------------
690: Procedure upd
691: (
692: p_ptx_extra_info_id in number,
693: p_information_type in varchar2 default hr_api.g_varchar2,
694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,

Line 694: p_position_transaction_id in number default hr_api.g_number,

690: Procedure upd
691: (
692: p_ptx_extra_info_id in number,
693: p_information_type in varchar2 default hr_api.g_varchar2,
694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,

Line 695: p_position_extra_info_id in number default hr_api.g_number,

691: (
692: p_ptx_extra_info_id in number,
693: p_information_type in varchar2 default hr_api.g_varchar2,
694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,

Line 696: p_information_category in varchar2 default hr_api.g_varchar2,

692: p_ptx_extra_info_id in number,
693: p_information_type in varchar2 default hr_api.g_varchar2,
694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,

Line 697: p_information1 in varchar2 default hr_api.g_varchar2,

693: p_information_type in varchar2 default hr_api.g_varchar2,
694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,

Line 698: p_information2 in varchar2 default hr_api.g_varchar2,

694: p_position_transaction_id in number default hr_api.g_number,
695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,

Line 699: p_information3 in varchar2 default hr_api.g_varchar2,

695: p_position_extra_info_id in number default hr_api.g_number,
696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,

Line 700: p_information4 in varchar2 default hr_api.g_varchar2,

696: p_information_category in varchar2 default hr_api.g_varchar2,
697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,

Line 701: p_information5 in varchar2 default hr_api.g_varchar2,

697: p_information1 in varchar2 default hr_api.g_varchar2,
698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,

Line 702: p_information6 in varchar2 default hr_api.g_varchar2,

698: p_information2 in varchar2 default hr_api.g_varchar2,
699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,

Line 703: p_information7 in varchar2 default hr_api.g_varchar2,

699: p_information3 in varchar2 default hr_api.g_varchar2,
700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,

Line 704: p_information8 in varchar2 default hr_api.g_varchar2,

700: p_information4 in varchar2 default hr_api.g_varchar2,
701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,

Line 705: p_information9 in varchar2 default hr_api.g_varchar2,

701: p_information5 in varchar2 default hr_api.g_varchar2,
702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,

Line 706: p_information10 in varchar2 default hr_api.g_varchar2,

702: p_information6 in varchar2 default hr_api.g_varchar2,
703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,

Line 707: p_information11 in varchar2 default hr_api.g_varchar2,

703: p_information7 in varchar2 default hr_api.g_varchar2,
704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,

Line 708: p_information12 in varchar2 default hr_api.g_varchar2,

704: p_information8 in varchar2 default hr_api.g_varchar2,
705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,

Line 709: p_information13 in varchar2 default hr_api.g_varchar2,

705: p_information9 in varchar2 default hr_api.g_varchar2,
706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,

Line 710: p_information14 in varchar2 default hr_api.g_varchar2,

706: p_information10 in varchar2 default hr_api.g_varchar2,
707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,

Line 711: p_information15 in varchar2 default hr_api.g_varchar2,

707: p_information11 in varchar2 default hr_api.g_varchar2,
708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,

Line 712: p_information16 in varchar2 default hr_api.g_varchar2,

708: p_information12 in varchar2 default hr_api.g_varchar2,
709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,

Line 713: p_information17 in varchar2 default hr_api.g_varchar2,

709: p_information13 in varchar2 default hr_api.g_varchar2,
710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,

Line 714: p_information18 in varchar2 default hr_api.g_varchar2,

710: p_information14 in varchar2 default hr_api.g_varchar2,
711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,

Line 715: p_information19 in varchar2 default hr_api.g_varchar2,

711: p_information15 in varchar2 default hr_api.g_varchar2,
712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,

Line 716: p_information20 in varchar2 default hr_api.g_varchar2,

712: p_information16 in varchar2 default hr_api.g_varchar2,
713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,

Line 717: p_information21 in varchar2 default hr_api.g_varchar2,

713: p_information17 in varchar2 default hr_api.g_varchar2,
714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,

Line 718: p_information22 in varchar2 default hr_api.g_varchar2,

714: p_information18 in varchar2 default hr_api.g_varchar2,
715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,

Line 719: p_information23 in varchar2 default hr_api.g_varchar2,

715: p_information19 in varchar2 default hr_api.g_varchar2,
716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,

Line 720: p_information24 in varchar2 default hr_api.g_varchar2,

716: p_information20 in varchar2 default hr_api.g_varchar2,
717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,

Line 721: p_information25 in varchar2 default hr_api.g_varchar2,

717: p_information21 in varchar2 default hr_api.g_varchar2,
718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,

Line 722: p_information26 in varchar2 default hr_api.g_varchar2,

718: p_information22 in varchar2 default hr_api.g_varchar2,
719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,

Line 723: p_information27 in varchar2 default hr_api.g_varchar2,

719: p_information23 in varchar2 default hr_api.g_varchar2,
720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,

Line 724: p_information28 in varchar2 default hr_api.g_varchar2,

720: p_information24 in varchar2 default hr_api.g_varchar2,
721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,

Line 725: p_information29 in varchar2 default hr_api.g_varchar2,

721: p_information25 in varchar2 default hr_api.g_varchar2,
722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,

Line 726: p_information30 in varchar2 default hr_api.g_varchar2,

722: p_information26 in varchar2 default hr_api.g_varchar2,
723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,

Line 727: p_attribute_category in varchar2 default hr_api.g_varchar2,

723: p_information27 in varchar2 default hr_api.g_varchar2,
724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,

Line 728: p_attribute1 in varchar2 default hr_api.g_varchar2,

724: p_information28 in varchar2 default hr_api.g_varchar2,
725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,

Line 729: p_attribute2 in varchar2 default hr_api.g_varchar2,

725: p_information29 in varchar2 default hr_api.g_varchar2,
726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,

Line 730: p_attribute3 in varchar2 default hr_api.g_varchar2,

726: p_information30 in varchar2 default hr_api.g_varchar2,
727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,

Line 731: p_attribute4 in varchar2 default hr_api.g_varchar2,

727: p_attribute_category in varchar2 default hr_api.g_varchar2,
728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,

Line 732: p_attribute5 in varchar2 default hr_api.g_varchar2,

728: p_attribute1 in varchar2 default hr_api.g_varchar2,
729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,

Line 733: p_attribute6 in varchar2 default hr_api.g_varchar2,

729: p_attribute2 in varchar2 default hr_api.g_varchar2,
730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,

Line 734: p_attribute7 in varchar2 default hr_api.g_varchar2,

730: p_attribute3 in varchar2 default hr_api.g_varchar2,
731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,

Line 735: p_attribute8 in varchar2 default hr_api.g_varchar2,

731: p_attribute4 in varchar2 default hr_api.g_varchar2,
732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,

Line 736: p_attribute9 in varchar2 default hr_api.g_varchar2,

732: p_attribute5 in varchar2 default hr_api.g_varchar2,
733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,

Line 737: p_attribute10 in varchar2 default hr_api.g_varchar2,

733: p_attribute6 in varchar2 default hr_api.g_varchar2,
734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,

Line 738: p_attribute11 in varchar2 default hr_api.g_varchar2,

734: p_attribute7 in varchar2 default hr_api.g_varchar2,
735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,

Line 739: p_attribute12 in varchar2 default hr_api.g_varchar2,

735: p_attribute8 in varchar2 default hr_api.g_varchar2,
736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,

Line 740: p_attribute13 in varchar2 default hr_api.g_varchar2,

736: p_attribute9 in varchar2 default hr_api.g_varchar2,
737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,

Line 741: p_attribute14 in varchar2 default hr_api.g_varchar2,

737: p_attribute10 in varchar2 default hr_api.g_varchar2,
738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,

Line 742: p_attribute15 in varchar2 default hr_api.g_varchar2,

738: p_attribute11 in varchar2 default hr_api.g_varchar2,
739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,

Line 743: p_attribute16 in varchar2 default hr_api.g_varchar2,

739: p_attribute12 in varchar2 default hr_api.g_varchar2,
740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,
747: p_attribute20 in varchar2 default hr_api.g_varchar2,

Line 744: p_attribute17 in varchar2 default hr_api.g_varchar2,

740: p_attribute13 in varchar2 default hr_api.g_varchar2,
741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,
747: p_attribute20 in varchar2 default hr_api.g_varchar2,
748: p_object_version_number in out nocopy number

Line 745: p_attribute18 in varchar2 default hr_api.g_varchar2,

741: p_attribute14 in varchar2 default hr_api.g_varchar2,
742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,
747: p_attribute20 in varchar2 default hr_api.g_varchar2,
748: p_object_version_number in out nocopy number
749: ) is

Line 746: p_attribute19 in varchar2 default hr_api.g_varchar2,

742: p_attribute15 in varchar2 default hr_api.g_varchar2,
743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,
747: p_attribute20 in varchar2 default hr_api.g_varchar2,
748: p_object_version_number in out nocopy number
749: ) is
750: --

Line 747: p_attribute20 in varchar2 default hr_api.g_varchar2,

743: p_attribute16 in varchar2 default hr_api.g_varchar2,
744: p_attribute17 in varchar2 default hr_api.g_varchar2,
745: p_attribute18 in varchar2 default hr_api.g_varchar2,
746: p_attribute19 in varchar2 default hr_api.g_varchar2,
747: p_attribute20 in varchar2 default hr_api.g_varchar2,
748: p_object_version_number in out nocopy number
749: ) is
750: --
751: l_rec pqh_pte_shd.g_rec_type;