DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on HXC_BLOCK_TABLE_TYPE

Line 1115: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,--hxc_self_service_time_deposit.timecard_info,

1111: -- | This procedure creates a pl/sql reference table for the day date |
1112: -- | attached to a detail time_building_block_id |
1113: -- ----------------------------------------------------------------------------
1114: PROCEDURE get_tbb_date_reference_table
1115: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,--hxc_self_service_time_deposit.timecard_info,
1116: p_tbb_date_reference_table IN OUT NOCOPY t_tbb_date_reference_table,
1117: p_timecard_start_time OUT NOCOPY DATE,
1118: p_timecard_stop_time OUT NOCOPY DATE)
1119: IS

Line 5210: return HXC_BLOCK_TABLE_TYPE is

5206:
5207:
5208: Function convert_timecard_to_type
5209: (p_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info)
5210: return HXC_BLOCK_TABLE_TYPE is
5211:
5212: l_blocks HXC_BLOCK_TABLE_TYPE;
5213: l_index NUMBER;
5214:

Line 5212: l_blocks HXC_BLOCK_TABLE_TYPE;

5208: Function convert_timecard_to_type
5209: (p_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info)
5210: return HXC_BLOCK_TABLE_TYPE is
5211:
5212: l_blocks HXC_BLOCK_TABLE_TYPE;
5213: l_index NUMBER;
5214:
5215:
5216: BEGIN

Line 5220: l_blocks := HXC_BLOCK_TABLE_TYPE();

5216: BEGIN
5217:
5218: -- Initialize the collection
5219:
5220: l_blocks := HXC_BLOCK_TABLE_TYPE();
5221:
5222: l_index := p_blocks.first;
5223:
5224: LOOP

Line 5424: l_tbb_block HXC_BLOCK_TABLE_TYPE;

5420: and htbb.time_building_block_id = p_detail_bb_id
5421: and htbb.object_version_number = p_detail_bb_ovn
5422: and htbb.resource_id = p_resource_id;
5423:
5424: l_tbb_block HXC_BLOCK_TABLE_TYPE;
5425:
5426: l_index NUMBER := 1;
5427: l_att_index NUMBER := 1;
5428:

Line 5431: l_tbb_block := HXC_BLOCK_TABLE_TYPE ();

5427: l_att_index NUMBER := 1;
5428:
5429: BEGIN
5430:
5431: l_tbb_block := HXC_BLOCK_TABLE_TYPE ();
5432: p_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
5433:
5434:
5435: -- now we need to build the type table