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.
PACKAGE: APPS.PQP_PL_VEHICLE_REPOSITORY

Source


1 PACKAGE pqp_pl_vehicle_repository AS
2 /* $Header: pqplvrep.pkh 120.0.12000000.1 2007/01/16 04:23:58 appldev noship $ */
3 PROCEDURE create_pl_vehicle(P_EFFECTIVE_DATE in DATE
4 		,P_REGISTRATION_NUMBER in VARCHAR2
5 		,P_VEHICLE_TYPE in VARCHAR2
6 		,P_VEHICLE_ID_NUMBER in VARCHAR2
7 		,P_BUSINESS_GROUP_ID in NUMBER
8 		,P_MAKE in VARCHAR2
9 		,P_ENGINE_CAPACITY_IN_CC in NUMBER
10 		,P_FUEL_TYPE in VARCHAR2
11 		,P_CURRENCY_CODE in VARCHAR2
12 		,P_VEHICLE_STATUS in VARCHAR2
13 		,P_VEHICLE_INACTIVITY_REASON in VARCHAR2
14 		,P_MODEL in VARCHAR2
15 		,P_INITIAL_REGISTRATION in DATE
16 		,P_LAST_REGISTRATION_RENEW_DATE in DATE
17 		,P_LIST_PRICE in NUMBER
18 		,P_ACCESSORY_VALUE_AT_STARTDATE in NUMBER
19 		,P_ACCESSORY_VALUE_ADDED_LATER in NUMBER
20 		,P_MARKET_VALUE_CLASSIC_CAR in NUMBER
21 		,P_FISCAL_RATINGS in NUMBER
22 		,P_FISCAL_RATINGS_UOM in VARCHAR2
23 		,P_VEHICLE_PROVIDER in VARCHAR2
24 		,P_VEHICLE_OWNERSHIP in VARCHAR2
25 		,P_SHARED_VEHICLE in VARCHAR2
26 		,P_ASSET_NUMBER in VARCHAR2
27 		,P_LEASE_CONTRACT_NUMBER in VARCHAR2
28 		,P_LEASE_CONTRACT_EXPIRY_DATE in DATE
29 		,P_TAXATION_METHOD in VARCHAR2
30 		,P_FLEET_INFO in VARCHAR2
31 		,P_FLEET_TRANSFER_DATE in DATE
32 		,P_COLOR in VARCHAR2
33 		,P_SEATING_CAPACITY in NUMBER
34 		,P_WEIGHT in NUMBER
35 		,P_WEIGHT_UOM in VARCHAR2
36 		,P_MODEL_YEAR in NUMBER
37 		,P_INSURANCE_NUMBER in VARCHAR2
38 		,P_INSURANCE_EXPIRY_DATE in DATE
39 		,P_COMMENTS in VARCHAR2
40 		,P_VRE_ATTRIBUTE_CATEGORY in VARCHAR2
41 		,P_VRE_INFORMATION_CATEGORY in VARCHAR2
42 		,P_VRE_INFORMATION1 in VARCHAR2
43 		,P_VRE_INFORMATION2 in VARCHAR2
44 		,P_VRE_INFORMATION3 in VARCHAR2
45 		,P_VRE_INFORMATION4 in VARCHAR2
46 		,P_VRE_INFORMATION5 in VARCHAR2
47 		,P_VRE_INFORMATION6 in VARCHAR2
48 		,P_VRE_INFORMATION7 in VARCHAR2
49 		,P_VRE_INFORMATION8 in VARCHAR2
50 		,P_VRE_INFORMATION9 in VARCHAR2
51 		,P_VRE_INFORMATION10 in VARCHAR2
52 		,P_VRE_INFORMATION11 in VARCHAR2
53 		,P_VRE_INFORMATION12 in VARCHAR2
54 		,P_VRE_INFORMATION13 in VARCHAR2
55 		,P_VRE_INFORMATION14 in VARCHAR2
56 		,P_VRE_INFORMATION15 in VARCHAR2
57 		,P_VRE_INFORMATION16 in VARCHAR2
58 		,P_VRE_INFORMATION17 in VARCHAR2
59 		,P_VRE_INFORMATION18 in VARCHAR2
60 		,P_VRE_INFORMATION19 in VARCHAR2
61 		,P_VRE_INFORMATION20 in VARCHAR2
62 		);
63 
64 PROCEDURE update_pl_vehicle(P_EFFECTIVE_DATE in DATE
65 		,P_DATETRACK_MODE in VARCHAR2
66 		,P_VEHICLE_REPOSITORY_ID in NUMBER
67 		,P_OBJECT_VERSION_NUMBER in NUMBER
68 		,P_REGISTRATION_NUMBER in VARCHAR2
69 		,P_VEHICLE_TYPE in VARCHAR2
70 		,P_VEHICLE_ID_NUMBER in VARCHAR2
71 		,P_BUSINESS_GROUP_ID in NUMBER
72 		,P_MAKE in VARCHAR2
73 		,P_ENGINE_CAPACITY_IN_CC in NUMBER
74 		,P_FUEL_TYPE in VARCHAR2
75 		,P_CURRENCY_CODE in VARCHAR2
76 		,P_VEHICLE_STATUS in VARCHAR2
77 		,P_VEHICLE_INACTIVITY_REASON in VARCHAR2
78 		,P_MODEL in VARCHAR2
79 		,P_INITIAL_REGISTRATION in DATE
80 		,P_LAST_REGISTRATION_RENEW_DATE in DATE
81 		,P_LIST_PRICE in NUMBER
82 		,P_ACCESSORY_VALUE_AT_STARTDATE in NUMBER
83 		,P_ACCESSORY_VALUE_ADDED_LATER in NUMBER
84 		,P_MARKET_VALUE_CLASSIC_CAR in NUMBER
85 		,P_FISCAL_RATINGS in NUMBER
86 		,P_FISCAL_RATINGS_UOM in VARCHAR2
87 		,P_VEHICLE_PROVIDER in VARCHAR2
88 		,P_VEHICLE_OWNERSHIP in VARCHAR2
89 		,P_SHARED_VEHICLE in VARCHAR2
90 		,P_ASSET_NUMBER in VARCHAR2
91 		,P_LEASE_CONTRACT_NUMBER in VARCHAR2
92 		,P_LEASE_CONTRACT_EXPIRY_DATE in DATE
93 		,P_TAXATION_METHOD in VARCHAR2
94 		,P_FLEET_INFO in VARCHAR2
95 		,P_FLEET_TRANSFER_DATE in DATE
96 		,P_COLOR in VARCHAR2
97 		,P_SEATING_CAPACITY in NUMBER
98 		,P_WEIGHT in NUMBER
99 		,P_WEIGHT_UOM in VARCHAR2
100 		,P_MODEL_YEAR in NUMBER
101 		,P_INSURANCE_NUMBER in VARCHAR2
102 		,P_INSURANCE_EXPIRY_DATE in DATE
103 		,P_COMMENTS in VARCHAR2
104 		,P_VRE_ATTRIBUTE_CATEGORY in VARCHAR2
105 		,P_VRE_INFORMATION_CATEGORY in VARCHAR2
106  		,P_VRE_INFORMATION1 in VARCHAR2
107 		,P_VRE_INFORMATION2 in VARCHAR2
108 		,P_VRE_INFORMATION3 in VARCHAR2
109 		,P_VRE_INFORMATION4 in VARCHAR2
110 		,P_VRE_INFORMATION5 in VARCHAR2
111 		,P_VRE_INFORMATION6 in VARCHAR2
112 		,P_VRE_INFORMATION7 in VARCHAR2
113 		,P_VRE_INFORMATION8 in VARCHAR2
114 		,P_VRE_INFORMATION9 in VARCHAR2
115 		,P_VRE_INFORMATION10 in VARCHAR2
116 		,P_VRE_INFORMATION11 in VARCHAR2
117 		,P_VRE_INFORMATION12 in VARCHAR2
118 		,P_VRE_INFORMATION13 in VARCHAR2
119 		,P_VRE_INFORMATION14 in VARCHAR2
120 		,P_VRE_INFORMATION15 in VARCHAR2
121 		,P_VRE_INFORMATION16 in VARCHAR2
122 		,P_VRE_INFORMATION17 in VARCHAR2
123 		,P_VRE_INFORMATION18 in VARCHAR2
124 		,P_VRE_INFORMATION19 in VARCHAR2
125 		,P_VRE_INFORMATION20 in VARCHAR2);
126 
127 END pqp_pl_vehicle_repository;