eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQP_VRE_DEL dependencies on PQP_VRE_SHD

Line 54: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

50: --
51: -- {End Of Comments}
52: -- ----------------------------------------------------------------------------
53: PROCEDURE dt_delete_dml
54: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
55: ,p_effective_date IN DATE
56: ,p_datetrack_mode IN VARCHAR2
57: ,p_validation_start_date IN DATE
58: ,p_validation_end_date IN DATE

Line 98: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

94: -- ----------------------------------------------------------------------------
95: -- |------------------------------< delete_dml >------------------------------|
96: -- ----------------------------------------------------------------------------
97: PROCEDURE delete_dml
98: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
99: ,p_effective_date IN DATE
100: ,p_datetrack_mode IN VARCHAR2
101: ,p_validation_start_date IN DATE
102: ,p_validation_end_date IN DATE

Line 155: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

151: --
152: -- {End Of Comments}
153: -- ----------------------------------------------------------------------------
154: PROCEDURE dt_pre_delete
155: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
156: ,p_effective_date IN DATE
157: ,p_datetrack_mode IN VARCHAR2
158: ,p_validation_start_date IN DATE
159: ,p_validation_end_date IN DATE

Line 170: := pqp_vre_shd.g_old_rec.effective_start_date;

166: --
167: IF (p_datetrack_mode <> hr_api.g_zap) THEN
168: --
169: p_rec.effective_start_date
170: := pqp_vre_shd.g_old_rec.effective_start_date;
171: --
172: IF (p_datetrack_mode = hr_api.g_delete) THEN
173: p_rec.effective_end_date := p_validation_start_date - 1;
174: Else

Line 180: pqp_vre_shd.upd_effective_end_date

