[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_xrc_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_xrc_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_ext_rcd Row
68: --
69: update ben_ext_rcd
111: last_update_login = p_rec.last_update_login,
112: object_version_number = p_rec.object_version_number
113: where ext_rcd_id = p_rec.ext_rcd_id;
114: --
115: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
116: --
117: hr_utility.set_location(' Leaving:'||l_proc, 10);
118: --
119: Exception
118: --
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
123: ben_xrc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
119: Exception
120: When hr_api.check_integrity_violated Then
121: -- A check constraint has been violated
122: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
123: ben_xrc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
123: ben_xrc_shd.constraint_error
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
128: ben_xrc_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
124: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
125: When hr_api.parent_integrity_violated Then
126: -- Parent integrity has been violated
127: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
128: ben_xrc_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
128: ben_xrc_shd.constraint_error
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
133: ben_xrc_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
129: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
130: When hr_api.unique_integrity_violated Then
131: -- Unique integrity has been violated
132: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
133: ben_xrc_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
137: Raise;
132: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
133: ben_xrc_shd.constraint_error
134: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
135: When Others Then
136: ben_xrc_shd.g_api_dml := false; -- Unset the api dml status
137: Raise;
138: End update_dml;
139: --
140: -- ----------------------------------------------------------------------------
168: -- Internal Row Handler Use Only.
169: --
170: -- {End Of Comments}
171: -- ----------------------------------------------------------------------------
172: Procedure pre_update(p_rec in ben_xrc_shd.g_rec_type) is
173: --
174: l_proc varchar2(72) := g_package||'pre_update';
175: --
176: Begin
211: --
212: -- {End Of Comments}
213: -- ----------------------------------------------------------------------------
214: Procedure post_update(
215: p_effective_date in date,p_rec in ben_xrc_shd.g_rec_type) is
216: --
217: l_proc varchar2(72) := g_package||'post_update';
218: --
219: Begin
265: ,p_xrc_attribute29 =>p_rec.xrc_attribute29
266: ,p_xrc_attribute30 =>p_rec.xrc_attribute30
267: ,p_object_version_number =>p_rec.object_version_number
268: ,p_effective_date =>p_effective_date
269: ,p_name_o =>ben_xrc_shd.g_old_rec.name
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
266: ,p_xrc_attribute30 =>p_rec.xrc_attribute30
267: ,p_object_version_number =>p_rec.object_version_number
268: ,p_effective_date =>p_effective_date
269: ,p_name_o =>ben_xrc_shd.g_old_rec.name
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
267: ,p_object_version_number =>p_rec.object_version_number
268: ,p_effective_date =>p_effective_date
269: ,p_name_o =>ben_xrc_shd.g_old_rec.name
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
268: ,p_effective_date =>p_effective_date
269: ,p_name_o =>ben_xrc_shd.g_old_rec.name
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
269: ,p_name_o =>ben_xrc_shd.g_old_rec.name
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
270: ,p_xml_tag_name_o =>ben_xrc_shd.g_old_rec.xml_tag_name
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
271: ,p_rcd_type_cd_o =>ben_xrc_shd.g_old_rec.rcd_type_cd
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
272: ,p_low_lvl_cd_o =>ben_xrc_shd.g_old_rec.low_lvl_cd
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
273: ,p_business_group_id_o =>ben_xrc_shd.g_old_rec.business_group_id
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
274: ,p_legislation_code_o =>ben_xrc_shd.g_old_rec.legislation_code
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
275: ,p_xrc_attribute_category_o =>ben_xrc_shd.g_old_rec.xrc_attribute_category
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
276: ,p_xrc_attribute1_o =>ben_xrc_shd.g_old_rec.xrc_attribute1
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
277: ,p_xrc_attribute2_o =>ben_xrc_shd.g_old_rec.xrc_attribute2
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
278: ,p_xrc_attribute3_o =>ben_xrc_shd.g_old_rec.xrc_attribute3
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
279: ,p_xrc_attribute4_o =>ben_xrc_shd.g_old_rec.xrc_attribute4
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
280: ,p_xrc_attribute5_o =>ben_xrc_shd.g_old_rec.xrc_attribute5
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
281: ,p_xrc_attribute6_o =>ben_xrc_shd.g_old_rec.xrc_attribute6
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
282: ,p_xrc_attribute7_o =>ben_xrc_shd.g_old_rec.xrc_attribute7
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
283: ,p_xrc_attribute8_o =>ben_xrc_shd.g_old_rec.xrc_attribute8
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
284: ,p_xrc_attribute9_o =>ben_xrc_shd.g_old_rec.xrc_attribute9
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
285: ,p_xrc_attribute10_o =>ben_xrc_shd.g_old_rec.xrc_attribute10
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
286: ,p_xrc_attribute11_o =>ben_xrc_shd.g_old_rec.xrc_attribute11
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
287: ,p_xrc_attribute12_o =>ben_xrc_shd.g_old_rec.xrc_attribute12
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
288: ,p_xrc_attribute13_o =>ben_xrc_shd.g_old_rec.xrc_attribute13
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
289: ,p_xrc_attribute14_o =>ben_xrc_shd.g_old_rec.xrc_attribute14
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
290: ,p_xrc_attribute15_o =>ben_xrc_shd.g_old_rec.xrc_attribute15
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
291: ,p_xrc_attribute16_o =>ben_xrc_shd.g_old_rec.xrc_attribute16
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
292: ,p_xrc_attribute17_o =>ben_xrc_shd.g_old_rec.xrc_attribute17
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
293: ,p_xrc_attribute18_o =>ben_xrc_shd.g_old_rec.xrc_attribute18
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
294: ,p_xrc_attribute19_o =>ben_xrc_shd.g_old_rec.xrc_attribute19
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
295: ,p_xrc_attribute20_o =>ben_xrc_shd.g_old_rec.xrc_attribute20
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
296: ,p_xrc_attribute21_o =>ben_xrc_shd.g_old_rec.xrc_attribute21
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
297: ,p_xrc_attribute22_o =>ben_xrc_shd.g_old_rec.xrc_attribute22
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
298: ,p_xrc_attribute23_o =>ben_xrc_shd.g_old_rec.xrc_attribute23
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
306: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
299: ,p_xrc_attribute24_o =>ben_xrc_shd.g_old_rec.xrc_attribute24
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
306: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
307: );
300: ,p_xrc_attribute25_o =>ben_xrc_shd.g_old_rec.xrc_attribute25
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
306: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
307: );
308: --
301: ,p_xrc_attribute26_o =>ben_xrc_shd.g_old_rec.xrc_attribute26
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
306: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
307: );
308: --
309: exception
302: ,p_xrc_attribute27_o =>ben_xrc_shd.g_old_rec.xrc_attribute27
303: ,p_xrc_attribute28_o =>ben_xrc_shd.g_old_rec.xrc_attribute28
304: ,p_xrc_attribute29_o =>ben_xrc_shd.g_old_rec.xrc_attribute29
305: ,p_xrc_attribute30_o =>ben_xrc_shd.g_old_rec.xrc_attribute30
306: ,p_object_version_number_o =>ben_xrc_shd.g_old_rec.object_version_number
307: );
308: --
309: exception
310: --
364: -- Internal Row Handler Use Only.
365: --
366: -- {End Of Comments}
367: -- ----------------------------------------------------------------------------
368: Procedure convert_defs(p_rec in out nocopy ben_xrc_shd.g_rec_type) is
369: --
370: l_proc varchar2(72) := g_package||'convert_defs';
371: --
372: Begin
379: -- is being used then we must set to the 'current' argument value.
380: --
381: If (p_rec.name = hr_api.g_varchar2) then
382: p_rec.name :=
383: ben_xrc_shd.g_old_rec.name;
384: End If;
385:
386: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
387: p_rec.xml_tag_name :=
384: End If;
385:
386: If (p_rec.xml_tag_name = hr_api.g_varchar2) then
387: p_rec.xml_tag_name :=
388: ben_xrc_shd.g_old_rec.xml_tag_name;
389: End If;
390: If (p_rec.rcd_type_cd = hr_api.g_varchar2) then
391: p_rec.rcd_type_cd :=
392: ben_xrc_shd.g_old_rec.rcd_type_cd;
388: ben_xrc_shd.g_old_rec.xml_tag_name;
389: End If;
390: If (p_rec.rcd_type_cd = hr_api.g_varchar2) then
391: p_rec.rcd_type_cd :=
392: ben_xrc_shd.g_old_rec.rcd_type_cd;
393: End If;
394: If (p_rec.low_lvl_cd = hr_api.g_varchar2) then
395: p_rec.low_lvl_cd :=
396: ben_xrc_shd.g_old_rec.low_lvl_cd;
392: ben_xrc_shd.g_old_rec.rcd_type_cd;
393: End If;
394: If (p_rec.low_lvl_cd = hr_api.g_varchar2) then
395: p_rec.low_lvl_cd :=
396: ben_xrc_shd.g_old_rec.low_lvl_cd;
397: End If;
398: If (p_rec.business_group_id = hr_api.g_number) then
399: p_rec.business_group_id :=
400: ben_xrc_shd.g_old_rec.business_group_id;
396: ben_xrc_shd.g_old_rec.low_lvl_cd;
397: End If;
398: If (p_rec.business_group_id = hr_api.g_number) then
399: p_rec.business_group_id :=
400: ben_xrc_shd.g_old_rec.business_group_id;
401: End If;
402: If (p_rec.legislation_code = hr_api.g_varchar2) then
403: p_rec.legislation_code :=
404: ben_xrc_shd.g_old_rec.legislation_code;
400: ben_xrc_shd.g_old_rec.business_group_id;
401: End If;
402: If (p_rec.legislation_code = hr_api.g_varchar2) then
403: p_rec.legislation_code :=
404: ben_xrc_shd.g_old_rec.legislation_code;
405: End If;
406: If (p_rec.xrc_attribute_category = hr_api.g_varchar2) then
407: p_rec.xrc_attribute_category :=
408: ben_xrc_shd.g_old_rec.xrc_attribute_category;
404: ben_xrc_shd.g_old_rec.legislation_code;
405: End If;
406: If (p_rec.xrc_attribute_category = hr_api.g_varchar2) then
407: p_rec.xrc_attribute_category :=
408: ben_xrc_shd.g_old_rec.xrc_attribute_category;
409: End If;
410: If (p_rec.xrc_attribute1 = hr_api.g_varchar2) then
411: p_rec.xrc_attribute1 :=
412: ben_xrc_shd.g_old_rec.xrc_attribute1;
408: ben_xrc_shd.g_old_rec.xrc_attribute_category;
409: End If;
410: If (p_rec.xrc_attribute1 = hr_api.g_varchar2) then
411: p_rec.xrc_attribute1 :=
412: ben_xrc_shd.g_old_rec.xrc_attribute1;
413: End If;
414: If (p_rec.xrc_attribute2 = hr_api.g_varchar2) then
415: p_rec.xrc_attribute2 :=
416: ben_xrc_shd.g_old_rec.xrc_attribute2;
412: ben_xrc_shd.g_old_rec.xrc_attribute1;
413: End If;
414: If (p_rec.xrc_attribute2 = hr_api.g_varchar2) then
415: p_rec.xrc_attribute2 :=
416: ben_xrc_shd.g_old_rec.xrc_attribute2;
417: End If;
418: If (p_rec.xrc_attribute3 = hr_api.g_varchar2) then
419: p_rec.xrc_attribute3 :=
420: ben_xrc_shd.g_old_rec.xrc_attribute3;
416: ben_xrc_shd.g_old_rec.xrc_attribute2;
417: End If;
418: If (p_rec.xrc_attribute3 = hr_api.g_varchar2) then
419: p_rec.xrc_attribute3 :=
420: ben_xrc_shd.g_old_rec.xrc_attribute3;
421: End If;
422: If (p_rec.xrc_attribute4 = hr_api.g_varchar2) then
423: p_rec.xrc_attribute4 :=
424: ben_xrc_shd.g_old_rec.xrc_attribute4;
420: ben_xrc_shd.g_old_rec.xrc_attribute3;
421: End If;
422: If (p_rec.xrc_attribute4 = hr_api.g_varchar2) then
423: p_rec.xrc_attribute4 :=
424: ben_xrc_shd.g_old_rec.xrc_attribute4;
425: End If;
426: If (p_rec.xrc_attribute5 = hr_api.g_varchar2) then
427: p_rec.xrc_attribute5 :=
428: ben_xrc_shd.g_old_rec.xrc_attribute5;
424: ben_xrc_shd.g_old_rec.xrc_attribute4;
425: End If;
426: If (p_rec.xrc_attribute5 = hr_api.g_varchar2) then
427: p_rec.xrc_attribute5 :=
428: ben_xrc_shd.g_old_rec.xrc_attribute5;
429: End If;
430: If (p_rec.xrc_attribute6 = hr_api.g_varchar2) then
431: p_rec.xrc_attribute6 :=
432: ben_xrc_shd.g_old_rec.xrc_attribute6;
428: ben_xrc_shd.g_old_rec.xrc_attribute5;
429: End If;
430: If (p_rec.xrc_attribute6 = hr_api.g_varchar2) then
431: p_rec.xrc_attribute6 :=
432: ben_xrc_shd.g_old_rec.xrc_attribute6;
433: End If;
434: If (p_rec.xrc_attribute7 = hr_api.g_varchar2) then
435: p_rec.xrc_attribute7 :=
436: ben_xrc_shd.g_old_rec.xrc_attribute7;
432: ben_xrc_shd.g_old_rec.xrc_attribute6;
433: End If;
434: If (p_rec.xrc_attribute7 = hr_api.g_varchar2) then
435: p_rec.xrc_attribute7 :=
436: ben_xrc_shd.g_old_rec.xrc_attribute7;
437: End If;
438: If (p_rec.xrc_attribute8 = hr_api.g_varchar2) then
439: p_rec.xrc_attribute8 :=
440: ben_xrc_shd.g_old_rec.xrc_attribute8;
436: ben_xrc_shd.g_old_rec.xrc_attribute7;
437: End If;
438: If (p_rec.xrc_attribute8 = hr_api.g_varchar2) then
439: p_rec.xrc_attribute8 :=
440: ben_xrc_shd.g_old_rec.xrc_attribute8;
441: End If;
442: If (p_rec.xrc_attribute9 = hr_api.g_varchar2) then
443: p_rec.xrc_attribute9 :=
444: ben_xrc_shd.g_old_rec.xrc_attribute9;
440: ben_xrc_shd.g_old_rec.xrc_attribute8;
441: End If;
442: If (p_rec.xrc_attribute9 = hr_api.g_varchar2) then
443: p_rec.xrc_attribute9 :=
444: ben_xrc_shd.g_old_rec.xrc_attribute9;
445: End If;
446: If (p_rec.xrc_attribute10 = hr_api.g_varchar2) then
447: p_rec.xrc_attribute10 :=
448: ben_xrc_shd.g_old_rec.xrc_attribute10;
444: ben_xrc_shd.g_old_rec.xrc_attribute9;
445: End If;
446: If (p_rec.xrc_attribute10 = hr_api.g_varchar2) then
447: p_rec.xrc_attribute10 :=
448: ben_xrc_shd.g_old_rec.xrc_attribute10;
449: End If;
450: If (p_rec.xrc_attribute11 = hr_api.g_varchar2) then
451: p_rec.xrc_attribute11 :=
452: ben_xrc_shd.g_old_rec.xrc_attribute11;
448: ben_xrc_shd.g_old_rec.xrc_attribute10;
449: End If;
450: If (p_rec.xrc_attribute11 = hr_api.g_varchar2) then
451: p_rec.xrc_attribute11 :=
452: ben_xrc_shd.g_old_rec.xrc_attribute11;
453: End If;
454: If (p_rec.xrc_attribute12 = hr_api.g_varchar2) then
455: p_rec.xrc_attribute12 :=
456: ben_xrc_shd.g_old_rec.xrc_attribute12;
452: ben_xrc_shd.g_old_rec.xrc_attribute11;
453: End If;
454: If (p_rec.xrc_attribute12 = hr_api.g_varchar2) then
455: p_rec.xrc_attribute12 :=
456: ben_xrc_shd.g_old_rec.xrc_attribute12;
457: End If;
458: If (p_rec.xrc_attribute13 = hr_api.g_varchar2) then
459: p_rec.xrc_attribute13 :=
460: ben_xrc_shd.g_old_rec.xrc_attribute13;
456: ben_xrc_shd.g_old_rec.xrc_attribute12;
457: End If;
458: If (p_rec.xrc_attribute13 = hr_api.g_varchar2) then
459: p_rec.xrc_attribute13 :=
460: ben_xrc_shd.g_old_rec.xrc_attribute13;
461: End If;
462: If (p_rec.xrc_attribute14 = hr_api.g_varchar2) then
463: p_rec.xrc_attribute14 :=
464: ben_xrc_shd.g_old_rec.xrc_attribute14;
460: ben_xrc_shd.g_old_rec.xrc_attribute13;
461: End If;
462: If (p_rec.xrc_attribute14 = hr_api.g_varchar2) then
463: p_rec.xrc_attribute14 :=
464: ben_xrc_shd.g_old_rec.xrc_attribute14;
465: End If;
466: If (p_rec.xrc_attribute15 = hr_api.g_varchar2) then
467: p_rec.xrc_attribute15 :=
468: ben_xrc_shd.g_old_rec.xrc_attribute15;
464: ben_xrc_shd.g_old_rec.xrc_attribute14;
465: End If;
466: If (p_rec.xrc_attribute15 = hr_api.g_varchar2) then
467: p_rec.xrc_attribute15 :=
468: ben_xrc_shd.g_old_rec.xrc_attribute15;
469: End If;
470: If (p_rec.xrc_attribute16 = hr_api.g_varchar2) then
471: p_rec.xrc_attribute16 :=
472: ben_xrc_shd.g_old_rec.xrc_attribute16;
468: ben_xrc_shd.g_old_rec.xrc_attribute15;
469: End If;
470: If (p_rec.xrc_attribute16 = hr_api.g_varchar2) then
471: p_rec.xrc_attribute16 :=
472: ben_xrc_shd.g_old_rec.xrc_attribute16;
473: End If;
474: If (p_rec.xrc_attribute17 = hr_api.g_varchar2) then
475: p_rec.xrc_attribute17 :=
476: ben_xrc_shd.g_old_rec.xrc_attribute17;
472: ben_xrc_shd.g_old_rec.xrc_attribute16;
473: End If;
474: If (p_rec.xrc_attribute17 = hr_api.g_varchar2) then
475: p_rec.xrc_attribute17 :=
476: ben_xrc_shd.g_old_rec.xrc_attribute17;
477: End If;
478: If (p_rec.xrc_attribute18 = hr_api.g_varchar2) then
479: p_rec.xrc_attribute18 :=
480: ben_xrc_shd.g_old_rec.xrc_attribute18;
476: ben_xrc_shd.g_old_rec.xrc_attribute17;
477: End If;
478: If (p_rec.xrc_attribute18 = hr_api.g_varchar2) then
479: p_rec.xrc_attribute18 :=
480: ben_xrc_shd.g_old_rec.xrc_attribute18;
481: End If;
482: If (p_rec.xrc_attribute19 = hr_api.g_varchar2) then
483: p_rec.xrc_attribute19 :=
484: ben_xrc_shd.g_old_rec.xrc_attribute19;
480: ben_xrc_shd.g_old_rec.xrc_attribute18;
481: End If;
482: If (p_rec.xrc_attribute19 = hr_api.g_varchar2) then
483: p_rec.xrc_attribute19 :=
484: ben_xrc_shd.g_old_rec.xrc_attribute19;
485: End If;
486: If (p_rec.xrc_attribute20 = hr_api.g_varchar2) then
487: p_rec.xrc_attribute20 :=
488: ben_xrc_shd.g_old_rec.xrc_attribute20;
484: ben_xrc_shd.g_old_rec.xrc_attribute19;
485: End If;
486: If (p_rec.xrc_attribute20 = hr_api.g_varchar2) then
487: p_rec.xrc_attribute20 :=
488: ben_xrc_shd.g_old_rec.xrc_attribute20;
489: End If;
490: If (p_rec.xrc_attribute21 = hr_api.g_varchar2) then
491: p_rec.xrc_attribute21 :=
492: ben_xrc_shd.g_old_rec.xrc_attribute21;
488: ben_xrc_shd.g_old_rec.xrc_attribute20;
489: End If;
490: If (p_rec.xrc_attribute21 = hr_api.g_varchar2) then
491: p_rec.xrc_attribute21 :=
492: ben_xrc_shd.g_old_rec.xrc_attribute21;
493: End If;
494: If (p_rec.xrc_attribute22 = hr_api.g_varchar2) then
495: p_rec.xrc_attribute22 :=
496: ben_xrc_shd.g_old_rec.xrc_attribute22;
492: ben_xrc_shd.g_old_rec.xrc_attribute21;
493: End If;
494: If (p_rec.xrc_attribute22 = hr_api.g_varchar2) then
495: p_rec.xrc_attribute22 :=
496: ben_xrc_shd.g_old_rec.xrc_attribute22;
497: End If;
498: If (p_rec.xrc_attribute23 = hr_api.g_varchar2) then
499: p_rec.xrc_attribute23 :=
500: ben_xrc_shd.g_old_rec.xrc_attribute23;
496: ben_xrc_shd.g_old_rec.xrc_attribute22;
497: End If;
498: If (p_rec.xrc_attribute23 = hr_api.g_varchar2) then
499: p_rec.xrc_attribute23 :=
500: ben_xrc_shd.g_old_rec.xrc_attribute23;
501: End If;
502: If (p_rec.xrc_attribute24 = hr_api.g_varchar2) then
503: p_rec.xrc_attribute24 :=
504: ben_xrc_shd.g_old_rec.xrc_attribute24;
500: ben_xrc_shd.g_old_rec.xrc_attribute23;
501: End If;
502: If (p_rec.xrc_attribute24 = hr_api.g_varchar2) then
503: p_rec.xrc_attribute24 :=
504: ben_xrc_shd.g_old_rec.xrc_attribute24;
505: End If;
506: If (p_rec.xrc_attribute25 = hr_api.g_varchar2) then
507: p_rec.xrc_attribute25 :=
508: ben_xrc_shd.g_old_rec.xrc_attribute25;
504: ben_xrc_shd.g_old_rec.xrc_attribute24;
505: End If;
506: If (p_rec.xrc_attribute25 = hr_api.g_varchar2) then
507: p_rec.xrc_attribute25 :=
508: ben_xrc_shd.g_old_rec.xrc_attribute25;
509: End If;
510: If (p_rec.xrc_attribute26 = hr_api.g_varchar2) then
511: p_rec.xrc_attribute26 :=
512: ben_xrc_shd.g_old_rec.xrc_attribute26;
508: ben_xrc_shd.g_old_rec.xrc_attribute25;
509: End If;
510: If (p_rec.xrc_attribute26 = hr_api.g_varchar2) then
511: p_rec.xrc_attribute26 :=
512: ben_xrc_shd.g_old_rec.xrc_attribute26;
513: End If;
514: If (p_rec.xrc_attribute27 = hr_api.g_varchar2) then
515: p_rec.xrc_attribute27 :=
516: ben_xrc_shd.g_old_rec.xrc_attribute27;
512: ben_xrc_shd.g_old_rec.xrc_attribute26;
513: End If;
514: If (p_rec.xrc_attribute27 = hr_api.g_varchar2) then
515: p_rec.xrc_attribute27 :=
516: ben_xrc_shd.g_old_rec.xrc_attribute27;
517: End If;
518: If (p_rec.xrc_attribute28 = hr_api.g_varchar2) then
519: p_rec.xrc_attribute28 :=
520: ben_xrc_shd.g_old_rec.xrc_attribute28;
516: ben_xrc_shd.g_old_rec.xrc_attribute27;
517: End If;
518: If (p_rec.xrc_attribute28 = hr_api.g_varchar2) then
519: p_rec.xrc_attribute28 :=
520: ben_xrc_shd.g_old_rec.xrc_attribute28;
521: End If;
522: If (p_rec.xrc_attribute29 = hr_api.g_varchar2) then
523: p_rec.xrc_attribute29 :=
524: ben_xrc_shd.g_old_rec.xrc_attribute29;
520: ben_xrc_shd.g_old_rec.xrc_attribute28;
521: End If;
522: If (p_rec.xrc_attribute29 = hr_api.g_varchar2) then
523: p_rec.xrc_attribute29 :=
524: ben_xrc_shd.g_old_rec.xrc_attribute29;
525: End If;
526: If (p_rec.xrc_attribute30 = hr_api.g_varchar2) then
527: p_rec.xrc_attribute30 :=
528: ben_xrc_shd.g_old_rec.xrc_attribute30;
524: ben_xrc_shd.g_old_rec.xrc_attribute29;
525: End If;
526: If (p_rec.xrc_attribute30 = hr_api.g_varchar2) then
527: p_rec.xrc_attribute30 :=
528: ben_xrc_shd.g_old_rec.xrc_attribute30;
529: End If;
530:
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
538: -- ----------------------------------------------------------------------------
539: Procedure upd
540: (
541: p_effective_date in date,
542: p_rec in out nocopy ben_xrc_shd.g_rec_type
543: ) is
544: --
545: l_proc varchar2(72) := g_package||'upd';
546: --
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: -- We must lock the row which we need to update.
551: --
552: ben_xrc_shd.lck
553: (
554: p_rec.ext_rcd_id,
555: p_rec.object_version_number
556: );
634: p_created_by in number default hr_api.g_number,
635: p_object_version_number in out nocopy number
636: ) is
637: --
638: l_rec ben_xrc_shd.g_rec_type;
639: l_proc varchar2(72) := g_package||'upd';
640: --
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
644: -- Call conversion function to turn arguments into the
645: -- l_rec structure.
646: --
647: l_rec :=
648: ben_xrc_shd.convert_args
649: (
650: p_ext_rcd_id,
651: p_name,
652: p_xml_tag_name,