Sending Notification With Attachment.

Topic        Sending Notification to Application User With Attachment

Steps

Create Workflow Message Type in your workflow (No need to create Custom Workflow, only create message type)

1.

2. Create Message Type

And in that message type Create Attributes whatever you required.

Here, I create all these attributes and I created Document1 to 6 means I can send multiple attachment of the person upto 6. Document attribute you have to create like this.

Save your workflow.

Calling Procedure:

Below Statement calling one Custom Procedure which will send Notification With Attachment to a Particular Application User Name. (YOU HAVE TO USE THIS TO CALL CUSTOM PACKAGE THAT I ATTACHED IN THIS DOCUMENT)

         APPS.KFSH_SEND_ATTACHMENT.KFSH_SEND_NOTI_WITH_ATT (

               'APPOINT_REGISTRATION',

               L_SUBJECT,

               L_MESSAGE,

               'SYSADMIN',

               P_CONTACT_PERSON_ID);

Parameter Explanation

APPOINT_REGISTRATION 

is the Application User Name to whom I want to Send Notification.

L_SUBJECT          

is the Subject Variable which will stores Subject Which you want to put in Notification.

L_MESSAGE      

is the Message Variable which Stores Message that you want to send in Notification.

SYSADMIN       

is the FROM_ROLE From which you want to Send Notification.

P_CONTACT_PERSON_ID 

Here I take PERSON_ID of the DEPEDENT FOR WHICH I WILL SEND NOTIFICATION WITH ALL ATTACHMENT OF THAT DEPEDENT.

Here I am attaching the required Package that is used to send notification with attachment to application username.