1: PACKAGE BODY hxc_timecard_attribute_utils AS
2: /* $Header: hxctcatut.pkb 115.4 2004/01/02 16:32:48 arundell noship $ */
3:
4: type attribute_index is table of hxc_time_attributes.time_attribute_id%type index by binary_integer;
5: type bld_blk_info_type_ids is table of hxc_bld_blk_info_types.bld_blk_info_type%type index by binary_integer;
6:
7: g_bld_blk_info_type_ids bld_blk_info_type_ids;
8:
363:
364: End process_attribute;
365:
366: Function build_attribute
367: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
368: ,p_object_version_number in HXC_TIME_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE
369: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
370: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
371: ) return HXC_ATTRIBUTE_TYPE is
364: End process_attribute;
365:
366: Function build_attribute
367: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
368: ,p_object_version_number in HXC_TIME_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE
369: ,p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
370: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
371: ) return HXC_ATTRIBUTE_TYPE is
372:
370: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
371: ) return HXC_ATTRIBUTE_TYPE is
372:
373: cursor c_attribute
374: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
375: ,p_object_version_number in HXC_TIME_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE
376: ) is
377: select *
378: from hxc_time_attributes
371: ) return HXC_ATTRIBUTE_TYPE is
372:
373: cursor c_attribute
374: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
375: ,p_object_version_number in HXC_TIME_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE
376: ) is
377: select *
378: from hxc_time_attributes
379: where time_attribute_id = p_time_attribute_id
374: (p_time_attribute_id in HXC_TIME_ATTRIBUTES.TIME_ATTRIBUTE_ID%TYPE
375: ,p_object_version_number in HXC_TIME_ATTRIBUTES.OBJECT_VERSION_NUMBER%TYPE
376: ) is
377: select *
378: from hxc_time_attributes
379: where time_attribute_id = p_time_attribute_id
380: and object_version_number = p_object_version_number;
381:
382: l_new_attribute HXC_ATTRIBUTE_TYPE;
584: End attributes_are_different;
585:
586: Function get_attribute_index
587: (p_attributes in hxc_attribute_table_type
588: ,p_context in hxc_time_attributes.attribute_category%type
589: ,p_building_block_id in hxc_time_building_blocks.time_building_block_id%type default null
590: ) return NUMBER is
591:
592: l_index number;