1 PACKAGE FA_GAINLOSS_MIS_PKG AS
2 /* $Header: fagmiss.pls 120.2 2005/06/24 02:23:25 lson ship $*/
3
4 /*============================================================================
5 | NAME faggfy |
6 | |
7 | FUNCTION It returns the fiscal year, prorate_calendar, prorate_periods|
8 | per_year through the input parameter 'xdate" |
9 | |
10 | HISTORY 1/12/89 R Rumanang Created |
11 | 08/09/90 M Chan Modified for MPL 8 |
12 | 01/08/97 S Behura Rewrote into PL/SQL |
13 |===========================================================================*/
14
15 FUNCTION faggfy(xdate in date, p_cal in out nocopy varchar2,
16 pro_month in out nocopy number, fiscalyr in out number,
17 fiscal_year_name in out nocopy varchar2,
18 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
19
20 /*===========================================================================
21 | NAME fagpdi |
22 | |
23 | FUNCTION Return period information based on the deprn_calendar and |
24 | prorate_calendar |
25 | |
26 | HISTORY 01/12/89 R Rumanang Created |
27 | 06/23/89 R Rumanang Standarized |
28 | 08/21/90 M Chan return p_pds_per_year |
29 | 04/04/91 M Chan restructure the function |
30 | 01/09/97 S Behura Rewrote in PL/SQL |
31 |===========================================================================*/
32
33 Function fagpdi(book_type in varchar2, pds_per_year_ptr in out nocopy number,
34 period_type in out nocopy varchar2, cpdname in varchar2,
35 cpdnum in out nocopy number, ret_p_date in out date,
36 ret_pd in out nocopy number, p_pds_per_year_ptr in out number,
37 fiscal_year_name in out nocopy varchar2,
38 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) Return BOOLEAN;
39
40 /*===========================================================================
41 | NAME faggbi |
42 | |
43 | FUNCTION Returns book information based on a retirement-id |
44 | |
45 | HISTORY 1/12/89 R Rumanang Created |
46 | 6/23/89 R Rumanang Standarized |
47 | 7/11/89 R Rumanang Fixed a bug in getting |
48 | prorate date. There maybe |
49 | possible to have 2 rows |
50 | for calendar type year. |
51 | 8/8/90 M Chan Add prorate calendar |
52 | 04/02/91 M Chan Rewrite the routine |
53 | 01/09/97 S Behura Rewrote in PL/SQL |
54 |===========================================================================*/
55
56 FUNCTION faggbi(bk in out nocopy fa_ret_types.book_struct,
57 ret in out nocopy fa_ret_types.ret_struct,
58 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) Return BOOLEAN;
59
60 END FA_GAINLOSS_MIS_PKG;