139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
146: ben_prv_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
146: ben_prv_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
151: ben_prv_shd.constraint_error
144: -- A check constraint has been violated
145: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
146: ben_prv_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
151: ben_prv_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
151: ben_prv_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
156: ben_prv_shd.constraint_error
149: -- Parent integrity has been violated
150: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
151: ben_prv_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
156: ben_prv_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
156: ben_prv_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;
449: ,p_effective_date => p_effective_date );
450: end if ;
451: exception
452: --
453: when hr_api.cannot_find_prog_unit then
454: --
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'ben_prtt_rt_val'
457: ,p_hook_type => 'AU');
451: exception
452: --
453: when hr_api.cannot_find_prog_unit then
454: --
455: hr_api.cannot_find_prog_unit_error
456: (p_module_name => 'ben_prtt_rt_val'
457: ,p_hook_type => 'AU');
458: --
459: end;
519: -- p_rec plsql record structure
520: -- to see if a system default is being used. If a system default
521: -- is being used then we must set to the 'current' argument value.
522: --
523: If (p_rec.rt_strt_dt = hr_api.g_date) then
524: p_rec.rt_strt_dt :=
525: ben_prv_shd.g_old_rec.rt_strt_dt;
526: End If;
527: If (p_rec.rt_end_dt = hr_api.g_date) then
523: If (p_rec.rt_strt_dt = hr_api.g_date) then
524: p_rec.rt_strt_dt :=
525: ben_prv_shd.g_old_rec.rt_strt_dt;
526: End If;
527: If (p_rec.rt_end_dt = hr_api.g_date) then
528: p_rec.rt_end_dt :=
529: ben_prv_shd.g_old_rec.rt_end_dt;
530: End If;
531: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
527: If (p_rec.rt_end_dt = hr_api.g_date) then
528: p_rec.rt_end_dt :=
529: ben_prv_shd.g_old_rec.rt_end_dt;
530: End If;
531: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
532: p_rec.rt_typ_cd :=
533: ben_prv_shd.g_old_rec.rt_typ_cd;
534: End If;
535: If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
531: If (p_rec.rt_typ_cd = hr_api.g_varchar2) then
532: p_rec.rt_typ_cd :=
533: ben_prv_shd.g_old_rec.rt_typ_cd;
534: End If;
535: If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
536: p_rec.tx_typ_cd :=
537: ben_prv_shd.g_old_rec.tx_typ_cd;
538: End If;
539: If (p_rec.ordr_num = hr_api.g_number) then
535: If (p_rec.tx_typ_cd = hr_api.g_varchar2) then
536: p_rec.tx_typ_cd :=
537: ben_prv_shd.g_old_rec.tx_typ_cd;
538: End If;
539: If (p_rec.ordr_num = hr_api.g_number) then
540: p_rec.ordr_num :=
541: ben_abr_shd.g_old_rec.ordr_num;
542: End If;
543: If (p_rec.acty_typ_cd = hr_api.g_varchar2) then
539: If (p_rec.ordr_num = hr_api.g_number) then
540: p_rec.ordr_num :=
541: ben_abr_shd.g_old_rec.ordr_num;
542: End If;
543: If (p_rec.acty_typ_cd = hr_api.g_varchar2) then
544: p_rec.acty_typ_cd :=
545: ben_prv_shd.g_old_rec.acty_typ_cd;
546: End If;
547: If (p_rec.mlt_cd = hr_api.g_varchar2) then
543: If (p_rec.acty_typ_cd = hr_api.g_varchar2) then
544: p_rec.acty_typ_cd :=
545: ben_prv_shd.g_old_rec.acty_typ_cd;
546: End If;
547: If (p_rec.mlt_cd = hr_api.g_varchar2) then
548: p_rec.mlt_cd :=
549: ben_prv_shd.g_old_rec.mlt_cd;
550: End If;
551: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
547: If (p_rec.mlt_cd = hr_api.g_varchar2) then
548: p_rec.mlt_cd :=
549: ben_prv_shd.g_old_rec.mlt_cd;
550: End If;
551: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
552: p_rec.acty_ref_perd_cd :=
553: ben_prv_shd.g_old_rec.acty_ref_perd_cd;
554: End If;
555: If (p_rec.rt_val = hr_api.g_number) then
551: If (p_rec.acty_ref_perd_cd = hr_api.g_varchar2) then
552: p_rec.acty_ref_perd_cd :=
553: ben_prv_shd.g_old_rec.acty_ref_perd_cd;
554: End If;
555: If (p_rec.rt_val = hr_api.g_number) then
556: p_rec.rt_val :=
557: ben_prv_shd.g_old_rec.rt_val;
558: End If;
559: If (p_rec.ann_rt_val = hr_api.g_number) then
555: If (p_rec.rt_val = hr_api.g_number) then
556: p_rec.rt_val :=
557: ben_prv_shd.g_old_rec.rt_val;
558: End If;
559: If (p_rec.ann_rt_val = hr_api.g_number) then
560: p_rec.ann_rt_val :=
561: ben_prv_shd.g_old_rec.ann_rt_val;
562: End If;
563: If (p_rec.cmcd_rt_val = hr_api.g_number) then
559: If (p_rec.ann_rt_val = hr_api.g_number) then
560: p_rec.ann_rt_val :=
561: ben_prv_shd.g_old_rec.ann_rt_val;
562: End If;
563: If (p_rec.cmcd_rt_val = hr_api.g_number) then
564: p_rec.cmcd_rt_val :=
565: ben_prv_shd.g_old_rec.cmcd_rt_val;
566: End If;
567: If (p_rec.cmcd_ref_perd_cd = hr_api.g_varchar2) then
563: If (p_rec.cmcd_rt_val = hr_api.g_number) then
564: p_rec.cmcd_rt_val :=
565: ben_prv_shd.g_old_rec.cmcd_rt_val;
566: End If;
567: If (p_rec.cmcd_ref_perd_cd = hr_api.g_varchar2) then
568: p_rec.cmcd_ref_perd_cd :=
569: ben_prv_shd.g_old_rec.cmcd_ref_perd_cd;
570: End If;
571: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
567: If (p_rec.cmcd_ref_perd_cd = hr_api.g_varchar2) then
568: p_rec.cmcd_ref_perd_cd :=
569: ben_prv_shd.g_old_rec.cmcd_ref_perd_cd;
570: End If;
571: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
572: p_rec.bnft_rt_typ_cd :=
573: ben_prv_shd.g_old_rec.bnft_rt_typ_cd;
574: End If;
575: If (p_rec.dsply_on_enrt_flag = hr_api.g_varchar2) then
571: If (p_rec.bnft_rt_typ_cd = hr_api.g_varchar2) then
572: p_rec.bnft_rt_typ_cd :=
573: ben_prv_shd.g_old_rec.bnft_rt_typ_cd;
574: End If;
575: If (p_rec.dsply_on_enrt_flag = hr_api.g_varchar2) then
576: p_rec.dsply_on_enrt_flag :=
577: ben_prv_shd.g_old_rec.dsply_on_enrt_flag;
578: End If;
579: If (p_rec.rt_ovridn_flag = hr_api.g_varchar2) then
575: If (p_rec.dsply_on_enrt_flag = hr_api.g_varchar2) then
576: p_rec.dsply_on_enrt_flag :=
577: ben_prv_shd.g_old_rec.dsply_on_enrt_flag;
578: End If;
579: If (p_rec.rt_ovridn_flag = hr_api.g_varchar2) then
580: p_rec.rt_ovridn_flag :=
581: ben_prv_shd.g_old_rec.rt_ovridn_flag;
582: End If;
583: If (p_rec.rt_ovridn_thru_dt = hr_api.g_date) then
579: If (p_rec.rt_ovridn_flag = hr_api.g_varchar2) then
580: p_rec.rt_ovridn_flag :=
581: ben_prv_shd.g_old_rec.rt_ovridn_flag;
582: End If;
583: If (p_rec.rt_ovridn_thru_dt = hr_api.g_date) then
584: p_rec.rt_ovridn_thru_dt :=
585: ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
586: End If;
587: If (p_rec.elctns_made_dt = hr_api.g_date) then
583: If (p_rec.rt_ovridn_thru_dt = hr_api.g_date) then
584: p_rec.rt_ovridn_thru_dt :=
585: ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
586: End If;
587: If (p_rec.elctns_made_dt = hr_api.g_date) then
588: p_rec.elctns_made_dt :=
589: ben_prv_shd.g_old_rec.elctns_made_dt;
590: End If;
591: If (p_rec.prtt_rt_val_stat_cd = hr_api.g_varchar2) then
587: If (p_rec.elctns_made_dt = hr_api.g_date) then
588: p_rec.elctns_made_dt :=
589: ben_prv_shd.g_old_rec.elctns_made_dt;
590: End If;
591: If (p_rec.prtt_rt_val_stat_cd = hr_api.g_varchar2) then
592: p_rec.prtt_rt_val_stat_cd :=
593: ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
594: End If;
595: If (p_rec.prtt_enrt_rslt_id = hr_api.g_number) then
591: If (p_rec.prtt_rt_val_stat_cd = hr_api.g_varchar2) then
592: p_rec.prtt_rt_val_stat_cd :=
593: ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
594: End If;
595: If (p_rec.prtt_enrt_rslt_id = hr_api.g_number) then
596: p_rec.prtt_enrt_rslt_id :=
597: ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
598: End If;
599: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
595: If (p_rec.prtt_enrt_rslt_id = hr_api.g_number) then
596: p_rec.prtt_enrt_rslt_id :=
597: ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
598: End If;
599: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
600: p_rec.cvg_amt_calc_mthd_id :=
601: ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id;
602: End If;
603: If (p_rec.actl_prem_id = hr_api.g_number) then
599: If (p_rec.cvg_amt_calc_mthd_id = hr_api.g_number) then
600: p_rec.cvg_amt_calc_mthd_id :=
601: ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id;
602: End If;
603: If (p_rec.actl_prem_id = hr_api.g_number) then
604: p_rec.actl_prem_id :=
605: ben_prv_shd.g_old_rec.actl_prem_id;
606: End If;
607: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
603: If (p_rec.actl_prem_id = hr_api.g_number) then
604: p_rec.actl_prem_id :=
605: ben_prv_shd.g_old_rec.actl_prem_id;
606: End If;
607: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
608: p_rec.comp_lvl_fctr_id :=
609: ben_prv_shd.g_old_rec.comp_lvl_fctr_id;
610: End If;
611: If (p_rec.element_entry_value_id = hr_api.g_number) then
607: If (p_rec.comp_lvl_fctr_id = hr_api.g_number) then
608: p_rec.comp_lvl_fctr_id :=
609: ben_prv_shd.g_old_rec.comp_lvl_fctr_id;
610: End If;
611: If (p_rec.element_entry_value_id = hr_api.g_number) then
612: p_rec.element_entry_value_id :=
613: ben_prv_shd.g_old_rec.element_entry_value_id;
614: End If;
615: If (p_rec.per_in_ler_id = hr_api.g_number) then
611: If (p_rec.element_entry_value_id = hr_api.g_number) then
612: p_rec.element_entry_value_id :=
613: ben_prv_shd.g_old_rec.element_entry_value_id;
614: End If;
615: If (p_rec.per_in_ler_id = hr_api.g_number) then
616: p_rec.per_in_ler_id :=
617: ben_prv_shd.g_old_rec.per_in_ler_id;
618: End If;
619: If (p_rec.ended_per_in_ler_id = hr_api.g_number) then
615: If (p_rec.per_in_ler_id = hr_api.g_number) then
616: p_rec.per_in_ler_id :=
617: ben_prv_shd.g_old_rec.per_in_ler_id;
618: End If;
619: If (p_rec.ended_per_in_ler_id = hr_api.g_number) then
620: p_rec.ended_per_in_ler_id :=
621: ben_prv_shd.g_old_rec.ended_per_in_ler_id;
622: End If;
623: If (p_rec.acty_base_rt_id = hr_api.g_number) then
619: If (p_rec.ended_per_in_ler_id = hr_api.g_number) then
620: p_rec.ended_per_in_ler_id :=
621: ben_prv_shd.g_old_rec.ended_per_in_ler_id;
622: End If;
623: If (p_rec.acty_base_rt_id = hr_api.g_number) then
624: p_rec.acty_base_rt_id :=
625: ben_prv_shd.g_old_rec.acty_base_rt_id;
626: End If;
627: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
623: If (p_rec.acty_base_rt_id = hr_api.g_number) then
624: p_rec.acty_base_rt_id :=
625: ben_prv_shd.g_old_rec.acty_base_rt_id;
626: End If;
627: If (p_rec.prtt_reimbmt_rqst_id = hr_api.g_number) then
628: p_rec.prtt_reimbmt_rqst_id :=
629: ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id;
630: End If;
631:
628: p_rec.prtt_reimbmt_rqst_id :=
629: ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id;
630: End If;
631:
632: If (p_rec.prtt_rmt_aprvd_fr_pymt_id = hr_api.g_number) then
633: p_rec.prtt_rmt_aprvd_fr_pymt_id :=
634: ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id;
635: End If;
636:
633: p_rec.prtt_rmt_aprvd_fr_pymt_id :=
634: ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id;
635: End If;
636:
637: If (p_rec.pp_in_yr_used_num = hr_api.g_number) then
638: p_rec.pp_in_yr_used_num :=
639: ben_prv_shd.g_old_rec.pp_in_yr_used_num;
640: End If;
641:
639: ben_prv_shd.g_old_rec.pp_in_yr_used_num;
640: End If;
641:
642:
643: If (p_rec.business_group_id = hr_api.g_number) then
644: p_rec.business_group_id :=
645: ben_prv_shd.g_old_rec.business_group_id;
646: End If;
647:
644: p_rec.business_group_id :=
645: ben_prv_shd.g_old_rec.business_group_id;
646: End If;
647:
648: If (p_rec.prv_attribute_category = hr_api.g_varchar2) then
649: p_rec.prv_attribute_category :=
650: ben_prv_shd.g_old_rec.prv_attribute_category;
651: End If;
652:
649: p_rec.prv_attribute_category :=
650: ben_prv_shd.g_old_rec.prv_attribute_category;
651: End If;
652:
653: If (p_rec.prv_attribute1 = hr_api.g_varchar2) then
654: p_rec.prv_attribute1 :=
655: ben_prv_shd.g_old_rec.prv_attribute1;
656: End If;
657:
654: p_rec.prv_attribute1 :=
655: ben_prv_shd.g_old_rec.prv_attribute1;
656: End If;
657:
658: If (p_rec.prv_attribute2 = hr_api.g_varchar2) then
659: p_rec.prv_attribute2 :=
660: ben_prv_shd.g_old_rec.prv_attribute2;
661: End If;
662: If (p_rec.prv_attribute3 = hr_api.g_varchar2) then
658: If (p_rec.prv_attribute2 = hr_api.g_varchar2) then
659: p_rec.prv_attribute2 :=
660: ben_prv_shd.g_old_rec.prv_attribute2;
661: End If;
662: If (p_rec.prv_attribute3 = hr_api.g_varchar2) then
663: p_rec.prv_attribute3 :=
664: ben_prv_shd.g_old_rec.prv_attribute3;
665: End If;
666: If (p_rec.prv_attribute4 = hr_api.g_varchar2) then
662: If (p_rec.prv_attribute3 = hr_api.g_varchar2) then
663: p_rec.prv_attribute3 :=
664: ben_prv_shd.g_old_rec.prv_attribute3;
665: End If;
666: If (p_rec.prv_attribute4 = hr_api.g_varchar2) then
667: p_rec.prv_attribute4 :=
668: ben_prv_shd.g_old_rec.prv_attribute4;
669: End If;
670: If (p_rec.prv_attribute5 = hr_api.g_varchar2) then
666: If (p_rec.prv_attribute4 = hr_api.g_varchar2) then
667: p_rec.prv_attribute4 :=
668: ben_prv_shd.g_old_rec.prv_attribute4;
669: End If;
670: If (p_rec.prv_attribute5 = hr_api.g_varchar2) then
671: p_rec.prv_attribute5 :=
672: ben_prv_shd.g_old_rec.prv_attribute5;
673: End If;
674: If (p_rec.prv_attribute6 = hr_api.g_varchar2) then
670: If (p_rec.prv_attribute5 = hr_api.g_varchar2) then
671: p_rec.prv_attribute5 :=
672: ben_prv_shd.g_old_rec.prv_attribute5;
673: End If;
674: If (p_rec.prv_attribute6 = hr_api.g_varchar2) then
675: p_rec.prv_attribute6 :=
676: ben_prv_shd.g_old_rec.prv_attribute6;
677: End If;
678: If (p_rec.prv_attribute7 = hr_api.g_varchar2) then
674: If (p_rec.prv_attribute6 = hr_api.g_varchar2) then
675: p_rec.prv_attribute6 :=
676: ben_prv_shd.g_old_rec.prv_attribute6;
677: End If;
678: If (p_rec.prv_attribute7 = hr_api.g_varchar2) then
679: p_rec.prv_attribute7 :=
680: ben_prv_shd.g_old_rec.prv_attribute7;
681: End If;
682: If (p_rec.prv_attribute8 = hr_api.g_varchar2) then
678: If (p_rec.prv_attribute7 = hr_api.g_varchar2) then
679: p_rec.prv_attribute7 :=
680: ben_prv_shd.g_old_rec.prv_attribute7;
681: End If;
682: If (p_rec.prv_attribute8 = hr_api.g_varchar2) then
683: p_rec.prv_attribute8 :=
684: ben_prv_shd.g_old_rec.prv_attribute8;
685: End If;
686: If (p_rec.prv_attribute9 = hr_api.g_varchar2) then
682: If (p_rec.prv_attribute8 = hr_api.g_varchar2) then
683: p_rec.prv_attribute8 :=
684: ben_prv_shd.g_old_rec.prv_attribute8;
685: End If;
686: If (p_rec.prv_attribute9 = hr_api.g_varchar2) then
687: p_rec.prv_attribute9 :=
688: ben_prv_shd.g_old_rec.prv_attribute9;
689: End If;
690: If (p_rec.prv_attribute10 = hr_api.g_varchar2) then
686: If (p_rec.prv_attribute9 = hr_api.g_varchar2) then
687: p_rec.prv_attribute9 :=
688: ben_prv_shd.g_old_rec.prv_attribute9;
689: End If;
690: If (p_rec.prv_attribute10 = hr_api.g_varchar2) then
691: p_rec.prv_attribute10 :=
692: ben_prv_shd.g_old_rec.prv_attribute10;
693: End If;
694: If (p_rec.prv_attribute11 = hr_api.g_varchar2) then
690: If (p_rec.prv_attribute10 = hr_api.g_varchar2) then
691: p_rec.prv_attribute10 :=
692: ben_prv_shd.g_old_rec.prv_attribute10;
693: End If;
694: If (p_rec.prv_attribute11 = hr_api.g_varchar2) then
695: p_rec.prv_attribute11 :=
696: ben_prv_shd.g_old_rec.prv_attribute11;
697: End If;
698: If (p_rec.prv_attribute12 = hr_api.g_varchar2) then
694: If (p_rec.prv_attribute11 = hr_api.g_varchar2) then
695: p_rec.prv_attribute11 :=
696: ben_prv_shd.g_old_rec.prv_attribute11;
697: End If;
698: If (p_rec.prv_attribute12 = hr_api.g_varchar2) then
699: p_rec.prv_attribute12 :=
700: ben_prv_shd.g_old_rec.prv_attribute12;
701: End If;
702: If (p_rec.prv_attribute13 = hr_api.g_varchar2) then
698: If (p_rec.prv_attribute12 = hr_api.g_varchar2) then
699: p_rec.prv_attribute12 :=
700: ben_prv_shd.g_old_rec.prv_attribute12;
701: End If;
702: If (p_rec.prv_attribute13 = hr_api.g_varchar2) then
703: p_rec.prv_attribute13 :=
704: ben_prv_shd.g_old_rec.prv_attribute13;
705: End If;
706: If (p_rec.prv_attribute14 = hr_api.g_varchar2) then
702: If (p_rec.prv_attribute13 = hr_api.g_varchar2) then
703: p_rec.prv_attribute13 :=
704: ben_prv_shd.g_old_rec.prv_attribute13;
705: End If;
706: If (p_rec.prv_attribute14 = hr_api.g_varchar2) then
707: p_rec.prv_attribute14 :=
708: ben_prv_shd.g_old_rec.prv_attribute14;
709: End If;
710: If (p_rec.prv_attribute15 = hr_api.g_varchar2) then
706: If (p_rec.prv_attribute14 = hr_api.g_varchar2) then
707: p_rec.prv_attribute14 :=
708: ben_prv_shd.g_old_rec.prv_attribute14;
709: End If;
710: If (p_rec.prv_attribute15 = hr_api.g_varchar2) then
711: p_rec.prv_attribute15 :=
712: ben_prv_shd.g_old_rec.prv_attribute15;
713: End If;
714: If (p_rec.prv_attribute16 = hr_api.g_varchar2) then
710: If (p_rec.prv_attribute15 = hr_api.g_varchar2) then
711: p_rec.prv_attribute15 :=
712: ben_prv_shd.g_old_rec.prv_attribute15;
713: End If;
714: If (p_rec.prv_attribute16 = hr_api.g_varchar2) then
715: p_rec.prv_attribute16 :=
716: ben_prv_shd.g_old_rec.prv_attribute16;
717: End If;
718: If (p_rec.prv_attribute17 = hr_api.g_varchar2) then
714: If (p_rec.prv_attribute16 = hr_api.g_varchar2) then
715: p_rec.prv_attribute16 :=
716: ben_prv_shd.g_old_rec.prv_attribute16;
717: End If;
718: If (p_rec.prv_attribute17 = hr_api.g_varchar2) then
719: p_rec.prv_attribute17 :=
720: ben_prv_shd.g_old_rec.prv_attribute17;
721: End If;
722: If (p_rec.prv_attribute18 = hr_api.g_varchar2) then
718: If (p_rec.prv_attribute17 = hr_api.g_varchar2) then
719: p_rec.prv_attribute17 :=
720: ben_prv_shd.g_old_rec.prv_attribute17;
721: End If;
722: If (p_rec.prv_attribute18 = hr_api.g_varchar2) then
723: p_rec.prv_attribute18 :=
724: ben_prv_shd.g_old_rec.prv_attribute18;
725: End If;
726: If (p_rec.prv_attribute19 = hr_api.g_varchar2) then
722: If (p_rec.prv_attribute18 = hr_api.g_varchar2) then
723: p_rec.prv_attribute18 :=
724: ben_prv_shd.g_old_rec.prv_attribute18;
725: End If;
726: If (p_rec.prv_attribute19 = hr_api.g_varchar2) then
727: p_rec.prv_attribute19 :=
728: ben_prv_shd.g_old_rec.prv_attribute19;
729: End If;
730: If (p_rec.prv_attribute20 = hr_api.g_varchar2) then
726: If (p_rec.prv_attribute19 = hr_api.g_varchar2) then
727: p_rec.prv_attribute19 :=
728: ben_prv_shd.g_old_rec.prv_attribute19;
729: End If;
730: If (p_rec.prv_attribute20 = hr_api.g_varchar2) then
731: p_rec.prv_attribute20 :=
732: ben_prv_shd.g_old_rec.prv_attribute20;
733: End If;
734: If (p_rec.prv_attribute21 = hr_api.g_varchar2) then
730: If (p_rec.prv_attribute20 = hr_api.g_varchar2) then
731: p_rec.prv_attribute20 :=
732: ben_prv_shd.g_old_rec.prv_attribute20;
733: End If;
734: If (p_rec.prv_attribute21 = hr_api.g_varchar2) then
735: p_rec.prv_attribute21 :=
736: ben_prv_shd.g_old_rec.prv_attribute21;
737: End If;
738: If (p_rec.prv_attribute22 = hr_api.g_varchar2) then
734: If (p_rec.prv_attribute21 = hr_api.g_varchar2) then
735: p_rec.prv_attribute21 :=
736: ben_prv_shd.g_old_rec.prv_attribute21;
737: End If;
738: If (p_rec.prv_attribute22 = hr_api.g_varchar2) then
739: p_rec.prv_attribute22 :=
740: ben_prv_shd.g_old_rec.prv_attribute22;
741: End If;
742: If (p_rec.prv_attribute23 = hr_api.g_varchar2) then
738: If (p_rec.prv_attribute22 = hr_api.g_varchar2) then
739: p_rec.prv_attribute22 :=
740: ben_prv_shd.g_old_rec.prv_attribute22;
741: End If;
742: If (p_rec.prv_attribute23 = hr_api.g_varchar2) then
743: p_rec.prv_attribute23 :=
744: ben_prv_shd.g_old_rec.prv_attribute23;
745: End If;
746: If (p_rec.prv_attribute24 = hr_api.g_varchar2) then
742: If (p_rec.prv_attribute23 = hr_api.g_varchar2) then
743: p_rec.prv_attribute23 :=
744: ben_prv_shd.g_old_rec.prv_attribute23;
745: End If;
746: If (p_rec.prv_attribute24 = hr_api.g_varchar2) then
747: p_rec.prv_attribute24 :=
748: ben_prv_shd.g_old_rec.prv_attribute24;
749: End If;
750: If (p_rec.prv_attribute25 = hr_api.g_varchar2) then
746: If (p_rec.prv_attribute24 = hr_api.g_varchar2) then
747: p_rec.prv_attribute24 :=
748: ben_prv_shd.g_old_rec.prv_attribute24;
749: End If;
750: If (p_rec.prv_attribute25 = hr_api.g_varchar2) then
751: p_rec.prv_attribute25 :=
752: ben_prv_shd.g_old_rec.prv_attribute25;
753: End If;
754: If (p_rec.prv_attribute26 = hr_api.g_varchar2) then
750: If (p_rec.prv_attribute25 = hr_api.g_varchar2) then
751: p_rec.prv_attribute25 :=
752: ben_prv_shd.g_old_rec.prv_attribute25;
753: End If;
754: If (p_rec.prv_attribute26 = hr_api.g_varchar2) then
755: p_rec.prv_attribute26 :=
756: ben_prv_shd.g_old_rec.prv_attribute26;
757: End If;
758: If (p_rec.prv_attribute27 = hr_api.g_varchar2) then
754: If (p_rec.prv_attribute26 = hr_api.g_varchar2) then
755: p_rec.prv_attribute26 :=
756: ben_prv_shd.g_old_rec.prv_attribute26;
757: End If;
758: If (p_rec.prv_attribute27 = hr_api.g_varchar2) then
759: p_rec.prv_attribute27 :=
760: ben_prv_shd.g_old_rec.prv_attribute27;
761: End If;
762: If (p_rec.prv_attribute28 = hr_api.g_varchar2) then
758: If (p_rec.prv_attribute27 = hr_api.g_varchar2) then
759: p_rec.prv_attribute27 :=
760: ben_prv_shd.g_old_rec.prv_attribute27;
761: End If;
762: If (p_rec.prv_attribute28 = hr_api.g_varchar2) then
763: p_rec.prv_attribute28 :=
764: ben_prv_shd.g_old_rec.prv_attribute28;
765: End If;
766: If (p_rec.prv_attribute29 = hr_api.g_varchar2) then
762: If (p_rec.prv_attribute28 = hr_api.g_varchar2) then
763: p_rec.prv_attribute28 :=
764: ben_prv_shd.g_old_rec.prv_attribute28;
765: End If;
766: If (p_rec.prv_attribute29 = hr_api.g_varchar2) then
767: p_rec.prv_attribute29 :=
768: ben_prv_shd.g_old_rec.prv_attribute29;
769: End If;
770: If (p_rec.prv_attribute30 = hr_api.g_varchar2) then
766: If (p_rec.prv_attribute29 = hr_api.g_varchar2) then
767: p_rec.prv_attribute29 :=
768: ben_prv_shd.g_old_rec.prv_attribute29;
769: End If;
770: If (p_rec.prv_attribute30 = hr_api.g_varchar2) then
771: p_rec.prv_attribute30 :=
772: ben_prv_shd.g_old_rec.prv_attribute30;
773: End If;
774: If (p_rec.pk_id_table_name = hr_api.g_varchar2) then
770: If (p_rec.prv_attribute30 = hr_api.g_varchar2) then
771: p_rec.prv_attribute30 :=
772: ben_prv_shd.g_old_rec.prv_attribute30;
773: End If;
774: If (p_rec.pk_id_table_name = hr_api.g_varchar2) then
775: p_rec.pk_id_table_name :=
776: ben_prv_shd.g_old_rec.pk_id_table_name;
777: End If;
778: If (p_rec.pk_id= hr_api.g_number) then
774: If (p_rec.pk_id_table_name = hr_api.g_varchar2) then
775: p_rec.pk_id_table_name :=
776: ben_prv_shd.g_old_rec.pk_id_table_name;
777: End If;
778: If (p_rec.pk_id= hr_api.g_number) then
779: p_rec.pk_id :=
780: ben_prv_shd.g_old_rec.pk_id;
781: End If;
782:
832: -- ----------------------------------------------------------------------------
833: Procedure upd
834: (
835: p_prtt_rt_val_id in number,
836: p_enrt_rt_id in number default hr_api.g_number,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
833: Procedure upd
834: (
835: p_prtt_rt_val_id in number,
836: p_enrt_rt_id in number default hr_api.g_number,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
834: (
835: p_prtt_rt_val_id in number,
836: p_enrt_rt_id in number default hr_api.g_number,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
835: p_prtt_rt_val_id in number,
836: p_enrt_rt_id in number default hr_api.g_number,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
836: p_enrt_rt_id in number default hr_api.g_number,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
837: p_rt_strt_dt in date default hr_api.g_date,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
838: p_rt_end_dt in date default hr_api.g_date,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
839: p_rt_typ_cd in varchar2 default hr_api.g_varchar2,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
840: p_tx_typ_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
841: p_ordr_num in number default hr_api.g_number,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
842: p_acty_typ_cd in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
843: p_mlt_cd in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
844: p_acty_ref_perd_cd in varchar2 default hr_api.g_varchar2,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
845: p_rt_val in number default hr_api.g_number,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
846: p_ann_rt_val in number default hr_api.g_number,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
847: p_cmcd_rt_val in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
848: p_cmcd_ref_perd_cd in varchar2 default hr_api.g_varchar2,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
849: p_bnft_rt_typ_cd in varchar2 default hr_api.g_varchar2,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
850: p_dsply_on_enrt_flag in varchar2 default hr_api.g_varchar2,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
851: p_rt_ovridn_flag in varchar2 default hr_api.g_varchar2,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
852: p_rt_ovridn_thru_dt in date default hr_api.g_date,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
853: p_elctns_made_dt in date default hr_api.g_date,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
854: p_prtt_rt_val_stat_cd in varchar2 default hr_api.g_varchar2,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
855: p_prtt_enrt_rslt_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
856: p_cvg_amt_calc_mthd_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
857: p_actl_prem_id in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
858: p_comp_lvl_fctr_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
859: p_element_entry_value_id in number default hr_api.g_number,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
860: p_per_in_ler_id in number default hr_api.g_number,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
861: p_ended_per_in_ler_id in number default hr_api.g_number,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
862: p_acty_base_rt_id in number default hr_api.g_number,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
863: p_prtt_reimbmt_rqst_id in number default hr_api.g_number,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
864: p_prtt_rmt_aprvd_fr_pymt_id in number default hr_api.g_number,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
865: p_pp_in_yr_used_num in number default hr_api.g_number,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
866: p_business_group_id in number default hr_api.g_number,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
867: p_prv_attribute_category in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
868: p_prv_attribute1 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
869: p_prv_attribute2 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
870: p_prv_attribute3 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
871: p_prv_attribute4 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
872: p_prv_attribute5 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
873: p_prv_attribute6 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
874: p_prv_attribute7 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
875: p_prv_attribute8 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
876: p_prv_attribute9 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
877: p_prv_attribute10 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
878: p_prv_attribute11 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
879: p_prv_attribute12 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
880: p_prv_attribute13 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
881: p_prv_attribute14 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
882: p_prv_attribute15 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
883: p_prv_attribute16 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
884: p_prv_attribute17 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
885: p_prv_attribute18 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
886: p_prv_attribute19 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
887: p_prv_attribute20 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
888: p_prv_attribute21 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
889: p_prv_attribute22 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
890: p_prv_attribute23 in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
891: p_prv_attribute24 in varchar2 default hr_api.g_varchar2,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
899: p_pk_id in number default hr_api.g_number,
892: p_prv_attribute25 in varchar2 default hr_api.g_varchar2,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
899: p_pk_id in number default hr_api.g_number,
900: p_object_version_number in out nocopy number ,
893: p_prv_attribute26 in varchar2 default hr_api.g_varchar2,
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
899: p_pk_id in number default hr_api.g_number,
900: p_object_version_number in out nocopy number ,
901: p_effective_Date in date
894: p_prv_attribute27 in varchar2 default hr_api.g_varchar2,
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
899: p_pk_id in number default hr_api.g_number,
900: p_object_version_number in out nocopy number ,
901: p_effective_Date in date
902: ) is
895: p_prv_attribute28 in varchar2 default hr_api.g_varchar2,
896: p_prv_attribute29 in varchar2 default hr_api.g_varchar2,
897: p_prv_attribute30 in varchar2 default hr_api.g_varchar2,
898: p_pk_id_table_name in varchar2 default hr_api.g_varchar2,
899: p_pk_id in number default hr_api.g_number,
900: p_object_version_number in out nocopy number ,
901: p_effective_Date in date
902: ) is
903: --