[Home] [Help]
54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_prc_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) is
77: (p_base_table_name => 'ben_prtt_reimbmt_rqst_f',
78: p_base_key_column => 'prtt_reimbmt_rqst_id',
79: p_base_key_value => p_rec.prtt_reimbmt_rqst_id);
80: --
81: ben_prc_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_prtt_reimbmt_rqst_f Row
84: --
85: update ben_prtt_reimbmt_rqst_f
158: where prtt_reimbmt_rqst_id = p_rec.prtt_reimbmt_rqst_id
159: and effective_start_date = p_validation_start_date
160: and effective_end_date = p_validation_end_date;
161: --
162: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
163: --
164: -- Set the effective start and end dates
165: --
166: p_rec.effective_start_date := p_validation_start_date;
170: hr_utility.set_location(' Leaving:'||l_proc, 15);
171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
175: ben_prc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
171: Exception
172: When hr_api.check_integrity_violated Then
173: -- A check constraint has been violated
174: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
175: ben_prc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
175: ben_prc_shd.constraint_error
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
180: ben_prc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
176: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
177: When hr_api.unique_integrity_violated Then
178: -- Unique integrity has been violated
179: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
180: ben_prc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
184: Raise;
179: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
180: ben_prc_shd.constraint_error
181: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
182: When Others Then
183: ben_prc_shd.g_api_dml := false; -- Unset the api dml status
184: Raise;
185: End dt_update_dml;
186: --
187: -- ----------------------------------------------------------------------------
215: --
216: -- {End Of Comments}
217: -- ----------------------------------------------------------------------------
218: Procedure update_dml
219: (p_rec in out nocopy ben_prc_shd.g_rec_type,
220: p_effective_date in date,
221: p_datetrack_mode in varchar2,
222: p_validation_start_date in date,
223: p_validation_end_date in date) is
279: --
280: -- {End Of Comments}
281: -- ----------------------------------------------------------------------------
282: Procedure dt_pre_update
283: (p_rec in out nocopy ben_prc_shd.g_rec_type,
284: p_effective_date in date,
285: p_datetrack_mode in varchar2,
286: p_validation_start_date in date,
287: p_validation_end_date in date) is
295: hr_utility.set_location(l_proc, 10);
296: --
297: -- Update the current effective end date
298: --
299: ben_prc_shd.upd_effective_end_date
300: (p_effective_date => p_effective_date,
301: p_base_key_value => p_rec.prtt_reimbmt_rqst_id,
302: p_new_effective_end_date => (p_validation_start_date - 1),
303: p_validation_start_date => p_validation_start_date,
364: --
365: -- {End Of Comments}
366: -- ----------------------------------------------------------------------------
367: Procedure pre_update
368: (p_rec in out nocopy ben_prc_shd.g_rec_type,
369: p_effective_date in date,
370: p_datetrack_mode in varchar2,
371: p_validation_start_date in date,
372: p_validation_end_date in date) is
420: --
421: -- {End Of Comments}
422: -- ----------------------------------------------------------------------------
423: Procedure post_update
424: (p_rec in ben_prc_shd.g_rec_type,
425: p_effective_date in date,
426: p_datetrack_mode in varchar2,
427: p_validation_start_date in date,
428: p_validation_end_date in date) is
515: ,p_effective_date =>p_effective_date
516: ,p_datetrack_mode =>p_datetrack_mode
517: ,p_validation_start_date =>p_validation_start_date
518: ,p_validation_end_date =>p_validation_end_date
519: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
516: ,p_datetrack_mode =>p_datetrack_mode
517: ,p_validation_start_date =>p_validation_start_date
518: ,p_validation_end_date =>p_validation_end_date
519: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
517: ,p_validation_start_date =>p_validation_start_date
518: ,p_validation_end_date =>p_validation_end_date
519: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
518: ,p_validation_end_date =>p_validation_end_date
519: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
519: ,p_effective_start_date_o =>ben_prc_shd.g_old_rec.effective_start_date
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
520: ,p_effective_end_date_o =>ben_prc_shd.g_old_rec.effective_end_date
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
521: ,p_incrd_from_dt_o =>ben_prc_shd.g_old_rec.incrd_from_dt
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
522: ,p_incrd_to_dt_o =>ben_prc_shd.g_old_rec.incrd_to_dt
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
523: ,p_rqst_num_o =>ben_prc_shd.g_old_rec.rqst_num
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
524: ,p_rqst_amt_o =>ben_prc_shd.g_old_rec.rqst_amt
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
525: ,p_rqst_amt_uom_o =>ben_prc_shd.g_old_rec.rqst_amt_uom
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
526: ,p_rqst_btch_num_o =>ben_prc_shd.g_old_rec.rqst_btch_num
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
527: ,p_prtt_reimbmt_rqst_stat_cd_o =>ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
528: ,p_reimbmt_ctfn_typ_prvdd_cd_o =>ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
529: ,p_rcrrg_cd_o =>ben_prc_shd.g_old_rec.rcrrg_cd
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
530: ,p_submitter_person_id_o =>ben_prc_shd.g_old_rec.submitter_person_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
531: ,p_recipient_person_id_o =>ben_prc_shd.g_old_rec.recipient_person_id
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
532: ,p_provider_person_id_o =>ben_prc_shd.g_old_rec.provider_person_id
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
533: ,p_provider_ssn_person_id_o =>ben_prc_shd.g_old_rec.provider_ssn_person_id
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
534: ,p_pl_id_o =>ben_prc_shd.g_old_rec.pl_id
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
535: ,p_gd_or_svc_typ_id_o =>ben_prc_shd.g_old_rec.gd_or_svc_typ_id
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
536: ,p_contact_relationship_id_o =>ben_prc_shd.g_old_rec.contact_relationship_id
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
537: ,p_business_group_id_o =>ben_prc_shd.g_old_rec.business_group_id
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
538: ,p_opt_id_o =>ben_prc_shd.g_old_rec.opt_id
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
539: ,p_popl_yr_perd_id_1_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_1
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
540: ,p_popl_yr_perd_id_2_o =>ben_prc_shd.g_old_rec.popl_yr_perd_id_2
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
541: ,p_amt_year1_o =>ben_prc_shd.g_old_rec.amt_year1
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
542: ,p_amt_year2_o =>ben_prc_shd.g_old_rec.amt_year2
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
543: ,p_prc_attribute_category_o =>ben_prc_shd.g_old_rec.prc_attribute_category
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
544: ,p_prc_attribute1_o =>ben_prc_shd.g_old_rec.prc_attribute1
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
545: ,p_prc_attribute2_o =>ben_prc_shd.g_old_rec.prc_attribute2
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
546: ,p_prc_attribute3_o =>ben_prc_shd.g_old_rec.prc_attribute3
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
547: ,p_prc_attribute4_o =>ben_prc_shd.g_old_rec.prc_attribute4
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
548: ,p_prc_attribute5_o =>ben_prc_shd.g_old_rec.prc_attribute5
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
549: ,p_prc_attribute6_o =>ben_prc_shd.g_old_rec.prc_attribute6
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
550: ,p_prc_attribute7_o =>ben_prc_shd.g_old_rec.prc_attribute7
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
551: ,p_prc_attribute8_o =>ben_prc_shd.g_old_rec.prc_attribute8
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
552: ,p_prc_attribute9_o =>ben_prc_shd.g_old_rec.prc_attribute9
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
553: ,p_prc_attribute10_o =>ben_prc_shd.g_old_rec.prc_attribute10
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
554: ,p_prc_attribute11_o =>ben_prc_shd.g_old_rec.prc_attribute11
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
555: ,p_prc_attribute12_o =>ben_prc_shd.g_old_rec.prc_attribute12
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
556: ,p_prc_attribute13_o =>ben_prc_shd.g_old_rec.prc_attribute13
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
557: ,p_prc_attribute14_o =>ben_prc_shd.g_old_rec.prc_attribute14
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
558: ,p_prc_attribute15_o =>ben_prc_shd.g_old_rec.prc_attribute15
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
559: ,p_prc_attribute16_o =>ben_prc_shd.g_old_rec.prc_attribute16
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
560: ,p_prc_attribute17_o =>ben_prc_shd.g_old_rec.prc_attribute17
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
561: ,p_prc_attribute18_o =>ben_prc_shd.g_old_rec.prc_attribute18
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
562: ,p_prc_attribute19_o =>ben_prc_shd.g_old_rec.prc_attribute19
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
563: ,p_prc_attribute20_o =>ben_prc_shd.g_old_rec.prc_attribute20
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
564: ,p_prc_attribute21_o =>ben_prc_shd.g_old_rec.prc_attribute21
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
565: ,p_prc_attribute22_o =>ben_prc_shd.g_old_rec.prc_attribute22
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
566: ,p_prc_attribute23_o =>ben_prc_shd.g_old_rec.prc_attribute23
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
567: ,p_prc_attribute24_o =>ben_prc_shd.g_old_rec.prc_attribute24
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
568: ,p_prc_attribute25_o =>ben_prc_shd.g_old_rec.prc_attribute25
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
569: ,p_prc_attribute26_o =>ben_prc_shd.g_old_rec.prc_attribute26
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
570: ,p_prc_attribute27_o =>ben_prc_shd.g_old_rec.prc_attribute27
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
571: ,p_prc_attribute28_o =>ben_prc_shd.g_old_rec.prc_attribute28
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
572: ,p_prc_attribute29_o =>ben_prc_shd.g_old_rec.prc_attribute29
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
573: ,p_prc_attribute30_o =>ben_prc_shd.g_old_rec.prc_attribute30
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
574: ,p_prtt_enrt_rslt_id_o =>ben_prc_shd.g_old_rec.prtt_enrt_rslt_id
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
575: ,p_comment_id_o =>ben_prc_shd.g_old_rec.comment_id
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
576: ,p_object_version_number_o =>ben_prc_shd.g_old_rec.object_version_number
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
577: ,p_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_rsn_cd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
578: ,p_pymt_stat_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_cd
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
579: ,p_pymt_stat_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_rsn_cd
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
580: ,p_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.stat_ovrdn_flag
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
581: ,p_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.stat_ovrdn_rsn_cd
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
582: ,p_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.stat_prr_to_ovrd
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
590: ,p_exp_incurd_dt_o =>ben_prc_shd.g_old_rec.exp_incurd_dt
583: ,p_pymt_stat_ovrdn_flag_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_flag
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
590: ,p_exp_incurd_dt_o =>ben_prc_shd.g_old_rec.exp_incurd_dt
591: );
584: ,p_pymt_stat_ovrdn_rsn_cd_o =>ben_prc_shd.g_old_rec.pymt_stat_ovrdn_rsn_cd
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
590: ,p_exp_incurd_dt_o =>ben_prc_shd.g_old_rec.exp_incurd_dt
591: );
592: --
585: ,p_pymt_stat_prr_to_ovrd_o =>ben_prc_shd.g_old_rec.pymt_stat_prr_to_ovrd
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
590: ,p_exp_incurd_dt_o =>ben_prc_shd.g_old_rec.exp_incurd_dt
591: );
592: --
593: exception
586: ,p_adjmt_flag_o =>ben_prc_shd.g_old_rec.adjmt_flag
587: ,p_submtd_dt_o =>ben_prc_shd.g_old_rec.submtd_dt
588: ,p_ttl_rqst_amt_o =>ben_prc_shd.g_old_rec.ttl_rqst_amt
589: ,p_aprvd_for_pymt_amt_o =>ben_prc_shd.g_old_rec.aprvd_for_pymt_amt
590: ,p_exp_incurd_dt_o =>ben_prc_shd.g_old_rec.exp_incurd_dt
591: );
592: --
593: exception
594: --
648: -- Internal Row Handler Use Only.
649: --
650: -- {End Of Comments}
651: -- ----------------------------------------------------------------------------
652: Procedure convert_defs(p_rec in out nocopy ben_prc_shd.g_rec_type) is
653: --
654: l_proc varchar2(72) := g_package||'convert_defs';
655: --
656: Begin
663: -- is being used then we must set to the 'current' argument value.
664: --
665: If (p_rec.incrd_from_dt = hr_api.g_date) then
666: p_rec.incrd_from_dt :=
667: ben_prc_shd.g_old_rec.incrd_from_dt;
668: End If;
669: If (p_rec.incrd_to_dt = hr_api.g_date) then
670: p_rec.incrd_to_dt :=
671: ben_prc_shd.g_old_rec.incrd_to_dt;
667: ben_prc_shd.g_old_rec.incrd_from_dt;
668: End If;
669: If (p_rec.incrd_to_dt = hr_api.g_date) then
670: p_rec.incrd_to_dt :=
671: ben_prc_shd.g_old_rec.incrd_to_dt;
672: End If;
673: If (p_rec.rqst_num = hr_api.g_number) then
674: p_rec.rqst_num :=
675: ben_prc_shd.g_old_rec.rqst_num;
671: ben_prc_shd.g_old_rec.incrd_to_dt;
672: End If;
673: If (p_rec.rqst_num = hr_api.g_number) then
674: p_rec.rqst_num :=
675: ben_prc_shd.g_old_rec.rqst_num;
676: End If;
677: If (p_rec.rqst_amt = hr_api.g_number) then
678: p_rec.rqst_amt :=
679: ben_prc_shd.g_old_rec.rqst_amt;
675: ben_prc_shd.g_old_rec.rqst_num;
676: End If;
677: If (p_rec.rqst_amt = hr_api.g_number) then
678: p_rec.rqst_amt :=
679: ben_prc_shd.g_old_rec.rqst_amt;
680: End If;
681: If (p_rec.rqst_amt_uom = hr_api.g_varchar2) then
682: p_rec.rqst_amt_uom :=
683: ben_prc_shd.g_old_rec.rqst_amt_uom;
679: ben_prc_shd.g_old_rec.rqst_amt;
680: End If;
681: If (p_rec.rqst_amt_uom = hr_api.g_varchar2) then
682: p_rec.rqst_amt_uom :=
683: ben_prc_shd.g_old_rec.rqst_amt_uom;
684: End If;
685: If (p_rec.rqst_btch_num = hr_api.g_number) then
686: p_rec.rqst_btch_num :=
687: ben_prc_shd.g_old_rec.rqst_btch_num;
683: ben_prc_shd.g_old_rec.rqst_amt_uom;
684: End If;
685: If (p_rec.rqst_btch_num = hr_api.g_number) then
686: p_rec.rqst_btch_num :=
687: ben_prc_shd.g_old_rec.rqst_btch_num;
688: End If;
689: If (p_rec.prtt_reimbmt_rqst_stat_cd = hr_api.g_varchar2) then
690: p_rec.prtt_reimbmt_rqst_stat_cd :=
691: ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd;
687: ben_prc_shd.g_old_rec.rqst_btch_num;
688: End If;
689: If (p_rec.prtt_reimbmt_rqst_stat_cd = hr_api.g_varchar2) then
690: p_rec.prtt_reimbmt_rqst_stat_cd :=
691: ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd;
692: End If;
693: If (p_rec.reimbmt_ctfn_typ_prvdd_cd = hr_api.g_varchar2) then
694: p_rec.reimbmt_ctfn_typ_prvdd_cd :=
695: ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd;
691: ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd;
692: End If;
693: If (p_rec.reimbmt_ctfn_typ_prvdd_cd = hr_api.g_varchar2) then
694: p_rec.reimbmt_ctfn_typ_prvdd_cd :=
695: ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd;
696: End If;
697: If (p_rec.rcrrg_cd = hr_api.g_varchar2) then
698: p_rec.rcrrg_cd :=
699: ben_prc_shd.g_old_rec.rcrrg_cd;
695: ben_prc_shd.g_old_rec.reimbmt_ctfn_typ_prvdd_cd;
696: End If;
697: If (p_rec.rcrrg_cd = hr_api.g_varchar2) then
698: p_rec.rcrrg_cd :=
699: ben_prc_shd.g_old_rec.rcrrg_cd;
700: End If;
701: If (p_rec.submitter_person_id = hr_api.g_number) then
702: p_rec.submitter_person_id :=
703: ben_prc_shd.g_old_rec.submitter_person_id;
699: ben_prc_shd.g_old_rec.rcrrg_cd;
700: End If;
701: If (p_rec.submitter_person_id = hr_api.g_number) then
702: p_rec.submitter_person_id :=
703: ben_prc_shd.g_old_rec.submitter_person_id;
704: End If;
705: If (p_rec.recipient_person_id = hr_api.g_number) then
706: p_rec.recipient_person_id :=
707: ben_prc_shd.g_old_rec.recipient_person_id;
703: ben_prc_shd.g_old_rec.submitter_person_id;
704: End If;
705: If (p_rec.recipient_person_id = hr_api.g_number) then
706: p_rec.recipient_person_id :=
707: ben_prc_shd.g_old_rec.recipient_person_id;
708: End If;
709: If (p_rec.provider_person_id = hr_api.g_number) then
710: p_rec.provider_person_id :=
711: ben_prc_shd.g_old_rec.provider_person_id;
707: ben_prc_shd.g_old_rec.recipient_person_id;
708: End If;
709: If (p_rec.provider_person_id = hr_api.g_number) then
710: p_rec.provider_person_id :=
711: ben_prc_shd.g_old_rec.provider_person_id;
712: End If;
713: If (p_rec.provider_ssn_person_id = hr_api.g_number) then
714: p_rec.provider_ssn_person_id :=
715: ben_prc_shd.g_old_rec.provider_ssn_person_id;
711: ben_prc_shd.g_old_rec.provider_person_id;
712: End If;
713: If (p_rec.provider_ssn_person_id = hr_api.g_number) then
714: p_rec.provider_ssn_person_id :=
715: ben_prc_shd.g_old_rec.provider_ssn_person_id;
716: End If;
717: If (p_rec.pl_id = hr_api.g_number) then
718: p_rec.pl_id :=
719: ben_prc_shd.g_old_rec.pl_id;
715: ben_prc_shd.g_old_rec.provider_ssn_person_id;
716: End If;
717: If (p_rec.pl_id = hr_api.g_number) then
718: p_rec.pl_id :=
719: ben_prc_shd.g_old_rec.pl_id;
720: End If;
721: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
722: p_rec.gd_or_svc_typ_id :=
723: ben_prc_shd.g_old_rec.gd_or_svc_typ_id;
719: ben_prc_shd.g_old_rec.pl_id;
720: End If;
721: If (p_rec.gd_or_svc_typ_id = hr_api.g_number) then
722: p_rec.gd_or_svc_typ_id :=
723: ben_prc_shd.g_old_rec.gd_or_svc_typ_id;
724: End If;
725: If (p_rec.contact_relationship_id = hr_api.g_number) then
726: p_rec.contact_relationship_id :=
727: ben_prc_shd.g_old_rec.contact_relationship_id;
723: ben_prc_shd.g_old_rec.gd_or_svc_typ_id;
724: End If;
725: If (p_rec.contact_relationship_id = hr_api.g_number) then
726: p_rec.contact_relationship_id :=
727: ben_prc_shd.g_old_rec.contact_relationship_id;
728: End If;
729: If (p_rec.business_group_id = hr_api.g_number) then
730: p_rec.business_group_id :=
731: ben_prc_shd.g_old_rec.business_group_id;
727: ben_prc_shd.g_old_rec.contact_relationship_id;
728: End If;
729: If (p_rec.business_group_id = hr_api.g_number) then
730: p_rec.business_group_id :=
731: ben_prc_shd.g_old_rec.business_group_id;
732: End If;
733: If (p_rec.opt_id = hr_api.g_number) then
734: p_rec.opt_id :=
735: ben_prc_shd.g_old_rec.opt_id;
731: ben_prc_shd.g_old_rec.business_group_id;
732: End If;
733: If (p_rec.opt_id = hr_api.g_number) then
734: p_rec.opt_id :=
735: ben_prc_shd.g_old_rec.opt_id;
736: End If;
737: If (p_rec.popl_yr_perd_id_1 = hr_api.g_number) then
738: p_rec.popl_yr_perd_id_1 :=
739: ben_prc_shd.g_old_rec.popl_yr_perd_id_1;
735: ben_prc_shd.g_old_rec.opt_id;
736: End If;
737: If (p_rec.popl_yr_perd_id_1 = hr_api.g_number) then
738: p_rec.popl_yr_perd_id_1 :=
739: ben_prc_shd.g_old_rec.popl_yr_perd_id_1;
740: End If;
741: If (p_rec.popl_yr_perd_id_2 = hr_api.g_number) then
742: p_rec.popl_yr_perd_id_2 :=
743: ben_prc_shd.g_old_rec.popl_yr_perd_id_2;
739: ben_prc_shd.g_old_rec.popl_yr_perd_id_1;
740: End If;
741: If (p_rec.popl_yr_perd_id_2 = hr_api.g_number) then
742: p_rec.popl_yr_perd_id_2 :=
743: ben_prc_shd.g_old_rec.popl_yr_perd_id_2;
744: End If;
745: If (p_rec.amt_year1 = hr_api.g_number) then
746: p_rec.amt_year1 :=
747: ben_prc_shd.g_old_rec.amt_year1;
743: ben_prc_shd.g_old_rec.popl_yr_perd_id_2;
744: End If;
745: If (p_rec.amt_year1 = hr_api.g_number) then
746: p_rec.amt_year1 :=
747: ben_prc_shd.g_old_rec.amt_year1;
748: End If;
749: If (p_rec.amt_year2 = hr_api.g_number) then
750: p_rec.amt_year2 :=
751: ben_prc_shd.g_old_rec.amt_year2;
747: ben_prc_shd.g_old_rec.amt_year1;
748: End If;
749: If (p_rec.amt_year2 = hr_api.g_number) then
750: p_rec.amt_year2 :=
751: ben_prc_shd.g_old_rec.amt_year2;
752: End If;
753: If (p_rec.prc_attribute_category = hr_api.g_varchar2) then
754: p_rec.prc_attribute_category :=
755: ben_prc_shd.g_old_rec.prc_attribute_category;
751: ben_prc_shd.g_old_rec.amt_year2;
752: End If;
753: If (p_rec.prc_attribute_category = hr_api.g_varchar2) then
754: p_rec.prc_attribute_category :=
755: ben_prc_shd.g_old_rec.prc_attribute_category;
756: End If;
757: If (p_rec.prc_attribute1 = hr_api.g_varchar2) then
758: p_rec.prc_attribute1 :=
759: ben_prc_shd.g_old_rec.prc_attribute1;
755: ben_prc_shd.g_old_rec.prc_attribute_category;
756: End If;
757: If (p_rec.prc_attribute1 = hr_api.g_varchar2) then
758: p_rec.prc_attribute1 :=
759: ben_prc_shd.g_old_rec.prc_attribute1;
760: End If;
761: If (p_rec.prc_attribute2 = hr_api.g_varchar2) then
762: p_rec.prc_attribute2 :=
763: ben_prc_shd.g_old_rec.prc_attribute2;
759: ben_prc_shd.g_old_rec.prc_attribute1;
760: End If;
761: If (p_rec.prc_attribute2 = hr_api.g_varchar2) then
762: p_rec.prc_attribute2 :=
763: ben_prc_shd.g_old_rec.prc_attribute2;
764: End If;
765: If (p_rec.prc_attribute3 = hr_api.g_varchar2) then
766: p_rec.prc_attribute3 :=
767: ben_prc_shd.g_old_rec.prc_attribute3;
763: ben_prc_shd.g_old_rec.prc_attribute2;
764: End If;
765: If (p_rec.prc_attribute3 = hr_api.g_varchar2) then
766: p_rec.prc_attribute3 :=
767: ben_prc_shd.g_old_rec.prc_attribute3;
768: End If;
769: If (p_rec.prc_attribute4 = hr_api.g_varchar2) then
770: p_rec.prc_attribute4 :=
771: ben_prc_shd.g_old_rec.prc_attribute4;
767: ben_prc_shd.g_old_rec.prc_attribute3;
768: End If;
769: If (p_rec.prc_attribute4 = hr_api.g_varchar2) then
770: p_rec.prc_attribute4 :=
771: ben_prc_shd.g_old_rec.prc_attribute4;
772: End If;
773: If (p_rec.prc_attribute5 = hr_api.g_varchar2) then
774: p_rec.prc_attribute5 :=
775: ben_prc_shd.g_old_rec.prc_attribute5;
771: ben_prc_shd.g_old_rec.prc_attribute4;
772: End If;
773: If (p_rec.prc_attribute5 = hr_api.g_varchar2) then
774: p_rec.prc_attribute5 :=
775: ben_prc_shd.g_old_rec.prc_attribute5;
776: End If;
777: If (p_rec.prc_attribute6 = hr_api.g_varchar2) then
778: p_rec.prc_attribute6 :=
779: ben_prc_shd.g_old_rec.prc_attribute6;
775: ben_prc_shd.g_old_rec.prc_attribute5;
776: End If;
777: If (p_rec.prc_attribute6 = hr_api.g_varchar2) then
778: p_rec.prc_attribute6 :=
779: ben_prc_shd.g_old_rec.prc_attribute6;
780: End If;
781: If (p_rec.prc_attribute7 = hr_api.g_varchar2) then
782: p_rec.prc_attribute7 :=
783: ben_prc_shd.g_old_rec.prc_attribute7;
779: ben_prc_shd.g_old_rec.prc_attribute6;
780: End If;
781: If (p_rec.prc_attribute7 = hr_api.g_varchar2) then
782: p_rec.prc_attribute7 :=
783: ben_prc_shd.g_old_rec.prc_attribute7;
784: End If;
785: If (p_rec.prc_attribute8 = hr_api.g_varchar2) then
786: p_rec.prc_attribute8 :=
787: ben_prc_shd.g_old_rec.prc_attribute8;
783: ben_prc_shd.g_old_rec.prc_attribute7;
784: End If;
785: If (p_rec.prc_attribute8 = hr_api.g_varchar2) then
786: p_rec.prc_attribute8 :=
787: ben_prc_shd.g_old_rec.prc_attribute8;
788: End If;
789: If (p_rec.prc_attribute9 = hr_api.g_varchar2) then
790: p_rec.prc_attribute9 :=
791: ben_prc_shd.g_old_rec.prc_attribute9;
787: ben_prc_shd.g_old_rec.prc_attribute8;
788: End If;
789: If (p_rec.prc_attribute9 = hr_api.g_varchar2) then
790: p_rec.prc_attribute9 :=
791: ben_prc_shd.g_old_rec.prc_attribute9;
792: End If;
793: If (p_rec.prc_attribute10 = hr_api.g_varchar2) then
794: p_rec.prc_attribute10 :=
795: ben_prc_shd.g_old_rec.prc_attribute10;
791: ben_prc_shd.g_old_rec.prc_attribute9;
792: End If;
793: If (p_rec.prc_attribute10 = hr_api.g_varchar2) then
794: p_rec.prc_attribute10 :=
795: ben_prc_shd.g_old_rec.prc_attribute10;
796: End If;
797: If (p_rec.prc_attribute11 = hr_api.g_varchar2) then
798: p_rec.prc_attribute11 :=
799: ben_prc_shd.g_old_rec.prc_attribute11;
795: ben_prc_shd.g_old_rec.prc_attribute10;
796: End If;
797: If (p_rec.prc_attribute11 = hr_api.g_varchar2) then
798: p_rec.prc_attribute11 :=
799: ben_prc_shd.g_old_rec.prc_attribute11;
800: End If;
801: If (p_rec.prc_attribute12 = hr_api.g_varchar2) then
802: p_rec.prc_attribute12 :=
803: ben_prc_shd.g_old_rec.prc_attribute12;
799: ben_prc_shd.g_old_rec.prc_attribute11;
800: End If;
801: If (p_rec.prc_attribute12 = hr_api.g_varchar2) then
802: p_rec.prc_attribute12 :=
803: ben_prc_shd.g_old_rec.prc_attribute12;
804: End If;
805: If (p_rec.prc_attribute13 = hr_api.g_varchar2) then
806: p_rec.prc_attribute13 :=
807: ben_prc_shd.g_old_rec.prc_attribute13;
803: ben_prc_shd.g_old_rec.prc_attribute12;
804: End If;
805: If (p_rec.prc_attribute13 = hr_api.g_varchar2) then
806: p_rec.prc_attribute13 :=
807: ben_prc_shd.g_old_rec.prc_attribute13;
808: End If;
809: If (p_rec.prc_attribute14 = hr_api.g_varchar2) then
810: p_rec.prc_attribute14 :=
811: ben_prc_shd.g_old_rec.prc_attribute14;
807: ben_prc_shd.g_old_rec.prc_attribute13;
808: End If;
809: If (p_rec.prc_attribute14 = hr_api.g_varchar2) then
810: p_rec.prc_attribute14 :=
811: ben_prc_shd.g_old_rec.prc_attribute14;
812: End If;
813: If (p_rec.prc_attribute15 = hr_api.g_varchar2) then
814: p_rec.prc_attribute15 :=
815: ben_prc_shd.g_old_rec.prc_attribute15;
811: ben_prc_shd.g_old_rec.prc_attribute14;
812: End If;
813: If (p_rec.prc_attribute15 = hr_api.g_varchar2) then
814: p_rec.prc_attribute15 :=
815: ben_prc_shd.g_old_rec.prc_attribute15;
816: End If;
817: If (p_rec.prc_attribute16 = hr_api.g_varchar2) then
818: p_rec.prc_attribute16 :=
819: ben_prc_shd.g_old_rec.prc_attribute16;
815: ben_prc_shd.g_old_rec.prc_attribute15;
816: End If;
817: If (p_rec.prc_attribute16 = hr_api.g_varchar2) then
818: p_rec.prc_attribute16 :=
819: ben_prc_shd.g_old_rec.prc_attribute16;
820: End If;
821: If (p_rec.prc_attribute17 = hr_api.g_varchar2) then
822: p_rec.prc_attribute17 :=
823: ben_prc_shd.g_old_rec.prc_attribute17;
819: ben_prc_shd.g_old_rec.prc_attribute16;
820: End If;
821: If (p_rec.prc_attribute17 = hr_api.g_varchar2) then
822: p_rec.prc_attribute17 :=
823: ben_prc_shd.g_old_rec.prc_attribute17;
824: End If;
825: If (p_rec.prc_attribute18 = hr_api.g_varchar2) then
826: p_rec.prc_attribute18 :=
827: ben_prc_shd.g_old_rec.prc_attribute18;
823: ben_prc_shd.g_old_rec.prc_attribute17;
824: End If;
825: If (p_rec.prc_attribute18 = hr_api.g_varchar2) then
826: p_rec.prc_attribute18 :=
827: ben_prc_shd.g_old_rec.prc_attribute18;
828: End If;
829: If (p_rec.prc_attribute19 = hr_api.g_varchar2) then
830: p_rec.prc_attribute19 :=
831: ben_prc_shd.g_old_rec.prc_attribute19;
827: ben_prc_shd.g_old_rec.prc_attribute18;
828: End If;
829: If (p_rec.prc_attribute19 = hr_api.g_varchar2) then
830: p_rec.prc_attribute19 :=
831: ben_prc_shd.g_old_rec.prc_attribute19;
832: End If;
833: If (p_rec.prc_attribute20 = hr_api.g_varchar2) then
834: p_rec.prc_attribute20 :=
835: ben_prc_shd.g_old_rec.prc_attribute20;
831: ben_prc_shd.g_old_rec.prc_attribute19;
832: End If;
833: If (p_rec.prc_attribute20 = hr_api.g_varchar2) then
834: p_rec.prc_attribute20 :=
835: ben_prc_shd.g_old_rec.prc_attribute20;
836: End If;
837: If (p_rec.prc_attribute21 = hr_api.g_varchar2) then
838: p_rec.prc_attribute21 :=
839: ben_prc_shd.g_old_rec.prc_attribute21;
835: ben_prc_shd.g_old_rec.prc_attribute20;
836: End If;
837: If (p_rec.prc_attribute21 = hr_api.g_varchar2) then
838: p_rec.prc_attribute21 :=
839: ben_prc_shd.g_old_rec.prc_attribute21;
840: End If;
841: If (p_rec.prc_attribute22 = hr_api.g_varchar2) then
842: p_rec.prc_attribute22 :=
843: ben_prc_shd.g_old_rec.prc_attribute22;
839: ben_prc_shd.g_old_rec.prc_attribute21;
840: End If;
841: If (p_rec.prc_attribute22 = hr_api.g_varchar2) then
842: p_rec.prc_attribute22 :=
843: ben_prc_shd.g_old_rec.prc_attribute22;
844: End If;
845: If (p_rec.prc_attribute23 = hr_api.g_varchar2) then
846: p_rec.prc_attribute23 :=
847: ben_prc_shd.g_old_rec.prc_attribute23;
843: ben_prc_shd.g_old_rec.prc_attribute22;
844: End If;
845: If (p_rec.prc_attribute23 = hr_api.g_varchar2) then
846: p_rec.prc_attribute23 :=
847: ben_prc_shd.g_old_rec.prc_attribute23;
848: End If;
849: If (p_rec.prc_attribute24 = hr_api.g_varchar2) then
850: p_rec.prc_attribute24 :=
851: ben_prc_shd.g_old_rec.prc_attribute24;
847: ben_prc_shd.g_old_rec.prc_attribute23;
848: End If;
849: If (p_rec.prc_attribute24 = hr_api.g_varchar2) then
850: p_rec.prc_attribute24 :=
851: ben_prc_shd.g_old_rec.prc_attribute24;
852: End If;
853: If (p_rec.prc_attribute25 = hr_api.g_varchar2) then
854: p_rec.prc_attribute25 :=
855: ben_prc_shd.g_old_rec.prc_attribute25;
851: ben_prc_shd.g_old_rec.prc_attribute24;
852: End If;
853: If (p_rec.prc_attribute25 = hr_api.g_varchar2) then
854: p_rec.prc_attribute25 :=
855: ben_prc_shd.g_old_rec.prc_attribute25;
856: End If;
857: If (p_rec.prc_attribute26 = hr_api.g_varchar2) then
858: p_rec.prc_attribute26 :=
859: ben_prc_shd.g_old_rec.prc_attribute26;
855: ben_prc_shd.g_old_rec.prc_attribute25;
856: End If;
857: If (p_rec.prc_attribute26 = hr_api.g_varchar2) then
858: p_rec.prc_attribute26 :=
859: ben_prc_shd.g_old_rec.prc_attribute26;
860: End If;
861: If (p_rec.prc_attribute27 = hr_api.g_varchar2) then
862: p_rec.prc_attribute27 :=
863: ben_prc_shd.g_old_rec.prc_attribute27;
859: ben_prc_shd.g_old_rec.prc_attribute26;
860: End If;
861: If (p_rec.prc_attribute27 = hr_api.g_varchar2) then
862: p_rec.prc_attribute27 :=
863: ben_prc_shd.g_old_rec.prc_attribute27;
864: End If;
865: If (p_rec.prc_attribute28 = hr_api.g_varchar2) then
866: p_rec.prc_attribute28 :=
867: ben_prc_shd.g_old_rec.prc_attribute28;
863: ben_prc_shd.g_old_rec.prc_attribute27;
864: End If;
865: If (p_rec.prc_attribute28 = hr_api.g_varchar2) then
866: p_rec.prc_attribute28 :=
867: ben_prc_shd.g_old_rec.prc_attribute28;
868: End If;
869: If (p_rec.prc_attribute29 = hr_api.g_varchar2) then
870: p_rec.prc_attribute29 :=
871: ben_prc_shd.g_old_rec.prc_attribute29;
867: ben_prc_shd.g_old_rec.prc_attribute28;
868: End If;
869: If (p_rec.prc_attribute29 = hr_api.g_varchar2) then
870: p_rec.prc_attribute29 :=
871: ben_prc_shd.g_old_rec.prc_attribute29;
872: End If;
873: If (p_rec.prc_attribute30 = hr_api.g_varchar2) then
874: p_rec.prc_attribute30 :=
875: ben_prc_shd.g_old_rec.prc_attribute30;
871: ben_prc_shd.g_old_rec.prc_attribute29;
872: End If;
873: If (p_rec.prc_attribute30 = hr_api.g_varchar2) then
874: p_rec.prc_attribute30 :=
875: ben_prc_shd.g_old_rec.prc_attribute30;
876: End If;
877: If (p_rec.exp_incurd_dt = hr_api.g_date) then
878: p_rec.exp_incurd_dt :=
879: ben_prc_shd.g_old_rec.exp_incurd_dt;
875: ben_prc_shd.g_old_rec.prc_attribute30;
876: End If;
877: If (p_rec.exp_incurd_dt = hr_api.g_date) then
878: p_rec.exp_incurd_dt :=
879: ben_prc_shd.g_old_rec.exp_incurd_dt;
880: End If;
881:
882: --
883: hr_utility.set_location(' Leaving:'||l_proc, 10);
888: -- |---------------------------------< upd >----------------------------------|
889: -- ----------------------------------------------------------------------------
890: Procedure upd
891: (
892: p_rec in out nocopy ben_prc_shd.g_rec_type,
893: p_effective_date in date,
894: p_datetrack_mode in varchar2
895: ) is
896: --
906: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
907: --
908: -- We must lock the row which we need to update.
909: --
910: ben_prc_shd.lck
911: (p_effective_date => p_effective_date,
912: p_datetrack_mode => p_datetrack_mode,
913: p_prtt_reimbmt_rqst_id => p_rec.prtt_reimbmt_rqst_id,
914: p_object_version_number => p_rec.object_version_number,
1042: p_effective_date in date,
1043: p_datetrack_mode in varchar2
1044: ) is
1045: --
1046: l_rec ben_prc_shd.g_rec_type;
1047: l_proc varchar2(72) := g_package||'upd';
1048: --
1049: Begin
1050: hr_utility.set_location('Entering:'||l_proc, 5);
1052: -- Call conversion function to turn arguments into the
1053: -- l_rec structure.
1054: --
1055: l_rec :=
1056: ben_prc_shd.convert_args
1057: (
1058: p_prtt_reimbmt_rqst_id,
1059: null,
1060: null,