[Home] [Help]
PACKAGE: APPS.FA_SORP_REVALUATION_PKG
Source
1 PACKAGE fa_sorp_revaluation_pkg AUTHID CURRENT_USER AS
2 /* $Header: FAVSRVS.pls 120.8 2011/03/03 10:37:45 gigupta noship $ */
3
4 --Procedure has logic for linking revaluations with prior impairments
5 PROCEDURE fa_sorp_link_reval (
6 -- p_nbv NUMBER,
7 p_adj_amt NUMBER,
8 p_mass_reval_id NUMBER,
9 p_asset_id NUMBER,
10 p_book_type_code VARCHAR2,
11 p_run_mode VARCHAR2,
12 p_request_id NUMBER,
13 p_mrc_sob_type_code VARCHAR2,
14 p_category_id NUMBER,
15 p_reval_type VARCHAR2,
16 p_set_of_books_id NUMBER,
17 x_imp_loss_impact OUT NOCOPY NUMBER,
18 x_reval_gain OUT NOCOPY NUMBER,
19 x_impair_loss_acct OUT NOCOPY VARCHAR2,
20 x_temp_imp_deprn_effect OUT NOCOPY NUMBER,
21 x_reval_rsv_deprn_effect OUT NOCOPY NUMBER
22 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
23
24 --Procedure updates FA_ITF_IMPAIRMENTS with reversed amounts
25 PROCEDURE fa_imp_itf_upd (
26 p_request_id NUMBER,
27 p_book_type_code VARCHAR2,
28 p_asset_id NUMBER,
29 p_last_updated_by NUMBER,
30 p_last_update_date DATE
31 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
32
33 --Function returns impairment efffect on depriciation
34 FUNCTION fa_imp_deprn_eff_fn (
35 p_impairment_id NUMBER,
36 p_book_type_code VARCHAR2,
37 p_asset_id NUMBER,
38 p_reval_imp_flag VARCHAR2,
39 p_amount NUMBER
40 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
41 RETURN NUMBER;
42
43 -- Performs Accounting related to SORP
44 FUNCTION fa_sorp_accounting (
45 p_asset_id IN NUMBER,
46 p_request_id IN NUMBER,
47 px_adj IN OUT NOCOPY fa_adjust_type_pkg.fa_adj_row_struct,
48 p_created_by IN NUMBER,
49 p_creation_date IN DATE
50 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
51 RETURN BOOLEAN;
52
53 -- Changes concatenated impairment id to original impairment id
54 FUNCTION fa_sorp_process_imp_id_fn (p_impairment_id NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
55 RETURN NUMBER;
56
57 /*Bug#7392015 function to calculate deprn effect for double db depreciation method*/
58 Function fa_sorp_link_reval_dd(
59 p_mass_reval_id IN NUMBER,
60 p_asset_id IN NUMBER,
61 p_book_type_code IN VARCHAR2,
62 p_impairment_id IN NUMBER,
63 p_unused_imp_amount IN NUMBER,
64 p_mrc_sob_type_code IN VARCHAR2,
65 p_set_of_books_id IN NUMBER,
66 x_deprn_rsv OUT NOCOPY NUMBER,
67 x_impairment_amt OUT NOCOPY NUMBER,
68 x_impair_split_flag OUT NOCOPY VARCHAR2,
69 x_override_flag OUT NOCOPY VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
70
71 FUNCTION process_loss_reversal(
72 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
73 p_period_rec IN FA_API_TYPES.period_rec_type,
74 p_mrc_sob_type_code IN VARCHAR2,
75 p_set_of_books_id IN NUMBER,
76 p_reval_options_rec IN FA_API_TYPES.reval_options_rec_type,
77 p_fully_rsvd_flag IN BOOLEAN,
78 p_flag IN VARCHAR2,
79 px_gain_amt IN OUT NOCOPY NUMBER,
80 px_reval_loss_exp IN OUT NOCOPY NUMBER,
81 px_deprn_exp IN OUT NOCOPY NUMBER,
82 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
83
84 FUNCTION calculate_deprn_exp(
85 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
86 p_period_rec IN FA_API_TYPES.period_rec_type,
87 p_mrc_sob_type_code IN VARCHAR2,
88 p_set_of_books_id IN NUMBER,
89 p_th_id IN NUMBER,
90 p_loss_pc IN NUMBER,
91 x_deprn_exp OUT NOCOPY NUMBER,
92 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
93
94 END fa_sorp_revaluation_pkg;
95