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_MAPPING_UTILITIES dependencies on HXC_MAPPING_COMPONENTS

Line 83: , hxc_mapping_components mpc

79: , bbitu.building_block_category category
80: FROM
81: hxc_bld_blk_info_type_usages bbitu
82: , hxc_bld_blk_info_types bbit
83: , hxc_mapping_components mpc
84: , hxc_mapping_comp_usages mcu
85: , hxc_mappings map
86: WHERE map.mapping_id = p_mapping_id
87: AND

Line 1922: from hxc_mapping_components hmc,

1918: ) return varchar2 is
1919:
1920: cursor c_map is
1921: select hmc.segment
1922: from hxc_mapping_components hmc,
1923: hxc_bld_blk_info_types hit
1924: where hit.descriptive_flexfield_name = p_descriptive_flexfield_name
1925: and hit.bld_blk_info_type_id = hmc.bld_blk_info_type_id
1926: and hit.bld_blk_info_type = p_bld_blk_info_type

Line 1986: from hxc_mapping_components hmc

1982: ) return boolean is
1983:
1984: cursor c_map_ret is
1985: select distinct hmc.segment, hit.bld_blk_info_type
1986: from hxc_mapping_components hmc
1987: , hxc_mapping_comp_usages hmu
1988: , hxc_mappings hmp
1989: , hxc_retrieval_processes hrp
1990: , hxc_bld_blk_info_types hit

Line 2000: from hxc_mapping_components hmc

1996: and hmc.field_name = p_field_name;
1997:
1998: cursor c_map_dep is
1999: select distinct hmc.segment, hit.bld_blk_info_type
2000: from hxc_mapping_components hmc
2001: , hxc_mapping_comp_usages hmu
2002: , hxc_mappings hmp
2003: , hxc_deposit_processes hdp
2004: , hxc_bld_blk_info_types hit

Line 2065: p_segment out nocopy hxc_mapping_components.segment%TYPE,

2061:
2062:
2063: Procedure get_mapping_value(p_bld_blk_info_type in varchar2,
2064: p_field_name in varchar2,
2065: p_segment out nocopy hxc_mapping_components.segment%TYPE,
2066: p_bld_blk_info_type_id out nocopy hxc_mapping_components.bld_blk_info_type_id%TYPE ) is
2067:
2068: CURSOR csr_parse_mapping(p_bld_blk_info_type varchar2,p_field_name varchar2) IS
2069: SELECT segment

Line 2066: p_bld_blk_info_type_id out nocopy hxc_mapping_components.bld_blk_info_type_id%TYPE ) is

2062:
2063: Procedure get_mapping_value(p_bld_blk_info_type in varchar2,
2064: p_field_name in varchar2,
2065: p_segment out nocopy hxc_mapping_components.segment%TYPE,
2066: p_bld_blk_info_type_id out nocopy hxc_mapping_components.bld_blk_info_type_id%TYPE ) is
2067:
2068: CURSOR csr_parse_mapping(p_bld_blk_info_type varchar2,p_field_name varchar2) IS
2069: SELECT segment
2070: , bld_blk_info_type_id

Line 2071: FROM hxc_mapping_components_v

2067:
2068: CURSOR csr_parse_mapping(p_bld_blk_info_type varchar2,p_field_name varchar2) IS
2069: SELECT segment
2070: , bld_blk_info_type_id
2071: FROM hxc_mapping_components_v
2072: WHERE bld_blk_info_type = p_bld_blk_info_type
2073: AND field_name = p_field_name;
2074:
2075:

Line 2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;

2131: l_mapping_exists BOOLEAN := FALSE;
2132:
2133: l_exists VARCHAR2(1) := 'N';
2134:
2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;

Line 2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;

2132:
2133: l_exists VARCHAR2(1) := 'N';
2134:
2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;

Line 2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;

2133: l_exists VARCHAR2(1) := 'N';
2134:
2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;

Line 2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;

2134:
2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;

Line 2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;

2135: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;

Line 2140: l_segment1 hxc_mapping_components.segment%TYPE;

2136: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;

Line 2141: l_segment2 hxc_mapping_components.segment%TYPE;

2137: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;
2145:

Line 2142: l_segment3 hxc_mapping_components.segment%TYPE;

2138: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;
2145:
2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;

Line 2143: l_segment4 hxc_mapping_components.segment%TYPE;

2139: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;
2145:
2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
2147: l_field_name_outer varchar2(1000);

Line 2144: l_segment5 hxc_mapping_components.segment%TYPE;

2140: l_segment1 hxc_mapping_components.segment%TYPE;
2141: l_segment2 hxc_mapping_components.segment%TYPE;
2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;
2145:
2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
2147: l_field_name_outer varchar2(1000);
2148: l_field_value_outer varchar2(1000);

Line 2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;

