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

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

Line: 22


  ,p_treaty_info_update_date        in  date      default null
  ,p_number_of_days_in_usa          in  number    default null
  ,p_withldg_allow_eligible_flag    in  varchar2  default null
  ,p_ra_effective_date              in  date      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_object_version_number          out nocopy number
  ,p_effective_date                 in  date
  ,p_date_8233_signed               in  date      default null
  ,p_date_w4_signed                 in  date      default null
  ) is
  -- p_date_8233_signed and p_date_w4_signed were added by Ashu Gupta
  -- on 07/27/2000
  --
  -- Declare cursors and local variables
  --
  l_analyzed_data_id pqp_analyzed_alien_data.analyzed_data_id%TYPE;

Line: 71


      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_withldg_allow_eligible_flag    =>  p_withldg_allow_eligible_flag
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,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_effective_date               => trunc(p_effective_date)
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      );

Line: 107


    ,p_treaty_info_update_date       => p_treaty_info_update_date
    ,p_number_of_days_in_usa         => p_number_of_days_in_usa
    ,p_withldg_allow_eligible_flag   => p_withldg_allow_eligible_flag
    ,p_ra_effective_date             => p_ra_effective_date
    ,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_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    ,p_date_8233_signed              =>  p_date_8233_signed
    ,p_date_w4_signed                =>  p_date_w4_signed
    );

Line: 137


      ,p_treaty_info_update_date        =>  p_treaty_info_update_date
      ,p_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_withldg_allow_eligible_flag    =>  p_withldg_allow_eligible_flag
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,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_object_version_number          =>  l_object_version_number
      ,p_effective_date                 => trunc(p_effective_date)
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      );

Line: 210


procedure update_analyzed_alien_data
  (p_validate                       in  boolean   default false
  ,p_analyzed_data_id               in  number
  ,p_assignment_id                  in  number    default hr_api.g_number
  ,p_data_source                    in  varchar2  default hr_api.g_varchar2
  ,p_tax_year                       in  number    default hr_api.g_number
  ,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_number_of_days_in_usa          in  number    default hr_api.g_number
  ,p_withldg_allow_eligible_flag    in  varchar2  default hr_api.g_varchar2
  ,p_ra_effective_date              in  date      default hr_api.g_date
  ,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_object_version_number          in out nocopy number
  ,p_effective_date                 in  date
  ,p_date_8233_signed               in  date      default hr_api.g_date
  ,p_date_w4_signed                 in  date      default hr_api.g_date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72) := g_package||'update_analyzed_alien_data';

Line: 247


  savepoint update_analyzed_alien_data;

Line: 259


    pqp_analyzed_alien_data_bk2.update_analyzed_alien_data_b
      (
       p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_assignment_id                  =>  p_assignment_id
      ,p_data_source                    =>  p_data_source
      ,p_tax_year                       =>  p_tax_year
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_withldg_allow_eligible_flag    =>  p_withldg_allow_eligible_flag
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,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_object_version_number          =>  p_object_version_number
    ,p_effective_date                 => trunc(p_effective_date)
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      );

Line: 287


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

Line: 305


    ,p_treaty_info_update_date       => p_treaty_info_update_date
    ,p_number_of_days_in_usa         => p_number_of_days_in_usa
    ,p_withldg_allow_eligible_flag   => p_withldg_allow_eligible_flag
    ,p_ra_effective_date             => p_ra_effective_date
    ,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_object_version_number         => l_object_version_number
    ,p_effective_date                => trunc(p_effective_date)
    ,p_date_8233_signed              =>  p_date_8233_signed
    ,p_date_w4_signed                =>  p_date_w4_signed
    );

Line: 325


    pqp_analyzed_alien_data_bk2.update_analyzed_alien_data_a
      (
       p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_assignment_id                  =>  p_assignment_id
      ,p_data_source                    =>  p_data_source
      ,p_tax_year                       =>  p_tax_year
      ,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_number_of_days_in_usa          =>  p_number_of_days_in_usa
      ,p_withldg_allow_eligible_flag    =>  p_withldg_allow_eligible_flag
      ,p_ra_effective_date              =>  p_ra_effective_date
      ,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_object_version_number          =>  l_object_version_number
      ,p_effective_date                => trunc(p_effective_date)
      ,p_date_8233_signed               =>  p_date_8233_signed
      ,p_date_w4_signed                 =>  p_date_w4_signed
      );

Line: 353


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

Line: 382


    ROLLBACK TO update_analyzed_alien_data;

Line: 394


    ROLLBACK TO update_analyzed_alien_data;

Line: 397


end update_analyzed_alien_data;

Line: 402


procedure delete_analyzed_alien_data
  (p_validate                       in  boolean  default false
  ,p_analyzed_data_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||'delete_analyzed_alien_data';

Line: 420


  savepoint delete_analyzed_alien_data;

Line: 433


    pqp_analyzed_alien_data_bk3.delete_analyzed_alien_data_b
      (
       p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_object_version_number          =>  p_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 442


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

Line: 461


    pqp_analyzed_alien_data_bk3.delete_analyzed_alien_data_a
      (
       p_analyzed_data_id               =>  p_analyzed_data_id
      ,p_object_version_number          =>  l_object_version_number
    ,p_effective_date                      => trunc(p_effective_date)
      );

Line: 470


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

Line: 495


    ROLLBACK TO delete_analyzed_alien_data;

Line: 506


    ROLLBACK TO delete_analyzed_alien_data;

Line: 509


end delete_analyzed_alien_data;