[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_prv_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_prv_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_prtt_rt_val Row
68: --
69: update ben_prtt_rt_val
134: pk_id = p_rec.pk_id,
135: object_version_number = p_rec.object_version_number
136: where prtt_rt_val_id = p_rec.prtt_rt_val_id;
137: --
138: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
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));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
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));
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
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));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
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));
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
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));
158: When Others Then
159: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
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));
158: When Others Then
159: ben_prv_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
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;
162: --
163: -- ----------------------------------------------------------------------------
191: -- Internal Row Handler Use Only.
192: --
193: -- {End Of Comments}
194: -- ----------------------------------------------------------------------------
195: Procedure pre_update(p_rec in out nocopy ben_prv_shd.g_rec_type ,p_effective_date in date ) is
196: --
197: cursor c1 is
198: select enrt_rt_id, object_version_number
199: from ben_enrt_rt
261: -- Internal Row Handler Use Only.
262: --
263: -- {End Of Comments}
264: -- ----------------------------------------------------------------------------
265: Procedure post_update(p_rec in ben_prv_shd.g_rec_type,p_effective_date in date ) is
266: --
267: l_proc varchar2(72) := g_package||'post_update';
268: -- p_effective_date date := sysdate;
269: l_old_rec ben_prv_ler.g_prv_ler_rec ;
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: -- Start of API User Hook for post_update.
275: --
276: begin
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
274: -- Start of API User Hook for post_update.
275: --
276: begin
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
275: --
276: begin
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
276: begin
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
277: l_old_rec.prtt_enrt_rslt_id := ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
278: l_old_rec.business_group_id := ben_prv_shd.g_old_rec.business_group_id;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
279: l_old_rec.rt_strt_dt := ben_prv_shd.g_old_rec.rt_strt_dt;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
280: l_old_rec.rt_end_dt := ben_prv_shd.g_old_rec.rt_end_dt;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
281: l_old_rec.cmcd_rt_val := ben_prv_shd.g_old_rec.cmcd_rt_val;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
282: l_old_rec.ann_rt_val := ben_prv_shd.g_old_rec.ann_rt_val;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
283: l_old_rec.rt_val := ben_prv_shd.g_old_rec.rt_val;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
284: l_old_rec.rt_ovridn_flag := ben_prv_shd.g_old_rec.rt_ovridn_flag;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
292: l_old_rec.prtt_rt_val_id := ben_prv_shd.g_old_rec.prtt_rt_val_id;
285: l_old_rec.elctns_made_dt := ben_prv_shd.g_old_rec.elctns_made_dt;
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
292: l_old_rec.prtt_rt_val_id := ben_prv_shd.g_old_rec.prtt_rt_val_id;
293:
286: l_old_rec.rt_ovridn_thru_dt := ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
292: l_old_rec.prtt_rt_val_id := ben_prv_shd.g_old_rec.prtt_rt_val_id;
293:
294: l_new_rec.prtt_enrt_rslt_id := p_rec.prtt_enrt_rslt_id;
287: l_old_rec.tx_typ_cd := ben_prv_shd.g_old_rec.tx_typ_cd;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
292: l_old_rec.prtt_rt_val_id := ben_prv_shd.g_old_rec.prtt_rt_val_id;
293:
294: l_new_rec.prtt_enrt_rslt_id := p_rec.prtt_enrt_rslt_id;
295: l_new_rec.business_group_id := p_rec.business_group_id;
288: l_old_rec.acty_typ_cd := ben_prv_shd.g_old_rec.acty_typ_cd;
289: l_old_rec.per_in_ler_id := ben_prv_shd.g_old_rec.per_in_ler_id;
290: l_old_rec.acty_base_rt_id := ben_prv_shd.g_old_rec.acty_base_rt_id;
291: l_old_rec.prtt_rt_val_stat_cd := ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
292: l_old_rec.prtt_rt_val_id := ben_prv_shd.g_old_rec.prtt_rt_val_id;
293:
294: l_new_rec.prtt_enrt_rslt_id := p_rec.prtt_enrt_rslt_id;
295: l_new_rec.business_group_id := p_rec.business_group_id;
296: l_new_rec.rt_strt_dt := p_rec.rt_strt_dt;
375: ,p_pk_id_table_name =>p_rec.pk_id_table_name
376: ,p_pk_id =>p_rec.pk_id
377: ,p_object_version_number =>p_rec.object_version_number
378: ,p_effective_date =>p_effective_date
379: ,p_rt_strt_dt_o =>ben_prv_shd.g_old_rec.rt_strt_dt
380: ,p_rt_end_dt_o =>ben_prv_shd.g_old_rec.rt_end_dt
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
376: ,p_pk_id =>p_rec.pk_id
377: ,p_object_version_number =>p_rec.object_version_number
378: ,p_effective_date =>p_effective_date
379: ,p_rt_strt_dt_o =>ben_prv_shd.g_old_rec.rt_strt_dt
380: ,p_rt_end_dt_o =>ben_prv_shd.g_old_rec.rt_end_dt
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
377: ,p_object_version_number =>p_rec.object_version_number
378: ,p_effective_date =>p_effective_date
379: ,p_rt_strt_dt_o =>ben_prv_shd.g_old_rec.rt_strt_dt
380: ,p_rt_end_dt_o =>ben_prv_shd.g_old_rec.rt_end_dt
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
378: ,p_effective_date =>p_effective_date
379: ,p_rt_strt_dt_o =>ben_prv_shd.g_old_rec.rt_strt_dt
380: ,p_rt_end_dt_o =>ben_prv_shd.g_old_rec.rt_end_dt
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
380: ,p_rt_end_dt_o =>ben_prv_shd.g_old_rec.rt_end_dt
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
381: ,p_rt_typ_cd_o =>ben_prv_shd.g_old_rec.rt_typ_cd
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
382: ,p_tx_typ_cd_o =>ben_prv_shd.g_old_rec.tx_typ_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
383: ,p_ordr_num_o =>ben_abr_shd.g_old_rec.ordr_num
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
384: ,p_acty_typ_cd_o =>ben_prv_shd.g_old_rec.acty_typ_cd
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
385: ,p_mlt_cd_o =>ben_prv_shd.g_old_rec.mlt_cd
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
386: ,p_acty_ref_perd_cd_o =>ben_prv_shd.g_old_rec.acty_ref_perd_cd
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
387: ,p_rt_val_o =>ben_prv_shd.g_old_rec.rt_val
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
388: ,p_ann_rt_val_o =>ben_prv_shd.g_old_rec.ann_rt_val
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
389: ,p_cmcd_rt_val_o =>ben_prv_shd.g_old_rec.cmcd_rt_val
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
390: ,p_cmcd_ref_perd_cd_o =>ben_prv_shd.g_old_rec.cmcd_ref_perd_cd
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
391: ,p_bnft_rt_typ_cd_o =>ben_prv_shd.g_old_rec.bnft_rt_typ_cd
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
392: ,p_dsply_on_enrt_flag_o =>ben_prv_shd.g_old_rec.dsply_on_enrt_flag
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
393: ,p_rt_ovridn_flag_o =>ben_prv_shd.g_old_rec.rt_ovridn_flag
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
394: ,p_rt_ovridn_thru_dt_o =>ben_prv_shd.g_old_rec.rt_ovridn_thru_dt
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
395: ,p_elctns_made_dt_o =>ben_prv_shd.g_old_rec.elctns_made_dt
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
396: ,p_prtt_rt_val_stat_cd_o =>ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
397: ,p_prtt_enrt_rslt_id_o =>ben_prv_shd.g_old_rec.prtt_enrt_rslt_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
398: ,p_cvg_amt_calc_mthd_id_o =>ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
399: ,p_actl_prem_id_o =>ben_prv_shd.g_old_rec.actl_prem_id
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
400: ,p_comp_lvl_fctr_id_o =>ben_prv_shd.g_old_rec.comp_lvl_fctr_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
401: ,p_element_entry_value_id_o =>ben_prv_shd.g_old_rec.element_entry_value_id
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
402: ,p_per_in_ler_id_o =>ben_prv_shd.g_old_rec.per_in_ler_id
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
403: ,p_ended_per_in_ler_id_o =>ben_prv_shd.g_old_rec.ended_per_in_ler_id
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
404: ,p_acty_base_rt_id_o =>ben_prv_shd.g_old_rec.acty_base_rt_id
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
405: ,p_prtt_reimbmt_rqst_id_o =>ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_id
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
406: ,p_prtt_rmt_aprvd_fr_pymt_id_o =>ben_prv_shd.g_old_rec.prtt_rmt_aprvd_fr_pymt_id
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
407: ,p_pp_in_yr_used_num_o =>ben_prv_shd.g_old_rec.pp_in_yr_used_num
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
408: ,p_business_group_id_o =>ben_prv_shd.g_old_rec.business_group_id
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
409: ,p_prv_attribute_category_o =>ben_prv_shd.g_old_rec.prv_attribute_category
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
410: ,p_prv_attribute1_o =>ben_prv_shd.g_old_rec.prv_attribute1
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
411: ,p_prv_attribute2_o =>ben_prv_shd.g_old_rec.prv_attribute2
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
412: ,p_prv_attribute3_o =>ben_prv_shd.g_old_rec.prv_attribute3
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
413: ,p_prv_attribute4_o =>ben_prv_shd.g_old_rec.prv_attribute4
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
414: ,p_prv_attribute5_o =>ben_prv_shd.g_old_rec.prv_attribute5
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
415: ,p_prv_attribute6_o =>ben_prv_shd.g_old_rec.prv_attribute6
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
416: ,p_prv_attribute7_o =>ben_prv_shd.g_old_rec.prv_attribute7
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
417: ,p_prv_attribute8_o =>ben_prv_shd.g_old_rec.prv_attribute8
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
418: ,p_prv_attribute9_o =>ben_prv_shd.g_old_rec.prv_attribute9
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
419: ,p_prv_attribute10_o =>ben_prv_shd.g_old_rec.prv_attribute10
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
420: ,p_prv_attribute11_o =>ben_prv_shd.g_old_rec.prv_attribute11
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
421: ,p_prv_attribute12_o =>ben_prv_shd.g_old_rec.prv_attribute12
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
422: ,p_prv_attribute13_o =>ben_prv_shd.g_old_rec.prv_attribute13
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
423: ,p_prv_attribute14_o =>ben_prv_shd.g_old_rec.prv_attribute14
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
424: ,p_prv_attribute15_o =>ben_prv_shd.g_old_rec.prv_attribute15
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
425: ,p_prv_attribute16_o =>ben_prv_shd.g_old_rec.prv_attribute16
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
426: ,p_prv_attribute17_o =>ben_prv_shd.g_old_rec.prv_attribute17
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
427: ,p_prv_attribute18_o =>ben_prv_shd.g_old_rec.prv_attribute18
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
428: ,p_prv_attribute19_o =>ben_prv_shd.g_old_rec.prv_attribute19
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
429: ,p_prv_attribute20_o =>ben_prv_shd.g_old_rec.prv_attribute20
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
430: ,p_prv_attribute21_o =>ben_prv_shd.g_old_rec.prv_attribute21
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
431: ,p_prv_attribute22_o =>ben_prv_shd.g_old_rec.prv_attribute22
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
432: ,p_prv_attribute23_o =>ben_prv_shd.g_old_rec.prv_attribute23
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
433: ,p_prv_attribute24_o =>ben_prv_shd.g_old_rec.prv_attribute24
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
434: ,p_prv_attribute25_o =>ben_prv_shd.g_old_rec.prv_attribute25
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
435: ,p_prv_attribute26_o =>ben_prv_shd.g_old_rec.prv_attribute26
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
443: );
436: ,p_prv_attribute27_o =>ben_prv_shd.g_old_rec.prv_attribute27
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
443: );
444: hr_utility.set_location('DM Mode prv ' ||hr_general.g_data_migrator_mode ,379);
437: ,p_prv_attribute28_o =>ben_prv_shd.g_old_rec.prv_attribute28
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
443: );
444: hr_utility.set_location('DM Mode prv ' ||hr_general.g_data_migrator_mode ,379);
445: --bug 1408379 caliing ler_chk moved from trigger to here
438: ,p_prv_attribute29_o =>ben_prv_shd.g_old_rec.prv_attribute29
439: ,p_prv_attribute30_o =>ben_prv_shd.g_old_rec.prv_attribute30
440: ,p_pk_id_table_name_o =>ben_prv_shd.g_old_rec.pk_id_table_name
441: ,p_pk_id_o =>ben_prv_shd.g_old_rec.pk_id
442: ,p_object_version_number_o =>ben_prv_shd.g_old_rec.object_version_number
443: );
444: hr_utility.set_location('DM Mode prv ' ||hr_general.g_data_migrator_mode ,379);
445: --bug 1408379 caliing ler_chk moved from trigger to here
446: if hr_general.g_data_migrator_mode not in ( 'Y','P') then
506: -- Internal Row Handler Use Only.
507: --
508: -- {End Of Comments}
509: -- ----------------------------------------------------------------------------
510: Procedure convert_defs(p_rec in out nocopy ben_prv_shd.g_rec_type) is
511: --
512: l_proc varchar2(72) := g_package||'convert_defs';
513: --
514: Begin
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
528: p_rec.rt_end_dt :=
529: ben_prv_shd.g_old_rec.rt_end_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
532: p_rec.rt_typ_cd :=
533: ben_prv_shd.g_old_rec.rt_typ_cd;
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
536: p_rec.tx_typ_cd :=
537: ben_prv_shd.g_old_rec.tx_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
540: p_rec.ordr_num :=
541: ben_abr_shd.g_old_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
548: p_rec.mlt_cd :=
549: ben_prv_shd.g_old_rec.mlt_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
552: p_rec.acty_ref_perd_cd :=
553: ben_prv_shd.g_old_rec.acty_ref_perd_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
556: p_rec.rt_val :=
557: ben_prv_shd.g_old_rec.rt_val;
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
560: p_rec.ann_rt_val :=
561: ben_prv_shd.g_old_rec.ann_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
564: p_rec.cmcd_rt_val :=
565: ben_prv_shd.g_old_rec.cmcd_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
568: p_rec.cmcd_ref_perd_cd :=
569: ben_prv_shd.g_old_rec.cmcd_ref_perd_cd;
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
572: p_rec.bnft_rt_typ_cd :=
573: ben_prv_shd.g_old_rec.bnft_rt_typ_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
576: p_rec.dsply_on_enrt_flag :=
577: ben_prv_shd.g_old_rec.dsply_on_enrt_flag;
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
580: p_rec.rt_ovridn_flag :=
581: ben_prv_shd.g_old_rec.rt_ovridn_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
584: p_rec.rt_ovridn_thru_dt :=
585: ben_prv_shd.g_old_rec.rt_ovridn_thru_dt;
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
588: p_rec.elctns_made_dt :=
589: ben_prv_shd.g_old_rec.elctns_made_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
592: p_rec.prtt_rt_val_stat_cd :=
593: ben_prv_shd.g_old_rec.prtt_rt_val_stat_cd;
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
596: p_rec.prtt_enrt_rslt_id :=
597: ben_prv_shd.g_old_rec.prtt_enrt_rslt_id;
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
600: p_rec.cvg_amt_calc_mthd_id :=
601: ben_prv_shd.g_old_rec.cvg_amt_calc_mthd_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
604: p_rec.actl_prem_id :=
605: ben_prv_shd.g_old_rec.actl_prem_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
608: p_rec.comp_lvl_fctr_id :=
609: ben_prv_shd.g_old_rec.comp_lvl_fctr_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
612: p_rec.element_entry_value_id :=
613: ben_prv_shd.g_old_rec.element_entry_value_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
616: p_rec.per_in_ler_id :=
617: ben_prv_shd.g_old_rec.per_in_ler_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
620: p_rec.ended_per_in_ler_id :=
621: ben_prv_shd.g_old_rec.ended_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
624: p_rec.acty_base_rt_id :=
625: ben_prv_shd.g_old_rec.acty_base_rt_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
628: p_rec.prtt_reimbmt_rqst_id :=
629: ben_prv_shd.g_old_rec.prtt_reimbmt_rqst_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:
632: If (p_rec.prtt_rmt_aprvd_fr_pymt_id = hr_api.g_number) then
633: p_rec.prtt_rmt_aprvd_fr_pymt_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:
637: If (p_rec.pp_in_yr_used_num = hr_api.g_number) then
638: p_rec.pp_in_yr_used_num :=
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:
642:
643: If (p_rec.business_group_id = hr_api.g_number) then
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:
648: If (p_rec.prv_attribute_category = hr_api.g_varchar2) then
649: p_rec.prv_attribute_category :=
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:
653: If (p_rec.prv_attribute1 = hr_api.g_varchar2) then
654: p_rec.prv_attribute1 :=
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:
658: If (p_rec.prv_attribute2 = hr_api.g_varchar2) then
659: p_rec.prv_attribute2 :=
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
663: p_rec.prv_attribute3 :=
664: ben_prv_shd.g_old_rec.prv_attribute3;
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
667: p_rec.prv_attribute4 :=
668: ben_prv_shd.g_old_rec.prv_attribute4;
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
671: p_rec.prv_attribute5 :=
672: ben_prv_shd.g_old_rec.prv_attribute5;
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
675: p_rec.prv_attribute6 :=
676: ben_prv_shd.g_old_rec.prv_attribute6;
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
679: p_rec.prv_attribute7 :=
680: ben_prv_shd.g_old_rec.prv_attribute7;
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
683: p_rec.prv_attribute8 :=
684: ben_prv_shd.g_old_rec.prv_attribute8;
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
687: p_rec.prv_attribute9 :=
688: ben_prv_shd.g_old_rec.prv_attribute9;
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
691: p_rec.prv_attribute10 :=
692: ben_prv_shd.g_old_rec.prv_attribute10;
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
695: p_rec.prv_attribute11 :=
696: ben_prv_shd.g_old_rec.prv_attribute11;
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
699: p_rec.prv_attribute12 :=
700: ben_prv_shd.g_old_rec.prv_attribute12;
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
703: p_rec.prv_attribute13 :=
704: ben_prv_shd.g_old_rec.prv_attribute13;
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
707: p_rec.prv_attribute14 :=
708: ben_prv_shd.g_old_rec.prv_attribute14;
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
711: p_rec.prv_attribute15 :=
712: ben_prv_shd.g_old_rec.prv_attribute15;
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
715: p_rec.prv_attribute16 :=
716: ben_prv_shd.g_old_rec.prv_attribute16;
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
719: p_rec.prv_attribute17 :=
720: ben_prv_shd.g_old_rec.prv_attribute17;
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
723: p_rec.prv_attribute18 :=
724: ben_prv_shd.g_old_rec.prv_attribute18;
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
727: p_rec.prv_attribute19 :=
728: ben_prv_shd.g_old_rec.prv_attribute19;
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
731: p_rec.prv_attribute20 :=
732: ben_prv_shd.g_old_rec.prv_attribute20;
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
735: p_rec.prv_attribute21 :=
736: ben_prv_shd.g_old_rec.prv_attribute21;
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
739: p_rec.prv_attribute22 :=
740: ben_prv_shd.g_old_rec.prv_attribute22;
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
743: p_rec.prv_attribute23 :=
744: ben_prv_shd.g_old_rec.prv_attribute23;
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
747: p_rec.prv_attribute24 :=
748: ben_prv_shd.g_old_rec.prv_attribute24;
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
751: p_rec.prv_attribute25 :=
752: ben_prv_shd.g_old_rec.prv_attribute25;
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
755: p_rec.prv_attribute26 :=
756: ben_prv_shd.g_old_rec.prv_attribute26;
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
759: p_rec.prv_attribute27 :=
760: ben_prv_shd.g_old_rec.prv_attribute27;
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
763: p_rec.prv_attribute28 :=
764: ben_prv_shd.g_old_rec.prv_attribute28;
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
767: p_rec.prv_attribute29 :=
768: ben_prv_shd.g_old_rec.prv_attribute29;
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
771: p_rec.prv_attribute30 :=
772: ben_prv_shd.g_old_rec.prv_attribute30;
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
775: p_rec.pk_id_table_name :=
776: ben_prv_shd.g_old_rec.pk_id_table_name;
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
779: p_rec.pk_id :=
780: ben_prv_shd.g_old_rec.pk_id;
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:
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
788: -- ----------------------------------------------------------------------------
789: -- |---------------------------------< upd >----------------------------------|
790: -- ----------------------------------------------------------------------------
791: Procedure upd
792: ( p_rec in out nocopy ben_prv_shd.g_rec_type ,
793: p_effective_date in date ) is
794: l_proc varchar2(72) := g_package||'upd';
795: --
796: Begin
797: hr_utility.set_location('Entering:'||l_proc, 5);
798: ---
799: -- We must lock the row which we need to update.
800: --
801: ben_prv_shd.lck
802: (
803: p_rec.prtt_rt_val_id,
804: p_rec.object_version_number
805: );
900: p_object_version_number in out nocopy number ,
901: p_effective_Date in date
902: ) is
903: --
904: l_rec ben_prv_shd.g_rec_type;
905: l_proc varchar2(72) := g_package||'upd';
906: --
907: Begin
908: hr_utility.set_location('Entering:'||l_proc, 5);
910: -- Call conversion function to turn arguments into the
911: -- l_rec structure.
912: --
913: l_rec :=
914: ben_prv_shd.convert_args
915: (
916: p_prtt_rt_val_id,
917: p_enrt_rt_id,
918: p_rt_strt_dt,