oracle ebs 固定资产 折旧 deprn_amount,Oracle EBS FA 获取累计折旧

FUNCTION get_ltd_deprn(p_asset_id IN NUMBER,

p_book_type_code IN VARCHAR2,

p_rate_source_rule IN VARCHAR2 DEFAULT NULL,

p_dist_id IN NUMBER DEFAULT 0,

p_period_ctr IN NUMBER DEFAULT 0,

p_mrc_sob_type_code IN VARCHAR2 DEFAULT 'N',

p_set_of_books_id IN NUMBER) RETURN NUMBER IS

dummy_num NUMBER;

dummy_bool BOOLEAN;

dummy_char VARCHAR2(2000);

l_log_level_rec fa_api_types.log_level_rec_type;

l_ltd_production NUMBER;

l_ytd_production NUMBER;

l_ltd_deprn NUMBER;

l_ytd_deprn NUMBER;

BEGIN

fa_query_balances_pkg.query_balances(x_asset_id => p_asset_id,

x_book => p_book_type_code,

x_period_ctr => nvl(p_period_ctr,

0),

x_dist_id => nvl(p_dist_id,

0),

x_run_mode => 'STANDARD',

x_cost => dummy_num,