eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PJI_UPD dependencies on HR_API

Line 143: When hr_api.check_integrity_violated Then

139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --
146: per_pji_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: --
146: per_pji_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: per_pji_shd.constraint_error

Line 148: When hr_api.parent_integrity_violated Then

144: -- A check constraint has been violated
145: --
146: per_pji_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: per_pji_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: --
151: per_pji_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: per_pji_shd.constraint_error

Line 153: When hr_api.unique_integrity_violated Then

149: -- Parent integrity has been violated
150: --
151: per_pji_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: per_pji_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: --
156: per_pji_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: --
160: Raise;
161: End update_dml;

Line 386: when hr_api.cannot_find_prog_unit then

382: );
383: --
384: exception
385: --
386: when hr_api.cannot_find_prog_unit then
387: --
388: hr_api.cannot_find_prog_unit_error
389: (p_module_name => 'PER_PREV_JOB_EXTRA_INFO'
390: ,p_hook_type => 'AU');

Line 388: hr_api.cannot_find_prog_unit_error

384: exception
385: --
386: when hr_api.cannot_find_prog_unit then
387: --
388: hr_api.cannot_find_prog_unit_error
389: (p_module_name => 'PER_PREV_JOB_EXTRA_INFO'
390: ,p_hook_type => 'AU');
391: --
392: end;

Line 451: If (p_rec.previous_job_id = hr_api.g_number) then

447: -- p_rec plsql record structure
448: -- to see if a system default is being used. If a system default
449: -- is being used then we must set to the 'current' argument value.
450: --
451: If (p_rec.previous_job_id = hr_api.g_number) then
452: p_rec.previous_job_id :=
453: per_pji_shd.g_old_rec.previous_job_id;
454: End If;
455: If (p_rec.information_type = hr_api.g_varchar2) then

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

451: If (p_rec.previous_job_id = hr_api.g_number) then
452: p_rec.previous_job_id :=
453: per_pji_shd.g_old_rec.previous_job_id;
454: End If;
455: If (p_rec.information_type = hr_api.g_varchar2) then
456: p_rec.information_type :=
457: per_pji_shd.g_old_rec.information_type;
458: End If;
459: If (p_rec.pji_attribute_category = hr_api.g_varchar2) then

Line 459: If (p_rec.pji_attribute_category = hr_api.g_varchar2) then

455: If (p_rec.information_type = hr_api.g_varchar2) then
456: p_rec.information_type :=
457: per_pji_shd.g_old_rec.information_type;
458: End If;
459: If (p_rec.pji_attribute_category = hr_api.g_varchar2) then
460: p_rec.pji_attribute_category :=
461: per_pji_shd.g_old_rec.pji_attribute_category;
462: End If;
463: If (p_rec.pji_attribute1 = hr_api.g_varchar2) then

Line 463: If (p_rec.pji_attribute1 = hr_api.g_varchar2) then

459: If (p_rec.pji_attribute_category = hr_api.g_varchar2) then
460: p_rec.pji_attribute_category :=
461: per_pji_shd.g_old_rec.pji_attribute_category;
462: End If;
463: If (p_rec.pji_attribute1 = hr_api.g_varchar2) then
464: p_rec.pji_attribute1 :=
465: per_pji_shd.g_old_rec.pji_attribute1;
466: End If;
467: If (p_rec.pji_attribute2 = hr_api.g_varchar2) then

Line 467: If (p_rec.pji_attribute2 = hr_api.g_varchar2) then

463: If (p_rec.pji_attribute1 = hr_api.g_varchar2) then
464: p_rec.pji_attribute1 :=
465: per_pji_shd.g_old_rec.pji_attribute1;
466: End If;
467: If (p_rec.pji_attribute2 = hr_api.g_varchar2) then
468: p_rec.pji_attribute2 :=
469: per_pji_shd.g_old_rec.pji_attribute2;
470: End If;
471: If (p_rec.pji_attribute3 = hr_api.g_varchar2) then

Line 471: If (p_rec.pji_attribute3 = hr_api.g_varchar2) then

467: If (p_rec.pji_attribute2 = hr_api.g_varchar2) then
468: p_rec.pji_attribute2 :=
469: per_pji_shd.g_old_rec.pji_attribute2;
470: End If;
471: If (p_rec.pji_attribute3 = hr_api.g_varchar2) then
472: p_rec.pji_attribute3 :=
473: per_pji_shd.g_old_rec.pji_attribute3;
474: End If;
475: If (p_rec.pji_attribute4 = hr_api.g_varchar2) then

Line 475: If (p_rec.pji_attribute4 = hr_api.g_varchar2) then

471: If (p_rec.pji_attribute3 = hr_api.g_varchar2) then
472: p_rec.pji_attribute3 :=
473: per_pji_shd.g_old_rec.pji_attribute3;
474: End If;
475: If (p_rec.pji_attribute4 = hr_api.g_varchar2) then
476: p_rec.pji_attribute4 :=
477: per_pji_shd.g_old_rec.pji_attribute4;
478: End If;
479: If (p_rec.pji_attribute5 = hr_api.g_varchar2) then

Line 479: If (p_rec.pji_attribute5 = hr_api.g_varchar2) then

475: If (p_rec.pji_attribute4 = hr_api.g_varchar2) then
476: p_rec.pji_attribute4 :=
477: per_pji_shd.g_old_rec.pji_attribute4;
478: End If;
479: If (p_rec.pji_attribute5 = hr_api.g_varchar2) then
480: p_rec.pji_attribute5 :=
481: per_pji_shd.g_old_rec.pji_attribute5;
482: End If;
483: If (p_rec.pji_attribute6 = hr_api.g_varchar2) then

Line 483: If (p_rec.pji_attribute6 = hr_api.g_varchar2) then

479: If (p_rec.pji_attribute5 = hr_api.g_varchar2) then
480: p_rec.pji_attribute5 :=
481: per_pji_shd.g_old_rec.pji_attribute5;
482: End If;
483: If (p_rec.pji_attribute6 = hr_api.g_varchar2) then
484: p_rec.pji_attribute6 :=
485: per_pji_shd.g_old_rec.pji_attribute6;
486: End If;
487: If (p_rec.pji_attribute7 = hr_api.g_varchar2) then

Line 487: If (p_rec.pji_attribute7 = hr_api.g_varchar2) then

483: If (p_rec.pji_attribute6 = hr_api.g_varchar2) then
484: p_rec.pji_attribute6 :=
485: per_pji_shd.g_old_rec.pji_attribute6;
486: End If;
487: If (p_rec.pji_attribute7 = hr_api.g_varchar2) then
488: p_rec.pji_attribute7 :=
489: per_pji_shd.g_old_rec.pji_attribute7;
490: End If;
491: If (p_rec.pji_attribute8 = hr_api.g_varchar2) then

Line 491: If (p_rec.pji_attribute8 = hr_api.g_varchar2) then

487: If (p_rec.pji_attribute7 = hr_api.g_varchar2) then
488: p_rec.pji_attribute7 :=
489: per_pji_shd.g_old_rec.pji_attribute7;
490: End If;
491: If (p_rec.pji_attribute8 = hr_api.g_varchar2) then
492: p_rec.pji_attribute8 :=
493: per_pji_shd.g_old_rec.pji_attribute8;
494: End If;
495: If (p_rec.pji_attribute9 = hr_api.g_varchar2) then

Line 495: If (p_rec.pji_attribute9 = hr_api.g_varchar2) then

491: If (p_rec.pji_attribute8 = hr_api.g_varchar2) then
492: p_rec.pji_attribute8 :=
493: per_pji_shd.g_old_rec.pji_attribute8;
494: End If;
495: If (p_rec.pji_attribute9 = hr_api.g_varchar2) then
496: p_rec.pji_attribute9 :=
497: per_pji_shd.g_old_rec.pji_attribute9;
498: End If;
499: If (p_rec.pji_attribute10 = hr_api.g_varchar2) then

Line 499: If (p_rec.pji_attribute10 = hr_api.g_varchar2) then

495: If (p_rec.pji_attribute9 = hr_api.g_varchar2) then
496: p_rec.pji_attribute9 :=
497: per_pji_shd.g_old_rec.pji_attribute9;
498: End If;
499: If (p_rec.pji_attribute10 = hr_api.g_varchar2) then
500: p_rec.pji_attribute10 :=
501: per_pji_shd.g_old_rec.pji_attribute10;
502: End If;
503: If (p_rec.pji_attribute11 = hr_api.g_varchar2) then

Line 503: If (p_rec.pji_attribute11 = hr_api.g_varchar2) then

499: If (p_rec.pji_attribute10 = hr_api.g_varchar2) then
500: p_rec.pji_attribute10 :=
501: per_pji_shd.g_old_rec.pji_attribute10;
502: End If;
503: If (p_rec.pji_attribute11 = hr_api.g_varchar2) then
504: p_rec.pji_attribute11 :=
505: per_pji_shd.g_old_rec.pji_attribute11;
506: End If;
507: If (p_rec.pji_attribute12 = hr_api.g_varchar2) then

Line 507: If (p_rec.pji_attribute12 = hr_api.g_varchar2) then

503: If (p_rec.pji_attribute11 = hr_api.g_varchar2) then
504: p_rec.pji_attribute11 :=
505: per_pji_shd.g_old_rec.pji_attribute11;
506: End If;
507: If (p_rec.pji_attribute12 = hr_api.g_varchar2) then
508: p_rec.pji_attribute12 :=
509: per_pji_shd.g_old_rec.pji_attribute12;
510: End If;
511: If (p_rec.pji_attribute13 = hr_api.g_varchar2) then

Line 511: If (p_rec.pji_attribute13 = hr_api.g_varchar2) then

507: If (p_rec.pji_attribute12 = hr_api.g_varchar2) then
508: p_rec.pji_attribute12 :=
509: per_pji_shd.g_old_rec.pji_attribute12;
510: End If;
511: If (p_rec.pji_attribute13 = hr_api.g_varchar2) then
512: p_rec.pji_attribute13 :=
513: per_pji_shd.g_old_rec.pji_attribute13;
514: End If;
515: If (p_rec.pji_attribute14 = hr_api.g_varchar2) then

Line 515: If (p_rec.pji_attribute14 = hr_api.g_varchar2) then

511: If (p_rec.pji_attribute13 = hr_api.g_varchar2) then
512: p_rec.pji_attribute13 :=
513: per_pji_shd.g_old_rec.pji_attribute13;
514: End If;
515: If (p_rec.pji_attribute14 = hr_api.g_varchar2) then
516: p_rec.pji_attribute14 :=
517: per_pji_shd.g_old_rec.pji_attribute14;
518: End If;
519: If (p_rec.pji_attribute15 = hr_api.g_varchar2) then

Line 519: If (p_rec.pji_attribute15 = hr_api.g_varchar2) then

515: If (p_rec.pji_attribute14 = hr_api.g_varchar2) then
516: p_rec.pji_attribute14 :=
517: per_pji_shd.g_old_rec.pji_attribute14;
518: End If;
519: If (p_rec.pji_attribute15 = hr_api.g_varchar2) then
520: p_rec.pji_attribute15 :=
521: per_pji_shd.g_old_rec.pji_attribute15;
522: End If;
523: If (p_rec.pji_attribute16 = hr_api.g_varchar2) then

Line 523: If (p_rec.pji_attribute16 = hr_api.g_varchar2) then

519: If (p_rec.pji_attribute15 = hr_api.g_varchar2) then
520: p_rec.pji_attribute15 :=
521: per_pji_shd.g_old_rec.pji_attribute15;
522: End If;
523: If (p_rec.pji_attribute16 = hr_api.g_varchar2) then
524: p_rec.pji_attribute16 :=
525: per_pji_shd.g_old_rec.pji_attribute16;
526: End If;
527: If (p_rec.pji_attribute17 = hr_api.g_varchar2) then

Line 527: If (p_rec.pji_attribute17 = hr_api.g_varchar2) then

523: If (p_rec.pji_attribute16 = hr_api.g_varchar2) then
524: p_rec.pji_attribute16 :=
525: per_pji_shd.g_old_rec.pji_attribute16;
526: End If;
527: If (p_rec.pji_attribute17 = hr_api.g_varchar2) then
528: p_rec.pji_attribute17 :=
529: per_pji_shd.g_old_rec.pji_attribute17;
530: End If;
531: If (p_rec.pji_attribute18 = hr_api.g_varchar2) then

Line 531: If (p_rec.pji_attribute18 = hr_api.g_varchar2) then

527: If (p_rec.pji_attribute17 = hr_api.g_varchar2) then
528: p_rec.pji_attribute17 :=
529: per_pji_shd.g_old_rec.pji_attribute17;
530: End If;
531: If (p_rec.pji_attribute18 = hr_api.g_varchar2) then
532: p_rec.pji_attribute18 :=
533: per_pji_shd.g_old_rec.pji_attribute18;
534: End If;
535: If (p_rec.pji_attribute19 = hr_api.g_varchar2) then

Line 535: If (p_rec.pji_attribute19 = hr_api.g_varchar2) then

531: If (p_rec.pji_attribute18 = hr_api.g_varchar2) then
532: p_rec.pji_attribute18 :=
533: per_pji_shd.g_old_rec.pji_attribute18;
534: End If;
535: If (p_rec.pji_attribute19 = hr_api.g_varchar2) then
536: p_rec.pji_attribute19 :=
537: per_pji_shd.g_old_rec.pji_attribute19;
538: End If;
539: If (p_rec.pji_attribute20 = hr_api.g_varchar2) then

Line 539: If (p_rec.pji_attribute20 = hr_api.g_varchar2) then

535: If (p_rec.pji_attribute19 = hr_api.g_varchar2) then
536: p_rec.pji_attribute19 :=
537: per_pji_shd.g_old_rec.pji_attribute19;
538: End If;
539: If (p_rec.pji_attribute20 = hr_api.g_varchar2) then
540: p_rec.pji_attribute20 :=
541: per_pji_shd.g_old_rec.pji_attribute20;
542: End If;
543: If (p_rec.pji_attribute21 = hr_api.g_varchar2) then

Line 543: If (p_rec.pji_attribute21 = hr_api.g_varchar2) then

539: If (p_rec.pji_attribute20 = hr_api.g_varchar2) then
540: p_rec.pji_attribute20 :=
541: per_pji_shd.g_old_rec.pji_attribute20;
542: End If;
543: If (p_rec.pji_attribute21 = hr_api.g_varchar2) then
544: p_rec.pji_attribute21 :=
545: per_pji_shd.g_old_rec.pji_attribute21;
546: End If;
547: If (p_rec.pji_attribute22 = hr_api.g_varchar2) then

Line 547: If (p_rec.pji_attribute22 = hr_api.g_varchar2) then

543: If (p_rec.pji_attribute21 = hr_api.g_varchar2) then
544: p_rec.pji_attribute21 :=
545: per_pji_shd.g_old_rec.pji_attribute21;
546: End If;
547: If (p_rec.pji_attribute22 = hr_api.g_varchar2) then
548: p_rec.pji_attribute22 :=
549: per_pji_shd.g_old_rec.pji_attribute22;
550: End If;
551: If (p_rec.pji_attribute23 = hr_api.g_varchar2) then

Line 551: If (p_rec.pji_attribute23 = hr_api.g_varchar2) then

547: If (p_rec.pji_attribute22 = hr_api.g_varchar2) then
548: p_rec.pji_attribute22 :=
549: per_pji_shd.g_old_rec.pji_attribute22;
550: End If;
551: If (p_rec.pji_attribute23 = hr_api.g_varchar2) then
552: p_rec.pji_attribute23 :=
553: per_pji_shd.g_old_rec.pji_attribute23;
554: End If;
555: If (p_rec.pji_attribute24 = hr_api.g_varchar2) then

Line 555: If (p_rec.pji_attribute24 = hr_api.g_varchar2) then

551: If (p_rec.pji_attribute23 = hr_api.g_varchar2) then
552: p_rec.pji_attribute23 :=
553: per_pji_shd.g_old_rec.pji_attribute23;
554: End If;
555: If (p_rec.pji_attribute24 = hr_api.g_varchar2) then
556: p_rec.pji_attribute24 :=
557: per_pji_shd.g_old_rec.pji_attribute24;
558: End If;
559: If (p_rec.pji_attribute25 = hr_api.g_varchar2) then

Line 559: If (p_rec.pji_attribute25 = hr_api.g_varchar2) then

