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

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

Line: 56


Procedure update_dml
  (p_rec in out nocopy ota_off_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'update_dml';

Line: 72


  update ota_offerings
    set
     offering_id                     = p_rec.offering_id
    ,activity_version_id             = p_rec.activity_version_id
    ,business_group_id               = p_rec.business_group_id
    ,start_date                      = p_rec.start_date
    ,end_date                        = p_rec.end_date
    ,owner_id                        = p_rec.owner_id
    ,delivery_mode_id                = p_rec.delivery_mode_id
    ,language_id                     = p_rec.language_id
    ,duration                        = p_rec.duration
    ,duration_units                  = p_rec.duration_units
    ,learning_object_id              = p_rec.learning_object_id
    ,player_toolbar_flag             = p_rec.player_toolbar_flag
    ,player_toolbar_bitset           = p_rec.player_toolbar_bitset
    ,player_new_window_flag          = p_rec.player_new_window_flag
    ,maximum_attendees               = p_rec.maximum_attendees
    ,maximum_internal_attendees      = p_rec.maximum_internal_attendees
    ,minimum_attendees               = p_rec.minimum_attendees
    ,actual_cost                     = p_rec.actual_cost
    ,budget_cost                     = p_rec.budget_cost
    ,budget_currency_code            = p_rec.budget_currency_code
    ,price_basis                     = p_rec.price_basis
    ,currency_code                   = p_rec.currency_code
    ,standard_price                  = p_rec.standard_price
    ,object_version_number           = p_rec.object_version_number
    ,attribute_category              = p_rec.attribute_category
    ,attribute1                      = p_rec.attribute1
    ,attribute2                      = p_rec.attribute2
    ,attribute3                      = p_rec.attribute3
    ,attribute4                      = p_rec.attribute4
    ,attribute5                      = p_rec.attribute5
    ,attribute6                      = p_rec.attribute6
    ,attribute7                      = p_rec.attribute7
    ,attribute8                      = p_rec.attribute8
    ,attribute9                      = p_rec.attribute9
    ,attribute10                     = p_rec.attribute10
    ,attribute11                     = p_rec.attribute11
    ,attribute12                     = p_rec.attribute12
    ,attribute13                     = p_rec.attribute13
    ,attribute14                     = p_rec.attribute14
    ,attribute15                     = p_rec.attribute15
    ,attribute16                     = p_rec.attribute16
    ,attribute17                     = p_rec.attribute17
    ,attribute18                     = p_rec.attribute18
    ,attribute19                     = p_rec.attribute19
    ,attribute20                     = p_rec.attribute20
    ,data_source                     = p_rec.data_source
    ,vendor_id                       = p_rec.vendor_id
    ,competency_update_level      = p_rec.competency_update_level
    ,language_code                = p_rec.language_code  -- 2733966
    where offering_id = p_rec.offering_id;

Line: 148


End update_dml;

Line: 182


Procedure pre_update
  (p_rec in ota_off_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'pre_update';

Line: 192


End pre_update;

Line: 226


Procedure post_update
  (p_effective_date               in date
  ,p_rec                          in ota_off_shd.g_rec_type
  ) is
--
  l_proc  varchar2(72) := g_package||'post_update';

Line: 240


         update_evt_when_course_change( p_rec.offering_id , p_rec.activity_version_id);

Line: 242


    ota_off_rku.after_update
      (p_effective_date              => p_effective_date
      ,p_offering_id
      => p_rec.offering_id
      ,p_activity_version_id
      => p_rec.activity_version_id
      ,p_business_group_id
      => p_rec.business_group_id
      ,p_start_date
      => p_rec.start_date
      ,p_end_date
      => p_rec.end_date
      ,p_owner_id
      => p_rec.owner_id
      ,p_delivery_mode_id
      => p_rec.delivery_mode_id
      ,p_language_id
      => p_rec.language_id
      ,p_duration
      => p_rec.duration
      ,p_duration_units
      => p_rec.duration_units
      ,p_learning_object_id
      => p_rec.learning_object_id
      ,p_player_toolbar_flag
      => p_rec.player_toolbar_flag
      ,p_player_toolbar_bitset
      => p_rec.player_toolbar_bitset
      ,p_player_new_window_flag
      => p_rec.player_new_window_flag
      ,p_maximum_attendees
      => p_rec.maximum_attendees
      ,p_maximum_internal_attendees
      => p_rec.maximum_internal_attendees
      ,p_minimum_attendees
      => p_rec.minimum_attendees
      ,p_actual_cost
      => p_rec.actual_cost
      ,p_budget_cost
      => p_rec.budget_cost
      ,p_budget_currency_code
      => p_rec.budget_currency_code
      ,p_price_basis
      => p_rec.price_basis
      ,p_currency_code
      => p_rec.currency_code
      ,p_standard_price
      => p_rec.standard_price
      ,p_object_version_number
      => p_rec.object_version_number
      ,p_attribute_category
      => p_rec.attribute_category
      ,p_attribute1
      => p_rec.attribute1
      ,p_attribute2
      => p_rec.attribute2
      ,p_attribute3
      => p_rec.attribute3
      ,p_attribute4
      => p_rec.attribute4
      ,p_attribute5
      => p_rec.attribute5
      ,p_attribute6
      => p_rec.attribute6
      ,p_attribute7
      => p_rec.attribute7
      ,p_attribute8
      => p_rec.attribute8
      ,p_attribute9
      => p_rec.attribute9
      ,p_attribute10
      => p_rec.attribute10
      ,p_attribute11
      => p_rec.attribute11
      ,p_attribute12
      => p_rec.attribute12
      ,p_attribute13
      => p_rec.attribute13
      ,p_attribute14
      => p_rec.attribute14
      ,p_attribute15
      => p_rec.attribute15
      ,p_attribute16
      => p_rec.attribute16
      ,p_attribute17
      => p_rec.attribute17
      ,p_attribute18
      => p_rec.attribute18
      ,p_attribute19
      => p_rec.attribute19
      ,p_attribute20
      => p_rec.attribute20
      ,p_data_source
      => p_rec.data_source
      ,p_vendor_id
      => p_rec.vendor_id
      ,p_competency_update_level      => p_rec.competency_update_level
      ,p_activity_version_id_o
      => ota_off_shd.g_old_rec.activity_version_id
      ,p_business_group_id_o
      => ota_off_shd.g_old_rec.business_group_id
      ,p_start_date_o
      => ota_off_shd.g_old_rec.start_date
      ,p_end_date_o
      => ota_off_shd.g_old_rec.end_date
      ,p_owner_id_o
      => ota_off_shd.g_old_rec.owner_id
      ,p_delivery_mode_id_o
      => ota_off_shd.g_old_rec.delivery_mode_id
      ,p_language_id_o
      => ota_off_shd.g_old_rec.language_id
      ,p_duration_o
      => ota_off_shd.g_old_rec.duration
      ,p_duration_units_o
      => ota_off_shd.g_old_rec.duration_units
      ,p_learning_object_id_o
      => ota_off_shd.g_old_rec.learning_object_id
      ,p_player_toolbar_flag_o
      => ota_off_shd.g_old_rec.player_toolbar_flag
      ,p_player_toolbar_bitset_o
      => ota_off_shd.g_old_rec.player_toolbar_bitset
      ,p_player_new_window_flag_o
      => ota_off_shd.g_old_rec.player_new_window_flag
      ,p_maximum_attendees_o
      => ota_off_shd.g_old_rec.maximum_attendees
      ,p_maximum_internal_attendees_o
      => ota_off_shd.g_old_rec.maximum_internal_attendees
      ,p_minimum_attendees_o
      => ota_off_shd.g_old_rec.minimum_attendees
      ,p_actual_cost_o
      => ota_off_shd.g_old_rec.actual_cost
      ,p_budget_cost_o
      => ota_off_shd.g_old_rec.budget_cost
      ,p_budget_currency_code_o
      => ota_off_shd.g_old_rec.budget_currency_code
      ,p_price_basis_o
      => ota_off_shd.g_old_rec.price_basis
      ,p_currency_code_o
      => ota_off_shd.g_old_rec.currency_code
      ,p_standard_price_o
      => ota_off_shd.g_old_rec.standard_price
      ,p_object_version_number_o
      => ota_off_shd.g_old_rec.object_version_number
      ,p_attribute_category_o
      => ota_off_shd.g_old_rec.attribute_category
      ,p_attribute1_o
      => ota_off_shd.g_old_rec.attribute1
      ,p_attribute2_o
      => ota_off_shd.g_old_rec.attribute2
      ,p_attribute3_o
      => ota_off_shd.g_old_rec.attribute3
      ,p_attribute4_o
      => ota_off_shd.g_old_rec.attribute4
      ,p_attribute5_o
      => ota_off_shd.g_old_rec.attribute5
      ,p_attribute6_o
      => ota_off_shd.g_old_rec.attribute6
      ,p_attribute7_o
      => ota_off_shd.g_old_rec.attribute7
      ,p_attribute8_o
      => ota_off_shd.g_old_rec.attribute8
      ,p_attribute9_o
      => ota_off_shd.g_old_rec.attribute9
      ,p_attribute10_o
      => ota_off_shd.g_old_rec.attribute10
      ,p_attribute11_o
      => ota_off_shd.g_old_rec.attribute11
      ,p_attribute12_o
      => ota_off_shd.g_old_rec.attribute12
      ,p_attribute13_o
      => ota_off_shd.g_old_rec.attribute13
      ,p_attribute14_o
      => ota_off_shd.g_old_rec.attribute14
      ,p_attribute15_o
      => ota_off_shd.g_old_rec.attribute15
      ,p_attribute16_o
      => ota_off_shd.g_old_rec.attribute16
      ,p_attribute17_o
      => ota_off_shd.g_old_rec.attribute17
      ,p_attribute18_o
      => ota_off_shd.g_old_rec.attribute18
      ,p_attribute19_o
      => ota_off_shd.g_old_rec.attribute19
      ,p_attribute20_o
      => ota_off_shd.g_old_rec.attribute20
      ,p_data_source_o
      => ota_off_shd.g_old_rec.data_source
      ,p_vendor_id_o
      => ota_off_shd.g_old_rec.vendor_id
      ,p_competency_update_level_o      => ota_off_shd.g_old_rec.competency_update_level
      ,p_language_code                  => ota_off_shd.g_old_rec.language_code  -- 2733966
      );

Line: 447


End post_update;

Line: 683


  If (p_rec.competency_update_level = hr_api.g_varchar2) then
    p_rec.competency_update_level :=
    ota_off_shd.g_old_rec.competency_update_level;

Line: 722


  ota_off_bus.update_validate
     (p_effective_date
     ,p_rec
     ,p_name
     );

Line: 733


  ota_off_upd.pre_update(p_rec);

Line: 737


  ota_off_upd.update_dml(p_rec);

Line: 741


  ota_off_upd.post_update
     (p_effective_date
     ,p_rec
     );

Line: 803


  ,p_competency_update_level      in     varchar2  default hr_api.g_varchar2
  ,p_language_code                in     varchar2  default hr_api.g_varchar2 -- 2733966
  ) is
--
  l_rec   ota_off_shd.g_rec_type;

Line: 866


  ,p_competency_update_level
  ,p_language_code  -- 2733966
  );

Line: 884


Procedure update_evt_when_course_change
  (
   p_offering_id  in  number,
   p_activity_version_id in number
  ) is
  --
  v_exists                varchar2(1);

Line: 891


  v_proc                  varchar2(72) := g_package||'update_evt_when_course_changed';

Line: 898


    select event_id,object_version_number
      from ota_events              evt
     where evt.parent_offering_id = p_offering_id ;

Line: 912


	OTA_EVENT_API.update_class
	(
		p_effective_date => p_effective_date,
		p_event_id => event.event_id,
		p_activity_version_id => p_activity_version_id,
        p_object_version_number => event.object_version_number,
        p_parent_offering_id => p_offering_id
	);

Line: 926


End update_evt_when_course_change;