DBA Data[Home] [Help]

APPS.MRP_EXP_WF dependencies on WF_NOTIFICATIONS

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