APPS.PQH_DE_VLDLVL_API SQL Statements

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

Line: 12

procedure Insert_Vldtn_Lvl
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number
  ,P_WRKPLC_VLDTN_VER_ID           In  Number
  ,P_LEVEL_NUMBER_ID               In  Number
  ,P_LEVEL_CODE_ID                 In  Number
  ,P_WRKPLC_VLDTN_LVLNUM_Id        out nocopy Number
  ,p_object_version_number         out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 35

  savepoint Insert_Vldtn_Lvl;

Line: 44

   PQH_DE_VLDLVL_BK1.Insert_Vldtn_LVL_b
   (p_effective_date             => L_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);

Line: 55

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

Line: 77

     PQH_DE_VLDLVL_BK1.Insert_Vldtn_LVL_a
     (p_effective_date               => l_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       => l_WRKPLC_VLDTN_LVLNUM_ID
     ,p_object_version_number        => l_object_version_number);

Line: 89

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

Line: 113

    rollback to Insert_Vldtn_Lvl;

Line: 129

    rollback to Insert_Vldtn_Lvl;

Line: 132

end Insert_Vldtn_Lvl;

Line: 139

procedure Update_Vldtn_Lvl
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_business_group_id             in  number   Default hr_api.g_Number
  ,P_WRKPLC_VLDTN_VER_ID           In  Number   Default hr_api.g_Number
  ,p_LEVEL_NUMBER_ID               In  Number   Default hr_api.g_Number
  ,P_LEVEL_CODE_ID                 In  Number   Default hr_api.g_Number
  ,P_WRKPLC_VLDTN_LVLNUM_ID        In  Number
  ,p_object_version_number         IN  out nocopy number) Is

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

Line: 158

  savepoint Update_Vldtn_Lvl;

Line: 168

   PQH_DE_VLDLVL_BK2.Update_Vldtn_LVL_b
  (p_effective_date                => l_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         => l_object_version_number);

Line: 180

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

Line: 200

   PQH_DE_VLDLVL_BK2.Update_Vldtn_LVL_a
  (p_effective_date                => l_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         => l_object_version_number);

Line: 212

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

Line: 236

    rollback to Update_Vldtn_Lvl;

Line: 249

    rollback to Update_Vldtn_Lvl;

Line: 252

end Update_Vldtn_Lvl;

Line: 258

procedure delete_Vldtn_lvl
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_Lvlnum_ID        In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 272

  savepoint delete_Vldtn_Lvl;

Line: 277

  PQH_DE_VLDLVL_BK3.Delete_Vldtn_Lvl_b
  (p_WRKPLC_VLDTN_Lvlnum_ID        =>   p_WRKPLC_VLDTN_LvlNum_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 283

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

Line: 297

   PQH_DE_VLDLvl_BK3.Delete_Vldtn_Lvl_a
  (p_WRKPLC_VLDTN_LvlNum_ID         => p_WRKPLC_VLDTN_LvlNum_ID
  ,p_object_version_number          => p_object_version_number);

Line: 304

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

Line: 323

    rollback to delete_Vldtn_Lvl;

Line: 334

    rollback to delete_Vldtn_Lvl;

Line: 337

end delete_Vldtn_Lvl;