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_SS_VEHICLE_TRANSACTIONS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 49


 SELECT COUNT(1)
 FROM pqp_veh_repos_info_types ait, fnd_descr_flex_contexts_vl flv
 WHERE ait.information_type = flv.descriptive_flex_context_code
  AND flv.descriptive_flexfield_name IN ( 'Vehicle Repos Extra Info DDF'
        ,'Vehicle Alloc Extra Info DDF')
   AND flv.enabled_flag = 'Y'
   AND exists (  SELECT NULL
   FROM per_info_type_security its,
        pqp_veh_repos_info_types ait
  WHERE its.info_type_table_name IN ( 'PQP_VEH_REPOS_INFO_TYPES'
                       ,'PQP_VEH_ALLOC_INFO_TYPES')
   AND its.information_type = ait.information_type
   AND  responsibility_id = l_responsibility_id  );

Line: 109


    select hats.transaction_id
    from   hr_api_transaction_steps  hats
    where  hats.transaction_step_id = p_transaction_step_id;

Line: 132


PROCEDURE delete_process (
    p_validate             IN BOOLEAN
   ,p_effective_date         IN DATE
   ,p_person_id              IN NUMBER
   ,p_assignment_id          IN NUMBER
   ,p_business_group_id      IN NUMBER
   ,p_vehicle_allocation_id  IN NUMBER
   ,p_error_status           OUT NOCOPY VARCHAR2
                      )
--
--
IS

l_person_id             NUMBER;

Line: 154


SELECT pva.object_version_number
      ,pva.vehicle_repository_id repository_id
  FROM pqp_vehicle_allocations_f pva
 WHERE pva.vehicle_allocation_id =cp_allocation_id
   AND pva.assignment_id =cp_assignment_id
   AND pva.business_group_id =cp_business_group_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 169


SELECT COUNT(pva.vehicle_repository_id) usr_count
  FROM pqp_vehicle_allocations_f pva
 WHERE pva.vehicle_repository_id = cp_repository_id
   AND pva.business_group_id =cp_business_group_id
   AND pva.assignment_id    = cp_assignment_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 182


SELECT pvr.object_version_number ovn
  FROM pqp_vehicle_repository_f pvr
 WHERE pvr.vehicle_repository_id = cp_repository_id
   AND pvr.business_group_id     = cp_business_group_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pvr.effective_start_date
                             AND pvr.effective_end_date;

Line: 213


   PQP_VEHICLE_ALLOCATIONS_API.delete_vehicle_allocation(
           p_validate                       => p_validate
          ,p_effective_date                 => ltrim(rtrim(p_effective_date))
          ,p_datetrack_mode                 =>'DELETE'
          ,p_vehicle_allocation_id          =>p_vehicle_allocation_id
          ,p_object_version_number          =>l_get_ovn.object_version_number
          ,p_effective_start_date           =>l_effective_start_date
          ,p_effective_end_date             =>l_effective_end_date
         );

Line: 233


  pqp_vehicle_repository_api.delete_vehicle
  (p_validate                         =>     p_validate
  ,p_effective_date                   =>     ltrim(rtrim(p_effective_date))
  ,p_datetrack_mode                   =>     'DELETE'
  ,p_vehicle_repository_id            =>     l_get_ovn.repository_id
  ,p_object_version_number            =>     l_get_rep_ovn.ovn
  ,p_effective_start_date             =>     l_effective_start_date
  ,p_effective_end_date               =>     l_effective_end_date
  );

Line: 252


PROCEDURE update_transaction_itemkey (
      itemtype        IN     VARCHAR2,
      itemkey         IN     VARCHAR2,
      actid           IN     NUMBER,
      funcmode        IN     VARCHAR2,
       result          OUT NOCOPY    VARCHAR2 )

 IS
 l_transaction_id  number;

Line: 279


  UPDATE hr_api_transactions hat
  set hat.item_key = itemkey
  WHERE hat.transaction_id=l_transaction_id;

Line: 283


  UPDATE hr_api_transaction_steps hats
  set hats.item_key = itemkey
  WHERE hats.transaction_id=l_transaction_id;

Line: 294


   SELECT Vehtrn.*,lkp.meaning vehicletype from (SELECT
   hr_transaction_api.get_number_Value
              (  p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
  ,hr_transaction_api.get_number_Value
              (  p_transaction_step_id, 'P_PERSON_ID' ) person_id
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
  ,hr_transaction_api.get_date_Value
              (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id ,'P_ITEM_TYPE')  item_type
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id, 'P_item_key') item_key
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_MAKE') make
  ,hr_transaction_api.get_number_Value
              (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
  , hr_transaction_api.get_number_Value
              (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
  ,hr_transaction_api.get_date_Value
              (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_MODEL' ) model
  ,hr_transaction_api.get_number_value
                  (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
   FROM DUAL)  Vehtrn
               ,hr_lookups lkp
          WHERE vehtrn.vehicle_type=lkp.lookup_code
            AND lkp.lookup_type='PQP_VEHICLE_TYPE' ;

Line: 358


 SELECT DISTINCT  (a.number_value) person_usr_id
       , b.number_value assignment_usr_id
       , c.varchar2_value usr_type
    FROM hr_api_transaction_steps s,
         hr_api_transaction_values a,
         hr_api_transaction_steps s1,
         hr_api_transaction_values b,
         hr_api_transaction_steps s2,
         hr_api_transaction_values c
   WHERE s.transaction_step_id = a.transaction_step_id
     AND s1.transaction_step_id = b.transaction_step_id
     AND s2.transaction_step_id = c.transaction_step_id
     AND s.transaction_step_id = p_transaction_step_id
     AND s.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
     AND a.name like 'P_PERSON_USR_ID%'
     AND s1.transaction_step_id = p_transaction_step_id
     AND s1.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
     AND b.name like 'P_ASSIGNMENT_USR_ID%'
     AND s2.transaction_step_id = p_transaction_step_id
     AND s2.api_name = 'PQP_SS_VEHICLE_TRANSACTIONS.PROCESS_API'
     AND c.name like 'P_USER_TYPE%'
     AND substr(a.name,-1) =  substr(b.name,-1)
     AND substr(a.name,-1) =  substr(c.name,-1);

Line: 394


  SELECT
   hr_transaction_api.get_number_Value
                  (p_transaction_step_id,'P_LOGIN_PERSON_ID') login_person_id
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_PERSON_ID' ) person_id
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id,'P_ASSIGNMENT_ID') assignment_id
  ,hr_transaction_api.get_date_Value
                  (p_transaction_step_id, 'P_EFFECTIVE_DATE' ) effective_date
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id ,'P_ITEM_TYPE')  item_type
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_item_key') item_key
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_ACTIVITY_ID' ) activity_id
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id,'P_REGISTRATION_NUMBER') registration_number
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_VEHICLE_OWNERSHIP') vehicle_ownership
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_VEHICLE_ID_NUMBER') vehicle_id_number
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_BUSINESS_GROUP_ID') business_group_id
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_MAKE') make
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_ENGINE_CAPACITY_IN_CC') engine_capacity_in_cc
  , hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_MODEL_YEAR' ) model_year
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_INSURANCE_NUMBER' ) insurance_number
  ,hr_transaction_api.get_date_Value
                  (p_transaction_step_id, 'P_INSURANCE_EXPIRY_DATE') insurance_expiry_date
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_MODEL' ) model
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_FUEL_TYPE' ) fuel_type
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_VEHICLE_REPOSITORY_ID' ) vehicle_repository_id
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_OBJECT_VERSION_NUMBER') object_version_number
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_CURRENCY_CODE') currency_code
  ,hr_transaction_api.get_date_Value
                  (p_transaction_step_id, 'P_INITIAL_REGISTRATION') initial_registration
  ,hr_transaction_api.get_date_Value
                  (p_transaction_step_id, 'P_LAST_REGISTRATION_RENEW_DATE' )
                   last_registration_renew_date
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_FISCAL_RATINGS' ) fiscal_ratings
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_SHARED_VEHICLE' ) shared_vehicle
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_COLOR' ) color
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_SEATING_CAPACITY' ) seating_capacity
  ,hr_transaction_api.get_number_Value
                  (p_transaction_step_id, 'P_WEIGHT' ) weight
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_WEIGHT_UOM' ) weight_uom
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_TAXATION_METHOD' ) taxation_method
  ,hr_transaction_api.get_varchar2_Value
                  (p_transaction_step_id, 'P_COMMENTS' ) comments
   ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE_CATEGORY')
                  vre_attribute_category
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE1') vre_attribute1
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE2') vre_attribute2
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE3') vre_attribute3
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE4') vre_attribute4
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE5') vre_attribute5
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE6') vre_attribute6
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE7') vre_attribute7
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE8') vre_attribute8
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE9') vre_attribute9
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE10') vre_attribute10
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE11')vre_attribute11
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE12') vre_attribute12
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE13') vre_attribute13
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE14') vre_attribute14
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE15') vre_attribute15
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id,  'P_VRE_ATTRIBUTE16') vre_attribute16
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE17') vre_attribute17
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE18') vre_attribute18
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE19') vre_attribute19
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_ATTRIBUTE20') vre_attribute20
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION_CATEGORY')
                   vre_information_category
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION1') vre_information1
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION2') vre_information2
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION3') vre_information3
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION4') vre_information4
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION5') vre_information5
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION6') vre_information6
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION7') vre_information7
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION8') vre_information8
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION9') vre_information9
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION10') vre_information10
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION11') vre_information11
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION12') vre_information12
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION13') vre_information13
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION14') vre_information14
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION15') vre_information15
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION16') vre_information16
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION17') vre_information17
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION18') vre_information18
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION19') vre_information19
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VRE_INFORMATION20') vre_information20
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_ACROSS_ASSIGNMENTS') across_assignments
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_USAGE_TYPE') usage_type
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_DEFAULT_VEHICLE') default_vehicle
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_FUEL_CARD') fuel_card
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_FUEL_CARD_NUMBER') fuel_card_number
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_FUEL_BENEFIT') fuel_benefit
  ,hr_transaction_api.get_number_value
                  (p_transaction_step_id, 'P_VEHICLE_ALLOCATION_ID') vehicle_allocation_id
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE_CATEGORY')
                  val_attribute_category
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE1') val_attribute1
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE2') val_attribute2
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE3') val_attribute3
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE4') val_attribute4
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE5') val_attribute5
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE6') val_attribute6
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE7') val_attribute7
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE8') val_attribute8
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE9') val_attribute9
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE10') val_attribute10
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE11') val_attribute11
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE12') val_attribute12
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE13') val_attribute13
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE14') val_attribute14
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE15') val_attribute15
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE16') val_attribute16
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE17') val_attribute17
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE18') val_attribute18
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE19') val_attribute19
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_ATTRIBUTE20') val_attribute20
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION_CATEGORY')
                   val_information_category
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION1') val_information1
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION2') val_information2
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION3') val_information3
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION4') val_information4
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION5') val_information5
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION6') val_information6
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION7') val_information7
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION8') val_information8
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION9') val_information9
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION10') val_information10
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION11') val_information11
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION12') val_information12
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION13') val_information13
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION14') val_information14
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION15') val_information15
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION16') val_information16
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION17') val_information17
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION18') val_information18
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION19') val_information19
  ,hr_transaction_api.get_varchar2_value
                  (p_transaction_step_id, 'P_VAL_INFORMATION20') val_information20
  FROM DUAL;

Line: 659


PROCEDURE update_vehicle_allocations
  (p_validate                     in     boolean
  ,p_effective_date               in     date
  ,p_business_group_id            in     number
  ,p_registration_number          in     varchar2
  ,p_vehicle_repository_id        in     number
  ,p_across_assignments           in     varchar2
  ,p_usage_type                   in     varchar2
  ,p_default_vehicle              in     varchar2
  ,p_fuel_card                    in     varchar2
  ,p_fuel_card_number             in     varchar2
  ,p_insurance_number             in     varchar2
  ,p_insurance_expiry_date        in     date
  ,p_val_attribute_category       in     varchar2
  ,p_val_attribute1               in     varchar2
  ,p_val_attribute2               in     varchar2
  ,p_val_attribute3               in     varchar2
  ,p_val_attribute4               in     varchar2
  ,p_val_attribute5               in     varchar2
  ,p_val_attribute6               in     varchar2
  ,p_val_attribute7               in     varchar2
  ,p_val_attribute8               in     varchar2
  ,p_val_attribute9               in     varchar2
  ,p_val_attribute10              in     varchar2
  ,p_val_attribute11              in     varchar2
  ,p_val_attribute12              in     varchar2
  ,p_val_attribute13              in     varchar2
  ,p_val_attribute14              in     varchar2
  ,p_val_attribute15              in     varchar2
  ,p_val_attribute16              in     varchar2
  ,p_val_attribute17              in     varchar2
  ,p_val_attribute18              in     varchar2
  ,p_val_attribute19              in     varchar2
  ,p_val_attribute20              in     varchar2
  ,p_val_information_category     in     varchar2
  ,p_val_information1             in     varchar2
  ,p_val_information2             in     varchar2
  ,p_val_information3             in     varchar2
  ,p_val_information4             in     varchar2
  ,p_val_information5             in     varchar2
  ,p_val_information6             in     varchar2
  ,p_val_information7             in     varchar2
  ,p_val_information8             in     varchar2
  ,p_val_information9             in     varchar2
  ,p_val_information10            in     varchar2
  ,p_val_information11            in     varchar2
  ,p_val_information12            in     varchar2
  ,p_val_information13            in     varchar2
  ,p_val_information14            in     varchar2
  ,p_val_information15            in     varchar2
  ,p_val_information16            in     varchar2
  ,p_val_information17            in     varchar2
  ,p_val_information18            in     varchar2
  ,p_val_information19            in     varchar2
  ,p_val_information20            in     varchar2
  ,p_fuel_benefit                 in     varchar2
  ,p_user_info                    in     t_user_info
  ,p_error_message                in     varchar2
  )
