41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_asn_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
58: --
59: Exception
60: When hr_api.child_integrity_violated then
61: -- Child integrity has been violated
62: per_asn_shd.constraint_error
63: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
64: When Others Then
65: Raise;
66: End delete_dml;
96: -- Internal Table Handler Use Only.
97: --
98: -- {End Of Comments}
99: -- ----------------------------------------------------------------------------
100: Procedure pre_delete(p_rec in per_asn_shd.g_rec_type) is
101: --
102: l_proc varchar2(72) := g_package||'pre_delete';
103: --
104: Begin
138: -- Internal table Handler Use Only.
139: --
140: -- {End Of Comments}
141: -- ----------------------------------------------------------------------------
142: Procedure post_delete(p_rec in per_asn_shd.g_rec_type) is
143: --
144: l_proc varchar2(72) := g_package||'post_delete';
145: --
146: Begin
150: --
151: begin
152: per_asn_rkd.after_delete (
153: p_assessment_id => p_rec.assessment_id ,
154: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
151: begin
152: per_asn_rkd.after_delete (
153: p_assessment_id => p_rec.assessment_id ,
154: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
152: per_asn_rkd.after_delete (
153: p_assessment_id => p_rec.assessment_id ,
154: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
153: p_assessment_id => p_rec.assessment_id ,
154: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
154: p_business_group_id_o => per_asn_shd.g_old_rec.business_group_id ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
155: p_object_version_number_o => per_asn_shd.g_old_rec.object_version_number ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
156: p_person_id_o => per_asn_shd.g_old_rec.person_id ,
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
157: p_assessment_type_id_o => per_asn_shd.g_old_rec.assessment_type_id ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
158: p_group_date_o => per_asn_shd.g_old_rec.group_date ,
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
159: p_group_initiator_id_o => per_asn_shd.g_old_rec.group_initiator_id ,
160: p_assessor_person_id_o => per_asn_shd.g_old_rec.assessor_person_id ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
161: p_assessment_group_id_o => per_asn_shd.g_old_rec.assessment_group_id ,
162: p_assessment_date_o => per_asn_shd.g_old_rec.assessment_date ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
163: p_status_o => per_asn_shd.g_old_rec.status ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
164: p_assessment_period_start_da_o =>
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
165: per_asn_shd.g_old_rec.assessment_period_start_date ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
166: p_assessment_period_end_date_o =>
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
167: per_asn_shd.g_old_rec.assessment_period_end_date ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
168: p_comments_o => per_asn_shd.g_old_rec.comments ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
169: p_total_score_o => per_asn_shd.g_old_rec.total_score ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
170: p_appraisal_id_o => per_asn_shd.g_old_rec.appraisal_id ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
171: p_attribute_category_o => per_asn_shd.g_old_rec.attribute_category ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
172: p_attribute1_o => per_asn_shd.g_old_rec.attribute1 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
173: p_attribute2_o => per_asn_shd.g_old_rec.attribute2 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
174: p_attribute3_o => per_asn_shd.g_old_rec.attribute3 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
175: p_attribute4_o => per_asn_shd.g_old_rec.attribute4 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
176: p_attribute5_o => per_asn_shd.g_old_rec.attribute5 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
177: p_attribute6_o => per_asn_shd.g_old_rec.attribute6 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
178: p_attribute7_o => per_asn_shd.g_old_rec.attribute7 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
179: p_attribute8_o => per_asn_shd.g_old_rec.attribute8 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
180: p_attribute9_o => per_asn_shd.g_old_rec.attribute9 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
181: p_attribute10_o => per_asn_shd.g_old_rec.attribute10 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
182: p_attribute11_o => per_asn_shd.g_old_rec.attribute11 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
183: p_attribute12_o => per_asn_shd.g_old_rec.attribute12 ,
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
184: p_attribute13_o => per_asn_shd.g_old_rec.attribute13 ,
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
185: p_attribute14_o => per_asn_shd.g_old_rec.attribute14 ,
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
193: when hr_api.cannot_find_prog_unit then
186: p_attribute15_o => per_asn_shd.g_old_rec.attribute15 ,
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
187: p_attribute16_o => per_asn_shd.g_old_rec.attribute16 ,
188: p_attribute17_o => per_asn_shd.g_old_rec.attribute17 ,
189: p_attribute18_o => per_asn_shd.g_old_rec.attribute18 ,
190: p_attribute19_o => per_asn_shd.g_old_rec.attribute19 ,
191: p_attribute20_o => per_asn_shd.g_old_rec.attribute20 );
192: exception
193: when hr_api.cannot_find_prog_unit then
194: hr_api.cannot_find_prog_unit_error
195: ( p_module_name => 'PER_ASSESSMENTS'
205: -- |---------------------------------< del >----------------------------------|
206: -- ----------------------------------------------------------------------------
207: Procedure del
208: (
209: p_rec in per_asn_shd.g_rec_type,
210: p_validate in boolean default false
211: ) is
212: --
213: l_proc varchar2(72) := g_package||'del';
225: End If;
226: --
227: -- We must lock the row which we need to delete.
228: --
229: per_asn_shd.lck
230: (
231: p_rec.assessment_id,
232: p_rec.object_version_number
233: );
283: p_object_version_number in number,
284: p_validate in boolean default false
285: ) is
286: --
287: l_rec per_asn_shd.g_rec_type;
288: l_proc varchar2(72) := g_package||'del';
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);