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

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

Line: 30


  ,p_treaty_info_update_date        in  date      default null
  ,p_nra_exempt_from_fica           in  varchar2  default null
  ,p_student_exempt_from_fica       in  varchar2  default null
  ,p_addl_withholding_flag          in  varchar2  default null
  ,p_addl_withholding_amt           in  number    default null
  ,p_addl_wthldng_amt_period_type   in  varchar2  default null
  ,p_personal_exemption             in  number    default null
  ,p_addl_exemption_allowed         in  number    default null
  ,p_number_of_days_in_usa          in  number    default null
  ,p_wthldg_allow_eligible_flag     in  varchar2  default null
  ,p_treaty_ben_allowed_flag        in  varchar2  default null
  ,p_treaty_benefits_start_date     in  date      default null
  ,p_ra_effective_date              in  date      default null
  ,p_state_code                     in  varchar2  default null
  ,p_state_honors_treaty_flag       in  varchar2  default null
  ,p_ytd_payments                   in  number    default null
  ,p_ytd_w2_payments                in  number    default null
  ,p_ytd_w2_withholding             in  number    default null
  ,p_ytd_withholding_allowance      in  number    default null
  ,p_ytd_treaty_payments            in  number    default null
  ,p_ytd_treaty_withheld_amt        in  number    default null
  ,p_record_source                  in  varchar2  default null
  ,p_visa_type                      in  varchar2  default null
  ,p_j_sub_type                     in  varchar2  default null
  ,p_primary_activity               in  varchar2  default null
  ,p_non_us_country_code            in  varchar2  default null
  ,p_citizenship_country_code       in  varchar2  default null
  ,p_constant_addl_tax              in  number    default null
  ,p_date_8233_signed               in  date      default null
  ,p_date_w4_signed                 in  date      default null
  ,p_error_indicator                in  varchar2  default null
  ,p_prev_er_treaty_benefit_amt     in  number    default null
  ,p_error_text                     in  varchar2  default null
  ,p_object_version_number          out nocopy number
  ,p_effective_date                 in  date
  ,p_current_analysis               in  varchar2  default null
  ,p_forecast_income_code           in  varchar2  default null
  ) is
  --
  -- Declare cursors and local variables
  --
  l_alien_transaction_id pqp_alien_transaction_data.alien_transaction_id%TYPE;

Line: 108


      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_nra_exempt_from_fica           =>  p_nra_exempt_from_fica
      ,p_student_exempt_from_fica       =>  p_student_exempt_from_fica
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_wthldg_allow_eligible_flag     =>  p_wthldg_allow_eligible_flag
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,p_state_code                     =>  p_state_code
      ,p_state_honors_treaty_flag       =>  p_state_honors_treaty_flag
      ,p_ytd_payments                   =>  p_ytd_payments
      ,p_ytd_w2_payments                =>  p_ytd_w2_payments
      ,p_ytd_w2_withholding             =>  p_ytd_w2_withholding
      ,p_ytd_withholding_allowance      =>  p_ytd_withholding_allowance
      ,p_ytd_treaty_payments            =>  p_ytd_treaty_payments
      ,p_ytd_treaty_withheld_amt        =>  p_ytd_treaty_withheld_amt
      ,p_record_source                  =>  p_record_source
      ,p_visa_type                      =>  p_visa_type
      ,p_j_sub_type                     =>  p_j_sub_type
      ,p_primary_activity               =>  p_primary_activity
      ,p_non_us_country_code            =>  p_non_us_country_code
      ,p_citizenship_country_code       =>  p_citizenship_country_code
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      ,p_error_indicator                =>  p_error_indicator
      ,p_prev_er_treaty_benefit_amt     =>  p_prev_er_treaty_benefit_amt
      ,p_error_text                     =>  p_error_text
      ,p_effective_date                 =>  trunc(p_effective_date)
      ,p_current_analysis               =>  p_current_analysis
      ,p_forecast_income_code           =>  p_forecast_income_code
      );

