67: --
68: Begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: --
71: If (p_datetrack_mode = hr_api.g_correction) then
72: hr_utility.set_location(l_proc, 10);
73: --
74: -- Because we are updating a row we must get the next object
75: -- version number.
142: End If;
143: --
144: hr_utility.set_location(' Leaving:'||l_proc, 15);
145: Exception
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
149: pay_ele_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
146: When hr_api.check_integrity_violated Then
147: -- A check constraint has been violated
148: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
149: pay_ele_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
154: pay_ele_shd.constraint_error
147: -- A check constraint has been violated
148: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
149: pay_ele_shd.constraint_error
150: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
154: pay_ele_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
153: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
154: pay_ele_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When Others Then
157: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
158: Raise;
159: End dt_update_dml;
268: l_dummy_version_number number;
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272: If (p_datetrack_mode <> hr_api.g_correction) then
273: --
274: -- Update the current effective end date
275: --
276: pay_ele_shd.upd_effective_end_date
281: ,p_validation_end_date => p_validation_end_date
282: ,p_object_version_number => l_dummy_version_number
283: );
284: --
285: If (p_datetrack_mode = hr_api.g_update_override) then
286: --
287: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
288: -- delete any future rows
289: --
680: );
681: --
682: exception
683: --
684: when hr_api.cannot_find_prog_unit then
685: --
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
688: ,p_hook_type => 'AU');
682: exception
683: --
684: when hr_api.cannot_find_prog_unit then
685: --
686: hr_api.cannot_find_prog_unit_error
687: (p_module_name => 'PAY_ELEMENT_ENTRIES_F'
688: ,p_hook_type => 'AU');
689: --
690: end;
749: -- p_rec plsql record structure
750: -- to see if a system default is being used. If a system default
751: -- is being used then we must set to the 'current' argument value.
752: --
753: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
754: p_rec.cost_allocation_keyflex_id :=
755: pay_ele_shd.g_old_rec.cost_allocation_keyflex_id;
756: End If;
757: If (p_rec.assignment_id = hr_api.g_number) then
753: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
754: p_rec.cost_allocation_keyflex_id :=
755: pay_ele_shd.g_old_rec.cost_allocation_keyflex_id;
756: End If;
757: If (p_rec.assignment_id = hr_api.g_number) then
758: p_rec.assignment_id :=
759: pay_ele_shd.g_old_rec.assignment_id;
760: End If;
761: If (p_rec.updating_action_id = hr_api.g_number) then
757: If (p_rec.assignment_id = hr_api.g_number) then
758: p_rec.assignment_id :=
759: pay_ele_shd.g_old_rec.assignment_id;
760: End If;
761: If (p_rec.updating_action_id = hr_api.g_number) then
762: p_rec.updating_action_id :=
763: pay_ele_shd.g_old_rec.updating_action_id;
764: End If;
765: If (p_rec.updating_action_type = hr_api.g_varchar2) then
761: If (p_rec.updating_action_id = hr_api.g_number) then
762: p_rec.updating_action_id :=
763: pay_ele_shd.g_old_rec.updating_action_id;
764: End If;
765: If (p_rec.updating_action_type = hr_api.g_varchar2) then
766: p_rec.updating_action_type :=
767: pay_ele_shd.g_old_rec.updating_action_type;
768: End If;
769: If (p_rec.element_link_id = hr_api.g_number) then
765: If (p_rec.updating_action_type = hr_api.g_varchar2) then
766: p_rec.updating_action_type :=
767: pay_ele_shd.g_old_rec.updating_action_type;
768: End If;
769: If (p_rec.element_link_id = hr_api.g_number) then
770: p_rec.element_link_id :=
771: pay_ele_shd.g_old_rec.element_link_id;
772: End If;
773: If (p_rec.original_entry_id = hr_api.g_number) then
769: If (p_rec.element_link_id = hr_api.g_number) then
770: p_rec.element_link_id :=
771: pay_ele_shd.g_old_rec.element_link_id;
772: End If;
773: If (p_rec.original_entry_id = hr_api.g_number) then
774: p_rec.original_entry_id :=
775: pay_ele_shd.g_old_rec.original_entry_id;
776: End If;
777: If (p_rec.creator_type = hr_api.g_varchar2) then
773: If (p_rec.original_entry_id = hr_api.g_number) then
774: p_rec.original_entry_id :=
775: pay_ele_shd.g_old_rec.original_entry_id;
776: End If;
777: If (p_rec.creator_type = hr_api.g_varchar2) then
778: p_rec.creator_type :=
779: pay_ele_shd.g_old_rec.creator_type;
780: End If;
781: If (p_rec.entry_type = hr_api.g_varchar2) then
777: If (p_rec.creator_type = hr_api.g_varchar2) then
778: p_rec.creator_type :=
779: pay_ele_shd.g_old_rec.creator_type;
780: End If;
781: If (p_rec.entry_type = hr_api.g_varchar2) then
782: p_rec.entry_type :=
783: pay_ele_shd.g_old_rec.entry_type;
784: End If;
785: If (p_rec.comment_id = hr_api.g_number) then
781: If (p_rec.entry_type = hr_api.g_varchar2) then
782: p_rec.entry_type :=
783: pay_ele_shd.g_old_rec.entry_type;
784: End If;
785: If (p_rec.comment_id = hr_api.g_number) then
786: p_rec.comment_id :=
787: pay_ele_shd.g_old_rec.comment_id;
788: End If;
789: If (p_rec.comments = hr_api.g_varchar2) then
785: If (p_rec.comment_id = hr_api.g_number) then
786: p_rec.comment_id :=
787: pay_ele_shd.g_old_rec.comment_id;
788: End If;
789: If (p_rec.comments = hr_api.g_varchar2) then
790: p_rec.comments :=
791: pay_ele_shd.g_old_rec.comments;
792: End If;
793: If (p_rec.creator_id = hr_api.g_number) then
789: If (p_rec.comments = hr_api.g_varchar2) then
790: p_rec.comments :=
791: pay_ele_shd.g_old_rec.comments;
792: End If;
793: If (p_rec.creator_id = hr_api.g_number) then
794: p_rec.creator_id :=
795: pay_ele_shd.g_old_rec.creator_id;
796: End If;
797: If (p_rec.reason = hr_api.g_varchar2) then
793: If (p_rec.creator_id = hr_api.g_number) then
794: p_rec.creator_id :=
795: pay_ele_shd.g_old_rec.creator_id;
796: End If;
797: If (p_rec.reason = hr_api.g_varchar2) then
798: p_rec.reason :=
799: pay_ele_shd.g_old_rec.reason;
800: End If;
801: If (p_rec.target_entry_id = hr_api.g_number) then
797: If (p_rec.reason = hr_api.g_varchar2) then
798: p_rec.reason :=
799: pay_ele_shd.g_old_rec.reason;
800: End If;
801: If (p_rec.target_entry_id = hr_api.g_number) then
802: p_rec.target_entry_id :=
803: pay_ele_shd.g_old_rec.target_entry_id;
804: End If;
805: If (p_rec.attribute_category = hr_api.g_varchar2) then
801: If (p_rec.target_entry_id = hr_api.g_number) then
802: p_rec.target_entry_id :=
803: pay_ele_shd.g_old_rec.target_entry_id;
804: End If;
805: If (p_rec.attribute_category = hr_api.g_varchar2) then
806: p_rec.attribute_category :=
807: pay_ele_shd.g_old_rec.attribute_category;
808: End If;
809: If (p_rec.attribute1 = hr_api.g_varchar2) then
805: If (p_rec.attribute_category = hr_api.g_varchar2) then
806: p_rec.attribute_category :=
807: pay_ele_shd.g_old_rec.attribute_category;
808: End If;
809: If (p_rec.attribute1 = hr_api.g_varchar2) then
810: p_rec.attribute1 :=
811: pay_ele_shd.g_old_rec.attribute1;
812: End If;
813: If (p_rec.attribute2 = hr_api.g_varchar2) then
809: If (p_rec.attribute1 = hr_api.g_varchar2) then
810: p_rec.attribute1 :=
811: pay_ele_shd.g_old_rec.attribute1;
812: End If;
813: If (p_rec.attribute2 = hr_api.g_varchar2) then
814: p_rec.attribute2 :=
815: pay_ele_shd.g_old_rec.attribute2;
816: End If;
817: If (p_rec.attribute3 = hr_api.g_varchar2) then
813: If (p_rec.attribute2 = hr_api.g_varchar2) then
814: p_rec.attribute2 :=
815: pay_ele_shd.g_old_rec.attribute2;
816: End If;
817: If (p_rec.attribute3 = hr_api.g_varchar2) then
818: p_rec.attribute3 :=
819: pay_ele_shd.g_old_rec.attribute3;
820: End If;
821: If (p_rec.attribute4 = hr_api.g_varchar2) then
817: If (p_rec.attribute3 = hr_api.g_varchar2) then
818: p_rec.attribute3 :=
819: pay_ele_shd.g_old_rec.attribute3;
820: End If;
821: If (p_rec.attribute4 = hr_api.g_varchar2) then
822: p_rec.attribute4 :=
823: pay_ele_shd.g_old_rec.attribute4;
824: End If;
825: If (p_rec.attribute5 = hr_api.g_varchar2) then
821: If (p_rec.attribute4 = hr_api.g_varchar2) then
822: p_rec.attribute4 :=
823: pay_ele_shd.g_old_rec.attribute4;
824: End If;
825: If (p_rec.attribute5 = hr_api.g_varchar2) then
826: p_rec.attribute5 :=
827: pay_ele_shd.g_old_rec.attribute5;
828: End If;
829: If (p_rec.attribute6 = hr_api.g_varchar2) then
825: If (p_rec.attribute5 = hr_api.g_varchar2) then
826: p_rec.attribute5 :=
827: pay_ele_shd.g_old_rec.attribute5;
828: End If;
829: If (p_rec.attribute6 = hr_api.g_varchar2) then
830: p_rec.attribute6 :=
831: pay_ele_shd.g_old_rec.attribute6;
832: End If;
833: If (p_rec.attribute7 = hr_api.g_varchar2) then
829: If (p_rec.attribute6 = hr_api.g_varchar2) then
830: p_rec.attribute6 :=
831: pay_ele_shd.g_old_rec.attribute6;
832: End If;
833: If (p_rec.attribute7 = hr_api.g_varchar2) then
834: p_rec.attribute7 :=
835: pay_ele_shd.g_old_rec.attribute7;
836: End If;
837: If (p_rec.attribute8 = hr_api.g_varchar2) then
833: If (p_rec.attribute7 = hr_api.g_varchar2) then
834: p_rec.attribute7 :=
835: pay_ele_shd.g_old_rec.attribute7;
836: End If;
837: If (p_rec.attribute8 = hr_api.g_varchar2) then
838: p_rec.attribute8 :=
839: pay_ele_shd.g_old_rec.attribute8;
840: End If;
841: If (p_rec.attribute9 = hr_api.g_varchar2) then
837: If (p_rec.attribute8 = hr_api.g_varchar2) then
838: p_rec.attribute8 :=
839: pay_ele_shd.g_old_rec.attribute8;
840: End If;
841: If (p_rec.attribute9 = hr_api.g_varchar2) then
842: p_rec.attribute9 :=
843: pay_ele_shd.g_old_rec.attribute9;
844: End If;
845: If (p_rec.attribute10 = hr_api.g_varchar2) then
841: If (p_rec.attribute9 = hr_api.g_varchar2) then
842: p_rec.attribute9 :=
843: pay_ele_shd.g_old_rec.attribute9;
844: End If;
845: If (p_rec.attribute10 = hr_api.g_varchar2) then
846: p_rec.attribute10 :=
847: pay_ele_shd.g_old_rec.attribute10;
848: End If;
849: If (p_rec.attribute11 = hr_api.g_varchar2) then
845: If (p_rec.attribute10 = hr_api.g_varchar2) then
846: p_rec.attribute10 :=
847: pay_ele_shd.g_old_rec.attribute10;
848: End If;
849: If (p_rec.attribute11 = hr_api.g_varchar2) then
850: p_rec.attribute11 :=
851: pay_ele_shd.g_old_rec.attribute11;
852: End If;
853: If (p_rec.attribute12 = hr_api.g_varchar2) then
849: If (p_rec.attribute11 = hr_api.g_varchar2) then
850: p_rec.attribute11 :=
851: pay_ele_shd.g_old_rec.attribute11;
852: End If;
853: If (p_rec.attribute12 = hr_api.g_varchar2) then
854: p_rec.attribute12 :=
855: pay_ele_shd.g_old_rec.attribute12;
856: End If;
857: If (p_rec.attribute13 = hr_api.g_varchar2) then
853: If (p_rec.attribute12 = hr_api.g_varchar2) then
854: p_rec.attribute12 :=
855: pay_ele_shd.g_old_rec.attribute12;
856: End If;
857: If (p_rec.attribute13 = hr_api.g_varchar2) then
858: p_rec.attribute13 :=
859: pay_ele_shd.g_old_rec.attribute13;
860: End If;
861: If (p_rec.attribute14 = hr_api.g_varchar2) then
857: If (p_rec.attribute13 = hr_api.g_varchar2) then
858: p_rec.attribute13 :=
859: pay_ele_shd.g_old_rec.attribute13;
860: End If;
861: If (p_rec.attribute14 = hr_api.g_varchar2) then
862: p_rec.attribute14 :=
863: pay_ele_shd.g_old_rec.attribute14;
864: End If;
865: If (p_rec.attribute15 = hr_api.g_varchar2) then
861: If (p_rec.attribute14 = hr_api.g_varchar2) then
862: p_rec.attribute14 :=
863: pay_ele_shd.g_old_rec.attribute14;
864: End If;
865: If (p_rec.attribute15 = hr_api.g_varchar2) then
866: p_rec.attribute15 :=
867: pay_ele_shd.g_old_rec.attribute15;
868: End If;
869: If (p_rec.attribute16 = hr_api.g_varchar2) then
865: If (p_rec.attribute15 = hr_api.g_varchar2) then
866: p_rec.attribute15 :=
867: pay_ele_shd.g_old_rec.attribute15;
868: End If;
869: If (p_rec.attribute16 = hr_api.g_varchar2) then
870: p_rec.attribute16 :=
871: pay_ele_shd.g_old_rec.attribute16;
872: End If;
873: If (p_rec.attribute17 = hr_api.g_varchar2) then
869: If (p_rec.attribute16 = hr_api.g_varchar2) then
870: p_rec.attribute16 :=
871: pay_ele_shd.g_old_rec.attribute16;
872: End If;
873: If (p_rec.attribute17 = hr_api.g_varchar2) then
874: p_rec.attribute17 :=
875: pay_ele_shd.g_old_rec.attribute17;
876: End If;
877: If (p_rec.attribute18 = hr_api.g_varchar2) then
873: If (p_rec.attribute17 = hr_api.g_varchar2) then
874: p_rec.attribute17 :=
875: pay_ele_shd.g_old_rec.attribute17;
876: End If;
877: If (p_rec.attribute18 = hr_api.g_varchar2) then
878: p_rec.attribute18 :=
879: pay_ele_shd.g_old_rec.attribute18;
880: End If;
881: If (p_rec.attribute19 = hr_api.g_varchar2) then
877: If (p_rec.attribute18 = hr_api.g_varchar2) then
878: p_rec.attribute18 :=
879: pay_ele_shd.g_old_rec.attribute18;
880: End If;
881: If (p_rec.attribute19 = hr_api.g_varchar2) then
882: p_rec.attribute19 :=
883: pay_ele_shd.g_old_rec.attribute19;
884: End If;
885: If (p_rec.attribute20 = hr_api.g_varchar2) then
881: If (p_rec.attribute19 = hr_api.g_varchar2) then
882: p_rec.attribute19 :=
883: pay_ele_shd.g_old_rec.attribute19;
884: End If;
885: If (p_rec.attribute20 = hr_api.g_varchar2) then
886: p_rec.attribute20 :=
887: pay_ele_shd.g_old_rec.attribute20;
888: End If;
889: If (p_rec.subpriority = hr_api.g_number) then
885: If (p_rec.attribute20 = hr_api.g_varchar2) then
886: p_rec.attribute20 :=
887: pay_ele_shd.g_old_rec.attribute20;
888: End If;
889: If (p_rec.subpriority = hr_api.g_number) then
890: p_rec.subpriority :=
891: pay_ele_shd.g_old_rec.subpriority;
892: End If;
893: If (p_rec.personal_payment_method_id = hr_api.g_number) then
889: If (p_rec.subpriority = hr_api.g_number) then
890: p_rec.subpriority :=
891: pay_ele_shd.g_old_rec.subpriority;
892: End If;
893: If (p_rec.personal_payment_method_id = hr_api.g_number) then
894: p_rec.personal_payment_method_id :=
895: pay_ele_shd.g_old_rec.personal_payment_method_id;
896: End If;
897: If (p_rec.date_earned = hr_api.g_date) then
893: If (p_rec.personal_payment_method_id = hr_api.g_number) then
894: p_rec.personal_payment_method_id :=
895: pay_ele_shd.g_old_rec.personal_payment_method_id;
896: End If;
897: If (p_rec.date_earned = hr_api.g_date) then
898: p_rec.date_earned :=
899: pay_ele_shd.g_old_rec.date_earned;
900: End If;
901: If (p_rec.source_id = hr_api.g_number) then
897: If (p_rec.date_earned = hr_api.g_date) then
898: p_rec.date_earned :=
899: pay_ele_shd.g_old_rec.date_earned;
900: End If;
901: If (p_rec.source_id = hr_api.g_number) then
902: p_rec.source_id :=
903: pay_ele_shd.g_old_rec.source_id;
904: End If;
905: If (p_rec.balance_adj_cost_flag = hr_api.g_varchar2) then
901: If (p_rec.source_id = hr_api.g_number) then
902: p_rec.source_id :=
903: pay_ele_shd.g_old_rec.source_id;
904: End If;
905: If (p_rec.balance_adj_cost_flag = hr_api.g_varchar2) then
906: p_rec.balance_adj_cost_flag :=
907: pay_ele_shd.g_old_rec.balance_adj_cost_flag;
908: End If;
909: If (p_rec.element_type_id = hr_api.g_number) then
905: If (p_rec.balance_adj_cost_flag = hr_api.g_varchar2) then
906: p_rec.balance_adj_cost_flag :=
907: pay_ele_shd.g_old_rec.balance_adj_cost_flag;
908: End If;
909: If (p_rec.element_type_id = hr_api.g_number) then
910: p_rec.element_type_id :=
911: pay_ele_shd.g_old_rec.element_type_id;
912: End If;
913: If (p_rec.all_entry_values_null = hr_api.g_varchar2) then
909: If (p_rec.element_type_id = hr_api.g_number) then
910: p_rec.element_type_id :=
911: pay_ele_shd.g_old_rec.element_type_id;
912: End If;
913: If (p_rec.all_entry_values_null = hr_api.g_varchar2) then
914: p_rec.all_entry_values_null :=
915: pay_ele_shd.g_old_rec.all_entry_values_null;
916: End If;
917: --
1002: (p_effective_date in date
1003: ,p_datetrack_mode in varchar2
1004: ,p_element_entry_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_assignment_id in number default hr_api.g_number
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1003: ,p_datetrack_mode in varchar2
1004: ,p_element_entry_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_assignment_id in number default hr_api.g_number
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1004: ,p_element_entry_id in number
1005: ,p_object_version_number in out nocopy number
1006: ,p_assignment_id in number default hr_api.g_number
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1005: ,p_object_version_number in out nocopy number
1006: ,p_assignment_id in number default hr_api.g_number
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1006: ,p_assignment_id in number default hr_api.g_number
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1007: ,p_element_link_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1008: ,p_creator_type in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1009: ,p_entry_type in varchar2 default hr_api.g_varchar2
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1010: ,p_cost_allocation_keyflex_id in number default hr_api.g_number
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1011: ,p_updating_action_id in number default hr_api.g_number
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1012: ,p_updating_action_type in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1013: ,p_original_entry_id in number default hr_api.g_number
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1014: ,p_comments in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1015: ,p_creator_id in number default hr_api.g_number
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1016: ,p_reason in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1017: ,p_target_entry_id in number default hr_api.g_number
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1018: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1019: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1020: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1021: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1022: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1023: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1024: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1025: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1026: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1027: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1028: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1029: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1030: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1031: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1032: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1033: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1034: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1035: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1043: ,p_balance_adj_cost_flag in varchar2 default hr_api.g_varchar2
1036: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1043: ,p_balance_adj_cost_flag in varchar2 default hr_api.g_varchar2
1044: ,p_effective_start_date out nocopy date
1037: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1043: ,p_balance_adj_cost_flag in varchar2 default hr_api.g_varchar2
1044: ,p_effective_start_date out nocopy date
1045: ,p_effective_end_date out nocopy date
1038: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1043: ,p_balance_adj_cost_flag in varchar2 default hr_api.g_varchar2
1044: ,p_effective_start_date out nocopy date
1045: ,p_effective_end_date out nocopy date
1046: ,p_comment_id out nocopy number
1039: ,p_subpriority in number default hr_api.g_number
1040: ,p_personal_payment_method_id in number default hr_api.g_number
1041: ,p_date_earned in date default hr_api.g_date
1042: ,p_source_id in number default hr_api.g_number
1043: ,p_balance_adj_cost_flag in varchar2 default hr_api.g_varchar2
1044: ,p_effective_start_date out nocopy date
1045: ,p_effective_end_date out nocopy date
1046: ,p_comment_id out nocopy number
1047: ) is
1067: ,p_element_link_id
1068: ,p_original_entry_id
1069: ,p_creator_type
1070: ,p_entry_type
1071: ,hr_api.g_number
1072: ,p_comments
1073: ,p_creator_id
1074: ,p_reason
1075: ,p_target_entry_id
1099: ,p_date_earned
1100: ,p_object_version_number
1101: ,p_source_id
1102: ,p_balance_adj_cost_flag
1103: ,hr_api.g_number
1104: ,hr_api.g_varchar2 -- p_all_entry_values_null
1105: );
1106: --
1107: -- Having converted the arguments into the
1100: ,p_object_version_number
1101: ,p_source_id
1102: ,p_balance_adj_cost_flag
1103: ,hr_api.g_number
1104: ,hr_api.g_varchar2 -- p_all_entry_values_null
1105: );
1106: --
1107: -- Having converted the arguments into the
1108: -- plsql record structure we call the corresponding record