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 185: iid_rec irc_interview_details%rowtype;

181: PROCEDURE UPDATE_INTERVIEW(
182: p_assignment_id in NUMBER
183: ,p_assignment_status_type_id in NUMBER
184: ) is
185: iid_rec irc_interview_details%rowtype;
186: l_return_status varchar2(30);
187: L_NOTIFY_PARAMS VARCHAR2(4000);
188: cursor cur_iid is
189: select iid.*

Line 190: from irc_interview_details iid

186: l_return_status varchar2(30);
187: L_NOTIFY_PARAMS VARCHAR2(4000);
188: cursor cur_iid is
189: select iid.*
190: from irc_interview_details iid
191: ,per_events pe
192: where iid.event_id = pe.event_id
193: and iid.status not in ('COMPLETED','CANCELLED')
194: and sysdate between iid.start_date and iid.end_date

Line 199: IRC_INTERVIEW_DETAILS_SWI.UPDATE_IRC_INTERVIEW_DETAILS(

195: and pe.assignment_id = p_assignment_id;
196: begin
197: for iid_rec in cur_iid
198: loop
199: IRC_INTERVIEW_DETAILS_SWI.UPDATE_IRC_INTERVIEW_DETAILS(
200: P_STATUS => 'CANCELLED'
201: ,P_FEEDBACK => IID_REC.FEEDBACK
202: ,P_NOTES => IID_REC.NOTES
203: ,P_NOTES_TO_CANDIDATE => IID_REC.NOTES_TO_CANDIDATE