54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_pyd_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_ptip_dpnt_cvg_ctfn_f',
78: p_base_key_column => 'ptip_dpnt_cvg_ctfn_id',
79: p_base_key_value => p_rec.ptip_dpnt_cvg_ctfn_id);
80: --
81: ben_pyd_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_ptip_dpnt_cvg_ctfn_f Row
84: --
85: update ben_ptip_dpnt_cvg_ctfn_f
128: where ptip_dpnt_cvg_ctfn_id = p_rec.ptip_dpnt_cvg_ctfn_id
129: and effective_start_date = p_validation_start_date
130: and effective_end_date = p_validation_end_date;
131: --
132: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
133: --
134: -- Set the effective start and end dates
135: --
136: p_rec.effective_start_date := p_validation_start_date;
140: hr_utility.set_location(' Leaving:'||l_proc, 15);
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
145: ben_pyd_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
141: Exception
142: When hr_api.check_integrity_violated Then
143: -- A check constraint has been violated
144: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
145: ben_pyd_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
149: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
145: ben_pyd_shd.constraint_error
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
149: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
146: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
147: When hr_api.unique_integrity_violated Then
148: -- Unique integrity has been violated
149: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
154: Raise;
149: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
150: ben_pyd_shd.constraint_error
151: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
152: When Others Then
153: ben_pyd_shd.g_api_dml := false; -- Unset the api dml status
154: Raise;
155: End dt_update_dml;
156: --
157: -- ----------------------------------------------------------------------------
185: --
186: -- {End Of Comments}
187: -- ----------------------------------------------------------------------------
188: Procedure update_dml
189: (p_rec in out nocopy ben_pyd_shd.g_rec_type,
190: p_effective_date in date,
191: p_datetrack_mode in varchar2,
192: p_validation_start_date in date,
193: p_validation_end_date in date) is
249: --
250: -- {End Of Comments}
251: -- ----------------------------------------------------------------------------
252: Procedure dt_pre_update
253: (p_rec in out nocopy ben_pyd_shd.g_rec_type,
254: p_effective_date in date,
255: p_datetrack_mode in varchar2,
256: p_validation_start_date in date,
257: p_validation_end_date in date) is
265: hr_utility.set_location(l_proc, 10);
266: --
267: -- Update the current effective end date
268: --
269: ben_pyd_shd.upd_effective_end_date
270: (p_effective_date => p_effective_date,
271: p_base_key_value => p_rec.ptip_dpnt_cvg_ctfn_id,
272: p_new_effective_end_date => (p_validation_start_date - 1),
273: p_validation_start_date => p_validation_start_date,
334: --
335: -- {End Of Comments}
336: -- ----------------------------------------------------------------------------
337: Procedure pre_update
338: (p_rec in out nocopy ben_pyd_shd.g_rec_type,
339: p_effective_date in date,
340: p_datetrack_mode in varchar2,
341: p_validation_start_date in date,
342: p_validation_end_date in date) is
390: --
391: -- {End Of Comments}
392: -- ----------------------------------------------------------------------------
393: Procedure post_update
394: (p_rec in ben_pyd_shd.g_rec_type,
395: p_effective_date in date,
396: p_datetrack_mode in varchar2,
397: p_validation_start_date in date,
398: p_validation_end_date in date) is
455: ,p_effective_date =>p_effective_date
456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
456: ,p_datetrack_mode =>p_datetrack_mode
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
457: ,p_validation_start_date =>p_validation_start_date
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
458: ,p_validation_end_date =>p_validation_end_date
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
459: ,p_effective_start_date_o =>ben_pyd_shd.g_old_rec.effective_start_date
460: ,p_effective_end_date_o =>ben_pyd_shd.g_old_rec.effective_end_date
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
461: ,p_business_group_id_o =>ben_pyd_shd.g_old_rec.business_group_id
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
462: ,p_ptip_id_o =>ben_pyd_shd.g_old_rec.ptip_id
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
463: ,p_pfd_flag_o =>ben_pyd_shd.g_old_rec.pfd_flag
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
464: ,p_lack_ctfn_sspnd_enrt_flag_o =>
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
465: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
466: ,p_ctfn_rqd_when_rl_o =>ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
467: ,p_dpnt_cvg_ctfn_typ_cd_o =>ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
468: ,p_rlshp_typ_cd_o =>ben_pyd_shd.g_old_rec.rlshp_typ_cd
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
469: ,p_rqd_flag_o =>ben_pyd_shd.g_old_rec.rqd_flag
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
470: ,p_pyd_attribute_category_o =>ben_pyd_shd.g_old_rec.pyd_attribute_category
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
471: ,p_pyd_attribute1_o =>ben_pyd_shd.g_old_rec.pyd_attribute1
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
472: ,p_pyd_attribute2_o =>ben_pyd_shd.g_old_rec.pyd_attribute2
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
473: ,p_pyd_attribute3_o =>ben_pyd_shd.g_old_rec.pyd_attribute3
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
474: ,p_pyd_attribute4_o =>ben_pyd_shd.g_old_rec.pyd_attribute4
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
475: ,p_pyd_attribute5_o =>ben_pyd_shd.g_old_rec.pyd_attribute5
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
476: ,p_pyd_attribute6_o =>ben_pyd_shd.g_old_rec.pyd_attribute6
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
477: ,p_pyd_attribute7_o =>ben_pyd_shd.g_old_rec.pyd_attribute7
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
478: ,p_pyd_attribute8_o =>ben_pyd_shd.g_old_rec.pyd_attribute8
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
479: ,p_pyd_attribute9_o =>ben_pyd_shd.g_old_rec.pyd_attribute9
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
480: ,p_pyd_attribute10_o =>ben_pyd_shd.g_old_rec.pyd_attribute10
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
481: ,p_pyd_attribute11_o =>ben_pyd_shd.g_old_rec.pyd_attribute11
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
482: ,p_pyd_attribute12_o =>ben_pyd_shd.g_old_rec.pyd_attribute12
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
483: ,p_pyd_attribute13_o =>ben_pyd_shd.g_old_rec.pyd_attribute13
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
484: ,p_pyd_attribute14_o =>ben_pyd_shd.g_old_rec.pyd_attribute14
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
485: ,p_pyd_attribute15_o =>ben_pyd_shd.g_old_rec.pyd_attribute15
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
486: ,p_pyd_attribute16_o =>ben_pyd_shd.g_old_rec.pyd_attribute16
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
487: ,p_pyd_attribute17_o =>ben_pyd_shd.g_old_rec.pyd_attribute17
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
488: ,p_pyd_attribute18_o =>ben_pyd_shd.g_old_rec.pyd_attribute18
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
489: ,p_pyd_attribute19_o =>ben_pyd_shd.g_old_rec.pyd_attribute19
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
490: ,p_pyd_attribute20_o =>ben_pyd_shd.g_old_rec.pyd_attribute20
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
491: ,p_pyd_attribute21_o =>ben_pyd_shd.g_old_rec.pyd_attribute21
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
492: ,p_pyd_attribute22_o =>ben_pyd_shd.g_old_rec.pyd_attribute22
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
493: ,p_pyd_attribute23_o =>ben_pyd_shd.g_old_rec.pyd_attribute23
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
494: ,p_pyd_attribute24_o =>ben_pyd_shd.g_old_rec.pyd_attribute24
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
495: ,p_pyd_attribute25_o =>ben_pyd_shd.g_old_rec.pyd_attribute25
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --
496: ,p_pyd_attribute26_o =>ben_pyd_shd.g_old_rec.pyd_attribute26
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --
504: exception
497: ,p_pyd_attribute27_o =>ben_pyd_shd.g_old_rec.pyd_attribute27
498: ,p_pyd_attribute28_o =>ben_pyd_shd.g_old_rec.pyd_attribute28
499: ,p_pyd_attribute29_o =>ben_pyd_shd.g_old_rec.pyd_attribute29
500: ,p_pyd_attribute30_o =>ben_pyd_shd.g_old_rec.pyd_attribute30
501: ,p_object_version_number_o =>ben_pyd_shd.g_old_rec.object_version_number
502: );
503: --
504: exception
505: --
559: -- Internal Row Handler Use Only.
560: --
561: -- {End Of Comments}
562: -- ----------------------------------------------------------------------------
563: Procedure convert_defs(p_rec in out nocopy ben_pyd_shd.g_rec_type) is
564: --
565: l_proc varchar2(72) := g_package||'convert_defs';
566: --
567: Begin
574: -- is being used then we must set to the 'current' argument value.
575: --
576: If (p_rec.business_group_id = hr_api.g_number) then
577: p_rec.business_group_id :=
578: ben_pyd_shd.g_old_rec.business_group_id;
579: End If;
580: If (p_rec.ptip_id = hr_api.g_number) then
581: p_rec.ptip_id :=
582: ben_pyd_shd.g_old_rec.ptip_id;
578: ben_pyd_shd.g_old_rec.business_group_id;
579: End If;
580: If (p_rec.ptip_id = hr_api.g_number) then
581: p_rec.ptip_id :=
582: ben_pyd_shd.g_old_rec.ptip_id;
583: End If;
584: If (p_rec.pfd_flag = hr_api.g_varchar2) then
585: p_rec.pfd_flag :=
586: ben_pyd_shd.g_old_rec.pfd_flag;
582: ben_pyd_shd.g_old_rec.ptip_id;
583: End If;
584: If (p_rec.pfd_flag = hr_api.g_varchar2) then
585: p_rec.pfd_flag :=
586: ben_pyd_shd.g_old_rec.pfd_flag;
587: End If;
588: If (p_rec.lack_ctfn_sspnd_enrt_flag = hr_api.g_varchar2) then
589: p_rec.lack_ctfn_sspnd_enrt_flag :=
590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;
586: ben_pyd_shd.g_old_rec.pfd_flag;
587: End If;
588: If (p_rec.lack_ctfn_sspnd_enrt_flag = hr_api.g_varchar2) then
589: p_rec.lack_ctfn_sspnd_enrt_flag :=
590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;
591: End If;
592: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
593: p_rec.ctfn_rqd_when_rl :=
594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;
590: ben_pyd_shd.g_old_rec.lack_ctfn_sspnd_enrt_flag;
591: End If;
592: If (p_rec.ctfn_rqd_when_rl = hr_api.g_number) then
593: p_rec.ctfn_rqd_when_rl :=
594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;
595: End If;
596: If (p_rec.dpnt_cvg_ctfn_typ_cd = hr_api.g_varchar2) then
597: p_rec.dpnt_cvg_ctfn_typ_cd :=
598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
594: ben_pyd_shd.g_old_rec.ctfn_rqd_when_rl;
595: End If;
596: If (p_rec.dpnt_cvg_ctfn_typ_cd = hr_api.g_varchar2) then
597: p_rec.dpnt_cvg_ctfn_typ_cd :=
598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
599: End If;
600: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
601: p_rec.rlshp_typ_cd :=
602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;
598: ben_pyd_shd.g_old_rec.dpnt_cvg_ctfn_typ_cd;
599: End If;
600: If (p_rec.rlshp_typ_cd = hr_api.g_varchar2) then
601: p_rec.rlshp_typ_cd :=
602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;
603: End If;
604: If (p_rec.rqd_flag = hr_api.g_varchar2) then
605: p_rec.rqd_flag :=
606: ben_pyd_shd.g_old_rec.rqd_flag;
602: ben_pyd_shd.g_old_rec.rlshp_typ_cd;
603: End If;
604: If (p_rec.rqd_flag = hr_api.g_varchar2) then
605: p_rec.rqd_flag :=
606: ben_pyd_shd.g_old_rec.rqd_flag;
607: End If;
608: If (p_rec.pyd_attribute_category = hr_api.g_varchar2) then
609: p_rec.pyd_attribute_category :=
610: ben_pyd_shd.g_old_rec.pyd_attribute_category;
606: ben_pyd_shd.g_old_rec.rqd_flag;
607: End If;
608: If (p_rec.pyd_attribute_category = hr_api.g_varchar2) then
609: p_rec.pyd_attribute_category :=
610: ben_pyd_shd.g_old_rec.pyd_attribute_category;
611: End If;
612: If (p_rec.pyd_attribute1 = hr_api.g_varchar2) then
613: p_rec.pyd_attribute1 :=
614: ben_pyd_shd.g_old_rec.pyd_attribute1;
610: ben_pyd_shd.g_old_rec.pyd_attribute_category;
611: End If;
612: If (p_rec.pyd_attribute1 = hr_api.g_varchar2) then
613: p_rec.pyd_attribute1 :=
614: ben_pyd_shd.g_old_rec.pyd_attribute1;
615: End If;
616: If (p_rec.pyd_attribute2 = hr_api.g_varchar2) then
617: p_rec.pyd_attribute2 :=
618: ben_pyd_shd.g_old_rec.pyd_attribute2;
614: ben_pyd_shd.g_old_rec.pyd_attribute1;
615: End If;
616: If (p_rec.pyd_attribute2 = hr_api.g_varchar2) then
617: p_rec.pyd_attribute2 :=
618: ben_pyd_shd.g_old_rec.pyd_attribute2;
619: End If;
620: If (p_rec.pyd_attribute3 = hr_api.g_varchar2) then
621: p_rec.pyd_attribute3 :=
622: ben_pyd_shd.g_old_rec.pyd_attribute3;
618: ben_pyd_shd.g_old_rec.pyd_attribute2;
619: End If;
620: If (p_rec.pyd_attribute3 = hr_api.g_varchar2) then
621: p_rec.pyd_attribute3 :=
622: ben_pyd_shd.g_old_rec.pyd_attribute3;
623: End If;
624: If (p_rec.pyd_attribute4 = hr_api.g_varchar2) then
625: p_rec.pyd_attribute4 :=
626: ben_pyd_shd.g_old_rec.pyd_attribute4;
622: ben_pyd_shd.g_old_rec.pyd_attribute3;
623: End If;
624: If (p_rec.pyd_attribute4 = hr_api.g_varchar2) then
625: p_rec.pyd_attribute4 :=
626: ben_pyd_shd.g_old_rec.pyd_attribute4;
627: End If;
628: If (p_rec.pyd_attribute5 = hr_api.g_varchar2) then
629: p_rec.pyd_attribute5 :=
630: ben_pyd_shd.g_old_rec.pyd_attribute5;
626: ben_pyd_shd.g_old_rec.pyd_attribute4;
627: End If;
628: If (p_rec.pyd_attribute5 = hr_api.g_varchar2) then
629: p_rec.pyd_attribute5 :=
630: ben_pyd_shd.g_old_rec.pyd_attribute5;
631: End If;
632: If (p_rec.pyd_attribute6 = hr_api.g_varchar2) then
633: p_rec.pyd_attribute6 :=
634: ben_pyd_shd.g_old_rec.pyd_attribute6;
630: ben_pyd_shd.g_old_rec.pyd_attribute5;
631: End If;
632: If (p_rec.pyd_attribute6 = hr_api.g_varchar2) then
633: p_rec.pyd_attribute6 :=
634: ben_pyd_shd.g_old_rec.pyd_attribute6;
635: End If;
636: If (p_rec.pyd_attribute7 = hr_api.g_varchar2) then
637: p_rec.pyd_attribute7 :=
638: ben_pyd_shd.g_old_rec.pyd_attribute7;
634: ben_pyd_shd.g_old_rec.pyd_attribute6;
635: End If;
636: If (p_rec.pyd_attribute7 = hr_api.g_varchar2) then
637: p_rec.pyd_attribute7 :=
638: ben_pyd_shd.g_old_rec.pyd_attribute7;
639: End If;
640: If (p_rec.pyd_attribute8 = hr_api.g_varchar2) then
641: p_rec.pyd_attribute8 :=
642: ben_pyd_shd.g_old_rec.pyd_attribute8;
638: ben_pyd_shd.g_old_rec.pyd_attribute7;
639: End If;
640: If (p_rec.pyd_attribute8 = hr_api.g_varchar2) then
641: p_rec.pyd_attribute8 :=
642: ben_pyd_shd.g_old_rec.pyd_attribute8;
643: End If;
644: If (p_rec.pyd_attribute9 = hr_api.g_varchar2) then
645: p_rec.pyd_attribute9 :=
646: ben_pyd_shd.g_old_rec.pyd_attribute9;
642: ben_pyd_shd.g_old_rec.pyd_attribute8;
643: End If;
644: If (p_rec.pyd_attribute9 = hr_api.g_varchar2) then
645: p_rec.pyd_attribute9 :=
646: ben_pyd_shd.g_old_rec.pyd_attribute9;
647: End If;
648: If (p_rec.pyd_attribute10 = hr_api.g_varchar2) then
649: p_rec.pyd_attribute10 :=
650: ben_pyd_shd.g_old_rec.pyd_attribute10;
646: ben_pyd_shd.g_old_rec.pyd_attribute9;
647: End If;
648: If (p_rec.pyd_attribute10 = hr_api.g_varchar2) then
649: p_rec.pyd_attribute10 :=
650: ben_pyd_shd.g_old_rec.pyd_attribute10;
651: End If;
652: If (p_rec.pyd_attribute11 = hr_api.g_varchar2) then
653: p_rec.pyd_attribute11 :=
654: ben_pyd_shd.g_old_rec.pyd_attribute11;
650: ben_pyd_shd.g_old_rec.pyd_attribute10;
651: End If;
652: If (p_rec.pyd_attribute11 = hr_api.g_varchar2) then
653: p_rec.pyd_attribute11 :=
654: ben_pyd_shd.g_old_rec.pyd_attribute11;
655: End If;
656: If (p_rec.pyd_attribute12 = hr_api.g_varchar2) then
657: p_rec.pyd_attribute12 :=
658: ben_pyd_shd.g_old_rec.pyd_attribute12;
654: ben_pyd_shd.g_old_rec.pyd_attribute11;
655: End If;
656: If (p_rec.pyd_attribute12 = hr_api.g_varchar2) then
657: p_rec.pyd_attribute12 :=
658: ben_pyd_shd.g_old_rec.pyd_attribute12;
659: End If;
660: If (p_rec.pyd_attribute13 = hr_api.g_varchar2) then
661: p_rec.pyd_attribute13 :=
662: ben_pyd_shd.g_old_rec.pyd_attribute13;
658: ben_pyd_shd.g_old_rec.pyd_attribute12;
659: End If;
660: If (p_rec.pyd_attribute13 = hr_api.g_varchar2) then
661: p_rec.pyd_attribute13 :=
662: ben_pyd_shd.g_old_rec.pyd_attribute13;
663: End If;
664: If (p_rec.pyd_attribute14 = hr_api.g_varchar2) then
665: p_rec.pyd_attribute14 :=
666: ben_pyd_shd.g_old_rec.pyd_attribute14;
662: ben_pyd_shd.g_old_rec.pyd_attribute13;
663: End If;
664: If (p_rec.pyd_attribute14 = hr_api.g_varchar2) then
665: p_rec.pyd_attribute14 :=
666: ben_pyd_shd.g_old_rec.pyd_attribute14;
667: End If;
668: If (p_rec.pyd_attribute15 = hr_api.g_varchar2) then
669: p_rec.pyd_attribute15 :=
670: ben_pyd_shd.g_old_rec.pyd_attribute15;
666: ben_pyd_shd.g_old_rec.pyd_attribute14;
667: End If;
668: If (p_rec.pyd_attribute15 = hr_api.g_varchar2) then
669: p_rec.pyd_attribute15 :=
670: ben_pyd_shd.g_old_rec.pyd_attribute15;
671: End If;
672: If (p_rec.pyd_attribute16 = hr_api.g_varchar2) then
673: p_rec.pyd_attribute16 :=
674: ben_pyd_shd.g_old_rec.pyd_attribute16;
670: ben_pyd_shd.g_old_rec.pyd_attribute15;
671: End If;
672: If (p_rec.pyd_attribute16 = hr_api.g_varchar2) then
673: p_rec.pyd_attribute16 :=
674: ben_pyd_shd.g_old_rec.pyd_attribute16;
675: End If;
676: If (p_rec.pyd_attribute17 = hr_api.g_varchar2) then
677: p_rec.pyd_attribute17 :=
678: ben_pyd_shd.g_old_rec.pyd_attribute17;
674: ben_pyd_shd.g_old_rec.pyd_attribute16;
675: End If;
676: If (p_rec.pyd_attribute17 = hr_api.g_varchar2) then
677: p_rec.pyd_attribute17 :=
678: ben_pyd_shd.g_old_rec.pyd_attribute17;
679: End If;
680: If (p_rec.pyd_attribute18 = hr_api.g_varchar2) then
681: p_rec.pyd_attribute18 :=
682: ben_pyd_shd.g_old_rec.pyd_attribute18;
678: ben_pyd_shd.g_old_rec.pyd_attribute17;
679: End If;
680: If (p_rec.pyd_attribute18 = hr_api.g_varchar2) then
681: p_rec.pyd_attribute18 :=
682: ben_pyd_shd.g_old_rec.pyd_attribute18;
683: End If;
684: If (p_rec.pyd_attribute19 = hr_api.g_varchar2) then
685: p_rec.pyd_attribute19 :=
686: ben_pyd_shd.g_old_rec.pyd_attribute19;
682: ben_pyd_shd.g_old_rec.pyd_attribute18;
683: End If;
684: If (p_rec.pyd_attribute19 = hr_api.g_varchar2) then
685: p_rec.pyd_attribute19 :=
686: ben_pyd_shd.g_old_rec.pyd_attribute19;
687: End If;
688: If (p_rec.pyd_attribute20 = hr_api.g_varchar2) then
689: p_rec.pyd_attribute20 :=
690: ben_pyd_shd.g_old_rec.pyd_attribute20;
686: ben_pyd_shd.g_old_rec.pyd_attribute19;
687: End If;
688: If (p_rec.pyd_attribute20 = hr_api.g_varchar2) then
689: p_rec.pyd_attribute20 :=
690: ben_pyd_shd.g_old_rec.pyd_attribute20;
691: End If;
692: If (p_rec.pyd_attribute21 = hr_api.g_varchar2) then
693: p_rec.pyd_attribute21 :=
694: ben_pyd_shd.g_old_rec.pyd_attribute21;
690: ben_pyd_shd.g_old_rec.pyd_attribute20;
691: End If;
692: If (p_rec.pyd_attribute21 = hr_api.g_varchar2) then
693: p_rec.pyd_attribute21 :=
694: ben_pyd_shd.g_old_rec.pyd_attribute21;
695: End If;
696: If (p_rec.pyd_attribute22 = hr_api.g_varchar2) then
697: p_rec.pyd_attribute22 :=
698: ben_pyd_shd.g_old_rec.pyd_attribute22;
694: ben_pyd_shd.g_old_rec.pyd_attribute21;
695: End If;
696: If (p_rec.pyd_attribute22 = hr_api.g_varchar2) then
697: p_rec.pyd_attribute22 :=
698: ben_pyd_shd.g_old_rec.pyd_attribute22;
699: End If;
700: If (p_rec.pyd_attribute23 = hr_api.g_varchar2) then
701: p_rec.pyd_attribute23 :=
702: ben_pyd_shd.g_old_rec.pyd_attribute23;
698: ben_pyd_shd.g_old_rec.pyd_attribute22;
699: End If;
700: If (p_rec.pyd_attribute23 = hr_api.g_varchar2) then
701: p_rec.pyd_attribute23 :=
702: ben_pyd_shd.g_old_rec.pyd_attribute23;
703: End If;
704: If (p_rec.pyd_attribute24 = hr_api.g_varchar2) then
705: p_rec.pyd_attribute24 :=
706: ben_pyd_shd.g_old_rec.pyd_attribute24;
702: ben_pyd_shd.g_old_rec.pyd_attribute23;
703: End If;
704: If (p_rec.pyd_attribute24 = hr_api.g_varchar2) then
705: p_rec.pyd_attribute24 :=
706: ben_pyd_shd.g_old_rec.pyd_attribute24;
707: End If;
708: If (p_rec.pyd_attribute25 = hr_api.g_varchar2) then
709: p_rec.pyd_attribute25 :=
710: ben_pyd_shd.g_old_rec.pyd_attribute25;
706: ben_pyd_shd.g_old_rec.pyd_attribute24;
707: End If;
708: If (p_rec.pyd_attribute25 = hr_api.g_varchar2) then
709: p_rec.pyd_attribute25 :=
710: ben_pyd_shd.g_old_rec.pyd_attribute25;
711: End If;
712: If (p_rec.pyd_attribute26 = hr_api.g_varchar2) then
713: p_rec.pyd_attribute26 :=
714: ben_pyd_shd.g_old_rec.pyd_attribute26;
710: ben_pyd_shd.g_old_rec.pyd_attribute25;
711: End If;
712: If (p_rec.pyd_attribute26 = hr_api.g_varchar2) then
713: p_rec.pyd_attribute26 :=
714: ben_pyd_shd.g_old_rec.pyd_attribute26;
715: End If;
716: If (p_rec.pyd_attribute27 = hr_api.g_varchar2) then
717: p_rec.pyd_attribute27 :=
718: ben_pyd_shd.g_old_rec.pyd_attribute27;
714: ben_pyd_shd.g_old_rec.pyd_attribute26;
715: End If;
716: If (p_rec.pyd_attribute27 = hr_api.g_varchar2) then
717: p_rec.pyd_attribute27 :=
718: ben_pyd_shd.g_old_rec.pyd_attribute27;
719: End If;
720: If (p_rec.pyd_attribute28 = hr_api.g_varchar2) then
721: p_rec.pyd_attribute28 :=
722: ben_pyd_shd.g_old_rec.pyd_attribute28;
718: ben_pyd_shd.g_old_rec.pyd_attribute27;
719: End If;
720: If (p_rec.pyd_attribute28 = hr_api.g_varchar2) then
721: p_rec.pyd_attribute28 :=
722: ben_pyd_shd.g_old_rec.pyd_attribute28;
723: End If;
724: If (p_rec.pyd_attribute29 = hr_api.g_varchar2) then
725: p_rec.pyd_attribute29 :=
726: ben_pyd_shd.g_old_rec.pyd_attribute29;
722: ben_pyd_shd.g_old_rec.pyd_attribute28;
723: End If;
724: If (p_rec.pyd_attribute29 = hr_api.g_varchar2) then
725: p_rec.pyd_attribute29 :=
726: ben_pyd_shd.g_old_rec.pyd_attribute29;
727: End If;
728: If (p_rec.pyd_attribute30 = hr_api.g_varchar2) then
729: p_rec.pyd_attribute30 :=
730: ben_pyd_shd.g_old_rec.pyd_attribute30;
726: ben_pyd_shd.g_old_rec.pyd_attribute29;
727: End If;
728: If (p_rec.pyd_attribute30 = hr_api.g_varchar2) then
729: p_rec.pyd_attribute30 :=
730: ben_pyd_shd.g_old_rec.pyd_attribute30;
731: End If;
732:
733: --
734: hr_utility.set_location(' Leaving:'||l_proc, 10);
739: -- |---------------------------------< upd >----------------------------------|
740: -- ----------------------------------------------------------------------------
741: Procedure upd
742: (
743: p_rec in out nocopy ben_pyd_shd.g_rec_type,
744: p_effective_date in date,
745: p_datetrack_mode in varchar2
746: ) is
747: --
757: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
758: --
759: -- We must lock the row which we need to update.
760: --
761: ben_pyd_shd.lck
762: (p_effective_date => p_effective_date,
763: p_datetrack_mode => p_datetrack_mode,
764: p_ptip_dpnt_cvg_ctfn_id => p_rec.ptip_dpnt_cvg_ctfn_id,
765: p_object_version_number => p_rec.object_version_number,
859: p_effective_date in date,
860: p_datetrack_mode in varchar2
861: ) is
862: --
863: l_rec ben_pyd_shd.g_rec_type;
864: l_proc varchar2(72) := g_package||'upd';
865: --
866: Begin
867: hr_utility.set_location('Entering:'||l_proc, 5);
869: -- Call conversion function to turn arguments into the
870: -- l_rec structure.
871: --
872: l_rec :=
873: ben_pyd_shd.convert_args
874: (
875: p_ptip_dpnt_cvg_ctfn_id,
876: null,
877: null,