DBA Data[Home] [Help]

APPS.PQP_PL_VEHICLE_REPOSITORY_API dependencies on HR_API

Line 372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2

368: ,p_effective_date in date
369: ,p_datetrack_mode in varchar2
370: ,p_vehicle_repository_id in number
371: ,p_object_version_number in out NOCOPY number
372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2

Line 373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2

369: ,p_datetrack_mode in varchar2
370: ,p_vehicle_repository_id in number
371: ,p_object_version_number in out NOCOPY number
372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number

Line 374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2

370: ,p_vehicle_repository_id in number
371: ,p_object_version_number in out NOCOPY number
372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2

Line 375: ,p_business_group_id in number default hr_api.g_number

371: ,p_object_version_number in out NOCOPY number
372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2

Line 376: ,p_make in varchar2 default hr_api.g_varchar2

372: ,p_vehicle_registration_number in varchar2 default hr_api.g_varchar2
373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2

Line 377: ,p_engine_capacity_in_cc in number default hr_api.g_number

373: ,p_vehicle_type in varchar2 default hr_api.g_varchar2
374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2

Line 378: ,p_fuel_type in varchar2 default hr_api.g_varchar2

374: ,p_vehicle_body_number in varchar2 default hr_api.g_varchar2
375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2

Line 379: ,p_currency_code in varchar2 default hr_api.g_varchar2

375: ,p_business_group_id in number default hr_api.g_number
376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date

Line 380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2

376: ,p_make in varchar2 default hr_api.g_varchar2
377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date

Line 381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2

377: ,p_engine_capacity_in_cc in number default hr_api.g_number
378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number

Line 382: ,p_model in varchar2 default hr_api.g_varchar2

378: ,p_fuel_type in varchar2 default hr_api.g_varchar2
379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number

Line 383: ,p_initial_registration in date default hr_api.g_date

379: ,p_currency_code in varchar2 default hr_api.g_varchar2
380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number

Line 384: ,p_last_registration_renew_date in date default hr_api.g_date

380: ,p_vehicle_status in varchar2 default hr_api.g_varchar2
381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number

Line 385: ,p_list_price in number default hr_api.g_number

381: ,p_vehicle_inactivity_reason in varchar2 default hr_api.g_varchar2
382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number

Line 386: ,p_accessory_value_at_startdate in number default hr_api.g_number

382: ,p_model in varchar2 default hr_api.g_varchar2
383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2

Line 387: ,p_accessory_value_added_later in number default hr_api.g_number

383: ,p_initial_registration in date default hr_api.g_date
384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2

Line 388: ,p_market_value_classic_car in number default hr_api.g_number

384: ,p_last_registration_renew_date in date default hr_api.g_date
385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2

Line 389: ,p_fiscal_ratings in number default hr_api.g_number

385: ,p_list_price in number default hr_api.g_number
386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2

Line 390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2

386: ,p_accessory_value_at_startdate in number default hr_api.g_number
387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2

Line 391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2

387: ,p_accessory_value_added_later in number default hr_api.g_number
388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2

Line 392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2

388: ,p_market_value_classic_car in number default hr_api.g_number
389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date

Line 393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2

389: ,p_fiscal_ratings in number default hr_api.g_number
390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2

Line 394: ,p_asset_number in varchar2 default hr_api.g_varchar2

390: ,p_fiscal_ratings_uom in varchar2 default hr_api.g_varchar2
391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2

Line 395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2

391: ,p_vehicle_provider in varchar2 default hr_api.g_varchar2
392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date

Line 396: ,p_lease_contract_expiry_date in date default hr_api.g_date

392: ,p_vehicle_ownership in varchar2 default hr_api.g_varchar2
393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2

Line 397: ,p_taxation_method in varchar2 default hr_api.g_varchar2

393: ,p_shared_vehicle in varchar2 default hr_api.g_varchar2
394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number

Line 398: ,p_fleet_info in varchar2 default hr_api.g_varchar2

394: ,p_asset_number in varchar2 default hr_api.g_varchar2
395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number

Line 399: ,p_fleet_transfer_date in date default hr_api.g_date

395: ,p_lease_contract_number in varchar2 default hr_api.g_varchar2
396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2

Line 400: ,p_color in varchar2 default hr_api.g_varchar2

396: ,p_lease_contract_expiry_date in date default hr_api.g_date
397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number

Line 401: ,p_seating_capacity in number default hr_api.g_number

397: ,p_taxation_method in varchar2 default hr_api.g_varchar2
398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2

Line 402: ,p_weight in number default hr_api.g_number

398: ,p_fleet_info in varchar2 default hr_api.g_varchar2
399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date

Line 403: ,p_weight_uom in varchar2 default hr_api.g_varchar2

399: ,p_fleet_transfer_date in date default hr_api.g_date
400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2

Line 404: ,p_year_of_manufacture in number default hr_api.g_number

400: ,p_color in varchar2 default hr_api.g_varchar2
401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2

Line 405: ,p_insurance_number in varchar2 default hr_api.g_varchar2

401: ,p_seating_capacity in number default hr_api.g_number
402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2

Line 406: ,p_insurance_expiry_date in date default hr_api.g_date

402: ,p_weight in number default hr_api.g_number
403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2

Line 407: ,p_comments in varchar2 default hr_api.g_varchar2

403: ,p_weight_uom in varchar2 default hr_api.g_varchar2
404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2

Line 408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2

404: ,p_year_of_manufacture in number default hr_api.g_number
405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2

Line 409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2

405: ,p_insurance_number in varchar2 default hr_api.g_varchar2
406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2

Line 410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2

406: ,p_insurance_expiry_date in date default hr_api.g_date
407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2

Line 411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2

407: ,p_comments in varchar2 default hr_api.g_varchar2
408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2

Line 412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2

408: ,p_vre_attribute_category in varchar2 default hr_api.g_varchar2
409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2

Line 413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2

409: ,p_vre_attribute1 in varchar2 default hr_api.g_varchar2
410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2

Line 414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2

410: ,p_vre_attribute2 in varchar2 default hr_api.g_varchar2
411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2

Line 415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2

411: ,p_vre_attribute3 in varchar2 default hr_api.g_varchar2
412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2

Line 416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2

412: ,p_vre_attribute4 in varchar2 default hr_api.g_varchar2
413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2

Line 417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2

413: ,p_vre_attribute5 in varchar2 default hr_api.g_varchar2
414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2

Line 418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2

414: ,p_vre_attribute6 in varchar2 default hr_api.g_varchar2
415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2

Line 419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2

415: ,p_vre_attribute7 in varchar2 default hr_api.g_varchar2
416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2

Line 420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2

416: ,p_vre_attribute8 in varchar2 default hr_api.g_varchar2
417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2

Line 421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2

417: ,p_vre_attribute9 in varchar2 default hr_api.g_varchar2
418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2

Line 422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2

418: ,p_vre_attribute10 in varchar2 default hr_api.g_varchar2
419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2

Line 423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2

419: ,p_vre_attribute11 in varchar2 default hr_api.g_varchar2
420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2

Line 424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2

420: ,p_vre_attribute12 in varchar2 default hr_api.g_varchar2
421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2

Line 425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2

421: ,p_vre_attribute13 in varchar2 default hr_api.g_varchar2
422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2

Line 426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2

422: ,p_vre_attribute14 in varchar2 default hr_api.g_varchar2
423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2

Line 427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2

423: ,p_vre_attribute15 in varchar2 default hr_api.g_varchar2
424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2

Line 428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2

424: ,p_vre_attribute16 in varchar2 default hr_api.g_varchar2
425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2

Line 429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2

425: ,p_vre_attribute17 in varchar2 default hr_api.g_varchar2
426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2

Line 430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2

426: ,p_vre_attribute18 in varchar2 default hr_api.g_varchar2
427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2

Line 431: ,p_owner in varchar2 default hr_api.g_varchar2

427: ,p_vre_attribute19 in varchar2 default hr_api.g_varchar2
428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2

Line 432: ,p_engine_number in varchar2 default hr_api.g_varchar2

428: ,p_vre_attribute20 in varchar2 default hr_api.g_varchar2
429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2
436: ,p_effective_start_date out NOCOPY date

Line 433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2

429: ,p_vre_information_category in varchar2 default hr_api.g_varchar2
430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2
436: ,p_effective_start_date out NOCOPY date
437: ,p_effective_end_date out NOCOPY date

Line 434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2

430: ,p_vehicle_card_id_number in varchar2 default hr_api.g_varchar2
431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2
436: ,p_effective_start_date out NOCOPY date
437: ,p_effective_end_date out NOCOPY date
438: );

Line 435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2

431: ,p_owner in varchar2 default hr_api.g_varchar2
432: ,p_engine_number in varchar2 default hr_api.g_varchar2
433: ,p_date_of_first_inspection in varchar2 default hr_api.g_varchar2
434: ,p_date_of_next_inspection in varchar2 default hr_api.g_varchar2
435: ,p_other_technical_information in varchar2 default hr_api.g_varchar2
436: ,p_effective_start_date out NOCOPY date
437: ,p_effective_end_date out NOCOPY date
438: );
439: