APPS.HXC_ALIAS_UTILITY dependencies on HXC_TIME_BUILDING_BLOCKS

Line 653: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE

649: -- | This procedure is used while the deposit translation |
650: -- ----------------------------------------------------------------------------
651: PROCEDURE attribute_check
652: (p_bld_blk_info_type_id IN NUMBER
653: ,p_time_building_block_id IN hxc_time_building_blocks.time_building_block_id%TYPE
654: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE--hxc_self_service_time_deposit.building_block_attribute_info
655: ,p_tbb_id_reference_table IN OUT NOCOPY t_tbb_id_reference
656: ,p_attribute_index IN OUT NOCOPY NUMBER
657: ,p_attribute_found IN OUT NOCOPY BOOLEAN)

Line 1443: l_scope hxc_time_building_blocks.SCOPE%TYPE;

1439: l_tbb_id NUMBER;
1440: l_parent_tbb_id NUMBER;
1441: l_start_time DATE;
1442: l_stop_time DATE;
1443: l_scope hxc_time_building_blocks.SCOPE%TYPE;
1444: --l_template BOOLEAN := FALSE;
1445: --l_tbb_date_reference_table t_tbb_date_reference_table;
1446:
1447: BEGIN

Line 4021: hxc_time_building_blocks htbb

4017: ,'N' PROCESS
4018: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
4019: from hxc_time_attribute_usages au,
4020: hxc_time_attributes a,
4021: hxc_time_building_blocks htbb
4022: where a.time_attribute_id = au.time_attribute_id
4023: and au.time_building_block_id = htbb.time_building_block_id
4024: and au.time_building_block_ovn = htbb.object_version_number
4025: and htbb.scope = 'TIMECARD'

Line 5611: FROM hxc_time_building_blocks timecard,

5607: ,detail.PARENT_BUILDING_BLOCK_ID detail_PARENT_BB_ID
5608: ,detail.PARENT_BUILDING_BLOCK_OVN detail_PARENT_BB_OVN
5609: ,detail.SCOPE detail_SCOPE
5610: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5611: FROM hxc_time_building_blocks timecard,
5612: hxc_time_building_blocks day,
5613: hxc_time_building_blocks detail
5614: where detail.time_building_block_id = p_detail_bb_id
5615: and detail.object_version_number = p_detail_bb_ovn

Line 5612: hxc_time_building_blocks day,

5608: ,detail.PARENT_BUILDING_BLOCK_OVN detail_PARENT_BB_OVN
5609: ,detail.SCOPE detail_SCOPE
5610: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5611: FROM hxc_time_building_blocks timecard,
5612: hxc_time_building_blocks day,
5613: hxc_time_building_blocks detail
5614: where detail.time_building_block_id = p_detail_bb_id
5615: and detail.object_version_number = p_detail_bb_ovn
5616: and detail.resource_id = p_resource_id

Line 5613: hxc_time_building_blocks detail

5609: ,detail.SCOPE detail_SCOPE
5610: ,detail.OBJECT_VERSION_NUMBER detail_OBJECT_VERSION_NUMBER
5611: FROM hxc_time_building_blocks timecard,
5612: hxc_time_building_blocks day,
5613: hxc_time_building_blocks detail
5614: where detail.time_building_block_id = p_detail_bb_id
5615: and detail.object_version_number = p_detail_bb_ovn
5616: and detail.resource_id = p_resource_id
5617: and detail.scope = 'DETAIL'

Line 5673: hxc_time_building_blocks htbb

5669: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5670: from hxc_bld_blk_info_types bbit,
5671: hxc_time_attribute_usages au,
5672: hxc_time_attributes a,
5673: hxc_time_building_blocks htbb
5674: where a.time_attribute_id = au.time_attribute_id
5675: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
5676: and au.time_building_block_id = htbb.time_building_block_id
5677: and au.time_building_block_ovn = htbb.object_version_number

Line 5730: hxc_time_building_blocks htbb

5726: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
5727: from hxc_bld_blk_info_types bbit,
5728: hxc_time_attribute_usages au,
5729: hxc_time_attributes a,
5730: hxc_time_building_blocks htbb
5731: where a.time_attribute_id = au.time_attribute_id
5732: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
5733: and au.time_building_block_id = htbb.time_building_block_id
5734: and au.time_building_block_ovn = htbb.object_version_number