1 Package pqp_vre_rku as
2 /* $Header: pqvrerhi.pkh 120.0.12010000.1 2008/07/28 11:26:09 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
9 (p_effective_date IN DATE
10 ,p_datetrack_mode IN VARCHAR2
11 ,p_validation_start_date IN DATE
12 ,p_validation_end_date IN DATE
13 ,p_vehicle_repository_id IN NUMBER
14 ,p_effective_start_date IN DATE
15 ,p_effective_end_date IN DATE
16 ,p_registration_number IN VARCHAR2
17 ,p_vehicle_type IN VARCHAR2
18 ,p_vehicle_id_number IN VARCHAR2
19 ,p_business_group_id IN NUMBER
20 ,p_make IN VARCHAR2
21 ,p_model IN VARCHAR2
22 ,p_initial_registration IN DATE
23 ,p_last_registration_renew_date IN DATE
24 ,p_engine_capacity_in_cc IN NUMBER
25 ,p_fuel_type IN VARCHAR2
26 ,p_currency_code IN VARCHAR2
27 ,p_list_price IN NUMBER
28 ,p_accessory_value_at_startdate IN NUMBER
29 ,p_accessory_value_added_later IN NUMBER
30 ,p_market_value_classic_car IN NUMBER
31 ,p_fiscal_ratings IN NUMBER
32 ,p_fiscal_ratings_uom IN VARCHAR2
33 ,p_vehicle_provider IN VARCHAR2
34 ,p_vehicle_ownership IN VARCHAR2
35 ,p_shared_vehicle IN VARCHAR2
36 ,p_vehicle_status IN VARCHAR2
37 ,p_vehicle_inactivity_reason IN VARCHAR2
38 ,p_asset_number IN VARCHAR2
39 ,p_lease_contract_number IN VARCHAR2
40 ,p_lease_contract_expiry_date IN DATE
41 ,p_taxation_method IN VARCHAR2
42 ,p_fleet_info IN VARCHAR2
43 ,p_fleet_transfer_date IN DATE
44 ,p_object_version_number IN NUMBER
45 ,p_color IN VARCHAR2
46 ,p_seating_capacity IN NUMBER
47 ,p_weight IN NUMBER
48 ,p_weight_uom IN VARCHAR2
49 ,p_model_year IN NUMBER
50 ,p_insurance_number IN VARCHAR2
51 ,p_insurance_expiry_date IN DATE
52 ,p_comments IN VARCHAR2
53 ,p_vre_attribute_category IN VARCHAR2
54 ,p_vre_attribute1 IN VARCHAR2
55 ,p_vre_attribute2 IN VARCHAR2
56 ,p_vre_attribute3 IN VARCHAR2
57 ,p_vre_attribute4 IN VARCHAR2
58 ,p_vre_attribute5 IN VARCHAR2
59 ,p_vre_attribute6 IN VARCHAR2
60 ,p_vre_attribute7 IN VARCHAR2
61 ,p_vre_attribute8 IN VARCHAR2
62 ,p_vre_attribute9 IN VARCHAR2
63 ,p_vre_attribute10 IN VARCHAR2
64 ,p_vre_attribute11 IN VARCHAR2
65 ,p_vre_attribute12 IN VARCHAR2
66 ,p_vre_attribute13 IN VARCHAR2
67 ,p_vre_attribute14 IN VARCHAR2
68 ,p_vre_attribute15 IN VARCHAR2
69 ,p_vre_attribute16 IN VARCHAR2
70 ,p_vre_attribute17 IN VARCHAR2
71 ,p_vre_attribute18 IN VARCHAR2
72 ,p_vre_attribute19 IN VARCHAR2
73 ,p_vre_attribute20 IN VARCHAR2
74 ,p_vre_information_category IN VARCHAR2
75 ,p_vre_information1 IN VARCHAR2
76 ,p_vre_information2 IN VARCHAR2
77 ,p_vre_information3 IN VARCHAR2
78 ,p_vre_information4 IN VARCHAR2
79 ,p_vre_information5 IN VARCHAR2
80 ,p_vre_information6 IN VARCHAR2
81 ,p_vre_information7 IN VARCHAR2
82 ,p_vre_information8 IN VARCHAR2
83 ,p_vre_information9 IN VARCHAR2
84 ,p_vre_information10 IN VARCHAR2
85 ,p_vre_information11 IN VARCHAR2
86 ,p_vre_information12 IN VARCHAR2
87 ,p_vre_information13 IN VARCHAR2
88 ,p_vre_information14 IN VARCHAR2
89 ,p_vre_information15 IN VARCHAR2
90 ,p_vre_information16 IN VARCHAR2
91 ,p_vre_information17 IN VARCHAR2
92 ,p_vre_information18 IN VARCHAR2
93 ,p_vre_information19 IN VARCHAR2
94 ,p_vre_information20 IN VARCHAR2
95 ,p_effective_start_date_o IN DATE
96 ,p_effective_end_date_o IN DATE
97 ,p_registration_number_o IN VARCHAR2
98 ,p_vehicle_type_o IN VARCHAR2
99 ,p_vehicle_id_number_o IN VARCHAR2
100 ,p_business_group_id_o IN NUMBER
101 ,p_make_o IN VARCHAR2
102 ,p_model_o IN VARCHAR2
103 ,p_initial_registration_o IN DATE
104 ,p_last_registration_renew_da_o IN DATE
105 ,p_engine_capacity_in_cc_o IN NUMBER
106 ,p_fuel_type_o IN VARCHAR2
107 ,p_currency_code_o IN VARCHAR2
108 ,p_list_price_o IN NUMBER
109 ,p_accessory_value_at_startda_o IN NUMBER
110 ,p_accessory_value_added_late_o IN NUMBER
111 ,p_market_value_classic_car_o IN NUMBER
112 ,p_fiscal_ratings_o IN NUMBER
113 ,p_fiscal_ratings_uom_o IN VARCHAR2
114 ,p_vehicle_provider_o IN VARCHAR2
115 ,p_vehicle_ownership_o IN VARCHAR2
116 ,p_shared_vehicle_o IN VARCHAR2
117 ,p_vehicle_status_o IN VARCHAR2
118 ,p_vehicle_inactivity_reason_o IN VARCHAR2
119 ,p_asset_number_o IN VARCHAR2
120 ,p_lease_contract_number_o IN VARCHAR2
121 ,p_lease_contract_expiry_date_o IN DATE
122 ,p_taxation_method_o IN VARCHAR2
123 ,p_fleet_info_o IN VARCHAR2
124 ,p_fleet_transfer_date_o IN DATE
125 ,p_object_version_number_o IN NUMBER
126 ,p_color_o IN VARCHAR2
127 ,p_seating_capacity_o IN NUMBER
128 ,p_weight_o IN NUMBER
129 ,p_weight_uom_o IN VARCHAR2
130 ,p_model_year_o IN NUMBER
131 ,p_insurance_number_o IN VARCHAR2
132 ,p_insurance_expiry_date_o IN DATE
133 ,p_comments_o IN VARCHAR2
134 ,p_vre_attribute_category_o IN VARCHAR2
135 ,p_vre_attribute1_o IN VARCHAR2
136 ,p_vre_attribute2_o IN VARCHAR2
137 ,p_vre_attribute3_o IN VARCHAR2
138 ,p_vre_attribute4_o IN VARCHAR2
139 ,p_vre_attribute5_o IN VARCHAR2
140 ,p_vre_attribute6_o IN VARCHAR2
141 ,p_vre_attribute7_o IN VARCHAR2
142 ,p_vre_attribute8_o IN VARCHAR2
143 ,p_vre_attribute9_o IN VARCHAR2
144 ,p_vre_attribute10_o IN VARCHAR2
145 ,p_vre_attribute11_o IN VARCHAR2
146 ,p_vre_attribute12_o IN VARCHAR2
147 ,p_vre_attribute13_o IN VARCHAR2
148 ,p_vre_attribute14_o IN VARCHAR2
149 ,p_vre_attribute15_o IN VARCHAR2
150 ,p_vre_attribute16_o IN VARCHAR2
151 ,p_vre_attribute17_o IN VARCHAR2
152 ,p_vre_attribute18_o IN VARCHAR2
153 ,p_vre_attribute19_o IN VARCHAR2
154 ,p_vre_attribute20_o IN VARCHAR2
155 ,p_vre_information_category_o IN VARCHAR2
156 ,p_vre_information1_o IN VARCHAR2
157 ,p_vre_information2_o IN VARCHAR2
158 ,p_vre_information3_o IN VARCHAR2
159 ,p_vre_information4_o IN VARCHAR2
160 ,p_vre_information5_o IN VARCHAR2
161 ,p_vre_information6_o IN VARCHAR2
162 ,p_vre_information7_o IN VARCHAR2
163 ,p_vre_information8_o IN VARCHAR2
164 ,p_vre_information9_o IN VARCHAR2
165 ,p_vre_information10_o IN VARCHAR2
166 ,p_vre_information11_o IN VARCHAR2
167 ,p_vre_information12_o IN VARCHAR2
168 ,p_vre_information13_o IN VARCHAR2
169 ,p_vre_information14_o IN VARCHAR2
170 ,p_vre_information15_o IN VARCHAR2
171 ,p_vre_information16_o IN VARCHAR2
172 ,p_vre_information17_o IN VARCHAR2
173 ,p_vre_information18_o IN VARCHAR2
174 ,p_vre_information19_o IN VARCHAR2
175 ,p_vre_information20_o IN VARCHAR2
176 );
177 --
178 end pqp_vre_rku;