1: PACKAGE BODY OKS_MAIL AS
2: /* $Header: OKSMAILB.pls 120.0 2005/05/25 17:37:39 appldev noship $ */
3:
4: -- Return the email address in the mailbox. The format of mailbox
5: -- may be in one of these formats:
382: BEGIN
383: conn := begin_mail(sender => sender,
384: recipient_tbl => recipient_tbl,
385: subject => subject,
386: mime_type => oks_mail.MULTIPART_MIME_TYPE,
387: priority => priority);
388:
389: attach_text(conn, mail_text, 'text/html');
390:
452:
453: conn := begin_mail(sender => sender,
454: recipient_tbl => recipient_tbl,
455: subject => subject,
456: mime_type => oks_mail.MULTIPART_MIME_TYPE,
457: priority => priority);
458:
459: attach_text(conn, mail_text);
460:
539:
540: conn := begin_mail(sender => sender,
541: recipient_tbl => recipient_tbl,
542: subject => subject,
543: mime_type => oks_mail.MULTIPART_MIME_TYPE,
544: priority => priority);
545:
546: attach_text(
547: conn => conn,
587:
588: conn := begin_mail(sender => sender,
589: recipient_tbl => recipient_tbl,
590: subject => subject,
591: mime_type => oks_mail.MULTIPART_MIME_TYPE,
592: priority => priority);
593:
594: attach_text(
595: conn => conn,
657:
658: conn := begin_mail(sender => sender,
659: recipient_tbl => recipient_tbl,
660: subject => subject,
661: mime_type => oks_mail.MULTIPART_MIME_TYPE,
662: priority => priority);
663:
664: begin_attachment(conn => conn,
665: mime_type => mime_type);
734:
735: conn := begin_mail(sender => sender,
736: recipient_tbl => recipient_tbl,
737: subject => subject,
738: mime_type => oks_mail.MULTIPART_MIME_TYPE,
739: priority => priority);
740:
741: begin_attachment(
742: conn => conn,
792:
793: conn := begin_mail(sender => sender,
794: recipient_tbl => recipient_tbl,
795: subject => subject,
796: mime_type => oks_mail.MULTIPART_MIME_TYPE,
797: priority => priority);
798:
799: attach_text(
800: conn => conn,
808: WHEN OTHERS THEN
809: FND_FILE.PUT_LINE(FND_FILE.LOG, SQLERRM );
810: END;
811:
812: END OKS_MAIL;