[Home] [Help]
PACKAGE: APPS.CN_DIM_HIERARCHIES_PVT
Source
1 PACKAGE CN_DIM_HIERARCHIES_PVT 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
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
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);
22
23 -- Update hierarchy type (only name is updateable)
24 PROCEDURE Update_Hierarchy_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,
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
40 -- Delete hierarchy type
41 PROCEDURE Delete_Hierarchy_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,
51 x_msg_count OUT NOCOPY NUMBER,
52 x_msg_data OUT NOCOPY VARCHAR2);
53
54 -- Create head hierarchy
55 PROCEDURE Create_Head_Hierarchy
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
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
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
82 x_return_status OUT NOCOPY VARCHAR2,
83 x_msg_count OUT NOCOPY NUMBER,
84 x_msg_data OUT NOCOPY VARCHAR2);
85
86 -- Delete head hierarchy
87 PROCEDURE Delete_Head_Hierarchy
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,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2);
99
100 -- Create dimension hierarchy
101 PROCEDURE Create_Dim_Hierarchy
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
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,
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
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,
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);
134
135 -- Delete dimension hierarchy
136 PROCEDURE Delete_Dim_Hierarchy
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,
146 x_msg_count OUT NOCOPY NUMBER,
147 x_msg_data OUT NOCOPY VARCHAR2);
148
149 -- Create edge
150 PROCEDURE Create_Edge
151 (p_api_version IN NUMBER, -- required
152 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
153 p_commit IN VARCHAR2 := FND_API.G_FALSE,
154 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
155 p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
156 p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
157 p_name IN CN_HIERARCHY_NODES.NAME%TYPE,
158 p_external_id IN CN_HIERARCHY_NODES.EXTERNAL_ID%TYPE,
159 --R12 MOAC Changes--Start
160 p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
161 --R12 MOAC Changes--End
162 x_return_status OUT NOCOPY VARCHAR2,
163 x_msg_count OUT NOCOPY NUMBER,
164 x_msg_data OUT NOCOPY VARCHAR2,
165 x_value_id OUT NOCOPY CN_HIERARCHY_EDGES.VALUE_ID%TYPE);
166
167 -- Delete edge
168 PROCEDURE Delete_Edge
169 (p_api_version IN NUMBER, -- required
170 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
171 p_commit IN VARCHAR2 := FND_API.G_FALSE,
172 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
173 p_dim_hierarchy_id IN CN_HIERARCHY_EDGES.DIM_HIERARCHY_ID%TYPE,
174 p_value_id IN CN_HIERARCHY_EDGES.VALUE_ID%TYPE,
175 p_parent_value_id IN CN_HIERARCHY_EDGES.PARENT_VALUE_ID%TYPE,
176 --R12 MOAC Changes--Start
177 p_org_id IN CN_HIERARCHY_EDGES.ORG_ID%TYPE,
178 --R12 MOAC Changes--End
179 x_return_status OUT NOCOPY VARCHAR2,
180 x_msg_count OUT NOCOPY NUMBER,
181 x_msg_data OUT NOCOPY VARCHAR2);
182
183
184 -- export
185 PROCEDURE Export
186 (errbuf OUT NOCOPY VARCHAR2,
187 retcode OUT NOCOPY VARCHAR2,
188 p_imp_header_id IN NUMBER,
189 --R12 MOAC Changes--Start
190 p_org_id IN NUMBER);
191 --R12 MOAC Changes--End
192
193
194 END CN_DIM_HIERARCHIES_PVT;