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.PQP_PVD_UPD dependencies on HR_API

Line 143: When hr_api.check_integrity_violated Then

139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
146: pqp_pvd_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
146: pqp_pvd_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
151: pqp_pvd_shd.constraint_error

Line 148: When hr_api.parent_integrity_violated Then

144: -- A check constraint has been violated
145: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
146: pqp_pvd_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
151: pqp_pvd_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
151: pqp_pvd_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
156: pqp_pvd_shd.constraint_error

Line 153: When hr_api.unique_integrity_violated Then

149: -- Parent integrity has been violated
150: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
151: pqp_pvd_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
156: pqp_pvd_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

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

153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
156: pqp_pvd_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: pqp_pvd_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;

Line 510: when hr_api.cannot_find_prog_unit then

506: );
507: --
508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PQP_VEHICLE_DETAILS'
514: ,p_hook_type => 'AU');

Line 512: hr_api.cannot_find_prog_unit_error

508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PQP_VEHICLE_DETAILS'
514: ,p_hook_type => 'AU');
515: --
516: end;

Line 575: If (p_rec.vehicle_type = hr_api.g_varchar2) then

571: -- p_rec plsql record structure
572: -- to see if a system default is being used. If a system default
573: -- is being used then we must set to the 'current' argument value.
574: --
575: If (p_rec.vehicle_type = hr_api.g_varchar2) then
576: p_rec.vehicle_type :=
577: pqp_pvd_shd.g_old_rec.vehicle_type;
578: End If;
579: If (p_rec.business_group_id = hr_api.g_number) then

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

575: If (p_rec.vehicle_type = hr_api.g_varchar2) then
576: p_rec.vehicle_type :=
577: pqp_pvd_shd.g_old_rec.vehicle_type;
578: End If;
579: If (p_rec.business_group_id = hr_api.g_number) then
580: p_rec.business_group_id :=
581: pqp_pvd_shd.g_old_rec.business_group_id;
582: End If;
583: If (p_rec.registration_number = hr_api.g_varchar2) then

Line 583: If (p_rec.registration_number = hr_api.g_varchar2) then

579: If (p_rec.business_group_id = hr_api.g_number) then
580: p_rec.business_group_id :=
581: pqp_pvd_shd.g_old_rec.business_group_id;
582: End If;
583: If (p_rec.registration_number = hr_api.g_varchar2) then
584: p_rec.registration_number :=
585: pqp_pvd_shd.g_old_rec.registration_number;
586: End If;
587: If (p_rec.make = hr_api.g_varchar2) then

Line 587: If (p_rec.make = hr_api.g_varchar2) then

583: If (p_rec.registration_number = hr_api.g_varchar2) then
584: p_rec.registration_number :=
585: pqp_pvd_shd.g_old_rec.registration_number;
586: End If;
587: If (p_rec.make = hr_api.g_varchar2) then
588: p_rec.make :=
589: pqp_pvd_shd.g_old_rec.make;
590: End If;
591: If (p_rec.model = hr_api.g_varchar2) then

Line 591: If (p_rec.model = hr_api.g_varchar2) then

587: If (p_rec.make = hr_api.g_varchar2) then
588: p_rec.make :=
589: pqp_pvd_shd.g_old_rec.make;
590: End If;
591: If (p_rec.model = hr_api.g_varchar2) then
592: p_rec.model :=
593: pqp_pvd_shd.g_old_rec.model;
594: End If;
595: If (p_rec.date_first_registered = hr_api.g_date) then

Line 595: If (p_rec.date_first_registered = hr_api.g_date) then

591: If (p_rec.model = hr_api.g_varchar2) then
592: p_rec.model :=
593: pqp_pvd_shd.g_old_rec.model;
594: End If;
595: If (p_rec.date_first_registered = hr_api.g_date) then
596: p_rec.date_first_registered :=
597: pqp_pvd_shd.g_old_rec.date_first_registered;
598: End If;
599: If (p_rec.engine_capacity_in_cc = hr_api.g_number) then

Line 599: If (p_rec.engine_capacity_in_cc = hr_api.g_number) then

595: If (p_rec.date_first_registered = hr_api.g_date) then
596: p_rec.date_first_registered :=
597: pqp_pvd_shd.g_old_rec.date_first_registered;
598: End If;
599: If (p_rec.engine_capacity_in_cc = hr_api.g_number) then
600: p_rec.engine_capacity_in_cc :=
601: pqp_pvd_shd.g_old_rec.engine_capacity_in_cc;
602: End If;
603: If (p_rec.fuel_type = hr_api.g_varchar2) then

Line 603: If (p_rec.fuel_type = hr_api.g_varchar2) then

599: If (p_rec.engine_capacity_in_cc = hr_api.g_number) then
600: p_rec.engine_capacity_in_cc :=
601: pqp_pvd_shd.g_old_rec.engine_capacity_in_cc;
602: End If;
603: If (p_rec.fuel_type = hr_api.g_varchar2) then
604: p_rec.fuel_type :=
605: pqp_pvd_shd.g_old_rec.fuel_type;
606: End If;
607: If (p_rec.fuel_card = hr_api.g_varchar2) then

Line 607: If (p_rec.fuel_card = hr_api.g_varchar2) then

603: If (p_rec.fuel_type = hr_api.g_varchar2) then
604: p_rec.fuel_type :=
605: pqp_pvd_shd.g_old_rec.fuel_type;
606: End If;
607: If (p_rec.fuel_card = hr_api.g_varchar2) then
608: p_rec.fuel_card :=
609: pqp_pvd_shd.g_old_rec.fuel_card;
610: End If;
611: If (p_rec.currency_code = hr_api.g_varchar2) then

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

607: If (p_rec.fuel_card = hr_api.g_varchar2) then
608: p_rec.fuel_card :=
609: pqp_pvd_shd.g_old_rec.fuel_card;
610: End If;
611: If (p_rec.currency_code = hr_api.g_varchar2) then
612: p_rec.currency_code :=
613: pqp_pvd_shd.g_old_rec.currency_code;
614: End If;
615: If (p_rec.list_price = hr_api.g_number) then

Line 615: If (p_rec.list_price = hr_api.g_number) then

611: If (p_rec.currency_code = hr_api.g_varchar2) then
612: p_rec.currency_code :=
613: pqp_pvd_shd.g_old_rec.currency_code;
614: End If;
615: If (p_rec.list_price = hr_api.g_number) then
616: p_rec.list_price :=
617: pqp_pvd_shd.g_old_rec.list_price;
618: End If;
619: If (p_rec.accessory_value_at_startdate = hr_api.g_number) then

Line 619: If (p_rec.accessory_value_at_startdate = hr_api.g_number) then

615: If (p_rec.list_price = hr_api.g_number) then
616: p_rec.list_price :=
617: pqp_pvd_shd.g_old_rec.list_price;
618: End If;
619: If (p_rec.accessory_value_at_startdate = hr_api.g_number) then
620: p_rec.accessory_value_at_startdate :=
621: pqp_pvd_shd.g_old_rec.accessory_value_at_startdate;
622: End If;
623: If (p_rec.accessory_value_added_later = hr_api.g_number) then

Line 623: If (p_rec.accessory_value_added_later = hr_api.g_number) then

619: If (p_rec.accessory_value_at_startdate = hr_api.g_number) then
620: p_rec.accessory_value_at_startdate :=
621: pqp_pvd_shd.g_old_rec.accessory_value_at_startdate;
622: End If;
623: If (p_rec.accessory_value_added_later = hr_api.g_number) then
624: p_rec.accessory_value_added_later :=
625: pqp_pvd_shd.g_old_rec.accessory_value_added_later;
626: End If;
627: -- If (p_rec.capital_contributions = hr_api.g_number) then

Line 627: -- If (p_rec.capital_contributions = hr_api.g_number) then

623: If (p_rec.accessory_value_added_later = hr_api.g_number) then
624: p_rec.accessory_value_added_later :=
625: pqp_pvd_shd.g_old_rec.accessory_value_added_later;
626: End If;
627: -- If (p_rec.capital_contributions = hr_api.g_number) then
628: -- p_rec.capital_contributions :=
629: -- pqp_pvd_shd.g_old_rec.capital_contributions;
630: -- End If;
631: -- If (p_rec.private_use_contributions = hr_api.g_number) then

Line 631: -- If (p_rec.private_use_contributions = hr_api.g_number) then

627: -- If (p_rec.capital_contributions = hr_api.g_number) then
628: -- p_rec.capital_contributions :=
629: -- pqp_pvd_shd.g_old_rec.capital_contributions;
630: -- End If;
631: -- If (p_rec.private_use_contributions = hr_api.g_number) then
632: -- p_rec.private_use_contributions :=
633: -- pqp_pvd_shd.g_old_rec.private_use_contributions;
634: -- End If;
635: If (p_rec.market_value_classic_car = hr_api.g_number) then

Line 635: If (p_rec.market_value_classic_car = hr_api.g_number) then

631: -- If (p_rec.private_use_contributions = hr_api.g_number) then
632: -- p_rec.private_use_contributions :=
633: -- pqp_pvd_shd.g_old_rec.private_use_contributions;
634: -- End If;
635: If (p_rec.market_value_classic_car = hr_api.g_number) then
636: p_rec.market_value_classic_car :=
637: pqp_pvd_shd.g_old_rec.market_value_classic_car;
638: End If;
639: If (p_rec.co2_emissions = hr_api.g_number) then

Line 639: If (p_rec.co2_emissions = hr_api.g_number) then

635: If (p_rec.market_value_classic_car = hr_api.g_number) then
636: p_rec.market_value_classic_car :=
637: pqp_pvd_shd.g_old_rec.market_value_classic_car;
638: End If;
639: If (p_rec.co2_emissions = hr_api.g_number) then
640: p_rec.co2_emissions :=
641: pqp_pvd_shd.g_old_rec.co2_emissions;
642: End If;
643: If (p_rec.vehicle_provider = hr_api.g_varchar2) then

Line 643: If (p_rec.vehicle_provider = hr_api.g_varchar2) then

