54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy pay_pel_shd.g_rec_type
59: ,p_effective_date in date
60: ,p_datetrack_mode in varchar2
61: ,p_validation_start_date in date
62: ,p_validation_end_date in date
79: ,p_base_key_column => 'element_link_id'
80: ,p_base_key_value => p_rec.element_link_id
81: );
82: --
83: pay_pel_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the pay_element_links_f Row
86: --
87: update pay_element_links_f
126: where element_link_id = p_rec.element_link_id
127: and effective_start_date = p_validation_start_date
128: and effective_end_date = p_validation_end_date;
129: --
130: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
131: --
132: -- Set the effective start and end dates
133: --
134: p_rec.effective_start_date := p_validation_start_date;
138: hr_utility.set_location(' Leaving:'||l_proc, 15);
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
139: Exception
140: When hr_api.check_integrity_violated Then
141: -- A check constraint has been violated
142: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
143: pay_pel_shd.constraint_error
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
144: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
145: When hr_api.unique_integrity_violated Then
146: -- Unique integrity has been violated
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;
147: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
148: pay_pel_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When Others Then
151: pay_pel_shd.g_api_dml := false; -- Unset the api dml status
152: Raise;
153: End dt_update_dml;
154: --
155: -- ----------------------------------------------------------------------------
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure update_dml
187: (p_rec in out nocopy pay_pel_shd.g_rec_type
188: ,p_effective_date in date
189: ,p_datetrack_mode in varchar2
190: ,p_validation_start_date in date
191: ,p_validation_end_date in date
250: --
251: -- {End Of Comments}
252: -- ----------------------------------------------------------------------------
253: Procedure dt_pre_update
254: (p_rec in out nocopy pay_pel_shd.g_rec_type
255: ,p_effective_date in date
256: ,p_datetrack_mode in varchar2
257: ,p_validation_start_date in date
258: ,p_validation_end_date in date
267: --
268: -- Update the current effective end date
269: --
270:
271: pay_pel_shd.upd_effective_end_date
272: (p_effective_date => p_effective_date
273: ,p_base_key_value => p_rec.element_link_id
274: ,p_new_effective_end_date => (p_validation_start_date - 1)
275: ,p_validation_start_date => p_validation_start_date
336: --
337: -- {End Of Comments}
338: -- ----------------------------------------------------------------------------
339: Procedure pre_update
340: (p_rec in out nocopy pay_pel_shd.g_rec_type
341: ,p_effective_date in date
342: ,p_datetrack_mode in varchar2
343: ,p_validation_start_date in date
344: ,p_validation_end_date in date
358: ,p_comment_text => p_rec.comments
359: );
360: -- Update the comments if they have changed
361: ElsIf (p_rec.comment_id is not null and p_rec.comments <>
362: pay_pel_shd.g_old_rec.comments) then
363: hr_comm_api.upd(p_comment_id => p_rec.comment_id
364: ,p_source_table_name => 'PAY_ELEMENT_LINKS_F'
365: ,p_comment_text => p_rec.comments
366: );
409: --
410: -- {End Of Comments}
411: -- ----------------------------------------------------------------------------
412: Procedure post_update
413: (p_rec in pay_pel_shd.g_rec_type
414: ,p_effective_date in date
415: ,p_datetrack_mode in varchar2
416: ,p_validation_start_date in date
417: ,p_validation_end_date in date
530: => p_rec.attribute20
531: ,p_object_version_number
532: => p_rec.object_version_number
533: ,p_effective_start_date_o
534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
532: => p_rec.object_version_number
533: ,p_effective_start_date_o
534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
534: => pay_pel_shd.g_old_rec.effective_start_date
535: ,p_effective_end_date_o
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
536: => pay_pel_shd.g_old_rec.effective_end_date
537: ,p_payroll_id_o
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
538: => pay_pel_shd.g_old_rec.payroll_id
539: ,p_job_id_o
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
540: => pay_pel_shd.g_old_rec.job_id
541: ,p_position_id_o
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
542: => pay_pel_shd.g_old_rec.position_id
543: ,p_people_group_id_o
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
544: => pay_pel_shd.g_old_rec.people_group_id
545: ,p_cost_allocation_keyflex_id_o
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
546: => pay_pel_shd.g_old_rec.cost_allocation_keyflex_id
547: ,p_organization_id_o
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
548: => pay_pel_shd.g_old_rec.organization_id
549: ,p_element_type_id_o
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
550: => pay_pel_shd.g_old_rec.element_type_id
551: ,p_location_id_o
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
552: => pay_pel_shd.g_old_rec.location_id
553: ,p_grade_id_o
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
554: => pay_pel_shd.g_old_rec.grade_id
555: ,p_balancing_keyflex_id_o
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
556: => pay_pel_shd.g_old_rec.balancing_keyflex_id
557: ,p_business_group_id_o
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
558: => pay_pel_shd.g_old_rec.business_group_id
559: ,p_element_set_id_o
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
560: => pay_pel_shd.g_old_rec.element_set_id
561: ,p_pay_basis_id_o
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
562: => pay_pel_shd.g_old_rec.pay_basis_id
563: ,p_costable_type_o
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
564: => pay_pel_shd.g_old_rec.costable_type
565: ,p_link_to_all_payrolls_flag_o
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
566: => pay_pel_shd.g_old_rec.link_to_all_payrolls_flag
567: ,p_multiply_value_flag_o
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
568: => pay_pel_shd.g_old_rec.multiply_value_flag
569: ,p_standard_link_flag_o
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
570: => pay_pel_shd.g_old_rec.standard_link_flag
571: ,p_transfer_to_gl_flag_o
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
572: => pay_pel_shd.g_old_rec.transfer_to_gl_flag
573: ,p_comment_id_o
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
574: => pay_pel_shd.g_old_rec.comment_id
575: ,p_comments_o
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
576: => pay_pel_shd.g_old_rec.comments
577: ,p_employment_category_o
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
578: => pay_pel_shd.g_old_rec.employment_category
579: ,p_qualifying_age_o
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
580: => pay_pel_shd.g_old_rec.qualifying_age
581: ,p_qualifying_length_of_servi_o
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
582: => pay_pel_shd.g_old_rec.qualifying_length_of_service
583: ,p_qualifying_units_o
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
584: => pay_pel_shd.g_old_rec.qualifying_units
585: ,p_attribute_category_o
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
586: => pay_pel_shd.g_old_rec.attribute_category
587: ,p_attribute1_o
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
588: => pay_pel_shd.g_old_rec.attribute1
589: ,p_attribute2_o
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
590: => pay_pel_shd.g_old_rec.attribute2
591: ,p_attribute3_o
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
592: => pay_pel_shd.g_old_rec.attribute3
593: ,p_attribute4_o
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
594: => pay_pel_shd.g_old_rec.attribute4
595: ,p_attribute5_o
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
596: => pay_pel_shd.g_old_rec.attribute5
597: ,p_attribute6_o
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
598: => pay_pel_shd.g_old_rec.attribute6
599: ,p_attribute7_o
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
600: => pay_pel_shd.g_old_rec.attribute7
601: ,p_attribute8_o
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
602: => pay_pel_shd.g_old_rec.attribute8
603: ,p_attribute9_o
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
604: => pay_pel_shd.g_old_rec.attribute9
605: ,p_attribute10_o
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
606: => pay_pel_shd.g_old_rec.attribute10
607: ,p_attribute11_o
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
608: => pay_pel_shd.g_old_rec.attribute11
609: ,p_attribute12_o
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
610: => pay_pel_shd.g_old_rec.attribute12
611: ,p_attribute13_o
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
612: => pay_pel_shd.g_old_rec.attribute13
613: ,p_attribute14_o
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
614: => pay_pel_shd.g_old_rec.attribute14
615: ,p_attribute15_o
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
616: => pay_pel_shd.g_old_rec.attribute15
617: ,p_attribute16_o
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
618: => pay_pel_shd.g_old_rec.attribute16
619: ,p_attribute17_o
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
620: => pay_pel_shd.g_old_rec.attribute17
621: ,p_attribute18_o
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number
622: => pay_pel_shd.g_old_rec.attribute18
623: ,p_attribute19_o
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number
629: );
630: --
624: => pay_pel_shd.g_old_rec.attribute19
625: ,p_attribute20_o
626: => pay_pel_shd.g_old_rec.attribute20
627: ,p_object_version_number_o
628: => pay_pel_shd.g_old_rec.object_version_number
629: );
630: --
631: exception
632: --
684: --
685: -- {End Of Comments}
686: -- ----------------------------------------------------------------------------
687: Procedure convert_defs
688: (p_rec in out nocopy pay_pel_shd.g_rec_type
689: ) is
690: --
691: Begin
692: --
696: -- is being used then we must set to the 'current' argument value.
697: --
698: If (p_rec.payroll_id = hr_api.g_number) then
699: p_rec.payroll_id :=
700: pay_pel_shd.g_old_rec.payroll_id;
701: End If;
702: If (p_rec.job_id = hr_api.g_number) then
703: p_rec.job_id :=
704: pay_pel_shd.g_old_rec.job_id;
700: pay_pel_shd.g_old_rec.payroll_id;
701: End If;
702: If (p_rec.job_id = hr_api.g_number) then
703: p_rec.job_id :=
704: pay_pel_shd.g_old_rec.job_id;
705: End If;
706: If (p_rec.position_id = hr_api.g_number) then
707: p_rec.position_id :=
708: pay_pel_shd.g_old_rec.position_id;
704: pay_pel_shd.g_old_rec.job_id;
705: End If;
706: If (p_rec.position_id = hr_api.g_number) then
707: p_rec.position_id :=
708: pay_pel_shd.g_old_rec.position_id;
709: End If;
710: If (p_rec.people_group_id = hr_api.g_number) then
711: p_rec.people_group_id :=
712: pay_pel_shd.g_old_rec.people_group_id;
708: pay_pel_shd.g_old_rec.position_id;
709: End If;
710: If (p_rec.people_group_id = hr_api.g_number) then
711: p_rec.people_group_id :=
712: pay_pel_shd.g_old_rec.people_group_id;
713: End If;
714: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
715: p_rec.cost_allocation_keyflex_id :=
716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;
712: pay_pel_shd.g_old_rec.people_group_id;
713: End If;
714: If (p_rec.cost_allocation_keyflex_id = hr_api.g_number) then
715: p_rec.cost_allocation_keyflex_id :=
716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;
717: End If;
718: If (p_rec.organization_id = hr_api.g_number) then
719: p_rec.organization_id :=
720: pay_pel_shd.g_old_rec.organization_id;
716: pay_pel_shd.g_old_rec.cost_allocation_keyflex_id;
717: End If;
718: If (p_rec.organization_id = hr_api.g_number) then
719: p_rec.organization_id :=
720: pay_pel_shd.g_old_rec.organization_id;
721: End If;
722: If (p_rec.element_type_id = hr_api.g_number) then
723: p_rec.element_type_id :=
724: pay_pel_shd.g_old_rec.element_type_id;
720: pay_pel_shd.g_old_rec.organization_id;
721: End If;
722: If (p_rec.element_type_id = hr_api.g_number) then
723: p_rec.element_type_id :=
724: pay_pel_shd.g_old_rec.element_type_id;
725: End If;
726: If (p_rec.location_id = hr_api.g_number) then
727: p_rec.location_id :=
728: pay_pel_shd.g_old_rec.location_id;
724: pay_pel_shd.g_old_rec.element_type_id;
725: End If;
726: If (p_rec.location_id = hr_api.g_number) then
727: p_rec.location_id :=
728: pay_pel_shd.g_old_rec.location_id;
729: End If;
730: If (p_rec.grade_id = hr_api.g_number) then
731: p_rec.grade_id :=
732: pay_pel_shd.g_old_rec.grade_id;
728: pay_pel_shd.g_old_rec.location_id;
729: End If;
730: If (p_rec.grade_id = hr_api.g_number) then
731: p_rec.grade_id :=
732: pay_pel_shd.g_old_rec.grade_id;
733: End If;
734: If (p_rec.balancing_keyflex_id = hr_api.g_number) then
735: p_rec.balancing_keyflex_id :=
736: pay_pel_shd.g_old_rec.balancing_keyflex_id;
732: pay_pel_shd.g_old_rec.grade_id;
733: End If;
734: If (p_rec.balancing_keyflex_id = hr_api.g_number) then
735: p_rec.balancing_keyflex_id :=
736: pay_pel_shd.g_old_rec.balancing_keyflex_id;
737: End If;
738: If (p_rec.business_group_id = hr_api.g_number) then
739: p_rec.business_group_id :=
740: pay_pel_shd.g_old_rec.business_group_id;
736: pay_pel_shd.g_old_rec.balancing_keyflex_id;
737: End If;
738: If (p_rec.business_group_id = hr_api.g_number) then
739: p_rec.business_group_id :=
740: pay_pel_shd.g_old_rec.business_group_id;
741: End If;
742: If (p_rec.element_set_id = hr_api.g_number) then
743: p_rec.element_set_id :=
744: pay_pel_shd.g_old_rec.element_set_id;
740: pay_pel_shd.g_old_rec.business_group_id;
741: End If;
742: If (p_rec.element_set_id = hr_api.g_number) then
743: p_rec.element_set_id :=
744: pay_pel_shd.g_old_rec.element_set_id;
745: End If;
746: If (p_rec.pay_basis_id = hr_api.g_number) then
747: p_rec.pay_basis_id :=
748: pay_pel_shd.g_old_rec.pay_basis_id;
744: pay_pel_shd.g_old_rec.element_set_id;
745: End If;
746: If (p_rec.pay_basis_id = hr_api.g_number) then
747: p_rec.pay_basis_id :=
748: pay_pel_shd.g_old_rec.pay_basis_id;
749: End If;
750: If (p_rec.costable_type = hr_api.g_varchar2) then
751: p_rec.costable_type :=
752: pay_pel_shd.g_old_rec.costable_type;
748: pay_pel_shd.g_old_rec.pay_basis_id;
749: End If;
750: If (p_rec.costable_type = hr_api.g_varchar2) then
751: p_rec.costable_type :=
752: pay_pel_shd.g_old_rec.costable_type;
753: End If;
754: If (p_rec.link_to_all_payrolls_flag = hr_api.g_varchar2) then
755: p_rec.link_to_all_payrolls_flag :=
756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;
752: pay_pel_shd.g_old_rec.costable_type;
753: End If;
754: If (p_rec.link_to_all_payrolls_flag = hr_api.g_varchar2) then
755: p_rec.link_to_all_payrolls_flag :=
756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;
757: End If;
758: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
759: p_rec.multiply_value_flag :=
760: pay_pel_shd.g_old_rec.multiply_value_flag;
756: pay_pel_shd.g_old_rec.link_to_all_payrolls_flag;
757: End If;
758: If (p_rec.multiply_value_flag = hr_api.g_varchar2) then
759: p_rec.multiply_value_flag :=
760: pay_pel_shd.g_old_rec.multiply_value_flag;
761: End If;
762: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
763: p_rec.standard_link_flag :=
764: pay_pel_shd.g_old_rec.standard_link_flag;
760: pay_pel_shd.g_old_rec.multiply_value_flag;
761: End If;
762: If (p_rec.standard_link_flag = hr_api.g_varchar2) then
763: p_rec.standard_link_flag :=
764: pay_pel_shd.g_old_rec.standard_link_flag;
765: End If;
766: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
767: p_rec.transfer_to_gl_flag :=
768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;
764: pay_pel_shd.g_old_rec.standard_link_flag;
765: End If;
766: If (p_rec.transfer_to_gl_flag = hr_api.g_varchar2) then
767: p_rec.transfer_to_gl_flag :=
768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;
769: End If;
770: If (p_rec.comment_id = hr_api.g_number) then
771: p_rec.comment_id :=
772: pay_pel_shd.g_old_rec.comment_id;
768: pay_pel_shd.g_old_rec.transfer_to_gl_flag;
769: End If;
770: If (p_rec.comment_id = hr_api.g_number) then
771: p_rec.comment_id :=
772: pay_pel_shd.g_old_rec.comment_id;
773: End If;
774: If (p_rec.comments = hr_api.g_varchar2) then
775: p_rec.comments :=
776: pay_pel_shd.g_old_rec.comments;
772: pay_pel_shd.g_old_rec.comment_id;
773: End If;
774: If (p_rec.comments = hr_api.g_varchar2) then
775: p_rec.comments :=
776: pay_pel_shd.g_old_rec.comments;
777: End If;
778: If (p_rec.employment_category = hr_api.g_varchar2) then
779: p_rec.employment_category :=
780: pay_pel_shd.g_old_rec.employment_category;
776: pay_pel_shd.g_old_rec.comments;
777: End If;
778: If (p_rec.employment_category = hr_api.g_varchar2) then
779: p_rec.employment_category :=
780: pay_pel_shd.g_old_rec.employment_category;
781: End If;
782: If (p_rec.qualifying_age = hr_api.g_number) then
783: p_rec.qualifying_age :=
784: pay_pel_shd.g_old_rec.qualifying_age;
780: pay_pel_shd.g_old_rec.employment_category;
781: End If;
782: If (p_rec.qualifying_age = hr_api.g_number) then
783: p_rec.qualifying_age :=
784: pay_pel_shd.g_old_rec.qualifying_age;
785: End If;
786: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
787: p_rec.qualifying_length_of_service :=
788: pay_pel_shd.g_old_rec.qualifying_length_of_service;
784: pay_pel_shd.g_old_rec.qualifying_age;
785: End If;
786: If (p_rec.qualifying_length_of_service = hr_api.g_number) then
787: p_rec.qualifying_length_of_service :=
788: pay_pel_shd.g_old_rec.qualifying_length_of_service;
789: End If;
790: If (p_rec.qualifying_units = hr_api.g_varchar2) then
791: p_rec.qualifying_units :=
792: pay_pel_shd.g_old_rec.qualifying_units;
788: pay_pel_shd.g_old_rec.qualifying_length_of_service;
789: End If;
790: If (p_rec.qualifying_units = hr_api.g_varchar2) then
791: p_rec.qualifying_units :=
792: pay_pel_shd.g_old_rec.qualifying_units;
793: End If;
794: If (p_rec.attribute_category = hr_api.g_varchar2) then
795: p_rec.attribute_category :=
796: pay_pel_shd.g_old_rec.attribute_category;
792: pay_pel_shd.g_old_rec.qualifying_units;
793: End If;
794: If (p_rec.attribute_category = hr_api.g_varchar2) then
795: p_rec.attribute_category :=
796: pay_pel_shd.g_old_rec.attribute_category;
797: End If;
798: If (p_rec.attribute1 = hr_api.g_varchar2) then
799: p_rec.attribute1 :=
800: pay_pel_shd.g_old_rec.attribute1;
796: pay_pel_shd.g_old_rec.attribute_category;
797: End If;
798: If (p_rec.attribute1 = hr_api.g_varchar2) then
799: p_rec.attribute1 :=
800: pay_pel_shd.g_old_rec.attribute1;
801: End If;
802: If (p_rec.attribute2 = hr_api.g_varchar2) then
803: p_rec.attribute2 :=
804: pay_pel_shd.g_old_rec.attribute2;
800: pay_pel_shd.g_old_rec.attribute1;
801: End If;
802: If (p_rec.attribute2 = hr_api.g_varchar2) then
803: p_rec.attribute2 :=
804: pay_pel_shd.g_old_rec.attribute2;
805: End If;
806: If (p_rec.attribute3 = hr_api.g_varchar2) then
807: p_rec.attribute3 :=
808: pay_pel_shd.g_old_rec.attribute3;
804: pay_pel_shd.g_old_rec.attribute2;
805: End If;
806: If (p_rec.attribute3 = hr_api.g_varchar2) then
807: p_rec.attribute3 :=
808: pay_pel_shd.g_old_rec.attribute3;
809: End If;
810: If (p_rec.attribute4 = hr_api.g_varchar2) then
811: p_rec.attribute4 :=
812: pay_pel_shd.g_old_rec.attribute4;
808: pay_pel_shd.g_old_rec.attribute3;
809: End If;
810: If (p_rec.attribute4 = hr_api.g_varchar2) then
811: p_rec.attribute4 :=
812: pay_pel_shd.g_old_rec.attribute4;
813: End If;
814: If (p_rec.attribute5 = hr_api.g_varchar2) then
815: p_rec.attribute5 :=
816: pay_pel_shd.g_old_rec.attribute5;
812: pay_pel_shd.g_old_rec.attribute4;
813: End If;
814: If (p_rec.attribute5 = hr_api.g_varchar2) then
815: p_rec.attribute5 :=
816: pay_pel_shd.g_old_rec.attribute5;
817: End If;
818: If (p_rec.attribute6 = hr_api.g_varchar2) then
819: p_rec.attribute6 :=
820: pay_pel_shd.g_old_rec.attribute6;
816: pay_pel_shd.g_old_rec.attribute5;
817: End If;
818: If (p_rec.attribute6 = hr_api.g_varchar2) then
819: p_rec.attribute6 :=
820: pay_pel_shd.g_old_rec.attribute6;
821: End If;
822: If (p_rec.attribute7 = hr_api.g_varchar2) then
823: p_rec.attribute7 :=
824: pay_pel_shd.g_old_rec.attribute7;
820: pay_pel_shd.g_old_rec.attribute6;
821: End If;
822: If (p_rec.attribute7 = hr_api.g_varchar2) then
823: p_rec.attribute7 :=
824: pay_pel_shd.g_old_rec.attribute7;
825: End If;
826: If (p_rec.attribute8 = hr_api.g_varchar2) then
827: p_rec.attribute8 :=
828: pay_pel_shd.g_old_rec.attribute8;
824: pay_pel_shd.g_old_rec.attribute7;
825: End If;
826: If (p_rec.attribute8 = hr_api.g_varchar2) then
827: p_rec.attribute8 :=
828: pay_pel_shd.g_old_rec.attribute8;
829: End If;
830: If (p_rec.attribute9 = hr_api.g_varchar2) then
831: p_rec.attribute9 :=
832: pay_pel_shd.g_old_rec.attribute9;
828: pay_pel_shd.g_old_rec.attribute8;
829: End If;
830: If (p_rec.attribute9 = hr_api.g_varchar2) then
831: p_rec.attribute9 :=
832: pay_pel_shd.g_old_rec.attribute9;
833: End If;
834: If (p_rec.attribute10 = hr_api.g_varchar2) then
835: p_rec.attribute10 :=
836: pay_pel_shd.g_old_rec.attribute10;
832: pay_pel_shd.g_old_rec.attribute9;
833: End If;
834: If (p_rec.attribute10 = hr_api.g_varchar2) then
835: p_rec.attribute10 :=
836: pay_pel_shd.g_old_rec.attribute10;
837: End If;
838: If (p_rec.attribute11 = hr_api.g_varchar2) then
839: p_rec.attribute11 :=
840: pay_pel_shd.g_old_rec.attribute11;
836: pay_pel_shd.g_old_rec.attribute10;
837: End If;
838: If (p_rec.attribute11 = hr_api.g_varchar2) then
839: p_rec.attribute11 :=
840: pay_pel_shd.g_old_rec.attribute11;
841: End If;
842: If (p_rec.attribute12 = hr_api.g_varchar2) then
843: p_rec.attribute12 :=
844: pay_pel_shd.g_old_rec.attribute12;
840: pay_pel_shd.g_old_rec.attribute11;
841: End If;
842: If (p_rec.attribute12 = hr_api.g_varchar2) then
843: p_rec.attribute12 :=
844: pay_pel_shd.g_old_rec.attribute12;
845: End If;
846: If (p_rec.attribute13 = hr_api.g_varchar2) then
847: p_rec.attribute13 :=
848: pay_pel_shd.g_old_rec.attribute13;
844: pay_pel_shd.g_old_rec.attribute12;
845: End If;
846: If (p_rec.attribute13 = hr_api.g_varchar2) then
847: p_rec.attribute13 :=
848: pay_pel_shd.g_old_rec.attribute13;
849: End If;
850: If (p_rec.attribute14 = hr_api.g_varchar2) then
851: p_rec.attribute14 :=
852: pay_pel_shd.g_old_rec.attribute14;
848: pay_pel_shd.g_old_rec.attribute13;
849: End If;
850: If (p_rec.attribute14 = hr_api.g_varchar2) then
851: p_rec.attribute14 :=
852: pay_pel_shd.g_old_rec.attribute14;
853: End If;
854: If (p_rec.attribute15 = hr_api.g_varchar2) then
855: p_rec.attribute15 :=
856: pay_pel_shd.g_old_rec.attribute15;
852: pay_pel_shd.g_old_rec.attribute14;
853: End If;
854: If (p_rec.attribute15 = hr_api.g_varchar2) then
855: p_rec.attribute15 :=
856: pay_pel_shd.g_old_rec.attribute15;
857: End If;
858: If (p_rec.attribute16 = hr_api.g_varchar2) then
859: p_rec.attribute16 :=
860: pay_pel_shd.g_old_rec.attribute16;
856: pay_pel_shd.g_old_rec.attribute15;
857: End If;
858: If (p_rec.attribute16 = hr_api.g_varchar2) then
859: p_rec.attribute16 :=
860: pay_pel_shd.g_old_rec.attribute16;
861: End If;
862: If (p_rec.attribute17 = hr_api.g_varchar2) then
863: p_rec.attribute17 :=
864: pay_pel_shd.g_old_rec.attribute17;
860: pay_pel_shd.g_old_rec.attribute16;
861: End If;
862: If (p_rec.attribute17 = hr_api.g_varchar2) then
863: p_rec.attribute17 :=
864: pay_pel_shd.g_old_rec.attribute17;
865: End If;
866: If (p_rec.attribute18 = hr_api.g_varchar2) then
867: p_rec.attribute18 :=
868: pay_pel_shd.g_old_rec.attribute18;
864: pay_pel_shd.g_old_rec.attribute17;
865: End If;
866: If (p_rec.attribute18 = hr_api.g_varchar2) then
867: p_rec.attribute18 :=
868: pay_pel_shd.g_old_rec.attribute18;
869: End If;
870: If (p_rec.attribute19 = hr_api.g_varchar2) then
871: p_rec.attribute19 :=
872: pay_pel_shd.g_old_rec.attribute19;
868: pay_pel_shd.g_old_rec.attribute18;
869: End If;
870: If (p_rec.attribute19 = hr_api.g_varchar2) then
871: p_rec.attribute19 :=
872: pay_pel_shd.g_old_rec.attribute19;
873: End If;
874: If (p_rec.attribute20 = hr_api.g_varchar2) then
875: p_rec.attribute20 :=
876: pay_pel_shd.g_old_rec.attribute20;
872: pay_pel_shd.g_old_rec.attribute19;
873: End If;
874: If (p_rec.attribute20 = hr_api.g_varchar2) then
875: p_rec.attribute20 :=
876: pay_pel_shd.g_old_rec.attribute20;
877: End If;
878: --
879: End convert_defs;
880: --
883: -- ----------------------------------------------------------------------------
884: Procedure upd
885: (p_effective_date in date
886: ,p_datetrack_mode in varchar2
887: ,p_rec in out nocopy pay_pel_shd.g_rec_type
888: ) is
889: --
890: l_proc varchar2(72) := g_package||'upd';
891: l_validation_start_date date;
909: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
910: --
911: -- We must lock the row which we need to update.
912: --
913: pay_pel_shd.lck
914: (p_effective_date => p_effective_date
915: ,p_datetrack_mode => p_datetrack_mode
916: ,p_element_link_id => p_rec.element_link_id
917: ,p_object_version_number => p_rec.object_version_number
1019: ,p_effective_start_date out nocopy date
1020: ,p_effective_end_date out nocopy date
1021: ) is
1022: --
1023: l_rec pay_pel_shd.g_rec_type;
1024: l_proc varchar2(72) := g_package||'upd';
1025: --
1026: Begin
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1029: -- Call conversion function to turn arguments into the
1030: -- l_rec structure.
1031: --
1032: l_rec :=
1033: pay_pel_shd.convert_args
1034: (p_element_link_id
1035: ,null
1036: ,null
1037: ,null