3273: PROCEDURE Delete_Item(l_type in varchar2, l_key in varchar2)
3274: IS
3275: CURSOR c1 IS
3276: select nt.notification_id,nt.status
3277: from wf_item_activity_statuses st,
3278: wf_notifications nt
3279: where st.item_type = l_type
3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3282: union
3283: select nt.notification_id,nt.status
3284: from wf_item_activity_statuses_h st1,wf_notifications nt
3285: where st1.item_type = l_type
3286: and st1.item_key like l_key
3287: and
3288: nt.notification_id = st1.notification_id;
3303: end_date = sysdate
3304: where item_type = l_type
3305: and item_key like l_key;
3306:
3307: update wf_item_activity_statuses set
3308: end_date = sysdate
3309: where item_type = l_type
3310: and item_key like l_key;
3311:
3308: end_date = sysdate
3309: where item_type = l_type
3310: and item_key like l_key;
3311:
3312: update wf_item_activity_statuses_h set
3313: end_date = sysdate
3314: where item_type = l_type
3315: and item_key like l_key;
3316: