1 PACKAGE FA_ASSET_VAL_PVT AUTHID CURRENT_USER as
2 /* $Header: FAVVALS.pls 120.56.12020000.5 2013/03/02 19:25:49 dvjoshi ship $ */
3
4 G_asset_key_required boolean;
5
6 FUNCTION validate
7 (p_trans_rec IN FA_API_TYPES.trans_rec_type,
8 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
9 p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
10 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
11 p_asset_cat_rec IN FA_API_TYPES.asset_cat_rec_type,
12 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
13 p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
14 p_asset_dist_tbl IN FA_API_TYPES.asset_dist_tbl_type,
15 p_inv_tbl IN FA_API_TYPES.inv_tbl_type,
16 p_calling_fn IN VARCHAR2,
17 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
18
19 FUNCTION validate_asset_number
20 (p_transaction_type_code IN VARCHAR2,
21 p_asset_number IN VARCHAR2,
22 p_asset_id IN NUMBER DEFAULT NULL,
23 p_calling_fn IN VARCHAR2,
24 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
25
26 FUNCTION validate_owned_leased
27 (p_transaction_type_code IN VARCHAR2,
28 p_owned_leased IN VARCHAR2,
29 p_calling_fn IN VARCHAR2,
30 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
31
32 FUNCTION validate_category
33 (p_transaction_type_code IN VARCHAR2,
34 p_category_id IN NUMBER,
35 p_book_type_code IN VARCHAR2 DEFAULT NULL,
36 p_calling_fn IN VARCHAR2,
37 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
38
39 -- Bug No#5708875
40 -- Addding validation for current units
41 --current units cannot be in fractions
42
43 FUNCTION validate_current_units
44 (p_transaction_type_code IN VARCHAR2,
45 p_current_units IN NUMBER,
46 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
47
48 FUNCTION validate_category_df
49 (p_transaction_type_code IN VARCHAR2,
50 p_cat_desc_flex IN FA_API_TYPES.desc_flex_rec_type,
51 p_calling_fn IN VARCHAR2,
52 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
53
54 FUNCTION validate_serial_number
55 (p_transaction_type_code IN VARCHAR2,
56 p_serial_number IN VARCHAR2,
57 p_calling_fn IN VARCHAR2,
58 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
59
60 FUNCTION validate_asset_key
61 (p_transaction_type_code IN VARCHAR2,
62 p_asset_key_ccid IN NUMBER,
63 p_calling_fn IN VARCHAR2,
64 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
65
66 FUNCTION validate_asset_type
67 (p_transaction_type_code IN VARCHAR2,
68 p_asset_type IN VARCHAR2,
69 p_book_type_code IN VARCHAR2,
70 p_category_id IN NUMBER,
71 p_calling_fn IN VARCHAR2,
72 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
73
74 FUNCTION validate_depreciate_flag
75 (p_depreciate_flag IN VARCHAR2,
76 p_calling_fn IN VARCHAR2,
77 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
78
79 FUNCTION validate_supplier_name
80 (p_transaction_type_code IN VARCHAR2,
81 p_calling_fn IN VARCHAR2,
82 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
83
84 FUNCTION validate_supplier_number
85 (p_transaction_type_code IN VARCHAR2,
86 p_calling_fn IN VARCHAR2,
87 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
88
89 FUNCTION validate_asset_book
90 (p_transaction_type_code IN VARCHAR2,
91 p_book_type_code IN VARCHAR2,
92 p_asset_id IN NUMBER,
93 p_calling_fn IN VARCHAR2,
94 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
95
96 FUNCTION validate_cost
97 (p_transaction_type_code IN VARCHAR2,
98 p_cost IN NUMBER,
99 p_asset_type IN VARCHAR2,
100 p_num_invoices IN NUMBER DEFAULT 0,
101 p_calling_fn IN VARCHAR2,
102 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
103
104 FUNCTION validate_assigned_to
105 (p_transaction_type_code IN VARCHAR2,
106 p_assigned_to IN NUMBER,
107 p_date IN DATE DEFAULT sysdate,
108 p_calling_fn IN VARCHAR2,
109 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
110
111 FUNCTION validate_expense_ccid
112 (p_expense_ccid IN NUMBER,
113 p_gl_chart_id IN NUMBER,
114 p_calling_fn IN VARCHAR2,
115 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
116
117 FUNCTION validate_location_ccid
118 (p_transaction_type_code IN VARCHAR2,
119 p_location_ccid IN NUMBER,
120 p_calling_fn IN VARCHAR2,
121 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
122
123 FUNCTION validate_dpis
124 (p_transaction_type_code IN VARCHAR2,
125 p_book_type_code IN VARCHAR2,
126 p_date_placed_in_service IN DATE,
127 p_prorate_convention_code IN VARCHAR2 DEFAULT NULL,
128 p_old_date_placed_in_service IN DATE DEFAULT NULL,
129 p_asset_id IN NUMBER DEFAULT NULL,
130 p_db_rule_name IN VARCHAR2 DEFAULT NULL, -- ENERGY
131 p_rate_source_rule IN VARCHAR2 DEFAULT NULL, -- ENERGY
132 p_transaction_subtype IN VARCHAR2 DEFAULT 'EXPENSED',
133 p_asset_type IN VARCHAR2 DEFAULT NULL,
134 p_calling_interface IN VARCHAR2 DEFAULT NULL,
135 p_calling_fn IN VARCHAR2,
136 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
137
138 FUNCTION validate_rec_cost_reserve
139 (p_transaction_type_code IN VARCHAR2,
140 p_recoverable_cost IN NUMBER,
141 p_deprn_reserve IN NUMBER,
142 p_calling_fn IN VARCHAR2,
143 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
144
145 FUNCTION validate_adj_rec_cost
146 (p_adjusted_recoverable_cost IN NUMBER,
147 p_deprn_reserve IN NUMBER,
148 p_calling_fn IN VARCHAR2,
149 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
150
151 FUNCTION validate_ytd_reserve /*Bug#9682863 - Modified the parameters - instead of individual value passing records. */
152 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
153 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
154 p_asset_fin_rec_new IN FA_API_TYPES.asset_fin_rec_type,
155 p_asset_deprn_rec_new IN FA_API_TYPES.asset_deprn_rec_type,
156 p_period_rec IN FA_API_TYPES.period_rec_type,
157 p_asset_deprn_rec_old IN FA_API_TYPES.asset_deprn_rec_type, /*Fix for bug 8790562 */
158 p_calling_fn IN VARCHAR2,
159 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
160
161 FUNCTION validate_short_tax_year
162 (p_book_type_code IN VARCHAR2,
163 p_transaction_type_code IN VARCHAR2,
164 p_asset_type IN VARCHAR2,
165 p_short_fiscal_year_flag IN VARCHAR2,
166 p_conversion_date IN DATE,
167 px_orig_deprn_start_date IN OUT NOCOPY DATE,
168 p_date_placed_in_service IN DATE,
169 p_ytd_deprn IN NUMBER,
170 p_deprn_reserve IN NUMBER,
171 p_period_rec IN FA_API_TYPES.period_rec_type,
172 p_calling_fn IN VARCHAR2,
173 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
174
175 FUNCTION validate_trx_date_entered
176 (p_transaction_type_code IN VARCHAR2,
177 p_book_type_code IN VARCHAR2,
178 p_transaction_date_entered IN DATE,
179 p_period_rec IN FA_API_TYPES.period_rec_type,
180 p_calling_fn IN VARCHAR2,
181 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
182
183 FUNCTION validate_amort_start_date
184 (p_transaction_type_code IN VARCHAR2,
185 p_asset_id IN NUMBER,
186 p_book_type_code IN VARCHAR2,
187 p_date_placed_in_service IN DATE DEFAULT NULL,
188 p_conversion_date IN DATE DEFAULT NULL,
189 p_period_rec IN FA_API_TYPES.period_rec_type,
190 p_amortization_start_date IN DATE,
191 p_db_rule_name IN VARCHAR2 DEFAULT NULL, -- ENERGY
192 p_rate_source_rule IN VARCHAR2 DEFAULT NULL, -- ENERGY
193 p_transaction_key IN VARCHAR2 DEFAULT 'XX',
194 x_amortization_start_date OUT NOCOPY DATE,
195 x_trxs_exist OUT NOCOPY VARCHAR2,
196 p_calling_fn IN VARCHAR2,
197 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
198
199 FUNCTION validate_life
200 (p_deprn_method IN VARCHAR2,
201 p_rate_source_rule IN VARCHAR2,
202 p_life_in_months IN NUMBER,
203 p_lim IN NUMBER,
204 p_user_id IN NUMBER,
205 p_curr_date IN DATE,
206 px_new_life IN OUT NOCOPY NUMBER,
207 p_calling_fn IN VARCHAR2,
208 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
209
210 FUNCTION validate_payables_ccid
211 (px_payables_ccid IN OUT NOCOPY NUMBER,
212 p_gl_chart_id IN NUMBER,
213 p_calling_fn IN VARCHAR2,
214 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
215
216 FUNCTION validate_fixed_assets_cost
217 (p_fixed_assets_cost IN NUMBER,
218 p_calling_fn IN VARCHAR2,
219 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
220
221 FUNCTION validate_fixed_assets_units
222 (p_fixed_assets_units IN NUMBER,
223 p_calling_fn IN VARCHAR2,
224 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
225
226 FUNCTION validate_payables_cost
227 (p_payables_cost IN NUMBER,
228 p_calling_fn IN VARCHAR2,
229 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
230
231 FUNCTION validate_payables_units
232 (p_payables_units IN NUMBER,
233 p_calling_fn IN VARCHAR2,
234 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
235
236 FUNCTION validate_po_vendor_id
237 (p_po_vendor_id IN NUMBER,
238 p_calling_fn IN VARCHAR2,
239 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
240
241 FUNCTION validate_unit_of_measure
242 (p_unit_of_measure IN VARCHAR2,
243 p_calling_fn IN VARCHAR2,
244 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
245
246 FUNCTION validate_salvage_value
247 (p_salvage_value IN NUMBER,
248 p_nbv IN NUMBER,
249 p_calling_fn IN VARCHAR2,
250 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
251
252 FUNCTION validate_tag_number
253 (p_tag_number IN VARCHAR2,
254 p_mass_addition_id IN NUMBER DEFAULT NULL,
255 p_calling_fn IN VARCHAR2,
256 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
257
258 FUNCTION validate_split_merged_code
259 (p_split_merged_code IN VARCHAR2,
260 p_calling_fn IN VARCHAR2,
261 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
262
263 /* Japan Tax Phase 3 -- Added New parameter */
264 FUNCTION validate_exp_after_amort
265 (p_asset_id IN number,
266 p_book IN varchar2,
267 p_extended_flag IN BOOLEAN DEFAULT FALSE,
268 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
269
270 FUNCTION validate_unplanned_exists
271 (p_asset_id IN number,
272 p_book IN varchar2,
273 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
274
275 FUNCTION validate_period_of_addition
276 (p_asset_id IN number,
277 p_book IN varchar2,
278 p_mode IN varchar2 DEFAULT 'ABSOLUTE',
279 px_period_of_addition IN OUT NOCOPY varchar2,
280 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
281
282 FUNCTION validate_fully_retired
283 (p_asset_id IN number,
284 p_book IN varchar2,
285 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
286
287 FUNCTION validate_add_to_asset_pending
288 (p_asset_id in number,
289 p_book in varchar2,
290 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
291
292 FUNCTION validate_asset_id_exist
293 (p_asset_id in number,
294 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
295
296 FUNCTION validate_ret_rst_pending
297 (p_asset_id in number,
298 p_book in varchar2,
299 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
300
301 FUNCTION validate_fa_lookup_code
302 (p_lookup_type in varchar2,
303 p_lookup_code in varchar2,
304 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
305
306 FUNCTION validate_dist_id
307 (p_asset_id in number,
308 p_dist_id in number,
309 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
310
311 FUNCTION validate_corp_pending_ret
312 (p_asset_id in number,
313 p_book in varchar2,
314 p_transaction_header_id_in in number,
315 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return BOOLEAN;
316 -- end of validations introduced by Retirement API
317
318 FUNCTION validate_parent_asset(
319 p_parent_asset_id IN number,
320 p_asset_id IN number,
321 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
322
323 FUNCTION validate_lease(
324 p_asset_id IN number,
325 p_lease_id IN number,
326 p_category_id IN number,
327 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
328
329 FUNCTION validate_warranty (
330 p_warranty_id IN NUMBER,
331 p_date_placed_in_service IN DATE,
332 p_book_type_code IN VARCHAR2,
333 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
334
335 FUNCTION validate_property_type(p_property_type_code in VARCHAR2,
336 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
337
338 FUNCTION validate_1245_1250_code(p_1245_1250_code in VARCHAR2,
339 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
340
341 FUNCTION validate_group_asset
342 (p_group_asset_id in NUMBER,
343 p_book_type_code in VARCHAR2,
344 p_asset_type in VARCHAR2,
345 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
346
347 FUNCTION validate_disabled_flag
348 (p_group_asset_id in NUMBER,
349 p_book_type_code in VARCHAR2,
350 p_old_flag IN VARCHAR2,
351 p_new_flag IN VARCHAR2,
352 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
353
354 FUNCTION validate_group_info
355 (p_group_asset_id in NUMBER,
356 p_book_type_code in VARCHAR2,
357 p_calling_fn in VARCHAR2,
358 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
359
360 FUNCTION validate_over_depreciate
361 (p_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type,
362 p_asset_type VARCHAR2,
363 p_over_depreciate_option VARCHAR2 default null,
364 p_adjusted_recoverable_cost NUMBER default null,
365 p_recoverable_cost NUMBER default null,
366 p_deprn_reserve_new NUMBER default null,
367 p_rate_source_rule VARCHAR2 default null,
368 p_deprn_basis_rule VARCHAR2 default null,
369 p_recapture_reserve_flag VARCHAR2 default null,
370 p_deprn_limit_type VARCHAR2 default null,
371 p_log_level_rec FA_API_TYPES.log_level_rec_type) return boolean;
372
373 --
374 -- Function
375 -- validate_cost_change
376 --
377 -- Description
378 -- This function returns false if user entered cost/
379 -- salvage_value/allowed_deprn_limit_amount
380 -- which result in different sign from current sign.
381 --
382 FUNCTION validate_cost_change (
383 p_asset_id number,
384 p_group_asset_id number,
385 p_book_type_code varchar2,
386 p_asset_type varchar2,
387 p_transaction_header_id number,
388 p_transaction_date date,
389 p_cost number default 0,
390 p_cost_adj number default 0,
391 p_salvage_value number default 0,
392 p_salvage_value_adj number default 0,
393 p_deprn_limit_amount number default 0,
394 p_deprn_limit_amount_adj number default 0,
395 p_mrc_sob_type_code varchar2,
396 p_set_of_books_id number,
397 p_over_depreciate_option varchar2,
398 p_log_level_rec FA_API_TYPES.log_level_rec_type) return boolean;
399
400 -- New function due for bug2846357
401 --
402 -- check if duplicate distribution info exist in p_asset_dist_tbl
403 -- current row( p_curr_index) of p_asset_dist_tbl is compared to
404 -- all of previous rows of p_asset_dist_tbl
405 -- to check for duplicates
406
407 FUNCTION validate_duplicate_dist (
408 p_transaction_type_code IN VARCHAR2,
409 p_asset_dist_tbl IN OUT NOCOPY FA_API_TYPES.asset_dist_tbl_type,
410 p_curr_index IN NUMBER,
411 p_calling_function IN VARCHAR2, --Bug:16038304
412 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) return boolean;
413
414 FUNCTION validate_polish
415 (p_transaction_type_code IN VARCHAR2,
416 p_method_code IN VARCHAR2,
417 p_life_in_months IN NUMBER DEFAULT NULL,
418 p_asset_type IN VARCHAR2 DEFAULT NULL,
419 p_bonus_rule IN VARCHAR2 DEFAULT NULL,
420 p_ceiling_name IN VARCHAR2 DEFAULT NULL,
421 p_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
422 p_group_asset_id IN NUMBER DEFAULT NULL,
423 p_date_placed_in_service IN DATE DEFAULT NULL,
424 p_calendar_period_open_date IN DATE DEFAULT NULL,
425 p_ytd_deprn IN NUMBER DEFAULT NULL,
426 p_deprn_reserve IN NUMBER DEFAULT NULL,
427 p_calling_fn IN VARCHAR2,
428 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
429
430 FUNCTION validate_jp250db
431 (p_transaction_type_code IN VARCHAR2,
432 p_book_type_code IN VARCHAR2,
433 p_asset_id IN NUMBER,
434 p_method_code IN VARCHAR2,
435 p_life_in_months IN NUMBER DEFAULT NULL,
436 p_asset_type IN VARCHAR2 DEFAULT NULL,
437 p_bonus_rule IN VARCHAR2 DEFAULT NULL,
438 p_transaction_key IN VARCHAR2 DEFAULT NULL,
439 p_cash_generating_unit_id IN VARCHAR2 DEFAULT NULL,
440 p_deprn_override_flag IN VARCHAR2 DEFAULT 'N',
441 p_calling_fn IN VARCHAR2,
442 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
443
444 --
445 -- Check to see that whether new super_group has already been used or not
446 -- If it is used by other group, raise error
447 -- Do not call this if the book is not primary book.
448
449 FUNCTION validate_super_group (
450 p_book_type_code IN VARCHAR2,
451 p_old_super_group_id IN NUMBER,
452 p_new_super_group_id IN NUMBER,
453 p_calling_fn IN VARCHAR2,
454 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
455
456 FUNCTION validate_member_dpis
457 (p_book_type_code IN VARCHAR2,
458 p_date_placed_in_service IN DATE,
459 p_group_asset_Id IN NUMBER,
460 p_calling_fn IN VARCHAR2,
461 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
462
463 FUNCTION validate_egy_prod_date ( -- ENERGY
464 p_calendar_period_start_date IN DATE, -- ENERGY
465 p_transaction_date IN DATE, -- ENERGY
466 p_transaction_key IN VARCHAR2,
467 p_rate_source_rule IN VARCHAR2, -- ENERGY
468 p_rule_name IN VARCHAR2, -- ENERGY
469 p_calling_fn IN VARCHAR2,
470 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN; -- ENERGY
471
472 -- Bug:5154035
473 FUNCTION validate_reval_exists (
474 p_book_type_code IN VARCHAR2,
475 p_asset_Id IN NUMBER,
476 p_calling_fn IN VARCHAR2,
477 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
478
479
480 /* Japan Tax Phase3 Prevent cost adjustment
481 and method change for assets in extended depreciation */
482 FUNCTION validate_extended_asset (
483 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
484 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
485 p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
486 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
487
488 FUNCTION validate_extending_asset (
489 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
490 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
491 p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
492 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
493 p_period_rec IN FA_API_TYPES.period_rec_type,
494 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
495
496 --Adding new Functions for bug 7698030
497
498 FUNCTION validate_JP_STL_EXTND(
499 p_prior_deprn_method IN VARCHAR2 DEFAULT NULL,
500 p_prior_basic_rate IN NUMBER DEFAULT NULL,
501 p_prior_adjusted_rate IN NUMBER DEFAULT NULL,
502 p_prior_life_in_months IN NUMBER DEFAULT NULL,
503 p_calling_fn IN VARCHAR2,
504 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
505
506 FUNCTION validate_earl_deprn_limit(
507 p_prior_deprn_limit_amount IN NUMBER DEFAULT NULL,
508 p_prior_deprn_limit IN NUMBER DEFAULT NULL,
509 p_prior_deprn_limit_type IN VARCHAR2 DEFAULT NULL,
510 p_calling_fn IN VARCHAR2,
511 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
512
513 FUNCTION validate_period_fully_reserved(
514 p_book_type_code IN VARCHAR2,
515 p_pc_fully_reserved IN NUMBER DEFAULT NULL,
516 p_date_placed_in_service IN DATE,
517 p_calling_fn IN VARCHAR2,
518 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
519
520 FUNCTION validate_fst_prd_extd_deprn(
521 p_book_type_code IN VARCHAR2,
522 p_extended_deprn_period IN NUMBER DEFAULT NULL,
523 p_date_placed_in_service IN DATE,
524 p_calling_fn IN VARCHAR2,
525 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
526
527 FUNCTION validate_NOT_JP_STL_EXTND(
528 p_book_type_code IN VARCHAR2,
529 p_deprn_limit IN NUMBER DEFAULT NULL,
530 p_sp_deprn_limit IN NUMBER DEFAULT NULL,
531 p_deprn_reserve IN NUMBER DEFAULT NULL,
532 p_asset_type IN VARCHAR2 DEFAULT NULL,
533 p_pc_fully_reserved IN NUMBER DEFAULT NULL,
534 p_date_placed_in_service IN DATE,
535 p_cost IN NUMBER DEFAULT NULL,
536 p_calling_fn IN VARCHAR2,
537 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
538
539 FUNCTION validate_JP_250_DB(
540 p_deprn_method_code IN VARCHAR2 DEFAULT NULL,
541 p_cost IN NUMBER DEFAULT NULL,
542 p_nbv_at_switch IN NUMBER DEFAULT NULL,
543 p_deprn_reserve IN NUMBER DEFAULT NULL,
544 p_ytd_deprn IN NUMBER DEFAULT NULL,
545 p_calling_fn IN VARCHAR2,
546 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
547
548 -- End of adding new Fuctions 7698030
549
550 FUNCTION validate_reserve_transfer (
551 p_book_type_code IN VARCHAR2 DEFAULT NULL,
552 p_asset_id IN NUMBER DEFAULT NULL,
553 p_transfer_amount IN NUMBER DEFAULT 0,
554 p_calling_fn IN VARCHAR2,
555 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
556
557 /* Bug#8351285-To validate change of salvage_type or deprn_limit_type of group asset */
558 FUNCTION validate_sal_deprn_sum (
559 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
560 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
561 p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
562 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
563 ) RETURN BOOLEAN;
564
565 FUNCTION validate_impairment_exists
566 (p_asset_id IN number,
567 p_book IN varchar2,
568 p_mrc_sob_type_code IN varchar2,
569 p_set_of_books_id IN number,
570 p_log_level_rec IN FA_API_TYPES.log_level_rec_type
571 ) RETURN BOOLEAN ;
572
573 /*Bug# 8527619 This function is called from public APIs to check if group will become over depreciate
574 NBV should not have sign different than cost, when over_depreciation_option is set to NO*/
575 FUNCTION validate_over_depreciation (
576 p_asset_hdr_rec IN fa_api_types.asset_hdr_rec_type,
577 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type default null,
578 p_validation_type IN varchar2,
579 p_cost_adj IN number,
580 p_rsv_adj IN number,
581 p_mrc_sob_type_code IN varchar2 default 'P',
582 p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
583 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
584 ) RETURN BOOLEAN;
585
586 FUNCTION validate_grp_track_method(
587 p_asset_fin_rec_old IN fa_api_types.asset_fin_rec_type,
588 p_asset_fin_rec_new IN fa_api_types.asset_fin_rec_type,
589 p_group_reclass_options_rec IN FA_API_TYPES.group_reclass_options_rec_type,
590 p_log_level_rec IN FA_API_TYPES.log_level_rec_type DEFAULT NULL) RETURN BOOLEAN;
591
592 /*Bug 8601485 - Verify the if transfer date of asset is before DPIS */
593 FUNCTION validate_asset_transfer_date
594 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
595 p_trans_rec IN FA_API_TYPES.trans_rec_type,
596 p_calling_fn IN VARCHAR2,
597 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
598
599 /* Bug#8584206-To validate type of transactions allowed on Energy UOP assets */
600 FUNCTION validate_energy_transactions (
601 p_trans_rec IN FA_API_TYPES.trans_rec_type,
602 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type default null,
603 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
604 p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type default null,
605 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
606 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
607
608 /* Bug#8633654-To validate reinstatement possible or not */
609 FUNCTION validate_mbr_reins_possible (
610 p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type,
611 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
612 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
613
614 -- Bug 8722521 : Validation for Japan methods during Tax upload
615 FUNCTION validate_jp_taxupl (
616 p_trans_rec IN FA_API_TYPES.trans_rec_type,
617 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
618 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
619 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
620 p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
621 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
622
623 --Bug 8828394 - Group Asset ID should be valid Group Asset ID
624 FUNCTION validate_group_asset_id(
625 p_asset_id IN NUMBER,
626 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
627
628 -- Bug 8471701-To prevent reserve change if any 'B' row distribution is inactive
629 FUNCTION validate_ltd_deprn_change(
630 p_book_type_code IN VARCHAR2,
631 p_asset_Id IN NUMBER,
632 p_calling_fn IN VARCHAR2,
633 p_log_level_rec IN FA_API_TYPES.log_level_rec_type
634 ) RETURN BOOLEAN;
635 -- End Bug 8471701
636 /*phase5 This function will validate if current transaction is overlapping to any previously done impairment*/
637 FUNCTION check_overlapping_impairment (
638 p_trans_rec IN FA_API_TYPES.trans_rec_type,
639 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
640 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
641
642 /*phase5 This function will restrict any impairment posted on Asset added with depreciate flag NO and wiithout reserve*/
643 FUNCTION check_non_depreciating_asset (
644 p_asset_id IN NUMBER,
645 p_book_type_code IN VARCHAR2,
646 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
647
648 FUNCTION validate_bonus_rule_resv
649 (p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
650 p_asset_desc_rec IN FA_API_TYPES.asset_desc_rec_type,
651 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
652 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
653 p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type,
654 p_calling_fn IN VARCHAR2,
655 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) RETURN BOOLEAN;
656
657 /* Bug 9916378 */
658 FUNCTION validate_uop_method (
659 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
660 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
661 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
662 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
663 p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
664 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
665
666 /* Bug 9916378 */
667 FUNCTION validate_prev_period_amort
668 (
669 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
670 p_trans_rec IN FA_API_TYPES.trans_rec_type,
671 p_period_rec IN FA_API_TYPES.period_rec_type,
672 p_asset_retire_rec IN FA_API_TYPES.asset_retire_rec_type default null,
673 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
674
675 /* Bug 13513616/9559584 */
676 FUNCTION is_financial_info_changed
677 (
678 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type,
679 p_asset_fin_rec_adj IN FA_API_TYPES.asset_fin_rec_type,
680 px_asset_fin_rec_new IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
681 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
682
683 FUNCTION validate_ccid
684 (p_book_type_code IN VARCHAR2,
685 p_ccid IN NUMBER,
686 p_gl_chart_id IN NUMBER,
687 p_ledger_id IN NUMBER,
688 p_validation_date IN DATE,
689 p_calling_fn IN VARCHAR2,
690 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
691
692 /*bug#16426081 */
693 FUNCTION validate_cca_rules (
694 p_trans_rec IN FA_API_TYPES.trans_rec_type,
695 p_asset_hdr_rec IN FA_API_TYPES.asset_hdr_rec_type,
696 p_asset_type_rec IN FA_API_TYPES.asset_type_rec_type,
697 p_asset_fin_rec IN FA_API_TYPES.asset_fin_rec_type,
698 p_asset_fin_rec_old IN FA_API_TYPES.asset_fin_rec_type default null,
699 p_asset_deprn_rec IN FA_API_TYPES.asset_deprn_rec_type default null,
700 p_asset_deprn_rec_adj IN FA_API_TYPES.asset_deprn_rec_type default null,
701 p_period_rec IN FA_API_TYPES.period_rec_type,
702 p_log_level_rec IN FA_API_TYPES.log_level_rec_type) RETURN BOOLEAN;
703
704 END FA_ASSET_VAL_PVT;
[Home] [Help]