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

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

Line: 5


procedure AFTER_DELETE
(P_EFFECTIVE_DATE in DATE
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_DATETRACK_MODE in VARCHAR2
,P_PERSON_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_OBJECT_VERSION_NUMBER in NUMBER
,P_EFFECTIVE_START_DATE_O in DATE
,P_EFFECTIVE_END_DATE_O in DATE
,P_BUSINESS_GROUP_ID_O in NUMBER
,P_PERSON_TYPE_ID_O in NUMBER
,P_LAST_NAME_O in VARCHAR2
,P_START_DATE_O in DATE
,P_APPLICANT_NUMBER_O in VARCHAR2
,P_COMMENT_ID_O in NUMBER
,P_CURRENT_APPLICANT_FLAG_O in VARCHAR2
,P_CURRENT_EMP_OR_APL_FLAG_O in VARCHAR2
,P_CURRENT_EMPLOYEE_FLAG_O in VARCHAR2
,P_DATE_EMPLOYEE_DATA_VERIFIE_O in DATE
,P_DATE_OF_BIRTH_O in DATE
,P_EMAIL_ADDRESS_O in VARCHAR2
,P_EMPLOYEE_NUMBER_O in VARCHAR2
,P_EXPENSE_CHECK_SEND_TO_ADDR_O in VARCHAR2
,P_FIRST_NAME_O in VARCHAR2
,P_FULL_NAME_O in VARCHAR2
,P_KNOWN_AS_O in VARCHAR2
,P_MARITAL_STATUS_O in VARCHAR2
,P_MIDDLE_NAMES_O in VARCHAR2
,P_NATIONALITY_O in VARCHAR2
,P_NATIONAL_IDENTIFIER_O in VARCHAR2
,P_PREVIOUS_LAST_NAME_O in VARCHAR2
,P_REGISTERED_DISABLED_FLAG_O in VARCHAR2
,P_SEX_O in VARCHAR2
,P_TITLE_O in VARCHAR2
,P_VENDOR_ID_O in NUMBER
,P_WORK_TELEPHONE_O in VARCHAR2
,P_REQUEST_ID_O in NUMBER
,P_PROGRAM_APPLICATION_ID_O in NUMBER
,P_PROGRAM_ID_O in NUMBER
,P_PROGRAM_UPDATE_DATE_O in DATE
,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_PER_INFORMATION_CATEGORY_O in VARCHAR2
,P_PER_INFORMATION1_O in VARCHAR2
,P_PER_INFORMATION2_O in VARCHAR2
,P_PER_INFORMATION3_O in VARCHAR2
,P_PER_INFORMATION4_O in VARCHAR2
,P_PER_INFORMATION5_O in VARCHAR2
,P_PER_INFORMATION6_O in VARCHAR2
,P_PER_INFORMATION7_O in VARCHAR2
,P_PER_INFORMATION8_O in VARCHAR2
,P_PER_INFORMATION9_O in VARCHAR2
,P_PER_INFORMATION10_O in VARCHAR2
,P_PER_INFORMATION11_O in VARCHAR2
,P_PER_INFORMATION12_O in VARCHAR2
,P_PER_INFORMATION13_O in VARCHAR2
,P_PER_INFORMATION14_O in VARCHAR2
,P_PER_INFORMATION15_O in VARCHAR2
,P_PER_INFORMATION16_O in VARCHAR2
,P_PER_INFORMATION17_O in VARCHAR2
,P_PER_INFORMATION18_O in VARCHAR2
,P_PER_INFORMATION19_O in VARCHAR2
,P_PER_INFORMATION20_O in VARCHAR2
,P_SUFFIX_O in VARCHAR2
,P_DATE_OF_DEATH_O in DATE
,P_BACKGROUND_CHECK_STATUS_O in VARCHAR2
,P_BACKGROUND_DATE_CHECK_O in DATE
,P_BLOOD_TYPE_O in VARCHAR2
,P_CORRESPONDENCE_LANGUAGE_O in VARCHAR2
,P_FAST_PATH_EMPLOYEE_O in VARCHAR2
,P_FTE_CAPACITY_O in NUMBER
,P_HOLD_APPLICANT_DATE_UNTIL_O in DATE
,P_HONORS_O in VARCHAR2
,P_INTERNAL_LOCATION_O in VARCHAR2
,P_LAST_MEDICAL_TEST_BY_O in VARCHAR2
,P_LAST_MEDICAL_TEST_DATE_O in DATE
,P_MAILSTOP_O in VARCHAR2
,P_OFFICE_NUMBER_O in VARCHAR2
,P_ON_MILITARY_SERVICE_O in VARCHAR2
,P_ORDER_NAME_O in VARCHAR2
,P_PRE_NAME_ADJUNCT_O in VARCHAR2
,P_PROJECTED_START_DATE_O in DATE
,P_REHIRE_AUTHORIZOR_O in VARCHAR2
,P_REHIRE_RECOMMENDATION_O in VARCHAR2
,P_RESUME_EXISTS_O in VARCHAR2
,P_RESUME_LAST_UPDATED_O in DATE
,P_SECOND_PASSPORT_EXISTS_O in VARCHAR2
,P_STUDENT_STATUS_O in VARCHAR2
,P_WORK_SCHEDULE_O in VARCHAR2
,P_PER_INFORMATION21_O in VARCHAR2
,P_PER_INFORMATION22_O in VARCHAR2
,P_PER_INFORMATION23_O in VARCHAR2
,P_PER_INFORMATION24_O in VARCHAR2
,P_PER_INFORMATION25_O in VARCHAR2
,P_PER_INFORMATION26_O in VARCHAR2
,P_PER_INFORMATION27_O in VARCHAR2
,P_PER_INFORMATION28_O in VARCHAR2
,P_PER_INFORMATION29_O in VARCHAR2
,P_PER_INFORMATION30_O in VARCHAR2
,P_REHIRE_REASON_O in VARCHAR2
,P_BENEFIT_GROUP_ID_O in VARCHAR2
,P_RECEIPT_OF_DEATH_CERT_DATE_O in DATE
,P_COORD_BEN_MED_PLN_NO_O in VARCHAR2
,P_COORD_BEN_NO_CVG_FLAG_O in VARCHAR2
,P_COORD_BEN_MED_EXT_ER_O in VARCHAR2
,P_COORD_BEN_MED_PL_NAME_O in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_NAM_O in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_IDE_O in VARCHAR2
,P_COORD_BEN_MED_CVG_STRT_DT_O in DATE
,P_COORD_BEN_MED_CVG_END_DT_O in DATE
,P_USES_TOBACCO_FLAG_O in VARCHAR2
,P_DPDNT_ADOPTION_DATE_O in DATE
,P_DPDNT_VLNTRY_SVCE_FLAG_O in VARCHAR2
,P_ORIGINAL_DATE_OF_HIRE_O in DATE
,P_TOWN_OF_BIRTH_O in VARCHAR2
,P_REGION_OF_BIRTH_O in VARCHAR2
,P_COUNTRY_OF_BIRTH_O in VARCHAR2
,P_GLOBAL_PERSON_ID_O in VARCHAR2
,P_PARTY_ID_O in NUMBER
,P_NPW_NUMBER_O in VARCHAR2
,P_CURRENT_NPW_FLAG_O in VARCHAR2
,P_GLOBAL_NAME_O in VARCHAR2
,P_LOCAL_NAME_O in VARCHAR2
,P_OBJECT_VERSION_NUMBER_O in NUMBER
)is
begin
hr_utility.set_location('Entering: PER_PER_RKD.AFTER_DELETE', 10);

Line: 163


hr_utility.set_location(' Leaving: PER_PER_RKD.AFTER_DELETE', 20);

Line: 164


end AFTER_DELETE;