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

Line 55: (p_rec in out nocopy ota_rud_shd.g_rec_type

51: --
52: -- {End Of Comments}
53: -- ----------------------------------------------------------------------------
54: Procedure update_dml
55: (p_rec in out nocopy ota_rud_shd.g_rec_type
56: ) is
57: --
58: l_proc varchar2(72) := g_package||'update_dml';
59: --

Line 116: ota_rud_shd.constraint_error

112: Exception
113: When hr_api.check_integrity_violated Then
114: -- A check constraint has been violated
115: --
116: ota_rud_shd.constraint_error
117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --

Line 121: ota_rud_shd.constraint_error

117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
118: When hr_api.parent_integrity_violated Then
119: -- Parent integrity has been violated
120: --
121: ota_rud_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --

Line 126: ota_rud_shd.constraint_error

122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
123: When hr_api.unique_integrity_violated Then
124: -- Unique integrity has been violated
125: --
126: ota_rud_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
128: When Others Then
129: --
130: Raise;

Line 166: (p_rec in ota_rud_shd.g_rec_type

162: --
163: -- {End Of Comments}
164: -- ----------------------------------------------------------------------------
165: Procedure pre_update
166: (p_rec in ota_rud_shd.g_rec_type
167: ) is
168: --
169: l_proc varchar2(72) := g_package||'pre_update';
170: --

Line 211: ,p_rec in ota_rud_shd.g_rec_type

207: -- {End Of Comments}
208: -- ----------------------------------------------------------------------------
209: Procedure post_update
210: (p_effective_date in date
211: ,p_rec in ota_rud_shd.g_rec_type
212: ) is
213: --
214: l_proc varchar2(72) := g_package||'post_update';
215: --

Line 291: => ota_rud_shd.g_old_rec.supplied_resource_id

287: => p_rec.rud_information20
288: ,p_offering_id
289: => p_rec.offering_id
290: ,p_supplied_resource_id_o
291: => ota_rud_shd.g_old_rec.supplied_resource_id
292: ,p_activity_version_id_o
293: => ota_rud_shd.g_old_rec.activity_version_id
294: ,p_object_version_number_o
295: => ota_rud_shd.g_old_rec.object_version_number

Line 293: => ota_rud_shd.g_old_rec.activity_version_id

289: => p_rec.offering_id
290: ,p_supplied_resource_id_o
291: => ota_rud_shd.g_old_rec.supplied_resource_id
292: ,p_activity_version_id_o
293: => ota_rud_shd.g_old_rec.activity_version_id
294: ,p_object_version_number_o
295: => ota_rud_shd.g_old_rec.object_version_number
296: ,p_required_flag_o
297: => ota_rud_shd.g_old_rec.required_flag

Line 295: => ota_rud_shd.g_old_rec.object_version_number

291: => ota_rud_shd.g_old_rec.supplied_resource_id
292: ,p_activity_version_id_o
293: => ota_rud_shd.g_old_rec.activity_version_id
294: ,p_object_version_number_o
295: => ota_rud_shd.g_old_rec.object_version_number
296: ,p_required_flag_o
297: => ota_rud_shd.g_old_rec.required_flag
298: ,p_start_date_o
299: => ota_rud_shd.g_old_rec.start_date

Line 297: => ota_rud_shd.g_old_rec.required_flag

293: => ota_rud_shd.g_old_rec.activity_version_id
294: ,p_object_version_number_o
295: => ota_rud_shd.g_old_rec.object_version_number
296: ,p_required_flag_o
297: => ota_rud_shd.g_old_rec.required_flag
298: ,p_start_date_o
299: => ota_rud_shd.g_old_rec.start_date
300: ,p_comments_o
301: => ota_rud_shd.g_old_rec.comments

Line 299: => ota_rud_shd.g_old_rec.start_date

295: => ota_rud_shd.g_old_rec.object_version_number
296: ,p_required_flag_o
297: => ota_rud_shd.g_old_rec.required_flag
298: ,p_start_date_o
299: => ota_rud_shd.g_old_rec.start_date
300: ,p_comments_o
301: => ota_rud_shd.g_old_rec.comments
302: ,p_end_date_o
303: => ota_rud_shd.g_old_rec.end_date

Line 301: => ota_rud_shd.g_old_rec.comments

297: => ota_rud_shd.g_old_rec.required_flag
298: ,p_start_date_o
299: => ota_rud_shd.g_old_rec.start_date
300: ,p_comments_o
301: => ota_rud_shd.g_old_rec.comments
302: ,p_end_date_o
303: => ota_rud_shd.g_old_rec.end_date
304: ,p_quantity_o
305: => ota_rud_shd.g_old_rec.quantity

Line 303: => ota_rud_shd.g_old_rec.end_date

299: => ota_rud_shd.g_old_rec.start_date
300: ,p_comments_o
301: => ota_rud_shd.g_old_rec.comments
302: ,p_end_date_o
303: => ota_rud_shd.g_old_rec.end_date
304: ,p_quantity_o
305: => ota_rud_shd.g_old_rec.quantity
306: ,p_resource_type_o
307: => ota_rud_shd.g_old_rec.resource_type

Line 305: => ota_rud_shd.g_old_rec.quantity

301: => ota_rud_shd.g_old_rec.comments
302: ,p_end_date_o
303: => ota_rud_shd.g_old_rec.end_date
304: ,p_quantity_o
305: => ota_rud_shd.g_old_rec.quantity
306: ,p_resource_type_o
307: => ota_rud_shd.g_old_rec.resource_type
308: ,p_role_to_play_o
309: => ota_rud_shd.g_old_rec.role_to_play

Line 307: => ota_rud_shd.g_old_rec.resource_type

303: => ota_rud_shd.g_old_rec.end_date
304: ,p_quantity_o
305: => ota_rud_shd.g_old_rec.quantity
306: ,p_resource_type_o
307: => ota_rud_shd.g_old_rec.resource_type
308: ,p_role_to_play_o
309: => ota_rud_shd.g_old_rec.role_to_play
310: ,p_usage_reason_o
311: => ota_rud_shd.g_old_rec.usage_reason

Line 309: => ota_rud_shd.g_old_rec.role_to_play

305: => ota_rud_shd.g_old_rec.quantity
306: ,p_resource_type_o
307: => ota_rud_shd.g_old_rec.resource_type
308: ,p_role_to_play_o
309: => ota_rud_shd.g_old_rec.role_to_play
310: ,p_usage_reason_o
311: => ota_rud_shd.g_old_rec.usage_reason
312: ,p_rud_information_category_o
313: => ota_rud_shd.g_old_rec.rud_information_category

Line 311: => ota_rud_shd.g_old_rec.usage_reason

307: => ota_rud_shd.g_old_rec.resource_type
308: ,p_role_to_play_o
309: => ota_rud_shd.g_old_rec.role_to_play
310: ,p_usage_reason_o
311: => ota_rud_shd.g_old_rec.usage_reason
312: ,p_rud_information_category_o
313: => ota_rud_shd.g_old_rec.rud_information_category
314: ,p_rud_information1_o
315: => ota_rud_shd.g_old_rec.rud_information1

Line 313: => ota_rud_shd.g_old_rec.rud_information_category

309: => ota_rud_shd.g_old_rec.role_to_play
310: ,p_usage_reason_o
311: => ota_rud_shd.g_old_rec.usage_reason
312: ,p_rud_information_category_o
313: => ota_rud_shd.g_old_rec.rud_information_category
314: ,p_rud_information1_o
315: => ota_rud_shd.g_old_rec.rud_information1
316: ,p_rud_information2_o
317: => ota_rud_shd.g_old_rec.rud_information2

Line 315: => ota_rud_shd.g_old_rec.rud_information1

311: => ota_rud_shd.g_old_rec.usage_reason
312: ,p_rud_information_category_o
313: => ota_rud_shd.g_old_rec.rud_information_category
314: ,p_rud_information1_o
315: => ota_rud_shd.g_old_rec.rud_information1
316: ,p_rud_information2_o
317: => ota_rud_shd.g_old_rec.rud_information2
318: ,p_rud_information3_o
319: => ota_rud_shd.g_old_rec.rud_information3

Line 317: => ota_rud_shd.g_old_rec.rud_information2

313: => ota_rud_shd.g_old_rec.rud_information_category
314: ,p_rud_information1_o
315: => ota_rud_shd.g_old_rec.rud_information1
316: ,p_rud_information2_o
317: => ota_rud_shd.g_old_rec.rud_information2
318: ,p_rud_information3_o
319: => ota_rud_shd.g_old_rec.rud_information3
320: ,p_rud_information4_o
321: => ota_rud_shd.g_old_rec.rud_information4

Line 319: => ota_rud_shd.g_old_rec.rud_information3

315: => ota_rud_shd.g_old_rec.rud_information1
316: ,p_rud_information2_o
317: => ota_rud_shd.g_old_rec.rud_information2
318: ,p_rud_information3_o
319: => ota_rud_shd.g_old_rec.rud_information3
320: ,p_rud_information4_o
321: => ota_rud_shd.g_old_rec.rud_information4
322: ,p_rud_information5_o
323: => ota_rud_shd.g_old_rec.rud_information5

Line 321: => ota_rud_shd.g_old_rec.rud_information4

317: => ota_rud_shd.g_old_rec.rud_information2
318: ,p_rud_information3_o
319: => ota_rud_shd.g_old_rec.rud_information3
320: ,p_rud_information4_o
321: => ota_rud_shd.g_old_rec.rud_information4
322: ,p_rud_information5_o
323: => ota_rud_shd.g_old_rec.rud_information5
324: ,p_rud_information6_o
325: => ota_rud_shd.g_old_rec.rud_information6

Line 323: => ota_rud_shd.g_old_rec.rud_information5

319: => ota_rud_shd.g_old_rec.rud_information3
320: ,p_rud_information4_o
321: => ota_rud_shd.g_old_rec.rud_information4
322: ,p_rud_information5_o
323: => ota_rud_shd.g_old_rec.rud_information5
324: ,p_rud_information6_o
325: => ota_rud_shd.g_old_rec.rud_information6
326: ,p_rud_information7_o
327: => ota_rud_shd.g_old_rec.rud_information7

Line 325: => ota_rud_shd.g_old_rec.rud_information6

321: => ota_rud_shd.g_old_rec.rud_information4
322: ,p_rud_information5_o
323: => ota_rud_shd.g_old_rec.rud_information5
324: ,p_rud_information6_o
325: => ota_rud_shd.g_old_rec.rud_information6
326: ,p_rud_information7_o
327: => ota_rud_shd.g_old_rec.rud_information7
328: ,p_rud_information8_o
329: => ota_rud_shd.g_old_rec.rud_information8

Line 327: => ota_rud_shd.g_old_rec.rud_information7

323: => ota_rud_shd.g_old_rec.rud_information5
324: ,p_rud_information6_o
325: => ota_rud_shd.g_old_rec.rud_information6
326: ,p_rud_information7_o
327: => ota_rud_shd.g_old_rec.rud_information7
328: ,p_rud_information8_o
329: => ota_rud_shd.g_old_rec.rud_information8
330: ,p_rud_information9_o
331: => ota_rud_shd.g_old_rec.rud_information9

Line 329: => ota_rud_shd.g_old_rec.rud_information8

325: => ota_rud_shd.g_old_rec.rud_information6
326: ,p_rud_information7_o
327: => ota_rud_shd.g_old_rec.rud_information7
328: ,p_rud_information8_o
329: => ota_rud_shd.g_old_rec.rud_information8
330: ,p_rud_information9_o
331: => ota_rud_shd.g_old_rec.rud_information9
332: ,p_rud_information10_o
333: => ota_rud_shd.g_old_rec.rud_information10

Line 331: => ota_rud_shd.g_old_rec.rud_information9

327: => ota_rud_shd.g_old_rec.rud_information7
328: ,p_rud_information8_o
329: => ota_rud_shd.g_old_rec.rud_information8
330: ,p_rud_information9_o
331: => ota_rud_shd.g_old_rec.rud_information9
332: ,p_rud_information10_o
333: => ota_rud_shd.g_old_rec.rud_information10
334: ,p_rud_information11_o
335: => ota_rud_shd.g_old_rec.rud_information11

Line 333: => ota_rud_shd.g_old_rec.rud_information10

329: => ota_rud_shd.g_old_rec.rud_information8
330: ,p_rud_information9_o
331: => ota_rud_shd.g_old_rec.rud_information9
332: ,p_rud_information10_o
333: => ota_rud_shd.g_old_rec.rud_information10
334: ,p_rud_information11_o
335: => ota_rud_shd.g_old_rec.rud_information11
336: ,p_rud_information12_o
337: => ota_rud_shd.g_old_rec.rud_information12

Line 335: => ota_rud_shd.g_old_rec.rud_information11

331: => ota_rud_shd.g_old_rec.rud_information9
332: ,p_rud_information10_o
333: => ota_rud_shd.g_old_rec.rud_information10
334: ,p_rud_information11_o
335: => ota_rud_shd.g_old_rec.rud_information11
336: ,p_rud_information12_o
337: => ota_rud_shd.g_old_rec.rud_information12
338: ,p_rud_information13_o
339: => ota_rud_shd.g_old_rec.rud_information13

Line 337: => ota_rud_shd.g_old_rec.rud_information12

333: => ota_rud_shd.g_old_rec.rud_information10
334: ,p_rud_information11_o
335: => ota_rud_shd.g_old_rec.rud_information11
336: ,p_rud_information12_o
337: => ota_rud_shd.g_old_rec.rud_information12
338: ,p_rud_information13_o
339: => ota_rud_shd.g_old_rec.rud_information13
340: ,p_rud_information14_o
341: => ota_rud_shd.g_old_rec.rud_information14

Line 339: => ota_rud_shd.g_old_rec.rud_information13

335: => ota_rud_shd.g_old_rec.rud_information11
336: ,p_rud_information12_o
337: => ota_rud_shd.g_old_rec.rud_information12
338: ,p_rud_information13_o
339: => ota_rud_shd.g_old_rec.rud_information13
340: ,p_rud_information14_o
341: => ota_rud_shd.g_old_rec.rud_information14
342: ,p_rud_information15_o
343: => ota_rud_shd.g_old_rec.rud_information15

Line 341: => ota_rud_shd.g_old_rec.rud_information14

337: => ota_rud_shd.g_old_rec.rud_information12
338: ,p_rud_information13_o
339: => ota_rud_shd.g_old_rec.rud_information13
340: ,p_rud_information14_o
341: => ota_rud_shd.g_old_rec.rud_information14
342: ,p_rud_information15_o
343: => ota_rud_shd.g_old_rec.rud_information15
344: ,p_rud_information16_o
345: => ota_rud_shd.g_old_rec.rud_information16

Line 343: => ota_rud_shd.g_old_rec.rud_information15

339: => ota_rud_shd.g_old_rec.rud_information13
340: ,p_rud_information14_o
341: => ota_rud_shd.g_old_rec.rud_information14
342: ,p_rud_information15_o
343: => ota_rud_shd.g_old_rec.rud_information15
344: ,p_rud_information16_o
345: => ota_rud_shd.g_old_rec.rud_information16
346: ,p_rud_information17_o
347: => ota_rud_shd.g_old_rec.rud_information17

Line 345: => ota_rud_shd.g_old_rec.rud_information16

341: => ota_rud_shd.g_old_rec.rud_information14
342: ,p_rud_information15_o
343: => ota_rud_shd.g_old_rec.rud_information15
344: ,p_rud_information16_o
345: => ota_rud_shd.g_old_rec.rud_information16
346: ,p_rud_information17_o
347: => ota_rud_shd.g_old_rec.rud_information17
348: ,p_rud_information18_o
349: => ota_rud_shd.g_old_rec.rud_information18

Line 347: => ota_rud_shd.g_old_rec.rud_information17

343: => ota_rud_shd.g_old_rec.rud_information15
344: ,p_rud_information16_o
345: => ota_rud_shd.g_old_rec.rud_information16
346: ,p_rud_information17_o
347: => ota_rud_shd.g_old_rec.rud_information17
348: ,p_rud_information18_o
349: => ota_rud_shd.g_old_rec.rud_information18
350: ,p_rud_information19_o
351: => ota_rud_shd.g_old_rec.rud_information19

Line 349: => ota_rud_shd.g_old_rec.rud_information18

345: => ota_rud_shd.g_old_rec.rud_information16
346: ,p_rud_information17_o
347: => ota_rud_shd.g_old_rec.rud_information17
348: ,p_rud_information18_o
349: => ota_rud_shd.g_old_rec.rud_information18
350: ,p_rud_information19_o
351: => ota_rud_shd.g_old_rec.rud_information19
352: ,p_rud_information20_o
353: => ota_rud_shd.g_old_rec.rud_information20

Line 351: => ota_rud_shd.g_old_rec.rud_information19

347: => ota_rud_shd.g_old_rec.rud_information17
348: ,p_rud_information18_o
349: => ota_rud_shd.g_old_rec.rud_information18
350: ,p_rud_information19_o
351: => ota_rud_shd.g_old_rec.rud_information19
352: ,p_rud_information20_o
353: => ota_rud_shd.g_old_rec.rud_information20
354: ,p_offering_id_o
355: => ota_rud_shd.g_old_rec.offering_id

Line 353: => ota_rud_shd.g_old_rec.rud_information20

349: => ota_rud_shd.g_old_rec.rud_information18
350: ,p_rud_information19_o
351: => ota_rud_shd.g_old_rec.rud_information19
352: ,p_rud_information20_o
353: => ota_rud_shd.g_old_rec.rud_information20
354: ,p_offering_id_o
355: => ota_rud_shd.g_old_rec.offering_id
356: );
357: --

Line 355: => ota_rud_shd.g_old_rec.offering_id

351: => ota_rud_shd.g_old_rec.rud_information19
352: ,p_rud_information20_o
353: => ota_rud_shd.g_old_rec.rud_information20
354: ,p_offering_id_o
355: => ota_rud_shd.g_old_rec.offering_id
356: );
357: --
358: exception
359: --

