1 package IEM_SENDMAIL_PVT AUTHID CURRENT_USER as
2 /* $Header: iemvsoms.pls 115.3 2002/12/05 06:14:03 sboorela shipped $*/
3 TYPE email_encrypt_rec_type IS RECORD (
4 encrypt_key varchar2(100),
5 encrypt_value varchar2(500));
6
7 TYPE email_encrypt_tbl IS TABLE OF email_encrypt_rec_type
8 INDEX BY BINARY_INTEGER;
9 PROCEDURE IEM_CHK_TEMPLATE(
10 p_template_id in number,
11 x_status OUT NOCOPY varchar2);
12 PROCEDURE IEM_SENDMAIL(
13 p_user in varchar2,
14 p_domain in varchar2,
15 p_password in varchar2,
16 p_replyto in varchar2,
17 p_file_id in number,
18 p_subject in varchar2,
19 p_tostr in varchar2,
20 p_fromstr in varchar2,
21 p_encrypt_tbl in email_encrypt_tbl,
22 x_status OUT NOCOPY varchar2,
23 x_return_text OUT NOCOPY varchar2
24 );
25 end IEM_SENDMAIL_PVT;