555: If (p_rec.pji_attribute24 = hr_api.g_varchar2) then
556: p_rec.pji_attribute24 :=
557: per_pji_shd.g_old_rec.pji_attribute24;
558: End If;
559: If (p_rec.pji_attribute25 = hr_api.g_varchar2) then
560: p_rec.pji_attribute25 :=
561: per_pji_shd.g_old_rec.pji_attribute25;
562: End If;
563: If (p_rec.pji_attribute26 = hr_api.g_varchar2) then

Line 563: If (p_rec.pji_attribute26 = hr_api.g_varchar2) then

559: If (p_rec.pji_attribute25 = hr_api.g_varchar2) then
560: p_rec.pji_attribute25 :=
561: per_pji_shd.g_old_rec.pji_attribute25;
562: End If;
563: If (p_rec.pji_attribute26 = hr_api.g_varchar2) then
564: p_rec.pji_attribute26 :=
565: per_pji_shd.g_old_rec.pji_attribute26;
566: End If;
567: If (p_rec.pji_attribute27 = hr_api.g_varchar2) then

Line 567: If (p_rec.pji_attribute27 = hr_api.g_varchar2) then

563: If (p_rec.pji_attribute26 = hr_api.g_varchar2) then
564: p_rec.pji_attribute26 :=
565: per_pji_shd.g_old_rec.pji_attribute26;
566: End If;
567: If (p_rec.pji_attribute27 = hr_api.g_varchar2) then
568: p_rec.pji_attribute27 :=
569: per_pji_shd.g_old_rec.pji_attribute27;
570: End If;
571: If (p_rec.pji_attribute28 = hr_api.g_varchar2) then

Line 571: If (p_rec.pji_attribute28 = hr_api.g_varchar2) then

567: If (p_rec.pji_attribute27 = hr_api.g_varchar2) then
568: p_rec.pji_attribute27 :=
569: per_pji_shd.g_old_rec.pji_attribute27;
570: End If;
571: If (p_rec.pji_attribute28 = hr_api.g_varchar2) then
572: p_rec.pji_attribute28 :=
573: per_pji_shd.g_old_rec.pji_attribute28;
574: End If;
575: If (p_rec.pji_attribute29 = hr_api.g_varchar2) then

Line 575: If (p_rec.pji_attribute29 = hr_api.g_varchar2) then

571: If (p_rec.pji_attribute28 = hr_api.g_varchar2) then
572: p_rec.pji_attribute28 :=
573: per_pji_shd.g_old_rec.pji_attribute28;
574: End If;
575: If (p_rec.pji_attribute29 = hr_api.g_varchar2) then
576: p_rec.pji_attribute29 :=
577: per_pji_shd.g_old_rec.pji_attribute29;
578: End If;
579: If (p_rec.pji_attribute30 = hr_api.g_varchar2) then

Line 579: If (p_rec.pji_attribute30 = hr_api.g_varchar2) then

575: If (p_rec.pji_attribute29 = hr_api.g_varchar2) then
576: p_rec.pji_attribute29 :=
577: per_pji_shd.g_old_rec.pji_attribute29;
578: End If;
579: If (p_rec.pji_attribute30 = hr_api.g_varchar2) then
580: p_rec.pji_attribute30 :=
581: per_pji_shd.g_old_rec.pji_attribute30;
582: End If;
583: If (p_rec.pji_information_category = hr_api.g_varchar2) then

Line 583: If (p_rec.pji_information_category = hr_api.g_varchar2) then

579: If (p_rec.pji_attribute30 = hr_api.g_varchar2) then
580: p_rec.pji_attribute30 :=
581: per_pji_shd.g_old_rec.pji_attribute30;
582: End If;
583: If (p_rec.pji_information_category = hr_api.g_varchar2) then
584: p_rec.pji_information_category :=
585: per_pji_shd.g_old_rec.pji_information_category;
586: End If;
587: If (p_rec.pji_information1 = hr_api.g_varchar2) then

Line 587: If (p_rec.pji_information1 = hr_api.g_varchar2) then

583: If (p_rec.pji_information_category = hr_api.g_varchar2) then
584: p_rec.pji_information_category :=
585: per_pji_shd.g_old_rec.pji_information_category;
586: End If;
587: If (p_rec.pji_information1 = hr_api.g_varchar2) then
588: p_rec.pji_information1 :=
589: per_pji_shd.g_old_rec.pji_information1;
590: End If;
591: If (p_rec.pji_information2 = hr_api.g_varchar2) then

Line 591: If (p_rec.pji_information2 = hr_api.g_varchar2) then

587: If (p_rec.pji_information1 = hr_api.g_varchar2) then
588: p_rec.pji_information1 :=
589: per_pji_shd.g_old_rec.pji_information1;
590: End If;
591: If (p_rec.pji_information2 = hr_api.g_varchar2) then
592: p_rec.pji_information2 :=
593: per_pji_shd.g_old_rec.pji_information2;
594: End If;
595: If (p_rec.pji_information3 = hr_api.g_varchar2) then

Line 595: If (p_rec.pji_information3 = hr_api.g_varchar2) then

591: If (p_rec.pji_information2 = hr_api.g_varchar2) then
592: p_rec.pji_information2 :=
593: per_pji_shd.g_old_rec.pji_information2;
594: End If;
595: If (p_rec.pji_information3 = hr_api.g_varchar2) then
596: p_rec.pji_information3 :=
597: per_pji_shd.g_old_rec.pji_information3;
598: End If;
599: If (p_rec.pji_information4 = hr_api.g_varchar2) then

Line 599: If (p_rec.pji_information4 = hr_api.g_varchar2) then

