eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_SECURITY_CHECK_SV dependencies on WF_NOTIFICATIONS

Line 235: FROM WF_NOTIFICATIONS WF,

231: /* use MAX to get the latest notification sent for the wf item */
232:
233: CURSOR getcurrnotif is
234: SELECT NVL(MAX(wf.notification_id), -9995),wf.from_role --Bug 12534279
235: FROM WF_NOTIFICATIONS WF,
236: WF_ITEM_ACTIVITY_STATUSES WIAS
237: WHERE WIAS.ITEM_TYPE = x_itemtype AND
238: WIAS.ITEM_KEY = x_itemkey AND
239: WIAS.NOTIFICATION_ID = WF.group_id

Line 272: l_notification_key wf_notifications.ACCESS_KEY%TYPE;

268: SELECT FND_GLOBAL.USER_NAME AS granter_key
269: FROM dual;
270:
271: -- Bug 4633202: Temp variables
272: l_notification_key wf_notifications.ACCESS_KEY%TYPE;
273: l_granter_key FND_GRANTS.PARAMETER1%TYPE;
274: l_has_access BOOLEAN;
275:
276:

Line 277: l_notification_id WF_NOTIFICATIONS.notification_id%type;

273: l_granter_key FND_GRANTS.PARAMETER1%TYPE;
274: l_has_access BOOLEAN;
275:
276:
277: l_notification_id WF_NOTIFICATIONS.notification_id%type;
278: l_responder WF_NOTIFICATIONS.responder%type;
279: l_original_recipient_id wf_users.orig_system_id%type;
280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;

Line 278: l_responder WF_NOTIFICATIONS.responder%type;

274: l_has_access BOOLEAN;
275:
276:
277: l_notification_id WF_NOTIFICATIONS.notification_id%type;
278: l_responder WF_NOTIFICATIONS.responder%type;
279: l_original_recipient_id wf_users.orig_system_id%type;
280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;

Line 281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;

277: l_notification_id WF_NOTIFICATIONS.notification_id%type;
278: l_responder WF_NOTIFICATIONS.responder%type;
279: l_original_recipient_id wf_users.orig_system_id%type;
280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
283:
284: l_from_role WF_NOTIFICATIONS.from_role%TYPE; --Bug 12534279
285:

Line 282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;

278: l_responder WF_NOTIFICATIONS.responder%type;
279: l_original_recipient_id wf_users.orig_system_id%type;
280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
283:
284: l_from_role WF_NOTIFICATIONS.from_role%TYPE; --Bug 12534279
285:
286: Begin

Line 284: l_from_role WF_NOTIFICATIONS.from_role%TYPE; --Bug 12534279

280: l_recipient_id wf_users.orig_system_id%type;
281: l_recipient_role WF_NOTIFICATIONS.recipient_role%type;
282: l_original_recipient WF_NOTIFICATIONS.ORIGINAL_RECIPIENT%type;
283:
284: l_from_role WF_NOTIFICATIONS.from_role%TYPE; --Bug 12534279
285:
286: Begin
287: Open getcurrnotif;
288: fetch getcurrnotif into l_notification_id, l_from_role; --Bug 12534279

Line 328: FROM wf_notifications wfn

324: This check is not required. WF API itself
325: will take care of all these checks.
326: SELECT wfn.recipient_role, wfn.original_recipient
327: INTO l_recipient_role, l_original_recipient
328: FROM wf_notifications wfn
329: WHERE wfn.notification_id = l_notification_id;
330:
331: OPEN c_responderid(l_recipient_role);
332: FETCH c_responderid INTO l_recipient_id;