APPS.PO_APPROVAL_LIST_HISTORY_SV dependencies on WF_NOTIFICATIONS

Line 173: l_responder wf_notifications.responder%TYPE;

169: x_action_code VARCHAR2(24) := NULL;
170: x_responder_id wf_local_roles.ORIG_SYSTEM_ID%TYPE;
171: x_notification_id NUMBER;
172: e_invalid_action EXCEPTION;
173: l_responder wf_notifications.responder%TYPE;
174: l_employee_id NUMBER;
175: l_original_recipient_id NUMBER;
176: l_original_recipient wf_notifications.original_recipient%TYPE;
177: l_recipient_role wf_notifications.recipient_role%TYPE;

Line 176: l_original_recipient wf_notifications.original_recipient%TYPE;

172: e_invalid_action EXCEPTION;
173: l_responder wf_notifications.responder%TYPE;
174: l_employee_id NUMBER;
175: l_original_recipient_id NUMBER;
176: l_original_recipient wf_notifications.original_recipient%TYPE;
177: l_recipient_role wf_notifications.recipient_role%TYPE;
178:
179: /* begin bug 3090563
180: * notification enhancement to support more info requested

Line 177: l_recipient_role wf_notifications.recipient_role%TYPE;

173: l_responder wf_notifications.responder%TYPE;
174: l_employee_id NUMBER;
175: l_original_recipient_id NUMBER;
176: l_original_recipient wf_notifications.original_recipient%TYPE;
177: l_recipient_role wf_notifications.recipient_role%TYPE;
178:
179: /* begin bug 3090563
180: * notification enhancement to support more info requested
181: */

Line 182: l_more_info_role wf_notifications.more_info_role%TYPE;

178:
179: /* begin bug 3090563
180: * notification enhancement to support more info requested
181: */
182: l_more_info_role wf_notifications.more_info_role%TYPE;
183: l_more_origsys wf_roles.orig_system%TYPE;
184: l_more_origsysid wf_roles.orig_system_id%TYPE := null;
185: /* end bug 3090563 */
186: l_appr_and_fwd_flag boolean := FALSE;-- Flag to check if we have 'APPROVE_AND_FORWARD' action

Line 216: FROM WF_NOTIFICATIONS WF,

212: */
213:
214: SELECT NVL(MAX(wf.notification_id), -9995)
215: INTO x_notification_id
216: FROM WF_NOTIFICATIONS WF,
217: WF_ITEM_ACTIVITY_STATUSES WIAS
218: WHERE WIAS.ITEM_TYPE = itemtype AND
219: WIAS.ITEM_KEY = itemkey AND
220: WIAS.NOTIFICATION_ID = WF.group_id;

Line 233: FROM WF_NOTIFICATIONS WF,

229:
230: IF (x_notification_id = -9995) THEN
231: SELECT NVL(MAX(wf.notification_id), -9995)
232: INTO x_notification_id
233: FROM WF_NOTIFICATIONS WF,
234: WF_ITEM_ACTIVITY_STATUSES_H WIAS
235: WHERE WIAS.ITEM_TYPE = itemtype AND
236: WIAS.ITEM_KEY = itemkey AND
237: WIAS.NOTIFICATION_ID = WF.group_id;

Line 258: FROM wf_notifications wfn

254: SELECT wfn.responder, wfn.recipient_role,
255: wfn.original_recipient, wfn.more_info_role
256: INTO l_responder, l_recipient_role,
257: l_original_recipient, l_more_info_role
258: FROM wf_notifications wfn
259: WHERE wfn.notification_id = x_notification_id;
260:
261: /* csheu bug #1287135 use reponder value in wf_notification to find
262: its orig_system_id from wf_users. If no matched rows found from