1 Package pqp_vre_rki as
2 /* $Header: pqvrerhi.pkh 120.0.12010000.1 2008/07/28 11:26:09 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |-----------------------------< after_insert >-----------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_insert
9 (p_effective_date IN DATE
10 ,p_validation_start_date IN DATE
11 ,p_validation_end_date IN DATE
12 ,p_vehicle_repository_id IN NUMBER
13 ,p_effective_start_date IN DATE
14 ,p_effective_end_date IN DATE
15 ,p_registration_number IN VARCHAR2
16 ,p_vehicle_type IN VARCHAR2
17 ,p_vehicle_id_number IN VARCHAR2
18 ,p_business_group_id IN NUMBER
19 ,p_make IN VARCHAR2
20 ,p_model IN VARCHAR2
21 ,p_initial_registration IN DATE
22 ,p_last_registration_renew_date IN DATE
23 ,p_engine_capacity_in_cc IN NUMBER
24 ,p_fuel_type IN VARCHAR2
25 ,p_currency_code IN VARCHAR2
26 ,p_list_price IN NUMBER
27 ,p_accessory_value_at_startdate IN NUMBER
28 ,p_accessory_value_added_later IN NUMBER
29 ,p_market_value_classic_car IN NUMBER
30 ,p_fiscal_ratings IN NUMBER
31 ,p_fiscal_ratings_uom IN VARCHAR2
32 ,p_vehicle_provider IN VARCHAR2
33 ,p_vehicle_ownership IN VARCHAR2
34 ,p_shared_vehicle IN VARCHAR2
35 ,p_vehicle_status IN VARCHAR2
36 ,p_vehicle_inactivity_reason IN VARCHAR2
37 ,p_asset_number IN VARCHAR2
38 ,p_lease_contract_number IN VARCHAR2
39 ,p_lease_contract_expiry_date IN DATE
40 ,p_taxation_method IN VARCHAR2
41 ,p_fleet_info IN VARCHAR2
42 ,p_fleet_transfer_date IN DATE
43 ,p_object_version_number IN NUMBER
44 ,p_color IN VARCHAR2
45 ,p_seating_capacity IN NUMBER
46 ,p_weight IN NUMBER
47 ,p_weight_uom IN VARCHAR2
48 ,p_model_year IN NUMBER
49 ,p_insurance_number IN VARCHAR2
50 ,p_insurance_expiry_date IN DATE
51 ,p_comments IN VARCHAR2
52 ,p_vre_attribute_category IN VARCHAR2
53 ,p_vre_attribute1 IN VARCHAR2
54 ,p_vre_attribute2 IN VARCHAR2
55 ,p_vre_attribute3 IN VARCHAR2
56 ,p_vre_attribute4 IN VARCHAR2
57 ,p_vre_attribute5 IN VARCHAR2
58 ,p_vre_attribute6 IN VARCHAR2
59 ,p_vre_attribute7 IN VARCHAR2
60 ,p_vre_attribute8 IN VARCHAR2
61 ,p_vre_attribute9 IN VARCHAR2
62 ,p_vre_attribute10 IN VARCHAR2
63 ,p_vre_attribute11 IN VARCHAR2
64 ,p_vre_attribute12 IN VARCHAR2
65 ,p_vre_attribute13 IN VARCHAR2
66 ,p_vre_attribute14 IN VARCHAR2
67 ,p_vre_attribute15 IN VARCHAR2
68 ,p_vre_attribute16 IN VARCHAR2
69 ,p_vre_attribute17 IN VARCHAR2
70 ,p_vre_attribute18 IN VARCHAR2
71 ,p_vre_attribute19 IN VARCHAR2
72 ,p_vre_attribute20 IN VARCHAR2
73 ,p_vre_information_category IN VARCHAR2
74 ,p_vre_information1 IN VARCHAR2
75 ,p_vre_information2 IN VARCHAR2
76 ,p_vre_information3 IN VARCHAR2
77 ,p_vre_information4 IN VARCHAR2
78 ,p_vre_information5 IN VARCHAR2
79 ,p_vre_information6 IN VARCHAR2
80 ,p_vre_information7 IN VARCHAR2
81 ,p_vre_information8 IN VARCHAR2
82 ,p_vre_information9 IN VARCHAR2
83 ,p_vre_information10 IN VARCHAR2
84 ,p_vre_information11 IN VARCHAR2
85 ,p_vre_information12 IN VARCHAR2
86 ,p_vre_information13 IN VARCHAR2
87 ,p_vre_information14 IN VARCHAR2
88 ,p_vre_information15 IN VARCHAR2
89 ,p_vre_information16 IN VARCHAR2
90 ,p_vre_information17 IN VARCHAR2
91 ,p_vre_information18 IN VARCHAR2
92 ,p_vre_information19 IN VARCHAR2
93 ,p_vre_information20 IN VARCHAR2
94 );
95 end pqp_vre_rki;