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_PL_VEHICLE_REPOSITORY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 103


PROCEDURE update_pl_vehicle(P_EFFECTIVE_DATE 		in DATE
		,P_DATETRACK_MODE 						in VARCHAR2
		,P_VEHICLE_REPOSITORY_ID 				in NUMBER
		,P_OBJECT_VERSION_NUMBER 				in NUMBER
		,P_REGISTRATION_NUMBER 					in VARCHAR2
		,P_VEHICLE_TYPE 						in VARCHAR2
		,P_VEHICLE_ID_NUMBER 					in VARCHAR2
		,P_BUSINESS_GROUP_ID 					in NUMBER
		,P_MAKE 								in VARCHAR2
		,P_ENGINE_CAPACITY_IN_CC				in NUMBER
		,P_FUEL_TYPE 							in VARCHAR2
		,P_CURRENCY_CODE 						in VARCHAR2
		,P_VEHICLE_STATUS 						in VARCHAR2
		,P_VEHICLE_INACTIVITY_REASON 			in VARCHAR2
		,P_MODEL 								in VARCHAR2
		,P_INITIAL_REGISTRATION 				in DATE
		,P_LAST_REGISTRATION_RENEW_DATE			in DATE
		,P_LIST_PRICE 							in NUMBER
		,P_ACCESSORY_VALUE_AT_STARTDATE			in NUMBER
		,P_ACCESSORY_VALUE_ADDED_LATER 			in NUMBER
		,P_MARKET_VALUE_CLASSIC_CAR 			in NUMBER
		,P_FISCAL_RATINGS 						in NUMBER
		,P_FISCAL_RATINGS_UOM 					in VARCHAR2
		,P_VEHICLE_PROVIDER 					in VARCHAR2
		,P_VEHICLE_OWNERSHIP 					in VARCHAR2
		,P_SHARED_VEHICLE 						in VARCHAR2
		,P_ASSET_NUMBER 						in VARCHAR2
		,P_LEASE_CONTRACT_NUMBER 				in VARCHAR2
		,P_LEASE_CONTRACT_EXPIRY_DATE 			in DATE
		,P_TAXATION_METHOD 						in VARCHAR2
		,P_FLEET_INFO 							in VARCHAR2
		,P_FLEET_TRANSFER_DATE 					in DATE
		,P_COLOR 								in VARCHAR2
		,P_SEATING_CAPACITY 					in NUMBER
		,P_WEIGHT 								in NUMBER
		,P_WEIGHT_UOM 							in VARCHAR2
		,P_MODEL_YEAR 							in NUMBER
		,P_INSURANCE_NUMBER 					in VARCHAR2
		,P_INSURANCE_EXPIRY_DATE 				in DATE
		,P_COMMENTS 							in VARCHAR2
		,P_VRE_ATTRIBUTE_CATEGORY 				in VARCHAR2
		,P_VRE_INFORMATION_CATEGORY 			in VARCHAR2
 		,P_VRE_INFORMATION1 					in VARCHAR2
		,P_VRE_INFORMATION2 					in VARCHAR2
		,P_VRE_INFORMATION3 					in VARCHAR2
		,P_VRE_INFORMATION4 					in VARCHAR2
		,P_VRE_INFORMATION5 					in VARCHAR2
		,P_VRE_INFORMATION6 					in VARCHAR2
		,P_VRE_INFORMATION7 					in VARCHAR2
		,P_VRE_INFORMATION8 					in VARCHAR2
		,P_VRE_INFORMATION9 					in VARCHAR2
		,P_VRE_INFORMATION10 					in VARCHAR2
		,P_VRE_INFORMATION11 					in VARCHAR2
		,P_VRE_INFORMATION12 					in VARCHAR2
		,P_VRE_INFORMATION13 					in VARCHAR2
		,P_VRE_INFORMATION14 					in VARCHAR2
		,P_VRE_INFORMATION15 					in VARCHAR2
		,P_VRE_INFORMATION16 					in VARCHAR2
		,P_VRE_INFORMATION17 					in VARCHAR2
		,P_VRE_INFORMATION18 					in VARCHAR2
		,P_VRE_INFORMATION19 					in VARCHAR2
		,P_VRE_INFORMATION20 					in VARCHAR2) is
Begin
  /* Added for GSI Bug 5472781 */
IF NOT hr_utility.chk_product_install('Oracle Human Resources', 'PL') THEN
   hr_utility.trace('PL not installed.Leaving update_pl_vehicle');

Line: 194


End update_pl_vehicle;