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

Description:

Procedure to create the email that is sent on releasing requisitions to procurement.

Parameter Details:

p_scheduled_mail.SMAIL_ID > Primary Key of the mail.

p_scheduled_mail.CREATED_BY > User ID of the user who triggered the mail

p_scheduled_mail.PK_ID > Requisition Id (R_ID)

• The DBA settings REPORT_SERVER, PDB_REPORT_DEST_DB, BI_START_REPORT_SERVER and DEFAULT_TNS_NAMES_ENTRY should be filled correctly to generate the file at the defined location set with PDB_REPORT_DEST_DB.

• The DBA setting value for REPORT_SERVER should be added to ACL.

Type:

Procedure

Usage:

Smart Materials - Maintain Requisitions

Event:

Clicking Release button to release the requisition to procurement

Default:

Subject: [Requisition Released] Requisition number (supplement_number) is released to procurement

Body: Please find hereafter the document's neccesary information and corresponding file

01) Document Reference : v_document_reference

02) Revision Number : v_mr_revision

03) Document Title : v_desc

04) Released to Procurement : v_rel_to_proc_date

05) Document Origin : v_origin_code

06) Project : v_proj_details

07) Discipline : v_dp_code

Attachment :