DBA Data[Home] [Help]

APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 124: p_item_key in wf_item_activity_statuses.item_key%type,

120: --the loop variable in a safe fashion, ensuring that if by accident an existing workflow comes into this
121: --procedure it won't fail
122: PROCEDURE loop_initialization
123: (p_item_type in wf_items.item_type%type,
124: p_item_key in wf_item_activity_statuses.item_key%type,
125: p_resend_number in number) is
126:
127: BEGIN
128:

Line 939: from wf_item_activity_statuses wias,

935:
936: cursor c_get_notification(p_itemtype varchar2,p_itemkey varchar2)
937: is
938: select wn.original_recipient
939: from wf_item_activity_statuses wias,
940: wf_process_activities wpa,
941: wf_notifications wn
942: where wias.item_type = p_itemtype
943: and wias.item_key = p_itemkey