595: If (p_rec.pji_information3 = hr_api.g_varchar2) then
596: p_rec.pji_information3 :=
597: per_pji_shd.g_old_rec.pji_information3;
598: End If;
599: If (p_rec.pji_information4 = hr_api.g_varchar2) then
600: p_rec.pji_information4 :=
601: per_pji_shd.g_old_rec.pji_information4;
602: End If;
603: If (p_rec.pji_information5 = hr_api.g_varchar2) then

Line 603: If (p_rec.pji_information5 = hr_api.g_varchar2) then

599: If (p_rec.pji_information4 = hr_api.g_varchar2) then
600: p_rec.pji_information4 :=
601: per_pji_shd.g_old_rec.pji_information4;
602: End If;
603: If (p_rec.pji_information5 = hr_api.g_varchar2) then
604: p_rec.pji_information5 :=
605: per_pji_shd.g_old_rec.pji_information5;
606: End If;
607: If (p_rec.pji_information6 = hr_api.g_varchar2) then

Line 607: If (p_rec.pji_information6 = hr_api.g_varchar2) then

603: If (p_rec.pji_information5 = hr_api.g_varchar2) then
604: p_rec.pji_information5 :=
605: per_pji_shd.g_old_rec.pji_information5;
606: End If;
607: If (p_rec.pji_information6 = hr_api.g_varchar2) then
608: p_rec.pji_information6 :=
609: per_pji_shd.g_old_rec.pji_information6;
610: End If;
611: If (p_rec.pji_information7 = hr_api.g_varchar2) then

Line 611: If (p_rec.pji_information7 = hr_api.g_varchar2) then

607: If (p_rec.pji_information6 = hr_api.g_varchar2) then
608: p_rec.pji_information6 :=
609: per_pji_shd.g_old_rec.pji_information6;
610: End If;
611: If (p_rec.pji_information7 = hr_api.g_varchar2) then
612: p_rec.pji_information7 :=
613: per_pji_shd.g_old_rec.pji_information7;
614: End If;
615: If (p_rec.pji_information8 = hr_api.g_varchar2) then

Line 615: If (p_rec.pji_information8 = hr_api.g_varchar2) then

611: If (p_rec.pji_information7 = hr_api.g_varchar2) then
612: p_rec.pji_information7 :=
613: per_pji_shd.g_old_rec.pji_information7;
614: End If;
615: If (p_rec.pji_information8 = hr_api.g_varchar2) then
616: p_rec.pji_information8 :=
617: per_pji_shd.g_old_rec.pji_information8;
618: End If;
619: If (p_rec.pji_information9 = hr_api.g_varchar2) then

Line 619: If (p_rec.pji_information9 = hr_api.g_varchar2) then

615: If (p_rec.pji_information8 = hr_api.g_varchar2) then
616: p_rec.pji_information8 :=
617: per_pji_shd.g_old_rec.pji_information8;
618: End If;
619: If (p_rec.pji_information9 = hr_api.g_varchar2) then
620: p_rec.pji_information9 :=
621: per_pji_shd.g_old_rec.pji_information9;
622: End If;
623: If (p_rec.pji_information10 = hr_api.g_varchar2) then

Line 623: If (p_rec.pji_information10 = hr_api.g_varchar2) then

619: If (p_rec.pji_information9 = hr_api.g_varchar2) then
620: p_rec.pji_information9 :=
621: per_pji_shd.g_old_rec.pji_information9;
622: End If;
623: If (p_rec.pji_information10 = hr_api.g_varchar2) then
624: p_rec.pji_information10 :=
625: per_pji_shd.g_old_rec.pji_information10;
626: End If;
627: If (p_rec.pji_information11 = hr_api.g_varchar2) then

Line 627: If (p_rec.pji_information11 = hr_api.g_varchar2) then

623: If (p_rec.pji_information10 = hr_api.g_varchar2) then
624: p_rec.pji_information10 :=
625: per_pji_shd.g_old_rec.pji_information10;
626: End If;
627: If (p_rec.pji_information11 = hr_api.g_varchar2) then
628: p_rec.pji_information11 :=
629: per_pji_shd.g_old_rec.pji_information11;
630: End If;
631: If (p_rec.pji_information12 = hr_api.g_varchar2) then

Line 631: If (p_rec.pji_information12 = hr_api.g_varchar2) then

627: If (p_rec.pji_information11 = hr_api.g_varchar2) then
628: p_rec.pji_information11 :=
629: per_pji_shd.g_old_rec.pji_information11;
630: End If;
631: If (p_rec.pji_information12 = hr_api.g_varchar2) then
632: p_rec.pji_information12 :=
633: per_pji_shd.g_old_rec.pji_information12;
634: End If;
635: If (p_rec.pji_information13 = hr_api.g_varchar2) then

Line 635: If (p_rec.pji_information13 = hr_api.g_varchar2) then

631: If (p_rec.pji_information12 = hr_api.g_varchar2) then
632: p_rec.pji_information12 :=
633: per_pji_shd.g_old_rec.pji_information12;
634: End If;
635: If (p_rec.pji_information13 = hr_api.g_varchar2) then
636: p_rec.pji_information13 :=
637: per_pji_shd.g_old_rec.pji_information13;
638: End If;
639: If (p_rec.pji_information14 = hr_api.g_varchar2) then

Line 639: If (p_rec.pji_information14 = hr_api.g_varchar2) then

