APPS.IRC_IPD_RKI SQL Statements

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

Line: 5

procedure AFTER_INSERT
(P_PENDING_DATA_ID in NUMBER
,P_EMAIL_ADDRESS in VARCHAR2
,P_VACANCY_ID in NUMBER
,P_LAST_NAME in VARCHAR2
,P_FIRST_NAME in VARCHAR2
,P_USER_PASSWORD in VARCHAR2
,P_RESUME_FILE_NAME in VARCHAR2
,P_RESUME_DESCRIPTION in VARCHAR2
,P_RESUME_MIME_TYPE in VARCHAR2
,P_SOURCE_TYPE in VARCHAR2
,P_JOB_POST_SOURCE_NAME in VARCHAR2
,P_POSTING_CONTENT_ID in NUMBER
,P_PERSON_ID in NUMBER
,P_PROCESSED in VARCHAR2
,P_SEX in VARCHAR2
,P_DATE_OF_BIRTH in DATE
,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_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_ERROR_MESSAGE in VARCHAR2
,P_CREATION_DATE in DATE
,P_LAST_UPDATE_DATE in DATE
,P_ALLOW_ACCESS in VARCHAR2
,P_VISITOR_RESP_KEY in VARCHAR2
,P_VISITOR_RESP_APPL_ID in NUMBER
,P_SECURITY_GROUP_KEY in VARCHAR2
)is
begin
hr_utility.set_location('Entering: IRC_IPD_RKI.AFTER_INSERT', 10);

Line: 63

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

Line: 64

end AFTER_INSERT;