DBA Data[Home] [Help]

APPS.HXC_ALIAS_UTILITY dependencies on HXC_BLOCK_TABLE_TYPE

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

1427: -- | This procedure creates a pl/sql reference table for the day date |
1428: -- | attached to a detail time_building_block_id |
1429: -- ----------------------------------------------------------------------------
1430: PROCEDURE get_tbb_date_reference_table
1431: (p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE,--hxc_self_service_time_deposit.timecard_info,
1432: p_tbb_date_reference_table IN OUT NOCOPY t_tbb_date_reference_table,
1433: p_timecard_start_time OUT NOCOPY DATE,
1434: p_timecard_stop_time OUT NOCOPY DATE)
1435: IS

Line 5526: return HXC_BLOCK_TABLE_TYPE is

5522:
5523:
5524: Function convert_timecard_to_type
5525: (p_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info)
5526: return HXC_BLOCK_TABLE_TYPE is
5527:
5528: l_blocks HXC_BLOCK_TABLE_TYPE;
5529: l_index NUMBER;
5530:

Line 5528: l_blocks HXC_BLOCK_TABLE_TYPE;

5524: Function convert_timecard_to_type
5525: (p_blocks in HXC_SELF_SERVICE_TIME_DEPOSIT.timecard_info)
5526: return HXC_BLOCK_TABLE_TYPE is
5527:
5528: l_blocks HXC_BLOCK_TABLE_TYPE;
5529: l_index NUMBER;
5530:
5531:
5532: BEGIN

Line 5536: l_blocks := HXC_BLOCK_TABLE_TYPE();

5532: BEGIN
5533:
5534: -- Initialize the collection
5535:
5536: l_blocks := HXC_BLOCK_TABLE_TYPE();
5537:
5538: l_index := p_blocks.first;
5539:
5540: LOOP

Line 5740: l_tbb_block HXC_BLOCK_TABLE_TYPE;

5736: and htbb.time_building_block_id = p_detail_bb_id
5737: and htbb.object_version_number = p_detail_bb_ovn
5738: and htbb.resource_id = p_resource_id;
5739:
5740: l_tbb_block HXC_BLOCK_TABLE_TYPE;
5741:
5742: l_index NUMBER := 1;
5743: l_att_index NUMBER := 1;
5744:

Line 5747: l_tbb_block := HXC_BLOCK_TABLE_TYPE ();

5743: l_att_index NUMBER := 1;
5744:
5745: BEGIN
5746:
5747: l_tbb_block := HXC_BLOCK_TABLE_TYPE ();
5748: p_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
5749:
5750:
5751: -- now we need to build the type table