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