DBA Data[Home] [Help]

APPS.ALR_MLR_PACKAGE dependencies on WF_MAIL

Line 8: -- Calls the wf_mail.send routine to send emails to the recipients in the

4: --
5: -- Generic mailer routines
6: --
7: -- Send
8: -- Calls the wf_mail.send routine to send emails to the recipients in the
9: -- receipient list.
10:
11: procedure Send(a_idstring in varchar2,
12: a_module in varchar2,

Line 26: WF_MAIL.SEND(p_idstring => a_idstring,

22: len := length(a_message);
23: dbms_lob.writeappend(clobvar, len, a_message);
24: dbms_lob.close(clobvar);
25:
26: WF_MAIL.SEND(p_idstring => a_idstring,
27: p_module => a_module,
28: p_recipient_list => ALR_EMAIL_TABLE,
29: p_replyto => a_replyto,
30: p_subject => a_subject,

Line 63: WF_MAIL.SEND(p_idstring => a_idstring,

59: LEN := LENGTH(a_chunk2);
60: DBMS_LOB.WRITE(a_message, LEN, OFFSET, a_chunk2);
61: OFFSET := OFFSET + LEN;
62: end if;
63: WF_MAIL.SEND(p_idstring => a_idstring,
64: p_module => a_module,
65: p_recipient_list => ALR_EMAIL_TABLE,
66: p_replyto => a_replyto,
67: p_subject => a_subject,