4. Mode of Functions.

Post notification:

After notification is delivered, the funciton/proc will exceute.

same 5 parameters as function should be used.
result should be ignored.

MOdes of functions:

1. Validate. : Fires at when the user tries to respond it validates.
2. Respond.  : it wil read response from user.
3. Forwrard. : forwarding notification to other user (keep ownership with the sam user)
4. Transfer. : Transfer notification ownership to other user.
5. Question  : <request information> requesting more information regarding the same , user/response.
6. Answer    : Replying to the request.
7. Run       : After Validation>Respond> Run will be fired.
8. Timeout   : when the notification gets timeout after period of time.


Use any Workflow
Attach the procedure created in the notification function field.

--for timeout go to Notification properties> Node> Type = Relative Time, Value = 2 min
 Notification tab> Result Type = 'Approval'
  In the same window beside Message click 'Edit'
  Go to Result tab>
    Display name : Approval
    Description  : Approval
    Lookup Type  : Approval




CREATE TABLE XX_POST_NOTI
(SEQUENCE_NUM NUMBER,
ITEM_TYPE VARCHAR2(240),
ITEM_KEY VARCHAR2(240),
ACTIVITY_ID NUMBER,
FUNC_MODE VARCHAR2(240),
ACTION_DATE DATE)


CREATE OR REPLACE PROCEDURE XX_POST_NOTI_PROC
( ITEM_TYPE IN VARCHAR2,
  ITEM_KEY IN VARCHAR2,
  ACT_ID IN NUMBER, --ACTIVITY ID 
  FUNC_MODE IN VARCHAR2,
  RESULT_OUT OUT VARCHAR2)
AS
BEGIN
INSERT INTO XX_POST_NOTI
VALUES(XX_POST_NOTI_S.NEXTVAL,ITEM_TYPE, ITEM_KEY,ACT_ID,FUNC_MODE,SYSDATE);
COMMIT;
END;

--drop procedure procedure

BEGIN                       
WF_ENGINE.LaunchProcess(itemtype =>'XXWF_FUN',
                        itemkey  =>'11',
                        process => 'XXWF_FUNC_PROC' ,
                        userkey => 'A1',
                        owner   => 'EG_AFZAL');
END;      

select * from wf_notifications
where message_type = 'XXWF_FUN'
AND ITEM_KEY = 11