APPS.HXC_TIMEKEEPER_WF_PKG dependencies on WF_ITEMS

Line 261: from wf_items

257: ) IS
258:
259: CURSOR c_audit_keys is
260: SELECT ITEM_KEY,ITEM_TYPE
261: from wf_items
262: where parent_item_key =p_tk_audit_item_key
263: and parent_item_type = p_tk_audit_item_type;
264:
265:

Line 285: l_item_key wf_items.item_key%type;

281: where WN.GROUP_ID = WIAS.NOTIFICATION_ID
282: and WIAS.ITEM_TYPE = p_item_type
283: and WIAS.ITEM_KEY = p_item_key;
284:
285: l_item_key wf_items.item_key%type;
286: l_item_type wf_items.item_type%type;
287: l_ntfid Number;
288:
289: BEGIN

Line 286: l_item_type wf_items.item_type%type;

282: and WIAS.ITEM_TYPE = p_item_type
283: and WIAS.ITEM_KEY = p_item_key;
284:
285: l_item_key wf_items.item_key%type;
286: l_item_type wf_items.item_type%type;
287: l_ntfid Number;
288:
289: BEGIN
290:

Line 446: l_child_item_key wf_items.item_key%type;

442: ,p_tc_tk_nofity_type IN VARCHAR2
443: ,p_tc_tk_nofity_to IN VARCHAR2
444: )is
445:
446: l_child_item_key wf_items.item_key%type;
447:
448: BEGIN
449: l_child_item_key := hxc_timekeeper_wf_pkg.get_item_key;
450:

Line 653: l_child_item_key wf_items.item_key%type;

649: l_tc_stop_time hxc_time_building_blocks.stop_time%TYPE;
650: l_ntf_type VARCHAR2(150);
651: l_ntf_to VARCHAR2(150);
652: l_timkeeper_id hxc_time_building_blocks.resource_id%TYPE;
653: l_child_item_key wf_items.item_key%type;
654: l_process_name varchar2(150);
655: l_resource_id hxc_time_building_blocks.resource_id%TYPE;
656:
657: BEGIN