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_TPC_UPD dependencies on HR_API

Line 145: When hr_api.check_integrity_violated Then

141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 10);
143: --
144: Exception
145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: --
148: ota_tpc_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

145: When hr_api.check_integrity_violated Then
146: -- A check constraint has been violated
147: --
148: ota_tpc_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
153: ota_tpc_shd.constraint_error

Line 150: When hr_api.parent_integrity_violated Then

146: -- A check constraint has been violated
147: --
148: ota_tpc_shd.constraint_error
149: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
153: ota_tpc_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

150: When hr_api.parent_integrity_violated Then
151: -- Parent integrity has been violated
152: --
153: ota_tpc_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
158: ota_tpc_shd.constraint_error

Line 155: When hr_api.unique_integrity_violated Then

151: -- Parent integrity has been violated
152: --
153: ota_tpc_shd.constraint_error
154: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
158: ota_tpc_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

155: When hr_api.unique_integrity_violated Then
156: -- Unique integrity has been violated
157: --
158: ota_tpc_shd.constraint_error
159: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
160: When Others Then
161: --
162: Raise;
163: End update_dml;

Line 540: when hr_api.cannot_find_prog_unit then

536: );
537: --
538: exception
539: --
540: when hr_api.cannot_find_prog_unit then
541: --
542: hr_api.cannot_find_prog_unit_error
543: (p_module_name => 'OTA_TRAINING_PLAN_COSTS'
544: ,p_hook_type => 'AU');

Line 542: hr_api.cannot_find_prog_unit_error

538: exception
539: --
540: when hr_api.cannot_find_prog_unit then
541: --
542: hr_api.cannot_find_prog_unit_error
543: (p_module_name => 'OTA_TRAINING_PLAN_COSTS'
544: ,p_hook_type => 'AU');
545: --
546: end;

Line 605: If (p_rec.tp_measurement_type_id = hr_api.g_number) then

601: -- p_rec plsql record structure
602: -- to see if a system default is being used. If a system default
603: -- is being used then we must set to the 'current' argument value.
604: --
605: If (p_rec.tp_measurement_type_id = hr_api.g_number) then
606: p_rec.tp_measurement_type_id :=
607: ota_tpc_shd.g_old_rec.tp_measurement_type_id;
608: End If;
609: If (p_rec.training_plan_id = hr_api.g_number) then

Line 609: If (p_rec.training_plan_id = hr_api.g_number) then

605: If (p_rec.tp_measurement_type_id = hr_api.g_number) then
606: p_rec.tp_measurement_type_id :=
607: ota_tpc_shd.g_old_rec.tp_measurement_type_id;
608: End If;
609: If (p_rec.training_plan_id = hr_api.g_number) then
610: p_rec.training_plan_id :=
611: ota_tpc_shd.g_old_rec.training_plan_id;
612: End If;
613: If (p_rec.booking_id = hr_api.g_number) then

Line 613: If (p_rec.booking_id = hr_api.g_number) then

609: If (p_rec.training_plan_id = hr_api.g_number) then
610: p_rec.training_plan_id :=
611: ota_tpc_shd.g_old_rec.training_plan_id;
612: End If;
613: If (p_rec.booking_id = hr_api.g_number) then
614: p_rec.booking_id :=
615: ota_tpc_shd.g_old_rec.booking_id;
616: End If;
617: If (p_rec.event_id = hr_api.g_number) then

Line 617: If (p_rec.event_id = hr_api.g_number) then

613: If (p_rec.booking_id = hr_api.g_number) then
614: p_rec.booking_id :=
615: ota_tpc_shd.g_old_rec.booking_id;
616: End If;
617: If (p_rec.event_id = hr_api.g_number) then
618: p_rec.event_id :=
619: ota_tpc_shd.g_old_rec.event_id;
620: End If;
621: If (p_rec.amount = hr_api.g_number) then

Line 621: If (p_rec.amount = hr_api.g_number) then

617: If (p_rec.event_id = hr_api.g_number) then
618: p_rec.event_id :=
619: ota_tpc_shd.g_old_rec.event_id;
620: End If;
621: If (p_rec.amount = hr_api.g_number) then
622: p_rec.amount :=
623: ota_tpc_shd.g_old_rec.amount;
624: End If;
625: If (p_rec.currency_code = hr_api.g_varchar2) then

Line 625: If (p_rec.currency_code = hr_api.g_varchar2) then

621: If (p_rec.amount = hr_api.g_number) then
622: p_rec.amount :=
623: ota_tpc_shd.g_old_rec.amount;
624: End If;
625: If (p_rec.currency_code = hr_api.g_varchar2) then
626: p_rec.currency_code :=
627: ota_tpc_shd.g_old_rec.currency_code;
628: End If;
629: If (p_rec.business_group_id = hr_api.g_number) then

Line 629: If (p_rec.business_group_id = hr_api.g_number) then

625: If (p_rec.currency_code = hr_api.g_varchar2) then
626: p_rec.currency_code :=
627: ota_tpc_shd.g_old_rec.currency_code;
628: End If;
629: If (p_rec.business_group_id = hr_api.g_number) then
630: p_rec.business_group_id :=
631: ota_tpc_shd.g_old_rec.business_group_id;
632: End If;
633: If (p_rec.attribute_category = hr_api.g_varchar2) then

Line 633: If (p_rec.attribute_category = hr_api.g_varchar2) then

629: If (p_rec.business_group_id = hr_api.g_number) then
630: p_rec.business_group_id :=
631: ota_tpc_shd.g_old_rec.business_group_id;
632: End If;
633: If (p_rec.attribute_category = hr_api.g_varchar2) then
634: p_rec.attribute_category :=
635: ota_tpc_shd.g_old_rec.attribute_category;
636: End If;
637: If (p_rec.attribute1 = hr_api.g_varchar2) then

Line 637: If (p_rec.attribute1 = hr_api.g_varchar2) then

633: If (p_rec.attribute_category = hr_api.g_varchar2) then
634: p_rec.attribute_category :=
635: ota_tpc_shd.g_old_rec.attribute_category;
636: End If;
637: If (p_rec.attribute1 = hr_api.g_varchar2) then
638: p_rec.attribute1 :=
639: ota_tpc_shd.g_old_rec.attribute1;
640: End If;
641: If (p_rec.attribute2 = hr_api.g_varchar2) then

Line 641: If (p_rec.attribute2 = hr_api.g_varchar2) then

637: If (p_rec.attribute1 = hr_api.g_varchar2) then
638: p_rec.attribute1 :=
639: ota_tpc_shd.g_old_rec.attribute1;
640: End If;
641: If (p_rec.attribute2 = hr_api.g_varchar2) then
642: p_rec.attribute2 :=
643: ota_tpc_shd.g_old_rec.attribute2;
644: End If;
645: If (p_rec.attribute3 = hr_api.g_varchar2) then

Line 645: If (p_rec.attribute3 = hr_api.g_varchar2) then

641: If (p_rec.attribute2 = hr_api.g_varchar2) then
642: p_rec.attribute2 :=
643: ota_tpc_shd.g_old_rec.attribute2;
644: End If;
645: If (p_rec.attribute3 = hr_api.g_varchar2) then
646: p_rec.attribute3 :=
647: ota_tpc_shd.g_old_rec.attribute3;
648: End If;
649: If (p_rec.attribute4 = hr_api.g_varchar2) then

Line 649: If (p_rec.attribute4 = hr_api.g_varchar2) then

645: If (p_rec.attribute3 = hr_api.g_varchar2) then
646: p_rec.attribute3 :=
647: ota_tpc_shd.g_old_rec.attribute3;
648: End If;
649: If (p_rec.attribute4 = hr_api.g_varchar2) then
650: p_rec.attribute4 :=
651: ota_tpc_shd.g_old_rec.attribute4;
652: End If;
653: If (p_rec.attribute5 = hr_api.g_varchar2) then

Line 653: If (p_rec.attribute5 = hr_api.g_varchar2) then

649: If (p_rec.attribute4 = hr_api.g_varchar2) then
650: p_rec.attribute4 :=
651: ota_tpc_shd.g_old_rec.attribute4;
652: End If;
653: If (p_rec.attribute5 = hr_api.g_varchar2) then
654: p_rec.attribute5 :=
655: ota_tpc_shd.g_old_rec.attribute5;
656: End If;
657: If (p_rec.attribute6 = hr_api.g_varchar2) then

Line 657: If (p_rec.attribute6 = hr_api.g_varchar2) then

653: If (p_rec.attribute5 = hr_api.g_varchar2) then
654: p_rec.attribute5 :=
655: ota_tpc_shd.g_old_rec.attribute5;
656: End If;
657: If (p_rec.attribute6 = hr_api.g_varchar2) then
658: p_rec.attribute6 :=
659: ota_tpc_shd.g_old_rec.attribute6;
660: End If;
661: If (p_rec.attribute7 = hr_api.g_varchar2) then

Line 661: If (p_rec.attribute7 = hr_api.g_varchar2) then

657: If (p_rec.attribute6 = hr_api.g_varchar2) then
658: p_rec.attribute6 :=
659: ota_tpc_shd.g_old_rec.attribute6;
660: End If;
661: If (p_rec.attribute7 = hr_api.g_varchar2) then
662: p_rec.attribute7 :=
663: ota_tpc_shd.g_old_rec.attribute7;
664: End If;
665: If (p_rec.attribute8 = hr_api.g_varchar2) then

Line 665: If (p_rec.attribute8 = hr_api.g_varchar2) then

661: If (p_rec.attribute7 = hr_api.g_varchar2) then
662: p_rec.attribute7 :=
663: ota_tpc_shd.g_old_rec.attribute7;
664: End If;
665: If (p_rec.attribute8 = hr_api.g_varchar2) then
666: p_rec.attribute8 :=
667: ota_tpc_shd.g_old_rec.attribute8;
668: End If;
669: If (p_rec.attribute9 = hr_api.g_varchar2) then

Line 669: If (p_rec.attribute9 = hr_api.g_varchar2) then

665: If (p_rec.attribute8 = hr_api.g_varchar2) then
666: p_rec.attribute8 :=
667: ota_tpc_shd.g_old_rec.attribute8;
668: End If;
669: If (p_rec.attribute9 = hr_api.g_varchar2) then
670: p_rec.attribute9 :=
671: ota_tpc_shd.g_old_rec.attribute9;
672: End If;
673: If (p_rec.attribute10 = hr_api.g_varchar2) then

Line 673: If (p_rec.attribute10 = hr_api.g_varchar2) then

669: If (p_rec.attribute9 = hr_api.g_varchar2) then
670: p_rec.attribute9 :=
671: ota_tpc_shd.g_old_rec.attribute9;
672: End If;
673: If (p_rec.attribute10 = hr_api.g_varchar2) then
674: p_rec.attribute10 :=
675: ota_tpc_shd.g_old_rec.attribute10;
676: End If;
677: If (p_rec.attribute11 = hr_api.g_varchar2) then

Line 677: If (p_rec.attribute11 = hr_api.g_varchar2) then

673: If (p_rec.attribute10 = hr_api.g_varchar2) then
674: p_rec.attribute10 :=
675: ota_tpc_shd.g_old_rec.attribute10;
676: End If;
677: If (p_rec.attribute11 = hr_api.g_varchar2) then
678: p_rec.attribute11 :=
679: ota_tpc_shd.g_old_rec.attribute11;
680: End If;
681: If (p_rec.attribute12 = hr_api.g_varchar2) then

Line 681: If (p_rec.attribute12 = hr_api.g_varchar2) then

677: If (p_rec.attribute11 = hr_api.g_varchar2) then
678: p_rec.attribute11 :=
679: ota_tpc_shd.g_old_rec.attribute11;
680: End If;
681: If (p_rec.attribute12 = hr_api.g_varchar2) then
682: p_rec.attribute12 :=
683: ota_tpc_shd.g_old_rec.attribute12;
684: End If;
685: If (p_rec.attribute13 = hr_api.g_varchar2) then

Line 685: If (p_rec.attribute13 = hr_api.g_varchar2) then

681: If (p_rec.attribute12 = hr_api.g_varchar2) then
682: p_rec.attribute12 :=
683: ota_tpc_shd.g_old_rec.attribute12;
684: End If;
685: If (p_rec.attribute13 = hr_api.g_varchar2) then
686: p_rec.attribute13 :=
687: ota_tpc_shd.g_old_rec.attribute13;
688: End If;
689: If (p_rec.attribute14 = hr_api.g_varchar2) then

Line 689: If (p_rec.attribute14 = hr_api.g_varchar2) then

685: If (p_rec.attribute13 = hr_api.g_varchar2) then
686: p_rec.attribute13 :=
687: ota_tpc_shd.g_old_rec.attribute13;
688: End If;
689: If (p_rec.attribute14 = hr_api.g_varchar2) then
690: p_rec.attribute14 :=
691: ota_tpc_shd.g_old_rec.attribute14;
692: End If;
693: If (p_rec.attribute15 = hr_api.g_varchar2) then

Line 693: If (p_rec.attribute15 = hr_api.g_varchar2) then

689: If (p_rec.attribute14 = hr_api.g_varchar2) then
690: p_rec.attribute14 :=
691: ota_tpc_shd.g_old_rec.attribute14;
692: End If;
693: If (p_rec.attribute15 = hr_api.g_varchar2) then
694: p_rec.attribute15 :=
695: ota_tpc_shd.g_old_rec.attribute15;
696: End If;
697: If (p_rec.attribute16 = hr_api.g_varchar2) then

Line 697: If (p_rec.attribute16 = hr_api.g_varchar2) then

693: If (p_rec.attribute15 = hr_api.g_varchar2) then
694: p_rec.attribute15 :=
695: ota_tpc_shd.g_old_rec.attribute15;
696: End If;
697: If (p_rec.attribute16 = hr_api.g_varchar2) then
698: p_rec.attribute16 :=
699: ota_tpc_shd.g_old_rec.attribute16;
700: End If;
701: If (p_rec.attribute17 = hr_api.g_varchar2) then

Line 701: If (p_rec.attribute17 = hr_api.g_varchar2) then

697: If (p_rec.attribute16 = hr_api.g_varchar2) then
698: p_rec.attribute16 :=
699: ota_tpc_shd.g_old_rec.attribute16;
700: End If;
701: If (p_rec.attribute17 = hr_api.g_varchar2) then
702: p_rec.attribute17 :=
703: ota_tpc_shd.g_old_rec.attribute17;
704: End If;
705: If (p_rec.attribute18 = hr_api.g_varchar2) then

Line 705: If (p_rec.attribute18 = hr_api.g_varchar2) then

701: If (p_rec.attribute17 = hr_api.g_varchar2) then
702: p_rec.attribute17 :=
703: ota_tpc_shd.g_old_rec.attribute17;
704: End If;
705: If (p_rec.attribute18 = hr_api.g_varchar2) then
706: p_rec.attribute18 :=
707: ota_tpc_shd.g_old_rec.attribute18;
708: End If;
709: If (p_rec.attribute19 = hr_api.g_varchar2) then

Line 709: If (p_rec.attribute19 = hr_api.g_varchar2) then

705: If (p_rec.attribute18 = hr_api.g_varchar2) then
706: p_rec.attribute18 :=
707: ota_tpc_shd.g_old_rec.attribute18;
708: End If;
709: If (p_rec.attribute19 = hr_api.g_varchar2) then
710: p_rec.attribute19 :=
711: ota_tpc_shd.g_old_rec.attribute19;
712: End If;
713: If (p_rec.attribute20 = hr_api.g_varchar2) then

Line 713: If (p_rec.attribute20 = hr_api.g_varchar2) then

709: If (p_rec.attribute19 = hr_api.g_varchar2) then
710: p_rec.attribute19 :=
711: ota_tpc_shd.g_old_rec.attribute19;
712: End If;
713: If (p_rec.attribute20 = hr_api.g_varchar2) then
714: p_rec.attribute20 :=
715: ota_tpc_shd.g_old_rec.attribute20;
716: End If;
717: If (p_rec.attribute21 = hr_api.g_varchar2) then

Line 717: If (p_rec.attribute21 = hr_api.g_varchar2) then

713: If (p_rec.attribute20 = hr_api.g_varchar2) then
714: p_rec.attribute20 :=
715: ota_tpc_shd.g_old_rec.attribute20;
716: End If;
717: If (p_rec.attribute21 = hr_api.g_varchar2) then
718: p_rec.attribute21 :=
719: ota_tpc_shd.g_old_rec.attribute21;
720: End If;
721: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 721: If (p_rec.attribute22 = hr_api.g_varchar2) then

717: If (p_rec.attribute21 = hr_api.g_varchar2) then
718: p_rec.attribute21 :=
719: ota_tpc_shd.g_old_rec.attribute21;
720: End If;
721: If (p_rec.attribute22 = hr_api.g_varchar2) then
722: p_rec.attribute22 :=
723: ota_tpc_shd.g_old_rec.attribute22;
724: End If;
725: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 725: If (p_rec.attribute23 = hr_api.g_varchar2) then

721: If (p_rec.attribute22 = hr_api.g_varchar2) then
722: p_rec.attribute22 :=
723: ota_tpc_shd.g_old_rec.attribute22;
724: End If;
725: If (p_rec.attribute23 = hr_api.g_varchar2) then
726: p_rec.attribute23 :=
727: ota_tpc_shd.g_old_rec.attribute23;
728: End If;
729: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 729: If (p_rec.attribute24 = hr_api.g_varchar2) then

725: If (p_rec.attribute23 = hr_api.g_varchar2) then
726: p_rec.attribute23 :=
727: ota_tpc_shd.g_old_rec.attribute23;
728: End If;
729: If (p_rec.attribute24 = hr_api.g_varchar2) then
730: p_rec.attribute24 :=
731: ota_tpc_shd.g_old_rec.attribute24;
732: End If;
733: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 733: If (p_rec.attribute25 = hr_api.g_varchar2) then

729: If (p_rec.attribute24 = hr_api.g_varchar2) then
730: p_rec.attribute24 :=
731: ota_tpc_shd.g_old_rec.attribute24;
732: End If;
733: If (p_rec.attribute25 = hr_api.g_varchar2) then
734: p_rec.attribute25 :=
735: ota_tpc_shd.g_old_rec.attribute25;
736: End If;
737: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 737: If (p_rec.attribute26 = hr_api.g_varchar2) then

733: If (p_rec.attribute25 = hr_api.g_varchar2) then
734: p_rec.attribute25 :=
735: ota_tpc_shd.g_old_rec.attribute25;
736: End If;
737: If (p_rec.attribute26 = hr_api.g_varchar2) then
738: p_rec.attribute26 :=
739: ota_tpc_shd.g_old_rec.attribute26;
740: End If;
741: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 741: If (p_rec.attribute27 = hr_api.g_varchar2) then

737: If (p_rec.attribute26 = hr_api.g_varchar2) then
738: p_rec.attribute26 :=
739: ota_tpc_shd.g_old_rec.attribute26;
740: End If;
741: If (p_rec.attribute27 = hr_api.g_varchar2) then
742: p_rec.attribute27 :=
743: ota_tpc_shd.g_old_rec.attribute27;
744: End If;
745: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 745: If (p_rec.attribute28 = hr_api.g_varchar2) then

741: If (p_rec.attribute27 = hr_api.g_varchar2) then
742: p_rec.attribute27 :=
743: ota_tpc_shd.g_old_rec.attribute27;
744: End If;
745: If (p_rec.attribute28 = hr_api.g_varchar2) then
746: p_rec.attribute28 :=
747: ota_tpc_shd.g_old_rec.attribute28;
748: End If;
749: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 749: If (p_rec.attribute29 = hr_api.g_varchar2) then

745: If (p_rec.attribute28 = hr_api.g_varchar2) then
746: p_rec.attribute28 :=
747: ota_tpc_shd.g_old_rec.attribute28;
748: End If;
749: If (p_rec.attribute29 = hr_api.g_varchar2) then
750: p_rec.attribute29 :=
751: ota_tpc_shd.g_old_rec.attribute29;
752: End If;
753: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 753: If (p_rec.attribute30 = hr_api.g_varchar2) then

749: If (p_rec.attribute29 = hr_api.g_varchar2) then
750: p_rec.attribute29 :=
751: ota_tpc_shd.g_old_rec.attribute29;
752: End If;
753: If (p_rec.attribute30 = hr_api.g_varchar2) then
754: p_rec.attribute30 :=
755: ota_tpc_shd.g_old_rec.attribute30;
756: End If;
757: If (p_rec.information_category = hr_api.g_varchar2) then

Line 757: If (p_rec.information_category = hr_api.g_varchar2) then

753: If (p_rec.attribute30 = hr_api.g_varchar2) then
754: p_rec.attribute30 :=
755: ota_tpc_shd.g_old_rec.attribute30;
756: End If;
757: If (p_rec.information_category = hr_api.g_varchar2) then
758: p_rec.information_category :=
759: ota_tpc_shd.g_old_rec.information_category;
760: End If;
761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then

Line 761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then

757: If (p_rec.information_category = hr_api.g_varchar2) then
758: p_rec.information_category :=
759: ota_tpc_shd.g_old_rec.information_category;
760: End If;
761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then
762: p_rec.tp_cost_information1 :=
763: ota_tpc_shd.g_old_rec.tp_cost_information1;
764: End If;
765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then

Line 765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then

761: If (p_rec.tp_cost_information1 = hr_api.g_varchar2) then
762: p_rec.tp_cost_information1 :=
763: ota_tpc_shd.g_old_rec.tp_cost_information1;
764: End If;
765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then
766: p_rec.tp_cost_information2 :=
767: ota_tpc_shd.g_old_rec.tp_cost_information2;
768: End If;
769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then

Line 769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then

765: If (p_rec.tp_cost_information2 = hr_api.g_varchar2) then
766: p_rec.tp_cost_information2 :=
767: ota_tpc_shd.g_old_rec.tp_cost_information2;
768: End If;
769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then
770: p_rec.tp_cost_information3 :=
771: ota_tpc_shd.g_old_rec.tp_cost_information3;
772: End If;
773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then

Line 773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then

769: If (p_rec.tp_cost_information3 = hr_api.g_varchar2) then
770: p_rec.tp_cost_information3 :=
771: ota_tpc_shd.g_old_rec.tp_cost_information3;
772: End If;
773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then
774: p_rec.tp_cost_information4 :=
775: ota_tpc_shd.g_old_rec.tp_cost_information4;
776: End If;
777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then

Line 777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then

773: If (p_rec.tp_cost_information4 = hr_api.g_varchar2) then
774: p_rec.tp_cost_information4 :=
775: ota_tpc_shd.g_old_rec.tp_cost_information4;
776: End If;
777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then
778: p_rec.tp_cost_information5 :=
779: ota_tpc_shd.g_old_rec.tp_cost_information5;
780: End If;
781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then

Line 781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then

777: If (p_rec.tp_cost_information5 = hr_api.g_varchar2) then
778: p_rec.tp_cost_information5 :=
779: ota_tpc_shd.g_old_rec.tp_cost_information5;
780: End If;
781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then
782: p_rec.tp_cost_information6 :=
783: ota_tpc_shd.g_old_rec.tp_cost_information6;
784: End If;
785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then

Line 785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then

781: If (p_rec.tp_cost_information6 = hr_api.g_varchar2) then
782: p_rec.tp_cost_information6 :=
783: ota_tpc_shd.g_old_rec.tp_cost_information6;
784: End If;
785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then
786: p_rec.tp_cost_information7 :=
787: ota_tpc_shd.g_old_rec.tp_cost_information7;
788: End If;
789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then

Line 789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then

785: If (p_rec.tp_cost_information7 = hr_api.g_varchar2) then
786: p_rec.tp_cost_information7 :=
787: ota_tpc_shd.g_old_rec.tp_cost_information7;
788: End If;
789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then
790: p_rec.tp_cost_information8 :=
791: ota_tpc_shd.g_old_rec.tp_cost_information8;
792: End If;
793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then

Line 793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then

789: If (p_rec.tp_cost_information8 = hr_api.g_varchar2) then
790: p_rec.tp_cost_information8 :=
791: ota_tpc_shd.g_old_rec.tp_cost_information8;
792: End If;
793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then
794: p_rec.tp_cost_information9 :=
795: ota_tpc_shd.g_old_rec.tp_cost_information9;
796: End If;
797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then

Line 797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then

793: If (p_rec.tp_cost_information9 = hr_api.g_varchar2) then
794: p_rec.tp_cost_information9 :=
795: ota_tpc_shd.g_old_rec.tp_cost_information9;
796: End If;
797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then
798: p_rec.tp_cost_information10 :=
799: ota_tpc_shd.g_old_rec.tp_cost_information10;
800: End If;
801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then

Line 801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then

797: If (p_rec.tp_cost_information10 = hr_api.g_varchar2) then
798: p_rec.tp_cost_information10 :=
799: ota_tpc_shd.g_old_rec.tp_cost_information10;
800: End If;
801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then
802: p_rec.tp_cost_information11 :=
803: ota_tpc_shd.g_old_rec.tp_cost_information11;
804: End If;
805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then

Line 805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then

801: If (p_rec.tp_cost_information11 = hr_api.g_varchar2) then
802: p_rec.tp_cost_information11 :=
803: ota_tpc_shd.g_old_rec.tp_cost_information11;
804: End If;
805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then
806: p_rec.tp_cost_information12 :=
807: ota_tpc_shd.g_old_rec.tp_cost_information12;
808: End If;
809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then

Line 809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then

805: If (p_rec.tp_cost_information12 = hr_api.g_varchar2) then
806: p_rec.tp_cost_information12 :=
807: ota_tpc_shd.g_old_rec.tp_cost_information12;
808: End If;
809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then
810: p_rec.tp_cost_information13 :=
811: ota_tpc_shd.g_old_rec.tp_cost_information13;
812: End If;
813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then

Line 813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then

809: If (p_rec.tp_cost_information13 = hr_api.g_varchar2) then
810: p_rec.tp_cost_information13 :=
811: ota_tpc_shd.g_old_rec.tp_cost_information13;
812: End If;
813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then
814: p_rec.tp_cost_information14 :=
815: ota_tpc_shd.g_old_rec.tp_cost_information14;
816: End If;
817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then

Line 817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then

813: If (p_rec.tp_cost_information14 = hr_api.g_varchar2) then
814: p_rec.tp_cost_information14 :=
815: ota_tpc_shd.g_old_rec.tp_cost_information14;
816: End If;
817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then
818: p_rec.tp_cost_information15 :=
819: ota_tpc_shd.g_old_rec.tp_cost_information15;
820: End If;
821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then

Line 821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then

817: If (p_rec.tp_cost_information15 = hr_api.g_varchar2) then
818: p_rec.tp_cost_information15 :=
819: ota_tpc_shd.g_old_rec.tp_cost_information15;
820: End If;
821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then
822: p_rec.tp_cost_information16 :=
823: ota_tpc_shd.g_old_rec.tp_cost_information16;
824: End If;
825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then

Line 825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then

821: If (p_rec.tp_cost_information16 = hr_api.g_varchar2) then
822: p_rec.tp_cost_information16 :=
823: ota_tpc_shd.g_old_rec.tp_cost_information16;
824: End If;
825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then
826: p_rec.tp_cost_information17 :=
827: ota_tpc_shd.g_old_rec.tp_cost_information17;
828: End If;
829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then

