APPS.PAY_BALANCE_FEEDS_API SQL Statements

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

Line: 188

procedure update_balance_feed
  (p_validate	                   in     boolean  default false
  ,p_effective_date		   in     date
  ,p_datetrack_update_mode	   in     varchar2
  ,p_balance_feed_id		   in     number
  ,p_scale			   in     varchar2 default hr_api.g_number
  ,p_object_version_number	   in out nocopy  number
  ,p_effective_start_date	      out nocopy  date
  ,p_effective_end_date		      out nocopy  date
  ,p_exist_run_result_warning	      out nocopy  boolean
  ) is
  --
  -- Declare cursors and local variables
  --

  cursor csr_sel is
  select balance_type_id,input_value_id,legislation_code,
         business_group_id,legislation_subgroup
  from   pay_balance_feeds_f
  where  balance_feed_id =p_balance_feed_id
  and    p_effective_date between effective_start_date and effective_end_date;

Line: 210

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

Line: 230

  savepoint update_balance_feed;

Line: 255

    PAY_BALANCE_FEEDS_BK2.update_balance_feed_b
      (p_effective_date		=> l_effective_date
      ,p_datetrack_update_mode	=> p_datetrack_update_mode
      ,p_balance_feed_id	=> p_balance_feed_id
      ,p_scale			=> p_scale
      );

Line: 264

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

Line: 286

	    ,p_datetrack_mode		=> p_datetrack_update_mode
	    ,p_balance_feed_id          => p_balance_feed_id
	    ,p_object_version_number    => l_object_version_number
	    ,p_balance_type_id          => l_balance_type_id
	    ,p_input_value_id           => l_input_value_id
	    ,p_scale                    => p_scale
	    ,p_business_group_id        => l_business_group_id
	    ,p_legislation_code         => l_legislation_code
	    ,p_legislation_subgroup     => l_legislation_subgroup
	    ,p_effective_start_date     => l_effective_start_date
	    ,p_effective_end_date       => l_effective_end_date
	    ,p_exist_run_result_warning => l_exist_run_result_warning
	    );

Line: 303

    PAY_BALANCE_FEEDS_BK2.update_balance_feed_a
      (p_effective_date		  => l_effective_date
      ,p_datetrack_update_mode	  => p_datetrack_update_mode
      ,p_balance_feed_id	  => p_balance_feed_id
      ,p_scale			  => p_scale
      ,p_effective_start_date	  => l_effective_start_date
      ,p_effective_end_date	  => l_effective_end_date
      ,p_object_version_number	  => l_object_version_number
      ,p_exist_run_result_warning => l_exist_run_result_warning
      );

Line: 317

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

Line: 342

    rollback to update_balance_feed;

Line: 358

    rollback to update_balance_feed;

Line: 367

end update_balance_feed;

Line: 373

procedure delete_balance_feed
  (p_validate                        in     boolean default false
  ,p_effective_date                  in     date
  ,p_datetrack_delete_mode           in     varchar2
  ,p_balance_feed_id                 in     number
  ,p_object_version_number           in out nocopy number
  ,p_effective_start_date               out nocopy date
  ,p_effective_end_date                 out nocopy date
  ,p_exist_run_result_warning	        out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --

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

Line: 401

  savepoint delete_balance_feed;

Line: 411

    PAY_BALANCE_FEEDS_BK3.delete_balance_feed_b
      (p_effective_date		=> l_effective_date
      ,p_datetrack_delete_mode  => p_datetrack_delete_mode
      ,p_balance_feed_id        => p_balance_feed_id
      ,p_object_version_number  => l_object_version_number
      );

Line: 420

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

Line: 431

	    ,p_datetrack_mode		=> p_datetrack_delete_mode
	    ,p_balance_feed_id          => p_balance_feed_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
	    ,p_exist_run_result_warning => l_exist_run_result_warning
	    );

Line: 442

    PAY_BALANCE_FEEDS_BK3.delete_balance_feed_a
      (p_effective_date		  => l_effective_date
      ,p_datetrack_delete_mode    => p_datetrack_delete_mode
      ,p_balance_feed_id          => p_balance_feed_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
      ,p_exist_run_result_warning => l_exist_run_result_warning
      );

Line: 454

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

Line: 479

    rollback to delete_balance_feed;

Line: 495

    rollback to delete_balance_feed;

Line: 504

end delete_balance_feed;