APPS.PQH_DE_VLDOPR_API SQL Statements

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

Line: 12

procedure Insert_Vldtn_Oprn
  (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_WRKPLC_OPERATION_ID           In  Number
  ,P_DESCRIPTION                   In  Varchar2
  ,P_UNIT_PERCENTAGE               In  Number
  ,P_WRKPLC_VLDTN_OP_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_Oprn';

Line: 36

  savepoint Insert_Vldtn_Oprn;

Line: 45

   PQH_DE_VLDOPR_BK1.Insert_Vldtn_Oprn_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_WRKPLC_OPERATION_ID        => P_Wrkplc_Operation_Id
   ,P_DESCRIPTION                => P_Description
   ,P_UNIT_PERCENTAGE            => p_Unit_Percentage);

Line: 57

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

Line: 80

     PQH_DE_VLDOPR_BK1.Insert_Vldtn_Oprn_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_WRKPLC_OPERATION_ID          => p_WRKPLC_OPERATION_ID
     ,P_DESCRIPTION                  => P_DESCRIPTION
     ,P_UNIT_PERCENTAGE              => P_UNIT_PERCENTAGE
     ,P_WRKPLC_VLDTN_OP_ID           => l_WRKPLC_VLDTN_OP_ID
     ,p_object_version_number        => l_object_version_number);

Line: 93

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

Line: 117

    rollback to Insert_Vldtn_oprn;

Line: 133

    rollback to Insert_Vldtn_oprn;

Line: 136

end Insert_Vldtn_Oprn;

Line: 143

procedure Update_Vldtn_Oprn
  (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_WRKPLC_OPERATION_ID           In  Number   Default hr_api.g_Number
  ,P_DESCRIPTION                   In  Varchar2 Default hr_api.g_Varchar2
  ,P_UNIT_PERCENTAGE               In  Number   Default hr_api.g_Number
  ,P_WRKPLC_VLDTN_OP_ID            In  Number
  ,p_object_version_number         In  out nocopy number) Is

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

Line: 163

  savepoint Update_Vldtn_Oprn;

Line: 173

   PQH_DE_VLDOPR_BK2.Update_Vldtn_Oprn_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_WRKPLC_OPERATION_ID           => P_WRKPLC_OPERATION_ID
  ,P_DESCRIPTION                   => P_DESCRIPTION
  ,P_UNIT_PERCENTAGE               => P_UNIT_PERCENTAGE
  ,P_WRKPLC_VLDTN_OP_ID            => P_WRKPLC_VLDTN_OP_ID
  ,p_object_version_number         => l_object_version_number);

Line: 186

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

Line: 207

   PQH_DE_VLDOPR_BK2.Update_Vldtn_Oprn_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_WRKPLC_OPERATION_ID           => P_WRKPLC_OPERATION_ID
  ,P_DESCRIPTION                   => P_DESCRIPTION
  ,P_UNIT_PERCENTAGE               => P_UNIT_PERCENTAGE
  ,P_WRKPLC_VLDTN_OP_ID            => P_WRKPLC_VLDTN_OP_ID
  ,p_object_version_number         => l_object_version_number);

Line: 220

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

Line: 244

    rollback to Update_Vldtn_Oprn;

Line: 257

    rollback to Update_Vldtn_oprn;

Line: 260

end Update_Vldtn_Oprn;

Line: 266

procedure delete_Vldtn_Oprn
  (p_validate                      in     boolean  default false
  ,p_WRKPLC_VLDTN_OP_ID            In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 280

  savepoint delete_Vldtn_Oprn;

Line: 285

  PQH_DE_VLDOPR_BK3.Delete_Vldtn_Oprn_b
  (p_WRKPLC_VLDTN_OP_ID            =>   p_WRKPLC_VLDTN_OP_ID
  ,p_object_version_number         =>   p_object_version_number);

Line: 291

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

Line: 305

   PQH_DE_VLDOPR_BK3.Delete_Vldtn_Oprn_a
  (p_WRKPLC_VLDTN_OP_ID            => p_WRKPLC_VLDTN_OP_ID
  ,p_object_version_number         => p_object_version_number);

Line: 312

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

Line: 331

    rollback to delete_Vldtn_Oprn;

Line: 342

    rollback to delete_Vldtn_Oprn;

Line: 345

end delete_Vldtn_Oprn;