APPS.PO_PROTESTS_UTIL dependencies on WF_NOTIFICATION

Line 283: l_notification_id := wf_notification.Send(ROLE => to_emp_user,

279: -- DBMS_OUTPUT.PUT_LINE(to_emp_user);
280: -- DBMS_OUTPUT.PUT_LINE('1');
281: IF ( file_id = 0
282: OR file_id =- 999 ) THEN
283: l_notification_id := wf_notification.Send(ROLE => to_emp_user,
284: msg_type => 'POPRNT',
285: msg_name => 'PROTEST_NOTIF_WITHOUT_ATT'
286: );
287:

Line 288: wf_notification.Setattrtext(nid => l_notification_id,

284: msg_type => 'POPRNT',
285: msg_name => 'PROTEST_NOTIF_WITHOUT_ATT'
286: );
287:
288: wf_notification.Setattrtext(nid => l_notification_id,
289: aname => '#FROM_ROLE',
290: avalue => from_user);
291:
292: wf_notification.Setattrtext(nid => l_notification_id,

Line 292: wf_notification.Setattrtext(nid => l_notification_id,

288: wf_notification.Setattrtext(nid => l_notification_id,
289: aname => '#FROM_ROLE',
290: avalue => from_user);
291:
292: wf_notification.Setattrtext(nid => l_notification_id,
293: aname =>'NOTIFICATION_SUBJECT',
294: avalue => notification_subject);
295: wf_notification.Setattrtext(nid => l_notification_id,
296: aname => 'NOTIFICATION_REGION',

Line 295: wf_notification.Setattrtext(nid => l_notification_id,

291:
292: wf_notification.Setattrtext(nid => l_notification_id,
293: aname =>'NOTIFICATION_SUBJECT',
294: avalue => notification_subject);
295: wf_notification.Setattrtext(nid => l_notification_id,
296: aname => 'NOTIFICATION_REGION',
297: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PROTEST_NOTIFICATION_REGION&protestId='|| protestid || '&mode=V&protestNotes='|| protestnotes);
298: ELSE
299: l_notification_id := wf_notification.Send(ROLE => to_emp_user,

Line 299: l_notification_id := wf_notification.Send(ROLE => to_emp_user,

295: wf_notification.Setattrtext(nid => l_notification_id,
296: aname => 'NOTIFICATION_REGION',
297: avalue =>'JSP:/OA_HTML/OA.jsp?OAFunc=PROTEST_NOTIFICATION_REGION&protestId='|| protestid || '&mode=V&protestNotes='|| protestnotes);
298: ELSE
299: l_notification_id := wf_notification.Send(ROLE => to_emp_user,
300: msg_type => 'POPRNT',
301: msg_name => 'PROTEST_NOTIF'
302: );
303:

Line 304: wf_notification.Setattrtext(nid => l_notification_id,

300: msg_type => 'POPRNT',
301: msg_name => 'PROTEST_NOTIF'
302: );
303:
304: wf_notification.Setattrtext(nid => l_notification_id,
305: aname => '#FROM_ROLE',
306: avalue => from_user);
307:
308: wf_notification.Setattrtext(nid => l_notification_id,

Line 308: wf_notification.Setattrtext(nid => l_notification_id,

304: wf_notification.Setattrtext(nid => l_notification_id,
305: aname => '#FROM_ROLE',
306: avalue => from_user);
307:
308: wf_notification.Setattrtext(nid => l_notification_id,
309: aname =>'NOTIFICATION_SUBJECT',
310: avalue => notification_subject);
311:
312: wf_notification.Setattrtext(nid => l_notification_id,

Line 312: wf_notification.Setattrtext(nid => l_notification_id,

308: wf_notification.Setattrtext(nid => l_notification_id,
309: aname =>'NOTIFICATION_SUBJECT',
310: avalue => notification_subject);
311:
312: wf_notification.Setattrtext(nid => l_notification_id,
313: aname => 'NOTIFICATION_REGION',
314: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PROTEST_NOTIFICATION_REGION&protestId='|| protestid || '&mode=V&protestNotes='|| protestnotes);
315: wf_notification.Setattrtext(nid => l_notification_id,
316: aname => 'ZIP_ATTACHMENT',

Line 315: wf_notification.Setattrtext(nid => l_notification_id,

311:
312: wf_notification.Setattrtext(nid => l_notification_id,
313: aname => 'NOTIFICATION_REGION',
314: avalue => 'JSP:/OA_HTML/OA.jsp?OAFunc=PROTEST_NOTIFICATION_REGION&protestId='|| protestid || '&mode=V&protestNotes='|| protestnotes);
315: wf_notification.Setattrtext(nid => l_notification_id,
316: aname => 'ZIP_ATTACHMENT',
317: avalue =>'PLSQLBLOB:PO_PROTESTS_UTIL.ZIP_ATTACH/'||file_id);
318: END IF;
319: