1 Package pqp_vre_rkd as
2 /* $Header: pqvrerhi.pkh 120.0.12010000.1 2008/07/28 11:26:09 appldev ship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_delete >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_delete
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_effective_start_date_o IN DATE
17 ,p_effective_end_date_o IN DATE
18 ,p_registration_number_o IN VARCHAR2
19 ,p_vehicle_type_o IN VARCHAR2
20 ,p_vehicle_id_number_o IN VARCHAR2
21 ,p_business_group_id_o IN NUMBER
22 ,p_make_o IN VARCHAR2
23 ,p_model_o IN VARCHAR2
24 ,p_initial_registration_o IN DATE
25 ,p_last_registration_renew_da_o IN DATE
26 ,p_engine_capacity_in_cc_o IN NUMBER
27 ,p_fuel_type_o IN VARCHAR2
28 ,p_currency_code_o IN VARCHAR2
29 ,p_list_price_o IN NUMBER
30 ,p_accessory_value_at_startda_o IN NUMBER
31 ,p_accessory_value_added_late_o IN NUMBER
32 ,p_market_value_classic_car_o IN NUMBER
33 ,p_fiscal_ratings_o IN NUMBER
34 ,p_fiscal_ratings_uom_o IN VARCHAR2
35 ,p_vehicle_provider_o IN VARCHAR2
36 ,p_vehicle_ownership_o IN VARCHAR2
37 ,p_shared_vehicle_o IN VARCHAR2
38 ,p_vehicle_status_o IN VARCHAR2
39 ,p_vehicle_inactivity_reason_o IN VARCHAR2
40 ,p_asset_number_o IN VARCHAR2
41 ,p_lease_contract_number_o IN VARCHAR2
42 ,p_lease_contract_expiry_date_o IN DATE
43 ,p_taxation_method_o IN VARCHAR2
44 ,p_fleet_info_o IN VARCHAR2
45 ,p_fleet_transfer_date_o IN DATE
46 ,p_object_version_number_o IN NUMBER
47 ,p_color_o IN VARCHAR2
48 ,p_seating_capacity_o IN NUMBER
49 ,p_weight_o IN NUMBER
50 ,p_weight_uom_o IN VARCHAR2
51 ,p_model_year_o IN NUMBER
52 ,p_insurance_number_o IN VARCHAR2
53 ,p_insurance_expiry_date_o IN DATE
54 ,p_comments_o IN VARCHAR2
55 ,p_vre_attribute_category_o IN VARCHAR2
56 ,p_vre_attribute1_o IN VARCHAR2
57 ,p_vre_attribute2_o IN VARCHAR2
58 ,p_vre_attribute3_o IN VARCHAR2
59 ,p_vre_attribute4_o IN VARCHAR2
60 ,p_vre_attribute5_o IN VARCHAR2
61 ,p_vre_attribute6_o IN VARCHAR2
62 ,p_vre_attribute7_o IN VARCHAR2
63 ,p_vre_attribute8_o IN VARCHAR2
64 ,p_vre_attribute9_o IN VARCHAR2
65 ,p_vre_attribute10_o IN VARCHAR2
66 ,p_vre_attribute11_o IN VARCHAR2
67 ,p_vre_attribute12_o IN VARCHAR2
68 ,p_vre_attribute13_o IN VARCHAR2
69 ,p_vre_attribute14_o IN VARCHAR2
70 ,p_vre_attribute15_o IN VARCHAR2
71 ,p_vre_attribute16_o IN VARCHAR2
72 ,p_vre_attribute17_o IN VARCHAR2
73 ,p_vre_attribute18_o IN VARCHAR2
74 ,p_vre_attribute19_o IN VARCHAR2
75 ,p_vre_attribute20_o IN VARCHAR2
76 ,p_vre_information_category_o IN VARCHAR2
77 ,p_vre_information1_o IN VARCHAR2
78 ,p_vre_information2_o IN VARCHAR2
79 ,p_vre_information3_o IN VARCHAR2
80 ,p_vre_information4_o IN VARCHAR2
81 ,p_vre_information5_o IN VARCHAR2
82 ,p_vre_information6_o IN VARCHAR2
83 ,p_vre_information7_o IN VARCHAR2
84 ,p_vre_information8_o IN VARCHAR2
85 ,p_vre_information9_o IN VARCHAR2
86 ,p_vre_information10_o IN VARCHAR2
87 ,p_vre_information11_o IN VARCHAR2
88 ,p_vre_information12_o IN VARCHAR2
89 ,p_vre_information13_o IN VARCHAR2
90 ,p_vre_information14_o IN VARCHAR2
91 ,p_vre_information15_o IN VARCHAR2
92 ,p_vre_information16_o IN VARCHAR2
93 ,p_vre_information17_o IN VARCHAR2
94 ,p_vre_information18_o IN VARCHAR2
95 ,p_vre_information19_o IN VARCHAR2
96 ,p_vre_information20_o IN VARCHAR2
97 );
98 --
99 end pqp_vre_rkd;