50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_ecc_shd.g_rec_type) is
55: --
56: l_proc varchar2(72) := g_package||'update_dml';
57: --
58: Begin
61: -- Increment the object version
62: --
63: p_rec.object_version_number := p_rec.object_version_number + 1;
64: --
65: ben_ecc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_elctbl_chc_ctfn Row
68: --
69: update ben_elctbl_chc_ctfn
113: program_update_date = p_rec.program_update_date,
114: object_version_number = p_rec.object_version_number
115: where elctbl_chc_ctfn_id = p_rec.elctbl_chc_ctfn_id;
116: --
117: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
118: --
119: hr_utility.set_location(' Leaving:'||l_proc, 10);
120: --
121: Exception
120: --
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
121: Exception
122: When hr_api.check_integrity_violated Then
123: -- A check constraint has been violated
124: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
125: ben_ecc_shd.constraint_error
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
126: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
127: When hr_api.parent_integrity_violated Then
128: -- Parent integrity has been violated
129: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
130: ben_ecc_shd.constraint_error
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
131: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
132: When hr_api.unique_integrity_violated Then
133: -- Unique integrity has been violated
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;
134: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
135: ben_ecc_shd.constraint_error
136: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
137: When Others Then
138: ben_ecc_shd.g_api_dml := false; -- Unset the api dml status
139: Raise;
140: End update_dml;
141: --
142: -- ----------------------------------------------------------------------------
170: -- Internal Row Handler Use Only.
171: --
172: -- {End Of Comments}
173: -- ----------------------------------------------------------------------------
174: Procedure pre_update(p_rec in ben_ecc_shd.g_rec_type) is
175: --
176: l_proc varchar2(72) := g_package||'pre_update';
177: --
178: Begin
213: --
214: -- {End Of Comments}
215: -- ----------------------------------------------------------------------------
216: Procedure post_update(
217: p_effective_date in date,p_rec in ben_ecc_shd.g_rec_type) is
218: --
219: l_proc varchar2(72) := g_package||'post_update';
220: --
221: Begin
272: ,p_program_id =>p_rec.program_id
273: ,p_program_update_date =>p_rec.program_update_date
274: ,p_object_version_number =>p_rec.object_version_number
275: ,p_effective_date =>p_effective_date
276: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
273: ,p_program_update_date =>p_rec.program_update_date
274: ,p_object_version_number =>p_rec.object_version_number
275: ,p_effective_date =>p_effective_date
276: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
274: ,p_object_version_number =>p_rec.object_version_number
275: ,p_effective_date =>p_effective_date
276: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
275: ,p_effective_date =>p_effective_date
276: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
276: ,p_enrt_ctfn_typ_cd_o =>ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
277: ,p_rqd_flag_o =>ben_ecc_shd.g_old_rec.rqd_flag
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
278: ,p_elig_per_elctbl_chc_id_o =>ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
279: ,p_enrt_bnft_id_o =>ben_ecc_shd.g_old_rec.enrt_bnft_id
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
280: ,p_business_group_id_o =>ben_ecc_shd.g_old_rec.business_group_id
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
281: ,p_ecc_attribute_category_o =>ben_ecc_shd.g_old_rec.ecc_attribute_category
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
282: ,p_ecc_attribute1_o =>ben_ecc_shd.g_old_rec.ecc_attribute1
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
283: ,p_ecc_attribute2_o =>ben_ecc_shd.g_old_rec.ecc_attribute2
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
284: ,p_ecc_attribute3_o =>ben_ecc_shd.g_old_rec.ecc_attribute3
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
285: ,p_ecc_attribute4_o =>ben_ecc_shd.g_old_rec.ecc_attribute4
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
286: ,p_ecc_attribute5_o =>ben_ecc_shd.g_old_rec.ecc_attribute5
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
287: ,p_ecc_attribute6_o =>ben_ecc_shd.g_old_rec.ecc_attribute6
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
288: ,p_ecc_attribute7_o =>ben_ecc_shd.g_old_rec.ecc_attribute7
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
289: ,p_ecc_attribute8_o =>ben_ecc_shd.g_old_rec.ecc_attribute8
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
290: ,p_ecc_attribute9_o =>ben_ecc_shd.g_old_rec.ecc_attribute9
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
291: ,p_ecc_attribute10_o =>ben_ecc_shd.g_old_rec.ecc_attribute10
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
292: ,p_ecc_attribute11_o =>ben_ecc_shd.g_old_rec.ecc_attribute11
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
293: ,p_ecc_attribute12_o =>ben_ecc_shd.g_old_rec.ecc_attribute12
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
294: ,p_ecc_attribute13_o =>ben_ecc_shd.g_old_rec.ecc_attribute13
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
295: ,p_ecc_attribute14_o =>ben_ecc_shd.g_old_rec.ecc_attribute14
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
296: ,p_ecc_attribute15_o =>ben_ecc_shd.g_old_rec.ecc_attribute15
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
297: ,p_ecc_attribute16_o =>ben_ecc_shd.g_old_rec.ecc_attribute16
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
298: ,p_ecc_attribute17_o =>ben_ecc_shd.g_old_rec.ecc_attribute17
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
299: ,p_ecc_attribute18_o =>ben_ecc_shd.g_old_rec.ecc_attribute18
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
300: ,p_ecc_attribute19_o =>ben_ecc_shd.g_old_rec.ecc_attribute19
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
301: ,p_ecc_attribute20_o =>ben_ecc_shd.g_old_rec.ecc_attribute20
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
302: ,p_ecc_attribute21_o =>ben_ecc_shd.g_old_rec.ecc_attribute21
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
303: ,p_ecc_attribute22_o =>ben_ecc_shd.g_old_rec.ecc_attribute22
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
304: ,p_ecc_attribute23_o =>ben_ecc_shd.g_old_rec.ecc_attribute23
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
305: ,p_ecc_attribute24_o =>ben_ecc_shd.g_old_rec.ecc_attribute24
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
306: ,p_ecc_attribute25_o =>ben_ecc_shd.g_old_rec.ecc_attribute25
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
307: ,p_ecc_attribute26_o =>ben_ecc_shd.g_old_rec.ecc_attribute26
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
308: ,p_ecc_attribute27_o =>ben_ecc_shd.g_old_rec.ecc_attribute27
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
309: ,p_ecc_attribute28_o =>ben_ecc_shd.g_old_rec.ecc_attribute28
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
310: ,p_ecc_attribute29_o =>ben_ecc_shd.g_old_rec.ecc_attribute29
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
318: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
311: ,p_ecc_attribute30_o =>ben_ecc_shd.g_old_rec.ecc_attribute30
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
318: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
319: );
312: ,p_susp_if_ctfn_not_prvd_flag_o =>ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
318: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
319: );
320: --
313: ,p_ctfn_determine_cd_o =>ben_ecc_shd.g_old_rec.ctfn_determine_cd
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
318: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
319: );
320: --
321: exception
314: ,p_request_id_o =>ben_ecc_shd.g_old_rec.request_id
315: ,p_program_application_id_o =>ben_ecc_shd.g_old_rec.program_application_id
316: ,p_program_id_o =>ben_ecc_shd.g_old_rec.program_id
317: ,p_program_update_date_o =>ben_ecc_shd.g_old_rec.program_update_date
318: ,p_object_version_number_o =>ben_ecc_shd.g_old_rec.object_version_number
319: );
320: --
321: exception
322: --
376: -- Internal Row Handler Use Only.
377: --
378: -- {End Of Comments}
379: -- ----------------------------------------------------------------------------
380: Procedure convert_defs(p_rec in out nocopy ben_ecc_shd.g_rec_type) is
381: --
382: l_proc varchar2(72) := g_package||'convert_defs';
383: --
384: Begin
391: -- is being used then we must set to the 'current' argument value.
392: --
393: If (p_rec.enrt_ctfn_typ_cd = hr_api.g_varchar2) then
394: p_rec.enrt_ctfn_typ_cd :=
395: ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd;
396: End If;
397: If (p_rec.rqd_flag = hr_api.g_varchar2) then
398: p_rec.rqd_flag :=
399: ben_ecc_shd.g_old_rec.rqd_flag;
395: ben_ecc_shd.g_old_rec.enrt_ctfn_typ_cd;
396: End If;
397: If (p_rec.rqd_flag = hr_api.g_varchar2) then
398: p_rec.rqd_flag :=
399: ben_ecc_shd.g_old_rec.rqd_flag;
400: End If;
401: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
402: p_rec.elig_per_elctbl_chc_id :=
403: ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id;
399: ben_ecc_shd.g_old_rec.rqd_flag;
400: End If;
401: If (p_rec.elig_per_elctbl_chc_id = hr_api.g_number) then
402: p_rec.elig_per_elctbl_chc_id :=
403: ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id;
404: End If;
405: If (p_rec.enrt_bnft_id = hr_api.g_number) then
406: p_rec.enrt_bnft_id :=
407: ben_ecc_shd.g_old_rec.enrt_bnft_id;
403: ben_ecc_shd.g_old_rec.elig_per_elctbl_chc_id;
404: End If;
405: If (p_rec.enrt_bnft_id = hr_api.g_number) then
406: p_rec.enrt_bnft_id :=
407: ben_ecc_shd.g_old_rec.enrt_bnft_id;
408: End If;
409: If (p_rec.business_group_id = hr_api.g_number) then
410: p_rec.business_group_id :=
411: ben_ecc_shd.g_old_rec.business_group_id;
407: ben_ecc_shd.g_old_rec.enrt_bnft_id;
408: End If;
409: If (p_rec.business_group_id = hr_api.g_number) then
410: p_rec.business_group_id :=
411: ben_ecc_shd.g_old_rec.business_group_id;
412: End If;
413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then
414: p_rec.ecc_attribute_category :=
415: ben_ecc_shd.g_old_rec.ecc_attribute_category;
411: ben_ecc_shd.g_old_rec.business_group_id;
412: End If;
413: If (p_rec.ecc_attribute_category = hr_api.g_varchar2) then
414: p_rec.ecc_attribute_category :=
415: ben_ecc_shd.g_old_rec.ecc_attribute_category;
416: End If;
417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then
418: p_rec.ecc_attribute1 :=
419: ben_ecc_shd.g_old_rec.ecc_attribute1;
415: ben_ecc_shd.g_old_rec.ecc_attribute_category;
416: End If;
417: If (p_rec.ecc_attribute1 = hr_api.g_varchar2) then
418: p_rec.ecc_attribute1 :=
419: ben_ecc_shd.g_old_rec.ecc_attribute1;
420: End If;
421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then
422: p_rec.ecc_attribute2 :=
423: ben_ecc_shd.g_old_rec.ecc_attribute2;
419: ben_ecc_shd.g_old_rec.ecc_attribute1;
420: End If;
421: If (p_rec.ecc_attribute2 = hr_api.g_varchar2) then
422: p_rec.ecc_attribute2 :=
423: ben_ecc_shd.g_old_rec.ecc_attribute2;
424: End If;
425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then
426: p_rec.ecc_attribute3 :=
427: ben_ecc_shd.g_old_rec.ecc_attribute3;
423: ben_ecc_shd.g_old_rec.ecc_attribute2;
424: End If;
425: If (p_rec.ecc_attribute3 = hr_api.g_varchar2) then
426: p_rec.ecc_attribute3 :=
427: ben_ecc_shd.g_old_rec.ecc_attribute3;
428: End If;
429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then
430: p_rec.ecc_attribute4 :=
431: ben_ecc_shd.g_old_rec.ecc_attribute4;
427: ben_ecc_shd.g_old_rec.ecc_attribute3;
428: End If;
429: If (p_rec.ecc_attribute4 = hr_api.g_varchar2) then
430: p_rec.ecc_attribute4 :=
431: ben_ecc_shd.g_old_rec.ecc_attribute4;
432: End If;
433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then
434: p_rec.ecc_attribute5 :=
435: ben_ecc_shd.g_old_rec.ecc_attribute5;
431: ben_ecc_shd.g_old_rec.ecc_attribute4;
432: End If;
433: If (p_rec.ecc_attribute5 = hr_api.g_varchar2) then
434: p_rec.ecc_attribute5 :=
435: ben_ecc_shd.g_old_rec.ecc_attribute5;
436: End If;
437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then
438: p_rec.ecc_attribute6 :=
439: ben_ecc_shd.g_old_rec.ecc_attribute6;
435: ben_ecc_shd.g_old_rec.ecc_attribute5;
436: End If;
437: If (p_rec.ecc_attribute6 = hr_api.g_varchar2) then
438: p_rec.ecc_attribute6 :=
439: ben_ecc_shd.g_old_rec.ecc_attribute6;
440: End If;
441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then
442: p_rec.ecc_attribute7 :=
443: ben_ecc_shd.g_old_rec.ecc_attribute7;
439: ben_ecc_shd.g_old_rec.ecc_attribute6;
440: End If;
441: If (p_rec.ecc_attribute7 = hr_api.g_varchar2) then
442: p_rec.ecc_attribute7 :=
443: ben_ecc_shd.g_old_rec.ecc_attribute7;
444: End If;
445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then
446: p_rec.ecc_attribute8 :=
447: ben_ecc_shd.g_old_rec.ecc_attribute8;
443: ben_ecc_shd.g_old_rec.ecc_attribute7;
444: End If;
445: If (p_rec.ecc_attribute8 = hr_api.g_varchar2) then
446: p_rec.ecc_attribute8 :=
447: ben_ecc_shd.g_old_rec.ecc_attribute8;
448: End If;
449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then
450: p_rec.ecc_attribute9 :=
451: ben_ecc_shd.g_old_rec.ecc_attribute9;
447: ben_ecc_shd.g_old_rec.ecc_attribute8;
448: End If;
449: If (p_rec.ecc_attribute9 = hr_api.g_varchar2) then
450: p_rec.ecc_attribute9 :=
451: ben_ecc_shd.g_old_rec.ecc_attribute9;
452: End If;
453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then
454: p_rec.ecc_attribute10 :=
455: ben_ecc_shd.g_old_rec.ecc_attribute10;
451: ben_ecc_shd.g_old_rec.ecc_attribute9;
452: End If;
453: If (p_rec.ecc_attribute10 = hr_api.g_varchar2) then
454: p_rec.ecc_attribute10 :=
455: ben_ecc_shd.g_old_rec.ecc_attribute10;
456: End If;
457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then
458: p_rec.ecc_attribute11 :=
459: ben_ecc_shd.g_old_rec.ecc_attribute11;
455: ben_ecc_shd.g_old_rec.ecc_attribute10;
456: End If;
457: If (p_rec.ecc_attribute11 = hr_api.g_varchar2) then
458: p_rec.ecc_attribute11 :=
459: ben_ecc_shd.g_old_rec.ecc_attribute11;
460: End If;
461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then
462: p_rec.ecc_attribute12 :=
463: ben_ecc_shd.g_old_rec.ecc_attribute12;
459: ben_ecc_shd.g_old_rec.ecc_attribute11;
460: End If;
461: If (p_rec.ecc_attribute12 = hr_api.g_varchar2) then
462: p_rec.ecc_attribute12 :=
463: ben_ecc_shd.g_old_rec.ecc_attribute12;
464: End If;
465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then
466: p_rec.ecc_attribute13 :=
467: ben_ecc_shd.g_old_rec.ecc_attribute13;
463: ben_ecc_shd.g_old_rec.ecc_attribute12;
464: End If;
465: If (p_rec.ecc_attribute13 = hr_api.g_varchar2) then
466: p_rec.ecc_attribute13 :=
467: ben_ecc_shd.g_old_rec.ecc_attribute13;
468: End If;
469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then
470: p_rec.ecc_attribute14 :=
471: ben_ecc_shd.g_old_rec.ecc_attribute14;
467: ben_ecc_shd.g_old_rec.ecc_attribute13;
468: End If;
469: If (p_rec.ecc_attribute14 = hr_api.g_varchar2) then
470: p_rec.ecc_attribute14 :=
471: ben_ecc_shd.g_old_rec.ecc_attribute14;
472: End If;
473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then
474: p_rec.ecc_attribute15 :=
475: ben_ecc_shd.g_old_rec.ecc_attribute15;
471: ben_ecc_shd.g_old_rec.ecc_attribute14;
472: End If;
473: If (p_rec.ecc_attribute15 = hr_api.g_varchar2) then
474: p_rec.ecc_attribute15 :=
475: ben_ecc_shd.g_old_rec.ecc_attribute15;
476: End If;
477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then
478: p_rec.ecc_attribute16 :=
479: ben_ecc_shd.g_old_rec.ecc_attribute16;
475: ben_ecc_shd.g_old_rec.ecc_attribute15;
476: End If;
477: If (p_rec.ecc_attribute16 = hr_api.g_varchar2) then
478: p_rec.ecc_attribute16 :=
479: ben_ecc_shd.g_old_rec.ecc_attribute16;
480: End If;
481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then
482: p_rec.ecc_attribute17 :=
483: ben_ecc_shd.g_old_rec.ecc_attribute17;
479: ben_ecc_shd.g_old_rec.ecc_attribute16;
480: End If;
481: If (p_rec.ecc_attribute17 = hr_api.g_varchar2) then
482: p_rec.ecc_attribute17 :=
483: ben_ecc_shd.g_old_rec.ecc_attribute17;
484: End If;
485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then
486: p_rec.ecc_attribute18 :=
487: ben_ecc_shd.g_old_rec.ecc_attribute18;
483: ben_ecc_shd.g_old_rec.ecc_attribute17;
484: End If;
485: If (p_rec.ecc_attribute18 = hr_api.g_varchar2) then
486: p_rec.ecc_attribute18 :=
487: ben_ecc_shd.g_old_rec.ecc_attribute18;
488: End If;
489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then
490: p_rec.ecc_attribute19 :=
491: ben_ecc_shd.g_old_rec.ecc_attribute19;
487: ben_ecc_shd.g_old_rec.ecc_attribute18;
488: End If;
489: If (p_rec.ecc_attribute19 = hr_api.g_varchar2) then
490: p_rec.ecc_attribute19 :=
491: ben_ecc_shd.g_old_rec.ecc_attribute19;
492: End If;
493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then
494: p_rec.ecc_attribute20 :=
495: ben_ecc_shd.g_old_rec.ecc_attribute20;
491: ben_ecc_shd.g_old_rec.ecc_attribute19;
492: End If;
493: If (p_rec.ecc_attribute20 = hr_api.g_varchar2) then
494: p_rec.ecc_attribute20 :=
495: ben_ecc_shd.g_old_rec.ecc_attribute20;
496: End If;
497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then
498: p_rec.ecc_attribute21 :=
499: ben_ecc_shd.g_old_rec.ecc_attribute21;
495: ben_ecc_shd.g_old_rec.ecc_attribute20;
496: End If;
497: If (p_rec.ecc_attribute21 = hr_api.g_varchar2) then
498: p_rec.ecc_attribute21 :=
499: ben_ecc_shd.g_old_rec.ecc_attribute21;
500: End If;
501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then
502: p_rec.ecc_attribute22 :=
503: ben_ecc_shd.g_old_rec.ecc_attribute22;
499: ben_ecc_shd.g_old_rec.ecc_attribute21;
500: End If;
501: If (p_rec.ecc_attribute22 = hr_api.g_varchar2) then
502: p_rec.ecc_attribute22 :=
503: ben_ecc_shd.g_old_rec.ecc_attribute22;
504: End If;
505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then
506: p_rec.ecc_attribute23 :=
507: ben_ecc_shd.g_old_rec.ecc_attribute23;
503: ben_ecc_shd.g_old_rec.ecc_attribute22;
504: End If;
505: If (p_rec.ecc_attribute23 = hr_api.g_varchar2) then
506: p_rec.ecc_attribute23 :=
507: ben_ecc_shd.g_old_rec.ecc_attribute23;
508: End If;
509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then
510: p_rec.ecc_attribute24 :=
511: ben_ecc_shd.g_old_rec.ecc_attribute24;
507: ben_ecc_shd.g_old_rec.ecc_attribute23;
508: End If;
509: If (p_rec.ecc_attribute24 = hr_api.g_varchar2) then
510: p_rec.ecc_attribute24 :=
511: ben_ecc_shd.g_old_rec.ecc_attribute24;
512: End If;
513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then
514: p_rec.ecc_attribute25 :=
515: ben_ecc_shd.g_old_rec.ecc_attribute25;
511: ben_ecc_shd.g_old_rec.ecc_attribute24;
512: End If;
513: If (p_rec.ecc_attribute25 = hr_api.g_varchar2) then
514: p_rec.ecc_attribute25 :=
515: ben_ecc_shd.g_old_rec.ecc_attribute25;
516: End If;
517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then
518: p_rec.ecc_attribute26 :=
519: ben_ecc_shd.g_old_rec.ecc_attribute26;
515: ben_ecc_shd.g_old_rec.ecc_attribute25;
516: End If;
517: If (p_rec.ecc_attribute26 = hr_api.g_varchar2) then
518: p_rec.ecc_attribute26 :=
519: ben_ecc_shd.g_old_rec.ecc_attribute26;
520: End If;
521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then
522: p_rec.ecc_attribute27 :=
523: ben_ecc_shd.g_old_rec.ecc_attribute27;
519: ben_ecc_shd.g_old_rec.ecc_attribute26;
520: End If;
521: If (p_rec.ecc_attribute27 = hr_api.g_varchar2) then
522: p_rec.ecc_attribute27 :=
523: ben_ecc_shd.g_old_rec.ecc_attribute27;
524: End If;
525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then
526: p_rec.ecc_attribute28 :=
527: ben_ecc_shd.g_old_rec.ecc_attribute28;
523: ben_ecc_shd.g_old_rec.ecc_attribute27;
524: End If;
525: If (p_rec.ecc_attribute28 = hr_api.g_varchar2) then
526: p_rec.ecc_attribute28 :=
527: ben_ecc_shd.g_old_rec.ecc_attribute28;
528: End If;
529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then
530: p_rec.ecc_attribute29 :=
531: ben_ecc_shd.g_old_rec.ecc_attribute29;
527: ben_ecc_shd.g_old_rec.ecc_attribute28;
528: End If;
529: If (p_rec.ecc_attribute29 = hr_api.g_varchar2) then
530: p_rec.ecc_attribute29 :=
531: ben_ecc_shd.g_old_rec.ecc_attribute29;
532: End If;
533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then
534: p_rec.ecc_attribute30 :=
535: ben_ecc_shd.g_old_rec.ecc_attribute30;
531: ben_ecc_shd.g_old_rec.ecc_attribute29;
532: End If;
533: If (p_rec.ecc_attribute30 = hr_api.g_varchar2) then
534: p_rec.ecc_attribute30 :=
535: ben_ecc_shd.g_old_rec.ecc_attribute30;
536: End If;
537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
538: p_rec.susp_if_ctfn_not_prvd_flag :=
539: ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
535: ben_ecc_shd.g_old_rec.ecc_attribute30;
536: End If;
537: If (p_rec.susp_if_ctfn_not_prvd_flag = hr_api.g_varchar2) then
538: p_rec.susp_if_ctfn_not_prvd_flag :=
539: ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
540: End If;
541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
542: p_rec.ctfn_determine_cd :=
543: ben_ecc_shd.g_old_rec.ctfn_determine_cd;
539: ben_ecc_shd.g_old_rec.susp_if_ctfn_not_prvd_flag;
540: End If;
541: If (p_rec.ctfn_determine_cd = hr_api.g_varchar2) then
542: p_rec.ctfn_determine_cd :=
543: ben_ecc_shd.g_old_rec.ctfn_determine_cd;
544: End If;
545: If (p_rec.request_id = hr_api.g_number) then
546: p_rec.request_id :=
547: ben_ecc_shd.g_old_rec.request_id;
543: ben_ecc_shd.g_old_rec.ctfn_determine_cd;
544: End If;
545: If (p_rec.request_id = hr_api.g_number) then
546: p_rec.request_id :=
547: ben_ecc_shd.g_old_rec.request_id;
548: End If;
549: If (p_rec.program_application_id = hr_api.g_number) then
550: p_rec.program_application_id :=
551: ben_ecc_shd.g_old_rec.program_application_id;
547: ben_ecc_shd.g_old_rec.request_id;
548: End If;
549: If (p_rec.program_application_id = hr_api.g_number) then
550: p_rec.program_application_id :=
551: ben_ecc_shd.g_old_rec.program_application_id;
552: End If;
553: If (p_rec.program_id = hr_api.g_number) then
554: p_rec.program_id :=
555: ben_ecc_shd.g_old_rec.program_id;
551: ben_ecc_shd.g_old_rec.program_application_id;
552: End If;
553: If (p_rec.program_id = hr_api.g_number) then
554: p_rec.program_id :=
555: ben_ecc_shd.g_old_rec.program_id;
556: End If;
557: If (p_rec.program_update_date = hr_api.g_date) then
558: p_rec.program_update_date :=
559: ben_ecc_shd.g_old_rec.program_update_date;
555: ben_ecc_shd.g_old_rec.program_id;
556: End If;
557: If (p_rec.program_update_date = hr_api.g_date) then
558: p_rec.program_update_date :=
559: ben_ecc_shd.g_old_rec.program_update_date;
560: End If;
561:
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 10);
569: -- ----------------------------------------------------------------------------
570: Procedure upd
571: (
572: p_effective_date in date,
573: p_rec in out nocopy ben_ecc_shd.g_rec_type
574: ) is
575: --
576: l_proc varchar2(72) := g_package||'upd';
577: --
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- We must lock the row which we need to update.
582: --
583: ben_ecc_shd.lck
584: (
585: p_rec.elctbl_chc_ctfn_id,
586: p_rec.object_version_number
587: );
661: p_program_update_date in date default hr_api.g_date,
662: p_object_version_number in out nocopy number
663: ) is
664: --
665: l_rec ben_ecc_shd.g_rec_type;
666: l_proc varchar2(72) := g_package||'upd';
667: --
668: Begin
669: hr_utility.set_location('Entering:'||l_proc, 5);
671: -- Call conversion function to turn arguments into the
672: -- l_rec structure.
673: --
674: l_rec :=
675: ben_ecc_shd.convert_args
676: (
677: p_elctbl_chc_ctfn_id,
678: p_enrt_ctfn_typ_cd,
679: p_rqd_flag,