eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_NHS_DEL dependencies on OTA_NHS_SHD

Line 51: Procedure delete_dml(p_rec in ota_nhs_shd.g_rec_type) is

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

Line 58: ota_nhs_shd.g_api_dml := true; -- Set the api dml status

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

Line 65: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 72: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

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

Line 73: ota_nhs_shd.constraint_error

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;

Line 76: ota_nhs_shd.g_api_dml := false; -- Unset the api dml status

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: -- ----------------------------------------------------------------------------

Line 112: Procedure pre_delete(p_rec in ota_nhs_shd.g_rec_type) is

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

Line 154: Procedure post_delete(p_rec in ota_nhs_shd.g_rec_type) is

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

Line 165: => ota_nhs_shd.g_old_rec.person_id

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

Line 167: => ota_nhs_shd.g_old_rec.contact_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
170: ,p_provider_o
171: => ota_nhs_shd.g_old_rec.provider

Line 169: => ota_nhs_shd.g_old_rec.trng_title

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

Line 171: => ota_nhs_shd.g_old_rec.provider

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

Line 173: => ota_nhs_shd.g_old_rec.type

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

Line 175: => ota_nhs_shd.g_old_rec.centre

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

Line 177: => ota_nhs_shd.g_old_rec.completion_date

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

Line 179: => ota_nhs_shd.g_old_rec.award

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

Line 181: => ota_nhs_shd.g_old_rec.rating

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

Line 183: => ota_nhs_shd.g_old_rec.duration

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

Line 185: => ota_nhs_shd.g_old_rec.duration_units

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

Line 187: => ota_nhs_shd.g_old_rec.activity_version_id

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

Line 189: => ota_nhs_shd.g_old_rec.status

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

Line 191: => ota_nhs_shd.g_old_rec.verified_by_id

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

Line 193: => ota_nhs_shd.g_old_rec.nth_information_category

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

Line 195: => ota_nhs_shd.g_old_rec.nth_information1

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

Line 197: => ota_nhs_shd.g_old_rec.nth_information2

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

Line 199: => ota_nhs_shd.g_old_rec.nth_information3

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

Line 201: => ota_nhs_shd.g_old_rec.nth_information4

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

Line 203: => ota_nhs_shd.g_old_rec.nth_information5

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

Line 205: => ota_nhs_shd.g_old_rec.nth_information6

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

Line 207: => ota_nhs_shd.g_old_rec.nth_information7

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

Line 209: => ota_nhs_shd.g_old_rec.nth_information8

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

Line 211: => ota_nhs_shd.g_old_rec.nth_information9

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

Line 213: => ota_nhs_shd.g_old_rec.nth_information10

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

Line 215: => ota_nhs_shd.g_old_rec.nth_information11

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

Line 217: => ota_nhs_shd.g_old_rec.nth_information12

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

Line 219: => ota_nhs_shd.g_old_rec.nth_information13

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

Line 221: => ota_nhs_shd.g_old_rec.nth_information15

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

Line 223: => ota_nhs_shd.g_old_rec.nth_information16

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

Line 225: => ota_nhs_shd.g_old_rec.nth_information17

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

Line 227: => ota_nhs_shd.g_old_rec.nth_information18

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

Line 229: => ota_nhs_shd.g_old_rec.nth_information19

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

Line 231: => ota_nhs_shd.g_old_rec.nth_information20

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

Line 233: => ota_nhs_shd.g_old_rec.org_id

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

Line 235: => ota_nhs_shd.g_old_rec.object_version_number

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

Line 237: => ota_nhs_shd.g_old_rec.business_group_id

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

Line 239: => ota_nhs_shd.g_old_rec.nth_information14

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

Line 241: => ota_nhs_shd.g_old_rec.customer_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: --

Line 243: => ota_nhs_shd.g_old_rec.organization_id

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: --

Line 264: p_rec in ota_nhs_shd.g_rec_type

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: --

Line 274: ota_nhs_shd.lck

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: );

Line 306: l_rec ota_nhs_shd.g_rec_type;

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);