APPS.HXC_TIME_ENTRY_RULES_UTILS_PKG dependencies on HXC_TIME_BUILDING_BLOCKS

Line 1603: from hxc_time_building_blocks tbbdet,

1599: cursor range_details_of_day(p_day_date in DATE,p_resource_id in NUMBER)
1600: IS
1601: select /*+ ORDERED *
1602: tbbdet.start_time, tbbdet.stop_time
1603: from hxc_time_building_blocks tbbdet,
1604: hxc_time_building_blocks tbbday,
1605: hxc_time_building_blocks tbbtc
1606: where
1607: tbbtc.scope = 'TIMECARD'

Line 1604: hxc_time_building_blocks tbbday,

1600: IS
1601: select /*+ ORDERED *
1602: tbbdet.start_time, tbbdet.stop_time
1603: from hxc_time_building_blocks tbbdet,
1604: hxc_time_building_blocks tbbday,
1605: hxc_time_building_blocks tbbtc
1606: where
1607: tbbtc.scope = 'TIMECARD'
1608: and tbbdet.scope = 'DETAIL'

Line 1605: hxc_time_building_blocks tbbtc

1601: select /*+ ORDERED *
1602: tbbdet.start_time, tbbdet.stop_time
1603: from hxc_time_building_blocks tbbdet,
1604: hxc_time_building_blocks tbbday,
1605: hxc_time_building_blocks tbbtc
1606: where
1607: tbbtc.scope = 'TIMECARD'
1608: and tbbdet.scope = 'DETAIL'
1609: and tbbdet.type = 'RANGE'

Line 1631: INDEX(tbbday HXC_TIME_BUILDING_BLOCKS_FK2)

1627: CURSOR range_details_of_day(p_day_date IN DATE,
1628: p_resource_id IN NUMBER)
1629: IS
1630: SELECT /*+ LEADING(tbbday)
1631: INDEX(tbbday HXC_TIME_BUILDING_BLOCKS_FK2)
1632: INDEX(tbbdet HXC_TIME_BUILDING_BLOCKS_FK3)
1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */
1634: tbbdet.start_time,
1635: tbbdet.stop_time

Line 1632: INDEX(tbbdet HXC_TIME_BUILDING_BLOCKS_FK3)

1628: p_resource_id IN NUMBER)
1629: IS
1630: SELECT /*+ LEADING(tbbday)
1631: INDEX(tbbday HXC_TIME_BUILDING_BLOCKS_FK2)
1632: INDEX(tbbdet HXC_TIME_BUILDING_BLOCKS_FK3)
1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */
1634: tbbdet.start_time,
1635: tbbdet.stop_time
1636: FROM hxc_time_building_blocks tbbdet,

Line 1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */

1629: IS
1630: SELECT /*+ LEADING(tbbday)
1631: INDEX(tbbday HXC_TIME_BUILDING_BLOCKS_FK2)
1632: INDEX(tbbdet HXC_TIME_BUILDING_BLOCKS_FK3)
1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */
1634: tbbdet.start_time,
1635: tbbdet.stop_time
1636: FROM hxc_time_building_blocks tbbdet,
1637: hxc_time_building_blocks tbbday,

Line 1636: FROM hxc_time_building_blocks tbbdet,

1632: INDEX(tbbdet HXC_TIME_BUILDING_BLOCKS_FK3)
1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */
1634: tbbdet.start_time,
1635: tbbdet.stop_time
1636: FROM hxc_time_building_blocks tbbdet,
1637: hxc_time_building_blocks tbbday,
1638: hxc_time_building_blocks tbbtc
1639: WHERE tbbtc.scope = 'TIMECARD'
1640: AND tbbdet.scope = 'DETAIL'

Line 1637: hxc_time_building_blocks tbbday,

1633: INDEX(tbbtc HXC_TIME_BUILDING_BLOCKS_PK) */
1634: tbbdet.start_time,
1635: tbbdet.stop_time
1636: FROM hxc_time_building_blocks tbbdet,
1637: hxc_time_building_blocks tbbday,
1638: hxc_time_building_blocks tbbtc
1639: WHERE tbbtc.scope = 'TIMECARD'
1640: AND tbbdet.scope = 'DETAIL'
1641: AND tbbdet.type = 'RANGE'

Line 1638: hxc_time_building_blocks tbbtc

1634: tbbdet.start_time,
1635: tbbdet.stop_time
1636: FROM hxc_time_building_blocks tbbdet,
1637: hxc_time_building_blocks tbbday,
1638: hxc_time_building_blocks tbbtc
1639: WHERE tbbtc.scope = 'TIMECARD'
1640: AND tbbdet.scope = 'DETAIL'
1641: AND tbbdet.type = 'RANGE'
1642: AND tbbday.scope = 'DAY'

Line 2490: hxc_time_building_blocks tbb_day,

2486: SELECT NVL(SUM(SUM(NVL(hxc_time_category_utils_pkg.category_detail_hrs( tbb_detail.time_building_block_id,
2487: tbb_detail.object_version_number),0)) ),0)
2488: FROM
2489: hxc_timecard_summary ts,
2490: hxc_time_building_blocks tbb_day,
2491: hxc_time_building_blocks tbb_detail
2492: WHERE
2493: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2494: ts.timecard_id = tbb_day.parent_building_block_id and

Line 2491: hxc_time_building_blocks tbb_detail

2487: tbb_detail.object_version_number),0)) ),0)
2488: FROM
2489: hxc_timecard_summary ts,
2490: hxc_time_building_blocks tbb_day,
2491: hxc_time_building_blocks tbb_detail
2492: WHERE
2493: tbb_day.time_building_block_id = tbb_detail.parent_building_block_id and
2494: ts.timecard_id = tbb_day.parent_building_block_id and
2495: tbb_detail.scope='DETAIL' and

Line 2981: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

2977:
2978: END asg_status_id;
2979:
2980: PROCEDURE tc_edit_allowed (
2981: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2982: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2983: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2984: ,p_edit_allowed IN OUT nocopy VARCHAR2
2985: ) IS

Line 2982: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

2978: END asg_status_id;
2979:
2980: PROCEDURE tc_edit_allowed (
2981: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
2982: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
2983: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
2984: ,p_edit_allowed IN OUT nocopy VARCHAR2
2985: ) IS
2986:

Line 3000: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

2996:
2997: end tc_edit_allowed;
2998:
2999: PROCEDURE tc_edit_allowed (
3000: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3001: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3002: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
3003: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
3004: ,p_edit_allowed IN OUT nocopy VARCHAR2

Line 3001: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

2997: end tc_edit_allowed;
2998:
2999: PROCEDURE tc_edit_allowed (
3000: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3001: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3002: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
3003: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
3004: ,p_edit_allowed IN OUT nocopy VARCHAR2
3005: ) is

Line 3002: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE

2998:
2999: PROCEDURE tc_edit_allowed (
3000: p_timecard_id HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
3001: ,p_timecard_ovn HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
3002: ,p_timecard_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE
3003: ,p_edit_allowed_preference HXC_PREF_HIERARCHIES.ATTRIBUTE1%TYPE
3004: ,p_edit_allowed IN OUT nocopy VARCHAR2
3005: ) is
3006:

Line 3022: l_tc_status hxc_time_building_blocks.approval_status%TYPE;

3018: t.status = 'SUCCESS' );
3019:
3020: l_proc VARCHAR2(72);
3021:
3022: l_tc_status hxc_time_building_blocks.approval_status%TYPE;
3023:
3024: l_dummy NUMBER(1);
3025:
3026: BEGIN

Line 3406: FROM hxc_time_building_blocks detail,

3402: detail.resource_id, detail.resource_type,
3403: detail.approval_style_id, detail.date_from, detail.date_to,
3404: detail.comment_text, detail.parent_building_block_ovn,
3405: 'N' NEW, 'N' changed
3406: FROM hxc_time_building_blocks detail,
3407: hxc_time_building_blocks DAY
3408: WHERE DAY.parent_building_block_id =
3409: p_timecard_rec.timecard_bb_id
3410: AND DAY.parent_building_block_ovn =

Line 3407: hxc_time_building_blocks DAY

3403: detail.approval_style_id, detail.date_from, detail.date_to,
3404: detail.comment_text, detail.parent_building_block_ovn,
3405: 'N' NEW, 'N' changed
3406: FROM hxc_time_building_blocks detail,
3407: hxc_time_building_blocks DAY
3408: WHERE DAY.parent_building_block_id =
3409: p_timecard_rec.timecard_bb_id
3410: AND DAY.parent_building_block_ovn =
3411: p_timecard_rec.timecard_ovn

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

5631:
5632: function check_valid_calc_date_accrual(p_resource_id NUMBER, p_calculate_date DATE) return varchar2
5633: is
5634:
5635: cursor emp_hire_info(p_resource_id hxc_time_building_blocks.resource_id%TYPE) IS
5636: select date_start from per_periods_of_service where person_id=p_resource_id order by date_start desc;
5637:
5638: l_emp_hire_date date;
5639: