[Home] [Help]
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
14: tbb.scope = 'TIMECARD' and
15: tbb.date_to = hr_general.end_of_time);
16:
17: cursor c_deleted_timecards is
18: select ts.timecard_id
19: ,ts.timecard_ovn
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
25: tbb.scope = 'TIMECARD' and
26: tbb.date_to <> hr_general.end_of_time);
27:
28:
29: l_blocks hxc_block_table_type;
30:
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
57: tbb.scope = 'TIMECARD_TEMPLATE' and
58: tbb.date_to = hr_general.end_of_time);
59:
60: cursor c_deleted_templates is
61: select ts.template_id
62: ,ts.template_ovn
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
68: tbb.scope = 'TIMECARD_TEMPLATE' and
69: tbb.date_to <> hr_general.end_of_time);
70:
71: -- l_blocks hxc_block_table_type;
72:
73: Begin
92: select tbb.time_building_block_id
93: ,tbb.object_version_number
94: from hxc_time_building_blocks tbb
95: where tbb.resource_id = p_rid and
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
127: select tbb.time_building_block_id
128: ,tbb.object_version_number
129: from hxc_time_building_blocks tbb
130: where tbb.resource_id = p_rid and
131: tbb.date_to = hr_general.end_of_time and
132: tbb.scope = 'TIMECARD_TEMPLATE'
133: and resource_id <>-1 and
134: not exists
135: (select 'Y'
162: from hxc_time_building_blocks tbb
163: ,hxc_time_attribute_usages tau
164: ,hxc_time_attributes ta
165: where tbb.scope = 'APPLICATION_PERIOD' and
166: tbb.date_to = hr_general.end_of_time and
167: tbb.resource_id = p_resource_id and
168: tau.time_building_block_id = tbb.time_building_block_id and
169: tau.time_building_block_ovn = tbb.object_version_number and
170: ta.attribute_category = 'APPROVAL' and
202: cursor c_valid_resources is
203: select distinct resource_id
204: from hxc_time_building_blocks tbb
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
221: cursor c_valid_template_resources is
222: select distinct resource_id
223: from hxc_time_building_blocks tbb
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
761: cursor c_templates(p_start_date date, p_end_date date) is
762: select tbb.time_building_block_id
763: ,tbb.object_version_number
764: from hxc_time_building_blocks tbb
765: where tbb.date_to = hr_general.end_of_time and
766: tbb.scope = 'TIMECARD_TEMPLATE'
767: and resource_id <>-1 and
768: not exists
769: (select 'Y'
780: cursor c_templates_bg(p_start_date date, p_end_date date) is
781: select tbb.time_building_block_id
782: ,tbb.object_version_number
783: from hxc_time_building_blocks tbb
784: where tbb.date_to = hr_general.end_of_time and
785: tbb.scope = 'TIMECARD_TEMPLATE'
786: and resource_id <>-1 and
787: not exists
788: (select 'Y'
982: cursor c_timecards(p_start_date date, p_end_date date) is
983: select tbb.time_building_block_id
984: ,tbb.object_version_number
985: from hxc_time_building_blocks tbb
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
1000: cursor c_timecards_bg(p_start_date date, p_end_date date) is
1001: select tbb.time_building_block_id
1002: ,tbb.object_version_number
1003: from hxc_time_building_blocks tbb
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
1021: from hxc_time_building_blocks tbb
1022: ,hxc_time_attribute_usages tau
1023: ,hxc_time_attributes ta
1024: where tbb.scope = 'APPLICATION_PERIOD' and
1025: tbb.date_to = hr_general.end_of_time and
1026: tau.time_building_block_id = tbb.time_building_block_id and
1027: tau.time_building_block_ovn = tbb.object_version_number and
1028: ta.attribute_category = 'APPROVAL' and
1029: ta.time_attribute_id = tau.time_attribute_id and
1045: from hxc_time_building_blocks tbb
1046: ,hxc_time_attribute_usages tau
1047: ,hxc_time_attributes ta
1048: where tbb.scope = 'APPLICATION_PERIOD' and
1049: tbb.date_to = hr_general.end_of_time and
1050: tau.time_building_block_id = tbb.time_building_block_id and
1051: tau.time_building_block_ovn = tbb.object_version_number and
1052: ta.attribute_category = 'APPROVAL' and
1053: ta.time_attribute_id = tau.time_attribute_id and