APPS.FF_GLOBALS_API SQL Statements

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

Line: 166

procedure update_global
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_global_id                     in     number
  ,p_datetrack_update_mode         in     varchar2
  ,p_value                         in     varchar2 default HR_API.G_VARCHAR2
  ,p_description                   in     varchar2 default HR_API.G_VARCHAR2
  ,p_object_version_number         in out nocopy number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 182

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

Line: 192

  savepoint update_global;

Line: 208

	ff_globals_bk2.update_global_b
	(p_effective_date             => l_effective_date
	,p_global_id                  => p_global_id
	,p_datetrack_update_mode      => p_datetrack_update_mode
	,p_value                      => p_value
	,p_object_version_number      => l_object_version_number
	);

Line: 218

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

Line: 227

  ,p_datetrack_mode               => p_datetrack_update_mode
  ,p_global_id                    => p_global_id
  ,p_object_version_number        => l_object_version_number
  ,p_global_value                 => p_value
  ,p_global_description           => p_description
  ,p_effective_start_date         => l_effective_start_date
  ,p_effective_end_date           => l_effective_end_date
  ) ;

Line: 239

      ff_globals_bk2.update_global_a
        (p_effective_date             => l_effective_date
	,p_global_id                  => p_global_id
	,p_datetrack_update_mode      => p_datetrack_update_mode
	,p_value                      => p_value
	,p_object_version_number      => l_object_version_number
        ,p_effective_start_date       => l_effective_start_date
        ,p_effective_end_date         => l_effective_end_date
	);

Line: 252

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

Line: 277

    rollback to update_global;

Line: 292

    rollback to update_global;

Line: 303

end update_global;

Line: 309

procedure delete_global
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_global_id                     in     number
  ,p_datetrack_update_mode         in     varchar2
  ,p_object_version_number         in out nocopy number
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter    number;

Line: 323

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

Line: 333

  savepoint delete_global;

Line: 348

	ff_globals_bk3.delete_global_b
	(p_effective_date           =>  l_effective_date
	,p_global_id                =>  p_global_id
	,p_datetrack_update_mode    =>  p_datetrack_update_mode
	,p_object_version_number    =>  l_object_version_number
	);

Line: 357

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

Line: 366

    ,p_datetrack_mode             => p_datetrack_update_mode
    ,p_global_id                  => p_global_id
    ,p_object_version_number      => l_object_version_number
    ,p_effective_start_date       => l_effective_start_date
    ,p_effective_end_date         => l_effective_end_date
    );

Line: 376

      ff_globals_bk3.delete_global_a
      	(p_effective_date           =>  l_effective_date
	,p_global_id                =>  p_global_id
	,p_datetrack_update_mode    =>  p_datetrack_update_mode
	,p_object_version_number    =>  l_object_version_number
	,p_effective_start_date     =>  l_effective_start_date
        ,p_effective_end_date       =>  l_effective_end_date
	);

Line: 388

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

Line: 413

    rollback to delete_global;

Line: 428

    rollback to delete_global;

Line: 439

end delete_global;