DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 2012: p_name in wf_item_attribute_values.name%type)

2008:
2009: FUNCTION item_attribute_exists
2010: (p_item_type in wf_items.item_type%type,
2011: p_item_key in wf_item_activity_statuses.item_key%type,
2012: p_name in wf_item_attribute_values.name%type)
2013: return boolean is
2014:
2015: l_dummy varchar2(1);
2016:

Line 2021: from wf_item_attribute_values

2017: BEGIN
2018:
2019: select 'Y'
2020: into l_dummy
2021: from wf_item_attribute_values
2022: where item_type = p_item_type
2023: and item_key = p_item_key
2024: and name = p_name;
2025:

Line 2037: ,p_item_key IN wf_item_attribute_values.item_key%type

2033:
2034:
2035: PROCEDURE generate_app_period(
2036: p_item_type IN wf_item_types.name%type
2037: ,p_item_key IN wf_item_attribute_values.item_key%type
2038: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
2039: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
2040: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
2041: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE