Human Capital Management - EBS (MOSC)

MOSC Banner

Approval of pending leave applications from backend

edited Jan 20, 2017 5:28PM in Human Capital Management - EBS (MOSC) Question

Hi, Can any one help me in approval of pending leave applications of 2016 with supervisors??

For this question from one member in the community gave me below script to be run for approving the notifications using notification id..

(BEGIN wf_notification.setattrtext (nid => '4754620',                                  aname       => 'RESULT',                                  avalue      => 'REJECTED'                                 );     wf_notification.respond (nid         => '4754620',                                       respond_comment =>  'Reject From backend', responder =>  'XXTEST');     COMMIT; END)

for getting those notification id we have used this script –

(select * from wf_notifications where recipient_role in ('username',) and MESSAGE_TYPE='HRSSA' and status='OPEN' and to_char(begin_date,'YYYY')='YYYY')

but can any one tell us how can we know that these notifications are pertaining to leave approval. Appreciate your quick reply

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center