APPS.PQP_DET_INS SQL Statements

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

Line: 53

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

Line: 65

  insert into pqp_analyzed_alien_details
  (	analyzed_data_details_id,
	analyzed_data_id,
	income_code,
	withholding_rate,
	income_code_sub_type,
	exemption_code,
	maximum_benefit_amount,
	retro_lose_ben_amt_flag,
	date_benefit_ends,
	retro_lose_ben_date_flag,
	nra_exempt_from_ss,
	nra_exempt_from_medicare,
	student_exempt_from_ss,
	student_exempt_from_medicare,
	addl_withholding_flag,
	constant_addl_tax,
	addl_withholding_amt,
	addl_wthldng_amt_period_type,
	personal_exemption,
	addl_exemption_allowed,
	treaty_ben_allowed_flag,
	treaty_benefits_start_date,
	object_version_number,
        retro_loss_notification_sent,
        current_analysis,
        forecast_income_code
  )
  Values
  (	p_rec.analyzed_data_details_id,
	p_rec.analyzed_data_id,
	p_rec.income_code,
	p_rec.withholding_rate,
	p_rec.income_code_sub_type,
	p_rec.exemption_code,
	p_rec.maximum_benefit_amount,
	p_rec.retro_lose_ben_amt_flag,
	p_rec.date_benefit_ends,
	p_rec.retro_lose_ben_date_flag,
	p_rec.nra_exempt_from_ss,
	p_rec.nra_exempt_from_medicare,
	p_rec.student_exempt_from_ss,
	p_rec.student_exempt_from_medicare,
	p_rec.addl_withholding_flag,
	p_rec.constant_addl_tax,
	p_rec.addl_withholding_amt,
	p_rec.addl_wthldng_amt_period_type,
	p_rec.personal_exemption,
	p_rec.addl_exemption_allowed,
	p_rec.treaty_ben_allowed_flag,
	p_rec.treaty_benefits_start_date,
	p_rec.object_version_number,
        p_rec.retro_loss_notification_sent,
        p_rec.current_analysis,
        p_rec.forecast_income_code
  );

Line: 144

End insert_dml;

Line: 183

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

Line: 187

  Cursor C_Sel1 is select pqp_analyzed_alien_details_s.nextval from sys.dual;

Line: 200

End pre_insert;

Line: 234

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

Line: 247

    pqp_det_rki.after_insert
      (
  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
      );

Line: 292

End post_insert;

Line: 310

  pqp_det_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 315

  pre_insert(p_rec);

Line: 319

  insert_dml(p_rec);

Line: 323

  post_insert(
p_effective_date,p_rec);