DBA Data[Home] [Help]

APPS.ECX_UTILS dependencies on ECX_MAPPINGS

Line 886: ecx_mappings em

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
890: and eol.object_level = 0

Line 978: ecx_mappings em

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
982: order by target_level;

Line 1087: ecx_mappings em

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
1091: order by target_level;

Line 1432: from ecx_mappings em

1428: select em.ecx_major_version,
1429: em.ecx_minor_version
1430: into i_major_version,
1431: i_minor_version
1432: from ecx_mappings em
1433: where em.map_id = i_map_id;
1434: exception
1435: when others then
1436: if(l_unexpectedEnabled) then

Line 1656: select map_code into i_map_code from ecx_mappings where map_id=i_map_id;

1652: end if;
1653: raise ecx_utils.program_exit;
1654: end if;
1655: /* Find the map code for bug 1939677 */
1656: select map_code into i_map_code from ecx_mappings where map_id=i_map_id;
1657:
1658: /* Try to find if it is an Inbound or Outbound Txn */
1659: begin
1660: SELECT object_id_source,

Line 1664: FROM ecx_mappings em

1660: SELECT object_id_source,
1661: object_id_target
1662: INTO g_source_object_id,
1663: g_target_object_id
1664: FROM ecx_mappings em
1665: WHERE em.map_id = i_map_id;
1666: exception
1667: when others then
1668: ecx_debug.setErrorInfo(1, 30, 'ECX_MAPPINGS_NOT_FOUND', 'MAP_ID', i_map_id);

Line 1668: ecx_debug.setErrorInfo(1, 30, 'ECX_MAPPINGS_NOT_FOUND', 'MAP_ID', i_map_id);

1664: FROM ecx_mappings em
1665: WHERE em.map_id = i_map_id;
1666: exception
1667: when others then
1668: ecx_debug.setErrorInfo(1, 30, 'ECX_MAPPINGS_NOT_FOUND', 'MAP_ID', i_map_id);
1669: if(l_unexpectedEnabled) then
1670: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAPPINGS_NOT_FOUND',i_method_name,
1671: 'MAP_ID', i_map_id);
1672: end if;

Line 1670: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAPPINGS_NOT_FOUND',i_method_name,

1666: exception
1667: when others then
1668: ecx_debug.setErrorInfo(1, 30, 'ECX_MAPPINGS_NOT_FOUND', 'MAP_ID', i_map_id);
1669: if(l_unexpectedEnabled) then
1670: ecx_debug.log(l_unexpected,'ECX', 'ECX_MAPPINGS_NOT_FOUND',i_method_name,
1671: 'MAP_ID', i_map_id);
1672: end if;
1673: raise ecx_utils.program_exit;
1674: end;