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

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

Line: 4


g_package  varchar2(33):='pqp_insert_mileage_claim.';

Line: 6


PROCEDURE pqp_insert_mileage_claim
        ( p_effective_date             IN DATE,
          p_web_adi_identifier         IN VARCHAR2  ,
          p_info_id                    IN VARCHAR2  ,
          p_time_stamp                 IN VARCHAR2  ,
          p_assignment_id              IN NUMBER,
          p_business_group_id          IN NUMBER,
          p_legislation_code           IN VARCHAR2,
          p_ownership                  IN VARCHAR2  ,
          p_usage_type                 IN VARCHAR2  ,
          p_vehicle_type               IN VARCHAR2,
          p_start_date                 IN DATE  ,
          p_end_date                   IN DATE  ,
          p_claimed_mileage            IN VARCHAR2  ,
          p_actual_mileage             IN VARCHAR2 ,
          p_registration_number        IN VARCHAR2  ,
          p_engine_capacity            IN VARCHAR2  ,
          p_fuel_type                  IN VARCHAR2  ,
          p_calculation_method         IN VARCHAR2  ,
          p_user_rates_table           IN VARCHAR2  ,
          p_fiscal_ratings             IN VARCHAR2  ,
          p_PAYE_taxable               IN VARCHAR2  ,
          p_no_of_passengers           IN VARCHAR2  ,
          p_data_source                IN VARCHAR2  ,
          p_mileage_claim_element      IN OUT NOCOPY NUMBER  ,
          p_element_entry_id           IN OUT NOCOPY NUMBER  ,
          p_element_entry_date         IN OUT NOCOPY DATE,
          p_return_status              OUT NOCOPY varchar2,
          p_purpose                    IN VARCHAR2  ,
          p_user_type                  IN VARCHAR2
 )
IS

l_proc            varchar2(72) := g_package ||'insert_mileage_claim';

Line: 49


 savepoint pqp_insert_mileage_claim;

Line: 55


pqp_gb_mileage_claim_pkg.insert_mileage_claim
        ( p_effective_date            =>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                 =>l_start_date  ,
          p_end_date                   =>l_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_calculation_method         =>p_calculation_method ,
          p_user_rates_table           =>p_user_rates_table,
          p_fiscal_ratings             =>p_fiscal_ratings,
          p_PAYE_taxable               =>p_PAYE_taxable,
          p_no_of_passengers           =>p_no_of_passengers,
          p_purpose                    =>p_purpose,
          p_data_source                =>p_data_source,
          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: 94


   rollback to savepoint pqp_insert_mileage_claim;

Line: 113


   rollback to savepoint pqp_insert_mileage_claim;

Line: 129


PROCEDURE pqp_update_mileage_claim
        ( p_effective_date             IN DATE,
          p_assignment_id              IN number,
          p_business_group_id          IN NUMBER,
          p_legislation_code           IN VARCHAR2,
          p_ownership                  IN VARCHAR2  ,
          p_usage_type                 IN VARCHAR2  ,
          p_vehicle_type               IN VARCHAR2,
          p_start_date_o               IN DATE  ,
          p_start_date                 IN DATE  ,
          p_end_date_o                 IN DATE  ,
          p_end_date                   IN DATE  ,
          p_claimed_mileage_o          IN VARCHAR2  ,
          p_claimed_mileage            IN VARCHAR2  ,
          p_actual_mileage_o           IN VARCHAR2  ,
          p_actual_mileage             IN VARCHAR2  ,
          p_registration_number        IN VARCHAR2  ,
          p_engine_capacity            IN VARCHAR2  ,
          p_fuel_type                  IN VARCHAR2  ,
          p_calculation_method         IN VARCHAR2  ,
          p_user_rates_table           IN VARCHAR2  ,
          p_fiscal_ratings_o           IN VARCHAR2  ,
          p_fiscal_ratings             IN VARCHAR2  ,
          p_PAYE_taxable               IN VARCHAR2  ,
          p_no_of_passengers_o         IN VARCHAR2  ,
          p_no_of_passengers           IN VARCHAR2  ,
          p_purpose                    IN VARCHAR2  ,
          p_data_source                IN VARCHAR2  ,
          p_mileage_claim_element      IN OUT NOCOPY NUMBER  ,
          p_element_entry_id           IN OUT NOCOPY NUMBER  ,
          p_element_entry_date         IN OUT NOCOPY DATE,
          p_return_status              OUT nocopy varchar2
 )
IS
l_start_date  VARCHAR2(20);

Line: 167


l_proc    varchar2(72) := g_package ||'update_mileage_claim';

Line: 177


  savepoint update_mileage_claim;

Line: 186


 pqp_gb_mileage_claim_pkg.update_mileage_claim
         ( p_effective_date           => 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_o              => l_start_date_o ,
          p_start_date                => l_start_date ,
          p_end_date_o                => l_end_date_o  ,
          p_end_date                  => l_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_calculation_method        => p_calculation_method ,
          p_user_rates_table          => p_user_rates_table ,
          p_fiscal_ratings_o          => p_fiscal_ratings_o ,
          p_fiscal_ratings            => p_fiscal_ratings ,
          p_PAYE_taxable              => p_PAYE_taxable ,
          p_no_of_passengers_o        => p_no_of_passengers_o  ,
          p_no_of_passengers          => p_no_of_passengers ,
          p_purpose                   => p_purpose,
          p_data_source               => p_data_source ,
          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: 232


    rollback to update_mileage_claim;

Line: 248


    rollback to update_mileage_claim;

Line: 268


PROCEDURE pqp_delete_mileage_claim
        (  p_effective_date            IN DATE,
          p_assignment_id              IN number,
          p_mileage_claim_element      IN OUT NOCOPY NUMBER  ,
          p_element_entry_id           IN OUT NOCOPY NUMBER  ,
          p_element_entry_date         IN OUT NOCOPY DATE,
          p_return_status              OUT NOCOPY varchar2
 )
IS
l_proc    varchar2(72) := g_package ||'delete_mileage_claim';

Line: 283


  savepoint delete_mileage_claim;

Line: 290


pqp_gb_mileage_claim_pkg.delete_mileage_claim
        ( p_effective_date             => p_effective_date,
          p_assignment_id              => p_assignment_id,
          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: 313


    rollback to delete_mileage_claim;

Line: 330


    rollback to delete_mileage_claim;

Line: 367


  select user_table_id
    from pay_user_tables
   where range_or_match = 'M'
     and user_table_name = p_field;

Line: 405


  select element_name
    from pay_element_types_f_tl
   where element_type_id = p_field_id;

Line: 414


  select user_table_name
    from pay_user_tables
   where user_table_id = p_field_id;