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 468: l_approval_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;

464: l_dummy varchar2(15);
465: l_proc VARCHAR2(50);
466:
467: l_set_more_period VARCHAR2(1);
468: l_approval_status HXC_TIME_BUILDING_BLOCKS.APPROVAL_STATUS%TYPE;
469:
470: -- New Fields.
471: l_assignment_processed_periods periods;
472: l_index number;

Line 484: FROM hxc_time_building_blocks

480: IS
481: SELECT START_TIME,
482: STOP_TIME,
483: APPROVAL_STATUS
484: FROM hxc_time_building_blocks
485: WHERE SCOPE = 'TIMECARD'
486: AND DATE_TO = hr_general.end_of_time
487: AND RESOURCE_ID = p_resource_id
488: AND RESOURCE_TYPE = p_resource_type

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

1001: IF g_debug THEN
1002: hr_utility.set_location (g_package||l_proc, 70);
1003: END IF;
1004: -- For this period we need not check whether its archived or not, as this is an existing period.
1005: -- Existing periods are found from hxc_time_building_blocks table, which means the data is
1006: -- present in the online tables.
1007:
1008: --add timecard row
1009: IF (l_approval_status NOT IN ('ERROR')) THEN

Line 1613: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,

1609: END get_period_list;
1610:
1611:
1612: FUNCTION get_assignment_periods(
1613: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE,
1614: p_period_start_date IN DATE DEFAULT SYSDATE -- 12387815
1615: )
1616: RETURN periods
1617: IS

Line 1783: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE

1779:
1780:
1781:
1782: PROCEDURE init_globals(
1783: p_resource_id IN hxc_time_building_blocks.resource_id%TYPE
1784: )
1785: IS
1786: l_assignment_index NUMBER;
1787: l_start_date DATE;

Line 2255: FROM hxc_time_building_blocks

2251: ,'N' CHANGED
2252: ,'N' PROCESS
2253: ,APPLICATION_SET_ID
2254: ,TRANSLATION_DISPLAY_KEY
2255: FROM hxc_time_building_blocks
2256: where time_building_block_id = p_timecard_id
2257: and resource_id = p_resource_id
2258: and scope = 'TIMECARD';
2259: --and date_to = hr_general.end_of_time;

Line 2292: FROM hxc_time_building_blocks

2288: ,'N' CHANGED
2289: ,'N' PROCESS
2290: ,APPLICATION_SET_ID
2291: ,TRANSLATION_DISPLAY_KEY
2292: FROM hxc_time_building_blocks
2293: WHERE resource_id = p_resource_id
2294: AND parent_building_block_id = p_parent_building_block_id
2295: AND parent_building_block_ovn = p_parent_ovn
2296: AND SCOPE = 'DAY';

Line 2328: FROM hxc_time_building_blocks

2324: ,'N' CHANGED
2325: ,'N' PROCESS
2326: ,APPLICATION_SET_ID
2327: ,TRANSLATION_DISPLAY_KEY
2328: FROM hxc_time_building_blocks
2329: WHERE resource_id = p_resource_id
2330: AND parent_building_block_id = p_parent_building_block_id
2331: AND parent_building_block_ovn = p_parent_ovn
2332: AND SCOPE = 'DETAIL'

Line 2385: from hxc_time_building_blocks detail,

2381: where a.time_attribute_id = au.time_attribute_id
2382: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2383: and (au.time_building_block_id,au.time_building_block_ovn) in
2384: (select detail.time_building_block_id,detail.object_version_number
2385: from hxc_time_building_blocks detail,
2386: hxc_time_building_blocks day
2387: where day.time_building_block_id = detail.parent_building_block_id
2388: and day.object_version_number = detail.parent_building_block_ovn
2389: and day.scope = 'DAY'

Line 2386: hxc_time_building_blocks day

2382: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2383: and (au.time_building_block_id,au.time_building_block_ovn) in
2384: (select detail.time_building_block_id,detail.object_version_number
2385: from hxc_time_building_blocks detail,
2386: hxc_time_building_blocks day
2387: where day.time_building_block_id = detail.parent_building_block_id
2388: and day.object_version_number = detail.parent_building_block_ovn
2389: and day.scope = 'DAY'
2390: and detail.resource_id = l_resource_id

Line 2446: from hxc_time_building_blocks day

2442: where a.time_attribute_id = au.time_attribute_id
2443: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2444: and (au.time_building_block_id,au.time_building_block_ovn) in
2445: (select day.time_building_block_id,day.object_version_number
2446: from hxc_time_building_blocks day
2447: where -- day.date_to = hr_general.end_of_time
2448: day.scope = 'DAY'
2449: and day.parent_building_block_id = timecard_id
2450: and day.parent_building_block_ovn = timecard_ovn

Line 2501: from hxc_time_building_blocks htbb

2497: where a.time_attribute_id = au.time_attribute_id
2498: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2499: and (au.time_building_block_id,au.time_building_block_ovn) in
2500: (select time_building_block_id,object_version_number
2501: from hxc_time_building_blocks htbb
2502: where --htbb.date_to = hr_general.end_of_time
2503: htbb.scope = 'TIMECARD'
2504: and htbb.time_building_block_id = timecard_id
2505: and htbb.object_version_number = timecard_ovn

Line 2556: hxc_time_building_blocks htbb

2552: ,au.time_building_block_ovn BUILDING_BLOCK_OVN
2553: from hxc_bld_blk_info_types bbit,
2554: hxc_time_attribute_usages au,
2555: hxc_time_attributes a,
2556: hxc_time_building_blocks htbb
2557: where a.time_attribute_id = au.time_attribute_id
2558: and a.bld_blk_info_type_id = bbit.bld_blk_info_type_id
2559: and au.time_building_block_id = htbb.time_building_block_id
2560: and au.time_building_block_ovn = htbb.object_version_number

Line 2916: FROM hxc_time_building_blocks app

2912: , fad.program_id
2913: , fad.request_id
2914: , fad.automatically_added_flag
2915: , fad.category_id
2916: FROM hxc_time_building_blocks app
2917: ,hxc_tc_ap_links htal
2918: ,hxc_timecard_summary hts
2919: ,fnd_attached_documents fad
2920: WHERE app.scope = 'APPLICATION_PERIOD'