DBA Data[Home] [Help]

APPS.HXC_TIMECARD_UTILITIES dependencies on HXC_BLOCK_TABLE_TYPE

Line 2224: ,p_blocks IN OUT NOCOPY HXC_BLOCK_TABLE_TYPE

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:

Line 2567: l_timecard_block HXC_BLOCK_TABLE_TYPE;

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:

Line 2568: l_day_block HXC_BLOCK_TABLE_TYPE;

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;

Line 2569: l_detail_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:

Line 2572: l_alias_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:
2574: l_index NUMBER := 1;
2575: l_att_index NUMBER := 1;
2576:

Line 2580: l_timecard_block := HXC_BLOCK_TABLE_TYPE ();

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:

Line 2581: l_day_block := HXC_BLOCK_TABLE_TYPE ();

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 ();

Line 2582: l_detail_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:

Line 2585: l_alias_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:
2587: p_blocks := HXC_BLOCK_TABLE_TYPE ();
2588: p_attributes := HXC_ATTRIBUTE_TABLE_TYPE();
2589:

Line 2587: p_blocks := 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:
2590: --l_index := l_block.first;
2591: --l_att_index := l_attribute.first;