APPS.HXC_ALIAS_UTILITY dependencies on HXC_TIME_BUILDING_BLOCKS

Line 589: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

585: -- | This procedure is used while the deposit translation |
586: -- ----------------------------------------------------------------------------
587: PROCEDURE attribute_check
588: (p_bld_blk_info_type_id IN NUMBER
589: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
590: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info
591: ,p_tbb_id_reference_table IN OUT NOCOPY t_tbb_id_reference
592: ,p_attribute_index IN OUT NOCOPY NUMBER
593: ,p_attribute_found IN OUT NOCOPY BOOLEAN)

Line 1127: l_scope hxc_time_building_blocks.SCOPE%TYPE;

1123: l_tbb_id NUMBER;
1124: l_parent_tbb_id NUMBER;
1125: l_start_time DATE;
1126: l_stop_time DATE;
1127: l_scope hxc_time_building_blocks.SCOPE%TYPE;
1128: --l_template BOOLEAN := FALSE;
1129: --l_tbb_date_reference_table t_tbb_date_reference_table;
1130:
1131: BEGIN

Line 3705: hxc_time_building_blocks htbb

3701: ,'N' PROCESS
3702: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
3703: from hxc_time_attribute_usages au,
3704: hxc_time_attributes a,
3705: hxc_time_building_blocks htbb
3706: where a.time_attribute_id = au.time_attribute_id
3707: and au.time_building_block_id = htbb.time_building_block_id
3708: and au.time_building_block_ovn = htbb.object_version_number
3709: and htbb.scope = 'TIMECARD'

Line 5295: FROM hxc_time_building_blocks timecard,

5291: ,detail.PARENT_BUILDING_BLOCK_ID detail_PARENT_BB_ID
5292: ,detail.PARENT_BUILDING_BLOCK_OVN detail_PARENT_BB_OVN
5293: ,detail.SCOPE detail_SCOPE
5294: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5295: FROM hxc_time_building_blocks timecard,
5296: hxc_time_building_blocks day,
5297: hxc_time_building_blocks detail
5298: where detail.time_building_block_id = p_detail_bb_id
5299: and detail.object_version_number = p_detail_bb_ovn

Line 5296: hxc_time_building_blocks day,

5292: ,detail.PARENT_BUILDING_BLOCK_OVN detail_PARENT_BB_OVN
5293: ,detail.SCOPE detail_SCOPE
5294: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5295: FROM hxc_time_building_blocks timecard,
5296: hxc_time_building_blocks day,
5297: hxc_time_building_blocks detail
5298: where detail.time_building_block_id = p_detail_bb_id
5299: and detail.object_version_number = p_detail_bb_ovn
5300: and detail.resource_id = p_resource_id

Line 5297: hxc_time_building_blocks detail

5293: ,detail.SCOPE detail_SCOPE
5294: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5295: FROM hxc_time_building_blocks timecard,
5296: hxc_time_building_blocks day,
5297: hxc_time_building_blocks detail
5298: where detail.time_building_block_id = p_detail_bb_id
5299: and detail.object_version_number = p_detail_bb_ovn
5300: and detail.resource_id = p_resource_id
5301: and detail.scope = 'DETAIL'

Line 5357: hxc_time_building_blocks htbb

5353: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5354: from hxc_bld_blk_info_types bbit,
5355: hxc_time_attribute_usages au,
5356: hxc_time_attributes a,
5357: hxc_time_building_blocks htbb
5358: where a.time_attribute_id = au.time_attribute_id
5359: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
5360: and au.time_building_block_id = htbb.time_building_block_id
5361: and au.time_building_block_ovn = htbb.object_version_number

Line 5414: hxc_time_building_blocks htbb

5410: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5411: from hxc_bld_blk_info_types bbit,
5412: hxc_time_attribute_usages au,
5413: hxc_time_attributes a,
5414: hxc_time_building_blocks htbb
5415: where a.time_attribute_id = au.time_attribute_id
5416: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
5417: and au.time_building_block_id = htbb.time_building_block_id
5418: and au.time_building_block_ovn = htbb.object_version_number