APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMM_RECIPIENTS

Line 1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is

1520: irc_comm_messages msg
1521: where
1522: msg.communication_message_id = p_message_id;
1523: --
1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is
1525: --get topic_id from recipient_id
1526: select icr.communication_object_id
1527: from
1528: irc_comm_recipients icr

Line 1528: irc_comm_recipients icr

1524: Cursor cur_tpc_frm_rcpt(p_recipient_id irc_comm_recipients.recipient_id%TYPE) is
1525: --get topic_id from recipient_id
1526: select icr.communication_object_id
1527: from
1528: irc_comm_recipients icr
1529: where
1530: icr.communication_recipient_id = p_recipient_id
1531: and icr.communication_object_type = 'TOPIC';
1532: --

Line 1587: ' irc_comm_recipients icr'||

1583:
1584: --get recipients for a given topic_id
1585: query_str := ' select icr.recipient_id, icr.recipient_type' ||
1586: ' from' ||
1587: ' irc_comm_recipients icr'||
1588: ' where icr.communication_object_id = :1' ||
1589: ' and icr.communication_object_type= ''TOPIC''';
1590:
1591: ----------Fetch only selected recipients of a topic

Line 1620: ' irc_comm_recipients icr' ||

1616:
1617: query_str :=' select icr.recipient_id,icr.recipient_type' ||
1618: ' from' ||
1619: ' irc_comm_messages icm,' ||
1620: ' irc_comm_recipients icr' ||
1621: ' where' ||
1622: ' icm.communication_message_id= :1' ||
1623: ' and icr.communication_object_id = icm.communication_topic_id' ||
1624: ' and icr.communication_object_type = ''TOPIC''' ||

Line 1637: ' irc_comm_recipients icr' ||

1633:
1634: if filter = 'ROLE' then
1635: query_str :=' select icr.recipient_id,icr.recipient_type' ||
1636: ' from' ||
1637: ' irc_comm_recipients icr' ||
1638: ' where' ||
1639: ' icr.communication_recipient_id =:1';
1640: end if;
1641: -----------------------Recipient query making finish------------------------------

Line 2249: l_comm_recp_rec irc_comm_recipients%rowtype;

2245: ) is
2246:
2247: l_proc varchar2(72) := g_package || 'copy_comm_to_apl_asg';
2248: l_comm_rec irc_communications%rowtype;
2249: l_comm_recp_rec irc_comm_recipients%rowtype;
2250: l_comm_topics irc_comm_topics%rowtype;
2251: irc_comm_msgs irc_comm_messages%rowtype;
2252: l_src_asgn_id number:=p_source_asg_id;
2253: l_eff_date date:=sysdate;

Line 2268: select * from irc_comm_recipients

2264: select * from irc_communications
2265: where object_id = src_asgn_id;
2266:
2267: Cursor csrGetCommRec(comm_topic_id in number) is
2268: select * from irc_comm_recipients
2269: where communication_object_id = comm_topic_id;
2270:
2271: cursor csrGetCommTopics(comm_id in number) is
2272: select * from irc_comm_topics