[Home] [Help]
PACKAGE: APPS.FEM_DIMENSION_UTIL_PKG
Source
1 PACKAGE FEM_DIMENSION_UTIL_PKG AUTHID CURRENT_USER AS
2 --$Header: FEMDIMAPS.pls 120.9 2006/08/24 08:32:28 nmartine ship $
3 /*==========================================================================+
4 | Copyright (c) 1997 Oracle Corporation, Redwood Shores, CA, USA |
5 | All rights reserved. |
6 +==========================================================================+
7 | FILENAME
8 |
9 | FEMDIMAPS.pls
10 |
11 | NAME fem_dimension_util_pkg
12 |
13 | DESCRIPTION
14 |
15 | Package Spec for fem_dimension_util_pkg. This package provides functions
16 | and procedures helpful in querying against dimension tables and views.
17 |
18 | HISTORY
19 |
20 | 22-APR-04 BugNo#3570753 - changed c_fem_set_of_books
21 | to fem_ledger
22 |
23 | 09-JUL-04 Rflippo
24 | Bug#3755923 added Task and Fin Elem is pop flags to new_ledger
25 | modified new_ledger signature to use DEFAULT 'N' for is pop
26 | flags
27 | 10-AUG-04 Rflippo bug#3824427 - added New_Budget API to create budget members
28 | 22-NOV-04 gcheng Bug 4005877 - added Relative_Cal_Period_ID function.
29 | 13-JAN-05 gcheng Bug 3824701 - altered Register_Data_Location signature
30 |
31 | 21-APR-05 RFlippo Bug#4303380 Add Global_vs_combo_display_code as parm
32 | to New_Global_VS_Combo_ID procedure.
33 | 15-JUN-05 gcheng 4417618. Created the Get_Default_Dim_Member procedures.
34 | 30-JUN-05 gcheng 4143586. Added another version to the overloaded
35 | Generate_Default_Load_Member procedure.
36 | 24-OCT-05 tmoore 4619062. Added Get_Dim_Member_Display_Code
37 | 10-FEB-06 gcheng 5011140 (FP:4596447). Added an optional parameter
38 | v120.7 p_table_name to UnRegister_Data_Location.
39 | 17-MAR-06 rflippo 5102692 Overload Generate_Member_ID for Cal
40 | Period dim
41 | 24-AUG-06 nmartine Bug 5473131. Added Get_Dim_Member_Name.
42 +=========================================================================*/
43
44
45 ------------------------
46 -- Package Constants --
47 ------------------------
48
49 c_fem_ledger CONSTANT VARCHAR2(30) := 'FEM_LEDGER';
50 c_false CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
51 c_true CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
52 c_success CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
53 c_error CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
54 c_unexp CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
55 c_api_version CONSTANT NUMBER := 1.0;
56
57 ------------------
58 -- Subprograms --
59 ------------------
60 PROCEDURE FEM_INITIALIZE (
61 p_ledger_id IN NUMBER
62 );
63
64 FUNCTION Application_Group_ID
65 RETURN NUMBER;
66
67 FUNCTION Global_VS_Combo_ID (
68 p_ledger_id IN NUMBER,
69 x_err_code OUT NOCOPY NUMBER,
70 x_num_msg OUT NOCOPY NUMBER
71 ) RETURN NUMBER;
72
73 FUNCTION Global_VS_Combo_ID (
74 p_api_version IN NUMBER DEFAULT c_api_version,
75 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
76 p_commit IN VARCHAR2 DEFAULT c_false,
77 p_encoded IN VARCHAR2 DEFAULT c_true,
78 x_return_status OUT NOCOPY VARCHAR2,
79 x_msg_count OUT NOCOPY NUMBER,
80 x_msg_data OUT NOCOPY VARCHAR2,
81 p_ledger_id IN NUMBER
82 ) RETURN NUMBER;
83
84 FUNCTION Local_VS_Combo_ID (
85 p_ledger_id IN NUMBER,
86 x_err_code OUT NOCOPY NUMBER,
87 x_num_msg OUT NOCOPY NUMBER
88 ) RETURN NUMBER;
89
90 FUNCTION Local_VS_Combo_ID (
91 p_api_version IN NUMBER DEFAULT c_api_version,
92 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
93 p_commit IN VARCHAR2 DEFAULT c_false,
94 p_encoded IN VARCHAR2 DEFAULT c_true,
95 x_return_status OUT NOCOPY VARCHAR2,
96 x_msg_count OUT NOCOPY NUMBER,
97 x_msg_data OUT NOCOPY VARCHAR2,
98 p_ledger_id IN NUMBER
99 ) RETURN NUMBER;
100
101 FUNCTION Dimension_Value_Set_ID (
102 p_dimension_id IN NUMBER,
103 p_ledger_id IN NUMBER DEFAULT NULL
104 ) RETURN NUMBER;
105
106 FUNCTION Dimension_Value_Set_ID (
107 p_dimension_id IN NUMBER,
108 p_ledger_id IN NUMBER,
109 x_err_code OUT NOCOPY NUMBER,
110 x_num_msg OUT NOCOPY NUMBER
111 ) RETURN NUMBER;
112
113 FUNCTION Dimension_Value_Set_ID (
114 p_api_version IN NUMBER DEFAULT c_api_version,
115 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
116 p_commit IN VARCHAR2 DEFAULT c_false,
117 p_encoded IN VARCHAR2 DEFAULT c_true,
118 x_return_status OUT NOCOPY VARCHAR2,
119 x_msg_count OUT NOCOPY NUMBER,
120 x_msg_data OUT NOCOPY VARCHAR2,
121 p_dimension_id IN NUMBER,
122 p_ledger_id IN NUMBER
123 ) RETURN NUMBER;
124
125 FUNCTION Is_Rule_Valid_For_Ledger (
126 p_object_id IN NUMBER,
127 p_ledger_id IN NUMBER
128 ) RETURN VARCHAR2;
129
130 FUNCTION Relative_Cal_Period_ID (
131 p_api_version IN NUMBER DEFAULT c_api_version,
132 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
133 p_commit IN VARCHAR2 DEFAULT c_false,
134 p_encoded IN VARCHAR2 DEFAULT c_true,
135 x_return_status OUT NOCOPY VARCHAR2,
136 x_msg_count OUT NOCOPY NUMBER,
137 x_msg_data OUT NOCOPY VARCHAR2,
138 p_per_num_offset IN NUMBER,
139 p_base_cal_period_id IN NUMBER
140 ) RETURN NUMBER;
141
142 FUNCTION Effective_Cal_Period_ID (
143 p_per_num_offset IN NUMBER,
144 p_rel_dim_grp_id IN NUMBER,
145 p_ledger_id IN NUMBER,
146 p_ref_cal_per_id IN NUMBER,
147 x_err_code OUT NOCOPY NUMBER,
148 x_num_msg OUT NOCOPY NUMBER
149 ) RETURN NUMBER;
150
151 FUNCTION Get_Cal_Period_ID (
152 p_ledger_id IN NUMBER,
153 p_dim_grp_dc IN VARCHAR2,
154 p_cal_per_num IN NUMBER,
155 p_fiscal_year IN NUMBER
156 ) RETURN NUMBER;
157
158 FUNCTION Get_Cal_Period_ID (
159 p_ledger_id IN NUMBER,
160 p_dim_grp_dc IN VARCHAR2,
161 p_cal_per_num IN NUMBER,
162 p_cal_per_end_date IN DATE
163 ) RETURN NUMBER;
164
165 PROCEDURE Register_Data_Location (
166 p_request_id IN NUMBER,
167 p_object_id IN NUMBER,
168 p_table_name IN VARCHAR2,
169 p_ledger_id IN NUMBER,
170 p_cal_per_id IN NUMBER,
171 p_dataset_cd IN NUMBER,
172 p_source_cd IN NUMBER,
173 p_load_status IN VARCHAR2 DEFAULT NULL,
174 p_avg_bal_flag IN VARCHAR2 DEFAULT NULL,
175 p_trans_curr IN VARCHAR2 DEFAULT NULL
176 );
177
178 PROCEDURE UnRegister_Data_Location (
179 p_request_id IN NUMBER,
180 p_object_id IN NUMBER,
181 p_table_name IN VARCHAR2 DEFAULT NULL
182 );
183
184 FUNCTION Generate_Member_ID (
185 p_dim_id IN NUMBER
186 ) RETURN NUMBER;
187
188 FUNCTION Generate_Member_ID (
189 p_dim_id IN NUMBER,
190 x_err_code OUT NOCOPY NUMBER,
191 x_num_msg OUT NOCOPY NUMBER
192 ) RETURN NUMBER;
193
194 FUNCTION Generate_Member_ID (
195 p_api_version IN NUMBER DEFAULT c_api_version,
196 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
197 p_commit IN VARCHAR2 DEFAULT c_false,
198 p_encoded IN VARCHAR2 DEFAULT c_true,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_dim_id IN NUMBER
203 ) RETURN NUMBER;
204
205 FUNCTION Generate_Member_ID (
206 p_end_date IN DATE,
207 p_period_num IN NUMBER,
208 p_calendar_id IN NUMBER,
209 p_dim_grp_id IN NUMBER
210 ) RETURN NUMBER;
211
212 FUNCTION Generate_Member_ID (
213 p_end_date IN DATE,
214 p_period_num IN NUMBER,
215 p_calendar_dc IN VARCHAR2,
216 p_dim_grp_dc IN VARCHAR2
217 ) RETURN NUMBER;
218
219 FUNCTION Generate_Member_ID (
220 p_end_date IN DATE,
221 p_period_num IN NUMBER,
222 p_calendar_id IN NUMBER,
223 p_dim_grp_id IN NUMBER,
224 x_err_code OUT NOCOPY NUMBER,
225 x_num_msg OUT NOCOPY NUMBER
226 ) RETURN NUMBER;
227
228 FUNCTION Generate_Member_ID (
229 p_api_version IN NUMBER DEFAULT c_api_version,
230 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
231 p_commit IN VARCHAR2 DEFAULT c_false,
232 p_encoded IN VARCHAR2 DEFAULT c_true,
233 x_return_status OUT NOCOPY VARCHAR2,
234 x_msg_count OUT NOCOPY NUMBER,
235 x_msg_data OUT NOCOPY VARCHAR2,
236 p_end_date IN DATE,
237 p_period_num IN NUMBER,
238 p_calendar_id IN NUMBER,
239 p_dim_grp_id IN NUMBER
240 ) RETURN NUMBER;
241
242 FUNCTION Generate_Member_ID (
243 p_api_version IN NUMBER DEFAULT c_api_version,
244 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
245 p_commit IN VARCHAR2 DEFAULT c_false,
246 p_encoded IN VARCHAR2 DEFAULT c_true,
247 x_return_status OUT NOCOPY VARCHAR2,
248 x_msg_count OUT NOCOPY NUMBER,
249 x_msg_data OUT NOCOPY VARCHAR2,
250 p_end_date IN DATE,
251 p_period_num IN NUMBER,
252 p_calendar_dc IN VARCHAR2,
253 p_dim_grp_dc IN VARCHAR2
254 ) RETURN NUMBER;
255
256 PROCEDURE Generate_Default_Load_Member (
257 p_api_version IN NUMBER DEFAULT c_api_version,
258 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
259 p_commit IN VARCHAR2 DEFAULT c_false,
260 p_encoded IN VARCHAR2 DEFAULT c_true,
261 x_return_status OUT NOCOPY VARCHAR2,
262 x_msg_count OUT NOCOPY NUMBER,
263 x_msg_data OUT NOCOPY VARCHAR2,
264 p_dim_label IN VARCHAR2,
265 p_vs_id IN NUMBER DEFAULT NULL,
266 x_member_code OUT NOCOPY VARCHAR2
267 );
268
269 PROCEDURE Generate_Default_Load_Member (
270 p_api_version IN NUMBER DEFAULT c_api_version,
271 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
272 p_commit IN VARCHAR2 DEFAULT c_false,
273 p_encoded IN VARCHAR2 DEFAULT c_true,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_vs_id IN NUMBER
278 );
279
280 PROCEDURE Generate_Default_Load_Member (
281 p_api_version IN NUMBER DEFAULT c_api_version,
282 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
283 p_commit IN VARCHAR2 DEFAULT c_false,
284 p_encoded IN VARCHAR2 DEFAULT c_true,
285 x_return_status OUT NOCOPY VARCHAR2,
286 x_msg_count OUT NOCOPY NUMBER,
287 x_msg_data OUT NOCOPY VARCHAR2
288 );
289
290 PROCEDURE New_Dataset (
291 p_display_code IN VARCHAR2,
292 p_dataset_name IN VARCHAR2,
293 p_bal_type_cd IN VARCHAR2,
294 p_source_cd IN NUMBER,
295 p_pft_w_flg IN VARCHAR2 DEFAULT 'Y',
296 p_prod_flg IN VARCHAR2 DEFAULT 'Y',
297 p_budget_id IN NUMBER,
298 p_enc_type_id IN NUMBER,
299 p_ver_name IN VARCHAR2,
300 p_ver_disp_cd IN VARCHAR2,
301 p_dataset_desc IN VARCHAR2,
302 x_err_code OUT NOCOPY NUMBER,
303 x_num_msg OUT NOCOPY NUMBER
304 );
305
306 PROCEDURE New_Dataset (
307 p_api_version IN NUMBER DEFAULT c_api_version,
308 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
309 p_commit IN VARCHAR2 DEFAULT c_false,
310 p_encoded IN VARCHAR2 DEFAULT c_true,
311 x_return_status OUT NOCOPY VARCHAR2,
312 x_msg_count OUT NOCOPY NUMBER,
313 x_msg_data OUT NOCOPY VARCHAR2,
314 p_display_code IN VARCHAR2,
315 p_dataset_name IN VARCHAR2,
316 p_bal_type_cd IN VARCHAR2,
317 p_source_cd IN NUMBER,
318 p_pft_w_flg IN VARCHAR2 DEFAULT 'Y',
319 p_prod_flg IN VARCHAR2 DEFAULT 'Y',
320 p_budget_id IN NUMBER,
321 p_enc_type_id IN NUMBER,
322 p_ver_name IN VARCHAR2,
323 p_ver_disp_cd IN VARCHAR2,
324 p_dataset_desc IN VARCHAR2
325 );
326 -- API for creating a new Budget dimension member
327 PROCEDURE New_Budget (
328 p_api_version IN NUMBER DEFAULT c_api_version,
329 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
330 p_commit IN VARCHAR2 DEFAULT c_false,
331 p_encoded IN VARCHAR2 DEFAULT c_true,
332 x_return_status OUT NOCOPY VARCHAR2,
333 x_msg_count OUT NOCOPY NUMBER,
334 x_msg_data OUT NOCOPY VARCHAR2,
335 p_budget_display_code IN VARCHAR2,
336 p_budget_name IN VARCHAR2,
337 p_budget_ledger IN VARCHAR2,
338 p_require_journals_flag IN VARCHAR2,
339 p_budget_status_code IN VARCHAR2,
340 p_budget_latest_open_year IN NUMBER,
341 p_budget_source_system IN VARCHAR2,
342 p_first_period_calendar IN VARCHAR2,
343 p_first_period_dimgrp IN VARCHAR2,
344 p_first_period_number IN VARCHAR2,
345 p_first_period_end_date IN DATE,
346 p_last_period_calendar IN VARCHAR2,
347 p_last_period_dimgrp IN VARCHAR2,
348 p_last_period_number IN VARCHAR2,
349 p_last_period_end_date IN DATE,
350 p_ver_name IN VARCHAR2,
351 p_ver_disp_cd IN VARCHAR2,
352 p_budget_desc IN VARCHAR2
353 );
354
355 PROCEDURE Register_Budget (
356 p_api_version IN NUMBER DEFAULT c_api_version,
357 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
358 p_commit IN VARCHAR2 DEFAULT c_false,
359 p_encoded IN VARCHAR2 DEFAULT c_true,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_budget_id IN NUMBER,
364 p_budget_display_code IN VARCHAR2,
365 p_budget_name IN VARCHAR2,
366 p_budget_ledger IN VARCHAR2,
367 p_require_journals_flag IN VARCHAR2,
368 p_budget_status_code IN VARCHAR2,
369 p_budget_latest_open_year IN NUMBER,
370 p_budget_source_system IN VARCHAR2,
371 p_first_period_calendar IN VARCHAR2,
372 p_first_period_dimgrp IN VARCHAR2,
373 p_first_period_number IN VARCHAR2,
374 p_first_period_end_date IN DATE,
375 p_last_period_calendar IN VARCHAR2,
376 p_last_period_dimgrp IN VARCHAR2,
377 p_last_period_number IN VARCHAR2,
378 p_last_period_end_date IN DATE,
379 p_ver_name IN VARCHAR2,
380 p_ver_disp_cd IN VARCHAR2,
381 p_budget_desc IN VARCHAR2
382 );
383
384 PROCEDURE New_Ledger (
385 p_display_code IN VARCHAR2,
386 p_ledger_name IN VARCHAR2,
387 p_func_curr_cd IN VARCHAR2,
388 p_source_cd IN NUMBER,
389 p_cal_per_hid IN NUMBER,
390 p_global_vs_id IN NUMBER,
391 p_epb_def_lg_flg IN VARCHAR2,
392 p_ent_curr_flg IN VARCHAR2,
393 p_avg_bal_flg IN VARCHAR2,
394 p_chan_flg IN VARCHAR2 DEFAULT 'N',
395 p_cctr_flg IN VARCHAR2 DEFAULT 'N',
396 p_cust_flg IN VARCHAR2 DEFAULT 'N',
397 p_geog_flg IN VARCHAR2 DEFAULT 'N',
398 p_ln_item_flg IN VARCHAR2 DEFAULT 'N',
399 p_nat_acct_flg IN VARCHAR2 DEFAULT 'N',
400 p_prod_flg IN VARCHAR2 DEFAULT 'N',
401 p_proj_flg IN VARCHAR2 DEFAULT 'N',
405 p_user3_flg IN VARCHAR2 DEFAULT 'N',
402 p_entity_flg IN VARCHAR2 DEFAULT 'N',
403 p_user1_flg IN VARCHAR2 DEFAULT 'N',
404 p_user2_flg IN VARCHAR2 DEFAULT 'N',
406 p_user4_flg IN VARCHAR2 DEFAULT 'N',
407 p_user5_flg IN VARCHAR2 DEFAULT 'N',
408 p_user6_flg IN VARCHAR2 DEFAULT 'N',
409 p_user7_flg IN VARCHAR2 DEFAULT 'N',
410 p_user8_flg IN VARCHAR2 DEFAULT 'N',
411 p_user9_flg IN VARCHAR2 DEFAULT 'N',
412 p_user10_flg IN VARCHAR2 DEFAULT 'N',
413 p_task_flg IN VARCHAR2 DEFAULT 'N',
414 p_fin_elem_flg IN VARCHAR2 DEFAULT 'N',
415 p_ver_name IN VARCHAR2,
416 p_ver_disp_cd IN VARCHAR2,
417 p_ledger_desc IN VARCHAR2,
418 x_err_code OUT NOCOPY NUMBER,
419 x_num_msg OUT NOCOPY NUMBER
420 );
421
422 PROCEDURE New_Ledger (
423 p_api_version IN NUMBER DEFAULT c_api_version,
424 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
425 p_commit IN VARCHAR2 DEFAULT c_false,
426 p_encoded IN VARCHAR2 DEFAULT c_true,
427 x_return_status OUT NOCOPY VARCHAR2,
428 x_msg_count OUT NOCOPY NUMBER,
429 x_msg_data OUT NOCOPY VARCHAR2,
430 p_display_code IN VARCHAR2,
431 p_ledger_name IN VARCHAR2,
432 p_func_curr_cd IN VARCHAR2,
433 p_source_cd IN NUMBER,
434 p_cal_per_hid IN NUMBER,
435 p_global_vs_id IN NUMBER,
436 p_epb_def_lg_flg IN VARCHAR2,
437 p_ent_curr_flg IN VARCHAR2,
438 p_avg_bal_flg IN VARCHAR2,
439 p_chan_flg IN VARCHAR2 DEFAULT 'N',
440 p_cctr_flg IN VARCHAR2 DEFAULT 'N',
441 p_cust_flg IN VARCHAR2 DEFAULT 'N',
442 p_geog_flg IN VARCHAR2 DEFAULT 'N',
443 p_ln_item_flg IN VARCHAR2 DEFAULT 'N',
444 p_nat_acct_flg IN VARCHAR2 DEFAULT 'N',
445 p_prod_flg IN VARCHAR2 DEFAULT 'N',
446 p_proj_flg IN VARCHAR2 DEFAULT 'N',
447 p_entity_flg IN VARCHAR2 DEFAULT 'N',
448 p_user1_flg IN VARCHAR2 DEFAULT 'N',
449 p_user2_flg IN VARCHAR2 DEFAULT 'N',
450 p_user3_flg IN VARCHAR2 DEFAULT 'N',
451 p_user4_flg IN VARCHAR2 DEFAULT 'N',
452 p_user5_flg IN VARCHAR2 DEFAULT 'N',
453 p_user6_flg IN VARCHAR2 DEFAULT 'N',
454 p_user7_flg IN VARCHAR2 DEFAULT 'N',
455 p_user8_flg IN VARCHAR2 DEFAULT 'N',
456 p_user9_flg IN VARCHAR2 DEFAULT 'N',
457 p_user10_flg IN VARCHAR2 DEFAULT 'N',
458 p_task_flg IN VARCHAR2 DEFAULT 'N',
459 p_fin_elem_flg IN VARCHAR2 DEFAULT 'N',
460 p_ver_name IN VARCHAR2,
461 p_ver_disp_cd IN VARCHAR2,
462 p_ledger_desc IN VARCHAR2
463 );
464
465 PROCEDURE Register_Ledger (
466 p_api_version IN NUMBER DEFAULT c_api_version,
467 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
468 p_commit IN VARCHAR2 DEFAULT c_false,
469 p_encoded IN VARCHAR2 DEFAULT c_true,
470 x_return_status OUT NOCOPY VARCHAR2,
471 x_msg_count OUT NOCOPY NUMBER,
472 x_msg_data OUT NOCOPY VARCHAR2,
473 p_ledger_id IN NUMBER,
474 p_display_code IN VARCHAR2,
475 p_ledger_name IN VARCHAR2,
476 p_func_curr_cd IN VARCHAR2,
477 p_source_cd IN NUMBER,
478 p_cal_per_hid IN NUMBER,
479 p_global_vs_id IN NUMBER,
480 p_epb_def_lg_flg IN VARCHAR2,
481 p_ent_curr_flg IN VARCHAR2,
482 p_avg_bal_flg IN VARCHAR2,
483 p_chan_flg IN VARCHAR2 DEFAULT 'N',
484 p_cctr_flg IN VARCHAR2 DEFAULT 'N',
485 p_cust_flg IN VARCHAR2 DEFAULT 'N',
486 p_geog_flg IN VARCHAR2 DEFAULT 'N',
487 p_ln_item_flg IN VARCHAR2 DEFAULT 'N',
488 p_nat_acct_flg IN VARCHAR2 DEFAULT 'N',
489 p_prod_flg IN VARCHAR2 DEFAULT 'N',
490 p_proj_flg IN VARCHAR2 DEFAULT 'N',
491 p_entity_flg IN VARCHAR2 DEFAULT 'N',
492 p_user1_flg IN VARCHAR2 DEFAULT 'N',
493 p_user2_flg IN VARCHAR2 DEFAULT 'N',
494 p_user3_flg IN VARCHAR2 DEFAULT 'N',
498 p_user7_flg IN VARCHAR2 DEFAULT 'N',
495 p_user4_flg IN VARCHAR2 DEFAULT 'N',
496 p_user5_flg IN VARCHAR2 DEFAULT 'N',
497 p_user6_flg IN VARCHAR2 DEFAULT 'N',
499 p_user8_flg IN VARCHAR2 DEFAULT 'N',
500 p_user9_flg IN VARCHAR2 DEFAULT 'N',
501 p_user10_flg IN VARCHAR2 DEFAULT 'N',
502 p_task_flg IN VARCHAR2 DEFAULT 'N',
503 p_fin_elem_flg IN VARCHAR2 DEFAULT 'N',
504 p_ver_name IN VARCHAR2,
505 p_ver_disp_cd IN VARCHAR2,
506 p_ledger_desc IN VARCHAR2
507 );
508
509 PROCEDURE New_Encumbrance_Type (
510 p_api_version IN NUMBER DEFAULT c_api_version,
511 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
512 p_commit IN VARCHAR2 DEFAULT c_false,
513 p_encoded IN VARCHAR2 DEFAULT c_true,
514 x_return_status OUT NOCOPY VARCHAR2,
515 x_msg_count OUT NOCOPY NUMBER,
516 x_msg_data OUT NOCOPY VARCHAR2,
517 x_enc_type_id OUT NOCOPY NUMBER,
518 p_enc_type_code IN VARCHAR2,
519 p_enc_type_name IN VARCHAR2,
520 p_enc_type_desc IN VARCHAR2,
521 p_source_cd IN NUMBER,
522 p_ver_name IN VARCHAR2,
523 p_ver_disp_cd IN VARCHAR2
524 );
525
526 PROCEDURE Register_Encumbrance_Type (
527 p_api_version IN NUMBER DEFAULT c_api_version,
528 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
529 p_commit IN VARCHAR2 DEFAULT c_false,
530 p_encoded IN VARCHAR2 DEFAULT c_true,
531 x_return_status OUT NOCOPY VARCHAR2,
532 x_msg_count OUT NOCOPY NUMBER,
533 x_msg_data OUT NOCOPY VARCHAR2,
534 p_enc_type_id IN NUMBER,
535 p_enc_type_code IN VARCHAR2,
536 p_enc_type_name IN VARCHAR2,
537 p_enc_type_desc IN VARCHAR2,
538 p_source_cd IN NUMBER,
539 p_ver_name IN VARCHAR2,
540 p_ver_disp_cd IN VARCHAR2
541 );
542
543 PROCEDURE New_Global_VS_Combo (
544 p_api_version IN NUMBER DEFAULT c_api_version,
545 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
546 p_commit IN VARCHAR2 DEFAULT c_false,
547 p_encoded IN VARCHAR2 DEFAULT c_true,
548 x_return_status OUT NOCOPY VARCHAR2,
549 x_msg_count OUT NOCOPY NUMBER,
550 x_msg_data OUT NOCOPY VARCHAR2,
551 x_global_vs_combo_id OUT NOCOPY NUMBER,
552 p_global_vs_combo_name IN VARCHAR2,
553 p_global_vs_combo_desc IN VARCHAR2 DEFAULT NULL,
554 p_read_only_flag IN VARCHAR2 DEFAULT 'N',
555 p_enabled_flag IN VARCHAR2 DEFAULT 'Y',
556 p_global_vs_combo_dc IN VARCHAR2 DEFAULT NULL
557 );
558
559 PROCEDURE Get_Dim_Attr_ID_Ver_ID (
560 p_dim_id IN NUMBER,
561 p_attr_label IN VARCHAR,
562 x_attr_id OUT NOCOPY NUMBER,
563 x_ver_id OUT NOCOPY NUMBER,
564 x_err_code OUT NOCOPY NUMBER
565 );
566
567 FUNCTION Get_Dim_Member_ID (
568 p_api_version IN NUMBER DEFAULT 1.0,
569 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
570 p_commit IN VARCHAR2 DEFAULT c_false,
571 p_encoded IN VARCHAR2 DEFAULT c_true,
572 x_return_status OUT NOCOPY VARCHAR2,
573 x_msg_count OUT NOCOPY NUMBER,
574 x_msg_data OUT NOCOPY VARCHAR2,
575 p_dimension_varchar_label IN VARCHAR2,
576 p_member_display_code IN VARCHAR2,
577 p_member_vs_display_code IN VARCHAR2
578 ) RETURN VARCHAR2;
579
580 FUNCTION Get_Dim_Attr_Name (
581 p_attr_id IN NUMBER
582 ) RETURN VARCHAR2;
583
584 FUNCTION Get_Dim_Attr_Name (
585 p_dim_id IN NUMBER,
586 p_attr_label IN VARCHAR2
587 ) RETURN VARCHAR2;
588
589 FUNCTION Get_Dim_Attr_Name (
590 p_dim_label IN VARCHAR2,
591 p_attr_label IN VARCHAR2
595 p_dim_id IN NUMBER
592 ) RETURN VARCHAR2;
593
594 FUNCTION Get_Dimension_Name (
596 ) RETURN VARCHAR2;
597
598 FUNCTION Get_Dimension_Name (
599 p_dim_label IN VARCHAR2
600 ) RETURN VARCHAR2;
601
602 PROCEDURE Validate_OA_Params (
603 p_api_version IN NUMBER,
604 p_init_msg_list IN VARCHAR2,
605 p_commit IN VARCHAR2,
606 p_encoded IN VARCHAR2,
607 x_return_status OUT NOCOPY VARCHAR2
608 );
609
610 PROCEDURE Get_Default_Dim_Member (
611 p_api_version IN NUMBER DEFAULT 1.0,
612 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
613 p_commit IN VARCHAR2 DEFAULT c_false,
614 p_encoded IN VARCHAR2 DEFAULT c_true,
615 p_dimension_id IN NUMBER DEFAULT NULL,
616 p_dimension_varchar_label IN VARCHAR2 DEFAULT NULL,
617 p_ledger_id IN NUMBER DEFAULT NULL,
618 x_member_code OUT NOCOPY VARCHAR2,
619 x_member_data_type OUT NOCOPY VARCHAR2,
620 x_member_display_code OUT NOCOPY VARCHAR2,
621 x_return_status OUT NOCOPY VARCHAR2,
622 x_msg_count OUT NOCOPY NUMBER,
623 x_msg_data OUT NOCOPY VARCHAR2
624 );
625
626 PROCEDURE Get_Default_Dim_Member (
627 p_api_version IN NUMBER DEFAULT 1.0,
628 p_init_msg_list IN VARCHAR2 DEFAULT c_false,
629 p_commit IN VARCHAR2 DEFAULT c_false,
630 p_encoded IN VARCHAR2 DEFAULT c_true,
631 p_table_name IN VARCHAR2,
632 p_column_name IN VARCHAR2,
633 p_ledger_id IN NUMBER DEFAULT NULL,
634 x_member_code OUT NOCOPY VARCHAR2,
635 x_member_data_type OUT NOCOPY VARCHAR2,
636 x_member_display_code OUT NOCOPY VARCHAR2,
637 x_return_status OUT NOCOPY VARCHAR2,
638 x_msg_count OUT NOCOPY NUMBER,
639 x_msg_data OUT NOCOPY VARCHAR2
640 );
641
642 FUNCTION Get_Dim_Member_Display_Code (
643 p_dimension_id IN NUMBER,
644 p_dimension_member_id IN VARCHAR2,
645 p_dimension_member_vs_id IN NUMBER DEFAULT NULL
646 ) RETURN VARCHAR2;
647
648 FUNCTION Get_Dim_Member_Name (
649 p_dimension_id IN NUMBER,
650 p_dimension_member_id IN VARCHAR2,
651 p_dimension_member_vs_id IN NUMBER DEFAULT NULL
652 ) RETURN VARCHAR2;
653
654 END FEM_Dimension_Util_Pkg;
655
656