APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_COMM_MESSAGES

Line 329: -- For IRC_COMM_MESSAGES

325: per_events pe
326: where pe.party_id = p_party_id
327: and iid.event_id = pe.event_id;
328:
329: -- For IRC_COMM_MESSAGES
330: ---------------------
331: cursor csr_irc_cmm is
332: select icm.COMMUNICATION_MESSAGE_ID, icm.OBJECT_VERSION_NUMBER
333: from irc_comm_messages icm,

Line 333: from irc_comm_messages icm,

329: -- For IRC_COMM_MESSAGES
330: ---------------------
331: cursor csr_irc_cmm is
332: select icm.COMMUNICATION_MESSAGE_ID, icm.OBJECT_VERSION_NUMBER
333: from irc_comm_messages icm,
334: irc_comm_topics ict,
335: irc_communications ic,
336: per_all_assignments_f paf,
337: per_all_people_f ppf

Line 534: -- Delete from IRC_COMM_MESSAGES

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
535: --
536: for rec_irc_cmm in csr_irc_cmm loop
537: irc_cmm_del.del
538: (p_communication_message_id => rec_irc_cmm.COMMUNICATION_MESSAGE_ID