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_API SQL Statements

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

Line: 56


  p_competency_update_level        in     varchar2  default null,
  p_learning_path_id             out nocopy number,
  p_object_version_number        out nocopy number

  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' create_learning_path';

Line: 121


    ,p_competency_update_level      => p_competency_update_level
    );

Line: 172


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

Line: 239


    ,p_competency_update_level      => p_competency_update_level
    );

Line: 287


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_business_group_id            in number           default hr_api.g_number,
  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_validate                     in boolean          default false
  ,p_competency_update_level        in     varchar2  default hr_api.g_varchar2
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Learning Path';

Line: 346


  savepoint UPDATE_LEARNING_PATH;

Line: 350


  ota_learning_path_bk2.update_learning_path_b
  (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_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_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    ,p_competency_update_level      => p_competency_update_level
    );

Line: 402


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

Line: 449


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

Line: 467


  ota_learning_path_bk2.update_learning_path_a
  (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_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_business_group_id            => p_business_group_id
    ,p_validate                     => p_validate
    ,p_competency_update_level      => p_competency_update_level
    );

Line: 519


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

Line: 541


    rollback to UPDATE_LEARNING_PATH;

Line: 553


    rollback to UPDATE_LEARNING_PATH;

Line: 557


end update_learning_path;

Line: 563


procedure delete_learning_path
  (
  p_learning_path_id                in number,
  p_object_version_number              in number,
  p_validate                           in boolean
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Learning Path';

Line: 580


  savepoint DELETE_LEARNING_PATH;

Line: 587


  ota_learning_path_bk3.delete_learning_path_b
  (p_learning_path_id             => p_learning_path_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 594


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

Line: 614


  ota_learning_path_bk3.delete_learning_path_a
  (p_learning_path_id             => p_learning_path_id
    ,p_object_version_number        => p_object_version_number
    );

Line: 621


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

Line: 643


    rollback to DELETE_LEARNING_PATH;

Line: 654


    rollback to DELETE_LEARNING_PATH;

Line: 657


end delete_learning_path;