[Home] [Help]
5: bks_book_type_code in varchar2,
6: bks_depreciation_check in out nocopy varchar2,
7: bks_current_period_flag in out nocopy varchar2,
8: bks_calling_fn varchar2,
9: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
10: IS
11:
12: cursor deprn_check is
13: select 'Y'
63: bks_recoverable_cost in out nocopy number,
64: bks_date_placed_in_service in date,
65: x_return_status out nocopy boolean,
66: bks_calling_fn varchar2,
67: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
68: is
69: cursor no_itc_yes_ceiling is
70: select least(bks_cost - bks_salvage_value,
71: nvl(ce.limit, bks_cost - bks_salvage_value))
210: bks_cost in number,
211: bks_salvage_value in number,
212: x_return_status out nocopy boolean,
213: bks_calling_fn varchar2,
214: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
215: is
216: amt_error exception; -- syoung.
217: begin
218: if bks_depreciation_check <> 'Y' then
351: bks_itc_amount_id in number,
352: bks_ceiling_type in varchar2,
353: bks_depreciate_flag in varchar2,
354: bks_calling_fn varchar2,
355: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
356: is
357: /* BUG# 1487644
358: this doesn't work when the entire fiscal year is not defined
359: removing joins to deprn periods and going strictly against FY
645: bks_global_attribute20 in varchar2,
646: bks_global_attribute_category in varchar2,
647: bks_adjustment_required_status in out nocopy varchar2,
648: bks_calling_fn varchar2,
649: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
650: is
651: cursor exist_to_book_cur is
652: select 'Y'
653: from fa_books bk