DBA Data[Home] [Help]

APPS.CN_DIM_HIERARCHIES_PVT dependencies on CN_HEAD_HIERARCHIES

Line 60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,

56: (p_api_version IN NUMBER, -- required
57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
62: --R12 MOAC Changes--Start
63: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
64: --R12 MOAC Changes--End

Line 61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,

57: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
58: p_commit IN VARCHAR2 := FND_API.G_FALSE,
59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
62: --R12 MOAC Changes--Start
63: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
64: --R12 MOAC Changes--End
65: x_return_status OUT NOCOPY VARCHAR2,

Line 63: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

59: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
60: p_dimension_id IN CN_HEAD_HIERARCHIES.DIMENSION_ID%TYPE,
61: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
62: --R12 MOAC Changes--Start
63: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
64: --R12 MOAC Changes--End
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,

Line 68: x_head_hierarchy_id OUT NOCOPY CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE);

64: --R12 MOAC Changes--End
65: x_return_status OUT NOCOPY VARCHAR2,
66: x_msg_count OUT NOCOPY NUMBER,
67: x_msg_data OUT NOCOPY VARCHAR2,
68: x_head_hierarchy_id OUT NOCOPY CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE);
69:
70: -- Update head hierarchy (only name is updateable)
71: PROCEDURE Update_Head_Hierarchy
72: (p_api_version IN NUMBER, -- required

Line 76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,

72: (p_api_version IN NUMBER, -- required
73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
79: --R12 MOAC Changes--Start
80: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

Line 77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,

73: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
79: --R12 MOAC Changes--Start
80: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
81: --R12 MOAC Changes--End

Line 78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

74: p_commit IN VARCHAR2 := FND_API.G_FALSE,
75: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
79: --R12 MOAC Changes--Start
80: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
81: --R12 MOAC Changes--End
82: x_return_status OUT NOCOPY VARCHAR2,

Line 80: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

76: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
77: p_name IN CN_HEAD_HIERARCHIES.NAME%TYPE,
78: p_object_version_number IN OUT NOCOPY CN_HEAD_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
79: --R12 MOAC Changes--Start
80: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
81: --R12 MOAC Changes--End
82: x_return_status OUT NOCOPY VARCHAR2,
83: x_msg_count OUT NOCOPY NUMBER,
84: x_msg_data OUT NOCOPY VARCHAR2);

Line 92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,

88: (p_api_version IN NUMBER, -- required
89: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
93: --R12 MOAC Changes--Start
94: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
95: --R12 MOAC Changes--End
96: x_return_status OUT NOCOPY VARCHAR2,

Line 94: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,

90: p_commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92: p_head_hierarchy_id IN CN_HEAD_HIERARCHIES.HEAD_HIERARCHY_ID%TYPE,
93: --R12 MOAC Changes--Start
94: p_org_id IN CN_HEAD_HIERARCHIES.ORG_ID%TYPE,
95: --R12 MOAC Changes--End
96: x_return_status OUT NOCOPY VARCHAR2,
97: x_msg_count OUT NOCOPY NUMBER,
98: x_msg_data OUT NOCOPY VARCHAR2);