APPS.IRC_PURGE_OLD_DATA_PKG dependencies on IRC_COMM_TOPICS

Line 334: irc_comm_topics ict,

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
338: where ppf.party_id = p_party_id

Line 353: irc_comm_topics ict,

349: -----------------------
350: cursor csr_irc_cmr is
351: select icr.COMMUNICATION_RECIPIENT_ID, icr.OBJECT_VERSION_NUMBER
352: from irc_comm_recipients icr,
353: irc_comm_topics ict,
354: irc_communications ic,
355: per_all_assignments_f paf,
356: per_all_people_f ppf
357: where ppf.party_id = p_party_id

Line 368: -- For IRC_COMM_TOPICS

364: and ict.COMMUNICATION_ID = ic.COMMUNICATION_ID
365: and icr.COMMUNICATION_OBJECT_ID = ict.COMMUNICATION_TOPIC_ID
366: and icr.COMMUNICATION_OBJECT_TYPE = 'TOPIC';
367:
368: -- For IRC_COMM_TOPICS
369: -------------------
370: cursor csr_irc_cmt is
371: select ict.COMMUNICATION_TOPIC_ID, ict.OBJECT_VERSION_NUMBER
372: from irc_comm_topics ict,

Line 372: from irc_comm_topics ict,

368: -- For IRC_COMM_TOPICS
369: -------------------
370: cursor csr_irc_cmt is
371: select ict.COMMUNICATION_TOPIC_ID, ict.OBJECT_VERSION_NUMBER
372: from irc_comm_topics ict,
373: irc_communications ic,
374: per_all_assignments_f paf,
375: per_all_people_f ppf
376: where ppf.party_id = p_party_id

Line 552: -- Delete from IRC_COMM_TOPICS

548: ,p_object_version_number => rec_irc_cmr.OBJECT_VERSION_NUMBER
549: );
550: end loop;
551: --
552: -- Delete from IRC_COMM_TOPICS
553: --
554: for rec_irc_cmt in csr_irc_cmt loop
555: irc_cmt_del.del
556: (p_communication_topic_id => rec_irc_cmt.COMMUNICATION_TOPIC_ID