[Home] [Help]
1469: -- ----------------------------------------------------------------------------
1470: --
1471: function get_rcpt_list(p_object_id IN number,filter varchar2 ) return varchar2 is
1472: --
1473: Cursor cur_vac_id(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1474: --get vacancy_id from topic_id
1475: select icp.object_id
1476: from
1477: irc_comm_properties icp,
1475: select icp.object_id
1476: from
1477: irc_comm_properties icp,
1478: irc_communications ic,
1479: irc_comm_topics ict
1480: where
1481: ict.communication_topic_id = p_topic_id
1482: and ic.communication_id = ict.communication_id
1483: and icp.communication_property_id = ic.communication_property_id
1499: irc_rec_team_members team
1500: where
1501: team.vacancy_id = p_vacancy_id;
1502: --
1503: Cursor cur_apl(p_topic_id irc_comm_topics.communication_topic_id%TYPE) is
1504: --get applicant for application attached to the given topic
1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,
1505: select paf.person_id
1506: from
1507: per_all_assignments_f paf,
1508: irc_communications ic,
1509: irc_comm_topics ict
1510: where
1511: ict.communication_topic_id = p_topic_id
1512: and ic.communication_id = ict.communication_id
1513: and paf.assignment_id = ic.object_id
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;
2254: l_target_asgn_id number:=p_target_asg_id;
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
2273: where communication_id = comm_id;
2274:
2275: cursor csrGetCommMessage(topic_id in number) is
2276: select * from irc_comm_messages