GET_EMAIL_ACCOUNT_SUBSTITUTE - 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 function can be used to return a substitute email address, that is used as the sender email address instead of the email address specified with DBA setting EMAIL ACCOUNT, in the event of emails sent on approving inquiries.

Parameters p_pk_type, p_pk_id1 and p_pk_id2, used to identify email addresses dependent on the pk-type. For example, with pk_type='INQ' and pk_id1=INQ_ID you determine the buyer of the inquiry.

PK_TYPE

PK_ID1

PK_ID2

Table

Screen

INQ

INQ_ID

M_INQUIRIES

A2049, P3021

INQ_SUP

INQ_ID

SUP_ID

M_INQ_SUPPLIERS

A2049, A6055, P3021

INQ_ML

INQ_ID

M_MIP_MAIL_LISTS

A2049, P3021

LR

LRE_ID

M_LOGIN_REQUESTS

P2002

SUP_FIN

INQ_ID

SUP_ID

M_INQ_SUPPLIER

P3027

SHOP_EXP

SF_ID

M_FREELANCER_CONTACTS

P7073

SHOP_INSP

SF_ID

M_FREELANCER_CONTACTS

P7073

SUP_NOB

INQ_ID

SUP_ID

M_INQ_SUPPLIERS

WWW_SUP_ENTRY

CCP_PWD

CCP_ID

M_COMPANY_CONTACT_PEOPLE

A1023

Type:

Function

Usage:

Inquiry Approval

Event:

Approve inquiry

Default:

NULL