IS


lc_object_version_number  NUMBER;

Line: 741


SELECT pva.assignment_id ,
       pva.vehicle_allocation_id allocation_id
 FROM pqp_vehicle_allocations_f pva
     ,pqp_vehicle_repository_f pvr
WHERE pvr.registration_number = cp_registration_number
  AND pvr.business_group_id = cp_business_group_id
  AND pvr.business_group_id=pva.business_group_id
  AND pvr.vehicle_repository_id=pva.vehicle_repository_id
  AND cp_effective_date BETWEEN pvr.effective_start_date
                            AND pvr.effective_end_date
  AND cp_effective_date BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 762


SELECT pva.object_version_number
  FROM pqp_vehicle_allocations_f pva
 WHERE pva.vehicle_allocation_id =cp_vehicle_allocation_id
   AND pva.assignment_id = cp_assignment_id
   AND pva.business_group_id = cp_business_group_id
   AND cp_effective_date BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 776


SELECT pvr.vehicle_repository_id
  FROM pqp_vehicle_repository_f pvr
 WHERE pvr.registration_number = cp_registration_number
   AND pvr.business_group_id = cp_business_group_id
   AND cp_effective_date BETWEEN pvr.effective_start_date
                            AND pvr.effective_end_date;

Line: 791


l_update                    NUMBER;

Line: 792


l_update_override           NUMBER;

Line: 793


l_update_change_insert      NUMBER;

Line: 977


   pqp_vehicle_allocations_api.delete_vehicle_allocation
    (p_validate                     => p_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => 'DELETE'
    ,p_vehicle_allocation_id        => l_del_assignment_tab(i).allocation_id
    ,p_object_version_number        => lc_object_version_number
    ,p_effective_start_date         => l_effective_start_date
    ,p_effective_end_date           => l_effective_end_date
    );

Line: 1014


   ,p_update                 =>l_update
   ,p_update_override        =>l_update_override
   ,p_update_change_insert   =>l_update_change_insert
   );

Line: 1021


   ELSIF l_update = 1 THEN
    l_datetrack_mode :='UPDATE' ;

Line: 1027


  pqp_vehicle_allocations_api.update_vehicle_allocation
    (p_validate                     => p_validate
    ,p_effective_date               => p_effective_date
    ,p_datetrack_mode               => l_datetrack_mode
    ,p_vehicle_allocation_id        => l_user_info(i).allocation_id
    ,p_object_version_number        => lc_object_version_number
    ,p_assignment_id                => l_user_info(i).assignment_id
    ,p_business_group_id            => p_business_group_id
    ,p_across_assignments           => p_across_assignments
    ,p_usage_type                   => p_usage_type
    ,p_default_vehicle              => p_default_vehicle
    ,p_fuel_card                    => p_fuel_card
    ,p_fuel_card_number             => p_fuel_card_number
    ,p_insurance_number             => p_insurance_number
    ,p_insurance_expiry_date        => p_insurance_expiry_date
    ,p_val_attribute_category       => p_val_attribute_category
    ,p_val_attribute1               => p_val_attribute1
    ,p_val_attribute2               => p_val_attribute2
    ,p_val_attribute3               => p_val_attribute3
    ,p_val_attribute4               => p_val_attribute4
    ,p_val_attribute5               => p_val_attribute5
    ,p_val_attribute6               => p_val_attribute6
    ,p_val_attribute7               => p_val_attribute7
    ,p_val_attribute8               => p_val_attribute8
    ,p_val_attribute9               => p_val_attribute9
    ,p_val_attribute10              => p_val_attribute10
    ,p_val_attribute11              => p_val_attribute11
    ,p_val_attribute12              => p_val_attribute12
    ,p_val_attribute13              => p_val_attribute13
    ,p_val_attribute14              => p_val_attribute14
    ,p_val_attribute15              => p_val_attribute15
    ,p_val_attribute16              => p_val_attribute16
    ,p_val_attribute17              => p_val_attribute17
    ,p_val_attribute18              => p_val_attribute18
    ,p_val_attribute19              => p_val_attribute19
    ,p_val_attribute20              => p_val_attribute20
    ,p_val_information1             => p_val_information1
    ,p_val_information2             => p_val_information2
    ,p_val_information3             => p_val_information3
    ,p_val_information4             => p_val_information4
    ,p_val_information5             => p_val_information5
    ,p_val_information6             => p_val_information6
    ,p_val_information7             => p_val_information7
    ,p_val_information8             => p_val_information8
    ,p_val_information9             => p_val_information9
    ,p_val_information10            => p_val_information10
    ,p_val_information11            => p_val_information11
    ,p_val_information12            => p_val_information12
    ,p_val_information13            => p_val_information13
    ,p_val_information14            => p_val_information14
    ,p_val_information15            => p_val_information15
    ,p_val_information16            => p_val_information16
    ,p_val_information17            => p_val_information17
    ,p_val_information18            => p_val_information18
    ,p_val_information19            => p_val_information19
    ,p_val_information20            => p_val_information20
    ,p_fuel_benefit                 => p_fuel_benefit
    ,p_effective_start_date         => l_effective_start_date
    ,p_effective_end_date           => l_effective_end_date
    );

