1 PACKAGE FA_POLISH_PVT AS
2 /* $Header: FAVPOLS.pls 120.4.12010000.1 2008/07/28 13:18:48 appldev ship $ */
3
4 CALLING_MODE varchar2(10);
5 AMORTIZATION_START_DATE date;
6 ADJUSTMENT_AMOUNT number;
7
8 PROCEDURE Calc_Polish_Rate_Cost (
9 p_Book_Type_Code IN VARCHAR2,
10 p_Asset_Id IN NUMBER,
11 p_Polish_Rule IN NUMBER,
12 p_Deprn_Factor IN NUMBER,
13 p_Alternate_Deprn_Factor IN NUMBER,
14 p_Polish_Adj_Calc_Basis_Flag
15 IN VARCHAR2,
16 p_Rate IN NUMBER,
17 p_Depreciate_Flag IN VARCHAR2,
18 p_Adjusted_Cost IN NUMBER,
19 p_Recoverable_Cost IN NUMBER,
20 p_Adjusted_Recoverable_Cost
21 IN NUMBER,
22 p_Fiscal_Year IN NUMBER,
23 p_Period_Num IN NUMBER,
24 p_Periods_Per_Year IN NUMBER,
25 p_Year_Retired IN VARCHAR2,
26 p_MRC_Sob_Type_Code IN VARCHAR2,
27 x_Rate OUT NOCOPY NUMBER,
28 x_Depreciate_Flag OUT NOCOPY VARCHAR2,
29 x_Adjusted_Cost OUT NOCOPY NUMBER,
30 x_Adjusted_Recoverable_Cost
31 OUT NOCOPY NUMBER,
32 x_Success OUT NOCOPY INTEGER,
33 p_Calling_Fn IN VARCHAR2,
34 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
35
36 FUNCTION Calc_Basis_Neg_Adj_Flag_Yes (
37 p_book_type_code IN VARCHAR2,
38 p_old_cost IN NUMBER,
39 p_old_reserve IN NUMBER,
40 p_adjustment_amount IN NUMBER,
41 x_new_deprn_basis OUT NOCOPY NUMBER,
42 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
43 RETURN BOOLEAN;
44
45 FUNCTION Calc_Basis_Neg_Adj_Flag_No (
46 p_book_type_code IN VARCHAR2,
47 p_old_cost IN NUMBER,
48 p_old_deprn_basis IN NUMBER,
49 p_adjustment_amount IN NUMBER,
50 x_new_deprn_basis OUT NOCOPY NUMBER,
51 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
52 RETURN BOOLEAN;
53
54 FUNCTION Calc_Basis_Partial_Ret (
55 p_book_type_code IN VARCHAR2,
56 p_old_cost IN NUMBER,
57 p_old_deprn_basis IN NUMBER,
58 p_retirement_amount IN NUMBER,
59 x_new_deprn_basis OUT NOCOPY NUMBER,
60 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
61 RETURN BOOLEAN;
62
63 FUNCTION Calc_Basis_Trxn (
64 p_book_type_code IN VARCHAR2,
65 p_transaction_type_code IN VARCHAR2,
66 p_pos_neg_adjustment IN VARCHAR2,
67 p_polish_adj_calc_basis_flag
68 IN VARCHAR2,
69 p_adjusted_cost IN NUMBER,
70 p_adjusted_recoverable_cost
71 IN NUMBER,
72 p_prev_adj_rec_cost IN NUMBER,
73 p_prev_basis IN NUMBER,
74 p_prev_reserve IN NUMBER,
75 p_adjustment_amount IN NUMBER,
76 p_retirement_amount IN NUMBER,
77 p_switch_code IN VARCHAR2,
78 x_adjusted_cost OUT NOCOPY NUMBER,
79 x_adjusted_recoverable_cost OUT NOCOPY NUMBER,
80 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
81 RETURN BOOLEAN;
82
83 FUNCTION Calc_Trxn_Values (
84 p_book_type_code IN VARCHAR2,
85 p_asset_id IN NUMBER,
86 p_transaction_type_code IN VARCHAR2,
87 p_transaction_header_id IN NUMBER,
88 p_first_period_counter IN NUMBER,
89 p_mrc_sob_type_code IN VARCHAR2,
90 p_calling_mode IN VARCHAR2,
91 x_adjustment_amount OUT NOCOPY NUMBER,
92 x_retirement_amount OUT NOCOPY NUMBER,
93 x_bef_trxn_period_counter OUT NOCOPY NUMBER,
94 x_pos_neg_adjustment OUT NOCOPY VARCHAR2,
95 x_prev_basis OUT NOCOPY NUMBER,
96 x_prev_adj_rec_cost OUT NOCOPY NUMBER,
97 x_prev_reserve OUT NOCOPY NUMBER,
98 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
99 RETURN BOOLEAN;
100
101 FUNCTION Calc_Rate (
102 p_book_type_code IN VARCHAR2,
103 p_asset_id IN NUMBER,
104 p_polish_rule IN NUMBER,
105 p_year_of_life IN NUMBER,
106 p_year_retired IN VARCHAR2,
107 p_period_counter IN NUMBER,
108 p_first_period_counter IN NUMBER,
109 p_open_period_counter IN NUMBER,
110 p_period_num IN NUMBER,
111 p_periods_per_year IN NUMBER,
112 p_adjusted_rate IN NUMBER,
113 p_deprn_factor IN NUMBER,
114 p_alternate_deprn_factor IN NUMBER,
115 p_depreciate_flag IN VARCHAR2,
116 p_first_year_reserve IN NUMBER,
117 p_prev_year_reserve IN NUMBER,
118 p_prev_year_adjusted_cost
119 IN NUMBER,
120 p_prev_year_adj_rec_cost IN NUMBER,
121 p_mrc_sob_type_code IN VARCHAR2,
122 x_adjusted_rate OUT NOCOPY NUMBER,
123 x_depreciate_flag OUT NOCOPY VARCHAR2,
124 x_switch_code OUT NOCOPY VARCHAR2,
125 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
126 RETURN BOOLEAN;
127
128 END FA_POLISH_PVT;