APPS.PQP_DET_UPD SQL Statements

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

Line: 54

Procedure update_dml(p_rec in out nocopy pqp_det_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 69

  update pqp_analyzed_alien_details
  set
  analyzed_data_details_id          = p_rec.analyzed_data_details_id,
  analyzed_data_id                  = p_rec.analyzed_data_id,
  income_code                       = p_rec.income_code,
  withholding_rate                  = p_rec.withholding_rate,
  income_code_sub_type              = p_rec.income_code_sub_type,
  exemption_code                    = p_rec.exemption_code,
  maximum_benefit_amount            = p_rec.maximum_benefit_amount,
  retro_lose_ben_amt_flag           = p_rec.retro_lose_ben_amt_flag,
  date_benefit_ends                 = p_rec.date_benefit_ends,
  retro_lose_ben_date_flag          = p_rec.retro_lose_ben_date_flag,
  nra_exempt_from_ss                = p_rec.nra_exempt_from_ss,
  nra_exempt_from_medicare          = p_rec.nra_exempt_from_medicare,
  student_exempt_from_ss            = p_rec.student_exempt_from_ss,
  student_exempt_from_medicare      = p_rec.student_exempt_from_medicare,
  addl_withholding_flag             = p_rec.addl_withholding_flag,
  constant_addl_tax                 = p_rec.constant_addl_tax,
  addl_withholding_amt              = p_rec.addl_withholding_amt,
  addl_wthldng_amt_period_type      = p_rec.addl_wthldng_amt_period_type,
  personal_exemption                = p_rec.personal_exemption,
  addl_exemption_allowed            = p_rec.addl_exemption_allowed,
  treaty_ben_allowed_flag           = p_rec.treaty_ben_allowed_flag,
  treaty_benefits_start_date        = p_rec.treaty_benefits_start_date,
  object_version_number             = p_rec.object_version_number,
  retro_loss_notification_sent      = p_rec.retro_loss_notification_sent,
  current_analysis                  = p_rec.current_analysis,
  forecast_income_code              = p_rec.forecast_income_code
  where analyzed_data_details_id    = p_rec.analyzed_data_details_id;

Line: 122

End update_dml;

Line: 156

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

Line: 164

End pre_update;

Line: 198

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

Line: 211

    pqp_det_rku.after_update
      (
  p_analyzed_data_details_id      =>p_rec.analyzed_data_details_id
 ,p_analyzed_data_id              =>p_rec.analyzed_data_id
 ,p_income_code                   =>p_rec.income_code
 ,p_withholding_rate              =>p_rec.withholding_rate
 ,p_income_code_sub_type          =>p_rec.income_code_sub_type
 ,p_exemption_code                =>p_rec.exemption_code
 ,p_maximum_benefit_amount        =>p_rec.maximum_benefit_amount
 ,p_retro_lose_ben_amt_flag       =>p_rec.retro_lose_ben_amt_flag
 ,p_date_benefit_ends             =>p_rec.date_benefit_ends
 ,p_retro_lose_ben_date_flag      =>p_rec.retro_lose_ben_date_flag
 ,p_nra_exempt_from_ss            =>p_rec.nra_exempt_from_ss
 ,p_nra_exempt_from_medicare      =>p_rec.nra_exempt_from_medicare
 ,p_student_exempt_from_ss        =>p_rec.student_exempt_from_ss
 ,p_student_exempt_from_medi      =>p_rec.student_exempt_from_medicare
 ,p_addl_withholding_flag         =>p_rec.addl_withholding_flag
 ,p_constant_addl_tax             =>p_rec.constant_addl_tax
 ,p_addl_withholding_amt          =>p_rec.addl_withholding_amt
 ,p_addl_wthldng_amt_period_type  =>p_rec.addl_wthldng_amt_period_type
 ,p_personal_exemption            =>p_rec.personal_exemption
 ,p_addl_exemption_allowed        =>p_rec.addl_exemption_allowed
 ,p_treaty_ben_allowed_flag       =>p_rec.treaty_ben_allowed_flag
 ,p_treaty_benefits_start_date    =>p_rec.treaty_benefits_start_date
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_retro_loss_notification_sent  =>p_rec.retro_loss_notification_sent
 ,p_current_analysis              =>p_rec.current_analysis
 ,p_forecast_income_code          =>p_rec.forecast_income_code
 ,p_analyzed_data_id_o            =>pqp_det_shd.g_old_rec.analyzed_data_id
 ,p_income_code_o                 =>pqp_det_shd.g_old_rec.income_code
 ,p_withholding_rate_o            =>pqp_det_shd.g_old_rec.withholding_rate
 ,p_income_code_sub_type_o        =>pqp_det_shd.g_old_rec.income_code_sub_type
 ,p_exemption_code_o              =>pqp_det_shd.g_old_rec.exemption_code
 ,p_maximum_benefit_amount_o      =>pqp_det_shd.g_old_rec.maximum_benefit_amount
 ,p_retro_lose_ben_amt_flag_o     =>pqp_det_shd.g_old_rec.retro_lose_ben_amt_flag
 ,p_date_benefit_ends_o           =>pqp_det_shd.g_old_rec.date_benefit_ends
 ,p_retro_lose_ben_date_flag_o    =>pqp_det_shd.g_old_rec.retro_lose_ben_date_flag
 ,p_nra_exempt_from_ss_o          =>pqp_det_shd.g_old_rec.nra_exempt_from_ss
 ,p_nra_exempt_from_medicare_o    =>pqp_det_shd.g_old_rec.nra_exempt_from_medicare
 ,p_student_exempt_from_ss_o      =>pqp_det_shd.g_old_rec.student_exempt_from_ss
 ,p_student_exempt_from_medi_o    =>pqp_det_shd.g_old_rec.student_exempt_from_medicare
 ,p_addl_withholding_flag_o       =>pqp_det_shd.g_old_rec.addl_withholding_flag
 ,p_constant_addl_tax_o           =>pqp_det_shd.g_old_rec.constant_addl_tax
 ,p_addl_withholding_amt_o        =>pqp_det_shd.g_old_rec.addl_withholding_amt
 ,p_addl_wthldng_amt_period_ty_o  =>pqp_det_shd.g_old_rec.addl_wthldng_amt_period_type
 ,p_personal_exemption_o          =>pqp_det_shd.g_old_rec.personal_exemption
 ,p_addl_exemption_allowed_o      =>pqp_det_shd.g_old_rec.addl_exemption_allowed
 ,p_treaty_ben_allowed_flag_o     =>pqp_det_shd.g_old_rec.treaty_ben_allowed_flag
 ,p_treaty_benefits_start_date_o  =>pqp_det_shd.g_old_rec.treaty_benefits_start_date
 ,p_object_version_number_o       =>pqp_det_shd.g_old_rec.object_version_number
 ,p_retro_loss_notif_sent_o       =>pqp_det_shd.g_old_rec.retro_loss_notification_sent
 ,p_current_analysis_o            =>pqp_det_shd.g_old_rec.current_analysis
 ,p_forecast_income_code_o        =>pqp_det_shd.g_old_rec.forecast_income_code
      );

Line: 281

End post_update;

Line: 470

  pqp_det_bus.update_validate(p_rec
  ,p_effective_date);

Line: 475

  pre_update(p_rec);

Line: 479

  update_dml(p_rec);

Line: 483

  post_update(
p_effective_date,p_rec);