DBA Data[Home] [Help]

APPS.MRP_EXP_WF dependencies on WF_NOTIFICATION

Line 1926: UPDATE wf_notifications

1922: l_item_key in varchar2)
1923: IS
1924: BEGIN
1925:
1926: UPDATE wf_notifications
1927: SET end_date = SYSDATE - 450
1928: WHERE group_id IN
1929: (SELECT notification_id
1930: FROM wf_item_activity_statuses

Line 1987: FROM wf_notifications wn,

1983:
1984: CURSOR CANCEL_NOTIFICATIONS_C( p_item_type in varchar2,
1985: p_item_key in varchar2) IS
1986: SELECT wn.notification_id
1987: FROM wf_notifications wn,
1988: wf_item_activity_statuses wias
1989: WHERE wn.status = 'OPEN'
1990: AND wn.notification_id = wias.notification_id
1991: AND wias.item_key = p_item_key

Line 2040: wf_notification.Cancel(l_notification_id);

2036: OPEN CANCEL_NOTIFICATIONS_C('MRPEXPWF', l_item_key);
2037: LOOP
2038: FETCH CANCEL_NOTIFICATIONS_C INTO l_notification_id;
2039: EXIT WHEN CANCEL_NOTIFICATIONS_C%NOTFOUND OR CANCEL_NOTIFICATIONS_C%NOTFOUND IS NULL;
2040: wf_notification.Cancel(l_notification_id);
2041: END LOOP;
2042: CLOSE CANCEL_NOTIFICATIONS_C;
2043:
2044: -- Cancel all notifications within process and process itself