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.CN_DIM_HIERARCHIES_PVT dependencies on CN_HIERARCHY_EDGES

Line 1136: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,

1132: (p_api_version IN NUMBER, -- required
1133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1136: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1137: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1138: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
1139: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
1140: --R12 MOAC Changes--Start

Line 1137: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

1133: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1134: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1135: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1136: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1137: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1138: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
1139: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
1140: --R12 MOAC Changes--Start
1141: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

Line 1141: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

1137: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1138: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
1139: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
1140: --R12 MOAC Changes--Start
1141: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
1142: --R12 MOAC Changes--End
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,

Line 1146: x_value_id OUT NOCOPY CN_HIERARCHY_EDGES.VALUE_ID%TYPE) IS

1142: --R12 MOAC Changes--End
1143: x_return_status OUT NOCOPY VARCHAR2,
1144: x_msg_count OUT NOCOPY NUMBER,
1145: x_msg_data OUT NOCOPY VARCHAR2,
1146: x_value_id OUT NOCOPY CN_HIERARCHY_EDGES.VALUE_ID%TYPE) IS
1147:
1148: l_api_name CONSTANT VARCHAR2(30) := 'Create_Edge';
1149: l_api_version CONSTANT NUMBER := 1.0;
1150: l_max_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');

Line 1291: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,

1287: (p_api_version IN NUMBER, -- required
1288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1291: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1292: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
1293: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1294: --R12 MOAC Changes--Start
1295: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

Line 1292: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,

1288: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1291: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1292: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
1293: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1294: --R12 MOAC Changes--Start
1295: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
1296: --R12 MOAC Changes--End

Line 1293: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

1289: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1291: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1292: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
1293: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1294: --R12 MOAC Changes--Start
1295: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
1296: --R12 MOAC Changes--End
1297: x_return_status OUT NOCOPY VARCHAR2,

Line 1295: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

1291: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
1292: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
1293: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
1294: --R12 MOAC Changes--Start
1295: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
1296: --R12 MOAC Changes--End
1297: x_return_status OUT NOCOPY VARCHAR2,
1298: x_msg_count OUT NOCOPY NUMBER,
1299: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 1346: from cn_hierarchy_edges

1342: end if;
1343:
1344: -- make sure the edge still exists
1345: select count(1) into l_count
1346: from cn_hierarchy_edges
1347: where value_id = p_value_id
1348: and nvl(parent_value_id, -99) = nvl(p_parent_value_id, -99)
1349: and dim_hierarchy_id = p_dim_hierarchy_id
1350: --R12 MOAC Changes--Start

Line 1477: from cn_hierarchy_edges

1473: child.name NODE_NAME,
1474: e.depth LEVEL_NUM
1475: from cn_hierarchy_nodes child, cn_hierarchy_nodes parent,
1476: (select value_id, parent_value_id, level depth, dim_hierarchy_id
1477: from cn_hierarchy_edges
1478: start with (parent_value_id is null and
1479: dim_hierarchy_id = l_dim_hierarchy_id)
1480: connect by parent_value_id = prior value_id
1481: and dim_hierarchy_id = l_dim_hierarchy_id) e