eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_MAIL dependencies on UTL_SMTP

Line 27: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,

23: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
24: END;
25:
26: -- Write a MIME header
27: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,
28: name IN VARCHAR2,
29: value IN VARCHAR2) IS
30: BEGIN
31: utl_smtp.write_data(conn, name || ': ' || value || CRLF);

Line 31: utl_smtp.write_data(conn, name || ': ' || value || CRLF);

27: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,
28: name IN VARCHAR2,
29: value IN VARCHAR2) IS
30: BEGIN
31: utl_smtp.write_data(conn, name || ': ' || value || CRLF);
32:
33: EXCEPTION
34: WHEN OTHERS THEN
35: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

Line 39: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,

35: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
36: END;
37:
38: -- Mark a message-part boundary. Set to TRUE for the last boundary.
39: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,
40: last IN BOOLEAN DEFAULT FALSE) AS
41: BEGIN
42: IF (last) THEN
43: utl_smtp.write_data(conn, LAST_BOUNDARY);

Line 43: utl_smtp.write_data(conn, LAST_BOUNDARY);

39: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,
40: last IN BOOLEAN DEFAULT FALSE) AS
41: BEGIN
42: IF (last) THEN
43: utl_smtp.write_data(conn, LAST_BOUNDARY);
44: ELSE
45: utl_smtp.write_data(conn, FIRST_BOUNDARY);
46: END IF;
47: EXCEPTION

Line 45: utl_smtp.write_data(conn, FIRST_BOUNDARY);

41: BEGIN
42: IF (last) THEN
43: utl_smtp.write_data(conn, LAST_BOUNDARY);
44: ELSE
45: utl_smtp.write_data(conn, FIRST_BOUNDARY);
46: END IF;
47: EXCEPTION
48: WHEN OTHERS THEN
49: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

Line 57: conn utl_smtp.connection;

53: PROCEDURE mail(sender IN VARCHAR2,
54: recipient_tbl IN recipient_rec_tbl,
55: subject IN VARCHAR2,
56: message IN VARCHAR2) IS
57: conn utl_smtp.connection;
58: BEGIN
59: conn := begin_mail(sender, recipient_tbl, subject);
60: write_text(conn, message);
61: end_mail(conn);

Line 73: RETURN utl_smtp.connection IS

69: recipient_tbl IN recipient_rec_tbl,
70: subject IN VARCHAR2,
71: mime_type IN VARCHAR2 DEFAULT 'text/plain',
72: priority IN PLS_INTEGER DEFAULT NULL)
73: RETURN utl_smtp.connection IS
74: conn utl_smtp.connection;
75: BEGIN
76: conn := begin_session;
77: begin_mail_in_session(conn, sender, recipient_tbl, subject, mime_type,

Line 74: conn utl_smtp.connection;

70: subject IN VARCHAR2,
71: mime_type IN VARCHAR2 DEFAULT 'text/plain',
72: priority IN PLS_INTEGER DEFAULT NULL)
73: RETURN utl_smtp.connection IS
74: conn utl_smtp.connection;
75: BEGIN
76: conn := begin_session;
77: begin_mail_in_session(conn, sender, recipient_tbl, subject, mime_type,
78: priority);

Line 87: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,

83: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
84: END;
85:
86: ------------------------------------------------------------------------
87: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,
88: message IN VARCHAR2) IS
89: BEGIN
90: utl_smtp.write_data(conn, message);
91: EXCEPTION

Line 90: utl_smtp.write_data(conn, message);

86: ------------------------------------------------------------------------
87: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,
88: message IN VARCHAR2) IS
89: BEGIN
90: utl_smtp.write_data(conn, message);
91: EXCEPTION
92: WHEN OTHERS THEN
93: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
94: END;

Line 97: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,

93: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
94: END;
95:
96: ------------------------------------------------------------------------
97: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,
98: message IN VARCHAR2) IS
99: --l_message VARCHAR2(32000);
100: BEGIN
101: utl_smtp.write_raw_data(conn, utl_raw.cast_to_raw(message));

Line 101: utl_smtp.write_raw_data(conn, utl_raw.cast_to_raw(message));

