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

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

Line: 12


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
  ,p_completion_date                in     date
  ,p_previous_employer_id           in     number
  ,p_status                         in     varchar2
  ,p_employer_amount                in     number
  ,p_employer_currency_code         in     varchar2
  ,p_employee_amount                in     number
  ,p_employee_currency_code         in     varchar2
  ,p_deduction_per_period           in     number
  ,p_deduction_currency_code        in     varchar2
  ,p_percent_of_salary              in     number
  ,p_validation_id                     out nocopy number
  ,p_object_version_number             out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 48


  savepoint Insert_Validation;

Line: 57


   PQH_FR_VALIDATIONS_BK1.Insert_Validation_b
   (p_effective_date               => l_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
   );

Line: 81


        (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
        ,p_hook_type   => 'BP'
        );

Line: 117


     PQH_FR_VALIDATIONS_BK1.Insert_Validation_a
     (
     p_effective_date              => l_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
     );

Line: 141


        (p_module_name => 'PQH_FR_VALIDATIONS_API.Insert_Validation'
        ,p_hook_type   => 'AP'
        );

Line: 169


    rollback to Insert_Validation;

Line: 183


    rollback to Insert_Validation;

Line: 186


end Insert_Validation;

Line: 193


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
  ,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
  ,p_completion_date              in     date
  ,p_previous_employer_id         in     number
  ,p_status                       in     varchar2
  ,p_employer_amount              in     number
  ,p_employer_currency_code       in     varchar2
  ,p_employee_amount              in     number
  ,p_employee_currency_code       in     varchar2
  ,p_deduction_per_period         in     number
  ,p_deduction_currency_code      in     varchar2
  ,p_percent_of_salary            in     number
  ) Is

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

Line: 225


  savepoint Update_Validation;

Line: 235


   PQH_FR_VALIDATIONS_BK2.Update_Validation_b
  (
  p_effective_date               => l_effective_date
  ,p_validation_id               => p_validation_id
  ,p_object_version_number       => l_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: 261


        (p_module_name => 'Update_Validation'
        ,p_hook_type   => 'BP'
        );

Line: 295


   PQH_FR_VALIDATIONS_BK2.Update_Validation_a
  (
  p_effective_date               => l_effective_date
  ,p_validation_id               => p_validation_id
  ,p_object_version_number       => l_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: 322


        (p_module_name => 'Update_Validation'
        ,p_hook_type   => 'AP'
        );

Line: 346


    rollback to Update_Validation;

Line: 359


    rollback to Update_Validation;

Line: 362


end Update_Validation;

Line: 368


procedure delete_Validation
  (
  p_validation_id                        in     number
  ,p_object_version_number                in     number
  ) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_Validation';

Line: 383


  savepoint delete_Validation;

Line: 388


  PQH_FR_VALIDATIONS_BK3.Delete_Validation_b
  (
  p_validation_id            => p_validation_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 396


        (p_module_name => 'delete_Validation'
        ,p_hook_type   => 'BP');

Line: 412


   PQH_FR_VALIDATIONS_BK3.Delete_Validation_a
  (
  p_validation_id            => p_validation_id
  ,p_object_version_number   => p_object_version_number
  );

Line: 421


        (p_module_name => 'delete_Validation'
        ,p_hook_type   => 'AP');

Line: 440


    rollback to delete_Validation;

Line: 451


    rollback to delete_Validation;

Line: 454


end delete_Validation;