Description: |
This function fetches information about a change order request and appends it to the approval email body. |
Type: |
Function |
Usage: |
Called by BUILD_APPORVAL_BODY CIP function |
Event: |
Select Ready for Approval, or click Approve button |
Default: |
'Change Order Request:' || v_cnr_number || v_cr || 'Revision :' || v_revision_id || v_cr || 'Short Desc :' || NVL(v_short_desc, '(Not set)') || v_cr || 'Description :' || NVL(v_description, '(Not set)') || v_cr || 'Project :' || v_proj_id || v_cr || 'Agreement :' || v_po_number || v_cr || 'Subcontractor :' || v_sup_code || v_cr || 'Requested Amount :' || TO_CHAR(v_req_amount,'999G999G999G990D00') || ' ' || v_curcy_code || v_cr || v_cr; |