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

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

Line: 81


  select person_id,learning_path_id
  from ota_training_plans
  where training_plan_id = crs_id;

Line: 296


  ota_competence_ss.create_wf_process(p_process 	=>'OTA_COMPETENCE_UPDATE_JSP_PRC',
            p_itemtype 		=>'HRSSA',
            p_person_id 	=> l_person_id,
            p_eventid       =>null,
            p_learningpath_ids => l_learning_path_id,
            p_itemkey    =>l_item_key);

Line: 334


procedure update_training_plan
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_training_plan_id              in     number
  ,p_object_version_number         in out nocopy number
  ,p_time_period_id                in     number
  ,p_plan_status_type_id           in     varchar2
  ,p_budget_currency               in     varchar2
  ,p_name                          in     varchar2
  ,p_description                   in     varchar2 default hr_api.g_varchar2
  ,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_attribute21                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
  ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
  ,p_plan_source                   in     varchar2 default hr_api.g_varchar2  --changed
  ,p_start_date                    in     date     default hr_api.g_date
  ,p_end_date                      in     date     default hr_api.g_date
  ,p_creator_person_id             in     number
  ,p_additional_member_flag        in     varchar2 default hr_api.g_varchar2
  ,p_learning_path_id              in     number
  -- Modified for Bug#3479186
  ,p_contact_id              in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Update Training Plan';

Line: 398


  select person_id,learning_path_id
  from ota_training_plans
  where training_plan_id = p_training_plan_id;

Line: 407


  savepoint UPDATE_TRAINING_PLAN;

Line: 416


    ota_tps_api_bk2.update_training_plan_b
  (p_effective_date                 => l_effective_date
  ,p_training_plan_id               => p_training_plan_id
  ,p_object_version_number          => p_object_version_number
  ,p_time_period_id                 => p_time_period_id
  ,p_plan_status_type_id            => p_plan_status_type_id
  ,p_budget_currency                => p_budget_currency
  ,p_name                           => p_name
  ,p_description                    => p_description
  ,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_attribute21                    => p_attribute21
  ,p_attribute22                    => p_attribute22
  ,p_attribute23                    => p_attribute23
  ,p_attribute24                    => p_attribute24
  ,p_attribute25                    => p_attribute25
  ,p_attribute26                    => p_attribute26
  ,p_attribute27                    => p_attribute27
  ,p_attribute28                    => p_attribute28
  ,p_attribute29                    => p_attribute29
  ,p_attribute30                    => p_attribute30
  ,p_plan_source                    => p_plan_source  --changed
  ,p_start_date                     => p_start_date
  ,p_end_date                       => p_end_date
  ,p_creator_person_id              => p_creator_person_id
  ,p_additional_member_flag         => p_additional_member_flag
  ,p_learning_path_id               => p_learning_path_id
 ,p_contact_id                        => p_contact_id
  );

Line: 467


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

Line: 529


  ota_tps_api_bk2.update_training_plan_a
  (p_effective_date                 => l_effective_date
  ,p_training_plan_id               => p_training_plan_id
  ,p_object_version_number          => p_object_version_number
  ,p_time_period_id                 => p_time_period_id
  ,p_plan_status_type_id            => p_plan_status_type_id
  ,p_budget_currency                => p_budget_currency
  ,p_name                           => p_name
  ,p_description                    => p_description
  ,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_attribute21                    => p_attribute21
  ,p_attribute22                    => p_attribute22
  ,p_attribute23                    => p_attribute23
  ,p_attribute24                    => p_attribute24
  ,p_attribute25                    => p_attribute25
  ,p_attribute26                    => p_attribute26
  ,p_attribute27                    => p_attribute27
  ,p_attribute28                    => p_attribute28
  ,p_attribute29                    => p_attribute29
  ,p_attribute30                    => p_attribute30
  ,p_plan_source                    => p_plan_source  --changed
  ,p_start_date                     => p_start_date
  ,p_end_date                       => p_end_date
  ,p_creator_person_id              => p_creator_person_id
  ,p_additional_member_flag         => p_additional_member_flag
  ,p_learning_path_id               => p_learning_path_id
  ,p_contact_id                        => p_contact_id
  );

Line: 580


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

Line: 598


  ota_competence_ss.create_wf_process(p_process 	=>'OTA_COMPETENCE_UPDATE_JSP_PRC',
            p_itemtype 		=>'HRSSA',
            p_person_id 	=> l_person_id,
            p_eventid       =>null,
            p_learningpath_ids => l_learning_path_id,
            p_itemkey    =>l_item_key);

Line: 615


    rollback to UPDATE_TRAINING_PLAN;

Line: 627


    rollback to UPDATE_TRAINING_PLAN;

Line: 631


end update_training_plan;

Line: 637


procedure delete_training_plan
  (p_validate                      in     boolean  default false
  ,p_training_plan_id              in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  l_proc                    varchar2(72) := g_package||' Delete Training Plan';

Line: 654


  savepoint DELETE_TRAINING_PLAN;

Line: 662


    ota_tps_api_bk3.delete_training_plan_b
  (p_training_plan_id            => p_training_plan_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 669


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

Line: 687


  ota_tps_api_bk3.delete_training_plan_a
  (p_training_plan_id            => p_training_plan_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 694


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

Line: 715


    rollback to DELETE_TRAINING_PLAN;

Line: 726


    rollback to DELETE_TRAINING_PLAN;

Line: 729


end delete_training_plan;