639: If (p_rec.co2_emissions = hr_api.g_number) then
640: p_rec.co2_emissions :=
641: pqp_pvd_shd.g_old_rec.co2_emissions;
642: End If;
643: If (p_rec.vehicle_provider = hr_api.g_varchar2) then
644: p_rec.vehicle_provider :=
645: pqp_pvd_shd.g_old_rec.vehicle_provider;
646: End If;
647: If (p_rec.vehicle_identification_number = hr_api.g_varchar2) then

Line 647: If (p_rec.vehicle_identification_number = hr_api.g_varchar2) then

643: If (p_rec.vehicle_provider = hr_api.g_varchar2) then
644: p_rec.vehicle_provider :=
645: pqp_pvd_shd.g_old_rec.vehicle_provider;
646: End If;
647: If (p_rec.vehicle_identification_number = hr_api.g_varchar2) then
648: p_rec.vehicle_identification_number :=
649: pqp_pvd_shd.g_old_rec.vehicle_identification_number;
650: End If;
651: If (p_rec.vehicle_ownership = hr_api.g_varchar2) then

Line 651: If (p_rec.vehicle_ownership = hr_api.g_varchar2) then

647: If (p_rec.vehicle_identification_number = hr_api.g_varchar2) then
648: p_rec.vehicle_identification_number :=
649: pqp_pvd_shd.g_old_rec.vehicle_identification_number;
650: End If;
651: If (p_rec.vehicle_ownership = hr_api.g_varchar2) then
652: p_rec.vehicle_ownership :=
653: pqp_pvd_shd.g_old_rec.vehicle_ownership;
654: End If;
655: If (p_rec.vhd_attribute_category = hr_api.g_varchar2) then

Line 655: If (p_rec.vhd_attribute_category = hr_api.g_varchar2) then

651: If (p_rec.vehicle_ownership = hr_api.g_varchar2) then
652: p_rec.vehicle_ownership :=
653: pqp_pvd_shd.g_old_rec.vehicle_ownership;
654: End If;
655: If (p_rec.vhd_attribute_category = hr_api.g_varchar2) then
656: p_rec.vhd_attribute_category :=
657: pqp_pvd_shd.g_old_rec.vhd_attribute_category;
658: End If;
659: If (p_rec.vhd_attribute1 = hr_api.g_varchar2) then

Line 659: If (p_rec.vhd_attribute1 = hr_api.g_varchar2) then

655: If (p_rec.vhd_attribute_category = hr_api.g_varchar2) then
656: p_rec.vhd_attribute_category :=
657: pqp_pvd_shd.g_old_rec.vhd_attribute_category;
658: End If;
659: If (p_rec.vhd_attribute1 = hr_api.g_varchar2) then
660: p_rec.vhd_attribute1 :=
661: pqp_pvd_shd.g_old_rec.vhd_attribute1;
662: End If;
663: If (p_rec.vhd_attribute2 = hr_api.g_varchar2) then

Line 663: If (p_rec.vhd_attribute2 = hr_api.g_varchar2) then

659: If (p_rec.vhd_attribute1 = hr_api.g_varchar2) then
660: p_rec.vhd_attribute1 :=
661: pqp_pvd_shd.g_old_rec.vhd_attribute1;
662: End If;
663: If (p_rec.vhd_attribute2 = hr_api.g_varchar2) then
664: p_rec.vhd_attribute2 :=
665: pqp_pvd_shd.g_old_rec.vhd_attribute2;
666: End If;
667: If (p_rec.vhd_attribute3 = hr_api.g_varchar2) then

Line 667: If (p_rec.vhd_attribute3 = hr_api.g_varchar2) then

663: If (p_rec.vhd_attribute2 = hr_api.g_varchar2) then
664: p_rec.vhd_attribute2 :=
665: pqp_pvd_shd.g_old_rec.vhd_attribute2;
666: End If;
667: If (p_rec.vhd_attribute3 = hr_api.g_varchar2) then
668: p_rec.vhd_attribute3 :=
669: pqp_pvd_shd.g_old_rec.vhd_attribute3;
670: End If;
671: If (p_rec.vhd_attribute4 = hr_api.g_varchar2) then

Line 671: If (p_rec.vhd_attribute4 = hr_api.g_varchar2) then

667: If (p_rec.vhd_attribute3 = hr_api.g_varchar2) then
668: p_rec.vhd_attribute3 :=
669: pqp_pvd_shd.g_old_rec.vhd_attribute3;
670: End If;
671: If (p_rec.vhd_attribute4 = hr_api.g_varchar2) then
672: p_rec.vhd_attribute4 :=
673: pqp_pvd_shd.g_old_rec.vhd_attribute4;
674: End If;
675: If (p_rec.vhd_attribute5 = hr_api.g_varchar2) then

Line 675: If (p_rec.vhd_attribute5 = hr_api.g_varchar2) then

671: If (p_rec.vhd_attribute4 = hr_api.g_varchar2) then
672: p_rec.vhd_attribute4 :=
673: pqp_pvd_shd.g_old_rec.vhd_attribute4;
674: End If;
675: If (p_rec.vhd_attribute5 = hr_api.g_varchar2) then
676: p_rec.vhd_attribute5 :=
677: pqp_pvd_shd.g_old_rec.vhd_attribute5;
678: End If;
679: If (p_rec.vhd_attribute6 = hr_api.g_varchar2) then

Line 679: If (p_rec.vhd_attribute6 = hr_api.g_varchar2) then

675: If (p_rec.vhd_attribute5 = hr_api.g_varchar2) then
676: p_rec.vhd_attribute5 :=
677: pqp_pvd_shd.g_old_rec.vhd_attribute5;
678: End If;
679: If (p_rec.vhd_attribute6 = hr_api.g_varchar2) then
680: p_rec.vhd_attribute6 :=
681: pqp_pvd_shd.g_old_rec.vhd_attribute6;
682: End If;
683: If (p_rec.vhd_attribute7 = hr_api.g_varchar2) then

Line 683: If (p_rec.vhd_attribute7 = hr_api.g_varchar2) then

679: If (p_rec.vhd_attribute6 = hr_api.g_varchar2) then
680: p_rec.vhd_attribute6 :=
681: pqp_pvd_shd.g_old_rec.vhd_attribute6;
682: End If;
683: If (p_rec.vhd_attribute7 = hr_api.g_varchar2) then
684: p_rec.vhd_attribute7 :=
685: pqp_pvd_shd.g_old_rec.vhd_attribute7;
686: End If;
687: If (p_rec.vhd_attribute8 = hr_api.g_varchar2) then

Line 687: If (p_rec.vhd_attribute8 = hr_api.g_varchar2) then

683: If (p_rec.vhd_attribute7 = hr_api.g_varchar2) then
684: p_rec.vhd_attribute7 :=
685: pqp_pvd_shd.g_old_rec.vhd_attribute7;
686: End If;
687: If (p_rec.vhd_attribute8 = hr_api.g_varchar2) then
688: p_rec.vhd_attribute8 :=
689: pqp_pvd_shd.g_old_rec.vhd_attribute8;
690: End If;
691: If (p_rec.vhd_attribute9 = hr_api.g_varchar2) then

Line 691: If (p_rec.vhd_attribute9 = hr_api.g_varchar2) then

687: If (p_rec.vhd_attribute8 = hr_api.g_varchar2) then
688: p_rec.vhd_attribute8 :=
689: pqp_pvd_shd.g_old_rec.vhd_attribute8;
690: End If;
691: If (p_rec.vhd_attribute9 = hr_api.g_varchar2) then
692: p_rec.vhd_attribute9 :=
693: pqp_pvd_shd.g_old_rec.vhd_attribute9;
694: End If;
695: If (p_rec.vhd_attribute10 = hr_api.g_varchar2) then

Line 695: If (p_rec.vhd_attribute10 = hr_api.g_varchar2) then

691: If (p_rec.vhd_attribute9 = hr_api.g_varchar2) then
692: p_rec.vhd_attribute9 :=
693: pqp_pvd_shd.g_old_rec.vhd_attribute9;
694: End If;
695: If (p_rec.vhd_attribute10 = hr_api.g_varchar2) then
696: p_rec.vhd_attribute10 :=
697: pqp_pvd_shd.g_old_rec.vhd_attribute10;
698: End If;
699: If (p_rec.vhd_attribute11 = hr_api.g_varchar2) then

Line 699: If (p_rec.vhd_attribute11 = hr_api.g_varchar2) then

695: If (p_rec.vhd_attribute10 = hr_api.g_varchar2) then
696: p_rec.vhd_attribute10 :=
697: pqp_pvd_shd.g_old_rec.vhd_attribute10;
698: End If;
699: If (p_rec.vhd_attribute11 = hr_api.g_varchar2) then
700: p_rec.vhd_attribute11 :=
701: pqp_pvd_shd.g_old_rec.vhd_attribute11;
702: End If;
703: If (p_rec.vhd_attribute12 = hr_api.g_varchar2) then

Line 703: If (p_rec.vhd_attribute12 = hr_api.g_varchar2) then

699: If (p_rec.vhd_attribute11 = hr_api.g_varchar2) then
700: p_rec.vhd_attribute11 :=
701: pqp_pvd_shd.g_old_rec.vhd_attribute11;
702: End If;
703: If (p_rec.vhd_attribute12 = hr_api.g_varchar2) then
704: p_rec.vhd_attribute12 :=
705: pqp_pvd_shd.g_old_rec.vhd_attribute12;
706: End If;
707: If (p_rec.vhd_attribute13 = hr_api.g_varchar2) then

Line 707: If (p_rec.vhd_attribute13 = hr_api.g_varchar2) then

703: If (p_rec.vhd_attribute12 = hr_api.g_varchar2) then
704: p_rec.vhd_attribute12 :=
705: pqp_pvd_shd.g_old_rec.vhd_attribute12;
706: End If;
707: If (p_rec.vhd_attribute13 = hr_api.g_varchar2) then
708: p_rec.vhd_attribute13 :=
709: pqp_pvd_shd.g_old_rec.vhd_attribute13;
710: End If;
711: If (p_rec.vhd_attribute14 = hr_api.g_varchar2) then

Line 711: If (p_rec.vhd_attribute14 = hr_api.g_varchar2) then

707: If (p_rec.vhd_attribute13 = hr_api.g_varchar2) then
708: p_rec.vhd_attribute13 :=
709: pqp_pvd_shd.g_old_rec.vhd_attribute13;
710: End If;
711: If (p_rec.vhd_attribute14 = hr_api.g_varchar2) then
712: p_rec.vhd_attribute14 :=
713: pqp_pvd_shd.g_old_rec.vhd_attribute14;
714: End If;
715: If (p_rec.vhd_attribute15 = hr_api.g_varchar2) then

Line 715: If (p_rec.vhd_attribute15 = hr_api.g_varchar2) then

711: If (p_rec.vhd_attribute14 = hr_api.g_varchar2) then
712: p_rec.vhd_attribute14 :=
713: pqp_pvd_shd.g_old_rec.vhd_attribute14;
714: End If;
715: If (p_rec.vhd_attribute15 = hr_api.g_varchar2) then
716: p_rec.vhd_attribute15 :=
717: pqp_pvd_shd.g_old_rec.vhd_attribute15;
718: End If;
719: If (p_rec.vhd_attribute16 = hr_api.g_varchar2) then

Line 719: If (p_rec.vhd_attribute16 = hr_api.g_varchar2) then

715: If (p_rec.vhd_attribute15 = hr_api.g_varchar2) then
716: p_rec.vhd_attribute15 :=
717: pqp_pvd_shd.g_old_rec.vhd_attribute15;
718: End If;
719: If (p_rec.vhd_attribute16 = hr_api.g_varchar2) then
720: p_rec.vhd_attribute16 :=
721: pqp_pvd_shd.g_old_rec.vhd_attribute16;
722: End If;
723: If (p_rec.vhd_attribute17 = hr_api.g_varchar2) then

Line 723: If (p_rec.vhd_attribute17 = hr_api.g_varchar2) then

719: If (p_rec.vhd_attribute16 = hr_api.g_varchar2) then
720: p_rec.vhd_attribute16 :=
721: pqp_pvd_shd.g_old_rec.vhd_attribute16;
722: End If;
723: If (p_rec.vhd_attribute17 = hr_api.g_varchar2) then
724: p_rec.vhd_attribute17 :=
725: pqp_pvd_shd.g_old_rec.vhd_attribute17;
726: End If;
727: If (p_rec.vhd_attribute18 = hr_api.g_varchar2) then

Line 727: If (p_rec.vhd_attribute18 = hr_api.g_varchar2) then

723: If (p_rec.vhd_attribute17 = hr_api.g_varchar2) then
724: p_rec.vhd_attribute17 :=
725: pqp_pvd_shd.g_old_rec.vhd_attribute17;
726: End If;
727: If (p_rec.vhd_attribute18 = hr_api.g_varchar2) then
728: p_rec.vhd_attribute18 :=
729: pqp_pvd_shd.g_old_rec.vhd_attribute18;
730: End If;
731: If (p_rec.vhd_attribute19 = hr_api.g_varchar2) then

Line 731: If (p_rec.vhd_attribute19 = hr_api.g_varchar2) then

727: If (p_rec.vhd_attribute18 = hr_api.g_varchar2) then
728: p_rec.vhd_attribute18 :=
729: pqp_pvd_shd.g_old_rec.vhd_attribute18;
730: End If;
731: If (p_rec.vhd_attribute19 = hr_api.g_varchar2) then
732: p_rec.vhd_attribute19 :=
733: pqp_pvd_shd.g_old_rec.vhd_attribute19;
734: End If;
735: If (p_rec.vhd_attribute20 = hr_api.g_varchar2) then

Line 735: If (p_rec.vhd_attribute20 = hr_api.g_varchar2) then

731: If (p_rec.vhd_attribute19 = hr_api.g_varchar2) then
732: p_rec.vhd_attribute19 :=
733: pqp_pvd_shd.g_old_rec.vhd_attribute19;
734: End If;
735: If (p_rec.vhd_attribute20 = hr_api.g_varchar2) then
736: p_rec.vhd_attribute20 :=
737: pqp_pvd_shd.g_old_rec.vhd_attribute20;
738: End If;
739: If (p_rec.vhd_information_category = hr_api.g_varchar2) then

Line 739: If (p_rec.vhd_information_category = hr_api.g_varchar2) then

735: If (p_rec.vhd_attribute20 = hr_api.g_varchar2) then
736: p_rec.vhd_attribute20 :=
737: pqp_pvd_shd.g_old_rec.vhd_attribute20;
738: End If;
739: If (p_rec.vhd_information_category = hr_api.g_varchar2) then
740: p_rec.vhd_information_category :=
741: pqp_pvd_shd.g_old_rec.vhd_information_category;
742: End If;
743: If (p_rec.vhd_information1 = hr_api.g_varchar2) then

Line 743: If (p_rec.vhd_information1 = hr_api.g_varchar2) then

739: If (p_rec.vhd_information_category = hr_api.g_varchar2) then
740: p_rec.vhd_information_category :=
741: pqp_pvd_shd.g_old_rec.vhd_information_category;
742: End If;
743: If (p_rec.vhd_information1 = hr_api.g_varchar2) then
744: p_rec.vhd_information1 :=
745: pqp_pvd_shd.g_old_rec.vhd_information1;
746: End If;
747: If (p_rec.vhd_information2 = hr_api.g_varchar2) then

