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

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

Line: 5


procedure UPDATE_PENDING_DATA_A
(P_EMAIL_ADDRESS in VARCHAR2
,P_LAST_NAME in VARCHAR2
,P_VACANCY_ID in NUMBER
,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
l_commit_unit_number number;

Line: 63


hr_utility.set_location('Entering: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_A', 10);

Line: 66


irc_pending_data_be2.UPDATE_PENDING_DATA_A
(P_EMAIL_ADDRESS => P_EMAIL_ADDRESS
,P_LAST_NAME => P_LAST_NAME
,P_VACANCY_ID => P_VACANCY_ID
,P_FIRST_NAME => P_FIRST_NAME
,P_USER_PASSWORD => P_USER_PASSWORD
,P_RESUME_FILE_NAME => P_RESUME_FILE_NAME
,P_RESUME_DESCRIPTION => P_RESUME_DESCRIPTION
,P_RESUME_MIME_TYPE => P_RESUME_MIME_TYPE
,P_SOURCE_TYPE => P_SOURCE_TYPE
,P_JOB_POST_SOURCE_NAME => P_JOB_POST_SOURCE_NAME
,P_POSTING_CONTENT_ID => P_POSTING_CONTENT_ID
,P_PERSON_ID => P_PERSON_ID
,P_PROCESSED => P_PROCESSED
,P_SEX => P_SEX
,P_DATE_OF_BIRTH => P_DATE_OF_BIRTH
,P_PER_INFORMATION_CATEGORY => P_PER_INFORMATION_CATEGORY
,P_PER_INFORMATION1 => P_PER_INFORMATION1
,P_PER_INFORMATION2 => P_PER_INFORMATION2
,P_PER_INFORMATION3 => P_PER_INFORMATION3
,P_PER_INFORMATION4 => P_PER_INFORMATION4
,P_PER_INFORMATION5 => P_PER_INFORMATION5
,P_PER_INFORMATION6 => P_PER_INFORMATION6
,P_PER_INFORMATION7 => P_PER_INFORMATION7
,P_PER_INFORMATION8 => P_PER_INFORMATION8
,P_PER_INFORMATION9 => P_PER_INFORMATION9
,P_PER_INFORMATION10 => P_PER_INFORMATION10
,P_PER_INFORMATION11 => P_PER_INFORMATION11
,P_PER_INFORMATION12 => P_PER_INFORMATION12
,P_PER_INFORMATION13 => P_PER_INFORMATION13
,P_PER_INFORMATION14 => P_PER_INFORMATION14
,P_PER_INFORMATION15 => P_PER_INFORMATION15
,P_PER_INFORMATION16 => P_PER_INFORMATION16
,P_PER_INFORMATION17 => P_PER_INFORMATION17
,P_PER_INFORMATION18 => P_PER_INFORMATION18
,P_PER_INFORMATION19 => P_PER_INFORMATION19
,P_PER_INFORMATION20 => P_PER_INFORMATION20
,P_PER_INFORMATION21 => P_PER_INFORMATION21
,P_PER_INFORMATION22 => P_PER_INFORMATION22
,P_PER_INFORMATION23 => P_PER_INFORMATION23
,P_PER_INFORMATION24 => P_PER_INFORMATION24
,P_PER_INFORMATION25 => P_PER_INFORMATION25
,P_PER_INFORMATION26 => P_PER_INFORMATION26
,P_PER_INFORMATION27 => P_PER_INFORMATION27
,P_PER_INFORMATION28 => P_PER_INFORMATION28
,P_PER_INFORMATION29 => P_PER_INFORMATION29
,P_PER_INFORMATION30 => P_PER_INFORMATION30
,P_ERROR_MESSAGE => P_ERROR_MESSAGE
,P_CREATION_DATE => P_CREATION_DATE
,P_LAST_UPDATE_DATE => P_LAST_UPDATE_DATE
,P_ALLOW_ACCESS => P_ALLOW_ACCESS
,P_VISITOR_RESP_KEY => P_VISITOR_RESP_KEY
,P_VISITOR_RESP_APPL_ID => P_VISITOR_RESP_APPL_ID
,P_SECURITY_GROUP_KEY => P_SECURITY_GROUP_KEY
);

Line: 123


hr_api.validate_commit_unit(l_commit_unit_number, 'UPDATE_PENDING_DATA', 'AP');

Line: 124


hr_utility.set_location(' Leaving: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_A', 20);

Line: 125


end UPDATE_PENDING_DATA_A;

Line: 126


procedure UPDATE_PENDING_DATA_B
(P_EMAIL_ADDRESS in VARCHAR2
,P_LAST_NAME in VARCHAR2
,P_VACANCY_ID in NUMBER
,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_PENDING_DATA_BK2.UPDATE_PENDING_DATA_B', 10);

Line: 183


hr_utility.set_location(' Leaving: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_B', 20);

Line: 184


end UPDATE_PENDING_DATA_B;