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_RUD_DEL dependencies on OTA_RUD_SHD

Line 52: (p_rec in ota_rud_shd.g_rec_type

48: --
49: -- {End Of Comments}
50: -- ----------------------------------------------------------------------------
51: Procedure delete_dml
52: (p_rec in ota_rud_shd.g_rec_type
53: ) is
54: --
55: l_proc varchar2(72) := g_package||'delete_dml';
56: --

Line 75: ota_rud_shd.constraint_error

71: Exception
72: When hr_api.child_integrity_violated then
73: -- Child integrity has been violated
74: --
75: ota_rud_shd.constraint_error
76: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
77: When Others Then
78: --
79: Raise;

Line 114: Procedure pre_delete(p_rec in ota_rud_shd.g_rec_type) is

110: -- Internal Row Handler Use Only.
111: --
112: -- {End Of Comments}
113: -- ----------------------------------------------------------------------------
114: Procedure pre_delete(p_rec in ota_rud_shd.g_rec_type) is
115: --
116: l_proc varchar2(72) := g_package||'pre_delete';
117: --
118: Begin

Line 156: Procedure post_delete(p_rec in ota_rud_shd.g_rec_type) is

152: -- Internal Row Handler Use Only.
153: --
154: -- {End Of Comments}
155: -- -----------------------------------------------------------------------------
156: Procedure post_delete(p_rec in ota_rud_shd.g_rec_type) is
157: --
158: l_proc varchar2(72) := g_package||'post_delete';
159: --
160: Begin

Line 168: => ota_rud_shd.g_old_rec.supplied_resource_id

164: ota_rud_rkd.after_delete
165: (p_resource_usage_id
166: => p_rec.resource_usage_id
167: ,p_supplied_resource_id_o
168: => ota_rud_shd.g_old_rec.supplied_resource_id
169: ,p_activity_version_id_o
170: => ota_rud_shd.g_old_rec.activity_version_id
171: ,p_object_version_number_o
172: => ota_rud_shd.g_old_rec.object_version_number

Line 170: => ota_rud_shd.g_old_rec.activity_version_id

166: => p_rec.resource_usage_id
167: ,p_supplied_resource_id_o
168: => ota_rud_shd.g_old_rec.supplied_resource_id
169: ,p_activity_version_id_o
170: => ota_rud_shd.g_old_rec.activity_version_id
171: ,p_object_version_number_o
172: => ota_rud_shd.g_old_rec.object_version_number
173: ,p_required_flag_o
174: => ota_rud_shd.g_old_rec.required_flag

Line 172: => ota_rud_shd.g_old_rec.object_version_number

168: => ota_rud_shd.g_old_rec.supplied_resource_id
169: ,p_activity_version_id_o
170: => ota_rud_shd.g_old_rec.activity_version_id
171: ,p_object_version_number_o
172: => ota_rud_shd.g_old_rec.object_version_number
173: ,p_required_flag_o
174: => ota_rud_shd.g_old_rec.required_flag
175: ,p_start_date_o
176: => ota_rud_shd.g_old_rec.start_date

Line 174: => ota_rud_shd.g_old_rec.required_flag

170: => ota_rud_shd.g_old_rec.activity_version_id
171: ,p_object_version_number_o
172: => ota_rud_shd.g_old_rec.object_version_number
173: ,p_required_flag_o
174: => ota_rud_shd.g_old_rec.required_flag
175: ,p_start_date_o
176: => ota_rud_shd.g_old_rec.start_date
177: ,p_comments_o
178: => ota_rud_shd.g_old_rec.comments

Line 176: => ota_rud_shd.g_old_rec.start_date

172: => ota_rud_shd.g_old_rec.object_version_number
173: ,p_required_flag_o
174: => ota_rud_shd.g_old_rec.required_flag
175: ,p_start_date_o
176: => ota_rud_shd.g_old_rec.start_date
177: ,p_comments_o
178: => ota_rud_shd.g_old_rec.comments
179: ,p_end_date_o
180: => ota_rud_shd.g_old_rec.end_date

Line 178: => ota_rud_shd.g_old_rec.comments

174: => ota_rud_shd.g_old_rec.required_flag
175: ,p_start_date_o
176: => ota_rud_shd.g_old_rec.start_date
177: ,p_comments_o
178: => ota_rud_shd.g_old_rec.comments
179: ,p_end_date_o
180: => ota_rud_shd.g_old_rec.end_date
181: ,p_quantity_o
182: => ota_rud_shd.g_old_rec.quantity

Line 180: => ota_rud_shd.g_old_rec.end_date

176: => ota_rud_shd.g_old_rec.start_date
177: ,p_comments_o
178: => ota_rud_shd.g_old_rec.comments
179: ,p_end_date_o
180: => ota_rud_shd.g_old_rec.end_date
181: ,p_quantity_o
182: => ota_rud_shd.g_old_rec.quantity
183: ,p_resource_type_o
184: => ota_rud_shd.g_old_rec.resource_type

Line 182: => ota_rud_shd.g_old_rec.quantity

178: => ota_rud_shd.g_old_rec.comments
179: ,p_end_date_o
180: => ota_rud_shd.g_old_rec.end_date
181: ,p_quantity_o
182: => ota_rud_shd.g_old_rec.quantity
183: ,p_resource_type_o
184: => ota_rud_shd.g_old_rec.resource_type
185: ,p_role_to_play_o
186: => ota_rud_shd.g_old_rec.role_to_play

Line 184: => ota_rud_shd.g_old_rec.resource_type

180: => ota_rud_shd.g_old_rec.end_date
181: ,p_quantity_o
182: => ota_rud_shd.g_old_rec.quantity
183: ,p_resource_type_o
184: => ota_rud_shd.g_old_rec.resource_type
185: ,p_role_to_play_o
186: => ota_rud_shd.g_old_rec.role_to_play
187: ,p_usage_reason_o
188: => ota_rud_shd.g_old_rec.usage_reason

Line 186: => ota_rud_shd.g_old_rec.role_to_play

182: => ota_rud_shd.g_old_rec.quantity
183: ,p_resource_type_o
184: => ota_rud_shd.g_old_rec.resource_type
185: ,p_role_to_play_o
186: => ota_rud_shd.g_old_rec.role_to_play
187: ,p_usage_reason_o
188: => ota_rud_shd.g_old_rec.usage_reason
189: ,p_rud_information_category_o
190: => ota_rud_shd.g_old_rec.rud_information_category

Line 188: => ota_rud_shd.g_old_rec.usage_reason

184: => ota_rud_shd.g_old_rec.resource_type
185: ,p_role_to_play_o
186: => ota_rud_shd.g_old_rec.role_to_play
187: ,p_usage_reason_o
188: => ota_rud_shd.g_old_rec.usage_reason
189: ,p_rud_information_category_o
190: => ota_rud_shd.g_old_rec.rud_information_category
191: ,p_rud_information1_o
192: => ota_rud_shd.g_old_rec.rud_information1

Line 190: => ota_rud_shd.g_old_rec.rud_information_category

186: => ota_rud_shd.g_old_rec.role_to_play
187: ,p_usage_reason_o
188: => ota_rud_shd.g_old_rec.usage_reason
189: ,p_rud_information_category_o
190: => ota_rud_shd.g_old_rec.rud_information_category
191: ,p_rud_information1_o
192: => ota_rud_shd.g_old_rec.rud_information1
193: ,p_rud_information2_o
194: => ota_rud_shd.g_old_rec.rud_information2

Line 192: => ota_rud_shd.g_old_rec.rud_information1

188: => ota_rud_shd.g_old_rec.usage_reason
189: ,p_rud_information_category_o
190: => ota_rud_shd.g_old_rec.rud_information_category
191: ,p_rud_information1_o
192: => ota_rud_shd.g_old_rec.rud_information1
193: ,p_rud_information2_o
194: => ota_rud_shd.g_old_rec.rud_information2
195: ,p_rud_information3_o
196: => ota_rud_shd.g_old_rec.rud_information3

Line 194: => ota_rud_shd.g_old_rec.rud_information2

190: => ota_rud_shd.g_old_rec.rud_information_category
191: ,p_rud_information1_o
192: => ota_rud_shd.g_old_rec.rud_information1
193: ,p_rud_information2_o
194: => ota_rud_shd.g_old_rec.rud_information2
195: ,p_rud_information3_o
196: => ota_rud_shd.g_old_rec.rud_information3
197: ,p_rud_information4_o
198: => ota_rud_shd.g_old_rec.rud_information4

Line 196: => ota_rud_shd.g_old_rec.rud_information3

192: => ota_rud_shd.g_old_rec.rud_information1
193: ,p_rud_information2_o
194: => ota_rud_shd.g_old_rec.rud_information2
195: ,p_rud_information3_o
196: => ota_rud_shd.g_old_rec.rud_information3
197: ,p_rud_information4_o
198: => ota_rud_shd.g_old_rec.rud_information4
199: ,p_rud_information5_o
200: => ota_rud_shd.g_old_rec.rud_information5

Line 198: => ota_rud_shd.g_old_rec.rud_information4

194: => ota_rud_shd.g_old_rec.rud_information2
195: ,p_rud_information3_o
196: => ota_rud_shd.g_old_rec.rud_information3
197: ,p_rud_information4_o
198: => ota_rud_shd.g_old_rec.rud_information4
199: ,p_rud_information5_o
200: => ota_rud_shd.g_old_rec.rud_information5
201: ,p_rud_information6_o
202: => ota_rud_shd.g_old_rec.rud_information6

Line 200: => ota_rud_shd.g_old_rec.rud_information5

196: => ota_rud_shd.g_old_rec.rud_information3
197: ,p_rud_information4_o
198: => ota_rud_shd.g_old_rec.rud_information4
199: ,p_rud_information5_o
200: => ota_rud_shd.g_old_rec.rud_information5
201: ,p_rud_information6_o
202: => ota_rud_shd.g_old_rec.rud_information6
203: ,p_rud_information7_o
204: => ota_rud_shd.g_old_rec.rud_information7

Line 202: => ota_rud_shd.g_old_rec.rud_information6

198: => ota_rud_shd.g_old_rec.rud_information4
199: ,p_rud_information5_o
200: => ota_rud_shd.g_old_rec.rud_information5
201: ,p_rud_information6_o
202: => ota_rud_shd.g_old_rec.rud_information6
203: ,p_rud_information7_o
204: => ota_rud_shd.g_old_rec.rud_information7
205: ,p_rud_information8_o
206: => ota_rud_shd.g_old_rec.rud_information8

Line 204: => ota_rud_shd.g_old_rec.rud_information7

200: => ota_rud_shd.g_old_rec.rud_information5
201: ,p_rud_information6_o
202: => ota_rud_shd.g_old_rec.rud_information6
203: ,p_rud_information7_o
204: => ota_rud_shd.g_old_rec.rud_information7
205: ,p_rud_information8_o
206: => ota_rud_shd.g_old_rec.rud_information8
207: ,p_rud_information9_o
208: => ota_rud_shd.g_old_rec.rud_information9

Line 206: => ota_rud_shd.g_old_rec.rud_information8

202: => ota_rud_shd.g_old_rec.rud_information6
203: ,p_rud_information7_o
204: => ota_rud_shd.g_old_rec.rud_information7
205: ,p_rud_information8_o
206: => ota_rud_shd.g_old_rec.rud_information8
207: ,p_rud_information9_o
208: => ota_rud_shd.g_old_rec.rud_information9
209: ,p_rud_information10_o
210: => ota_rud_shd.g_old_rec.rud_information10

Line 208: => ota_rud_shd.g_old_rec.rud_information9

204: => ota_rud_shd.g_old_rec.rud_information7
205: ,p_rud_information8_o
206: => ota_rud_shd.g_old_rec.rud_information8
207: ,p_rud_information9_o
208: => ota_rud_shd.g_old_rec.rud_information9
209: ,p_rud_information10_o
210: => ota_rud_shd.g_old_rec.rud_information10
211: ,p_rud_information11_o
212: => ota_rud_shd.g_old_rec.rud_information11

Line 210: => ota_rud_shd.g_old_rec.rud_information10

206: => ota_rud_shd.g_old_rec.rud_information8
207: ,p_rud_information9_o
208: => ota_rud_shd.g_old_rec.rud_information9
209: ,p_rud_information10_o
210: => ota_rud_shd.g_old_rec.rud_information10
211: ,p_rud_information11_o
212: => ota_rud_shd.g_old_rec.rud_information11
213: ,p_rud_information12_o
214: => ota_rud_shd.g_old_rec.rud_information12

Line 212: => ota_rud_shd.g_old_rec.rud_information11

208: => ota_rud_shd.g_old_rec.rud_information9
209: ,p_rud_information10_o
210: => ota_rud_shd.g_old_rec.rud_information10
211: ,p_rud_information11_o
212: => ota_rud_shd.g_old_rec.rud_information11
213: ,p_rud_information12_o
214: => ota_rud_shd.g_old_rec.rud_information12
215: ,p_rud_information13_o
216: => ota_rud_shd.g_old_rec.rud_information13

Line 214: => ota_rud_shd.g_old_rec.rud_information12

210: => ota_rud_shd.g_old_rec.rud_information10
211: ,p_rud_information11_o
212: => ota_rud_shd.g_old_rec.rud_information11
213: ,p_rud_information12_o
214: => ota_rud_shd.g_old_rec.rud_information12
215: ,p_rud_information13_o
216: => ota_rud_shd.g_old_rec.rud_information13
217: ,p_rud_information14_o
218: => ota_rud_shd.g_old_rec.rud_information14

Line 216: => ota_rud_shd.g_old_rec.rud_information13

212: => ota_rud_shd.g_old_rec.rud_information11
213: ,p_rud_information12_o
214: => ota_rud_shd.g_old_rec.rud_information12
215: ,p_rud_information13_o
216: => ota_rud_shd.g_old_rec.rud_information13
217: ,p_rud_information14_o
218: => ota_rud_shd.g_old_rec.rud_information14
219: ,p_rud_information15_o
220: => ota_rud_shd.g_old_rec.rud_information15

Line 218: => ota_rud_shd.g_old_rec.rud_information14

214: => ota_rud_shd.g_old_rec.rud_information12
215: ,p_rud_information13_o
216: => ota_rud_shd.g_old_rec.rud_information13
217: ,p_rud_information14_o
218: => ota_rud_shd.g_old_rec.rud_information14
219: ,p_rud_information15_o
220: => ota_rud_shd.g_old_rec.rud_information15
221: ,p_rud_information16_o
222: => ota_rud_shd.g_old_rec.rud_information16

Line 220: => ota_rud_shd.g_old_rec.rud_information15

216: => ota_rud_shd.g_old_rec.rud_information13
217: ,p_rud_information14_o
218: => ota_rud_shd.g_old_rec.rud_information14
219: ,p_rud_information15_o
220: => ota_rud_shd.g_old_rec.rud_information15
221: ,p_rud_information16_o
222: => ota_rud_shd.g_old_rec.rud_information16
223: ,p_rud_information17_o
224: => ota_rud_shd.g_old_rec.rud_information17

Line 222: => ota_rud_shd.g_old_rec.rud_information16

218: => ota_rud_shd.g_old_rec.rud_information14
219: ,p_rud_information15_o
220: => ota_rud_shd.g_old_rec.rud_information15
221: ,p_rud_information16_o
222: => ota_rud_shd.g_old_rec.rud_information16
223: ,p_rud_information17_o
224: => ota_rud_shd.g_old_rec.rud_information17
225: ,p_rud_information18_o
226: => ota_rud_shd.g_old_rec.rud_information18

Line 224: => ota_rud_shd.g_old_rec.rud_information17

220: => ota_rud_shd.g_old_rec.rud_information15
221: ,p_rud_information16_o
222: => ota_rud_shd.g_old_rec.rud_information16
223: ,p_rud_information17_o
224: => ota_rud_shd.g_old_rec.rud_information17
225: ,p_rud_information18_o
226: => ota_rud_shd.g_old_rec.rud_information18
227: ,p_rud_information19_o
228: => ota_rud_shd.g_old_rec.rud_information19

Line 226: => ota_rud_shd.g_old_rec.rud_information18

222: => ota_rud_shd.g_old_rec.rud_information16
223: ,p_rud_information17_o
224: => ota_rud_shd.g_old_rec.rud_information17
225: ,p_rud_information18_o
226: => ota_rud_shd.g_old_rec.rud_information18
227: ,p_rud_information19_o
228: => ota_rud_shd.g_old_rec.rud_information19
229: ,p_rud_information20_o
230: => ota_rud_shd.g_old_rec.rud_information20

Line 228: => ota_rud_shd.g_old_rec.rud_information19

224: => ota_rud_shd.g_old_rec.rud_information17
225: ,p_rud_information18_o
226: => ota_rud_shd.g_old_rec.rud_information18
227: ,p_rud_information19_o
228: => ota_rud_shd.g_old_rec.rud_information19
229: ,p_rud_information20_o
230: => ota_rud_shd.g_old_rec.rud_information20
231: ,p_offering_id_o
232: => ota_rud_shd.g_old_rec.offering_id

Line 230: => ota_rud_shd.g_old_rec.rud_information20

226: => ota_rud_shd.g_old_rec.rud_information18
227: ,p_rud_information19_o
228: => ota_rud_shd.g_old_rec.rud_information19
229: ,p_rud_information20_o
230: => ota_rud_shd.g_old_rec.rud_information20
231: ,p_offering_id_o
232: => ota_rud_shd.g_old_rec.offering_id
233: );
234: --

Line 232: => ota_rud_shd.g_old_rec.offering_id

228: => ota_rud_shd.g_old_rec.rud_information19
229: ,p_rud_information20_o
230: => ota_rud_shd.g_old_rec.rud_information20
231: ,p_offering_id_o
232: => ota_rud_shd.g_old_rec.offering_id
233: );
234: --
235: exception
236: --

Line 252: (p_rec in ota_rud_shd.g_rec_type

248: -- ----------------------------------------------------------------------------
249: -- |---------------------------------< del >----------------------------------|
250: -- ----------------------------------------------------------------------------
251: Procedure del
252: (p_rec in ota_rud_shd.g_rec_type
253: ) is
254: --
255: l_proc varchar2(72) := g_package||'del';
256: --

Line 262: ota_rud_shd.lck

258: hr_utility.set_location('Entering:'||l_proc, 5);
259: --
260: -- We must lock the row which we need to delete.
261: --
262: ota_rud_shd.lck
263: (p_rec.resource_usage_id
264: ,p_rec.object_version_number
265: );
266: --

Line 299: l_rec ota_rud_shd.g_rec_type;

295: (p_resource_usage_id in number
296: ,p_object_version_number in number
297: ) is
298: --
299: l_rec ota_rud_shd.g_rec_type;
300: l_proc varchar2(72) := g_package||'del';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);