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

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

Line: 5


procedure AFTER_INSERT
(P_EFFECTIVE_DATE in DATE
,P_NAME_COMBINATION_WARNING in BOOLEAN
,P_DOB_NULL_WARNING in BOOLEAN
,P_ORIG_HIRE_WARNING in BOOLEAN
,P_VALIDATION_START_DATE in DATE
,P_VALIDATION_END_DATE in DATE
,P_PERSON_ID in NUMBER
,P_EFFECTIVE_START_DATE in DATE
,P_EFFECTIVE_END_DATE in DATE
,P_BUSINESS_GROUP_ID in NUMBER
,P_PERSON_TYPE_ID in NUMBER
,P_LAST_NAME in VARCHAR2
,P_START_DATE in DATE
,P_APPLICANT_NUMBER in VARCHAR2
,P_COMMENT_ID in NUMBER
,P_CURRENT_APPLICANT_FLAG in VARCHAR2
,P_CURRENT_EMP_OR_APL_FLAG in VARCHAR2
,P_CURRENT_EMPLOYEE_FLAG in VARCHAR2
,P_DATE_EMPLOYEE_DATA_VERIFIED in DATE
,P_DATE_OF_BIRTH in DATE
,P_EMAIL_ADDRESS in VARCHAR2
,P_EMPLOYEE_NUMBER in VARCHAR2
,P_EXPENSE_CHECK_SEND_TO_ADDRES in VARCHAR2
,P_FIRST_NAME in VARCHAR2
,P_FULL_NAME in VARCHAR2
,P_KNOWN_AS in VARCHAR2
,P_MARITAL_STATUS in VARCHAR2
,P_MIDDLE_NAMES in VARCHAR2
,P_NATIONALITY in VARCHAR2
,P_NATIONAL_IDENTIFIER in VARCHAR2
,P_PREVIOUS_LAST_NAME in VARCHAR2
,P_REGISTERED_DISABLED_FLAG in VARCHAR2
,P_SEX in VARCHAR2
,P_TITLE in VARCHAR2
,P_VENDOR_ID in NUMBER
,P_WORK_TELEPHONE in VARCHAR2
,P_REQUEST_ID in NUMBER
,P_PROGRAM_APPLICATION_ID in NUMBER
,P_PROGRAM_ID in NUMBER
,P_PROGRAM_UPDATE_DATE in DATE
,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_PER_INFORMATION_CATEGORY in VARCHAR2
,P_PER_INFORMATION1 in VARCHAR2
,P_PER_INFORMATION2 in VARCHAR2
,P_PER_INFORMATION3 in VARCHAR2
,P_PER_INFORMATION4 in VARCHAR2
,P_PER_INFORMATION5 in VARCHAR2
,P_PER_INFORMATION6 in VARCHAR2
,P_PER_INFORMATION7 in VARCHAR2
,P_PER_INFORMATION8 in VARCHAR2
,P_PER_INFORMATION9 in VARCHAR2
,P_PER_INFORMATION10 in VARCHAR2
,P_PER_INFORMATION11 in VARCHAR2
,P_PER_INFORMATION12 in VARCHAR2
,P_PER_INFORMATION13 in VARCHAR2
,P_PER_INFORMATION14 in VARCHAR2
,P_PER_INFORMATION15 in VARCHAR2
,P_PER_INFORMATION16 in VARCHAR2
,P_PER_INFORMATION17 in VARCHAR2
,P_PER_INFORMATION18 in VARCHAR2
,P_PER_INFORMATION19 in VARCHAR2
,P_PER_INFORMATION20 in VARCHAR2
,P_SUFFIX in VARCHAR2
,P_DATE_OF_DEATH in DATE
,P_BACKGROUND_CHECK_STATUS in VARCHAR2
,P_BACKGROUND_DATE_CHECK in DATE
,P_BLOOD_TYPE in VARCHAR2
,P_CORRESPONDENCE_LANGUAGE in VARCHAR2
,P_FAST_PATH_EMPLOYEE in VARCHAR2
,P_FTE_CAPACITY in NUMBER
,P_HOLD_APPLICANT_DATE_UNTIL in DATE
,P_HONORS in VARCHAR2
,P_INTERNAL_LOCATION in VARCHAR2
,P_LAST_MEDICAL_TEST_BY in VARCHAR2
,P_LAST_MEDICAL_TEST_DATE in DATE
,P_MAILSTOP in VARCHAR2
,P_OFFICE_NUMBER in VARCHAR2
,P_ON_MILITARY_SERVICE in VARCHAR2
,P_ORDER_NAME in VARCHAR2
,P_PRE_NAME_ADJUNCT in VARCHAR2
,P_PROJECTED_START_DATE in DATE
,P_REHIRE_AUTHORIZOR in VARCHAR2
,P_REHIRE_RECOMMENDATION in VARCHAR2
,P_RESUME_EXISTS in VARCHAR2
,P_RESUME_LAST_UPDATED in DATE
,P_SECOND_PASSPORT_EXISTS in VARCHAR2
,P_STUDENT_STATUS in VARCHAR2
,P_WORK_SCHEDULE in VARCHAR2
,P_PER_INFORMATION21 in VARCHAR2
,P_PER_INFORMATION22 in VARCHAR2
,P_PER_INFORMATION23 in VARCHAR2
,P_PER_INFORMATION24 in VARCHAR2
,P_PER_INFORMATION25 in VARCHAR2
,P_PER_INFORMATION26 in VARCHAR2
,P_PER_INFORMATION27 in VARCHAR2
,P_PER_INFORMATION28 in VARCHAR2
,P_PER_INFORMATION29 in VARCHAR2
,P_PER_INFORMATION30 in VARCHAR2
,P_REHIRE_REASON in VARCHAR2
,P_BENEFIT_GROUP_ID in VARCHAR2
,P_RECEIPT_OF_DEATH_CERT_DATE in DATE
,P_COORD_BEN_MED_PLN_NO in VARCHAR2
,P_COORD_BEN_NO_CVG_FLAG in VARCHAR2
,P_COORD_BEN_MED_EXT_ER in VARCHAR2
,P_COORD_BEN_MED_PL_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_NAME in VARCHAR2
,P_COORD_BEN_MED_INSR_CRR_IDENT in VARCHAR2
,P_COORD_BEN_MED_CVG_STRT_DT in DATE
,P_COORD_BEN_MED_CVG_END_DT in DATE
,P_USES_TOBACCO_FLAG in VARCHAR2
,P_DPDNT_ADOPTION_DATE in DATE
,P_DPDNT_VLNTRY_SVCE_FLAG in VARCHAR2
,P_ORIGINAL_DATE_OF_HIRE in DATE
,P_TOWN_OF_BIRTH in VARCHAR2
,P_REGION_OF_BIRTH in VARCHAR2
,P_COUNTRY_OF_BIRTH in VARCHAR2
,P_GLOBAL_PERSON_ID in VARCHAR2
,P_PARTY_ID in NUMBER
,P_NPW_NUMBER in VARCHAR2
,P_CURRENT_NPW_FLAG in VARCHAR2
,P_GLOBAL_NAME in VARCHAR2
,P_LOCAL_NAME in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
l_commit_unit_number number;

Line: 163


hr_utility.set_location('Entering: PER_PER_RKI.AFTER_INSERT', 10);

Line: 177


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

Line: 178


end AFTER_INSERT;