eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_DE_VLD_NEWVER_DEL SQL Statements

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

Line: 20


  Select b.Wrkplc_Vldtn_Id,VALIDATION_NAME, EMPLOYMENT_TYPE, REMUNERATION_REGULATION, WRKPLC_VLDTN_VER_ID, VERSION_NUMBER,
         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,
         Tariff_contract_code, Tariff_Group_Code
   From  Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a
   Where a.WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID and
         a.Business_Group_Id   = P_Business_Group_Id   and
         b.Wrkplc_Vldtn_Id     = a.Wrkplc_Vldtn_Id     and
         b.Business_Group_Id   = a.Business_Group_Id;

Line: 31


 Select  WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE
   From  Pqh_De_Wrkplc_Vldtn_Ops
   Where Wrkplc_Vldtn_Ver_Id = P_Wrkplc_Vldtn_Ver_Id and
         Business_Group_id   = P_Business_Group_Id;

Line: 37


 Select  WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION
   From  Pqh_De_Wrkplc_Vldtn_Jobs
  Where  Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
         Business_Group_Id  = p_Business_Group_Id;

Line: 43


 Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE
   From PQH_DE_WRKPLC_VLDTN_JOBFTRS
  Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
        WRKPLC_VLDTN_OPR_JOB_ID   = P_Wrkplc_Vldtn_OpJob_Id    and
        Business_group_id         = p_Business_group_id;

Line: 50


 Select WRKPLC_VLDTN_LVLNUM_ID, LEVEL_NUMBER_ID, LEVEL_CODE_ID
   From Pqh_De_Wrkplc_Vldtn_Lvlnums
  where Wrkplc_Vldtn_Ver_id = p_WRKPLC_VLDTN_VER_ID and
        Business_group_Id   = p_Business_Group_Id;

Line: 60


  PQH_DE_VLDVER_API.Insert_Vldtn_Vern
  (p_effective_date                => Trunc(Sysdate)
  ,p_business_group_id             => p_Business_group_id
  ,p_WRKPLC_VLDTN_ID               => Defrec.Wrkplc_Vldtn_Id
  ,P_VERSION_NUMBER                => Defrec.version_number
  ,P_REMUNERATION_JOB_DESCRIPTION  => Defrec.REMUNERATION_JOB_DESCRIPTION
  ,P_TARIFF_CONTRACT_CODE          => Defrec.Tariff_Contract_Code
  ,P_TARIFF_GROUP_CODE             => Defrec.Tariff_Group_Code
  ,P_JOB_GROUP_ID                  => Defrec.Job_Group_Id
  ,P_REMUNERATION_JOB_ID           => Defrec.Remuneration_Job_Id
  ,P_DERIVED_GRADE_ID              => Defrec.Derived_Grade_Id
  ,P_DERIVED_CASE_GROUP_ID         => Defrec.Derived_Case_Group_Id
  ,P_DERIVED_SUBCASGRP_ID          => Defrec.Derived_Subcasgrp_Id
  ,P_USER_ENTERABLE_GRADE_ID       => Defrec.USER_ENTERABLE_GRADE_ID
  ,P_USER_ENTERABLE_CASE_GROUP_ID  => Defrec.USER_ENTERABLE_CASE_GROUP_ID
  ,P_USER_ENTERABLE_SUBCASGRP_ID   => Defrec.USER_ENTERABLE_SUBCASGRP_ID
  ,P_FREEZE                        => 'U'
  ,p_WRKPLC_VLDTN_VER_ID           => l_Wrkplc_Vldtn_ver_Id
  ,p_object_version_number         => l_Object_Version_Number);

Line: 86


         PQH_DE_VLDOPR_API.Insert_Vldtn_Oprn
         (p_effective_date         => Trunc(Sysdate)
         ,p_business_group_id      => P_Business_Group_Id
         ,p_WRKPLC_VLDTN_VER_ID    => l_Wrkplc_Vldtn_Ver_Id
         ,P_WRKPLC_OPERATION_ID    => Oprrec.Wrkplc_Operation_Id
         ,P_DESCRIPTION            => Oprrec.Description
         ,P_UNIT_PERCENTAGE        => Oprrec.Unit_Percentage
         ,P_WRKPLC_VLDTN_OP_ID     => l_Wrkplc_Vldtn_Op_Id
         ,p_object_version_number  => l_Opr_Object_Version_Number);

