APPS.HXC_DEPOSIT_PROCESS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 15: -- HXC_TIME_BUILDING_BLOCKS

11: -- store. accepts a 'timecard' in the form of a pl/sql record structure,
12: -- along with all associated header information, and splits the data into
13: -- suitable components prior to insertion into the following storage tables:
14: --
15: -- HXC_TIME_BUILDING_BLOCKS
16: -- HXC_TIME_ATTRIBUTES
17: -- HXC_TIME_ATTRIBUTE_USAGES
18: --
19: -- parameters

Line 97: -- first, create a building block in HXC_TIME_BUILDING_BLOCKS

93: l_time_building_block_id_o := p_time_building_block_id;
94:
95: savepoint pre_create;
96:
97: -- first, create a building block in HXC_TIME_BUILDING_BLOCKS
98: hxc_building_block_api.create_building_block
99: (p_effective_date => p_effective_date
100: ,p_type => p_type
101: ,p_measure => p_measure

Line 158: -- first, create a building block in HXC_TIME_BUILDING_BLOCKS

154: l_time_building_block_id_o := p_time_building_block_id;
155:
156: savepoint pre_create;
157:
158: -- first, create a building block in HXC_TIME_BUILDING_BLOCKS
159: hxc_building_block_api.create_building_block
160: (p_effective_date => p_effective_date
161: ,p_type => p_type
162: ,p_measure => p_measure

Line 283: from hxc_time_building_blocks tbb

279:
280: -- You can only have one object version number of a block with date to of hr_general.end_of_time
281: cursor c_latest_ovn is
282: select null
283: from hxc_time_building_blocks tbb
284: where tbb.time_building_block_id = p_time_building_block_id
285: and tbb.object_version_number = p_object_version_number
286: and tbb.date_to = hr_general.end_of_time;
287: /*cursor c_latest_ovn is

Line 289: from hxc_time_building_blocks tbb

285: and tbb.object_version_number = p_object_version_number
286: and tbb.date_to = hr_general.end_of_time;
287: /*cursor c_latest_ovn is
288: select null
289: from hxc_time_building_blocks tbb
290: where tbb.time_building_block_id = p_time_building_block_id
291: and p_object_version_number = (select max(object_version_number) from hxc_time_building_blocks where time_building_block_id = tbb.time_building_block_id)
292: and tbb.date_to = to_date('31/12/4712','DD/MM/YYYY');
293: */

Line 291: and p_object_version_number = (select max(object_version_number) from hxc_time_building_blocks where time_building_block_id = tbb.time_building_block_id)

287: /*cursor c_latest_ovn is
288: select null
289: from hxc_time_building_blocks tbb
290: where tbb.time_building_block_id = p_time_building_block_id
291: and p_object_version_number = (select max(object_version_number) from hxc_time_building_blocks where time_building_block_id = tbb.time_building_block_id)
292: and tbb.date_to = to_date('31/12/4712','DD/MM/YYYY');
293: */
294: /*cursor c_latest_ovn is
295: select null

Line 296: from hxc_time_building_blocks tbb

292: and tbb.date_to = to_date('31/12/4712','DD/MM/YYYY');
293: */
294: /*cursor c_latest_ovn is
295: select null
296: from hxc_time_building_blocks tbb
297: where tbb.time_building_block_id = p_time_building_block_id
298: and ((select max(object_version_number)
299: from hxc_time_building_blocks
300: where time_building_block_id = tbb.time_building_block_id)

Line 299: from hxc_time_building_blocks

295: select null
296: from hxc_time_building_blocks tbb
297: where tbb.time_building_block_id = p_time_building_block_id
298: and ((select max(object_version_number)
299: from hxc_time_building_blocks
300: where time_building_block_id = tbb.time_building_block_id)
301: = p_object_version_number)
302: and tbb.date_to = to_date('31/12/4712','DD/MM/YYYY');
303: */