DBA Data[Home] [Help]

APPS.HXC_BLOCK_ATTRIBUTE_UPDATE dependencies on HXC_TIME_BUILDING_BLOCKS

Line 19: (p_id in hxc_time_building_blocks.time_building_block_id%type

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

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

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

Line 22: from hxc_time_building_blocks

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

Line 33: l_dummy_scope hxc_time_building_blocks.scope%type;

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