[Home] [Help]
50: -- Internal Row Handler Use Only.
51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml(p_rec in out nocopy ben_crd_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_crd_shd.g_api_dml := true; -- Set the api dml status
66: --
67: -- Update the ben_crt_ordr_cvrd_per Row
68: --
69: update ben_crt_ordr_cvrd_per
105: crd_attribute30 = p_rec.crd_attribute30,
106: object_version_number = p_rec.object_version_number
107: where crt_ordr_cvrd_per_id = p_rec.crt_ordr_cvrd_per_id;
108: --
109: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
110: --
111: hr_utility.set_location(' Leaving:'||l_proc, 10);
112: --
113: Exception
112: --
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
117: ben_crd_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
113: Exception
114: When hr_api.check_integrity_violated Then
115: -- A check constraint has been violated
116: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
117: ben_crd_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
117: ben_crd_shd.constraint_error
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
122: ben_crd_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
118: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
119: When hr_api.parent_integrity_violated Then
120: -- Parent integrity has been violated
121: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
122: ben_crd_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
122: ben_crd_shd.constraint_error
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
127: ben_crd_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
123: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
124: When hr_api.unique_integrity_violated Then
125: -- Unique integrity has been violated
126: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
127: ben_crd_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
126: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
127: ben_crd_shd.constraint_error
128: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
129: When Others Then
130: ben_crd_shd.g_api_dml := false; -- Unset the api dml status
131: Raise;
132: End update_dml;
133: --
134: -- ----------------------------------------------------------------------------
162: -- Internal Row Handler Use Only.
163: --
164: -- {End Of Comments}
165: -- ----------------------------------------------------------------------------
166: Procedure pre_update(p_rec in ben_crd_shd.g_rec_type) is
167: --
168: l_proc varchar2(72) := g_package||'pre_update';
169: --
170: Begin
204: -- Internal Row Handler Use Only.
205: --
206: -- {End Of Comments}
207: -- ----------------------------------------------------------------------------
208: Procedure post_update(p_rec in ben_crd_shd.g_rec_type) is
209: --
210: l_proc varchar2(72) := g_package||'post_update';
211: --
212: Begin
254: ,p_crd_attribute28 =>p_rec.crd_attribute28
255: ,p_crd_attribute29 =>p_rec.crd_attribute29
256: ,p_crd_attribute30 =>p_rec.crd_attribute30
257: ,p_object_version_number =>p_rec.object_version_number
258: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
255: ,p_crd_attribute29 =>p_rec.crd_attribute29
256: ,p_crd_attribute30 =>p_rec.crd_attribute30
257: ,p_object_version_number =>p_rec.object_version_number
258: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
256: ,p_crd_attribute30 =>p_rec.crd_attribute30
257: ,p_object_version_number =>p_rec.object_version_number
258: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
257: ,p_object_version_number =>p_rec.object_version_number
258: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
258: ,p_crt_ordr_id_o =>ben_crd_shd.g_old_rec.crt_ordr_id
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
259: ,p_person_id_o =>ben_crd_shd.g_old_rec.person_id
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
260: ,p_business_group_id_o =>ben_crd_shd.g_old_rec.business_group_id
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
261: ,p_crd_attribute_category_o =>ben_crd_shd.g_old_rec.crd_attribute_category
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
262: ,p_crd_attribute1_o =>ben_crd_shd.g_old_rec.crd_attribute1
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
263: ,p_crd_attribute2_o =>ben_crd_shd.g_old_rec.crd_attribute2
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
264: ,p_crd_attribute3_o =>ben_crd_shd.g_old_rec.crd_attribute3
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
265: ,p_crd_attribute4_o =>ben_crd_shd.g_old_rec.crd_attribute4
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
266: ,p_crd_attribute5_o =>ben_crd_shd.g_old_rec.crd_attribute5
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
267: ,p_crd_attribute6_o =>ben_crd_shd.g_old_rec.crd_attribute6
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
268: ,p_crd_attribute7_o =>ben_crd_shd.g_old_rec.crd_attribute7
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
269: ,p_crd_attribute8_o =>ben_crd_shd.g_old_rec.crd_attribute8
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
270: ,p_crd_attribute9_o =>ben_crd_shd.g_old_rec.crd_attribute9
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
271: ,p_crd_attribute10_o =>ben_crd_shd.g_old_rec.crd_attribute10
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
272: ,p_crd_attribute11_o =>ben_crd_shd.g_old_rec.crd_attribute11
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
273: ,p_crd_attribute12_o =>ben_crd_shd.g_old_rec.crd_attribute12
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
274: ,p_crd_attribute13_o =>ben_crd_shd.g_old_rec.crd_attribute13
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
275: ,p_crd_attribute14_o =>ben_crd_shd.g_old_rec.crd_attribute14
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
276: ,p_crd_attribute15_o =>ben_crd_shd.g_old_rec.crd_attribute15
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
277: ,p_crd_attribute16_o =>ben_crd_shd.g_old_rec.crd_attribute16
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
278: ,p_crd_attribute17_o =>ben_crd_shd.g_old_rec.crd_attribute17
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
279: ,p_crd_attribute18_o =>ben_crd_shd.g_old_rec.crd_attribute18
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
280: ,p_crd_attribute19_o =>ben_crd_shd.g_old_rec.crd_attribute19
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
281: ,p_crd_attribute20_o =>ben_crd_shd.g_old_rec.crd_attribute20
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
282: ,p_crd_attribute21_o =>ben_crd_shd.g_old_rec.crd_attribute21
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
283: ,p_crd_attribute22_o =>ben_crd_shd.g_old_rec.crd_attribute22
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
284: ,p_crd_attribute23_o =>ben_crd_shd.g_old_rec.crd_attribute23
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
292: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
285: ,p_crd_attribute24_o =>ben_crd_shd.g_old_rec.crd_attribute24
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
292: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
293: );
286: ,p_crd_attribute25_o =>ben_crd_shd.g_old_rec.crd_attribute25
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
292: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
293: );
294: --
287: ,p_crd_attribute26_o =>ben_crd_shd.g_old_rec.crd_attribute26
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
292: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
293: );
294: --
295: exception
288: ,p_crd_attribute27_o =>ben_crd_shd.g_old_rec.crd_attribute27
289: ,p_crd_attribute28_o =>ben_crd_shd.g_old_rec.crd_attribute28
290: ,p_crd_attribute29_o =>ben_crd_shd.g_old_rec.crd_attribute29
291: ,p_crd_attribute30_o =>ben_crd_shd.g_old_rec.crd_attribute30
292: ,p_object_version_number_o =>ben_crd_shd.g_old_rec.object_version_number
293: );
294: --
295: exception
296: --
350: -- Internal Row Handler Use Only.
351: --
352: -- {End Of Comments}
353: -- ----------------------------------------------------------------------------
354: Procedure convert_defs(p_rec in out nocopy ben_crd_shd.g_rec_type) is
355: --
356: l_proc varchar2(72) := g_package||'convert_defs';
357: --
358: Begin
365: -- is being used then we must set to the 'current' argument value.
366: --
367: If (p_rec.crt_ordr_id = hr_api.g_number) then
368: p_rec.crt_ordr_id :=
369: ben_crd_shd.g_old_rec.crt_ordr_id;
370: End If;
371: If (p_rec.person_id = hr_api.g_number) then
372: p_rec.person_id :=
373: ben_crd_shd.g_old_rec.person_id;
369: ben_crd_shd.g_old_rec.crt_ordr_id;
370: End If;
371: If (p_rec.person_id = hr_api.g_number) then
372: p_rec.person_id :=
373: ben_crd_shd.g_old_rec.person_id;
374: End If;
375: If (p_rec.business_group_id = hr_api.g_number) then
376: p_rec.business_group_id :=
377: ben_crd_shd.g_old_rec.business_group_id;
373: ben_crd_shd.g_old_rec.person_id;
374: End If;
375: If (p_rec.business_group_id = hr_api.g_number) then
376: p_rec.business_group_id :=
377: ben_crd_shd.g_old_rec.business_group_id;
378: End If;
379: If (p_rec.crd_attribute_category = hr_api.g_varchar2) then
380: p_rec.crd_attribute_category :=
381: ben_crd_shd.g_old_rec.crd_attribute_category;
377: ben_crd_shd.g_old_rec.business_group_id;
378: End If;
379: If (p_rec.crd_attribute_category = hr_api.g_varchar2) then
380: p_rec.crd_attribute_category :=
381: ben_crd_shd.g_old_rec.crd_attribute_category;
382: End If;
383: If (p_rec.crd_attribute1 = hr_api.g_varchar2) then
384: p_rec.crd_attribute1 :=
385: ben_crd_shd.g_old_rec.crd_attribute1;
381: ben_crd_shd.g_old_rec.crd_attribute_category;
382: End If;
383: If (p_rec.crd_attribute1 = hr_api.g_varchar2) then
384: p_rec.crd_attribute1 :=
385: ben_crd_shd.g_old_rec.crd_attribute1;
386: End If;
387: If (p_rec.crd_attribute2 = hr_api.g_varchar2) then
388: p_rec.crd_attribute2 :=
389: ben_crd_shd.g_old_rec.crd_attribute2;
385: ben_crd_shd.g_old_rec.crd_attribute1;
386: End If;
387: If (p_rec.crd_attribute2 = hr_api.g_varchar2) then
388: p_rec.crd_attribute2 :=
389: ben_crd_shd.g_old_rec.crd_attribute2;
390: End If;
391: If (p_rec.crd_attribute3 = hr_api.g_varchar2) then
392: p_rec.crd_attribute3 :=
393: ben_crd_shd.g_old_rec.crd_attribute3;
389: ben_crd_shd.g_old_rec.crd_attribute2;
390: End If;
391: If (p_rec.crd_attribute3 = hr_api.g_varchar2) then
392: p_rec.crd_attribute3 :=
393: ben_crd_shd.g_old_rec.crd_attribute3;
394: End If;
395: If (p_rec.crd_attribute4 = hr_api.g_varchar2) then
396: p_rec.crd_attribute4 :=
397: ben_crd_shd.g_old_rec.crd_attribute4;
393: ben_crd_shd.g_old_rec.crd_attribute3;
394: End If;
395: If (p_rec.crd_attribute4 = hr_api.g_varchar2) then
396: p_rec.crd_attribute4 :=
397: ben_crd_shd.g_old_rec.crd_attribute4;
398: End If;
399: If (p_rec.crd_attribute5 = hr_api.g_varchar2) then
400: p_rec.crd_attribute5 :=
401: ben_crd_shd.g_old_rec.crd_attribute5;
397: ben_crd_shd.g_old_rec.crd_attribute4;
398: End If;
399: If (p_rec.crd_attribute5 = hr_api.g_varchar2) then
400: p_rec.crd_attribute5 :=
401: ben_crd_shd.g_old_rec.crd_attribute5;
402: End If;
403: If (p_rec.crd_attribute6 = hr_api.g_varchar2) then
404: p_rec.crd_attribute6 :=
405: ben_crd_shd.g_old_rec.crd_attribute6;
401: ben_crd_shd.g_old_rec.crd_attribute5;
402: End If;
403: If (p_rec.crd_attribute6 = hr_api.g_varchar2) then
404: p_rec.crd_attribute6 :=
405: ben_crd_shd.g_old_rec.crd_attribute6;
406: End If;
407: If (p_rec.crd_attribute7 = hr_api.g_varchar2) then
408: p_rec.crd_attribute7 :=
409: ben_crd_shd.g_old_rec.crd_attribute7;
405: ben_crd_shd.g_old_rec.crd_attribute6;
406: End If;
407: If (p_rec.crd_attribute7 = hr_api.g_varchar2) then
408: p_rec.crd_attribute7 :=
409: ben_crd_shd.g_old_rec.crd_attribute7;
410: End If;
411: If (p_rec.crd_attribute8 = hr_api.g_varchar2) then
412: p_rec.crd_attribute8 :=
413: ben_crd_shd.g_old_rec.crd_attribute8;
409: ben_crd_shd.g_old_rec.crd_attribute7;
410: End If;
411: If (p_rec.crd_attribute8 = hr_api.g_varchar2) then
412: p_rec.crd_attribute8 :=
413: ben_crd_shd.g_old_rec.crd_attribute8;
414: End If;
415: If (p_rec.crd_attribute9 = hr_api.g_varchar2) then
416: p_rec.crd_attribute9 :=
417: ben_crd_shd.g_old_rec.crd_attribute9;
413: ben_crd_shd.g_old_rec.crd_attribute8;
414: End If;
415: If (p_rec.crd_attribute9 = hr_api.g_varchar2) then
416: p_rec.crd_attribute9 :=
417: ben_crd_shd.g_old_rec.crd_attribute9;
418: End If;
419: If (p_rec.crd_attribute10 = hr_api.g_varchar2) then
420: p_rec.crd_attribute10 :=
421: ben_crd_shd.g_old_rec.crd_attribute10;
417: ben_crd_shd.g_old_rec.crd_attribute9;
418: End If;
419: If (p_rec.crd_attribute10 = hr_api.g_varchar2) then
420: p_rec.crd_attribute10 :=
421: ben_crd_shd.g_old_rec.crd_attribute10;
422: End If;
423: If (p_rec.crd_attribute11 = hr_api.g_varchar2) then
424: p_rec.crd_attribute11 :=
425: ben_crd_shd.g_old_rec.crd_attribute11;
421: ben_crd_shd.g_old_rec.crd_attribute10;
422: End If;
423: If (p_rec.crd_attribute11 = hr_api.g_varchar2) then
424: p_rec.crd_attribute11 :=
425: ben_crd_shd.g_old_rec.crd_attribute11;
426: End If;
427: If (p_rec.crd_attribute12 = hr_api.g_varchar2) then
428: p_rec.crd_attribute12 :=
429: ben_crd_shd.g_old_rec.crd_attribute12;
425: ben_crd_shd.g_old_rec.crd_attribute11;
426: End If;
427: If (p_rec.crd_attribute12 = hr_api.g_varchar2) then
428: p_rec.crd_attribute12 :=
429: ben_crd_shd.g_old_rec.crd_attribute12;
430: End If;
431: If (p_rec.crd_attribute13 = hr_api.g_varchar2) then
432: p_rec.crd_attribute13 :=
433: ben_crd_shd.g_old_rec.crd_attribute13;
429: ben_crd_shd.g_old_rec.crd_attribute12;
430: End If;
431: If (p_rec.crd_attribute13 = hr_api.g_varchar2) then
432: p_rec.crd_attribute13 :=
433: ben_crd_shd.g_old_rec.crd_attribute13;
434: End If;
435: If (p_rec.crd_attribute14 = hr_api.g_varchar2) then
436: p_rec.crd_attribute14 :=
437: ben_crd_shd.g_old_rec.crd_attribute14;
433: ben_crd_shd.g_old_rec.crd_attribute13;
434: End If;
435: If (p_rec.crd_attribute14 = hr_api.g_varchar2) then
436: p_rec.crd_attribute14 :=
437: ben_crd_shd.g_old_rec.crd_attribute14;
438: End If;
439: If (p_rec.crd_attribute15 = hr_api.g_varchar2) then
440: p_rec.crd_attribute15 :=
441: ben_crd_shd.g_old_rec.crd_attribute15;
437: ben_crd_shd.g_old_rec.crd_attribute14;
438: End If;
439: If (p_rec.crd_attribute15 = hr_api.g_varchar2) then
440: p_rec.crd_attribute15 :=
441: ben_crd_shd.g_old_rec.crd_attribute15;
442: End If;
443: If (p_rec.crd_attribute16 = hr_api.g_varchar2) then
444: p_rec.crd_attribute16 :=
445: ben_crd_shd.g_old_rec.crd_attribute16;
441: ben_crd_shd.g_old_rec.crd_attribute15;
442: End If;
443: If (p_rec.crd_attribute16 = hr_api.g_varchar2) then
444: p_rec.crd_attribute16 :=
445: ben_crd_shd.g_old_rec.crd_attribute16;
446: End If;
447: If (p_rec.crd_attribute17 = hr_api.g_varchar2) then
448: p_rec.crd_attribute17 :=
449: ben_crd_shd.g_old_rec.crd_attribute17;
445: ben_crd_shd.g_old_rec.crd_attribute16;
446: End If;
447: If (p_rec.crd_attribute17 = hr_api.g_varchar2) then
448: p_rec.crd_attribute17 :=
449: ben_crd_shd.g_old_rec.crd_attribute17;
450: End If;
451: If (p_rec.crd_attribute18 = hr_api.g_varchar2) then
452: p_rec.crd_attribute18 :=
453: ben_crd_shd.g_old_rec.crd_attribute18;
449: ben_crd_shd.g_old_rec.crd_attribute17;
450: End If;
451: If (p_rec.crd_attribute18 = hr_api.g_varchar2) then
452: p_rec.crd_attribute18 :=
453: ben_crd_shd.g_old_rec.crd_attribute18;
454: End If;
455: If (p_rec.crd_attribute19 = hr_api.g_varchar2) then
456: p_rec.crd_attribute19 :=
457: ben_crd_shd.g_old_rec.crd_attribute19;
453: ben_crd_shd.g_old_rec.crd_attribute18;
454: End If;
455: If (p_rec.crd_attribute19 = hr_api.g_varchar2) then
456: p_rec.crd_attribute19 :=
457: ben_crd_shd.g_old_rec.crd_attribute19;
458: End If;
459: If (p_rec.crd_attribute20 = hr_api.g_varchar2) then
460: p_rec.crd_attribute20 :=
461: ben_crd_shd.g_old_rec.crd_attribute20;
457: ben_crd_shd.g_old_rec.crd_attribute19;
458: End If;
459: If (p_rec.crd_attribute20 = hr_api.g_varchar2) then
460: p_rec.crd_attribute20 :=
461: ben_crd_shd.g_old_rec.crd_attribute20;
462: End If;
463: If (p_rec.crd_attribute21 = hr_api.g_varchar2) then
464: p_rec.crd_attribute21 :=
465: ben_crd_shd.g_old_rec.crd_attribute21;
461: ben_crd_shd.g_old_rec.crd_attribute20;
462: End If;
463: If (p_rec.crd_attribute21 = hr_api.g_varchar2) then
464: p_rec.crd_attribute21 :=
465: ben_crd_shd.g_old_rec.crd_attribute21;
466: End If;
467: If (p_rec.crd_attribute22 = hr_api.g_varchar2) then
468: p_rec.crd_attribute22 :=
469: ben_crd_shd.g_old_rec.crd_attribute22;
465: ben_crd_shd.g_old_rec.crd_attribute21;
466: End If;
467: If (p_rec.crd_attribute22 = hr_api.g_varchar2) then
468: p_rec.crd_attribute22 :=
469: ben_crd_shd.g_old_rec.crd_attribute22;
470: End If;
471: If (p_rec.crd_attribute23 = hr_api.g_varchar2) then
472: p_rec.crd_attribute23 :=
473: ben_crd_shd.g_old_rec.crd_attribute23;
469: ben_crd_shd.g_old_rec.crd_attribute22;
470: End If;
471: If (p_rec.crd_attribute23 = hr_api.g_varchar2) then
472: p_rec.crd_attribute23 :=
473: ben_crd_shd.g_old_rec.crd_attribute23;
474: End If;
475: If (p_rec.crd_attribute24 = hr_api.g_varchar2) then
476: p_rec.crd_attribute24 :=
477: ben_crd_shd.g_old_rec.crd_attribute24;
473: ben_crd_shd.g_old_rec.crd_attribute23;
474: End If;
475: If (p_rec.crd_attribute24 = hr_api.g_varchar2) then
476: p_rec.crd_attribute24 :=
477: ben_crd_shd.g_old_rec.crd_attribute24;
478: End If;
479: If (p_rec.crd_attribute25 = hr_api.g_varchar2) then
480: p_rec.crd_attribute25 :=
481: ben_crd_shd.g_old_rec.crd_attribute25;
477: ben_crd_shd.g_old_rec.crd_attribute24;
478: End If;
479: If (p_rec.crd_attribute25 = hr_api.g_varchar2) then
480: p_rec.crd_attribute25 :=
481: ben_crd_shd.g_old_rec.crd_attribute25;
482: End If;
483: If (p_rec.crd_attribute26 = hr_api.g_varchar2) then
484: p_rec.crd_attribute26 :=
485: ben_crd_shd.g_old_rec.crd_attribute26;
481: ben_crd_shd.g_old_rec.crd_attribute25;
482: End If;
483: If (p_rec.crd_attribute26 = hr_api.g_varchar2) then
484: p_rec.crd_attribute26 :=
485: ben_crd_shd.g_old_rec.crd_attribute26;
486: End If;
487: If (p_rec.crd_attribute27 = hr_api.g_varchar2) then
488: p_rec.crd_attribute27 :=
489: ben_crd_shd.g_old_rec.crd_attribute27;
485: ben_crd_shd.g_old_rec.crd_attribute26;
486: End If;
487: If (p_rec.crd_attribute27 = hr_api.g_varchar2) then
488: p_rec.crd_attribute27 :=
489: ben_crd_shd.g_old_rec.crd_attribute27;
490: End If;
491: If (p_rec.crd_attribute28 = hr_api.g_varchar2) then
492: p_rec.crd_attribute28 :=
493: ben_crd_shd.g_old_rec.crd_attribute28;
489: ben_crd_shd.g_old_rec.crd_attribute27;
490: End If;
491: If (p_rec.crd_attribute28 = hr_api.g_varchar2) then
492: p_rec.crd_attribute28 :=
493: ben_crd_shd.g_old_rec.crd_attribute28;
494: End If;
495: If (p_rec.crd_attribute29 = hr_api.g_varchar2) then
496: p_rec.crd_attribute29 :=
497: ben_crd_shd.g_old_rec.crd_attribute29;
493: ben_crd_shd.g_old_rec.crd_attribute28;
494: End If;
495: If (p_rec.crd_attribute29 = hr_api.g_varchar2) then
496: p_rec.crd_attribute29 :=
497: ben_crd_shd.g_old_rec.crd_attribute29;
498: End If;
499: If (p_rec.crd_attribute30 = hr_api.g_varchar2) then
500: p_rec.crd_attribute30 :=
501: ben_crd_shd.g_old_rec.crd_attribute30;
497: ben_crd_shd.g_old_rec.crd_attribute29;
498: End If;
499: If (p_rec.crd_attribute30 = hr_api.g_varchar2) then
500: p_rec.crd_attribute30 :=
501: ben_crd_shd.g_old_rec.crd_attribute30;
502: End If;
503:
504: --
505: hr_utility.set_location(' Leaving:'||l_proc, 10);
510: -- |---------------------------------< upd >----------------------------------|
511: -- ----------------------------------------------------------------------------
512: Procedure upd
513: (
514: p_rec in out nocopy ben_crd_shd.g_rec_type
515: ) is
516: --
517: l_proc varchar2(72) := g_package||'upd';
518: --
520: hr_utility.set_location('Entering:'||l_proc, 5);
521: --
522: -- We must lock the row which we need to update.
523: --
524: ben_crd_shd.lck
525: (
526: p_rec.crt_ordr_cvrd_per_id,
527: p_rec.object_version_number
528: );
591: p_crd_attribute30 in varchar2 default hr_api.g_varchar2,
592: p_object_version_number in out nocopy number
593: ) is
594: --
595: l_rec ben_crd_shd.g_rec_type;
596: l_proc varchar2(72) := g_package||'upd';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
601: -- Call conversion function to turn arguments into the
602: -- l_rec structure.
603: --
604: l_rec :=
605: ben_crd_shd.convert_args
606: (
607: p_crt_ordr_cvrd_per_id,
608: p_crt_ordr_id,
609: p_person_id,