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

Line 239: (p_block_id in hxc_time_building_blocks.time_building_block_id%type

235: (p_block in HXC_BLOCK_TYPE)
236: return BOOLEAN is
237:
238: cursor c_existing
239: (p_block_id in hxc_time_building_blocks.time_building_block_id%type
240: ,p_block_ovn in hxc_time_building_blocks.object_version_number%type
241: ) is
242: select 'Y'
243: from hxc_time_building_blocks tbb

Line 240: ,p_block_ovn in hxc_time_building_blocks.object_version_number%type

236: return BOOLEAN is
237:
238: cursor c_existing
239: (p_block_id in hxc_time_building_blocks.time_building_block_id%type
240: ,p_block_ovn in hxc_time_building_blocks.object_version_number%type
241: ) is
242: select 'Y'
243: from hxc_time_building_blocks tbb
244: where tbb.time_building_block_id = p_block_id

Line 243: from hxc_time_building_blocks tbb

239: (p_block_id in hxc_time_building_blocks.time_building_block_id%type
240: ,p_block_ovn in hxc_time_building_blocks.object_version_number%type
241: ) is
242: select 'Y'
243: from hxc_time_building_blocks tbb
244: where tbb.time_building_block_id = p_block_id
245: and tbb.object_version_number = p_block_ovn;
246:
247: l_dummy varchar2(1);

Line 278: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type

274: End is_detail_block;
275:
276: Function is_parent_block
277: (p_block in HXC_BLOCK_TYPE
278: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
279: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
280: ,p_check_id in boolean
281: ) return pls_integer is
282: Begin

Line 279: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type

275:
276: Function is_parent_block
277: (p_block in HXC_BLOCK_TYPE
278: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
279: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
280: ,p_check_id in boolean
281: ) return pls_integer is
282: Begin
283:

Line 300: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type

296: End is_parent_block;
297:
298: Function is_parent_block
299: (p_block in HXC_BLOCK_TYPE
300: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
301: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
302: ) return BOOLEAN is
303:
304: Begin

Line 301: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type

297:
298: Function is_parent_block
299: (p_block in HXC_BLOCK_TYPE
300: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type
301: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type
302: ) return BOOLEAN is
303:
304: Begin
305: if(is_parent_block(p_block,p_parent_id,p_parent_ovn,true)=0) then

Line 347: ,p_parent_block_id in hxc_time_building_blocks.time_building_block_id%type

343: End is_updated_block;
344:
345: Function parent_has_changed
346: (p_blocks in HXC_BLOCK_TABLE_TYPE
347: ,p_parent_block_id in hxc_time_building_blocks.time_building_block_id%type
348: ) return BOOLEAN is
349:
350: l_index number;
351: l_parent_changed boolean := false;

Line 416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

412:
413: end date_value;
414:
415: Function build_block
416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
418: ) return HXC_BLOCK_TYPE is
419:
420: cursor c_block

Line 417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

413: end date_value;
414:
415: Function build_block
416: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
418: ) return HXC_BLOCK_TYPE is
419:
420: cursor c_block
421: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

Line 421: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

417: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
418: ) return HXC_BLOCK_TYPE is
419:
420: cursor c_block
421: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
422: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
423: ) is
424: select *
425: from hxc_time_building_blocks

Line 422: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

418: ) return HXC_BLOCK_TYPE is
419:
420: cursor c_block
421: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
422: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
423: ) is
424: select *
425: from hxc_time_building_blocks
426: where time_building_block_id = p_time_building_block_id

Line 425: from hxc_time_building_blocks

421: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE
422: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE
423: ) is
424: select *
425: from hxc_time_building_blocks
426: where time_building_block_id = p_time_building_block_id
427: and object_version_number = p_time_building_block_ovn;
428:
429: