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

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

Line: 5


procedure AFTER_INSERT
(P_COMPETENCE_ELEMENT_ID in NUMBER
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_TYPE in VARCHAR2
,P_BUSINESS_GROUP_ID in NUMBER
,P_ENTERPRISE_ID in NUMBER
,P_COMPETENCE_ID 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_PERSON_ID in NUMBER
,P_JOB_ID in NUMBER
,P_VALID_GRADE_ID in NUMBER
,P_POSITION_ID in NUMBER
,P_ORGANIZATION_ID in NUMBER
,P_PARENT_COMPETENCE_ELEMENT_ID in NUMBER
,P_ACTIVITY_VERSION_ID in NUMBER
,P_ASSESSMENT_ID in NUMBER
,P_ASSESSMENT_TYPE_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_OBJECT_ID in NUMBER
,P_OBJECT_NAME in VARCHAR2
,P_PARTY_ID in NUMBER
,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: PER_CEL_RKI.AFTER_INSERT', 10);

Line: 92


hr_utility.set_location(' Leaving: PER_CEL_RKI.AFTER_INSERT', 20);

Line: 93


end AFTER_INSERT;