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

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

Line: 5


procedure AFTER_UPDATE
(P_EFFECTIVE_DATE in DATE
,P_INCIDENT_ID in NUMBER
,P_INCIDENT_REFERENCE in VARCHAR2
,P_INCIDENT_TYPE in VARCHAR2
,P_INCIDENT_DATE in DATE
,P_INCIDENT_TIME in VARCHAR2
,P_ORG_NOTIFIED_DATE in DATE
,P_ASSIGNMENT_ID in NUMBER
,P_LOCATION in VARCHAR2
,P_AT_WORK_FLAG in VARCHAR2
,P_REPORT_DATE in DATE
,P_REPORT_TIME in VARCHAR2
,P_REPORT_METHOD in VARCHAR2
,P_PERSON_REPORTED_BY in NUMBER
,P_PERSON_REPORTED_TO in VARCHAR2
,P_WITNESS_DETAILS in VARCHAR2
,P_DESCRIPTION in VARCHAR2
,P_INJURY_TYPE in VARCHAR2
,P_DISEASE_TYPE in VARCHAR2
,P_HAZARD_TYPE in VARCHAR2
,P_BODY_PART in VARCHAR2
,P_TREATMENT_RECEIVED_FLAG in VARCHAR2
,P_HOSPITAL_DETAILS in VARCHAR2
,P_EMERGENCY_CODE in VARCHAR2
,P_HOSPITALIZED_FLAG in VARCHAR2
,P_HOSPITAL_ADDRESS in VARCHAR2
,P_ACTIVITY_AT_TIME_OF_WORK in VARCHAR2
,P_OBJECTS_INVOLVED in VARCHAR2
,P_PRIVACY_ISSUE in VARCHAR2
,P_WORK_START_TIME in VARCHAR2
,P_DATE_OF_DEATH in DATE
,P_REPORT_COMPLETED_BY in VARCHAR2
,P_REPORTING_PERSON_TITLE in VARCHAR2
,P_REPORTING_PERSON_PHONE in VARCHAR2
,P_DAYS_RESTRICTED_WORK in NUMBER
,P_DAYS_AWAY_FROM_WORK in NUMBER
,P_DOCTOR_NAME in VARCHAR2
,P_COMPENSATION_DATE in DATE
,P_COMPENSATION_CURRENCY in VARCHAR2
,P_COMPENSATION_AMOUNT in NUMBER
,P_REMEDIAL_HS_ACTION in VARCHAR2
,P_NOTIFIED_HSREP_ID in NUMBER
,P_NOTIFIED_HSREP_DATE in DATE
,P_NOTIFIED_REP_ID in NUMBER
,P_NOTIFIED_REP_DATE in DATE
,P_NOTIFIED_REP_ORG_ID in NUMBER
,P_RELATED_INCIDENT_ID in NUMBER
,P_OVER_TIME_FLAG in VARCHAR2
,P_ABSENCE_EXISTS_FLAG 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_ATTRIBUTE21 in VARCHAR2
,P_ATTRIBUTE22 in VARCHAR2
,P_ATTRIBUTE23 in VARCHAR2
,P_ATTRIBUTE24 in VARCHAR2
,P_ATTRIBUTE25 in VARCHAR2
,P_ATTRIBUTE26 in VARCHAR2
,P_ATTRIBUTE27 in VARCHAR2
,P_ATTRIBUTE28 in VARCHAR2
,P_ATTRIBUTE29 in VARCHAR2
,P_ATTRIBUTE30 in VARCHAR2
,P_INC_INFORMATION_CATEGORY in VARCHAR2
,P_INC_INFORMATION1 in VARCHAR2
,P_INC_INFORMATION2 in VARCHAR2
,P_INC_INFORMATION3 in VARCHAR2
,P_INC_INFORMATION4 in VARCHAR2
,P_INC_INFORMATION5 in VARCHAR2
,P_INC_INFORMATION6 in VARCHAR2
,P_INC_INFORMATION7 in VARCHAR2
,P_INC_INFORMATION8 in VARCHAR2
,P_INC_INFORMATION9 in VARCHAR2
,P_INC_INFORMATION10 in VARCHAR2
,P_INC_INFORMATION11 in VARCHAR2
,P_INC_INFORMATION12 in VARCHAR2
,P_INC_INFORMATION13 in VARCHAR2
,P_INC_INFORMATION14 in VARCHAR2
,P_INC_INFORMATION15 in VARCHAR2
,P_INC_INFORMATION16 in VARCHAR2
,P_INC_INFORMATION17 in VARCHAR2
,P_INC_INFORMATION18 in VARCHAR2
,P_INC_INFORMATION19 in VARCHAR2
,P_INC_INFORMATION20 in VARCHAR2
,P_INC_INFORMATION21 in VARCHAR2
,P_INC_INFORMATION22 in VARCHAR2
,P_INC_INFORMATION23 in VARCHAR2
,P_INC_INFORMATION24 in VARCHAR2
,P_INC_INFORMATION25 in VARCHAR2
,P_INC_INFORMATION26 in VARCHAR2
,P_INC_INFORMATION27 in VARCHAR2
,P_INC_INFORMATION28 in VARCHAR2
,P_INC_INFORMATION29 in VARCHAR2
,P_INC_INFORMATION30 in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_PERSON_ID_O in NUMBER
,P_INCIDENT_REFERENCE_O in VARCHAR2
,P_INCIDENT_TYPE_O in VARCHAR2
,P_INCIDENT_DATE_O in DATE
,P_INCIDENT_TIME_O in VARCHAR2
,P_ORG_NOTIFIED_DATE_O in DATE
,P_ASSIGNMENT_ID_O in NUMBER
,P_LOCATION_O in VARCHAR2
,P_AT_WORK_FLAG_O in VARCHAR2
,P_REPORT_DATE_O in DATE
,P_REPORT_TIME_O in VARCHAR2
,P_REPORT_METHOD_O in VARCHAR2
,P_PERSON_REPORTED_BY_O in NUMBER
,P_PERSON_REPORTED_TO_O in VARCHAR2
,P_WITNESS_DETAILS_O in VARCHAR2
,P_DESCRIPTION_O in VARCHAR2
,P_INJURY_TYPE_O in VARCHAR2
,P_DISEASE_TYPE_O in VARCHAR2
,P_HAZARD_TYPE_O in VARCHAR2
,P_BODY_PART_O in VARCHAR2
,P_TREATMENT_RECEIVED_FLAG_O in VARCHAR2
,P_HOSPITAL_DETAILS_O in VARCHAR2
,P_EMERGENCY_CODE_O in VARCHAR2
,P_HOSPITALIZED_FLAG_O in VARCHAR2
,P_HOSPITAL_ADDRESS_O in VARCHAR2
,P_ACTIVITY_AT_TIME_OF_WORK_O in VARCHAR2
,P_OBJECTS_INVOLVED_O in VARCHAR2
,P_PRIVACY_ISSUE_O in VARCHAR2
,P_WORK_START_TIME_O in VARCHAR2
,P_DATE_OF_DEATH_O in DATE
,P_REPORT_COMPLETED_BY_O in VARCHAR2
,P_REPORTING_PERSON_TITLE_O in VARCHAR2
,P_REPORTING_PERSON_PHONE_O in VARCHAR2
,P_DAYS_RESTRICTED_WORK_O in NUMBER
,P_DAYS_AWAY_FROM_WORK_O in NUMBER
,P_DOCTOR_NAME_O in VARCHAR2
,P_COMPENSATION_DATE_O in DATE
,P_COMPENSATION_CURRENCY_O in VARCHAR2
,P_COMPENSATION_AMOUNT_O in NUMBER
,P_REMEDIAL_HS_ACTION_O in VARCHAR2
,P_NOTIFIED_HSREP_ID_O in NUMBER
,P_NOTIFIED_HSREP_DATE_O in DATE
,P_NOTIFIED_REP_ID_O in NUMBER
,P_NOTIFIED_REP_DATE_O in DATE
,P_NOTIFIED_REP_ORG_ID_O in NUMBER
,P_RELATED_INCIDENT_ID_O in NUMBER
,P_OVER_TIME_FLAG_O in VARCHAR2
,P_ABSENCE_EXISTS_FLAG_O in VARCHAR2
,P_ATTRIBUTE_CATEGORY_O in VARCHAR2
,P_ATTRIBUTE1_O in VARCHAR2
,P_ATTRIBUTE2_O in VARCHAR2
,P_ATTRIBUTE3_O in VARCHAR2
,P_ATTRIBUTE4_O in VARCHAR2
,P_ATTRIBUTE5_O in VARCHAR2
,P_ATTRIBUTE6_O in VARCHAR2
,P_ATTRIBUTE7_O in VARCHAR2
,P_ATTRIBUTE8_O in VARCHAR2
,P_ATTRIBUTE9_O in VARCHAR2
,P_ATTRIBUTE10_O in VARCHAR2
,P_ATTRIBUTE11_O in VARCHAR2
,P_ATTRIBUTE12_O in VARCHAR2
,P_ATTRIBUTE13_O in VARCHAR2
,P_ATTRIBUTE14_O in VARCHAR2
,P_ATTRIBUTE15_O in VARCHAR2
,P_ATTRIBUTE16_O in VARCHAR2
,P_ATTRIBUTE17_O in VARCHAR2
,P_ATTRIBUTE18_O in VARCHAR2
,P_ATTRIBUTE19_O in VARCHAR2
,P_ATTRIBUTE20_O in VARCHAR2
,P_ATTRIBUTE21_O in VARCHAR2
,P_ATTRIBUTE22_O in VARCHAR2
,P_ATTRIBUTE23_O in VARCHAR2
,P_ATTRIBUTE24_O in VARCHAR2
,P_ATTRIBUTE25_O in VARCHAR2
,P_ATTRIBUTE26_O in VARCHAR2
,P_ATTRIBUTE27_O in VARCHAR2
,P_ATTRIBUTE28_O in VARCHAR2
,P_ATTRIBUTE29_O in VARCHAR2
,P_ATTRIBUTE30_O in VARCHAR2
,P_INC_INFORMATION_CATEGORY_O in VARCHAR2
,P_INC_INFORMATION1_O in VARCHAR2
,P_INC_INFORMATION2_O in VARCHAR2
,P_INC_INFORMATION3_O in VARCHAR2
,P_INC_INFORMATION4_O in VARCHAR2
,P_INC_INFORMATION5_O in VARCHAR2
,P_INC_INFORMATION6_O in VARCHAR2
,P_INC_INFORMATION7_O in VARCHAR2
,P_INC_INFORMATION8_O in VARCHAR2
,P_INC_INFORMATION9_O in VARCHAR2
,P_INC_INFORMATION10_O in VARCHAR2
,P_INC_INFORMATION11_O in VARCHAR2
,P_INC_INFORMATION12_O in VARCHAR2
,P_INC_INFORMATION13_O in VARCHAR2
,P_INC_INFORMATION14_O in VARCHAR2
,P_INC_INFORMATION15_O in VARCHAR2
,P_INC_INFORMATION16_O in VARCHAR2
,P_INC_INFORMATION17_O in VARCHAR2
,P_INC_INFORMATION18_O in VARCHAR2
,P_INC_INFORMATION19_O in VARCHAR2
,P_INC_INFORMATION20_O in VARCHAR2
,P_INC_INFORMATION21_O in VARCHAR2
,P_INC_INFORMATION22_O in VARCHAR2
,P_INC_INFORMATION23_O in VARCHAR2
,P_INC_INFORMATION24_O in VARCHAR2
,P_INC_INFORMATION25_O in VARCHAR2
,P_INC_INFORMATION26_O in VARCHAR2
,P_INC_INFORMATION27_O in VARCHAR2
,P_INC_INFORMATION28_O in VARCHAR2
,P_INC_INFORMATION29_O in VARCHAR2
,P_INC_INFORMATION30_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_INC_RKU.AFTER_UPDATE', 10);

Line: 232


hr_utility.set_location(' Leaving: PER_INC_RKU.AFTER_UPDATE', 20);

Line: 233


end AFTER_UPDATE;