APPS.HXC_TCSUMMARY_MIGRATE dependencies on HXC_TEMPLATE_SUMMARY

Line 52: from hxc_template_summary ts

48:
49: cursor c_templates is
50: select ts.template_id
51: ,ts.template_ovn
52: from hxc_template_summary ts
53: where not exists (select 'Y'
54: from hxc_time_building_blocks tbb
55: where tbb.time_building_block_id = ts.template_id and
56: tbb.object_version_number = ts.template_ovn and

Line 63: from hxc_template_summary ts

59:
60: cursor c_deleted_templates is
61: select ts.template_id
62: ,ts.template_ovn
63: from hxc_template_summary ts
64: where exists (select 'Y'
65: from hxc_time_building_blocks tbb
66: where tbb.time_building_block_id = ts.template_id and
67: tbb.object_version_number = ts.template_ovn and

Line 77: hxc_template_summary_api.delete_template(template_rec.template_id);

73: Begin
74:
75: for template_rec in c_templates loop
76:
77: hxc_template_summary_api.delete_template(template_rec.template_id);
78:
79: end loop;
80:
81: for template_rec in c_deleted_templates loop

Line 83: hxc_template_summary_api.delete_template(template_rec.template_id);

79: end loop;
80:
81: for template_rec in c_deleted_templates loop
82:
83: hxc_template_summary_api.delete_template(template_rec.template_id);
84:
85: end loop;
86:
87: End delete_templates;

Line 136: from hxc_template_summary

132: tbb.scope = 'TIMECARD_TEMPLATE'
133: and resource_id <>-1 and
134: not exists
135: (select 'Y'
136: from hxc_template_summary
137: where template_id = tbb.time_building_block_id and
138: template_ovn = tbb.object_version_number);
139:
140: l_blocks hxc_block_table_type;

Line 145: hxc_template_summary_api.template_deposit

141:
142: Begin
143:
144: for template_rec in c_templates(p_resource_id) loop
145: hxc_template_summary_api.template_deposit
146: (p_template_id => template_rec.time_building_block_id
147: ,p_template_ovn =>template_rec.object_version_number
148: );
149: end loop;

Line 219: where exists ( select 'x' from hxc_template_summary);

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);
220:
221: cursor c_valid_template_resources is
222: select distinct resource_id
223: from hxc_time_building_blocks tbb

Line 228: from hxc_template_summary ts

224: where tbb.scope = 'TIMECARD_TEMPLATE' and
225: tbb.date_to = hr_general.end_of_time and
226: not exists
227: (select 'Y'
228: from hxc_template_summary ts
229: where tbb.time_building_block_id = ts.template_id and
230: tbb.object_version_number = ts.template_ovn);
231: l_dummy number;
232:

Line 770: from hxc_template_summary

766: tbb.scope = 'TIMECARD_TEMPLATE'
767: and resource_id <>-1 and
768: not exists
769: (select 'Y'
770: from hxc_template_summary
771: where template_id = tbb.time_building_block_id and
772: template_ovn = tbb.object_version_number) and
773: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
774: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date

Line 789: from hxc_template_summary

785: tbb.scope = 'TIMECARD_TEMPLATE'
786: and resource_id <>-1 and
787: not exists
788: (select 'Y'
789: from hxc_template_summary
790: where template_id = tbb.time_building_block_id and
791: template_ovn = tbb.object_version_number) and
792: TRUNC(tbb.start_time) >= nvl(p_start_date, TRUNC(tbb.start_time)) and -- 5985862 Added TRUNC to truncate time component from date
793: TRUNC(tbb.stop_time) <= nvl(p_end_date, tbb.stop_time) and -- 5985862 Added TRUNC to truncate time component from date

Line 1625: hxc_template_summary_api.template_deposit

1621:
1622: if sql%found then
1623:
1624: for timecard_rec in c_temp_resources(l_worker_id, 'TIMECARD_TEMPLATE') loop
1625: hxc_template_summary_api.template_deposit
1626: (p_template_id => timecard_rec.time_building_block_id
1627: ,p_template_ovn =>timecard_rec.object_version_number
1628: );
1629: l_time_summary_count := l_time_summary_count + 1;