55: --
56: -- {End Of Comments}
57: -- ----------------------------------------------------------------------------
58: Procedure dt_update_dml
59: (p_rec in out nocopy pay_ele_shd.g_rec_type
60: ,p_effective_date in date
61: ,p_datetrack_mode in varchar2
62: ,p_validation_start_date in date
63: ,p_validation_end_date in date
80: ,p_base_key_column => 'element_entry_id'
81: ,p_base_key_value => p_rec.element_entry_id
82: );
83: --
84: pay_ele_shd.g_api_dml := true; -- Set the api dml status
85: --
86: -- Update the pay_element_entries_f Row
87: --
88: update pay_element_entries_f
132: where element_entry_id = p_rec.element_entry_id
133: and effective_start_date = p_validation_start_date
134: and effective_end_date = p_validation_end_date;
135: --
136: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
137: --
138: -- Set the effective start and end dates
139: --
140: p_rec.effective_start_date := p_validation_start_date;
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));
151: When hr_api.unique_integrity_violated Then
152: -- Unique integrity has been violated
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));
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
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));
156: When Others Then
157: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
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));
156: When Others Then
157: pay_ele_shd.g_api_dml := false; -- Unset the api dml status
158: Raise;
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;
160: --
161: -- ----------------------------------------------------------------------------
189: --
190: -- {End Of Comments}
191: -- ----------------------------------------------------------------------------
192: Procedure update_dml
193: (p_rec in out nocopy pay_ele_shd.g_rec_type
194: ,p_effective_date in date
195: ,p_datetrack_mode in varchar2
196: ,p_validation_start_date in date
197: ,p_validation_end_date in date
256: --
257: -- {End Of Comments}
258: -- ----------------------------------------------------------------------------
259: Procedure dt_pre_update
260: (p_rec in out nocopy pay_ele_shd.g_rec_type
261: ,p_effective_date in date
262: ,p_datetrack_mode in varchar2
263: ,p_validation_start_date in date
264: ,p_validation_end_date in date
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
277: (p_effective_date => p_effective_date
278: ,p_base_key_value => p_rec.element_entry_id
279: ,p_new_effective_end_date => (p_validation_start_date - 1)
280: ,p_validation_start_date => p_validation_start_date
342: --
343: -- {End Of Comments}
344: -- ----------------------------------------------------------------------------
345: Procedure pre_update
346: (p_rec in out nocopy pay_ele_shd.g_rec_type
347: ,p_effective_date in date
348: ,p_datetrack_mode in varchar2
349: ,p_validation_start_date in date
350: ,p_validation_end_date in date
364: ,p_comment_text => p_rec.comments
365: );
366: -- Update the comments if they have changed
367: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
368: pay_ele_shd.g_old_rec.comments) then
369: hr_comm_api.upd(p_comment_id => p_rec.comment_id
370: ,p_source_table_name => 'PAY_ELEMENT_ENTRIES_F'
371: ,p_comment_text => p_rec.comments
372: );
415: --
416: -- {End Of Comments}
417: -- ----------------------------------------------------------------------------
418: Procedure post_update
419: (p_rec in pay_ele_shd.g_rec_type
420: ,p_effective_date in date
421: ,p_datetrack_mode in varchar2
422: ,p_validation_start_date in date
423: ,p_validation_end_date in date
556: => p_rec.balance_adj_cost_flag
557: ,p_all_entry_values_null
558: => p_rec.all_entry_values_null
559: ,p_effective_start_date_o
560: => pay_ele_shd.g_old_rec.effective_start_date
561: ,p_effective_end_date_o
562: => pay_ele_shd.g_old_rec.effective_end_date
563: ,p_cost_allocation_keyflex_id_o
564: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
558: => p_rec.all_entry_values_null
559: ,p_effective_start_date_o
560: => pay_ele_shd.g_old_rec.effective_start_date
561: ,p_effective_end_date_o
562: => pay_ele_shd.g_old_rec.effective_end_date
563: ,p_cost_allocation_keyflex_id_o
564: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
565: ,p_assignment_id_o
566: => pay_ele_shd.g_old_rec.assignment_id
560: => pay_ele_shd.g_old_rec.effective_start_date
561: ,p_effective_end_date_o
562: => pay_ele_shd.g_old_rec.effective_end_date
563: ,p_cost_allocation_keyflex_id_o
564: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
565: ,p_assignment_id_o
566: => pay_ele_shd.g_old_rec.assignment_id
567: ,p_updating_action_id_o
568: => pay_ele_shd.g_old_rec.updating_action_id
562: => pay_ele_shd.g_old_rec.effective_end_date
563: ,p_cost_allocation_keyflex_id_o
564: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
565: ,p_assignment_id_o
566: => pay_ele_shd.g_old_rec.assignment_id
567: ,p_updating_action_id_o
568: => pay_ele_shd.g_old_rec.updating_action_id
569: ,p_updating_action_type_o
570: => pay_ele_shd.g_old_rec.updating_action_type
564: => pay_ele_shd.g_old_rec.cost_allocation_keyflex_id
565: ,p_assignment_id_o
566: => pay_ele_shd.g_old_rec.assignment_id
567: ,p_updating_action_id_o
568: => pay_ele_shd.g_old_rec.updating_action_id
569: ,p_updating_action_type_o
570: => pay_ele_shd.g_old_rec.updating_action_type
571: ,p_element_link_id_o
572: => pay_ele_shd.g_old_rec.element_link_id
566: => pay_ele_shd.g_old_rec.assignment_id
567: ,p_updating_action_id_o
568: => pay_ele_shd.g_old_rec.updating_action_id
569: ,p_updating_action_type_o
570: => pay_ele_shd.g_old_rec.updating_action_type
571: ,p_element_link_id_o
572: => pay_ele_shd.g_old_rec.element_link_id
573: ,p_original_entry_id_o
574: => pay_ele_shd.g_old_rec.original_entry_id
568: => pay_ele_shd.g_old_rec.updating_action_id
569: ,p_updating_action_type_o
570: => pay_ele_shd.g_old_rec.updating_action_type
571: ,p_element_link_id_o
572: => pay_ele_shd.g_old_rec.element_link_id
573: ,p_original_entry_id_o
574: => pay_ele_shd.g_old_rec.original_entry_id
575: ,p_creator_type_o
576: => pay_ele_shd.g_old_rec.creator_type
570: => pay_ele_shd.g_old_rec.updating_action_type
571: ,p_element_link_id_o
572: => pay_ele_shd.g_old_rec.element_link_id
573: ,p_original_entry_id_o
574: => pay_ele_shd.g_old_rec.original_entry_id
575: ,p_creator_type_o
576: => pay_ele_shd.g_old_rec.creator_type
577: ,p_entry_type_o
578: => pay_ele_shd.g_old_rec.entry_type
572: => pay_ele_shd.g_old_rec.element_link_id
573: ,p_original_entry_id_o
574: => pay_ele_shd.g_old_rec.original_entry_id
575: ,p_creator_type_o
576: => pay_ele_shd.g_old_rec.creator_type
577: ,p_entry_type_o
578: => pay_ele_shd.g_old_rec.entry_type
579: ,p_comment_id_o
580: => pay_ele_shd.g_old_rec.comment_id
574: => pay_ele_shd.g_old_rec.original_entry_id
575: ,p_creator_type_o
576: => pay_ele_shd.g_old_rec.creator_type
577: ,p_entry_type_o
578: => pay_ele_shd.g_old_rec.entry_type
579: ,p_comment_id_o
580: => pay_ele_shd.g_old_rec.comment_id
581: ,p_comments_o
582: => pay_ele_shd.g_old_rec.comments
576: => pay_ele_shd.g_old_rec.creator_type
577: ,p_entry_type_o
578: => pay_ele_shd.g_old_rec.entry_type
579: ,p_comment_id_o
580: => pay_ele_shd.g_old_rec.comment_id
581: ,p_comments_o
582: => pay_ele_shd.g_old_rec.comments
583: ,p_creator_id_o
584: => pay_ele_shd.g_old_rec.creator_id
578: => pay_ele_shd.g_old_rec.entry_type
579: ,p_comment_id_o
580: => pay_ele_shd.g_old_rec.comment_id
581: ,p_comments_o
582: => pay_ele_shd.g_old_rec.comments
583: ,p_creator_id_o
584: => pay_ele_shd.g_old_rec.creator_id
585: ,p_reason_o
586: => pay_ele_shd.g_old_rec.reason
580: => pay_ele_shd.g_old_rec.comment_id
581: ,p_comments_o
582: => pay_ele_shd.g_old_rec.comments
583: ,p_creator_id_o
584: => pay_ele_shd.g_old_rec.creator_id
585: ,p_reason_o
586: => pay_ele_shd.g_old_rec.reason
587: ,p_target_entry_id_o
588: => pay_ele_shd.g_old_rec.target_entry_id
582: => pay_ele_shd.g_old_rec.comments
583: ,p_creator_id_o
584: => pay_ele_shd.g_old_rec.creator_id
585: ,p_reason_o
586: => pay_ele_shd.g_old_rec.reason
587: ,p_target_entry_id_o
588: => pay_ele_shd.g_old_rec.target_entry_id
589: ,p_attribute_category_o
590: => pay_ele_shd.g_old_rec.attribute_category
584: => pay_ele_shd.g_old_rec.creator_id
585: ,p_reason_o
586: => pay_ele_shd.g_old_rec.reason
587: ,p_target_entry_id_o
588: => pay_ele_shd.g_old_rec.target_entry_id
589: ,p_attribute_category_o
590: => pay_ele_shd.g_old_rec.attribute_category
591: ,p_attribute1_o
592: => pay_ele_shd.g_old_rec.attribute1
586: => pay_ele_shd.g_old_rec.reason
587: ,p_target_entry_id_o
588: => pay_ele_shd.g_old_rec.target_entry_id
589: ,p_attribute_category_o
590: => pay_ele_shd.g_old_rec.attribute_category
591: ,p_attribute1_o
592: => pay_ele_shd.g_old_rec.attribute1
593: ,p_attribute2_o
594: => pay_ele_shd.g_old_rec.attribute2
588: => pay_ele_shd.g_old_rec.target_entry_id
589: ,p_attribute_category_o
590: => pay_ele_shd.g_old_rec.attribute_category
591: ,p_attribute1_o
592: => pay_ele_shd.g_old_rec.attribute1
593: ,p_attribute2_o
594: => pay_ele_shd.g_old_rec.attribute2
595: ,p_attribute3_o
596: => pay_ele_shd.g_old_rec.attribute3
590: => pay_ele_shd.g_old_rec.attribute_category
591: ,p_attribute1_o
592: => pay_ele_shd.g_old_rec.attribute1
593: ,p_attribute2_o
594: => pay_ele_shd.g_old_rec.attribute2
595: ,p_attribute3_o
596: => pay_ele_shd.g_old_rec.attribute3
597: ,p_attribute4_o
598: => pay_ele_shd.g_old_rec.attribute4
592: => pay_ele_shd.g_old_rec.attribute1
593: ,p_attribute2_o
594: => pay_ele_shd.g_old_rec.attribute2
595: ,p_attribute3_o
596: => pay_ele_shd.g_old_rec.attribute3
597: ,p_attribute4_o
598: => pay_ele_shd.g_old_rec.attribute4
599: ,p_attribute5_o
600: => pay_ele_shd.g_old_rec.attribute5
594: => pay_ele_shd.g_old_rec.attribute2
595: ,p_attribute3_o
596: => pay_ele_shd.g_old_rec.attribute3
597: ,p_attribute4_o
598: => pay_ele_shd.g_old_rec.attribute4
599: ,p_attribute5_o
600: => pay_ele_shd.g_old_rec.attribute5
601: ,p_attribute6_o
602: => pay_ele_shd.g_old_rec.attribute6
596: => pay_ele_shd.g_old_rec.attribute3
597: ,p_attribute4_o
598: => pay_ele_shd.g_old_rec.attribute4
599: ,p_attribute5_o
600: => pay_ele_shd.g_old_rec.attribute5
601: ,p_attribute6_o
602: => pay_ele_shd.g_old_rec.attribute6
603: ,p_attribute7_o
604: => pay_ele_shd.g_old_rec.attribute7
598: => pay_ele_shd.g_old_rec.attribute4
599: ,p_attribute5_o
600: => pay_ele_shd.g_old_rec.attribute5
601: ,p_attribute6_o
602: => pay_ele_shd.g_old_rec.attribute6
603: ,p_attribute7_o
604: => pay_ele_shd.g_old_rec.attribute7
605: ,p_attribute8_o
606: => pay_ele_shd.g_old_rec.attribute8
600: => pay_ele_shd.g_old_rec.attribute5
601: ,p_attribute6_o
602: => pay_ele_shd.g_old_rec.attribute6
603: ,p_attribute7_o
604: => pay_ele_shd.g_old_rec.attribute7
605: ,p_attribute8_o
606: => pay_ele_shd.g_old_rec.attribute8
607: ,p_attribute9_o
608: => pay_ele_shd.g_old_rec.attribute9
602: => pay_ele_shd.g_old_rec.attribute6
603: ,p_attribute7_o
604: => pay_ele_shd.g_old_rec.attribute7
605: ,p_attribute8_o
606: => pay_ele_shd.g_old_rec.attribute8
607: ,p_attribute9_o
608: => pay_ele_shd.g_old_rec.attribute9
609: ,p_attribute10_o
610: => pay_ele_shd.g_old_rec.attribute10
604: => pay_ele_shd.g_old_rec.attribute7
605: ,p_attribute8_o
606: => pay_ele_shd.g_old_rec.attribute8
607: ,p_attribute9_o
608: => pay_ele_shd.g_old_rec.attribute9
609: ,p_attribute10_o
610: => pay_ele_shd.g_old_rec.attribute10
611: ,p_attribute11_o
612: => pay_ele_shd.g_old_rec.attribute11
606: => pay_ele_shd.g_old_rec.attribute8
607: ,p_attribute9_o
608: => pay_ele_shd.g_old_rec.attribute9
609: ,p_attribute10_o
610: => pay_ele_shd.g_old_rec.attribute10
611: ,p_attribute11_o
612: => pay_ele_shd.g_old_rec.attribute11
613: ,p_attribute12_o
614: => pay_ele_shd.g_old_rec.attribute12
608: => pay_ele_shd.g_old_rec.attribute9
609: ,p_attribute10_o
610: => pay_ele_shd.g_old_rec.attribute10
611: ,p_attribute11_o
612: => pay_ele_shd.g_old_rec.attribute11
613: ,p_attribute12_o
614: => pay_ele_shd.g_old_rec.attribute12
615: ,p_attribute13_o
616: => pay_ele_shd.g_old_rec.attribute13
610: => pay_ele_shd.g_old_rec.attribute10
611: ,p_attribute11_o
612: => pay_ele_shd.g_old_rec.attribute11
613: ,p_attribute12_o
614: => pay_ele_shd.g_old_rec.attribute12
615: ,p_attribute13_o
616: => pay_ele_shd.g_old_rec.attribute13
617: ,p_attribute14_o
618: => pay_ele_shd.g_old_rec.attribute14
612: => pay_ele_shd.g_old_rec.attribute11
613: ,p_attribute12_o
614: => pay_ele_shd.g_old_rec.attribute12
615: ,p_attribute13_o
616: => pay_ele_shd.g_old_rec.attribute13
617: ,p_attribute14_o
618: => pay_ele_shd.g_old_rec.attribute14
619: ,p_attribute15_o
620: => pay_ele_shd.g_old_rec.attribute15
614: => pay_ele_shd.g_old_rec.attribute12
615: ,p_attribute13_o
616: => pay_ele_shd.g_old_rec.attribute13
617: ,p_attribute14_o
618: => pay_ele_shd.g_old_rec.attribute14
619: ,p_attribute15_o
620: => pay_ele_shd.g_old_rec.attribute15
621: ,p_attribute16_o
622: => pay_ele_shd.g_old_rec.attribute16
616: => pay_ele_shd.g_old_rec.attribute13
617: ,p_attribute14_o
618: => pay_ele_shd.g_old_rec.attribute14
619: ,p_attribute15_o
620: => pay_ele_shd.g_old_rec.attribute15
621: ,p_attribute16_o
622: => pay_ele_shd.g_old_rec.attribute16
623: ,p_attribute17_o
624: => pay_ele_shd.g_old_rec.attribute17
618: => pay_ele_shd.g_old_rec.attribute14
619: ,p_attribute15_o
620: => pay_ele_shd.g_old_rec.attribute15
621: ,p_attribute16_o
622: => pay_ele_shd.g_old_rec.attribute16
623: ,p_attribute17_o
624: => pay_ele_shd.g_old_rec.attribute17
625: ,p_attribute18_o
626: => pay_ele_shd.g_old_rec.attribute18
620: => pay_ele_shd.g_old_rec.attribute15
621: ,p_attribute16_o
622: => pay_ele_shd.g_old_rec.attribute16
623: ,p_attribute17_o
624: => pay_ele_shd.g_old_rec.attribute17
625: ,p_attribute18_o
626: => pay_ele_shd.g_old_rec.attribute18
627: ,p_attribute19_o
628: => pay_ele_shd.g_old_rec.attribute19
622: => pay_ele_shd.g_old_rec.attribute16
623: ,p_attribute17_o
624: => pay_ele_shd.g_old_rec.attribute17
625: ,p_attribute18_o
626: => pay_ele_shd.g_old_rec.attribute18
627: ,p_attribute19_o
628: => pay_ele_shd.g_old_rec.attribute19
629: ,p_attribute20_o
630: => pay_ele_shd.g_old_rec.attribute20
624: => pay_ele_shd.g_old_rec.attribute17
625: ,p_attribute18_o
626: => pay_ele_shd.g_old_rec.attribute18
627: ,p_attribute19_o
628: => pay_ele_shd.g_old_rec.attribute19
629: ,p_attribute20_o
630: => pay_ele_shd.g_old_rec.attribute20
631: -- --
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
626: => pay_ele_shd.g_old_rec.attribute18
627: ,p_attribute19_o
628: => pay_ele_shd.g_old_rec.attribute19
629: ,p_attribute20_o
630: => pay_ele_shd.g_old_rec.attribute20
631: -- --
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
628: => pay_ele_shd.g_old_rec.attribute19
629: ,p_attribute20_o
630: => pay_ele_shd.g_old_rec.attribute20
631: -- --
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
630: => pay_ele_shd.g_old_rec.attribute20
631: -- --
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
631: -- --
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
632: ,--Altered next 30 lines, 20-FEB-03 changed p_rec -> pay_ele_shd.g_old_rec
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
633: --as looked like a cut-n-paste accident
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
634: p_entry_information_category_o => pay_ele_shd.g_old_rec.entry_information_category,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
635: p_entry_information1_o => pay_ele_shd.g_old_rec.entry_information1,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
636: p_entry_information2_o => pay_ele_shd.g_old_rec.entry_information2,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
637: p_entry_information3_o => pay_ele_shd.g_old_rec.entry_information3,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
638: p_entry_information4_o => pay_ele_shd.g_old_rec.entry_information4,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
639: p_entry_information5_o => pay_ele_shd.g_old_rec.entry_information5,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
640: p_entry_information6_o => pay_ele_shd.g_old_rec.entry_information6,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
641: p_entry_information7_o => pay_ele_shd.g_old_rec.entry_information7,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
642: p_entry_information8_o => pay_ele_shd.g_old_rec.entry_information8,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
643: p_entry_information9_o => pay_ele_shd.g_old_rec.entry_information9,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
644: p_entry_information10_o => pay_ele_shd.g_old_rec.entry_information10,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
645: p_entry_information11_o => pay_ele_shd.g_old_rec.entry_information11,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
646: p_entry_information12_o => pay_ele_shd.g_old_rec.entry_information12,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
647: p_entry_information13_o => pay_ele_shd.g_old_rec.entry_information13,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
648: p_entry_information14_o => pay_ele_shd.g_old_rec.entry_information14,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
649: p_entry_information15_o => pay_ele_shd.g_old_rec.entry_information15,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
650: p_entry_information16_o => pay_ele_shd.g_old_rec.entry_information16,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
651: p_entry_information17_o => pay_ele_shd.g_old_rec.entry_information17,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
652: p_entry_information18_o => pay_ele_shd.g_old_rec.entry_information18,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
653: p_entry_information19_o => pay_ele_shd.g_old_rec.entry_information19,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
654: p_entry_information20_o => pay_ele_shd.g_old_rec.entry_information20,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
655: p_entry_information21_o => pay_ele_shd.g_old_rec.entry_information21,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
656: p_entry_information22_o => pay_ele_shd.g_old_rec.entry_information22,
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
657: p_entry_information23_o => pay_ele_shd.g_old_rec.entry_information23,
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
658: p_entry_information24_o => pay_ele_shd.g_old_rec.entry_information24,
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
666: => pay_ele_shd.g_old_rec.subpriority
659: p_entry_information25_o => pay_ele_shd.g_old_rec.entry_information25,
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
666: => pay_ele_shd.g_old_rec.subpriority
667: ,p_personal_payment_method_id_o
660: p_entry_information26_o => pay_ele_shd.g_old_rec.entry_information26,
661: p_entry_information27_o => pay_ele_shd.g_old_rec.entry_information27,
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
666: => pay_ele_shd.g_old_rec.subpriority
667: ,p_personal_payment_method_id_o
668: => pay_ele_shd.g_old_rec.personal_payment_method_id
662: p_entry_information28_o => pay_ele_shd.g_old_rec.entry_information28,
663: p_entry_information29_o => pay_ele_shd.g_old_rec.entry_information29,
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
666: => pay_ele_shd.g_old_rec.subpriority
667: ,p_personal_payment_method_id_o
668: => pay_ele_shd.g_old_rec.personal_payment_method_id
669: ,p_date_earned_o
670: => pay_ele_shd.g_old_rec.date_earned
664: p_entry_information30_o => pay_ele_shd.g_old_rec.entry_information30
665: ,p_subpriority_o
666: => pay_ele_shd.g_old_rec.subpriority
667: ,p_personal_payment_method_id_o
668: => pay_ele_shd.g_old_rec.personal_payment_method_id
669: ,p_date_earned_o
670: => pay_ele_shd.g_old_rec.date_earned
671: ,p_object_version_number_o
672: => pay_ele_shd.g_old_rec.object_version_number
666: => pay_ele_shd.g_old_rec.subpriority
667: ,p_personal_payment_method_id_o
668: => pay_ele_shd.g_old_rec.personal_payment_method_id
669: ,p_date_earned_o
670: => pay_ele_shd.g_old_rec.date_earned
671: ,p_object_version_number_o
672: => pay_ele_shd.g_old_rec.object_version_number
673: ,p_source_id_o
674: => pay_ele_shd.g_old_rec.source_id
668: => pay_ele_shd.g_old_rec.personal_payment_method_id
669: ,p_date_earned_o
670: => pay_ele_shd.g_old_rec.date_earned
671: ,p_object_version_number_o
672: => pay_ele_shd.g_old_rec.object_version_number
673: ,p_source_id_o
674: => pay_ele_shd.g_old_rec.source_id
675: ,p_balance_adj_cost_flag_o
676: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
670: => pay_ele_shd.g_old_rec.date_earned
671: ,p_object_version_number_o
672: => pay_ele_shd.g_old_rec.object_version_number
673: ,p_source_id_o
674: => pay_ele_shd.g_old_rec.source_id
675: ,p_balance_adj_cost_flag_o
676: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
677: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
678: ,p_all_entry_values_null_o
672: => pay_ele_shd.g_old_rec.object_version_number
673: ,p_source_id_o
674: => pay_ele_shd.g_old_rec.source_id
675: ,p_balance_adj_cost_flag_o
676: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
677: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
678: ,p_all_entry_values_null_o
679: => pay_ele_shd.g_old_rec.all_entry_values_null
680: );
673: ,p_source_id_o
674: => pay_ele_shd.g_old_rec.source_id
675: ,p_balance_adj_cost_flag_o
676: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
677: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
678: ,p_all_entry_values_null_o
679: => pay_ele_shd.g_old_rec.all_entry_values_null
680: );
681: --
675: ,p_balance_adj_cost_flag_o
676: => pay_ele_shd.g_old_rec.balance_adj_cost_flag
677: ,p_element_type_id_o => pay_ele_shd.g_old_rec.element_type_id
678: ,p_all_entry_values_null_o
679: => pay_ele_shd.g_old_rec.all_entry_values_null
680: );
681: --
682: exception
683: --
739: --
740: -- {End Of Comments}
741: -- ----------------------------------------------------------------------------
742: Procedure convert_defs
743: (p_rec in out nocopy pay_ele_shd.g_rec_type
744: ) is
745: --
746: Begin
747: --
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
758: p_rec.assignment_id :=
759: pay_ele_shd.g_old_rec.assignment_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
762: p_rec.updating_action_id :=
763: pay_ele_shd.g_old_rec.updating_action_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
766: p_rec.updating_action_type :=
767: pay_ele_shd.g_old_rec.updating_action_type;
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
770: p_rec.element_link_id :=
771: pay_ele_shd.g_old_rec.element_link_id;
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
774: p_rec.original_entry_id :=
775: pay_ele_shd.g_old_rec.original_entry_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
778: p_rec.creator_type :=
779: pay_ele_shd.g_old_rec.creator_type;
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
782: p_rec.entry_type :=
783: pay_ele_shd.g_old_rec.entry_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
786: p_rec.comment_id :=
787: pay_ele_shd.g_old_rec.comment_id;
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
790: p_rec.comments :=
791: pay_ele_shd.g_old_rec.comments;
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
794: p_rec.creator_id :=
795: pay_ele_shd.g_old_rec.creator_id;
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
798: p_rec.reason :=
799: pay_ele_shd.g_old_rec.reason;
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
802: p_rec.target_entry_id :=
803: pay_ele_shd.g_old_rec.target_entry_id;
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
806: p_rec.attribute_category :=
807: pay_ele_shd.g_old_rec.attribute_category;
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
810: p_rec.attribute1 :=
811: pay_ele_shd.g_old_rec.attribute1;
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
814: p_rec.attribute2 :=
815: pay_ele_shd.g_old_rec.attribute2;
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
818: p_rec.attribute3 :=
819: pay_ele_shd.g_old_rec.attribute3;
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
822: p_rec.attribute4 :=
823: pay_ele_shd.g_old_rec.attribute4;
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
826: p_rec.attribute5 :=
827: pay_ele_shd.g_old_rec.attribute5;
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
830: p_rec.attribute6 :=
831: pay_ele_shd.g_old_rec.attribute6;
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
834: p_rec.attribute7 :=
835: pay_ele_shd.g_old_rec.attribute7;
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
838: p_rec.attribute8 :=
839: pay_ele_shd.g_old_rec.attribute8;
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
842: p_rec.attribute9 :=
843: pay_ele_shd.g_old_rec.attribute9;
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
846: p_rec.attribute10 :=
847: pay_ele_shd.g_old_rec.attribute10;
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
850: p_rec.attribute11 :=
851: pay_ele_shd.g_old_rec.attribute11;
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
854: p_rec.attribute12 :=
855: pay_ele_shd.g_old_rec.attribute12;
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
858: p_rec.attribute13 :=
859: pay_ele_shd.g_old_rec.attribute13;
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
862: p_rec.attribute14 :=
863: pay_ele_shd.g_old_rec.attribute14;
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
866: p_rec.attribute15 :=
867: pay_ele_shd.g_old_rec.attribute15;
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
870: p_rec.attribute16 :=
871: pay_ele_shd.g_old_rec.attribute16;
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
874: p_rec.attribute17 :=
875: pay_ele_shd.g_old_rec.attribute17;
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
878: p_rec.attribute18 :=
879: pay_ele_shd.g_old_rec.attribute18;
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
882: p_rec.attribute19 :=
883: pay_ele_shd.g_old_rec.attribute19;
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
886: p_rec.attribute20 :=
887: pay_ele_shd.g_old_rec.attribute20;
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
890: p_rec.subpriority :=
891: pay_ele_shd.g_old_rec.subpriority;
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
894: p_rec.personal_payment_method_id :=
895: pay_ele_shd.g_old_rec.personal_payment_method_id;
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
898: p_rec.date_earned :=
899: pay_ele_shd.g_old_rec.date_earned;
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
902: p_rec.source_id :=
903: pay_ele_shd.g_old_rec.source_id;
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
906: p_rec.balance_adj_cost_flag :=
907: pay_ele_shd.g_old_rec.balance_adj_cost_flag;
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
910: p_rec.element_type_id :=
911: pay_ele_shd.g_old_rec.element_type_id;
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
914: p_rec.all_entry_values_null :=
915: pay_ele_shd.g_old_rec.all_entry_values_null;
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: --
918: End convert_defs;
919: --
922: -- ----------------------------------------------------------------------------
923: Procedure upd
924: (p_effective_date in date
925: ,p_datetrack_mode in varchar2
926: ,p_rec in out nocopy pay_ele_shd.g_rec_type
927: ) is
928: --
929: l_proc varchar2(72) := g_package||'upd';
930: l_validation_start_date date;
938: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
939: --
940: -- We must lock the row which we need to update.
941: --
942: pay_ele_shd.lck
943: (p_effective_date => p_effective_date
944: ,p_datetrack_mode => p_datetrack_mode
945: ,p_element_entry_id => p_rec.element_entry_id
946: ,p_object_version_number => p_rec.object_version_number
1045: ,p_effective_end_date out nocopy date
1046: ,p_comment_id out nocopy number
1047: ) is
1048: --
1049: l_rec pay_ele_shd.g_rec_type;
1050: l_proc varchar2(72) := g_package||'upd';
1051: --
1052: Begin
1053: hr_utility.set_location('Entering:'||l_proc, 5);
1055: -- Call conversion function to turn arguments into the
1056: -- l_rec structure.
1057: --
1058: l_rec :=
1059: pay_ele_shd.convert_args
1060: (p_element_entry_id
1061: ,null
1062: ,null
1063: ,p_cost_allocation_keyflex_id