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.HXT_HXC_RETRIEVAL_PROCESS dependencies on HXC_BLD_BLK_INFO_TYPES

Line 3599: hxc_bld_blk_info_types bbit,

3595: FROM hxc_mapping_components mc,
3596: hxc_mapping_comp_usages mcu,
3597: hxc_mappings m,
3598: hxc_deposit_processes dp,
3599: hxc_bld_blk_info_types bbit,
3600: hxc_bld_blk_info_type_usages bbui
3601: WHERE dp.mapping_id = m.mapping_id
3602: AND dp.deposit_process_id = p_deposit_process_id --AI3
3603: AND m.mapping_id = mcu.mapping_id

Line 3616: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;

3612: l_attribute_index BINARY_INTEGER := 0;
3613: l_proc VARCHAR2 (70) := 'BUILD_ATTRIBUTES';
3614: l_exception EXCEPTION;
3615: l_deposit_process_id NUMBER;
3616: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
3617: l_segment hxc_mapping_components.SEGMENT%TYPE;
3618: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
3619: -- Bug 8486310
3620: -- The below variables for AN Id calculation

Line 3618: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

3614: l_exception EXCEPTION;
3615: l_deposit_process_id NUMBER;
3616: l_attribute_category hxc_bld_blk_info_types.bld_blk_info_type%TYPE;
3617: l_segment hxc_mapping_components.SEGMENT%TYPE;
3618: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
3619: -- Bug 8486310
3620: -- The below variables for AN Id calculation
3621: l_bbit hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
3622: l_hours_type VARCHAR2(50);

Line 3621: l_bbit hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;

3617: l_segment hxc_mapping_components.SEGMENT%TYPE;
3618: l_bld_blk_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
3619: -- Bug 8486310
3620: -- The below variables for AN Id calculation
3621: l_bbit hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
3622: l_hours_type VARCHAR2(50);
3623: BEGIN
3624: SELECT dp.deposit_process_id
3625: INTO l_deposit_process_id

Line 3634: FROM hxc_bld_blk_info_types

3630: -- Bug 8486310
3631: -- Pretty sure that this would return only one value, so no need of a cursor.
3632: SELECT bld_blk_info_type_id
3633: INTO l_bbit
3634: FROM hxc_bld_blk_info_types
3635: WHERE bld_blk_info_type = 'ALTERNATE NAME IDENTIFIERS';
3636:
3637: l_attributes.DELETE;
3638: l_attribute := p_detail_attributes.FIRST;