127: --
128: hr_utility.set_location(' Leaving:'||l_proc, 10);
129: --
130: Exception
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: per_pju_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
131: When hr_api.check_integrity_violated Then
132: -- A check constraint has been violated
133: --
134: per_pju_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
132: -- A check constraint has been violated
133: --
134: per_pju_shd.constraint_error
135: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
136: When hr_api.parent_integrity_violated Then
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pju_shd.constraint_error
137: -- Parent integrity has been violated
138: --
139: per_pju_shd.constraint_error
140: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pju_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.unique_integrity_violated Then
142: -- Unique integrity has been violated
143: --
144: per_pju_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When Others Then
147: --
148: Raise;
149: End update_dml;
342: );
343: --
344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
350: ,p_hook_type => 'AU');
344: exception
345: --
346: when hr_api.cannot_find_prog_unit then
347: --
348: hr_api.cannot_find_prog_unit_error
349: (p_module_name => 'PER_PREVIOUS_JOB_USAGES'
350: ,p_hook_type => 'AU');
351: --
352: end;
407: -- p_rec plsql record structure
408: -- to see if a system default is being used. If a system default
409: -- is being used then we must set to the 'current' argument value.
410: --
411: If (p_rec.assignment_id = hr_api.g_number) then
412: p_rec.assignment_id :=
413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
411: If (p_rec.assignment_id = hr_api.g_number) then
412: p_rec.assignment_id :=
413: per_pju_shd.g_old_rec.assignment_id;
414: End If;
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
415: If (p_rec.previous_employer_id = hr_api.g_number) then
416: p_rec.previous_employer_id :=
417: per_pju_shd.g_old_rec.previous_employer_id;
418: End If;
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
419: If (p_rec.previous_job_id = hr_api.g_number) then
420: p_rec.previous_job_id :=
421: per_pju_shd.g_old_rec.previous_job_id;
422: End If;
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
423: If (p_rec.start_date = hr_api.g_date) then
424: p_rec.start_date :=
425: per_pju_shd.g_old_rec.start_date;
426: End If;
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
427: If (p_rec.end_date = hr_api.g_date) then
428: p_rec.end_date :=
429: per_pju_shd.g_old_rec.end_date;
430: End If;
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
431: If (p_rec.period_years = hr_api.g_number) then
432: p_rec.period_years :=
433: per_pju_shd.g_old_rec.period_years;
434: End If;
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
435: If (p_rec.period_months = hr_api.g_number) then
436: p_rec.period_months :=
437: per_pju_shd.g_old_rec.period_months;
438: End If;
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
439: If (p_rec.period_days = hr_api.g_number) then
440: p_rec.period_days :=
441: per_pju_shd.g_old_rec.period_days;
442: End If;
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
443: If (p_rec.pju_attribute_category = hr_api.g_varchar2) then
444: p_rec.pju_attribute_category :=
445: per_pju_shd.g_old_rec.pju_attribute_category;
446: End If;
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
447: If (p_rec.pju_attribute1 = hr_api.g_varchar2) then
448: p_rec.pju_attribute1 :=
449: per_pju_shd.g_old_rec.pju_attribute1;
450: End If;
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
451: If (p_rec.pju_attribute2 = hr_api.g_varchar2) then
452: p_rec.pju_attribute2 :=
453: per_pju_shd.g_old_rec.pju_attribute2;
454: End If;
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
455: If (p_rec.pju_attribute3 = hr_api.g_varchar2) then
456: p_rec.pju_attribute3 :=
457: per_pju_shd.g_old_rec.pju_attribute3;
458: End If;
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
459: If (p_rec.pju_attribute4 = hr_api.g_varchar2) then
460: p_rec.pju_attribute4 :=
461: per_pju_shd.g_old_rec.pju_attribute4;
462: End If;
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
463: If (p_rec.pju_attribute5 = hr_api.g_varchar2) then
464: p_rec.pju_attribute5 :=
465: per_pju_shd.g_old_rec.pju_attribute5;
466: End If;
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
467: If (p_rec.pju_attribute6 = hr_api.g_varchar2) then
468: p_rec.pju_attribute6 :=
469: per_pju_shd.g_old_rec.pju_attribute6;
470: End If;
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
471: If (p_rec.pju_attribute7 = hr_api.g_varchar2) then
472: p_rec.pju_attribute7 :=
473: per_pju_shd.g_old_rec.pju_attribute7;
474: End If;
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
475: If (p_rec.pju_attribute8 = hr_api.g_varchar2) then
476: p_rec.pju_attribute8 :=
477: per_pju_shd.g_old_rec.pju_attribute8;
478: End If;
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
479: If (p_rec.pju_attribute9 = hr_api.g_varchar2) then
480: p_rec.pju_attribute9 :=
481: per_pju_shd.g_old_rec.pju_attribute9;
482: End If;
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
483: If (p_rec.pju_attribute10 = hr_api.g_varchar2) then
484: p_rec.pju_attribute10 :=
485: per_pju_shd.g_old_rec.pju_attribute10;
486: End If;
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
487: If (p_rec.pju_attribute11 = hr_api.g_varchar2) then
488: p_rec.pju_attribute11 :=
489: per_pju_shd.g_old_rec.pju_attribute11;
490: End If;
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
491: If (p_rec.pju_attribute12 = hr_api.g_varchar2) then
492: p_rec.pju_attribute12 :=
493: per_pju_shd.g_old_rec.pju_attribute12;
494: End If;
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
495: If (p_rec.pju_attribute13 = hr_api.g_varchar2) then
496: p_rec.pju_attribute13 :=
497: per_pju_shd.g_old_rec.pju_attribute13;
498: End If;
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
499: If (p_rec.pju_attribute14 = hr_api.g_varchar2) then
500: p_rec.pju_attribute14 :=
501: per_pju_shd.g_old_rec.pju_attribute14;
502: End If;
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
503: If (p_rec.pju_attribute15 = hr_api.g_varchar2) then
504: p_rec.pju_attribute15 :=
505: per_pju_shd.g_old_rec.pju_attribute15;
506: End If;
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
507: If (p_rec.pju_attribute16 = hr_api.g_varchar2) then
508: p_rec.pju_attribute16 :=
509: per_pju_shd.g_old_rec.pju_attribute16;
510: End If;
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
511: If (p_rec.pju_attribute17 = hr_api.g_varchar2) then
512: p_rec.pju_attribute17 :=
513: per_pju_shd.g_old_rec.pju_attribute17;
514: End If;
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
515: If (p_rec.pju_attribute18 = hr_api.g_varchar2) then
516: p_rec.pju_attribute18 :=
517: per_pju_shd.g_old_rec.pju_attribute18;
518: End If;
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
519: If (p_rec.pju_attribute19 = hr_api.g_varchar2) then
520: p_rec.pju_attribute19 :=
521: per_pju_shd.g_old_rec.pju_attribute19;
522: End If;
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
523: If (p_rec.pju_attribute20 = hr_api.g_varchar2) then
524: p_rec.pju_attribute20 :=
525: per_pju_shd.g_old_rec.pju_attribute20;
526: End If;
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
527: If (p_rec.pju_information_category = hr_api.g_varchar2) then
528: p_rec.pju_information_category :=
529: per_pju_shd.g_old_rec.pju_information_category;
530: End If;
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
531: If (p_rec.pju_information1 = hr_api.g_varchar2) then
532: p_rec.pju_information1 :=
533: per_pju_shd.g_old_rec.pju_information1;
534: End If;
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
535: If (p_rec.pju_information2 = hr_api.g_varchar2) then
536: p_rec.pju_information2 :=
537: per_pju_shd.g_old_rec.pju_information2;
538: End If;
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
539: If (p_rec.pju_information3 = hr_api.g_varchar2) then
540: p_rec.pju_information3 :=
541: per_pju_shd.g_old_rec.pju_information3;
542: End If;
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
543: If (p_rec.pju_information4 = hr_api.g_varchar2) then
544: p_rec.pju_information4 :=
545: per_pju_shd.g_old_rec.pju_information4;
546: End If;
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
547: If (p_rec.pju_information5 = hr_api.g_varchar2) then
548: p_rec.pju_information5 :=
549: per_pju_shd.g_old_rec.pju_information5;
550: End If;
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
551: If (p_rec.pju_information6 = hr_api.g_varchar2) then
552: p_rec.pju_information6 :=
553: per_pju_shd.g_old_rec.pju_information6;
554: End If;
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
555: If (p_rec.pju_information7 = hr_api.g_varchar2) then
556: p_rec.pju_information7 :=
557: per_pju_shd.g_old_rec.pju_information7;
558: End If;
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
559: If (p_rec.pju_information8 = hr_api.g_varchar2) then
560: p_rec.pju_information8 :=
561: per_pju_shd.g_old_rec.pju_information8;
562: End If;
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
563: If (p_rec.pju_information9 = hr_api.g_varchar2) then
564: p_rec.pju_information9 :=
565: per_pju_shd.g_old_rec.pju_information9;
566: End If;
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
567: If (p_rec.pju_information10 = hr_api.g_varchar2) then
568: p_rec.pju_information10 :=
569: per_pju_shd.g_old_rec.pju_information10;
570: End If;
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
571: If (p_rec.pju_information11 = hr_api.g_varchar2) then
572: p_rec.pju_information11 :=
573: per_pju_shd.g_old_rec.pju_information11;
574: End If;
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
575: If (p_rec.pju_information12 = hr_api.g_varchar2) then
576: p_rec.pju_information12 :=
577: per_pju_shd.g_old_rec.pju_information12;
578: End If;
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
579: If (p_rec.pju_information13 = hr_api.g_varchar2) then
580: p_rec.pju_information13 :=
581: per_pju_shd.g_old_rec.pju_information13;
582: End If;
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
583: If (p_rec.pju_information14 = hr_api.g_varchar2) then
584: p_rec.pju_information14 :=
585: per_pju_shd.g_old_rec.pju_information14;
586: End If;
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
587: If (p_rec.pju_information15 = hr_api.g_varchar2) then
588: p_rec.pju_information15 :=
589: per_pju_shd.g_old_rec.pju_information15;
590: End If;
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
591: If (p_rec.pju_information16 = hr_api.g_varchar2) then
592: p_rec.pju_information16 :=
593: per_pju_shd.g_old_rec.pju_information16;
594: End If;
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
595: If (p_rec.pju_information17 = hr_api.g_varchar2) then
596: p_rec.pju_information17 :=
597: per_pju_shd.g_old_rec.pju_information17;
598: End If;
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
599: If (p_rec.pju_information18 = hr_api.g_varchar2) then
600: p_rec.pju_information18 :=
601: per_pju_shd.g_old_rec.pju_information18;
602: End If;
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
603: If (p_rec.pju_information19 = hr_api.g_varchar2) then
604: p_rec.pju_information19 :=
605: per_pju_shd.g_old_rec.pju_information19;
606: End If;
607: If (p_rec.pju_information20 = hr_api.g_varchar2) then
608: p_rec.pju_information20 :=
609: per_pju_shd.g_old_rec.pju_information20;
610: End If;
611: --
661: -- ----------------------------------------------------------------------------
662: Procedure upd
663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
662: Procedure upd
663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
663: (p_previous_job_usage_id in number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
664: ,p_object_version_number in out nocopy number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
665: ,p_assignment_id in number default hr_api.g_number
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
666: ,p_previous_employer_id in number default hr_api.g_number
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
667: ,p_previous_job_id in number default hr_api.g_number
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
668: ,p_start_date in date default hr_api.g_date
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
669: ,p_end_date in date default hr_api.g_date
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
670: ,p_period_years in number default hr_api.g_number
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
671: ,p_period_months in number default hr_api.g_number
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
672: ,p_period_days in number default hr_api.g_number
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
673: ,p_pju_attribute_category in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
674: ,p_pju_attribute1 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
675: ,p_pju_attribute2 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
676: ,p_pju_attribute3 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
677: ,p_pju_attribute4 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
678: ,p_pju_attribute5 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
679: ,p_pju_attribute6 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
680: ,p_pju_attribute7 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
681: ,p_pju_attribute8 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
682: ,p_pju_attribute9 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
683: ,p_pju_attribute10 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
684: ,p_pju_attribute11 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
685: ,p_pju_attribute12 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
686: ,p_pju_attribute13 in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
687: ,p_pju_attribute14 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
688: ,p_pju_attribute15 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
689: ,p_pju_attribute16 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
690: ,p_pju_attribute17 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
691: ,p_pju_attribute18 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
692: ,p_pju_attribute19 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
693: ,p_pju_attribute20 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
694: ,p_pju_information_category in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
695: ,p_pju_information1 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
696: ,p_pju_information2 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
697: ,p_pju_information3 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
698: ,p_pju_information4 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
699: ,p_pju_information5 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
700: ,p_pju_information6 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
701: ,p_pju_information7 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
702: ,p_pju_information8 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
703: ,p_pju_information9 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
704: ,p_pju_information10 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
705: ,p_pju_information11 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
706: ,p_pju_information12 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
707: ,p_pju_information13 in varchar2 default hr_api.g_varchar2
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
708: ,p_pju_information14 in varchar2 default hr_api.g_varchar2
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
716: --
709: ,p_pju_information15 in varchar2 default hr_api.g_varchar2
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
716: --
717: l_rec per_pju_shd.g_rec_type;
710: ,p_pju_information16 in varchar2 default hr_api.g_varchar2
711: ,p_pju_information17 in varchar2 default hr_api.g_varchar2
712: ,p_pju_information18 in varchar2 default hr_api.g_varchar2
713: ,p_pju_information19 in varchar2 default hr_api.g_varchar2
714: ,p_pju_information20 in varchar2 default hr_api.g_varchar2
715: ) is
716: --
717: l_rec per_pju_shd.g_rec_type;
718: l_proc varchar2(72) := g_package||'upd';