APPS.AP_WEB_HOLDS_WF dependencies on WF_ITEMS

Line 26: l_item_key wf_items.item_key%TYPE;

22: p_item_key IN VARCHAR2) RETURN VARCHAR2 IS
23: ------------------------------------------------------------------------
24: l_debug_info VARCHAR2(200);
25:
26: l_item_key wf_items.item_key%TYPE;
27:
28: BEGIN
29:
30: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start ParseItemKey');

Line 188: from wf_items

184: BEGIN
185:
186: select 'Y'
187: into l_event_key_exists
188: from wf_items
189: where item_type = C_APWHOLDS
190: and item_key = p_event_key
191: and rownum = 1;
192:

Line 208: l_event_key wf_items.item_key%type;

204: p_expense_report_id IN NUMBER) IS
205: ------------------------------------------------------------------------
206: l_debug_info VARCHAR2(200);
207:
208: l_event_key wf_items.item_key%type;
209:
210: BEGIN
211:
212: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseHeldEvent');

Line 249: l_event_key wf_items.item_key%type;

245: p_expense_report_id IN NUMBER) IS
246: ------------------------------------------------------------------------
247: l_debug_info VARCHAR2(200);
248:
249: l_event_key wf_items.item_key%type;
250:
251: BEGIN
252:
253: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_HOLDS_WF', 'start RaiseReleasedEvent');