97: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,
98: message IN VARCHAR2) IS
99: --l_message VARCHAR2(32000);
100: BEGIN
101: utl_smtp.write_raw_data(conn, utl_raw.cast_to_raw(message));
102: --l_message := oks_base64.encode(message);
103: --utl_smtp.write_data(conn, l_message);
104: EXCEPTION
105: WHEN OTHERS THEN

Line 103: --utl_smtp.write_data(conn, l_message);

99: --l_message VARCHAR2(32000);
100: BEGIN
101: utl_smtp.write_raw_data(conn, utl_raw.cast_to_raw(message));
102: --l_message := oks_base64.encode(message);
103: --utl_smtp.write_data(conn, l_message);
104: EXCEPTION
105: WHEN OTHERS THEN
106: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
107: END;

Line 110: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,

106: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
107: END;
108:
109: ------------------------------------------------------------------------
110: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,
111: message IN RAW) IS
112: --l_message VARCHAR2(32000);
113: BEGIN
114: utl_smtp.write_raw_data(conn, message);

Line 114: utl_smtp.write_raw_data(conn, message);

110: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,
111: message IN RAW) IS
112: --l_message VARCHAR2(32000);
113: BEGIN
114: utl_smtp.write_raw_data(conn, message);
115: --l_message := oks_base64.encode(message);
116: --utl_smtp.write_data(conn, l_message);
117: EXCEPTION
118: WHEN OTHERS THEN

Line 116: --utl_smtp.write_data(conn, l_message);

112: --l_message VARCHAR2(32000);
113: BEGIN
114: utl_smtp.write_raw_data(conn, message);
115: --l_message := oks_base64.encode(message);
116: --utl_smtp.write_data(conn, l_message);
117: EXCEPTION
118: WHEN OTHERS THEN
119: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
120: END;

Line 123: PROCEDURE attach_text(conn IN OUT NOCOPY utl_smtp.connection,

119: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
120: END;
121:
122: ------------------------------------------------------------------------
123: PROCEDURE attach_text(conn IN OUT NOCOPY utl_smtp.connection,
124: data IN VARCHAR2,
125: mime_type IN VARCHAR2 DEFAULT 'text/plain',
126: inline IN BOOLEAN DEFAULT TRUE,
127: filename IN VARCHAR2 DEFAULT NULL,

Line 139: PROCEDURE attach_base64(conn IN OUT NOCOPY utl_smtp.connection,

135: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
136: END;
137:
138: ------------------------------------------------------------------------
139: PROCEDURE attach_base64(conn IN OUT NOCOPY utl_smtp.connection,
140: data IN RAW,
141: mime_type IN VARCHAR2 DEFAULT 'application/pdf',
142: inline IN BOOLEAN DEFAULT TRUE,
143: filename IN VARCHAR2 DEFAULT NULL,

Line 160: -- utl_smtp.write_raw_data(conn,

156: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
157: -- For Oracle 9i, replace oks_base64.encode with the native
158: -- utl_encode.base64_encode:
159: --
160: -- utl_smtp.write_raw_data(conn,
161: -- utl_encode.base64_encode(utl_raw.substr(data, i,
162: -- MAX_BASE64_LINE_WIDTH)));
163: --
164: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

Line 165: utl_smtp.write_data(conn,

161: -- utl_encode.base64_encode(utl_raw.substr(data, i,
162: -- MAX_BASE64_LINE_WIDTH)));
163: --
164: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
165: utl_smtp.write_data(conn,
166: oks_base64.encode(utl_raw.substr(data, i,
167: MAX_BASE64_LINE_WIDTH)));
168: -- utl_smtp.write_raw_data(conn, utl_raw.substr(data, i, MAX_BASE64_LINE_WIDTH)); -- By MK
169:

Line 168: -- utl_smtp.write_raw_data(conn, utl_raw.substr(data, i, MAX_BASE64_LINE_WIDTH)); -- By MK

164: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
165: utl_smtp.write_data(conn,
166: oks_base64.encode(utl_raw.substr(data, i,
167: MAX_BASE64_LINE_WIDTH)));
168: -- utl_smtp.write_raw_data(conn, utl_raw.substr(data, i, MAX_BASE64_LINE_WIDTH)); -- By MK
169:
170: ELSE
171: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
172: -- For Oracle 9i, replace oks_base64.encode with the native

Line 175: -- utl_smtp.write_raw_data(conn,

171: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
172: -- For Oracle 9i, replace oks_base64.encode with the native
173: -- utl_encode.base64_encode:
174: --
175: -- utl_smtp.write_raw_data(conn,
176: -- utl_encode.base64_encode(utl_raw.substr(data, i)));
177: --
178: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
179: utl_smtp.write_data(conn,

Line 179: utl_smtp.write_data(conn,

175: -- utl_smtp.write_raw_data(conn,
176: -- utl_encode.base64_encode(utl_raw.substr(data, i)));
177: --
178: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
179: utl_smtp.write_data(conn,
180: oks_base64.encode(utl_raw.substr(data, i)));
181: --utl_smtp.write_raw_data(conn, utl_raw.substr(data, i)); -- By MK
182: END IF;
183: utl_smtp.write_data(conn, CRLF);

Line 181: --utl_smtp.write_raw_data(conn, utl_raw.substr(data, i)); -- By MK

177: --
178: -- @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
179: utl_smtp.write_data(conn,
180: oks_base64.encode(utl_raw.substr(data, i)));
181: --utl_smtp.write_raw_data(conn, utl_raw.substr(data, i)); -- By MK
182: END IF;
183: utl_smtp.write_data(conn, CRLF);
184: i := i + MAX_BASE64_LINE_WIDTH;
185: END LOOP;

Line 183: utl_smtp.write_data(conn, CRLF);

179: utl_smtp.write_data(conn,
180: oks_base64.encode(utl_raw.substr(data, i)));
181: --utl_smtp.write_raw_data(conn, utl_raw.substr(data, i)); -- By MK
182: END IF;
183: utl_smtp.write_data(conn, CRLF);
184: i := i + MAX_BASE64_LINE_WIDTH;
185: END LOOP;
186:
187: -- By MK -- end_attachment(conn, last);

Line 195: PROCEDURE begin_attachment(conn IN OUT NOCOPY utl_smtp.connection,

191: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
192: END;
193:
194: ------------------------------------------------------------------------
195: PROCEDURE begin_attachment(conn IN OUT NOCOPY utl_smtp.connection,
196: mime_type IN VARCHAR2 DEFAULT 'text/plain',
197: inline IN BOOLEAN DEFAULT TRUE,
198: filename IN VARCHAR2 DEFAULT NULL,
199: transfer_enc IN VARCHAR2 DEFAULT NULL) IS

Line 218: utl_smtp.write_data(conn, CRLF);

214: IF (transfer_enc IS NOT NULL) THEN
215: write_mime_header(conn, 'Content-Transfer-Encoding', transfer_enc);
216: END IF;
217:
218: utl_smtp.write_data(conn, CRLF);
219:
220: EXCEPTION
221: WHEN OTHERS THEN
222: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );

Line 226: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,

222: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
223: END;
224:
225: ------------------------------------------------------------------------
226: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,
227: last IN BOOLEAN DEFAULT FALSE) IS
228: BEGIN
229: utl_smtp.write_data(conn, CRLF);
230: IF (last) THEN

Line 229: utl_smtp.write_data(conn, CRLF);

225: ------------------------------------------------------------------------
226: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,
227: last IN BOOLEAN DEFAULT FALSE) IS
228: BEGIN
229: utl_smtp.write_data(conn, CRLF);
230: IF (last) THEN
231: write_boundary(conn, last);
232: END IF;
233: EXCEPTION

Line 239: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection) IS

235: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
236: END;
237:
238: ------------------------------------------------------------------------
239: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection) IS
240: BEGIN
241: end_mail_in_session(conn);
242: end_session(conn);
243: EXCEPTION

Line 249: FUNCTION begin_session RETURN utl_smtp.connection IS

245: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
246: END;
247:
248: ------------------------------------------------------------------------
249: FUNCTION begin_session RETURN utl_smtp.connection IS
250: conn utl_smtp.connection;
251: status UTL_SMTP.REPLY;
252: BEGIN
253: -- open SMTP connection

Line 250: conn utl_smtp.connection;

246: END;
247:
248: ------------------------------------------------------------------------
249: FUNCTION begin_session RETURN utl_smtp.connection IS
250: conn utl_smtp.connection;
251: status UTL_SMTP.REPLY;
252: BEGIN
253: -- open SMTP connection
254: status := utl_smtp.open_connection(smtp_host, smtp_port, conn);

Line 251: status UTL_SMTP.REPLY;

247:
248: ------------------------------------------------------------------------
249: FUNCTION begin_session RETURN utl_smtp.connection IS
250: conn utl_smtp.connection;
251: status UTL_SMTP.REPLY;
252: BEGIN
253: -- open SMTP connection
254: status := utl_smtp.open_connection(smtp_host, smtp_port, conn);
255:

Line 254: status := utl_smtp.open_connection(smtp_host, smtp_port, conn);

250: conn utl_smtp.connection;
251: status UTL_SMTP.REPLY;
252: BEGIN
253: -- open SMTP connection
254: status := utl_smtp.open_connection(smtp_host, smtp_port, conn);
255:
256: -- Status code 220 - Service is ready
257: IF (status.code <> 220) THEN
258: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );

Line 261: status := utl_smtp.helo(conn, smtp_host); -- @@ or EHLO?

257: IF (status.code <> 220) THEN
258: FND_FILE.PUT_LINE(FND_FILE.LOG, status.code || ': ' || status.text );
259: END IF;
260:
261: status := utl_smtp.helo(conn, smtp_host); -- @@ or EHLO?
262:
263: -- Status code 250 - Requested mail action OKAY completed
264: -- Hand shaking working
265: IF (status.code <> 250) THEN

Line 275: PROCEDURE begin_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection,

271: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
272: END;
273:
274: ------------------------------------------------------------------------
275: PROCEDURE begin_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection,
276: sender IN VARCHAR2,
277: recipient_tbl IN recipient_rec_tbl,
278: subject IN VARCHAR2,
279: mime_type IN VARCHAR2 DEFAULT 'text/plain',

Line 286: utl_smtp.mail(conn, get_address(sender));

282: BEGIN
283:
284: -- Specify sender's address (our server allows bogus address
285: -- as long as it is a full email address ([email protected]).
286: utl_smtp.mail(conn, get_address(sender));
287:
288: -- Specify recipient(s) of the email.
289: While l_count <= recipient_tbl.count
290: Loop

Line 291: utl_smtp.rcpt(conn, get_address(recipient_tbl(l_count).to_email_address) );

287:
288: -- Specify recipient(s) of the email.
289: While l_count <= recipient_tbl.count
290: Loop
291: utl_smtp.rcpt(conn, get_address(recipient_tbl(l_count).to_email_address) );
292: l_count := l_count + 1;
293: End Loop;
294:
295: -- Start body of email

Line 296: utl_smtp.open_data(conn);

292: l_count := l_count + 1;
293: End Loop;
294:
295: -- Start body of email
296: utl_smtp.open_data(conn);
297:
298: -- Set "From" MIME header
299: write_mime_header(conn, 'From', sender);
300:

Line 337: utl_smtp.write_data(conn, CRLF);

333: END IF;
334:
335: -- Send an empty line to denotes end of MIME headers and
336: -- beginning of message body.
337: utl_smtp.write_data(conn, CRLF);
338:
339: IF (mime_type LIKE 'multipart/mixed%') THEN
340: write_text(conn, 'This is a multi-part message in MIME format.' ||
341: CRLF);

Line 350: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection) IS

346: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
347: END;
348:
349: ------------------------------------------------------------------------
350: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection) IS
351: BEGIN
352: utl_smtp.close_data(conn);
353: EXCEPTION
354: WHEN OTHERS THEN

Line 352: utl_smtp.close_data(conn);

348:
349: ------------------------------------------------------------------------
350: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection) IS
351: BEGIN
352: utl_smtp.close_data(conn);
353: EXCEPTION
354: WHEN OTHERS THEN
355: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
356: END;