Line: 99


           PQH_DE_VLDJOBFTR_API.Insert_Vldtn_JObftr
           (p_effective_date            => Trunc(Sysdate)
           ,p_business_group_id         => p_Business_Group_Id
           ,p_WRKPLC_VLDTN_OPR_JOB_ID   => l_Wrkplc_Vldtn_Op_Id
           ,P_JOB_FEATURE_CODE          => JobFtrRec.JOB_FEATURE_CODE
           ,P_Wrkplc_Vldtn_Opr_job_Type => 'O'
           ,P_WRKPLC_VLDTN_JObFTR_ID    => l_WRKPLC_VLDTN_JObFTR_ID
           ,p_object_version_number     => l_Jobftr_Object_Version_Number);

Line: 110


            PQH_DE_VLDJOB_API.Insert_Vldtn_JOb
            (p_effective_date           => Trunc(Sysdate)
            ,p_business_group_id        => p_Business_Group_Id
            ,p_WRKPLC_VLDTN_OP_ID       => l_Wrkplc_Vldtn_Op_Id
            ,P_WRKPLC_JOB_ID            => JobRec.Wrkplc_Job_Id
            ,P_DESCRIPTION              => Jobrec.Description
            ,P_WRKPLC_VLDTN_JOb_ID      => l_Wrkplc_Vldtn_Job_Id
            ,p_object_version_number    => l_Job_Object_Version_Number);

Line: 122


                PQH_DE_VLDJOBFTR_API.Insert_Vldtn_JObftr
                (p_effective_date            => Trunc(Sysdate)
                ,p_business_group_id         => p_Business_Group_Id
                ,p_WRKPLC_VLDTN_OPR_JOB_ID   => l_Wrkplc_Vldtn_Op_Id
                ,P_JOB_FEATURE_CODE          => JobFtrRec.JOB_FEATURE_CODE
                ,P_Wrkplc_Vldtn_Opr_job_Type => 'J'
                ,P_WRKPLC_VLDTN_JObFTR_ID    => l_WRKPLC_VLDTN_JObFTR_ID
                ,p_object_version_number     => l_Jobftr_Object_Version_Number);

Line: 137


          PQH_DE_VLDLVL_API.Insert_Vldtn_Lvl
          (p_effective_date                => Trunc(Sysdate)
          ,p_business_group_id             => p_Business_Group_Id
          ,P_WRKPLC_VLDTN_VER_ID           => l_Wrkplc_Vldtn_Ver_Id
          ,P_LEVEL_NUMBER_ID               => lvlrec.LEVEL_NUMBER_ID
          ,P_LEVEL_CODE_ID                 => lvlrec.Level_Code_Id
          ,P_WRKPLC_VLDTN_LVLNUM_Id        => l_WRKPLC_VLDTN_LVLNUM_Id
          ,p_object_version_number         => l_lvlnum_Object_Version_Number);

Line: 150


 Procedure PQH_DE_DELETE_VERSION
 (p_WRKPLC_VLDTN_VER_ID In Number,
  P_Business_Group_Id   In Number)  is

  Cursor wrkplc_vldtn_defn is
  Select b.Wrkplc_Vldtn_Id,VALIDATION_NAME, EMPLOYMENT_TYPE, REMUNERATION_REGULATION, WRKPLC_VLDTN_VER_ID, VERSION_NUMBER,
         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,
         a.Object_Version_Number Vers_ovn_Num, b.Object_Version_Number Def_ovn_Num
   From  Pqh_De_Wrkplc_Vldtns b, Pqh_De_Wrkplc_Vldtn_Vers a
   Where a.WRKPLC_VLDTN_VER_ID = p_WRKPLC_VLDTN_VER_ID and
         a.Business_Group_Id   = P_Business_Group_Id   and
         b.Wrkplc_Vldtn_Id     = a.Wrkplc_Vldtn_Id     and
         b.Business_Group_Id   = a.Business_Group_Id;

Line: 166


 Select  WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE, Object_Version_Number
   From  Pqh_De_Wrkplc_Vldtn_Ops
   Where Wrkplc_Vldtn_Ver_Id = P_Wrkplc_Vldtn_Ver_Id and
         Business_Group_id   = P_Business_Group_Id;

Line: 172


 Select  WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
   From  Pqh_De_Wrkplc_Vldtn_Jobs
  Where  Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
         Business_Group_Id  = p_Business_Group_Id;

Line: 178


 Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
   From PQH_DE_WRKPLC_VLDTN_JOBFTRS
  Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
        WRKPLC_VLDTN_OPR_JOB_ID   = P_Wrkplc_Vldtn_OpJob_Id    and
        Business_group_id         = p_Business_group_id;

