1 PACKAGE FA_BASIS_OVERRIDE_INIT_PKG as
2 /* $Header: FADBOIS.pls 120.5 2005/06/23 21:44:00 dfred noship $ */
3
4
5 /*
6 --------------------------------------------------------------------------
7 *
8 * Name
9 * facodda()
10 *
11 * Description
12 * Override the Default Depreciation Amounts - cover from Pro*C
13 * Parameters
14 *
15 * Modifies
16 *
17 * Returns
18 * True on successful completion. Otherwise False.
19 *
20 * Notes
21 *
22 * History
23 * FEB 15, 2002 astakaha created
24 * OCT 02, 2002 ynatsui added p_mrc_sob_type_code
25 * DEC 05, 2002 ynatsui added ytd parameteres
26 *--------------------------------------------------------------------------
27 */
28 FUNCTION facodda(Book IN VARCHAR2,
29 Used_By_Adjustment IN number,
30 Asset_ID IN NUMBER,
31 Bonus_Rule IN VARCHAR2,
32 Fyctr IN NUMBER,
33 Perd_Ctr IN NUMBER,
34 Prod_Rate_Src_Flag IN number,
35 Deprn_Projecting_Flag IN number,
36 p_ytd_deprn IN NUMBER,
37 p_bonus_ytd_deprn IN NUMBER,
38 Override_Depr_Amt OUT NOCOPY NUMBER,
39 Override_Bonus_Amt OUT NOCOPY NUMBER,
40 Deprn_Override_Flag OUT NOCOPY VARCHAR2,
41 Return_Code OUT NOCOPY NUMBER,
42 p_mrc_sob_type_code IN VARCHAR2 DEFAULT NULL,
43 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
44 ) return number;
45
46 ----------------------------------------------------------------------------
47 --
48 -- Name
49 -- faxccdb()
50 --
51 -- Description
52 -- Depreciable Basis Formula feature - cover from Pro*C
53 -- Parameters
54 --
55 -- Modifies
56 --
57 -- Returns
58 -- True on successful completion. Otherwise False.
59 --
60 -- Notes
61 --
62 -- History
63 -- FEB 15, 2002 hsugimot Created
64 -- OCT 09, 2002 hsugimot Added new parameters
65 -- for group depreciation
66 ----------------------------------------------------------------------------
67
68
69 FUNCTION faxccdb(event_type in varchar2,
70 asset_id in number default 0,
71 group_asset_id in number default 0,
72 book_type_code in varchar2 default null,
73 asset_type in varchar2 default null,
74 depreciate_flag in varchar2 default null,
75 method_code in varchar2 default null,
76 life_in_months in number default 0,
77 method_id in number default 0,
78 method_type in varchar2 default null,
79 calc_basis in varchar2 default null,
80 adjustment_amount in number default 0,
81 transaction_flag in varchar2 default null,
82 cost in number default 0,
83 salvage_value in number default 0,
84 recoverable_cost in number default 0,
85 adjusted_cost in number default 0,
86 current_total_rsv in number default 0,
87 current_rsv in number default 0,
88 current_total_ytd in number default 0,
89 current_ytd in number default 0,
90 hyp_basis in number default 0,
91 hyp_total_rsv in number default 0,
92 hyp_rsv in number default 0,
93 hyp_total_ytd in number default 0,
94 hyp_ytd in number default 0,
95 old_adjusted_cost in number default 0,
96 old_raf in number default 0,
97 old_formula_factor in number default 0,
98 new_adjusted_cost out NOCOPY number,
99 new_raf out NOCOPY number,
100 new_formula_factor out NOCOPY number,
101 -- new parameter for group depreciation
102 p_period_counter in number default null,
103 p_fiscal_year in number default null,
104 p_eofy_reserve in number default null,
105 p_tracking_method in varchar2 default null,
106 p_allocate_to_fully_rsv_flag in varchar2 default null,
107 p_allocate_to_fully_ret_flag in varchar2 default null,
108 p_depreciation_option in varchar2 default null,
109 p_member_rollup_flag in varchar2 default null,
110 p_eofy_recoverable_cost in number default null,
111 p_eop_recoverable_cost in number default null,
112 p_eofy_salvage_value in number default null,
113 p_eop_salvage_value in number default null,
114 p_used_by_adjustment in number default null,
115 p_eofy_flag in varchar2 default null,
116 -- new parameter for polish enhancement
117 p_polish_rule in number default
118 FA_STD_TYPES.FAD_DBR_POLISH_NONE,
119 p_deprn_factor in number default null,
120 p_alternate_deprn_factor in number default null,
121 p_mrc_sob_type_code in varchar2 default 'N',
122 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
123 ) return number;
124
125 /*
126 --------------------------------------------------------------------------
127 *
128 * Name
129 * faoddat()
130 *
131 * Description
132 * Update the deprn_override_trigger_enabled global variable
133 * Parameters
134 *
135 * Modifies
136 *
137 * Returns
138 * True on successful completion. Otherwise False.
139 *
140 * Notes
141 *
142 * History
143 * MAR 5, 2002 astakaha created
144 *--------------------------------------------------------------------------
145 */
146 FUNCTION faoddat(deprn_override_trigger in number,
147 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
148 Return number;
149
150
151 END FA_BASIS_OVERRIDE_INIT_PKG;