To see a notification as below.
If there is an email attached to the WF Role of recepient, then an Email will be sent out to that recepient with the contents as shown below.
Run the API, as shown below
DECLARE
n_not_id INTEGER;
BEGIN
xx_notifications_api_pkg.send_notification(
x_email_address => ''
,x_user_name => 'PASSIA'
,x_notification_api_id => n_not_id
,x_message_type => 'TEXT_AND_QUERY'
,x_process_short_code=> 'TEST'
,x_message_subject => 'Annual Return 2001'
,x_response_lookup_type => ''
,x_message_text => '___________________________________________________________________________________________________
<br>
<CENTER><b><font size=+1>Annual Return 2003</font></b></CENTER>
<br>____________________________________________________________________________________________________
<p>
<CENTER><b>DECLARATION OF INTERESTS</b></CENTER><b></b>
<p>
Each member of Company must respond, whether full or part time.
<br><b>
To be completed even if the return is zero</b><b></b>
<p><b>Full Name </b>Anil Passi
<br><b>Employee Number
</b>163707
<p>
This return covers the period between 1 August 2002 and 31 July 2003. The
information you
<br>
give should relate to this period only
<p><b>During this period have you occupied a position of Director, Partner,
Consultant, Trustee or Trader?</b>
</body>
</html>');
dbms_output.put_line('n_not_id: ' || n_not_id);
commit;
END;
/
Comments
Thanks - Mike
Cheers
Anil Passi
Is this a custom API? or a seeded one ? Can we use this in any of our user procedure?
Could you provide source code for this package 'xx_notificatio ns_api_pkg'.
I wan to know how did you to implement it in your package.
I have to develop the same functionality , thank god you have this code, can you please help me.
Please provide me the source code or suggest me how to send HTML notifications.
Thanks
Sriniva s
i am trying to send notification to application and it was working fine but my problem in add_query procedure i want pass bindvariable plz send me any script by useing bindvairables in add_query procedure.
RSS feed for comments to this post