Description: |
Sends an email to the supplier and to the ZP_NDA_ML distribution list. Parameters: IN: sup_code, proj_id, old_status, new_status, comments OUT: mail_subject, mail_body |
Type: |
Procedure |
Usage: |
P.20.01 |
Event: |
When the buyer selects 'Pending' (even before the NDA document is uploaded) or 'Received' from the NDA Status dropdown list, this mail is sent. |
Default: |
p_mail_subject := 'NDA status changed'; p_mail_body := 'NDA status of the supplier '|| UPPER(p_sup_code)||' for project ' || UPPER(p_proj_id) ||' has been changed from ' ||UPPER(p_old_status)||' to ' || UPPER(p_new_status) || chr(10) || chr(10) ||'Comments: ' || UPPER(p_comments) || chr(10) || chr(10)||'This e-mail has been generated automatically. Please do not reply.'; |