APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on WF_ITEMS

Line 174: (p_item_type in wf_items.item_type%type,

170: --This procedure initializes the loop item attribute value for use with the resending of notifications. It sets
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

Line 658: from wf_items

654:
655: CURSOR c_is_error_process(p_itemtype in varchar2, p_item_key in varchar2)
656: is
657: select parent_item_key
658: from wf_items
659: where item_type = p_itemtype
660: and item_key = p_item_key
661: and root_activity = 'OTL_ERROR_PROCESS';
662:

Line 697: l_item_key wf_items.item_key%type;

693: l_time_category_id hxc_time_categories.time_category_id%TYPE;
694: l_category_sequence hxc_approval_comps.approval_order%TYPE;
695: l_approval_style_id number;
696: l_tc_url varchar2(1000);
697: l_item_key wf_items.item_key%type;
698: itemkey wf_items.item_key%type;
699: l_user_id number;
700: l_resp_id number;
701: l_resp_appl_id number;

Line 698: itemkey wf_items.item_key%type;

694: l_category_sequence hxc_approval_comps.approval_order%TYPE;
695: l_approval_style_id number;
696: l_tc_url varchar2(1000);
697: l_item_key wf_items.item_key%type;
698: itemkey wf_items.item_key%type;
699: l_user_id number;
700: l_resp_id number;
701: l_resp_appl_id number;
702: l_sec_grp_id number;