APPS.PQH_VLD_INS SQL Statements

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

Line: 75

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

Line: 89

  insert into pqh_fr_validations
      (validation_id
      ,pension_fund_type_code
      ,pension_fund_id
      ,business_group_id
      ,person_id
      ,request_date
      ,completion_date
      ,previous_employer_id
      ,previously_validated_flag
      ,status
      ,employer_amount
      ,employer_currency_code
      ,employee_amount
      ,employee_currency_code
      ,deduction_per_period
      ,deduction_currency_code
      ,percent_of_salary
      ,object_version_number
      )
  Values
    (p_rec.validation_id
    ,p_rec.pension_fund_type_code
    ,p_rec.pension_fund_id
    ,p_rec.business_group_id
    ,p_rec.person_id
    ,p_rec.request_date
    ,p_rec.completion_date
    ,p_rec.previous_employer_id
    ,p_rec.previously_validated_flag
    ,p_rec.status
    ,p_rec.employer_amount
    ,p_rec.employer_currency_code
    ,p_rec.employee_amount
    ,p_rec.employee_currency_code
    ,p_rec.deduction_per_period
    ,p_rec.deduction_currency_code
    ,p_rec.percent_of_salary
    ,p_rec.object_version_number
    );

Line: 152

End insert_dml;

Line: 191

Procedure pre_insert
  (p_rec  in out nocopy pqh_vld_shd.g_rec_type
  ) is
--
  Cursor C_Sel1 is select pqh_fr_validations_s.nextval from sys.dual;

Line: 198

    Select null
      from pqh_fr_validations
     where validation_id =
             pqh_vld_ins.g_validation_id_i;

Line: 203

  l_proc   varchar2(72) := g_package||'pre_insert';

Line: 244

End pre_insert;

Line: 278

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

Line: 289

    pqh_vld_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_validation_id
      => p_rec.validation_id
      ,p_pension_fund_type_code
      => p_rec.pension_fund_type_code
      ,p_pension_fund_id
      => p_rec.pension_fund_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_person_id
      => p_rec.person_id
      ,p_request_date
      => p_rec.request_date
      ,p_completion_date
      => p_rec.completion_date
      ,p_previous_employer_id
      => p_rec.previous_employer_id
      ,p_previously_validated_flag
      => p_rec.previously_validated_flag
      ,p_status
      => p_rec.status
      ,p_employer_amount
      => p_rec.employer_amount
      ,p_employer_currency_code
      => p_rec.employer_currency_code
      ,p_employee_amount
      => p_rec.employee_amount
      ,p_employee_currency_code
      => p_rec.employee_currency_code
      ,p_deduction_per_period
      => p_rec.deduction_per_period
      ,p_deduction_currency_code
      => p_rec.deduction_currency_code
      ,p_percent_of_salary
      => p_rec.percent_of_salary
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 340

End post_insert;

Line: 357

  pqh_vld_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 367

  pqh_vld_ins.pre_insert(p_rec);

Line: 371

  pqh_vld_ins.insert_dml(p_rec);

Line: 375

  pqh_vld_ins.post_insert
     (p_effective_date
     ,p_rec
     );