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

Line: 89

  insert into pqh_de_wrkplc_vldtn_vers
      (wrkplc_vldtn_ver_id
      ,wrkplc_vldtn_id
      ,version_number
      ,business_group_id
      ,tariff_contract_code
      ,tariff_group_code
      ,remuneration_job_description
      ,job_group_id
      ,remuneration_job_id
      ,derived_grade_id
      ,derived_case_group_id
      ,derived_subcasgrp_id
      ,user_enterable_grade_id
      ,user_enterable_case_group_id
      ,user_enterable_subcasgrp_id
      ,freeze
      ,object_version_number
      )
  Values
    (p_rec.wrkplc_vldtn_ver_id
    ,p_rec.wrkplc_vldtn_id
    ,p_rec.version_number
    ,p_rec.business_group_id
    ,p_rec.tariff_contract_code
    ,p_rec.tariff_group_code
    ,p_rec.remuneration_job_description
    ,p_rec.job_group_id
    ,p_rec.remuneration_job_id
    ,p_rec.derived_grade_id
    ,p_rec.derived_case_group_id
    ,p_rec.derived_subcasgrp_id
    ,p_rec.user_enterable_grade_id
    ,p_rec.user_enterable_case_group_id
    ,p_rec.user_enterable_subcasgrp_id
    ,p_rec.freeze
    ,p_rec.object_version_number
    );

Line: 150

End insert_dml;

Line: 189

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

Line: 196

    Select null
      from pqh_de_wrkplc_vldtn_vers
     where wrkplc_vldtn_ver_id =
             pqh_ver_ins.g_wrkplc_vldtn_ver_id_i;

Line: 201

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

Line: 242

End pre_insert;

Line: 276

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

Line: 287

    pqh_ver_rki.after_insert
      (p_effective_date              => p_effective_date
      ,p_wrkplc_vldtn_ver_id
      => p_rec.wrkplc_vldtn_ver_id
      ,p_wrkplc_vldtn_id
      => p_rec.wrkplc_vldtn_id
      ,p_version_number
      => p_rec.version_number
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_tariff_contract_code
      => p_rec.tariff_contract_code
      ,p_tariff_group_code
      => p_rec.tariff_group_code
      ,p_remuneration_job_description
      => p_rec.remuneration_job_description
      ,p_job_group_id
      => p_rec.job_group_id
      ,p_remuneration_job_id
      => p_rec.remuneration_job_id
      ,p_derived_grade_id
      => p_rec.derived_grade_id
      ,p_derived_case_group_id
      => p_rec.derived_case_group_id
      ,p_derived_subcasgrp_id
      => p_rec.derived_subcasgrp_id
      ,p_user_enterable_grade_id
      => p_rec.user_enterable_grade_id
      ,p_user_enterable_case_group_id
      => p_rec.user_enterable_case_group_id
      ,p_user_enterable_subcasgrp_id
      => p_rec.user_enterable_subcasgrp_id
      ,p_freeze
      => p_rec.freeze
      ,p_object_version_number
      => p_rec.object_version_number
      );

Line: 336

End post_insert;

Line: 354

  pqh_ver_bus.insert_validate
     (p_effective_date
     ,p_rec
     );

Line: 365

  pqh_ver_ins.pre_insert(p_rec);

Line: 369

  pqh_ver_ins.insert_dml(p_rec);

Line: 373

  pqh_ver_ins.post_insert
     (p_effective_date
     ,p_rec
     );