Line: 175


    ,p_treaty_info_update_date       => p_treaty_info_update_date
    ,p_nra_exempt_from_fica          => p_nra_exempt_from_fica
    ,p_student_exempt_from_fica      => p_student_exempt_from_fica
    ,p_addl_withholding_flag         => p_addl_withholding_flag
    ,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_number_of_days_in_usa         => p_number_of_days_in_usa
    ,p_wthldg_allow_eligible_flag    => p_wthldg_allow_eligible_flag
    ,p_treaty_ben_allowed_flag       => p_treaty_ben_allowed_flag
    ,p_treaty_benefits_start_date    => p_treaty_benefits_start_date
    ,p_ra_effective_date             => p_ra_effective_date
    ,p_state_code                    => p_state_code
    ,p_state_honors_treaty_flag      => p_state_honors_treaty_flag
    ,p_ytd_payments                  => p_ytd_payments
    ,p_ytd_w2_payments               => p_ytd_w2_payments
    ,p_ytd_w2_withholding            => p_ytd_w2_withholding
    ,p_ytd_withholding_allowance     => p_ytd_withholding_allowance
    ,p_ytd_treaty_payments           => p_ytd_treaty_payments
    ,p_ytd_treaty_withheld_amt       => p_ytd_treaty_withheld_amt
    ,p_record_source                 => p_record_source
    ,p_visa_type                     => p_visa_type
    ,p_j_sub_type                    => p_j_sub_type
    ,p_primary_activity              => p_primary_activity
    ,p_non_us_country_code           => p_non_us_country_code
    ,p_citizenship_country_code      => p_citizenship_country_code
    ,p_constant_addl_tax             => p_constant_addl_tax
    ,p_date_8233_signed              => p_date_8233_signed
    ,p_date_w4_signed                => p_date_w4_signed
    ,p_error_indicator               => p_error_indicator
    ,p_prev_er_treaty_benefit_amt    => p_prev_er_treaty_benefit_amt
    ,p_error_text                    => p_error_text
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    ,p_current_analysis              =>  p_current_analysis
    ,p_forecast_income_code          =>  p_forecast_income_code
    );

Line: 236


      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_nra_exempt_from_fica           =>  p_nra_exempt_from_fica
      ,p_student_exempt_from_fica       =>  p_student_exempt_from_fica
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_wthldg_allow_eligible_flag     =>  p_wthldg_allow_eligible_flag
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,p_state_code                     =>  p_state_code
      ,p_state_honors_treaty_flag       =>  p_state_honors_treaty_flag
      ,p_ytd_payments                   =>  p_ytd_payments
      ,p_ytd_w2_payments                =>  p_ytd_w2_payments
      ,p_ytd_w2_withholding             =>  p_ytd_w2_withholding
      ,p_ytd_withholding_allowance      =>  p_ytd_withholding_allowance
      ,p_ytd_treaty_payments            =>  p_ytd_treaty_payments
      ,p_ytd_treaty_withheld_amt        =>  p_ytd_treaty_withheld_amt
      ,p_record_source                  =>  p_record_source
      ,p_visa_type                      =>  p_visa_type
      ,p_j_sub_type                     =>  p_j_sub_type
      ,p_primary_activity               =>  p_primary_activity
      ,p_non_us_country_code            =>  p_non_us_country_code
      ,p_citizenship_country_code       =>  p_citizenship_country_code
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      ,p_error_indicator                =>  p_error_indicator
      ,p_prev_er_treaty_benefit_amt     =>  p_prev_er_treaty_benefit_amt
      ,p_error_text                     =>  p_error_text
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_current_analysis              =>  p_current_analysis
      ,p_forecast_income_code          =>  p_forecast_income_code
      );

Line: 334


procedure update_alien_trans_data
  (p_validate                       in  boolean   default false
  ,p_alien_transaction_id           in  number
  ,p_person_id                      in  number    default hr_api.g_number
  ,p_data_source_type               in  varchar2  default hr_api.g_varchar2
  ,p_tax_year                       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_current_residency_status       in  varchar2  default hr_api.g_varchar2
  ,p_nra_to_ra_date                 in  date      default hr_api.g_date
  ,p_target_departure_date          in  date      default hr_api.g_date
  ,p_tax_residence_country_code     in  varchar2  default hr_api.g_varchar2
  ,p_treaty_info_update_date        in  date      default hr_api.g_date
  ,p_nra_exempt_from_fica           in  varchar2  default hr_api.g_varchar2
  ,p_student_exempt_from_fica       in  varchar2  default hr_api.g_varchar2
  ,p_addl_withholding_flag          in  varchar2  default hr_api.g_varchar2
  ,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_number_of_days_in_usa          in  number    default hr_api.g_number
  ,p_wthldg_allow_eligible_flag     in  varchar2  default hr_api.g_varchar2
  ,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_ra_effective_date              in  date      default hr_api.g_date
  ,p_state_code                     in  varchar2  default hr_api.g_varchar2
  ,p_state_honors_treaty_flag       in  varchar2  default hr_api.g_varchar2
  ,p_ytd_payments                   in  number    default hr_api.g_number
  ,p_ytd_w2_payments                in  number    default hr_api.g_number
  ,p_ytd_w2_withholding             in  number    default hr_api.g_number
  ,p_ytd_withholding_allowance      in  number    default hr_api.g_number
  ,p_ytd_treaty_payments            in  number    default hr_api.g_number
  ,p_ytd_treaty_withheld_amt        in  number    default hr_api.g_number
  ,p_record_source                  in  varchar2  default hr_api.g_varchar2
  ,p_visa_type                      in  varchar2  default hr_api.g_varchar2
  ,p_j_sub_type                     in  varchar2  default hr_api.g_varchar2
  ,p_primary_activity               in  varchar2  default hr_api.g_varchar2
  ,p_non_us_country_code            in  varchar2  default hr_api.g_varchar2
  ,p_citizenship_country_code       in  varchar2  default hr_api.g_varchar2
  ,p_constant_addl_tax              in  number    default hr_api.g_number
  ,p_date_8233_signed               in  date      default hr_api.g_date
  ,p_date_w4_signed                 in  date      default hr_api.g_date
  ,p_error_indicator                in  varchar2  default hr_api.g_varchar2
  ,p_prev_er_treaty_benefit_amt     in  number    default hr_api.g_number
  ,p_error_text                     in  varchar2  default hr_api.g_varchar2
  ,p_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,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_alien_trans_data';

Line: 402


  savepoint update_alien_trans_data;

Line: 414


    pqp_alien_trans_data_bk2.update_alien_trans_data_b
      (
       p_alien_transaction_id           =>  p_alien_transaction_id
      ,p_person_id                      =>  p_person_id
      ,p_data_source_type               =>  p_data_source_type
      ,p_tax_year                       =>  p_tax_year
      ,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_current_residency_status       =>  p_current_residency_status
      ,p_nra_to_ra_date                 =>  p_nra_to_ra_date
      ,p_target_departure_date          =>  p_target_departure_date
      ,p_tax_residence_country_code     =>  p_tax_residence_country_code
      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_nra_exempt_from_fica           =>  p_nra_exempt_from_fica
      ,p_student_exempt_from_fica       =>  p_student_exempt_from_fica
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_wthldg_allow_eligible_flag     =>  p_wthldg_allow_eligible_flag
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,p_state_code                     =>  p_state_code
      ,p_state_honors_treaty_flag       =>  p_state_honors_treaty_flag
      ,p_ytd_payments                   =>  p_ytd_payments
      ,p_ytd_w2_payments                =>  p_ytd_w2_payments
      ,p_ytd_w2_withholding             =>  p_ytd_w2_withholding
      ,p_ytd_withholding_allowance      =>  p_ytd_withholding_allowance
      ,p_ytd_treaty_payments            =>  p_ytd_treaty_payments
      ,p_ytd_treaty_withheld_amt        =>  p_ytd_treaty_withheld_amt
      ,p_record_source                  =>  p_record_source
      ,p_visa_type                      =>  p_visa_type
      ,p_j_sub_type                     =>  p_j_sub_type
      ,p_primary_activity               =>  p_primary_activity
      ,p_non_us_country_code            =>  p_non_us_country_code
      ,p_citizenship_country_code       =>  p_citizenship_country_code
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      ,p_error_indicator                =>  p_error_indicator
      ,p_prev_er_treaty_benefit_amt     =>  p_prev_er_treaty_benefit_amt
      ,p_error_text                     =>  p_error_text
      ,p_object_version_number          =>  p_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_current_analysis              =>  p_current_analysis
      ,p_forecast_income_code          =>  p_forecast_income_code
      );

Line: 473


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

Line: 499


    ,p_treaty_info_update_date       => p_treaty_info_update_date
    ,p_nra_exempt_from_fica          => p_nra_exempt_from_fica
    ,p_student_exempt_from_fica      => p_student_exempt_from_fica
    ,p_addl_withholding_flag         => p_addl_withholding_flag
    ,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_number_of_days_in_usa         => p_number_of_days_in_usa
    ,p_wthldg_allow_eligible_flag    => p_wthldg_allow_eligible_flag
    ,p_treaty_ben_allowed_flag       => p_treaty_ben_allowed_flag
    ,p_treaty_benefits_start_date    => p_treaty_benefits_start_date
    ,p_ra_effective_date             => p_ra_effective_date
    ,p_state_code                    => p_state_code
    ,p_state_honors_treaty_flag      => p_state_honors_treaty_flag
    ,p_ytd_payments                  => p_ytd_payments
    ,p_ytd_w2_payments               => p_ytd_w2_payments
    ,p_ytd_w2_withholding            => p_ytd_w2_withholding
    ,p_ytd_withholding_allowance     => p_ytd_withholding_allowance
    ,p_ytd_treaty_payments           => p_ytd_treaty_payments
    ,p_ytd_treaty_withheld_amt       => p_ytd_treaty_withheld_amt
    ,p_record_source                 => p_record_source
    ,p_visa_type                     => p_visa_type
    ,p_j_sub_type                    => p_j_sub_type
    ,p_primary_activity              => p_primary_activity
    ,p_non_us_country_code           => p_non_us_country_code
    ,p_citizenship_country_code      => p_citizenship_country_code
    ,p_constant_addl_tax             => p_constant_addl_tax
    ,p_date_8233_signed              => p_date_8233_signed
    ,p_date_w4_signed                => p_date_w4_signed
    ,p_error_indicator               => p_error_indicator
    ,p_prev_er_treaty_benefit_amt    => p_prev_er_treaty_benefit_amt
    ,p_error_text                    => p_error_text
    ,p_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    ,p_current_analysis              =>  p_current_analysis
    ,p_forecast_income_code          =>  p_forecast_income_code
    );

Line: 542


    pqp_alien_trans_data_bk2.update_alien_trans_data_a
      (
       p_alien_transaction_id           =>  p_alien_transaction_id
      ,p_person_id                      =>  p_person_id
      ,p_data_source_type               =>  p_data_source_type
      ,p_tax_year                       =>  p_tax_year
      ,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_current_residency_status       =>  p_current_residency_status
      ,p_nra_to_ra_date                 =>  p_nra_to_ra_date
      ,p_target_departure_date          =>  p_target_departure_date
      ,p_tax_residence_country_code     =>  p_tax_residence_country_code
      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_nra_exempt_from_fica           =>  p_nra_exempt_from_fica
      ,p_student_exempt_from_fica       =>  p_student_exempt_from_fica
      ,p_addl_withholding_flag          =>  p_addl_withholding_flag
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_wthldg_allow_eligible_flag     =>  p_wthldg_allow_eligible_flag
      ,p_treaty_ben_allowed_flag        =>  p_treaty_ben_allowed_flag
      ,p_treaty_benefits_start_date     =>  p_treaty_benefits_start_date
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,p_state_code                     =>  p_state_code
      ,p_state_honors_treaty_flag       =>  p_state_honors_treaty_flag
      ,p_ytd_payments                   =>  p_ytd_payments
      ,p_ytd_w2_payments                =>  p_ytd_w2_payments
      ,p_ytd_w2_withholding             =>  p_ytd_w2_withholding
      ,p_ytd_withholding_allowance      =>  p_ytd_withholding_allowance
      ,p_ytd_treaty_payments            =>  p_ytd_treaty_payments
      ,p_ytd_treaty_withheld_amt        =>  p_ytd_treaty_withheld_amt
      ,p_record_source                  =>  p_record_source
      ,p_visa_type                      =>  p_visa_type
      ,p_j_sub_type                     =>  p_j_sub_type
      ,p_primary_activity               =>  p_primary_activity
      ,p_non_us_country_code            =>  p_non_us_country_code
      ,p_citizenship_country_code       =>  p_citizenship_country_code
      ,p_constant_addl_tax              =>  p_constant_addl_tax
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      ,p_error_indicator                =>  p_error_indicator
      ,p_prev_er_treaty_benefit_amt     =>  p_prev_er_treaty_benefit_amt
      ,p_error_text                     =>  p_error_text
      ,p_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      ,p_current_analysis              =>  p_current_analysis
      ,p_forecast_income_code          =>  p_forecast_income_code
      );

Line: 601


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

Line: 630


    ROLLBACK TO update_alien_trans_data;

Line: 642


    ROLLBACK TO update_alien_trans_data;

Line: 647


end update_alien_trans_data;

Line: 652


procedure delete_alien_trans_data
  (p_validate                       in  boolean  default false
  ,p_alien_transaction_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_alien_trans_data';

Line: 670


  savepoint delete_alien_trans_data;

Line: 683


    pqp_alien_trans_data_bk3.delete_alien_trans_data_b
      (
       p_alien_transaction_id           =>  p_alien_transaction_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 692


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

Line: 711


    pqp_alien_trans_data_bk3.delete_alien_trans_data_a
      (
       p_alien_transaction_id           =>  p_alien_transaction_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 720


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

Line: 745


    ROLLBACK TO delete_alien_trans_data;

Line: 756


    ROLLBACK TO delete_alien_trans_data;

Line: 760


end delete_alien_trans_data;