| index

Package mip_email

Program units

send_email_plain_text |
send_email_vchar |
send_email_clob |

Constants

g_from_address |

g_from_address

    g_from_address CONSTANT VARCHAR2(50) := cout_system_configuration.get_configuration_item('EMAIL_FROM_ADDRESS');

send_email_plain_text

    PROCEDURE send_email_plain_text(p_recipient IN VARCHAR2
                                   ,p_from      IN VARCHAR2 DEFAULT g_from_address
                                   ,p_body      IN VARCHAR2
                                   ,p_subject   IN VARCHAR2)

send_email_vchar

    PROCEDURE send_email_vchar(p_recipient IN VARCHAR2
                              ,p_from      IN VARCHAR2 DEFAULT g_from_address
                              ,p_body      IN VARCHAR2
                              ,p_body_html IN VARCHAR2
                              ,p_subject   IN VARCHAR2)

send_email_clob

    PROCEDURE send_email_clob(p_recipient IN VARCHAR2
                             ,p_from      IN VARCHAR2 DEFAULT g_from_address
                             ,p_body      IN CLOB
                             ,p_body_html IN CLOB
                             ,p_subject   IN VARCHAR2)