Line 359: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection) IS

355: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
356: END;
357:
358: ------------------------------------------------------------------------
359: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection) IS
360: BEGIN
361: utl_smtp.quit(conn);
362: EXCEPTION
363: WHEN OTHERS THEN

Line 361: utl_smtp.quit(conn);

357:
358: ------------------------------------------------------------------------
359: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection) IS
360: BEGIN
361: utl_smtp.quit(conn);
362: EXCEPTION
363: WHEN OTHERS THEN
364: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
365: END;

Line 376: conn utl_smtp.connection;

372: priority IN PLS_INTEGER DEFAULT NORMAL_PRIORITY,
373: path_name IN VARCHAR2,
374: file_name IN VARCHAR2
375: ) IS
376: conn utl_smtp.connection;
377: l_file_loc BFILE;
378: l_raw RAW(32000);
379: l_num INTEGER;
380: l_amount BINARY_INTEGER := 32000;

Line 442: conn UTL_SMTP.CONNECTION;

438: url IN VARCHAR2,
439: file_name IN VARCHAR2
440: ) IS
441:
442: conn UTL_SMTP.CONNECTION;
443: buf RAW(32767);
444: pieces UTL_HTTP.HTML_PIECES;
445: wallet_pswd VARCHAR2(2000);
446: j pls_integer;

