APPS.PQP_RIW_COURSE_WRAPPER SQL Statements

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

Line: 92

  l_course_rec.competency_update_level       :=  hr_api.g_varchar2;

Line: 112

  select lower(bic.interface_col_name) interface_col_name
    from bne_interface_cols_b  bic
   where bic.interface_code = c_interface_code
     and bic.display_flag ='Y';

Line: 120

  select lower(bic.interface_col_name) interface_col_name
    from bne_interface_cols_b  bic
   where bic.interface_code = c_interface_code
     and bic.display_flag ='N';

Line: 208

    when 'p_competency_update_level' then
          l_course_rec.competency_update_level := g_course_rec.competency_update_level;

Line: 334

  ,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: 381

    Select ota_activity_definitions.CATEGORY_USAGE_ID
      from ota_activity_definitions
     where activity_id = p_activity_id;

Line: 392

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

Line: 426

       l_create_flag := 2;  --update course

Line: 443

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

Line: 506

    ,p_competency_update_level      => p_competency_update_level
    );

Line: 553

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

Line: 610

 g_course_rec.competency_update_level				                := p_competency_update_level   ;

Line: 617

select object_version_number into l_object_version_number from
     ota_activity_versions where activity_version_id = l_activity_version_id;

Line: 620

ota_activity_version_api.update_activity_version
  (
  p_effective_date               => p_effective_date,
  p_activity_version_id          => l_activity_version_id,
  p_activity_id                  => l_course_rec.activity_id,
  p_superseded_by_act_version_id => l_course_rec.superseded_by_act_version_id,
  p_developer_organization_id    => l_course_rec.developer_organization_id,
  p_controlling_person_id        => l_course_rec.controlling_person_id,
  p_object_version_number        => l_object_version_number,
  p_version_name                 => l_course_rec.version_name,
  p_comments                     => l_course_rec.comments,
  p_description                  => l_course_rec.description,
  p_duration                     => l_course_rec.duration,
  p_duration_units               => l_course_rec.duration_units,
  p_end_date                     => l_course_rec.end_date,
  p_intended_audience            => l_course_rec.intended_audience,
  p_language_id                  => l_course_rec.language_id ,
  p_maximum_attendees            => l_course_rec.maximum_attendees,
  p_minimum_attendees            => l_course_rec.minimum_attendees,
  p_objectives                   => l_course_rec.objectives,
  p_start_date                   => l_course_rec.start_date,
  p_success_criteria             => l_course_rec.success_criteria,
  p_user_status                  => l_course_rec.user_status,
  p_vendor_id                    => l_course_rec.vendor_id,
  p_actual_cost                  => l_course_rec.actual_cost,
  p_budget_cost                  => l_course_rec.budget_cost,
  p_budget_currency_code         => l_course_rec.budget_currency_code,
  p_expenses_allowed             => l_course_rec.expenses_allowed,
  p_professional_credit_type     => l_course_rec.professional_credit_type,
  p_professional_credits         => l_course_rec.professional_credits,
  p_maximum_internal_attendees   => l_course_rec.maximum_internal_attendees
    ,p_tav_information_category     => l_course_rec.tav_information_category
    ,p_tav_information1             => l_course_rec.tav_information1
    ,p_tav_information2             => l_course_rec.tav_information2
    ,p_tav_information3             => l_course_rec.tav_information3
    ,p_tav_information4             => l_course_rec.tav_information4
    ,p_tav_information5             => l_course_rec.tav_information5
    ,p_tav_information6             => l_course_rec.tav_information6
    ,p_tav_information7             => l_course_rec.tav_information7
    ,p_tav_information8             => l_course_rec.tav_information8
    ,p_tav_information9             => l_course_rec.tav_information9
    ,p_tav_information10            => l_course_rec.tav_information10
    ,p_tav_information11            => l_course_rec.tav_information11
    ,p_tav_information12            => l_course_rec.tav_information12
    ,p_tav_information13            => l_course_rec.tav_information13
    ,p_tav_information14            => l_course_rec.tav_information14
    ,p_tav_information15            => l_course_rec.tav_information15
    ,p_tav_information16            => l_course_rec.tav_information16
    ,p_tav_information17            => l_course_rec.tav_information17
    ,p_tav_information18            => l_course_rec.tav_information18
    ,p_tav_information19            => l_course_rec.tav_information19
    ,p_tav_information20            => l_course_rec.tav_information20
    ,p_inventory_item_id            => l_course_rec.inventory_item_id
    ,p_organization_id              => l_course_rec.organization_id
    ,p_rco_id                       => l_course_rec.rco_id
    ,p_version_code                 => l_course_rec.version_code
    ,p_keywords                     => l_course_rec.keywords
    ,p_business_group_id            => l_course_rec.business_group_id
    ,p_data_source                  => l_course_rec.data_source
    ,p_competency_update_level      => l_course_rec.competency_update_level
  );