APPS.HXC_WF_ERROR_HELPER dependencies on WF_ITEMS

Line 35: l_itemkey wf_items.item_key%type;

31: l_error_body varchar2(32000);
32: l_tc_start_date date;
33: l_tc_stop_date date;
34: l_resource_id number;
35: l_itemkey wf_items.item_key%type;
36: l_error varchar2(3000);
37: l_recipient_login fnd_user.user_name%type;
38: l_recipient_id number;
39: l_proc constant varchar2(61) := g_pkg ||'prepare_error';

Line 64: CURSOR c_get_error(p_itemkey wf_items.item_key%type)

60: from hxc_time_building_blocks htb1
61: where htb.time_building_block_id =htb1.time_building_block_id);
62:
63:
64: CURSOR c_get_error(p_itemkey wf_items.item_key%type)
65: is
66: select error_message
67: from WF_ITEM_ACTIVITY_STATUSES
68: where item_type = 'HXCEMP'

Line 73: CURSOR c_get_parent_itemkey(itemkey in wf_items.item_key%type)

69: and item_key = p_itemkey
70: and activity_status = 'ERROR';
71:
72:
73: CURSOR c_get_parent_itemkey(itemkey in wf_items.item_key%type)
74: is
75: select parent_item_key
76: from wf_items
77: where item_key = itemkey;

Line 76: from wf_items

72:
73: CURSOR c_get_parent_itemkey(itemkey in wf_items.item_key%type)
74: is
75: select parent_item_key
76: from wf_items
77: where item_key = itemkey;
78:
79: BEGIN
80: