APPS.HXC_APP_PERIOD_SUMMARY_API dependencies on HXC_TIME_BUILDING_BLOCKS

Line 40: from hxc_time_building_blocks tbb, hxc_time_Attributes ta, hxc_time_attribute_usages tau

36: select tbb.resource_id
37: ,tbb.start_time
38: ,tbb.stop_time
39: ,ta.attribute1 time_recipient_id
40: from hxc_time_building_blocks tbb, hxc_time_Attributes ta, hxc_time_attribute_usages tau
41: where tbb.time_building_block_id = p_id
42: and tbb.date_to = hr_general.end_of_time
43: and tau.time_building_block_id = tbb.time_building_block_id
44: and tau.time_building_block_ovn = tbb.object_version_number

Line 149: select data_set_id from hxc_time_building_blocks

145: ,p_approval_item_key in hxc_app_period_summary.approval_item_key%type default null
146: ) is
147:
148: cursor c_get_data_set_id(p_application_period_id number, p_application_period_ovn number) is
149: select data_set_id from hxc_time_building_blocks
150: where scope = 'APPLICATION_PERIOD'
151: and time_building_block_id = p_application_period_id
152: and object_version_number = p_application_period_ovn;
153:

Line 154: l_data_set_id hxc_time_building_blocks.data_set_id%TYPE;

150: where scope = 'APPLICATION_PERIOD'
151: and time_building_block_id = p_application_period_id
152: and object_version_number = p_application_period_ovn;
153:
154: l_data_set_id hxc_time_building_blocks.data_set_id%TYPE;
155:
156: Begin
157: --
158: -- 1. Clean up current application period data

Line 221: p_status IN hxc_time_building_blocks.approval_status%TYPE

217:
218:
219: --below for Garry's retrieval
220: FUNCTION valid_status(
221: p_status IN hxc_time_building_blocks.approval_status%TYPE
222: ,p_block_status IN hxc_time_building_blocks.approval_status%TYPE
223: )
224: RETURN BOOLEAN
225: IS

Line 222: ,p_block_status IN hxc_time_building_blocks.approval_status%TYPE

218:
219: --below for Garry's retrieval
220: FUNCTION valid_status(
221: p_status IN hxc_time_building_blocks.approval_status%TYPE
222: ,p_block_status IN hxc_time_building_blocks.approval_status%TYPE
223: )
224: RETURN BOOLEAN
225: IS
226: BEGIN

Line 334: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

330: return l_merged_periods;
331: End mergePeriods;
332:
333: PROCEDURE get_valid_periods(
334: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
335: ,p_time_recipient_id IN hxc_time_recipients.time_recipient_id%TYPE
336: ,p_start_date IN DATE
337: ,p_stop_date IN DATE
338: ,p_valid_status IN VARCHAR2

Line 343: p_resource_id hxc_time_building_blocks.resource_id%TYPE

339: ,p_valid_periods OUT NOCOPY valid_period_tab
340: ) is
341:
342: CURSOR c_app_periods(
343: p_resource_id hxc_time_building_blocks.resource_id%TYPE
344: ,p_time_recipient_id hxc_time_recipients.time_recipient_id%TYPE
345: ,p_start_date DATE
346: ,p_stop_date DATE
347: )

Line 366: ( p_resource_id hxc_time_building_blocks.resource_id%TYPE

362: )
363: ORDER BY start_time;
364:
365: CURSOR c_timecard_periods
366: ( p_resource_id hxc_time_building_blocks.resource_id%TYPE
367: ,p_start_date DATE
368: ,p_stop_date DATE
369: )
370: is

Line 385: l_app_period_status hxc_time_building_blocks.approval_status%TYPE;

381: l_start DATE := NULL;
382: l_stop DATE := NULL;
383: l_app_period_start DATE;
384: l_app_period_stop DATE;
385: l_app_period_status hxc_time_building_blocks.approval_status%TYPE;
386: l_index NUMBER := 0;
387:
388: l_ela_used boolean;
389: l_time_category_id number;