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_NODES

Line 742: l_name CN_HIERARCHY_NODES.NAME%TYPE;

738:
739: l_api_name CONSTANT VARCHAR2(30) := 'Create_Dim_Hierarchy';
740: l_api_version CONSTANT NUMBER := 1.0;
741: l_count NUMBER;
742: l_name CN_HIERARCHY_NODES.NAME%TYPE;
743: x_root_node CN_DIM_HIERARCHIES.ROOT_NODE%TYPE;
744:
745: BEGIN
746: -- Standard Start of API savepoint

Line 1138: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,

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,
1142: --R12 MOAC Changes--End

Line 1139: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,

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,
1142: --R12 MOAC Changes--End
1143: x_return_status OUT NOCOPY VARCHAR2,

Line 1303: l_ext_id CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE;

1299: x_msg_data OUT NOCOPY VARCHAR2) IS
1300:
1301: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Edge';
1302: l_api_version CONSTANT NUMBER := 1.0;
1303: l_ext_id CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE;
1304: l_count NUMBER;
1305:
1306: BEGIN
1307: -- Standard Start of API savepoint

Line 1331: from cn_hierarchy_nodes

1327: -- make sure the root is not being deleted
1328: if p_parent_value_id is null then
1329: -- see if parent value is a BASE NODE... if so it has no external ID
1330: select external_id into l_ext_id
1331: from cn_hierarchy_nodes
1332: where value_id = p_value_id
1333: --R12 MOAC Changes--Start
1334: and org_id = p_org_id;
1335: --R12 MOAC Changes--End

Line 1475: from cn_hierarchy_nodes child, cn_hierarchy_nodes parent,

1471: select decode(child.external_id, null, 'Y', 'N') DEFAULT_NODE_FLAG,
1472: parent.name PARENT_NODE_NAME,
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)