Line 504: utl_smtp.write_data(conn,

500: FOR i IN 1..pieces.count LOOP
501: buf := utl_raw.concat(buf, utl_raw.cast_to_raw(pieces(i)));
502: j := 1;
503: WHILE ((j + 57) < utl_raw.length(buf)) LOOP
504: utl_smtp.write_data(conn,
505: oks_base64.encode(utl_raw.substr(buf, j, 57)) || utl_tcp.crlf);
506: j := j + 57;
507: END LOOP;
508: buf := utl_raw.substr(buf, j);

Line 512: utl_smtp.write_data(conn, oks_base64.encode(buf) || utl_tcp.crlf);

508: buf := utl_raw.substr(buf, j);
509: END LOOP;
510:
511: IF (buf IS NOT NULL) then
512: utl_smtp.write_data(conn, oks_base64.encode(buf) || utl_tcp.crlf);
513: END IF;
514:
515: --------------------------------------------------------
516:

Line 535: conn UTL_SMTP.CONNECTION;

531: document IN VARCHAR2,
532: file_name IN VARCHAR2
533: ) IS
534:
535: conn UTL_SMTP.CONNECTION;
536: l_raw RAW(32767);
537:
538: BEGIN
539:

Line 579: conn UTL_SMTP.CONNECTION;

575: document IN CLOB,
576: file_name IN VARCHAR2
577: ) IS
578:
579: conn UTL_SMTP.CONNECTION;
580: l_raw RAW(3000);
581: l_str VARCHAR2(3000);
582: clob_length INTEGER;
583: offset INTEGER;

Line 649: conn UTL_SMTP.CONNECTION;

645: document IN CLOB,
646: file_name IN VARCHAR2
647: ) IS
648:
649: conn UTL_SMTP.CONNECTION;
650: l_raw RAW(32767);
651: l_str VARCHAR2(4000);
652: clob_length INTEGER;
653: offset INTEGER;

Line 731: conn UTL_SMTP.CONNECTION;

727: document IN OKS_AUTO_REMINDER.message_rec_tbl,
728: file_name IN VARCHAR2
729: ) IS
730:
731: conn UTL_SMTP.CONNECTION;
732:
733: BEGIN
734:
735: conn := begin_mail(sender => sender,

Line 789: conn UTL_SMTP.CONNECTION;

785: mime_type IN VARCHAR2 DEFAULT 'text/plain',
786: priority IN PLS_INTEGER DEFAULT NORMAL_PRIORITY
787: ) IS
788:
789: conn UTL_SMTP.CONNECTION;
790:
791: BEGIN
792:
793: conn := begin_mail(sender => sender,