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.ECX_UTILS dependencies on ECX_LEVEL_MAPPINGS

Line 988: level_mapping_id ecx_level_mappings.level_mapping_id%TYPE,

984: /*
985:
986: TYPE target_source_record
987: is RECORD (source_level ecx_object_levels.object_level%TYPE,
988: level_mapping_id ecx_level_mappings.level_mapping_id%TYPE,
989: source_level_id ecx_object_levels.objectlevel_id%TYPE,
990: source_element_id ecx_level_mappings.source_element_id%TYPE,
991: target_element_id ecx_level_mappings.target_element_id%TYPE
992: );

Line 990: source_element_id ecx_level_mappings.source_element_id%TYPE,

986: TYPE target_source_record
987: is RECORD (source_level ecx_object_levels.object_level%TYPE,
988: level_mapping_id ecx_level_mappings.level_mapping_id%TYPE,
989: source_level_id ecx_object_levels.objectlevel_id%TYPE,
990: source_element_id ecx_level_mappings.source_element_id%TYPE,
991: target_element_id ecx_level_mappings.target_element_id%TYPE
992: );
993:
994: TYPE target_source_record_table is TABLE of target_source_record index by BINARY_INTEGER;

Line 991: target_element_id ecx_level_mappings.target_element_id%TYPE

987: is RECORD (source_level ecx_object_levels.object_level%TYPE,
988: level_mapping_id ecx_level_mappings.level_mapping_id%TYPE,
989: source_level_id ecx_object_levels.objectlevel_id%TYPE,
990: source_element_id ecx_level_mappings.source_element_id%TYPE,
991: target_element_id ecx_level_mappings.target_element_id%TYPE
992: );
993:
994: TYPE target_source_record_table is TABLE of target_source_record index by BINARY_INTEGER;
995: targ_src_rec_table target_source_record_table;

Line 998: TYPE t_level_mapping_id is TABLE of ecx_level_mappings.level_mapping_id%TYPE;

994: TYPE target_source_record_table is TABLE of target_source_record index by BINARY_INTEGER;
995: targ_src_rec_table target_source_record_table;
996: */
997: TYPE t_source_level is TABLE of ecx_object_levels.object_level%TYPE;
998: TYPE t_level_mapping_id is TABLE of ecx_level_mappings.level_mapping_id%TYPE;
999: TYPE t_source_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
1000: TYPE t_source_element_id is TABLE of ecx_level_mappings.source_element_id%TYPE;
1001: TYPE t_target_element_id is TABLE of ecx_level_mappings.target_element_id%TYPE;
1002:

Line 1000: TYPE t_source_element_id is TABLE of ecx_level_mappings.source_element_id%TYPE;

996: */
997: TYPE t_source_level is TABLE of ecx_object_levels.object_level%TYPE;
998: TYPE t_level_mapping_id is TABLE of ecx_level_mappings.level_mapping_id%TYPE;
999: TYPE t_source_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
1000: TYPE t_source_element_id is TABLE of ecx_level_mappings.source_element_id%TYPE;
1001: TYPE t_target_element_id is TABLE of ecx_level_mappings.target_element_id%TYPE;
1002:
1003:
1004: v_source_level t_source_level;

Line 1001: TYPE t_target_element_id is TABLE of ecx_level_mappings.target_element_id%TYPE;

997: TYPE t_source_level is TABLE of ecx_object_levels.object_level%TYPE;
998: TYPE t_level_mapping_id is TABLE of ecx_level_mappings.level_mapping_id%TYPE;
999: TYPE t_source_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
1000: TYPE t_source_element_id is TABLE of ecx_level_mappings.source_element_id%TYPE;
1001: TYPE t_target_element_id is TABLE of ecx_level_mappings.target_element_id%TYPE;
1002:
1003:
1004: v_source_level t_source_level;
1005: v_level_mapping_id t_level_mapping_id;

Line 1023: from ecx_level_mappings elm,

1019: level_mapping_id ,
1020: objectlevel_id source_level_id,
1021: source_element_id,
1022: target_element_id
1023: from ecx_level_mappings elm,
1024: ecx_object_levels eol
1025: where elm.target_level_id = p_target_id
1026: and elm.map_id = p_map_id
1027: and elm.map_id = eol.map_id

Line 1144: from ecx_level_mappings elm,

1140: v_source_level_id,
1141: v_source_element_id,
1142: v_target_element_id
1143:
1144: from ecx_level_mappings elm,
1145: ecx_object_levels eol
1146: where elm.target_level_id = v_target_level_id(j)
1147: and elm.map_id = i_map_id
1148: and elm.map_id = eol.map_id