APPS.PAY_USER_COLUMN_INSTANCE_API SQL Statements

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

Line: 162

procedure update_user_column_instance
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_user_column_instance_id       in     number
  ,p_datetrack_update_mode         in     varchar2
  ,p_value                         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: 177

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

Line: 187

  savepoint update_user_column_instance;

Line: 203

	pay_user_column_instance_bk2.update_user_column_instance_b
	(p_effective_date             => l_effective_date
	,p_user_column_instance_id    => p_user_column_instance_id
	,p_datetrack_update_mode      => p_datetrack_update_mode
	,p_value                      => p_value
	,p_object_version_number      => l_object_version_number
	);

Line: 213

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

Line: 222

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

Line: 233

      pay_user_column_instance_bk2.update_user_column_instance_a
        (p_effective_date             => l_effective_date
	,p_user_column_instance_id    => p_user_column_instance_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: 246

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

Line: 271

    rollback to update_user_column_instance;

Line: 286

    rollback to update_user_column_instance;

Line: 297

end update_user_column_instance;

Line: 303

procedure delete_user_column_instance
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_user_column_instance_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: 317

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

Line: 327

  savepoint delete_user_column_instance;

Line: 342

	pay_user_column_instance_bk3.delete_user_column_instance_b
	(p_effective_date           =>  l_effective_date
	,p_user_column_instance_id  =>  p_user_column_instance_id
	,p_datetrack_update_mode    =>  p_datetrack_update_mode
	,p_object_version_number    =>  l_object_version_number
	);

Line: 351

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

Line: 360

    ,p_datetrack_mode             => p_datetrack_update_mode
    ,p_user_column_instance_id    => p_user_column_instance_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: 370

      pay_user_column_instance_bk3.delete_user_column_instance_a
      	(p_effective_date           =>  l_effective_date
	,p_user_column_instance_id  =>  p_user_column_instance_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: 382

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

Line: 407

    rollback to delete_user_column_instance;

Line: 422

    rollback to delete_user_column_instance;

Line: 433

end delete_user_column_instance;