-- Resubmitted Primary Requirements Portal and Email
INSERT INTO SMNTP_MESSAGE_DEFAULT (TYPE_ID, SUBJECT, TOPIC, MESSAGE, STATUS_ID) VALUES ('1', '[vendorname]', 'Resubmitted Primary Requirements', 'Dear [vrdstaff],

[vendorname] has resubmitted his/her Incomplete Primary Requirements.

Thank you,
SM Vendor Portal Admin', '1001');

INSERT INTO SMNTP_EMAIL_DEFAULT_TEMPLATE (TEMPLATE_TYPE, CONTENT, ACTIVE, DESCRIPTION) VALUES ('47', 'Dear [vrdstaff],

[vendorname] has resubmitted his/her Incomplete Primary Requirements.

Thank you,
SM Vendor Portal Admin', '1', 'Resubmitted Primary Requirements');

UPDATE SMNTP_EMAIL_DEFAULT_TEMPLATE SET CONTENT = 'Dear [vrdstaff],

Please review additional requirements of [vendorname]

Thank you,
SM Vendor Portal Admin' WHERE TEMPLATE_TYPE = 43;

UPDATE SMNTP_EMAIL_DEFAULT_TEMPLATE SET CONTENT = 'Dear [approver],

Please review additional requirements of [vendorname].

Thank you,
SM Vendor Portal Admin' WHERE TEMPLATE_TYPE = 38;