APPS.PQH_DE_LEVEL_CODES_API SQL Statements

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

Line: 12

procedure Insert_LEVEL_CODES
   (p_validate                      in  boolean  default false
  ,p_effective_date                in  date
  ,p_level_number_id               in  number
  ,p_level_code                    in  varchar2
  ,p_description                   in  varchar2
  ,p_gradual_value_number          in  number
  ,p_level_code_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_CODES';

Line: 37

  savepoint Insert_LEVEL_CODES;

Line: 46

   PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_b
  (p_effective_date             => L_Effective_Date
   ,p_level_number_id           => p_level_number_id
  ,p_level_code                 => p_level_code
  ,p_description                => p_description
  ,p_gradual_value_number       => p_gradual_value_number
  );

Line: 81

        PQH_DE_LEVEL_CODES_BK1.Insert_LEVEL_CODES_a
        (p_effective_date       => L_Effective_Date
   ,p_level_number_id           => p_level_number_id
  ,p_level_code                 => p_level_code
  ,p_description                => p_description
  ,p_gradual_value_number       => p_gradual_value_number
  ,p_level_code_id              => p_level_code_id
  ,p_object_version_number      => p_object_version_number
  );

Line: 95

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

Line: 119

    rollback to Insert_LEVEL_CODES;

Line: 135

    rollback to Insert_LEVEL_CODES;

Line: 138

end Insert_LEVEL_CODES;

Line: 145

procedure Update_LEVEL_CODES
 (p_validate                      in     boolean  default false
  ,p_effective_date               in     date
  ,p_level_code_id                in     number
  ,p_object_version_number        in out nocopy number
  ,p_level_number_id              in     number    default hr_api.g_number
  ,p_level_code                   in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_gradual_value_number         in     number    default hr_api.g_number
  )  Is

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

Line: 165

  savepoint Update_OPERATIONS;

Line: 176

PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_b
 (p_effective_date                => L_Effective_Date
   ,p_level_number_id           => p_level_number_id
  ,p_level_code                 => p_level_code
  ,p_description                => p_description
  ,p_gradual_value_number       => p_gradual_value_number
  ,p_level_code_id              => p_level_code_id
  ,p_object_version_number      => p_object_version_number
  );

Line: 190

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

Line: 212

 PQH_DE_LEVEL_CODES_BK2.Update_LEVEL_CODES_a
(p_effective_date                => L_Effective_Date
   ,p_level_number_id           => p_level_number_id
  ,p_level_code                 => p_level_code
  ,p_description                => p_description
  ,p_gradual_value_number       => p_gradual_value_number
  ,p_level_code_id              => p_level_code_id
  ,p_object_version_number      => p_object_version_number
  );

Line: 225

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

Line: 249

    rollback to Update_LEVEL_CODES;

Line: 262

    rollback to Update_LEVEL_CODES;

Line: 265

end Update_LEVEL_CODES;

Line: 271

procedure delete_LEVEL_CODES
  (p_validate                      in     boolean  default false
  ,p_level_code_ID                  In     Number
  ,p_object_version_number         In     number) Is   --

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

Line: 285

  savepoint delete_LEVEL_CODES;

Line: 290

  PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_b
  (p_LEVEL_CODE_Id                  =>   p_LEVEL_CODE_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 296

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

Line: 311

  PQH_DE_LEVEL_CODES_BK3.Delete_LEVEL_CODES_a
  (p_LEVEL_CODE_Id                  =>   p_LEVEL_CODE_Id
  ,p_object_version_number         =>   p_object_version_number);

Line: 318

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

Line: 337

    rollback to delete_LEVEL_CODES;

Line: 348

    rollback to delete_LEVEL_CODES;

Line: 351

end delete_LEVEL_CODES;