APPS.FF_FUNCTION_CONTEXT_USG_API SQL Statements

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

Line: 132

procedure UPDATE_CONTEXT
  (p_validate                      in     boolean  default false
  ,p_function_id                   in     number
  ,p_sequence_number               in     number
  ,p_object_version_number         in out nocopy   number
  ,p_context_id                    in     number   default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number      ff_function_context_usages.object_version_number%type;

Line: 143

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

Line: 149

  savepoint UPDATE_CONTEXT;

Line: 162

    FF_FUNCTION_CONTEXT_USG_BK2.UPDATE_CONTEXT_b
       (p_function_id               => p_function_id
       ,p_sequence_number           => p_sequence_number
       ,p_object_version_number     => l_object_version_number
       ,p_context_id                => p_context_id
       );

Line: 171

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

Line: 196

    FF_FUNCTION_CONTEXT_USG_BK2.UPDATE_CONTEXT_a
       (p_function_id               => p_function_id
       ,p_sequence_number           => p_sequence_number
       ,p_object_version_number     => l_object_version_number
       ,p_context_id                => p_context_id
       );

Line: 205

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

Line: 227

    rollback to UPDATE_CONTEXT;

Line: 239

    rollback to UPDATE_CONTEXT;

Line: 247

end UPDATE_CONTEXT;

Line: 253

procedure DELETE_CONTEXT
  (p_validate                      in     boolean  default false
  ,p_function_id                   in     number
  ,p_sequence_number               in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 269

  savepoint DELETE_CONTEXT;

Line: 279

    FF_FUNCTION_CONTEXT_USG_BK3.DELETE_CONTEXT_b
       (p_function_id               => p_function_id
       ,p_sequence_number           => p_sequence_number
       ,p_object_version_number     => p_object_version_number
       );

Line: 287

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

Line: 311

    FF_FUNCTION_CONTEXT_USG_BK3.DELETE_CONTEXT_a
       (p_function_id               => p_function_id
       ,p_sequence_number           => p_sequence_number
       ,p_object_version_number     => p_object_version_number
       );

Line: 319

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

Line: 340

    rollback to DELETE_CONTEXT;

Line: 351

    rollback to DELETE_CONTEXT;

Line: 358

end DELETE_CONTEXT;