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
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: