APPS.OTA_COURSE_PREREQUISITE_API SQL Statements

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

Line: 137

procedure update_course_prerequisite
  (p_validate                       in  boolean  default false
  ,p_effective_date                 in     date
  ,p_activity_version_id            in number
  ,p_prerequisite_course_id         in number
  ,p_business_group_id              in     number
  ,p_prerequisite_type              in     varchar2
  ,p_enforcement_mode               in     varchar2
  ,p_object_version_number          in out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_course_prerequisite ';

Line: 159

  savepoint update_course_prerequisite ;

Line: 170

    ota_course_prerequisite_bk2.update_course_prerequisite_b
    (p_effective_date             => l_effective_date
    ,p_activity_version_id        => p_activity_version_id
    ,p_prerequisite_course_id     => p_prerequisite_course_id
    ,p_business_group_id          => p_business_group_id
    ,p_prerequisite_type          => p_prerequisite_type
    ,p_enforcement_mode           => p_enforcement_mode
    ,p_object_version_number      => l_object_version_number
    );

Line: 183

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

Line: 206

  ota_course_prerequisite_bk2.update_course_prerequisite_a
    (p_effective_date             => l_effective_date
    ,p_activity_version_id        => p_activity_version_id
    ,p_prerequisite_course_id     => p_prerequisite_course_id
    ,p_business_group_id          => p_business_group_id
    ,p_prerequisite_type          => p_prerequisite_type
    ,p_enforcement_mode           => p_enforcement_mode
    ,p_object_version_number      => l_object_version_number
    );

Line: 218

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

Line: 240

    rollback to update_course_prerequisite ;

Line: 252

    rollback to update_course_prerequisite ;

Line: 256

end update_course_prerequisite ;

Line: 262

procedure delete_course_prerequisite
  (p_validate                           in boolean default false
  ,p_activity_version_id                in number
  ,p_prerequisite_course_id             in number
  ,p_object_version_number              in number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' delete_course_prerequisite ';

Line: 278

  savepoint delete_course_prerequisite ;

Line: 283

    ota_course_prerequisite_bk3.delete_course_prerequisite_b
     (p_activity_version_id        => p_activity_version_id
     ,p_prerequisite_course_id     => p_prerequisite_course_id
     ,p_object_version_number      => p_object_version_number);

Line: 291

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

Line: 310

  ota_course_prerequisite_bk3.delete_course_prerequisite_a
     (p_activity_version_id        => p_activity_version_id
     ,p_prerequisite_course_id     => p_prerequisite_course_id
     ,p_object_version_number      => p_object_version_number);

Line: 317

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

Line: 338

    rollback to delete_course_prerequisite ;

Line: 349

    rollback to delete_course_prerequisite ;

Line: 352

end delete_course_prerequisite;