iKnowBase


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.

Field Detail

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.

Method Detail

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


iKnowBase