66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.
137: End If;
138: --
139: hr_utility.set_location(' Leaving:'||l_proc, 15);
140: Exception
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
144: ben_qig_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
141: When hr_api.check_integrity_violated Then
142: -- A check constraint has been violated
143: --
144: ben_qig_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_qig_shd.constraint_error
142: -- A check constraint has been violated
143: --
144: ben_qig_shd.constraint_error
145: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_qig_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.unique_integrity_violated Then
147: -- Unique integrity has been violated
148: --
149: ben_qig_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When Others Then
152: --
153: Raise;
154: End dt_update_dml;
263: l_dummy_version_number number;
264: --
265: Begin
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: If (p_datetrack_mode <> hr_api.g_correction) then
268: --
269: -- Update the current effective end date
270: --
271: ben_qig_shd.upd_effective_end_date
276: ,p_validation_end_date => p_validation_end_date
277: ,p_object_version_number => l_dummy_version_number
278: );
279: --
280: If (p_datetrack_mode = hr_api.g_update_override) then
281: --
282: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
283: -- delete any future rows
284: --
578: );
579: --
580: exception
581: --
582: when hr_api.cannot_find_prog_unit then
583: --
584: hr_api.cannot_find_prog_unit_error
585: (p_module_name => 'BEN_QUA_IN_GR_RT_F'
586: ,p_hook_type => 'AU');
580: exception
581: --
582: when hr_api.cannot_find_prog_unit then
583: --
584: hr_api.cannot_find_prog_unit_error
585: (p_module_name => 'BEN_QUA_IN_GR_RT_F'
586: ,p_hook_type => 'AU');
587: --
588: end;
643: -- p_rec plsql record structure
644: -- to see if a system default is being used. If a system default
645: -- is being used then we must set to the 'current' argument value.
646: --
647: If (p_rec.quar_in_grade_cd = hr_api.g_varchar2) then
648: p_rec.quar_in_grade_cd :=
649: ben_qig_shd.g_old_rec.quar_in_grade_cd;
650: End If;
651: If (p_rec.excld_flag = hr_api.g_varchar2) then
647: If (p_rec.quar_in_grade_cd = hr_api.g_varchar2) then
648: p_rec.quar_in_grade_cd :=
649: ben_qig_shd.g_old_rec.quar_in_grade_cd;
650: End If;
651: If (p_rec.excld_flag = hr_api.g_varchar2) then
652: p_rec.excld_flag :=
653: ben_qig_shd.g_old_rec.excld_flag;
654: End If;
655: If (p_rec.business_group_id = hr_api.g_number) then
651: If (p_rec.excld_flag = hr_api.g_varchar2) then
652: p_rec.excld_flag :=
653: ben_qig_shd.g_old_rec.excld_flag;
654: End If;
655: If (p_rec.business_group_id = hr_api.g_number) then
656: p_rec.business_group_id :=
657: ben_qig_shd.g_old_rec.business_group_id;
658: End If;
659: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
655: If (p_rec.business_group_id = hr_api.g_number) then
656: p_rec.business_group_id :=
657: ben_qig_shd.g_old_rec.business_group_id;
658: End If;
659: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
660: p_rec.vrbl_rt_prfl_id :=
661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;
662: End If;
663: If (p_rec.ordr_num = hr_api.g_number) then
659: If (p_rec.vrbl_rt_prfl_id = hr_api.g_number) then
660: p_rec.vrbl_rt_prfl_id :=
661: ben_qig_shd.g_old_rec.vrbl_rt_prfl_id;
662: End If;
663: If (p_rec.ordr_num = hr_api.g_number) then
664: p_rec.ordr_num :=
665: ben_qig_shd.g_old_rec.ordr_num;
666: End If;
667: If (p_rec.qig_attribute_category = hr_api.g_varchar2) then
663: If (p_rec.ordr_num = hr_api.g_number) then
664: p_rec.ordr_num :=
665: ben_qig_shd.g_old_rec.ordr_num;
666: End If;
667: If (p_rec.qig_attribute_category = hr_api.g_varchar2) then
668: p_rec.qig_attribute_category :=
669: ben_qig_shd.g_old_rec.qig_attribute_category;
670: End If;
671: If (p_rec.qig_attribute1 = hr_api.g_varchar2) then
667: If (p_rec.qig_attribute_category = hr_api.g_varchar2) then
668: p_rec.qig_attribute_category :=
669: ben_qig_shd.g_old_rec.qig_attribute_category;
670: End If;
671: If (p_rec.qig_attribute1 = hr_api.g_varchar2) then
672: p_rec.qig_attribute1 :=
673: ben_qig_shd.g_old_rec.qig_attribute1;
674: End If;
675: If (p_rec.qig_attribute2 = hr_api.g_varchar2) then
671: If (p_rec.qig_attribute1 = hr_api.g_varchar2) then
672: p_rec.qig_attribute1 :=
673: ben_qig_shd.g_old_rec.qig_attribute1;
674: End If;
675: If (p_rec.qig_attribute2 = hr_api.g_varchar2) then
676: p_rec.qig_attribute2 :=
677: ben_qig_shd.g_old_rec.qig_attribute2;
678: End If;
679: If (p_rec.qig_attribute3 = hr_api.g_varchar2) then
675: If (p_rec.qig_attribute2 = hr_api.g_varchar2) then
676: p_rec.qig_attribute2 :=
677: ben_qig_shd.g_old_rec.qig_attribute2;
678: End If;
679: If (p_rec.qig_attribute3 = hr_api.g_varchar2) then
680: p_rec.qig_attribute3 :=
681: ben_qig_shd.g_old_rec.qig_attribute3;
682: End If;
683: If (p_rec.qig_attribute4 = hr_api.g_varchar2) then
679: If (p_rec.qig_attribute3 = hr_api.g_varchar2) then
680: p_rec.qig_attribute3 :=
681: ben_qig_shd.g_old_rec.qig_attribute3;
682: End If;
683: If (p_rec.qig_attribute4 = hr_api.g_varchar2) then
684: p_rec.qig_attribute4 :=
685: ben_qig_shd.g_old_rec.qig_attribute4;
686: End If;
687: If (p_rec.qig_attribute5 = hr_api.g_varchar2) then
683: If (p_rec.qig_attribute4 = hr_api.g_varchar2) then
684: p_rec.qig_attribute4 :=
685: ben_qig_shd.g_old_rec.qig_attribute4;
686: End If;
687: If (p_rec.qig_attribute5 = hr_api.g_varchar2) then
688: p_rec.qig_attribute5 :=
689: ben_qig_shd.g_old_rec.qig_attribute5;
690: End If;
691: If (p_rec.qig_attribute6 = hr_api.g_varchar2) then
687: If (p_rec.qig_attribute5 = hr_api.g_varchar2) then
688: p_rec.qig_attribute5 :=
689: ben_qig_shd.g_old_rec.qig_attribute5;
690: End If;
691: If (p_rec.qig_attribute6 = hr_api.g_varchar2) then
692: p_rec.qig_attribute6 :=
693: ben_qig_shd.g_old_rec.qig_attribute6;
694: End If;
695: If (p_rec.qig_attribute7 = hr_api.g_varchar2) then
691: If (p_rec.qig_attribute6 = hr_api.g_varchar2) then
692: p_rec.qig_attribute6 :=
693: ben_qig_shd.g_old_rec.qig_attribute6;
694: End If;
695: If (p_rec.qig_attribute7 = hr_api.g_varchar2) then
696: p_rec.qig_attribute7 :=
697: ben_qig_shd.g_old_rec.qig_attribute7;
698: End If;
699: If (p_rec.qig_attribute8 = hr_api.g_varchar2) then
695: If (p_rec.qig_attribute7 = hr_api.g_varchar2) then
696: p_rec.qig_attribute7 :=
697: ben_qig_shd.g_old_rec.qig_attribute7;
698: End If;
699: If (p_rec.qig_attribute8 = hr_api.g_varchar2) then
700: p_rec.qig_attribute8 :=
701: ben_qig_shd.g_old_rec.qig_attribute8;
702: End If;
703: If (p_rec.qig_attribute9 = hr_api.g_varchar2) then
699: If (p_rec.qig_attribute8 = hr_api.g_varchar2) then
700: p_rec.qig_attribute8 :=
701: ben_qig_shd.g_old_rec.qig_attribute8;
702: End If;
703: If (p_rec.qig_attribute9 = hr_api.g_varchar2) then
704: p_rec.qig_attribute9 :=
705: ben_qig_shd.g_old_rec.qig_attribute9;
706: End If;
707: If (p_rec.qig_attribute10 = hr_api.g_varchar2) then
703: If (p_rec.qig_attribute9 = hr_api.g_varchar2) then
704: p_rec.qig_attribute9 :=
705: ben_qig_shd.g_old_rec.qig_attribute9;
706: End If;
707: If (p_rec.qig_attribute10 = hr_api.g_varchar2) then
708: p_rec.qig_attribute10 :=
709: ben_qig_shd.g_old_rec.qig_attribute10;
710: End If;
711: If (p_rec.qig_attribute11 = hr_api.g_varchar2) then
707: If (p_rec.qig_attribute10 = hr_api.g_varchar2) then
708: p_rec.qig_attribute10 :=
709: ben_qig_shd.g_old_rec.qig_attribute10;
710: End If;
711: If (p_rec.qig_attribute11 = hr_api.g_varchar2) then
712: p_rec.qig_attribute11 :=
713: ben_qig_shd.g_old_rec.qig_attribute11;
714: End If;
715: If (p_rec.qig_attribute12 = hr_api.g_varchar2) then
711: If (p_rec.qig_attribute11 = hr_api.g_varchar2) then
712: p_rec.qig_attribute11 :=
713: ben_qig_shd.g_old_rec.qig_attribute11;
714: End If;
715: If (p_rec.qig_attribute12 = hr_api.g_varchar2) then
716: p_rec.qig_attribute12 :=
717: ben_qig_shd.g_old_rec.qig_attribute12;
718: End If;
719: If (p_rec.qig_attribute13 = hr_api.g_varchar2) then
715: If (p_rec.qig_attribute12 = hr_api.g_varchar2) then
716: p_rec.qig_attribute12 :=
717: ben_qig_shd.g_old_rec.qig_attribute12;
718: End If;
719: If (p_rec.qig_attribute13 = hr_api.g_varchar2) then
720: p_rec.qig_attribute13 :=
721: ben_qig_shd.g_old_rec.qig_attribute13;
722: End If;
723: If (p_rec.qig_attribute14 = hr_api.g_varchar2) then
719: If (p_rec.qig_attribute13 = hr_api.g_varchar2) then
720: p_rec.qig_attribute13 :=
721: ben_qig_shd.g_old_rec.qig_attribute13;
722: End If;
723: If (p_rec.qig_attribute14 = hr_api.g_varchar2) then
724: p_rec.qig_attribute14 :=
725: ben_qig_shd.g_old_rec.qig_attribute14;
726: End If;
727: If (p_rec.qig_attribute15 = hr_api.g_varchar2) then
723: If (p_rec.qig_attribute14 = hr_api.g_varchar2) then
724: p_rec.qig_attribute14 :=
725: ben_qig_shd.g_old_rec.qig_attribute14;
726: End If;
727: If (p_rec.qig_attribute15 = hr_api.g_varchar2) then
728: p_rec.qig_attribute15 :=
729: ben_qig_shd.g_old_rec.qig_attribute15;
730: End If;
731: If (p_rec.qig_attribute16 = hr_api.g_varchar2) then
727: If (p_rec.qig_attribute15 = hr_api.g_varchar2) then
728: p_rec.qig_attribute15 :=
729: ben_qig_shd.g_old_rec.qig_attribute15;
730: End If;
731: If (p_rec.qig_attribute16 = hr_api.g_varchar2) then
732: p_rec.qig_attribute16 :=
733: ben_qig_shd.g_old_rec.qig_attribute16;
734: End If;
735: If (p_rec.qig_attribute17 = hr_api.g_varchar2) then
731: If (p_rec.qig_attribute16 = hr_api.g_varchar2) then
732: p_rec.qig_attribute16 :=
733: ben_qig_shd.g_old_rec.qig_attribute16;
734: End If;
735: If (p_rec.qig_attribute17 = hr_api.g_varchar2) then
736: p_rec.qig_attribute17 :=
737: ben_qig_shd.g_old_rec.qig_attribute17;
738: End If;
739: If (p_rec.qig_attribute18 = hr_api.g_varchar2) then
735: If (p_rec.qig_attribute17 = hr_api.g_varchar2) then
736: p_rec.qig_attribute17 :=
737: ben_qig_shd.g_old_rec.qig_attribute17;
738: End If;
739: If (p_rec.qig_attribute18 = hr_api.g_varchar2) then
740: p_rec.qig_attribute18 :=
741: ben_qig_shd.g_old_rec.qig_attribute18;
742: End If;
743: If (p_rec.qig_attribute19 = hr_api.g_varchar2) then
739: If (p_rec.qig_attribute18 = hr_api.g_varchar2) then
740: p_rec.qig_attribute18 :=
741: ben_qig_shd.g_old_rec.qig_attribute18;
742: End If;
743: If (p_rec.qig_attribute19 = hr_api.g_varchar2) then
744: p_rec.qig_attribute19 :=
745: ben_qig_shd.g_old_rec.qig_attribute19;
746: End If;
747: If (p_rec.qig_attribute20 = hr_api.g_varchar2) then
743: If (p_rec.qig_attribute19 = hr_api.g_varchar2) then
744: p_rec.qig_attribute19 :=
745: ben_qig_shd.g_old_rec.qig_attribute19;
746: End If;
747: If (p_rec.qig_attribute20 = hr_api.g_varchar2) then
748: p_rec.qig_attribute20 :=
749: ben_qig_shd.g_old_rec.qig_attribute20;
750: End If;
751: If (p_rec.qig_attribute21 = hr_api.g_varchar2) then
747: If (p_rec.qig_attribute20 = hr_api.g_varchar2) then
748: p_rec.qig_attribute20 :=
749: ben_qig_shd.g_old_rec.qig_attribute20;
750: End If;
751: If (p_rec.qig_attribute21 = hr_api.g_varchar2) then
752: p_rec.qig_attribute21 :=
753: ben_qig_shd.g_old_rec.qig_attribute21;
754: End If;
755: If (p_rec.qig_attribute22 = hr_api.g_varchar2) then
751: If (p_rec.qig_attribute21 = hr_api.g_varchar2) then
752: p_rec.qig_attribute21 :=
753: ben_qig_shd.g_old_rec.qig_attribute21;
754: End If;
755: If (p_rec.qig_attribute22 = hr_api.g_varchar2) then
756: p_rec.qig_attribute22 :=
757: ben_qig_shd.g_old_rec.qig_attribute22;
758: End If;
759: If (p_rec.qig_attribute23 = hr_api.g_varchar2) then
755: If (p_rec.qig_attribute22 = hr_api.g_varchar2) then
756: p_rec.qig_attribute22 :=
757: ben_qig_shd.g_old_rec.qig_attribute22;
758: End If;
759: If (p_rec.qig_attribute23 = hr_api.g_varchar2) then
760: p_rec.qig_attribute23 :=
761: ben_qig_shd.g_old_rec.qig_attribute23;
762: End If;
763: If (p_rec.qig_attribute24 = hr_api.g_varchar2) then
759: If (p_rec.qig_attribute23 = hr_api.g_varchar2) then
760: p_rec.qig_attribute23 :=
761: ben_qig_shd.g_old_rec.qig_attribute23;
762: End If;
763: If (p_rec.qig_attribute24 = hr_api.g_varchar2) then
764: p_rec.qig_attribute24 :=
765: ben_qig_shd.g_old_rec.qig_attribute24;
766: End If;
767: If (p_rec.qig_attribute25 = hr_api.g_varchar2) then
763: If (p_rec.qig_attribute24 = hr_api.g_varchar2) then
764: p_rec.qig_attribute24 :=
765: ben_qig_shd.g_old_rec.qig_attribute24;
766: End If;
767: If (p_rec.qig_attribute25 = hr_api.g_varchar2) then
768: p_rec.qig_attribute25 :=
769: ben_qig_shd.g_old_rec.qig_attribute25;
770: End If;
771: If (p_rec.qig_attribute26 = hr_api.g_varchar2) then
767: If (p_rec.qig_attribute25 = hr_api.g_varchar2) then
768: p_rec.qig_attribute25 :=
769: ben_qig_shd.g_old_rec.qig_attribute25;
770: End If;
771: If (p_rec.qig_attribute26 = hr_api.g_varchar2) then
772: p_rec.qig_attribute26 :=
773: ben_qig_shd.g_old_rec.qig_attribute26;
774: End If;
775: If (p_rec.qig_attribute27 = hr_api.g_varchar2) then
771: If (p_rec.qig_attribute26 = hr_api.g_varchar2) then
772: p_rec.qig_attribute26 :=
773: ben_qig_shd.g_old_rec.qig_attribute26;
774: End If;
775: If (p_rec.qig_attribute27 = hr_api.g_varchar2) then
776: p_rec.qig_attribute27 :=
777: ben_qig_shd.g_old_rec.qig_attribute27;
778: End If;
779: If (p_rec.qig_attribute28 = hr_api.g_varchar2) then
775: If (p_rec.qig_attribute27 = hr_api.g_varchar2) then
776: p_rec.qig_attribute27 :=
777: ben_qig_shd.g_old_rec.qig_attribute27;
778: End If;
779: If (p_rec.qig_attribute28 = hr_api.g_varchar2) then
780: p_rec.qig_attribute28 :=
781: ben_qig_shd.g_old_rec.qig_attribute28;
782: End If;
783: If (p_rec.qig_attribute29 = hr_api.g_varchar2) then
779: If (p_rec.qig_attribute28 = hr_api.g_varchar2) then
780: p_rec.qig_attribute28 :=
781: ben_qig_shd.g_old_rec.qig_attribute28;
782: End If;
783: If (p_rec.qig_attribute29 = hr_api.g_varchar2) then
784: p_rec.qig_attribute29 :=
785: ben_qig_shd.g_old_rec.qig_attribute29;
786: End If;
787: If (p_rec.qig_attribute30 = hr_api.g_varchar2) then
783: If (p_rec.qig_attribute29 = hr_api.g_varchar2) then
784: p_rec.qig_attribute29 :=
785: ben_qig_shd.g_old_rec.qig_attribute29;
786: End If;
787: If (p_rec.qig_attribute30 = hr_api.g_varchar2) then
788: p_rec.qig_attribute30 :=
789: ben_qig_shd.g_old_rec.qig_attribute30;
790: End If;
791: --
882: (p_effective_date in date
883: ,p_datetrack_mode in varchar2
884: ,p_qua_in_gr_rt_id in number
885: ,p_object_version_number in out nocopy number
886: ,p_quar_in_grade_cd in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
883: ,p_datetrack_mode in varchar2
884: ,p_qua_in_gr_rt_id in number
885: ,p_object_version_number in out nocopy number
886: ,p_quar_in_grade_cd in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
884: ,p_qua_in_gr_rt_id in number
885: ,p_object_version_number in out nocopy number
886: ,p_quar_in_grade_cd in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
885: ,p_object_version_number in out nocopy number
886: ,p_quar_in_grade_cd in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
886: ,p_quar_in_grade_cd in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
887: ,p_excld_flag in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
889: ,p_vrbl_rt_prfl_id in number default hr_api.g_number
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
890: ,p_ordr_num in number default hr_api.g_number
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
891: ,p_qig_attribute_category in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
892: ,p_qig_attribute1 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
893: ,p_qig_attribute2 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
894: ,p_qig_attribute3 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
895: ,p_qig_attribute4 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
896: ,p_qig_attribute5 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
897: ,p_qig_attribute6 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
898: ,p_qig_attribute7 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
899: ,p_qig_attribute8 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
900: ,p_qig_attribute9 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
901: ,p_qig_attribute10 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
902: ,p_qig_attribute11 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
903: ,p_qig_attribute12 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
904: ,p_qig_attribute13 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
905: ,p_qig_attribute14 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
906: ,p_qig_attribute15 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
907: ,p_qig_attribute16 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
908: ,p_qig_attribute17 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
909: ,p_qig_attribute18 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
910: ,p_qig_attribute19 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
911: ,p_qig_attribute20 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
912: ,p_qig_attribute21 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
913: ,p_qig_attribute22 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_qig_attribute30 in varchar2 default hr_api.g_varchar2
914: ,p_qig_attribute23 in varchar2 default hr_api.g_varchar2
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_qig_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_effective_start_date out nocopy date
915: ,p_qig_attribute24 in varchar2 default hr_api.g_varchar2
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_qig_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_effective_start_date out nocopy date
923: ,p_effective_end_date out nocopy date
916: ,p_qig_attribute25 in varchar2 default hr_api.g_varchar2
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_qig_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_effective_start_date out nocopy date
923: ,p_effective_end_date out nocopy date
924: ) is
917: ,p_qig_attribute26 in varchar2 default hr_api.g_varchar2
918: ,p_qig_attribute27 in varchar2 default hr_api.g_varchar2
919: ,p_qig_attribute28 in varchar2 default hr_api.g_varchar2
920: ,p_qig_attribute29 in varchar2 default hr_api.g_varchar2
921: ,p_qig_attribute30 in varchar2 default hr_api.g_varchar2
922: ,p_effective_start_date out nocopy date
923: ,p_effective_end_date out nocopy date
924: ) is
925: --