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

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

Line: 5


procedure UPDATE_IRC_INTERVIEW_DETAILS_A
(P_INTERVIEW_DETAILS_ID in NUMBER
,P_STATUS in VARCHAR2
,P_FEEDBACK in VARCHAR2
,P_NOTES in VARCHAR2
,P_NOTES_TO_CANDIDATE in VARCHAR2
,P_CATEGORY in VARCHAR2
,P_RESULT in VARCHAR2
,P_IID_INFORMATION_CATEGORY in VARCHAR2
,P_IID_INFORMATION1 in VARCHAR2
,P_IID_INFORMATION2 in VARCHAR2
,P_IID_INFORMATION3 in VARCHAR2
,P_IID_INFORMATION4 in VARCHAR2
,P_IID_INFORMATION5 in VARCHAR2
,P_IID_INFORMATION6 in VARCHAR2
,P_IID_INFORMATION7 in VARCHAR2
,P_IID_INFORMATION8 in VARCHAR2
,P_IID_INFORMATION9 in VARCHAR2
,P_IID_INFORMATION10 in VARCHAR2
,P_IID_INFORMATION11 in VARCHAR2
,P_IID_INFORMATION12 in VARCHAR2
,P_IID_INFORMATION13 in VARCHAR2
,P_IID_INFORMATION14 in VARCHAR2
,P_IID_INFORMATION15 in VARCHAR2
,P_IID_INFORMATION16 in VARCHAR2
,P_IID_INFORMATION17 in VARCHAR2
,P_IID_INFORMATION18 in VARCHAR2
,P_IID_INFORMATION19 in VARCHAR2
,P_IID_INFORMATION20 in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: IRC_INTERVIEW_DETAILS_BK2.UPDATE_IRC_INTERVIEW_DETAILS_A', 10);

Line: 38


hr_utility.set_location(' Leaving: IRC_INTERVIEW_DETAILS_BK2.UPDATE_IRC_INTERVIEW_DETAILS_A', 20);

Line: 39


end UPDATE_IRC_INTERVIEW_DETAILS_A;

Line: 40


procedure UPDATE_IRC_INTERVIEW_DETAILS_B
(P_INTERVIEW_DETAILS_ID in NUMBER
,P_STATUS in VARCHAR2
,P_FEEDBACK in VARCHAR2
,P_NOTES in VARCHAR2
,P_NOTES_TO_CANDIDATE in VARCHAR2
,P_CATEGORY in VARCHAR2
,P_RESULT in VARCHAR2
,P_IID_INFORMATION_CATEGORY in VARCHAR2
,P_IID_INFORMATION1 in VARCHAR2
,P_IID_INFORMATION2 in VARCHAR2
,P_IID_INFORMATION3 in VARCHAR2
,P_IID_INFORMATION4 in VARCHAR2
,P_IID_INFORMATION5 in VARCHAR2
,P_IID_INFORMATION6 in VARCHAR2
,P_IID_INFORMATION7 in VARCHAR2
,P_IID_INFORMATION8 in VARCHAR2
,P_IID_INFORMATION9 in VARCHAR2
,P_IID_INFORMATION10 in VARCHAR2
,P_IID_INFORMATION11 in VARCHAR2
,P_IID_INFORMATION12 in VARCHAR2
,P_IID_INFORMATION13 in VARCHAR2
,P_IID_INFORMATION14 in VARCHAR2
,P_IID_INFORMATION15 in VARCHAR2
,P_IID_INFORMATION16 in VARCHAR2
,P_IID_INFORMATION17 in VARCHAR2
,P_IID_INFORMATION18 in VARCHAR2
,P_IID_INFORMATION19 in VARCHAR2
,P_IID_INFORMATION20 in VARCHAR2
,P_OBJECT_VERSION_NUMBER in NUMBER
)is
begin
hr_utility.set_location('Entering: IRC_INTERVIEW_DETAILS_BK2.UPDATE_IRC_INTERVIEW_DETAILS_B', 10);

Line: 73


hr_utility.set_location(' Leaving: IRC_INTERVIEW_DETAILS_BK2.UPDATE_IRC_INTERVIEW_DETAILS_B', 20);

Line: 74


end UPDATE_IRC_INTERVIEW_DETAILS_B;