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