2220: PROCEDURE cla_summary_alias_translation(
2221: p_timecard_id IN NUMBER
2222: ,p_resource_id IN NUMBER
2223: ,p_attributes IN OUT NOCOPY HXC_ATTRIBUTE_TABLE_TYPE
2224: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE
2225: ,p_messages IN OUT NOCOPY HXC_MESSAGE_TABLE_TYPE
2226: )IS
2227:
2228:
2563: and htbb.object_version_number = detail_ovn
2564: and htbb.resource_id = l_resource_id;
2565:
2566:
2567: l_timecard_block HXC_BLOCK_TABLE_TYPE;
2568: l_day_block HXC_BLOCK_TABLE_TYPE;
2569: l_detail_block HXC_BLOCK_TABLE_TYPE;
2570: l_detail_attribute HXC_ATTRIBUTE_TABLE_TYPE;
2571:
2564: and htbb.resource_id = l_resource_id;
2565:
2566:
2567: l_timecard_block HXC_BLOCK_TABLE_TYPE;
2568: l_day_block HXC_BLOCK_TABLE_TYPE;
2569: l_detail_block HXC_BLOCK_TABLE_TYPE;
2570: l_detail_attribute HXC_ATTRIBUTE_TABLE_TYPE;
2571:
2572: l_alias_block HXC_BLOCK_TABLE_TYPE;
2565:
2566:
2567: l_timecard_block HXC_BLOCK_TABLE_TYPE;
2568: l_day_block HXC_BLOCK_TABLE_TYPE;
2569: l_detail_block HXC_BLOCK_TABLE_TYPE;
2570: l_detail_attribute HXC_ATTRIBUTE_TABLE_TYPE;
2571:
2572: l_alias_block HXC_BLOCK_TABLE_TYPE;
2573:
2568: l_day_block HXC_BLOCK_TABLE_TYPE;
2569: l_detail_block HXC_BLOCK_TABLE_TYPE;
2570: l_detail_attribute HXC_ATTRIBUTE_TABLE_TYPE;
2571:
2572: l_alias_block HXC_BLOCK_TABLE_TYPE;
2573:
2574: l_index NUMBER := 1;
2575: l_att_index NUMBER := 1;
2576:
2576:
2577: BEGIN
2578:
2579:
2580: l_timecard_block := HXC_BLOCK_TABLE_TYPE ();
2581: l_day_block := HXC_BLOCK_TABLE_TYPE ();
2582: l_detail_block := HXC_BLOCK_TABLE_TYPE ();
2583: l_detail_attribute := HXC_ATTRIBUTE_TABLE_TYPE();
2584:
2577: BEGIN
2578:
2579:
2580: l_timecard_block := HXC_BLOCK_TABLE_TYPE ();
2581: l_day_block := HXC_BLOCK_TABLE_TYPE ();
2582: l_detail_block := HXC_BLOCK_TABLE_TYPE ();
2583: l_detail_attribute := HXC_ATTRIBUTE_TABLE_TYPE();
2584:
2585: l_alias_block := HXC_BLOCK_TABLE_TYPE ();
2578:
2579:
2580: l_timecard_block := HXC_BLOCK_TABLE_TYPE ();
2581: l_day_block := HXC_BLOCK_TABLE_TYPE ();
2582: l_detail_block := HXC_BLOCK_TABLE_TYPE ();
2583: l_detail_attribute := HXC_ATTRIBUTE_TABLE_TYPE();
2584:
2585: l_alias_block := HXC_BLOCK_TABLE_TYPE ();
2586:
2581: l_day_block := HXC_BLOCK_TABLE_TYPE ();
2582: l_detail_block := HXC_BLOCK_TABLE_TYPE ();
2583: l_detail_attribute := HXC_ATTRIBUTE_TABLE_TYPE();
2584:
2585: l_alias_block := HXC_BLOCK_TABLE_TYPE ();
2586:
2587: p_blocks := HXC_BLOCK_TABLE_TYPE ();
2588: p_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
2589:
2583: l_detail_attribute := HXC_ATTRIBUTE_TABLE_TYPE();
2584:
2585: l_alias_block := HXC_BLOCK_TABLE_TYPE ();
2586:
2587: p_blocks := HXC_BLOCK_TABLE_TYPE ();
2588: p_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
2589:
2590: --l_index := l_block.first;
2591: --l_att_index := l_attribute.first;