[Home] [Help]
PACKAGE: APPS.FA_CUA_ASSET_APIS
Source
1 PACKAGE FA_CUA_ASSET_APIS AS
2 /* $Header: FACXAPIMS.pls 120.1 2002/11/12 07:59:24 glchen ship $ */
3
4 G_conc_process VARCHAR2(1):= 'N';
5 g_status VARCHAR2(10); -- used by ifa_retirements_bru and aru
6 G_asset_array fa_cua_derive_asset_attr_pkg.asset_tabtype;
7 g_multi_books_flg VARCHAR2(1);
8 g_book_type_code VARCHAR2(15); --also used by ifa_retirements_bru and aru
9 g_book_class VARCHAR2(15);
10 g_corporate_book VARCHAR2(15);
11 g_parent_node_id NUMBER;
12 g_asset_number VARCHAR2(15) ;
13 g_asset_id NUMBER ; --also used by ifa_retirements_bru and aru
14 g_prorate_date DATE;
15 g_cat_id_in NUMBER;
16 g_cat_id_out NUMBER;
17 g_cat_overide_allowed VARCHAR2(1);
18 g_cat_rejection_flag VARCHAR2(1);
19 g_lease_id_in NUMBER ;
20 g_lease_id_out NUMBER;
21 g_lease_overide_allowed VARCHAR2(1);
22 g_lease_rejection_flag VARCHAR2(1);
23 g_distribution_set_id_out NUMBER;
24 g_distribution_overide_allowed VARCHAR2(1);
25 g_distribution_rejection_flag VARCHAR2(1);
26 g_serial_number_in VARCHAR2(35);
27 g_serial_number_out VARCHAR2(35);
28 g_serial_num_overide_allowed VARCHAR2(1);
29 g_serial_num_rejection_flag VARCHAR2(1);
30 g_asset_key_ccid_in NUMBER ;
31 g_asset_key_ccid_out NUMBER;
32 g_asset_key_overide_allowed VARCHAR2(1);
33 g_asset_key_rejection_flag VARCHAR2(1);
34 g_life_in_months_in NUMBER ;
35 g_life_in_months_out NUMBER;
36 g_life_end_dte_overide_allowed VARCHAR2(1);
37 g_life_rejection_flag VARCHAR2(1);
38 g_derivation_type VARCHAR2(30) := 'ALL';
39 g_derive_from_entity VARCHAR2(30):= NULL;
40 g_derive_from_entity_value VARCHAR2(30):= NULL;
41 g_precedence_used_flag VARCHAR2(1) := 'N';
42 g_category_life_type VARCHAR2(7) := 'LIFE';
43 g_err_code VARCHAR2(630):= NULL;
44 g_err_stage VARCHAR2(630):= NULL;
45 g_err_stack VARCHAR2(630):= NULL;
46
47 -- added on 24-NOV-99
48 -- bugfix1535892 initialized the variable to 'N'
49 -- fa_cua_transaction_headers_bri refers to this variable
50 -- somehow this variable was not resetting for retirements
51 -- and was assigning incorrect values to the transactions dffs
52 g_process_batch VARCHAR2(1):= 'N'; -- bugfix1535892
53 g_transaction_name VARCHAR2(30);
54 g_attribute_category VARCHAR2(30);
55 g_attribute1 VARCHAR2(150);
56 g_attribute2 VARCHAR2(150);
57 g_attribute3 VARCHAR2(150);
58 g_attribute4 VARCHAR2(150);
59 g_attribute5 VARCHAR2(150);
60 g_attribute6 VARCHAR2(150);
61 g_attribute7 VARCHAR2(150);
62 g_attribute8 VARCHAR2(150);
63 g_attribute9 VARCHAR2(150);
64 g_attribute10 VARCHAR2(150);
65 g_attribute11 VARCHAR2(150);
66 g_attribute12 VARCHAR2(150);
67 g_attribute13 VARCHAR2(150);
68 g_attribute14 VARCHAR2(150);
69 g_attribute15 VARCHAR2(150);
70
71 TYPE derived_from_entity_rec_type IS RECORD (
72 category NUMBER
73 , lease NUMBER
74 , distribution NUMBER
75 , asset_key NUMBER
76 , serial_number NUMBER
77 , life_in_months NUMBER
78 , lim_type VARCHAR2(15) );
79
80 g_derived_from_entity_rec derived_from_entity_rec_type;
81
82
83
84 PROCEDURE derive_asset_attribute(
85 x_book_type_code IN VARCHAR2
86 , x_parent_node_id IN NUMBER
87 , x_asset_number IN VARCHAR2 DEFAULT NULL
88 , x_asset_id IN NUMBER DEFAULT NULL
89 , x_prorate_date IN DATE
90 , x_cat_id_in IN NUMBER
91 , x_cat_id_out OUT NOCOPY NUMBER
92 , x_cat_overide_allowed OUT NOCOPY VARCHAR2
93 , x_cat_rejection_flag OUT NOCOPY VARCHAR2
94 , x_lease_id_in IN NUMBER DEFAULT NULL
95 , x_lease_id_out OUT NOCOPY NUMBER
96 , x_lease_overide_allowed OUT NOCOPY VARCHAR2
97 , x_lease_rejection_flag OUT NOCOPY VARCHAR2
98 , x_distribution_set_id_in IN NUMBER DEFAULT NULL
99 , x_distribution_set_id_out OUT NOCOPY NUMBER
100 , x_distribution_overide_allowed OUT NOCOPY VARCHAR2
101 , x_distribution_rejection_flag OUT NOCOPY VARCHAR2
102 , x_serial_number_in IN VARCHAR2 DEFAULT NULL
103 , x_serial_number_out OUT NOCOPY VARCHAR2
104 , x_serial_num_overide_allowed OUT NOCOPY VARCHAR2
105 , x_serial_num_rejection_flag OUT NOCOPY VARCHAR2
106 , x_asset_key_ccid_in IN NUMBER DEFAULT NULL
107 , x_asset_key_ccid_out OUT NOCOPY NUMBER
108 , x_asset_key_overide_allowed OUT NOCOPY VARCHAR2
109 , x_asset_key_rejection_flag OUT NOCOPY VARCHAR2
110 , x_life_in_months_in IN NUMBER DEFAULT NULL
111 , x_life_in_months_out OUT NOCOPY NUMBER
112 , x_life_end_dte_overide_allowed OUT NOCOPY VARCHAR2
113 , x_life_rejection_flag OUT NOCOPY VARCHAR2
114 , x_err_code IN OUT NOCOPY VARCHAR2
115 , x_err_stage IN OUT NOCOPY VARCHAR2
116 , x_err_stack IN OUT NOCOPY VARCHAR2
117 , x_derivation_type IN VARCHAR2 DEFAULT 'ALL') ;
118
119 PROCEDURE generate_batch_transactions(
120 x_event_code IN VARCHAR2
121 , x_book_type_code IN VARCHAR2
122 , x_src_entity_name IN VARCHAR2
123 , x_src_entity_value IN VARCHAR2
124 , x_src_attribute_name IN VARCHAR2
125 , x_src_attr_value_from IN VARCHAR2
126 , x_src_attr_value_to IN VARCHAR2
127 , x_amortize_expense_flg IN VARCHAR2
128 , x_amortization_date IN DATE
129 , x_batch_num IN OUT NOCOPY VARCHAR2
130 , x_batch_id IN OUT NOCOPY NUMBER
131 , x_transaction_name IN VARCHAR2 DEFAULT NULL
132 , x_attribute_category IN VARCHAR2 DEFAULT NULL
133 , x_attribute1 IN VARCHAR2 DEFAULT NULL
134 , x_attribute2 IN VARCHAR2 DEFAULT NULL
135 , x_attribute3 IN VARCHAR2 DEFAULT NULL
136 , x_attribute4 IN VARCHAR2 DEFAULT NULL
137 , x_attribute5 IN VARCHAR2 DEFAULT NULL
138 , x_attribute6 IN VARCHAR2 DEFAULT NULL
139 , x_attribute7 IN VARCHAR2 DEFAULT NULL
140 , x_attribute8 IN VARCHAR2 DEFAULT NULL
141 , x_attribute9 IN VARCHAR2 DEFAULT NULL
142 , x_attribute10 IN VARCHAR2 DEFAULT NULL
143 , x_attribute11 IN VARCHAR2 DEFAULT NULL
144 , x_attribute12 IN VARCHAR2 DEFAULT NULL
145 , x_attribute13 IN VARCHAR2 DEFAULT NULL
146 , x_attribute14 IN VARCHAR2 DEFAULT NULL
147 , x_attribute15 IN VARCHAR2 DEFAULT NULL
148 , x_err_code IN OUT NOCOPY VARCHAR2
149 , x_err_stage IN OUT NOCOPY VARCHAR2
150 , x_err_stack IN OUT NOCOPY VARCHAR2 );
151
152 PROCEDURE derive_rule( x_book_type_code IN VARCHAR2
153 , x_parent_node_id IN NUMBER
154 , x_asset_id IN NUMBER
155 , x_cat_id_in IN NUMBER
156 , x_rule_set_id OUT NOCOPY NUMBER
157 , x_err_code IN OUT NOCOPY VARCHAR2
158 , x_err_stage IN OUT NOCOPY VARCHAR2
159 , x_err_stack IN OUT NOCOPY VARCHAR2 );
160
161 PROCEDURE derive_LED_for_ALL(
162 x_book_type_code IN VARCHAR2
163 , x_asset_id IN NUMBER
164 , x_parent_node_id IN NUMBER
165 , x_top_node_id IN NUMBER
166 , x_asset_cat_id IN NUMBER
167 , x_node_category_id IN NUMBER
168 , x_asset_lease_id IN NUMBER
169 , x_node_lease_id IN NUMBER
170 , x_prorate_date IN DATE
171 , x_convention_code IN VARCHAR2
172 , x_deprn_method_code IN VARCHAR2
173 , x_rule_det_rec IN fa_hierarchy_rule_details%ROWTYPE
174 , x_life_out OUT NOCOPY NUMBER
175 , x_err_code IN OUT NOCOPY VARCHAR2
176 , x_err_stage IN OUT NOCOPY VARCHAR2
177 , x_err_stack IN OUT NOCOPY VARCHAR2);
178
179 PROCEDURE wrapper_derive_asset_attribute;
180
181 PROCEDURE generate_batch_transactions1(
182 x_event_code IN VARCHAR2
183 , x_book_type_code IN VARCHAR2
184 , x_src_entity_name IN VARCHAR2
185 , x_src_entity_value IN VARCHAR2
186 , x_src_attribute_name IN VARCHAR2
187 , x_src_attr_value_from IN VARCHAR2
188 , x_src_attr_value_to IN VARCHAR2
189 , x_amortize_expense_flg IN VARCHAR2
190 , x_amortization_date IN DATE
191 , x_batch_num IN OUT NOCOPY VARCHAR2
192 , x_batch_id IN OUT NOCOPY NUMBER
193 , x_transaction_name IN VARCHAR2 DEFAULT NULL
194 , x_attribute_category IN VARCHAR2 DEFAULT NULL
195 , x_attribute1 IN VARCHAR2 DEFAULT NULL
196 , x_attribute2 IN VARCHAR2 DEFAULT NULL
197 , x_attribute3 IN VARCHAR2 DEFAULT NULL
198 , x_attribute4 IN VARCHAR2 DEFAULT NULL
199 , x_attribute5 IN VARCHAR2 DEFAULT NULL
200 , x_attribute6 IN VARCHAR2 DEFAULT NULL
201 , x_attribute7 IN VARCHAR2 DEFAULT NULL
202 , x_attribute8 IN VARCHAR2 DEFAULT NULL
203 , x_attribute9 IN VARCHAR2 DEFAULT NULL
204 , x_attribute10 IN VARCHAR2 DEFAULT NULL
205 , x_attribute11 IN VARCHAR2 DEFAULT NULL
206 , x_attribute12 IN VARCHAR2 DEFAULT NULL
207 , x_attribute13 IN VARCHAR2 DEFAULT NULL
208 , x_attribute14 IN VARCHAR2 DEFAULT NULL
209 , x_attribute15 IN VARCHAR2 DEFAULT NULL
210 , x_err_code IN OUT NOCOPY VARCHAR2
211 , x_err_stage IN OUT NOCOPY VARCHAR2
212 , x_err_stack IN OUT NOCOPY VARCHAR2 );
213
214 PROCEDURE initialize_Gvariables;
215
216 PROCEDURE process_conc_batch ( ERRBUF OUT NOCOPY VARCHAR2,
217 RETCODE OUT NOCOPY VARCHAR2,
218 x_batch_number IN VARCHAR2 ) ;
219
220 PROCEDURE Purge(errbuf OUT NOCOPY VARCHAR2,
221 retcode OUT NOCOPY VARCHAR2,
222 x_book_type_code IN VARCHAR2,
223 x_batch_id IN NUMBER );
224
225 /* -----------------------------------------------------
226 This function returns TRUE if override is allowed
227 for the attribute, else returns FALSE.
228 Valid Attribute Names are: CATEGORY, DISTRIBUTION,
229 SERIAL_NUMBER, ASSET_KEY,
230 LIFE_END_DATE,LEASE_NUMBER
231 --------------------------------------------------- */
232 FUNCTION check_override_allowed(
233 p_attribute_name in varchar2,
234 p_book_type_code in varchar2,
235 p_asset_id in number,
236 x_override_flag out nocopy varchar2 ) return boolean;
237
238
239 END FA_CUA_ASSET_APIS;