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_ASG_STATUS_API dependencies on IRC_INTERVIEW_DETAILS

Line 158: iid_rec irc_interview_details%rowtype;

154: PROCEDURE UPDATE_INTERVIEW(
155: p_assignment_id in NUMBER
156: ,p_assignment_status_type_id in NUMBER
157: ) is
158: iid_rec irc_interview_details%rowtype;
159: l_return_status varchar2(30);
160: L_NOTIFY_PARAMS VARCHAR2(4000);
161: cursor cur_iid is
162: select iid.*

Line 163: from irc_interview_details iid

159: l_return_status varchar2(30);
160: L_NOTIFY_PARAMS VARCHAR2(4000);
161: cursor cur_iid is
162: select iid.*
163: from irc_interview_details iid
164: ,per_events pe
165: where iid.event_id = pe.event_id
166: and iid.status not in ('COMPLETED','CANCELLED')
167: and sysdate between iid.start_date and iid.end_date

Line 172: IRC_INTERVIEW_DETAILS_SWI.UPDATE_IRC_INTERVIEW_DETAILS(

168: and pe.assignment_id = p_assignment_id;
169: begin
170: for iid_rec in cur_iid
171: loop
172: IRC_INTERVIEW_DETAILS_SWI.UPDATE_IRC_INTERVIEW_DETAILS(
173: P_STATUS => 'CANCELLED'
174: ,P_FEEDBACK => IID_REC.FEEDBACK
175: ,P_NOTES => IID_REC.NOTES
176: ,P_NOTES_TO_CANDIDATE => IID_REC.NOTES_TO_CANDIDATE