195:
196: END IF;
197:
198:
199: fnd_file.put(fnd_file.output,'Ownership ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
196: END IF;
197:
198:
199: fnd_file.put(fnd_file.output,'Ownership ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
197:
198:
199: fnd_file.put(fnd_file.output,'Ownership ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
198:
199: fnd_file.put(fnd_file.output,'Ownership ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
199: fnd_file.put(fnd_file.output,'Ownership ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
200: fnd_file.put(fnd_file.output,'Usage type ');
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
208:
201: fnd_file.put(fnd_file.output,'Vehicle Type ');
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
208:
209:
202: fnd_file.put(fnd_file.output,' ' );
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
208:
209:
210: fnd_file.put_line(fnd_file.output,' ');
203: fnd_file.put(fnd_file.output,'Fuel Type ');
204: fnd_file.put(fnd_file.output,' ' );
205: fnd_file.put(fnd_file.output,'Rates');
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
208:
209:
210: fnd_file.put_line(fnd_file.output,' ');
211:
206: fnd_file.put(fnd_file.output,' ' );
207: fnd_file.put(fnd_file.output,'Element ');
208:
209:
210: fnd_file.put_line(fnd_file.output,' ');
211:
212: OPEN c_get_info;
213: LOOP
214: FETCH c_get_info INTO l_get_info;
212: OPEN c_get_info;
213: LOOP
214: FETCH c_get_info INTO l_get_info;
215: EXIT WHEN c_get_info%NOTFOUND;
216: fnd_file.put_line(fnd_file.output,' ');
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
213: LOOP
214: FETCH c_get_info INTO l_get_info;
215: EXIT WHEN c_get_info%NOTFOUND;
216: fnd_file.put_line(fnd_file.output,' ');
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
214: FETCH c_get_info INTO l_get_info;
215: EXIT WHEN c_get_info%NOTFOUND;
216: fnd_file.put_line(fnd_file.output,' ');
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
215: EXIT WHEN c_get_info%NOTFOUND;
216: fnd_file.put_line(fnd_file.output,' ');
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
216: fnd_file.put_line(fnd_file.output,' ');
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
217: fnd_file.put(fnd_file.output,l_get_info.Ownership );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
218: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
219: fnd_file.put(fnd_file.output,l_get_info.usage_type );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
227: fnd_file.put(fnd_file.output,l_get_info.element_name );
220: fnd_file.put(fnd_file.output,' ' );
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
227: fnd_file.put(fnd_file.output,l_get_info.element_name );
228:
221: fnd_file.put(fnd_file.output,l_get_info.vehicle_type );
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
227: fnd_file.put(fnd_file.output,l_get_info.element_name );
228:
229:
222: fnd_file.put(fnd_file.output,' ' );
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
227: fnd_file.put(fnd_file.output,l_get_info.element_name );
228:
229:
230: END LOOP;
223: fnd_file.put(fnd_file.output,l_get_info.fuel_type );
224: fnd_file.put(fnd_file.output,' ' );
225: fnd_file.put(fnd_file.output,l_get_info.rates_type );
226: fnd_file.put(fnd_file.output,' ' );
227: fnd_file.put(fnd_file.output,l_get_info.element_name );
228:
229:
230: END LOOP;
231: CLOSE c_get_info;