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_DIMENSIONS

Line 12: p_name IN CN_DIMENSIONS.NAME%TYPE,

8: (p_api_version IN NUMBER, -- required
9: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
10: p_commit IN VARCHAR2 := FND_API.G_FALSE,
11: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
12: p_name IN CN_DIMENSIONS.NAME%TYPE,
13: p_base_table_id IN CN_OBJ_TABLES_V.TABLE_ID%TYPE,
14: p_primary_key_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
15: p_user_column_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
16: --R12 MOAC Changes--Start

Line 17: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

13: p_base_table_id IN CN_OBJ_TABLES_V.TABLE_ID%TYPE,
14: p_primary_key_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
15: p_user_column_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
16: --R12 MOAC Changes--Start
17: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
18: --R12 MOAC Changes--End
19: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,

Line 19: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12

15: p_user_column_id IN CN_OBJ_COLUMNS_V.COLUMN_ID%TYPE,
16: --R12 MOAC Changes--Start
17: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
18: --R12 MOAC Changes--End
19: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: x_dimension_id OUT NOCOPY CN_DIMENSIONS.DIMENSION_ID%TYPE) IS

Line 23: x_dimension_id OUT NOCOPY CN_DIMENSIONS.DIMENSION_ID%TYPE) IS

19: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
20: x_return_status OUT NOCOPY VARCHAR2,
21: x_msg_count OUT NOCOPY NUMBER,
22: x_msg_data OUT NOCOPY VARCHAR2,
23: x_dimension_id OUT NOCOPY CN_DIMENSIONS.DIMENSION_ID%TYPE) IS
24:
25: l_api_name CONSTANT VARCHAR2(30) := 'Create_Hierarchy_Type';
26: l_api_version CONSTANT NUMBER := 1.0;
27: l_rowid ROWID;

Line 54: select count(1) into l_count from cn_dimensions where name = p_name and org_id = p_org_id; --R12 MOAC change

50: -- API body
51: -- call the original forms API (CNDIHY.fmb -> CNDIHY2s/b.pls)
52:
53: -- validate name is unique
54: select count(1) into l_count from cn_dimensions where name = p_name and org_id = p_org_id; --R12 MOAC change
55: if l_count > 0 then
56: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
57: FND_MSG_PUB.ADD;
58: RAISE FND_API.G_EXC_ERROR;

Line 62: from cn_dimensions_all_tl T, fnd_languages L

58: RAISE FND_API.G_EXC_ERROR;
59: end if;
60:
61: select count(1) into l_count_tl
62: from cn_dimensions_all_tl T, fnd_languages L
63: where name = p_name
64: and org_id = p_org_id
65: and T.language = L.language_code
66: and L.INSTALLED_FLAG in ('I', 'B');

Line 75: x_dimension_id := CN_DIMENSIONS_PKG.New_Dimension;

71: RAISE FND_API.G_EXC_ERROR;
72: end if;
73:
74: -- get dimension ID
75: x_dimension_id := CN_DIMENSIONS_PKG.New_Dimension;
76: cn_dimensions_pkg.insert_row
77: (
78: X_DIMENSION_ID => x_dimension_id,
79: X_DESCRIPTION => p_description,-- Added for R12

Line 76: cn_dimensions_pkg.insert_row

72: end if;
73:
74: -- get dimension ID
75: x_dimension_id := CN_DIMENSIONS_PKG.New_Dimension;
76: cn_dimensions_pkg.insert_row
77: (
78: X_DIMENSION_ID => x_dimension_id,
79: X_DESCRIPTION => p_description,-- Added for R12
80: X_SOURCE_TABLE_ID => p_base_table_id,

Line 149: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,

145: (p_api_version IN NUMBER, -- required
146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
150: p_name IN CN_DIMENSIONS.NAME%TYPE,
151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
152: --R12 MOAC Changes--Start
153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

Line 150: p_name IN CN_DIMENSIONS.NAME%TYPE,

146: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
150: p_name IN CN_DIMENSIONS.NAME%TYPE,
151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
152: --R12 MOAC Changes--Start
153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
154: --R12 MOAC Changes--End

Line 151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,

147: p_commit IN VARCHAR2 := FND_API.G_FALSE,
148: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
149: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
150: p_name IN CN_DIMENSIONS.NAME%TYPE,
151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
152: --R12 MOAC Changes--Start
153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
154: --R12 MOAC Changes--End
155: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12

Line 153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

149: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
150: p_name IN CN_DIMENSIONS.NAME%TYPE,
151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
152: --R12 MOAC Changes--Start
153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
154: --R12 MOAC Changes--End
155: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,

Line 155: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12

151: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
152: --R12 MOAC Changes--Start
153: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
154: --R12 MOAC Changes--End
155: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2) IS
159:

Line 165: select source_table_id, object_version_number from cn_dimensions

161: l_api_version CONSTANT NUMBER := 1.0;
162: l_count NUMBER;
163:
164: cursor c is
165: select source_table_id, object_version_number from cn_dimensions
166: where dimension_id = p_dimension_id
167: and org_id = p_org_id; --R12 MOAC changes
168:
169: tlinfo c%rowtype ;

Line 203: select count(1) into l_count from cn_dimensions

199: end if;
200: close c;
201:
202: -- validate name is unique
203: select count(1) into l_count from cn_dimensions
204: where name = p_name and dimension_id <> p_dimension_id and org_id = p_org_id; --R12 MOAC changes
205: if l_count > 0 then
206: FND_MESSAGE.SET_NAME('CN', 'CN_NAME_NOT_UNIQUE');
207: FND_MSG_PUB.ADD;

Line 223: cn_dimensions_pkg.update_row

219: raise fnd_api.g_exc_error;
220: end if;
221: -- END LOCK ROW --
222:
223: cn_dimensions_pkg.update_row
224: (X_DIMENSION_ID => p_dimension_id,
225: X_DESCRIPTION => p_description, --Added for R12
226: X_SOURCE_TABLE_ID => tlinfo.source_table_id,
227: X_NAME => p_name,

Line 286: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,

282: (p_api_version IN NUMBER, -- required
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
287: --R12 MOAC Changes--Start
288: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
289: --R12 MOAC Changes--End
290: x_return_status OUT NOCOPY VARCHAR2,

Line 288: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
287: --R12 MOAC Changes--Start
288: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
289: --R12 MOAC Changes--End
290: x_return_status OUT NOCOPY VARCHAR2,
291: x_msg_count OUT NOCOPY NUMBER,
292: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 318: cn_dimensions_pkg.delete_row

314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: -- API body
317: -- call the original forms API (CNDIHY.fmb -> CNDIHY2s/b.pls)
318: cn_dimensions_pkg.delete_row
319: (X_DIMENSION_ID => p_dimension_id,
320: --R12 MOAC Changes--Start
321: X_ORG_ID => p_org_id);
322: --R12 MOAC Changes--End

Line 1450: FROM cn_dimensions d, cn_objects o1, cn_objects o2, cn_objects o3,

1446: H.NAME HIERARCHY_NAME,
1447: M.START_DATE START_DATE,
1448: M.END_DATE END_DATE,
1449: m.dim_hierarchy_id
1450: FROM cn_dimensions d, cn_objects o1, cn_objects o2, cn_objects o3,
1451: cn_head_hierarchies h, cn_dim_hierarchies m
1452: WHERE o1.dimension_id = d.dimension_id
1453: AND o1.table_id = d.source_table_id
1454: AND o1.object_type = 'COL'