103: This procedure....
104:
105: ***************************************************************************/
106: Function load_blocks
107: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
108: ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type
109: ) return hxc_block_table_type is
110:
111: cursor c_blocks
104:
105: ***************************************************************************/
106: Function load_blocks
107: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
108: ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type
109: ) return hxc_block_table_type is
110:
111: cursor c_blocks
112: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
108: ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type
109: ) return hxc_block_table_type is
110:
111: cursor c_blocks
112: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
113: ) is
114: select tbb.time_building_block_id
115: ,tbb.object_version_number
116: from hxc_time_building_blocks tbb
112: (p_tc_id in hxc_time_building_blocks.time_building_block_id%type
113: ) is
114: select tbb.time_building_block_id
115: ,tbb.object_version_number
116: from hxc_time_building_blocks tbb
117: where tbb.date_to = hr_general.end_of_time
118: start with (tbb.time_building_block_id = p_tc_id)
119: connect by prior tbb.time_building_block_id = tbb.parent_building_block_id
120: and prior tbb.object_version_number = tbb.parent_building_block_ovn;
150: (p_blocks in out nocopy hxc_block_table_type)
151: return hxc_attribute_table_type is
152:
153: cursor c_attributes
154: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type
155: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%type
156: ) is
157: select tau.time_attribute_id
158: from hxc_time_attribute_usages tau
151: return hxc_attribute_table_type is
152:
153: cursor c_attributes
154: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type
155: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%type
156: ) is
157: select tau.time_attribute_id
158: from hxc_time_attribute_usages tau
159: where tau.time_building_block_id = p_building_block_id
193: ***************************************************************************/
194: Procedure delete_timecard
195: (p_mode in varchar2
196: ,p_template in varchar2
197: ,p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
198: ) is
199:
200: cursor c_timecard_ovn
201: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
197: ,p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type
198: ) is
199:
200: cursor c_timecard_ovn
201: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
202: select tbb.object_version_number
203: from hxc_time_building_blocks tbb
204: where tbb.time_building_block_id = p_timecard_id
205: and tbb.date_to = hr_general.end_of_time;
199:
200: cursor c_timecard_ovn
201: (p_timecard_id in hxc_time_building_blocks.time_building_block_id%type) is
202: select tbb.object_version_number
203: from hxc_time_building_blocks tbb
204: where tbb.time_building_block_id = p_timecard_id
205: and tbb.date_to = hr_general.end_of_time;
206:
207: l_blocks hxc_block_table_type := hxc_block_table_type();
216: l_timecard_props hxc_timecard_prop_table_type;
217:
218: l_dummy boolean := true;
219:
220: l_timecard_ovn hxc_time_building_blocks.object_version_number%type;
221: l_timecard_index number;
222:
223: Begin
224: