1 PACKAGE FA_CACHE_PKG AUTHID CURRENT_USER as
2 /* $Header: FACACHES.pls 120.16 2011/01/28 08:39:31 saalampa ship $ */
3
4 -- deprn method global variables
5 -- added for new alternative flat depreciation adjustment.
6
7 g_max_array_size number := 200;
8
9 -- PRIVATE TYPES
10 --
11
12 TYPE fazcff_type is RECORD (
16 frac number,
13 book_type_code varchar2(15),
14 calendar_type varchar2(15),
15 fiscal_year number,
17 start_jdate number,
18 end_jdate number);
19
20 TYPE fazccp_type is RECORD (
21 t_calendar varchar2(30),
22 t_fy_name varchar2(30),
23 t_jdate number,
24 period_num number,
25 fiscal_year number,
26 start_jdate number);
27
28 TYPE fazccl_type is RECORD (
29 t_ceiling_name varchar2(30),
30 t_jdate number,
31 t_year number,
32 ceiling number);
33
34 TYPE fazcbr_type is RECORD (
35 t_bonus_rule varchar2(30),
36 t_year number,
37 bonus_rate number,
38 deprn_factor number,
39 alternate_deprn_factor number);
40
41 -- BUG# 1910033 - added for mrc
42 TYPE fazcsob_type is record(
43 set_of_books_id number,
44 mrc_sob_type_code varchar2(1));
45
46
47 TYPE fazctbk_pvt_rec_type IS RECORD
48 (corp_book varchar2(15),
49 tax_book varchar2(15),
50 allow_cip_assets_flag varchar2(3),
51 immediate_copy_flag varchar2(3),
52 copy_group_addition_flag varchar2(3)
53 );
54
55 TYPE fazcrsob_pvt_rec_type IS RECORD
56 (book_type_code varchar2(15),
57 set_of_books_id number
58 );
59
60 TYPE fazcdp_rec_type IS RECORD
61 (book_type_code varchar2(15),
62 period_name varchar2(15),
63 period_counter number,
64 fiscal_year number,
65 period_num number,
66 period_open_date date,
67 period_close_date date,
68 calendar_period_open_date date,
69 calendar_period_close_date date,
70 deprn_run varchar2(1)
71 );
72
73 TYPE fazcsgr_rec_type IS RECORD
74 (super_group_id number,
75 book_type_code varchar2(15),
76 start_period_counter number(15),
77 end_period_counter number(15),
78 deprn_method_code varchar2(15),
79 basic_rate number,
80 adjusted_rate number,
81 percent_salvage_value number
82 );
83
84 TYPE fazcdbr_rec_type is RECORD (
85 deprn_basis_rule_id FA_DEPRN_BASIS_RULES.DEPRN_BASIS_RULE_ID%TYPE,
86 rule_name FA_DEPRN_BASIS_RULES.RULE_NAME%TYPE,
87 user_rule_name FA_DEPRN_BASIS_RULES.USER_RULE_NAME%TYPE,
88 last_update_date FA_DEPRN_BASIS_RULES.LAST_UPDATE_DATE%TYPE,
89 last_updated_by FA_DEPRN_BASIS_RULES.LAST_UPDATED_BY%TYPE,
90 created_by FA_DEPRN_BASIS_RULES.CREATED_BY%TYPE,
91 creation_date FA_DEPRN_BASIS_RULES.CREATION_DATE%TYPE,
92 last_update_login FA_DEPRN_BASIS_RULES.LAST_UPDATE_LOGIN%TYPE,
93 rate_source FA_DEPRN_BASIS_RULES.RATE_SOURCE%TYPE,
94 deprn_basis FA_DEPRN_BASIS_RULES.DEPRN_BASIS%TYPE,
95 enabled_flag FA_DEPRN_BASIS_RULES.ENABLED_FLAG%TYPE,
96 program_name FA_DEPRN_BASIS_RULES.PROGRAM_NAME%TYPE,
97 description FA_DEPRN_BASIS_RULES.DESCRIPTION%TYPE,
98 polish_rule NUMBER
99 );
100
101 -- BUG# 1913745 - implementing arrays to recuce db hits
102
103 TYPE fazcbc_type_tab is table of FA_BOOK_CONTROLS%RowType
104 index by binary_integer;
105 TYPE fazcct_type_tab is table of FA_CALENDAR_TYPES%RowType
106 index by binary_integer;
107 TYPE fazcff_type_tab is table of fazcff_type
108 index by binary_integer;
109 TYPE fazccp_type_tab is table of fazccp_type
110 index by binary_integer;
111 TYPE fazccb_type_tab is table of FA_CATEGORY_BOOKS%RowType
112 index by binary_integer;
113 TYPE fazccmt_type_tab is table of FA_METHODS%Rowtype
114 index by binary_integer;
115 TYPE fazccl_type_tab is table of fazccl_type
116 index by binary_integer;
117 TYPE fazcbr_type_tab is table of fazcbr_type
118 index by binary_integer;
119 TYPE fazcsob_type_tab is table of fazcsob_type
120 index by binary_integer;
121 TYPE fazccbd_type_tab is table of FA_CATEGORY_BOOK_DEFAULTS%rowtype
122 index by binary_integer;
123 TYPE fazcat_type_tab is table of FA_CATEGORIES%rowtype
124 index by binary_integer;
125 TYPE fazctbk_tbl_type IS TABLE OF VARCHAR2(15)
126 INDEX BY BINARY_INTEGER;
130 INDEX BY BINARY_INTEGER;
127 TYPE fazctbk_pvt_tbl_type IS TABLE OF fazctbk_pvt_rec_type
128 INDEX BY BINARY_INTEGER;
129 TYPE fazcrsob_sob_tbl_type IS TABLE OF NUMBER
131 TYPE fazcrsob_book_tbl_type IS TABLE OF VARCHAR2(15)
132 INDEX BY BINARY_INTEGER;
133 TYPE fazcrsob_pvt_tbl_type IS TABLE OF fazcrsob_pvt_rec_type
134 INDEX BY BINARY_INTEGER;
135 TYPE fazccvt_type_tab is table of FA_CONVENTION_TYPES%rowtype
136 index by binary_integer;
137 TYPE fazcfy_type_tab is table of FA_FISCAL_YEAR%rowtype
138 index by binary_integer;
142 index by binary_integer;
139 TYPE fazcdp_type_tab is table of fazcdp_rec_type
140 index by binary_integer;
141 TYPE fazcdbr_type_tab is table of fazcdbr_rec_type
143 TYPE fazcfor_type_tab is table of FA_FORMULAS%rowtype
144 index by binary_integer;
145 TYPE fazcdrd_type_tab is table of FA_DEPRN_RULE_DETAILS%rowtype
146 index by binary_integer;
147 TYPE fazcsgr_type_tab is table of fazcsgr_rec_type
148 index by binary_integer;
149
150 -- fazcbc variables
151 fazcbc_record FA_BOOK_CONTROLS%RowType;
152 fazcbc_table fazcbc_type_tab;
153 fazcbc_index number; -- used to store the index of last
154 -- book's position in array. will
155 -- be used to delete a member when
156 -- transaction approval finds it stale
157
158 -- fazcbcs variables
159 fazcbcs_record FA_BOOK_CONTROLS%RowType;
160 fazcbcs_table fazcbc_type_tab;
161 fazcbcs_index number; -- used to store the index of last
162 -- book's position in array. will
163 -- be used to delete a member when
164 -- transaction approval finds it stale
165
166
167
168 -- fazcct variables
169 fazcct_record FA_CALENDAR_TYPES%RowType;
170 fazcct_table fazcct_type_tab;
171
172 -- faxcff variables
173 fazcff_record fazcff_type;
174 fazcff_table fazcff_type_tab;
175
176 -- fazccl variables
177 fazccl_record fazccl_type;
178 fazccl_table fazccl_type_tab;
179
180 -- fazcbr variables
181 fazcbr_record fazcbr_type;
182 fazcbr_table fazcbr_type_tab;
183
184 -- fazccp variables
185 fazccp_record fazccp_type;
186 fazccp_table fazccp_type_tab;
187
188 -- fazccb variables
189 fazccb_record FA_CATEGORY_BOOKS%RowType;
190 fazccb_table fazccb_type_tab;
191
192 -- fazccmt variables
193 fazccmt_record FA_METHODS%RowType;
194 fazccmt_table fazccmt_type_tab;
195
196 -- fazcsob variables (added for mrc)
197 fazcsob_record fazcsob_type;
198 fazcsob_table fazcsob_type_tab;
199
200 -- fazccbd variables
201 fazccbd_record FA_CATEGORY_BOOK_DEFAULTS%RowType;
202 fazccbd_table fazccbd_type_tab;
203
204 -- fazcat variables
205 fazcat_record FA_CATEGORIES%RowType;
206 fazcat_table fazcat_type_tab;
207
208 -- fazsys variables
209 fazsys_record FA_SYSTEM_CONTROLS%RowType;
210
211 -- fazctbk variables
212 fazctbk_last_book_used VARCHAR2(15);
213 fazctbk_last_type_used VARCHAR2(15);
214 fazctbk_main_tbl fazctbk_pvt_tbl_type;
215 fazctbk_corp_tbl fazctbk_tbl_type;
219 fazcrsob_last_book_used VARCHAR2(15);
216 fazctbk_tax_tbl fazctbk_tbl_type;
217
218 -- fazcrsob variables
220 fazcrsob_main_tbl fazcrsob_pvt_tbl_type;
221 fazcrsob_book_tbl fazcrsob_book_tbl_type;
222 fazcrsob_sob_tbl fazcrsob_sob_tbl_type;
223
224 -- fazccvt variables
225 fazccvt_record FA_CONVENTION_TYPES%RowType;
226 fazccvt_table fazccvt_type_tab;
227
228 -- fazcfy variables
229 fazcfy_record FA_FISCAL_YEAR%RowType;
230 fazcfy_table fazcfy_type_tab;
231
232 -- fazcdp variables
233 fazcdp_record fazcdp_rec_type;
234 fazcdp_table fazcdp_type_tab;
235 fazcdp_index number; -- used to store the index of last
236 -- period's position in array. will
237 -- be used to delete a member when
238 -- transaction approval finds it stale
239
240 -- fazcdbr variables
241 fazcdbr_record fazcdbr_rec_type;
242 fazcdbr_table fazcdbr_type_tab;
243 fazcdbr_index number;
244
245 -- fazcfor variables
246 fazcfor_record fa_formulas%RowType;
247 fazcfor_table fazcfor_type_tab;
248 fazcfor_index number;
249
250
251 -- fazcdrd variables
252 fazcdrd_record fa_deprn_rule_details%RowType;
253 fazcdrd_table fazcdrd_type_tab;
254 fazcdrd_index number;
255
256 -- fazcdp variables
257 fazcsgr_record fazcsgr_rec_type;
258 fazcsgr_table fazcsgr_type_tab;
259
260 -- fazarel variables
261
262 -- we are defaulting here to a high number to
263 -- address the risk of INIT_CALLBACK removal
264 -- poses to certain low level routines (such as debug)
265 -- where a null value would have the opposite effect
266 -- then what is intended
267
268 -- Further more sense INIT_CALLBACK was currently
269 -- removed in 12.0, we give will give precidense to
270 -- the higher release if this occurs.
271
272 fazarel_release number := 999999999;
273
274 fazarel_release_name varchar2(30);-- Bug 10636707 - Character date international calendar support
275
276
277 -- profile variables
278 -- we will be caching these profile values as it's simply
279 -- to expensive to continously call the fnd_profile code - bmr
280
281 fa_profile_init boolean := FALSE;
282 fa_crl_enabled boolean ;
283 fa_print_debug boolean ;
284 fa_debug_file varchar2(240) ;
285 fa_large_rollback varchar2(240) ;
286 fa_use_threshold boolean ;
287 fa_gen_expense_account boolean ;
288 fa_pregen_asset_account boolean ;
289 fa_pregen_book_account boolean ;
290 fa_pregen_cat_account boolean ;
294 fa_enabled_deprn_basis_formula boolean ;
291 fa_mcp_all_cost_adj boolean ;
292 fa_annual_round varchar2(240) ;
293 fa_deprn_override_enabled boolean ;
295
296 fa_batch_size number ;
297 fa_custom_gen_ccid boolean ;
301 -- fa_cache_usage number ;
298
299 -- not frequently used in pl/sql
300 -- fa_time_diagnostic varchar2(3) ;
302 -- fa_num_par_requests number ;
303 -- fa_num_massadd_par_requests number ;
304 -- fa_num_genaccts_par_requests number ;
305 -- fa_security_profile_id varchar2(240) ;
306
307 -- fa_archive_table_size number ;
308 -- fa_ins_swiss_builing varchar2(3) ;
309 -- fa_deprn_single varchar2(3) ;
310 -- fa_default_dpis_to_inv_date varchar2(3) ;
311 -- fa_include_nonrec_tax_massadds varchar2(3) ;
312 -- FADI_ASSET_CREATION_PRIVS varchar2() ;
313 -- FADI_ASSET_PI_PRIVS varchar2() ;
314
315 /*
316 --------------------------------------------------------------------------
317 *
318 * Name
319 * fazcbc
320 *
321 * Description
322 * Cache FA_BOOK_CONTROLS information
323 *
324 * Parameters
325 * X_book - book type code to get information about
326 *
327 * Modifies
328 * fazcbc_record - stores book information in this
329 * structure.
330 * fazcct_last_used - stores book type code most
331 * recently retrieved.
332 *
333 * Returns
334 * True on successful retrieval. Otherwise False.
335 *
336 * Notes
337 *
338 * History
339 *
340 *--------------------------------------------------------------------------
341 */
342 FUNCTION fazcbc
343 (
344 X_book in varchar2
345 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
346 return boolean;
347
348
349 /*
350 --------------------------------------------------------------------------
351 *
352 * Name
353 * fazcbcs
354 *
355 * Description
356 * Cache FA_BOOK_CONTROLS by SOB information
357 *
358 * Parameters
359 * X_book - book type code to get information about
360 *
361 * Modifies
362 * fazcbcs_record - stores book information in this
363 * structure.
364 * fazcbcs_table - stores book information in this
365 * array
366 *
367 * Returns
368 * True on successful retrieval. Otherwise False.
369 *
370 * Notes
371 *
372 * This can be used for transaction bases processing in MRC
373 * namely for retrieving values that may differ between the
374 * primary and reporting books.
375 *
376 * Both the gl sob profile and currency_context must be set for
377 * this to retrieve the reporting book info.
378 *
379 * History
380 * 08-08-2001 bridgway created
381 *
382 *--------------------------------------------------------------------------
383 */
384 FUNCTION fazcbcs
385 (
386 X_book in varchar2,
387 X_set_of_books_id in number,
388 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
389 return boolean;
390
391
392 /*
393 --------------------------------------------------------------------------
394 *
395 * Name
396 * fazcbc_clr
397 *
398 * Description
399 * Cache FA_BOOK_CONTROLS clear row function
400 *
401 * Parameters
402 * X_book - book type code to get information about
403 * not currently used (always deletes lat used row)
404 * Modifies
405 * fazcbc_record_array - remove book info in array
406 * fazcct_record - remove book info in record
407 *
408 * Returns
409 * True on successful removal. Otherwise False.
410 *
411 * Notes
412 *
413 * History 08/06/01 bridgway created
414 *
415 *--------------------------------------------------------------------------
416 */
417 FUNCTION fazcbc_clr
418 (
419 X_book in varchar2
420 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
421 return boolean;
422
423
424 /*
425 --------------------------------------------------------------------------
426 *
427 * Name
428 * fazcct
429 *
430 * Description
431 * Cache FA_CALENDAR_TYPES information
432 *
433 * Parameters
434 * X_calendar - calendar type to get information about
435 *
436 * Modifies
437 * fazcct_record - stores calendar information in this
438 * structure.
439 * fazcct_last_used - stores calendar type most
440 * recently retrieved.
441 *
442 * Returns
443 * True on successful retrieval. Otherwise False.
444 *
445 * Notes
446 *
447 * History
448 *
449 *--------------------------------------------------------------------------
450 */
451 FUNCTION fazcct
452 (
453 X_calendar in varchar2
454 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
455 return boolean;
456
457
458 /*
459 --------------------------------------------------------------------------
460 *
461 * Name
465 * Cache fractions of Fiscal Year for Calendar Periods
462 * fazcff
463 *
464 * Description
466 *
467 * Parameters
468 * X_calendar - calendar type
469 * X_book - book_type_code
470 * X_fy - fiscal_year
471 * X_period_fracs - table to put fractions (OUT)
472 *
473 * Modifies
474 * X_period_fracs
475 *
476 * Returns
477 * True on successful retrieval. Otherwise False.
478 *
479 * Notes
480 *
481 * History
482 *
483 *--------------------------------------------------------------------------
484 */
485 FUNCTION fazcff
486 (
487 X_calendar varchar2,
488 X_book varchar2,
489 X_fy integer,
490 X_period_fracs out NOCOPY fa_std_types.table_fa_cp_struct
494
491 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
492 return boolean;
493
495 /*
496 --------------------------------------------------------------------------
497 *
498 * Name
499 * fazccl
500 *
501 * Description
502 * Cache FA_CEILINGS information
503 *
504 * Parameters
505 * X_target_ceiling_name - ceiling name
506 * X_target_year - year_of_life
507 * X_target_jdate - start_date
508 * X_ceiling - ceiling (OUT)
509 *
510 * Modifies
511 * X_ceiling
512 *
513 * Returns
514 * True on successful retrieval. Otherwise False.
515 *
516 * Notes
517 *
518 * History
519 *
520 *--------------------------------------------------------------------------
521 */
522 FUNCTION fazccl
523 (
524 X_target_ceiling_name varchar2,
525 X_target_jdate integer,
526 X_target_year integer,
527 X_ceiling out NOCOPY number
528 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
529 return boolean;
530
531
532 /*
533 --------------------------------------------------------------------------
534 *
535 * Name
536 * fazcbr
537 *
538 * Description
539 * Cache Bonus Rate
540 *
541 * Parameters
542 * X_target_bonus_rule - rule
543 * X_target_year - year
544 * X_bonus_rate - bonus_rate (OUT)
545 * X_deprn_factor - deprn_factor (OUT)
546 * X_alternate_deprn_factor - alternate_deprn_factor (OUT)
547 *
548 * Modifies
549 * X_bonus_rate
550 * X_deprn_factor
551 * X_alternate_deprn_factor
552 *
553 * Returns
554 * True on successful retrieval. Otherwise False.
555 *
556 * Notes
557 *
558 * History
559 *
560 *--------------------------------------------------------------------------
561 */
562 FUNCTION fazcbr
563 (
564 X_target_bonus_rule varchar2,
565 X_target_year number,
566 X_bonus_rate out NOCOPY number,
567 X_deprn_factor out NOCOPY number,
568 X_alternate_deprn_factor out NOCOPY number
569 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
570 return boolean;
571
572
573 /*
574 --------------------------------------------------------------------------
575 *
576 * Name
577 * fazccp
578 *
579 * Description
580 * Cache FA_CALENDAR_PERIODS and FA_FISCAL_YEAR information
581 *
582 * Parameters
583 * X_target_calendar - target calendar type
584 * X_target_fy_name - target fiscal year name
585 * X_target_jdate - target start date
586 * X_period_num (OUT) - period number
587 * X_fiscal_year (OUT) - fiscal year
588 * X_start_jdate (OUT) - start date
589 *
590 * Modifies
591 * X_period_num
592 * X_fiscal_year
593 * X_start_jdate
594 * fazccp_record - structure to store cached information
595 *
596 * Returns
597 * True on successful retrieval. Otherwise False.
598 *
599 * Notes
600 *
601 * History
602 *
603 *--------------------------------------------------------------------------
604 */
605 FUNCTION fazccp
606 (
607 X_target_calendar varchar2,
608 X_target_fy_name varchar2,
609 X_target_jdate number,
610 X_period_num in out NOCOPY number,
611 X_fiscal_year in out NOCOPY number,
615
612 X_start_jdate in out NOCOPY number
613 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
614 return boolean;
616
617 /*
618
619 --------------------------------------------------------------------------
620 *
621 * Name
622 * fazccmt
623 *
624 * Description
625 * Cache Methods
626 *
627 * Parameters
628 * X_method - method code
629 * X_life - life in months
630 * X_method_id - method id
631 * X_depr_last_year_flag - depreciate in last year flag
632 * X_rate_source_rule - rate source
633 * X_deprn_basis_rule - depreciation basis
634 * X_excl_salvage_val_flag - boolean
635 *
636 * Modifies
637 * X_method_id
638 * X_depr_last_year_flag
639 * X_rate_source_rule
640 * X_deprn_basis_rule
641 * X_excl_salvage_val_flag
642 *
643 * Returns
644 * True on successful retrieval. Otherwise False.
645 *
646 * Notes
647 *
648 * History
649 *
650 *--------------------------------------------------------------------------
651 */
652 FUNCTION fazccmt
653 (
654 X_method varchar2,
655 X_life integer
656 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
657 return boolean;
658
659
660 /*
661 --------------------------------------------------------------------------
662 *
663 * Name
664 * fazccb
665 *
666 * Description
667 * Cache FA_CATEGORY_BOOKS information
668 *
669 * Parameters
670 * X_book - book type code to get information about
671 * X_cat_id-category id to get the information about
672 * Modifies
673 * fazccb_record - stores category book information being
674 * retrieved.
675 * fazccb_last_book - stores book most recently retrieved
676 * fazccb_last_cat - stores category id most recently retrieved
677 * Returns
678 * True on successful retrieval. Otherwise False.
679 *
680 * Notes
681 *
682 * History
683 *
684 *--------------------------------------------------------------------------
685 */
686 FUNCTION fazccb
687 (
688 X_book in varchar2,
689 X_cat_id in number
690 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
691 return boolean;
692
693 /*
694 --------------------------------------------------------------------------
695 *
696 * Name
697 * fazcsob
698 *
699 * Description
703 * X_set_of_books_id - book type code to get information about
700 * Cache GL_SETS_OF_BOOKS information
701 *
702 * Parameters
704 * X_mrc_sob_type_code (OUT) - the value for the mrctype flag
705 * Modifies
706 * fazcsob_record - stores book information being retrieved
707 * fazcsob_last_sob - stores sob id most recently retrieved
708 * fazcsob_table - stores a list of of all sob's and the
709 * sob_type retrieved in the current session
710 *
711 * Returns
712 * True on successful retrieval. Otherwise False.
713 *
714 * Notes Currently, this is coded only toi return the value for the
715 * column in question. The Pro*C version could return any
716 * desired column and this could eaisly be modified to do
717 * the same
718 *
719 * History 07/30/2001 bridgway created
720 *
721 *--------------------------------------------------------------------------
722 */
723
724 FUNCTION fazcsob
725 (
726 X_set_of_books_id in number,
727 X_mrc_sob_type_code out NOCOPY varchar
728 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
729 return boolean;
730
731
732
733 /*
734 --------------------------------------------------------------------------
735 *
736 * Name
737 * fazccbd
738 *
739 * Description
740 * Cache FA_CATEGORY_BOOK_DEFAULTS information
741 *
742 * Parameters
743 * X_book - book type code to get information about
744 * X_cat_id - category id to get the information about
745 * X_dpis - julian dpis to get the information about
746 * Modifies
747 * fazccbd_record - stores category book information being retrieved
751 * Returns
748 * fazccbd_table - stores a list of all category book records
749 * retrieved in the current session
750 *
752 * True on successful retrieval. Otherwise False.
753 *
754 * Notes
755 *
756 * History 08/30/2001 bridgway created
757 *
758 *--------------------------------------------------------------------------
759 */
760 FUNCTION fazccbd
761 (
762 X_book in varchar2,
763 X_cat_id in number,
764 X_jdpis in number
765 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
766 return boolean;
767
768
769
770 /*
771 --------------------------------------------------------------------------
772 *
773 * Name
774 * fazcat
775 *
776 * Description
777 * Cache FA_CATEGORIES information
778 *
779 * Parameters
780 * X_cat_id - category id to get the information about
781 *
782 * Modifies
783 * fazcat_record - stores category being retrieved
784 * fazcat_table - stores a list of categories previously
785 * retrieved in the current session
786 *
787 * Returns
788 * True on successful retrieval. Otherwise False.
789 *
790 * Notes
791 *
792 * History 10/06/2001 bridgway created
793 *
794 *--------------------------------------------------------------------------
795 */
796 FUNCTION fazcat
797 (
798 X_cat_id in number
799 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
800 return boolean;
801
802
803
804 /*
805 --------------------------------------------------------------------------
806 *
807 * Name
808 * fazsys
809 *
810 * Description
811 * Cache FA_SYSTEM_CONTROLS information
812 *
813 * Parameters
814 * NONE
815 *
816 * Modifies
817 * fazsys_record - stores system control information
818 *
819 * Returns
820 * True on successful retrieval. Otherwise False.
821 *
822 * Notes
823 *
824 * History 10/06/2001 bridgway created
825 *
826 *--------------------------------------------------------------------------
827 */
828 FUNCTION fazsys ( p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) return boolean;
829
830
831 /*
832 *--------------------------------------------------------------------------
833 *
834 * Name
835 * fazctbk
836 *
837 * Description
838 * Cache FA_TAX_BOOKS information
839 *
840 * Used by the new APIs to retrieve the associated tax books
841 * for which we want to do cip-in-tax or autocopy on for a
842 * given transaction
843 *
844 * Parameters
845 * x_corp_book (in) - corporate book for which you wish to
846 * retrieve a list of tax books
847 * x_asset_type (in) - asset type for which to get associated
848 * tax books (CIP or CAPITALIZED)
849 * x_tax_book_tbl (out) - table of tax books for the book / type
850 *
851 * Modifies
852 * fazctbk_last_book_used last book for which cache was called
853 * fazctbk_last_type_used last asset_type for which the cache
854 * was called
855 * fazctbk_main_tbl private table storing all books and
856 * reporting sob_ids for which cache
857 * has been called
858 * fazctbk_corp_tbl private table storing list of all
859 * corporate books for which cache
860 * has been called
861 * fazctbk_tax_tbl private table storing the last
862 * list of tax book for the book in
863 * fazctbk_last_book_used
864 *
865 * Returns
866 * True on successful retrieval. Otherwise False.
867 *
868 * Notes
869 *
870 * History 11/02/2001 bridgway/yyoon created
871 *
872 *--------------------------------------------------------------------------
873 */
874
875 Function fazctbk
876 (
877 x_corp_book in varchar2,
878 x_asset_type in varchar2,
879 x_tax_book_tbl out NOCOPY fazctbk_tbl_type
880 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
881 return boolean;
882
883
884 /*
888 * fazcrsob
885 *--------------------------------------------------------------------------
886 *
887 * Name
889 *
890 * Description
891 * Cache REPORTING Set Of Books information
892 *
893 * Used by APIs to retrieve a list of all enabled and
894 * converted reporting options (by sob_id)
895 *
896 *
897 * Parameters
898 * x_book_type_code (IN) - book for which you wish to retrieve
899 * a listing of reporting options
900 * x_sob_tbl(OUT) - table of all enabled and converted
901 * sob_ids for this book
902 *
903 * Modifies
904 * x_sob_tbl (OUT param)
905 * fazcrsob_last_book_used last for which cache was called
906 * fazcrsob_main_tbl private table storing all books and
907 * reporting sob_ids for which cache
908 * has been called
909 * fazcrsob_book_tbl private table storing list of all books
910 * for which cache has been called
911 * fazcrsob_sob_tbl private table storing the last
912 * list of sob_ids for the last_book_used
913 *
914 * Returns
915 * True on successful retrieval. Otherwise False.
916 *
917 * Notes
918 *
919 * History 11/02/2001 bridgway/yyoon created
920 *
921 *--------------------------------------------------------------------------
922 */
923
924 Function fazcrsob
925 (
926 x_book_type_code in varchar2,
927 x_sob_tbl out NOCOPY fazcrsob_sob_tbl_type
928 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
929 return boolean;
930
931 /*
932 *--------------------------------------------------------------------------
933 *
934 * Name
935 * fazccvt
936 *
937 * Description
938 * Cache ConVention Types information
939 *
940 * Used by APIs to validate and retrieve a convention's info
941 *
942 *
943 * Parameters
944 * x_prorate_convention_code (IN) - convention which you wish
945 * to retrieve info
946 * x_fiscal_year_name (IN) - fy name for which you wish
947 * to retrieve info
948 *
949 * Modifies
950 * fazccvt_record - stores convention information being retrieved
951 * fazccvt_table - stores a table of all convention retrieved so far
952 *
953 * Returns
954 * True on successful retrieval. Otherwise False.
955 *
956 * Notes
957 *
958 * History 01/13/2002 bridgway created
959 *
960 *--------------------------------------------------------------------------
961 */
962
963 Function fazccvt
964 (
965 x_prorate_convention_code in varchar2,
966 x_fiscal_year_name in varchar2
967 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
968 return boolean;
969
970
971 /*
972 *--------------------------------------------------------------------------
973 *
974 * Name
975 * fazcfy
976 *
977 * Description
978 * Cache Fiscal Years information
979 *
980 * Used by APIs to validate and retrieve a fiscal years info
981 *
982 *
983 * Parameters
984 * x_fiscal_year_name (IN) - fy name for which you wish
985 * to retrieve info
986 * x_fiscal_year (IN) - fy for which you wish
987 * to retrieve info
988 *
989 * Modifies
990 * fazcfy_record - stores fy information being retrieved
991 * fazcfy_table - stores a table of all fy retrieved so far
992 *
993 * Returns
994 * True on successful retrieval. Otherwise False.
995 *
996 * Notes
997 *
998 * History 01/13/2002 bridgway created
999 *
1000 *--------------------------------------------------------------------------
1001 */
1002
1003 Function fazcfy
1004 (
1005 x_fiscal_year_name in varchar2,
1006 x_fiscal_year in number
1010 /*
1007 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1008 return boolean;
1009
1011 *--------------------------------------------------------------------------
1012 *
1013 * Name
1014 * fazcdp
1015 *
1016 * Description
1017 * Cache Deprn Period information
1018 *
1019 * Used by APIs to validate and retrieve deprn period info
1020 *
1021 *
1022 * Parameters
1023 * x_book_type_code (IN) - book for which you wish
1024 * to retrieve info
1025 * x_period_counter (IN) - period counter which you wish
1026 * to retrieve info
1027 * x_effective_date (IN) - date_effective for which you wish
1028 * to retrieve info
1029 *
1030 * Modifies
1031 * fazcdp_record - stores period information being retrieved
1032 * fazcdp_table - stores a table of all period retrieved so far
1033 * fazcdp_index - stores index in table of the info retireved
1034 *
1035 * Returns
1036 * True on successful retrieval. Otherwise False.
1037 *
1038 * Notes
1039 *
1040 * History 01/13/2002 bridgway created
1041 *
1042 *--------------------------------------------------------------------------
1043 */
1044
1045 Function fazcdp
1046 (
1047 x_book_type_code in varchar2,
1048 x_period_counter in number default null,
1049 x_effective_date in date default null
1050 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1051 return boolean;
1052
1053
1054 /*
1055 *--------------------------------------------------------------------------
1056 *
1057 * Name
1058 * fazcdp_clr
1059 *
1060 * Description
1061 * Cache Deprn Period information Clear Row
1062 *
1063 * Used by APIs to remove a stale row from cache
1064 *
1065 *
1066 * Parameters
1067 * x_book_type_code (IN) - not currently used
1068 * always deletes last accessed row
1069 *
1070 * Modifies
1071 * fazcdp_record - stores period information being retrieved
1072 * fazcdp_table - stores a table of all period retrieved so far
1073 *
1077 * Notes
1074 * Returns
1075 * True on successful retrieval. Otherwise False.
1076 *
1078 *
1079 * History 01/13/2002 bridgway created
1080 *
1081 *--------------------------------------------------------------------------
1082 */
1083
1084 Function fazcdp_clr
1085 (
1086 x_book in varchar2
1087 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1088 return boolean;
1089
1090 Function fazprof return boolean;
1091
1092 /*
1093 *--------------------------------------------------------------------------
1094 *
1095 * Name
1096 * fazcsgr
1097 *
1098 * Description
1099 * Cache Super Group Rule information
1100 *
1101 * Used by APIs to validate and retrieve super group rule info
1102 *
1103 *
1104 * Parameters
1105 * x_book_type_code (IN) - book for which you wish
1106 * to retrieve info
1107 * x_period_counter (IN) - period counter which you wish
1108 * to retrieve info
1109 *
1110 * Modifies
1111 * fazcsgr_record - stores super group rule information being retrieved
1112 * fazcsgr_table - stores a table of all super group rules retrieved so far
1113 *
1114 * Returns
1115 * True on successful retrieval. Otherwise False.
1116 *
1117 * Notes
1118 *
1119 *
1120 *--------------------------------------------------------------------------
1121 */
1122
1123 Function fazcsgr
1124 (
1125 x_super_group_id in number,
1126 x_book_type_code in varchar2,
1127 x_period_counter in number default null
1128 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
1129 return boolean;
1130
1131
1132 /*
1133 --------------------------------------------------------------------------
1134 *
1135 * Name
1136 * fazarel
1137 *
1138 * Description
1139 * Cache Applications RELease information
1140 *
1141 *
1142 * Modifies
1143 * fazarel_release - stores numeric representation of release
1144 *
1145 * Returns
1146 * True on successful retrieval. Otherwise False.
1147 *
1148 * Notes
1149 *
1150 * History
1151 *
1152 *--------------------------------------------------------------------------
1156
1153 */
1154
1155 Function fazarel return boolean;
1157
1158 END FA_CACHE_PKG;
[Home] [Help]