GET_MAIL_FOR_CHANGED_COMPANY - Intergraph Smart Materials - Version 10.1 - Customization & Programming - Hexagon

Intergraph Smart Materials Customization (10.1)

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

Description:

This CIP is called from the m_login_requests_aur_trg trigger when company data is changed after the approval on the Company tab in Smart Materials Portal.

Type:

Procedure

Usage:

Smart Materials Portal

Event:

Changing company data after the approval

Default:

p_header := 'Data of Company ' || p_company_code || ' changed in Portal';

p_body := 'The company data of ' || p_old_company_name || ' (' || p_company_code ||') has been updated in the Portal as follows:'|| cr || cr || 'Field: Old Value ---> New Value'|| chr(10) ||'-------------------------------------------------------' || cr || cr

followed by the list of changed values.

If DBA setting COMP_REG_AUTO_SYNC is set to N, this sentence is added to the mail:

'Verify and approve the changes, or reject with an explanation.'