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_VLDVER_API SQL Statements

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

Line: 12


procedure Insert_Vldtn_Vern
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,p_WRKPLC_VLDTN_ID               In  Number
  ,p_VERSION_NUMBER                In  Number   Default NULL
  ,p_REMUNERATION_JOB_DESCRIPTION  In  VarChar2 Default NULL
  ,P_TARIFF_CONTRACT_CODE          In  Varchar2
  ,P_TARIFF_GROUP_CODE             In  Varchar2
  ,P_JOB_GROUP_ID                  In  Number   Default NULL
  ,P_REMUNERATION_JOB_ID           In  Number   Default NULL
  ,p_DERIVED_GRADE_ID              In  Number   Default NULL
  ,P_DERIVED_CASE_GROUP_ID         In  Number   Default NULL
  ,P_DERIVED_SUBCASGRP_ID          In  Number   Default NULL
  ,P_USER_ENTERABLE_GRADE_ID       In  Number   Default NULL
  ,P_USER_ENTERABLE_CASE_GROUP_ID  In  Number   Default NULL
  ,P_USER_ENTERABLE_SUBCASGRP_ID   In  Number   Default NULL
  ,P_FREEZE                        In  Varchar2 Default NULL
  ,p_WRKPLC_VLDTN_VER_ID           out nocopy Number
  ,p_object_version_number         out nocopy number) is


  --
  -- Declare cursors and local variables
  --

  l_proc  varchar2(500)   := g_package||'Insert_Vldtn_Vern';

Line: 48


  savepoint Insert_Vldtn_Vern;

Line: 56


  Select Nvl(Max(Version_number),0) + 1 into l_Version_Number
    from Pqh_De_Wrkplc_Vldtn_vers
   where Wrkplc_Vldtn_Id = p_WRKPLC_VLDTN_ID;

Line: 60


   PQH_DE_VLDVER_BK1.Insert_Vldtn_Vern_b
  (p_effective_date                =>  l_Effective_Date
  ,p_business_group_id             =>  p_business_group_id
  ,P_WRKPLC_VLDTN_ID               =>  P_WRKPLC_VLDTN_ID
  ,P_VERSION_NUMBER                =>  l_Version_Number
  ,P_REMUNERATION_JOB_DESCRIPTION  =>  P_REMUNERATION_JOB_DESCRIPTION
  ,P_TARIFF_CONTRACT_CODE          =>  P_TARIFF_CONTRACT_CODE
  ,P_TARIFF_GROUP_CODE             =>  P_TARIFF_GROUP_CODE
  ,P_JOB_GROUP_ID                  =>  P_JOB_GROUP_ID
  ,P_REMUNERATION_JOB_ID           =>  P_REMUNERATION_JOB_ID
  ,P_DERIVED_GRADE_ID              =>  P_DERIVED_GRADE_ID
  ,p_DERIVED_CASE_GROUP_ID         =>  P_REMUNERATION_JOB_ID
  ,p_DERIVED_SUBCASGRP_ID          =>  p_DERIVED_SUBCASGRP_ID
  ,p_USER_ENTERABLE_GRADE_ID       =>  p_USER_ENTERABLE_GRADE_ID
  ,P_USER_ENTERABLE_CASE_GROUP_ID  =>  P_USER_ENTERABLE_CASE_GROUP_ID
  ,P_USER_ENTERABLE_SUBCASGRP_ID   =>  P_USER_ENTERABLE_SUBCASGRP_ID
  ,p_FREEZE                        =>  p_FREEZE);

Line: 82


        (p_module_name => 'Insert_Vldtn_Vern'
        ,p_hook_type   => 'BP'
        );

