1 Package pqp_vehicle_repository_swi As
2 /* $Header: pqvreswi.pkh 120.0 2005/05/29 02:18:56 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_vehicle >----------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: pqp_vehicle_repository_api.create_vehicle
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_vehicle
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_registration_number in varchar2 default null
30 ,p_vehicle_type in varchar2
31 ,p_vehicle_id_number in varchar2 default null
32 ,p_business_group_id in number
33 ,p_make in varchar2
34 ,p_engine_capacity_in_cc in number default null
35 ,p_fuel_type in varchar2 default null
36 ,p_currency_code in varchar2 default null
37 ,p_vehicle_status in varchar2 default 'A'
38 ,p_vehicle_inactivity_reason in varchar2 default null
39 ,p_model in varchar2
40 ,p_initial_registration in date default null
41 ,p_last_registration_renew_date in date default null
42 ,p_list_price in number default null
43 ,p_accessory_value_at_startdate in number default null
44 ,p_accessory_value_added_later in number default null
45 ,p_market_value_classic_car in number default null
46 ,p_fiscal_ratings in number default null
47 ,p_fiscal_ratings_uom in varchar2 default null
48 ,p_vehicle_provider in varchar2 default null
49 ,p_vehicle_ownership in varchar2 default null
50 ,p_shared_vehicle in varchar2 default null
51 ,p_asset_number in varchar2 default null
52 ,p_lease_contract_number in varchar2 default null
53 ,p_lease_contract_expiry_date in date default null
54 ,p_taxation_method in varchar2 default null
55 ,p_fleet_info in varchar2 default null
56 ,p_fleet_transfer_date in date default null
57 ,p_color in varchar2 default null
58 ,p_seating_capacity in number default null
59 ,p_weight in number default null
60 ,p_weight_uom in varchar2 default null
61 ,p_model_year in number default null
62 ,p_insurance_number in varchar2 default null
63 ,p_insurance_expiry_date in date default null
64 ,p_comments in varchar2 default null
65 ,p_vre_attribute_category in varchar2 default null
66 ,p_vre_attribute1 in varchar2 default null
67 ,p_vre_attribute2 in varchar2 default null
68 ,p_vre_attribute3 in varchar2 default null
69 ,p_vre_attribute4 in varchar2 default null
70 ,p_vre_attribute5 in varchar2 default null
71 ,p_vre_attribute6 in varchar2 default null
72 ,p_vre_attribute7 in varchar2 default null
73 ,p_vre_attribute8 in varchar2 default null
74 ,p_vre_attribute9 in varchar2 default null
75 ,p_vre_attribute10 in varchar2 default null
76 ,p_vre_attribute11 in varchar2 default null
77 ,p_vre_attribute12 in varchar2 default null
78 ,p_vre_attribute13 in varchar2 default null
79 ,p_vre_attribute14 in varchar2 default null
80 ,p_vre_attribute15 in varchar2 default null
81 ,p_vre_attribute16 in varchar2 default null
82 ,p_vre_attribute17 in varchar2 default null
83 ,p_vre_attribute18 in varchar2 default null
84 ,p_vre_attribute19 in varchar2 default null
85 ,p_vre_attribute20 in varchar2 default null
86 ,p_vre_information_category in varchar2 default null
87 ,p_vre_information1 in varchar2 default null
88 ,p_vre_information2 in varchar2 default null
89 ,p_vre_information3 in varchar2 default null
90 ,p_vre_information4 in varchar2 default null
91 ,p_vre_information5 in varchar2 default null
92 ,p_vre_information6 in varchar2 default null
93 ,p_vre_information7 in varchar2 default null
94 ,p_vre_information8 in varchar2 default null
95 ,p_vre_information9 in varchar2 default null
96 ,p_vre_information10 in varchar2 default null
97 ,p_vre_information11 in varchar2 default null
98 ,p_vre_information12 in varchar2 default null
99 ,p_vre_information13 in varchar2 default null
100 ,p_vre_information14 in varchar2 default null
101 ,p_vre_information15 in varchar2 default null
102 ,p_vre_information16 in varchar2 default null
103 ,p_vre_information17 in varchar2 default null
104 ,p_vre_information18 in varchar2 default null
105 ,p_vre_information19 in varchar2 default null
106 ,p_vre_information20 in varchar2 default null
107 ,p_vehicle_repository_id in number
108 ,p_object_version_number out nocopy number
109 ,p_effective_start_date out nocopy date
110 ,p_effective_end_date out nocopy date
111 ,p_return_status out nocopy varchar2
112 );
113 -- ----------------------------------------------------------------------------
114 -- |----------------------------< delete_vehicle >----------------------------|
115 -- ----------------------------------------------------------------------------
116 -- {Start of comments}
117 --
118 -- Description:
119 -- This procedure is the self-service wrapper procedure to the following
120 -- API: pqp_vehicle_repository_api.delete_vehicle
121 --
122 -- Pre-requisites
123 -- All 'IN' parameters to this procedure have been appropriately derived.
124 --
125 -- Post Success:
126 -- p_return_status will return value indicating success.
127 --
128 -- Post Failure:
129 -- p_return_status will return value indication failure.
130 --
131 -- Access Status:
132 -- Internal Development use only.
133 --
134 -- {End of comments}
135 -- ----------------------------------------------------------------------------
136 PROCEDURE delete_vehicle
137 (p_validate in number default hr_api.g_false_num
138 ,p_effective_date in date
139 ,p_datetrack_mode in varchar2
140 ,p_vehicle_repository_id in number
141 ,p_object_version_number in out nocopy number
142 ,p_effective_start_date out nocopy date
143 ,p_effective_end_date out nocopy date
144 ,p_return_status out nocopy varchar2
145 );
146 -- ----------------------------------------------------------------------------
147 -- |----------------------------< update_vehicle >----------------------------|
148 -- ----------------------------------------------------------------------------
149 -- {Start of comments}
150 --
151 -- Description:
152 -- This procedure is the self-service wrapper procedure to the following
153 -- API: pqp_vehicle_repository_api.update_vehicle
154 --
155 -- Pre-requisites
156 -- All 'IN' parameters to this procedure have been appropriately derived.
157 --
158 -- Post Success:
159 -- p_return_status will return value indicating success.
160 --
161 -- Post Failure:
162 -- p_return_status will return value indication failure.
163 --
164 -- Access Status:
165 -- Internal Development use only.
166 --
167 -- {End of comments}
168 -- ----------------------------------------------------------------------------
169 PROCEDURE update_vehicle
170 (p_validate in number default hr_api.g_false_num
171 ,p_effective_date in date
172 ,p_datetrack_mode in varchar2
173 ,p_vehicle_repository_id in number
174 ,p_object_version_number in out nocopy number
175 ,p_registration_number in varchar2 default hr_api.g_varchar2
176 ,p_vehicle_type in varchar2 default hr_api.g_varchar2
177 ,p_vehicle_id_number in varchar2 default hr_api.g_varchar2
178 ,p_business_group_id in number default hr_api.g_number
179 ,p_make in varchar2 default hr_api.g_varchar2
180 ,p_engine_capacity_in_cc in number default hr_api.g_number
181 ,p_fuel_type in varchar2 default hr_api.g_varchar2
182 ,p_currency_code in varchar2 default hr_api.g_varchar2
183 ,p_vehicle_status in varchar2 default hr_api.g_varchar2
184 ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
185 ,p_model in varchar2 default hr_api.g_varchar2
186 ,p_initial_registration in date default hr_api.g_date
187 ,p_last_registration_renew_date in date default hr_api.g_date
188 ,p_list_price in number default hr_api.g_number
189 ,p_accessory_value_at_startdate in number default hr_api.g_number
190 ,p_accessory_value_added_later in number default hr_api.g_number
191 ,p_market_value_classic_car in number default hr_api.g_number
192 ,p_fiscal_ratings in number default hr_api.g_number
193 ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
194 ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
195 ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
196 ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
197 ,p_asset_number in varchar2 default hr_api.g_number
198 ,p_lease_contract_number in varchar2 default hr_api.g_number
199 ,p_lease_contract_expiry_date in date default hr_api.g_date
200 ,p_taxation_method in varchar2 default hr_api.g_varchar2
201 ,p_fleet_info in varchar2 default hr_api.g_varchar2
202 ,p_fleet_transfer_date in date default hr_api.g_date
203 ,p_color in varchar2 default hr_api.g_varchar2
204 ,p_seating_capacity in number default hr_api.g_number
205 ,p_weight in number default hr_api.g_number
206 ,p_weight_uom in varchar2 default hr_api.g_varchar2
207 ,p_model_year in number default hr_api.g_number
208 ,p_insurance_number in varchar2 default hr_api.g_varchar2
209 ,p_insurance_expiry_date in date default hr_api.g_date
210 ,p_comments in varchar2 default hr_api.g_varchar2
211 ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
212 ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
213 ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
214 ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
215 ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
216 ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
217 ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
218 ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
219 ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
220 ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
221 ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
222 ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
223 ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
224 ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
225 ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
226 ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
227 ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
228 ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
229 ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
230 ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
231 ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
232 ,p_vre_information_category in varchar2 default hr_api.g_varchar2
233 ,p_vre_information1 in varchar2 default hr_api.g_varchar2
234 ,p_vre_information2 in varchar2 default hr_api.g_varchar2
235 ,p_vre_information3 in varchar2 default hr_api.g_varchar2
239 ,p_vre_information7 in varchar2 default hr_api.g_varchar2
236 ,p_vre_information4 in varchar2 default hr_api.g_varchar2
237 ,p_vre_information5 in varchar2 default hr_api.g_varchar2
238 ,p_vre_information6 in varchar2 default hr_api.g_varchar2
240 ,p_vre_information8 in varchar2 default hr_api.g_varchar2
241 ,p_vre_information9 in varchar2 default hr_api.g_varchar2
242 ,p_vre_information10 in varchar2 default hr_api.g_varchar2
243 ,p_vre_information11 in varchar2 default hr_api.g_varchar2
244 ,p_vre_information12 in varchar2 default hr_api.g_varchar2
245 ,p_vre_information13 in varchar2 default hr_api.g_varchar2
246 ,p_vre_information14 in varchar2 default hr_api.g_varchar2
247 ,p_vre_information15 in varchar2 default hr_api.g_varchar2
248 ,p_vre_information16 in varchar2 default hr_api.g_varchar2
249 ,p_vre_information17 in varchar2 default hr_api.g_varchar2
250 ,p_vre_information18 in varchar2 default hr_api.g_varchar2
254 ,p_effective_end_date out nocopy date
251 ,p_vre_information19 in varchar2 default hr_api.g_varchar2
252 ,p_vre_information20 in varchar2 default hr_api.g_varchar2
253 ,p_effective_start_date out nocopy date
255 ,p_return_status out nocopy varchar2
256 );
257 end pqp_vehicle_repository_swi;