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

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

Line: 18


SELECT psvh.value conf_number
  FROM pqh_ss_value_history psvh
 WHERE psvh.name='P_CONFIRMATION_NUMBER'
   AND psvh.value IS NOT NULL
   AND psvh.step_history_id IN
    (SELECT psvh1.step_history_id
       FROM pqh_ss_value_history psvh1
      WHERE psvh1.name='P_ELEMENT_ENTRY_ID'
        AND psvh1.value =cp_element_entry_id);

Line: 71


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: 104


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

Line: 108


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

Line: 162


  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_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_OWNERSHIP') ownership
  ,hr_transaction_api.get_varchar2_Value
              (p_transaction_step_id, 'P_VEHICLE_TYPE' ) vehicle_type
  ,hr_transaction_api.get_date_Value
             (p_transaction_step_id,  'P_START_DATE') start_date
  ,hr_transaction_api.get_date_Value
             (p_transaction_step_id,  'P_END_DATE' ) end_date
  ,hr_transaction_api.get_varchar2_Value
             (p_transaction_step_id,  'P_CLAIMED_MILEAGE' ) claimed_mileage
  ,hr_transaction_api.get_varchar2_Value
             (p_transaction_step_id,  'P_ACTUAL_MILEAGE' ) actual_mileage
  ,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_ENGINE_CAPACITY' ) engine_capacity
  ,hr_transaction_api.get_varchar2_Value
             (p_transaction_step_id,  'P_FUEL_TYPE' ) fuel_type
  ,hr_transaction_api.get_varchar2_Value
             (p_transaction_step_id,  'P_FISCAL_RATINGS') fiscal_ratings
  ,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_NO_OF_PASSENGERS') no_of_passengers
  ,hr_transaction_api.get_varchar2_Value
             (p_transaction_step_id,  'P_PURPOSE') purpose
  ,hr_transaction_api.get_number_Value
             (p_transaction_step_id,  'P_ELEMENT_ENTRY_ID') element_entry_id
  ,hr_transaction_api.get_number_Value
             (p_transaction_step_id,  'P_OBJECT_VERSION_NUMBER') object_version_number
  ,hr_transaction_api.get_date_Value
             (p_transaction_step_id,  'P_EFFECTIVE_DATE') p_effective_date
 FROM dual;

Line: 307


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

Line: 367


  pqp_gb_mileage_claim_pkg.insert_mileage_claim
         (
          p_effective_date             => RTRIM(LTRIM(p_effective_date)),
          p_web_adi_identifier         => p_web_adi_identifier,
          p_info_id                    => p_info_id,
          p_time_stamp                 => p_time_stamp,
          p_assignment_id              => p_assignment_id,
          p_business_group_id          => p_business_group_id,
          p_ownership                  => p_ownership,
          p_usage_type                 => p_usage_type,
          p_vehicle_type               => p_vehicle_type,
          p_start_date                 => p_start_date,
          p_end_date                   => p_end_date,
          p_claimed_mileage            => p_claimed_mileage,
          p_actual_mileage             => p_actual_mileage,
          p_registration_number        => p_registration_number,
          p_engine_capacity            => p_engine_capacity,
          p_fuel_type                  => p_fuel_type,
          p_fiscal_ratings             => p_fiscal_ratings,
          p_no_of_passengers           => p_no_of_passengers,
          p_purpose                    => p_purpose,
          p_user_type                  => p_user_type,
          p_mileage_claim_element      => p_mileage_claim_element,
          p_element_entry_id           => p_element_entry_id,
          p_element_entry_date         => p_element_entry_date
         );

Line: 399


  pqp_gb_mileage_claim_pkg.update_mileage_claim
         (
          p_effective_date             =>  RTRIM(LTRIM(p_effective_date)),
          p_assignment_id              => p_assignment_id,
          p_business_group_id          => p_business_group_id,
          p_ownership                  => p_ownership,
          p_usage_type                 => p_usage_type,
          p_vehicle_type               => p_vehicle_type,
          p_start_date                 => p_start_date,
          p_end_date                   => p_end_date,
          p_claimed_mileage_o          => p_claimed_mileage_o,
          p_claimed_mileage            => p_claimed_mileage,
          p_actual_mileage_o           => p_actual_mileage_o,
          p_actual_mileage             => p_actual_mileage,
          p_registration_number        => p_registration_number,
          p_engine_capacity            => p_engine_capacity,
          p_fuel_type                  => p_fuel_type,
          p_fiscal_ratings             => p_fiscal_ratings,
          p_no_of_passengers           => p_no_of_passengers,
          p_purpose                    => p_purpose,
          p_mileage_claim_element      => p_mileage_claim_element,
          p_element_entry_id           => p_element_entry_id,
          p_element_entry_date         => p_element_entry_date
         );

Line: 433


PROCEDURE delete_validate_mileage_claim (
   p_effective_date         IN DATE
  ,p_assignment_id          IN NUMBER
  ,p_mileage_claim_element  IN NUMBER
  ,p_element_entry_id       IN OUT NOCOPY NUMBER
  ,p_element_entry_date     IN OUT NOCOPY DATE
  ,p_error_status           OUT NOCOPY VARCHAR2
   )

IS
pragma autonomous_transaction;

Line: 446


 pqp_mileage_claim_pkg.pqp_delete_mileage_claim
        ( p_effective_date             =>p_effective_date,
          p_assignment_id              =>p_assignment_id,
          p_mileage_claim_element      =>l_mileage_claim_element  ,
          p_element_entry_id           =>p_element_entry_id  ,
          p_element_entry_date         =>p_element_entry_date,
          p_return_status              =>p_error_status
         );

Line: 465


PROCEDURE delete_vehicle_mileage_claim(
   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_element_entry_id       IN NUMBER
  ,p_status                 IN VARCHAR2
  ,x_transaction_id         IN OUT NOCOPY NUMBER
  ,x_transaction_step_id    IN OUT NOCOPY NUMBER
  ,x_confirmation_number    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: 497


                                := 'PQP_SS_VEHICLE_MILEAGE_CLAIMS.DELETE_PROCESS_API';

Line: 513


  delete_validate_mileage_claim
     ( p_effective_date             =>x_effective_date,
       p_assignment_id              =>x_assignment_id,
       p_mileage_claim_element      =>l_mileage_claim_element  ,
       p_element_entry_id           =>l_element_entry_id  ,
       p_element_entry_date         =>l_element_entry_date,
       p_error_status              =>l_error_status
       );

Line: 569


              ,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: 594


   DELETE from hr_api_transaction_values
     WHERE transaction_step_id = x_transaction_step_id;

Line: 676


SELECT transaction_step_id
 FROM  hr_api_transaction_steps hats
 WHERE transaction_id = x_transaction_id;

Line: 699


ln_selected_person_id          hr_api_transactions.selected_person_id%TYPE;

Line: 896


              ,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: 928


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

Line: 932


   DELETE from hr_api_transaction_values
    WHERE transaction_step_id = x_transaction_step_id;

Line: 1024


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

Line: 1063


  pqp_mileage_claim_pkg.pqp_delete_mileage_claim
        ( p_effective_date             =>l_effective_date,
          p_assignment_id              =>l_assignment_id,
          p_mileage_claim_element      =>l_mileage_claim_element  ,
          p_element_entry_id           =>l_element_entry_id  ,
          p_element_entry_date         =>l_element_entry_date,
          p_return_status              =>l_error_status
         );