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

Line 320: -- For IRC_INTERVIEW_DETAILS

316: from irc_vacancy_considerations
317: where party_id = p_party_id;
318: --
319:
320: -- For IRC_INTERVIEW_DETAILS
321: -------------------------
322: cursor csr_irc_iid is
323: select iid.interview_details_id, iid.object_version_number, iid.start_date, iid.end_date
324: from irc_interview_details iid,

Line 324: from irc_interview_details iid,

320: -- For IRC_INTERVIEW_DETAILS
321: -------------------------
322: cursor csr_irc_iid is
323: select iid.interview_details_id, iid.object_version_number, iid.start_date, iid.end_date
324: from irc_interview_details iid,
325: per_events pe
326: where pe.party_id = p_party_id
327: and iid.event_id = pe.event_id;
328:

Line 527: -- Delete from IRC_INTERVIEW_DETAILS

523: ,p_object_version_number => rec_ivc.object_version_number
524: );
525: end loop;
526: --
527: -- Delete from IRC_INTERVIEW_DETAILS
528: --
529: for rec_irc_iid in csr_irc_iid loop
530: delete from irc_interview_details
531: where interview_details_id = rec_irc_iid.interview_details_id;

Line 530: delete from irc_interview_details

526: --
527: -- Delete from IRC_INTERVIEW_DETAILS
528: --
529: for rec_irc_iid in csr_irc_iid loop
530: delete from irc_interview_details
531: where interview_details_id = rec_irc_iid.interview_details_id;
532: end loop;
533: --
534: -- Delete from IRC_COMM_MESSAGES