Line 829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then

825: If (p_rec.tp_cost_information17 = hr_api.g_varchar2) then
826: p_rec.tp_cost_information17 :=
827: ota_tpc_shd.g_old_rec.tp_cost_information17;
828: End If;
829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then
830: p_rec.tp_cost_information18 :=
831: ota_tpc_shd.g_old_rec.tp_cost_information18;
832: End If;
833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then

Line 833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then

829: If (p_rec.tp_cost_information18 = hr_api.g_varchar2) then
830: p_rec.tp_cost_information18 :=
831: ota_tpc_shd.g_old_rec.tp_cost_information18;
832: End If;
833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then
834: p_rec.tp_cost_information19 :=
835: ota_tpc_shd.g_old_rec.tp_cost_information19;
836: End If;
837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then

Line 837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then

833: If (p_rec.tp_cost_information19 = hr_api.g_varchar2) then
834: p_rec.tp_cost_information19 :=
835: ota_tpc_shd.g_old_rec.tp_cost_information19;
836: End If;
837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then
838: p_rec.tp_cost_information20 :=
839: ota_tpc_shd.g_old_rec.tp_cost_information20;
840: End If;
841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then

Line 841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then

837: If (p_rec.tp_cost_information20 = hr_api.g_varchar2) then
838: p_rec.tp_cost_information20 :=
839: ota_tpc_shd.g_old_rec.tp_cost_information20;
840: End If;
841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then
842: p_rec.tp_cost_information21 :=
843: ota_tpc_shd.g_old_rec.tp_cost_information21;
844: End If;
845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then

Line 845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then

841: If (p_rec.tp_cost_information21 = hr_api.g_varchar2) then
842: p_rec.tp_cost_information21 :=
843: ota_tpc_shd.g_old_rec.tp_cost_information21;
844: End If;
845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then
846: p_rec.tp_cost_information22 :=
847: ota_tpc_shd.g_old_rec.tp_cost_information22;
848: End If;
849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then

Line 849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then

845: If (p_rec.tp_cost_information22 = hr_api.g_varchar2) then
846: p_rec.tp_cost_information22 :=
847: ota_tpc_shd.g_old_rec.tp_cost_information22;
848: End If;
849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then
850: p_rec.tp_cost_information23 :=
851: ota_tpc_shd.g_old_rec.tp_cost_information23;
852: End If;
853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then

Line 853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then

849: If (p_rec.tp_cost_information23 = hr_api.g_varchar2) then
850: p_rec.tp_cost_information23 :=
851: ota_tpc_shd.g_old_rec.tp_cost_information23;
852: End If;
853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then
854: p_rec.tp_cost_information24 :=
855: ota_tpc_shd.g_old_rec.tp_cost_information24;
856: End If;
857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then

Line 857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then

853: If (p_rec.tp_cost_information24 = hr_api.g_varchar2) then
854: p_rec.tp_cost_information24 :=
855: ota_tpc_shd.g_old_rec.tp_cost_information24;
856: End If;
857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then
858: p_rec.tp_cost_information25 :=
859: ota_tpc_shd.g_old_rec.tp_cost_information25;
860: End If;
861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then

Line 861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then

857: If (p_rec.tp_cost_information25 = hr_api.g_varchar2) then
858: p_rec.tp_cost_information25 :=
859: ota_tpc_shd.g_old_rec.tp_cost_information25;
860: End If;
861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then
862: p_rec.tp_cost_information26 :=
863: ota_tpc_shd.g_old_rec.tp_cost_information26;
864: End If;
865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then

Line 865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then

861: If (p_rec.tp_cost_information26 = hr_api.g_varchar2) then
862: p_rec.tp_cost_information26 :=
863: ota_tpc_shd.g_old_rec.tp_cost_information26;
864: End If;
865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then
866: p_rec.tp_cost_information27 :=
867: ota_tpc_shd.g_old_rec.tp_cost_information27;
868: End If;
869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then

Line 869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then

865: If (p_rec.tp_cost_information27 = hr_api.g_varchar2) then
866: p_rec.tp_cost_information27 :=
867: ota_tpc_shd.g_old_rec.tp_cost_information27;
868: End If;
869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then
870: p_rec.tp_cost_information28 :=
871: ota_tpc_shd.g_old_rec.tp_cost_information28;
872: End If;
873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then

Line 873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then

869: If (p_rec.tp_cost_information28 = hr_api.g_varchar2) then
870: p_rec.tp_cost_information28 :=
871: ota_tpc_shd.g_old_rec.tp_cost_information28;
872: End If;
873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then
874: p_rec.tp_cost_information29 :=
875: ota_tpc_shd.g_old_rec.tp_cost_information29;
876: End If;
877: If (p_rec.tp_cost_information30 = hr_api.g_varchar2) then

Line 877: If (p_rec.tp_cost_information30 = hr_api.g_varchar2) then

873: If (p_rec.tp_cost_information29 = hr_api.g_varchar2) then
874: p_rec.tp_cost_information29 :=
875: ota_tpc_shd.g_old_rec.tp_cost_information29;
876: End If;
877: If (p_rec.tp_cost_information30 = hr_api.g_varchar2) then
878: p_rec.tp_cost_information30 :=
879: ota_tpc_shd.g_old_rec.tp_cost_information30;
880: End If;
881: --

Line 939: ,p_amount in number default hr_api.g_number

