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_DIM_HIERARCHIES

Line 1: PACKAGE CN_DIM_HIERARCHIES_PVT AUTHID CURRENT_USER AS

1: PACKAGE CN_DIM_HIERARCHIES_PVT AUTHID CURRENT_USER AS
2: -- $Header: cnvdimhs.pls 120.3 2005/12/13 02:01:02 hanaraya noship $
3:
4: -- Create a new hierarchy type
5: PROCEDURE Create_Hierarchy_Type

Line 106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,

102: (p_api_version IN NUMBER, -- required
103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
110: --R12 MOAC Changes--Start

Line 107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

103: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
110: --R12 MOAC Changes--Start
111: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

Line 108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

104: p_commit IN VARCHAR2 := FND_API.G_FALSE,
105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
110: --R12 MOAC Changes--Start
111: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
112: --R12 MOAC Changes--End

Line 109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,

105: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
106: p_head_hierarchy_id IN CN_DIM_HIERARCHIES.HEADER_DIM_HIERARCHY_ID%TYPE,
107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
110: --R12 MOAC Changes--Start
111: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
112: --R12 MOAC Changes--End
113: x_return_status OUT NOCOPY VARCHAR2,

Line 111: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

107: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
108: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
109: p_root_node IN CN_DIM_HIERARCHIES.ROOT_NODE%TYPE,
110: --R12 MOAC Changes--Start
111: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
112: --R12 MOAC Changes--End
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,

Line 116: x_dim_hierarchy_id OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE);

112: --R12 MOAC Changes--End
113: x_return_status OUT NOCOPY VARCHAR2,
114: x_msg_count OUT NOCOPY NUMBER,
115: x_msg_data OUT NOCOPY VARCHAR2,
116: x_dim_hierarchy_id OUT NOCOPY CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE);
117:
118: -- Update dimension hierarchy (only dates are updateable)
119: PROCEDURE Update_Dim_Hierarchy
120: (p_api_version IN NUMBER, -- required

Line 124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

120: (p_api_version IN NUMBER, -- required
121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
128: --R12 MOAC Changes--Start

Line 125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,

121: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
128: --R12 MOAC Changes--Start
129: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

Line 126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,

122: p_commit IN VARCHAR2 := FND_API.G_FALSE,
123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
128: --R12 MOAC Changes--Start
129: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
130: --R12 MOAC Changes--End

Line 127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,

123: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
124: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
128: --R12 MOAC Changes--Start
129: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
130: --R12 MOAC Changes--End
131: x_return_status OUT NOCOPY VARCHAR2,

Line 129: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

125: p_start_date IN CN_DIM_HIERARCHIES.START_DATE%TYPE,
126: p_end_date IN CN_DIM_HIERARCHIES.END_DATE%TYPE,
127: p_object_version_number IN OUT NOCOPY CN_DIM_HIERARCHIES.OBJECT_VERSION_NUMBER%TYPE,
128: --R12 MOAC Changes--Start
129: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
130: --R12 MOAC Changes--End
131: x_return_status OUT NOCOPY VARCHAR2,
132: x_msg_count OUT NOCOPY NUMBER,
133: x_msg_data OUT NOCOPY VARCHAR2);

Line 141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,

137: (p_api_version IN NUMBER, -- required
138: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
142: --R12 MOAC Changes--Start
143: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
144: --R12 MOAC Changes--End
145: x_return_status OUT NOCOPY VARCHAR2,

Line 143: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,

139: p_commit IN VARCHAR2 := FND_API.G_FALSE,
140: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
141: p_dim_hierarchy_id IN CN_DIM_HIERARCHIES.DIM_HIERARCHY_ID%TYPE,
142: --R12 MOAC Changes--Start
143: p_org_id IN CN_DIM_HIERARCHIES.ORG_ID%TYPE,
144: --R12 MOAC Changes--End
145: x_return_status OUT NOCOPY VARCHAR2,
146: x_msg_count OUT NOCOPY NUMBER,
147: x_msg_data OUT NOCOPY VARCHAR2);

Line 194: END CN_DIM_HIERARCHIES_PVT;

190: p_org_id IN NUMBER);
191: --R12 MOAC Changes--End
192:
193:
194: END CN_DIM_HIERARCHIES_PVT;