[Home] [Help]
52: --
53: -- {End Of Comments}
54: -- ----------------------------------------------------------------------------
55: Procedure update_dml
56: (p_rec in out nocopy ben_rts_shd.g_rec_type
57: ) is
58: --
59: l_proc varchar2(72) := g_package||'update_dml';
60: --
65: --
66: -- Increment the object version
67: p_rec.object_version_number := p_rec.object_version_number + 1;
68: --
69: ben_rts_shd.g_api_dml := true; -- Set the api dml status
70: --
71: -- Update the ben_cwb_person_rates Row
72: --
73: update ben_cwb_person_rates
123: where group_per_in_ler_id = p_rec.group_per_in_ler_id
124: and pl_id = p_rec.pl_id
125: and oipl_id = p_rec.oipl_id;
126: --
127: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
128: --
129: if g_debug then
130: hr_utility.set_location(' Leaving:'||l_proc, 10);
131: end if;
132: --
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
137: ben_rts_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
133: Exception
134: When hr_api.check_integrity_violated Then
135: -- A check constraint has been violated
136: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
137: ben_rts_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
137: ben_rts_shd.constraint_error
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
142: ben_rts_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
138: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
139: When hr_api.parent_integrity_violated Then
140: -- Parent integrity has been violated
141: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
142: ben_rts_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
142: ben_rts_shd.constraint_error
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
147: ben_rts_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
143: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
144: When hr_api.unique_integrity_violated Then
145: -- Unique integrity has been violated
146: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
147: ben_rts_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
146: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
147: ben_rts_shd.constraint_error
148: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
149: When Others Then
150: ben_rts_shd.g_api_dml := false; -- Unset the api dml status
151: Raise;
152: End update_dml;
153: --
154: -- ----------------------------------------------------------------------------
183: --
184: -- {End Of Comments}
185: -- ----------------------------------------------------------------------------
186: Procedure pre_update
187: (p_rec in ben_rts_shd.g_rec_type
188: ) is
189: --
190: l_proc varchar2(72) := g_package||'pre_update';
191: --
231: --
232: -- {End Of Comments}
233: -- ----------------------------------------------------------------------------
234: Procedure post_update
235: (p_rec in ben_rts_shd.g_rec_type
236: ) is
237: --
238: l_proc varchar2(72) := g_package||'post_update';
239: --
348: => p_rec.currency
349: ,p_object_version_number
350: => p_rec.object_version_number
351: ,p_group_per_in_ler_id_o
352: => ben_rts_shd.g_old_rec.group_per_in_ler_id
353: ,p_pl_id_o
354: => ben_rts_shd.g_old_rec.pl_id
355: ,p_oipl_id_o
356: => ben_rts_shd.g_old_rec.oipl_id
350: => p_rec.object_version_number
351: ,p_group_per_in_ler_id_o
352: => ben_rts_shd.g_old_rec.group_per_in_ler_id
353: ,p_pl_id_o
354: => ben_rts_shd.g_old_rec.pl_id
355: ,p_oipl_id_o
356: => ben_rts_shd.g_old_rec.oipl_id
357: ,p_group_pl_id_o
358: => ben_rts_shd.g_old_rec.group_pl_id
352: => ben_rts_shd.g_old_rec.group_per_in_ler_id
353: ,p_pl_id_o
354: => ben_rts_shd.g_old_rec.pl_id
355: ,p_oipl_id_o
356: => ben_rts_shd.g_old_rec.oipl_id
357: ,p_group_pl_id_o
358: => ben_rts_shd.g_old_rec.group_pl_id
359: ,p_group_oipl_id_o
360: => ben_rts_shd.g_old_rec.group_oipl_id
354: => ben_rts_shd.g_old_rec.pl_id
355: ,p_oipl_id_o
356: => ben_rts_shd.g_old_rec.oipl_id
357: ,p_group_pl_id_o
358: => ben_rts_shd.g_old_rec.group_pl_id
359: ,p_group_oipl_id_o
360: => ben_rts_shd.g_old_rec.group_oipl_id
361: ,p_lf_evt_ocrd_dt_o
362: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
356: => ben_rts_shd.g_old_rec.oipl_id
357: ,p_group_pl_id_o
358: => ben_rts_shd.g_old_rec.group_pl_id
359: ,p_group_oipl_id_o
360: => ben_rts_shd.g_old_rec.group_oipl_id
361: ,p_lf_evt_ocrd_dt_o
362: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
363: ,p_person_id_o
364: => ben_rts_shd.g_old_rec.person_id
358: => ben_rts_shd.g_old_rec.group_pl_id
359: ,p_group_oipl_id_o
360: => ben_rts_shd.g_old_rec.group_oipl_id
361: ,p_lf_evt_ocrd_dt_o
362: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
363: ,p_person_id_o
364: => ben_rts_shd.g_old_rec.person_id
365: ,p_assignment_id_o
366: => ben_rts_shd.g_old_rec.assignment_id
360: => ben_rts_shd.g_old_rec.group_oipl_id
361: ,p_lf_evt_ocrd_dt_o
362: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
363: ,p_person_id_o
364: => ben_rts_shd.g_old_rec.person_id
365: ,p_assignment_id_o
366: => ben_rts_shd.g_old_rec.assignment_id
367: ,p_elig_flag_o
368: => ben_rts_shd.g_old_rec.elig_flag
362: => ben_rts_shd.g_old_rec.lf_evt_ocrd_dt
363: ,p_person_id_o
364: => ben_rts_shd.g_old_rec.person_id
365: ,p_assignment_id_o
366: => ben_rts_shd.g_old_rec.assignment_id
367: ,p_elig_flag_o
368: => ben_rts_shd.g_old_rec.elig_flag
369: ,p_ws_val_o
370: => ben_rts_shd.g_old_rec.ws_val
364: => ben_rts_shd.g_old_rec.person_id
365: ,p_assignment_id_o
366: => ben_rts_shd.g_old_rec.assignment_id
367: ,p_elig_flag_o
368: => ben_rts_shd.g_old_rec.elig_flag
369: ,p_ws_val_o
370: => ben_rts_shd.g_old_rec.ws_val
371: ,p_ws_mn_val_o
372: => ben_rts_shd.g_old_rec.ws_mn_val
366: => ben_rts_shd.g_old_rec.assignment_id
367: ,p_elig_flag_o
368: => ben_rts_shd.g_old_rec.elig_flag
369: ,p_ws_val_o
370: => ben_rts_shd.g_old_rec.ws_val
371: ,p_ws_mn_val_o
372: => ben_rts_shd.g_old_rec.ws_mn_val
373: ,p_ws_mx_val_o
374: => ben_rts_shd.g_old_rec.ws_mx_val
368: => ben_rts_shd.g_old_rec.elig_flag
369: ,p_ws_val_o
370: => ben_rts_shd.g_old_rec.ws_val
371: ,p_ws_mn_val_o
372: => ben_rts_shd.g_old_rec.ws_mn_val
373: ,p_ws_mx_val_o
374: => ben_rts_shd.g_old_rec.ws_mx_val
375: ,p_ws_incr_val_o
376: => ben_rts_shd.g_old_rec.ws_incr_val
370: => ben_rts_shd.g_old_rec.ws_val
371: ,p_ws_mn_val_o
372: => ben_rts_shd.g_old_rec.ws_mn_val
373: ,p_ws_mx_val_o
374: => ben_rts_shd.g_old_rec.ws_mx_val
375: ,p_ws_incr_val_o
376: => ben_rts_shd.g_old_rec.ws_incr_val
377: ,p_elig_sal_val_o
378: => ben_rts_shd.g_old_rec.elig_sal_val
372: => ben_rts_shd.g_old_rec.ws_mn_val
373: ,p_ws_mx_val_o
374: => ben_rts_shd.g_old_rec.ws_mx_val
375: ,p_ws_incr_val_o
376: => ben_rts_shd.g_old_rec.ws_incr_val
377: ,p_elig_sal_val_o
378: => ben_rts_shd.g_old_rec.elig_sal_val
379: ,p_stat_sal_val_o
380: => ben_rts_shd.g_old_rec.stat_sal_val
374: => ben_rts_shd.g_old_rec.ws_mx_val
375: ,p_ws_incr_val_o
376: => ben_rts_shd.g_old_rec.ws_incr_val
377: ,p_elig_sal_val_o
378: => ben_rts_shd.g_old_rec.elig_sal_val
379: ,p_stat_sal_val_o
380: => ben_rts_shd.g_old_rec.stat_sal_val
381: ,p_oth_comp_val_o
382: => ben_rts_shd.g_old_rec.oth_comp_val
376: => ben_rts_shd.g_old_rec.ws_incr_val
377: ,p_elig_sal_val_o
378: => ben_rts_shd.g_old_rec.elig_sal_val
379: ,p_stat_sal_val_o
380: => ben_rts_shd.g_old_rec.stat_sal_val
381: ,p_oth_comp_val_o
382: => ben_rts_shd.g_old_rec.oth_comp_val
383: ,p_tot_comp_val_o
384: => ben_rts_shd.g_old_rec.tot_comp_val
378: => ben_rts_shd.g_old_rec.elig_sal_val
379: ,p_stat_sal_val_o
380: => ben_rts_shd.g_old_rec.stat_sal_val
381: ,p_oth_comp_val_o
382: => ben_rts_shd.g_old_rec.oth_comp_val
383: ,p_tot_comp_val_o
384: => ben_rts_shd.g_old_rec.tot_comp_val
385: ,p_misc1_val_o
386: => ben_rts_shd.g_old_rec.misc1_val
380: => ben_rts_shd.g_old_rec.stat_sal_val
381: ,p_oth_comp_val_o
382: => ben_rts_shd.g_old_rec.oth_comp_val
383: ,p_tot_comp_val_o
384: => ben_rts_shd.g_old_rec.tot_comp_val
385: ,p_misc1_val_o
386: => ben_rts_shd.g_old_rec.misc1_val
387: ,p_misc2_val_o
388: => ben_rts_shd.g_old_rec.misc2_val
382: => ben_rts_shd.g_old_rec.oth_comp_val
383: ,p_tot_comp_val_o
384: => ben_rts_shd.g_old_rec.tot_comp_val
385: ,p_misc1_val_o
386: => ben_rts_shd.g_old_rec.misc1_val
387: ,p_misc2_val_o
388: => ben_rts_shd.g_old_rec.misc2_val
389: ,p_misc3_val_o
390: => ben_rts_shd.g_old_rec.misc3_val
384: => ben_rts_shd.g_old_rec.tot_comp_val
385: ,p_misc1_val_o
386: => ben_rts_shd.g_old_rec.misc1_val
387: ,p_misc2_val_o
388: => ben_rts_shd.g_old_rec.misc2_val
389: ,p_misc3_val_o
390: => ben_rts_shd.g_old_rec.misc3_val
391: ,p_rec_val_o
392: => ben_rts_shd.g_old_rec.rec_val
386: => ben_rts_shd.g_old_rec.misc1_val
387: ,p_misc2_val_o
388: => ben_rts_shd.g_old_rec.misc2_val
389: ,p_misc3_val_o
390: => ben_rts_shd.g_old_rec.misc3_val
391: ,p_rec_val_o
392: => ben_rts_shd.g_old_rec.rec_val
393: ,p_rec_mn_val_o
394: => ben_rts_shd.g_old_rec.rec_mn_val
388: => ben_rts_shd.g_old_rec.misc2_val
389: ,p_misc3_val_o
390: => ben_rts_shd.g_old_rec.misc3_val
391: ,p_rec_val_o
392: => ben_rts_shd.g_old_rec.rec_val
393: ,p_rec_mn_val_o
394: => ben_rts_shd.g_old_rec.rec_mn_val
395: ,p_rec_mx_val_o
396: => ben_rts_shd.g_old_rec.rec_mx_val
390: => ben_rts_shd.g_old_rec.misc3_val
391: ,p_rec_val_o
392: => ben_rts_shd.g_old_rec.rec_val
393: ,p_rec_mn_val_o
394: => ben_rts_shd.g_old_rec.rec_mn_val
395: ,p_rec_mx_val_o
396: => ben_rts_shd.g_old_rec.rec_mx_val
397: ,p_rec_incr_val_o
398: => ben_rts_shd.g_old_rec.rec_incr_val
392: => ben_rts_shd.g_old_rec.rec_val
393: ,p_rec_mn_val_o
394: => ben_rts_shd.g_old_rec.rec_mn_val
395: ,p_rec_mx_val_o
396: => ben_rts_shd.g_old_rec.rec_mx_val
397: ,p_rec_incr_val_o
398: => ben_rts_shd.g_old_rec.rec_incr_val
399: ,p_ws_val_last_upd_date_o
400: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
394: => ben_rts_shd.g_old_rec.rec_mn_val
395: ,p_rec_mx_val_o
396: => ben_rts_shd.g_old_rec.rec_mx_val
397: ,p_rec_incr_val_o
398: => ben_rts_shd.g_old_rec.rec_incr_val
399: ,p_ws_val_last_upd_date_o
400: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
401: ,p_ws_val_last_upd_by_o
402: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
396: => ben_rts_shd.g_old_rec.rec_mx_val
397: ,p_rec_incr_val_o
398: => ben_rts_shd.g_old_rec.rec_incr_val
399: ,p_ws_val_last_upd_date_o
400: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
401: ,p_ws_val_last_upd_by_o
402: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
403: ,p_pay_proposal_id_o
404: => ben_rts_shd.g_old_rec.pay_proposal_id
398: => ben_rts_shd.g_old_rec.rec_incr_val
399: ,p_ws_val_last_upd_date_o
400: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
401: ,p_ws_val_last_upd_by_o
402: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
403: ,p_pay_proposal_id_o
404: => ben_rts_shd.g_old_rec.pay_proposal_id
405: ,p_element_entry_value_id_o
406: => ben_rts_shd.g_old_rec.element_entry_value_id
400: => ben_rts_shd.g_old_rec.ws_val_last_upd_date
401: ,p_ws_val_last_upd_by_o
402: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
403: ,p_pay_proposal_id_o
404: => ben_rts_shd.g_old_rec.pay_proposal_id
405: ,p_element_entry_value_id_o
406: => ben_rts_shd.g_old_rec.element_entry_value_id
407: ,p_inelig_rsn_cd_o
408: => ben_rts_shd.g_old_rec.inelig_rsn_cd
402: => ben_rts_shd.g_old_rec.ws_val_last_upd_by
403: ,p_pay_proposal_id_o
404: => ben_rts_shd.g_old_rec.pay_proposal_id
405: ,p_element_entry_value_id_o
406: => ben_rts_shd.g_old_rec.element_entry_value_id
407: ,p_inelig_rsn_cd_o
408: => ben_rts_shd.g_old_rec.inelig_rsn_cd
409: ,p_elig_ovrid_dt_o
410: => ben_rts_shd.g_old_rec.elig_ovrid_dt
404: => ben_rts_shd.g_old_rec.pay_proposal_id
405: ,p_element_entry_value_id_o
406: => ben_rts_shd.g_old_rec.element_entry_value_id
407: ,p_inelig_rsn_cd_o
408: => ben_rts_shd.g_old_rec.inelig_rsn_cd
409: ,p_elig_ovrid_dt_o
410: => ben_rts_shd.g_old_rec.elig_ovrid_dt
411: ,p_elig_ovrid_person_id_o
412: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
406: => ben_rts_shd.g_old_rec.element_entry_value_id
407: ,p_inelig_rsn_cd_o
408: => ben_rts_shd.g_old_rec.inelig_rsn_cd
409: ,p_elig_ovrid_dt_o
410: => ben_rts_shd.g_old_rec.elig_ovrid_dt
411: ,p_elig_ovrid_person_id_o
412: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
413: ,p_copy_dist_bdgt_val_o
414: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
408: => ben_rts_shd.g_old_rec.inelig_rsn_cd
409: ,p_elig_ovrid_dt_o
410: => ben_rts_shd.g_old_rec.elig_ovrid_dt
411: ,p_elig_ovrid_person_id_o
412: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
413: ,p_copy_dist_bdgt_val_o
414: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
415: ,p_copy_ws_bdgt_val_o
416: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
410: => ben_rts_shd.g_old_rec.elig_ovrid_dt
411: ,p_elig_ovrid_person_id_o
412: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
413: ,p_copy_dist_bdgt_val_o
414: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
415: ,p_copy_ws_bdgt_val_o
416: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
417: ,p_copy_rsrv_val_o
418: => ben_rts_shd.g_old_rec.copy_rsrv_val
412: => ben_rts_shd.g_old_rec.elig_ovrid_person_id
413: ,p_copy_dist_bdgt_val_o
414: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
415: ,p_copy_ws_bdgt_val_o
416: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
417: ,p_copy_rsrv_val_o
418: => ben_rts_shd.g_old_rec.copy_rsrv_val
419: ,p_copy_dist_bdgt_mn_val_o
420: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
414: => ben_rts_shd.g_old_rec.copy_dist_bdgt_val
415: ,p_copy_ws_bdgt_val_o
416: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
417: ,p_copy_rsrv_val_o
418: => ben_rts_shd.g_old_rec.copy_rsrv_val
419: ,p_copy_dist_bdgt_mn_val_o
420: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
421: ,p_copy_dist_bdgt_mx_val_o
422: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
416: => ben_rts_shd.g_old_rec.copy_ws_bdgt_val
417: ,p_copy_rsrv_val_o
418: => ben_rts_shd.g_old_rec.copy_rsrv_val
419: ,p_copy_dist_bdgt_mn_val_o
420: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
421: ,p_copy_dist_bdgt_mx_val_o
422: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
423: ,p_copy_dist_bdgt_incr_val_o
424: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
418: => ben_rts_shd.g_old_rec.copy_rsrv_val
419: ,p_copy_dist_bdgt_mn_val_o
420: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
421: ,p_copy_dist_bdgt_mx_val_o
422: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
423: ,p_copy_dist_bdgt_incr_val_o
424: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
425: ,p_copy_ws_bdgt_mn_val_o
426: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
420: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val
421: ,p_copy_dist_bdgt_mx_val_o
422: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
423: ,p_copy_dist_bdgt_incr_val_o
424: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
425: ,p_copy_ws_bdgt_mn_val_o
426: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
427: ,p_copy_ws_bdgt_mx_val_o
428: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
422: => ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val
423: ,p_copy_dist_bdgt_incr_val_o
424: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
425: ,p_copy_ws_bdgt_mn_val_o
426: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
427: ,p_copy_ws_bdgt_mx_val_o
428: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
429: ,p_copy_ws_bdgt_incr_val_o
430: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
424: => ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val
425: ,p_copy_ws_bdgt_mn_val_o
426: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
427: ,p_copy_ws_bdgt_mx_val_o
428: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
429: ,p_copy_ws_bdgt_incr_val_o
430: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
431: ,p_copy_rsrv_mn_val_o
432: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
426: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val
427: ,p_copy_ws_bdgt_mx_val_o
428: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
429: ,p_copy_ws_bdgt_incr_val_o
430: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
431: ,p_copy_rsrv_mn_val_o
432: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
433: ,p_copy_rsrv_mx_val_o
434: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
428: => ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val
429: ,p_copy_ws_bdgt_incr_val_o
430: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
431: ,p_copy_rsrv_mn_val_o
432: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
433: ,p_copy_rsrv_mx_val_o
434: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
435: ,p_copy_rsrv_incr_val_o
436: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
430: => ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val
431: ,p_copy_rsrv_mn_val_o
432: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
433: ,p_copy_rsrv_mx_val_o
434: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
435: ,p_copy_rsrv_incr_val_o
436: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
437: ,p_copy_dist_bdgt_iss_val_o
438: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
432: => ben_rts_shd.g_old_rec.copy_rsrv_mn_val
433: ,p_copy_rsrv_mx_val_o
434: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
435: ,p_copy_rsrv_incr_val_o
436: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
437: ,p_copy_dist_bdgt_iss_val_o
438: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
439: ,p_copy_ws_bdgt_iss_val_o
440: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
434: => ben_rts_shd.g_old_rec.copy_rsrv_mx_val
435: ,p_copy_rsrv_incr_val_o
436: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
437: ,p_copy_dist_bdgt_iss_val_o
438: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
439: ,p_copy_ws_bdgt_iss_val_o
440: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
441: ,p_copy_dist_bdgt_iss_date_o
442: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
436: => ben_rts_shd.g_old_rec.copy_rsrv_incr_val
437: ,p_copy_dist_bdgt_iss_val_o
438: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
439: ,p_copy_ws_bdgt_iss_val_o
440: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
441: ,p_copy_dist_bdgt_iss_date_o
442: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
443: ,p_copy_ws_bdgt_iss_date_o
444: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
438: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val
439: ,p_copy_ws_bdgt_iss_val_o
440: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
441: ,p_copy_dist_bdgt_iss_date_o
442: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
443: ,p_copy_ws_bdgt_iss_date_o
444: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
445: ,p_comp_posting_date_o
446: => ben_rts_shd.g_old_rec.comp_posting_date
440: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val
441: ,p_copy_dist_bdgt_iss_date_o
442: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
443: ,p_copy_ws_bdgt_iss_date_o
444: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
445: ,p_comp_posting_date_o
446: => ben_rts_shd.g_old_rec.comp_posting_date
447: ,p_ws_rt_start_date_o
448: => ben_rts_shd.g_old_rec.ws_rt_start_date
442: => ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date
443: ,p_copy_ws_bdgt_iss_date_o
444: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
445: ,p_comp_posting_date_o
446: => ben_rts_shd.g_old_rec.comp_posting_date
447: ,p_ws_rt_start_date_o
448: => ben_rts_shd.g_old_rec.ws_rt_start_date
449: ,p_currency_o
450: => ben_rts_shd.g_old_rec.currency
444: => ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date
445: ,p_comp_posting_date_o
446: => ben_rts_shd.g_old_rec.comp_posting_date
447: ,p_ws_rt_start_date_o
448: => ben_rts_shd.g_old_rec.ws_rt_start_date
449: ,p_currency_o
450: => ben_rts_shd.g_old_rec.currency
451: ,p_object_version_number_o
452: => ben_rts_shd.g_old_rec.object_version_number
446: => ben_rts_shd.g_old_rec.comp_posting_date
447: ,p_ws_rt_start_date_o
448: => ben_rts_shd.g_old_rec.ws_rt_start_date
449: ,p_currency_o
450: => ben_rts_shd.g_old_rec.currency
451: ,p_object_version_number_o
452: => ben_rts_shd.g_old_rec.object_version_number
453: );
454: --
448: => ben_rts_shd.g_old_rec.ws_rt_start_date
449: ,p_currency_o
450: => ben_rts_shd.g_old_rec.currency
451: ,p_object_version_number_o
452: => ben_rts_shd.g_old_rec.object_version_number
453: );
454: --
455: exception
456: --
510: --
511: -- {End Of Comments}
512: -- ----------------------------------------------------------------------------
513: Procedure convert_defs
514: (p_rec in out nocopy ben_rts_shd.g_rec_type
515: ) is
516: --
517: Begin
518: --
522: -- is being used then we must set to the 'current' argument value.
523: --
524: If (p_rec.group_pl_id = hr_api.g_number) then
525: p_rec.group_pl_id :=
526: ben_rts_shd.g_old_rec.group_pl_id;
527: End If;
528: If (p_rec.group_oipl_id = hr_api.g_number) then
529: p_rec.group_oipl_id :=
530: ben_rts_shd.g_old_rec.group_oipl_id;
526: ben_rts_shd.g_old_rec.group_pl_id;
527: End If;
528: If (p_rec.group_oipl_id = hr_api.g_number) then
529: p_rec.group_oipl_id :=
530: ben_rts_shd.g_old_rec.group_oipl_id;
531: End If;
532: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
533: p_rec.lf_evt_ocrd_dt :=
534: ben_rts_shd.g_old_rec.lf_evt_ocrd_dt;
530: ben_rts_shd.g_old_rec.group_oipl_id;
531: End If;
532: If (p_rec.lf_evt_ocrd_dt = hr_api.g_date) then
533: p_rec.lf_evt_ocrd_dt :=
534: ben_rts_shd.g_old_rec.lf_evt_ocrd_dt;
535: End If;
536: If (p_rec.person_id = hr_api.g_number) then
537: p_rec.person_id :=
538: ben_rts_shd.g_old_rec.person_id;
534: ben_rts_shd.g_old_rec.lf_evt_ocrd_dt;
535: End If;
536: If (p_rec.person_id = hr_api.g_number) then
537: p_rec.person_id :=
538: ben_rts_shd.g_old_rec.person_id;
539: End If;
540: If (p_rec.assignment_id = hr_api.g_number) then
541: p_rec.assignment_id :=
542: ben_rts_shd.g_old_rec.assignment_id;
538: ben_rts_shd.g_old_rec.person_id;
539: End If;
540: If (p_rec.assignment_id = hr_api.g_number) then
541: p_rec.assignment_id :=
542: ben_rts_shd.g_old_rec.assignment_id;
543: End If;
544: If (p_rec.elig_flag = hr_api.g_varchar2) then
545: p_rec.elig_flag :=
546: ben_rts_shd.g_old_rec.elig_flag;
542: ben_rts_shd.g_old_rec.assignment_id;
543: End If;
544: If (p_rec.elig_flag = hr_api.g_varchar2) then
545: p_rec.elig_flag :=
546: ben_rts_shd.g_old_rec.elig_flag;
547: End If;
548: If (p_rec.ws_val = hr_api.g_number) then
549: p_rec.ws_val :=
550: ben_rts_shd.g_old_rec.ws_val;
546: ben_rts_shd.g_old_rec.elig_flag;
547: End If;
548: If (p_rec.ws_val = hr_api.g_number) then
549: p_rec.ws_val :=
550: ben_rts_shd.g_old_rec.ws_val;
551: End If;
552: If (p_rec.ws_mn_val = hr_api.g_number) then
553: p_rec.ws_mn_val :=
554: ben_rts_shd.g_old_rec.ws_mn_val;
550: ben_rts_shd.g_old_rec.ws_val;
551: End If;
552: If (p_rec.ws_mn_val = hr_api.g_number) then
553: p_rec.ws_mn_val :=
554: ben_rts_shd.g_old_rec.ws_mn_val;
555: End If;
556: If (p_rec.ws_mx_val = hr_api.g_number) then
557: p_rec.ws_mx_val :=
558: ben_rts_shd.g_old_rec.ws_mx_val;
554: ben_rts_shd.g_old_rec.ws_mn_val;
555: End If;
556: If (p_rec.ws_mx_val = hr_api.g_number) then
557: p_rec.ws_mx_val :=
558: ben_rts_shd.g_old_rec.ws_mx_val;
559: End If;
560: If (p_rec.ws_incr_val = hr_api.g_number) then
561: p_rec.ws_incr_val :=
562: ben_rts_shd.g_old_rec.ws_incr_val;
558: ben_rts_shd.g_old_rec.ws_mx_val;
559: End If;
560: If (p_rec.ws_incr_val = hr_api.g_number) then
561: p_rec.ws_incr_val :=
562: ben_rts_shd.g_old_rec.ws_incr_val;
563: End If;
564: If (p_rec.elig_sal_val = hr_api.g_number) then
565: p_rec.elig_sal_val :=
566: ben_rts_shd.g_old_rec.elig_sal_val;
562: ben_rts_shd.g_old_rec.ws_incr_val;
563: End If;
564: If (p_rec.elig_sal_val = hr_api.g_number) then
565: p_rec.elig_sal_val :=
566: ben_rts_shd.g_old_rec.elig_sal_val;
567: End If;
568: If (p_rec.stat_sal_val = hr_api.g_number) then
569: p_rec.stat_sal_val :=
570: ben_rts_shd.g_old_rec.stat_sal_val;
566: ben_rts_shd.g_old_rec.elig_sal_val;
567: End If;
568: If (p_rec.stat_sal_val = hr_api.g_number) then
569: p_rec.stat_sal_val :=
570: ben_rts_shd.g_old_rec.stat_sal_val;
571: End If;
572: If (p_rec.oth_comp_val = hr_api.g_number) then
573: p_rec.oth_comp_val :=
574: ben_rts_shd.g_old_rec.oth_comp_val;
570: ben_rts_shd.g_old_rec.stat_sal_val;
571: End If;
572: If (p_rec.oth_comp_val = hr_api.g_number) then
573: p_rec.oth_comp_val :=
574: ben_rts_shd.g_old_rec.oth_comp_val;
575: End If;
576: If (p_rec.tot_comp_val = hr_api.g_number) then
577: p_rec.tot_comp_val :=
578: ben_rts_shd.g_old_rec.tot_comp_val;
574: ben_rts_shd.g_old_rec.oth_comp_val;
575: End If;
576: If (p_rec.tot_comp_val = hr_api.g_number) then
577: p_rec.tot_comp_val :=
578: ben_rts_shd.g_old_rec.tot_comp_val;
579: End If;
580: If (p_rec.misc1_val = hr_api.g_number) then
581: p_rec.misc1_val :=
582: ben_rts_shd.g_old_rec.misc1_val;
578: ben_rts_shd.g_old_rec.tot_comp_val;
579: End If;
580: If (p_rec.misc1_val = hr_api.g_number) then
581: p_rec.misc1_val :=
582: ben_rts_shd.g_old_rec.misc1_val;
583: End If;
584: If (p_rec.misc2_val = hr_api.g_number) then
585: p_rec.misc2_val :=
586: ben_rts_shd.g_old_rec.misc2_val;
582: ben_rts_shd.g_old_rec.misc1_val;
583: End If;
584: If (p_rec.misc2_val = hr_api.g_number) then
585: p_rec.misc2_val :=
586: ben_rts_shd.g_old_rec.misc2_val;
587: End If;
588: If (p_rec.misc3_val = hr_api.g_number) then
589: p_rec.misc3_val :=
590: ben_rts_shd.g_old_rec.misc3_val;
586: ben_rts_shd.g_old_rec.misc2_val;
587: End If;
588: If (p_rec.misc3_val = hr_api.g_number) then
589: p_rec.misc3_val :=
590: ben_rts_shd.g_old_rec.misc3_val;
591: End If;
592: If (p_rec.rec_val = hr_api.g_number) then
593: p_rec.rec_val :=
594: ben_rts_shd.g_old_rec.rec_val;
590: ben_rts_shd.g_old_rec.misc3_val;
591: End If;
592: If (p_rec.rec_val = hr_api.g_number) then
593: p_rec.rec_val :=
594: ben_rts_shd.g_old_rec.rec_val;
595: End If;
596: If (p_rec.rec_mn_val = hr_api.g_number) then
597: p_rec.rec_mn_val :=
598: ben_rts_shd.g_old_rec.rec_mn_val;
594: ben_rts_shd.g_old_rec.rec_val;
595: End If;
596: If (p_rec.rec_mn_val = hr_api.g_number) then
597: p_rec.rec_mn_val :=
598: ben_rts_shd.g_old_rec.rec_mn_val;
599: End If;
600: If (p_rec.rec_mx_val = hr_api.g_number) then
601: p_rec.rec_mx_val :=
602: ben_rts_shd.g_old_rec.rec_mx_val;
598: ben_rts_shd.g_old_rec.rec_mn_val;
599: End If;
600: If (p_rec.rec_mx_val = hr_api.g_number) then
601: p_rec.rec_mx_val :=
602: ben_rts_shd.g_old_rec.rec_mx_val;
603: End If;
604: If (p_rec.rec_incr_val = hr_api.g_number) then
605: p_rec.rec_incr_val :=
606: ben_rts_shd.g_old_rec.rec_incr_val;
602: ben_rts_shd.g_old_rec.rec_mx_val;
603: End If;
604: If (p_rec.rec_incr_val = hr_api.g_number) then
605: p_rec.rec_incr_val :=
606: ben_rts_shd.g_old_rec.rec_incr_val;
607: End If;
608: If (p_rec.ws_val_last_upd_date = hr_api.g_date) then
609: p_rec.ws_val_last_upd_date :=
610: ben_rts_shd.g_old_rec.ws_val_last_upd_date;
606: ben_rts_shd.g_old_rec.rec_incr_val;
607: End If;
608: If (p_rec.ws_val_last_upd_date = hr_api.g_date) then
609: p_rec.ws_val_last_upd_date :=
610: ben_rts_shd.g_old_rec.ws_val_last_upd_date;
611: End If;
612: If (p_rec.ws_val_last_upd_by = hr_api.g_number) then
613: p_rec.ws_val_last_upd_by :=
614: ben_rts_shd.g_old_rec.ws_val_last_upd_by;
610: ben_rts_shd.g_old_rec.ws_val_last_upd_date;
611: End If;
612: If (p_rec.ws_val_last_upd_by = hr_api.g_number) then
613: p_rec.ws_val_last_upd_by :=
614: ben_rts_shd.g_old_rec.ws_val_last_upd_by;
615: End If;
616: If (p_rec.pay_proposal_id = hr_api.g_number) then
617: p_rec.pay_proposal_id :=
618: ben_rts_shd.g_old_rec.pay_proposal_id;
614: ben_rts_shd.g_old_rec.ws_val_last_upd_by;
615: End If;
616: If (p_rec.pay_proposal_id = hr_api.g_number) then
617: p_rec.pay_proposal_id :=
618: ben_rts_shd.g_old_rec.pay_proposal_id;
619: End If;
620: If (p_rec.element_entry_value_id = hr_api.g_number) then
621: p_rec.element_entry_value_id :=
622: ben_rts_shd.g_old_rec.element_entry_value_id;
618: ben_rts_shd.g_old_rec.pay_proposal_id;
619: End If;
620: If (p_rec.element_entry_value_id = hr_api.g_number) then
621: p_rec.element_entry_value_id :=
622: ben_rts_shd.g_old_rec.element_entry_value_id;
623: End If;
624: If (p_rec.inelig_rsn_cd = hr_api.g_varchar2) then
625: p_rec.inelig_rsn_cd :=
626: ben_rts_shd.g_old_rec.inelig_rsn_cd;
622: ben_rts_shd.g_old_rec.element_entry_value_id;
623: End If;
624: If (p_rec.inelig_rsn_cd = hr_api.g_varchar2) then
625: p_rec.inelig_rsn_cd :=
626: ben_rts_shd.g_old_rec.inelig_rsn_cd;
627: End If;
628: If (p_rec.elig_ovrid_dt = hr_api.g_date) then
629: p_rec.elig_ovrid_dt :=
630: ben_rts_shd.g_old_rec.elig_ovrid_dt;
626: ben_rts_shd.g_old_rec.inelig_rsn_cd;
627: End If;
628: If (p_rec.elig_ovrid_dt = hr_api.g_date) then
629: p_rec.elig_ovrid_dt :=
630: ben_rts_shd.g_old_rec.elig_ovrid_dt;
631: End If;
632: If (p_rec.elig_ovrid_person_id = hr_api.g_number) then
633: p_rec.elig_ovrid_person_id :=
634: ben_rts_shd.g_old_rec.elig_ovrid_person_id;
630: ben_rts_shd.g_old_rec.elig_ovrid_dt;
631: End If;
632: If (p_rec.elig_ovrid_person_id = hr_api.g_number) then
633: p_rec.elig_ovrid_person_id :=
634: ben_rts_shd.g_old_rec.elig_ovrid_person_id;
635: End If;
636: If (p_rec.copy_dist_bdgt_val = hr_api.g_number) then
637: p_rec.copy_dist_bdgt_val :=
638: ben_rts_shd.g_old_rec.copy_dist_bdgt_val;
634: ben_rts_shd.g_old_rec.elig_ovrid_person_id;
635: End If;
636: If (p_rec.copy_dist_bdgt_val = hr_api.g_number) then
637: p_rec.copy_dist_bdgt_val :=
638: ben_rts_shd.g_old_rec.copy_dist_bdgt_val;
639: End If;
640: If (p_rec.copy_ws_bdgt_val = hr_api.g_number) then
641: p_rec.copy_ws_bdgt_val :=
642: ben_rts_shd.g_old_rec.copy_ws_bdgt_val;
638: ben_rts_shd.g_old_rec.copy_dist_bdgt_val;
639: End If;
640: If (p_rec.copy_ws_bdgt_val = hr_api.g_number) then
641: p_rec.copy_ws_bdgt_val :=
642: ben_rts_shd.g_old_rec.copy_ws_bdgt_val;
643: End If;
644: If (p_rec.copy_rsrv_val = hr_api.g_number) then
645: p_rec.copy_rsrv_val :=
646: ben_rts_shd.g_old_rec.copy_rsrv_val;
642: ben_rts_shd.g_old_rec.copy_ws_bdgt_val;
643: End If;
644: If (p_rec.copy_rsrv_val = hr_api.g_number) then
645: p_rec.copy_rsrv_val :=
646: ben_rts_shd.g_old_rec.copy_rsrv_val;
647: End If;
648: If (p_rec.copy_dist_bdgt_mn_val = hr_api.g_number) then
649: p_rec.copy_dist_bdgt_mn_val :=
650: ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val;
646: ben_rts_shd.g_old_rec.copy_rsrv_val;
647: End If;
648: If (p_rec.copy_dist_bdgt_mn_val = hr_api.g_number) then
649: p_rec.copy_dist_bdgt_mn_val :=
650: ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val;
651: End If;
652: If (p_rec.copy_dist_bdgt_mx_val = hr_api.g_number) then
653: p_rec.copy_dist_bdgt_mx_val :=
654: ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val;
650: ben_rts_shd.g_old_rec.copy_dist_bdgt_mn_val;
651: End If;
652: If (p_rec.copy_dist_bdgt_mx_val = hr_api.g_number) then
653: p_rec.copy_dist_bdgt_mx_val :=
654: ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val;
655: End If;
656: If (p_rec.copy_dist_bdgt_incr_val = hr_api.g_number) then
657: p_rec.copy_dist_bdgt_incr_val :=
658: ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val;
654: ben_rts_shd.g_old_rec.copy_dist_bdgt_mx_val;
655: End If;
656: If (p_rec.copy_dist_bdgt_incr_val = hr_api.g_number) then
657: p_rec.copy_dist_bdgt_incr_val :=
658: ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val;
659: End If;
660: If (p_rec.copy_ws_bdgt_mn_val = hr_api.g_number) then
661: p_rec.copy_ws_bdgt_mn_val :=
662: ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val;
658: ben_rts_shd.g_old_rec.copy_dist_bdgt_incr_val;
659: End If;
660: If (p_rec.copy_ws_bdgt_mn_val = hr_api.g_number) then
661: p_rec.copy_ws_bdgt_mn_val :=
662: ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val;
663: End If;
664: If (p_rec.copy_ws_bdgt_mx_val = hr_api.g_number) then
665: p_rec.copy_ws_bdgt_mx_val :=
666: ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val;
662: ben_rts_shd.g_old_rec.copy_ws_bdgt_mn_val;
663: End If;
664: If (p_rec.copy_ws_bdgt_mx_val = hr_api.g_number) then
665: p_rec.copy_ws_bdgt_mx_val :=
666: ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val;
667: End If;
668: If (p_rec.copy_ws_bdgt_incr_val = hr_api.g_number) then
669: p_rec.copy_ws_bdgt_incr_val :=
670: ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val;
666: ben_rts_shd.g_old_rec.copy_ws_bdgt_mx_val;
667: End If;
668: If (p_rec.copy_ws_bdgt_incr_val = hr_api.g_number) then
669: p_rec.copy_ws_bdgt_incr_val :=
670: ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val;
671: End If;
672: If (p_rec.copy_rsrv_mn_val = hr_api.g_number) then
673: p_rec.copy_rsrv_mn_val :=
674: ben_rts_shd.g_old_rec.copy_rsrv_mn_val;
670: ben_rts_shd.g_old_rec.copy_ws_bdgt_incr_val;
671: End If;
672: If (p_rec.copy_rsrv_mn_val = hr_api.g_number) then
673: p_rec.copy_rsrv_mn_val :=
674: ben_rts_shd.g_old_rec.copy_rsrv_mn_val;
675: End If;
676: If (p_rec.copy_rsrv_mx_val = hr_api.g_number) then
677: p_rec.copy_rsrv_mx_val :=
678: ben_rts_shd.g_old_rec.copy_rsrv_mx_val;
674: ben_rts_shd.g_old_rec.copy_rsrv_mn_val;
675: End If;
676: If (p_rec.copy_rsrv_mx_val = hr_api.g_number) then
677: p_rec.copy_rsrv_mx_val :=
678: ben_rts_shd.g_old_rec.copy_rsrv_mx_val;
679: End If;
680: If (p_rec.copy_rsrv_incr_val = hr_api.g_number) then
681: p_rec.copy_rsrv_incr_val :=
682: ben_rts_shd.g_old_rec.copy_rsrv_incr_val;
678: ben_rts_shd.g_old_rec.copy_rsrv_mx_val;
679: End If;
680: If (p_rec.copy_rsrv_incr_val = hr_api.g_number) then
681: p_rec.copy_rsrv_incr_val :=
682: ben_rts_shd.g_old_rec.copy_rsrv_incr_val;
683: End If;
684: If (p_rec.copy_dist_bdgt_iss_val = hr_api.g_number) then
685: p_rec.copy_dist_bdgt_iss_val :=
686: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val;
682: ben_rts_shd.g_old_rec.copy_rsrv_incr_val;
683: End If;
684: If (p_rec.copy_dist_bdgt_iss_val = hr_api.g_number) then
685: p_rec.copy_dist_bdgt_iss_val :=
686: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val;
687: End If;
688: If (p_rec.copy_ws_bdgt_iss_val = hr_api.g_number) then
689: p_rec.copy_ws_bdgt_iss_val :=
690: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val;
686: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_val;
687: End If;
688: If (p_rec.copy_ws_bdgt_iss_val = hr_api.g_number) then
689: p_rec.copy_ws_bdgt_iss_val :=
690: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val;
691: End If;
692: If (p_rec.copy_dist_bdgt_iss_date = hr_api.g_date) then
693: p_rec.copy_dist_bdgt_iss_date :=
694: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date;
690: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_val;
691: End If;
692: If (p_rec.copy_dist_bdgt_iss_date = hr_api.g_date) then
693: p_rec.copy_dist_bdgt_iss_date :=
694: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date;
695: End If;
696: If (p_rec.copy_ws_bdgt_iss_date = hr_api.g_date) then
697: p_rec.copy_ws_bdgt_iss_date :=
698: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date;
694: ben_rts_shd.g_old_rec.copy_dist_bdgt_iss_date;
695: End If;
696: If (p_rec.copy_ws_bdgt_iss_date = hr_api.g_date) then
697: p_rec.copy_ws_bdgt_iss_date :=
698: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date;
699: End If;
700: If (p_rec.comp_posting_date = hr_api.g_date) then
701: p_rec.comp_posting_date :=
702: ben_rts_shd.g_old_rec.comp_posting_date;
698: ben_rts_shd.g_old_rec.copy_ws_bdgt_iss_date;
699: End If;
700: If (p_rec.comp_posting_date = hr_api.g_date) then
701: p_rec.comp_posting_date :=
702: ben_rts_shd.g_old_rec.comp_posting_date;
703: End If;
704: If (p_rec.ws_rt_start_date = hr_api.g_date) then
705: p_rec.ws_rt_start_date :=
706: ben_rts_shd.g_old_rec.ws_rt_start_date;
702: ben_rts_shd.g_old_rec.comp_posting_date;
703: End If;
704: If (p_rec.ws_rt_start_date = hr_api.g_date) then
705: p_rec.ws_rt_start_date :=
706: ben_rts_shd.g_old_rec.ws_rt_start_date;
707: End If;
708: If (p_rec.currency = hr_api.g_varchar2) then
709: p_rec.currency :=
710: ben_rts_shd.g_old_rec.currency;
706: ben_rts_shd.g_old_rec.ws_rt_start_date;
707: End If;
708: If (p_rec.currency = hr_api.g_varchar2) then
709: p_rec.currency :=
710: ben_rts_shd.g_old_rec.currency;
711: End If;
712: --
713: End convert_defs;
714: --
715: -- ----------------------------------------------------------------------------
716: -- |---------------------------------< upd >----------------------------------|
717: -- ----------------------------------------------------------------------------
718: Procedure upd
719: (p_rec in out nocopy ben_rts_shd.g_rec_type
720: ) is
721: --
722: l_proc varchar2(72) := g_package||'upd';
723: --
727: end if;
728: --
729: -- We must lock the row which we need to update.
730: --
731: ben_rts_shd.lck
732: (p_rec.group_per_in_ler_id
733: ,p_rec.pl_id
734: ,p_rec.oipl_id
735: ,p_rec.object_version_number
823: ,p_ws_rt_start_date in date default hr_api.g_date
824: ,p_currency in varchar2 default hr_api.g_varchar2
825: ) is
826: --
827: l_rec ben_rts_shd.g_rec_type;
828: l_proc varchar2(72) := g_package||'upd';
829: --
830: Begin
831: if g_debug then
835: -- Call conversion function to turn arguments into the
836: -- l_rec structure.
837: --
838: l_rec :=
839: ben_rts_shd.convert_args
840: (null -- p_person_rate_id
841: ,p_group_per_in_ler_id
842: ,p_pl_id
843: ,p_oipl_id