APPS.FF_FUNCTIONS_API SQL Statements

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

Line: 166

procedure UPDATE_FUNCTION
  (p_validate                     in      boolean  default false
  ,p_effective_date               in      date
  ,p_function_id                  in     number
  ,p_object_version_number        in out nocopy number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_class                        in     varchar2  default hr_api.g_varchar2
  ,p_alias_name                   in     varchar2  default hr_api.g_varchar2
  ,p_data_type                    in     varchar2  default hr_api.g_varchar2
  ,p_definition                   in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_object_version_number   ff_functions.object_version_number%type;

Line: 183

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

Line: 189

  savepoint UPDATE_FUNCTION;

Line: 204

    FF_FUNCTIONS_BK2.UPDATE_FUNCTION_b
       (p_effective_date           => l_effective_date
       ,p_function_id              => p_function_id
       ,p_object_version_number    => l_object_version_number
       ,p_name                     => p_name
       ,p_class                    => p_class
       ,p_alias_name               => p_alias_name
       ,p_data_type                => p_data_type
       ,p_definition               => p_definition
       ,p_description              => p_description
      );

Line: 218

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

Line: 250

    FF_FUNCTIONS_BK2.UPDATE_FUNCTION_a
       (p_effective_date           => l_effective_date
       ,p_function_id              => p_function_id
       ,p_object_version_number    => l_object_version_number
       ,p_name                     => p_name
       ,p_class                    => p_class
       ,p_alias_name               => p_alias_name
       ,p_data_type                => p_data_type
       ,p_definition               => p_definition
       ,p_description              => p_description
      );

Line: 264

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

Line: 286

    rollback to UPDATE_FUNCTION;

Line: 299

    rollback to UPDATE_FUNCTION;

Line: 308

end UPDATE_FUNCTION;

Line: 314

procedure DELETE_FUNCTION
  (p_validate                     in      boolean  default false
  ,p_function_id                  in      number
  ,p_object_version_number        in      number
  ) is
  --
  -- Declare cursors and local variables
  --
  cursor csr_function_context  is
    select function_id
          ,sequence_number
	  ,object_version_number
    from ff_function_context_usages
    where function_id = p_function_id;

Line: 331

    select function_id
          ,sequence_number
	  ,object_version_number
    from ff_function_parameters
    where function_id = p_function_id;

Line: 342

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

Line: 348

  savepoint DELETE_FUNCTION;

Line: 360

    FF_FUNCTIONS_BK3.DELETE_FUNCTION_b
      ( p_function_id              => p_function_id
       ,p_object_version_number    => p_object_version_number
      );

Line: 367

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

Line: 382

      FF_FUNCTION_CONTEXT_USG_API.DELETE_CONTEXT
         (p_validate               => p_validate
         ,p_function_id            => l_function_id
         ,p_sequence_number        => l_context_sequence_number
         ,p_object_version_number  => l_context_ovn
         );

Line: 399

      FF_FUNCTION_PARAMETERS_API.DELETE_PARAMETER
         (p_validate               => p_validate
         ,p_function_id            => l_function_id
         ,p_sequence_number        => l_parameter_sequence_number
         ,p_object_version_number  => l_parameter_ovn
         );

Line: 422

    FF_FUNCTIONS_BK3.DELETE_FUNCTION_a
      ( p_function_id              => p_function_id
       ,p_object_version_number    => p_object_version_number
      );

Line: 429

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

Line: 450

    rollback to DELETE_FUNCTION;

Line: 461

    rollback to DELETE_FUNCTION;

Line: 468

end DELETE_FUNCTION;