41: -- Internal Table Handler Use Only.
42: --
43: -- {End Of Comments}
44: -- ----------------------------------------------------------------------------
45: Procedure delete_dml(p_rec in per_obj_shd.g_rec_type) is
46: --
47: l_proc varchar2(72) := g_package||'delete_dml';
48: --
49: Begin
59: --
60: Exception
61: When hr_api.child_integrity_violated then
62: -- Child integrity has been violated
63: per_obj_shd.constraint_error
64: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
65: When Others Then
66: Raise;
67: End delete_dml;
97: -- Internal Table Handler Use Only.
98: --
99: -- {End Of Comments}
100: -- ----------------------------------------------------------------------------
101: Procedure pre_delete(p_rec in per_obj_shd.g_rec_type) is
102: --
103: l_proc varchar2(72) := g_package||'pre_delete';
104: --
105: Begin
139: -- Internal table Handler Use Only.
140: --
141: -- {End Of Comments}
142: -- ----------------------------------------------------------------------------
143: Procedure post_delete(p_rec in per_obj_shd.g_rec_type) is
144: --
145: l_proc varchar2(72) := g_package||'post_delete';
146: --
147: Begin
151: begin
152: per_obj_rkd.after_delete
153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
152: per_obj_rkd.after_delete
153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
153: (
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
154: p_objective_id => p_rec.objective_id,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
155: p_name_o => per_obj_shd.g_old_rec.name,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
156: p_target_date_o => per_obj_shd.g_old_rec.target_date,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
157: p_start_date_o => per_obj_shd.g_old_rec.start_date,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
158: p_business_group_id_o => per_obj_shd.g_old_rec.business_group_id,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
159: p_object_version_number_o => per_obj_shd.g_old_rec.object_version_number,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
160: p_owning_person_id_o => per_obj_shd.g_old_rec.owning_person_id,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
161: p_achievement_date_o => per_obj_shd.g_old_rec.achievement_date,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
162: p_detail_o => per_obj_shd.g_old_rec.detail,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
163: p_comments_o => per_obj_shd.g_old_rec.comments,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
164: p_success_criteria_o => per_obj_shd.g_old_rec.success_criteria,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
165: p_appraisal_id_o => per_obj_shd.g_old_rec.appraisal_id,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
166: p_attribute_category_o => per_obj_shd.g_old_rec.attribute_category,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
167: p_attribute1_o => per_obj_shd.g_old_rec.attribute1,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
168: p_attribute2_o => per_obj_shd.g_old_rec.attribute2,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
169: p_attribute3_o => per_obj_shd.g_old_rec.attribute3,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
170: p_attribute4_o => per_obj_shd.g_old_rec.attribute4,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
171: p_attribute5_o => per_obj_shd.g_old_rec.attribute5,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
172: p_attribute6_o => per_obj_shd.g_old_rec.attribute6,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
173: p_attribute7_o => per_obj_shd.g_old_rec.attribute7,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
174: p_attribute8_o => per_obj_shd.g_old_rec.attribute8,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
175: p_attribute9_o => per_obj_shd.g_old_rec.attribute9,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
176: p_attribute10_o => per_obj_shd.g_old_rec.attribute10,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
177: p_attribute11_o => per_obj_shd.g_old_rec.attribute11,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
178: p_attribute12_o => per_obj_shd.g_old_rec.attribute12,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
179: p_attribute13_o => per_obj_shd.g_old_rec.attribute13,
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
180: p_attribute14_o => per_obj_shd.g_old_rec.attribute14,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
181: p_attribute15_o => per_obj_shd.g_old_rec.attribute15,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
182: p_attribute16_o => per_obj_shd.g_old_rec.attribute16,
183: p_attribute17_o => per_obj_shd.g_old_rec.attribute17,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
184: p_attribute18_o => per_obj_shd.g_old_rec.attribute18,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
185: p_attribute19_o => per_obj_shd.g_old_rec.attribute19,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
186: p_attribute20_o => per_obj_shd.g_old_rec.attribute20,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
187:
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
188: p_attribute21_o => per_obj_shd.g_old_rec.attribute21,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
189: p_attribute22_o => per_obj_shd.g_old_rec.attribute22,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
190: p_attribute23_o => per_obj_shd.g_old_rec.attribute23,
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
191: p_attribute24_o => per_obj_shd.g_old_rec.attribute24,
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
192: p_attribute25_o => per_obj_shd.g_old_rec.attribute25,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
193: p_attribute26_o => per_obj_shd.g_old_rec.attribute26,
194: p_attribute27_o => per_obj_shd.g_old_rec.attribute27,
195: p_attribute28_o => per_obj_shd.g_old_rec.attribute28,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
196: p_attribute29_o => per_obj_shd.g_old_rec.attribute29,
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
197: p_attribute30_o => per_obj_shd.g_old_rec.attribute30,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
198:
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
199:
200: p_scorecard_id_o => per_obj_shd.g_old_rec.scorecard_id,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
201: p_copied_from_library_id_o => per_obj_shd.g_old_rec.copied_from_library_id,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
202: p_copied_from_objective_id_o => per_obj_shd.g_old_rec.copied_from_objective_id,
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
203: p_aligned_with_objective_id_o => per_obj_shd.g_old_rec.aligned_with_objective_id,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
204:
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
205: p_next_review_date_o => per_obj_shd.g_old_rec.next_review_date,
206: p_group_code_o => per_obj_shd.g_old_rec.group_code,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
207: p_priority_code_o => per_obj_shd.g_old_rec.priority_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
208: p_appraise_flag_o => per_obj_shd.g_old_rec.appraise_flag,
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
209: p_verified_flag_o => per_obj_shd.g_old_rec.verified_flag,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
210:
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
211: p_target_value_o => per_obj_shd.g_old_rec.target_value,
212: p_actual_value_o => per_obj_shd.g_old_rec.actual_value,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
213: p_weighting_percent_o => per_obj_shd.g_old_rec.weighting_percent,
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
214: p_complete_percent_o => per_obj_shd.g_old_rec.complete_percent,
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
215: p_uom_code_o => per_obj_shd.g_old_rec.uom_code,
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:
216:
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:
224: );
217: p_measurement_style_code_o => per_obj_shd.g_old_rec.measurement_style_code,
218: p_measure_name_o => per_obj_shd.g_old_rec.measure_name,
219: p_measure_type_code_o => per_obj_shd.g_old_rec.measure_type_code,
220: p_measure_comments_o => per_obj_shd.g_old_rec.measure_comments ,
221: p_sharing_access_code_o => per_obj_shd.g_old_rec.sharing_access_code
222:
223:
224: );
225: exception
238: -- |---------------------------------< del >----------------------------------|
239: -- ----------------------------------------------------------------------------
240: Procedure del
241: (
242: p_rec in per_obj_shd.g_rec_type,
243: p_validate in boolean default false
244: ) is
245: --
246: l_proc varchar2(72) := g_package||'del';
258: End If;
259: --
260: -- We must lock the row which we need to delete.
261: --
262: per_obj_shd.lck
263: (
264: p_rec.objective_id,
265: p_rec.object_version_number
266: );
313: p_object_version_number in number,
314: p_validate in boolean default false
315: ) is
316: --
317: l_rec per_obj_shd.g_rec_type;
318: l_proc varchar2(72) := g_package||'del';
319: --
320: Begin
321: hr_utility.set_location('Entering:'||l_proc, 5);