[Home] [Help]
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
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
1548: --
1549: l_list varchar2(32767);
1550: l_vacancy_id number;
1551: l_recipient_id number;
1552: l_recipient_type irc_comm_messages.sender_type%TYPE;
1553: l_topic_id number;
1554: l_rec_id number;
1555: l_mgr_id number;
1556: l_apl_id number;
1606: --get message sender
1607: if filter = 'SENDER' then
1608: query_str := ' select icm.sender_id, icm.sender_type' ||
1609: ' from' ||
1610: ' irc_comm_messages icm'||
1611: ' where icm.communication_message_id =:1' ;
1612: end if;
1613:
1614: --get all recipients of message
1615: if filter = 'MESSAGE_ALL' then
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' ||
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;
2254: l_target_asgn_id number:=p_target_asg_id;
2255: l_comm_id number;
2272: select * from irc_comm_topics
2273: where communication_id = comm_id;
2274:
2275: cursor csrGetCommMessage(topic_id in number) is
2276: select * from irc_comm_messages
2277: where communication_topic_id = topic_id;
2278:
2279: begin
2280: --