APPS.HXC_TIMECARD_DEPOSIT_COMMON dependencies on HXC_TIME_BUILDING_BLOCKS

Line 107: (p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type

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

Line 108: ,p_timecard_ovn in out nocopy hxc_time_building_blocks.object_version_number%type

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

Line 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

Line 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;

Line 154: (p_building_block_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 155: ,p_building_block_ovn in hxc_time_building_blocks.object_version_number%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
159: where tau.time_building_block_id = p_building_block_id

Line 197: ,p_timecard_id in out nocopy hxc_time_building_blocks.time_building_block_id%type

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

Line 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;

Line 203: from hxc_time_building_blocks tbb

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

Line 220: l_timecard_ovn hxc_time_building_blocks.object_version_number%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: