APPS.PAY_USER_ROW_API SQL Statements

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

Line: 232

procedure update_user_row
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_update_mode         in     varchar2
  ,p_user_row_id                   in     number
  ,p_display_sequence              in out nocopy number
  ,p_object_version_number         in out nocopy number
  ,p_row_low_range_or_name         in     varchar2 default hr_api.g_varchar2
  ,p_base_row_low_range_or_name    in     varchar2 default hr_api.g_varchar2
  ,p_disable_range_overlap_check   in     boolean  default false
  ,p_disable_units_check           in     boolean  default false
  ,p_row_high_range                in     varchar2 default hr_api.g_varchar2
  ,p_effective_start_date             out nocopy date
  ,p_effective_end_date               out nocopy date
  ) is
  --
  -- Declare cursors and local variables
  --
  l_in_out_parameter1    number;

Line: 253

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

Line: 264

  savepoint update_user_row;

Line: 287

	pay_user_row_bk2.update_user_row_b
	(p_effective_date                => l_effective_date
	,p_datetrack_update_mode         => p_datetrack_update_mode
	,p_user_row_id                   => p_user_row_id
	,p_display_sequence              => l_display_sequence
	,p_object_version_number         => l_object_version_number
	,p_row_low_range_or_name         => p_base_row_low_range_or_name
	,p_disable_range_overlap_check   => p_disable_range_overlap_check
	,p_disable_units_check           => p_disable_units_check
	,p_row_high_range                => p_row_high_range
	);

Line: 301

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

Line: 310

  ,p_datetrack_mode               => p_datetrack_update_mode
  ,p_user_row_id                  => p_user_row_id
  ,p_object_version_number        => l_object_version_number
  ,p_row_low_range_or_name        => p_base_row_low_range_or_name
  ,p_display_sequence             => l_display_sequence
  ,p_row_high_range               => p_row_high_range
  ,p_disable_units_check          => p_disable_units_check
  ,p_disable_range_overlap_check  => p_disable_range_overlap_check
  ,p_effective_start_date         => l_effective_start_date
  ,p_effective_end_date           => l_effective_end_date
  ) ;

Line: 325

      pay_user_row_bk2.update_user_row_a
        (p_effective_date                => l_effective_date
	,p_datetrack_update_mode         => p_datetrack_update_mode
	,p_user_row_id                   => p_user_row_id
	,p_display_sequence              => l_display_sequence
	,p_object_version_number         => l_object_version_number
	,p_row_low_range_or_name         => p_base_row_low_range_or_name
	,p_disable_range_overlap_check   => p_disable_range_overlap_check
	,p_disable_units_check           => p_disable_units_check
	,p_row_high_range                => p_row_high_range
	,p_effective_start_date          => l_effective_start_date
	,p_effective_end_date            => l_effective_end_date
	);

Line: 342

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

Line: 371

    rollback to update_user_row;

Line: 387

    rollback to update_user_row;

Line: 399

end update_user_row;

Line: 405

procedure delete_user_row
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_datetrack_update_mode         in     varchar2
  ,p_user_row_id                   in     number
  ,p_object_version_number         in out nocopy number
  ,p_disable_range_overlap_check   in     boolean  default false
  ,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: 420

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

Line: 430

  savepoint delete_user_row;

Line: 446

	pay_user_row_bk3.delete_user_row_b
	(p_effective_date              => l_effective_date
	,p_datetrack_update_mode       => p_datetrack_update_mode
	,p_user_row_id                 => p_user_row_id
	,p_object_version_number       => l_object_version_number
	,p_disable_range_overlap_check => p_disable_range_overlap_check
	);

Line: 456

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

Line: 465

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

Line: 476

      pay_user_row_bk3.delete_user_row_a
        (p_effective_date              => l_effective_date
        ,p_datetrack_update_mode       => p_datetrack_update_mode
        ,p_user_row_id                 => p_user_row_id
	,p_object_version_number       => l_object_version_number
	,p_disable_range_overlap_check => p_disable_range_overlap_check
	,p_effective_start_date        => l_effective_start_date
        ,p_effective_end_date          => l_effective_end_date
	);

Line: 488

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

Line: 507

  if (UPPER(p_datetrack_update_mode) = 'ZAP') then
  pay_urt_del.del_tl(p_user_row_id);

Line: 518

    rollback to delete_user_row;

Line: 533

    rollback to delete_user_row;

Line: 544

end delete_user_row;