DBA Data[Home] [Help]

APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_HIERARCHY_EDGES

Line 155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,

151: (p_api_version IN NUMBER, -- required
152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
158: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
159: --R12 MOAC Changes--Start

Line 156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

152: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153: p_commit IN VARCHAR2 := FND_API.G_FALSE,
154: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
158: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
159: --R12 MOAC Changes--Start
160: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

Line 160: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

156: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157: p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
158: p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
159: --R12 MOAC Changes--Start
160: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
161: --R12 MOAC Changes--End
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,

Line 165: x_value_id OUT NOCOPY CN_HIERARCHY_EDGES.VALUE_ID%TYPE);

161: --R12 MOAC Changes--End
162: x_return_status OUT NOCOPY VARCHAR2,
163: x_msg_count OUT NOCOPY NUMBER,
164: x_msg_data OUT NOCOPY VARCHAR2,
165: x_value_id OUT NOCOPY CN_HIERARCHY_EDGES.VALUE_ID%TYPE);
166:
167: -- Delete edge
168: PROCEDURE Delete_Edge
169: (p_api_version IN NUMBER, -- required

Line 173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,

169: (p_api_version IN NUMBER, -- required
170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176: --R12 MOAC Changes--Start
177: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

Line 174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,

170: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176: --R12 MOAC Changes--Start
177: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
178: --R12 MOAC Changes--End

Line 175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,

171: p_commit IN VARCHAR2 := FND_API.G_FALSE,
172: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176: --R12 MOAC Changes--Start
177: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
178: --R12 MOAC Changes--End
179: x_return_status OUT NOCOPY VARCHAR2,

Line 177: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,

173: p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174: p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175: p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176: --R12 MOAC Changes--Start
177: p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
178: --R12 MOAC Changes--End
179: x_return_status OUT NOCOPY VARCHAR2,
180: x_msg_count OUT NOCOPY NUMBER,
181: x_msg_data OUT NOCOPY VARCHAR2);