APPS.HXC_BLOCK_ATTRIBUTE_UPDATE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 17: (p_id in hxc_time_building_blocks.time_building_block_id%type

13: ,p_duplicate_template in BOOLEAN
14: ) is
15:
16: cursor c_template_is_a_timecard
17: (p_id in hxc_time_building_blocks.time_building_block_id%type
18: ,p_ovn in hxc_time_building_blocks.object_version_number%type) is
19: select scope
20: from hxc_time_building_blocks
21: where time_building_block_id = p_id

Line 18: ,p_ovn in hxc_time_building_blocks.object_version_number%type) is

14: ) is
15:
16: cursor c_template_is_a_timecard
17: (p_id in hxc_time_building_blocks.time_building_block_id%type
18: ,p_ovn in hxc_time_building_blocks.object_version_number%type) is
19: select scope
20: from hxc_time_building_blocks
21: where time_building_block_id = p_id
22: and object_version_number = p_ovn;

Line 20: from hxc_time_building_blocks

16: cursor c_template_is_a_timecard
17: (p_id in hxc_time_building_blocks.time_building_block_id%type
18: ,p_ovn in hxc_time_building_blocks.object_version_number%type) is
19: select scope
20: from hxc_time_building_blocks
21: where time_building_block_id = p_id
22: and object_version_number = p_ovn;
23:
24: l_block_start number := -1000000;

Line 31: l_dummy_scope hxc_time_building_blocks.scope%type;

27: l_attribute_index number;
28: l_template_index number;
29: l_block_replacement_ids block_list;
30: l_replace boolean := false;
31: l_dummy_scope hxc_time_building_blocks.scope%type;
32:
33: Begin
34:
35: --