1 Package PQP_VEHICLE_DETAILS_API AUTHID CURRENT_USER as
2 /* $Header: pqpvdapi.pkh 115.6 2003/03/13 19:17:09 sshetty ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |--------------------------< CREATE_VEHICLE_DETAILS >--------------------------|
6 -- ----------------------------------------------------------------------------
7 -- Description:
8 -- Business process to create vehicle details.
9 --
10 -- Prerequisites:
11 --
12 --
13 -- In Parameters:
14
15 -- Name Reqd Type Description
16 -- p_vehicle_details_id yes number
17 -- p_vehicle_type yes varchar2
18 -- p_business_group_id no number
19 -- p_registration_number yes varchar2
20 -- p_make yes varchar2
21 -- p_model yes varchar2
22 -- p_date_first_registered yes date
23 -- p_engine_capacity_in_cc yes number
24 -- p_fuel_type yes varchar2
25 -- p_fuel_card yes varchar2
26 -- p_currency_code yes varchar2
27 -- p_list_price yes number
28 -- p_business_group_id no number
29 -- p_accessory_value_at_startdate no number
30 -- p_accessory_value_added_later no number
31 -- p_capital_contributions no number
32 -- p_private_use_contributions no number
33 -- p_market_value_classic_car no number
34 -- p_co2_emissions no number
35 -- p_vehicle_provider no varchar2
36 -- p_vehicle_ownership no varchar2
37 -- p_vehicle_identification_numbe no varchar2
38 -- p_object_version_number yes number
39 -- p_vhd_attribute_category no varchar2
40 -- p_vhd_attribute1 no varchar2
41 -- p_vhd_attribute2 no varchar2
42 -- p_vhd_attribute3 no varchar2
43 -- p_vhd_attribute4 no varchar2
44 -- p_vhd_attribute5 no varchar2
45 -- p_vhd_attribute6 no varchar2
46 -- p_vhd_attribute7 no varchar2
47 -- p_vhd_attribute8 no varchar2
48 -- p_vhd_attribute9 no varchar2
49 -- p_vhd_attribute10 no varchar2
50 -- p_vhd_attribute11 no varchar2
51 -- p_vhd_attribute12 no varchar2
52 -- p_vhd_attribute13 no varchar2
53 -- p_vhd_attribute14 no varchar2
54 -- p_vhd_attribute15 no varchar2
55 -- p_vhd_attribute16 no varchar2
56 -- p_vhd_attribute17 no varchar2
57 -- p_vhd_attribute18 no varchar2
58 -- p_vhd_attribute19 no varchar2
59 -- p_vhd_attribute20 no varchar2
60 -- p_vhd_information_category no varchar2
61 -- p_vhd_information1 no varchar2
62 -- p_vhd_information2 no varchar2
63 -- p_vhd_information3 no varchar2
64 -- p_vhd_information4 no varchar2
65 -- p_vhd_information5 no varchar2
66 -- p_vhd_information6 no varchar2
67 -- p_vhd_information7 no varchar2
68 -- p_vhd_information8 no varchar2
69 -- p_vhd_information9 no varchar2
70 -- p_vhd_information10 no varchar2
71 -- p_vhd_information11 no varchar2
72 -- p_vhd_information12 no varchar2
73 -- p_vhd_information13 no varchar2
74 -- p_vhd_information14 no varchar2
75 -- p_vhd_information15 no varchar2
76 -- p_vhd_information16 no varchar2
77 -- p_vhd_information17 no varchar2
78 -- p_vhd_information18 no varchar2
79 -- p_vhd_information19 no varchar2
80 -- p_vhd_information20 no varchar2
81
82 --
83 -- Post Success:
84 --
85 --
86 -- Name Type Description
87 --
88 -- Post Failure:
89 --
90 --
91 -- Access Status:
92 -- Internal Development Use Only.
93 --
94 procedure create_vehicle_details
95 ( p_effective_date in date default NULL
96 ,p_vehicle_type in varchar2
97 ,p_registration_number in varchar2
98 ,p_make in varchar2
99 ,p_model in varchar2
100 ,p_date_first_registered in date
101 ,p_engine_capacity_in_cc in number
102 ,p_fuel_type in varchar2
103 ,p_fuel_card in varchar2
104 ,p_currency_code in varchar2
105 ,p_list_price in number
106 ,p_business_group_id in number
107 ,p_accessory_value_at_startdate in number default NULL
108 ,p_accessory_value_added_later in number default NULL
109 -- ,p_capital_contributions in number
110 -- ,p_private_use_contributions in number
111 ,p_market_value_classic_car in number default NULL
112 ,p_co2_emissions in number default NULL
113 ,p_vehicle_provider in varchar2 default NULL
114 ,p_vehicle_ownership in varchar2 default NULL
115 ,p_vehicle_identification_numbe in varchar2 default NULL
116 ,p_vhd_attribute_category in varchar2
117 ,p_vhd_attribute1 in varchar2
118 ,p_vhd_attribute2 in varchar2
119 ,p_vhd_attribute3 in varchar2
120 ,p_vhd_attribute4 in varchar2
121 ,p_vhd_attribute5 in varchar2
122 ,p_vhd_attribute6 in varchar2
123 ,p_vhd_attribute7 in varchar2
124 ,p_vhd_attribute8 in varchar2
125 ,p_vhd_attribute9 in varchar2
126 ,p_vhd_attribute10 in varchar2
127 ,p_vhd_attribute11 in varchar2
128 ,p_vhd_attribute12 in varchar2
129 ,p_vhd_attribute13 in varchar2
130 ,p_vhd_attribute14 in varchar2
131 ,p_vhd_attribute15 in varchar2
132 ,p_vhd_attribute16 in varchar2
133 ,p_vhd_attribute17 in varchar2
134 ,p_vhd_attribute18 in varchar2
135 ,p_vhd_attribute19 in varchar2
136 ,p_vhd_attribute20 in varchar2
137 ,p_vhd_information_category in varchar2
138 ,p_vhd_information1 in varchar2
139 ,p_vhd_information2 in varchar2
140 ,p_vhd_information3 in varchar2
141 ,p_vhd_information4 in varchar2
142 ,p_vhd_information5 in varchar2
143 ,p_vhd_information6 in varchar2
144 ,p_vhd_information7 in varchar2
145 ,p_vhd_information8 in varchar2
146 ,p_vhd_information9 in varchar2
147 ,p_vhd_information10 in varchar2
148 ,p_vhd_information11 in varchar2
149 ,p_vhd_information12 in varchar2
150 ,p_vhd_information13 in varchar2
151 ,p_vhd_information14 in varchar2
152 ,p_vhd_information15 in varchar2
153 ,p_vhd_information16 in varchar2
154 ,p_vhd_information17 in varchar2
155 ,p_vhd_information18 in varchar2
156 ,p_vhd_information19 in varchar2
157 ,p_vhd_information20 in varchar2
158 ,p_vehicle_details_id out nocopy number
159 ,p_object_version_number out nocopy number
160 );
161 --
162 -- ----------------------------------------------------------------------------
163 -- |--------------------------< UPDATE_VEHICLE_DETAILS >-----------------------|
164 -- ----------------------------------------------------------------------------
165 -- Description:
166 -- Business process to update vehicle details.
167 --
168 -- Prerequisites:
169 --
170 --
171 -- In Parameters:
172
173 -- Name Reqd Type Description
174 --p_effective_date yes date
175 --p_vehicle_details_id yes number
176 --p_object_version_number yes number
177 --p_vehicle_type no varchar2
178 --p_registration_number no varchar2
179 --p_make no varchar2
180 --p_model no varchar2
181 --p_date_first_registered no date
182 --p_engine_capacity_in_cc no number
183 --p_fuel_type no varchar2
184 --p_fuel_card no varchar2
185 --p_currency_code no varchar2
186 --p_list_price no number
187 --p_business_group_id no number
188 --p_accessory_value_at_startdate no number
189 --p_accessory_value_added_later no number
190 --p_capital_contributions no number
191 --p_private_use_contributions no number
192 --p_market_value_classic_car no number
193 --p_co2_emissions no number
194 --p_vehicle_provider no varchar2
195 --p_vehicle_ownership no varchar2
196 --p_vehicle_identification_numbe no varchar2
197 -- p_vhd_attribute_category no varchar2
198 -- p_vhd_attribute1 no varchar2
199 -- p_vhd_attribute2 no varchar2
200 -- p_vhd_attribute3 no varchar2
201 -- p_vhd_attribute4 no varchar2
202 -- p_vhd_attribute5 no varchar2
203 -- p_vhd_attribute6 no varchar2
204 -- p_vhd_attribute7 no varchar2
205 -- p_vhd_attribute8 no varchar2
206 -- p_vhd_attribute9 no varchar2
207 -- p_vhd_attribute10 no varchar2
208 -- p_vhd_attribute11 no varchar2
209 -- p_vhd_attribute12 no varchar2
210 -- p_vhd_attribute13 no varchar2
211 -- p_vhd_attribute14 no varchar2
212 -- p_vhd_attribute15 no varchar2
213 -- p_vhd_attribute16 no varchar2
214 -- p_vhd_attribute17 no varchar2
215 -- p_vhd_attribute18 no varchar2
216 -- p_vhd_attribute19 no varchar2
217 -- p_vhd_attribute20 no varchar2
218 -- p_vhd_information_category no varchar2
219 -- p_vhd_information1 no varchar2
220 -- p_vhd_information2 no varchar2
221 -- p_vhd_information3 no varchar2
222 -- p_vhd_information4 no varchar2
223 -- p_vhd_information5 no varchar2
224 -- p_vhd_information6 no varchar2
225 -- p_vhd_information7 no varchar2
226 -- p_vhd_information8 no varchar2
227 -- p_vhd_information9 no varchar2
228 -- p_vhd_information10 no varchar2
229 -- p_vhd_information11 no varchar2
230 -- p_vhd_information12 no varchar2
231 -- p_vhd_information13 no varchar2
232 -- p_vhd_information14 no varchar2
233 -- p_vhd_information15 no varchar2
234 -- p_vhd_information16 no varchar2
235 -- p_vhd_information17 no varchar2
236 -- p_vhd_information18 no varchar2
237 -- p_vhd_information19 no varchar2
238 -- p_vhd_information20 no varchar2
239 --p_vehicle_details_id yes number
240 -- p_object_version_number yes number
241 --
242 -- Post Success:
243 --
244 --
245 -- Name Type Description
246 --
247 -- Post Failure:
248 --
249 --
250 -- Access Status:
251 -- Public.
252 --
253 procedure update_vehicle_details
254 (p_effective_date in date default NULL
255 ,p_vehicle_details_id in number
256 ,p_object_version_number in out nocopy number
257 ,p_vehicle_type in varchar2 default hr_api.g_varchar2
258 ,p_registration_number in varchar2 default hr_api.g_varchar2
259 ,p_make in varchar2 default hr_api.g_varchar2
260 ,p_model in varchar2 default hr_api.g_varchar2
261 ,p_date_first_registered in date default hr_api.g_date
262 ,p_engine_capacity_in_cc in number default hr_api.g_number
263 ,p_fuel_type in varchar2 default hr_api.g_varchar2
264 ,p_fuel_card in varchar2 default hr_api.g_varchar2
265 ,p_currency_code in varchar2 default hr_api.g_varchar2
266 ,p_list_price in number default hr_api.g_number
267 ,p_business_group_id in number default hr_api.g_number
268 ,p_accessory_value_at_startdate in number default hr_api.g_number
269 ,p_accessory_value_added_later in number default hr_api.g_number
270 -- ,p_capital_contributions in number default hr_api.g_number
271 -- ,p_private_use_contributions in number default hr_api.g_number
272 ,p_market_value_classic_car in number default hr_api.g_number
273 ,p_co2_emissions in number default hr_api.g_number
274 ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
275 ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
276 ,p_vehicle_identification_numbe in varchar2 default hr_api.g_varchar2
277 ,p_vhd_attribute_category in varchar2 default hr_api.g_varchar2
278 ,p_vhd_attribute1 in varchar2 default hr_api.g_varchar2
279 ,p_vhd_attribute2 in varchar2 default hr_api.g_varchar2
280 ,p_vhd_attribute3 in varchar2 default hr_api.g_varchar2
281 ,p_vhd_attribute4 in varchar2 default hr_api.g_varchar2
282 ,p_vhd_attribute5 in varchar2 default hr_api.g_varchar2
283 ,p_vhd_attribute6 in varchar2 default hr_api.g_varchar2
284 ,p_vhd_attribute7 in varchar2 default hr_api.g_varchar2
285 ,p_vhd_attribute8 in varchar2 default hr_api.g_varchar2
286 ,p_vhd_attribute9 in varchar2 default hr_api.g_varchar2
287 ,p_vhd_attribute10 in varchar2 default hr_api.g_varchar2
288 ,p_vhd_attribute11 in varchar2 default hr_api.g_varchar2
289 ,p_vhd_attribute12 in varchar2 default hr_api.g_varchar2
290 ,p_vhd_attribute13 in varchar2 default hr_api.g_varchar2
291 ,p_vhd_attribute14 in varchar2 default hr_api.g_varchar2
292 ,p_vhd_attribute15 in varchar2 default hr_api.g_varchar2
293 ,p_vhd_attribute16 in varchar2 default hr_api.g_varchar2
294 ,p_vhd_attribute17 in varchar2 default hr_api.g_varchar2
298 ,p_vhd_information_category in varchar2 default hr_api.g_varchar2
295 ,p_vhd_attribute18 in varchar2 default hr_api.g_varchar2
296 ,p_vhd_attribute19 in varchar2 default hr_api.g_varchar2
297 ,p_vhd_attribute20 in varchar2 default hr_api.g_varchar2
299 ,p_vhd_information1 in varchar2 default hr_api.g_varchar2
300 ,p_vhd_information2 in varchar2 default hr_api.g_varchar2
301 ,p_vhd_information3 in varchar2 default hr_api.g_varchar2
302 ,p_vhd_information4 in varchar2 default hr_api.g_varchar2
303 ,p_vhd_information5 in varchar2 default hr_api.g_varchar2
304 ,p_vhd_information6 in varchar2 default hr_api.g_varchar2
305 ,p_vhd_information7 in varchar2 default hr_api.g_varchar2
306 ,p_vhd_information8 in varchar2 default hr_api.g_varchar2
307 ,p_vhd_information9 in varchar2 default hr_api.g_varchar2
308 ,p_vhd_information10 in varchar2 default hr_api.g_varchar2
309 ,p_vhd_information11 in varchar2 default hr_api.g_varchar2
310 ,p_vhd_information12 in varchar2 default hr_api.g_varchar2
311 ,p_vhd_information13 in varchar2 default hr_api.g_varchar2
312 ,p_vhd_information14 in varchar2 default hr_api.g_varchar2
313 ,p_vhd_information15 in varchar2 default hr_api.g_varchar2
314 ,p_vhd_information16 in varchar2 default hr_api.g_varchar2
315 ,p_vhd_information17 in varchar2 default hr_api.g_varchar2
316 ,p_vhd_information18 in varchar2 default hr_api.g_varchar2
317 ,p_vhd_information19 in varchar2 default hr_api.g_varchar2
318 ,p_vhd_information20 in varchar2 default hr_api.g_varchar2
319 );
320
321 -- ----------------------------------------------------------------------------
322 -- |--------------------------< DELETE_VEHICLE_DETAILS >-----------------------|
323 -- ----------------------------------------------------------------------------
324 -- Description:
325 -- Business process to delete vehicle details.
326 --
327 -- Prerequisites:
328 --
329 --
330 -- In Parameters:
331 --p_vehicle_details_id in number
332 --p_object_version_number in number
333
334 -- Post Success:
335 --
336 --
337 -- Name Type Description
338 --
339 -- Post Failure:
340 --
341 --
342 -- Access Status:
343 -- Public.
344 procedure delete_vehicle_details
345 ( p_vehicle_details_id in number
346 ,p_object_version_number in number
347 );
348
349 end PQP_VEHICLE_DETAILS_API;