[Home] [Help]
54: (p_block_id hxc_time_building_blocks.time_building_block_id%type,
55: p_block_ovn hxc_time_building_blocks.object_version_number%type) is
56: select tau.time_attribute_id,
57: tbb.data_set_id
58: from hxc_time_attribute_usages tau,
59: hxc_time_attributes ta,
60: hxc_time_building_blocks tbb
61: where tau.time_building_block_id = p_block_id
62: and tau.time_building_block_ovn = p_block_ovn
67:
68: begin
69: for attribute_record in c_attributes(p_from_block_id,p_from_block_ovn) loop
70: -- Create the usage for the new block for this attribute
71: insert into hxc_time_attribute_usages
72: (time_attribute_usage_id,
73: time_attribute_id,
74: time_building_block_id,
75: created_by,
79: last_update_login,
80: object_version_number,
81: time_building_block_ovn,
82: data_set_id
83: ) values (hxc_time_attribute_usages_s.nextval,
84: attribute_record.time_attribute_id,
85: p_to_block_id,
86: null, -- WHO trigger sets
87: null, -- WHO trigger sets
703: group by time_building_block_id;
704:
705: cursor c_time_attribute_usage(p_ovn number, p_building_block_id number) is
706: SELECT htau.time_attribute_id time_attribute_id
707: FROM hxc_time_attribute_usages htau ,
708: hxc_time_attributes hta
709: WHERE htau.time_building_block_ovn = p_ovn
710: AND htau.time_building_block_id = p_building_block_id
711: AND hta.time_attribute_id = htau.time_attribute_id