APPS.HXC_NOTIFICATION_PROCESS_PKG dependencies on WF_ITEMS

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

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

Line 607: from wf_items

603:
604: CURSOR c_is_error_process(p_itemtype in varchar2, p_item_key in varchar2)
605: is
606: select parent_item_key
607: from wf_items
608: where item_type = p_itemtype
609: and item_key = p_item_key
610: and root_activity = 'OTL_ERROR_PROCESS';
611:

Line 646: l_item_key wf_items.item_key%type;

642: l_time_category_id hxc_time_categories.time_category_id%TYPE;
643: l_category_sequence hxc_approval_comps.approval_order%TYPE;
644: l_approval_style_id number;
645: l_tc_url varchar2(1000);
646: l_item_key wf_items.item_key%type;
647: itemkey wf_items.item_key%type;
648: l_user_id number;
649: l_resp_id number;
650: l_resp_appl_id number;

Line 647: itemkey wf_items.item_key%type;

643: l_category_sequence hxc_approval_comps.approval_order%TYPE;
644: l_approval_style_id number;
645: l_tc_url varchar2(1000);
646: l_item_key wf_items.item_key%type;
647: itemkey wf_items.item_key%type;
648: l_user_id number;
649: l_resp_id number;
650: l_resp_appl_id number;
651: l_sec_grp_id number;