48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_cci_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --
72: Exception
73: When hr_api.child_integrity_violated then
74: -- Child integrity has been violated
75: --
76: ota_cci_shd.constraint_error
77: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
78: When Others Then
79: --
80: Raise;
111: -- Internal Row Handler Use Only.
112: --
113: -- {End Of Comments}
114: -- ----------------------------------------------------------------------------
115: Procedure pre_delete(p_rec in ota_cci_shd.g_rec_type) is
116: --
117: l_proc varchar2(72) := g_package||'pre_delete';
118: --
119: Begin
153: -- Internal Row Handler Use Only.
154: --
155: -- {End Of Comments}
156: -- -----------------------------------------------------------------------------
157: Procedure post_delete(p_rec in ota_cci_shd.g_rec_type) is
158: --
159: l_proc varchar2(72) := g_package||'post_delete';
160: --
161: Begin
167: => p_rec.category_usage_id
168: ,p_certification_id
169: => p_rec.certification_id
170: ,p_object_version_number_o
171: => ota_cci_shd.g_old_rec.object_version_number
172: ,p_start_date_active_o
173: => ota_cci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_cci_shd.g_old_rec.end_date_active
169: => p_rec.certification_id
170: ,p_object_version_number_o
171: => ota_cci_shd.g_old_rec.object_version_number
172: ,p_start_date_active_o
173: => ota_cci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_cci_shd.g_old_rec.end_date_active
176: ,p_primary_flag_o
177: => ota_cci_shd.g_old_rec.primary_flag
171: => ota_cci_shd.g_old_rec.object_version_number
172: ,p_start_date_active_o
173: => ota_cci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_cci_shd.g_old_rec.end_date_active
176: ,p_primary_flag_o
177: => ota_cci_shd.g_old_rec.primary_flag
178: ,p_attribute_category_o
179: => ota_cci_shd.g_old_rec.attribute_category
173: => ota_cci_shd.g_old_rec.start_date_active
174: ,p_end_date_active_o
175: => ota_cci_shd.g_old_rec.end_date_active
176: ,p_primary_flag_o
177: => ota_cci_shd.g_old_rec.primary_flag
178: ,p_attribute_category_o
179: => ota_cci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_cci_shd.g_old_rec.attribute1
175: => ota_cci_shd.g_old_rec.end_date_active
176: ,p_primary_flag_o
177: => ota_cci_shd.g_old_rec.primary_flag
178: ,p_attribute_category_o
179: => ota_cci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_cci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_cci_shd.g_old_rec.attribute2
177: => ota_cci_shd.g_old_rec.primary_flag
178: ,p_attribute_category_o
179: => ota_cci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_cci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_cci_shd.g_old_rec.attribute2
184: ,p_attribute3_o
185: => ota_cci_shd.g_old_rec.attribute3
179: => ota_cci_shd.g_old_rec.attribute_category
180: ,p_attribute1_o
181: => ota_cci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_cci_shd.g_old_rec.attribute2
184: ,p_attribute3_o
185: => ota_cci_shd.g_old_rec.attribute3
186: ,p_attribute4_o
187: => ota_cci_shd.g_old_rec.attribute4
181: => ota_cci_shd.g_old_rec.attribute1
182: ,p_attribute2_o
183: => ota_cci_shd.g_old_rec.attribute2
184: ,p_attribute3_o
185: => ota_cci_shd.g_old_rec.attribute3
186: ,p_attribute4_o
187: => ota_cci_shd.g_old_rec.attribute4
188: ,p_attribute5_o
189: => ota_cci_shd.g_old_rec.attribute5
183: => ota_cci_shd.g_old_rec.attribute2
184: ,p_attribute3_o
185: => ota_cci_shd.g_old_rec.attribute3
186: ,p_attribute4_o
187: => ota_cci_shd.g_old_rec.attribute4
188: ,p_attribute5_o
189: => ota_cci_shd.g_old_rec.attribute5
190: ,p_attribute6_o
191: => ota_cci_shd.g_old_rec.attribute6
185: => ota_cci_shd.g_old_rec.attribute3
186: ,p_attribute4_o
187: => ota_cci_shd.g_old_rec.attribute4
188: ,p_attribute5_o
189: => ota_cci_shd.g_old_rec.attribute5
190: ,p_attribute6_o
191: => ota_cci_shd.g_old_rec.attribute6
192: ,p_attribute7_o
193: => ota_cci_shd.g_old_rec.attribute7
187: => ota_cci_shd.g_old_rec.attribute4
188: ,p_attribute5_o
189: => ota_cci_shd.g_old_rec.attribute5
190: ,p_attribute6_o
191: => ota_cci_shd.g_old_rec.attribute6
192: ,p_attribute7_o
193: => ota_cci_shd.g_old_rec.attribute7
194: ,p_attribute8_o
195: => ota_cci_shd.g_old_rec.attribute8
189: => ota_cci_shd.g_old_rec.attribute5
190: ,p_attribute6_o
191: => ota_cci_shd.g_old_rec.attribute6
192: ,p_attribute7_o
193: => ota_cci_shd.g_old_rec.attribute7
194: ,p_attribute8_o
195: => ota_cci_shd.g_old_rec.attribute8
196: ,p_attribute9_o
197: => ota_cci_shd.g_old_rec.attribute9
191: => ota_cci_shd.g_old_rec.attribute6
192: ,p_attribute7_o
193: => ota_cci_shd.g_old_rec.attribute7
194: ,p_attribute8_o
195: => ota_cci_shd.g_old_rec.attribute8
196: ,p_attribute9_o
197: => ota_cci_shd.g_old_rec.attribute9
198: ,p_attribute10_o
199: => ota_cci_shd.g_old_rec.attribute10
193: => ota_cci_shd.g_old_rec.attribute7
194: ,p_attribute8_o
195: => ota_cci_shd.g_old_rec.attribute8
196: ,p_attribute9_o
197: => ota_cci_shd.g_old_rec.attribute9
198: ,p_attribute10_o
199: => ota_cci_shd.g_old_rec.attribute10
200: ,p_attribute11_o
201: => ota_cci_shd.g_old_rec.attribute11
195: => ota_cci_shd.g_old_rec.attribute8
196: ,p_attribute9_o
197: => ota_cci_shd.g_old_rec.attribute9
198: ,p_attribute10_o
199: => ota_cci_shd.g_old_rec.attribute10
200: ,p_attribute11_o
201: => ota_cci_shd.g_old_rec.attribute11
202: ,p_attribute12_o
203: => ota_cci_shd.g_old_rec.attribute12
197: => ota_cci_shd.g_old_rec.attribute9
198: ,p_attribute10_o
199: => ota_cci_shd.g_old_rec.attribute10
200: ,p_attribute11_o
201: => ota_cci_shd.g_old_rec.attribute11
202: ,p_attribute12_o
203: => ota_cci_shd.g_old_rec.attribute12
204: ,p_attribute13_o
205: => ota_cci_shd.g_old_rec.attribute13
199: => ota_cci_shd.g_old_rec.attribute10
200: ,p_attribute11_o
201: => ota_cci_shd.g_old_rec.attribute11
202: ,p_attribute12_o
203: => ota_cci_shd.g_old_rec.attribute12
204: ,p_attribute13_o
205: => ota_cci_shd.g_old_rec.attribute13
206: ,p_attribute14_o
207: => ota_cci_shd.g_old_rec.attribute14
201: => ota_cci_shd.g_old_rec.attribute11
202: ,p_attribute12_o
203: => ota_cci_shd.g_old_rec.attribute12
204: ,p_attribute13_o
205: => ota_cci_shd.g_old_rec.attribute13
206: ,p_attribute14_o
207: => ota_cci_shd.g_old_rec.attribute14
208: ,p_attribute15_o
209: => ota_cci_shd.g_old_rec.attribute15
203: => ota_cci_shd.g_old_rec.attribute12
204: ,p_attribute13_o
205: => ota_cci_shd.g_old_rec.attribute13
206: ,p_attribute14_o
207: => ota_cci_shd.g_old_rec.attribute14
208: ,p_attribute15_o
209: => ota_cci_shd.g_old_rec.attribute15
210: ,p_attribute16_o
211: => ota_cci_shd.g_old_rec.attribute16
205: => ota_cci_shd.g_old_rec.attribute13
206: ,p_attribute14_o
207: => ota_cci_shd.g_old_rec.attribute14
208: ,p_attribute15_o
209: => ota_cci_shd.g_old_rec.attribute15
210: ,p_attribute16_o
211: => ota_cci_shd.g_old_rec.attribute16
212: ,p_attribute17_o
213: => ota_cci_shd.g_old_rec.attribute17
207: => ota_cci_shd.g_old_rec.attribute14
208: ,p_attribute15_o
209: => ota_cci_shd.g_old_rec.attribute15
210: ,p_attribute16_o
211: => ota_cci_shd.g_old_rec.attribute16
212: ,p_attribute17_o
213: => ota_cci_shd.g_old_rec.attribute17
214: ,p_attribute18_o
215: => ota_cci_shd.g_old_rec.attribute18
209: => ota_cci_shd.g_old_rec.attribute15
210: ,p_attribute16_o
211: => ota_cci_shd.g_old_rec.attribute16
212: ,p_attribute17_o
213: => ota_cci_shd.g_old_rec.attribute17
214: ,p_attribute18_o
215: => ota_cci_shd.g_old_rec.attribute18
216: ,p_attribute19_o
217: => ota_cci_shd.g_old_rec.attribute19
211: => ota_cci_shd.g_old_rec.attribute16
212: ,p_attribute17_o
213: => ota_cci_shd.g_old_rec.attribute17
214: ,p_attribute18_o
215: => ota_cci_shd.g_old_rec.attribute18
216: ,p_attribute19_o
217: => ota_cci_shd.g_old_rec.attribute19
218: ,p_attribute20_o
219: => ota_cci_shd.g_old_rec.attribute20
213: => ota_cci_shd.g_old_rec.attribute17
214: ,p_attribute18_o
215: => ota_cci_shd.g_old_rec.attribute18
216: ,p_attribute19_o
217: => ota_cci_shd.g_old_rec.attribute19
218: ,p_attribute20_o
219: => ota_cci_shd.g_old_rec.attribute20
220: );
221: --
215: => ota_cci_shd.g_old_rec.attribute18
216: ,p_attribute19_o
217: => ota_cci_shd.g_old_rec.attribute19
218: ,p_attribute20_o
219: => ota_cci_shd.g_old_rec.attribute20
220: );
221: --
222: exception
223: --
235: -- ----------------------------------------------------------------------------
236: -- |---------------------------------< del >----------------------------------|
237: -- ----------------------------------------------------------------------------
238: Procedure del
239: (p_rec in ota_cci_shd.g_rec_type
240: ) is
241: --
242: l_proc varchar2(72) := g_package||'del';
243: --
245: hr_utility.set_location('Entering:'||l_proc, 5);
246: --
247: -- We must lock the row which we need to delete.
248: --
249: ota_cci_shd.lck
250: (p_rec.category_usage_id
251: ,p_rec.certification_id
252: ,p_rec.object_version_number
253: );
284: ,p_certification_id in number
285: ,p_object_version_number in number
286: ) is
287: --
288: l_rec ota_cci_shd.g_rec_type;
289: l_proc varchar2(72) := g_package||'del';
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);