DBA Data[Home] [Help]

APPS.HXC_APPROVAL_WF_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 1833: p_name in wf_item_attribute_values.name%type)

1829:
1830: FUNCTION item_attribute_exists
1831: (p_item_type in wf_items.item_type%type,
1832: p_item_key in wf_item_activity_statuses.item_key%type,
1833: p_name in wf_item_attribute_values.name%type)
1834: return boolean is
1835:
1836: l_dummy varchar2(1);
1837:

Line 1842: from wf_item_attribute_values

1838: BEGIN
1839:
1840: select 'Y'
1841: into l_dummy
1842: from wf_item_attribute_values
1843: where item_type = p_item_type
1844: and item_key = p_item_key
1845: and name = p_name;
1846:

Line 1858: ,p_item_key IN wf_item_attribute_values.item_key%type

1854:
1855:
1856: PROCEDURE generate_app_period(
1857: p_item_type IN wf_item_types.name%type
1858: ,p_item_key IN wf_item_attribute_values.item_key%type
1859: ,p_timecard_id IN hxc_time_building_blocks.time_building_block_id%TYPE
1860: ,p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1861: ,p_start_time IN hxc_time_building_blocks.start_time%TYPE
1862: ,p_stop_time IN hxc_time_building_blocks.stop_time%TYPE