1 PACKAGE FA_BASIS_OVERRIDE_INIT_PKG AUTHID CURRENT_USER as
2 /* $Header: FADBOIS.pls 120.9 2009/06/12 09:26:17 bmaddine ship $ */
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_set_of_books_id IN NUMBER,
44 p_over_depreciate_option IN NUMBER DEFAULT NULL,
45 p_asset_type IN VARCHAR2 DEFAULT NULL,
46 p_deprn_rsv IN NUMBER DEFAULT NULL,
47 p_cur_adj_cost IN NUMBER DEFAULT NULL
48 ) return number;
49
50 ----------------------------------------------------------------------------
51 --
52 -- Name
53 -- faxccdb()
54 --
55 -- Description
56 -- Depreciable Basis Formula feature - cover from Pro*C
57 -- Parameters
58 --
59 -- Modifies
60 --
61 -- Returns
62 -- True on successful completion. Otherwise False.
63 --
64 -- Notes
65 --
66 -- History
67 -- FEB 15, 2002 hsugimot Created
68 -- OCT 09, 2002 hsugimot Added new parameters
69 -- for group depreciation
70 ----------------------------------------------------------------------------
71
72
73 FUNCTION faxccdb(event_type in varchar2,
74 asset_id in number default 0,
75 group_asset_id in number default 0,
76 book_type_code in varchar2 default null,
77 asset_type in varchar2 default null,
78 depreciate_flag in varchar2 default null,
79 method_code in varchar2 default null,
80 life_in_months in number default 0,
81 method_id in number default 0,
82 method_type in varchar2 default null,
83 calc_basis in varchar2 default null,
84 adjustment_amount in number default 0,
85 transaction_flag in varchar2 default null,
86 cost in number default 0,
87 salvage_value in number default 0,
88 recoverable_cost in number default 0,
89 adjusted_cost in number default 0,
90 current_total_rsv in number default 0,
91 current_rsv in number default 0,
92 current_total_ytd in number default 0,
93 current_ytd in number default 0,
94 hyp_basis in number default 0,
95 hyp_total_rsv in number default 0,
96 hyp_rsv in number default 0,
97 hyp_total_ytd in number default 0,
98 hyp_ytd in number default 0,
99 old_adjusted_cost in number default 0,
100 old_raf in number default 0,
101 old_formula_factor in number default 0,
102 new_adjusted_cost out NOCOPY number,
103 new_raf out NOCOPY number,
104 new_formula_factor out NOCOPY number,
105 -- new parameter for group depreciation
106 p_period_counter in number default null,
107 p_fiscal_year in number default null,
108 p_eofy_reserve in number default null,
109 p_tracking_method in varchar2 default null,
113 p_member_rollup_flag in varchar2 default null,
110 p_allocate_to_fully_rsv_flag in varchar2 default null,
111 p_allocate_to_fully_ret_flag in varchar2 default null,
112 p_depreciation_option in varchar2 default null,
114 p_eofy_recoverable_cost in number default null,
115 p_eop_recoverable_cost in number default null,
116 p_eofy_salvage_value in number default null,
117 p_eop_salvage_value in number default null,
118 p_used_by_adjustment in number default null,
119 p_eofy_flag in varchar2 default null,
120 -- new parameter for polish enhancement
121 p_polish_rule in number default
122 FA_STD_TYPES.FAD_DBR_POLISH_NONE,
123 p_deprn_factor in number default null,
124 p_alternate_deprn_factor in number default null,
125 p_impairment_reserve number default 0, -- P2IAS36
126 p_mrc_sob_type_code in varchar2 default 'N',
127 p_set_of_books_id in number
128 --
129 ) return number;
130
131 /*
132 --------------------------------------------------------------------------
133 *
134 * Name
135 * faoddat()
136 *
137 * Description
138 * Update the deprn_override_trigger_enabled global variable
139 * Parameters
140 *
141 * Modifies
142 *
143 * Returns
144 * True on successful completion. Otherwise False.
145 *
146 * Notes
147 *
148 * History
149 * MAR 5, 2002 astakaha created
150 *--------------------------------------------------------------------------
151 */
152 FUNCTION faoddat(deprn_override_trigger in number) Return number;
153
154 END FA_BASIS_OVERRIDE_INIT_PKG;