47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_esa_shd.g_rec_type) is
52: --
53: l_proc varchar2(72) := g_package||'delete_dml';
54: --
55: Begin
54: --
55: Begin
56: hr_utility.set_location('Entering:'||l_proc, 5);
57: --
58: per_esa_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_establish_attendances row.
61: --
62: delete from per_establishment_attendances
61: --
62: delete from per_establishment_attendances
63: where attendance_id = p_rec.attendance_id;
64: --
65: per_esa_shd.g_api_dml := false; -- Unset the api dml status
66: --
67: hr_utility.set_location(' Leaving:'||l_proc, 10);
68: --
69: Exception
68: --
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_esa_shd.g_api_dml := false; -- Unset the api dml status
73: per_esa_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_esa_shd.g_api_dml := false; -- Unset the api dml status
69: Exception
70: When hr_api.child_integrity_violated then
71: -- Child integrity has been violated
72: per_esa_shd.g_api_dml := false; -- Unset the api dml status
73: per_esa_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_esa_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: per_esa_shd.g_api_dml := false; -- Unset the api dml status
73: per_esa_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_esa_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Table Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in per_esa_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
150: -- Internal table Handler Use Only.
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete(p_rec in per_esa_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin
162: -- Start of API User Hook for post_delete.
163: begin
164: per_esa_rkd.after_delete
165: (p_attendance_id =>p_rec.attendance_id,
166: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
163: begin
164: per_esa_rkd.after_delete
165: (p_attendance_id =>p_rec.attendance_id,
166: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
164: per_esa_rkd.after_delete
165: (p_attendance_id =>p_rec.attendance_id,
166: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
165: (p_attendance_id =>p_rec.attendance_id,
166: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
166: p_person_id_o =>per_esa_shd.g_old_rec.person_id,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
167: p_establishment_id_o =>per_esa_shd.g_old_rec.establishment_id,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
168: p_establishment_o =>per_esa_shd.g_old_rec.establishment,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
169: p_attended_start_date_o =>per_esa_shd.g_old_rec.attended_start_date,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
170: p_attended_end_date_o =>per_esa_shd.g_old_rec.attended_end_date,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
171: p_full_time_o =>per_esa_shd.g_old_rec.full_time,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
172: p_attribute_category_o =>per_esa_shd.g_old_rec.attribute_category,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
173: p_attribute1_o =>per_esa_shd.g_old_rec.attribute1,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
174: p_attribute2_o =>per_esa_shd.g_old_rec.attribute2,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
175: p_attribute3_o =>per_esa_shd.g_old_rec.attribute3,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
176: p_attribute4_o =>per_esa_shd.g_old_rec.attribute4,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
177: p_attribute5_o =>per_esa_shd.g_old_rec.attribute5,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
178: p_attribute6_o =>per_esa_shd.g_old_rec.attribute6,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
179: p_attribute7_o =>per_esa_shd.g_old_rec.attribute7,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
180: p_attribute8_o =>per_esa_shd.g_old_rec.attribute8,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
181: p_attribute9_o =>per_esa_shd.g_old_rec.attribute9,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
182: p_attribute10_o =>per_esa_shd.g_old_rec.attribute10,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
183: p_attribute11_o =>per_esa_shd.g_old_rec.attribute11,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
184: p_attribute12_o =>per_esa_shd.g_old_rec.attribute12,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
185: p_attribute13_o =>per_esa_shd.g_old_rec.attribute13,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
186: p_attribute14_o =>per_esa_shd.g_old_rec.attribute14,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
187: p_attribute15_o =>per_esa_shd.g_old_rec.attribute15,
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
188: p_attribute16_o =>per_esa_shd.g_old_rec.attribute16,
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
196: p_address_o =>per_esa_shd.g_old_rec.address
189: p_attribute17_o =>per_esa_shd.g_old_rec.attribute17,
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
196: p_address_o =>per_esa_shd.g_old_rec.address
197: );
190: p_attribute18_o =>per_esa_shd.g_old_rec.attribute18,
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
196: p_address_o =>per_esa_shd.g_old_rec.address
197: );
198: exception
191: p_attribute19_o =>per_esa_shd.g_old_rec.attribute19,
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
196: p_address_o =>per_esa_shd.g_old_rec.address
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
192: p_attribute20_o =>per_esa_shd.g_old_rec.attribute20,
193: p_object_version_number_o =>per_esa_shd.g_old_rec.object_version_number,
194: p_business_group_id_o =>per_esa_shd.g_old_rec.business_group_id,
195: p_party_id_o =>per_esa_shd.g_old_rec.party_id, -- HR/TCA merge
196: p_address_o =>per_esa_shd.g_old_rec.address
197: );
198: exception
199: when hr_api.cannot_find_prog_unit then
200: hr_api.cannot_find_prog_unit_error
211: -- |---------------------------------< del >----------------------------------|
212: -- ----------------------------------------------------------------------------
213: Procedure del
214: (
215: p_rec in per_esa_shd.g_rec_type,
216: p_validate in boolean default false
217: ) is
218: --
219: l_proc varchar2(72) := g_package||'del';
231: End If;
232: --
233: -- We must lock the row which we need to delete.
234: --
235: per_esa_shd.lck
236: (
237: p_rec.attendance_id,
238: p_rec.object_version_number
239: );
279: p_object_version_number in number,
280: p_validate in boolean default false
281: ) is
282: --
283: l_rec per_esa_shd.g_rec_type;
284: l_proc varchar2(72) := g_package||'del';
285: --
286: Begin
287: hr_utility.set_location('Entering:'||l_proc, 5);