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_OBJECT_LEVELS

Line 885: from ecx_object_levels eol,

881: select objectlevel_id,
882: object_level,
883: object_level_name,
884: parent_level
885: from ecx_object_levels eol,
886: ecx_mappings em
887: where eol.map_id = p_map_id
888: and eol.map_id = em.map_id
889: and eol.object_id = 1

Line 896: --dummy data for g_source_levels can be gotten from ecx_object_levels

892:
893: begin
894:
895: -- we need load dummy data for g_source, g_target, g_source_levels
896: --dummy data for g_source_levels can be gotten from ecx_object_levels
897: for c_level_zero in get_level_zero(p_map_id=>g_map_id)
898: loop
899: -- should return only one match
900: ecx_utils.g_source_levels(0).level := c_level_zero.object_level;

Line 949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,

945:
946: i_method_name varchar2(2000) := 'ecx_utils.load_mappings';
947:
948: /* TYPE target_record
949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,
950: target_level ecx_object_levels.object_level%TYPE,
951: target_level_name ecx_object_levels.object_level_name%TYPE,
952: parent_level ecx_object_levels.parent_level%TYPE);
953:

Line 950: target_level ecx_object_levels.object_level%TYPE,

946: i_method_name varchar2(2000) := 'ecx_utils.load_mappings';
947:
948: /* TYPE target_record
949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,
950: target_level ecx_object_levels.object_level%TYPE,
951: target_level_name ecx_object_levels.object_level_name%TYPE,
952: parent_level ecx_object_levels.parent_level%TYPE);
953:
954: TYPE target_record_table is TABLE of target_record index by BINARY_INTEGER;

Line 951: target_level_name ecx_object_levels.object_level_name%TYPE,

947:
948: /* TYPE target_record
949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,
950: target_level ecx_object_levels.object_level%TYPE,
951: target_level_name ecx_object_levels.object_level_name%TYPE,
952: parent_level ecx_object_levels.parent_level%TYPE);
953:
954: TYPE target_record_table is TABLE of target_record index by BINARY_INTEGER;
955: targ_rec_table target_record_table;

Line 952: parent_level ecx_object_levels.parent_level%TYPE);

948: /* TYPE target_record
949: is RECORD (target_level_id ecx_object_levels.objectlevel_id%TYPE,
950: target_level ecx_object_levels.object_level%TYPE,
951: target_level_name ecx_object_levels.object_level_name%TYPE,
952: parent_level ecx_object_levels.parent_level%TYPE);
953:
954: TYPE target_record_table is TABLE of target_record index by BINARY_INTEGER;
955: targ_rec_table target_record_table;
956: */

Line 957: TYPE t_target_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;

953:
954: TYPE target_record_table is TABLE of target_record index by BINARY_INTEGER;
955: targ_rec_table target_record_table;
956: */
957: TYPE t_target_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
958: TYPE t_target_level is TABLE of ecx_object_levels.object_level%TYPE;
959: TYPE t_target_level_name is TABLE of ecx_object_levels.object_level_name%TYPE;
960: TYPE t_parent_level is TABLE of ecx_object_levels.parent_level%TYPE;
961:

Line 958: TYPE t_target_level is TABLE of ecx_object_levels.object_level%TYPE;

954: TYPE target_record_table is TABLE of target_record index by BINARY_INTEGER;
955: targ_rec_table target_record_table;
956: */
957: TYPE t_target_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
958: TYPE t_target_level is TABLE of ecx_object_levels.object_level%TYPE;
959: TYPE t_target_level_name is TABLE of ecx_object_levels.object_level_name%TYPE;
960: TYPE t_parent_level is TABLE of ecx_object_levels.parent_level%TYPE;
961:
962: v_target_level_id t_target_level_id;

Line 959: TYPE t_target_level_name is TABLE of ecx_object_levels.object_level_name%TYPE;

955: targ_rec_table target_record_table;
956: */
957: TYPE t_target_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
958: TYPE t_target_level is TABLE of ecx_object_levels.object_level%TYPE;
959: TYPE t_target_level_name is TABLE of ecx_object_levels.object_level_name%TYPE;
960: TYPE t_parent_level is TABLE of ecx_object_levels.parent_level%TYPE;
961:
962: v_target_level_id t_target_level_id;
963: v_target_level t_target_level;

Line 960: TYPE t_parent_level is TABLE of ecx_object_levels.parent_level%TYPE;

956: */
957: TYPE t_target_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;
958: TYPE t_target_level is TABLE of ecx_object_levels.object_level%TYPE;
959: TYPE t_target_level_name is TABLE of ecx_object_levels.object_level_name%TYPE;
960: TYPE t_parent_level is TABLE of ecx_object_levels.parent_level%TYPE;
961:
962: v_target_level_id t_target_level_id;
963: v_target_level t_target_level;
964: v_target_level_name t_target_level_name;

Line 977: from ecx_object_levels eol,

973: select objectlevel_id target_level_id,
974: object_level target_level,
975: object_level_name target_level_name,
976: parent_level
977: from ecx_object_levels eol,
978: ecx_mappings em
979: where eol.map_id = p_map_id
980: and eol.map_id = em.map_id
981: and eol.object_id = em.object_id_target

