Package IKB_MAILSENDER
Field Summary |
VARCHAR2(50) | GV_MAILSENDER_QUEUE CONSTANT := UPPER(IKB_GLOBAL_PREFS.PROVIDER_SCHEMA) || '.BATCH_EMAILSENDER_Q'
Send a message without waiting for a response. |
Method Summary |
VARCHAR2 |
GET_ADDRESS(ADDR_LIST IN OUT CLOB)
|
IKB_PORTAL_API.VC_ARR |
GET_ADDRESS_LIST(P_ADDRESS_LIST IN CLOB)
|
IKB_PORTAL_API.VC_ARR |
MAKEARRAY(P_LIST IN CT_VALUE_VARCHARS)
|
|
SEND(P_REQUEST IN OT_BATCH_EMAILSENDER_MESSAGE, P_ATTACHMENTS IN CT_ATTACHMENT DEFAULT CT_ATTACHMENT())
|
|
SEND(P_PROFILE IN VARCHAR2 DEFAULT 'default', P_FROM IN VARCHAR2, P_SUBJECT IN VARCHAR2, P_RECIP IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR, P_CC IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR, P_BCC IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR, P_ATTACHMENT IN CT_ATTACHMENT DEFAULT CT_ATTACHMENT(), P_HEADER_NAME IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR, P_HEADER_VALUE IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR, P_TEXT_BODY IN CLOB DEFAULT NULL, P_HTML_BODY IN CLOB DEFAULT NULL, P_SEND_INDIVIDUAL IN VARCHAR2 DEFAULT 'N')
Send mail to one or more recipients with or without attachments. |
GV_MAILSENDER_QUEUE
public VARCHAR2(50) GV_MAILSENDER_QUEUE CONSTANT := UPPER(IKB_GLOBAL_PREFS.PROVIDER_SCHEMA) || '.BATCH_EMAILSENDER_Q'
- Send a message without waiting for a response.
-
GET_ADDRESS
public VARCHAR2 GET_ADDRESS(ADDR_LIST IN OUT CLOB)
-
GET_ADDRESS_LIST
public IKB_PORTAL_API.VC_ARR GET_ADDRESS_LIST(P_ADDRESS_LIST IN CLOB)
-
MAKEARRAY
public IKB_PORTAL_API.VC_ARR MAKEARRAY(P_LIST IN CT_VALUE_VARCHARS)
-
SEND
public SEND(P_REQUEST IN OT_BATCH_EMAILSENDER_MESSAGE,
P_ATTACHMENTS IN CT_ATTACHMENT DEFAULT CT_ATTACHMENT())
-
SEND
public SEND(P_PROFILE IN VARCHAR2 DEFAULT 'default',
P_FROM IN VARCHAR2,
P_SUBJECT IN VARCHAR2,
P_RECIP IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR,
P_CC IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR,
P_BCC IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR,
P_ATTACHMENT IN CT_ATTACHMENT DEFAULT CT_ATTACHMENT(),
P_HEADER_NAME IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR,
P_HEADER_VALUE IN IKB_PORTAL_API.VC_ARR DEFAULT IKB_PORTAL_API.EMPTY_VC_ARR,
P_TEXT_BODY IN CLOB DEFAULT NULL,
P_HTML_BODY IN CLOB DEFAULT NULL,
P_SEND_INDIVIDUAL IN VARCHAR2 DEFAULT 'N')
- Send mail to one or more recipients with or without attachments.
-
- Parameters:
-
P_PROFILE
-
Applies only if ikb_global_prefs.has_oracle_smtp is FALSE, refers to ikb_installation_properties values for email settings
-
P_FROM
-
A valid email address
-
P_SUBJECT
-
The title of the email
-
P_RECIP
-
One or more recipients defined as an array
-
P_CC
-
One or more recipients defined as an array sent as CC (Carbon copy)
-
P_BCC
-
One or more recipients defined as an array sent as BCC (Blind copy)
-
P_ATTACHMENT
-
An array (ct_attachments) of attachments
-
P_HEADER_NAME
-
Array of header name. Must correspond with p_header_value
-
P_HEADER_VALUE
-
Array of header name. Must correspond with p_header_name
-
P_TEXT_BODY
-
The mail body as text. Only used by java mail function
-
P_HTML_BODY
-
The mail body as HTML.
-
P_SEND_INDIVIDUAL
-
If many recipients; Should the mail be sent as a single email or one for each recipient? Valid values are Y or N