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.HR_COMPETENCE_ELEMENT_API SQL Statements

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

Line: 453


procedure update_competence_element
  (
  p_competence_element_id        in number,
  p_object_version_number        in out nocopy number,
  p_proficiency_level_id         in number           default hr_api.g_number,
  p_high_proficiency_level_id    in number           default hr_api.g_number,
  p_weighting_level_id           in number           default hr_api.g_number,
  p_rating_level_id              in number           default hr_api.g_number,
  p_mandatory           	 in varchar2         default hr_api.g_varchar2,
  p_effective_date_from          in date             default hr_api.g_date,
  p_effective_date_to            in date             default hr_api.g_date,
  p_group_competence_type        in varchar2         default hr_api.g_varchar2,
  p_competence_type              in varchar2         default hr_api.g_varchar2,
  p_normal_elapse_duration       in number           default hr_api.g_number,
  p_normal_elapse_duration_unit  in varchar2         default hr_api.g_varchar2,
  p_sequence_number              in number           default hr_api.g_number,
  p_source_of_proficiency_level  in varchar2         default hr_api.g_varchar2,
  p_line_score                   in number           default hr_api.g_number,
  p_certification_date           in date             default hr_api.g_date,
  p_certification_method         in varchar2         default hr_api.g_varchar2,
  p_next_certification_date      in date             default hr_api.g_date,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  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_effective_date		 in Date,
  p_validate                     in boolean    	     default false,
  p_party_id     		 in number
 ,p_qualification_type_id        in number           default hr_api.g_number
 ,p_unit_standard_type           in varchar2         default hr_api.g_varchar2
 ,p_status                       in varchar2         default hr_api.g_varchar2
 ,p_information_category         in varchar2         default hr_api.g_varchar2
 ,p_information1                 in varchar2         default hr_api.g_varchar2
 ,p_information2                 in varchar2         default hr_api.g_varchar2
 ,p_information3                 in varchar2         default hr_api.g_varchar2
 ,p_information4                 in varchar2         default hr_api.g_varchar2
 ,p_information5                 in varchar2         default hr_api.g_varchar2
 ,p_information6                 in varchar2         default hr_api.g_varchar2
 ,p_information7                 in varchar2         default hr_api.g_varchar2
 ,p_information8                 in varchar2         default hr_api.g_varchar2
 ,p_information9                 in varchar2         default hr_api.g_varchar2
 ,p_information10                in varchar2         default hr_api.g_varchar2
 ,p_information11                in varchar2         default hr_api.g_varchar2
 ,p_information12                in varchar2         default hr_api.g_varchar2
 ,p_information13                in varchar2         default hr_api.g_varchar2
 ,p_information14                in varchar2         default hr_api.g_varchar2
 ,p_information15                in varchar2         default hr_api.g_varchar2
 ,p_information16                in varchar2         default hr_api.g_varchar2
 ,p_information17                in varchar2         default hr_api.g_varchar2
 ,p_information18                in varchar2         default hr_api.g_varchar2
 ,p_information19                in varchar2         default hr_api.g_varchar2
 ,p_information20                in varchar2         default hr_api.g_varchar2
 ,p_achieved_date                in date             default hr_api.g_date
 ,p_appr_line_score              in number           default hr_api.g_number
  ) is
  --
  -- Declare cursors and local variables
  --
  --
  l_proc                	varchar2(72) := g_package||'update_competence_element';

Line: 540


  savepoint update_competence_element;

Line: 546


	hr_competence_element_bk2.update_competence_element_b	(
        p_competence_element_id         	=> p_competence_element_id
       ,p_object_version_number	        	=> p_object_version_number
       ,p_proficiency_level_id          	=> p_proficiency_level_id
       ,p_high_proficiency_level_id     	=> p_high_proficiency_level_id
       ,p_weighting_level_id   	        	=> p_weighting_level_id
       ,p_rating_level_id       	     	=> p_rating_level_id
       ,p_mandatory             	 	=> p_mandatory
       ,p_effective_date_from          		=> p_effective_date_from
       ,p_effective_date_to           		=> p_effective_date_to
       ,p_group_competence_type         	=> p_group_competence_type
       ,p_competence_type               	=> p_competence_type
       ,p_normal_elapse_duration        	=> p_normal_elapse_duration
       ,p_normal_elapse_duration_unit   	=> p_normal_elapse_duration_unit
       ,p_sequence_number               	=> p_sequence_number
       ,p_source_of_proficiency_level   	=> p_source_of_proficiency_level
       ,p_line_score                    	=> p_line_score
       ,p_certification_date            	=> p_certification_date
       ,p_certification_method          	=> p_certification_method
       ,p_next_certification_date       	=> p_next_certification_date
       ,p_comments                      	=> p_comments
       ,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_effective_date		 	=> p_effective_date
       ,p_qualification_type_id                 => p_qualification_type_id
       ,p_unit_standard_type                    => p_unit_standard_type
       ,p_status                                => p_status
       ,p_information_category                  => p_information_category
       ,p_information1                          => p_information1
       ,p_information2                          => p_information2
       ,p_information3                          => p_information3
       ,p_information4                          => p_information4
       ,p_information5                          => p_information5
       ,p_information6                          => p_information6
       ,p_information7                          => p_information7
       ,p_information8                          => p_information8
       ,p_information9                          => p_information9
       ,p_information10                         => p_information10
       ,p_information11                         => p_information11
       ,p_information12                         => p_information12
       ,p_information13                         => p_information13
       ,p_information14                         => p_information14
       ,p_information15                         => p_information15
       ,p_information16                         => p_information16
       ,p_information17                         => p_information17
       ,p_information18                         => p_information18
       ,p_information19                         => p_information19
       ,p_information20                         => p_information20
       ,p_achieved_date                         => p_achieved_date
       ,p_appr_line_score                       => p_appr_line_score
	);

Line: 619


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

Line: 714


	hr_competence_element_bk2.update_competence_element_a	(
        p_competence_element_id         	=> p_competence_element_id
       ,p_object_version_number 	       	=> l_object_version_number
       ,p_proficiency_level_id          	=> p_proficiency_level_id
       ,p_high_proficiency_level_id     	=> p_high_proficiency_level_id
       ,p_weighting_level_id           		=> p_weighting_level_id
       ,p_rating_level_id             		=> p_rating_level_id
       ,p_mandatory            			=> p_mandatory
       ,p_effective_date_from          		=> p_effective_date_from
       ,p_effective_date_to           		=> p_effective_date_to
       ,p_group_competence_type         	=> p_group_competence_type
       ,p_competence_type               	=> p_competence_type
       ,p_normal_elapse_duration        	=> p_normal_elapse_duration
       ,p_normal_elapse_duration_unit   	=> p_normal_elapse_duration_unit
       ,p_sequence_number               	=> p_sequence_number
       ,p_source_of_proficiency_level   	=> p_source_of_proficiency_level
       ,p_line_score                    	=> p_line_score
       ,p_certification_date            	=> p_certification_date
       ,p_certification_method          	=> p_certification_method
       ,p_next_certification_date       	=> p_next_certification_date
       ,p_comments                      	=> p_comments
       ,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_effective_date		 	=> p_effective_date
       ,p_qualification_type_id                 => p_qualification_type_id
       ,p_unit_standard_type                    => p_unit_standard_type
       ,p_status                                => p_status
       ,p_information_category                  => p_information_category
       ,p_information1                          => p_information1
       ,p_information2                          => p_information2
       ,p_information3                          => p_information3
       ,p_information4                          => p_information4
       ,p_information5                          => p_information5
       ,p_information6                          => p_information6
       ,p_information7                          => p_information7
       ,p_information8                          => p_information8
       ,p_information9                          => p_information9
       ,p_information10                         => p_information10
       ,p_information11                         => p_information11
       ,p_information12                         => p_information12
       ,p_information13                         => p_information13
       ,p_information14                         => p_information14
       ,p_information15                         => p_information15
       ,p_information16                         => p_information16
       ,p_information17                         => p_information17
       ,p_information18                         => p_information18
       ,p_information19                         => p_information19
       ,p_information20                         => p_information20
       ,p_achieved_date                         => p_achieved_date
       ,p_appr_line_score	                => p_appr_line_score
	);

Line: 787


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

Line: 808


    ROLLBACK TO update_competence_element;

Line: 824


    ROLLBACK TO update_competence_element;

Line: 831


end update_competence_element;

Line: 840


procedure update_competence_element
  (
  p_competence_element_id        in number,
  p_object_version_number        in out nocopy number,
  p_proficiency_level_id         in number           default hr_api.g_number,
  p_high_proficiency_level_id    in number           default hr_api.g_number,
  p_weighting_level_id           in number           default hr_api.g_number,
  p_rating_level_id              in number           default hr_api.g_number,
  p_mandatory           	 in varchar2         default hr_api.g_varchar2,
  p_effective_date_from          in date             default hr_api.g_date,
  p_effective_date_to            in date             default hr_api.g_date,
  p_group_competence_type        in varchar2         default hr_api.g_varchar2,
  p_competence_type              in varchar2         default hr_api.g_varchar2,
  p_normal_elapse_duration       in number           default hr_api.g_number,
  p_normal_elapse_duration_unit  in varchar2         default hr_api.g_varchar2,
  p_sequence_number              in number           default hr_api.g_number,
  p_source_of_proficiency_level  in varchar2         default hr_api.g_varchar2,
  p_line_score                   in number           default hr_api.g_number,
  p_certification_date           in date             default hr_api.g_date,
  p_certification_method         in varchar2         default hr_api.g_varchar2,
  p_next_certification_date      in date             default hr_api.g_date,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  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_effective_date		 in Date,
  p_validate                     in boolean    	     default false
  ) is
  --
  -- Declare cursors and local variables
  --
  --
  l_proc                	varchar2(72) := g_package||'update_competence_element';

Line: 894


  select party_id
  from per_competence_elements
  where competence_element_id = p_competence_element_id;

Line: 911


  update_competence_element
          ( p_competence_element_id        => p_competence_element_id
          , p_object_version_number        => p_object_version_number
          , p_proficiency_level_id         => p_proficiency_level_id
          , p_high_proficiency_level_id    => p_high_proficiency_level_id
          , p_weighting_level_id           => p_weighting_level_id
          , p_rating_level_id              => p_rating_level_id
          , p_mandatory                    => p_mandatory
          , p_effective_date_from          => p_effective_date_from
          , p_effective_date_to            => p_effective_date_to
          , p_group_competence_type        => p_group_competence_type
          , p_competence_type              => p_competence_type
          , p_normal_elapse_duration       => p_normal_elapse_duration
          , p_normal_elapse_duration_unit  => p_normal_elapse_duration_unit
          , p_sequence_number              => p_sequence_number
          , p_source_of_proficiency_level  => p_source_of_proficiency_level
          , p_line_score                   => p_line_score
          , p_certification_date           => p_certification_date
          , p_certification_method         => p_certification_method
          , p_next_certification_date      => p_next_certification_date
          , p_comments                     => p_comments
          , 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_effective_date               => p_effective_date
          , p_validate                     => p_validate
          , p_party_id                     => l_party_id
          );

Line: 962


end update_competence_element;

Line: 968


procedure update_personal_comp_element
  (
  p_competence_element_id        in number,
  p_object_version_number        in out nocopy number,
  p_proficiency_level_id         in number           default hr_api.g_number,
  p_effective_date_from          in date             default hr_api.g_date,
  p_effective_date_to            in date             default hr_api.g_date,
  p_source_of_proficiency_level  in varchar2         default hr_api.g_varchar2,
  p_certification_date           in date             default hr_api.g_date,
  p_certification_method         in varchar2         default hr_api.g_varchar2,
  p_next_certification_date      in date             default hr_api.g_date,
  p_comments                     in varchar2         default hr_api.g_varchar2,
  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_effective_date		 in Date,
  p_validate                     in boolean          default false ,
  p_ins_ovn			 out nocopy number,
  p_ins_comp_id			 out nocopy number
  ) is
  --
  -- Declare cursors and local variables
  --
  --
  l_proc                	varchar2(72) := g_package||'update_Personal_comp_element';

Line: 1050


  l_insert			boolean := false;

Line: 1057


  select
	type,
	business_group_id,
	competence_id,
	proficiency_level_id,
	person_id,
	party_id,  -- HR/TCA merge
	effective_date_from,
	effective_date_to,
	source_of_proficiency_level,
	certification_date,
	certification_method,
	next_certification_date,
	comments,
	attribute_category,
	attribute1,
	attribute2,
	attribute3,
	attribute4,
	attribute5,
	attribute6,
	attribute7,
	attribute8,
	attribute9,
	attribute10,
	attribute11,
	attribute12,
	attribute13,
	attribute14,
	attribute15,
	attribute16,
	attribute17,
	attribute18,
	attribute19,
	attribute20
  from  per_competence_elements
  where competence_element_id = p_competence_element_id
  and   object_version_number = p_object_version_number;

Line: 1101


  savepoint update_competence_element;

Line: 1107


	hr_competence_element_bk3.update_personal_comp_element_b
	(
        p_competence_element_id        =>  p_competence_element_id,
        p_object_version_number        =>  p_object_version_number,
        p_proficiency_level_id         =>  p_proficiency_level_id ,
        p_effective_date_from          =>  p_effective_date_from  ,
        p_effective_date_to            =>  p_effective_date_to    ,
        p_source_of_proficiency_level  =>  p_source_of_proficiency_level,
        p_certification_date           =>  p_certification_date   ,
        p_certification_method         =>  p_certification_method ,
        p_next_certification_date      =>  p_next_certification_date,
        p_comments                     =>  p_comments   ,
        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_effective_date               =>  p_effective_date
	);

Line: 1145


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

Line: 1217


          l_insert := true;

Line: 1222


	-- We need to update the row with the previous proficiency_level and the
	-- date_to being one day less than the p_effective_date_from.
	--
	l_effective_date_to := p_effective_date_from -1;

Line: 1303


  if (l_insert) then
    hr_utility.set_location ('bus_id*** ' || to_char(l_business_group_id), 31);

Line: 1356


	hr_competence_element_bk3.update_personal_comp_element_a
	(
        p_competence_element_id        =>  p_competence_element_id,
        p_object_version_number        =>  p_object_version_number,
        p_proficiency_level_id         =>  p_proficiency_level_id ,
        p_effective_date_from          =>  p_effective_date_from  ,
        p_effective_date_to            =>  p_effective_date_to    ,
        p_source_of_proficiency_level  =>  p_source_of_proficiency_level,
        p_certification_date           =>  p_certification_date   ,
        p_certification_method         =>  p_certification_method ,
        p_next_certification_date      =>  p_next_certification_date,
        p_comments                     =>  p_comments   ,
        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_effective_date               =>  p_effective_date,
        p_ins_ovn                      =>  l_ins_ovn,
        p_ins_comp_id                  =>  l_ins_comp_id
	);

Line: 1396


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

Line: 1417


    ROLLBACK TO update_competence_element;

Line: 1438


    ROLLBACK TO update_competence_element;

Line: 1445


end update_personal_comp_element;

Line: 1452


procedure delete_competence_element
(p_validate                           in boolean default FALSE,
 p_competence_element_id              in number,
 p_object_version_number              in number
) is
  --
  -- Declare cursors and local variables
  --
  --
  l_proc                varchar2(72) := g_package||'delete_competence_element';

Line: 1467


  savepoint delete_competence_element;

Line: 1473


	hr_competence_element_bk4.delete_competence_element_b
		(
		p_competence_element_id       =>   p_competence_element_id,
		p_object_version_number       =>   p_object_version_number
		);

Line: 1481


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

Line: 1508


	hr_competence_element_bk4.delete_competence_element_a	(
		p_competence_element_id       =>   p_competence_element_id,
		p_object_version_number       =>   p_object_version_number
		);

Line: 1515


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

Line: 1535


    ROLLBACK TO delete_competence_element;

Line: 1544


    ROLLBACK TO delete_competence_element;

Line: 1550


end delete_competence_element;

Line: 1585


select competence_element_id
,      object_version_number
,      proficiency_level_id
,      effective_date_from
,      effective_date_to                        -- added for bug#1623036
from   per_competence_elements
where  person_id = p_person_id
and    type = 'PERSONAL'
and    competence_id = p_competence_id
order by effective_date_from desc;

Line: 1597


select competence_element_id
,      object_version_number
,      proficiency_level_id
,      effective_date_from
,      effective_date_to
from   per_competence_elements
where  person_id = p_person_id
and    type = 'PERSONAL'
and    competence_id = p_competence_id
and
p_effective_date_from between effective_date_from and Nvl(effective_Date_to,p_effective_date_from) ;

Line: 1611


select competence_element_id
,      object_version_number
,      proficiency_level_id
,      effective_date_from
,      effective_date_to                        -- added for bug#1623036
from   per_competence_elements
where  person_id = p_person_id
and    type = 'PERSONAL'
and    competence_id = p_competence_id
and
p_effective_date_from < effective_date_from
order by effective_date_from asc;

Line: 1765


              /*update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => l_proficiency_level_id
                   ,p_effective_date_from         => l_effective_date_from
                   ,p_effective_date_to           => p_effective_date_from -1
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);*/

Line: 1895


              update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => l_proficiency_level_id
                   ,p_effective_date_from         => l_effective_date_from
                   ,p_effective_date_to           => p_effective_date_from -1
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 1957


               delete_competence_element
                (p_validate      => p_validate,
                    p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                );

