APPS.OTA_RUD_UPD dependencies on HR_API

Line 113: When hr_api.check_integrity_violated Then

109: --
110: hr_utility.set_location(' Leaving:'||l_proc, 10);
111: --
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));

Line 117: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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: --
121: ota_rud_shd.constraint_error

Line 118: When hr_api.parent_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: --
121: ota_rud_shd.constraint_error
122: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 122: (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: --
126: ota_rud_shd.constraint_error

Line 123: When hr_api.unique_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: --
126: ota_rud_shd.constraint_error
127: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 127: (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;
131: End update_dml;

Line 360: when hr_api.cannot_find_prog_unit then

356: );
357: --
358: exception
359: --
360: when hr_api.cannot_find_prog_unit then
361: --
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'OTA_RESOURCE_USAGES'
364: ,p_hook_type => 'AU');

Line 362: hr_api.cannot_find_prog_unit_error

358: exception
359: --
360: when hr_api.cannot_find_prog_unit then
361: --
362: hr_api.cannot_find_prog_unit_error
363: (p_module_name => 'OTA_RESOURCE_USAGES'
364: ,p_hook_type => 'AU');
365: --
366: end;

Line 425: If (p_rec.supplied_resource_id = hr_api.g_number) then

421: -- p_rec plsql record structure
422: -- to see if a system default is being used. If a system default
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

Line 429: If (p_rec.activity_version_id = hr_api.g_number) then

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;
432: End If;
433: If (p_rec.required_flag = hr_api.g_varchar2) then

Line 433: If (p_rec.required_flag = hr_api.g_varchar2) then

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;
436: End If;
437: If (p_rec.start_date = hr_api.g_date) then

Line 437: If (p_rec.start_date = hr_api.g_date) then

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;
440: End If;
441: If (p_rec.comments = hr_api.g_varchar2) then

Line 441: If (p_rec.comments = hr_api.g_varchar2) then

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;
444: End If;
445: If (p_rec.end_date = hr_api.g_date) then

Line 445: If (p_rec.end_date = hr_api.g_date) then

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;
448: End If;
449: If (p_rec.quantity = hr_api.g_number) then

Line 449: If (p_rec.quantity = hr_api.g_number) then

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;
452: End If;
453: If (p_rec.resource_type = hr_api.g_varchar2) then

Line 453: If (p_rec.resource_type = hr_api.g_varchar2) then

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;
456: End If;
457: If (p_rec.role_to_play = hr_api.g_varchar2) then

Line 457: If (p_rec.role_to_play = hr_api.g_varchar2) then

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;
460: End If;
461: If (p_rec.usage_reason = hr_api.g_varchar2) then

Line 461: If (p_rec.usage_reason = hr_api.g_varchar2) then

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;
464: End If;
465: If (p_rec.rud_information_category = hr_api.g_varchar2) then

Line 465: If (p_rec.rud_information_category = hr_api.g_varchar2) then

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;
468: End If;
469: If (p_rec.rud_information1 = hr_api.g_varchar2) then

Line 469: If (p_rec.rud_information1 = hr_api.g_varchar2) then

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;
472: End If;
473: If (p_rec.rud_information2 = hr_api.g_varchar2) then

Line 473: If (p_rec.rud_information2 = hr_api.g_varchar2) then

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;
476: End If;
477: If (p_rec.rud_information3 = hr_api.g_varchar2) then

Line 477: If (p_rec.rud_information3 = hr_api.g_varchar2) then

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;
480: End If;
481: If (p_rec.rud_information4 = hr_api.g_varchar2) then

Line 481: If (p_rec.rud_information4 = hr_api.g_varchar2) then

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;
484: End If;
485: If (p_rec.rud_information5 = hr_api.g_varchar2) then

Line 485: If (p_rec.rud_information5 = hr_api.g_varchar2) then

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;
488: End If;
489: If (p_rec.rud_information6 = hr_api.g_varchar2) then

Line 489: If (p_rec.rud_information6 = hr_api.g_varchar2) then

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;
492: End If;
493: If (p_rec.rud_information7 = hr_api.g_varchar2) then

Line 493: If (p_rec.rud_information7 = hr_api.g_varchar2) then

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;
496: End If;
497: If (p_rec.rud_information8 = hr_api.g_varchar2) then

Line 497: If (p_rec.rud_information8 = hr_api.g_varchar2) then

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;
500: End If;
501: If (p_rec.rud_information9 = hr_api.g_varchar2) then

Line 501: If (p_rec.rud_information9 = hr_api.g_varchar2) then

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;
504: End If;
505: If (p_rec.rud_information10 = hr_api.g_varchar2) then

Line 505: If (p_rec.rud_information10 = hr_api.g_varchar2) then

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;
508: End If;
509: If (p_rec.rud_information11 = hr_api.g_varchar2) then

Line 509: If (p_rec.rud_information11 = hr_api.g_varchar2) then

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;
512: End If;
513: If (p_rec.rud_information12 = hr_api.g_varchar2) then

Line 513: If (p_rec.rud_information12 = hr_api.g_varchar2) then

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;
516: End If;
517: If (p_rec.rud_information13 = hr_api.g_varchar2) then

Line 517: If (p_rec.rud_information13 = hr_api.g_varchar2) then

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;
520: End If;
521: If (p_rec.rud_information14 = hr_api.g_varchar2) then

Line 521: If (p_rec.rud_information14 = hr_api.g_varchar2) then

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;
524: End If;
525: If (p_rec.rud_information15 = hr_api.g_varchar2) then

Line 525: If (p_rec.rud_information15 = hr_api.g_varchar2) then

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;
528: End If;
529: If (p_rec.rud_information16 = hr_api.g_varchar2) then

