APPS.PQP_AAD_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_aad_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_dml';

Line: 65

  insert into pqp_analyzed_alien_data
  (	analyzed_data_id,
	assignment_id,
	data_source,
	tax_year,
	current_residency_status,
	nra_to_ra_date,
	target_departure_date,
	tax_residence_country_code,
	treaty_info_update_date,
	number_of_days_in_usa,
	withldg_allow_eligible_flag,
	ra_effective_date,
	record_source,
	visa_type,
	j_sub_type,
	primary_activity,
	non_us_country_code,
	citizenship_country_code,
	object_version_number ,
        date_8233_signed,
        date_w4_signed
  )
  Values
  (	p_rec.analyzed_data_id,
	p_rec.assignment_id,
	p_rec.data_source,
	p_rec.tax_year,
	p_rec.current_residency_status,
	p_rec.nra_to_ra_date,
	p_rec.target_departure_date,
	p_rec.tax_residence_country_code,
	p_rec.treaty_info_update_date,
	p_rec.number_of_days_in_usa,
	p_rec.withldg_allow_eligible_flag,
	p_rec.ra_effective_date,
	p_rec.record_source,
	p_rec.visa_type,
	p_rec.j_sub_type,
	p_rec.primary_activity,
	p_rec.non_us_country_code,
	p_rec.citizenship_country_code,
	p_rec.object_version_number ,
        p_rec.date_8233_signed,
        p_rec.date_w4_signed
  );

Line: 134

End insert_dml;

Line: 173

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

Line: 177

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

Line: 190

End pre_insert;

Line: 224

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

Line: 237

    pqp_aad_rki.after_insert
      (
  p_analyzed_data_id              =>p_rec.analyzed_data_id
 ,p_assignment_id                 =>p_rec.assignment_id
 ,p_data_source                   =>p_rec.data_source
 ,p_tax_year                      =>p_rec.tax_year
 ,p_current_residency_status      =>p_rec.current_residency_status
 ,p_nra_to_ra_date                =>p_rec.nra_to_ra_date
 ,p_target_departure_date         =>p_rec.target_departure_date
 ,p_tax_residence_country_code    =>p_rec.tax_residence_country_code
 ,p_treaty_info_update_date       =>p_rec.treaty_info_update_date
 ,p_number_of_days_in_usa         =>p_rec.number_of_days_in_usa
 ,p_withldg_allow_eligible_flag   =>p_rec.withldg_allow_eligible_flag
 ,p_ra_effective_date             =>p_rec.ra_effective_date
 ,p_record_source                 =>p_rec.record_source
 ,p_visa_type                     =>p_rec.visa_type
 ,p_j_sub_type                    =>p_rec.j_sub_type
 ,p_primary_activity              =>p_rec.primary_activity
 ,p_non_us_country_code           =>p_rec.non_us_country_code
 ,p_citizenship_country_code      =>p_rec.citizenship_country_code
 ,p_object_version_number         =>p_rec.object_version_number
 ,p_effective_date                =>p_effective_date
 ,p_date_8233_signed              =>p_rec.date_8233_signed
 ,p_date_w4_signed                =>p_rec.date_w4_signed
      );

Line: 277

End post_insert;

Line: 295

  pqp_aad_bus.insert_validate(p_rec
  ,p_effective_date);

Line: 300

  pre_insert(p_rec);

Line: 304

  insert_dml(p_rec);

Line: 308

  post_insert(
p_effective_date,p_rec);

Line: 326

  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_date_8233_signed             in date             default null,
  p_date_w4_signed               in date             default null
  ) is
--
  l_rec	  pqp_aad_shd.g_rec_type;

Line: 361

  p_treaty_info_update_date,
  p_number_of_days_in_usa,
  p_withldg_allow_eligible_flag,
  p_ra_effective_date,
  p_record_source,
  p_visa_type,
  p_j_sub_type,
  p_primary_activity,
  p_non_us_country_code,
  p_citizenship_country_code,
  null ,
  p_date_8233_signed,
  p_date_w4_signed
  );