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

Line 1584: from hxc_time_building_blocks tbbday,

1580:
1581: cursor range_details_of_day(p_day_date in DATE,p_resource_id in NUMBER)
1582: IS
1583: select tbbdet.start_time, tbbdet.stop_time
1584: from hxc_time_building_blocks tbbday,
1585: hxc_time_building_blocks tbbdet
1586: where
1587: tbbdet.scope = 'DETAIL'
1588: and tbbdet.type = 'RANGE'

Line 1585: hxc_time_building_blocks tbbdet

1581: cursor range_details_of_day(p_day_date in DATE,p_resource_id in NUMBER)
1582: IS
1583: select tbbdet.start_time, tbbdet.stop_time
1584: from hxc_time_building_blocks tbbday,
1585: hxc_time_building_blocks tbbdet
1586: where
1587: tbbdet.scope = 'DETAIL'
1588: and tbbdet.type = 'RANGE'
1589: and tbbday.scope = 'DAY'

Line 2435: hxc_time_building_blocks tbb_day,

2431: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,
2432: tbb_detail.object_version_number),0)) ),0)
2433: FROM
2434: hxc_timecard_summary ts,
2435: hxc_time_building_blocks tbb_day,
2436: hxc_time_building_blocks tbb_detail
2437: WHERE
2438: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2439: ts.timecard_id = tbb_day.parent_building_block_id and

Line 2436: hxc_time_building_blocks tbb_detail

2432: tbb_detail.object_version_number),0)) ),0)
2433: FROM
2434: hxc_timecard_summary ts,
2435: hxc_time_building_blocks tbb_day,
2436: hxc_time_building_blocks tbb_detail
2437: WHERE
2438: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2439: ts.timecard_id = tbb_day.parent_building_block_id and
2440: tbb_detail.scope='DETAIL' and

Line 2926: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

2922:
2923: END asg_status_id;
2924:
2925: PROCEDURE tc_edit_allowed (
2926: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2927: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2928: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2929: ,p_edit_allowed IN OUT nocopy VARCHAR2
2930: ) IS

Line 2927: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

2923: END asg_status_id;
2924:
2925: PROCEDURE tc_edit_allowed (
2926: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2927: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2928: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2929: ,p_edit_allowed IN OUT nocopy VARCHAR2
2930: ) IS
2931:

Line 2945: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

2941:
2942: end tc_edit_allowed;
2943:
2944: PROCEDURE tc_edit_allowed (
2945: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2946: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2947: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
2948: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2949: ,p_edit_allowed IN OUT nocopy VARCHAR2

Line 2946: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

2942: end tc_edit_allowed;
2943:
2944: PROCEDURE tc_edit_allowed (
2945: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2946: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2947: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
2948: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2949: ,p_edit_allowed IN OUT nocopy VARCHAR2
2950: ) is

Line 2947: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE

2943:
2944: PROCEDURE tc_edit_allowed (
2945: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2946: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2947: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
2948: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2949: ,p_edit_allowed IN OUT nocopy VARCHAR2
2950: ) is
2951:

Line 2967: l_tc_status hxc_time_building_blocks.approval_status%TYPE;

2963: t.status = 'SUCCESS' );
2964:
2965: l_proc VARCHAR2(72);
2966:
2967: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
2968:
2969: l_dummy NUMBER(1);
2970:
2971: BEGIN

Line 3351: FROM hxc_time_building_blocks detail,

3347: detail.resource_id, detail.resource_type,
3348: detail.approval_style_id, detail.date_from, detail.date_to,
3349: detail.comment_text, detail.parent_building_block_ovn,
3350: 'N' NEW, 'N' changed
3351: FROM hxc_time_building_blocks detail,
3352: hxc_time_building_blocks DAY
3353: WHERE DAY.parent_building_block_id =
3354: p_timecard_rec.timecard_bb_id
3355: AND DAY.parent_building_block_ovn =

Line 3352: hxc_time_building_blocks DAY

3348: detail.approval_style_id, detail.date_from, detail.date_to,
3349: detail.comment_text, detail.parent_building_block_ovn,
3350: 'N' NEW, 'N' changed
3351: FROM hxc_time_building_blocks detail,
3352: hxc_time_building_blocks DAY
3353: WHERE DAY.parent_building_block_id =
3354: p_timecard_rec.timecard_bb_id
3355: AND DAY.parent_building_block_ovn =
3356: p_timecard_rec.timecard_ovn

Line 5538: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS

5534:
5535: function check_valid_calc_date_accrual(p_resource_id NUMBER, p_calculate_date DATE) return varchar2
5536: is
5537:
5538: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
5539: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
5540:
5541: l_emp_hire_date date;
5542: