1 Package pqp_pl_vehicle_repository_api as
2 /* $Header: pqvrepli.pkh 120.3 2006/04/24 23:32:27 nprasath noship $ */
3 /*#
4 * This package contains vehicle repository APIs for Poland
5 * @rep:scope public
6 * @rep:product per
7 * @rep:displayname Vehicle Repository for Poland
8 */
9
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_pl_vehicle >-----------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 --
16 /*#
17 * This API creates a vehicle in the repository for Polish legislation.
18 * This is an alternative to generic CREATE_VEHICLE API.
19 * <p><b>Licensing</b><br>
20 * This API is licensed for use with Human Resources.
21 *
22 * <p><b>Prerequisites</b><br>
23 * Business group should be present before creating a vehicle repository
24 *
25 * <p><b> Post Success</b><br>
26 * The vehicle repository record will be successfully inserted into the
27 * database.
28 *
29 * <p><b> Post Failure</b><br>
30 * The vehicle repository record will not be created and an error will be
31 * raised.
32 * @param p_validate If true, the database remains unchanged. If false,the
33 * vehicle repository record is created
34 * @param p_effective_date The effective start date of the vehicle repository
35 * record
36 * @param p_vehicle_registration_number Registration Number for this vehicle
37 * @param p_vehicle_type Identifies whether the vehicle is a car,
38 * motorcycle etc.Valid values are defined by 'PQP_VEHICLE_TYPE' lookup type
39 * @param p_vehicle_body_number The unique Vehicle identification number,
40 * commonly referred to as VIN or Chassis number
41 * @param p_business_group_id The Business Group Identifier to which the
42 * vehicle belongs to
43 * @param p_make The Make (manufacturer) of the vehicle
44 * @param p_engine_capacity_in_cc The Vehicle's engine size in cubic capacity
45 * @param p_fuel_type The type of fuel used in the vehicle. Valid values are
46 * defined by 'PQP_FUEL_TYPE' lookup type
47 * @param p_currency_code The currency code for all the monetary columns used
48 * in this record.The value should be the same as the Business groups currency
49 * code and is from the table FND_CURRENCIES.
50 * @param p_vehicle_status The status of the vehicle, whether it is active or
51 * inactive.Valid values are defined by 'PQP_VEHICLE_STATUS' lookup type
52 * @param p_vehicle_inactivity_reason The reason for vehicle inactivity.
53 * Only used if the status is Inactive (I). Valid values are defined by
54 * 'PQP_VEHICLE_INACTIVE_REASONS' lookup type
55 * @param p_model The model name of the Vehicle
56 * @param p_initial_registration The date the vehicle was registered for the
57 * first time.
58 * @param p_last_registration_renew_date The most recent date on which the
59 * vehicle registration was renewed.
60 * @param p_list_price The basic list price of the Vehicle.
61 * @param p_accessory_value_at_startdate The value of the accessories in the
62 * vehicle at Start Date.
63 * @param p_accessory_value_added_later The value of the accessories added
64 * later to the vehicle.
65 * @param p_market_value_classic_car The market value of the vehicle if it is
66 * a Classic vehicle
67 * @param p_fiscal_ratings The Fiscal Ratings of the vehicle.
68 * @param p_fiscal_ratings_uom The Fiscal Ratings Unit of Measure for the
69 * vehicle
70 * @param p_vehicle_provider The name of the vehicle provider
71 * @param p_vehicle_ownership Identifies whether it is a company or
72 * private vehicle.
73 * @param p_shared_vehicle Flag to indicate whether the vehicle can be
74 * 'allocated to' or 'shared between' multiple employees
75 * @param p_asset_number The asset number, if any for the vehicle
76 * @param p_lease_contract_number Lease contract number for the leased
77 * company vehicle
78 * @param p_lease_contract_expiry_date The date when the lease expires for
79 * the company vehicle.
80 * @param p_taxation_method Taxation Method used for this vehicle. Valid values
81 * are defined by 'PQP_VEHICLE_TAXATION_METHOD' lookup type
82 * @param p_fleet_info Additional information for fleet vehicles.
83 * @param p_fleet_transfer_date The date the vehicle was transferred, for the
84 * fleet vehicle
85 * @param p_color The color of the vehicle.Valid values are defined by
86 * 'PQP_VEHICLE_COLOR' lookup type
87 * @param p_seating_capacity The passenger seating capacity of the vehicle
88 * @param p_weight The weight of the vehicle, the unit of measure is stored in
89 * weight_uom column
90 * @param p_weight_uom The unit of measure for the weight column
91 * Valid values are defined by 'PQP_WEIGHT_UOM' lookup type
92 * @param p_year_of_manufacture Year of manufacture of the vehicle
93 * @param p_insurance_number The insurance details for the vehicle
94 * @param p_insurance_expiry_date Insurance expiration date for the vehicle
95 * @param p_comments Free text to store any comments
96 * @param p_vre_attribute_category Descriptive flexfield column
97 * @param p_vre_attribute1 Descriptive Flexfield Column
98 * @param p_vre_attribute2 Descriptive flexfield column
99 * @param p_vre_attribute3 Descriptive flexfield column
100 * @param p_vre_attribute4 Descriptive flexfield column
101 * @param p_vre_attribute5 Descriptive flexfield column
102 * @param p_vre_attribute6 Descriptive flexfield column
103 * @param p_vre_attribute7 Descriptive flexfield column
104 * @param p_vre_attribute8 Descriptive flexfield column
105 * @param p_vre_attribute9 Descriptive flexfield column
106 * @param p_vre_attribute10 Descriptive flexfield column
107 * @param p_vre_attribute11 Descriptive flexfield column
108 * @param p_vre_attribute12 Descriptive flexfield column
109 * @param p_vre_attribute13 Descriptive flexfield column
110 * @param p_vre_attribute14 Descriptive flexfield column
111 * @param p_vre_attribute15 Descriptive flexfield column
112 * @param p_vre_attribute16 Descriptive flexfield column
113 * @param p_vre_attribute17 Descriptive flexfield column
114 * @param p_vre_attribute18 Descriptive flexfield column
115 * @param p_vre_attribute19 Descriptive flexfield column
116 * @param p_vre_attribute20 Descriptive flexfield column
117 * @param p_vre_information_category Descriptive flexfield column
118 * @param p_vehicle_card_id_number Vehicle Card Identification number
119 * @param p_owner Owner
120 * @param p_engine_number Engine number
121 * @param p_date_of_first_inspection Date of first technical inspection
122 * @param p_date_of_next_inspection Date of next technical inspection
123 * @param p_other_technical_information Other Technical information
124 * @param p_vehicle_repository_id System generated primary key column
125 * using the sequence PQP_VEHICLE_REPOSITORY_F_S.If p_validate is false,
126 * then this uniquely identifies the vehicle repository record created.
127 * If p_validate is true, then set to null
128 * @param p_object_version_number If p_validate is false, then set to the
129 * version number of the new vehicle repository record.If p_validate is true,
130 * then set to null
131 * @param p_effective_start_date If p_validate is false, then set to the start
132 * date for this record.If p_validate is true, then set to null
133 * @param p_effective_end_date If p_validate is false, then set to the end date
134 * for this record.If p_validate is true, then set to null
135 * @rep:displayname Create Vehicle Repository for Poland
136 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
137 * @rep:lifecycle active
138 * @rep:scope public
139 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
140 */
141 -- End of commnets
142 --
143 procedure create_pl_vehicle
144 ( p_validate in boolean default false
145 ,p_effective_date in date
146 ,p_vehicle_registration_number in varchar2
147 ,p_vehicle_type in varchar2
148 ,p_vehicle_body_number in varchar2 default null
149 ,p_business_group_id in number
150 ,p_make in varchar2
151 ,p_engine_capacity_in_cc in number
152 ,p_fuel_type in varchar2
153 ,p_currency_code in varchar2
154 ,p_vehicle_status in varchar2
155 ,p_vehicle_inactivity_reason in varchar2
156 ,p_model in varchar2 default null
157 ,p_initial_registration in date default null
158 ,p_last_registration_renew_date in date default null
159 ,p_list_price in number default null
160 ,p_accessory_value_at_startdate in number default null
161 ,p_accessory_value_added_later in number default null
162 ,p_market_value_classic_car in number default null
163 ,p_fiscal_ratings in number default null
164 ,p_fiscal_ratings_uom in varchar2 default null
165 ,p_vehicle_provider in varchar2 default null
166 ,p_vehicle_ownership in varchar2 default null
167 ,p_shared_vehicle in varchar2 default null
168 ,p_asset_number in varchar2 default null
169 ,p_lease_contract_number in varchar2 default null
170 ,p_lease_contract_expiry_date in date default null
171 ,p_taxation_method in varchar2 default null
172 ,p_fleet_info in varchar2 default null
173 ,p_fleet_transfer_date in date default null
174 ,p_color in varchar2 default null
175 ,p_seating_capacity in number default null
176 ,p_weight in number default null
177 ,p_weight_uom in varchar2 default null
178 ,p_year_of_manufacture in number default null
179 ,p_insurance_number in varchar2 default null
180 ,p_insurance_expiry_date in date default null
181 ,p_comments in varchar2 default null
182 ,p_vre_attribute_category in varchar2 default null
183 ,p_vre_attribute1 in varchar2 default null
184 ,p_vre_attribute2 in varchar2 default null
185 ,p_vre_attribute3 in varchar2 default null
186 ,p_vre_attribute4 in varchar2 default null
187 ,p_vre_attribute5 in varchar2 default null
188 ,p_vre_attribute6 in varchar2 default null
189 ,p_vre_attribute7 in varchar2 default null
190 ,p_vre_attribute8 in varchar2 default null
191 ,p_vre_attribute9 in varchar2 default null
192 ,p_vre_attribute10 in varchar2 default null
193 ,p_vre_attribute11 in varchar2 default null
194 ,p_vre_attribute12 in varchar2 default null
195 ,p_vre_attribute13 in varchar2 default null
196 ,p_vre_attribute14 in varchar2 default null
197 ,p_vre_attribute15 in varchar2 default null
198 ,p_vre_attribute16 in varchar2 default null
199 ,p_vre_attribute17 in varchar2 default null
200 ,p_vre_attribute18 in varchar2 default null
201 ,p_vre_attribute19 in varchar2 default null
202 ,p_vre_attribute20 in varchar2 default null
203 ,p_vre_information_category in varchar2 default null
204 ,p_vehicle_card_id_number in varchar2 default null
205 ,p_owner in varchar2 default null
206 ,p_engine_number in varchar2 default null
207 ,p_date_of_first_inspection in varchar2 default null
208 ,p_date_of_next_inspection in varchar2 default null
209 ,p_other_technical_information in varchar2 default null
210 ,p_vehicle_repository_id out NOCOPY number
211 ,p_object_version_number out NOCOPY number
212 ,p_effective_start_date out NOCOPY date
216
213 ,p_effective_end_date out NOCOPY date
214 );
215 --
217 -- ----------------------------------------------------------------------------
218 -- |--------------------------< update_pl_vehicle >--------------------------|
219 -- ----------------------------------------------------------------------------
220 --
221 -- {Start Of Comments}
222 --
223 /*#
224 * This API updates a vehicle in the repository for Polish legislation.
225 * All attributes may not be changed if the vehicle is already
226 * allocated to an assignment.
227 *
228 * This is an alternative to generic 'UPDATE_VEHICLE' API.
229 *
230 * <p><b>Licensing</b><br>
231 * This API is licensed for use with Human Resources.
232 *
233 * <p><b>Prerequisites</b><br>
234 * Vehicle repository record should be present before updating a vehicle
235 * repository.
236 *
237 * <p><b>Post Success</b><br>
238 * The vehicle repository record will be successfully updated into the
239 * database.
240 *
241 * <p><b>Post Failure</b><br>
242 * The vehicle repository record will not be updated and an error will be
243 * raised.
244 *
245 * @param p_validate If true, then validation alone will be performed and the
246 * database will remain unchanged. If false and all validation checks pass,
247 * then the vehicle repository record will be updated
248 * @param p_effective_date Determines when the DateTrack operation comes into
249 * force.
250 * @param p_datetrack_mode Indicates which DateTrack mode to use when updating
251 * the record. You must set to either UPDATE, CORRECTION, UPDATE_OVERRIDE or
252 * UPDATE_CHANGE_INSERT. Modes available for use with a particular record
253 * depend on the dates of previous record changes and the effective date of
254 * this change.
255 * @param p_vehicle_repository_id Identifier to the vehicle repository record
256 * that needs to be updated
257 * @param p_object_version_number Pass in the current version number of the
258 * vehicle repository to be updated. When the API completes if p_validate is
259 * false, will be set to the new version number of the updated Vehicle
260 * Repository. If p_validate is true will be set to the same value which was
261 * passed in.
262 * @param p_vehicle_registration_number Registration Number for this vehicle
263 * @param p_vehicle_type Identifies whether the vehicle is a car, motorcycle etc.
264 * Valid values are defined by 'PQP_VEHICLE_TYPE' lookup type
265 * @param p_vehicle_body_number The unique Vehicle identification number,
266 * commonly referred
267 * to as VIN or Chassis number.
268 * @param p_business_group_id The Business Group Identifier to which the
269 * vehicle belongs to.
270 * @param p_make The Make (manufacturer) of the vehicle.
271 * @param p_engine_capacity_in_cc The Vehicle's engine size in cubic capacity
272 * @param p_fuel_type The type of fuel used in the vehicle. Valid values are
273 * defined by 'PQP_FUEL_TYPE' lookup type
274 * @param p_currency_code The currency code for all the monetary columns used
275 * in this record.
276 * The value should be the same as the Business groups currency code and
277 * is from the table FND_CURRENCIES.
278 * @param p_vehicle_status The status of the vehicle, whether it is active or
279 * inactive. Valid values are defined by 'PQP_VEHICLE_STATUS' lookup type
280 * @param p_vehicle_inactivity_reason The reason for vehicle inactivity. Only
281 * used if the status is Inactive (I). Valid values are defined by
282 * 'PQP_VEHICLE_INACTIVE_REASONS.' lookup type
283 * @param p_model The model name of the Vehicle.
284 * @param p_initial_registration The date the vehicle was registered for the
285 * first time.
286 * @param p_last_registration_renew_date The most recent date on which the
287 * vehicle registration was renewed
288 * @param p_list_price The basic list price of the Vehicle.
289 * @param p_accessory_value_at_startdate The value of the accessories in the
290 * vehicle at Start Date.
291 * @param p_accessory_value_added_later The value of the accessories added
292 * later to the vehicle.
293 * @param p_market_value_classic_car The market value of the vehicle if it is a
294 * classic vehicle.
295 * @param p_fiscal_ratings The Fiscal ratings of the vehicle
296 * @param p_fiscal_ratings_uom The Fiscal ratings unit of measure for the
297 * vehicle
298 * @param p_vehicle_provider The name of the vehicle provider.
299 * @param p_vehicle_ownership Identifies whether it is a company or private
300 * vehicle.
301 * @param p_shared_vehicle Flag to indicate whether the vehicle can be
302 *'allocated to' or 'shared between' multiple employees
303 * @param p_asset_number The asset number, if any for the vehicle.
304 * @param p_lease_contract_number Lease contract number for the leased company
305 * vehicle
306 * @param p_lease_contract_expiry_date The date when the lease expires for the
307 * company vehicle
308 * @param p_taxation_method Taxation method used for this vehicle.
309 * Valid values are defined by 'PQP_VEHICLE_TAXATION_METHOD' lookup type
310 * @param p_fleet_info Additional information for fleet vehicles.
311 * @param p_fleet_transfer_date The date the vehicle was transferred, for
312 * the fleet vehicle.
313 * @param p_color The color of the vehicle. Valid values are defined by
314 * 'PQP_VEHICLE_COLOR' lookup type
315 * @param p_seating_capacity The passenger seating capacity of the vehicle
316 * @param p_weight The weight of the vehicle, the unit of measure is stored in
317 * weight_uom column.
318 * @param p_weight_uom The unit of measure for the weight column.
319 * Valid values are defined by 'PQP_WEIGHT_UOM' lookup type
320 * @param p_year_of_manufacture Year of manufacture of the vehicle
321 * @param p_insurance_number The insurance details for the vehicle
322 * @param p_insurance_expiry_date Insurance expiration date for the vehicle
323 * @param p_comments Free text to store any comments.
327 * @param p_vre_attribute3 Descriptive flexfield column
324 * @param p_vre_attribute_category Descriptive flexfield column
325 * @param p_vre_attribute1 Descriptive flexfield column
326 * @param p_vre_attribute2 Descriptive flexfield column
328 * @param p_vre_attribute4 Descriptive flexfield column
329 * @param p_vre_attribute5 Descriptive flexfield column
330 * @param p_vre_attribute6 Descriptive flexfield column
331 * @param p_vre_attribute7 Descriptive flexfield column
332 * @param p_vre_attribute8 Descriptive flexfield column
333 * @param p_vre_attribute9 Descriptive flexfield column
334 * @param p_vre_attribute10 Descriptive flexfield column
335 * @param p_vre_attribute11 Descriptive flexfield column
336 * @param p_vre_attribute12 Descriptive flexfield column
337 * @param p_vre_attribute13 Descriptive flexfield column
338 * @param p_vre_attribute14 Descriptive flexfield column
339 * @param p_vre_attribute15 Descriptive flexfield column
340 * @param p_vre_attribute16 Descriptive flexfield column
341 * @param p_vre_attribute17 Descriptive flexfield column
342 * @param p_vre_attribute18 Descriptive flexfield column
343 * @param p_vre_attribute19 Descriptive flexfield column
344 * @param p_vre_attribute20 Descriptive flexfield column
345 * @param p_vre_information_category Descriptive flexfield column
346 * @param p_vehicle_card_id_number Vehicle card identification number
347 * @param p_owner Owner
348 * @param p_engine_number Engine number
349 * @param p_date_of_first_inspection Date of first technical inspection
350 * @param p_date_of_next_inspection Date of next technical inspection
351 * @param p_other_technical_information Other technical information
352 * @param p_effective_start_date If p_validate is false, then set to the
353 * effective start date on the updated vehicle repository row which now exists
354 * as of the effective date. If p_validate is true, then set to null.
355 * @param p_effective_end_date If p_validate is false, then set to the
356 * effective end date on the updated vehicle repository row which now exists as
357 * of the effective date. If p_validate is true, then set to null.
358 * @rep:displayname Update Vehicle Repository for Poland
359 * @rep:category BUSINESS_ENTITY PQP_VEHICLE_REPOSITORY
360 * @rep:lifecycle active
361 * @rep:scope public
362 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
363 */
364 --
365 -- {End Of Comments}
366 Procedure update_pl_vehicle
367 (p_validate in boolean default false
368 ,p_effective_date in date
369 ,p_datetrack_mode in varchar2
370 ,p_vehicle_repository_id in number
371 ,p_object_version_number in out NOCOPY number
372 ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373 ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374 ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375 ,p_business_group_id in number default hr_api.g_number
376 ,p_make in varchar2 default hr_api.g_varchar2
377 ,p_engine_capacity_in_cc in number default hr_api.g_number
378 ,p_fuel_type in varchar2 default hr_api.g_varchar2
379 ,p_currency_code in varchar2 default hr_api.g_varchar2
380 ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381 ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382 ,p_model in varchar2 default hr_api.g_varchar2
383 ,p_initial_registration in date default hr_api.g_date
384 ,p_last_registration_renew_date in date default hr_api.g_date
385 ,p_list_price in number default hr_api.g_number
386 ,p_accessory_value_at_startdate in number default hr_api.g_number
387 ,p_accessory_value_added_later in number default hr_api.g_number
388 ,p_market_value_classic_car in number default hr_api.g_number
389 ,p_fiscal_ratings in number default hr_api.g_number
390 ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391 ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392 ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393 ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394 ,p_asset_number in varchar2 default hr_api.g_varchar2
395 ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396 ,p_lease_contract_expiry_date in date default hr_api.g_date
397 ,p_taxation_method in varchar2 default hr_api.g_varchar2
398 ,p_fleet_info in varchar2 default hr_api.g_varchar2
399 ,p_fleet_transfer_date in date default hr_api.g_date
400 ,p_color in varchar2 default hr_api.g_varchar2
401 ,p_seating_capacity in number default hr_api.g_number
402 ,p_weight in number default hr_api.g_number
403 ,p_weight_uom in varchar2 default hr_api.g_varchar2
404 ,p_year_of_manufacture in number default hr_api.g_number
405 ,p_insurance_number in varchar2 default hr_api.g_varchar2
406 ,p_insurance_expiry_date in date default hr_api.g_date
407 ,p_comments in varchar2 default hr_api.g_varchar2
408 ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409 ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410 ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411 ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412 ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413 ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414 ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
418 ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
415 ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416 ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417 ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
419 ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420 ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421 ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422 ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423 ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424 ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425 ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426 ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427 ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428 ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429 ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430 ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431 ,p_owner in varchar2 default hr_api.g_varchar2
432 ,p_engine_number in varchar2 default hr_api.g_varchar2
433 ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434 ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435 ,p_other_technical_information in varchar2 default hr_api.g_varchar2
436 ,p_effective_start_date out NOCOPY date
437 ,p_effective_end_date out NOCOPY date
438 );
439
440 END pqp_pl_vehicle_repository_api;