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

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

Line: 64


  ,p_competency_update_level      in     varchar2  default null
  ,p_language_code                in     varchar2  default null   -- 2733966
  ) is
  --
  -- Declare cursors and local variables
  --bug 5435877 l_proc variable changed from 'Create Training Plan' to 'Create Offering'
  l_proc                    varchar2(72) := g_package||' Create Offering';

Line: 141


    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code  -- 2733966
   );

Line: 215


    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code -- 2733966
  );

Line: 281


    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code -- 2733966
  );

Line: 335


procedure update_offering
  (p_validate                     in     boolean  default false
  ,p_effective_date               in     date
  ,p_offering_id                  in     number
  ,p_object_version_number        in out nocopy number
  ,p_business_group_id            in     number    default hr_api.g_number
  ,p_name                         in     varchar2  default hr_api.g_varchar2
  ,p_start_date                   in     date      default hr_api.g_date
  ,p_activity_version_id          in     number    default hr_api.g_number
  ,p_end_date                     in     date      default hr_api.g_date
  ,p_owner_id                     in     number    default hr_api.g_number
  ,p_delivery_mode_id             in     number    default hr_api.g_number
  ,p_language_id                  in     number    default hr_api.g_number
  ,p_duration                     in     number    default hr_api.g_number
  ,p_duration_units               in     varchar2  default hr_api.g_varchar2
  ,p_learning_object_id           in     number    default hr_api.g_number
  ,p_player_toolbar_flag          in     varchar2  default hr_api.g_varchar2
  ,p_player_toolbar_bitset        in     number    default hr_api.g_number
  ,p_player_new_window_flag       in     varchar2  default hr_api.g_varchar2
  ,p_maximum_attendees            in     number    default hr_api.g_number
  ,p_maximum_internal_attendees   in     number    default hr_api.g_number
  ,p_minimum_attendees            in     number    default hr_api.g_number
  ,p_actual_cost                  in     number    default hr_api.g_number
  ,p_budget_cost                  in     number    default hr_api.g_number
  ,p_budget_currency_code         in     varchar2  default hr_api.g_varchar2
  ,p_price_basis                  in     varchar2  default hr_api.g_varchar2
  ,p_currency_code                in     varchar2  default hr_api.g_varchar2
  ,p_standard_price               in     number    default hr_api.g_number
  ,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_data_source                  in     varchar2  default hr_api.g_varchar2
  ,p_vendor_id                    in     number    default hr_api.g_number
  ,p_description		  in     varchar2  default hr_api.g_varchar2
   ,p_competency_update_level      in     varchar2  default hr_api.g_varchar2
   ,p_language_code                in     varchar2  default hr_api.g_varchar2  -- 2733966
  ) is
  --
  -- Declare cursors and local variables
  --bug 5435877 l_proc variable changed from 'Update Training Plan' to 'Update Offering'
  l_proc                    varchar2(72) := g_package||' Update Offering';

Line: 402


  savepoint UPDATE_OFFERING;

Line: 413


    ota_offering_bk2.update_offering_b
  (p_effective_date               => l_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_name                         => l_name
    ,p_start_date                   => p_start_date
    ,p_activity_version_id          => p_activity_version_id
    ,p_end_date                     => p_end_date
    ,p_owner_id                     => p_owner_id
    ,p_delivery_mode_id             => p_delivery_mode_id
    ,p_language_id                  => p_language_id
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_learning_object_id           => p_learning_object_id
    ,p_player_toolbar_flag          => p_player_toolbar_flag
    ,p_player_toolbar_bitset        => p_player_toolbar_bitset
    ,p_player_new_window_flag       => p_player_new_window_flag
    ,p_maximum_attendees            => p_maximum_attendees
    ,p_maximum_internal_attendees   => p_maximum_internal_attendees
    ,p_minimum_attendees            => p_minimum_attendees
    ,p_actual_cost                  => p_actual_cost
    ,p_budget_cost                  => p_budget_cost
    ,p_budget_currency_code         => p_budget_currency_code
    ,p_price_basis                  => p_price_basis
    ,p_currency_code                => p_currency_code
    ,p_standard_price               => p_standard_price
    ,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_offering_id                  => p_offering_id
    ,p_object_version_number        => p_object_version_number
    ,p_data_source                  => p_data_source
    ,p_vendor_id                    => p_vendor_id
    ,p_description                  => p_description
    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code  -- 2733966
  );

Line: 470


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

Line: 531


    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code  -- 2733966
    );

Line: 545


  ota_offering_bk2.update_offering_a
  (p_effective_date               => l_effective_date
    ,p_business_group_id            => p_business_group_id
    ,p_name                         => l_name
    ,p_start_date                   => p_start_date
    ,p_activity_version_id          => p_activity_version_id
    ,p_end_date                     => p_end_date
    ,p_owner_id                     => p_owner_id
    ,p_delivery_mode_id             => p_delivery_mode_id
    ,p_language_id                  => p_language_id
    ,p_duration                     => p_duration
    ,p_duration_units               => p_duration_units
    ,p_learning_object_id           => p_learning_object_id
    ,p_player_toolbar_flag          => p_player_toolbar_flag
    ,p_player_toolbar_bitset        => p_player_toolbar_bitset
    ,p_player_new_window_flag       => p_player_new_window_flag
    ,p_maximum_attendees            => p_maximum_attendees
    ,p_maximum_internal_attendees   => p_maximum_internal_attendees
    ,p_minimum_attendees            => p_minimum_attendees
    ,p_actual_cost                  => p_actual_cost
    ,p_budget_cost                  => p_budget_cost
    ,p_budget_currency_code         => p_budget_currency_code
    ,p_price_basis                  => p_price_basis
    ,p_currency_code                => p_currency_code
    ,p_standard_price               => p_standard_price
    ,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_offering_id                  => p_offering_id
    ,p_object_version_number        => p_object_version_number
    ,p_data_source                  => p_data_source
    ,p_vendor_id                    => p_vendor_id
    ,p_description                  => p_description
    ,p_competency_update_level      => p_competency_update_level
    ,p_language_code                => p_language_code -- 2733966
  );

Line: 602


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

Line: 623


    rollback to UPDATE_OFFERING;

Line: 635


    rollback to UPDATE_OFFERING;

Line: 639


end update_offering;

Line: 645


procedure delete_offering
  (p_validate                      in     boolean  default false
  ,p_offering_id                   in     number
  ,p_object_version_number         in     number
  ) is
  --
  -- Declare cursors and local variables
  --bug 5435877 l_proc variable changed from 'Delete Training Plan' to 'Delete Offering'
  l_proc                    varchar2(72) := g_package||' Delete Offering';

Line: 662


  savepoint DELETE_OFFERING;

Line: 671


    ota_offering_bk3.delete_offering_b
  (p_offering_id            => p_offering_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 678


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

Line: 701


  ota_offering_bk3.delete_offering_a
  (p_offering_id            => p_offering_id
  ,p_object_version_number       => p_object_version_number
  );

Line: 708


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

Line: 730


    rollback to DELETE_OFFERING;

Line: 741


    rollback to DELETE_OFFERING;

Line: 744


end delete_offering;