eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LEARNING_PATH_SWI SQL Statements

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

Line: 54


,p_competency_update_level        in     varchar2  default null
  ,p_learning_path_id             in     number
  ,p_object_version_number           out nocopy number
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 166


    ,p_competency_update_level      => p_competency_update_level
    ,p_learning_path_id             => l_learning_path_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 222


PROCEDURE delete_learning_path
  (p_learning_path_id             in     number
  ,p_object_version_number        in     number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 235


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

Line: 241


  savepoint delete_learning_path_swi;

Line: 261


  ota_learning_path_api.delete_learning_path
    (p_learning_path_id             => p_learning_path_id
    ,p_object_version_number        => p_object_version_number
    ,p_validate                     => l_validate
    );

Line: 288


    rollback to delete_learning_path_swi;

Line: 302


    rollback to delete_learning_path_swi;

Line: 312


end delete_learning_path;

Line: 316


PROCEDURE update_learning_path
  (p_effective_date               in     date
  ,p_learning_path_id             in     number
  ,p_object_version_number        in out nocopy number
  ,p_path_name                    in     varchar2  default hr_api.g_varchar2
  ,p_description                  in     varchar2  default hr_api.g_varchar2
  ,p_objectives                   in     varchar2  default hr_api.g_varchar2
  ,p_keywords                     in     varchar2  default hr_api.g_varchar2
  ,p_purpose                      in     varchar2  default hr_api.g_varchar2
  ,p_duration                     in     number    default hr_api.g_number
  ,p_duration_units               in     varchar2  default hr_api.g_varchar2
  ,p_start_date_active            in     date      default hr_api.g_date
  ,p_end_date_active              in     date      default hr_api.g_date
  ,p_attribute_category           in     varchar2  default hr_api.g_varchar2
  ,p_attribute1                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute2                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute3                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute4                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute5                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute6                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute7                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute8                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute9                   in     varchar2  default hr_api.g_varchar2
  ,p_attribute10                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute11                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute12                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute13                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute14                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute15                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute16                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute17                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute18                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute19                  in     varchar2  default hr_api.g_varchar2
  ,p_attribute20                  in     varchar2  default hr_api.g_varchar2
  ,p_path_source_code                  in     varchar2  default hr_api.g_varchar2
  ,p_source_function_code              in     varchar2  default hr_api.g_varchar2
  ,p_assignment_id                in     number    default hr_api.g_number
  ,p_source_id                    in     number    default hr_api.g_number
  ,p_notify_days_before_target    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_display_to_learner_flag      in     varchar2  default hr_api.g_varchar2
  ,p_public_flag                  in     varchar2  default hr_api.g_varchar2
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_validate                     in     number    default hr_api.g_false_num
  ,p_competency_update_level        in     varchar2  default hr_api.g_varchar2
  ,p_return_status                   out nocopy varchar2
  ) is
  --
  -- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 372


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

Line: 378


  savepoint update_learning_path_swi;

Line: 410


  ota_learning_path_api.update_learning_path
    (p_effective_date               => p_effective_date
    ,p_learning_path_id             => p_learning_path_id
    ,p_object_version_number        => p_object_version_number
    ,p_path_name                    => p_path_name
    ,p_description                  => p_description
    ,p_objectives                   => p_objectives
    ,p_keywords                     => p_keywords
    ,p_purpose                      => p_purpose
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_start_date_active            => p_start_date_active
    ,p_end_date_active              => p_end_date_active
    ,p_attribute_category           => p_attribute_category
    ,p_attribute1                   => p_attribute1
    ,p_attribute2                   => p_attribute2
    ,p_attribute3                   => p_attribute3
    ,p_attribute4                   => p_attribute4
    ,p_attribute5                   => p_attribute5
    ,p_attribute6                   => p_attribute6
    ,p_attribute7                   => p_attribute7
    ,p_attribute8                   => p_attribute8
    ,p_attribute9                   => p_attribute9
    ,p_attribute10                  => p_attribute10
    ,p_attribute11                  => p_attribute11
    ,p_attribute12                  => p_attribute12
    ,p_attribute13                  => p_attribute13
    ,p_attribute14                  => p_attribute14
    ,p_attribute15                  => p_attribute15
    ,p_attribute16                  => p_attribute16
    ,p_attribute17                  => p_attribute17
    ,p_attribute18                  => p_attribute18
    ,p_attribute19                  => p_attribute19
    ,p_attribute20                  => p_attribute20
    ,p_business_group_id            => p_business_group_id
    ,p_validate                     => l_validate
    ,p_path_source_code             => p_path_source_code
    ,p_source_function_code         => p_source_function_code
    ,p_assignment_id                => p_assignment_id
    ,p_source_id                    => p_source_id
    ,p_notify_days_before_target    => p_notify_days_before_target
    ,p_person_id                    => p_person_id
    ,p_contact_id                   => p_contact_id
    ,p_display_to_learner_flag      => p_display_to_learner_flag
    ,p_public_flag                  => p_public_flag
    ,p_competency_update_level      => p_competency_update_level
    );

Line: 479


    rollback to update_learning_path_swi;

Line: 494


    rollback to update_learning_path_swi;

Line: 505


end update_learning_path;

Line: 535


  SELECT 1
  FROM ota_lp_enrollments lpe
  WHERE lpe.learning_path_id = p_learning_path_id;

Line: 539


l_update_allowed   varchar2(1);

Line: 546


     l_update_allowed := 'N';

Line: 548


     l_update_allowed := 'Y';

Line: 552


  return l_update_allowed;

Line: 570


   SELECT 1
   FROM   OTA_LEARNING_PATHS_VL LPS
   WHERE  rtrim(p_name) = rtrim(lps.name)
      AND lps.business_group_id = l_business_group_id
      AND path_source_code = 'CATALOG'
      AND (p_learning_path_id IS NULL
            OR ( p_learning_path_id IS NOT NULL
                 AND p_learning_path_id <> lps.learning_path_id)) ;

Line: 580


   SELECT 1
   FROM   OTA_LEARNING_PATHS_VL LPS
   WHERE  rtrim(p_name) = rtrim(lps.name)
      AND lps.business_group_id = l_business_group_id
      AND person_id = p_person_id
      AND (p_learning_path_id IS NULL
            OR ( p_learning_path_id IS NOT NULL
                 AND p_learning_path_id <> lps.learning_path_id)) ;

Line: 590


   SELECT 1
   FROM   OTA_LEARNING_PATHS_VL LPS
   WHERE  rtrim(p_name) = rtrim(lps.name)
      AND lps.business_group_id = l_business_group_id
      AND contact_id = p_contact_id
      AND (p_learning_path_id IS NULL
            OR ( p_learning_path_id IS NOT NULL
                 AND p_learning_path_id <> lps.learning_path_id)) ;

Line: 600


  SELECT lps.business_group_id
  FROM OTA_LEARNING_PATHS lps
  WHERE lps.learning_path_id = p_learning_path_id;

Line: 680


FUNCTION is_Duration_Updateable
  ( p_learning_path_id IN NUMBER
  ) return VARCHAR2 IS

l_updateable VARCHAR2(30);

Line: 688


  l_updateable := ota_learning_path_swi.check_lp_enrollments_exist(p_learning_path_id);

Line: 689


  return l_updateable;

Line: 691


END is_Duration_Updateable;