Line: 1981


                    update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => l_proficiency_level_id
                   ,p_effective_date_from         => p_effective_date_to+1
                   ,p_effective_date_to           => l_effective_date_to
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2014


                update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => p_proficiency_level_id
                   ,p_effective_date_from         => l_new_effective_date_from
                   ,p_effective_date_to           => p_effective_date_to
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2102


           update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => p_proficiency_level_id
                   ,p_effective_date_from         => l_new_effective_date_from
                   ,p_effective_date_to           => p_effective_date_to
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2122


            update_personal_comp_element
                   (p_competence_element_id       => l_competence_element_id
                   ,p_object_version_number       => l_object_version_number
                   ,p_proficiency_level_id        => p_proficiency_level_id
                   ,p_effective_date_from         => l_new_effective_date_from
                   ,p_effective_date_to           => l_effective_date_to
                   ,p_certification_date          => p_certification_date
                   ,p_certification_method        => p_certification_method
                   ,p_next_certification_date     => p_next_certification_date
                   ,p_source_of_proficiency_level => p_source_of_proficiency_level
                   ,p_comments                    => p_comments
                   ,p_effective_date              => p_effective_date
                   ,p_ins_ovn                     => l_new_object_version_number
                   ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2213


               update_personal_comp_element
                      (p_competence_element_id       => l_competence_element_id
                      ,p_object_version_number       => l_object_version_number
                      ,p_proficiency_level_id        => p_proficiency_level_id
                      ,p_effective_date_from         => l_new_effective_date_from
                      ,p_effective_date_to           => p_effective_date_to
                      ,p_certification_date          => p_certification_date
                      ,p_certification_method        => p_certification_method
                      ,p_next_certification_date     => p_next_certification_date
                      ,p_source_of_proficiency_level => p_source_of_proficiency_level
                      ,p_comments                    => p_comments
                      ,p_effective_date              => p_effective_date
                      ,p_ins_ovn                     => l_new_object_version_number
                      ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2256


               update_personal_comp_element
                      (p_competence_element_id       => l_competence_element_id
                      ,p_object_version_number       => l_object_version_number
                      ,p_proficiency_level_id        => p_proficiency_level_id
                      ,p_effective_date_from         => l_new_effective_date_from
                      ,p_effective_date_to           => p_effective_date_to
                      ,p_certification_date          => p_certification_date
                      ,p_certification_method        => p_certification_method
                      ,p_next_certification_date     => p_next_certification_date
                      ,p_source_of_proficiency_level => p_source_of_proficiency_level
                      ,p_comments                    => p_comments
                      ,p_effective_date              => p_effective_date
                      ,p_ins_ovn                     => l_new_object_version_number
                      ,p_ins_comp_id                 => l_new_competence_element_id);

Line: 2362


select e.competence_id
,      e.business_group_id
,      e.proficiency_level_id
,      e.effective_date_from
,      e.effective_date_to
,      e.comments
,      e.attribute_category
,      e.attribute1
,      e.attribute2
,      e.attribute3
,      e.attribute4
,      e.attribute5
,      e.attribute6
,      e.attribute7
,      e.attribute8
,      e.attribute9
,      e.attribute10
,      e.attribute11
,      e.attribute12
,      e.attribute13
,      e.attribute14
,      e.attribute15
,      e.attribute16
,      e.attribute17
,      e.attribute18
,      e.attribute19
,      e.attribute20
from per_competence_elements e
where e.object_id = p_activity_version_from
and e.type='TRAINER';

Line: 2394


select e.competence_id
,      e.business_group_id
,      e.proficiency_level_id
,      e.effective_date_from
,      e.effective_date_to
,      e.comments
,      e.attribute_category
,      e.attribute1
,      e.attribute2
,      e.attribute3
,      e.attribute4
,      e.attribute5
,      e.attribute6
,      e.attribute7
,      e.attribute8
,      e.attribute9
,      e.attribute10
,      e.attribute11
,      e.attribute12
,      e.attribute13
,      e.attribute14
,      e.attribute15
,      e.attribute16
,      e.attribute17
,      e.attribute18
,      e.attribute19
,      e.attribute20
from per_competence_elements e
where e.activity_version_id = p_activity_version_from
and e.type = nvl(p_competence_type,'DELIVERY');  -- For Bug 1868713

Line: 2589


procedure update_delivered_dates
        (p_activity_version_id                 in number,
        p_old_start_date                       in date,
        p_start_date                           in date,
        p_old_end_date                         in date,
        p_end_date                             in date,
	p_validate			       in boolean   default FALSE)  is
  --
  v_proc         varchar2 (72) := g_package || 'update_delivered_dates';

Line: 2616


  select e.competence_element_id
        ,e.object_version_number
        ,e.effective_date_from
        ,e.effective_date_to
        ,c.date_from
        ,c.date_to
  from per_competence_elements e
  ,    per_competences c
  where e.activity_version_id = p_activity_version_id
  and   e.type = 'DELIVERY'
  and   e.competence_id = c.competence_id
  and (((l_sd_changed = 'Y'
   and nvl(e.effective_date_from,hr_api.g_sot)
     = nvl(p_old_start_date,hr_api.g_sot))
     or ( l_sd_changed = 'N'
       and l_ed_changed = 'Y'
     and nvl(e.effective_date_to,hr_api.g_eot)
       = nvl(p_old_end_date,hr_api.g_eot)))
  OR ((l_ed_changed = 'Y'
   and nvl(e.effective_date_to,hr_api.g_eot)
     = nvl(p_old_end_date,hr_api.g_eot))
  OR (l_ed_changed = 'N'
       and l_sd_changed = 'Y'
   and nvl(e.effective_date_from,hr_api.g_sot)
     = nvl(p_old_start_date,hr_api.g_sot))));

Line: 2648


  savepoint update_delivered_dates;

Line: 2653


     hr_competence_element_bk7.update_delivered_dates_b	(
        p_activity_version_id      =>  p_activity_version_id,
        p_old_start_date           =>  p_old_start_date     ,
        p_start_date               =>  p_start_date         ,
        p_old_end_date             =>  p_old_end_date       ,
        p_end_date                 =>  p_end_date
      );

Line: 2663


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

Line: 2779


     hr_competence_element_bk7.update_delivered_dates_a	(
        p_activity_version_id      =>  p_activity_version_id,
        p_old_start_date           =>  p_old_start_date     ,
        p_start_date               =>  p_start_date         ,
        p_old_end_date             =>  p_old_end_date       ,
        p_end_date                 =>  p_end_date
      );

Line: 2789


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

Line: 2806


    ROLLBACK TO update_delivered_dates;

Line: 2814


    ROLLBACK TO update_delivered_dates;

Line: 2822


End update_delivered_dates;