635: If (p_rec.pji_information13 = hr_api.g_varchar2) then
636: p_rec.pji_information13 :=
637: per_pji_shd.g_old_rec.pji_information13;
638: End If;
639: If (p_rec.pji_information14 = hr_api.g_varchar2) then
640: p_rec.pji_information14 :=
641: per_pji_shd.g_old_rec.pji_information14;
642: End If;
643: If (p_rec.pji_information15 = hr_api.g_varchar2) then

Line 643: If (p_rec.pji_information15 = hr_api.g_varchar2) then

639: If (p_rec.pji_information14 = hr_api.g_varchar2) then
640: p_rec.pji_information14 :=
641: per_pji_shd.g_old_rec.pji_information14;
642: End If;
643: If (p_rec.pji_information15 = hr_api.g_varchar2) then
644: p_rec.pji_information15 :=
645: per_pji_shd.g_old_rec.pji_information15;
646: End If;
647: If (p_rec.pji_information16 = hr_api.g_varchar2) then

Line 647: If (p_rec.pji_information16 = hr_api.g_varchar2) then

643: If (p_rec.pji_information15 = hr_api.g_varchar2) then
644: p_rec.pji_information15 :=
645: per_pji_shd.g_old_rec.pji_information15;
646: End If;
647: If (p_rec.pji_information16 = hr_api.g_varchar2) then
648: p_rec.pji_information16 :=
649: per_pji_shd.g_old_rec.pji_information16;
650: End If;
651: If (p_rec.pji_information17 = hr_api.g_varchar2) then

Line 651: If (p_rec.pji_information17 = hr_api.g_varchar2) then

647: If (p_rec.pji_information16 = hr_api.g_varchar2) then
648: p_rec.pji_information16 :=
649: per_pji_shd.g_old_rec.pji_information16;
650: End If;
651: If (p_rec.pji_information17 = hr_api.g_varchar2) then
652: p_rec.pji_information17 :=
653: per_pji_shd.g_old_rec.pji_information17;
654: End If;
655: If (p_rec.pji_information18 = hr_api.g_varchar2) then

Line 655: If (p_rec.pji_information18 = hr_api.g_varchar2) then

651: If (p_rec.pji_information17 = hr_api.g_varchar2) then
652: p_rec.pji_information17 :=
653: per_pji_shd.g_old_rec.pji_information17;
654: End If;
655: If (p_rec.pji_information18 = hr_api.g_varchar2) then
656: p_rec.pji_information18 :=
657: per_pji_shd.g_old_rec.pji_information18;
658: End If;
659: If (p_rec.pji_information19 = hr_api.g_varchar2) then

Line 659: If (p_rec.pji_information19 = hr_api.g_varchar2) then

655: If (p_rec.pji_information18 = hr_api.g_varchar2) then
656: p_rec.pji_information18 :=
657: per_pji_shd.g_old_rec.pji_information18;
658: End If;
659: If (p_rec.pji_information19 = hr_api.g_varchar2) then
660: p_rec.pji_information19 :=
661: per_pji_shd.g_old_rec.pji_information19;
662: End If;
663: If (p_rec.pji_information20 = hr_api.g_varchar2) then

Line 663: If (p_rec.pji_information20 = hr_api.g_varchar2) then

659: If (p_rec.pji_information19 = hr_api.g_varchar2) then
660: p_rec.pji_information19 :=
661: per_pji_shd.g_old_rec.pji_information19;
662: End If;
663: If (p_rec.pji_information20 = hr_api.g_varchar2) then
664: p_rec.pji_information20 :=
665: per_pji_shd.g_old_rec.pji_information20;
666: End If;
667: If (p_rec.pji_information21 = hr_api.g_varchar2) then

Line 667: If (p_rec.pji_information21 = hr_api.g_varchar2) then

663: If (p_rec.pji_information20 = hr_api.g_varchar2) then
664: p_rec.pji_information20 :=
665: per_pji_shd.g_old_rec.pji_information20;
666: End If;
667: If (p_rec.pji_information21 = hr_api.g_varchar2) then
668: p_rec.pji_information21 :=
669: per_pji_shd.g_old_rec.pji_information21;
670: End If;
671: If (p_rec.pji_information22 = hr_api.g_varchar2) then

Line 671: If (p_rec.pji_information22 = hr_api.g_varchar2) then

667: If (p_rec.pji_information21 = hr_api.g_varchar2) then
668: p_rec.pji_information21 :=
669: per_pji_shd.g_old_rec.pji_information21;
670: End If;
671: If (p_rec.pji_information22 = hr_api.g_varchar2) then
672: p_rec.pji_information22 :=
673: per_pji_shd.g_old_rec.pji_information22;
674: End If;
675: If (p_rec.pji_information23 = hr_api.g_varchar2) then

Line 675: If (p_rec.pji_information23 = hr_api.g_varchar2) then

671: If (p_rec.pji_information22 = hr_api.g_varchar2) then
672: p_rec.pji_information22 :=
673: per_pji_shd.g_old_rec.pji_information22;
674: End If;
675: If (p_rec.pji_information23 = hr_api.g_varchar2) then
676: p_rec.pji_information23 :=
677: per_pji_shd.g_old_rec.pji_information23;
678: End If;
679: If (p_rec.pji_information24 = hr_api.g_varchar2) then

Line 679: If (p_rec.pji_information24 = hr_api.g_varchar2) then

675: If (p_rec.pji_information23 = hr_api.g_varchar2) then
676: p_rec.pji_information23 :=
677: per_pji_shd.g_old_rec.pji_information23;
678: End If;
679: If (p_rec.pji_information24 = hr_api.g_varchar2) then
680: p_rec.pji_information24 :=
681: per_pji_shd.g_old_rec.pji_information24;
682: End If;
683: If (p_rec.pji_information25 = hr_api.g_varchar2) then

