eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_TIMECARD_SUMMARY

Line 9: from hxc_timecard_summary ts

5:
6: cursor c_timecards is
7: select ts.timecard_id
8: ,ts.timecard_ovn
9: from hxc_timecard_summary ts
10: where not exists (select 'Y'
11: from hxc_time_building_blocks tbb
12: where tbb.time_building_block_id = ts.timecard_id and
13: tbb.object_version_number = ts.timecard_ovn and

Line 20: from hxc_timecard_summary ts

16:
17: cursor c_deleted_timecards is
18: select ts.timecard_id
19: ,ts.timecard_ovn
20: from hxc_timecard_summary ts
21: where exists (select 'Y'
22: from hxc_time_building_blocks tbb
23: where tbb.time_building_block_id = ts.timecard_id and
24: tbb.object_version_number = ts.timecard_ovn and

Line 35: hxc_timecard_summary_api.delete_timecard(timecard_rec.timecard_id);

31: Begin
32:
33: for timecard_rec in c_timecards loop
34:
35: hxc_timecard_summary_api.delete_timecard(timecard_rec.timecard_id);
36:
37: end loop;
38:
39: for timecard_rec in c_deleted_timecards loop

Line 41: hxc_timecard_summary_api.delete_timecard(timecard_rec.timecard_id);

37: end loop;
38:
39: for timecard_rec in c_deleted_timecards loop
40:
41: hxc_timecard_summary_api.delete_timecard(timecard_rec.timecard_id);
42:
43: end loop;
44:
45: End delete_timecards;

Line 100: from hxc_timecard_summary

96: tbb.date_to = hr_general.end_of_time and
97: tbb.scope = 'TIMECARD' and
98: not exists
99: (select 'Y'
100: from hxc_timecard_summary
101: where timecard_id = tbb.time_building_block_id and
102: timecard_ovn = tbb.object_version_number);
103:
104: l_blocks hxc_block_table_type;

Line 110: hxc_timecard_summary_api.timecard_deposit

106:
107: Begin
108:
109: for timecard_rec in c_timecards(p_resource_id) loop
110: hxc_timecard_summary_api.timecard_deposit
111: (p_timecard_id => timecard_rec.time_building_block_id
112: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode
113: ,p_approval_item_type =>null
114: ,p_approval_process_name=> null

Line 112: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode

108:
109: for timecard_rec in c_timecards(p_resource_id) loop
110: hxc_timecard_summary_api.timecard_deposit
111: (p_timecard_id => timecard_rec.time_building_block_id
112: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode
113: ,p_approval_item_type =>null
114: ,p_approval_process_name=> null
115: ,p_approval_item_key => null
116: ,p_tk_audit_item_type => null

Line 193: ,hxc_timecard_summary_pkg.c_migration_mode);

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:
197: End application_period_summary;

Line 209: from hxc_timecard_summary ts

205: where tbb.scope = 'TIMECARD' and
206: tbb.date_to = hr_general.end_of_time and
207: not exists
208: (select 'Y'
209: from hxc_timecard_summary ts
210: where tbb.time_building_block_id = ts.timecard_id and
211: tbb.object_version_number = ts.timecard_ovn);
212:
213: cursor c_timecard_summary is

Line 215: where exists ( select 'x' from hxc_timecard_summary);

211: tbb.object_version_number = ts.timecard_ovn);
212:
213: cursor c_timecard_summary is
214: select 1 from dual
215: where exists ( select 'x' from hxc_timecard_summary);
216:
217: cursor c_template_summary is
218: select 1 from dual
219: where exists ( select 'x' from hxc_template_summary);

Line 243: -- even if there is a single record in hxc_timecard_summary, we are not going

239:
240: l_timecard_found := false;
241: l_template_found := false;
242:
243: -- even if there is a single record in hxc_timecard_summary, we are not going
244: -- to allow the migration of timecards.
245: open c_timecard_summary;
246: fetch c_timecard_summary
247: into l_dummy;

Line 990: from hxc_timecard_summary

986: where tbb.date_to = hr_general.end_of_time and
987: tbb.scope = 'TIMECARD' and
988: not exists
989: (select 'Y'
990: from hxc_timecard_summary
991: where timecard_id = tbb.time_building_block_id and
992: timecard_ovn = tbb.object_version_number) and
993: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
994: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date

Line 1008: from hxc_timecard_summary

1004: where tbb.date_to = hr_general.end_of_time and
1005: tbb.scope = 'TIMECARD' and
1006: not exists
1007: (select 'Y'
1008: from hxc_timecard_summary
1009: where timecard_id = tbb.time_building_block_id and
1010: timecard_ovn = tbb.object_version_number) and
1011: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
1012: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date

Line 1538: hxc_timecard_summary_api.timecard_deposit

1534:
1535: if sql%found then
1536:
1537: for timecard_rec in c_temp_resources(l_worker_id, 'TIMECARD') loop
1538: hxc_timecard_summary_api.timecard_deposit
1539: (p_timecard_id => timecard_rec.time_building_block_id
1540: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode
1541: ,p_approval_item_type =>null
1542: ,p_approval_process_name=> null

Line 1540: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode

1536:
1537: for timecard_rec in c_temp_resources(l_worker_id, 'TIMECARD') loop
1538: hxc_timecard_summary_api.timecard_deposit
1539: (p_timecard_id => timecard_rec.time_building_block_id
1540: ,p_mode => hxc_timecard_summary_pkg.c_migration_mode
1541: ,p_approval_item_type =>null
1542: ,p_approval_process_name=> null
1543: ,p_approval_item_key => null
1544: ,p_tk_audit_item_type => null

Line 1553: ,hxc_timecard_summary_pkg.c_migration_mode);

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:
1557: delete from hxc_temp_timecards