1 PACKAGE PQP_SS_VEHICLE_TRANSACTIONS AUTHID CURRENT_USER AS
2 /* $Header: pqpssvehinfo.pkh 120.0 2005/05/29 02:22:24 appldev noship $*/
3 --
4 --
5 TYPE ref_cursor IS REF CURSOR;
6 TYPE r_user_info IS RECORD (person_id per_all_people_f.person_id%TYPE
7 ,assignment_id per_all_assignments_f.assignment_id%TYPE
8 ,user_type VARCHAR2(10)) ;
9
10 TYPE t_user_info IS TABLE OF r_user_info
11 INDEX BY BINARY_INTEGER;
12
13 g_user_info t_user_info;
14
15 PROCEDURE IS_EXTRA_INFO_EXISTS (
16 itemtype IN VARCHAR2,
17 itemkey IN VARCHAR2,
18 actid IN NUMBER,
19 funcmode IN VARCHAR2,
20 result OUT NOCOPY VARCHAR2 );
21 --
22 PROCEDURE SET_EXTRA_INFO_VAL (
23 itemtype IN VARCHAR2,
24 itemkey IN VARCHAR2,
25 result OUT NOCOPY VARCHAR2 );
26 FUNCTION get_vehicle_usr_details (
27 p_transaction_step_id IN VARCHAR2 )
28 RETURN ref_cursor;
29
30 FUNCTION get_vehicle_details (
31 p_transaction_step_id IN VARCHAR2 )
32 RETURN ref_cursor ;
33 --
34 --
35 PROCEDURE delete_process_api (
36 p_validate IN BOOLEAN DEFAULT FALSE,
37 p_transaction_step_id IN NUMBER,
38 p_effective_date IN VARCHAR2 DEFAULT NULL );
39
40
41 FUNCTION get_vehicle_details_hgrid (
42 p_transaction_step_id in varchar2 ) RETURN ref_cursor ;
43
44
45 PROCEDURE delete_vehicle_details(
46 x_p_validate IN BOOLEAN
47 ,x_effective_date IN DATE
48 ,x_login_person_id IN NUMBER
49 ,x_person_id IN NUMBER
50 ,x_assignment_id IN NUMBER
51 ,x_business_group_id IN NUMBER
52 ,x_item_key IN NUMBER
53 ,x_item_type IN VARCHAR2
54 ,x_activity_id IN NUMBER
55 ,x_vehicle_allocation_id IN NUMBER
56 ,x_status IN VARCHAR2
57 ,x_transaction_id IN OUT NOCOPY NUMBER
58 ,x_error_status OUT NOCOPY VARCHAR2
59 );
60
61
62
63 PROCEDURE set_vehicle_details (
64 x_p_validate IN BOOLEAN DEFAULT false
65 ,x_effective_date IN DATE DEFAULT SYSDATE
66 ,x_login_person_id IN NUMBER
67 ,x_person_id IN NUMBER
68 ,x_assignment_id IN NUMBER
69 ,x_item_type IN VARCHAR2
70 ,x_item_key IN NUMBER
71 ,x_activity_id IN NUMBER
72 ,x_registration_number IN VARCHAR2
73 ,x_vehicle_ownership IN VARCHAR2 DEFAULT 'P'
74 ,x_vehicle_type IN VARCHAR2
75 ,x_vehicle_id_number IN VARCHAR2
76 ,x_business_group_id IN NUMBER
77 ,x_make IN VARCHAR2
78 ,x_engine_capacity_in_cc IN NUMBER
79 ,x_fuel_type IN VARCHAR2
80 ,x_currency_code IN VARCHAR2
81 ,x_model IN VARCHAR2
82 ,x_initial_registration IN DATE
83 ,x_last_registration_renew_date IN DATE
84 ,x_fiscal_ratings IN NUMBER
85 ,x_shared_vehicle IN VARCHAR2
86 ,x_color IN VARCHAR2
87 ,x_seating_capacity IN NUMBER
88 ,x_weight IN NUMBER
89 ,x_weight_uom IN VARCHAR2
90 ,x_model_year IN NUMBER
91 ,x_insurance_number IN VARCHAR2
92 ,x_insurance_expiry_date IN DATE
93 ,x_taxation_method IN VARCHAR2
94 ,x_comments IN VARCHAR2
95 ,x_vre_attribute_category IN VARCHAR2 DEFAULT NULL
96 ,x_vre_attribute1 IN VARCHAR2 DEFAULT NULL
97 ,x_vre_attribute2 IN VARCHAR2 DEFAULT NULL
98 ,x_vre_attribute3 IN VARCHAR2 DEFAULT NULL
99 ,x_vre_attribute4 IN VARCHAR2 DEFAULT NULL
100 ,x_vre_attribute5 IN VARCHAR2 DEFAULT NULL
101 ,x_vre_attribute6 IN VARCHAR2 DEFAULT NULL
102 ,x_vre_attribute7 IN VARCHAR2 DEFAULT NULL
103 ,x_vre_attribute8 IN VARCHAR2 DEFAULT NULL
104 ,x_vre_attribute9 IN VARCHAR2 DEFAULT NULL
105 ,x_vre_attribute10 IN VARCHAR2 DEFAULT NULL
106 ,x_vre_attribute11 IN VARCHAR2 DEFAULT NULL
107 ,x_vre_attribute12 IN VARCHAR2 DEFAULT NULL
108 ,x_vre_attribute13 IN VARCHAR2 DEFAULT NULL
109 ,x_vre_attribute14 IN VARCHAR2 DEFAULT NULL
110 ,x_vre_attribute15 IN VARCHAR2 DEFAULT NULL
111 ,x_vre_attribute16 IN VARCHAR2 DEFAULT NULL
112 ,x_vre_attribute17 IN VARCHAR2 DEFAULT NULL
113 ,x_vre_attribute18 IN VARCHAR2 DEFAULT NULL
114 ,x_vre_attribute19 IN VARCHAR2 DEFAULT NULL
115 ,x_vre_attribute20 IN VARCHAR2 DEFAULT NULL
116 ,x_vre_information_category IN VARCHAR2 DEFAULT NULL
117 ,x_vre_information1 IN VARCHAR2 DEFAULT NULL
118 ,x_vre_information2 IN VARCHAR2 DEFAULT NULL
119 ,x_vre_information3 IN VARCHAR2 DEFAULT NULL
120 ,x_vre_information4 IN VARCHAR2 DEFAULT NULL
121 ,x_vre_information5 IN VARCHAR2 DEFAULT NULL
122 ,x_vre_information6 IN VARCHAR2 DEFAULT NULL
123 ,x_vre_information7 IN VARCHAR2 DEFAULT NULL
124 ,x_vre_information8 IN VARCHAR2 DEFAULT NULL
125 ,x_vre_information9 IN VARCHAR2 DEFAULT NULL
126 ,x_vre_information10 IN VARCHAR2 DEFAULT NULL
127 ,x_vre_information11 IN VARCHAR2 DEFAULT NULL
128 ,x_vre_information12 IN VARCHAR2 DEFAULT NULL
129 ,x_vre_information13 IN VARCHAR2 DEFAULT NULL
130 ,x_vre_information14 IN VARCHAR2 DEFAULT NULL
131 ,x_vre_information15 IN VARCHAR2 DEFAULT NULL
132 ,x_vre_information16 IN VARCHAR2 DEFAULT NULL
133 ,x_vre_information17 IN VARCHAR2 DEFAULT NULL
134 ,x_vre_information18 IN VARCHAR2 DEFAULT NULL
135 ,x_vre_information19 IN VARCHAR2 DEFAULT NULL
136 ,x_vre_information20 IN VARCHAR2 DEFAULT NULL
137 ,x_across_assignments IN VARCHAR2 DEFAULT NULL
138 ,x_usage_type IN VARCHAR2 DEFAULT NULL
139 ,x_default_vehicle IN VARCHAR2 DEFAULT NULL
140 ,x_fuel_card IN VARCHAR2 DEFAULT NULL
141 ,x_fuel_card_number IN VARCHAR2 DEFAULT NULL
142 ,x_val_attribute_category IN VARCHAR2 DEFAULT NULL
143 ,x_val_attribute1 IN VARCHAR2 DEFAULT NULL
144 ,x_val_attribute2 IN VARCHAR2 DEFAULT NULL
145 ,x_val_attribute3 IN VARCHAR2 DEFAULT NULL
146 ,x_val_attribute4 IN VARCHAR2 DEFAULT NULL
147 ,x_val_attribute5 IN VARCHAR2 DEFAULT NULL
148 ,x_val_attribute6 IN VARCHAR2 DEFAULT NULL
149 ,x_val_attribute7 IN VARCHAR2 DEFAULT NULL
150 ,x_val_attribute8 IN VARCHAR2 DEFAULT NULL
151 ,x_val_attribute9 IN VARCHAR2 DEFAULT NULL
152 ,x_val_attribute10 IN VARCHAR2 DEFAULT NULL
153 ,x_val_attribute11 IN VARCHAR2 DEFAULT NULL
154 ,x_val_attribute12 IN VARCHAR2 DEFAULT NULL
155 ,x_val_attribute13 IN VARCHAR2 DEFAULT NULL
156 ,x_val_attribute14 IN VARCHAR2 DEFAULT NULL
157 ,x_val_attribute15 IN VARCHAR2 DEFAULT NULL
158 ,x_val_attribute16 IN VARCHAR2 DEFAULT NULL
159 ,x_val_attribute17 IN VARCHAR2 DEFAULT NULL
160 ,x_val_attribute18 IN VARCHAR2 DEFAULT NULL
161 ,x_val_attribute19 IN VARCHAR2 DEFAULT NULL
162 ,x_val_attribute20 IN VARCHAR2 DEFAULT NULL
163 ,x_val_information_category IN VARCHAR2 DEFAULT NULL
164 ,x_val_information1 IN VARCHAR2 DEFAULT NULL
165 ,x_val_information2 IN VARCHAR2 DEFAULT NULL
166 ,x_val_information3 IN VARCHAR2 DEFAULT NULL
167 ,x_val_information4 IN VARCHAR2 DEFAULT NULL
168 ,x_val_information5 IN VARCHAR2 DEFAULT NULL
169 ,x_val_information6 IN VARCHAR2 DEFAULT NULL
170 ,x_val_information7 IN VARCHAR2 DEFAULT NULL
171 ,x_val_information8 IN VARCHAR2 DEFAULT NULL
172 ,x_val_information9 IN VARCHAR2 DEFAULT NULL
173 ,x_val_information10 IN VARCHAR2 DEFAULT NULL
174 ,x_val_information11 IN VARCHAR2 DEFAULT NULL
175 ,x_val_information12 IN VARCHAR2 DEFAULT NULL
176 ,x_val_information13 IN VARCHAR2 DEFAULT NULL
177 ,x_val_information14 IN VARCHAR2 DEFAULT NULL
178 ,x_val_information15 IN VARCHAR2 DEFAULT NULL
179 ,x_val_information16 IN VARCHAR2 DEFAULT NULL
180 ,x_val_information17 IN VARCHAR2 DEFAULT NULL
181 ,x_val_information18 IN VARCHAR2 DEFAULT NULL
182 ,x_val_information19 IN VARCHAR2 DEFAULT NULL
183 ,x_val_information20 IN VARCHAR2 DEFAULT NULL
184 ,x_fuel_benefit IN VARCHAR2 DEFAULT NULL
185 ,x_user_info IN t_user_info
186 ,x_status IN VARCHAR2 DEFAULT NULL
187 ,x_effective_date_option IN VARCHAR2 DEFAULT NULL
188 ,x_vehicle_repository_id IN NUMBER DEFAULT NULL
189 ,x_vehicle_allocation_id IN NUMBER DEFAULT NULL
190 ,x_object_version_number IN NUMBER DEFAULT NULL
191 ,x_error_status OUT NOCOPY VARCHAR2
192 ,x_transaction_id IN OUT NOCOPY NUMBER
193 );
194 PROCEDURE update_transaction_itemkey (
195 itemtype IN VARCHAR2,
196 itemkey IN VARCHAR2,
197 actid IN NUMBER,
198 funcmode IN VARCHAR2,
199 result OUT NOCOPY VARCHAR2 );
200
201
202 --
203 --
204 --
205 --
206 PROCEDURE process_api (
207 p_validate IN BOOLEAN DEFAULT FALSE,
208 p_transaction_step_id IN NUMBER,
209 p_effective_date IN VARCHAR2 DEFAULT NULL);
210
211 PROCEDURE delete_allocation(
212 p_validate IN BOOLEAN DEFAULT FALSE
213 ,p_effective_date IN DATE
214 ,p_assignment_id IN NUMBER
215 ,p_vehicle_allocation_id IN NUMBER
216 ,p_business_group_id IN NUMBER
217 ,p_error_status OUT NOCOPY VARCHAR2
218 );
219 --
220 --
221 --
222 --
223 --
224 --
225 END PQP_SS_VEHICLE_TRANSACTIONS;
226