DBA Data[Home] [Help]

APPS.PQP_ANALYZED_ALIEN_DET_API SQL Statements

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

Line: 230

procedure update_analyzed_alien_det
  (p_validate                       in  boolean   default false
  ,p_analyzed_data_details_id       in  number
  ,p_analyzed_data_id               in  number    default hr_api.g_number
  ,p_income_code                    in  varchar2  default hr_api.g_varchar2
  ,p_withholding_rate               in  number    default hr_api.g_number
  ,p_income_code_sub_type           in  varchar2  default hr_api.g_varchar2
  ,p_exemption_code                 in  varchar2  default hr_api.g_varchar2
  ,p_maximum_benefit_amount         in  number    default hr_api.g_number
  ,p_retro_lose_ben_amt_flag        in  varchar2  default hr_api.g_varchar2
  ,p_date_benefit_ends              in  date      default hr_api.g_date
  ,p_retro_lose_ben_date_flag       in  varchar2  default hr_api.g_varchar2
  ,p_nra_exempt_from_ss             in  varchar2  default hr_api.g_varchar2
  ,p_nra_exempt_from_medicare       in  varchar2  default hr_api.g_varchar2
  ,p_student_exempt_from_ss         in  varchar2  default hr_api.g_varchar2
  ,p_student_exempt_from_medi       in  varchar2  default hr_api.g_varchar2
  ,p_addl_withholding_flag          in  varchar2  default hr_api.g_varchar2
  ,p_constant_addl_tax              in  number    default hr_api.g_number
  ,p_addl_withholding_amt           in  number    default hr_api.g_number
  ,p_addl_wthldng_amt_period_type   in  varchar2  default hr_api.g_varchar2
  ,p_personal_exemption             in  number    default hr_api.g_number
  ,p_addl_exemption_allowed         in  number    default hr_api.g_number
  ,p_treaty_ben_allowed_flag        in  varchar2  default hr_api.g_varchar2
  ,p_treaty_benefits_start_date     in  date      default hr_api.g_date
  ,p_object_version_number          in  out nocopy number
  ,p_effective_date                 in  date
  ,p_retro_loss_notification_sent   in  varchar2  default hr_api.g_varchar2
  ,p_current_analysis               in  varchar2  default hr_api.g_varchar2
  ,p_forecast_income_code           in  varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_analyzed_alien_det';
Line: 272

  savepoint update_analyzed_alien_det;
Line: 284

    pqp_analyzed_alien_det_bk2.update_analyzed_alien_det_b
      (
       p_analyzed_data_details_id       =>  p_analyzed_data_details_id
      ,p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_income_code                    =>  p_income_code
      ,p_withholding_rate               =>  p_withholding_rate
      ,p_income_code_sub_type           =>  p_income_code_sub_type
      ,p_exemption_code                 =>  p_exemption_code
      ,p_maximum_benefit_amount         =>  p_maximum_benefit_amount
      ,p_retro_lose_ben_amt_flag        =>  p_retro_lose_ben_amt_flag
      ,p_date_benefit_ends              =>  p_date_benefit_ends
      ,p_retro_lose_ben_date_flag       =>  p_retro_lose_ben_date_flag
      ,p_nra_exempt_from_ss             =>  p_nra_exempt_from_ss
      ,p_nra_exempt_from_medicare       =>  p_nra_exempt_from_medicare
      ,p_student_exempt_from_ss         =>  p_student_exempt_from_ss
      ,p_student_exempt_from_medi       =>  p_student_exempt_from_medi
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_addl_withholding_amt           =>  p_addl_withholding_amt
      ,p_addl_wthldng_amt_period_type   =>  p_addl_wthldng_amt_period_type
      ,p_personal_exemption             =>  p_personal_exemption
      ,p_addl_exemption_allowed         =>  p_addl_exemption_allowed
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_retro_loss_notification_sent   =>  p_retro_loss_notification_sent
      ,p_current_analysis               =>  p_current_analysis
      ,p_forecast_income_code           =>  p_forecast_income_code
      );
Line: 317

        (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
        ,p_hook_type   => 'BP'
        );
Line: 360

    pqp_analyzed_alien_det_bk2.update_analyzed_alien_det_a
      (
       p_analyzed_data_details_id       =>  p_analyzed_data_details_id
      ,p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_income_code                    =>  p_income_code
      ,p_withholding_rate               =>  p_withholding_rate
      ,p_income_code_sub_type           =>  p_income_code_sub_type
      ,p_exemption_code                 =>  p_exemption_code
      ,p_maximum_benefit_amount         =>  p_maximum_benefit_amount
      ,p_retro_lose_ben_amt_flag        =>  p_retro_lose_ben_amt_flag
      ,p_date_benefit_ends              =>  p_date_benefit_ends
      ,p_retro_lose_ben_date_flag       =>  p_retro_lose_ben_date_flag
      ,p_nra_exempt_from_ss             =>  p_nra_exempt_from_ss
      ,p_nra_exempt_from_medicare       =>  p_nra_exempt_from_medicare
      ,p_student_exempt_from_ss         =>  p_student_exempt_from_ss
      ,p_student_exempt_from_medi       =>  p_student_exempt_from_medi
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_addl_withholding_amt           =>  p_addl_withholding_amt
      ,p_addl_wthldng_amt_period_type   =>  p_addl_wthldng_amt_period_type
      ,p_personal_exemption             =>  p_personal_exemption
      ,p_addl_exemption_allowed         =>  p_addl_exemption_allowed
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_retro_loss_notification_sent   => p_retro_loss_notification_sent
      ,p_current_analysis               =>  p_current_analysis
      ,p_forecast_income_code           =>  p_forecast_income_code
      );
Line: 393

        (p_module_name => 'UPDATE_ANALYZED_ALIEN_DET'
        ,p_hook_type   => 'AP'
        );
Line: 422

    ROLLBACK TO update_analyzed_alien_det;
Line: 434

    ROLLBACK TO update_analyzed_alien_det;
Line: 439

end update_analyzed_alien_det;
Line: 444

procedure delete_analyzed_alien_det
  (p_validate                       in  boolean  default false
  ,p_analyzed_data_details_id       in  number
  ,p_object_version_number          in  out nocopy number
  ,p_effective_date                 in  date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_analyzed_alien_det';
Line: 462

  savepoint delete_analyzed_alien_det;
Line: 475

    pqp_analyzed_alien_det_bk3.delete_analyzed_alien_det_b
      (
       p_analyzed_data_details_id       =>  p_analyzed_data_details_id
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      );
Line: 484

        (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
        ,p_hook_type   => 'BP'
        );
Line: 503

    pqp_analyzed_alien_det_bk3.delete_analyzed_alien_det_a
      (
       p_analyzed_data_details_id       =>  p_analyzed_data_details_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                   => trunc(p_effective_date)
      );
Line: 512

        (p_module_name => 'DELETE_ANALYZED_ALIEN_DET'
        ,p_hook_type   => 'AP'
        );
Line: 537

    ROLLBACK TO delete_analyzed_alien_det;
Line: 548

    ROLLBACK TO delete_analyzed_alien_det;
Line: 552

end delete_analyzed_alien_det;