APPS.HXC_ARCHIVE_RESTORE_UTILS dependencies on HXC_TIME_BUILDING_BLOCKS

Line 41: FROM hxc_time_building_blocks temp, hxc_data_sets d

37: IS
38:
39: CURSOR c_timecard_template(p_data_set_id NUMBER) IS
40: SELECT DISTINCT temp.time_building_block_id
41: FROM hxc_time_building_blocks temp, hxc_data_sets d
42: WHERE temp.scope = 'TIMECARD_TEMPLATE'
43: AND EXISTS (SELECT 1 FROM hxc_time_building_blocks tc
44: WHERE tc.scope = 'TIMECARD'
45: AND tc.time_building_block_id = temp.time_building_block_id

Line 43: AND EXISTS (SELECT 1 FROM hxc_time_building_blocks tc

39: CURSOR c_timecard_template(p_data_set_id NUMBER) IS
40: SELECT DISTINCT temp.time_building_block_id
41: FROM hxc_time_building_blocks temp, hxc_data_sets d
42: WHERE temp.scope = 'TIMECARD_TEMPLATE'
43: AND EXISTS (SELECT 1 FROM hxc_time_building_blocks tc
44: WHERE tc.scope = 'TIMECARD'
45: AND tc.time_building_block_id = temp.time_building_block_id
46: )
47: AND temp.stop_time BETWEEN d.start_date AND d.end_date

Line 103: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_PK ) parallel (t,4)*/ count(time_building_block_id)

99:
100: BEGIN
101:
102: -- Building Blocks table
103: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_PK ) parallel (t,4)*/ count(time_building_block_id)
104: into p_tbb_count from hxc_time_building_blocks t;
105:
106: -- Attributes Usages
107: select/*+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)*/ count(time_attribute_usage_id)

Line 104: into p_tbb_count from hxc_time_building_blocks t;

100: BEGIN
101:
102: -- Building Blocks table
103: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_PK ) parallel (t,4)*/ count(time_building_block_id)
104: into p_tbb_count from hxc_time_building_blocks t;
105:
106: -- Attributes Usages
107: select/*+ index_ffs (t HXC_TIME_ATTRIBUTE_USAGES_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
108: into p_tau_count from hxc_time_attribute_usages t;

Line 146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);

142: -- Create the report
143: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
144: fnd_file.put_line(fnd_file.LOG,' Core Table Count Snapshot');
145: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
146: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks '||p_tbb_count);
147: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages '||p_tau_count);
148: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes '||p_ta_count);
149: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details '||p_td_count);
150: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions '||p_trans_count);

Line 179: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_AR_PK ) parallel (t,4)*/ count(time_building_block_id)

175:
176: BEGIN
177:
178: -- Building Blocks table
179: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_AR_PK ) parallel (t,4)*/ count(time_building_block_id)
180: into p_tbb_ar_count from hxc_time_building_blocks_ar t;
181:
182: -- Attributes Usages
183: select/*+ index_ffs (t HXC_TIME_ATTR_USAGES_AR_PK ) parallel (t,4)*/ count(time_attribute_usage_id)

Line 180: into p_tbb_ar_count from hxc_time_building_blocks_ar t;

176: BEGIN
177:
178: -- Building Blocks table
179: select /*+ index_ffs (t HXC_TIME_BUILDING_BLOCKS_AR_PK ) parallel (t,4)*/ count(time_building_block_id)
180: into p_tbb_ar_count from hxc_time_building_blocks_ar t;
181:
182: -- Attributes Usages
183: select/*+ index_ffs (t HXC_TIME_ATTR_USAGES_AR_PK ) parallel (t,4)*/ count(time_attribute_usage_id)
184: into p_tau_ar_count from hxc_time_attribute_usages_ar t;

Line 215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);

211: -- Create the report
212: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
213: fnd_file.put_line(fnd_file.LOG,' Archive Table Count Snapshot');
214: fnd_file.put_line(fnd_file.LOG,'--------------------------------------');
215: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_building_blocks_ar '||p_tbb_ar_count);
216: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attribute_usages_ar '||p_tau_ar_count);
217: fnd_file.put_line(fnd_file.LOG,'-> hxc_time_attributes_ar '||p_ta_ar_count);
218: fnd_file.put_line(fnd_file.LOG,'-> hxc_tansaction_details_ar '||p_td_ar_count);
219: fnd_file.put_line(fnd_file.LOG,'-> hxc_transactions_ar '||p_trans_ar_count);