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 237: (p_block_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 238: ,p_block_ovn in hxc_time_building_blocks.object_version_number%type

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

Line 241: from hxc_time_building_blocks tbb

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

Line 276: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 277: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type

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

Line 298: ,p_parent_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 299: ,p_parent_ovn in hxc_time_building_blocks.object_version_number%type

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

Line 345: ,p_parent_block_id in hxc_time_building_blocks.time_building_block_id%type

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

Line 414: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

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

Line 415: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

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

Line 419: (p_time_building_block_id in HXC_TIME_BUILDING_BLOCKS.TIME_BUILDING_BLOCK_ID%TYPE

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

Line 420: ,p_time_building_block_ovn in HXC_TIME_BUILDING_BLOCKS.OBJECT_VERSION_NUMBER%TYPE

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

Line 423: from hxc_time_building_blocks

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