DBA Data[Home] [Help]

APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_DIMENSIONS

Line 10: p_name IN CN_DIMENSIONS.NAME%TYPE,

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

Line 15: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

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

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

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

Line 21: x_dimension_id OUT NOCOPY CN_DIMENSIONS.DIMENSION_ID%TYPE);

17: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
18: x_return_status OUT NOCOPY VARCHAR2,
19: x_msg_count OUT NOCOPY NUMBER,
20: x_msg_data OUT NOCOPY VARCHAR2,
21: x_dimension_id OUT NOCOPY CN_DIMENSIONS.DIMENSION_ID%TYPE);
22:
23: -- Update hierarchy type (only name is updateable)
24: PROCEDURE Update_Hierarchy_Type
25: (p_api_version IN NUMBER, -- required

Line 29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,

25: (p_api_version IN NUMBER, -- required
26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start
33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

Line 30: p_name IN CN_DIMENSIONS.NAME%TYPE,

26: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start
33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
34: --R12 MOAC Changes--End

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

27: p_commit IN VARCHAR2 := FND_API.G_FALSE,
28: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start
33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
34: --R12 MOAC Changes--End
35: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12

Line 33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

29: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
30: p_name IN CN_DIMENSIONS.NAME%TYPE,
31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start
33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
34: --R12 MOAC Changes--End
35: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,

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

31: p_object_version_number IN OUT NOCOPY CN_DIMENSIONS.OBJECT_VERSION_NUMBER%TYPE,
32: --R12 MOAC Changes--Start
33: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
34: --R12 MOAC Changes--End
35: p_description IN CN_DIMENSIONS.DESCRIPTION%TYPE, -- Added for R12
36: x_return_status OUT NOCOPY VARCHAR2,
37: x_msg_count OUT NOCOPY NUMBER,
38: x_msg_data OUT NOCOPY VARCHAR2);
39:

Line 46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,

42: (p_api_version IN NUMBER, -- required
43: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
47: --R12 MOAC Changes--Start
48: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
49: --R12 MOAC Changes--End
50: x_return_status OUT NOCOPY VARCHAR2,

Line 48: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,

44: p_commit IN VARCHAR2 := FND_API.G_FALSE,
45: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
46: p_dimension_id IN CN_DIMENSIONS.DIMENSION_ID%TYPE,
47: --R12 MOAC Changes--Start
48: p_org_id IN CN_DIMENSIONS.ORG_ID%TYPE,
49: --R12 MOAC Changes--End
50: x_return_status OUT NOCOPY VARCHAR2,
51: x_msg_count OUT NOCOPY NUMBER,
52: x_msg_data OUT NOCOPY VARCHAR2);