110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_fmp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: --
117: hr_fmp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_fmp_shd.constraint_error
115: -- A check constraint has been violated
116: --
117: hr_fmp_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_fmp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: --
122: hr_fmp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_fmp_shd.constraint_error
120: -- Parent integrity has been violated
121: --
122: hr_fmp_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_fmp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: --
127: hr_fmp_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: --
131: Raise;
132: End update_dml;
367: );
368: --
369: exception
370: --
371: when hr_api.cannot_find_prog_unit then
372: --
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'HR_FORM_PROPERTIES'
375: ,p_hook_type => 'AU');
369: exception
370: --
371: when hr_api.cannot_find_prog_unit then
372: --
373: hr_api.cannot_find_prog_unit_error
374: (p_module_name => 'HR_FORM_PROPERTIES'
375: ,p_hook_type => 'AU');
376: --
377: end;
432: -- p_rec plsql record structure
433: -- to see if a system default is being used. If a system default
434: -- is being used then we must set to the 'current' argument value.
435: --
436: If (p_rec.application_id = hr_api.g_number) then
437: p_rec.application_id :=
438: hr_fmp_shd.g_old_rec.application_id;
439: End If;
440: If (p_rec.form_id = hr_api.g_number) then
436: If (p_rec.application_id = hr_api.g_number) then
437: p_rec.application_id :=
438: hr_fmp_shd.g_old_rec.application_id;
439: End If;
440: If (p_rec.form_id = hr_api.g_number) then
441: p_rec.form_id :=
442: hr_fmp_shd.g_old_rec.form_id;
443: End If;
444: If (p_rec.form_template_id = hr_api.g_number) then
440: If (p_rec.form_id = hr_api.g_number) then
441: p_rec.form_id :=
442: hr_fmp_shd.g_old_rec.form_id;
443: End If;
444: If (p_rec.form_template_id = hr_api.g_number) then
445: p_rec.form_template_id :=
446: hr_fmp_shd.g_old_rec.form_template_id;
447: End If;
448: If (p_rec.help_target = hr_api.g_varchar2) then
444: If (p_rec.form_template_id = hr_api.g_number) then
445: p_rec.form_template_id :=
446: hr_fmp_shd.g_old_rec.form_template_id;
447: End If;
448: If (p_rec.help_target = hr_api.g_varchar2) then
449: p_rec.help_target :=
450: hr_fmp_shd.g_old_rec.help_target;
451: End If;
452: If (p_rec.information_category = hr_api.g_varchar2) then
448: If (p_rec.help_target = hr_api.g_varchar2) then
449: p_rec.help_target :=
450: hr_fmp_shd.g_old_rec.help_target;
451: End If;
452: If (p_rec.information_category = hr_api.g_varchar2) then
453: p_rec.information_category :=
454: hr_fmp_shd.g_old_rec.information_category;
455: End If;
456: If (p_rec.information1 = hr_api.g_varchar2) then
452: If (p_rec.information_category = hr_api.g_varchar2) then
453: p_rec.information_category :=
454: hr_fmp_shd.g_old_rec.information_category;
455: End If;
456: If (p_rec.information1 = hr_api.g_varchar2) then
457: p_rec.information1 :=
458: hr_fmp_shd.g_old_rec.information1;
459: End If;
460: If (p_rec.information2 = hr_api.g_varchar2) then
456: If (p_rec.information1 = hr_api.g_varchar2) then
457: p_rec.information1 :=
458: hr_fmp_shd.g_old_rec.information1;
459: End If;
460: If (p_rec.information2 = hr_api.g_varchar2) then
461: p_rec.information2 :=
462: hr_fmp_shd.g_old_rec.information2;
463: End If;
464: If (p_rec.information3 = hr_api.g_varchar2) then
460: If (p_rec.information2 = hr_api.g_varchar2) then
461: p_rec.information2 :=
462: hr_fmp_shd.g_old_rec.information2;
463: End If;
464: If (p_rec.information3 = hr_api.g_varchar2) then
465: p_rec.information3 :=
466: hr_fmp_shd.g_old_rec.information3;
467: End If;
468: If (p_rec.information4 = hr_api.g_varchar2) then
464: If (p_rec.information3 = hr_api.g_varchar2) then
465: p_rec.information3 :=
466: hr_fmp_shd.g_old_rec.information3;
467: End If;
468: If (p_rec.information4 = hr_api.g_varchar2) then
469: p_rec.information4 :=
470: hr_fmp_shd.g_old_rec.information4;
471: End If;
472: If (p_rec.information5 = hr_api.g_varchar2) then
468: If (p_rec.information4 = hr_api.g_varchar2) then
469: p_rec.information4 :=
470: hr_fmp_shd.g_old_rec.information4;
471: End If;
472: If (p_rec.information5 = hr_api.g_varchar2) then
473: p_rec.information5 :=
474: hr_fmp_shd.g_old_rec.information5;
475: End If;
476: If (p_rec.information6 = hr_api.g_varchar2) then
472: If (p_rec.information5 = hr_api.g_varchar2) then
473: p_rec.information5 :=
474: hr_fmp_shd.g_old_rec.information5;
475: End If;
476: If (p_rec.information6 = hr_api.g_varchar2) then
477: p_rec.information6 :=
478: hr_fmp_shd.g_old_rec.information6;
479: End If;
480: If (p_rec.information7 = hr_api.g_varchar2) then
476: If (p_rec.information6 = hr_api.g_varchar2) then
477: p_rec.information6 :=
478: hr_fmp_shd.g_old_rec.information6;
479: End If;
480: If (p_rec.information7 = hr_api.g_varchar2) then
481: p_rec.information7 :=
482: hr_fmp_shd.g_old_rec.information7;
483: End If;
484: If (p_rec.information8 = hr_api.g_varchar2) then
480: If (p_rec.information7 = hr_api.g_varchar2) then
481: p_rec.information7 :=
482: hr_fmp_shd.g_old_rec.information7;
483: End If;
484: If (p_rec.information8 = hr_api.g_varchar2) then
485: p_rec.information8 :=
486: hr_fmp_shd.g_old_rec.information8;
487: End If;
488: If (p_rec.information9 = hr_api.g_varchar2) then
484: If (p_rec.information8 = hr_api.g_varchar2) then
485: p_rec.information8 :=
486: hr_fmp_shd.g_old_rec.information8;
487: End If;
488: If (p_rec.information9 = hr_api.g_varchar2) then
489: p_rec.information9 :=
490: hr_fmp_shd.g_old_rec.information9;
491: End If;
492: If (p_rec.information10 = hr_api.g_varchar2) then
488: If (p_rec.information9 = hr_api.g_varchar2) then
489: p_rec.information9 :=
490: hr_fmp_shd.g_old_rec.information9;
491: End If;
492: If (p_rec.information10 = hr_api.g_varchar2) then
493: p_rec.information10 :=
494: hr_fmp_shd.g_old_rec.information10;
495: End If;
496: If (p_rec.information11 = hr_api.g_varchar2) then
492: If (p_rec.information10 = hr_api.g_varchar2) then
493: p_rec.information10 :=
494: hr_fmp_shd.g_old_rec.information10;
495: End If;
496: If (p_rec.information11 = hr_api.g_varchar2) then
497: p_rec.information11 :=
498: hr_fmp_shd.g_old_rec.information11;
499: End If;
500: If (p_rec.information12 = hr_api.g_varchar2) then
496: If (p_rec.information11 = hr_api.g_varchar2) then
497: p_rec.information11 :=
498: hr_fmp_shd.g_old_rec.information11;
499: End If;
500: If (p_rec.information12 = hr_api.g_varchar2) then
501: p_rec.information12 :=
502: hr_fmp_shd.g_old_rec.information12;
503: End If;
504: If (p_rec.information13 = hr_api.g_varchar2) then
500: If (p_rec.information12 = hr_api.g_varchar2) then
501: p_rec.information12 :=
502: hr_fmp_shd.g_old_rec.information12;
503: End If;
504: If (p_rec.information13 = hr_api.g_varchar2) then
505: p_rec.information13 :=
506: hr_fmp_shd.g_old_rec.information13;
507: End If;
508: If (p_rec.information14 = hr_api.g_varchar2) then
504: If (p_rec.information13 = hr_api.g_varchar2) then
505: p_rec.information13 :=
506: hr_fmp_shd.g_old_rec.information13;
507: End If;
508: If (p_rec.information14 = hr_api.g_varchar2) then
509: p_rec.information14 :=
510: hr_fmp_shd.g_old_rec.information14;
511: End If;
512: If (p_rec.information15 = hr_api.g_varchar2) then
508: If (p_rec.information14 = hr_api.g_varchar2) then
509: p_rec.information14 :=
510: hr_fmp_shd.g_old_rec.information14;
511: End If;
512: If (p_rec.information15 = hr_api.g_varchar2) then
513: p_rec.information15 :=
514: hr_fmp_shd.g_old_rec.information15;
515: End If;
516: If (p_rec.information16 = hr_api.g_varchar2) then
512: If (p_rec.information15 = hr_api.g_varchar2) then
513: p_rec.information15 :=
514: hr_fmp_shd.g_old_rec.information15;
515: End If;
516: If (p_rec.information16 = hr_api.g_varchar2) then
517: p_rec.information16 :=
518: hr_fmp_shd.g_old_rec.information16;
519: End If;
520: If (p_rec.information17 = hr_api.g_varchar2) then
516: If (p_rec.information16 = hr_api.g_varchar2) then
517: p_rec.information16 :=
518: hr_fmp_shd.g_old_rec.information16;
519: End If;
520: If (p_rec.information17 = hr_api.g_varchar2) then
521: p_rec.information17 :=
522: hr_fmp_shd.g_old_rec.information17;
523: End If;
524: If (p_rec.information18 = hr_api.g_varchar2) then
520: If (p_rec.information17 = hr_api.g_varchar2) then
521: p_rec.information17 :=
522: hr_fmp_shd.g_old_rec.information17;
523: End If;
524: If (p_rec.information18 = hr_api.g_varchar2) then
525: p_rec.information18 :=
526: hr_fmp_shd.g_old_rec.information18;
527: End If;
528: If (p_rec.information19 = hr_api.g_varchar2) then
524: If (p_rec.information18 = hr_api.g_varchar2) then
525: p_rec.information18 :=
526: hr_fmp_shd.g_old_rec.information18;
527: End If;
528: If (p_rec.information19 = hr_api.g_varchar2) then
529: p_rec.information19 :=
530: hr_fmp_shd.g_old_rec.information19;
531: End If;
532: If (p_rec.information20 = hr_api.g_varchar2) then
528: If (p_rec.information19 = hr_api.g_varchar2) then
529: p_rec.information19 :=
530: hr_fmp_shd.g_old_rec.information19;
531: End If;
532: If (p_rec.information20 = hr_api.g_varchar2) then
533: p_rec.information20 :=
534: hr_fmp_shd.g_old_rec.information20;
535: End If;
536: If (p_rec.information21 = hr_api.g_varchar2) then
532: If (p_rec.information20 = hr_api.g_varchar2) then
533: p_rec.information20 :=
534: hr_fmp_shd.g_old_rec.information20;
535: End If;
536: If (p_rec.information21 = hr_api.g_varchar2) then
537: p_rec.information21 :=
538: hr_fmp_shd.g_old_rec.information21;
539: End If;
540: If (p_rec.information22 = hr_api.g_varchar2) then
536: If (p_rec.information21 = hr_api.g_varchar2) then
537: p_rec.information21 :=
538: hr_fmp_shd.g_old_rec.information21;
539: End If;
540: If (p_rec.information22 = hr_api.g_varchar2) then
541: p_rec.information22 :=
542: hr_fmp_shd.g_old_rec.information22;
543: End If;
544: If (p_rec.information23 = hr_api.g_varchar2) then
540: If (p_rec.information22 = hr_api.g_varchar2) then
541: p_rec.information22 :=
542: hr_fmp_shd.g_old_rec.information22;
543: End If;
544: If (p_rec.information23 = hr_api.g_varchar2) then
545: p_rec.information23 :=
546: hr_fmp_shd.g_old_rec.information23;
547: End If;
548: If (p_rec.information24 = hr_api.g_varchar2) then
544: If (p_rec.information23 = hr_api.g_varchar2) then
545: p_rec.information23 :=
546: hr_fmp_shd.g_old_rec.information23;
547: End If;
548: If (p_rec.information24 = hr_api.g_varchar2) then
549: p_rec.information24 :=
550: hr_fmp_shd.g_old_rec.information24;
551: End If;
552: If (p_rec.information25 = hr_api.g_varchar2) then
548: If (p_rec.information24 = hr_api.g_varchar2) then
549: p_rec.information24 :=
550: hr_fmp_shd.g_old_rec.information24;
551: End If;
552: If (p_rec.information25 = hr_api.g_varchar2) then
553: p_rec.information25 :=
554: hr_fmp_shd.g_old_rec.information25;
555: End If;
556: If (p_rec.information26 = hr_api.g_varchar2) then
552: If (p_rec.information25 = hr_api.g_varchar2) then
553: p_rec.information25 :=
554: hr_fmp_shd.g_old_rec.information25;
555: End If;
556: If (p_rec.information26 = hr_api.g_varchar2) then
557: p_rec.information26 :=
558: hr_fmp_shd.g_old_rec.information26;
559: End If;
560: If (p_rec.information27 = hr_api.g_varchar2) then
556: If (p_rec.information26 = hr_api.g_varchar2) then
557: p_rec.information26 :=
558: hr_fmp_shd.g_old_rec.information26;
559: End If;
560: If (p_rec.information27 = hr_api.g_varchar2) then
561: p_rec.information27 :=
562: hr_fmp_shd.g_old_rec.information27;
563: End If;
564: If (p_rec.information28 = hr_api.g_varchar2) then
560: If (p_rec.information27 = hr_api.g_varchar2) then
561: p_rec.information27 :=
562: hr_fmp_shd.g_old_rec.information27;
563: End If;
564: If (p_rec.information28 = hr_api.g_varchar2) then
565: p_rec.information28 :=
566: hr_fmp_shd.g_old_rec.information28;
567: End If;
568: If (p_rec.information29 = hr_api.g_varchar2) then
564: If (p_rec.information28 = hr_api.g_varchar2) then
565: p_rec.information28 :=
566: hr_fmp_shd.g_old_rec.information28;
567: End If;
568: If (p_rec.information29 = hr_api.g_varchar2) then
569: p_rec.information29 :=
570: hr_fmp_shd.g_old_rec.information29;
571: End If;
572: If (p_rec.information30 = hr_api.g_varchar2) then
568: If (p_rec.information29 = hr_api.g_varchar2) then
569: p_rec.information29 :=
570: hr_fmp_shd.g_old_rec.information29;
571: End If;
572: If (p_rec.information30 = hr_api.g_varchar2) then
573: p_rec.information30 :=
574: hr_fmp_shd.g_old_rec.information30;
575: End If;
576: --
626: -- ----------------------------------------------------------------------------
627: Procedure upd
628: (p_form_property_id in number
629: ,p_object_version_number in out nocopy number
630: ,p_application_id in number default hr_api.g_number
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
627: Procedure upd
628: (p_form_property_id in number
629: ,p_object_version_number in out nocopy number
630: ,p_application_id in number default hr_api.g_number
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
628: (p_form_property_id in number
629: ,p_object_version_number in out nocopy number
630: ,p_application_id in number default hr_api.g_number
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
629: ,p_object_version_number in out nocopy number
630: ,p_application_id in number default hr_api.g_number
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
630: ,p_application_id in number default hr_api.g_number
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
631: ,p_form_id in number default hr_api.g_number
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
632: ,p_form_template_id in number default hr_api.g_number
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
633: ,p_help_target in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
634: ,p_information_category in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
635: ,p_information1 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
636: ,p_information2 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
637: ,p_information3 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
638: ,p_information4 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
639: ,p_information5 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
640: ,p_information6 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
641: ,p_information7 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
642: ,p_information8 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
643: ,p_information9 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
644: ,p_information10 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
645: ,p_information11 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
646: ,p_information12 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
647: ,p_information13 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
648: ,p_information14 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
649: ,p_information15 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
650: ,p_information16 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
651: ,p_information17 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
652: ,p_information18 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
653: ,p_information19 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
654: ,p_information20 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
655: ,p_information21 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
656: ,p_information22 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
657: ,p_information23 in varchar2 default hr_api.g_varchar2
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
665: ) is
658: ,p_information24 in varchar2 default hr_api.g_varchar2
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
665: ) is
666: --
659: ,p_information25 in varchar2 default hr_api.g_varchar2
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
665: ) is
666: --
667: l_rec hr_fmp_shd.g_rec_type;
660: ,p_information26 in varchar2 default hr_api.g_varchar2
661: ,p_information27 in varchar2 default hr_api.g_varchar2
662: ,p_information28 in varchar2 default hr_api.g_varchar2
663: ,p_information29 in varchar2 default hr_api.g_varchar2
664: ,p_information30 in varchar2 default hr_api.g_varchar2
665: ) is
666: --
667: l_rec hr_fmp_shd.g_rec_type;
668: l_proc varchar2(72) := g_package||'upd';