1 PACKAGE FA_UTIL_PVT as
2 /* $Header: FAVUTILS.pls 120.2.12010000.3 2008/12/19 08:38:09 rjayaraj ship $ */
3
4 FUNCTION get_asset_fin_rec
5 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
6 px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
7 p_transaction_header_id IN FA_BOOKS.TRANSACTION_HEADER_ID_IN%TYPE DEFAULT NULL,
8 p_mrc_sob_type_code IN VARCHAR2,
9 p_log_level_rec IN fa_api_types.log_level_rec_type default null
10 ) RETURN BOOLEAN;
11
12
13 FUNCTION get_asset_deprn_rec
14 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
15 px_asset_deprn_rec IN OUT NOCOPY FA_API_TYPES.asset_deprn_rec_type,
16 p_period_counter IN FA_DEPRN_SUMMARY.period_counter%TYPE DEFAULT NULL,
17 p_mrc_sob_type_code IN VARCHAR2,
18 p_log_level_rec IN fa_api_types.log_level_rec_type default null
19 ) RETURN BOOLEAN;
20
21 FUNCTION get_asset_cat_rec
22 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
23 px_asset_cat_rec IN OUT NOCOPY FA_API_TYPES.asset_cat_rec_type,
24 p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
25 p_log_level_rec IN fa_api_types.log_level_rec_type default null
26 ) RETURN BOOLEAN;
27
28 FUNCTION get_asset_type_rec
29 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
30 px_asset_type_rec IN OUT NOCOPY FA_API_TYPES.asset_type_rec_type,
31 p_date_effective IN FA_ASSET_HISTORY.date_effective%TYPE DEFAULT NULL,
32 p_log_level_rec IN fa_api_types.log_level_rec_type default null
33 ) RETURN BOOLEAN;
34
35 FUNCTION get_asset_desc_rec
36 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
37 px_asset_desc_rec IN OUT NOCOPY FA_API_TYPES.asset_desc_rec_type,
38 p_log_level_rec IN fa_api_types.log_level_rec_type default null
39 ) RETURN BOOLEAN;
40
41 FUNCTION get_inv_rec
42 (px_inv_rec IN OUT NOCOPY FA_API_TYPES.inv_rec_type,
43 p_mrc_sob_type_code IN VARCHAR2,
44 p_inv_trans_rec IN FA_API_TYPES.inv_trans_rec_type DEFAULT NULL,
45 p_log_level_rec IN fa_api_types.log_level_rec_type default null
46 ) RETURN BOOLEAN;
47
48 -----------------------------------------------------------------------------
49 -- NAME check_asset_key_req |
50 -- |
51 -- FUNCTION checks whether the asset key flexfield has any |
52 -- required segments |
53 -- |
54 -- -- fdfkfa doesn't appear to allow you to |
55 -- check the required status of a column |
56 -- so hard coding this against FND. |
57 -----------------------------------------------------------------------------
58
59 FUNCTION check_asset_key_req
60 (p_asset_key_chart_id IN NUMBER,
61 p_asset_key_required OUT NOCOPY BOOLEAN,
62 p_calling_fn IN VARCHAR2,
63 p_log_level_rec IN fa_api_types.log_level_rec_type default null
64 ) RETURN BOOLEAN;
65
66 -- Added for Retirement API
67 FUNCTION get_current_units
68 (p_calling_fn in VARCHAR2
69 ,p_asset_id in NUMBER
70 ,x_current_units out NOCOPY NUMBER,
71 p_log_level_rec IN fa_api_types.log_level_rec_type default null
72 ) return BOOLEAN;
73
74 FUNCTION get_latest_trans_date
75 (p_calling_fn in VARCHAR2
76 ,p_asset_id in NUMBER
77 ,p_book in VARCHAR2
78 ,x_latest_trans_date out NOCOPY DATE,
79 p_log_level_rec IN fa_api_types.log_level_rec_type default null
80 ) return BOOLEAN;
81
82 -- This can be used by other APIs if necessary
83 FUNCTION get_period_rec
84 (p_book in varchar2
85 ,p_period_counter in number default null
86 ,p_effective_date in date default null
87 ,x_period_rec out NOCOPY FA_API_TYPES.period_rec_type,
88 p_log_level_rec IN fa_api_types.log_level_rec_type default null
89 ) return BOOLEAN;
90
91 -- This populates retirement info.
92 -- Need to set set_of_books id first
93 -- Input: retirement_id is required before calling this
94
95 FUNCTION get_asset_retire_rec
96 (px_asset_retire_rec in out NOCOPY FA_API_TYPES.asset_retire_rec_type,
97 p_mrc_sob_type_code IN VARCHAR2,
98 p_log_level_rec IN fa_api_types.log_level_rec_type default null
99 ) return BOOLEAN;
100
101 -- End of Retirement API
102
103 FUNCTION get_corp_book( p_asset_id IN NUMBER,
104 p_corp_book IN OUT NOCOPY VARCHAR2,
105 p_log_level_rec IN fa_api_types.log_level_rec_type default null ) return boolean;
106
107 PROCEDURE load_char_value
108 (p_char_old IN VARCHAR2,
109 p_char_adj IN VARCHAR2,
110 x_char_new IN OUT NOCOPY VARCHAR2,
111 p_log_level_rec IN fa_api_types.log_level_rec_type default null);
112
113 PROCEDURE load_date_value
114 (p_date_old IN VARCHAR2,
115 p_date_adj IN VARCHAR2,
116 x_date_new IN OUT NOCOPY VARCHAR2,
117 p_log_level_rec IN fa_api_types.log_level_rec_type default null);
118
119 PROCEDURE load_num_value
120 (p_num_old IN VARCHAR2,
121 p_num_adj IN VARCHAR2,
122 x_num_new IN OUT NOCOPY VARCHAR2,
123 p_log_level_rec IN fa_api_types.log_level_rec_type default null);
124 --Bug7627286
125 --Added function to check if deprn has been run for the period
126 FUNCTION check_deprn_run
127 (X_book IN VARCHAR2,
128 X_asset_id IN NUMBER DEFAULT 0,
129 X_deprn_amount OUT NOCOPY NUMBER,
130 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null ) return BOOLEAN;
131
132 END FA_UTIL_PVT ;