54: --
55: -- {End Of Comments}
56: -- ----------------------------------------------------------------------------
57: Procedure dt_update_dml
58: (p_rec in out nocopy ben_cpr_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_popl_org_role_f',
78: p_base_key_column => 'popl_org_role_id',
79: p_base_key_value => p_rec.popl_org_role_id);
80: --
81: ben_cpr_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_popl_org_role_f Row
84: --
85: update ben_popl_org_role_f
124: where popl_org_role_id = p_rec.popl_org_role_id
125: and effective_start_date = p_validation_start_date
126: and effective_end_date = p_validation_end_date;
127: --
128: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
129: --
130: -- Set the effective start and end dates
131: --
132: p_rec.effective_start_date := p_validation_start_date;
136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_cpr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_cpr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
141: ben_cpr_shd.constraint_error
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_cpr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
142: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.unique_integrity_violated Then
144: -- Unique integrity has been violated
145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_cpr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
145: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
146: ben_cpr_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When Others Then
149: ben_cpr_shd.g_api_dml := false; -- Unset the api dml status
150: Raise;
151: End dt_update_dml;
152: --
153: -- ----------------------------------------------------------------------------
181: --
182: -- {End Of Comments}
183: -- ----------------------------------------------------------------------------
184: Procedure update_dml
185: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
186: p_effective_date in date,
187: p_datetrack_mode in varchar2,
188: p_validation_start_date in date,
189: p_validation_end_date in date) is
245: --
246: -- {End Of Comments}
247: -- ----------------------------------------------------------------------------
248: Procedure dt_pre_update
249: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
250: p_effective_date in date,
251: p_datetrack_mode in varchar2,
252: p_validation_start_date in date,
253: p_validation_end_date in date) is
261: hr_utility.set_location(l_proc, 10);
262: --
263: -- Update the current effective end date
264: --
265: ben_cpr_shd.upd_effective_end_date
266: (p_effective_date => p_effective_date,
267: p_base_key_value => p_rec.popl_org_role_id,
268: p_new_effective_end_date => (p_validation_start_date - 1),
269: p_validation_start_date => p_validation_start_date,
330: --
331: -- {End Of Comments}
332: -- ----------------------------------------------------------------------------
333: Procedure pre_update
334: (p_rec in out nocopy ben_cpr_shd.g_rec_type,
335: p_effective_date in date,
336: p_datetrack_mode in varchar2,
337: p_validation_start_date in date,
338: p_validation_end_date in date) is
386: --
387: -- {End Of Comments}
388: -- ----------------------------------------------------------------------------
389: Procedure post_update
390: (p_rec in ben_cpr_shd.g_rec_type,
391: p_effective_date in date,
392: p_datetrack_mode in varchar2,
393: p_validation_start_date in date,
394: p_validation_end_date in date) is
447: ,p_effective_date =>p_effective_date
448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
448: ,p_datetrack_mode =>p_datetrack_mode
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
449: ,p_validation_start_date =>p_validation_start_date
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
450: ,p_validation_end_date =>p_validation_end_date
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
451: ,p_effective_start_date_o =>ben_cpr_shd.g_old_rec.effective_start_date
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
452: ,p_effective_end_date_o =>ben_cpr_shd.g_old_rec.effective_end_date
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
453: ,p_name_o =>ben_cpr_shd.g_old_rec.name
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
454: ,p_org_role_typ_cd_o =>ben_cpr_shd.g_old_rec.org_role_typ_cd
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
455: ,p_popl_org_id_o =>ben_cpr_shd.g_old_rec.popl_org_id
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
456: ,p_business_group_id_o =>ben_cpr_shd.g_old_rec.business_group_id
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
457: ,p_cpr_attribute_category_o =>ben_cpr_shd.g_old_rec.cpr_attribute_category
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
458: ,p_cpr_attribute1_o =>ben_cpr_shd.g_old_rec.cpr_attribute1
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
459: ,p_cpr_attribute2_o =>ben_cpr_shd.g_old_rec.cpr_attribute2
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
460: ,p_cpr_attribute3_o =>ben_cpr_shd.g_old_rec.cpr_attribute3
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
461: ,p_cpr_attribute4_o =>ben_cpr_shd.g_old_rec.cpr_attribute4
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
462: ,p_cpr_attribute5_o =>ben_cpr_shd.g_old_rec.cpr_attribute5
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
463: ,p_cpr_attribute6_o =>ben_cpr_shd.g_old_rec.cpr_attribute6
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
464: ,p_cpr_attribute7_o =>ben_cpr_shd.g_old_rec.cpr_attribute7
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
465: ,p_cpr_attribute8_o =>ben_cpr_shd.g_old_rec.cpr_attribute8
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
466: ,p_cpr_attribute9_o =>ben_cpr_shd.g_old_rec.cpr_attribute9
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
467: ,p_cpr_attribute10_o =>ben_cpr_shd.g_old_rec.cpr_attribute10
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
468: ,p_cpr_attribute11_o =>ben_cpr_shd.g_old_rec.cpr_attribute11
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
469: ,p_cpr_attribute12_o =>ben_cpr_shd.g_old_rec.cpr_attribute12
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
470: ,p_cpr_attribute13_o =>ben_cpr_shd.g_old_rec.cpr_attribute13
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
471: ,p_cpr_attribute14_o =>ben_cpr_shd.g_old_rec.cpr_attribute14
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
472: ,p_cpr_attribute15_o =>ben_cpr_shd.g_old_rec.cpr_attribute15
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
473: ,p_cpr_attribute16_o =>ben_cpr_shd.g_old_rec.cpr_attribute16
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
474: ,p_cpr_attribute17_o =>ben_cpr_shd.g_old_rec.cpr_attribute17
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
475: ,p_cpr_attribute18_o =>ben_cpr_shd.g_old_rec.cpr_attribute18
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
476: ,p_cpr_attribute19_o =>ben_cpr_shd.g_old_rec.cpr_attribute19
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
477: ,p_cpr_attribute20_o =>ben_cpr_shd.g_old_rec.cpr_attribute20
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
478: ,p_cpr_attribute21_o =>ben_cpr_shd.g_old_rec.cpr_attribute21
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
479: ,p_cpr_attribute22_o =>ben_cpr_shd.g_old_rec.cpr_attribute22
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
480: ,p_cpr_attribute23_o =>ben_cpr_shd.g_old_rec.cpr_attribute23
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
481: ,p_cpr_attribute24_o =>ben_cpr_shd.g_old_rec.cpr_attribute24
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
482: ,p_cpr_attribute25_o =>ben_cpr_shd.g_old_rec.cpr_attribute25
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --
483: ,p_cpr_attribute26_o =>ben_cpr_shd.g_old_rec.cpr_attribute26
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception
484: ,p_cpr_attribute27_o =>ben_cpr_shd.g_old_rec.cpr_attribute27
485: ,p_cpr_attribute28_o =>ben_cpr_shd.g_old_rec.cpr_attribute28
486: ,p_cpr_attribute29_o =>ben_cpr_shd.g_old_rec.cpr_attribute29
487: ,p_cpr_attribute30_o =>ben_cpr_shd.g_old_rec.cpr_attribute30
488: ,p_object_version_number_o =>ben_cpr_shd.g_old_rec.object_version_number
489: );
490: --
491: exception
492: --
546: -- Internal Row Handler Use Only.
547: --
548: -- {End Of Comments}
549: -- ----------------------------------------------------------------------------
550: Procedure convert_defs(p_rec in out nocopy ben_cpr_shd.g_rec_type) is
551: --
552: l_proc varchar2(72) := g_package||'convert_defs';
553: --
554: Begin
561: -- is being used then we must set to the 'current' argument value.
562: --
563: If (p_rec.name = hr_api.g_varchar2) then
564: p_rec.name :=
565: ben_cpr_shd.g_old_rec.name;
566: End If;
567: If (p_rec.popl_org_id = hr_api.g_number) then
568: p_rec.popl_org_id :=
569: ben_cpr_shd.g_old_rec.popl_org_id;
565: ben_cpr_shd.g_old_rec.name;
566: End If;
567: If (p_rec.popl_org_id = hr_api.g_number) then
568: p_rec.popl_org_id :=
569: ben_cpr_shd.g_old_rec.popl_org_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_cpr_shd.g_old_rec.business_group_id;
569: ben_cpr_shd.g_old_rec.popl_org_id;
570: End If;
571: If (p_rec.business_group_id = hr_api.g_number) then
572: p_rec.business_group_id :=
573: ben_cpr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.cpr_attribute_category = hr_api.g_varchar2) then
576: p_rec.cpr_attribute_category :=
577: ben_cpr_shd.g_old_rec.cpr_attribute_category;
573: ben_cpr_shd.g_old_rec.business_group_id;
574: End If;
575: If (p_rec.cpr_attribute_category = hr_api.g_varchar2) then
576: p_rec.cpr_attribute_category :=
577: ben_cpr_shd.g_old_rec.cpr_attribute_category;
578: End If;
579: If (p_rec.cpr_attribute1 = hr_api.g_varchar2) then
580: p_rec.cpr_attribute1 :=
581: ben_cpr_shd.g_old_rec.cpr_attribute1;
577: ben_cpr_shd.g_old_rec.cpr_attribute_category;
578: End If;
579: If (p_rec.cpr_attribute1 = hr_api.g_varchar2) then
580: p_rec.cpr_attribute1 :=
581: ben_cpr_shd.g_old_rec.cpr_attribute1;
582: End If;
583: If (p_rec.cpr_attribute2 = hr_api.g_varchar2) then
584: p_rec.cpr_attribute2 :=
585: ben_cpr_shd.g_old_rec.cpr_attribute2;
581: ben_cpr_shd.g_old_rec.cpr_attribute1;
582: End If;
583: If (p_rec.cpr_attribute2 = hr_api.g_varchar2) then
584: p_rec.cpr_attribute2 :=
585: ben_cpr_shd.g_old_rec.cpr_attribute2;
586: End If;
587: If (p_rec.cpr_attribute3 = hr_api.g_varchar2) then
588: p_rec.cpr_attribute3 :=
589: ben_cpr_shd.g_old_rec.cpr_attribute3;
585: ben_cpr_shd.g_old_rec.cpr_attribute2;
586: End If;
587: If (p_rec.cpr_attribute3 = hr_api.g_varchar2) then
588: p_rec.cpr_attribute3 :=
589: ben_cpr_shd.g_old_rec.cpr_attribute3;
590: End If;
591: If (p_rec.cpr_attribute4 = hr_api.g_varchar2) then
592: p_rec.cpr_attribute4 :=
593: ben_cpr_shd.g_old_rec.cpr_attribute4;
589: ben_cpr_shd.g_old_rec.cpr_attribute3;
590: End If;
591: If (p_rec.cpr_attribute4 = hr_api.g_varchar2) then
592: p_rec.cpr_attribute4 :=
593: ben_cpr_shd.g_old_rec.cpr_attribute4;
594: End If;
595: If (p_rec.cpr_attribute5 = hr_api.g_varchar2) then
596: p_rec.cpr_attribute5 :=
597: ben_cpr_shd.g_old_rec.cpr_attribute5;
593: ben_cpr_shd.g_old_rec.cpr_attribute4;
594: End If;
595: If (p_rec.cpr_attribute5 = hr_api.g_varchar2) then
596: p_rec.cpr_attribute5 :=
597: ben_cpr_shd.g_old_rec.cpr_attribute5;
598: End If;
599: If (p_rec.cpr_attribute6 = hr_api.g_varchar2) then
600: p_rec.cpr_attribute6 :=
601: ben_cpr_shd.g_old_rec.cpr_attribute6;
597: ben_cpr_shd.g_old_rec.cpr_attribute5;
598: End If;
599: If (p_rec.cpr_attribute6 = hr_api.g_varchar2) then
600: p_rec.cpr_attribute6 :=
601: ben_cpr_shd.g_old_rec.cpr_attribute6;
602: End If;
603: If (p_rec.cpr_attribute7 = hr_api.g_varchar2) then
604: p_rec.cpr_attribute7 :=
605: ben_cpr_shd.g_old_rec.cpr_attribute7;
601: ben_cpr_shd.g_old_rec.cpr_attribute6;
602: End If;
603: If (p_rec.cpr_attribute7 = hr_api.g_varchar2) then
604: p_rec.cpr_attribute7 :=
605: ben_cpr_shd.g_old_rec.cpr_attribute7;
606: End If;
607: If (p_rec.cpr_attribute8 = hr_api.g_varchar2) then
608: p_rec.cpr_attribute8 :=
609: ben_cpr_shd.g_old_rec.cpr_attribute8;
605: ben_cpr_shd.g_old_rec.cpr_attribute7;
606: End If;
607: If (p_rec.cpr_attribute8 = hr_api.g_varchar2) then
608: p_rec.cpr_attribute8 :=
609: ben_cpr_shd.g_old_rec.cpr_attribute8;
610: End If;
611: If (p_rec.cpr_attribute9 = hr_api.g_varchar2) then
612: p_rec.cpr_attribute9 :=
613: ben_cpr_shd.g_old_rec.cpr_attribute9;
609: ben_cpr_shd.g_old_rec.cpr_attribute8;
610: End If;
611: If (p_rec.cpr_attribute9 = hr_api.g_varchar2) then
612: p_rec.cpr_attribute9 :=
613: ben_cpr_shd.g_old_rec.cpr_attribute9;
614: End If;
615: If (p_rec.cpr_attribute10 = hr_api.g_varchar2) then
616: p_rec.cpr_attribute10 :=
617: ben_cpr_shd.g_old_rec.cpr_attribute10;
613: ben_cpr_shd.g_old_rec.cpr_attribute9;
614: End If;
615: If (p_rec.cpr_attribute10 = hr_api.g_varchar2) then
616: p_rec.cpr_attribute10 :=
617: ben_cpr_shd.g_old_rec.cpr_attribute10;
618: End If;
619: If (p_rec.cpr_attribute11 = hr_api.g_varchar2) then
620: p_rec.cpr_attribute11 :=
621: ben_cpr_shd.g_old_rec.cpr_attribute11;
617: ben_cpr_shd.g_old_rec.cpr_attribute10;
618: End If;
619: If (p_rec.cpr_attribute11 = hr_api.g_varchar2) then
620: p_rec.cpr_attribute11 :=
621: ben_cpr_shd.g_old_rec.cpr_attribute11;
622: End If;
623: If (p_rec.cpr_attribute12 = hr_api.g_varchar2) then
624: p_rec.cpr_attribute12 :=
625: ben_cpr_shd.g_old_rec.cpr_attribute12;
621: ben_cpr_shd.g_old_rec.cpr_attribute11;
622: End If;
623: If (p_rec.cpr_attribute12 = hr_api.g_varchar2) then
624: p_rec.cpr_attribute12 :=
625: ben_cpr_shd.g_old_rec.cpr_attribute12;
626: End If;
627: If (p_rec.cpr_attribute13 = hr_api.g_varchar2) then
628: p_rec.cpr_attribute13 :=
629: ben_cpr_shd.g_old_rec.cpr_attribute13;
625: ben_cpr_shd.g_old_rec.cpr_attribute12;
626: End If;
627: If (p_rec.cpr_attribute13 = hr_api.g_varchar2) then
628: p_rec.cpr_attribute13 :=
629: ben_cpr_shd.g_old_rec.cpr_attribute13;
630: End If;
631: If (p_rec.cpr_attribute14 = hr_api.g_varchar2) then
632: p_rec.cpr_attribute14 :=
633: ben_cpr_shd.g_old_rec.cpr_attribute14;
629: ben_cpr_shd.g_old_rec.cpr_attribute13;
630: End If;
631: If (p_rec.cpr_attribute14 = hr_api.g_varchar2) then
632: p_rec.cpr_attribute14 :=
633: ben_cpr_shd.g_old_rec.cpr_attribute14;
634: End If;
635: If (p_rec.cpr_attribute15 = hr_api.g_varchar2) then
636: p_rec.cpr_attribute15 :=
637: ben_cpr_shd.g_old_rec.cpr_attribute15;
633: ben_cpr_shd.g_old_rec.cpr_attribute14;
634: End If;
635: If (p_rec.cpr_attribute15 = hr_api.g_varchar2) then
636: p_rec.cpr_attribute15 :=
637: ben_cpr_shd.g_old_rec.cpr_attribute15;
638: End If;
639: If (p_rec.cpr_attribute16 = hr_api.g_varchar2) then
640: p_rec.cpr_attribute16 :=
641: ben_cpr_shd.g_old_rec.cpr_attribute16;
637: ben_cpr_shd.g_old_rec.cpr_attribute15;
638: End If;
639: If (p_rec.cpr_attribute16 = hr_api.g_varchar2) then
640: p_rec.cpr_attribute16 :=
641: ben_cpr_shd.g_old_rec.cpr_attribute16;
642: End If;
643: If (p_rec.cpr_attribute17 = hr_api.g_varchar2) then
644: p_rec.cpr_attribute17 :=
645: ben_cpr_shd.g_old_rec.cpr_attribute17;
641: ben_cpr_shd.g_old_rec.cpr_attribute16;
642: End If;
643: If (p_rec.cpr_attribute17 = hr_api.g_varchar2) then
644: p_rec.cpr_attribute17 :=
645: ben_cpr_shd.g_old_rec.cpr_attribute17;
646: End If;
647: If (p_rec.cpr_attribute18 = hr_api.g_varchar2) then
648: p_rec.cpr_attribute18 :=
649: ben_cpr_shd.g_old_rec.cpr_attribute18;
645: ben_cpr_shd.g_old_rec.cpr_attribute17;
646: End If;
647: If (p_rec.cpr_attribute18 = hr_api.g_varchar2) then
648: p_rec.cpr_attribute18 :=
649: ben_cpr_shd.g_old_rec.cpr_attribute18;
650: End If;
651: If (p_rec.cpr_attribute19 = hr_api.g_varchar2) then
652: p_rec.cpr_attribute19 :=
653: ben_cpr_shd.g_old_rec.cpr_attribute19;
649: ben_cpr_shd.g_old_rec.cpr_attribute18;
650: End If;
651: If (p_rec.cpr_attribute19 = hr_api.g_varchar2) then
652: p_rec.cpr_attribute19 :=
653: ben_cpr_shd.g_old_rec.cpr_attribute19;
654: End If;
655: If (p_rec.cpr_attribute20 = hr_api.g_varchar2) then
656: p_rec.cpr_attribute20 :=
657: ben_cpr_shd.g_old_rec.cpr_attribute20;
653: ben_cpr_shd.g_old_rec.cpr_attribute19;
654: End If;
655: If (p_rec.cpr_attribute20 = hr_api.g_varchar2) then
656: p_rec.cpr_attribute20 :=
657: ben_cpr_shd.g_old_rec.cpr_attribute20;
658: End If;
659: If (p_rec.cpr_attribute21 = hr_api.g_varchar2) then
660: p_rec.cpr_attribute21 :=
661: ben_cpr_shd.g_old_rec.cpr_attribute21;
657: ben_cpr_shd.g_old_rec.cpr_attribute20;
658: End If;
659: If (p_rec.cpr_attribute21 = hr_api.g_varchar2) then
660: p_rec.cpr_attribute21 :=
661: ben_cpr_shd.g_old_rec.cpr_attribute21;
662: End If;
663: If (p_rec.cpr_attribute22 = hr_api.g_varchar2) then
664: p_rec.cpr_attribute22 :=
665: ben_cpr_shd.g_old_rec.cpr_attribute22;
661: ben_cpr_shd.g_old_rec.cpr_attribute21;
662: End If;
663: If (p_rec.cpr_attribute22 = hr_api.g_varchar2) then
664: p_rec.cpr_attribute22 :=
665: ben_cpr_shd.g_old_rec.cpr_attribute22;
666: End If;
667: If (p_rec.cpr_attribute23 = hr_api.g_varchar2) then
668: p_rec.cpr_attribute23 :=
669: ben_cpr_shd.g_old_rec.cpr_attribute23;
665: ben_cpr_shd.g_old_rec.cpr_attribute22;
666: End If;
667: If (p_rec.cpr_attribute23 = hr_api.g_varchar2) then
668: p_rec.cpr_attribute23 :=
669: ben_cpr_shd.g_old_rec.cpr_attribute23;
670: End If;
671: If (p_rec.cpr_attribute24 = hr_api.g_varchar2) then
672: p_rec.cpr_attribute24 :=
673: ben_cpr_shd.g_old_rec.cpr_attribute24;
669: ben_cpr_shd.g_old_rec.cpr_attribute23;
670: End If;
671: If (p_rec.cpr_attribute24 = hr_api.g_varchar2) then
672: p_rec.cpr_attribute24 :=
673: ben_cpr_shd.g_old_rec.cpr_attribute24;
674: End If;
675: If (p_rec.cpr_attribute25 = hr_api.g_varchar2) then
676: p_rec.cpr_attribute25 :=
677: ben_cpr_shd.g_old_rec.cpr_attribute25;
673: ben_cpr_shd.g_old_rec.cpr_attribute24;
674: End If;
675: If (p_rec.cpr_attribute25 = hr_api.g_varchar2) then
676: p_rec.cpr_attribute25 :=
677: ben_cpr_shd.g_old_rec.cpr_attribute25;
678: End If;
679: If (p_rec.cpr_attribute26 = hr_api.g_varchar2) then
680: p_rec.cpr_attribute26 :=
681: ben_cpr_shd.g_old_rec.cpr_attribute26;
677: ben_cpr_shd.g_old_rec.cpr_attribute25;
678: End If;
679: If (p_rec.cpr_attribute26 = hr_api.g_varchar2) then
680: p_rec.cpr_attribute26 :=
681: ben_cpr_shd.g_old_rec.cpr_attribute26;
682: End If;
683: If (p_rec.cpr_attribute27 = hr_api.g_varchar2) then
684: p_rec.cpr_attribute27 :=
685: ben_cpr_shd.g_old_rec.cpr_attribute27;
681: ben_cpr_shd.g_old_rec.cpr_attribute26;
682: End If;
683: If (p_rec.cpr_attribute27 = hr_api.g_varchar2) then
684: p_rec.cpr_attribute27 :=
685: ben_cpr_shd.g_old_rec.cpr_attribute27;
686: End If;
687: If (p_rec.cpr_attribute28 = hr_api.g_varchar2) then
688: p_rec.cpr_attribute28 :=
689: ben_cpr_shd.g_old_rec.cpr_attribute28;
685: ben_cpr_shd.g_old_rec.cpr_attribute27;
686: End If;
687: If (p_rec.cpr_attribute28 = hr_api.g_varchar2) then
688: p_rec.cpr_attribute28 :=
689: ben_cpr_shd.g_old_rec.cpr_attribute28;
690: End If;
691: If (p_rec.cpr_attribute29 = hr_api.g_varchar2) then
692: p_rec.cpr_attribute29 :=
693: ben_cpr_shd.g_old_rec.cpr_attribute29;
689: ben_cpr_shd.g_old_rec.cpr_attribute28;
690: End If;
691: If (p_rec.cpr_attribute29 = hr_api.g_varchar2) then
692: p_rec.cpr_attribute29 :=
693: ben_cpr_shd.g_old_rec.cpr_attribute29;
694: End If;
695: If (p_rec.cpr_attribute30 = hr_api.g_varchar2) then
696: p_rec.cpr_attribute30 :=
697: ben_cpr_shd.g_old_rec.cpr_attribute30;
693: ben_cpr_shd.g_old_rec.cpr_attribute29;
694: End If;
695: If (p_rec.cpr_attribute30 = hr_api.g_varchar2) then
696: p_rec.cpr_attribute30 :=
697: ben_cpr_shd.g_old_rec.cpr_attribute30;
698: End If;
699:
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: -- |---------------------------------< upd >----------------------------------|
707: -- ----------------------------------------------------------------------------
708: Procedure upd
709: (
710: p_rec in out nocopy ben_cpr_shd.g_rec_type,
711: p_effective_date in date,
712: p_datetrack_mode in varchar2
713: ) is
714: --
724: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);
725: --
726: -- We must lock the row which we need to update.
727: --
728: ben_cpr_shd.lck
729: (p_effective_date => p_effective_date,
730: p_datetrack_mode => p_datetrack_mode,
731: p_popl_org_role_id => p_rec.popl_org_role_id,
732: p_object_version_number => p_rec.object_version_number,
822: p_effective_date in date,
823: p_datetrack_mode in varchar2
824: ) is
825: --
826: l_rec ben_cpr_shd.g_rec_type;
827: l_proc varchar2(72) := g_package||'upd';
828: --
829: Begin
830: hr_utility.set_location('Entering:'||l_proc, 5);
832: -- Call conversion function to turn arguments into the
833: -- l_rec structure.
834: --
835: l_rec :=
836: ben_cpr_shd.convert_args
837: (
838: p_popl_org_role_id,
839: null,
840: null,