176: END IF;
177: --
178: -- Update the current effective end date record
179: --
180: pqp_vre_shd.upd_effective_end_date
181: (p_effective_date => p_effective_date
182: ,p_base_key_value => p_rec.vehicle_repository_id
183: ,p_new_effective_end_date => p_rec.effective_end_date
184: ,p_validation_start_date => p_validation_start_date

Line 229: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

225: --
226: -- {End Of Comments}
227: -- ----------------------------------------------------------------------------
228: PROCEDURE pre_delete
229: (p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
230: ,p_effective_date IN DATE
231: ,p_datetrack_mode IN VARCHAR2
232: ,p_validation_start_date IN DATE
233: ,p_validation_end_date IN DATE

Line 306: (p_rec in pqp_vre_shd.g_rec_type

302: --
303: -- {End Of Comments}
304: -- ----------------------------------------------------------------------------
305: PROCEDURE post_delete
306: (p_rec in pqp_vre_shd.g_rec_type
307: ,p_effective_date in date
308: ,p_datetrack_mode in varchar2
309: ,p_validation_start_date in date
310: ,p_validation_end_date in date

Line 335: => pqp_vre_shd.g_old_rec.effective_start_date

331: => p_rec.effective_start_date
332: ,p_effective_end_date
333: => p_rec.effective_end_date
334: ,p_effective_start_date_o
335: => pqp_vre_shd.g_old_rec.effective_start_date
336: ,p_effective_end_date_o
337: => pqp_vre_shd.g_old_rec.effective_end_date
338: ,p_registration_number_o
339: => pqp_vre_shd.g_old_rec.registration_number

Line 337: => pqp_vre_shd.g_old_rec.effective_end_date

333: => p_rec.effective_end_date
334: ,p_effective_start_date_o
335: => pqp_vre_shd.g_old_rec.effective_start_date
336: ,p_effective_end_date_o
337: => pqp_vre_shd.g_old_rec.effective_end_date
338: ,p_registration_number_o
339: => pqp_vre_shd.g_old_rec.registration_number
340: ,p_vehicle_type_o
341: => pqp_vre_shd.g_old_rec.vehicle_type

Line 339: => pqp_vre_shd.g_old_rec.registration_number

335: => pqp_vre_shd.g_old_rec.effective_start_date
336: ,p_effective_end_date_o
337: => pqp_vre_shd.g_old_rec.effective_end_date
338: ,p_registration_number_o
339: => pqp_vre_shd.g_old_rec.registration_number
340: ,p_vehicle_type_o
341: => pqp_vre_shd.g_old_rec.vehicle_type
342: ,p_vehicle_id_number_o
343: => pqp_vre_shd.g_old_rec.vehicle_id_number

Line 341: => pqp_vre_shd.g_old_rec.vehicle_type

337: => pqp_vre_shd.g_old_rec.effective_end_date
338: ,p_registration_number_o
339: => pqp_vre_shd.g_old_rec.registration_number
340: ,p_vehicle_type_o
341: => pqp_vre_shd.g_old_rec.vehicle_type
342: ,p_vehicle_id_number_o
343: => pqp_vre_shd.g_old_rec.vehicle_id_number
344: ,p_business_group_id_o
345: => pqp_vre_shd.g_old_rec.business_group_id

Line 343: => pqp_vre_shd.g_old_rec.vehicle_id_number

339: => pqp_vre_shd.g_old_rec.registration_number
340: ,p_vehicle_type_o
341: => pqp_vre_shd.g_old_rec.vehicle_type
342: ,p_vehicle_id_number_o
343: => pqp_vre_shd.g_old_rec.vehicle_id_number
344: ,p_business_group_id_o
345: => pqp_vre_shd.g_old_rec.business_group_id
346: ,p_make_o
347: => pqp_vre_shd.g_old_rec.make

Line 345: => pqp_vre_shd.g_old_rec.business_group_id

341: => pqp_vre_shd.g_old_rec.vehicle_type
342: ,p_vehicle_id_number_o
343: => pqp_vre_shd.g_old_rec.vehicle_id_number
344: ,p_business_group_id_o
345: => pqp_vre_shd.g_old_rec.business_group_id
346: ,p_make_o
347: => pqp_vre_shd.g_old_rec.make
348: ,p_model_o
349: => pqp_vre_shd.g_old_rec.model

Line 347: => pqp_vre_shd.g_old_rec.make

343: => pqp_vre_shd.g_old_rec.vehicle_id_number
344: ,p_business_group_id_o
345: => pqp_vre_shd.g_old_rec.business_group_id
346: ,p_make_o
347: => pqp_vre_shd.g_old_rec.make
348: ,p_model_o
349: => pqp_vre_shd.g_old_rec.model
350: ,p_initial_registration_o
351: => pqp_vre_shd.g_old_rec.initial_registration

Line 349: => pqp_vre_shd.g_old_rec.model

345: => pqp_vre_shd.g_old_rec.business_group_id
346: ,p_make_o
347: => pqp_vre_shd.g_old_rec.make
348: ,p_model_o
349: => pqp_vre_shd.g_old_rec.model
350: ,p_initial_registration_o
351: => pqp_vre_shd.g_old_rec.initial_registration
352: ,p_last_registration_renew_da_o
353: => pqp_vre_shd.g_old_rec.last_registration_renew_date

Line 351: => pqp_vre_shd.g_old_rec.initial_registration

347: => pqp_vre_shd.g_old_rec.make
348: ,p_model_o
349: => pqp_vre_shd.g_old_rec.model
350: ,p_initial_registration_o
351: => pqp_vre_shd.g_old_rec.initial_registration
352: ,p_last_registration_renew_da_o
353: => pqp_vre_shd.g_old_rec.last_registration_renew_date
354: ,p_engine_capacity_in_cc_o
355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc

Line 353: => pqp_vre_shd.g_old_rec.last_registration_renew_date

349: => pqp_vre_shd.g_old_rec.model
350: ,p_initial_registration_o
351: => pqp_vre_shd.g_old_rec.initial_registration
352: ,p_last_registration_renew_da_o
353: => pqp_vre_shd.g_old_rec.last_registration_renew_date
354: ,p_engine_capacity_in_cc_o
355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
356: ,p_fuel_type_o
357: => pqp_vre_shd.g_old_rec.fuel_type

Line 355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc

351: => pqp_vre_shd.g_old_rec.initial_registration
352: ,p_last_registration_renew_da_o
353: => pqp_vre_shd.g_old_rec.last_registration_renew_date
354: ,p_engine_capacity_in_cc_o
355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
356: ,p_fuel_type_o
357: => pqp_vre_shd.g_old_rec.fuel_type
358: ,p_currency_code_o
359: => pqp_vre_shd.g_old_rec.currency_code

Line 357: => pqp_vre_shd.g_old_rec.fuel_type

353: => pqp_vre_shd.g_old_rec.last_registration_renew_date
354: ,p_engine_capacity_in_cc_o
355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
356: ,p_fuel_type_o
357: => pqp_vre_shd.g_old_rec.fuel_type
358: ,p_currency_code_o
359: => pqp_vre_shd.g_old_rec.currency_code
360: ,p_list_price_o
361: => pqp_vre_shd.g_old_rec.list_price

Line 359: => pqp_vre_shd.g_old_rec.currency_code

355: => pqp_vre_shd.g_old_rec.engine_capacity_in_cc
356: ,p_fuel_type_o
357: => pqp_vre_shd.g_old_rec.fuel_type
358: ,p_currency_code_o
359: => pqp_vre_shd.g_old_rec.currency_code
360: ,p_list_price_o
361: => pqp_vre_shd.g_old_rec.list_price
362: ,p_accessory_value_at_startda_o
363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate

Line 361: => pqp_vre_shd.g_old_rec.list_price

357: => pqp_vre_shd.g_old_rec.fuel_type
358: ,p_currency_code_o
359: => pqp_vre_shd.g_old_rec.currency_code
360: ,p_list_price_o
361: => pqp_vre_shd.g_old_rec.list_price
362: ,p_accessory_value_at_startda_o
363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
364: ,p_accessory_value_added_late_o
365: => pqp_vre_shd.g_old_rec.accessory_value_added_later

Line 363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate

359: => pqp_vre_shd.g_old_rec.currency_code
360: ,p_list_price_o
361: => pqp_vre_shd.g_old_rec.list_price
362: ,p_accessory_value_at_startda_o
363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
364: ,p_accessory_value_added_late_o
365: => pqp_vre_shd.g_old_rec.accessory_value_added_later
366: ,p_market_value_classic_car_o
367: => pqp_vre_shd.g_old_rec.market_value_classic_car

Line 365: => pqp_vre_shd.g_old_rec.accessory_value_added_later

361: => pqp_vre_shd.g_old_rec.list_price
362: ,p_accessory_value_at_startda_o
363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
364: ,p_accessory_value_added_late_o
365: => pqp_vre_shd.g_old_rec.accessory_value_added_later
366: ,p_market_value_classic_car_o
367: => pqp_vre_shd.g_old_rec.market_value_classic_car
368: ,p_fiscal_ratings_o
369: => pqp_vre_shd.g_old_rec.fiscal_ratings

Line 367: => pqp_vre_shd.g_old_rec.market_value_classic_car

363: => pqp_vre_shd.g_old_rec.accessory_value_at_startdate
364: ,p_accessory_value_added_late_o
365: => pqp_vre_shd.g_old_rec.accessory_value_added_later
366: ,p_market_value_classic_car_o
367: => pqp_vre_shd.g_old_rec.market_value_classic_car
368: ,p_fiscal_ratings_o
369: => pqp_vre_shd.g_old_rec.fiscal_ratings
370: ,p_fiscal_ratings_uom_o
371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom

Line 369: => pqp_vre_shd.g_old_rec.fiscal_ratings

365: => pqp_vre_shd.g_old_rec.accessory_value_added_later
366: ,p_market_value_classic_car_o
367: => pqp_vre_shd.g_old_rec.market_value_classic_car
368: ,p_fiscal_ratings_o
369: => pqp_vre_shd.g_old_rec.fiscal_ratings
370: ,p_fiscal_ratings_uom_o
371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
372: ,p_vehicle_provider_o
373: => pqp_vre_shd.g_old_rec.vehicle_provider

Line 371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom

367: => pqp_vre_shd.g_old_rec.market_value_classic_car
368: ,p_fiscal_ratings_o
369: => pqp_vre_shd.g_old_rec.fiscal_ratings
370: ,p_fiscal_ratings_uom_o
371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
372: ,p_vehicle_provider_o
373: => pqp_vre_shd.g_old_rec.vehicle_provider
374: ,p_vehicle_ownership_o
375: => pqp_vre_shd.g_old_rec.vehicle_ownership

Line 373: => pqp_vre_shd.g_old_rec.vehicle_provider

369: => pqp_vre_shd.g_old_rec.fiscal_ratings
370: ,p_fiscal_ratings_uom_o
371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
372: ,p_vehicle_provider_o
373: => pqp_vre_shd.g_old_rec.vehicle_provider
374: ,p_vehicle_ownership_o
375: => pqp_vre_shd.g_old_rec.vehicle_ownership
376: ,p_shared_vehicle_o
377: => pqp_vre_shd.g_old_rec.shared_vehicle

Line 375: => pqp_vre_shd.g_old_rec.vehicle_ownership

371: => pqp_vre_shd.g_old_rec.fiscal_ratings_uom
372: ,p_vehicle_provider_o
373: => pqp_vre_shd.g_old_rec.vehicle_provider
374: ,p_vehicle_ownership_o
375: => pqp_vre_shd.g_old_rec.vehicle_ownership
376: ,p_shared_vehicle_o
377: => pqp_vre_shd.g_old_rec.shared_vehicle
378: ,p_vehicle_status_o
379: => pqp_vre_shd.g_old_rec.vehicle_status

Line 377: => pqp_vre_shd.g_old_rec.shared_vehicle

373: => pqp_vre_shd.g_old_rec.vehicle_provider
374: ,p_vehicle_ownership_o
375: => pqp_vre_shd.g_old_rec.vehicle_ownership
376: ,p_shared_vehicle_o
377: => pqp_vre_shd.g_old_rec.shared_vehicle
378: ,p_vehicle_status_o
379: => pqp_vre_shd.g_old_rec.vehicle_status
380: ,p_vehicle_inactivity_reason_o
381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason

Line 379: => pqp_vre_shd.g_old_rec.vehicle_status

375: => pqp_vre_shd.g_old_rec.vehicle_ownership
376: ,p_shared_vehicle_o
377: => pqp_vre_shd.g_old_rec.shared_vehicle
378: ,p_vehicle_status_o
379: => pqp_vre_shd.g_old_rec.vehicle_status
380: ,p_vehicle_inactivity_reason_o
381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
382: ,p_asset_number_o
383: => pqp_vre_shd.g_old_rec.asset_number

Line 381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason

377: => pqp_vre_shd.g_old_rec.shared_vehicle
378: ,p_vehicle_status_o
379: => pqp_vre_shd.g_old_rec.vehicle_status
380: ,p_vehicle_inactivity_reason_o
381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
382: ,p_asset_number_o
383: => pqp_vre_shd.g_old_rec.asset_number
384: ,p_lease_contract_number_o
385: => pqp_vre_shd.g_old_rec.lease_contract_number

Line 383: => pqp_vre_shd.g_old_rec.asset_number

379: => pqp_vre_shd.g_old_rec.vehicle_status
380: ,p_vehicle_inactivity_reason_o
381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
382: ,p_asset_number_o
383: => pqp_vre_shd.g_old_rec.asset_number
384: ,p_lease_contract_number_o
385: => pqp_vre_shd.g_old_rec.lease_contract_number
386: ,p_lease_contract_expiry_date_o
387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date

Line 385: => pqp_vre_shd.g_old_rec.lease_contract_number

381: => pqp_vre_shd.g_old_rec.vehicle_inactivity_reason
382: ,p_asset_number_o
383: => pqp_vre_shd.g_old_rec.asset_number
384: ,p_lease_contract_number_o
385: => pqp_vre_shd.g_old_rec.lease_contract_number
386: ,p_lease_contract_expiry_date_o
387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
388: ,p_taxation_method_o
389: => pqp_vre_shd.g_old_rec.taxation_method

Line 387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date

383: => pqp_vre_shd.g_old_rec.asset_number
384: ,p_lease_contract_number_o
385: => pqp_vre_shd.g_old_rec.lease_contract_number
386: ,p_lease_contract_expiry_date_o
387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
388: ,p_taxation_method_o
389: => pqp_vre_shd.g_old_rec.taxation_method
390: ,p_fleet_info_o
391: => pqp_vre_shd.g_old_rec.fleet_info

Line 389: => pqp_vre_shd.g_old_rec.taxation_method

385: => pqp_vre_shd.g_old_rec.lease_contract_number
386: ,p_lease_contract_expiry_date_o
387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
388: ,p_taxation_method_o
389: => pqp_vre_shd.g_old_rec.taxation_method
390: ,p_fleet_info_o
391: => pqp_vre_shd.g_old_rec.fleet_info
392: ,p_fleet_transfer_date_o
393: => pqp_vre_shd.g_old_rec.fleet_transfer_date

Line 391: => pqp_vre_shd.g_old_rec.fleet_info

387: => pqp_vre_shd.g_old_rec.lease_contract_expiry_date
388: ,p_taxation_method_o
389: => pqp_vre_shd.g_old_rec.taxation_method
390: ,p_fleet_info_o
391: => pqp_vre_shd.g_old_rec.fleet_info
392: ,p_fleet_transfer_date_o
393: => pqp_vre_shd.g_old_rec.fleet_transfer_date
394: ,p_object_version_number_o
395: => pqp_vre_shd.g_old_rec.object_version_number

Line 393: => pqp_vre_shd.g_old_rec.fleet_transfer_date

389: => pqp_vre_shd.g_old_rec.taxation_method
390: ,p_fleet_info_o
391: => pqp_vre_shd.g_old_rec.fleet_info
392: ,p_fleet_transfer_date_o
393: => pqp_vre_shd.g_old_rec.fleet_transfer_date
394: ,p_object_version_number_o
395: => pqp_vre_shd.g_old_rec.object_version_number
396: ,p_color_o
397: => pqp_vre_shd.g_old_rec.color

Line 395: => pqp_vre_shd.g_old_rec.object_version_number

391: => pqp_vre_shd.g_old_rec.fleet_info
392: ,p_fleet_transfer_date_o
393: => pqp_vre_shd.g_old_rec.fleet_transfer_date
394: ,p_object_version_number_o
395: => pqp_vre_shd.g_old_rec.object_version_number
396: ,p_color_o
397: => pqp_vre_shd.g_old_rec.color
398: ,p_seating_capacity_o
399: => pqp_vre_shd.g_old_rec.seating_capacity

Line 397: => pqp_vre_shd.g_old_rec.color

393: => pqp_vre_shd.g_old_rec.fleet_transfer_date
394: ,p_object_version_number_o
395: => pqp_vre_shd.g_old_rec.object_version_number
396: ,p_color_o
397: => pqp_vre_shd.g_old_rec.color
398: ,p_seating_capacity_o
399: => pqp_vre_shd.g_old_rec.seating_capacity
400: ,p_weight_o
401: => pqp_vre_shd.g_old_rec.weight

Line 399: => pqp_vre_shd.g_old_rec.seating_capacity

395: => pqp_vre_shd.g_old_rec.object_version_number
396: ,p_color_o
397: => pqp_vre_shd.g_old_rec.color
398: ,p_seating_capacity_o
399: => pqp_vre_shd.g_old_rec.seating_capacity
400: ,p_weight_o
401: => pqp_vre_shd.g_old_rec.weight
402: ,p_weight_uom_o
403: => pqp_vre_shd.g_old_rec.weight_uom

Line 401: => pqp_vre_shd.g_old_rec.weight

397: => pqp_vre_shd.g_old_rec.color
398: ,p_seating_capacity_o
399: => pqp_vre_shd.g_old_rec.seating_capacity
400: ,p_weight_o
401: => pqp_vre_shd.g_old_rec.weight
402: ,p_weight_uom_o
403: => pqp_vre_shd.g_old_rec.weight_uom
404: ,p_model_year_o
405: => pqp_vre_shd.g_old_rec.model_year

Line 403: => pqp_vre_shd.g_old_rec.weight_uom

399: => pqp_vre_shd.g_old_rec.seating_capacity
400: ,p_weight_o
401: => pqp_vre_shd.g_old_rec.weight
402: ,p_weight_uom_o
403: => pqp_vre_shd.g_old_rec.weight_uom
404: ,p_model_year_o
405: => pqp_vre_shd.g_old_rec.model_year
406: ,p_insurance_number_o
407: => pqp_vre_shd.g_old_rec.insurance_number

Line 405: => pqp_vre_shd.g_old_rec.model_year

401: => pqp_vre_shd.g_old_rec.weight
402: ,p_weight_uom_o
403: => pqp_vre_shd.g_old_rec.weight_uom
404: ,p_model_year_o
405: => pqp_vre_shd.g_old_rec.model_year
406: ,p_insurance_number_o
407: => pqp_vre_shd.g_old_rec.insurance_number
408: ,p_insurance_expiry_date_o
409: => pqp_vre_shd.g_old_rec.insurance_expiry_date

Line 407: => pqp_vre_shd.g_old_rec.insurance_number

403: => pqp_vre_shd.g_old_rec.weight_uom
404: ,p_model_year_o
405: => pqp_vre_shd.g_old_rec.model_year
406: ,p_insurance_number_o
407: => pqp_vre_shd.g_old_rec.insurance_number
408: ,p_insurance_expiry_date_o
409: => pqp_vre_shd.g_old_rec.insurance_expiry_date
410: ,p_comments_o
411: => pqp_vre_shd.g_old_rec.comments

Line 409: => pqp_vre_shd.g_old_rec.insurance_expiry_date

405: => pqp_vre_shd.g_old_rec.model_year
406: ,p_insurance_number_o
407: => pqp_vre_shd.g_old_rec.insurance_number
408: ,p_insurance_expiry_date_o
409: => pqp_vre_shd.g_old_rec.insurance_expiry_date
410: ,p_comments_o
411: => pqp_vre_shd.g_old_rec.comments
412: ,p_vre_attribute_category_o
413: => pqp_vre_shd.g_old_rec.vre_attribute_category

Line 411: => pqp_vre_shd.g_old_rec.comments

407: => pqp_vre_shd.g_old_rec.insurance_number
408: ,p_insurance_expiry_date_o
409: => pqp_vre_shd.g_old_rec.insurance_expiry_date
410: ,p_comments_o
411: => pqp_vre_shd.g_old_rec.comments
412: ,p_vre_attribute_category_o
413: => pqp_vre_shd.g_old_rec.vre_attribute_category
414: ,p_vre_attribute1_o
415: => pqp_vre_shd.g_old_rec.vre_attribute1

Line 413: => pqp_vre_shd.g_old_rec.vre_attribute_category

409: => pqp_vre_shd.g_old_rec.insurance_expiry_date
410: ,p_comments_o
411: => pqp_vre_shd.g_old_rec.comments
412: ,p_vre_attribute_category_o
413: => pqp_vre_shd.g_old_rec.vre_attribute_category
414: ,p_vre_attribute1_o
415: => pqp_vre_shd.g_old_rec.vre_attribute1
416: ,p_vre_attribute2_o
417: => pqp_vre_shd.g_old_rec.vre_attribute2

Line 415: => pqp_vre_shd.g_old_rec.vre_attribute1

411: => pqp_vre_shd.g_old_rec.comments
412: ,p_vre_attribute_category_o
413: => pqp_vre_shd.g_old_rec.vre_attribute_category
414: ,p_vre_attribute1_o
415: => pqp_vre_shd.g_old_rec.vre_attribute1
416: ,p_vre_attribute2_o
417: => pqp_vre_shd.g_old_rec.vre_attribute2
418: ,p_vre_attribute3_o
419: => pqp_vre_shd.g_old_rec.vre_attribute3

Line 417: => pqp_vre_shd.g_old_rec.vre_attribute2

413: => pqp_vre_shd.g_old_rec.vre_attribute_category
414: ,p_vre_attribute1_o
415: => pqp_vre_shd.g_old_rec.vre_attribute1
416: ,p_vre_attribute2_o
417: => pqp_vre_shd.g_old_rec.vre_attribute2
418: ,p_vre_attribute3_o
419: => pqp_vre_shd.g_old_rec.vre_attribute3
420: ,p_vre_attribute4_o
421: => pqp_vre_shd.g_old_rec.vre_attribute4

Line 419: => pqp_vre_shd.g_old_rec.vre_attribute3

415: => pqp_vre_shd.g_old_rec.vre_attribute1
416: ,p_vre_attribute2_o
417: => pqp_vre_shd.g_old_rec.vre_attribute2
418: ,p_vre_attribute3_o
419: => pqp_vre_shd.g_old_rec.vre_attribute3
420: ,p_vre_attribute4_o
421: => pqp_vre_shd.g_old_rec.vre_attribute4
422: ,p_vre_attribute5_o
423: => pqp_vre_shd.g_old_rec.vre_attribute5

Line 421: => pqp_vre_shd.g_old_rec.vre_attribute4

417: => pqp_vre_shd.g_old_rec.vre_attribute2
418: ,p_vre_attribute3_o
419: => pqp_vre_shd.g_old_rec.vre_attribute3
420: ,p_vre_attribute4_o
421: => pqp_vre_shd.g_old_rec.vre_attribute4
422: ,p_vre_attribute5_o
423: => pqp_vre_shd.g_old_rec.vre_attribute5
424: ,p_vre_attribute6_o
425: => pqp_vre_shd.g_old_rec.vre_attribute6

Line 423: => pqp_vre_shd.g_old_rec.vre_attribute5

419: => pqp_vre_shd.g_old_rec.vre_attribute3
420: ,p_vre_attribute4_o
421: => pqp_vre_shd.g_old_rec.vre_attribute4
422: ,p_vre_attribute5_o
423: => pqp_vre_shd.g_old_rec.vre_attribute5
424: ,p_vre_attribute6_o
425: => pqp_vre_shd.g_old_rec.vre_attribute6
426: ,p_vre_attribute7_o
427: => pqp_vre_shd.g_old_rec.vre_attribute7

Line 425: => pqp_vre_shd.g_old_rec.vre_attribute6

421: => pqp_vre_shd.g_old_rec.vre_attribute4
422: ,p_vre_attribute5_o
423: => pqp_vre_shd.g_old_rec.vre_attribute5
424: ,p_vre_attribute6_o
425: => pqp_vre_shd.g_old_rec.vre_attribute6
426: ,p_vre_attribute7_o
427: => pqp_vre_shd.g_old_rec.vre_attribute7
428: ,p_vre_attribute8_o
429: => pqp_vre_shd.g_old_rec.vre_attribute8

Line 427: => pqp_vre_shd.g_old_rec.vre_attribute7

423: => pqp_vre_shd.g_old_rec.vre_attribute5
424: ,p_vre_attribute6_o
425: => pqp_vre_shd.g_old_rec.vre_attribute6
426: ,p_vre_attribute7_o
427: => pqp_vre_shd.g_old_rec.vre_attribute7
428: ,p_vre_attribute8_o
429: => pqp_vre_shd.g_old_rec.vre_attribute8
430: ,p_vre_attribute9_o
431: => pqp_vre_shd.g_old_rec.vre_attribute9

Line 429: => pqp_vre_shd.g_old_rec.vre_attribute8

425: => pqp_vre_shd.g_old_rec.vre_attribute6
426: ,p_vre_attribute7_o
427: => pqp_vre_shd.g_old_rec.vre_attribute7
428: ,p_vre_attribute8_o
429: => pqp_vre_shd.g_old_rec.vre_attribute8
430: ,p_vre_attribute9_o
431: => pqp_vre_shd.g_old_rec.vre_attribute9
432: ,p_vre_attribute10_o
433: => pqp_vre_shd.g_old_rec.vre_attribute10

Line 431: => pqp_vre_shd.g_old_rec.vre_attribute9

427: => pqp_vre_shd.g_old_rec.vre_attribute7
428: ,p_vre_attribute8_o
429: => pqp_vre_shd.g_old_rec.vre_attribute8
430: ,p_vre_attribute9_o
431: => pqp_vre_shd.g_old_rec.vre_attribute9
432: ,p_vre_attribute10_o
433: => pqp_vre_shd.g_old_rec.vre_attribute10
434: ,p_vre_attribute11_o
435: => pqp_vre_shd.g_old_rec.vre_attribute11

Line 433: => pqp_vre_shd.g_old_rec.vre_attribute10

429: => pqp_vre_shd.g_old_rec.vre_attribute8
430: ,p_vre_attribute9_o
431: => pqp_vre_shd.g_old_rec.vre_attribute9
432: ,p_vre_attribute10_o
433: => pqp_vre_shd.g_old_rec.vre_attribute10
434: ,p_vre_attribute11_o
435: => pqp_vre_shd.g_old_rec.vre_attribute11
436: ,p_vre_attribute12_o
437: => pqp_vre_shd.g_old_rec.vre_attribute12

Line 435: => pqp_vre_shd.g_old_rec.vre_attribute11

431: => pqp_vre_shd.g_old_rec.vre_attribute9
432: ,p_vre_attribute10_o
433: => pqp_vre_shd.g_old_rec.vre_attribute10
434: ,p_vre_attribute11_o
435: => pqp_vre_shd.g_old_rec.vre_attribute11
436: ,p_vre_attribute12_o
437: => pqp_vre_shd.g_old_rec.vre_attribute12
438: ,p_vre_attribute13_o
439: => pqp_vre_shd.g_old_rec.vre_attribute13

Line 437: => pqp_vre_shd.g_old_rec.vre_attribute12

433: => pqp_vre_shd.g_old_rec.vre_attribute10
434: ,p_vre_attribute11_o
435: => pqp_vre_shd.g_old_rec.vre_attribute11
436: ,p_vre_attribute12_o
437: => pqp_vre_shd.g_old_rec.vre_attribute12
438: ,p_vre_attribute13_o
439: => pqp_vre_shd.g_old_rec.vre_attribute13
440: ,p_vre_attribute14_o
441: => pqp_vre_shd.g_old_rec.vre_attribute14

Line 439: => pqp_vre_shd.g_old_rec.vre_attribute13

435: => pqp_vre_shd.g_old_rec.vre_attribute11
436: ,p_vre_attribute12_o
437: => pqp_vre_shd.g_old_rec.vre_attribute12
438: ,p_vre_attribute13_o
439: => pqp_vre_shd.g_old_rec.vre_attribute13
440: ,p_vre_attribute14_o
441: => pqp_vre_shd.g_old_rec.vre_attribute14
442: ,p_vre_attribute15_o
443: => pqp_vre_shd.g_old_rec.vre_attribute15

Line 441: => pqp_vre_shd.g_old_rec.vre_attribute14

437: => pqp_vre_shd.g_old_rec.vre_attribute12
438: ,p_vre_attribute13_o
439: => pqp_vre_shd.g_old_rec.vre_attribute13
440: ,p_vre_attribute14_o
441: => pqp_vre_shd.g_old_rec.vre_attribute14
442: ,p_vre_attribute15_o
443: => pqp_vre_shd.g_old_rec.vre_attribute15
444: ,p_vre_attribute16_o
445: => pqp_vre_shd.g_old_rec.vre_attribute16

Line 443: => pqp_vre_shd.g_old_rec.vre_attribute15

439: => pqp_vre_shd.g_old_rec.vre_attribute13
440: ,p_vre_attribute14_o
441: => pqp_vre_shd.g_old_rec.vre_attribute14
442: ,p_vre_attribute15_o
443: => pqp_vre_shd.g_old_rec.vre_attribute15
444: ,p_vre_attribute16_o
445: => pqp_vre_shd.g_old_rec.vre_attribute16
446: ,p_vre_attribute17_o
447: => pqp_vre_shd.g_old_rec.vre_attribute17

Line 445: => pqp_vre_shd.g_old_rec.vre_attribute16

441: => pqp_vre_shd.g_old_rec.vre_attribute14
442: ,p_vre_attribute15_o
443: => pqp_vre_shd.g_old_rec.vre_attribute15
444: ,p_vre_attribute16_o
445: => pqp_vre_shd.g_old_rec.vre_attribute16
446: ,p_vre_attribute17_o
447: => pqp_vre_shd.g_old_rec.vre_attribute17
448: ,p_vre_attribute18_o
449: => pqp_vre_shd.g_old_rec.vre_attribute18

Line 447: => pqp_vre_shd.g_old_rec.vre_attribute17

443: => pqp_vre_shd.g_old_rec.vre_attribute15
444: ,p_vre_attribute16_o
445: => pqp_vre_shd.g_old_rec.vre_attribute16
446: ,p_vre_attribute17_o
447: => pqp_vre_shd.g_old_rec.vre_attribute17
448: ,p_vre_attribute18_o
449: => pqp_vre_shd.g_old_rec.vre_attribute18
450: ,p_vre_attribute19_o
451: => pqp_vre_shd.g_old_rec.vre_attribute19

Line 449: => pqp_vre_shd.g_old_rec.vre_attribute18

445: => pqp_vre_shd.g_old_rec.vre_attribute16
446: ,p_vre_attribute17_o
447: => pqp_vre_shd.g_old_rec.vre_attribute17
448: ,p_vre_attribute18_o
449: => pqp_vre_shd.g_old_rec.vre_attribute18
450: ,p_vre_attribute19_o
451: => pqp_vre_shd.g_old_rec.vre_attribute19
452: ,p_vre_attribute20_o
453: => pqp_vre_shd.g_old_rec.vre_attribute20

Line 451: => pqp_vre_shd.g_old_rec.vre_attribute19

447: => pqp_vre_shd.g_old_rec.vre_attribute17
448: ,p_vre_attribute18_o
449: => pqp_vre_shd.g_old_rec.vre_attribute18
450: ,p_vre_attribute19_o
451: => pqp_vre_shd.g_old_rec.vre_attribute19
452: ,p_vre_attribute20_o
453: => pqp_vre_shd.g_old_rec.vre_attribute20
454: ,p_vre_information_category_o
455: => pqp_vre_shd.g_old_rec.vre_information_category

Line 453: => pqp_vre_shd.g_old_rec.vre_attribute20

449: => pqp_vre_shd.g_old_rec.vre_attribute18
450: ,p_vre_attribute19_o
451: => pqp_vre_shd.g_old_rec.vre_attribute19
452: ,p_vre_attribute20_o
453: => pqp_vre_shd.g_old_rec.vre_attribute20
454: ,p_vre_information_category_o
455: => pqp_vre_shd.g_old_rec.vre_information_category
456: ,p_vre_information1_o
457: => pqp_vre_shd.g_old_rec.vre_information1

Line 455: => pqp_vre_shd.g_old_rec.vre_information_category

451: => pqp_vre_shd.g_old_rec.vre_attribute19
452: ,p_vre_attribute20_o
453: => pqp_vre_shd.g_old_rec.vre_attribute20
454: ,p_vre_information_category_o
455: => pqp_vre_shd.g_old_rec.vre_information_category
456: ,p_vre_information1_o
457: => pqp_vre_shd.g_old_rec.vre_information1
458: ,p_vre_information2_o
459: => pqp_vre_shd.g_old_rec.vre_information2

Line 457: => pqp_vre_shd.g_old_rec.vre_information1

453: => pqp_vre_shd.g_old_rec.vre_attribute20
454: ,p_vre_information_category_o
455: => pqp_vre_shd.g_old_rec.vre_information_category
456: ,p_vre_information1_o
457: => pqp_vre_shd.g_old_rec.vre_information1
458: ,p_vre_information2_o
459: => pqp_vre_shd.g_old_rec.vre_information2
460: ,p_vre_information3_o
461: => pqp_vre_shd.g_old_rec.vre_information3

Line 459: => pqp_vre_shd.g_old_rec.vre_information2

455: => pqp_vre_shd.g_old_rec.vre_information_category
456: ,p_vre_information1_o
457: => pqp_vre_shd.g_old_rec.vre_information1
458: ,p_vre_information2_o
459: => pqp_vre_shd.g_old_rec.vre_information2
460: ,p_vre_information3_o
461: => pqp_vre_shd.g_old_rec.vre_information3
462: ,p_vre_information4_o
463: => pqp_vre_shd.g_old_rec.vre_information4

Line 461: => pqp_vre_shd.g_old_rec.vre_information3

457: => pqp_vre_shd.g_old_rec.vre_information1
458: ,p_vre_information2_o
459: => pqp_vre_shd.g_old_rec.vre_information2
460: ,p_vre_information3_o
461: => pqp_vre_shd.g_old_rec.vre_information3
462: ,p_vre_information4_o
463: => pqp_vre_shd.g_old_rec.vre_information4
464: ,p_vre_information5_o
465: => pqp_vre_shd.g_old_rec.vre_information5

Line 463: => pqp_vre_shd.g_old_rec.vre_information4

459: => pqp_vre_shd.g_old_rec.vre_information2
460: ,p_vre_information3_o
461: => pqp_vre_shd.g_old_rec.vre_information3
462: ,p_vre_information4_o
463: => pqp_vre_shd.g_old_rec.vre_information4
464: ,p_vre_information5_o
465: => pqp_vre_shd.g_old_rec.vre_information5
466: ,p_vre_information6_o
467: => pqp_vre_shd.g_old_rec.vre_information6

Line 465: => pqp_vre_shd.g_old_rec.vre_information5

461: => pqp_vre_shd.g_old_rec.vre_information3
462: ,p_vre_information4_o
463: => pqp_vre_shd.g_old_rec.vre_information4
464: ,p_vre_information5_o
465: => pqp_vre_shd.g_old_rec.vre_information5
466: ,p_vre_information6_o
467: => pqp_vre_shd.g_old_rec.vre_information6
468: ,p_vre_information7_o
469: => pqp_vre_shd.g_old_rec.vre_information7

Line 467: => pqp_vre_shd.g_old_rec.vre_information6

463: => pqp_vre_shd.g_old_rec.vre_information4
464: ,p_vre_information5_o
465: => pqp_vre_shd.g_old_rec.vre_information5
466: ,p_vre_information6_o
467: => pqp_vre_shd.g_old_rec.vre_information6
468: ,p_vre_information7_o
469: => pqp_vre_shd.g_old_rec.vre_information7
470: ,p_vre_information8_o
471: => pqp_vre_shd.g_old_rec.vre_information8

Line 469: => pqp_vre_shd.g_old_rec.vre_information7

465: => pqp_vre_shd.g_old_rec.vre_information5
466: ,p_vre_information6_o
467: => pqp_vre_shd.g_old_rec.vre_information6
468: ,p_vre_information7_o
469: => pqp_vre_shd.g_old_rec.vre_information7
470: ,p_vre_information8_o
471: => pqp_vre_shd.g_old_rec.vre_information8
472: ,p_vre_information9_o
473: => pqp_vre_shd.g_old_rec.vre_information9

Line 471: => pqp_vre_shd.g_old_rec.vre_information8

467: => pqp_vre_shd.g_old_rec.vre_information6
468: ,p_vre_information7_o
469: => pqp_vre_shd.g_old_rec.vre_information7
470: ,p_vre_information8_o
471: => pqp_vre_shd.g_old_rec.vre_information8
472: ,p_vre_information9_o
473: => pqp_vre_shd.g_old_rec.vre_information9
474: ,p_vre_information10_o
475: => pqp_vre_shd.g_old_rec.vre_information10

Line 473: => pqp_vre_shd.g_old_rec.vre_information9

469: => pqp_vre_shd.g_old_rec.vre_information7
470: ,p_vre_information8_o
471: => pqp_vre_shd.g_old_rec.vre_information8
472: ,p_vre_information9_o
473: => pqp_vre_shd.g_old_rec.vre_information9
474: ,p_vre_information10_o
475: => pqp_vre_shd.g_old_rec.vre_information10
476: ,p_vre_information11_o
477: => pqp_vre_shd.g_old_rec.vre_information11

Line 475: => pqp_vre_shd.g_old_rec.vre_information10

471: => pqp_vre_shd.g_old_rec.vre_information8
472: ,p_vre_information9_o
473: => pqp_vre_shd.g_old_rec.vre_information9
474: ,p_vre_information10_o
475: => pqp_vre_shd.g_old_rec.vre_information10
476: ,p_vre_information11_o
477: => pqp_vre_shd.g_old_rec.vre_information11
478: ,p_vre_information12_o
479: => pqp_vre_shd.g_old_rec.vre_information12

Line 477: => pqp_vre_shd.g_old_rec.vre_information11

473: => pqp_vre_shd.g_old_rec.vre_information9
474: ,p_vre_information10_o
475: => pqp_vre_shd.g_old_rec.vre_information10
476: ,p_vre_information11_o
477: => pqp_vre_shd.g_old_rec.vre_information11
478: ,p_vre_information12_o
479: => pqp_vre_shd.g_old_rec.vre_information12
480: ,p_vre_information13_o
481: => pqp_vre_shd.g_old_rec.vre_information13

Line 479: => pqp_vre_shd.g_old_rec.vre_information12

475: => pqp_vre_shd.g_old_rec.vre_information10
476: ,p_vre_information11_o
477: => pqp_vre_shd.g_old_rec.vre_information11
478: ,p_vre_information12_o
479: => pqp_vre_shd.g_old_rec.vre_information12
480: ,p_vre_information13_o
481: => pqp_vre_shd.g_old_rec.vre_information13
482: ,p_vre_information14_o
483: => pqp_vre_shd.g_old_rec.vre_information14

Line 481: => pqp_vre_shd.g_old_rec.vre_information13

477: => pqp_vre_shd.g_old_rec.vre_information11
478: ,p_vre_information12_o
479: => pqp_vre_shd.g_old_rec.vre_information12
480: ,p_vre_information13_o
481: => pqp_vre_shd.g_old_rec.vre_information13
482: ,p_vre_information14_o
483: => pqp_vre_shd.g_old_rec.vre_information14
484: ,p_vre_information15_o
485: => pqp_vre_shd.g_old_rec.vre_information15

Line 483: => pqp_vre_shd.g_old_rec.vre_information14

479: => pqp_vre_shd.g_old_rec.vre_information12
480: ,p_vre_information13_o
481: => pqp_vre_shd.g_old_rec.vre_information13
482: ,p_vre_information14_o
483: => pqp_vre_shd.g_old_rec.vre_information14
484: ,p_vre_information15_o
485: => pqp_vre_shd.g_old_rec.vre_information15
486: ,p_vre_information16_o
487: => pqp_vre_shd.g_old_rec.vre_information16

Line 485: => pqp_vre_shd.g_old_rec.vre_information15

481: => pqp_vre_shd.g_old_rec.vre_information13
482: ,p_vre_information14_o
483: => pqp_vre_shd.g_old_rec.vre_information14
484: ,p_vre_information15_o
485: => pqp_vre_shd.g_old_rec.vre_information15
486: ,p_vre_information16_o
487: => pqp_vre_shd.g_old_rec.vre_information16
488: ,p_vre_information17_o
489: => pqp_vre_shd.g_old_rec.vre_information17

Line 487: => pqp_vre_shd.g_old_rec.vre_information16

483: => pqp_vre_shd.g_old_rec.vre_information14
484: ,p_vre_information15_o
485: => pqp_vre_shd.g_old_rec.vre_information15
486: ,p_vre_information16_o
487: => pqp_vre_shd.g_old_rec.vre_information16
488: ,p_vre_information17_o
489: => pqp_vre_shd.g_old_rec.vre_information17
490: ,p_vre_information18_o
491: => pqp_vre_shd.g_old_rec.vre_information18

Line 489: => pqp_vre_shd.g_old_rec.vre_information17

485: => pqp_vre_shd.g_old_rec.vre_information15
486: ,p_vre_information16_o
487: => pqp_vre_shd.g_old_rec.vre_information16
488: ,p_vre_information17_o
489: => pqp_vre_shd.g_old_rec.vre_information17
490: ,p_vre_information18_o
491: => pqp_vre_shd.g_old_rec.vre_information18
492: ,p_vre_information19_o
493: => pqp_vre_shd.g_old_rec.vre_information19

Line 491: => pqp_vre_shd.g_old_rec.vre_information18

487: => pqp_vre_shd.g_old_rec.vre_information16
488: ,p_vre_information17_o
489: => pqp_vre_shd.g_old_rec.vre_information17
490: ,p_vre_information18_o
491: => pqp_vre_shd.g_old_rec.vre_information18
492: ,p_vre_information19_o
493: => pqp_vre_shd.g_old_rec.vre_information19
494: ,p_vre_information20_o
495: => pqp_vre_shd.g_old_rec.vre_information20

Line 493: => pqp_vre_shd.g_old_rec.vre_information19

489: => pqp_vre_shd.g_old_rec.vre_information17
490: ,p_vre_information18_o
491: => pqp_vre_shd.g_old_rec.vre_information18
492: ,p_vre_information19_o
493: => pqp_vre_shd.g_old_rec.vre_information19
494: ,p_vre_information20_o
495: => pqp_vre_shd.g_old_rec.vre_information20
496: );
497: --

Line 495: => pqp_vre_shd.g_old_rec.vre_information20

491: => pqp_vre_shd.g_old_rec.vre_information18
492: ,p_vre_information19_o
493: => pqp_vre_shd.g_old_rec.vre_information19
494: ,p_vre_information20_o
495: => pqp_vre_shd.g_old_rec.vre_information20
496: );
497: --
498: exception
499: --

Line 516: ,p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type

512: -- ----------------------------------------------------------------------------
513: PROCEDURE del
514: (p_effective_date IN DATE
515: ,p_datetrack_mode IN VARCHAR2
516: ,p_rec IN OUT NOCOPY pqp_vre_shd.g_rec_type
517: ) IS
518: --
519: l_proc varchar2(72) := g_package||'del';
520: l_validation_start_date date;

Line 532: pqp_vre_shd.lck

528: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);
529: --
530: -- We must lock the row which we need to delete.
531: --
532: pqp_vre_shd.lck
533: (p_effective_date => p_effective_date
534: ,p_datetrack_mode => p_datetrack_mode
535: ,p_vehicle_repository_id => p_rec.vehicle_repository_id
536: ,p_object_version_number => p_rec.object_version_number

Line 601: l_rec pqp_vre_shd.g_rec_type;

597: ,p_effective_start_date OUT NOCOPY DATE
598: ,p_effective_end_date OUT NOCOPY DATE
599: ) IS
600: --
601: l_rec pqp_vre_shd.g_rec_type;
602: l_proc varchar2(72) := g_package||'del';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);