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

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

Line: 5


procedure UPDATE_COMPETENCE_ELEMENT_A
(P_COMPETENCE_ELEMENT_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_PROFICIENCY_LEVEL_ID in NUMBER
,P_HIGH_PROFICIENCY_LEVEL_ID in NUMBER
,P_WEIGHTING_LEVEL_ID in NUMBER
,P_RATING_LEVEL_ID in NUMBER
,P_MANDATORY in VARCHAR2
,P_EFFECTIVE_DATE_FROM in DATE
,P_EFFECTIVE_DATE_TO in DATE
,P_GROUP_COMPETENCE_TYPE in VARCHAR2
,P_COMPETENCE_TYPE in VARCHAR2
,P_NORMAL_ELAPSE_DURATION in NUMBER
,P_NORMAL_ELAPSE_DURATION_UNIT in VARCHAR2
,P_SEQUENCE_NUMBER in NUMBER
,P_SOURCE_OF_PROFICIENCY_LEVEL in VARCHAR2
,P_LINE_SCORE in NUMBER
,P_CERTIFICATION_DATE in DATE
,P_CERTIFICATION_METHOD in VARCHAR2
,P_NEXT_CERTIFICATION_DATE in DATE
,P_COMMENTS in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_QUALIFICATION_TYPE_ID in NUMBER
,P_UNIT_STANDARD_TYPE in VARCHAR2
,P_STATUS in VARCHAR2
,P_INFORMATION_CATEGORY in VARCHAR2
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_ACHIEVED_DATE in DATE
,P_APPR_LINE_SCORE in NUMBER
)is
l_commit_unit_number number;

Line: 78


hr_utility.set_location('Entering: HR_COMPETENCE_ELEMENT_BK2.UPDATE_COMPETENCE_ELEMENT_A', 10);

Line: 81


hr_competence_element_be2.UPDATE_COMPETENCE_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_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: 153


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_COMPETENCE_ELEMENT', 'AP');

Line: 154


hr_utility.set_location(' Leaving: HR_COMPETENCE_ELEMENT_BK2.UPDATE_COMPETENCE_ELEMENT_A', 20);

Line: 155


end UPDATE_COMPETENCE_ELEMENT_A;

Line: 156


procedure UPDATE_COMPETENCE_ELEMENT_B
(P_COMPETENCE_ELEMENT_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_PROFICIENCY_LEVEL_ID in NUMBER
,P_HIGH_PROFICIENCY_LEVEL_ID in NUMBER
,P_WEIGHTING_LEVEL_ID in NUMBER
,P_RATING_LEVEL_ID in NUMBER
,P_MANDATORY in VARCHAR2
,P_EFFECTIVE_DATE_FROM in DATE
,P_EFFECTIVE_DATE_TO in DATE
,P_GROUP_COMPETENCE_TYPE in VARCHAR2
,P_COMPETENCE_TYPE in VARCHAR2
,P_NORMAL_ELAPSE_DURATION in NUMBER
,P_NORMAL_ELAPSE_DURATION_UNIT in VARCHAR2
,P_SEQUENCE_NUMBER in NUMBER
,P_SOURCE_OF_PROFICIENCY_LEVEL in VARCHAR2
,P_LINE_SCORE in NUMBER
,P_CERTIFICATION_DATE in DATE
,P_CERTIFICATION_METHOD in VARCHAR2
,P_NEXT_CERTIFICATION_DATE in DATE
,P_COMMENTS in VARCHAR2
,P_ATTRIBUTE_CATEGORY in VARCHAR2
,P_ATTRIBUTE1 in VARCHAR2
,P_ATTRIBUTE2 in VARCHAR2
,P_ATTRIBUTE3 in VARCHAR2
,P_ATTRIBUTE4 in VARCHAR2
,P_ATTRIBUTE5 in VARCHAR2
,P_ATTRIBUTE6 in VARCHAR2
,P_ATTRIBUTE7 in VARCHAR2
,P_ATTRIBUTE8 in VARCHAR2
,P_ATTRIBUTE9 in VARCHAR2
,P_ATTRIBUTE10 in VARCHAR2
,P_ATTRIBUTE11 in VARCHAR2
,P_ATTRIBUTE12 in VARCHAR2
,P_ATTRIBUTE13 in VARCHAR2
,P_ATTRIBUTE14 in VARCHAR2
,P_ATTRIBUTE15 in VARCHAR2
,P_ATTRIBUTE16 in VARCHAR2
,P_ATTRIBUTE17 in VARCHAR2
,P_ATTRIBUTE18 in VARCHAR2
,P_ATTRIBUTE19 in VARCHAR2
,P_ATTRIBUTE20 in VARCHAR2
,P_EFFECTIVE_DATE in DATE
,P_QUALIFICATION_TYPE_ID in NUMBER
,P_UNIT_STANDARD_TYPE in VARCHAR2
,P_STATUS in VARCHAR2
,P_INFORMATION_CATEGORY in VARCHAR2
,P_INFORMATION1 in VARCHAR2
,P_INFORMATION2 in VARCHAR2
,P_INFORMATION3 in VARCHAR2
,P_INFORMATION4 in VARCHAR2
,P_INFORMATION5 in VARCHAR2
,P_INFORMATION6 in VARCHAR2
,P_INFORMATION7 in VARCHAR2
,P_INFORMATION8 in VARCHAR2
,P_INFORMATION9 in VARCHAR2
,P_INFORMATION10 in VARCHAR2
,P_INFORMATION11 in VARCHAR2
,P_INFORMATION12 in VARCHAR2
,P_INFORMATION13 in VARCHAR2
,P_INFORMATION14 in VARCHAR2
,P_INFORMATION15 in VARCHAR2
,P_INFORMATION16 in VARCHAR2
,P_INFORMATION17 in VARCHAR2
,P_INFORMATION18 in VARCHAR2
,P_INFORMATION19 in VARCHAR2
,P_INFORMATION20 in VARCHAR2
,P_ACHIEVED_DATE in DATE
,P_APPR_LINE_SCORE in NUMBER
)is
begin
hr_utility.set_location('Entering: HR_COMPETENCE_ELEMENT_BK2.UPDATE_COMPETENCE_ELEMENT_B', 10);

Line: 228


hr_utility.set_location(' Leaving: HR_COMPETENCE_ELEMENT_BK2.UPDATE_COMPETENCE_ELEMENT_B', 20);

Line: 229


end UPDATE_COMPETENCE_ELEMENT_B;