APPS.HXC_BUILDING_BLOCK_API dependencies on HR_GENERAL

Line 135: and date_to = hr_general.end_of_time;

131: cursor c_get_tc_data_set_id (p_time_building_block_id number) is
132: select data_set_id
133: from hxc_time_building_blocks
134: where time_building_block_id = p_time_building_block_id
135: and date_to = hr_general.end_of_time;
136:
137: cursor c_get_tc_range_data_set_id (p_stop_time date) is
138: select data_set_id
139: from hxc_data_sets

Line 227: and date_to = hr_general.end_of_time;

223: ,trunc(p_effective_date)
224: ,p_effective_date
225: ,p_effective_date - 1)
226: where time_building_block_id = p_time_building_block_id
227: and date_to = hr_general.end_of_time;
228:
229: hxc_tbb_ins.ins
230: (p_effective_date => p_effective_date
231: ,p_type => p_type

Line 244: ,p_date_to => hr_general.end_of_time

240: ,p_resource_id => p_resource_id
241: ,p_resource_type => p_resource_type
242: ,p_approval_style_id => p_approval_style_id
243: ,p_date_from => p_effective_date
244: ,p_date_to => hr_general.end_of_time
245: ,p_comment_text => p_comment_text
246: ,p_application_set_id => p_application_set_id
247: ,p_data_set_id => l_data_set_id
248: ,p_translation_display_key => p_translation_display_key

Line 265: and date_to = hr_general.end_of_time;

261: set object_version_number = l_max_ovn + 1,
262: time_building_block_id = p_time_building_block_id
263: where time_building_block_id = l_time_building_block_id
264: and date_from = p_effective_date
265: and date_to = hr_general.end_of_time;
266:
267: l_object_version_number := l_max_ovn + 1;
268: --
269: -- ARR 115.6

Line 330: ,p_date_to => hr_general.end_of_time

326: ,p_resource_id => p_resource_id
327: ,p_resource_type => p_resource_type
328: ,p_approval_style_id => p_approval_style_id
329: ,p_date_from => p_effective_date
330: ,p_date_to => hr_general.end_of_time
331: ,p_comment_text => p_comment_text
332: ,p_application_set_id => p_application_set_id
333: ,p_data_set_id => l_data_set_id
334: ,p_translation_display_key => p_translation_display_key

Line 697: and date_to = hr_general.end_of_time;

693: cursor c_old_rec is
694: select *
695: from hxc_time_building_blocks
696: where time_building_block_id = p_time_building_block_id
697: and date_to = hr_general.end_of_time;
698:
699: cursor c_latest_bb_version is
700: select max(object_version_number)
701: from hxc_time_building_blocks

Line 756: and date_to = hr_general.end_of_time;

752: close c_old_rec;
753: update hxc_time_building_blocks
754: set date_to = p_effective_date
755: where time_building_block_id = p_time_building_block_id
756: and date_to = hr_general.end_of_time;
757:
758: l_time_building_block_id := null;
759:
760: if(l_time_record.scope = 'DETAIL' )then

Line 781: p_date_to => hr_general.end_of_time,

777: p_resource_id => l_time_record.resource_id,
778: p_resource_type => l_time_record.resource_type,
779: p_approval_style_id => l_time_record.approval_style_id,
780: p_date_from => p_effective_date,
781: p_date_to => hr_general.end_of_time,
782: p_comment_text => l_time_record.comment_text,
783: p_application_set_id => NVL(p_application_set_id, l_time_record.application_set_id),
784: p_data_set_id => l_time_record.data_set_id,
785: p_translation_display_key => l_time_record.translation_display_key,

Line 802: and date_to = hr_general.end_of_time;

798: time_building_block_id = p_time_building_block_id,
799: date_to = p_effective_date
800: where time_building_block_id = l_time_building_block_id
801: and date_from = p_effective_date
802: and date_to = hr_general.end_of_time;
803:
804: --
805: -- Ensure the attributes associated with the deleted block
806: -- are the same as the ones from the previous block.