APPS.PQH_DE_LEVEL_NUMBERS_API SQL Statements

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

Line: 12

procedure Insert_LEVEL_NUMBERS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_LEVEL_NUMBER                  In  Varchar2
  ,P_DESCRIPTION                   In  Varchar2
  ,P_LEVEL_NUMBER_ID               out nocopy Number
  ,p_object_version_number         out nocopy number) is
  --
  -- Declare cursors and local variables
  --

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

Line: 33

  savepoint Insert_LEVEL_NUMBERS;

Line: 42

   PQH_DE_LEVEL_NUMBERS_BK1.Insert_LEVEL_NUMBERS_b
   (p_effective_date             => L_Effective_Date
   ,p_LEVEL_NUMBER               => p_LEVEL_NUMBER
   ,P_DESCRIPTION                => P_DESCRIPTION);

Line: 74

        PQH_DE_LEVEL_NUMBERS_BK1.Insert_LEVEL_NUMBERS_a
           (p_effective_date             => L_Effective_Date
           ,p_LEVEL_NUMBER               => p_LEVEL_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_LEVEL_NUMBER_ID            => l_LEVEL_NUMBER_ID
           ,p_object_version_number      => l_object_version_number);

Line: 108

    rollback to Insert_LEVEL_NUMBERS;

Line: 124

    rollback to Insert_LEVEL_NUMBERS;

Line: 127

end Insert_LEVEL_NUMBERS;

Line: 134

procedure Update_LEVEL_NUMBERS
  (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_LEVEL_NUMBER                  In  Varchar2 Default hr_api.g_Varchar2
  ,P_DESCRIPTION                   In  Varchar2 Default hr_api.g_Varchar2
  ,P_LEVEL_NUMBER_ID               In  Number
  ,p_object_version_number         IN out nocopy number) Is

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

Line: 151

  savepoint Update_LEVEL_NUMBERS;

Line: 162

PQH_DE_LEVEL_NUMBERS_BK2.Update_LEVEL_NUMBERS_b
           (p_effective_date             => L_Effective_Date
           ,p_LEVEL_NUMBER               => p_LEVEL_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_LEVEL_NUMBER_ID            => p_LEVEL_NUMBER_ID
           ,p_object_version_number      => l_object_version_number);

Line: 173

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

Line: 192

 PQH_DE_LEVEL_NUMBERS_BK2.Update_LEVEL_NUMBERS_a
           (p_effective_date             => L_Effective_Date
           ,p_LEVEL_NUMBER               => p_LEVEL_NUMBER
           ,P_DESCRIPTION                => P_DESCRIPTION
           ,P_LEVEL_NUMBER_ID            => p_LEVEL_NUMBER_ID
           ,p_object_version_number      => l_object_version_number);

Line: 202

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

Line: 226

    rollback to Update_LEVEL_NUMBERS;

Line: 239

    rollback to Update_LEVEL_NUMBERS;

Line: 242

end Update_LEVEL_NUMBERS;

Line: 248

procedure delete_LEVEL_NUMBERS
  (p_validate                      in     boolean  default false
  ,p_LEVEL_NUMBER_ID               In     Number
  ,p_object_version_number         In     number) Is

--

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

Line: 264

  savepoint delete_LEVEL_NUMBERS;

Line: 272

  PQH_DE_LEVEL_NUMBERS_BK3.Delete_LEVEL_NUMBERS_b
  (p_LEVEL_NUMBER_Id           =>   p_LEVEL_NUMBER_Id
  ,p_object_version_number     =>   p_object_version_number);

Line: 278

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

Line: 293

  PQH_DE_LEVEL_NUMBERS_BK3.Delete_LEVEL_NUMBERS_a
  (p_LEVEL_NUMBER_Id               =>   p_LEVEL_NUMBER_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 300

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

Line: 319

    rollback to delete_LEVEL_NUMBERS;

Line: 330

    rollback to delete_LEVEL_NUMBERS;

Line: 333

end delete_LEVEL_NUMBERS;