APPS.IRC_COMMUNICATIONS_API dependencies on IRC_COMM_MESSAGES

Line 1516: Cursor cur_tpc_frm_msg(p_message_id irc_comm_messages.communication_message_id%TYPE) is

1512: and ic.communication_id = ict.communication_id
1513: and paf.assignment_id = ic.object_id
1514: and ic.object_type = 'APPL';
1515: --
1516: Cursor cur_tpc_frm_msg(p_message_id irc_comm_messages.communication_message_id%TYPE) is
1517: --get topic_id from message_id
1518: select msg.communication_topic_id
1519: from
1520: irc_comm_messages msg

Line 1520: irc_comm_messages msg

1516: Cursor cur_tpc_frm_msg(p_message_id irc_comm_messages.communication_message_id%TYPE) is
1517: --get topic_id from message_id
1518: select msg.communication_topic_id
1519: from
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

Line 1551: l_recipient_type irc_comm_messages.sender_type%TYPE;

1547: --
1548: l_list varchar2(32767);
1549: l_vacancy_id number;
1550: l_recipient_id number;
1551: l_recipient_type irc_comm_messages.sender_type%TYPE;
1552: l_topic_id number;
1553: l_rec_id number;
1554: l_mgr_id number;
1555: l_apl_id number;

Line 1609: ' irc_comm_messages icm'||

1605: --get message sender
1606: if filter = 'SENDER' then
1607: query_str := ' select icm.sender_id, icm.sender_type' ||
1608: ' from' ||
1609: ' irc_comm_messages icm'||
1610: ' where icm.communication_message_id =:1' ;
1611: end if;
1612:
1613: --get all recipients of message

Line 1618: ' irc_comm_messages icm,' ||

1614: if filter = 'MESSAGE_ALL' then
1615:
1616: query_str :=' select icr.recipient_id,icr.recipient_type' ||
1617: ' from' ||
1618: ' irc_comm_messages icm,' ||
1619: ' irc_comm_recipients icr' ||
1620: ' where' ||
1621: ' icm.communication_message_id= :1' ||
1622: ' and icr.communication_object_id = icm.communication_topic_id' ||