Line 415: (p_rec in out nocopy ota_rud_shd.g_rec_type

411: --
412: -- {End Of Comments}
413: -- ----------------------------------------------------------------------------
414: Procedure convert_defs
415: (p_rec in out nocopy ota_rud_shd.g_rec_type
416: ) is
417: --
418: Begin
419: --

Line 427: ota_rud_shd.g_old_rec.supplied_resource_id;

423: -- is being used then we must set to the 'current' argument value.
424: --
425: If (p_rec.supplied_resource_id = hr_api.g_number) then
426: p_rec.supplied_resource_id :=
427: ota_rud_shd.g_old_rec.supplied_resource_id;
428: End If;
429: If (p_rec.activity_version_id = hr_api.g_number) then
430: p_rec.activity_version_id :=
431: ota_rud_shd.g_old_rec.activity_version_id;

Line 431: ota_rud_shd.g_old_rec.activity_version_id;

427: ota_rud_shd.g_old_rec.supplied_resource_id;
428: End If;
429: If (p_rec.activity_version_id = hr_api.g_number) then
430: p_rec.activity_version_id :=
431: ota_rud_shd.g_old_rec.activity_version_id;
432: End If;
433: If (p_rec.required_flag = hr_api.g_varchar2) then
434: p_rec.required_flag :=
435: ota_rud_shd.g_old_rec.required_flag;

Line 435: ota_rud_shd.g_old_rec.required_flag;

431: ota_rud_shd.g_old_rec.activity_version_id;
432: End If;
433: If (p_rec.required_flag = hr_api.g_varchar2) then
434: p_rec.required_flag :=
435: ota_rud_shd.g_old_rec.required_flag;
436: End If;
437: If (p_rec.start_date = hr_api.g_date) then
438: p_rec.start_date :=
439: ota_rud_shd.g_old_rec.start_date;

Line 439: ota_rud_shd.g_old_rec.start_date;

435: ota_rud_shd.g_old_rec.required_flag;
436: End If;
437: If (p_rec.start_date = hr_api.g_date) then
438: p_rec.start_date :=
439: ota_rud_shd.g_old_rec.start_date;
440: End If;
441: If (p_rec.comments = hr_api.g_varchar2) then
442: p_rec.comments :=
443: ota_rud_shd.g_old_rec.comments;

Line 443: ota_rud_shd.g_old_rec.comments;

439: ota_rud_shd.g_old_rec.start_date;
440: End If;
441: If (p_rec.comments = hr_api.g_varchar2) then
442: p_rec.comments :=
443: ota_rud_shd.g_old_rec.comments;
444: End If;
445: If (p_rec.end_date = hr_api.g_date) then
446: p_rec.end_date :=
447: ota_rud_shd.g_old_rec.end_date;

Line 447: ota_rud_shd.g_old_rec.end_date;

443: ota_rud_shd.g_old_rec.comments;
444: End If;
445: If (p_rec.end_date = hr_api.g_date) then
446: p_rec.end_date :=
447: ota_rud_shd.g_old_rec.end_date;
448: End If;
449: If (p_rec.quantity = hr_api.g_number) then
450: p_rec.quantity :=
451: ota_rud_shd.g_old_rec.quantity;

Line 451: ota_rud_shd.g_old_rec.quantity;

447: ota_rud_shd.g_old_rec.end_date;
448: End If;
449: If (p_rec.quantity = hr_api.g_number) then
450: p_rec.quantity :=
451: ota_rud_shd.g_old_rec.quantity;
452: End If;
453: If (p_rec.resource_type = hr_api.g_varchar2) then
454: p_rec.resource_type :=
455: ota_rud_shd.g_old_rec.resource_type;

Line 455: ota_rud_shd.g_old_rec.resource_type;

451: ota_rud_shd.g_old_rec.quantity;
452: End If;
453: If (p_rec.resource_type = hr_api.g_varchar2) then
454: p_rec.resource_type :=
455: ota_rud_shd.g_old_rec.resource_type;
456: End If;
457: If (p_rec.role_to_play = hr_api.g_varchar2) then
458: p_rec.role_to_play :=
459: ota_rud_shd.g_old_rec.role_to_play;

Line 459: ota_rud_shd.g_old_rec.role_to_play;

455: ota_rud_shd.g_old_rec.resource_type;
456: End If;
457: If (p_rec.role_to_play = hr_api.g_varchar2) then
458: p_rec.role_to_play :=
459: ota_rud_shd.g_old_rec.role_to_play;
460: End If;
461: If (p_rec.usage_reason = hr_api.g_varchar2) then
462: p_rec.usage_reason :=
463: ota_rud_shd.g_old_rec.usage_reason;

Line 463: ota_rud_shd.g_old_rec.usage_reason;

459: ota_rud_shd.g_old_rec.role_to_play;
460: End If;
461: If (p_rec.usage_reason = hr_api.g_varchar2) then
462: p_rec.usage_reason :=
463: ota_rud_shd.g_old_rec.usage_reason;
464: End If;
465: If (p_rec.rud_information_category = hr_api.g_varchar2) then
466: p_rec.rud_information_category :=
467: ota_rud_shd.g_old_rec.rud_information_category;

Line 467: ota_rud_shd.g_old_rec.rud_information_category;

463: ota_rud_shd.g_old_rec.usage_reason;
464: End If;
465: If (p_rec.rud_information_category = hr_api.g_varchar2) then
466: p_rec.rud_information_category :=
467: ota_rud_shd.g_old_rec.rud_information_category;
468: End If;
469: If (p_rec.rud_information1 = hr_api.g_varchar2) then
470: p_rec.rud_information1 :=
471: ota_rud_shd.g_old_rec.rud_information1;

Line 471: ota_rud_shd.g_old_rec.rud_information1;

467: ota_rud_shd.g_old_rec.rud_information_category;
468: End If;
469: If (p_rec.rud_information1 = hr_api.g_varchar2) then
470: p_rec.rud_information1 :=
471: ota_rud_shd.g_old_rec.rud_information1;
472: End If;
473: If (p_rec.rud_information2 = hr_api.g_varchar2) then
474: p_rec.rud_information2 :=
475: ota_rud_shd.g_old_rec.rud_information2;

Line 475: ota_rud_shd.g_old_rec.rud_information2;

471: ota_rud_shd.g_old_rec.rud_information1;
472: End If;
473: If (p_rec.rud_information2 = hr_api.g_varchar2) then
474: p_rec.rud_information2 :=
475: ota_rud_shd.g_old_rec.rud_information2;
476: End If;
477: If (p_rec.rud_information3 = hr_api.g_varchar2) then
478: p_rec.rud_information3 :=
479: ota_rud_shd.g_old_rec.rud_information3;

Line 479: ota_rud_shd.g_old_rec.rud_information3;

475: ota_rud_shd.g_old_rec.rud_information2;
476: End If;
477: If (p_rec.rud_information3 = hr_api.g_varchar2) then
478: p_rec.rud_information3 :=
479: ota_rud_shd.g_old_rec.rud_information3;
480: End If;
481: If (p_rec.rud_information4 = hr_api.g_varchar2) then
482: p_rec.rud_information4 :=
483: ota_rud_shd.g_old_rec.rud_information4;

Line 483: ota_rud_shd.g_old_rec.rud_information4;

479: ota_rud_shd.g_old_rec.rud_information3;
480: End If;
481: If (p_rec.rud_information4 = hr_api.g_varchar2) then
482: p_rec.rud_information4 :=
483: ota_rud_shd.g_old_rec.rud_information4;
484: End If;
485: If (p_rec.rud_information5 = hr_api.g_varchar2) then
486: p_rec.rud_information5 :=
487: ota_rud_shd.g_old_rec.rud_information5;

Line 487: ota_rud_shd.g_old_rec.rud_information5;

483: ota_rud_shd.g_old_rec.rud_information4;
484: End If;
485: If (p_rec.rud_information5 = hr_api.g_varchar2) then
486: p_rec.rud_information5 :=
487: ota_rud_shd.g_old_rec.rud_information5;
488: End If;
489: If (p_rec.rud_information6 = hr_api.g_varchar2) then
490: p_rec.rud_information6 :=
491: ota_rud_shd.g_old_rec.rud_information6;

Line 491: ota_rud_shd.g_old_rec.rud_information6;

487: ota_rud_shd.g_old_rec.rud_information5;
488: End If;
489: If (p_rec.rud_information6 = hr_api.g_varchar2) then
490: p_rec.rud_information6 :=
491: ota_rud_shd.g_old_rec.rud_information6;
492: End If;
493: If (p_rec.rud_information7 = hr_api.g_varchar2) then
494: p_rec.rud_information7 :=
495: ota_rud_shd.g_old_rec.rud_information7;

Line 495: ota_rud_shd.g_old_rec.rud_information7;

491: ota_rud_shd.g_old_rec.rud_information6;
492: End If;
493: If (p_rec.rud_information7 = hr_api.g_varchar2) then
494: p_rec.rud_information7 :=
495: ota_rud_shd.g_old_rec.rud_information7;
496: End If;
497: If (p_rec.rud_information8 = hr_api.g_varchar2) then
498: p_rec.rud_information8 :=
499: ota_rud_shd.g_old_rec.rud_information8;

Line 499: ota_rud_shd.g_old_rec.rud_information8;

495: ota_rud_shd.g_old_rec.rud_information7;
496: End If;
497: If (p_rec.rud_information8 = hr_api.g_varchar2) then
498: p_rec.rud_information8 :=
499: ota_rud_shd.g_old_rec.rud_information8;
500: End If;
501: If (p_rec.rud_information9 = hr_api.g_varchar2) then
502: p_rec.rud_information9 :=
503: ota_rud_shd.g_old_rec.rud_information9;

Line 503: ota_rud_shd.g_old_rec.rud_information9;

499: ota_rud_shd.g_old_rec.rud_information8;
500: End If;
501: If (p_rec.rud_information9 = hr_api.g_varchar2) then
502: p_rec.rud_information9 :=
503: ota_rud_shd.g_old_rec.rud_information9;
504: End If;
505: If (p_rec.rud_information10 = hr_api.g_varchar2) then
506: p_rec.rud_information10 :=
507: ota_rud_shd.g_old_rec.rud_information10;

Line 507: ota_rud_shd.g_old_rec.rud_information10;

503: ota_rud_shd.g_old_rec.rud_information9;
504: End If;
505: If (p_rec.rud_information10 = hr_api.g_varchar2) then
506: p_rec.rud_information10 :=
507: ota_rud_shd.g_old_rec.rud_information10;
508: End If;
509: If (p_rec.rud_information11 = hr_api.g_varchar2) then
510: p_rec.rud_information11 :=
511: ota_rud_shd.g_old_rec.rud_information11;

Line 511: ota_rud_shd.g_old_rec.rud_information11;

507: ota_rud_shd.g_old_rec.rud_information10;
508: End If;
509: If (p_rec.rud_information11 = hr_api.g_varchar2) then
510: p_rec.rud_information11 :=
511: ota_rud_shd.g_old_rec.rud_information11;
512: End If;
513: If (p_rec.rud_information12 = hr_api.g_varchar2) then
514: p_rec.rud_information12 :=
515: ota_rud_shd.g_old_rec.rud_information12;

Line 515: ota_rud_shd.g_old_rec.rud_information12;

511: ota_rud_shd.g_old_rec.rud_information11;
512: End If;
513: If (p_rec.rud_information12 = hr_api.g_varchar2) then
514: p_rec.rud_information12 :=
515: ota_rud_shd.g_old_rec.rud_information12;
516: End If;
517: If (p_rec.rud_information13 = hr_api.g_varchar2) then
518: p_rec.rud_information13 :=
519: ota_rud_shd.g_old_rec.rud_information13;

Line 519: ota_rud_shd.g_old_rec.rud_information13;

515: ota_rud_shd.g_old_rec.rud_information12;
516: End If;
517: If (p_rec.rud_information13 = hr_api.g_varchar2) then
518: p_rec.rud_information13 :=
519: ota_rud_shd.g_old_rec.rud_information13;
520: End If;
521: If (p_rec.rud_information14 = hr_api.g_varchar2) then
522: p_rec.rud_information14 :=
523: ota_rud_shd.g_old_rec.rud_information14;

Line 523: ota_rud_shd.g_old_rec.rud_information14;

519: ota_rud_shd.g_old_rec.rud_information13;
520: End If;
521: If (p_rec.rud_information14 = hr_api.g_varchar2) then
522: p_rec.rud_information14 :=
523: ota_rud_shd.g_old_rec.rud_information14;
524: End If;
525: If (p_rec.rud_information15 = hr_api.g_varchar2) then
526: p_rec.rud_information15 :=
527: ota_rud_shd.g_old_rec.rud_information15;

Line 527: ota_rud_shd.g_old_rec.rud_information15;

523: ota_rud_shd.g_old_rec.rud_information14;
524: End If;
525: If (p_rec.rud_information15 = hr_api.g_varchar2) then
526: p_rec.rud_information15 :=
527: ota_rud_shd.g_old_rec.rud_information15;
528: End If;
529: If (p_rec.rud_information16 = hr_api.g_varchar2) then
530: p_rec.rud_information16 :=
531: ota_rud_shd.g_old_rec.rud_information16;

Line 531: ota_rud_shd.g_old_rec.rud_information16;

527: ota_rud_shd.g_old_rec.rud_information15;
528: End If;
529: If (p_rec.rud_information16 = hr_api.g_varchar2) then
530: p_rec.rud_information16 :=
531: ota_rud_shd.g_old_rec.rud_information16;
532: End If;
533: If (p_rec.rud_information17 = hr_api.g_varchar2) then
534: p_rec.rud_information17 :=
535: ota_rud_shd.g_old_rec.rud_information17;

Line 535: ota_rud_shd.g_old_rec.rud_information17;

531: ota_rud_shd.g_old_rec.rud_information16;
532: End If;
533: If (p_rec.rud_information17 = hr_api.g_varchar2) then
534: p_rec.rud_information17 :=
535: ota_rud_shd.g_old_rec.rud_information17;
536: End If;
537: If (p_rec.rud_information18 = hr_api.g_varchar2) then
538: p_rec.rud_information18 :=
539: ota_rud_shd.g_old_rec.rud_information18;

Line 539: ota_rud_shd.g_old_rec.rud_information18;

535: ota_rud_shd.g_old_rec.rud_information17;
536: End If;
537: If (p_rec.rud_information18 = hr_api.g_varchar2) then
538: p_rec.rud_information18 :=
539: ota_rud_shd.g_old_rec.rud_information18;
540: End If;
541: If (p_rec.rud_information19 = hr_api.g_varchar2) then
542: p_rec.rud_information19 :=
543: ota_rud_shd.g_old_rec.rud_information19;

Line 543: ota_rud_shd.g_old_rec.rud_information19;

539: ota_rud_shd.g_old_rec.rud_information18;
540: End If;
541: If (p_rec.rud_information19 = hr_api.g_varchar2) then
542: p_rec.rud_information19 :=
543: ota_rud_shd.g_old_rec.rud_information19;
544: End If;
545: If (p_rec.rud_information20 = hr_api.g_varchar2) then
546: p_rec.rud_information20 :=
547: ota_rud_shd.g_old_rec.rud_information20;

Line 547: ota_rud_shd.g_old_rec.rud_information20;

543: ota_rud_shd.g_old_rec.rud_information19;
544: End If;
545: If (p_rec.rud_information20 = hr_api.g_varchar2) then
546: p_rec.rud_information20 :=
547: ota_rud_shd.g_old_rec.rud_information20;
548: End If;
549: If (p_rec.offering_id = hr_api.g_number) then
550: p_rec.offering_id :=
551: ota_rud_shd.g_old_rec.offering_id;

Line 551: ota_rud_shd.g_old_rec.offering_id;

547: ota_rud_shd.g_old_rec.rud_information20;
548: End If;
549: If (p_rec.offering_id = hr_api.g_number) then
550: p_rec.offering_id :=
551: ota_rud_shd.g_old_rec.offering_id;
552: End If;
553: --
554: End convert_defs;
555: --

Line 561: ,p_rec in out nocopy ota_rud_shd.g_rec_type

557: -- |---------------------------------< upd >----------------------------------|
558: -- ----------------------------------------------------------------------------
559: Procedure upd
560: (p_effective_date in date
561: ,p_rec in out nocopy ota_rud_shd.g_rec_type
562: ) is
563: --
564: l_proc varchar2(72) := g_package||'upd';
565: --

Line 571: ota_rud_shd.lck

567: hr_utility.set_location('Entering:'||l_proc, 5);
568: --
569: -- We must lock the row which we need to update.
570: --
571: ota_rud_shd.lck
572: (p_rec.resource_usage_id
573: ,p_rec.object_version_number
574: );
575: --

Line 651: l_rec ota_rud_shd.g_rec_type;

647: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
648: ,p_offering_id in number default hr_api.g_number
649: ) is
650: --
651: l_rec ota_rud_shd.g_rec_type;
652: l_proc varchar2(72) := g_package||'upd';
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);

Line 661: ota_rud_shd.convert_args

657: -- Call conversion function to turn arguments into the
658: -- l_rec structure.
659: --
660: l_rec :=
661: ota_rud_shd.convert_args
662: (p_resource_usage_id
663: ,p_supplied_resource_id
664: ,p_activity_version_id
665: ,p_object_version_number