47: -- Internal Table Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in per_pea_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_pea_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the per_person_analyses row.
61: --
62: delete from per_person_analyses
61: --
62: delete from per_person_analyses
63: where person_analysis_id = p_rec.person_analysis_id;
64: --
65: per_pea_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_pea_shd.g_api_dml := false; -- Unset the api dml status
73: per_pea_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pea_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_pea_shd.g_api_dml := false; -- Unset the api dml status
73: per_pea_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pea_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: per_pea_shd.g_api_dml := false; -- Unset the api dml status
73: per_pea_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: per_pea_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_pea_shd.g_rec_type) is
113: --
114: l_proc varchar2(72) := g_package||'pre_delete';
115: --
116: Begin
151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: Procedure post_delete
155: (p_rec in per_pea_shd.g_rec_type) is
156: --
157: l_proc varchar2(72) := g_package||'post_delete';
158: --
159: Begin
163: begin
164: per_pea_rkd.after_delete
165: (
166: p_person_analysis_id => p_rec.person_analysis_id,
167: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
164: per_pea_rkd.after_delete
165: (
166: p_person_analysis_id => p_rec.person_analysis_id,
167: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
165: (
166: p_person_analysis_id => p_rec.person_analysis_id,
167: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
166: p_person_analysis_id => p_rec.person_analysis_id,
167: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
167: p_business_group_id_o => per_pea_shd.g_old_rec.business_group_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
168: p_analysis_criteria_id_o => per_pea_shd.g_old_rec.analysis_criteria_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
169: p_person_id_o => per_pea_shd.g_old_rec.person_id,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
170: p_comments_o => per_pea_shd.g_old_rec.comments,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
171: p_date_from_o => per_pea_shd.g_old_rec.date_from,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
172: p_date_to_o => per_pea_shd.g_old_rec.date_to,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
173: p_id_flex_num_o => per_pea_shd.g_old_rec.id_flex_num,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
174: p_request_id_o => per_pea_shd.g_old_rec.request_id,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
175: p_program_application_id_o => per_pea_shd.g_old_rec.program_application_id,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
176: p_program_id_o => per_pea_shd.g_old_rec.program_id,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
177: p_program_update_date_o => per_pea_shd.g_old_rec.program_update_date,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
178: p_attribute_category_o => per_pea_shd.g_old_rec.attribute_category,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
179: p_attribute1_o => per_pea_shd.g_old_rec.attribute1,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
180: p_attribute2_o => per_pea_shd.g_old_rec.attribute2,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
181: p_attribute3_o => per_pea_shd.g_old_rec.attribute3,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
182: p_attribute4_o => per_pea_shd.g_old_rec.attribute4,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
183: p_attribute5_o => per_pea_shd.g_old_rec.attribute5,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
184: p_attribute6_o => per_pea_shd.g_old_rec.attribute6,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
185: p_attribute7_o => per_pea_shd.g_old_rec.attribute7,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
186: p_attribute8_o => per_pea_shd.g_old_rec.attribute8,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
187: p_attribute9_o => per_pea_shd.g_old_rec.attribute9,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
188: p_attribute10_o => per_pea_shd.g_old_rec.attribute10,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
189: p_attribute11_o => per_pea_shd.g_old_rec.attribute11,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
190: p_attribute12_o => per_pea_shd.g_old_rec.attribute12,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
191: p_attribute13_o => per_pea_shd.g_old_rec.attribute13,
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
192: p_attribute14_o => per_pea_shd.g_old_rec.attribute14,
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
200: );
193: p_attribute15_o => per_pea_shd.g_old_rec.attribute15,
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
200: );
201: exception
194: p_attribute16_o => per_pea_shd.g_old_rec.attribute16,
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
195: p_attribute17_o => per_pea_shd.g_old_rec.attribute17,
196: p_attribute18_o => per_pea_shd.g_old_rec.attribute18,
197: p_attribute19_o => per_pea_shd.g_old_rec.attribute19,
198: p_attribute20_o => per_pea_shd.g_old_rec.attribute20,
199: p_object_version_number_o => per_pea_shd.g_old_rec.object_version_number
200: );
201: exception
202: when hr_api.cannot_find_prog_unit then
203: hr_api.cannot_find_prog_unit_error
214: -- |---------------------------------< del >----------------------------------|
215: -- ----------------------------------------------------------------------------
216: Procedure del
217: (
218: p_rec in per_pea_shd.g_rec_type,
219: p_validate in boolean default false
220: ) is
221: --
222: l_proc varchar2(72) := g_package||'del';
234: End If;
235: --
236: -- We must lock the row which we need to delete.
237: --
238: per_pea_shd.lck
239: (
240: p_person_analysis_id => p_rec.person_analysis_id,
241: p_object_version_number => p_rec.object_version_number
242: );
290: p_object_version_number in number,
291: p_validate in boolean default false
292: ) is
293: --
294: l_rec per_pea_shd.g_rec_type;
295: l_proc varchar2(72) := g_package||'del';
296: --
297: Begin
298: hr_utility.set_location('Entering:'||l_proc, 5);