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.PQH_FR_VALIDATIONS_SWI SQL Statements

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

Line: 11


PROCEDURE delete_validation
  (p_validation_id                in     number
  ,p_object_version_number        in     number
  ,p_return_status                   out nocopy varchar2
  ) is

  cursor c_vp is
  select validation_period_id, object_version_number from pqh_fr_validation_periods
  where validation_id = p_validation_id;

Line: 22


  select validation_event_id, object_version_number from pqh_fr_validation_events
  where validation_id = p_validation_id;

Line: 32


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

Line: 38


  savepoint delete_validation_swi;

Line: 56


  pqh_fr_validation_periods_api.delete_validation_period
  (p_validation_period_id         => vlp.validation_period_id
  ,p_object_version_number        => vlp.object_version_number);

Line: 62


  pqh_fr_validation_events_api.delete_validation_event
  (p_validation_event_id          => vle.validation_event_id
  ,p_object_version_number        => vle.object_version_number);

Line: 67


  pqh_fr_validations_api.delete_validation
    (p_validation_id                => p_validation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 93


    rollback to delete_validation_swi;

Line: 107


    rollback to delete_validation_swi;

Line: 117


end delete_validation;

Line: 121


PROCEDURE insert_validation
  (p_effective_date               in     date
  ,p_pension_fund_type_code       in     varchar2
  ,p_pension_fund_id              in     number
  ,p_business_group_id            in     number
  ,p_person_id                    in     number
  ,p_previously_validated_flag    in     varchar2
  ,p_request_date                 in     date      default null
  ,p_completion_date              in     date      default null
  ,p_previous_employer_id         in     number    default null
  ,p_status                       in     varchar2  default null
  ,p_employer_amount              in     number    default null
  ,p_employer_currency_code       in     varchar2  default null
  ,p_employee_amount              in     number    default null
  ,p_employee_currency_code       in     varchar2  default null
  ,p_deduction_per_period         in     number    default null
  ,p_deduction_currency_code      in     varchar2  default null
  ,p_percent_of_salary            in     number    default null
  ,p_validation_id                   out nocopy number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  --
  -- Other variables
  l_proc    varchar2(72) := g_package ||'insert_validation';

Line: 155


  savepoint insert_validation_swi;

Line: 175


  pqh_fr_validations_api.insert_validation
    (p_effective_date               => p_effective_date
    ,p_pension_fund_type_code       => p_pension_fund_type_code
    ,p_pension_fund_id              => p_pension_fund_id
    ,p_business_group_id            => p_business_group_id
    ,p_person_id                    => p_person_id
    ,p_previously_validated_flag    => p_previously_validated_flag
    ,p_request_date                 => p_request_date
    ,p_completion_date              => p_completion_date
    ,p_previous_employer_id         => p_previous_employer_id
    ,p_status                       => p_status
    ,p_employer_amount              => p_employer_amount
    ,p_employer_currency_code       => p_employer_currency_code
    ,p_employee_amount              => p_employee_amount
    ,p_employee_currency_code       => p_employee_currency_code
    ,p_deduction_per_period         => p_deduction_per_period
    ,p_deduction_currency_code      => p_deduction_currency_code
    ,p_percent_of_salary            => p_percent_of_salary
    ,p_validation_id                => p_validation_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 218


    rollback to insert_validation_swi;

Line: 234


    rollback to insert_validation_swi;

Line: 246


end insert_validation;

Line: 250


PROCEDURE update_validation
  (p_effective_date               in     date
  ,p_validation_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_pension_fund_type_code       in     varchar2  default hr_api.g_varchar2
  ,p_pension_fund_id              in     number    default hr_api.g_number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_person_id                    in     number    default hr_api.g_number
  ,p_previously_validated_flag    in     varchar2  default hr_api.g_varchar2
  ,p_request_date                 in     date      default hr_api.g_date
  ,p_completion_date              in     date      default hr_api.g_date
  ,p_previous_employer_id         in     number    default hr_api.g_number
  ,p_status                       in     varchar2  default hr_api.g_varchar2
  ,p_employer_amount              in     number    default hr_api.g_number
  ,p_employer_currency_code       in     varchar2  default hr_api.g_varchar2
  ,p_employee_amount              in     number    default hr_api.g_number
  ,p_employee_currency_code       in     varchar2  default hr_api.g_varchar2
  ,p_deduction_per_period         in     number    default hr_api.g_number
  ,p_deduction_currency_code      in     varchar2  default hr_api.g_varchar2
  ,p_percent_of_salary            in     number    default hr_api.g_number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  --
  -- Variables for IN/OUT parameters
  l_object_version_number         number;

Line: 279


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

Line: 285


  savepoint update_validation_swi;

Line: 303


  pqh_fr_validations_api.update_validation
    (p_effective_date               => p_effective_date
    ,p_validation_id                => p_validation_id
    ,p_object_version_number        => p_object_version_number
    ,p_pension_fund_type_code       => p_pension_fund_type_code
    ,p_pension_fund_id              => p_pension_fund_id
    ,p_business_group_id            => p_business_group_id
    ,p_person_id                    => p_person_id
    ,p_previously_validated_flag    => p_previously_validated_flag
    ,p_request_date                 => p_request_date
    ,p_completion_date              => p_completion_date
    ,p_previous_employer_id         => p_previous_employer_id
    ,p_status                       => p_status
    ,p_employer_amount              => p_employer_amount
    ,p_employer_currency_code       => p_employer_currency_code
    ,p_employee_amount              => p_employee_amount
    ,p_employee_currency_code       => p_employee_currency_code
    ,p_deduction_per_period         => p_deduction_per_period
    ,p_deduction_currency_code      => p_deduction_currency_code
    ,p_percent_of_salary            => p_percent_of_salary
    );

Line: 346


    rollback to update_validation_swi;

Line: 361


    rollback to update_validation_swi;

Line: 372


end update_validation;