Line 683: If (p_rec.pji_information25 = hr_api.g_varchar2) then

679: If (p_rec.pji_information24 = hr_api.g_varchar2) then
680: p_rec.pji_information24 :=
681: per_pji_shd.g_old_rec.pji_information24;
682: End If;
683: If (p_rec.pji_information25 = hr_api.g_varchar2) then
684: p_rec.pji_information25 :=
685: per_pji_shd.g_old_rec.pji_information25;
686: End If;
687: If (p_rec.pji_information26 = hr_api.g_varchar2) then

Line 687: If (p_rec.pji_information26 = hr_api.g_varchar2) then

683: If (p_rec.pji_information25 = hr_api.g_varchar2) then
684: p_rec.pji_information25 :=
685: per_pji_shd.g_old_rec.pji_information25;
686: End If;
687: If (p_rec.pji_information26 = hr_api.g_varchar2) then
688: p_rec.pji_information26 :=
689: per_pji_shd.g_old_rec.pji_information26;
690: End If;
691: If (p_rec.pji_information27 = hr_api.g_varchar2) then

Line 691: If (p_rec.pji_information27 = hr_api.g_varchar2) then

687: If (p_rec.pji_information26 = hr_api.g_varchar2) then
688: p_rec.pji_information26 :=
689: per_pji_shd.g_old_rec.pji_information26;
690: End If;
691: If (p_rec.pji_information27 = hr_api.g_varchar2) then
692: p_rec.pji_information27 :=
693: per_pji_shd.g_old_rec.pji_information27;
694: End If;
695: If (p_rec.pji_information28 = hr_api.g_varchar2) then

Line 695: If (p_rec.pji_information28 = hr_api.g_varchar2) then

691: If (p_rec.pji_information27 = hr_api.g_varchar2) then
692: p_rec.pji_information27 :=
693: per_pji_shd.g_old_rec.pji_information27;
694: End If;
695: If (p_rec.pji_information28 = hr_api.g_varchar2) then
696: p_rec.pji_information28 :=
697: per_pji_shd.g_old_rec.pji_information28;
698: End If;
699: If (p_rec.pji_information29 = hr_api.g_varchar2) then

Line 699: If (p_rec.pji_information29 = hr_api.g_varchar2) then

695: If (p_rec.pji_information28 = hr_api.g_varchar2) then
696: p_rec.pji_information28 :=
697: per_pji_shd.g_old_rec.pji_information28;
698: End If;
699: If (p_rec.pji_information29 = hr_api.g_varchar2) then
700: p_rec.pji_information29 :=
701: per_pji_shd.g_old_rec.pji_information29;
702: End If;
703: If (p_rec.pji_information30 = hr_api.g_varchar2) then

Line 703: If (p_rec.pji_information30 = hr_api.g_varchar2) then

699: If (p_rec.pji_information29 = hr_api.g_varchar2) then
700: p_rec.pji_information29 :=
701: per_pji_shd.g_old_rec.pji_information29;
702: End If;
703: If (p_rec.pji_information30 = hr_api.g_varchar2) then
704: p_rec.pji_information30 :=
705: per_pji_shd.g_old_rec.pji_information30;
706: End If;
707: --

Line 761: ,p_previous_job_id in number default hr_api.g_number

757: -- ----------------------------------------------------------------------------
758: Procedure upd
759: (p_previous_job_extra_info_id in number
760: ,p_object_version_number in out nocopy number
761: ,p_previous_job_id in number default hr_api.g_number
762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2

Line 762: ,p_information_type in varchar2 default hr_api.g_varchar2

758: Procedure upd
759: (p_previous_job_extra_info_id in number
760: ,p_object_version_number in out nocopy number
761: ,p_previous_job_id in number default hr_api.g_number
762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2

Line 763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2

759: (p_previous_job_extra_info_id in number
760: ,p_object_version_number in out nocopy number
761: ,p_previous_job_id in number default hr_api.g_number
762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2

Line 764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2

760: ,p_object_version_number in out nocopy number
761: ,p_previous_job_id in number default hr_api.g_number
762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2

Line 765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2

761: ,p_previous_job_id in number default hr_api.g_number
762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2

Line 766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2

762: ,p_information_type in varchar2 default hr_api.g_varchar2
763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2

Line 767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2

763: ,p_pji_attribute_category in varchar2 default hr_api.g_varchar2
764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2

Line 768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2

764: ,p_pji_attribute1 in varchar2 default hr_api.g_varchar2
765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2

Line 769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2

765: ,p_pji_attribute2 in varchar2 default hr_api.g_varchar2
766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2

Line 770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2

766: ,p_pji_attribute3 in varchar2 default hr_api.g_varchar2
767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2

Line 771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2

767: ,p_pji_attribute4 in varchar2 default hr_api.g_varchar2
768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2

Line 772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2

768: ,p_pji_attribute5 in varchar2 default hr_api.g_varchar2
769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2

Line 773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2

769: ,p_pji_attribute6 in varchar2 default hr_api.g_varchar2
770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2

Line 774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2

770: ,p_pji_attribute7 in varchar2 default hr_api.g_varchar2
771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2

Line 775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2

771: ,p_pji_attribute8 in varchar2 default hr_api.g_varchar2
772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2

Line 776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2

772: ,p_pji_attribute9 in varchar2 default hr_api.g_varchar2
773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2

Line 777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2

773: ,p_pji_attribute10 in varchar2 default hr_api.g_varchar2
774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2

Line 778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2

774: ,p_pji_attribute11 in varchar2 default hr_api.g_varchar2
775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2

Line 779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2

775: ,p_pji_attribute12 in varchar2 default hr_api.g_varchar2
776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2

Line 780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2

776: ,p_pji_attribute13 in varchar2 default hr_api.g_varchar2
777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2

Line 781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2

777: ,p_pji_attribute14 in varchar2 default hr_api.g_varchar2
778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2

Line 782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2

778: ,p_pji_attribute15 in varchar2 default hr_api.g_varchar2
779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2

Line 783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2

779: ,p_pji_attribute16 in varchar2 default hr_api.g_varchar2
780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2

Line 784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2

780: ,p_pji_attribute17 in varchar2 default hr_api.g_varchar2
781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2

Line 785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2

781: ,p_pji_attribute18 in varchar2 default hr_api.g_varchar2
782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2

Line 786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2

782: ,p_pji_attribute19 in varchar2 default hr_api.g_varchar2
783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2

Line 787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2

783: ,p_pji_attribute20 in varchar2 default hr_api.g_varchar2
784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2

Line 788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2

784: ,p_pji_attribute21 in varchar2 default hr_api.g_varchar2
785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2

Line 789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2

785: ,p_pji_attribute22 in varchar2 default hr_api.g_varchar2
786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2

Line 790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2

786: ,p_pji_attribute23 in varchar2 default hr_api.g_varchar2
787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2

Line 791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2

787: ,p_pji_attribute24 in varchar2 default hr_api.g_varchar2
788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2

Line 792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2

788: ,p_pji_attribute25 in varchar2 default hr_api.g_varchar2
789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2

Line 793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2

789: ,p_pji_attribute26 in varchar2 default hr_api.g_varchar2
790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2

Line 794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2

790: ,p_pji_attribute27 in varchar2 default hr_api.g_varchar2
791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2

Line 795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2

791: ,p_pji_attribute28 in varchar2 default hr_api.g_varchar2
792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2

Line 796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2

792: ,p_pji_attribute29 in varchar2 default hr_api.g_varchar2
793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2

Line 797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2

793: ,p_pji_attribute30 in varchar2 default hr_api.g_varchar2
794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2

Line 798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2

794: ,p_pji_information_category in varchar2 default hr_api.g_varchar2
795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2

Line 799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2

795: ,p_pji_information1 in varchar2 default hr_api.g_varchar2
796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2

Line 800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2

796: ,p_pji_information2 in varchar2 default hr_api.g_varchar2
797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2

Line 801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2

797: ,p_pji_information3 in varchar2 default hr_api.g_varchar2
798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2

Line 802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2

798: ,p_pji_information4 in varchar2 default hr_api.g_varchar2
799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2

Line 803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2

799: ,p_pji_information5 in varchar2 default hr_api.g_varchar2
800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2

Line 804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2

800: ,p_pji_information6 in varchar2 default hr_api.g_varchar2
801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2

Line 805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2

801: ,p_pji_information7 in varchar2 default hr_api.g_varchar2
802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2

Line 806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2

802: ,p_pji_information8 in varchar2 default hr_api.g_varchar2
803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2

Line 807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2

803: ,p_pji_information9 in varchar2 default hr_api.g_varchar2
804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2

Line 808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2

804: ,p_pji_information10 in varchar2 default hr_api.g_varchar2
805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2

Line 809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2

805: ,p_pji_information11 in varchar2 default hr_api.g_varchar2
806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2

Line 810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2

806: ,p_pji_information12 in varchar2 default hr_api.g_varchar2
807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2

Line 811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2

807: ,p_pji_information13 in varchar2 default hr_api.g_varchar2
808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2

Line 812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2

808: ,p_pji_information14 in varchar2 default hr_api.g_varchar2
809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2

Line 813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2

809: ,p_pji_information15 in varchar2 default hr_api.g_varchar2
810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2

Line 814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2

810: ,p_pji_information16 in varchar2 default hr_api.g_varchar2
811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2

Line 815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2

811: ,p_pji_information17 in varchar2 default hr_api.g_varchar2
812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2

Line 816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2

812: ,p_pji_information18 in varchar2 default hr_api.g_varchar2
813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2

Line 817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2

813: ,p_pji_information19 in varchar2 default hr_api.g_varchar2
814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2

Line 818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2

814: ,p_pji_information20 in varchar2 default hr_api.g_varchar2
815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2

Line 819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2

815: ,p_pji_information21 in varchar2 default hr_api.g_varchar2
816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2

Line 820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2

816: ,p_pji_information22 in varchar2 default hr_api.g_varchar2
817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2
824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2

Line 821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2

817: ,p_pji_information23 in varchar2 default hr_api.g_varchar2
818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2
824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2
825: ) is

Line 822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2

818: ,p_pji_information24 in varchar2 default hr_api.g_varchar2
819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2
824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2
825: ) is
826: --

Line 823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2

819: ,p_pji_information25 in varchar2 default hr_api.g_varchar2
820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2
824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2
825: ) is
826: --
827: l_rec per_pji_shd.g_rec_type;

Line 824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2

820: ,p_pji_information26 in varchar2 default hr_api.g_varchar2
821: ,p_pji_information27 in varchar2 default hr_api.g_varchar2
822: ,p_pji_information28 in varchar2 default hr_api.g_varchar2
823: ,p_pji_information29 in varchar2 default hr_api.g_varchar2
824: ,p_pji_information30 in varchar2 default hr_api.g_varchar2
825: ) is
826: --
827: l_rec per_pji_shd.g_rec_type;
828: l_proc varchar2(72) := g_package||'upd';