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 16: -- MAILER_ID CONSTANT VARCHAR2(256) := 'Mailer by Oracle 9i UTL_SMTP';

12: -- smtp_domain VARCHAR2(256) := 'oracle.com';
13:
14: -- Customize signature that will appear in the email's MIME header.
15: -- Useful for versioning.
16: -- MAILER_ID CONSTANT VARCHAR2(256) := 'Mailer by Oracle 9i UTL_SMTP';
17: MAILER_ID CONSTANT VARCHAR2(256) := 'Oracle Contracts for Service';
18:
19: -- A unique string that demarcates boundaries of parts in a multi-part
20: -- email. The string should not appear inside the body of any part of the

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

44:
45: FUNCTION get_address(mailbox IN VARCHAR2) RETURN VARCHAR2;
46:
47: -- Mark a message-part boundary. Set to TRUE for the last boundary.
48: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,
49: last IN BOOLEAN DEFAULT FALSE);
50:
51: -- Write a MIME header
52: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,

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

48: PROCEDURE write_boundary(conn IN OUT NOCOPY utl_smtp.connection,
49: last IN BOOLEAN DEFAULT FALSE);
50:
51: -- Write a MIME header
52: PROCEDURE write_mime_header(conn IN OUT NOCOPY utl_smtp.connection,
53: name IN VARCHAR2,
54: value IN VARCHAR2);
55:
56: -- A simple email API for sending email in plain text in a single call.

Line 72: RETURN utl_smtp.connection;

68: recipient_tbl IN recipient_rec_tbl,
69: subject IN VARCHAR2,
70: mime_type IN VARCHAR2 DEFAULT 'text/plain',
71: priority IN PLS_INTEGER DEFAULT NULL)
72: RETURN utl_smtp.connection;
73:
74: -- Write email body in ASCII
75: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,
76: message IN VARCHAR2);

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

71: priority IN PLS_INTEGER DEFAULT NULL)
72: RETURN utl_smtp.connection;
73:
74: -- Write email body in ASCII
75: PROCEDURE write_text(conn IN OUT NOCOPY utl_smtp.connection,
76: message IN VARCHAR2);
77:
78: -- Write email body in non-ASCII (including multi-byte). The email body
79: -- will be sent in the database character set.

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

76: message IN VARCHAR2);
77:
78: -- Write email body in non-ASCII (including multi-byte). The email body
79: -- will be sent in the database character set.
80: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,
81: message IN VARCHAR2);
82:
83: -- Write email body in binary
84: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,

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

80: PROCEDURE write_mb_text(conn IN OUT NOCOPY utl_smtp.connection,
81: message IN VARCHAR2);
82:
83: -- Write email body in binary
84: PROCEDURE write_raw(conn IN OUT NOCOPY utl_smtp.connection,
85: message IN RAW);
86:
87: -- APIs to send email with attachments. Attachments are sent by sending
88: -- emails in "multipart/mixed" MIME format. Specify that MIME format when

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

88: -- emails in "multipart/mixed" MIME format. Specify that MIME format when
89: -- beginning an email with begin_mail().
90:
91: -- Send a single text attachment.
92: PROCEDURE attach_text(conn IN OUT NOCOPY utl_smtp.connection,
93: data IN VARCHAR2,
94: mime_type IN VARCHAR2 DEFAULT 'text/plain',
95: inline IN BOOLEAN DEFAULT TRUE,
96: filename IN VARCHAR2 DEFAULT NULL,

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

97: last IN BOOLEAN DEFAULT FALSE);
98:
99: -- Send a binary attachment. The attachment will be encoded in Base-64
100: -- encoding format.
101: PROCEDURE attach_base64(conn IN OUT NOCOPY utl_smtp.connection,
102: data IN RAW,
103: mime_type IN VARCHAR2 DEFAULT 'application/pdf',
104: inline IN BOOLEAN DEFAULT TRUE,
105: filename IN VARCHAR2 DEFAULT NULL,

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

111: -- in non-ASCII or multi-byte character set, use write_mb_text() instead.
112: -- To send binary attachment, the binary content should first be
113: -- encoded in Base-64 encoding format using the demo package for 8i,
114: -- or the native one in 9i. End the attachment with end_attachment.
115: PROCEDURE begin_attachment(conn IN OUT NOCOPY utl_smtp.connection,
116: mime_type IN VARCHAR2 DEFAULT 'text/plain',
117: inline IN BOOLEAN DEFAULT TRUE,
118: filename IN VARCHAR2 DEFAULT NULL,
119: transfer_enc IN VARCHAR2 DEFAULT NULL);

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

118: filename IN VARCHAR2 DEFAULT NULL,
119: transfer_enc IN VARCHAR2 DEFAULT NULL);
120:
121: -- End the attachment.
122: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,
123: last IN BOOLEAN DEFAULT FALSE);
124:
125: -- End the email.
126: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection);

Line 126: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection);

122: PROCEDURE end_attachment(conn IN OUT NOCOPY utl_smtp.connection,
123: last IN BOOLEAN DEFAULT FALSE);
124:
125: -- End the email.
126: PROCEDURE end_mail(conn IN OUT NOCOPY utl_smtp.connection);
127:
128: -- Extended email API to send multiple emails in a session for better
129: -- performance. First, begin an email session with begin_session.
130: -- Then, begin each email with a session by calling begin_mail_in_session

Line 133: FUNCTION begin_session RETURN utl_smtp.connection;

129: -- performance. First, begin an email session with begin_session.
130: -- Then, begin each email with a session by calling begin_mail_in_session
131: -- instead of begin_mail. End the email with end_mail_in_session instead
132: -- of end_mail. End the email session by end_session.
133: FUNCTION begin_session RETURN utl_smtp.connection;
134:
135: -- Begin an email in a session.
136: PROCEDURE begin_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection,
137: sender IN VARCHAR2,

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

132: -- of end_mail. End the email session by end_session.
133: FUNCTION begin_session RETURN utl_smtp.connection;
134:
135: -- Begin an email in a session.
136: PROCEDURE begin_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection,
137: sender IN VARCHAR2,
138: recipient_tbl IN recipient_rec_tbl,
139: subject IN VARCHAR2,
140: mime_type IN VARCHAR2 DEFAULT 'text/plain',

Line 144: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection);

140: mime_type IN VARCHAR2 DEFAULT 'text/plain',
141: priority IN PLS_INTEGER DEFAULT NULL);
142:
143: -- End an email in a session.
144: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection);
145:
146: -- End an email session.
147: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection);
148:

Line 147: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection);

143: -- End an email in a session.
144: PROCEDURE end_mail_in_session(conn IN OUT NOCOPY utl_smtp.connection);
145:
146: -- End an email session.
147: PROCEDURE end_session(conn IN OUT NOCOPY utl_smtp.connection);
148:
149: -- This is the main program. It will call the other procedures to send the
150: -- attachment over.
151: PROCEDURE send_binary_attachment(sender IN VARCHAR2,