Lab_4_Notification to apps user based on the Payroll run

Giving the notification to user EG_AFZAL as conc request is completed using workflow process:

1. Make the workflow.
2. Register the Subscription under the event 'oracle.apps.fnd.concurrent.request.completed'
3. Run the concurrent Request named so to make our subscription active.

Enable the Business Alert in the Concurrent Progam

1. Making the workflow using the workflow builder: (see the .wtf file)

 

Event properties:

Procedure used in the function activity :

CREATE OR REPLACE PROCEDURE APPS.XXWF_PAYROLL_RUN_NOT

( ITEM_TYPE IN VARCHAR2,

  ITEM_KEY IN VARCHAR2,

  ACT_ID IN NUMBER,

  FUNC_MODE IN VARCHAR2,

  RESULT_OUT OUT VARCHAR2)

  AS

  V_REQUEST_ID NUMBER;

  V_USER_NAME VARCHAR2(240);

  V_PAYROLL_NAME VARCHAR2(40);

  V_CREATION_DATE DATE;

   BEGIN

  IF FUNC_MODE = 'RUN' THEN

  --    V_REQUEST_ID := getvalueforparameter('REQUEST_ID') ;

  SELECT REQUEST_ID INTO V_REQUEST_ID

FROM PAY_PAYROLL_ACTIONS

WHERE CREATION_DATE IN (SELECT MAX(CREATION_DATE) FROM PAY_PAYROLL_ACTIONS);

 

select pap.payroll_name, fu.user_name, paa.creation_date

INTO V_PAYROLL_NAME, V_USER_NAME,V_CREATION_DATE

  from

pay_payroll_actions paa,

pay_all_payrolls_f pap,

fnd_user fu

WHERE PAA.REQUEST_ID =V_REQUEST_ID-- 44345723

and paa.payroll_id = pap.payroll_id

and fu.user_id = paa.created_by;

  --ASSIGNING VALUES TO THE ATTRIBUTES IN THE WORKLOW

  WF_ENGINE.SETITEMATTRTEXT(ITEM_TYPE,ITEM_KEY,'PAYROLL_NAME',  V_PAYROLL_NAME);

  WF_ENGINE.SETITEMATTRTEXT(ITEM_TYPE,ITEM_KEY,'USER_NAME', V_USER_NAME);

  WF_ENGINE.SETITEMATTRDATE(ITEM_TYPE,ITEM_KEY,'CREATION_DATE',V_CREATION_DATE);

  END IF;

    RESULT_OUT := 'COMPLETE';

  END;

/

2.

3.

U can run from HRMS Resp if not exists then add in the request group



 

4.

Testing:

Go to  HRMS Manager Resp> people>Assignment>Others>Quick Pay.

 

Quick pay is run for employee 9213 for month November.

Lets chk the notification.

Workflow administrator Resp> Notification