DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 175: p_item_key in wf_item_activity_statuses.item_key%type,

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:

Line 990: from wf_item_activity_statuses wias,

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