DBA Data[Home] [Help]

APPS.HXC_BLOCK_COLLECTION_UTILS dependencies on HXC_BLOCK_TYPE

Line 132: select hxc_block_type

128: ) is
129:
130: CURSOR c_block_type_info
131: (p_block_id in hxc_time_building_blocks.time_building_block_id%type) is
132: select hxc_block_type
133: (time_building_block_id,
134: type,
135: measure,
136: unit_of_measure,

Line 189: select hxc_block_type

185: p_attributes in out nocopy hxc_attribute_table_type
186: ) is
187:
188: CURSOR c_block_type_info is
189: select hxc_block_type
190: (days.time_building_block_id,
191: days.type,
192: days.measure,
193: days.unit_of_measure,

Line 265: select hxc_block_type

261: p_attributes in out nocopy hxc_attribute_table_type
262: ) is
263:
264: CURSOR c_block_type_info is
265: select hxc_block_type
266: (days.time_building_block_id,
267: days.type,
268: days.measure,
269: days.unit_of_measure,

Line 329: l_day hxc_block_type;

325: ) is
326:
327: l_index pls_integer;
328: l_curr_day date;
329: l_day hxc_block_type;
330: l_temp_blocks hxc_block_table_type;
331: l_day_diff number;
332:
333: Begin

Line 405: select hxc_block_type

401:
402: CURSOR c_block_type_info
403: (p_app_period_id in hxc_time_building_blocks.time_building_block_id%type)
404: is
405: select hxc_block_type
406: (details.time_building_block_id,
407: details.type,
408: details.measure,
409: details.unit_of_measure,

Line 486: select hxc_block_type

482: CURSOR c_block_type_info
483: (p_day_id in hxc_time_building_blocks.time_building_block_id%type,
484: p_day_ovn in hxc_time_building_blocks.object_version_number%type)
485: is
486: select hxc_block_type
487: (details.time_building_block_id,
488: details.type,
489: details.measure,
490: details.unit_of_measure,