Line: 1089


END update_vehicle_allocations;

Line: 1229


SELECT paa.assignment_id
 FROM per_all_assignments_f paa
WHERE paa.person_id = cp_person_id
  AND paa.primary_flag ='Y'
  AND paa.business_group_id = cp_business_group_id
  AND cp_effective_date BETWEEN paa.effective_start_date
                            AND paa.effective_end_date;

Line: 1244


SELECT paa.assignment_id
 FROM per_all_assignments_f paa
WHERE paa.person_id = cp_person_id
  AND paa.assignment_id <> cp_assignment_id
  AND paa.business_group_id = cp_business_group_id
  AND cp_effective_date BETWEEN paa.effective_start_date
                            AND paa.effective_end_date;

Line: 1253


   SELECT hrl.lookup_code
     FROM hr_lookups hrl
    WHERE lookup_type = 'PQP_FISCAL_RATINGS_UOM'
      AND enabled_flag    = 'Y';

Line: 1263


SELECT pvr.vehicle_repository_id
      ,pvr.object_version_number
      ,pvr.shared_vehicle
 FROM pqp_vehicle_repository_f pvr
WHERE pvr.registration_number = cp_registration_number
  AND pvr.business_group_id = cp_business_group_id
  AND cp_effective_date BETWEEN pvr.effective_start_date
                            AND pvr.effective_end_date;

Line: 1283


l_update                   NUMBER;

Line: 1284


l_update_override          NUMBER;

Line: 1285


l_update_change_insert     NUMBER;

Line: 1456


				SELECT COUNT(1)
				  INTO l_count
				  FROM pqp_vehicle_allocations_f pvf
 				 WHERE pvf.vehicle_repository_id = l_vehicle_repository_id
				   AND pvf.assignment_id = l_user_info(i).assignment_id;

Line: 1548


  ,p_update                 => l_update
  ,p_update_override        => l_update_override
  ,p_update_change_insert   => l_update_change_insert
  );

Line: 1555


  ELSIF l_update = 1 THEN
   l_datetrack_mode :='UPDATE' ;

Line: 1560


    <>
  BEGIN
  --Checking to see if the shared_vehicle is switched from Yes to No
  --This will reverse the process of calling the API as
  -- we need to end date all the allocations for the additional
  --users and then comeback to update the vehicle repository
  --by incrementing the update date by one. Without incrementing
  --the date the api will give an error because the end dated
  --allocation will fall on the same day when updating vehicle
  --repository with flag 'N' and this would give an error.
   IF l_get_repository_id.shared_vehicle ='Y'
    AND p_shared_vehicle ='N' AND l_chk<>2THEN
    RAISE e_exist_other_asg;

Line: 1575


   pqp_vehicle_repository_api.update_vehicle
    (p_validate                     => p_validate
    ,p_effective_date               => p_effective_date+(l_dt_adj)
    ,p_datetrack_mode               => l_datetrack_mode
    ,p_vehicle_repository_id        => l_get_repository_id.vehicle_repository_id
    ,p_object_version_number        => l_object_version_number
    ,p_registration_number          => p_registration_number
    ,p_vehicle_type                 => p_vehicle_type
    ,p_vehicle_id_number            => p_vehicle_id_number
    ,p_business_group_id            => p_business_group_id
    ,p_make                         => p_make
    ,p_engine_capacity_in_cc        => p_engine_capacity_in_cc
    ,p_fuel_type                    => p_fuel_type
    ,p_currency_code                => p_currency_code
    ,p_vehicle_status               => 'A'
    ,p_model                        => p_model
    ,p_initial_registration         => p_initial_registration
    ,p_last_registration_renew_date => p_last_registration_renew_date
    ,p_fiscal_ratings               => p_fiscal_ratings
    ,p_fiscal_ratings_uom           => l_lookup_code
    ,p_vehicle_ownership            => p_vehicle_ownership
    ,p_shared_vehicle               => p_shared_vehicle
    ,p_taxation_method              => p_taxation_method
    ,p_color                        => p_color
    ,p_seating_capacity             => p_seating_capacity
    ,p_weight                       => p_weight
    ,p_weight_uom                   => p_weight_uom
    ,p_model_year                   => p_model_year
     ,p_insurance_number             => p_insurance_number
    ,p_insurance_expiry_date        => p_insurance_expiry_date
    ,p_comments                     => p_comments
    ,p_vre_attribute_category       => p_vre_attribute_category
    ,p_vre_attribute1               => p_vre_attribute1
    ,p_vre_attribute2               => p_vre_attribute2
    ,p_vre_attribute3               => p_vre_attribute3
    ,p_vre_attribute4               => p_vre_attribute4
    ,p_vre_attribute5               => p_vre_attribute5
    ,p_vre_attribute6               => p_vre_attribute6
    ,p_vre_attribute7               => p_vre_attribute7
    ,p_vre_attribute8               => p_vre_attribute8
    ,p_vre_attribute9               => p_vre_attribute9
    ,p_vre_attribute10              => p_vre_attribute10
    ,p_vre_attribute11              => p_vre_attribute11
    ,p_vre_attribute12              => p_vre_attribute12
    ,p_vre_attribute13              => p_vre_attribute13
    ,p_vre_attribute14              => p_vre_attribute14
    ,p_vre_attribute15              => p_vre_attribute15
    ,p_vre_attribute16              => p_vre_attribute16
    ,p_vre_attribute17              => p_vre_attribute17
    ,p_vre_attribute18              => p_vre_attribute18
    ,p_vre_attribute19              => p_vre_attribute19
    ,p_vre_attribute20              => p_vre_attribute20
    ,p_vre_information1             => p_vre_information1
    ,p_vre_information2             => p_vre_information2
    ,p_vre_information3             => p_vre_information3
    ,p_vre_information4             => p_vre_information4
    ,p_vre_information5             => p_vre_information5
    ,p_vre_information6             => p_vre_information6
    ,p_vre_information7             => p_vre_information7
    ,p_vre_information8             => p_vre_information8
    ,p_vre_information9             => p_vre_information9
    ,p_vre_information10            => p_vre_information10
    ,p_vre_information11            => p_vre_information11
    ,p_vre_information12            => p_vre_information12
    ,p_vre_information13            => p_vre_information13
    ,p_vre_information14            => p_vre_information14
    ,p_vre_information15            => p_vre_information15
    ,p_vre_information16            => p_vre_information16
    ,p_vre_information17            => p_vre_information17
    ,p_vre_information18            => p_vre_information18
    ,p_vre_information19            => p_vre_information19
    ,p_vre_information20            => p_vre_information20
    ,p_effective_start_date         => l_effective_start_date
    ,p_effective_end_date           => l_effective_end_date
    );

Line: 1668


   update_vehicle_allocations
    (p_validate                     => p_validate
    ,p_effective_date               => p_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_registration_number          => p_registration_number
    ,p_vehicle_repository_id        => l_get_repository_id.vehicle_repository_id
    ,p_across_assignments           => p_across_assignments
    ,p_usage_type                   => p_usage_type
    ,p_default_vehicle              => p_default_vehicle
    ,p_fuel_card                    => p_fuel_card
    ,p_fuel_card_number             => p_fuel_card_number
    ,p_insurance_number             => p_insurance_number
    ,p_insurance_expiry_date        => p_insurance_expiry_date
    ,p_val_attribute_category       => p_val_attribute_category
    ,p_val_attribute1               => p_val_attribute1
    ,p_val_attribute2               => p_val_attribute2
    ,p_val_attribute3               => p_val_attribute3
    ,p_val_attribute4               => p_val_attribute4
    ,p_val_attribute5               => p_val_attribute5
    ,p_val_attribute6               => p_val_attribute6
    ,p_val_attribute7               => p_val_attribute7
    ,p_val_attribute8               => p_val_attribute8
    ,p_val_attribute9               => p_val_attribute9
    ,p_val_attribute10              => p_val_attribute10
    ,p_val_attribute11              => p_val_attribute11
    ,p_val_attribute12              => p_val_attribute12
    ,p_val_attribute13              => p_val_attribute13
    ,p_val_attribute14              => p_val_attribute14
    ,p_val_attribute15              => p_val_attribute15
    ,p_val_attribute16              => p_val_attribute16
    ,p_val_attribute17              => p_val_attribute17
    ,p_val_attribute18              => p_val_attribute18
    ,p_val_attribute19              => p_val_attribute19
    ,p_val_attribute20              => p_val_attribute20
    ,p_val_information_category     => p_val_information_category
    ,p_val_information1             => p_val_information1
    ,p_val_information2             => p_val_information2
    ,p_val_information3             => p_val_information3
    ,p_val_information4             => p_val_information4
    ,p_val_information5             => p_val_information5
    ,p_val_information6             => p_val_information6
    ,p_val_information7             => p_val_information7
    ,p_val_information8             => p_val_information8
    ,p_val_information9             => p_val_information9
    ,p_val_information10            => p_val_information10
    ,p_val_information11            => p_val_information11
    ,p_val_information12            => p_val_information12
    ,p_val_information13            => p_val_information13
    ,p_val_information14            => p_val_information14
    ,p_val_information15            => p_val_information15
    ,p_val_information16            => p_val_information16
    ,p_val_information17            => p_val_information17
    ,p_val_information18            => p_val_information18
    ,p_val_information19            => p_val_information19
    ,p_val_information20            => p_val_information20
    ,p_fuel_benefit                 => p_fuel_benefit
    ,p_user_info                    => l_user_info
    ,p_error_message                => p_error_message
    );

Line: 1730


    GOTO update_vehicle;

Line: 2004


PROCEDURE delete_vehicle_details(
   x_p_validate             IN BOOLEAN
  ,x_effective_date         IN DATE
  ,x_login_person_id        IN NUMBER
  ,x_person_id              IN NUMBER
  ,x_assignment_id          IN NUMBER
  ,x_business_group_id      IN NUMBER
  ,x_item_key               IN NUMBER
  ,x_item_type              IN VARCHAR2
  ,x_activity_id            IN NUMBER
  ,x_vehicle_allocation_id  IN NUMBER
  ,x_status                 IN VARCHAR2
  ,x_transaction_id         IN OUT NOCOPY NUMBER
  ,x_error_status           OUT NOCOPY VARCHAR2
                      )

IS



CURSOR c_del_values
IS
SELECT transaction_step_id
 FROM  hr_api_transaction_steps hats
 WHERE transaction_id = x_transaction_id;

Line: 2036


                              := 'PQP_SS_VEHICLE_TRANSACTIONS.DELETE_PROCESS_API';

Line: 2048


   delete_process (
    p_validate               => true
   ,p_effective_date         => x_effective_date
   ,p_person_id              => x_person_id
   ,p_assignment_id          => x_assignment_id
   ,p_business_group_id      => x_business_group_id
   ,p_vehicle_allocation_id  => x_vehicle_allocation_id
   ,p_error_status           => l_error_status
                 );

Line: 2112


              ,p_selected_person_id         => x_person_id
              ,p_item_type                  => x_item_type
              ,p_item_key                   => x_item_key
              ,p_transaction_effective_date => x_effective_date
              ,p_process_name               => NULL
              ,p_plan_id                    => NULL
              ,p_rptg_grp_id                => NULL
              ,p_effective_date_option      => x_effective_date
              ,p_transaction_id             => l_transaction_id
              );

Line: 2147


   DELETE from hr_api_transaction_values
     WHERE transaction_step_id = l_del_values.transaction_step_id;

Line: 2326


SELECT transaction_step_id
 FROM  hr_api_transaction_steps hats
 WHERE transaction_id = x_transaction_id;

Line: 3276


              ,p_selected_person_id         =>x_person_id
              ,p_item_type                  =>x_item_type
              ,p_item_key                   =>x_item_key
              ,p_transaction_effective_date =>x_effective_date
              ,p_process_name               =>NULL
              ,p_plan_id                    =>NULL
              ,p_rptg_grp_id                =>NULL
              ,p_effective_date_option      =>x_effective_date_option
              ,p_transaction_id             =>l_transaction_id
              );

Line: 3312


   hr_utility.set_location('Entering update transaction :',10);

Line: 3313


   hr_transaction_api.update_transaction
           (p_transaction_id => x_transaction_id
            ,p_status         => x_status
           );

Line: 3317


   hr_utility.set_location('leaving update transaction :',15);

Line: 3323


   DELETE from hr_api_transaction_values
     WHERE transaction_step_id = l_del_values.transaction_step_id;

Line: 3326


   hr_utility.set_location('leaving delete :',25);

Line: 3412


PROCEDURE delete_process_api (
   p_validate                   IN BOOLEAN DEFAULT FALSE,
   p_transaction_step_id        IN NUMBER,
   p_effective_date             IN VARCHAR2 DEFAULT NULL ) IS
--
--
l_ovn                  NUMBER :=1;

Line: 3449


  delete_process (
    p_validate               => false
   ,p_effective_date         => l_effective_date
   ,p_person_id              => l_person_id
   ,p_assignment_id          => l_assignment_id
   ,p_business_group_id      => l_business_group_id
   ,p_vehicle_allocation_id  => l_allocation_id
   ,p_error_status           => l_error_status
                 );

Line: 3602


SELECT count(hatv.name)
  FROM hr_api_transaction_values hatv
 WHERE hatv.transaction_step_id=p_transaction_step_id
   AND hatv.name like 'P_PERSON_USR_ID%';

Line: 3613


SELECT hats.item_type,hats.item_key
  FROM hr_api_transaction_steps hats
 WHERE hats.transaction_id=l_transaction_id
   AND hats.transaction_step_id =p_transaction_step_id;

Line: 3620


SELECT pvr.vehicle_repository_id
       ,pva.vehicle_allocation_id
  FROM pqp_vehicle_repository_f pvr
       ,pqp_vehicle_allocations_f pva
 WHERE pvr.vehicle_repository_id =pva.vehicle_repository_id
   AND pva.assignment_id =l_assignment_id
   AND NVL(l_effective_date,SYSDATE) BETWEEN pvr.effective_start_date
                            AND pvr.effective_end_date
   AND NVL(l_effective_date,sysdate) BETWEEN pva.effective_start_date
                            AND pva.effective_end_date
                            AND pvr.registration_number=l_registration_number;

Line: 4296


PROCEDURE delete_allocation(
   p_validate             IN BOOLEAN
  ,p_effective_date         IN DATE
  ,p_assignment_id          IN NUMBER
  ,p_vehicle_allocation_id  IN NUMBER
  ,p_business_group_id      IN NUMBER
  ,p_error_status           OUT NOCOPY VARCHAR2
                      )

IS

 CURSOR c_get_ovn (cp_allocation_id     NUMBER
                 ,cp_business_group_id NUMBER
                 ,cp_assignment_id     NUMBER
                 ,cp_effective_date    DATE
                 )
IS
SELECT pva.object_version_number
      ,pva.vehicle_repository_id repository_id
  FROM pqp_vehicle_allocations_f pva
 WHERE pva.vehicle_allocation_id =cp_allocation_id
   AND pva.assignment_id =cp_assignment_id
   AND pva.business_group_id =cp_business_group_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 4328


SELECT COUNT(pva.vehicle_repository_id) usr_count
  FROM pqp_vehicle_allocations_f pva
 WHERE pva.vehicle_repository_id = cp_repository_id
   AND pva.business_group_id =cp_business_group_id
   AND pva.assignment_id    = cp_assignment_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pva.effective_start_date
                             AND pva.effective_end_date;

Line: 4341


SELECT pvr.object_version_number ovn
  FROM pqp_vehicle_repository_f pvr
 WHERE pvr.vehicle_repository_id = cp_repository_id
   AND pvr.business_group_id     = cp_business_group_id
   AND rtrim(ltrim(cp_effective_date)) BETWEEN pvr.effective_start_date
                             AND pvr.effective_end_date;

Line: 4378


   PQP_VEHICLE_ALLOCATIONS_API.delete_vehicle_allocation(
           p_validate                       => p_validate
          ,p_effective_date                 => ltrim(rtrim(p_effective_date))
          ,p_datetrack_mode                 =>'DELETE'
          ,p_vehicle_allocation_id          =>p_vehicle_allocation_id
          ,p_object_version_number          =>l_get_ovn.object_version_number
          ,p_effective_start_date           =>l_effective_start_date
          ,p_effective_end_date             =>l_effective_end_date
         );

Line: 4398


  pqp_vehicle_repository_api.delete_vehicle
  (p_validate                         =>     p_validate
  ,p_effective_date                   =>     ltrim(rtrim(p_effective_date))
  ,p_datetrack_mode                   =>     'DELETE'
  ,p_vehicle_repository_id            =>     l_get_ovn.repository_id
  ,p_object_version_number            =>     l_get_rep_ovn.ovn
  ,p_effective_start_date             =>     l_effective_start_date
  ,p_effective_end_date               =>     l_effective_end_date
  );

Line: 4418


END delete_allocation;