Line 747: If (p_rec.vhd_information2 = hr_api.g_varchar2) then

743: If (p_rec.vhd_information1 = hr_api.g_varchar2) then
744: p_rec.vhd_information1 :=
745: pqp_pvd_shd.g_old_rec.vhd_information1;
746: End If;
747: If (p_rec.vhd_information2 = hr_api.g_varchar2) then
748: p_rec.vhd_information2 :=
749: pqp_pvd_shd.g_old_rec.vhd_information2;
750: End If;
751: If (p_rec.vhd_information3 = hr_api.g_varchar2) then

Line 751: If (p_rec.vhd_information3 = hr_api.g_varchar2) then

747: If (p_rec.vhd_information2 = hr_api.g_varchar2) then
748: p_rec.vhd_information2 :=
749: pqp_pvd_shd.g_old_rec.vhd_information2;
750: End If;
751: If (p_rec.vhd_information3 = hr_api.g_varchar2) then
752: p_rec.vhd_information3 :=
753: pqp_pvd_shd.g_old_rec.vhd_information3;
754: End If;
755: If (p_rec.vhd_information4 = hr_api.g_varchar2) then

Line 755: If (p_rec.vhd_information4 = hr_api.g_varchar2) then

751: If (p_rec.vhd_information3 = hr_api.g_varchar2) then
752: p_rec.vhd_information3 :=
753: pqp_pvd_shd.g_old_rec.vhd_information3;
754: End If;
755: If (p_rec.vhd_information4 = hr_api.g_varchar2) then
756: p_rec.vhd_information4 :=
757: pqp_pvd_shd.g_old_rec.vhd_information4;
758: End If;
759: If (p_rec.vhd_information5 = hr_api.g_varchar2) then

Line 759: If (p_rec.vhd_information5 = hr_api.g_varchar2) then

755: If (p_rec.vhd_information4 = hr_api.g_varchar2) then
756: p_rec.vhd_information4 :=
757: pqp_pvd_shd.g_old_rec.vhd_information4;
758: End If;
759: If (p_rec.vhd_information5 = hr_api.g_varchar2) then
760: p_rec.vhd_information5 :=
761: pqp_pvd_shd.g_old_rec.vhd_information5;
762: End If;
763: If (p_rec.vhd_information6 = hr_api.g_varchar2) then

Line 763: If (p_rec.vhd_information6 = hr_api.g_varchar2) then

759: If (p_rec.vhd_information5 = hr_api.g_varchar2) then
760: p_rec.vhd_information5 :=
761: pqp_pvd_shd.g_old_rec.vhd_information5;
762: End If;
763: If (p_rec.vhd_information6 = hr_api.g_varchar2) then
764: p_rec.vhd_information6 :=
765: pqp_pvd_shd.g_old_rec.vhd_information6;
766: End If;
767: If (p_rec.vhd_information7 = hr_api.g_varchar2) then

Line 767: If (p_rec.vhd_information7 = hr_api.g_varchar2) then

763: If (p_rec.vhd_information6 = hr_api.g_varchar2) then
764: p_rec.vhd_information6 :=
765: pqp_pvd_shd.g_old_rec.vhd_information6;
766: End If;
767: If (p_rec.vhd_information7 = hr_api.g_varchar2) then
768: p_rec.vhd_information7 :=
769: pqp_pvd_shd.g_old_rec.vhd_information7;
770: End If;
771: If (p_rec.vhd_information8 = hr_api.g_varchar2) then

Line 771: If (p_rec.vhd_information8 = hr_api.g_varchar2) then

767: If (p_rec.vhd_information7 = hr_api.g_varchar2) then
768: p_rec.vhd_information7 :=
769: pqp_pvd_shd.g_old_rec.vhd_information7;
770: End If;
771: If (p_rec.vhd_information8 = hr_api.g_varchar2) then
772: p_rec.vhd_information8 :=
773: pqp_pvd_shd.g_old_rec.vhd_information8;
774: End If;
775: If (p_rec.vhd_information9 = hr_api.g_varchar2) then

Line 775: If (p_rec.vhd_information9 = hr_api.g_varchar2) then

771: If (p_rec.vhd_information8 = hr_api.g_varchar2) then
772: p_rec.vhd_information8 :=
773: pqp_pvd_shd.g_old_rec.vhd_information8;
774: End If;
775: If (p_rec.vhd_information9 = hr_api.g_varchar2) then
776: p_rec.vhd_information9 :=
777: pqp_pvd_shd.g_old_rec.vhd_information9;
778: End If;
779: If (p_rec.vhd_information10 = hr_api.g_varchar2) then

Line 779: If (p_rec.vhd_information10 = hr_api.g_varchar2) then

775: If (p_rec.vhd_information9 = hr_api.g_varchar2) then
776: p_rec.vhd_information9 :=
777: pqp_pvd_shd.g_old_rec.vhd_information9;
778: End If;
779: If (p_rec.vhd_information10 = hr_api.g_varchar2) then
780: p_rec.vhd_information10 :=
781: pqp_pvd_shd.g_old_rec.vhd_information10;
782: End If;
783: If (p_rec.vhd_information11 = hr_api.g_varchar2) then

Line 783: If (p_rec.vhd_information11 = hr_api.g_varchar2) then

779: If (p_rec.vhd_information10 = hr_api.g_varchar2) then
780: p_rec.vhd_information10 :=
781: pqp_pvd_shd.g_old_rec.vhd_information10;
782: End If;
783: If (p_rec.vhd_information11 = hr_api.g_varchar2) then
784: p_rec.vhd_information11 :=
785: pqp_pvd_shd.g_old_rec.vhd_information11;
786: End If;
787: If (p_rec.vhd_information12 = hr_api.g_varchar2) then

Line 787: If (p_rec.vhd_information12 = hr_api.g_varchar2) then

783: If (p_rec.vhd_information11 = hr_api.g_varchar2) then
784: p_rec.vhd_information11 :=
785: pqp_pvd_shd.g_old_rec.vhd_information11;
786: End If;
787: If (p_rec.vhd_information12 = hr_api.g_varchar2) then
788: p_rec.vhd_information12 :=
789: pqp_pvd_shd.g_old_rec.vhd_information12;
790: End If;
791: If (p_rec.vhd_information13 = hr_api.g_varchar2) then

Line 791: If (p_rec.vhd_information13 = hr_api.g_varchar2) then

787: If (p_rec.vhd_information12 = hr_api.g_varchar2) then
788: p_rec.vhd_information12 :=
789: pqp_pvd_shd.g_old_rec.vhd_information12;
790: End If;
791: If (p_rec.vhd_information13 = hr_api.g_varchar2) then
792: p_rec.vhd_information13 :=
793: pqp_pvd_shd.g_old_rec.vhd_information13;
794: End If;
795: If (p_rec.vhd_information14 = hr_api.g_varchar2) then

Line 795: If (p_rec.vhd_information14 = hr_api.g_varchar2) then

791: If (p_rec.vhd_information13 = hr_api.g_varchar2) then
792: p_rec.vhd_information13 :=
793: pqp_pvd_shd.g_old_rec.vhd_information13;
794: End If;
795: If (p_rec.vhd_information14 = hr_api.g_varchar2) then
796: p_rec.vhd_information14 :=
797: pqp_pvd_shd.g_old_rec.vhd_information14;
798: End If;
799: If (p_rec.vhd_information15 = hr_api.g_varchar2) then

Line 799: If (p_rec.vhd_information15 = hr_api.g_varchar2) then

795: If (p_rec.vhd_information14 = hr_api.g_varchar2) then
796: p_rec.vhd_information14 :=
797: pqp_pvd_shd.g_old_rec.vhd_information14;
798: End If;
799: If (p_rec.vhd_information15 = hr_api.g_varchar2) then
800: p_rec.vhd_information15 :=
801: pqp_pvd_shd.g_old_rec.vhd_information15;
802: End If;
803: If (p_rec.vhd_information16 = hr_api.g_varchar2) then

Line 803: If (p_rec.vhd_information16 = hr_api.g_varchar2) then

799: If (p_rec.vhd_information15 = hr_api.g_varchar2) then
800: p_rec.vhd_information15 :=
801: pqp_pvd_shd.g_old_rec.vhd_information15;
802: End If;
803: If (p_rec.vhd_information16 = hr_api.g_varchar2) then
804: p_rec.vhd_information16 :=
805: pqp_pvd_shd.g_old_rec.vhd_information16;
806: End If;
807: If (p_rec.vhd_information17 = hr_api.g_varchar2) then

Line 807: If (p_rec.vhd_information17 = hr_api.g_varchar2) then

803: If (p_rec.vhd_information16 = hr_api.g_varchar2) then
804: p_rec.vhd_information16 :=
805: pqp_pvd_shd.g_old_rec.vhd_information16;
806: End If;
807: If (p_rec.vhd_information17 = hr_api.g_varchar2) then
808: p_rec.vhd_information17 :=
809: pqp_pvd_shd.g_old_rec.vhd_information17;
810: End If;
811: If (p_rec.vhd_information18 = hr_api.g_varchar2) then

Line 811: If (p_rec.vhd_information18 = hr_api.g_varchar2) then

807: If (p_rec.vhd_information17 = hr_api.g_varchar2) then
808: p_rec.vhd_information17 :=
809: pqp_pvd_shd.g_old_rec.vhd_information17;
810: End If;
811: If (p_rec.vhd_information18 = hr_api.g_varchar2) then
812: p_rec.vhd_information18 :=
813: pqp_pvd_shd.g_old_rec.vhd_information18;
814: End If;
815: If (p_rec.vhd_information19 = hr_api.g_varchar2) then

Line 815: If (p_rec.vhd_information19 = hr_api.g_varchar2) then

811: If (p_rec.vhd_information18 = hr_api.g_varchar2) then
812: p_rec.vhd_information18 :=
813: pqp_pvd_shd.g_old_rec.vhd_information18;
814: End If;
815: If (p_rec.vhd_information19 = hr_api.g_varchar2) then
816: p_rec.vhd_information19 :=
817: pqp_pvd_shd.g_old_rec.vhd_information19;
818: End If;
819: If (p_rec.vhd_information20 = hr_api.g_varchar2) then

