1 PACKAGE FEM_DIM_UTILS_PVT AS
2 /* $Header: FEMVDDUS.pls 120.6.12010000.2 2008/08/19 08:26:20 lkiran ship $ */
3
4 -- Global Variable to set security context
5 g_user_mode varchar2(1) := 'N';
6 g_dimension_id NUMBER;
7
8 FUNCTION Get_Dim_Attr_Req_Flag_Access
9 (
10 p_dimension_id IN NUMBER
11 ) RETURN VARCHAR2;
12
13 FUNCTION Get_Dim_Attribute_Access
14 (
15 p_attribute_id IN NUMBER,
16 p_personal_flag IN VARCHAR2 := 'N'
17 ) RETURN VARCHAR2;
18
19 /* Bug#3980015
20 * Added to handle behavious of Delete switcher
21 * to seperate its behaviour from the update
22 * switcher's logic
23 */
24 FUNCTION Get_Dim_Attribute_Access_Del
25 (
26 p_attribute_id IN NUMBER,
27 p_personal_flag IN VARCHAR2 := 'N'
28 ) RETURN VARCHAR2;
29
30 /* Bug#3738974
31 * Parameter 'p_operation_type' added
32 * to distinguish between 'Update' and 'delete' operations
33 */
34
35 FUNCTION Get_Dim_Group_Access
36 (
37 p_group_id IN NUMBER,
38 p_read_only_flag IN VARCHAR2,
39 p_personal_flag IN VARCHAR2,
40 p_created_by IN NUMBER,
41 p_dimension_id IN VARCHAR2,
42 p_operation_type IN VARCHAR2
43 ) RETURN VARCHAR2;
44
45 FUNCTION Get_Dim_Member_Access
46 (
47 p_member_id IN VARCHAR2,
48 p_read_only_flag IN VARCHAR2,
49 p_personal_flag IN VARCHAR2,
50 p_created_by IN NUMBER,
51 p_operation IN VARCHAR2
52 ) RETURN VARCHAR2;
53
54
55 PROCEDURE Set_Security_Context;
56
57 PROCEDURE Set_Security_Dim_Context (
58 p_dimension_id IN NUMBER
59 );
60
61
62 PROCEDURE Set_Non_Security_Context;
63
64
65 FUNCTION Grp_Attribute_Validation
66 (
67 p_attribute_id IN NUMBER,
68 p_dim_group_id IN VARCHAR2
69 ) RETURN VARCHAR2;
70
71
72 PROCEDURE Set_Non_Security_Dim_Context (
73 p_dimension_id IN NUMBER
74 );
75
76
77 PROCEDURE Create_Comp_Dim_Member (
78 p_api_version IN NUMBER ,
79 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
80 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
81 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
82 p_return_status OUT NOCOPY VARCHAR2 ,
83 p_msg_count OUT NOCOPY NUMBER ,
84 p_msg_data OUT NOCOPY VARCHAR2 ,
85 --
86 p_structure_id IN NUMBER ,
87 p_display_code IN VARCHAR2 ,
88 p_dim_varchar_label IN VARCHAR2 ,
89 p_segment_1 IN VARCHAR2 ,
90 p_segment_2 IN VARCHAR2 ,
91 p_segment_3 IN VARCHAR2 ,
92 p_segment_4 IN VARCHAR2 ,
93 p_segment_5 IN VARCHAR2 ,
94 p_segment_6 IN VARCHAR2 ,
95 p_segment_7 IN VARCHAR2 ,
96 p_segment_8 IN VARCHAR2 ,
97 p_segment_9 IN VARCHAR2 ,
98 p_segment_10 IN VARCHAR2 ,
99 p_segment_11 IN VARCHAR2 ,
100 p_segment_12 IN VARCHAR2 ,
101 p_segment_13 IN VARCHAR2 ,
102 p_segment_14 IN VARCHAR2 ,
103 p_segment_15 IN VARCHAR2 ,
104 p_segment_16 IN VARCHAR2 ,
105 p_segment_17 IN VARCHAR2 ,
106 p_segment_18 IN VARCHAR2 ,
107 p_segment_19 IN VARCHAR2 ,
108 p_segment_20 IN VARCHAR2 ,
109 p_segment_21 IN VARCHAR2 ,
110 p_segment_22 IN VARCHAR2 ,
111 p_segment_23 IN VARCHAR2 ,
112 p_segment_24 IN VARCHAR2 ,
113 p_segment_25 IN VARCHAR2 ,
114 p_segment_26 IN VARCHAR2 ,
115 p_segment_27 IN VARCHAR2 ,
116 p_segment_28 IN VARCHAR2 ,
117 p_segment_29 IN VARCHAR2 ,
118 p_segment_30 IN VARCHAR2,
119 p_local_vs_combo_id IN VARCHAR2);
120
121
122 PROCEDURE Member_Insert_Row (
123 p_api_version IN NUMBER ,
124 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
125 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
126 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
127 p_return_status OUT NOCOPY VARCHAR2 ,
128 p_msg_count OUT NOCOPY NUMBER ,
129 p_msg_data OUT NOCOPY VARCHAR2 ,
130 --
131 p_rowid in out NOCOPY VARCHAR2,
132 p_dimension_varchar_label IN VARCHAR2 ,
133 p_dimension_id IN NUMBER ,
134 p_value_set_id IN NUMBER ,
135 p_dimension_group_id IN NUMBER ,
136 p_display_code IN VARCHAR2 ,
137 p_member_name IN VARCHAR2 ,
138 p_member_description IN VARCHAR2,
139 p_object_version_number IN NUMBER,
140 p_read_only_flag IN VARCHAR2,
141 p_enabled_flag IN VARCHAR2,
142 p_personal_flag IN VARCHAR2,
143 p_calendar_id IN NUMBER,
144 p_member_id IN VARCHAR2
145 );
146
147
148 PROCEDURE Member_Update_Row (
149 p_api_version IN NUMBER ,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
152 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
153 p_return_status OUT NOCOPY VARCHAR2 ,
154 p_msg_count OUT NOCOPY NUMBER ,
155 p_msg_data OUT NOCOPY VARCHAR2 ,
156 --
157 p_dimension_varchar_label IN VARCHAR2 ,
158 p_member_id IN NUMBER ,
159 p_value_set_id IN NUMBER ,
160 p_dimension_group_id IN NUMBER ,
161 p_display_code IN VARCHAR2 ,
162 p_member_name IN VARCHAR2 ,
163 p_member_description IN VARCHAR2,
164 p_object_version_number IN NUMBER,
165 p_read_only_flag IN VARCHAR2,
166 p_enabled_flag IN VARCHAR2,
167 p_personal_flag IN VARCHAR2,
168 p_calendar_id IN NUMBER
169 );
170
171 --Bug#4406010
172 --Added param p_value_set_id.
173
174 PROCEDURE Member_Delete_Row (
175 p_api_version IN NUMBER ,
176 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
177 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
178 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
179 p_return_status OUT NOCOPY VARCHAR2 ,
180 p_msg_count OUT NOCOPY NUMBER ,
181 p_msg_data OUT NOCOPY VARCHAR2 ,
182 --
183 p_dimension_varchar_label IN VARCHAR2,
184 p_member_id IN VARCHAR2,
185 p_value_set_id IN VARCHAR2
186 );
187
188 --Bug#4230148
189 --Added p_user_mode,p_snapshot_id
190
191 FUNCTION Do_Member_Adv_Search (
192 p_member_attr_table_name IN VARCHAR2,
193 p_member_column_name IN VARCHAR2,
194 p_search_attribute_id IN VARCHAR2,
195 p_search_version_id IN VARCHAR2,
196 p_search_attribute_value IN VARCHAR2,
197 p_user_mode IN VARCHAR2,
198 p_snapshot_id IN VARCHAR2
199 )
200 RETURN FND_TABLE_OF_VARCHAR2_120;
201
202
203 PROCEDURE Attribute_Insert_Row (
204 p_api_version IN NUMBER ,
205 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
206 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
207 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
208 p_return_status OUT NOCOPY VARCHAR2 ,
209 p_msg_count OUT NOCOPY NUMBER ,
210 p_msg_data OUT NOCOPY VARCHAR2 ,
211 --
212
213 p_attribute_table_name IN VARCHAR2 ,
214 p_attribute_column_name IN VARCHAR2 ,
215 p_attribute_id IN NUMBER ,
216 p_version_id IN NUMBER ,
217 p_member_id IN VARCHAR2 ,
218 p_member_value_set_id IN NUMBER ,
219 p_attribute_value_set_id IN NUMBER ,
220 p_attribute_numeric_member IN NUMBER,
221 p_attribute_varchar_member IN VARCHAR2,
222 p_number_assign_value IN NUMBER,
223 p_varchar_assign_value IN VARCHAR2,
224 p_date_assign_value IN DATE,
225 p_value_set_required_flag IN VARCHAR2
226
227 );
228
229
230 PROCEDURE Attribute_Update_Row (
231 p_api_version IN NUMBER ,
232 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
233 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
234 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
235 p_return_status OUT NOCOPY VARCHAR2 ,
236 p_msg_count OUT NOCOPY NUMBER ,
237 p_msg_data OUT NOCOPY VARCHAR2 ,
238 --
239 p_attribute_table_name IN VARCHAR2 ,
240 p_attribute_column_name IN VARCHAR2 ,
241 p_attribute_id IN NUMBER ,
242 p_version_id IN NUMBER ,
243 p_member_id IN VARCHAR2 ,
244 p_member_value_set_id IN NUMBER ,
245 p_attribute_value_set_id IN NUMBER ,
246 p_attribute_numeric_member IN NUMBER,
247 p_attribute_varchar_member IN VARCHAR2,
248 p_number_assign_value IN NUMBER,
249 p_varchar_assign_value IN VARCHAR2,
250 p_date_assign_value IN DATE,
251 p_value_set_required_flag IN VARCHAR2,
252 p_object_version_number IN NUMBER
253 );
254
255 PROCEDURE Attribute_Delete_Row (
256 p_api_version IN NUMBER ,
257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE ,
258 p_commit IN VARCHAR2 := FND_API.G_FALSE ,
259 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL ,
260 p_return_status OUT NOCOPY VARCHAR2 ,
261 p_msg_count OUT NOCOPY NUMBER ,
262 p_msg_data OUT NOCOPY VARCHAR2 ,
263 --
264 p_attribute_table_name IN VARCHAR2 ,
265 p_member_col_name IN VARCHAR2 ,
266 p_attribute_id IN NUMBER ,
267 p_version_id IN NUMBER ,
268 p_member_id IN VARCHAR2 ,
269 p_member_value_set_id IN NUMBER ,
270 p_dim_attr_numeric_member IN NUMBER ,
271 p_dim_attr_varchar_member IN VARCHAR2,
272 p_dim_attr_value_set_id IN NUMBER
273 );
274
275 -- Bug#3738974: Function to determine if a given group has members
276 FUNCTION Group_Has_Members (
277 p_dim_mem_tbl_name IN VARCHAR2,
278 p_group_id IN NUMBER
279 ) RETURN VARCHAR2;
280
281 --Bug#4370513
282 --Added param p_global_vs_combo_id
283
284 --Bug#4449895
285 --Added param p_member_group_id
286
287 PROCEDURE Check_Unique_Member
288 (
289 p_api_version IN NUMBER,
290 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
291 p_commit IN VARCHAR2 := FND_API.G_FALSE,
292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
293 p_return_status OUT NOCOPY VARCHAR2,
294 p_msg_count OUT NOCOPY NUMBER,
295 p_msg_data OUT NOCOPY VARCHAR2,
296 --
297 p_comp_dim_flag IN VARCHAR2,
298 p_member_name IN VARCHAR2,
299 p_member_display_code IN VARCHAR2,
300 p_dimension_varchar_label IN VARCHAR2,
301 p_member_group_id IN NUMBER,
302 p_value_set_id IN NUMBER,
303 p_calendar_id IN NUMBER := NULL,
304 p_global_vs_combo_id IN NUMBER,
305 p_member_id IN VARCHAR2);
306
307 --Bug#3998511: Added Validate_Cal_Period_Member Procedure
308 --Bug#4002913: Added the parameter p_calendar_id
309 --Bug#4096945: Added the parameters p_current_period_flag,p_cal_period_id
310 PROCEDURE Validate_Cal_Period_Member (
311 p_api_version IN NUMBER,
312 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313 x_return_status OUT NOCOPY VARCHAR2,
314 x_msg_count OUT NOCOPY NUMBER,
315 x_msg_data OUT NOCOPY VARCHAR2,
316 --
317 p_dimension_id IN NUMBER,
318 p_dimension_group_id IN NUMBER,
319 p_start_date IN DATE,
320 p_end_date IN DATE,
321 p_adjustment_period_flag IN VARCHAR2,
322 p_calendar_id IN NUMBER,
323 p_current_period_flag IN VARCHAR2,
324 p_cal_period_id IN VARCHAR2
325 );
326
327 FUNCTION Get_Ogl_Locked_Member_Access
328 (
329 p_attribute_id IN NUMBER,
330 p_read_only_flag IN VARCHAR2
331 ) RETURN VARCHAR2;
332
333
334 END FEM_DIM_UTILS_PVT;