GET_NDA_STATUS_CHANGE_MAIL - Intergraph Smart Materials - Version 10.2 - Customization & Programming - Hexagon

Intergraph Smart Materials Customization (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Customization & Programming
Smart Materials/Smart Reference Data Version
10.2

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.';