APPS.HXC_RECURRING_PERIODS_API SQL Statements

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

Line: 189

procedure update_recurring_periods
  (p_validate                      in     boolean  default false
  ,p_recurring_period_id           in     number
  ,p_object_version_number         in out nocopy number
  ,p_name                          in     varchar2
  ,p_period_type                   in     varchar2 default null
  ,p_duration_in_days              in     number   default null
  ,p_start_date                    in     date	   default null
  ,p_end_date                      in     date     default null
  ,p_effective_date                in     date     default null
  )is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 210

	l_proc := g_package||' update_recurring_periods';

Line: 216

  savepoint update_recurring_periods;

Line: 225

    hxc_recurring_periods_bk_1.update_recurring_periods_b
  (p_recurring_period_id     => p_recurring_period_id
  ,p_object_version_number   => p_object_version_number
  ,p_name                    => p_name
  ,p_start_date              => p_start_date
  ,p_end_date                => p_end_date
  ,p_period_type             => p_period_type
  ,p_duration_in_days        => p_duration_in_days
  ,p_effective_date          => p_effective_date
   );

Line: 238

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

Line: 279

    hxc_recurring_periods_bk_1.update_recurring_periods_a
  (p_recurring_period_id     => p_recurring_period_id
  ,p_object_version_number   => p_object_version_number
  ,p_name                    => p_name
  ,p_period_type             => p_period_type
  ,p_duration_in_days        => p_duration_in_days
  ,p_start_date              => p_start_date
  ,p_end_date                => p_end_date
  ,p_effective_date          => p_effective_date
   );

Line: 292

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

Line: 331

    ROLLBACK TO update_recurring_periods;

Line: 350

    ROLLBACK TO update_recurring_periods;

Line: 356

END update_recurring_periods;

Line: 362

procedure delete_recurring_periods
  (p_validate                       in  boolean  default false
  ,p_recurring_period_id            in  number
  ,p_object_version_number          in  number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc varchar2(72);

Line: 376

	l_proc := g_package||'delete_recurring_periods';

Line: 382

  savepoint delete_recurring_periods;

Line: 392

          hxc_recurring_periods_bk_1.delete_recurring_periods_b
          (p_recurring_period_id   => p_recurring_period_id
          ,p_object_version_number => p_object_version_number
          );

Line: 399

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

Line: 430

        hxc_recurring_periods_bk_1.delete_recurring_periods_a
          (p_recurring_period_id   => p_recurring_period_id
          ,p_object_version_number => p_object_version_number
          );

Line: 437

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

Line: 459

    ROLLBACK TO delete_recurring_periods;

Line: 465

    ROLLBACK TO delete_recurring_periods;

Line: 468

end delete_recurring_periods;