[Home] [Help]
385: , p_person_id number )
386: RETURN varchar2
387: IS
388: -- Size of the html text should be based on the size that WF can take
389: -- This is set in irc_notification_helper_pkg.set_v2_attributes
390: -- We define 8 packets of 1950 chars each minus 1 hence the size
391: -- of the varchar2 is set to 15599
392: --
393: l_job_html VARCHAR2(15599);
502: , p_person_id number)
503: RETURN varchar2
504: IS
505: -- Size of the html text should be based on the size that WF can take
506: -- This is set in irc_notification_helper_pkg.set_v2_attributes
507: -- We define 8 packets of 1950 chars each minus 1 hence the size
508: -- of the varchar2 is set to 15599
509: --
510: l_job_text VARCHAR2(15599);
1481: --dbms_output.put_line(' Person:'||seeker_rec.person_id||' Has Matches');
1482: --
1483: l_message_subject := fnd_message.get_string('PER','IRC_EMAIL_SEEKERS_SUBJECT');
1484: l_id :=
1485: irc_notification_helper_pkg.send_notification
1486: ( p_person_id => seeker_rec.person_id
1487: , p_subject => l_message_subject
1488: , p_html_body => get_seeker_html_msg_body
1489: ( p_posting_details_tab =>l_posting_details_tab
2067: l_message_subject := fnd_message.get;
2068:
2069:
2070: --
2071: l_id := irc_notification_helper_pkg.send_notification
2072: ( p_person_id => available_vacancy.recruiter_id
2073: , p_subject => l_message_subject
2074: , p_html_body => get_recruiter_html_msg_body
2075: ( p_seeker_details_tab =>l_seeker_details_tab )
2165: ,p_action =>'UG');
2166: --
2167: begin
2168: l_id :=
2169: irc_notification_helper_pkg.send_notification
2170: ( p_person_id => parties_wanting_it.person_id
2171: , p_subject => l_message_subject
2172: , p_html_body => l_general_body_html
2173: , p_text_body => l_general_body_text