1014: update wf_notifications
1015: set end_date = sysdate
1016: where group_id in
1017: (select notification_id
1018: from wf_item_activity_statuses
1019: where item_type = 'MRPEXWFS'
1020: and item_key = l_item_key
1021: union
1022: select notification_id
1019: where item_type = 'MRPEXWFS'
1020: and item_key = l_item_key
1021: union
1022: select notification_id
1023: from wf_item_activity_statuses_h
1024: where item_type = 'MRPEXWFS'
1025: and item_key = l_item_key);
1026:
1027: update wf_items
1028: set end_date = sysdate
1029: where item_type = 'MRPEXWFS'
1030: and item_key = l_item_key;
1031:
1032: update wf_item_activity_statuses
1033: set end_date = sysdate
1034: where item_type = 'MRPEXWFS'
1035: and item_key = l_item_key;
1036:
1033: set end_date = sysdate
1034: where item_type = 'MRPEXWFS'
1035: and item_key = l_item_key;
1036:
1037: update wf_item_activity_statuses_h
1038: set end_date = sysdate
1039: where item_type = 'MRPEXWFS'
1040: and item_key = l_item_key;
1041: