APPS.PQP_RIW_COURSE_WRAPPER SQL Statements

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

Line: 72

  ,p_competency_update_level      in     varchar2  default null
  ,P_CRT_UPD			  in 	 varchar2   default null
  ) is
  -- =============================================================================
  -- Variables for API Boolean parameters
  -- =============================================================================

  l_validate                      boolean;

Line: 116

    Select ota_activity_definitions.CATEGORY_USAGE_ID
      from ota_activity_definitions
     where activity_id = p_activity_id;

Line: 127

  e_crt_not_allowed exception; -- when mode is 'Update Only'

Line: 160

       l_create_flag := 2;  --update course

Line: 169

   raise e_crt_not_allowed;  -- Update only flag is enabled but Trying to Create

Line: 232

    ,p_competency_update_level      => p_competency_update_level
    );

Line: 279

 hr_utility.set_location('Inside the update', 90);

Line: 281

select object_version_number into l_object_version_number from
     ota_activity_versions where activity_version_id = l_activity_version_id;

Line: 284

ota_activity_version_api.update_activity_version
  (
  p_effective_date               => p_effective_date,
  p_activity_version_id          => l_activity_version_id,
  p_activity_id                  => p_activity_id,
  p_superseded_by_act_version_id => p_superseded_by_act_version_id,
  p_developer_organization_id    => p_developer_organization_id,
  p_controlling_person_id        => p_controlling_person_id,
  p_object_version_number        => l_object_version_number,
  p_version_name                 => p_version_name,
  p_comments                     => p_comments,
  p_description                  => p_description,
  p_duration                     => p_duration,
  p_duration_units               => p_duration_units,
  p_end_date                     => p_end_date,
  p_intended_audience            => p_intended_audience,
  p_language_id                  => p_language_id,
  p_maximum_attendees            => p_maximum_attendees,
  p_minimum_attendees            => p_minimum_attendees,
  p_objectives                   => p_objectives,
  p_start_date                   => p_start_date,
  p_success_criteria             => p_success_criteria,
  p_user_status                  => p_user_status,
  p_vendor_id                    => p_vendor_id,
  p_actual_cost                  => p_actual_cost,
  p_budget_cost                  => p_budget_cost,
  p_budget_currency_code         => p_budget_currency_code,
  p_expenses_allowed             => p_expenses_allowed,
  p_professional_credit_type     => p_professional_credit_type,
  p_professional_credits         => p_professional_credits,
  p_maximum_internal_attendees   => p_maximum_internal_attendees
    ,p_tav_information_category     => p_tav_information_category
    ,p_tav_information1             => p_tav_information1
    ,p_tav_information2             => p_tav_information2
    ,p_tav_information3             => p_tav_information3
    ,p_tav_information4             => p_tav_information4
    ,p_tav_information5             => p_tav_information5
    ,p_tav_information6             => p_tav_information6
    ,p_tav_information7             => p_tav_information7
    ,p_tav_information8             => p_tav_information8
    ,p_tav_information9             => p_tav_information9
    ,p_tav_information10            => p_tav_information10
    ,p_tav_information11            => p_tav_information11
    ,p_tav_information12            => p_tav_information12
    ,p_tav_information13            => p_tav_information13
    ,p_tav_information14            => p_tav_information14
    ,p_tav_information15            => p_tav_information15
    ,p_tav_information16            => p_tav_information16
    ,p_tav_information17            => p_tav_information17
    ,p_tav_information18            => p_tav_information18
    ,p_tav_information19            => p_tav_information19
    ,p_tav_information20            => p_tav_information20
    ,p_inventory_item_id            => p_inventory_item_id
    ,p_organization_id              => p_organization_id
    ,p_rco_id                       => p_rco_id
    ,p_version_code                 => p_version_code
    ,p_keywords                     => p_keywords
    ,p_business_group_id            => p_business_group_id
    ,p_data_source                  => p_data_source
    ,p_competency_update_level      => p_competency_update_level
  );