APPS.PQH_DE_OPERATIONS_API SQL Statements

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

Line: 12

procedure Insert_OPERATIONS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_OPERATION_NUMBER              In  Varchar2 Default NULL
  ,P_DESCRIPTION                   In  Varchar2
  ,P_OPERATION_ID                  out nocopy Number
  ,p_object_version_number         out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 35

  savepoint Insert_OPERATIONS;

Line: 45

   PQH_DE_OPERATIONS_BK1.Insert_OPERATIONS_b
   (p_effective_date             => L_Effective_Date
   ,p_OPERATION_NUMBER           => l_OPERATION_NUMBER
   ,P_DESCRIPTION                => P_DESCRIPTION );

Line: 77

        PQH_DE_OPERATIONS_BK1.Insert_OPERATIONS_a
           (p_effective_date             => L_Effective_Date
           ,p_OPERATION_NUMBER           => l_OPERATION_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_OPERATION_ID               => l_OPERATION_ID
           ,p_object_version_number      => l_object_version_number);

Line: 88

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

Line: 112

    rollback to Insert_OPERATIONS;

Line: 128

    rollback to Insert_OPERATIONS;

Line: 131

end Insert_OPERATIONS;

Line: 138

procedure Update_OPERATIONS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_OPERATION_NUMBER              In  Varchar2 Default hr_api.g_Varchar2
  ,P_DESCRIPTION                   In  Varchar2 Default hr_api.g_Varchar2
  ,P_OPERATION_ID                  In  Number
  ,p_object_version_number         in  out nocopy number) Is

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

Line: 155

  savepoint Update_OPERATIONS;

Line: 166

PQH_DE_OPERATIONS_BK2.Update_OPERATIONS_b
           (p_effective_date             => L_Effective_Date
           ,p_OPERATION_NUMBER           => p_OPERATION_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_OPERATION_ID               => p_OPERATION_ID
           ,p_object_version_number      => l_object_version_number);

Line: 177

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

Line: 196

 PQH_DE_OPERATIONS_BK2.Update_OPERATIONS_a
           (p_effective_date             => L_Effective_Date
           ,p_OPERATION_NUMBER           => p_OPERATION_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_OPERATION_ID               => p_OPERATION_ID
           ,p_object_version_number      => l_object_version_number);

Line: 206

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

Line: 230

    rollback to Update_OPERATIONS;

Line: 243

    rollback to Update_OPERATIONS;

Line: 246

end Update_OPERATIONS;

Line: 252

procedure delete_OPERATIONS
  (p_validate                      in     boolean  default false
  ,p_OPERATION_ID                  In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 266

  savepoint delete_OPERATIONS;

Line: 271

  PQH_DE_OPERATIONS_BK3.Delete_OPERATIONS_b
  (p_OPERATION_Id                  =>   p_OPERATION_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 277

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

Line: 292

  PQH_DE_OPERATIONS_BK3.Delete_OPERATIONS_a
  (p_OPERATION_Id                  =>   p_OPERATION_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 299

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

Line: 318

    rollback to delete_OPERATIONS;

Line: 329

    rollback to delete_OPERATIONS;

Line: 332

end delete_OPERATIONS;