Line 987: is RECORD (source_level ecx_object_levels.object_level%TYPE,

983: */
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

Line 989: source_level_id ecx_object_levels.objectlevel_id%TYPE,

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: );
993:

Line 997: TYPE t_source_level is TABLE of ecx_object_levels.object_level%TYPE;

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;
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;

Line 999: TYPE t_source_level_id is TABLE of ecx_object_levels.objectlevel_id%TYPE;

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:
1003:

Line 1024: ecx_object_levels eol

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
1028: and elm.source_level_id = eol.objectlevel_id;

Line 1038: from ecx_object_levels

1034: select object_level source_level,
1035: object_level_name source_level_name,
1036: parent_level,
1037: objectlevel_id
1038: from ecx_object_levels
1039: where objectlevel_id = p_source_level_id
1040: and map_id = p_map_id;
1041:
1042:

Line 1086: from ecx_object_levels eol,

1082: v_target_level,
1083: v_target_level_name,
1084: v_parent_level
1085:
1086: from ecx_object_levels eol,
1087: ecx_mappings em
1088: where eol.map_id = i_map_id
1089: and eol.map_id = em.map_id
1090: and eol.object_id = em.object_id_target

Line 1145: ecx_object_levels eol

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
1149: and elm.source_level_id = eol.objectlevel_id;

Line 2062: object_level ecx_object_levels.object_level%TYPE,

2058: i_method_name varchar2(2000) := 'ecx_utils.get_tran_stage_data';
2059:
2060: /* TYPE stage_data_record is RECORD (
2061: transtage_id ecx_tran_stage_data.transtage_id%TYPE,
2062: object_level ecx_object_levels.object_level%TYPE,
2063: objectlevel_id ecx_tran_stage_data.objectlevel_id%TYPE,
2064: stage ecx_tran_stage_data.stage%TYPE,
2065: object_direction ecx_tran_stage_data.object_direction%TYPE,
2066: seq_number ecx_tran_stage_data.seq_number%TYPE,

Line 2139: TYPE t_object_level is TABLE of ecx_object_levels.object_level%TYPE;

2135: TYPE stage_data_table is TABLE of stage_data_record index by BINARY_INTEGER;
2136: i_stage_data stage_data_table;
2137: */
2138: TYPE t_transtage_id is TABLE of ecx_tran_stage_data.transtage_id%TYPE;
2139: TYPE t_object_level is TABLE of ecx_object_levels.object_level%TYPE;
2140: TYPE t_objectlevel_id is TABLE of ecx_tran_stage_data.objectlevel_id%TYPE;
2141: TYPE t_stage is TABLE of ecx_tran_stage_data.stage%TYPE;
2142: TYPE t_object_direction is TABLE of ecx_tran_stage_data.object_direction%TYPE;
2143: TYPE t_seq_number is TABLE of ecx_tran_stage_data.seq_number%TYPE;

Line 2368: ecx_object_levels b

2364: operand6_pos,
2365: operand6_direction,
2366: operand6_constant
2367: from ecx_tran_stage_data a,
2368: ecx_object_levels b
2369: where a.map_id = p_map_id
2370: and a.map_id = b.map_id
2371: and a.objectlevel_id = b.objectlevel_id
2372: and action_type <> 10

Line 2537: ecx_object_levels b

2533: v_operand6_constant
2534:
2535:
2536: from ecx_tran_stage_data a,
2537: ecx_object_levels b
2538: where a.map_id = i_map_id
2539: and a.map_id = b.map_id
2540: and a.objectlevel_id = b.objectlevel_id
2541: and action_type <> 10

Line 3075: FROM ecx_object_levels

3071: if (l_procedureEnabled) then
3072: ecx_debug.push(i_method_name);
3073: end if;
3074: SELECT object_level_name INTO l_root_node
3075: FROM ecx_object_levels
3076: WHERE map_id=v_map_id and object_level=0 and object_id=1;
3077:
3078: IF (v_attribute_id = 0) THEN
3079: return l_root_node;

Line 3086: select objectlevel_id from ecx_object_levels

3082: SELECT attribute_name,attribute_id,parent_attribute_id
3083: INTO l_attribute_name,l_attribute_id,l_parent_id
3084: FROM ecx_object_attributes
3085: WHERE map_id = v_map_id and objectlevel_id in(
3086: select objectlevel_id from ecx_object_levels
3087: WHERE map_id=v_map_id and object_id = 1) AND attribute_id=v_attribute_id;
3088:
3089: l_node_path := NULL;
3090:

Line 3097: select objectlevel_id from ecx_object_levels

3093: SELECT attribute_name,attribute_id,parent_attribute_id
3094: INTO l_attribute_name,l_attribute_id,l_parent_id
3095: FROM ecx_object_attributes
3096: WHERE map_id = v_map_id and objectlevel_id in(
3097: select objectlevel_id from ecx_object_levels
3098: WHERE map_id=v_map_id and object_id = 1) AND attribute_id=l_parent_id;
3099:
3100: IF (l_node_path IS NULL ) THEN
3101: l_node_path := l_attribute_name;