APPS.OTA_OCL_API SQL Statements

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

Line: 230

procedure update_competence_language
  (p_validate                      in     boolean  default false
  ,p_effective_date                in     date
  ,p_competence_language_id        in  	number
  ,p_competence_id                 in     number
  ,p_language_code                   in     varchar2
  ,p_business_group_id             in     number
  ,p_min_proficiency_level_id      in     number   default null
  ,p_ocl_information_category      in     varchar2 default null
  ,p_ocl_information1              in     varchar2 default null
  ,p_ocl_information2              in     varchar2 default null
  ,p_ocl_information3              in     varchar2 default null
  ,p_ocl_information4              in     varchar2 default null
  ,p_ocl_information5              in     varchar2 default null
  ,p_ocl_information6              in     varchar2 default null
  ,p_ocl_information7              in     varchar2 default null
  ,p_ocl_information8              in     varchar2 default null
  ,p_ocl_information9              in     varchar2 default null
  ,p_ocl_information10             in     varchar2 default null
  ,p_ocl_information11             in     varchar2 default null
  ,p_ocl_information12             in     varchar2 default null
  ,p_ocl_information13             in     varchar2 default null
  ,p_ocl_information14             in     varchar2 default null
  ,p_ocl_information15             in     varchar2 default null
  ,p_ocl_information16             in     varchar2 default null
  ,p_ocl_information17             in     varchar2 default null
  ,p_ocl_information18             in     varchar2 default null
  ,p_ocl_information19             in     varchar2 default null
  ,p_ocl_information20             in     varchar2 default null
  ,p_object_version_number         in  out nocopy number
  ,p_some_warning                     out nocopy boolean
  ) is
  --
  -- Declare cursors and local variables
  --

  l_proc                varchar2(72) := g_package||'update_competence_language';

Line: 274

  savepoint update_competence_language;

Line: 284

    OTA_OCL_BK2.update_competence_language_b
  (p_effective_date                =>	l_effective_date
  ,p_competence_language_id        =>	p_competence_language_id
  ,p_competence_id                 => 	p_competence_id
  ,p_language_code                  =>     p_language_code
  ,p_business_group_id             =>	p_business_group_id
  ,p_min_proficiency_level_id      =>	p_min_proficiency_level_id
  ,p_ocl_information_category      =>	p_ocl_information_category
  ,p_ocl_information1              =>	p_ocl_information1
  ,p_ocl_information2              =>	p_ocl_information2
  ,p_ocl_information3              =>	p_ocl_information3
  ,p_ocl_information4              =>	p_ocl_information4
  ,p_ocl_information5              =>	p_ocl_information5
  ,p_ocl_information6              =>	p_ocl_information6
  ,p_ocl_information7              =>	p_ocl_information7
  ,p_ocl_information8              =>	p_ocl_information8
  ,p_ocl_information9              =>	p_ocl_information9
  ,p_ocl_information10             =>	p_ocl_information10
  ,p_ocl_information11             =>	p_ocl_information11
  ,p_ocl_information12             =>	p_ocl_information12
  ,p_ocl_information13             =>	p_ocl_information13
  ,p_ocl_information14             =>	p_ocl_information14
  ,p_ocl_information15             =>	p_ocl_information15
  ,p_ocl_information16             =>	p_ocl_information16
  ,p_ocl_information17             =>	p_ocl_information17
  ,p_ocl_information18             =>	p_ocl_information18
  ,p_ocl_information19             =>	p_ocl_information19
  ,p_ocl_information20             =>	p_ocl_information20
  ,p_object_version_number         =>	p_object_version_number
      );

Line: 317

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

Line: 367

    OTA_OCL_BK2.update_competence_language_a
  (p_effective_date                =>	l_effective_date
  ,p_competence_language_id        =>	p_competence_language_id
  ,p_competence_id                 => 	p_competence_id
  ,p_language_code                   =>     p_language_code
  ,p_business_group_id             =>	p_business_group_id
  ,p_min_proficiency_level_id      =>	p_min_proficiency_level_id
  ,p_ocl_information_category      =>	p_ocl_information_category
  ,p_ocl_information1              =>	p_ocl_information1
  ,p_ocl_information2              =>	p_ocl_information2
  ,p_ocl_information3              =>	p_ocl_information3
  ,p_ocl_information4              =>	p_ocl_information4
  ,p_ocl_information5              =>	p_ocl_information5
  ,p_ocl_information6              =>	p_ocl_information6
  ,p_ocl_information7              =>	p_ocl_information7
  ,p_ocl_information8              =>	p_ocl_information8
  ,p_ocl_information9              =>	p_ocl_information9
  ,p_ocl_information10             =>	p_ocl_information10
  ,p_ocl_information11             =>	p_ocl_information11
  ,p_ocl_information12             =>	p_ocl_information12
  ,p_ocl_information13             =>	p_ocl_information13
  ,p_ocl_information14             =>	p_ocl_information14
  ,p_ocl_information15             =>	p_ocl_information15
  ,p_ocl_information16             =>	p_ocl_information16
  ,p_ocl_information17             =>	p_ocl_information17
  ,p_ocl_information18             =>	p_ocl_information18
  ,p_ocl_information19             =>	p_ocl_information19
  ,p_ocl_information20             =>	p_ocl_information20
  ,p_object_version_number         =>	p_object_version_number
      );

Line: 400

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

Line: 424

    rollback to update_competence_language;

Line: 438

    rollback to update_competence_language;

Line: 441

end update_competence_language ;