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_TIMECARD_UTILITIES dependencies on HXC_TIME_BUILDING_BLOCKS

Line 460: l_approval_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;

456: l_dummy varchar2(15);
457: l_proc VARCHAR2(50);
458:
459: l_set_more_period VARCHAR2(1);
460: l_approval_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
461:
462: -- New Fields.
463: l_assignment_processed_periods periods;
464: l_index number;

Line 476: FROM hxc_time_building_blocks

472: IS
473: SELECT START_TIME,
474: STOP_TIME,
475: APPROVAL_STATUS
476: FROM hxc_time_building_blocks
477: WHERE SCOPE = 'TIMECARD'
478: AND DATE_TO = hr_general.end_of_time
479: AND RESOURCE_ID = p_resource_id
480: AND RESOURCE_TYPE = p_resource_type

Line 757: -- Existing periods are found from hxc_time_building_blocks table, which means the data is

753: IF g_debug THEN
754: hr_utility.set_location (g_package||l_proc, 70);
755: END IF;
756: -- For this period we need not check whether its archived or not, as this is an existing period.
757: -- Existing periods are found from hxc_time_building_blocks table, which means the data is
758: -- present in the online tables.
759:
760: --add timecard row
761: IF (l_approval_status NOT IN ('ERROR')) THEN

Line 1238: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1234: END get_period_list;
1235:
1236:
1237: FUNCTION get_assignment_periods(
1238: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1239: )
1240: RETURN periods
1241: IS
1242: l_assignment_index NUMBER;

Line 1356: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1352:
1353:
1354:
1355: PROCEDURE init_globals(
1356: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1357: )
1358: IS
1359: l_assignment_index NUMBER;
1360: l_start_date DATE;

Line 1811: FROM hxc_time_building_blocks

1807: ,'N' CHANGED
1808: ,'N' PROCESS
1809: ,APPLICATION_SET_ID
1810: ,TRANSLATION_DISPLAY_KEY
1811: FROM hxc_time_building_blocks
1812: where time_building_block_id = p_timecard_id
1813: and resource_id = p_resource_id
1814: and scope = 'TIMECARD';
1815: --and date_to = hr_general.end_of_time;

Line 1848: FROM hxc_time_building_blocks

1844: ,'N' CHANGED
1845: ,'N' PROCESS
1846: ,APPLICATION_SET_ID
1847: ,TRANSLATION_DISPLAY_KEY
1848: FROM hxc_time_building_blocks
1849: WHERE resource_id = p_resource_id
1850: AND parent_building_block_id = p_parent_building_block_id
1851: AND parent_building_block_ovn = p_parent_ovn
1852: AND SCOPE = 'DAY';

Line 1884: FROM hxc_time_building_blocks

1880: ,'N' CHANGED
1881: ,'N' PROCESS
1882: ,APPLICATION_SET_ID
1883: ,TRANSLATION_DISPLAY_KEY
1884: FROM hxc_time_building_blocks
1885: WHERE resource_id = p_resource_id
1886: AND parent_building_block_id = p_parent_building_block_id
1887: AND parent_building_block_ovn = p_parent_ovn
1888: AND SCOPE = 'DETAIL'

Line 1941: from hxc_time_building_blocks detail,

1937: where a.time_attribute_id = au.time_attribute_id
1938: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
1939: and (au.time_building_block_id,au.time_building_block_ovn) in
1940: (select detail.time_building_block_id,detail.object_version_number
1941: from hxc_time_building_blocks detail,
1942: hxc_time_building_blocks day
1943: where day.time_building_block_id = detail.parent_building_block_id
1944: and day.object_version_number = detail.parent_building_block_ovn
1945: and day.scope = 'DAY'

Line 1942: hxc_time_building_blocks day

1938: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
1939: and (au.time_building_block_id,au.time_building_block_ovn) in
1940: (select detail.time_building_block_id,detail.object_version_number
1941: from hxc_time_building_blocks detail,
1942: hxc_time_building_blocks day
1943: where day.time_building_block_id = detail.parent_building_block_id
1944: and day.object_version_number = detail.parent_building_block_ovn
1945: and day.scope = 'DAY'
1946: and detail.resource_id = l_resource_id

Line 2002: from hxc_time_building_blocks day

1998: where a.time_attribute_id = au.time_attribute_id
1999: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2000: and (au.time_building_block_id,au.time_building_block_ovn) in
2001: (select day.time_building_block_id,day.object_version_number
2002: from hxc_time_building_blocks day
2003: where -- day.date_to = hr_general.end_of_time
2004: day.scope = 'DAY'
2005: and day.parent_building_block_id = timecard_id
2006: and day.parent_building_block_ovn = timecard_ovn

Line 2057: from hxc_time_building_blocks htbb

2053: where a.time_attribute_id = au.time_attribute_id
2054: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2055: and (au.time_building_block_id,au.time_building_block_ovn) in
2056: (select time_building_block_id,object_version_number
2057: from hxc_time_building_blocks htbb
2058: where --htbb.date_to = hr_general.end_of_time
2059: htbb.scope = 'TIMECARD'
2060: and htbb.time_building_block_id = timecard_id
2061: and htbb.object_version_number = timecard_ovn

Line 2112: hxc_time_building_blocks htbb

2108: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
2109: from hxc_bld_blk_info_types bbit,
2110: hxc_time_attribute_usages au,
2111: hxc_time_attributes a,
2112: hxc_time_building_blocks htbb
2113: where a.time_attribute_id = au.time_attribute_id
2114: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2115: and au.time_building_block_id = htbb.time_building_block_id
2116: and au.time_building_block_ovn = htbb.object_version_number