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
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,
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);
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
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,
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
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
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,
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:
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,
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);