Line 529: If (p_rec.rud_information16 = hr_api.g_varchar2) then

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;
532: End If;
533: If (p_rec.rud_information17 = hr_api.g_varchar2) then

Line 533: If (p_rec.rud_information17 = hr_api.g_varchar2) then

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;
536: End If;
537: If (p_rec.rud_information18 = hr_api.g_varchar2) then

Line 537: If (p_rec.rud_information18 = hr_api.g_varchar2) then

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;
540: End If;
541: If (p_rec.rud_information19 = hr_api.g_varchar2) then

Line 541: If (p_rec.rud_information19 = hr_api.g_varchar2) then

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;
544: End If;
545: If (p_rec.rud_information20 = hr_api.g_varchar2) then

Line 545: If (p_rec.rud_information20 = hr_api.g_varchar2) then

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;
548: End If;
549: If (p_rec.offering_id = hr_api.g_number) then

Line 549: If (p_rec.offering_id = hr_api.g_number) then

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;
552: End If;
553: --

Line 617: ,p_activity_version_id in number default hr_api.g_number

613: Procedure upd
614: (p_effective_date in date
615: ,p_resource_usage_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_activity_version_id in number default hr_api.g_number
618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2

Line 618: ,p_required_flag in varchar2 default hr_api.g_varchar2

614: (p_effective_date in date
615: ,p_resource_usage_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_activity_version_id in number default hr_api.g_number
618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date

Line 619: ,p_start_date in date default hr_api.g_date

615: ,p_resource_usage_id in number
616: ,p_object_version_number in out nocopy number
617: ,p_activity_version_id in number default hr_api.g_number
618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number

Line 620: ,p_supplied_resource_id in number default hr_api.g_number

616: ,p_object_version_number in out nocopy number
617: ,p_activity_version_id in number default hr_api.g_number
618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2

Line 621: ,p_comments in varchar2 default hr_api.g_varchar2

617: ,p_activity_version_id in number default hr_api.g_number
618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2

Line 622: ,p_end_date in date default hr_api.g_date

618: ,p_required_flag in varchar2 default hr_api.g_varchar2
619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2

Line 623: ,p_quantity in number default hr_api.g_number

619: ,p_start_date in date default hr_api.g_date
620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2

Line 624: ,p_resource_type in varchar2 default hr_api.g_varchar2

620: ,p_supplied_resource_id in number default hr_api.g_number
621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2

Line 625: ,p_role_to_play in varchar2 default hr_api.g_varchar2

621: ,p_comments in varchar2 default hr_api.g_varchar2
622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2

Line 626: ,p_usage_reason in varchar2 default hr_api.g_varchar2

622: ,p_end_date in date default hr_api.g_date
623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2

Line 627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2

623: ,p_quantity in number default hr_api.g_number
624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2

Line 628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2

624: ,p_resource_type in varchar2 default hr_api.g_varchar2
625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2

Line 629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2

625: ,p_role_to_play in varchar2 default hr_api.g_varchar2
626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2

Line 630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2

626: ,p_usage_reason in varchar2 default hr_api.g_varchar2
627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2

Line 631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2

627: ,p_rud_information_category in varchar2 default hr_api.g_varchar2
628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2

Line 632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2

628: ,p_rud_information1 in varchar2 default hr_api.g_varchar2
629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2

Line 633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2

629: ,p_rud_information2 in varchar2 default hr_api.g_varchar2
630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2

Line 634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2

630: ,p_rud_information3 in varchar2 default hr_api.g_varchar2
631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2

Line 635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2

631: ,p_rud_information4 in varchar2 default hr_api.g_varchar2
632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2

Line 636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2

632: ,p_rud_information5 in varchar2 default hr_api.g_varchar2
633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2

Line 637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2

633: ,p_rud_information6 in varchar2 default hr_api.g_varchar2
634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2

Line 638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2

634: ,p_rud_information7 in varchar2 default hr_api.g_varchar2
635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2

Line 639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2

635: ,p_rud_information8 in varchar2 default hr_api.g_varchar2
636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2

Line 640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2

636: ,p_rud_information9 in varchar2 default hr_api.g_varchar2
637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2

Line 641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2

637: ,p_rud_information10 in varchar2 default hr_api.g_varchar2
638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2

Line 642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2

638: ,p_rud_information11 in varchar2 default hr_api.g_varchar2
639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2

Line 643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2

639: ,p_rud_information12 in varchar2 default hr_api.g_varchar2
640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
647: ,p_rud_information20 in varchar2 default hr_api.g_varchar2

Line 644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2

640: ,p_rud_information13 in varchar2 default hr_api.g_varchar2
641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
647: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
648: ,p_offering_id in number default hr_api.g_number

Line 645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2

641: ,p_rud_information14 in varchar2 default hr_api.g_varchar2
642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
647: ,p_rud_information20 in varchar2 default hr_api.g_varchar2
648: ,p_offering_id in number default hr_api.g_number
649: ) is

Line 646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2

642: ,p_rud_information15 in varchar2 default hr_api.g_varchar2
643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
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: --

Line 647: ,p_rud_information20 in varchar2 default hr_api.g_varchar2

643: ,p_rud_information16 in varchar2 default hr_api.g_varchar2
644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
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;

Line 648: ,p_offering_id in number default hr_api.g_number

644: ,p_rud_information17 in varchar2 default hr_api.g_varchar2
645: ,p_rud_information18 in varchar2 default hr_api.g_varchar2
646: ,p_rud_information19 in varchar2 default hr_api.g_varchar2
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';