APPS.HXC_INTEGRATION_LAYER_V1_GRP dependencies on HXC_TIME_BUILDING_BLOCKS

Line 1411: (p_time_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

1407: -- ----------------------------------------------------------------------------
1408: -- |-----------------------------------< build_block >------------------------|
1409: -- ----------------------------------------------------------------------------
1410: FUNCTION build_block
1411: (p_time_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1412: ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1414:
1415: cursor c_block

Line 1412: ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

1408: -- |-----------------------------------< build_block >------------------------|
1409: -- ----------------------------------------------------------------------------
1410: FUNCTION build_block
1411: (p_time_building_block_id IN HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1412: ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1414:
1415: cursor c_block
1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

Line 1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

1412: ,p_time_building_block_ovn IN HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1414:
1415: cursor c_block
1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1418: ) is
1419: select *
1420: from hxc_time_building_blocks

Line 1417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

1413: ) RETURN HXC_USER_TYPE_DEFINITION_GRP.building_block_info IS
1414:
1415: cursor c_block
1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1418: ) is
1419: select *
1420: from hxc_time_building_blocks
1421: where time_building_block_id = p_time_building_block_id

Line 1420: from hxc_time_building_blocks

1416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
1418: ) is
1419: select *
1420: from hxc_time_building_blocks
1421: where time_building_block_id = p_time_building_block_id
1422: and object_version_number = p_time_building_block_ovn;
1423:
1424:

Line 1478: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

1474: -- ----------------------------------------------------------------------------
1475: -- |-------------------------------< build_attribute >------------------------|
1476: -- ----------------------------------------------------------------------------
1477: FUNCTION build_attribute
1478: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1479: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
1480: ,p_attribute_category in hxc_time_attributes.attribute_category%type
1481: ) return HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info is
1482:

Line 1479: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type

1475: -- |-------------------------------< build_attribute >------------------------|
1476: -- ----------------------------------------------------------------------------
1477: FUNCTION build_attribute
1478: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
1479: ,p_time_building_block_ovn in hxc_time_building_blocks.object_version_number%type
1480: ,p_attribute_category in hxc_time_attributes.attribute_category%type
1481: ) return HXC_USER_TYPE_DEFINITION_GRP.building_block_attribute_info is
1482:
1483: cursor c_attribute is