Line: 118


     PQH_DE_VLDVER_BK1.Insert_Vldtn_Vern_a
     (p_effective_date                =>  l_Effective_Date
     ,p_business_group_id             =>  p_business_group_id
     ,P_WRKPLC_VLDTN_ID               =>  P_WRKPLC_VLDTN_ID
     ,P_VERSION_NUMBER                =>  l_Version_Number
     ,P_REMUNERATION_JOB_DESCRIPTION  =>  P_REMUNERATION_JOB_DESCRIPTION
     ,P_TARIFF_CONTRACT_CODE          =>  P_TARIFF_CONTRACT_CODE
     ,P_TARIFF_GROUP_CODE             =>  P_TARIFF_GROUP_CODE
     ,P_JOB_GROUP_ID                  =>  P_JOB_GROUP_ID
     ,P_REMUNERATION_JOB_ID           =>  P_REMUNERATION_JOB_ID
     ,P_DERIVED_GRADE_ID              =>  P_DERIVED_GRADE_ID
     ,p_DERIVED_CASE_GROUP_ID         =>  P_REMUNERATION_JOB_ID
     ,p_DERIVED_SUBCASGRP_ID          =>  p_DERIVED_SUBCASGRP_ID
     ,p_USER_ENTERABLE_GRADE_ID       =>  p_USER_ENTERABLE_GRADE_ID
     ,P_USER_ENTERABLE_CASE_GROUP_ID  =>  P_USER_ENTERABLE_CASE_GROUP_ID
     ,P_USER_ENTERABLE_SUBCASGRP_ID   =>  P_USER_ENTERABLE_SUBCASGRP_ID
     ,p_FREEZE                        =>  p_FREEZE
     ,p_Wrkplc_Vldtn_Ver_Id           =>  l_Wrkplc_Vldtn_Ver_Id
     ,p_object_version_number         =>  l_object_version_Number);

Line: 141


        (p_module_name => 'Insert_Vldtn_Vern'
        ,p_hook_type   => 'AP'
        );

Line: 165


    rollback to Insert_Vldtn_Vern;

Line: 181


    rollback to Insert_Vldtn_Vern;

Line: 184


end Insert_Vldtn_Vern;

Line: 191


procedure Update_Vldtn_Vern
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,p_WRKPLC_VLDTN_ID               In  Number   Default hr_api.g_Number
  ,P_VERSION_NUMBER                In  Number   Default hr_api.g_Number
  ,P_REMUNERATION_JOB_DESCRIPTION  In  VarChar2 Default hr_api.g_Varchar2
  ,P_TARIFF_CONTRACT_CODE          In  Varchar2 Default hr_api.g_VArchar2
  ,P_TARIFF_GROUP_CODE             In  Varchar2 Default hr_api.g_Varchar2
  ,P_JOB_GROUP_ID                  In  Number   Default hr_api.g_Number
  ,P_REMUNERATION_JOB_ID           In  Number   Default hr_api.g_Number
  ,P_DERIVED_GRADE_ID              In  Number   Default hr_api.g_Number
  ,P_DERIVED_CASE_GROUP_ID         In  Number   Default hr_api.g_Number
  ,P_DERIVED_SUBCASGRP_ID          In  Number   Default hr_api.g_Number
  ,P_USER_ENTERABLE_GRADE_ID       In  Number   Default hr_api.g_Number
  ,P_USER_ENTERABLE_CASE_GROUP_ID  In  Number   Default hr_api.g_Number
  ,P_USER_ENTERABLE_SUBCASGRP_ID   In  Number   Default hr_api.g_Number
  ,P_FREEZE                        In  Varchar2 Default hr_api.g_Varchar2
  ,p_WRKPLC_VLDTN_VER_ID           In  Number
  ,p_object_version_number         in out nocopy number) Is

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

Line: 221


  savepoint Update_Vldtn_Vern;

Line: 231


  PQH_DE_VLDVER_BK2.Update_Vldtn_Vern_b
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,P_WRKPLC_VLDTN_ID               => P_WRKPLC_VLDTN_ID
  ,P_VERSION_NUMBER                => P_VERSION_NUMBER
  ,P_REMUNERATION_JOB_DESCRIPTION  => P_REMUNERATION_JOB_DESCRIPTION
  ,P_TARIFF_CONTRACT_CODE          => P_TARIFF_CONTRACT_CODE
  ,P_TARIFF_GROUP_CODE             => P_TARIFF_GROUP_CODE
  ,P_JOB_GROUP_ID                  => P_JOB_GROUP_ID
  ,P_REMUNERATION_JOB_ID           => P_REMUNERATION_JOB_ID
  ,P_DERIVED_GRADE_ID              => P_DERIVED_GRADE_ID
  ,P_DERIVED_CASE_GROUP_ID         => P_DERIVED_CASE_GROUP_ID
  ,P_DERIVED_SUBCASGRP_ID          => P_DERIVED_SUBCASGRP_ID
  ,P_USER_ENTERABLE_GRADE_ID       => P_USER_ENTERABLE_GRADE_ID
  ,P_USER_ENTERABLE_CASE_GROUP_ID  => P_USER_ENTERABLE_CASE_GROUP_ID
  ,P_USER_ENTERABLE_SUBCASGRP_ID   => P_USER_ENTERABLE_SUBCASGRP_ID
  ,P_FREEZE                        => P_FREEZE
  ,p_WRKPLC_VLDTN_VER_ID           => p_Wrkplc_Vldtn_ver_Id
  ,p_object_version_number         => l_Object_Version_Number);

Line: 254


        (p_module_name => 'Update_Vldtn_Vern'
        ,p_hook_type   => 'BP'
        );

Line: 284


  PQH_DE_VLDVER_BK2.Update_Vldtn_Vern_a
  (p_effective_date                => l_Effective_Date
  ,p_business_group_id             => p_business_group_id
  ,P_WRKPLC_VLDTN_ID               => P_WRKPLC_VLDTN_ID
  ,P_VERSION_NUMBER                => P_VERSION_NUMBER
  ,P_REMUNERATION_JOB_DESCRIPTION  => P_REMUNERATION_JOB_DESCRIPTION
  ,P_TARIFF_CONTRACT_CODE          => P_TARIFF_CONTRACT_CODE
  ,P_TARIFF_GROUP_CODE             => P_TARIFF_GROUP_CODE
  ,P_JOB_GROUP_ID                  => P_JOB_GROUP_ID
  ,P_REMUNERATION_JOB_ID           => P_REMUNERATION_JOB_ID
  ,P_DERIVED_GRADE_ID              => P_DERIVED_GRADE_ID
  ,P_DERIVED_CASE_GROUP_ID         => P_DERIVED_CASE_GROUP_ID
  ,P_DERIVED_SUBCASGRP_ID          => P_DERIVED_SUBCASGRP_ID
  ,P_USER_ENTERABLE_GRADE_ID       => P_USER_ENTERABLE_GRADE_ID
  ,P_USER_ENTERABLE_CASE_GROUP_ID  => P_USER_ENTERABLE_CASE_GROUP_ID
  ,P_USER_ENTERABLE_SUBCASGRP_ID   => P_USER_ENTERABLE_SUBCASGRP_ID
  ,P_FREEZE                        => P_FREEZE
  ,p_WRKPLC_VLDTN_VER_ID           => p_Wrkplc_Vldtn_ver_Id
  ,p_object_version_number         => l_Object_Version_Number);

Line: 308


        (p_module_name => 'Update_Vldtn_Vern'
        ,p_hook_type   => 'AP'
        );

Line: 332


    rollback to Update_Vldtn_Vern;

Line: 345


    rollback to Update_Vldtn_Vern;

Line: 348


end Update_Vldtn_Vern;

Line: 354


procedure delete_Vldtn_Vern
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_Ver_ID           In     Number
  ,p_object_version_number         In     number) Is   --

  -- Declare cursors and local variables
  --
  l_proc           varchar2(72) := g_package||'delete_Vldtn_Vern';

Line: 368


  savepoint delete_Vldtn_Vern;

Line: 373


  PQH_DE_VLDVER_BK3.Delete_Vldtn_Vern_b
  (p_WRKPLC_VLDTN_VERID            =>   p_WRKPLC_VLDTN_VER_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 379


        (p_module_name => 'delete_Vldtn_Vern'
        ,p_hook_type   => 'BP');

Line: 393


   PQH_DE_VLDVER_BK3.Delete_Vldtn_Vern_a
  (p_WRKPLC_VLDTN_VER_ID                => p_WRKPLC_VLDTN_VER_ID
  ,p_object_version_number              => p_object_version_number);

Line: 400


        (p_module_name => 'delete_Vldtn_Vern'
        ,p_hook_type   => 'AP');

Line: 419


    rollback to delete_Vldtn_Vern;

Line: 430


    rollback to delete_Vldtn_Vern;

Line: 433


end delete_Vldtn_Vern;