Line: 185


 Select WRKPLC_VLDTN_LVLNUM_ID, LEVEL_NUMBER_ID, LEVEL_CODE_ID, Object_Version_Number
   From Pqh_De_Wrkplc_Vldtn_Lvlnums
  where Wrkplc_Vldtn_Ver_id = p_WRKPLC_VLDTN_VER_ID and
        Business_group_Id   = p_Business_Group_Id;

Line: 209


                PQH_DE_VLDJOBFTR_API.Delete_Vldtn_JobFtr
                (p_WRKPLC_VLDTN_JobFtr_Id        => Jobftrrec.WRKPLC_VLDTN_JOBFTR_ID
                ,p_object_version_number         => Jobftrrec.Object_Version_Number);

Line: 220


                PQH_DE_VLDJOBFTR_API.Delete_Vldtn_JobFtr
                (p_WRKPLC_VLDTN_JobFtr_Id        => Jobftrrec.WRKPLC_VLDTN_JOBFTR_ID
                ,p_object_version_number         => Jobftrrec.Object_Version_Number);

Line: 226


               PQH_DE_VLDJOB_API.Delete_Vldtn_Job
               (p_WRKPLC_VLDTN_Job_Id           => Jobrec.WRKPLC_VLDTN_Job_Id
               ,p_object_version_number         => Jobrec.Object_Version_Number);

Line: 232


           Pqh_de_vldopr_Api.delete_Vldtn_Oprn
           (p_WRKPLC_VLDTN_OP_ID          => oprrec.Wrkplc_vldtn_op_id
           ,p_object_version_number       => Oprrec.Object_version_number);

Line: 242


           PQH_DE_VLDLVL_API.Delete_Vldtn_Lvl
           (P_WRKPLC_VLDTN_Lvlnum_Id      => Lvlrec.WRKPLC_VLDTN_Lvlnum_Id
           ,p_object_version_number       => Lvlrec.Object_Version_Number);

Line: 251


    PQH_DE_VLDVER_API.Delete_Vldtn_Vern
    (p_WRKPLC_VLDTN_VER_ID          => Defrec.WRKPLC_VLDTN_VER_ID
    ,p_object_version_number        => Defrec.Vers_ovn_Num);

Line: 255


    Select Count(*) into l_vldcnt
    from  Pqh_De_Wrkplc_Vldtn_vers
    Where WRKPLC_VLDTN_ID = Defrec.WRKPLC_VLDTN_ID;

Line: 260


       PQH_DE_VLDDEF_API.Delete_Vldtn_Defn
       (p_WRKPLC_VLDTN_ID             => Defrec.WRKPLC_VLDTN_ID
       ,p_object_version_number       => Defrec.Def_ovn_Num);

Line: 268


 Procedure PQH_DE_DELETE_OPERATION
 (p_WRKPLC_VLDTN_OP_ID  In Number,
  P_Business_Group_Id   In Number)  is

 Cursor  Wrkplc_Vldtn_Oprs is
 Select  WRKPLC_VLDTN_OP_ID, WRKPLC_OPERATION_ID, DESCRIPTION, UNIT_PERCENTAGE, Object_Version_Number
   From  Pqh_De_Wrkplc_Vldtn_Ops
   Where WRKPLC_VLDTN_OP_ID  = P_WRKPLC_VLDTN_OP_ID and
         Business_Group_id   = P_Business_Group_Id;

Line: 279


 Select  WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
   From  Pqh_De_Wrkplc_Vldtn_Jobs
  Where  Wrkplc_Vldtn_Op_Id = P_Wrkplc_Vldtn_Op_Id and
         Business_Group_Id  = p_Business_Group_Id;

Line: 285


 Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
   From PQH_DE_WRKPLC_VLDTN_JOBFTRS
  Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
        WRKPLC_VLDTN_OPR_JOB_ID   = P_Wrkplc_Vldtn_OpJob_Id    and
        Business_group_id         = p_Business_group_id;

Line: 299


         PQH_DE_VLDJOBFTR_API.Delete_Vldtn_JobFtr
         (p_WRKPLC_VLDTN_JobFtr_Id        => Jobftrrec.WRKPLC_VLDTN_JOBFTR_ID
         ,p_object_version_number         => Jobftrrec.Object_Version_Number);

Line: 309


              PQH_DE_VLDJOBFTR_API.Delete_Vldtn_JobFtr
              (p_WRKPLC_VLDTN_JobFtr_Id        => Jobftrrec.WRKPLC_VLDTN_JOBFTR_ID
              ,p_object_version_number         => Jobftrrec.Object_Version_Number);

Line: 313


           PQH_DE_VLDJOB_API.Delete_Vldtn_Job
           (p_WRKPLC_VLDTN_Job_Id           => Jobrec.WRKPLC_VLDTN_Job_Id
            ,p_object_version_number         => Jobrec.Object_Version_Number);

Line: 318


      Pqh_de_vldopr_Api.delete_Vldtn_Oprn
      (p_WRKPLC_VLDTN_OP_ID          => oprrec.Wrkplc_vldtn_op_id
      ,p_object_version_number       => Oprrec.Object_version_number);

Line: 326


Procedure PQH_DE_DELETE_JOB
 (p_WRKPLC_VLDTN_JOB_ID  In Number,
  P_Business_Group_Id   In Number)  is

 Cursor  Wrkplc_Vldtn_Jobs  is
 Select  WRKPLC_VLDTN_JOB_ID, WRKPLC_JOB_ID, DESCRIPTION, Object_version_Number
   From  Pqh_De_Wrkplc_Vldtn_Jobs
  Where  Wrkplc_Vldtn_Job_Id = p_WRKPLC_VLDTN_JOB_ID and
         Business_Group_Id   = p_Business_Group_Id;

Line: 337


 Select WRKPLC_VLDTN_JOBFTR_ID, JOB_FEATURE_CODE, Object_Version_Number
   From PQH_DE_WRKPLC_VLDTN_JOBFTRS
  Where WRKPLC_VLDTN_OPR_JOB_TYPE = P_Wrkplc_Vldtn_OprJob_Type and
        WRKPLC_VLDTN_OPR_JOB_ID   = P_Wrkplc_Vldtn_OpJob_Id    and
        Business_group_id         = p_Business_group_id;

Line: 351


        PQH_DE_VLDJOBFTR_API.Delete_Vldtn_JobFtr
        (p_WRKPLC_VLDTN_JobFtr_Id        => Jobftrrec.WRKPLC_VLDTN_JOBFTR_ID
        ,p_object_version_number         => Jobftrrec.Object_Version_Number);

Line: 355


     PQH_DE_VLDJOB_API.Delete_Vldtn_Job
     (p_WRKPLC_VLDTN_Job_Id           => Jobrec.WRKPLC_VLDTN_Job_Id
     ,p_object_version_number         => Jobrec.Object_Version_Number);

Line: 379


 Select count(*)  from
        pqh_de_wrkplc_vldtn_lvlnums
  where WRKPLC_VLDTN_VER_ID             = p_Wrkplc_Val_Ver_Id
    and LEVEL_NUMBER_ID         	= p_Lvl_Number_Id
    and LEVEL_CODE_ID  			= p_Lvl_Code_Id;

Line: 392


	pqh_de_vldlvl_swi.UPDATE_VLDTN_LVL
	 (
	   p_effective_date               	=> P_EFFECTIVE_DATE
	  ,p_business_group_id                  => P_BUSINESS_GROUP_ID
	  ,p_wrkplc_vldtn_ver_id                => P_WRKPLC_VLDTN_VER_ID
	  ,p_level_number_id                    => P_LEVEL_NUMBER_ID
	  ,p_level_code_id                      => P_LEVEL_CODE_ID
	  ,p_wrkplc_vldtn_lvlnum_id             => P_WRKPLC_VLDTN_LVLNUM_ID
	  ,p_object_version_number              => P_OBJECT_VERSION_NUMBER
	  ,p_return_status       		=> P_RETURN_STATUS
	 );

Line: 408


	pqh_de_vldlvl_swi.INSERT_VLDTN_LVL
	  (
	     p_effective_date               => P_EFFECTIVE_DATE
	    ,p_business_group_id            => P_BUSINESS_GROUP_ID
	    ,p_wrkplc_vldtn_ver_id          => P_WRKPLC_VLDTN_VER_ID
	    ,p_level_number_id              => P_LEVEL_NUMBER_ID
	    ,p_level_code_id                => P_LEVEL_CODE_ID
	    ,p_wrkplc_vldtn_lvlnum_id       => P_WRKPLC_VLDTN_LVLNUM_ID
	    ,p_object_version_number        => P_OBJECT_VERSION_NUMBER
            ,p_return_status                => P_RETURN_STATUS
          );