APPS.PQP_AAD_DEL SQL Statements

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

Line: 51

Procedure delete_dml(p_rec in pqp_aad_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_dml';

Line: 62

  delete from pqp_analyzed_alien_data
  where analyzed_data_id = p_rec.analyzed_data_id;

Line: 78

End delete_dml;

Line: 112

Procedure pre_delete(p_rec in pqp_aad_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'pre_delete';

Line: 120

End pre_delete;

Line: 154

Procedure post_delete(
p_effective_date in date,p_rec in pqp_aad_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'post_delete';

Line: 167

    pqp_aad_rkd.after_delete
      (
  p_analyzed_data_id              =>p_rec.analyzed_data_id
 ,p_assignment_id_o               =>pqp_aad_shd.g_old_rec.assignment_id
 ,p_data_source_o                 =>pqp_aad_shd.g_old_rec.data_source
 ,p_tax_year_o                    =>pqp_aad_shd.g_old_rec.tax_year
 ,p_current_residency_status_o    =>pqp_aad_shd.g_old_rec.current_residency_status
 ,p_nra_to_ra_date_o              =>pqp_aad_shd.g_old_rec.nra_to_ra_date
 ,p_target_departure_date_o       =>pqp_aad_shd.g_old_rec.target_departure_date
 ,p_tax_residence_country_code_o  =>pqp_aad_shd.g_old_rec.tax_residence_country_code
 ,p_treaty_info_update_date_o     =>pqp_aad_shd.g_old_rec.treaty_info_update_date
 ,p_number_of_days_in_usa_o       =>pqp_aad_shd.g_old_rec.number_of_days_in_usa
 ,p_withldg_allow_eligible_fla_o =>pqp_aad_shd.g_old_rec.withldg_allow_eligible_flag
 ,p_ra_effective_date_o           =>pqp_aad_shd.g_old_rec.ra_effective_date
 ,p_record_source_o               =>pqp_aad_shd.g_old_rec.record_source
 ,p_visa_type_o                   =>pqp_aad_shd.g_old_rec.visa_type
 ,p_j_sub_type_o                  =>pqp_aad_shd.g_old_rec.j_sub_type
 ,p_primary_activity_o            =>pqp_aad_shd.g_old_rec.primary_activity
 ,p_non_us_country_code_o         =>pqp_aad_shd.g_old_rec.non_us_country_code
 ,p_citizenship_country_code_o    =>pqp_aad_shd.g_old_rec.citizenship_country_code
 ,p_object_version_number_o       =>pqp_aad_shd.g_old_rec.object_version_number
,p_date_8233_signed_o             =>pqp_aad_shd.g_old_rec.date_8233_signed
,p_date_w4_signed_o               =>pqp_aad_shd.g_old_rec.date_w4_signed
      );

Line: 206

End post_delete;

Line: 232

  pqp_aad_bus.delete_validate(p_rec
  ,p_effective_date);

Line: 237

  pre_delete(p_rec);

Line: 241

  delete_dml(p_rec);

Line: 245

  post_delete(
p_effective_date,p_rec);