APPS.WF_MAIL dependencies on WF_NOTIFICATION

Line 9: * @rep:category BUSINESS_ENTITY WF_NOTIFICATION

5: * @rep:scope public
6: * @rep:product OWF
7: * @rep:displayname Workflow Message Subsystem
8: * @rep:lifecycle active
9: * @rep:category BUSINESS_ENTITY WF_NOTIFICATION
10: * @rep:compatibility S
11: */
12: --
13: -- Global table to store the url content.

Line 143: -- This function is triggered by the oracle.apps.wf.notification.send.failure

139:
140: -- UpdateRecipient
141: -- Updates the recipient of a notification to DISABLED where
142: -- there has been a failure to deliver to their email address.
143: -- This function is triggered by the oracle.apps.wf.notification.send.failure
144: -- event.
145: function Disable_Recipient_Ntf_Pref(p_subscription_guid in raw,
146: p_event in out NOCOPY WF_EVENT_T) return varchar2;
147:

Line 309: -- columns of wf_notifications table

305: procedure setContext(nid NUMBER);
306:
307: -- GetLOBMessage4 - get email message data
308: -- Bug 10202313: Added n_status, n_mstatus parameters to store the status, mail_status
309: -- columns of wf_notifications table
310: --
311: -- IN
312: -- notification id
313: -- mailer node name

Line 441: procedure InitFetchLOB(doc_type VARCHAR2 default WF_NOTIFICATION.doc_text,

437: --
438: -- IN
439: -- type - Document type (TEXT or HTML)
440: --
441: procedure InitFetchLOB(doc_type VARCHAR2 default WF_NOTIFICATION.doc_text,
442: doc_length OUT NOCOPY NUMBER);
443:
444:
445: -- FetchLOBContent

Line 454: -- WF_MAIL.InitFetchLob(WF_NOTIFICATION.doc_text)

450: -- OUT
451: -- 32K chunk of the LOB
452: --
453: -- Use the API in the following manner
454: -- WF_MAIL.InitFetchLob(WF_NOTIFICATION.doc_text)
455: -- while not clob_end loop
456: -- WF_MAIL.FetchLobContent(cBuf, WF_NOTIFICATION.doc_text, clob_end);
457: -- ...
458: -- end loop;

Line 456: -- WF_MAIL.FetchLobContent(cBuf, WF_NOTIFICATION.doc_text, clob_end);

452: --
453: -- Use the API in the following manner
454: -- WF_MAIL.InitFetchLob(WF_NOTIFICATION.doc_text)
455: -- while not clob_end loop
456: -- WF_MAIL.FetchLobContent(cBuf, WF_NOTIFICATION.doc_text, clob_end);
457: -- ...
458: -- end loop;
459: --
460: procedure FetchLOBContent(buffer OUT NOCOPY VARCHAR2,

Line 461: doc_type IN VARCHAR2 DEFAULT WF_NOTIFICATION.doc_text,

457: -- ...
458: -- end loop;
459: --
460: procedure FetchLOBContent(buffer OUT NOCOPY VARCHAR2,
461: doc_type IN VARCHAR2 DEFAULT WF_NOTIFICATION.doc_text,
462: end_of_clob IN OUT NOCOPY NUMBER);
463: -- CloseLOB - Close the message LOBs ready for use again later
464: --
465: -- IN

Line 616: -- update wf_notification and wf_comments apropriately

612:
613: -- PutMoreInfoMessage
614: -- Reply processor. Read body of a reply for more information
615: -- request, parse the body for the comments from the user and
616: -- update wf_notification and wf_comments apropriately
617: -- Used by the notification mail response processor.
618: -- IN
619: -- notification id
620: -- mailer node name

Line 849: -- This API unlike wf_notification.send does not require workflow

845: -- Generic mailer routines
846: --
847: -- Send
848: -- Sends a e-mail notification to the specified list of recipients.
849: -- This API unlike wf_notification.send does not require workflow
850: -- message or workflow roles to send a notification.
851: /*#
852: * Sends a message to be dispatched through e-mail by the Oracle Workflow
853: * Notification Mailer. The message content and recipients provided in the

Line 880: * @rep:businessevent oracle.apps.wf.notification.send

876: * @param p_event_key The key that identifies the message when the message is enqueued for dispatch
877: * @param p_fyi_flag A flag to indicate whether the message is for your information (FYI) or requires a response
878: *
879: * @rep:displayname Send Message
880: * @rep:businessevent oracle.apps.wf.notification.send
881: * @rep:scope public
882: * @rep:lifecycle active
883: * @rep:compatibility S
884: *

Line 915: -- oracle.apps.wf.notification.send.group. This subscription is responsible

911: p_from_email IN VARCHAR2 default null);
912:
913: -- SetNtfEventsSubStatus
914: -- This procedure sets the status of seeded subscription to the event group
915: -- oracle.apps.wf.notification.send.group. This subscription is responsible
916: -- for notification XML message generation and presenting it to the mailer for
917: -- e-mail dispatch. Disabling this subscription causes e-mails not to be sent.
918: --
919: -- ENABLED - E-mails are sent