171: --the loop variable in a safe fashion, ensuring that if by accident an existing workflow comes into this
172: --procedure it won't fail
173: PROCEDURE loop_initialization
174: (p_item_type in wf_items.item_type%type,
175: p_item_key in wf_item_activity_statuses.item_key%type,
176: p_resend_number in number) is
177:
178: BEGIN
179:
986:
987: cursor c_get_notification(p_itemtype varchar2,p_itemkey varchar2)
988: is
989: select wn.original_recipient
990: from wf_item_activity_statuses wias,
991: wf_process_activities wpa,
992: wf_notifications wn
993: where wias.item_type = p_itemtype
994: and wias.item_key = p_itemkey