APPS.OTA_OPEN_FC_ENROLLMENT_API SQL Statements

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

Line: 139

procedure update_open_fc_enrollment
  ( p_validate                     in  boolean          default false
    ,p_effective_date               in     date
    ,p_enrollment_id                in     number
    ,p_business_group_id            in     number    default hr_api.g_number
    ,p_forum_id                     in     number    default hr_api.g_number
    ,p_person_id                    in     number    default hr_api.g_number
    ,p_contact_id                   in     number    default hr_api.g_number
    ,p_chat_id                      in     number    default hr_api.g_number
    ,p_object_version_number        in out nocopy number   ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' update_open_fc_enrollment';

Line: 164

  savepoint UPDATE_OPEN_FC_ENROLLMENT;

Line: 168

  OTA_OPEN_FC_ENROLLMENT_bk2.update_open_fc_enrollment_b
  (   p_effective_date      => p_effective_date
    ,p_enrollment_id        =>  p_enrollment_id
    ,p_business_group_id    =>  p_business_group_id
    ,p_forum_id             => p_forum_id
    ,p_person_id            =>   p_person_id
    ,p_contact_id           =>   p_contact_id
    ,p_chat_id              => p_chat_id
    ,p_object_version_number => p_object_version_number
    );

Line: 182

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

Line: 206

  OTA_OPEN_FC_ENROLLMENT_bk2.update_open_fc_enrollment_a
  (  p_effective_date      => p_effective_date
    ,p_enrollment_id        =>  p_enrollment_id
    ,p_business_group_id    =>  p_business_group_id
    ,p_forum_id             => p_forum_id
    ,p_person_id            =>   p_person_id
    ,p_contact_id           =>   p_contact_id
    ,p_chat_id              => p_chat_id
    ,p_object_version_number => p_object_version_number   );

Line: 219

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

Line: 241

    rollback to UPDATE_OPEN_FC_ENROLLMENT;

Line: 249

    rollback to UPDATE_OPEN_FC_ENROLLMENT;

Line: 253

end update_open_fc_enrollment;

Line: 259

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

Line: 275

  savepoint DELETE_OPEN_FC_ENROLLMENT ;

Line: 282

  OTA_OPEN_FC_ENROLLMENT_bk3.delete_open_fc_enrollment_b
  (p_enrollment_id         => p_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 289

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

Line: 306

  OTA_OPEN_FC_ENROLLMENT_bk3.delete_open_fc_enrollment_a
  (p_enrollment_id             => p_enrollment_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 313

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

Line: 335

    rollback to DELETE_OPEN_FC_ENROLLMENT ;

Line: 346

    rollback to DELETE_OPEN_FC_ENROLLMENT ;

Line: 349

end delete_open_fc_enrollment;