54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pry_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 => 'prtt_rmt_aprvd_fr_pymt_id'
80: ,p_base_key_value => p_rec.prtt_rmt_aprvd_fr_pymt_id
81: );
82: --
83: ben_pry_shd.g_api_dml := true; -- Set the api dml status
84: --
85: -- Update the ben_prtt_rmt_aprvd_fr_pymt_f Row
86: --
87: update ben_prtt_rmt_aprvd_fr_pymt_f
132: where prtt_rmt_aprvd_fr_pymt_id = p_rec.prtt_rmt_aprvd_fr_pymt_id
133: and effective_start_date = p_validation_start_date
134: and effective_end_date = p_validation_end_date;
135: --
136: ben_pry_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: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
149: ben_pry_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: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
149: ben_pry_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: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
149: ben_pry_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: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
154: ben_pry_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When Others Then
157: ben_pry_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: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
154: ben_pry_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When Others Then
157: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
158: Raise;
153: ben_pry_shd.g_api_dml := false; -- Unset the api dml status
154: ben_pry_shd.constraint_error
155: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When Others Then
157: ben_pry_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 ben_pry_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 ben_pry_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: ben_pry_shd.upd_effective_end_date
277: (p_effective_date => p_effective_date
278: ,p_base_key_value => p_rec.prtt_rmt_aprvd_fr_pymt_id
279: ,p_new_effective_end_date => (p_validation_start_date - 1)
280: ,p_validation_start_date => p_validation_start_date
341: --
342: -- {End Of Comments}
343: -- ----------------------------------------------------------------------------
344: Procedure pre_update
345: (p_rec in out nocopy ben_pry_shd.g_rec_type
346: ,p_effective_date in date
347: ,p_datetrack_mode in varchar2
348: ,p_validation_start_date in date
349: ,p_validation_end_date in date
399: --
400: -- {End Of Comments}
401: -- ----------------------------------------------------------------------------
402: Procedure post_update
403: (p_rec in ben_pry_shd.g_rec_type
404: ,p_effective_date in date
405: ,p_datetrack_mode in varchar2
406: ,p_validation_start_date in date
407: ,p_validation_end_date in date
511: => p_rec.pry_attribute30
512: ,p_object_version_number
513: => p_rec.object_version_number
514: ,p_prtt_reimbmt_rqst_id_o
515: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
516: ,p_effective_start_date_o
517: => ben_pry_shd.g_old_rec.effective_start_date
518: ,p_effective_end_date_o
519: => ben_pry_shd.g_old_rec.effective_end_date
513: => p_rec.object_version_number
514: ,p_prtt_reimbmt_rqst_id_o
515: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
516: ,p_effective_start_date_o
517: => ben_pry_shd.g_old_rec.effective_start_date
518: ,p_effective_end_date_o
519: => ben_pry_shd.g_old_rec.effective_end_date
520: ,p_apprvd_fr_pymt_num_o
521: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
515: => ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id
516: ,p_effective_start_date_o
517: => ben_pry_shd.g_old_rec.effective_start_date
518: ,p_effective_end_date_o
519: => ben_pry_shd.g_old_rec.effective_end_date
520: ,p_apprvd_fr_pymt_num_o
521: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
522: ,p_adjmt_flag_o
523: => ben_pry_shd.g_old_rec.adjmt_flag
517: => ben_pry_shd.g_old_rec.effective_start_date
518: ,p_effective_end_date_o
519: => ben_pry_shd.g_old_rec.effective_end_date
520: ,p_apprvd_fr_pymt_num_o
521: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
522: ,p_adjmt_flag_o
523: => ben_pry_shd.g_old_rec.adjmt_flag
524: ,p_aprvd_fr_pymt_amt_o
525: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
519: => ben_pry_shd.g_old_rec.effective_end_date
520: ,p_apprvd_fr_pymt_num_o
521: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
522: ,p_adjmt_flag_o
523: => ben_pry_shd.g_old_rec.adjmt_flag
524: ,p_aprvd_fr_pymt_amt_o
525: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
526: ,p_pymt_stat_cd_o
527: => ben_pry_shd.g_old_rec.pymt_stat_cd
521: => ben_pry_shd.g_old_rec.apprvd_fr_pymt_num
522: ,p_adjmt_flag_o
523: => ben_pry_shd.g_old_rec.adjmt_flag
524: ,p_aprvd_fr_pymt_amt_o
525: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
526: ,p_pymt_stat_cd_o
527: => ben_pry_shd.g_old_rec.pymt_stat_cd
528: ,p_pymt_stat_rsn_cd_o
529: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
523: => ben_pry_shd.g_old_rec.adjmt_flag
524: ,p_aprvd_fr_pymt_amt_o
525: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
526: ,p_pymt_stat_cd_o
527: => ben_pry_shd.g_old_rec.pymt_stat_cd
528: ,p_pymt_stat_rsn_cd_o
529: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
530: ,p_pymt_stat_ovrdn_rsn_cd_o
531: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
525: => ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt
526: ,p_pymt_stat_cd_o
527: => ben_pry_shd.g_old_rec.pymt_stat_cd
528: ,p_pymt_stat_rsn_cd_o
529: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
530: ,p_pymt_stat_ovrdn_rsn_cd_o
531: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
532: ,p_pymt_stat_prr_to_ovrd_cd_o
533: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
527: => ben_pry_shd.g_old_rec.pymt_stat_cd
528: ,p_pymt_stat_rsn_cd_o
529: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
530: ,p_pymt_stat_ovrdn_rsn_cd_o
531: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
532: ,p_pymt_stat_prr_to_ovrd_cd_o
533: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
534: ,p_business_group_id_o
535: => ben_pry_shd.g_old_rec.business_group_id
529: => ben_pry_shd.g_old_rec.pymt_stat_rsn_cd
530: ,p_pymt_stat_ovrdn_rsn_cd_o
531: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
532: ,p_pymt_stat_prr_to_ovrd_cd_o
533: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
534: ,p_business_group_id_o
535: => ben_pry_shd.g_old_rec.business_group_id
536: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
537: ,p_pry_attribute_category_o
531: => ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
532: ,p_pymt_stat_prr_to_ovrd_cd_o
533: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
534: ,p_business_group_id_o
535: => ben_pry_shd.g_old_rec.business_group_id
536: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
537: ,p_pry_attribute_category_o
538: => ben_pry_shd.g_old_rec.pry_attribute_category
539: ,p_pry_attribute1_o
532: ,p_pymt_stat_prr_to_ovrd_cd_o
533: => ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd
534: ,p_business_group_id_o
535: => ben_pry_shd.g_old_rec.business_group_id
536: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
537: ,p_pry_attribute_category_o
538: => ben_pry_shd.g_old_rec.pry_attribute_category
539: ,p_pry_attribute1_o
540: => ben_pry_shd.g_old_rec.pry_attribute1
534: ,p_business_group_id_o
535: => ben_pry_shd.g_old_rec.business_group_id
536: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
537: ,p_pry_attribute_category_o
538: => ben_pry_shd.g_old_rec.pry_attribute_category
539: ,p_pry_attribute1_o
540: => ben_pry_shd.g_old_rec.pry_attribute1
541: ,p_pry_attribute2_o
542: => ben_pry_shd.g_old_rec.pry_attribute2
536: ,p_element_entry_value_id_o => ben_pry_shd.g_old_rec.element_entry_value_id
537: ,p_pry_attribute_category_o
538: => ben_pry_shd.g_old_rec.pry_attribute_category
539: ,p_pry_attribute1_o
540: => ben_pry_shd.g_old_rec.pry_attribute1
541: ,p_pry_attribute2_o
542: => ben_pry_shd.g_old_rec.pry_attribute2
543: ,p_pry_attribute3_o
544: => ben_pry_shd.g_old_rec.pry_attribute3
538: => ben_pry_shd.g_old_rec.pry_attribute_category
539: ,p_pry_attribute1_o
540: => ben_pry_shd.g_old_rec.pry_attribute1
541: ,p_pry_attribute2_o
542: => ben_pry_shd.g_old_rec.pry_attribute2
543: ,p_pry_attribute3_o
544: => ben_pry_shd.g_old_rec.pry_attribute3
545: ,p_pry_attribute4_o
546: => ben_pry_shd.g_old_rec.pry_attribute4
540: => ben_pry_shd.g_old_rec.pry_attribute1
541: ,p_pry_attribute2_o
542: => ben_pry_shd.g_old_rec.pry_attribute2
543: ,p_pry_attribute3_o
544: => ben_pry_shd.g_old_rec.pry_attribute3
545: ,p_pry_attribute4_o
546: => ben_pry_shd.g_old_rec.pry_attribute4
547: ,p_pry_attribute5_o
548: => ben_pry_shd.g_old_rec.pry_attribute5
542: => ben_pry_shd.g_old_rec.pry_attribute2
543: ,p_pry_attribute3_o
544: => ben_pry_shd.g_old_rec.pry_attribute3
545: ,p_pry_attribute4_o
546: => ben_pry_shd.g_old_rec.pry_attribute4
547: ,p_pry_attribute5_o
548: => ben_pry_shd.g_old_rec.pry_attribute5
549: ,p_pry_attribute6_o
550: => ben_pry_shd.g_old_rec.pry_attribute6
544: => ben_pry_shd.g_old_rec.pry_attribute3
545: ,p_pry_attribute4_o
546: => ben_pry_shd.g_old_rec.pry_attribute4
547: ,p_pry_attribute5_o
548: => ben_pry_shd.g_old_rec.pry_attribute5
549: ,p_pry_attribute6_o
550: => ben_pry_shd.g_old_rec.pry_attribute6
551: ,p_pry_attribute7_o
552: => ben_pry_shd.g_old_rec.pry_attribute7
546: => ben_pry_shd.g_old_rec.pry_attribute4
547: ,p_pry_attribute5_o
548: => ben_pry_shd.g_old_rec.pry_attribute5
549: ,p_pry_attribute6_o
550: => ben_pry_shd.g_old_rec.pry_attribute6
551: ,p_pry_attribute7_o
552: => ben_pry_shd.g_old_rec.pry_attribute7
553: ,p_pry_attribute8_o
554: => ben_pry_shd.g_old_rec.pry_attribute8
548: => ben_pry_shd.g_old_rec.pry_attribute5
549: ,p_pry_attribute6_o
550: => ben_pry_shd.g_old_rec.pry_attribute6
551: ,p_pry_attribute7_o
552: => ben_pry_shd.g_old_rec.pry_attribute7
553: ,p_pry_attribute8_o
554: => ben_pry_shd.g_old_rec.pry_attribute8
555: ,p_pry_attribute9_o
556: => ben_pry_shd.g_old_rec.pry_attribute9
550: => ben_pry_shd.g_old_rec.pry_attribute6
551: ,p_pry_attribute7_o
552: => ben_pry_shd.g_old_rec.pry_attribute7
553: ,p_pry_attribute8_o
554: => ben_pry_shd.g_old_rec.pry_attribute8
555: ,p_pry_attribute9_o
556: => ben_pry_shd.g_old_rec.pry_attribute9
557: ,p_pry_attribute10_o
558: => ben_pry_shd.g_old_rec.pry_attribute10
552: => ben_pry_shd.g_old_rec.pry_attribute7
553: ,p_pry_attribute8_o
554: => ben_pry_shd.g_old_rec.pry_attribute8
555: ,p_pry_attribute9_o
556: => ben_pry_shd.g_old_rec.pry_attribute9
557: ,p_pry_attribute10_o
558: => ben_pry_shd.g_old_rec.pry_attribute10
559: ,p_pry_attribute11_o
560: => ben_pry_shd.g_old_rec.pry_attribute11
554: => ben_pry_shd.g_old_rec.pry_attribute8
555: ,p_pry_attribute9_o
556: => ben_pry_shd.g_old_rec.pry_attribute9
557: ,p_pry_attribute10_o
558: => ben_pry_shd.g_old_rec.pry_attribute10
559: ,p_pry_attribute11_o
560: => ben_pry_shd.g_old_rec.pry_attribute11
561: ,p_pry_attribute12_o
562: => ben_pry_shd.g_old_rec.pry_attribute12
556: => ben_pry_shd.g_old_rec.pry_attribute9
557: ,p_pry_attribute10_o
558: => ben_pry_shd.g_old_rec.pry_attribute10
559: ,p_pry_attribute11_o
560: => ben_pry_shd.g_old_rec.pry_attribute11
561: ,p_pry_attribute12_o
562: => ben_pry_shd.g_old_rec.pry_attribute12
563: ,p_pry_attribute13_o
564: => ben_pry_shd.g_old_rec.pry_attribute13
558: => ben_pry_shd.g_old_rec.pry_attribute10
559: ,p_pry_attribute11_o
560: => ben_pry_shd.g_old_rec.pry_attribute11
561: ,p_pry_attribute12_o
562: => ben_pry_shd.g_old_rec.pry_attribute12
563: ,p_pry_attribute13_o
564: => ben_pry_shd.g_old_rec.pry_attribute13
565: ,p_pry_attribute14_o
566: => ben_pry_shd.g_old_rec.pry_attribute14
560: => ben_pry_shd.g_old_rec.pry_attribute11
561: ,p_pry_attribute12_o
562: => ben_pry_shd.g_old_rec.pry_attribute12
563: ,p_pry_attribute13_o
564: => ben_pry_shd.g_old_rec.pry_attribute13
565: ,p_pry_attribute14_o
566: => ben_pry_shd.g_old_rec.pry_attribute14
567: ,p_pry_attribute15_o
568: => ben_pry_shd.g_old_rec.pry_attribute15
562: => ben_pry_shd.g_old_rec.pry_attribute12
563: ,p_pry_attribute13_o
564: => ben_pry_shd.g_old_rec.pry_attribute13
565: ,p_pry_attribute14_o
566: => ben_pry_shd.g_old_rec.pry_attribute14
567: ,p_pry_attribute15_o
568: => ben_pry_shd.g_old_rec.pry_attribute15
569: ,p_pry_attribute16_o
570: => ben_pry_shd.g_old_rec.pry_attribute16
564: => ben_pry_shd.g_old_rec.pry_attribute13
565: ,p_pry_attribute14_o
566: => ben_pry_shd.g_old_rec.pry_attribute14
567: ,p_pry_attribute15_o
568: => ben_pry_shd.g_old_rec.pry_attribute15
569: ,p_pry_attribute16_o
570: => ben_pry_shd.g_old_rec.pry_attribute16
571: ,p_pry_attribute17_o
572: => ben_pry_shd.g_old_rec.pry_attribute17
566: => ben_pry_shd.g_old_rec.pry_attribute14
567: ,p_pry_attribute15_o
568: => ben_pry_shd.g_old_rec.pry_attribute15
569: ,p_pry_attribute16_o
570: => ben_pry_shd.g_old_rec.pry_attribute16
571: ,p_pry_attribute17_o
572: => ben_pry_shd.g_old_rec.pry_attribute17
573: ,p_pry_attribute18_o
574: => ben_pry_shd.g_old_rec.pry_attribute18
568: => ben_pry_shd.g_old_rec.pry_attribute15
569: ,p_pry_attribute16_o
570: => ben_pry_shd.g_old_rec.pry_attribute16
571: ,p_pry_attribute17_o
572: => ben_pry_shd.g_old_rec.pry_attribute17
573: ,p_pry_attribute18_o
574: => ben_pry_shd.g_old_rec.pry_attribute18
575: ,p_pry_attribute19_o
576: => ben_pry_shd.g_old_rec.pry_attribute19
570: => ben_pry_shd.g_old_rec.pry_attribute16
571: ,p_pry_attribute17_o
572: => ben_pry_shd.g_old_rec.pry_attribute17
573: ,p_pry_attribute18_o
574: => ben_pry_shd.g_old_rec.pry_attribute18
575: ,p_pry_attribute19_o
576: => ben_pry_shd.g_old_rec.pry_attribute19
577: ,p_pry_attribute20_o
578: => ben_pry_shd.g_old_rec.pry_attribute20
572: => ben_pry_shd.g_old_rec.pry_attribute17
573: ,p_pry_attribute18_o
574: => ben_pry_shd.g_old_rec.pry_attribute18
575: ,p_pry_attribute19_o
576: => ben_pry_shd.g_old_rec.pry_attribute19
577: ,p_pry_attribute20_o
578: => ben_pry_shd.g_old_rec.pry_attribute20
579: ,p_pry_attribute21_o
580: => ben_pry_shd.g_old_rec.pry_attribute21
574: => ben_pry_shd.g_old_rec.pry_attribute18
575: ,p_pry_attribute19_o
576: => ben_pry_shd.g_old_rec.pry_attribute19
577: ,p_pry_attribute20_o
578: => ben_pry_shd.g_old_rec.pry_attribute20
579: ,p_pry_attribute21_o
580: => ben_pry_shd.g_old_rec.pry_attribute21
581: ,p_pry_attribute22_o
582: => ben_pry_shd.g_old_rec.pry_attribute22
576: => ben_pry_shd.g_old_rec.pry_attribute19
577: ,p_pry_attribute20_o
578: => ben_pry_shd.g_old_rec.pry_attribute20
579: ,p_pry_attribute21_o
580: => ben_pry_shd.g_old_rec.pry_attribute21
581: ,p_pry_attribute22_o
582: => ben_pry_shd.g_old_rec.pry_attribute22
583: ,p_pry_attribute23_o
584: => ben_pry_shd.g_old_rec.pry_attribute23
578: => ben_pry_shd.g_old_rec.pry_attribute20
579: ,p_pry_attribute21_o
580: => ben_pry_shd.g_old_rec.pry_attribute21
581: ,p_pry_attribute22_o
582: => ben_pry_shd.g_old_rec.pry_attribute22
583: ,p_pry_attribute23_o
584: => ben_pry_shd.g_old_rec.pry_attribute23
585: ,p_pry_attribute24_o
586: => ben_pry_shd.g_old_rec.pry_attribute24
580: => ben_pry_shd.g_old_rec.pry_attribute21
581: ,p_pry_attribute22_o
582: => ben_pry_shd.g_old_rec.pry_attribute22
583: ,p_pry_attribute23_o
584: => ben_pry_shd.g_old_rec.pry_attribute23
585: ,p_pry_attribute24_o
586: => ben_pry_shd.g_old_rec.pry_attribute24
587: ,p_pry_attribute25_o
588: => ben_pry_shd.g_old_rec.pry_attribute25
582: => ben_pry_shd.g_old_rec.pry_attribute22
583: ,p_pry_attribute23_o
584: => ben_pry_shd.g_old_rec.pry_attribute23
585: ,p_pry_attribute24_o
586: => ben_pry_shd.g_old_rec.pry_attribute24
587: ,p_pry_attribute25_o
588: => ben_pry_shd.g_old_rec.pry_attribute25
589: ,p_pry_attribute26_o
590: => ben_pry_shd.g_old_rec.pry_attribute26
584: => ben_pry_shd.g_old_rec.pry_attribute23
585: ,p_pry_attribute24_o
586: => ben_pry_shd.g_old_rec.pry_attribute24
587: ,p_pry_attribute25_o
588: => ben_pry_shd.g_old_rec.pry_attribute25
589: ,p_pry_attribute26_o
590: => ben_pry_shd.g_old_rec.pry_attribute26
591: ,p_pry_attribute27_o
592: => ben_pry_shd.g_old_rec.pry_attribute27
586: => ben_pry_shd.g_old_rec.pry_attribute24
587: ,p_pry_attribute25_o
588: => ben_pry_shd.g_old_rec.pry_attribute25
589: ,p_pry_attribute26_o
590: => ben_pry_shd.g_old_rec.pry_attribute26
591: ,p_pry_attribute27_o
592: => ben_pry_shd.g_old_rec.pry_attribute27
593: ,p_pry_attribute28_o
594: => ben_pry_shd.g_old_rec.pry_attribute28
588: => ben_pry_shd.g_old_rec.pry_attribute25
589: ,p_pry_attribute26_o
590: => ben_pry_shd.g_old_rec.pry_attribute26
591: ,p_pry_attribute27_o
592: => ben_pry_shd.g_old_rec.pry_attribute27
593: ,p_pry_attribute28_o
594: => ben_pry_shd.g_old_rec.pry_attribute28
595: ,p_pry_attribute29_o
596: => ben_pry_shd.g_old_rec.pry_attribute29
590: => ben_pry_shd.g_old_rec.pry_attribute26
591: ,p_pry_attribute27_o
592: => ben_pry_shd.g_old_rec.pry_attribute27
593: ,p_pry_attribute28_o
594: => ben_pry_shd.g_old_rec.pry_attribute28
595: ,p_pry_attribute29_o
596: => ben_pry_shd.g_old_rec.pry_attribute29
597: ,p_pry_attribute30_o
598: => ben_pry_shd.g_old_rec.pry_attribute30
592: => ben_pry_shd.g_old_rec.pry_attribute27
593: ,p_pry_attribute28_o
594: => ben_pry_shd.g_old_rec.pry_attribute28
595: ,p_pry_attribute29_o
596: => ben_pry_shd.g_old_rec.pry_attribute29
597: ,p_pry_attribute30_o
598: => ben_pry_shd.g_old_rec.pry_attribute30
599: ,p_object_version_number_o
600: => ben_pry_shd.g_old_rec.object_version_number
594: => ben_pry_shd.g_old_rec.pry_attribute28
595: ,p_pry_attribute29_o
596: => ben_pry_shd.g_old_rec.pry_attribute29
597: ,p_pry_attribute30_o
598: => ben_pry_shd.g_old_rec.pry_attribute30
599: ,p_object_version_number_o
600: => ben_pry_shd.g_old_rec.object_version_number
601: );
602: --
596: => ben_pry_shd.g_old_rec.pry_attribute29
597: ,p_pry_attribute30_o
598: => ben_pry_shd.g_old_rec.pry_attribute30
599: ,p_object_version_number_o
600: => ben_pry_shd.g_old_rec.object_version_number
601: );
602: --
603: exception
604: --
656: --
657: -- {End Of Comments}
658: -- ----------------------------------------------------------------------------
659: Procedure convert_defs
660: (p_rec in out nocopy ben_pry_shd.g_rec_type
661: ) is
662: --
663: Begin
664: --
668: -- is being used then we must set to the 'current' argument value.
669: --
670: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
671: p_rec.prtt_reimbmt_rqst_id :=
672: ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id;
673: End If;
674: If (p_rec.apprvd_fr_pymt_num = hr_api.g_number) then
675: p_rec.apprvd_fr_pymt_num :=
676: ben_pry_shd.g_old_rec.apprvd_fr_pymt_num;
672: ben_pry_shd.g_old_rec.prtt_reimbmt_rqst_id;
673: End If;
674: If (p_rec.apprvd_fr_pymt_num = hr_api.g_number) then
675: p_rec.apprvd_fr_pymt_num :=
676: ben_pry_shd.g_old_rec.apprvd_fr_pymt_num;
677: End If;
678: If (p_rec.adjmt_flag = hr_api.g_varchar2) then
679: p_rec.adjmt_flag :=
680: ben_pry_shd.g_old_rec.adjmt_flag;
676: ben_pry_shd.g_old_rec.apprvd_fr_pymt_num;
677: End If;
678: If (p_rec.adjmt_flag = hr_api.g_varchar2) then
679: p_rec.adjmt_flag :=
680: ben_pry_shd.g_old_rec.adjmt_flag;
681: End If;
682: If (p_rec.aprvd_fr_pymt_amt = hr_api.g_number) then
683: p_rec.aprvd_fr_pymt_amt :=
684: ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt;
680: ben_pry_shd.g_old_rec.adjmt_flag;
681: End If;
682: If (p_rec.aprvd_fr_pymt_amt = hr_api.g_number) then
683: p_rec.aprvd_fr_pymt_amt :=
684: ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt;
685: End If;
686: If (p_rec.pymt_stat_cd = hr_api.g_varchar2) then
687: p_rec.pymt_stat_cd :=
688: ben_pry_shd.g_old_rec.pymt_stat_cd;
684: ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt;
685: End If;
686: If (p_rec.pymt_stat_cd = hr_api.g_varchar2) then
687: p_rec.pymt_stat_cd :=
688: ben_pry_shd.g_old_rec.pymt_stat_cd;
689: End If;
690: If (p_rec.pymt_stat_rsn_cd = hr_api.g_varchar2) then
691: p_rec.pymt_stat_rsn_cd :=
692: ben_pry_shd.g_old_rec.pymt_stat_rsn_cd;
688: ben_pry_shd.g_old_rec.pymt_stat_cd;
689: End If;
690: If (p_rec.pymt_stat_rsn_cd = hr_api.g_varchar2) then
691: p_rec.pymt_stat_rsn_cd :=
692: ben_pry_shd.g_old_rec.pymt_stat_rsn_cd;
693: End If;
694: If (p_rec.pymt_stat_ovrdn_rsn_cd = hr_api.g_varchar2) then
695: p_rec.pymt_stat_ovrdn_rsn_cd :=
696: ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd;
692: ben_pry_shd.g_old_rec.pymt_stat_rsn_cd;
693: End If;
694: If (p_rec.pymt_stat_ovrdn_rsn_cd = hr_api.g_varchar2) then
695: p_rec.pymt_stat_ovrdn_rsn_cd :=
696: ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd;
697: End If;
698: If (p_rec.pymt_stat_prr_to_ovrd_cd = hr_api.g_varchar2) then
699: p_rec.pymt_stat_prr_to_ovrd_cd :=
700: ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd;
696: ben_pry_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd;
697: End If;
698: If (p_rec.pymt_stat_prr_to_ovrd_cd = hr_api.g_varchar2) then
699: p_rec.pymt_stat_prr_to_ovrd_cd :=
700: ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd;
701: End If;
702: If (p_rec.business_group_id = hr_api.g_number) then
703: p_rec.business_group_id :=
704: ben_pry_shd.g_old_rec.business_group_id;
700: ben_pry_shd.g_old_rec.pymt_stat_prr_to_ovrd_cd;
701: End If;
702: If (p_rec.business_group_id = hr_api.g_number) then
703: p_rec.business_group_id :=
704: ben_pry_shd.g_old_rec.business_group_id;
705: End If;
706: If (p_rec.element_entry_value_id = hr_api.g_number) then
707: p_rec.element_entry_value_id :=
708: ben_pry_shd.g_old_rec.element_entry_value_id;
704: ben_pry_shd.g_old_rec.business_group_id;
705: End If;
706: If (p_rec.element_entry_value_id = hr_api.g_number) then
707: p_rec.element_entry_value_id :=
708: ben_pry_shd.g_old_rec.element_entry_value_id;
709: End If;
710:
711: If (p_rec.pry_attribute_category = hr_api.g_varchar2) then
712: p_rec.pry_attribute_category :=
709: End If;
710:
711: If (p_rec.pry_attribute_category = hr_api.g_varchar2) then
712: p_rec.pry_attribute_category :=
713: ben_pry_shd.g_old_rec.pry_attribute_category;
714: End If;
715: If (p_rec.pry_attribute1 = hr_api.g_varchar2) then
716: p_rec.pry_attribute1 :=
717: ben_pry_shd.g_old_rec.pry_attribute1;
713: ben_pry_shd.g_old_rec.pry_attribute_category;
714: End If;
715: If (p_rec.pry_attribute1 = hr_api.g_varchar2) then
716: p_rec.pry_attribute1 :=
717: ben_pry_shd.g_old_rec.pry_attribute1;
718: End If;
719: If (p_rec.pry_attribute2 = hr_api.g_varchar2) then
720: p_rec.pry_attribute2 :=
721: ben_pry_shd.g_old_rec.pry_attribute2;
717: ben_pry_shd.g_old_rec.pry_attribute1;
718: End If;
719: If (p_rec.pry_attribute2 = hr_api.g_varchar2) then
720: p_rec.pry_attribute2 :=
721: ben_pry_shd.g_old_rec.pry_attribute2;
722: End If;
723: If (p_rec.pry_attribute3 = hr_api.g_varchar2) then
724: p_rec.pry_attribute3 :=
725: ben_pry_shd.g_old_rec.pry_attribute3;
721: ben_pry_shd.g_old_rec.pry_attribute2;
722: End If;
723: If (p_rec.pry_attribute3 = hr_api.g_varchar2) then
724: p_rec.pry_attribute3 :=
725: ben_pry_shd.g_old_rec.pry_attribute3;
726: End If;
727: If (p_rec.pry_attribute4 = hr_api.g_varchar2) then
728: p_rec.pry_attribute4 :=
729: ben_pry_shd.g_old_rec.pry_attribute4;
725: ben_pry_shd.g_old_rec.pry_attribute3;
726: End If;
727: If (p_rec.pry_attribute4 = hr_api.g_varchar2) then
728: p_rec.pry_attribute4 :=
729: ben_pry_shd.g_old_rec.pry_attribute4;
730: End If;
731: If (p_rec.pry_attribute5 = hr_api.g_varchar2) then
732: p_rec.pry_attribute5 :=
733: ben_pry_shd.g_old_rec.pry_attribute5;
729: ben_pry_shd.g_old_rec.pry_attribute4;
730: End If;
731: If (p_rec.pry_attribute5 = hr_api.g_varchar2) then
732: p_rec.pry_attribute5 :=
733: ben_pry_shd.g_old_rec.pry_attribute5;
734: End If;
735: If (p_rec.pry_attribute6 = hr_api.g_varchar2) then
736: p_rec.pry_attribute6 :=
737: ben_pry_shd.g_old_rec.pry_attribute6;
733: ben_pry_shd.g_old_rec.pry_attribute5;
734: End If;
735: If (p_rec.pry_attribute6 = hr_api.g_varchar2) then
736: p_rec.pry_attribute6 :=
737: ben_pry_shd.g_old_rec.pry_attribute6;
738: End If;
739: If (p_rec.pry_attribute7 = hr_api.g_varchar2) then
740: p_rec.pry_attribute7 :=
741: ben_pry_shd.g_old_rec.pry_attribute7;
737: ben_pry_shd.g_old_rec.pry_attribute6;
738: End If;
739: If (p_rec.pry_attribute7 = hr_api.g_varchar2) then
740: p_rec.pry_attribute7 :=
741: ben_pry_shd.g_old_rec.pry_attribute7;
742: End If;
743: If (p_rec.pry_attribute8 = hr_api.g_varchar2) then
744: p_rec.pry_attribute8 :=
745: ben_pry_shd.g_old_rec.pry_attribute8;
741: ben_pry_shd.g_old_rec.pry_attribute7;
742: End If;
743: If (p_rec.pry_attribute8 = hr_api.g_varchar2) then
744: p_rec.pry_attribute8 :=
745: ben_pry_shd.g_old_rec.pry_attribute8;
746: End If;
747: If (p_rec.pry_attribute9 = hr_api.g_varchar2) then
748: p_rec.pry_attribute9 :=
749: ben_pry_shd.g_old_rec.pry_attribute9;
745: ben_pry_shd.g_old_rec.pry_attribute8;
746: End If;
747: If (p_rec.pry_attribute9 = hr_api.g_varchar2) then
748: p_rec.pry_attribute9 :=
749: ben_pry_shd.g_old_rec.pry_attribute9;
750: End If;
751: If (p_rec.pry_attribute10 = hr_api.g_varchar2) then
752: p_rec.pry_attribute10 :=
753: ben_pry_shd.g_old_rec.pry_attribute10;
749: ben_pry_shd.g_old_rec.pry_attribute9;
750: End If;
751: If (p_rec.pry_attribute10 = hr_api.g_varchar2) then
752: p_rec.pry_attribute10 :=
753: ben_pry_shd.g_old_rec.pry_attribute10;
754: End If;
755: If (p_rec.pry_attribute11 = hr_api.g_varchar2) then
756: p_rec.pry_attribute11 :=
757: ben_pry_shd.g_old_rec.pry_attribute11;
753: ben_pry_shd.g_old_rec.pry_attribute10;
754: End If;
755: If (p_rec.pry_attribute11 = hr_api.g_varchar2) then
756: p_rec.pry_attribute11 :=
757: ben_pry_shd.g_old_rec.pry_attribute11;
758: End If;
759: If (p_rec.pry_attribute12 = hr_api.g_varchar2) then
760: p_rec.pry_attribute12 :=
761: ben_pry_shd.g_old_rec.pry_attribute12;
757: ben_pry_shd.g_old_rec.pry_attribute11;
758: End If;
759: If (p_rec.pry_attribute12 = hr_api.g_varchar2) then
760: p_rec.pry_attribute12 :=
761: ben_pry_shd.g_old_rec.pry_attribute12;
762: End If;
763: If (p_rec.pry_attribute13 = hr_api.g_varchar2) then
764: p_rec.pry_attribute13 :=
765: ben_pry_shd.g_old_rec.pry_attribute13;
761: ben_pry_shd.g_old_rec.pry_attribute12;
762: End If;
763: If (p_rec.pry_attribute13 = hr_api.g_varchar2) then
764: p_rec.pry_attribute13 :=
765: ben_pry_shd.g_old_rec.pry_attribute13;
766: End If;
767: If (p_rec.pry_attribute14 = hr_api.g_varchar2) then
768: p_rec.pry_attribute14 :=
769: ben_pry_shd.g_old_rec.pry_attribute14;
765: ben_pry_shd.g_old_rec.pry_attribute13;
766: End If;
767: If (p_rec.pry_attribute14 = hr_api.g_varchar2) then
768: p_rec.pry_attribute14 :=
769: ben_pry_shd.g_old_rec.pry_attribute14;
770: End If;
771: If (p_rec.pry_attribute15 = hr_api.g_varchar2) then
772: p_rec.pry_attribute15 :=
773: ben_pry_shd.g_old_rec.pry_attribute15;
769: ben_pry_shd.g_old_rec.pry_attribute14;
770: End If;
771: If (p_rec.pry_attribute15 = hr_api.g_varchar2) then
772: p_rec.pry_attribute15 :=
773: ben_pry_shd.g_old_rec.pry_attribute15;
774: End If;
775: If (p_rec.pry_attribute16 = hr_api.g_varchar2) then
776: p_rec.pry_attribute16 :=
777: ben_pry_shd.g_old_rec.pry_attribute16;
773: ben_pry_shd.g_old_rec.pry_attribute15;
774: End If;
775: If (p_rec.pry_attribute16 = hr_api.g_varchar2) then
776: p_rec.pry_attribute16 :=
777: ben_pry_shd.g_old_rec.pry_attribute16;
778: End If;
779: If (p_rec.pry_attribute17 = hr_api.g_varchar2) then
780: p_rec.pry_attribute17 :=
781: ben_pry_shd.g_old_rec.pry_attribute17;
777: ben_pry_shd.g_old_rec.pry_attribute16;
778: End If;
779: If (p_rec.pry_attribute17 = hr_api.g_varchar2) then
780: p_rec.pry_attribute17 :=
781: ben_pry_shd.g_old_rec.pry_attribute17;
782: End If;
783: If (p_rec.pry_attribute18 = hr_api.g_varchar2) then
784: p_rec.pry_attribute18 :=
785: ben_pry_shd.g_old_rec.pry_attribute18;
781: ben_pry_shd.g_old_rec.pry_attribute17;
782: End If;
783: If (p_rec.pry_attribute18 = hr_api.g_varchar2) then
784: p_rec.pry_attribute18 :=
785: ben_pry_shd.g_old_rec.pry_attribute18;
786: End If;
787: If (p_rec.pry_attribute19 = hr_api.g_varchar2) then
788: p_rec.pry_attribute19 :=
789: ben_pry_shd.g_old_rec.pry_attribute19;
785: ben_pry_shd.g_old_rec.pry_attribute18;
786: End If;
787: If (p_rec.pry_attribute19 = hr_api.g_varchar2) then
788: p_rec.pry_attribute19 :=
789: ben_pry_shd.g_old_rec.pry_attribute19;
790: End If;
791: If (p_rec.pry_attribute20 = hr_api.g_varchar2) then
792: p_rec.pry_attribute20 :=
793: ben_pry_shd.g_old_rec.pry_attribute20;
789: ben_pry_shd.g_old_rec.pry_attribute19;
790: End If;
791: If (p_rec.pry_attribute20 = hr_api.g_varchar2) then
792: p_rec.pry_attribute20 :=
793: ben_pry_shd.g_old_rec.pry_attribute20;
794: End If;
795: If (p_rec.pry_attribute21 = hr_api.g_varchar2) then
796: p_rec.pry_attribute21 :=
797: ben_pry_shd.g_old_rec.pry_attribute21;
793: ben_pry_shd.g_old_rec.pry_attribute20;
794: End If;
795: If (p_rec.pry_attribute21 = hr_api.g_varchar2) then
796: p_rec.pry_attribute21 :=
797: ben_pry_shd.g_old_rec.pry_attribute21;
798: End If;
799: If (p_rec.pry_attribute22 = hr_api.g_varchar2) then
800: p_rec.pry_attribute22 :=
801: ben_pry_shd.g_old_rec.pry_attribute22;
797: ben_pry_shd.g_old_rec.pry_attribute21;
798: End If;
799: If (p_rec.pry_attribute22 = hr_api.g_varchar2) then
800: p_rec.pry_attribute22 :=
801: ben_pry_shd.g_old_rec.pry_attribute22;
802: End If;
803: If (p_rec.pry_attribute23 = hr_api.g_varchar2) then
804: p_rec.pry_attribute23 :=
805: ben_pry_shd.g_old_rec.pry_attribute23;
801: ben_pry_shd.g_old_rec.pry_attribute22;
802: End If;
803: If (p_rec.pry_attribute23 = hr_api.g_varchar2) then
804: p_rec.pry_attribute23 :=
805: ben_pry_shd.g_old_rec.pry_attribute23;
806: End If;
807: If (p_rec.pry_attribute24 = hr_api.g_varchar2) then
808: p_rec.pry_attribute24 :=
809: ben_pry_shd.g_old_rec.pry_attribute24;
805: ben_pry_shd.g_old_rec.pry_attribute23;
806: End If;
807: If (p_rec.pry_attribute24 = hr_api.g_varchar2) then
808: p_rec.pry_attribute24 :=
809: ben_pry_shd.g_old_rec.pry_attribute24;
810: End If;
811: If (p_rec.pry_attribute25 = hr_api.g_varchar2) then
812: p_rec.pry_attribute25 :=
813: ben_pry_shd.g_old_rec.pry_attribute25;
809: ben_pry_shd.g_old_rec.pry_attribute24;
810: End If;
811: If (p_rec.pry_attribute25 = hr_api.g_varchar2) then
812: p_rec.pry_attribute25 :=
813: ben_pry_shd.g_old_rec.pry_attribute25;
814: End If;
815: If (p_rec.pry_attribute26 = hr_api.g_varchar2) then
816: p_rec.pry_attribute26 :=
817: ben_pry_shd.g_old_rec.pry_attribute26;
813: ben_pry_shd.g_old_rec.pry_attribute25;
814: End If;
815: If (p_rec.pry_attribute26 = hr_api.g_varchar2) then
816: p_rec.pry_attribute26 :=
817: ben_pry_shd.g_old_rec.pry_attribute26;
818: End If;
819: If (p_rec.pry_attribute27 = hr_api.g_varchar2) then
820: p_rec.pry_attribute27 :=
821: ben_pry_shd.g_old_rec.pry_attribute27;
817: ben_pry_shd.g_old_rec.pry_attribute26;
818: End If;
819: If (p_rec.pry_attribute27 = hr_api.g_varchar2) then
820: p_rec.pry_attribute27 :=
821: ben_pry_shd.g_old_rec.pry_attribute27;
822: End If;
823: If (p_rec.pry_attribute28 = hr_api.g_varchar2) then
824: p_rec.pry_attribute28 :=
825: ben_pry_shd.g_old_rec.pry_attribute28;
821: ben_pry_shd.g_old_rec.pry_attribute27;
822: End If;
823: If (p_rec.pry_attribute28 = hr_api.g_varchar2) then
824: p_rec.pry_attribute28 :=
825: ben_pry_shd.g_old_rec.pry_attribute28;
826: End If;
827: If (p_rec.pry_attribute29 = hr_api.g_varchar2) then
828: p_rec.pry_attribute29 :=
829: ben_pry_shd.g_old_rec.pry_attribute29;
825: ben_pry_shd.g_old_rec.pry_attribute28;
826: End If;
827: If (p_rec.pry_attribute29 = hr_api.g_varchar2) then
828: p_rec.pry_attribute29 :=
829: ben_pry_shd.g_old_rec.pry_attribute29;
830: End If;
831: If (p_rec.pry_attribute30 = hr_api.g_varchar2) then
832: p_rec.pry_attribute30 :=
833: ben_pry_shd.g_old_rec.pry_attribute30;
829: ben_pry_shd.g_old_rec.pry_attribute29;
830: End If;
831: If (p_rec.pry_attribute30 = hr_api.g_varchar2) then
832: p_rec.pry_attribute30 :=
833: ben_pry_shd.g_old_rec.pry_attribute30;
834: End If;
835: --
836: End convert_defs;
837: --
840: -- ----------------------------------------------------------------------------
841: Procedure upd
842: (p_effective_date in date
843: ,p_datetrack_mode in varchar2
844: ,p_rec in out nocopy ben_pry_shd.g_rec_type
845: ) is
846: --
847: l_proc varchar2(72) := g_package||'upd';
848: l_validation_start_date date;
856: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
857: --
858: -- We must lock the row which we need to update.
859: --
860: ben_pry_shd.lck
861: (p_effective_date => p_effective_date
862: ,p_datetrack_mode => p_datetrack_mode
863: ,p_prtt_rmt_aprvd_fr_pymt_id => p_rec.prtt_rmt_aprvd_fr_pymt_id
864: ,p_object_version_number => p_rec.object_version_number
965: ,p_effective_start_date out nocopy date
966: ,p_effective_end_date out nocopy date
967: ) is
968: --
969: l_rec ben_pry_shd.g_rec_type;
970: l_proc varchar2(72) := g_package||'upd';
971: --
972: Begin
973: hr_utility.set_location('Entering:'||l_proc, 5);
975: -- Call conversion function to turn arguments into the
976: -- l_rec structure.
977: --
978: l_rec :=
979: ben_pry_shd.convert_args
980: (p_prtt_rmt_aprvd_fr_pymt_id
981: ,p_prtt_reimbmt_rqst_id
982: ,null
983: ,null