935: Procedure upd
936: (p_effective_date in date
937: ,p_training_plan_cost_id in number
938: ,p_object_version_number in out nocopy number
939: ,p_amount in number default hr_api.g_number
940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 940: ,p_currency_code in varchar2 default hr_api.g_varchar2

936: (p_effective_date in date
937: ,p_training_plan_cost_id in number
938: ,p_object_version_number in out nocopy number
939: ,p_amount in number default hr_api.g_number
940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 941: ,p_attribute_category in varchar2 default hr_api.g_varchar2

937: ,p_training_plan_cost_id in number
938: ,p_object_version_number in out nocopy number
939: ,p_amount in number default hr_api.g_number
940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 942: ,p_attribute1 in varchar2 default hr_api.g_varchar2

938: ,p_object_version_number in out nocopy number
939: ,p_amount in number default hr_api.g_number
940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 943: ,p_attribute2 in varchar2 default hr_api.g_varchar2

939: ,p_amount in number default hr_api.g_number
940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 944: ,p_attribute3 in varchar2 default hr_api.g_varchar2

940: ,p_currency_code in varchar2 default hr_api.g_varchar2
941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 945: ,p_attribute4 in varchar2 default hr_api.g_varchar2

941: ,p_attribute_category in varchar2 default hr_api.g_varchar2
942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 946: ,p_attribute5 in varchar2 default hr_api.g_varchar2

942: ,p_attribute1 in varchar2 default hr_api.g_varchar2
943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 947: ,p_attribute6 in varchar2 default hr_api.g_varchar2

943: ,p_attribute2 in varchar2 default hr_api.g_varchar2
944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 948: ,p_attribute7 in varchar2 default hr_api.g_varchar2

944: ,p_attribute3 in varchar2 default hr_api.g_varchar2
945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 949: ,p_attribute8 in varchar2 default hr_api.g_varchar2

945: ,p_attribute4 in varchar2 default hr_api.g_varchar2
946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 950: ,p_attribute9 in varchar2 default hr_api.g_varchar2

946: ,p_attribute5 in varchar2 default hr_api.g_varchar2
947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 951: ,p_attribute10 in varchar2 default hr_api.g_varchar2

947: ,p_attribute6 in varchar2 default hr_api.g_varchar2
948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 952: ,p_attribute11 in varchar2 default hr_api.g_varchar2

948: ,p_attribute7 in varchar2 default hr_api.g_varchar2
949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 953: ,p_attribute12 in varchar2 default hr_api.g_varchar2

949: ,p_attribute8 in varchar2 default hr_api.g_varchar2
950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 954: ,p_attribute13 in varchar2 default hr_api.g_varchar2

950: ,p_attribute9 in varchar2 default hr_api.g_varchar2
951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 955: ,p_attribute14 in varchar2 default hr_api.g_varchar2

951: ,p_attribute10 in varchar2 default hr_api.g_varchar2
952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 956: ,p_attribute15 in varchar2 default hr_api.g_varchar2

952: ,p_attribute11 in varchar2 default hr_api.g_varchar2
953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 957: ,p_attribute16 in varchar2 default hr_api.g_varchar2

953: ,p_attribute12 in varchar2 default hr_api.g_varchar2
954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 958: ,p_attribute17 in varchar2 default hr_api.g_varchar2

954: ,p_attribute13 in varchar2 default hr_api.g_varchar2
955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 959: ,p_attribute18 in varchar2 default hr_api.g_varchar2

955: ,p_attribute14 in varchar2 default hr_api.g_varchar2
956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 960: ,p_attribute19 in varchar2 default hr_api.g_varchar2

956: ,p_attribute15 in varchar2 default hr_api.g_varchar2
957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 961: ,p_attribute20 in varchar2 default hr_api.g_varchar2

957: ,p_attribute16 in varchar2 default hr_api.g_varchar2
958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 962: ,p_attribute21 in varchar2 default hr_api.g_varchar2

958: ,p_attribute17 in varchar2 default hr_api.g_varchar2
959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 963: ,p_attribute22 in varchar2 default hr_api.g_varchar2

959: ,p_attribute18 in varchar2 default hr_api.g_varchar2
960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 964: ,p_attribute23 in varchar2 default hr_api.g_varchar2

960: ,p_attribute19 in varchar2 default hr_api.g_varchar2
961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 965: ,p_attribute24 in varchar2 default hr_api.g_varchar2

961: ,p_attribute20 in varchar2 default hr_api.g_varchar2
962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 966: ,p_attribute25 in varchar2 default hr_api.g_varchar2

962: ,p_attribute21 in varchar2 default hr_api.g_varchar2
963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 967: ,p_attribute26 in varchar2 default hr_api.g_varchar2

963: ,p_attribute22 in varchar2 default hr_api.g_varchar2
964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 968: ,p_attribute27 in varchar2 default hr_api.g_varchar2

964: ,p_attribute23 in varchar2 default hr_api.g_varchar2
965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2

Line 969: ,p_attribute28 in varchar2 default hr_api.g_varchar2

965: ,p_attribute24 in varchar2 default hr_api.g_varchar2
966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2

Line 970: ,p_attribute29 in varchar2 default hr_api.g_varchar2

966: ,p_attribute25 in varchar2 default hr_api.g_varchar2
967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2

Line 971: ,p_attribute30 in varchar2 default hr_api.g_varchar2

967: ,p_attribute26 in varchar2 default hr_api.g_varchar2
968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2

Line 972: ,p_information_category in varchar2 default hr_api.g_varchar2

968: ,p_attribute27 in varchar2 default hr_api.g_varchar2
969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2

Line 973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2

969: ,p_attribute28 in varchar2 default hr_api.g_varchar2
970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2

Line 974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2

970: ,p_attribute29 in varchar2 default hr_api.g_varchar2
971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2

Line 975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2

971: ,p_attribute30 in varchar2 default hr_api.g_varchar2
972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2

Line 976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2

972: ,p_information_category in varchar2 default hr_api.g_varchar2
973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2

Line 977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2

973: ,p_tp_cost_information1 in varchar2 default hr_api.g_varchar2
974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2

Line 978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2

974: ,p_tp_cost_information2 in varchar2 default hr_api.g_varchar2
975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2

Line 979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2

975: ,p_tp_cost_information3 in varchar2 default hr_api.g_varchar2
976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2

Line 980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2

976: ,p_tp_cost_information4 in varchar2 default hr_api.g_varchar2
977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2

Line 981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2

977: ,p_tp_cost_information5 in varchar2 default hr_api.g_varchar2
978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2

Line 982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2

978: ,p_tp_cost_information6 in varchar2 default hr_api.g_varchar2
979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2

Line 983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2

979: ,p_tp_cost_information7 in varchar2 default hr_api.g_varchar2
980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2

Line 984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2

980: ,p_tp_cost_information8 in varchar2 default hr_api.g_varchar2
981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2

Line 985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2

981: ,p_tp_cost_information9 in varchar2 default hr_api.g_varchar2
982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2

Line 986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2

982: ,p_tp_cost_information10 in varchar2 default hr_api.g_varchar2
983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2

Line 987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2

983: ,p_tp_cost_information11 in varchar2 default hr_api.g_varchar2
984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2

Line 988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2

984: ,p_tp_cost_information12 in varchar2 default hr_api.g_varchar2
985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2

Line 989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2

985: ,p_tp_cost_information13 in varchar2 default hr_api.g_varchar2
986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2

Line 990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2

986: ,p_tp_cost_information14 in varchar2 default hr_api.g_varchar2
987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2

Line 991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2

987: ,p_tp_cost_information15 in varchar2 default hr_api.g_varchar2
988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2

Line 992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2

988: ,p_tp_cost_information16 in varchar2 default hr_api.g_varchar2
989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2

Line 993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2

989: ,p_tp_cost_information17 in varchar2 default hr_api.g_varchar2
990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2

Line 994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2

990: ,p_tp_cost_information18 in varchar2 default hr_api.g_varchar2
991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2

Line 995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2

991: ,p_tp_cost_information19 in varchar2 default hr_api.g_varchar2
992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2

Line 996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2

992: ,p_tp_cost_information20 in varchar2 default hr_api.g_varchar2
993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2

Line 997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2

993: ,p_tp_cost_information21 in varchar2 default hr_api.g_varchar2
994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2

Line 998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2

994: ,p_tp_cost_information22 in varchar2 default hr_api.g_varchar2
995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2

Line 999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2

995: ,p_tp_cost_information23 in varchar2 default hr_api.g_varchar2
996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2
1003: ) is

Line 1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2

996: ,p_tp_cost_information24 in varchar2 default hr_api.g_varchar2
997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2
1003: ) is
1004: --