2142: l_segment3 hxc_mapping_components.segment%TYPE;
2143: l_segment4 hxc_mapping_components.segment%TYPE;
2144: l_segment5 hxc_mapping_components.segment%TYPE;
2145:
2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
2147: l_field_name_outer varchar2(1000);
2148: l_field_value_outer varchar2(1000);
2149: l_segment_outer hxc_mapping_components.segment%TYPE;
2150:

Line 2149: l_segment_outer hxc_mapping_components.segment%TYPE;

2145:
2146: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
2147: l_field_name_outer varchar2(1000);
2148: l_field_value_outer varchar2(1000);
2149: l_segment_outer hxc_mapping_components.segment%TYPE;
2150:
2151: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
2152: l_field_name_inner varchar2(1000);
2153: l_field_value_inner varchar2(1000);

Line 2151: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;

2147: l_field_name_outer varchar2(1000);
2148: l_field_value_outer varchar2(1000);
2149: l_segment_outer hxc_mapping_components.segment%TYPE;
2150:
2151: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
2152: l_field_name_inner varchar2(1000);
2153: l_field_value_inner varchar2(1000);
2154: l_segment_inner hxc_mapping_components.segment%TYPE;
2155:

Line 2154: l_segment_inner hxc_mapping_components.segment%TYPE;

2150:
2151: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
2152: l_field_name_inner varchar2(1000);
2153: l_field_value_inner varchar2(1000);
2154: l_segment_inner hxc_mapping_components.segment%TYPE;
2155:
2156: l_ret_id hxc_retrieval_processes.retrieval_process_id%TYPE;
2157:
2158: l_query VARCHAR2(8000);

Line 3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;

3008: l_proc VARCHAR2(72);
3009:
3010: l_sum NUMBER(20,3); -- 12533942 Added add three decimal places to l_sum.
3011:
3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;

Line 3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;

3009:
3010: l_sum NUMBER(20,3); -- 12533942 Added add three decimal places to l_sum.
3011:
3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;

Line 3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;

3010: l_sum NUMBER(20,3); -- 12533942 Added add three decimal places to l_sum.
3011:
3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;

Line 3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;

3011:
3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;

Line 3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;

3012: l_bld_blk_info_type_id hxc_mapping_components.bld_blk_info_type_id%TYPE;
3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;

Line 3017: l_segment1 hxc_mapping_components.segment%TYPE;

3013: l_bld_blk_info_type_id2 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;

Line 3018: l_segment2 hxc_mapping_components.segment%TYPE;

3014: l_bld_blk_info_type_id3 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:

Line 3019: l_segment3 hxc_mapping_components.segment%TYPE;

3015: l_bld_blk_info_type_id4 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:
3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;

Line 3020: l_segment4 hxc_mapping_components.segment%TYPE;

3016: l_bld_blk_info_type_id5 hxc_mapping_components.bld_blk_info_type_id%TYPE;
3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:
3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;
3024:

Line 3021: l_segment5 hxc_mapping_components.segment%TYPE;

3017: l_segment1 hxc_mapping_components.segment%TYPE;
3018: l_segment2 hxc_mapping_components.segment%TYPE;
3019: l_segment3 hxc_mapping_components.segment%TYPE;
3020: l_segment4 hxc_mapping_components.segment%TYPE;
3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:
3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;
3024:
3025: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;

Line 3025: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;

3021: l_segment5 hxc_mapping_components.segment%TYPE;
3022:
3023: t_consolidated_info hxc_mapping_utilities.t_consolidated_info_1;
3024:
3025: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
3026: l_field_name_outer varchar2(1000);
3027: l_field_value_outer varchar2(1000);
3028: l_segment_outer hxc_mapping_components.segment%TYPE;
3029:

Line 3028: l_segment_outer hxc_mapping_components.segment%TYPE;

3024:
3025: l_bld_block_info_id_outer hxc_mapping_components.bld_blk_info_type_id%TYPE;
3026: l_field_name_outer varchar2(1000);
3027: l_field_value_outer varchar2(1000);
3028: l_segment_outer hxc_mapping_components.segment%TYPE;
3029:
3030: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
3031: l_field_name_inner varchar2(1000);
3032: l_field_value_inner varchar2(1000);

Line 3030: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;

3026: l_field_name_outer varchar2(1000);
3027: l_field_value_outer varchar2(1000);
3028: l_segment_outer hxc_mapping_components.segment%TYPE;
3029:
3030: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
3031: l_field_name_inner varchar2(1000);
3032: l_field_value_inner varchar2(1000);
3033: l_segment_inner hxc_mapping_components.segment%TYPE;
3034:

Line 3033: l_segment_inner hxc_mapping_components.segment%TYPE;

3029:
3030: l_bld_block_info_id_inner hxc_mapping_components.bld_blk_info_type_id%TYPE;
3031: l_field_name_inner varchar2(1000);
3032: l_field_value_inner varchar2(1000);
3033: l_segment_inner hxc_mapping_components.segment%TYPE;
3034:
3035:
3036: l_query VARCHAR2(8000);
3037: