54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_bep_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
129: Exception
130: When hr_api.check_integrity_violated Then
131: -- A check constraint has been violated
132: --
133: ben_bep_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When hr_api.unique_integrity_violated Then
136: -- Unique integrity has been violated
137: --
138: ben_bep_shd.constraint_error
139: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
140: When Others Then
141: --
142: Raise;
173: --
174: -- {End Of Comments}
175: -- ----------------------------------------------------------------------------
176: Procedure update_dml
177: (p_rec in out nocopy ben_bep_shd.g_rec_type
178: ,p_effective_date in date
179: ,p_datetrack_mode in varchar2
180: ,p_validation_start_date in date
181: ,p_validation_end_date in date
240: --
241: -- {End Of Comments}
242: -- ----------------------------------------------------------------------------
243: Procedure dt_pre_update
244: (p_rec in out nocopy ben_bep_shd.g_rec_type
245: ,p_effective_date in date
246: ,p_datetrack_mode in varchar2
247: ,p_validation_start_date in date
248: ,p_validation_end_date in date
256: If (p_datetrack_mode <> hr_api.g_correction) then
257: --
258: -- Update the current effective end date
259: --
260: ben_bep_shd.upd_effective_end_date
261: (p_effective_date => p_effective_date
262: ,p_base_key_value => p_rec.elig_obj_elig_prfl_id
263: ,p_new_effective_end_date => (p_validation_start_date - 1)
264: ,p_validation_start_date => p_validation_start_date
325: --
326: -- {End Of Comments}
327: -- ----------------------------------------------------------------------------
328: Procedure pre_update
329: (p_rec in out nocopy ben_bep_shd.g_rec_type
330: ,p_effective_date in date
331: ,p_datetrack_mode in varchar2
332: ,p_validation_start_date in date
333: ,p_validation_end_date in date
383: --
384: -- {End Of Comments}
385: -- ----------------------------------------------------------------------------
386: Procedure post_update
387: (p_rec in ben_bep_shd.g_rec_type
388: ,p_effective_date in date
389: ,p_datetrack_mode in varchar2
390: ,p_validation_start_date in date
391: ,p_validation_end_date in date
464: => p_rec.bep_attribute20
465: ,p_object_version_number
466: => p_rec.object_version_number
467: ,p_effective_start_date_o
468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
466: => p_rec.object_version_number
467: ,p_effective_start_date_o
468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
468: => ben_bep_shd.g_old_rec.effective_start_date
469: ,p_effective_end_date_o
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
470: => ben_bep_shd.g_old_rec.effective_end_date
471: ,p_elig_obj_id_o
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
472: => ben_bep_shd.g_old_rec.elig_obj_id
473: ,p_elig_prfl_id_o
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
474: => ben_bep_shd.g_old_rec.elig_prfl_id
475: ,p_mndtry_flag_o
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
476: => ben_bep_shd.g_old_rec.mndtry_flag
477: ,p_business_group_id_o
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
478: => ben_bep_shd.g_old_rec.business_group_id
479: ,p_bep_attribute_category_o
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
480: => ben_bep_shd.g_old_rec.bep_attribute_category
481: ,p_bep_attribute1_o
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
482: => ben_bep_shd.g_old_rec.bep_attribute1
483: ,p_bep_attribute2_o
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
484: => ben_bep_shd.g_old_rec.bep_attribute2
485: ,p_bep_attribute3_o
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
486: => ben_bep_shd.g_old_rec.bep_attribute3
487: ,p_bep_attribute4_o
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
488: => ben_bep_shd.g_old_rec.bep_attribute4
489: ,p_bep_attribute5_o
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
490: => ben_bep_shd.g_old_rec.bep_attribute5
491: ,p_bep_attribute6_o
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
492: => ben_bep_shd.g_old_rec.bep_attribute6
493: ,p_bep_attribute7_o
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
494: => ben_bep_shd.g_old_rec.bep_attribute7
495: ,p_bep_attribute8_o
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
496: => ben_bep_shd.g_old_rec.bep_attribute8
497: ,p_bep_attribute9_o
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
498: => ben_bep_shd.g_old_rec.bep_attribute9
499: ,p_bep_attribute10_o
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
500: => ben_bep_shd.g_old_rec.bep_attribute10
501: ,p_bep_attribute11_o
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
502: => ben_bep_shd.g_old_rec.bep_attribute11
503: ,p_bep_attribute12_o
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
504: => ben_bep_shd.g_old_rec.bep_attribute12
505: ,p_bep_attribute13_o
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
506: => ben_bep_shd.g_old_rec.bep_attribute13
507: ,p_bep_attribute14_o
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
508: => ben_bep_shd.g_old_rec.bep_attribute14
509: ,p_bep_attribute15_o
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
510: => ben_bep_shd.g_old_rec.bep_attribute15
511: ,p_bep_attribute16_o
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
512: => ben_bep_shd.g_old_rec.bep_attribute16
513: ,p_bep_attribute17_o
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
514: => ben_bep_shd.g_old_rec.bep_attribute17
515: ,p_bep_attribute18_o
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number
516: => ben_bep_shd.g_old_rec.bep_attribute18
517: ,p_bep_attribute19_o
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number
523: );
524: --
518: => ben_bep_shd.g_old_rec.bep_attribute19
519: ,p_bep_attribute20_o
520: => ben_bep_shd.g_old_rec.bep_attribute20
521: ,p_object_version_number_o
522: => ben_bep_shd.g_old_rec.object_version_number
523: );
524: --
525: exception
526: --
578: --
579: -- {End Of Comments}
580: -- ----------------------------------------------------------------------------
581: Procedure convert_defs
582: (p_rec in out nocopy ben_bep_shd.g_rec_type
583: ) is
584: --
585: Begin
586: --
590: -- is being used then we must set to the 'current' argument value.
591: --
592: If (p_rec.elig_obj_id = hr_api.g_number) then
593: p_rec.elig_obj_id :=
594: ben_bep_shd.g_old_rec.elig_obj_id;
595: End If;
596: If (p_rec.elig_prfl_id = hr_api.g_number) then
597: p_rec.elig_prfl_id :=
598: ben_bep_shd.g_old_rec.elig_prfl_id;
594: ben_bep_shd.g_old_rec.elig_obj_id;
595: End If;
596: If (p_rec.elig_prfl_id = hr_api.g_number) then
597: p_rec.elig_prfl_id :=
598: ben_bep_shd.g_old_rec.elig_prfl_id;
599: End If;
600: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
601: p_rec.mndtry_flag :=
602: ben_bep_shd.g_old_rec.mndtry_flag;
598: ben_bep_shd.g_old_rec.elig_prfl_id;
599: End If;
600: If (p_rec.mndtry_flag = hr_api.g_varchar2) then
601: p_rec.mndtry_flag :=
602: ben_bep_shd.g_old_rec.mndtry_flag;
603: End If;
604: If (p_rec.business_group_id = hr_api.g_number) then
605: p_rec.business_group_id :=
606: ben_bep_shd.g_old_rec.business_group_id;
602: ben_bep_shd.g_old_rec.mndtry_flag;
603: End If;
604: If (p_rec.business_group_id = hr_api.g_number) then
605: p_rec.business_group_id :=
606: ben_bep_shd.g_old_rec.business_group_id;
607: End If;
608: If (p_rec.bep_attribute_category = hr_api.g_varchar2) then
609: p_rec.bep_attribute_category :=
610: ben_bep_shd.g_old_rec.bep_attribute_category;
606: ben_bep_shd.g_old_rec.business_group_id;
607: End If;
608: If (p_rec.bep_attribute_category = hr_api.g_varchar2) then
609: p_rec.bep_attribute_category :=
610: ben_bep_shd.g_old_rec.bep_attribute_category;
611: End If;
612: If (p_rec.bep_attribute1 = hr_api.g_varchar2) then
613: p_rec.bep_attribute1 :=
614: ben_bep_shd.g_old_rec.bep_attribute1;
610: ben_bep_shd.g_old_rec.bep_attribute_category;
611: End If;
612: If (p_rec.bep_attribute1 = hr_api.g_varchar2) then
613: p_rec.bep_attribute1 :=
614: ben_bep_shd.g_old_rec.bep_attribute1;
615: End If;
616: If (p_rec.bep_attribute2 = hr_api.g_varchar2) then
617: p_rec.bep_attribute2 :=
618: ben_bep_shd.g_old_rec.bep_attribute2;
614: ben_bep_shd.g_old_rec.bep_attribute1;
615: End If;
616: If (p_rec.bep_attribute2 = hr_api.g_varchar2) then
617: p_rec.bep_attribute2 :=
618: ben_bep_shd.g_old_rec.bep_attribute2;
619: End If;
620: If (p_rec.bep_attribute3 = hr_api.g_varchar2) then
621: p_rec.bep_attribute3 :=
622: ben_bep_shd.g_old_rec.bep_attribute3;
618: ben_bep_shd.g_old_rec.bep_attribute2;
619: End If;
620: If (p_rec.bep_attribute3 = hr_api.g_varchar2) then
621: p_rec.bep_attribute3 :=
622: ben_bep_shd.g_old_rec.bep_attribute3;
623: End If;
624: If (p_rec.bep_attribute4 = hr_api.g_varchar2) then
625: p_rec.bep_attribute4 :=
626: ben_bep_shd.g_old_rec.bep_attribute4;
622: ben_bep_shd.g_old_rec.bep_attribute3;
623: End If;
624: If (p_rec.bep_attribute4 = hr_api.g_varchar2) then
625: p_rec.bep_attribute4 :=
626: ben_bep_shd.g_old_rec.bep_attribute4;
627: End If;
628: If (p_rec.bep_attribute5 = hr_api.g_varchar2) then
629: p_rec.bep_attribute5 :=
630: ben_bep_shd.g_old_rec.bep_attribute5;
626: ben_bep_shd.g_old_rec.bep_attribute4;
627: End If;
628: If (p_rec.bep_attribute5 = hr_api.g_varchar2) then
629: p_rec.bep_attribute5 :=
630: ben_bep_shd.g_old_rec.bep_attribute5;
631: End If;
632: If (p_rec.bep_attribute6 = hr_api.g_varchar2) then
633: p_rec.bep_attribute6 :=
634: ben_bep_shd.g_old_rec.bep_attribute6;
630: ben_bep_shd.g_old_rec.bep_attribute5;
631: End If;
632: If (p_rec.bep_attribute6 = hr_api.g_varchar2) then
633: p_rec.bep_attribute6 :=
634: ben_bep_shd.g_old_rec.bep_attribute6;
635: End If;
636: If (p_rec.bep_attribute7 = hr_api.g_varchar2) then
637: p_rec.bep_attribute7 :=
638: ben_bep_shd.g_old_rec.bep_attribute7;
634: ben_bep_shd.g_old_rec.bep_attribute6;
635: End If;
636: If (p_rec.bep_attribute7 = hr_api.g_varchar2) then
637: p_rec.bep_attribute7 :=
638: ben_bep_shd.g_old_rec.bep_attribute7;
639: End If;
640: If (p_rec.bep_attribute8 = hr_api.g_varchar2) then
641: p_rec.bep_attribute8 :=
642: ben_bep_shd.g_old_rec.bep_attribute8;
638: ben_bep_shd.g_old_rec.bep_attribute7;
639: End If;
640: If (p_rec.bep_attribute8 = hr_api.g_varchar2) then
641: p_rec.bep_attribute8 :=
642: ben_bep_shd.g_old_rec.bep_attribute8;
643: End If;
644: If (p_rec.bep_attribute9 = hr_api.g_varchar2) then
645: p_rec.bep_attribute9 :=
646: ben_bep_shd.g_old_rec.bep_attribute9;
642: ben_bep_shd.g_old_rec.bep_attribute8;
643: End If;
644: If (p_rec.bep_attribute9 = hr_api.g_varchar2) then
645: p_rec.bep_attribute9 :=
646: ben_bep_shd.g_old_rec.bep_attribute9;
647: End If;
648: If (p_rec.bep_attribute10 = hr_api.g_varchar2) then
649: p_rec.bep_attribute10 :=
650: ben_bep_shd.g_old_rec.bep_attribute10;
646: ben_bep_shd.g_old_rec.bep_attribute9;
647: End If;
648: If (p_rec.bep_attribute10 = hr_api.g_varchar2) then
649: p_rec.bep_attribute10 :=
650: ben_bep_shd.g_old_rec.bep_attribute10;
651: End If;
652: If (p_rec.bep_attribute11 = hr_api.g_varchar2) then
653: p_rec.bep_attribute11 :=
654: ben_bep_shd.g_old_rec.bep_attribute11;
650: ben_bep_shd.g_old_rec.bep_attribute10;
651: End If;
652: If (p_rec.bep_attribute11 = hr_api.g_varchar2) then
653: p_rec.bep_attribute11 :=
654: ben_bep_shd.g_old_rec.bep_attribute11;
655: End If;
656: If (p_rec.bep_attribute12 = hr_api.g_varchar2) then
657: p_rec.bep_attribute12 :=
658: ben_bep_shd.g_old_rec.bep_attribute12;
654: ben_bep_shd.g_old_rec.bep_attribute11;
655: End If;
656: If (p_rec.bep_attribute12 = hr_api.g_varchar2) then
657: p_rec.bep_attribute12 :=
658: ben_bep_shd.g_old_rec.bep_attribute12;
659: End If;
660: If (p_rec.bep_attribute13 = hr_api.g_varchar2) then
661: p_rec.bep_attribute13 :=
662: ben_bep_shd.g_old_rec.bep_attribute13;
658: ben_bep_shd.g_old_rec.bep_attribute12;
659: End If;
660: If (p_rec.bep_attribute13 = hr_api.g_varchar2) then
661: p_rec.bep_attribute13 :=
662: ben_bep_shd.g_old_rec.bep_attribute13;
663: End If;
664: If (p_rec.bep_attribute14 = hr_api.g_varchar2) then
665: p_rec.bep_attribute14 :=
666: ben_bep_shd.g_old_rec.bep_attribute14;
662: ben_bep_shd.g_old_rec.bep_attribute13;
663: End If;
664: If (p_rec.bep_attribute14 = hr_api.g_varchar2) then
665: p_rec.bep_attribute14 :=
666: ben_bep_shd.g_old_rec.bep_attribute14;
667: End If;
668: If (p_rec.bep_attribute15 = hr_api.g_varchar2) then
669: p_rec.bep_attribute15 :=
670: ben_bep_shd.g_old_rec.bep_attribute15;
666: ben_bep_shd.g_old_rec.bep_attribute14;
667: End If;
668: If (p_rec.bep_attribute15 = hr_api.g_varchar2) then
669: p_rec.bep_attribute15 :=
670: ben_bep_shd.g_old_rec.bep_attribute15;
671: End If;
672: If (p_rec.bep_attribute16 = hr_api.g_varchar2) then
673: p_rec.bep_attribute16 :=
674: ben_bep_shd.g_old_rec.bep_attribute16;
670: ben_bep_shd.g_old_rec.bep_attribute15;
671: End If;
672: If (p_rec.bep_attribute16 = hr_api.g_varchar2) then
673: p_rec.bep_attribute16 :=
674: ben_bep_shd.g_old_rec.bep_attribute16;
675: End If;
676: If (p_rec.bep_attribute17 = hr_api.g_varchar2) then
677: p_rec.bep_attribute17 :=
678: ben_bep_shd.g_old_rec.bep_attribute17;
674: ben_bep_shd.g_old_rec.bep_attribute16;
675: End If;
676: If (p_rec.bep_attribute17 = hr_api.g_varchar2) then
677: p_rec.bep_attribute17 :=
678: ben_bep_shd.g_old_rec.bep_attribute17;
679: End If;
680: If (p_rec.bep_attribute18 = hr_api.g_varchar2) then
681: p_rec.bep_attribute18 :=
682: ben_bep_shd.g_old_rec.bep_attribute18;
678: ben_bep_shd.g_old_rec.bep_attribute17;
679: End If;
680: If (p_rec.bep_attribute18 = hr_api.g_varchar2) then
681: p_rec.bep_attribute18 :=
682: ben_bep_shd.g_old_rec.bep_attribute18;
683: End If;
684: If (p_rec.bep_attribute19 = hr_api.g_varchar2) then
685: p_rec.bep_attribute19 :=
686: ben_bep_shd.g_old_rec.bep_attribute19;
682: ben_bep_shd.g_old_rec.bep_attribute18;
683: End If;
684: If (p_rec.bep_attribute19 = hr_api.g_varchar2) then
685: p_rec.bep_attribute19 :=
686: ben_bep_shd.g_old_rec.bep_attribute19;
687: End If;
688: If (p_rec.bep_attribute20 = hr_api.g_varchar2) then
689: p_rec.bep_attribute20 :=
690: ben_bep_shd.g_old_rec.bep_attribute20;
686: ben_bep_shd.g_old_rec.bep_attribute19;
687: End If;
688: If (p_rec.bep_attribute20 = hr_api.g_varchar2) then
689: p_rec.bep_attribute20 :=
690: ben_bep_shd.g_old_rec.bep_attribute20;
691: End If;
692: --
693: End convert_defs;
694: --
697: -- ----------------------------------------------------------------------------
698: Procedure upd
699: (p_effective_date in date
700: ,p_datetrack_mode in varchar2
701: ,p_rec in out nocopy ben_bep_shd.g_rec_type
702: ) is
703: --
704: l_proc varchar2(72) := g_package||'upd';
705: l_validation_start_date date;
713: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
714: --
715: -- We must lock the row which we need to update.
716: --
717: ben_bep_shd.lck
718: (p_effective_date => p_effective_date
719: ,p_datetrack_mode => p_datetrack_mode
720: ,p_elig_obj_elig_prfl_id => p_rec.elig_obj_elig_prfl_id
721: ,p_object_version_number => p_rec.object_version_number
812: ,p_effective_start_date out nocopy date
813: ,p_effective_end_date out nocopy date
814: ) is
815: --
816: l_rec ben_bep_shd.g_rec_type;
817: l_proc varchar2(72) := g_package||'upd';
818: --
819: Begin
820: hr_utility.set_location('Entering:'||l_proc, 5);
822: -- Call conversion function to turn arguments into the
823: -- l_rec structure.
824: --
825: l_rec :=
826: ben_bep_shd.convert_args
827: (p_elig_obj_elig_prfl_id
828: ,null
829: ,null
830: ,p_elig_obj_id