Line 1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2

997: ,p_tp_cost_information25 in varchar2 default hr_api.g_varchar2
998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2
1003: ) is
1004: --
1005: l_rec ota_tpc_shd.g_rec_type;

Line 1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2

998: ,p_tp_cost_information26 in varchar2 default hr_api.g_varchar2
999: ,p_tp_cost_information27 in varchar2 default hr_api.g_varchar2
1000: ,p_tp_cost_information28 in varchar2 default hr_api.g_varchar2
1001: ,p_tp_cost_information29 in varchar2 default hr_api.g_varchar2
1002: ,p_tp_cost_information30 in varchar2 default hr_api.g_varchar2
1003: ) is
1004: --
1005: l_rec ota_tpc_shd.g_rec_type;
1006: l_proc varchar2(72) := g_package||'upd';

Line 1017: ,hr_api.g_number

1013: --
1014: l_rec :=
1015: ota_tpc_shd.convert_args
1016: (p_training_plan_cost_id
1017: ,hr_api.g_number
1018: ,hr_api.g_number
1019: ,hr_api.g_number
1020: ,hr_api.g_number
1021: ,p_amount

Line 1018: ,hr_api.g_number

1014: l_rec :=
1015: ota_tpc_shd.convert_args
1016: (p_training_plan_cost_id
1017: ,hr_api.g_number
1018: ,hr_api.g_number
1019: ,hr_api.g_number
1020: ,hr_api.g_number
1021: ,p_amount
1022: ,p_currency_code

Line 1019: ,hr_api.g_number

1015: ota_tpc_shd.convert_args
1016: (p_training_plan_cost_id
1017: ,hr_api.g_number
1018: ,hr_api.g_number
1019: ,hr_api.g_number
1020: ,hr_api.g_number
1021: ,p_amount
1022: ,p_currency_code
1023: ,hr_api.g_number

Line 1020: ,hr_api.g_number

1016: (p_training_plan_cost_id
1017: ,hr_api.g_number
1018: ,hr_api.g_number
1019: ,hr_api.g_number
1020: ,hr_api.g_number
1021: ,p_amount
1022: ,p_currency_code
1023: ,hr_api.g_number
1024: ,p_object_version_number

Line 1023: ,hr_api.g_number

1019: ,hr_api.g_number
1020: ,hr_api.g_number
1021: ,p_amount
1022: ,p_currency_code
1023: ,hr_api.g_number
1024: ,p_object_version_number
1025: ,p_attribute_category
1026: ,p_attribute1
1027: ,p_attribute2