Line 819: If (p_rec.vhd_information20 = hr_api.g_varchar2) then

815: If (p_rec.vhd_information19 = hr_api.g_varchar2) then
816: p_rec.vhd_information19 :=
817: pqp_pvd_shd.g_old_rec.vhd_information19;
818: End If;
819: If (p_rec.vhd_information20 = hr_api.g_varchar2) then
820: p_rec.vhd_information20 :=
821: pqp_pvd_shd.g_old_rec.vhd_information20;
822: End If;
823: --

Line 881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2

877: Procedure upd
878: (p_effective_date in date
879: ,p_vehicle_details_id in number
880: ,p_object_version_number in out nocopy number
881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date

Line 882: ,p_registration_number in varchar2 default hr_api.g_varchar2

878: (p_effective_date in date
879: ,p_vehicle_details_id in number
880: ,p_object_version_number in out nocopy number
881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number

Line 883: ,p_make in varchar2 default hr_api.g_varchar2

879: ,p_vehicle_details_id in number
880: ,p_object_version_number in out nocopy number
881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2

Line 884: ,p_model in varchar2 default hr_api.g_varchar2

880: ,p_object_version_number in out nocopy number
881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2

Line 885: ,p_date_first_registered in date default hr_api.g_date

881: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 886: ,p_engine_capacity_in_cc in number default hr_api.g_number

882: ,p_registration_number in varchar2 default hr_api.g_varchar2
883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number

Line 887: ,p_fuel_type in varchar2 default hr_api.g_varchar2

883: ,p_make in varchar2 default hr_api.g_varchar2
884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number

Line 888: ,p_fuel_card in varchar2 default hr_api.g_varchar2

884: ,p_model in varchar2 default hr_api.g_varchar2
885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number

Line 889: ,p_currency_code in varchar2 default hr_api.g_varchar2

885: ,p_date_first_registered in date default hr_api.g_date
886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number

Line 890: ,p_list_price in number default hr_api.g_number

886: ,p_engine_capacity_in_cc in number default hr_api.g_number
887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number

Line 891: ,p_business_group_id in number default hr_api.g_number

887: ,p_fuel_type in varchar2 default hr_api.g_varchar2
888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number

Line 892: ,p_accessory_value_at_startdate in number default hr_api.g_number

888: ,p_fuel_card in varchar2 default hr_api.g_varchar2
889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number

Line 893: ,p_accessory_value_added_later in number default hr_api.g_number

889: ,p_currency_code in varchar2 default hr_api.g_varchar2
890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number

Line 894: -- ,p_capital_contributions in number default hr_api.g_number

890: ,p_list_price in number default hr_api.g_number
891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2

Line 895: -- ,p_private_use_contributions in number default hr_api.g_number

891: ,p_business_group_id in number default hr_api.g_number
892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2

Line 896: ,p_market_value_classic_car in number default hr_api.g_number

892: ,p_accessory_value_at_startdate in number default hr_api.g_number
893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2

Line 897: ,p_co2_emissions in number default hr_api.g_number

893: ,p_accessory_value_added_later in number default hr_api.g_number
894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2

Line 898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2

894: -- ,p_capital_contributions in number default hr_api.g_number
895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2

Line 899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2

895: -- ,p_private_use_contributions in number default hr_api.g_number
896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2

Line 900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2

896: ,p_market_value_classic_car in number default hr_api.g_number
897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2

Line 901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2

897: ,p_co2_emissions in number default hr_api.g_number
898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2

Line 902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2

898: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2

Line 903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2

899: ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2

Line 904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2

900: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2

Line 905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2

901: ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2

Line 906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2

902: ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2

Line 907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2

903: ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2

Line 908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2

904: ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2

Line 909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2

905: ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2

Line 910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2

906: ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2

Line 911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2

907: ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2

Line 912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2

908: ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2

Line 913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2

909: ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2

Line 914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2

910: ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2

Line 915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2

911: ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2

Line 916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2

912: ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2

Line 917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2

913: ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2

Line 918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2

914: ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2

Line 919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2

915: ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2

Line 920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2

916: ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2

Line 921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2

917: ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2

Line 922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2

918: ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2

Line 923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2

919: ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2

Line 924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2

920: ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2

Line 925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2

921: ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2

Line 926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2

922: ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2

Line 927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2

923: ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2

Line 928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2

924: ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2

Line 929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2

925: ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2

Line 930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2

926: ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2

Line 931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2

927: ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2

Line 932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2

928: ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2

Line 933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2

929: ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2

Line 934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2

930: ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2

Line 935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2

931: ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2

Line 936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2

932: ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2

Line 937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2

933: ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2

Line 938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2

934: ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2

Line 939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2

935: ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
943: ) is

Line 940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2

936: ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
943: ) is
944: --

Line 941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2

937: ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
943: ) is
944: --
945: l_rec pqp_pvd_shd.g_rec_type;

Line 942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2

938: ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
939: ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
940: ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
941: ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
942: ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
943: ) is
944: --
945: l_rec pqp_pvd_shd.g_rec_type;
946: l_proc varchar2(72) := g_package||'upd';