54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_ddr_shd.g_rec_type,
59: p_effective_date in date,
60: p_datetrack_mode in varchar2,
61: p_validation_start_date in date,
62: p_validation_end_date in date) is
77: (p_base_table_name => 'ben_dsgn_rqmt_f',
78: p_base_key_column => 'dsgn_rqmt_id',
79: p_base_key_value => p_rec.dsgn_rqmt_id);
80: --
81: ben_ddr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_dsgn_rqmt_f Row
84: --
85: update ben_dsgn_rqmt_f
131: where dsgn_rqmt_id = p_rec.dsgn_rqmt_id
132: and effective_start_date = p_validation_start_date
133: and effective_end_date = p_validation_end_date;
134: --
135: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
136: --
137: -- Set the effective start and end dates
138: --
139: p_rec.effective_start_date := p_validation_start_date;
143: hr_utility.set_location(' Leaving:'||l_proc, 15);
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
148: ben_ddr_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
148: ben_ddr_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
148: ben_ddr_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
153: ben_ddr_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.unique_integrity_violated Then
151: -- Unique integrity has been violated
152: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
153: ben_ddr_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
152: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
153: ben_ddr_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When Others Then
156: ben_ddr_shd.g_api_dml := false; -- Unset the api dml status
157: Raise;
158: End dt_update_dml;
159: --
160: -- ----------------------------------------------------------------------------
188: --
189: -- {End Of Comments}
190: -- ----------------------------------------------------------------------------
191: Procedure update_dml
192: (p_rec in out nocopy ben_ddr_shd.g_rec_type,
193: p_effective_date in date,
194: p_datetrack_mode in varchar2,
195: p_validation_start_date in date,
196: p_validation_end_date in date) is
252: --
253: -- {End Of Comments}
254: -- ----------------------------------------------------------------------------
255: Procedure dt_pre_update
256: (p_rec in out nocopy ben_ddr_shd.g_rec_type,
257: p_effective_date in date,
258: p_datetrack_mode in varchar2,
259: p_validation_start_date in date,
260: p_validation_end_date in date) is
268: hr_utility.set_location(l_proc, 10);
269: --
270: -- Update the current effective end date
271: --
272: ben_ddr_shd.upd_effective_end_date
273: (p_effective_date => p_effective_date,
274: p_base_key_value => p_rec.dsgn_rqmt_id,
275: p_new_effective_end_date => (p_validation_start_date - 1),
276: p_validation_start_date => p_validation_start_date,
337: --
338: -- {End Of Comments}
339: -- ----------------------------------------------------------------------------
340: Procedure pre_update
341: (p_rec in out nocopy ben_ddr_shd.g_rec_type,
342: p_effective_date in date,
343: p_datetrack_mode in varchar2,
344: p_validation_start_date in date,
345: p_validation_end_date in date) is
393: --
394: -- {End Of Comments}
395: -- ----------------------------------------------------------------------------
396: Procedure post_update
397: (p_rec in ben_ddr_shd.g_rec_type,
398: p_effective_date in date,
399: p_datetrack_mode in varchar2,
400: p_validation_start_date in date,
401: p_validation_end_date in date) is
461: ,p_effective_date =>p_effective_date
462: ,p_datetrack_mode =>p_datetrack_mode
463: ,p_validation_start_date =>p_validation_start_date
464: ,p_validation_end_date =>p_validation_end_date
465: ,p_effective_start_date_o =>ben_ddr_shd.g_old_rec.effective_start_date
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
462: ,p_datetrack_mode =>p_datetrack_mode
463: ,p_validation_start_date =>p_validation_start_date
464: ,p_validation_end_date =>p_validation_end_date
465: ,p_effective_start_date_o =>ben_ddr_shd.g_old_rec.effective_start_date
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
463: ,p_validation_start_date =>p_validation_start_date
464: ,p_validation_end_date =>p_validation_end_date
465: ,p_effective_start_date_o =>ben_ddr_shd.g_old_rec.effective_start_date
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
464: ,p_validation_end_date =>p_validation_end_date
465: ,p_effective_start_date_o =>ben_ddr_shd.g_old_rec.effective_start_date
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
465: ,p_effective_start_date_o =>ben_ddr_shd.g_old_rec.effective_start_date
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
466: ,p_effective_end_date_o =>ben_ddr_shd.g_old_rec.effective_end_date
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
467: ,p_mn_dpnts_rqd_num_o =>ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
468: ,p_mx_dpnts_alwd_num_o =>ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
469: ,p_no_mn_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
470: ,p_no_mx_num_dfnd_flag_o =>ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
471: ,p_cvr_all_elig_flag_o =>ben_ddr_shd.g_old_rec.cvr_all_elig_flag
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
472: ,p_oipl_id_o =>ben_ddr_shd.g_old_rec.oipl_id
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
473: ,p_pl_id_o =>ben_ddr_shd.g_old_rec.pl_id
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
474: ,p_opt_id_o =>ben_ddr_shd.g_old_rec.opt_id
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
475: ,p_grp_rlshp_cd_o =>ben_ddr_shd.g_old_rec.grp_rlshp_cd
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
476: ,p_dsgn_typ_cd_o =>ben_ddr_shd.g_old_rec.dsgn_typ_cd
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
477: ,p_business_group_id_o =>ben_ddr_shd.g_old_rec.business_group_id
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
478: ,p_ddr_attribute_category_o =>ben_ddr_shd.g_old_rec.ddr_attribute_category
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
479: ,p_ddr_attribute1_o =>ben_ddr_shd.g_old_rec.ddr_attribute1
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
480: ,p_ddr_attribute2_o =>ben_ddr_shd.g_old_rec.ddr_attribute2
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
481: ,p_ddr_attribute3_o =>ben_ddr_shd.g_old_rec.ddr_attribute3
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
482: ,p_ddr_attribute4_o =>ben_ddr_shd.g_old_rec.ddr_attribute4
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
483: ,p_ddr_attribute5_o =>ben_ddr_shd.g_old_rec.ddr_attribute5
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
484: ,p_ddr_attribute6_o =>ben_ddr_shd.g_old_rec.ddr_attribute6
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
485: ,p_ddr_attribute7_o =>ben_ddr_shd.g_old_rec.ddr_attribute7
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
486: ,p_ddr_attribute8_o =>ben_ddr_shd.g_old_rec.ddr_attribute8
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
487: ,p_ddr_attribute9_o =>ben_ddr_shd.g_old_rec.ddr_attribute9
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
488: ,p_ddr_attribute10_o =>ben_ddr_shd.g_old_rec.ddr_attribute10
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
489: ,p_ddr_attribute11_o =>ben_ddr_shd.g_old_rec.ddr_attribute11
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
490: ,p_ddr_attribute12_o =>ben_ddr_shd.g_old_rec.ddr_attribute12
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
491: ,p_ddr_attribute13_o =>ben_ddr_shd.g_old_rec.ddr_attribute13
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
492: ,p_ddr_attribute14_o =>ben_ddr_shd.g_old_rec.ddr_attribute14
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
493: ,p_ddr_attribute15_o =>ben_ddr_shd.g_old_rec.ddr_attribute15
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
494: ,p_ddr_attribute16_o =>ben_ddr_shd.g_old_rec.ddr_attribute16
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
495: ,p_ddr_attribute17_o =>ben_ddr_shd.g_old_rec.ddr_attribute17
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
496: ,p_ddr_attribute18_o =>ben_ddr_shd.g_old_rec.ddr_attribute18
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
497: ,p_ddr_attribute19_o =>ben_ddr_shd.g_old_rec.ddr_attribute19
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
498: ,p_ddr_attribute20_o =>ben_ddr_shd.g_old_rec.ddr_attribute20
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
499: ,p_ddr_attribute21_o =>ben_ddr_shd.g_old_rec.ddr_attribute21
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
500: ,p_ddr_attribute22_o =>ben_ddr_shd.g_old_rec.ddr_attribute22
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
501: ,p_ddr_attribute23_o =>ben_ddr_shd.g_old_rec.ddr_attribute23
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
509: ,p_object_version_number_o =>ben_ddr_shd.g_old_rec.object_version_number
502: ,p_ddr_attribute24_o =>ben_ddr_shd.g_old_rec.ddr_attribute24
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
509: ,p_object_version_number_o =>ben_ddr_shd.g_old_rec.object_version_number
510: );
503: ,p_ddr_attribute25_o =>ben_ddr_shd.g_old_rec.ddr_attribute25
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
509: ,p_object_version_number_o =>ben_ddr_shd.g_old_rec.object_version_number
510: );
511: --
504: ,p_ddr_attribute26_o =>ben_ddr_shd.g_old_rec.ddr_attribute26
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
509: ,p_object_version_number_o =>ben_ddr_shd.g_old_rec.object_version_number
510: );
511: --
512: exception
505: ,p_ddr_attribute27_o =>ben_ddr_shd.g_old_rec.ddr_attribute27
506: ,p_ddr_attribute28_o =>ben_ddr_shd.g_old_rec.ddr_attribute28
507: ,p_ddr_attribute29_o =>ben_ddr_shd.g_old_rec.ddr_attribute29
508: ,p_ddr_attribute30_o =>ben_ddr_shd.g_old_rec.ddr_attribute30
509: ,p_object_version_number_o =>ben_ddr_shd.g_old_rec.object_version_number
510: );
511: --
512: exception
513: --
567: -- Internal Row Handler Use Only.
568: --
569: -- {End Of Comments}
570: -- ----------------------------------------------------------------------------
571: Procedure convert_defs(p_rec in out nocopy ben_ddr_shd.g_rec_type) is
572: --
573: l_proc varchar2(72) := g_package||'convert_defs';
574: --
575: Begin
582: -- is being used then we must set to the 'current' argument value.
583: --
584: If (p_rec.mn_dpnts_rqd_num = hr_api.g_number) then
585: p_rec.mn_dpnts_rqd_num :=
586: ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num;
587: End If;
588: If (p_rec.mx_dpnts_alwd_num = hr_api.g_number) then
589: p_rec.mx_dpnts_alwd_num :=
590: ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num;
586: ben_ddr_shd.g_old_rec.mn_dpnts_rqd_num;
587: End If;
588: If (p_rec.mx_dpnts_alwd_num = hr_api.g_number) then
589: p_rec.mx_dpnts_alwd_num :=
590: ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num;
591: End If;
592: If (p_rec.no_mn_num_dfnd_flag = hr_api.g_varchar2) then
593: p_rec.no_mn_num_dfnd_flag :=
594: ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag;
590: ben_ddr_shd.g_old_rec.mx_dpnts_alwd_num;
591: End If;
592: If (p_rec.no_mn_num_dfnd_flag = hr_api.g_varchar2) then
593: p_rec.no_mn_num_dfnd_flag :=
594: ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag;
595: End If;
596: If (p_rec.no_mx_num_dfnd_flag = hr_api.g_varchar2) then
597: p_rec.no_mx_num_dfnd_flag :=
598: ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag;
594: ben_ddr_shd.g_old_rec.no_mn_num_dfnd_flag;
595: End If;
596: If (p_rec.no_mx_num_dfnd_flag = hr_api.g_varchar2) then
597: p_rec.no_mx_num_dfnd_flag :=
598: ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag;
599: End If;
600: If (p_rec.cvr_all_elig_flag = hr_api.g_varchar2) then
601: p_rec.cvr_all_elig_flag :=
602: ben_ddr_shd.g_old_rec.cvr_all_elig_flag;
598: ben_ddr_shd.g_old_rec.no_mx_num_dfnd_flag;
599: End If;
600: If (p_rec.cvr_all_elig_flag = hr_api.g_varchar2) then
601: p_rec.cvr_all_elig_flag :=
602: ben_ddr_shd.g_old_rec.cvr_all_elig_flag;
603: End If;
604: If (p_rec.oipl_id = hr_api.g_number) then
605: p_rec.oipl_id :=
606: ben_ddr_shd.g_old_rec.oipl_id;
602: ben_ddr_shd.g_old_rec.cvr_all_elig_flag;
603: End If;
604: If (p_rec.oipl_id = hr_api.g_number) then
605: p_rec.oipl_id :=
606: ben_ddr_shd.g_old_rec.oipl_id;
607: End If;
608: If (p_rec.pl_id = hr_api.g_number) then
609: p_rec.pl_id :=
610: ben_ddr_shd.g_old_rec.pl_id;
606: ben_ddr_shd.g_old_rec.oipl_id;
607: End If;
608: If (p_rec.pl_id = hr_api.g_number) then
609: p_rec.pl_id :=
610: ben_ddr_shd.g_old_rec.pl_id;
611: End If;
612: If (p_rec.opt_id = hr_api.g_number) then
613: p_rec.opt_id :=
614: ben_ddr_shd.g_old_rec.opt_id;
610: ben_ddr_shd.g_old_rec.pl_id;
611: End If;
612: If (p_rec.opt_id = hr_api.g_number) then
613: p_rec.opt_id :=
614: ben_ddr_shd.g_old_rec.opt_id;
615: End If;
616: If (p_rec.grp_rlshp_cd = hr_api.g_varchar2) then
617: p_rec.grp_rlshp_cd :=
618: ben_ddr_shd.g_old_rec.grp_rlshp_cd;
614: ben_ddr_shd.g_old_rec.opt_id;
615: End If;
616: If (p_rec.grp_rlshp_cd = hr_api.g_varchar2) then
617: p_rec.grp_rlshp_cd :=
618: ben_ddr_shd.g_old_rec.grp_rlshp_cd;
619: End If;
620: If (p_rec.dsgn_typ_cd = hr_api.g_varchar2) then
621: p_rec.dsgn_typ_cd :=
622: ben_ddr_shd.g_old_rec.dsgn_typ_cd;
618: ben_ddr_shd.g_old_rec.grp_rlshp_cd;
619: End If;
620: If (p_rec.dsgn_typ_cd = hr_api.g_varchar2) then
621: p_rec.dsgn_typ_cd :=
622: ben_ddr_shd.g_old_rec.dsgn_typ_cd;
623: End If;
624: If (p_rec.business_group_id = hr_api.g_number) then
625: p_rec.business_group_id :=
626: ben_ddr_shd.g_old_rec.business_group_id;
622: ben_ddr_shd.g_old_rec.dsgn_typ_cd;
623: End If;
624: If (p_rec.business_group_id = hr_api.g_number) then
625: p_rec.business_group_id :=
626: ben_ddr_shd.g_old_rec.business_group_id;
627: End If;
628: If (p_rec.ddr_attribute_category = hr_api.g_varchar2) then
629: p_rec.ddr_attribute_category :=
630: ben_ddr_shd.g_old_rec.ddr_attribute_category;
626: ben_ddr_shd.g_old_rec.business_group_id;
627: End If;
628: If (p_rec.ddr_attribute_category = hr_api.g_varchar2) then
629: p_rec.ddr_attribute_category :=
630: ben_ddr_shd.g_old_rec.ddr_attribute_category;
631: End If;
632: If (p_rec.ddr_attribute1 = hr_api.g_varchar2) then
633: p_rec.ddr_attribute1 :=
634: ben_ddr_shd.g_old_rec.ddr_attribute1;
630: ben_ddr_shd.g_old_rec.ddr_attribute_category;
631: End If;
632: If (p_rec.ddr_attribute1 = hr_api.g_varchar2) then
633: p_rec.ddr_attribute1 :=
634: ben_ddr_shd.g_old_rec.ddr_attribute1;
635: End If;
636: If (p_rec.ddr_attribute2 = hr_api.g_varchar2) then
637: p_rec.ddr_attribute2 :=
638: ben_ddr_shd.g_old_rec.ddr_attribute2;
634: ben_ddr_shd.g_old_rec.ddr_attribute1;
635: End If;
636: If (p_rec.ddr_attribute2 = hr_api.g_varchar2) then
637: p_rec.ddr_attribute2 :=
638: ben_ddr_shd.g_old_rec.ddr_attribute2;
639: End If;
640: If (p_rec.ddr_attribute3 = hr_api.g_varchar2) then
641: p_rec.ddr_attribute3 :=
642: ben_ddr_shd.g_old_rec.ddr_attribute3;
638: ben_ddr_shd.g_old_rec.ddr_attribute2;
639: End If;
640: If (p_rec.ddr_attribute3 = hr_api.g_varchar2) then
641: p_rec.ddr_attribute3 :=
642: ben_ddr_shd.g_old_rec.ddr_attribute3;
643: End If;
644: If (p_rec.ddr_attribute4 = hr_api.g_varchar2) then
645: p_rec.ddr_attribute4 :=
646: ben_ddr_shd.g_old_rec.ddr_attribute4;
642: ben_ddr_shd.g_old_rec.ddr_attribute3;
643: End If;
644: If (p_rec.ddr_attribute4 = hr_api.g_varchar2) then
645: p_rec.ddr_attribute4 :=
646: ben_ddr_shd.g_old_rec.ddr_attribute4;
647: End If;
648: If (p_rec.ddr_attribute5 = hr_api.g_varchar2) then
649: p_rec.ddr_attribute5 :=
650: ben_ddr_shd.g_old_rec.ddr_attribute5;
646: ben_ddr_shd.g_old_rec.ddr_attribute4;
647: End If;
648: If (p_rec.ddr_attribute5 = hr_api.g_varchar2) then
649: p_rec.ddr_attribute5 :=
650: ben_ddr_shd.g_old_rec.ddr_attribute5;
651: End If;
652: If (p_rec.ddr_attribute6 = hr_api.g_varchar2) then
653: p_rec.ddr_attribute6 :=
654: ben_ddr_shd.g_old_rec.ddr_attribute6;
650: ben_ddr_shd.g_old_rec.ddr_attribute5;
651: End If;
652: If (p_rec.ddr_attribute6 = hr_api.g_varchar2) then
653: p_rec.ddr_attribute6 :=
654: ben_ddr_shd.g_old_rec.ddr_attribute6;
655: End If;
656: If (p_rec.ddr_attribute7 = hr_api.g_varchar2) then
657: p_rec.ddr_attribute7 :=
658: ben_ddr_shd.g_old_rec.ddr_attribute7;
654: ben_ddr_shd.g_old_rec.ddr_attribute6;
655: End If;
656: If (p_rec.ddr_attribute7 = hr_api.g_varchar2) then
657: p_rec.ddr_attribute7 :=
658: ben_ddr_shd.g_old_rec.ddr_attribute7;
659: End If;
660: If (p_rec.ddr_attribute8 = hr_api.g_varchar2) then
661: p_rec.ddr_attribute8 :=
662: ben_ddr_shd.g_old_rec.ddr_attribute8;
658: ben_ddr_shd.g_old_rec.ddr_attribute7;
659: End If;
660: If (p_rec.ddr_attribute8 = hr_api.g_varchar2) then
661: p_rec.ddr_attribute8 :=
662: ben_ddr_shd.g_old_rec.ddr_attribute8;
663: End If;
664: If (p_rec.ddr_attribute9 = hr_api.g_varchar2) then
665: p_rec.ddr_attribute9 :=
666: ben_ddr_shd.g_old_rec.ddr_attribute9;
662: ben_ddr_shd.g_old_rec.ddr_attribute8;
663: End If;
664: If (p_rec.ddr_attribute9 = hr_api.g_varchar2) then
665: p_rec.ddr_attribute9 :=
666: ben_ddr_shd.g_old_rec.ddr_attribute9;
667: End If;
668: If (p_rec.ddr_attribute10 = hr_api.g_varchar2) then
669: p_rec.ddr_attribute10 :=
670: ben_ddr_shd.g_old_rec.ddr_attribute10;
666: ben_ddr_shd.g_old_rec.ddr_attribute9;
667: End If;
668: If (p_rec.ddr_attribute10 = hr_api.g_varchar2) then
669: p_rec.ddr_attribute10 :=
670: ben_ddr_shd.g_old_rec.ddr_attribute10;
671: End If;
672: If (p_rec.ddr_attribute11 = hr_api.g_varchar2) then
673: p_rec.ddr_attribute11 :=
674: ben_ddr_shd.g_old_rec.ddr_attribute11;
670: ben_ddr_shd.g_old_rec.ddr_attribute10;
671: End If;
672: If (p_rec.ddr_attribute11 = hr_api.g_varchar2) then
673: p_rec.ddr_attribute11 :=
674: ben_ddr_shd.g_old_rec.ddr_attribute11;
675: End If;
676: If (p_rec.ddr_attribute12 = hr_api.g_varchar2) then
677: p_rec.ddr_attribute12 :=
678: ben_ddr_shd.g_old_rec.ddr_attribute12;
674: ben_ddr_shd.g_old_rec.ddr_attribute11;
675: End If;
676: If (p_rec.ddr_attribute12 = hr_api.g_varchar2) then
677: p_rec.ddr_attribute12 :=
678: ben_ddr_shd.g_old_rec.ddr_attribute12;
679: End If;
680: If (p_rec.ddr_attribute13 = hr_api.g_varchar2) then
681: p_rec.ddr_attribute13 :=
682: ben_ddr_shd.g_old_rec.ddr_attribute13;
678: ben_ddr_shd.g_old_rec.ddr_attribute12;
679: End If;
680: If (p_rec.ddr_attribute13 = hr_api.g_varchar2) then
681: p_rec.ddr_attribute13 :=
682: ben_ddr_shd.g_old_rec.ddr_attribute13;
683: End If;
684: If (p_rec.ddr_attribute14 = hr_api.g_varchar2) then
685: p_rec.ddr_attribute14 :=
686: ben_ddr_shd.g_old_rec.ddr_attribute14;
682: ben_ddr_shd.g_old_rec.ddr_attribute13;
683: End If;
684: If (p_rec.ddr_attribute14 = hr_api.g_varchar2) then
685: p_rec.ddr_attribute14 :=
686: ben_ddr_shd.g_old_rec.ddr_attribute14;
687: End If;
688: If (p_rec.ddr_attribute15 = hr_api.g_varchar2) then
689: p_rec.ddr_attribute15 :=
690: ben_ddr_shd.g_old_rec.ddr_attribute15;
686: ben_ddr_shd.g_old_rec.ddr_attribute14;
687: End If;
688: If (p_rec.ddr_attribute15 = hr_api.g_varchar2) then
689: p_rec.ddr_attribute15 :=
690: ben_ddr_shd.g_old_rec.ddr_attribute15;
691: End If;
692: If (p_rec.ddr_attribute16 = hr_api.g_varchar2) then
693: p_rec.ddr_attribute16 :=
694: ben_ddr_shd.g_old_rec.ddr_attribute16;
690: ben_ddr_shd.g_old_rec.ddr_attribute15;
691: End If;
692: If (p_rec.ddr_attribute16 = hr_api.g_varchar2) then
693: p_rec.ddr_attribute16 :=
694: ben_ddr_shd.g_old_rec.ddr_attribute16;
695: End If;
696: If (p_rec.ddr_attribute17 = hr_api.g_varchar2) then
697: p_rec.ddr_attribute17 :=
698: ben_ddr_shd.g_old_rec.ddr_attribute17;
694: ben_ddr_shd.g_old_rec.ddr_attribute16;
695: End If;
696: If (p_rec.ddr_attribute17 = hr_api.g_varchar2) then
697: p_rec.ddr_attribute17 :=
698: ben_ddr_shd.g_old_rec.ddr_attribute17;
699: End If;
700: If (p_rec.ddr_attribute18 = hr_api.g_varchar2) then
701: p_rec.ddr_attribute18 :=
702: ben_ddr_shd.g_old_rec.ddr_attribute18;
698: ben_ddr_shd.g_old_rec.ddr_attribute17;
699: End If;
700: If (p_rec.ddr_attribute18 = hr_api.g_varchar2) then
701: p_rec.ddr_attribute18 :=
702: ben_ddr_shd.g_old_rec.ddr_attribute18;
703: End If;
704: If (p_rec.ddr_attribute19 = hr_api.g_varchar2) then
705: p_rec.ddr_attribute19 :=
706: ben_ddr_shd.g_old_rec.ddr_attribute19;
702: ben_ddr_shd.g_old_rec.ddr_attribute18;
703: End If;
704: If (p_rec.ddr_attribute19 = hr_api.g_varchar2) then
705: p_rec.ddr_attribute19 :=
706: ben_ddr_shd.g_old_rec.ddr_attribute19;
707: End If;
708: If (p_rec.ddr_attribute20 = hr_api.g_varchar2) then
709: p_rec.ddr_attribute20 :=
710: ben_ddr_shd.g_old_rec.ddr_attribute20;
706: ben_ddr_shd.g_old_rec.ddr_attribute19;
707: End If;
708: If (p_rec.ddr_attribute20 = hr_api.g_varchar2) then
709: p_rec.ddr_attribute20 :=
710: ben_ddr_shd.g_old_rec.ddr_attribute20;
711: End If;
712: If (p_rec.ddr_attribute21 = hr_api.g_varchar2) then
713: p_rec.ddr_attribute21 :=
714: ben_ddr_shd.g_old_rec.ddr_attribute21;
710: ben_ddr_shd.g_old_rec.ddr_attribute20;
711: End If;
712: If (p_rec.ddr_attribute21 = hr_api.g_varchar2) then
713: p_rec.ddr_attribute21 :=
714: ben_ddr_shd.g_old_rec.ddr_attribute21;
715: End If;
716: If (p_rec.ddr_attribute22 = hr_api.g_varchar2) then
717: p_rec.ddr_attribute22 :=
718: ben_ddr_shd.g_old_rec.ddr_attribute22;
714: ben_ddr_shd.g_old_rec.ddr_attribute21;
715: End If;
716: If (p_rec.ddr_attribute22 = hr_api.g_varchar2) then
717: p_rec.ddr_attribute22 :=
718: ben_ddr_shd.g_old_rec.ddr_attribute22;
719: End If;
720: If (p_rec.ddr_attribute23 = hr_api.g_varchar2) then
721: p_rec.ddr_attribute23 :=
722: ben_ddr_shd.g_old_rec.ddr_attribute23;
718: ben_ddr_shd.g_old_rec.ddr_attribute22;
719: End If;
720: If (p_rec.ddr_attribute23 = hr_api.g_varchar2) then
721: p_rec.ddr_attribute23 :=
722: ben_ddr_shd.g_old_rec.ddr_attribute23;
723: End If;
724: If (p_rec.ddr_attribute24 = hr_api.g_varchar2) then
725: p_rec.ddr_attribute24 :=
726: ben_ddr_shd.g_old_rec.ddr_attribute24;
722: ben_ddr_shd.g_old_rec.ddr_attribute23;
723: End If;
724: If (p_rec.ddr_attribute24 = hr_api.g_varchar2) then
725: p_rec.ddr_attribute24 :=
726: ben_ddr_shd.g_old_rec.ddr_attribute24;
727: End If;
728: If (p_rec.ddr_attribute25 = hr_api.g_varchar2) then
729: p_rec.ddr_attribute25 :=
730: ben_ddr_shd.g_old_rec.ddr_attribute25;
726: ben_ddr_shd.g_old_rec.ddr_attribute24;
727: End If;
728: If (p_rec.ddr_attribute25 = hr_api.g_varchar2) then
729: p_rec.ddr_attribute25 :=
730: ben_ddr_shd.g_old_rec.ddr_attribute25;
731: End If;
732: If (p_rec.ddr_attribute26 = hr_api.g_varchar2) then
733: p_rec.ddr_attribute26 :=
734: ben_ddr_shd.g_old_rec.ddr_attribute26;
730: ben_ddr_shd.g_old_rec.ddr_attribute25;
731: End If;
732: If (p_rec.ddr_attribute26 = hr_api.g_varchar2) then
733: p_rec.ddr_attribute26 :=
734: ben_ddr_shd.g_old_rec.ddr_attribute26;
735: End If;
736: If (p_rec.ddr_attribute27 = hr_api.g_varchar2) then
737: p_rec.ddr_attribute27 :=
738: ben_ddr_shd.g_old_rec.ddr_attribute27;
734: ben_ddr_shd.g_old_rec.ddr_attribute26;
735: End If;
736: If (p_rec.ddr_attribute27 = hr_api.g_varchar2) then
737: p_rec.ddr_attribute27 :=
738: ben_ddr_shd.g_old_rec.ddr_attribute27;
739: End If;
740: If (p_rec.ddr_attribute28 = hr_api.g_varchar2) then
741: p_rec.ddr_attribute28 :=
742: ben_ddr_shd.g_old_rec.ddr_attribute28;
738: ben_ddr_shd.g_old_rec.ddr_attribute27;
739: End If;
740: If (p_rec.ddr_attribute28 = hr_api.g_varchar2) then
741: p_rec.ddr_attribute28 :=
742: ben_ddr_shd.g_old_rec.ddr_attribute28;
743: End If;
744: If (p_rec.ddr_attribute29 = hr_api.g_varchar2) then
745: p_rec.ddr_attribute29 :=
746: ben_ddr_shd.g_old_rec.ddr_attribute29;
742: ben_ddr_shd.g_old_rec.ddr_attribute28;
743: End If;
744: If (p_rec.ddr_attribute29 = hr_api.g_varchar2) then
745: p_rec.ddr_attribute29 :=
746: ben_ddr_shd.g_old_rec.ddr_attribute29;
747: End If;
748: If (p_rec.ddr_attribute30 = hr_api.g_varchar2) then
749: p_rec.ddr_attribute30 :=
750: ben_ddr_shd.g_old_rec.ddr_attribute30;
746: ben_ddr_shd.g_old_rec.ddr_attribute29;
747: End If;
748: If (p_rec.ddr_attribute30 = hr_api.g_varchar2) then
749: p_rec.ddr_attribute30 :=
750: ben_ddr_shd.g_old_rec.ddr_attribute30;
751: End If;
752:
753: --
754: hr_utility.set_location(' Leaving:'||l_proc, 10);
759: -- |---------------------------------< upd >----------------------------------|
760: -- ----------------------------------------------------------------------------
761: Procedure upd
762: (
763: p_rec in out nocopy ben_ddr_shd.g_rec_type,
764: p_effective_date in date,
765: p_datetrack_mode in varchar2
766: ) is
767: --
777: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
778: --
779: -- We must lock the row which we need to update.
780: --
781: ben_ddr_shd.lck
782: (p_effective_date => p_effective_date,
783: p_datetrack_mode => p_datetrack_mode,
784: p_dsgn_rqmt_id => p_rec.dsgn_rqmt_id,
785: p_object_version_number => p_rec.object_version_number,
882: p_effective_date in date,
883: p_datetrack_mode in varchar2
884: ) is
885: --
886: l_rec ben_ddr_shd.g_rec_type;
887: l_proc varchar2(72) := g_package||'upd';
888: --
889: Begin
890: hr_utility.set_location('Entering:'||l_proc, 5);
892: -- Call conversion function to turn arguments into the
893: -- l_rec structure.
894: --
895: l_rec :=
896: ben_ddr_shd.convert_args
897: (
898: p_dsgn_rqmt_id,
899: null,
900: null,