47: -- Internal Row Handler Use Only.
48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml(p_rec in ota_nhs_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: ota_nhs_shd.g_api_dml := true; -- Set the api dml status
59: --
60: -- Delete the ota_notrng_histories row.
61: --
62: delete from ota_notrng_histories
61: --
62: delete from ota_notrng_histories
63: where nota_history_id = p_rec.nota_history_id;
64: --
65: ota_nhs_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: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
73: ota_nhs_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ota_nhs_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: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
73: ota_nhs_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
72: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
73: ota_nhs_shd.constraint_error
74: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
75: When Others Then
76: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status
77: Raise;
78: End delete_dml;
79: --
80: -- ----------------------------------------------------------------------------
108: -- Internal Row Handler Use Only.
109: --
110: -- {End Of Comments}
111: -- ----------------------------------------------------------------------------
112: Procedure pre_delete(p_rec in ota_nhs_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 ota_nhs_shd.g_rec_type) is
155: --
156: l_proc varchar2(72) := g_package||'post_delete';
157: --
158: Begin
161: ota_nhs_rkd.after_delete
162: (p_nota_history_id
163: => p_rec.nota_history_id
164: ,p_person_id_o
165: => ota_nhs_shd.g_old_rec.person_id
166: ,p_contact_id_o
167: => ota_nhs_shd.g_old_rec.contact_id
168: ,p_trng_title_o
169: => ota_nhs_shd.g_old_rec.trng_title
163: => p_rec.nota_history_id
164: ,p_person_id_o
165: => ota_nhs_shd.g_old_rec.person_id
166: ,p_contact_id_o
167: => ota_nhs_shd.g_old_rec.contact_id
168: ,p_trng_title_o
169: => ota_nhs_shd.g_old_rec.trng_title
170: ,p_provider_o
171: => ota_nhs_shd.g_old_rec.provider
165: => ota_nhs_shd.g_old_rec.person_id
166: ,p_contact_id_o
167: => ota_nhs_shd.g_old_rec.contact_id
168: ,p_trng_title_o
169: => ota_nhs_shd.g_old_rec.trng_title
170: ,p_provider_o
171: => ota_nhs_shd.g_old_rec.provider
172: ,p_type_o
173: => ota_nhs_shd.g_old_rec.type
167: => ota_nhs_shd.g_old_rec.contact_id
168: ,p_trng_title_o
169: => ota_nhs_shd.g_old_rec.trng_title
170: ,p_provider_o
171: => ota_nhs_shd.g_old_rec.provider
172: ,p_type_o
173: => ota_nhs_shd.g_old_rec.type
174: ,p_centre_o
175: => ota_nhs_shd.g_old_rec.centre
169: => ota_nhs_shd.g_old_rec.trng_title
170: ,p_provider_o
171: => ota_nhs_shd.g_old_rec.provider
172: ,p_type_o
173: => ota_nhs_shd.g_old_rec.type
174: ,p_centre_o
175: => ota_nhs_shd.g_old_rec.centre
176: ,p_completion_date_o
177: => ota_nhs_shd.g_old_rec.completion_date
171: => ota_nhs_shd.g_old_rec.provider
172: ,p_type_o
173: => ota_nhs_shd.g_old_rec.type
174: ,p_centre_o
175: => ota_nhs_shd.g_old_rec.centre
176: ,p_completion_date_o
177: => ota_nhs_shd.g_old_rec.completion_date
178: ,p_award_o
179: => ota_nhs_shd.g_old_rec.award
173: => ota_nhs_shd.g_old_rec.type
174: ,p_centre_o
175: => ota_nhs_shd.g_old_rec.centre
176: ,p_completion_date_o
177: => ota_nhs_shd.g_old_rec.completion_date
178: ,p_award_o
179: => ota_nhs_shd.g_old_rec.award
180: ,p_rating_o
181: => ota_nhs_shd.g_old_rec.rating
175: => ota_nhs_shd.g_old_rec.centre
176: ,p_completion_date_o
177: => ota_nhs_shd.g_old_rec.completion_date
178: ,p_award_o
179: => ota_nhs_shd.g_old_rec.award
180: ,p_rating_o
181: => ota_nhs_shd.g_old_rec.rating
182: ,p_duration_o
183: => ota_nhs_shd.g_old_rec.duration
177: => ota_nhs_shd.g_old_rec.completion_date
178: ,p_award_o
179: => ota_nhs_shd.g_old_rec.award
180: ,p_rating_o
181: => ota_nhs_shd.g_old_rec.rating
182: ,p_duration_o
183: => ota_nhs_shd.g_old_rec.duration
184: ,p_duration_units_o
185: => ota_nhs_shd.g_old_rec.duration_units
179: => ota_nhs_shd.g_old_rec.award
180: ,p_rating_o
181: => ota_nhs_shd.g_old_rec.rating
182: ,p_duration_o
183: => ota_nhs_shd.g_old_rec.duration
184: ,p_duration_units_o
185: => ota_nhs_shd.g_old_rec.duration_units
186: ,p_activity_version_id_o
187: => ota_nhs_shd.g_old_rec.activity_version_id
181: => ota_nhs_shd.g_old_rec.rating
182: ,p_duration_o
183: => ota_nhs_shd.g_old_rec.duration
184: ,p_duration_units_o
185: => ota_nhs_shd.g_old_rec.duration_units
186: ,p_activity_version_id_o
187: => ota_nhs_shd.g_old_rec.activity_version_id
188: ,p_status_o
189: => ota_nhs_shd.g_old_rec.status
183: => ota_nhs_shd.g_old_rec.duration
184: ,p_duration_units_o
185: => ota_nhs_shd.g_old_rec.duration_units
186: ,p_activity_version_id_o
187: => ota_nhs_shd.g_old_rec.activity_version_id
188: ,p_status_o
189: => ota_nhs_shd.g_old_rec.status
190: ,p_verified_by_id_o
191: => ota_nhs_shd.g_old_rec.verified_by_id
185: => ota_nhs_shd.g_old_rec.duration_units
186: ,p_activity_version_id_o
187: => ota_nhs_shd.g_old_rec.activity_version_id
188: ,p_status_o
189: => ota_nhs_shd.g_old_rec.status
190: ,p_verified_by_id_o
191: => ota_nhs_shd.g_old_rec.verified_by_id
192: ,p_nth_information_category_o
193: => ota_nhs_shd.g_old_rec.nth_information_category
187: => ota_nhs_shd.g_old_rec.activity_version_id
188: ,p_status_o
189: => ota_nhs_shd.g_old_rec.status
190: ,p_verified_by_id_o
191: => ota_nhs_shd.g_old_rec.verified_by_id
192: ,p_nth_information_category_o
193: => ota_nhs_shd.g_old_rec.nth_information_category
194: ,p_nth_information1_o
195: => ota_nhs_shd.g_old_rec.nth_information1
189: => ota_nhs_shd.g_old_rec.status
190: ,p_verified_by_id_o
191: => ota_nhs_shd.g_old_rec.verified_by_id
192: ,p_nth_information_category_o
193: => ota_nhs_shd.g_old_rec.nth_information_category
194: ,p_nth_information1_o
195: => ota_nhs_shd.g_old_rec.nth_information1
196: ,p_nth_information2_o
197: => ota_nhs_shd.g_old_rec.nth_information2
191: => ota_nhs_shd.g_old_rec.verified_by_id
192: ,p_nth_information_category_o
193: => ota_nhs_shd.g_old_rec.nth_information_category
194: ,p_nth_information1_o
195: => ota_nhs_shd.g_old_rec.nth_information1
196: ,p_nth_information2_o
197: => ota_nhs_shd.g_old_rec.nth_information2
198: ,p_nth_information3_o
199: => ota_nhs_shd.g_old_rec.nth_information3
193: => ota_nhs_shd.g_old_rec.nth_information_category
194: ,p_nth_information1_o
195: => ota_nhs_shd.g_old_rec.nth_information1
196: ,p_nth_information2_o
197: => ota_nhs_shd.g_old_rec.nth_information2
198: ,p_nth_information3_o
199: => ota_nhs_shd.g_old_rec.nth_information3
200: ,p_nth_information4_o
201: => ota_nhs_shd.g_old_rec.nth_information4
195: => ota_nhs_shd.g_old_rec.nth_information1
196: ,p_nth_information2_o
197: => ota_nhs_shd.g_old_rec.nth_information2
198: ,p_nth_information3_o
199: => ota_nhs_shd.g_old_rec.nth_information3
200: ,p_nth_information4_o
201: => ota_nhs_shd.g_old_rec.nth_information4
202: ,p_nth_information5_o
203: => ota_nhs_shd.g_old_rec.nth_information5
197: => ota_nhs_shd.g_old_rec.nth_information2
198: ,p_nth_information3_o
199: => ota_nhs_shd.g_old_rec.nth_information3
200: ,p_nth_information4_o
201: => ota_nhs_shd.g_old_rec.nth_information4
202: ,p_nth_information5_o
203: => ota_nhs_shd.g_old_rec.nth_information5
204: ,p_nth_information6_o
205: => ota_nhs_shd.g_old_rec.nth_information6
199: => ota_nhs_shd.g_old_rec.nth_information3
200: ,p_nth_information4_o
201: => ota_nhs_shd.g_old_rec.nth_information4
202: ,p_nth_information5_o
203: => ota_nhs_shd.g_old_rec.nth_information5
204: ,p_nth_information6_o
205: => ota_nhs_shd.g_old_rec.nth_information6
206: ,p_nth_information7_o
207: => ota_nhs_shd.g_old_rec.nth_information7
201: => ota_nhs_shd.g_old_rec.nth_information4
202: ,p_nth_information5_o
203: => ota_nhs_shd.g_old_rec.nth_information5
204: ,p_nth_information6_o
205: => ota_nhs_shd.g_old_rec.nth_information6
206: ,p_nth_information7_o
207: => ota_nhs_shd.g_old_rec.nth_information7
208: ,p_nth_information8_o
209: => ota_nhs_shd.g_old_rec.nth_information8
203: => ota_nhs_shd.g_old_rec.nth_information5
204: ,p_nth_information6_o
205: => ota_nhs_shd.g_old_rec.nth_information6
206: ,p_nth_information7_o
207: => ota_nhs_shd.g_old_rec.nth_information7
208: ,p_nth_information8_o
209: => ota_nhs_shd.g_old_rec.nth_information8
210: ,p_nth_information9_o
211: => ota_nhs_shd.g_old_rec.nth_information9
205: => ota_nhs_shd.g_old_rec.nth_information6
206: ,p_nth_information7_o
207: => ota_nhs_shd.g_old_rec.nth_information7
208: ,p_nth_information8_o
209: => ota_nhs_shd.g_old_rec.nth_information8
210: ,p_nth_information9_o
211: => ota_nhs_shd.g_old_rec.nth_information9
212: ,p_nth_information10_o
213: => ota_nhs_shd.g_old_rec.nth_information10
207: => ota_nhs_shd.g_old_rec.nth_information7
208: ,p_nth_information8_o
209: => ota_nhs_shd.g_old_rec.nth_information8
210: ,p_nth_information9_o
211: => ota_nhs_shd.g_old_rec.nth_information9
212: ,p_nth_information10_o
213: => ota_nhs_shd.g_old_rec.nth_information10
214: ,p_nth_information11_o
215: => ota_nhs_shd.g_old_rec.nth_information11
209: => ota_nhs_shd.g_old_rec.nth_information8
210: ,p_nth_information9_o
211: => ota_nhs_shd.g_old_rec.nth_information9
212: ,p_nth_information10_o
213: => ota_nhs_shd.g_old_rec.nth_information10
214: ,p_nth_information11_o
215: => ota_nhs_shd.g_old_rec.nth_information11
216: ,p_nth_information12_o
217: => ota_nhs_shd.g_old_rec.nth_information12
211: => ota_nhs_shd.g_old_rec.nth_information9
212: ,p_nth_information10_o
213: => ota_nhs_shd.g_old_rec.nth_information10
214: ,p_nth_information11_o
215: => ota_nhs_shd.g_old_rec.nth_information11
216: ,p_nth_information12_o
217: => ota_nhs_shd.g_old_rec.nth_information12
218: ,p_nth_information13_o
219: => ota_nhs_shd.g_old_rec.nth_information13
213: => ota_nhs_shd.g_old_rec.nth_information10
214: ,p_nth_information11_o
215: => ota_nhs_shd.g_old_rec.nth_information11
216: ,p_nth_information12_o
217: => ota_nhs_shd.g_old_rec.nth_information12
218: ,p_nth_information13_o
219: => ota_nhs_shd.g_old_rec.nth_information13
220: ,p_nth_information15_o
221: => ota_nhs_shd.g_old_rec.nth_information15
215: => ota_nhs_shd.g_old_rec.nth_information11
216: ,p_nth_information12_o
217: => ota_nhs_shd.g_old_rec.nth_information12
218: ,p_nth_information13_o
219: => ota_nhs_shd.g_old_rec.nth_information13
220: ,p_nth_information15_o
221: => ota_nhs_shd.g_old_rec.nth_information15
222: ,p_nth_information16_o
223: => ota_nhs_shd.g_old_rec.nth_information16
217: => ota_nhs_shd.g_old_rec.nth_information12
218: ,p_nth_information13_o
219: => ota_nhs_shd.g_old_rec.nth_information13
220: ,p_nth_information15_o
221: => ota_nhs_shd.g_old_rec.nth_information15
222: ,p_nth_information16_o
223: => ota_nhs_shd.g_old_rec.nth_information16
224: ,p_nth_information17_o
225: => ota_nhs_shd.g_old_rec.nth_information17
219: => ota_nhs_shd.g_old_rec.nth_information13
220: ,p_nth_information15_o
221: => ota_nhs_shd.g_old_rec.nth_information15
222: ,p_nth_information16_o
223: => ota_nhs_shd.g_old_rec.nth_information16
224: ,p_nth_information17_o
225: => ota_nhs_shd.g_old_rec.nth_information17
226: ,p_nth_information18_o
227: => ota_nhs_shd.g_old_rec.nth_information18
221: => ota_nhs_shd.g_old_rec.nth_information15
222: ,p_nth_information16_o
223: => ota_nhs_shd.g_old_rec.nth_information16
224: ,p_nth_information17_o
225: => ota_nhs_shd.g_old_rec.nth_information17
226: ,p_nth_information18_o
227: => ota_nhs_shd.g_old_rec.nth_information18
228: ,p_nth_information19_o
229: => ota_nhs_shd.g_old_rec.nth_information19
223: => ota_nhs_shd.g_old_rec.nth_information16
224: ,p_nth_information17_o
225: => ota_nhs_shd.g_old_rec.nth_information17
226: ,p_nth_information18_o
227: => ota_nhs_shd.g_old_rec.nth_information18
228: ,p_nth_information19_o
229: => ota_nhs_shd.g_old_rec.nth_information19
230: ,p_nth_information20_o
231: => ota_nhs_shd.g_old_rec.nth_information20
225: => ota_nhs_shd.g_old_rec.nth_information17
226: ,p_nth_information18_o
227: => ota_nhs_shd.g_old_rec.nth_information18
228: ,p_nth_information19_o
229: => ota_nhs_shd.g_old_rec.nth_information19
230: ,p_nth_information20_o
231: => ota_nhs_shd.g_old_rec.nth_information20
232: ,p_org_id_o
233: => ota_nhs_shd.g_old_rec.org_id
227: => ota_nhs_shd.g_old_rec.nth_information18
228: ,p_nth_information19_o
229: => ota_nhs_shd.g_old_rec.nth_information19
230: ,p_nth_information20_o
231: => ota_nhs_shd.g_old_rec.nth_information20
232: ,p_org_id_o
233: => ota_nhs_shd.g_old_rec.org_id
234: ,p_object_version_number_o
235: => ota_nhs_shd.g_old_rec.object_version_number
229: => ota_nhs_shd.g_old_rec.nth_information19
230: ,p_nth_information20_o
231: => ota_nhs_shd.g_old_rec.nth_information20
232: ,p_org_id_o
233: => ota_nhs_shd.g_old_rec.org_id
234: ,p_object_version_number_o
235: => ota_nhs_shd.g_old_rec.object_version_number
236: ,p_business_group_id_o
237: => ota_nhs_shd.g_old_rec.business_group_id
231: => ota_nhs_shd.g_old_rec.nth_information20
232: ,p_org_id_o
233: => ota_nhs_shd.g_old_rec.org_id
234: ,p_object_version_number_o
235: => ota_nhs_shd.g_old_rec.object_version_number
236: ,p_business_group_id_o
237: => ota_nhs_shd.g_old_rec.business_group_id
238: ,p_nth_information14_o
239: => ota_nhs_shd.g_old_rec.nth_information14
233: => ota_nhs_shd.g_old_rec.org_id
234: ,p_object_version_number_o
235: => ota_nhs_shd.g_old_rec.object_version_number
236: ,p_business_group_id_o
237: => ota_nhs_shd.g_old_rec.business_group_id
238: ,p_nth_information14_o
239: => ota_nhs_shd.g_old_rec.nth_information14
240: ,p_customer_id_o
241: => ota_nhs_shd.g_old_rec.customer_id
235: => ota_nhs_shd.g_old_rec.object_version_number
236: ,p_business_group_id_o
237: => ota_nhs_shd.g_old_rec.business_group_id
238: ,p_nth_information14_o
239: => ota_nhs_shd.g_old_rec.nth_information14
240: ,p_customer_id_o
241: => ota_nhs_shd.g_old_rec.customer_id
242: ,p_organization_id_o
243: => ota_nhs_shd.g_old_rec.organization_id
237: => ota_nhs_shd.g_old_rec.business_group_id
238: ,p_nth_information14_o
239: => ota_nhs_shd.g_old_rec.nth_information14
240: ,p_customer_id_o
241: => ota_nhs_shd.g_old_rec.customer_id
242: ,p_organization_id_o
243: => ota_nhs_shd.g_old_rec.organization_id
244: );
245: --
239: => ota_nhs_shd.g_old_rec.nth_information14
240: ,p_customer_id_o
241: => ota_nhs_shd.g_old_rec.customer_id
242: ,p_organization_id_o
243: => ota_nhs_shd.g_old_rec.organization_id
244: );
245: --
246: exception
247: --
260: -- |---------------------------------< del >----------------------------------|
261: -- ----------------------------------------------------------------------------
262: Procedure del
263: (
264: p_rec in ota_nhs_shd.g_rec_type
265: ) is
266: --
267: l_proc varchar2(72) := g_package||'del';
268: --
270: hr_utility.set_location('Entering:'||l_proc, 5);
271: --
272: -- We must lock the row which we need to delete.
273: --
274: ota_nhs_shd.lck
275: (
276: p_rec.nota_history_id,
277: p_rec.object_version_number
278: );
302: p_nota_history_id in number,
303: p_object_version_number in number
304: ) is
305: --
306: l_rec ota_nhs_shd.g_rec_type;
307: l_proc varchar2(72) := g_package||'del';
308: --
309: Begin
310: hr_utility.set_location('Entering:'||l_proc, 5);