APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_APP_PERIOD_SUMMARY

Line 174: from hxc_app_period_summary aps

170: ta.attribute_category = 'APPROVAL' and
171: ta.time_attribute_id = tau.time_attribute_id and
172: not exists
173: (select 'Y'
174: from hxc_app_period_summary aps
175: where aps.application_period_id = tbb.time_building_block_id and
176: aps.application_period_ovn = tbb.object_version_number)
177: order by 1;
178:

Line 192: hxc_app_period_summary_api.app_period_create(l_app_periods(l_index)

188: l_index := l_app_periods.first;
189:
190: Loop
191: Exit when not l_app_periods.exists(l_index);
192: hxc_app_period_summary_api.app_period_create(l_app_periods(l_index)
193: ,hxc_timecard_summary_pkg.c_migration_mode);
194: l_index := l_app_periods.next(l_index);
195: end loop;
196:

Line 1034: from hxc_app_period_summary aps

1030: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
1031: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
1032: not exists
1033: (select 'Y'
1034: from hxc_app_period_summary aps
1035: where aps.application_period_id = tbb.time_building_block_id and
1036: aps.application_period_ovn = tbb.object_version_number) and
1037: exists
1038: (select 1

Line 1058: from hxc_app_period_summary aps

1054: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
1055: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date
1056: not exists
1057: (select 'Y'
1058: from hxc_app_period_summary aps
1059: where aps.application_period_id = tbb.time_building_block_id and
1060: aps.application_period_ovn = tbb.object_version_number) and
1061: exists
1062: (select 1

Line 1552: hxc_app_period_summary_api.app_period_create(l_app_period_rec.time_building_block_id

1548: l_time_summary_count := l_time_summary_count + 1;
1549: end loop;
1550:
1551: for l_app_period_rec in c_temp_resources(l_worker_id,'APPLICATION_PERIOD') loop
1552: hxc_app_period_summary_api.app_period_create(l_app_period_rec.time_building_block_id
1553: ,hxc_timecard_summary_pkg.c_migration_mode);
1554: l_app_per_summary_count := l_app_per_summary_count + 1;
1555: end loop;
1556: