APPS.FF_FUNCTION_PARAMETERS_API SQL Statements

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

Line: 169

procedure UPDATE_PARAMETER
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_function_id                   in     number
  ,p_sequence_number               in     number
  ,p_object_version_number         in out nocopy   number
  ,p_class                         in     varchar2 default hr_api.g_varchar2
  ,p_data_type                     in     varchar2 default hr_api.g_varchar2
  ,p_name                          in     varchar2 default hr_api.g_varchar2
  ,p_optional                      in     varchar2 default hr_api.g_varchar2
  ,p_continuing_parameter          in     varchar2 default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_optional                   ff_function_parameters.optional%type;

Line: 188

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

Line: 194

  savepoint UPDATE_PARAMETER;

Line: 209

    FF_FUNCTION_PARAMETERS_BK2.UPDATE_PARAMETER_b
       (p_effective_date           => l_effective_date
       ,p_function_id              => p_function_id
       ,p_sequence_number          => p_sequence_number
       ,p_object_version_number    => l_object_version_number
       ,p_class                    => p_class
       ,p_data_type                => p_data_type
       ,p_name                     => p_name
       ,p_optional                 => p_optional
       ,p_continuing_parameter     => p_continuing_parameter
  );  exception

Line: 222

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

Line: 259

    FF_FUNCTION_PARAMETERS_BK2.UPDATE_PARAMETER_a
       (p_effective_date           => l_effective_date
       ,p_function_id              => p_function_id
       ,p_sequence_number          => p_sequence_number
       ,p_object_version_number    => l_object_version_number
       ,p_class                    => p_class
       ,p_data_type                => p_data_type
       ,p_name                     => p_name
       ,p_optional                 => l_optional
       ,p_continuing_parameter     => l_continuing_parameter
      );

Line: 273

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

Line: 295

    rollback to UPDATE_PARAMETER;

Line: 307

    rollback to UPDATE_PARAMETER;

Line: 315

end UPDATE_PARAMETER;

Line: 321

procedure DELETE_PARAMETER
  (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_PARAMETER';

Line: 336

  savepoint DELETE_PARAMETER;

Line: 348

    FF_FUNCTION_PARAMETERS_BK3.DELETE_PARAMETER_b
       (p_function_id              => p_function_id
       ,p_sequence_number          => p_sequence_number
       ,p_object_version_number    => p_object_version_number
       );

Line: 356

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

Line: 377

    FF_FUNCTION_PARAMETERS_BK3.DELETE_PARAMETER_a
       (p_function_id              => p_function_id
       ,p_sequence_number          => p_sequence_number
       ,p_object_version_number    => p_object_version_number
       );

Line: 385

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

Line: 405

    rollback to DELETE_PARAMETER;

Line: 416

    rollback to DELETE_PARAMETER;

Line: 423

end DELETE_PARAMETER;