1: PACKAGE BODY FA_TERMINAL_GAIN_LOSS_PVT as
2: /* $Header: FAVTGLB.pls 120.10.12020000.2 2013/03/02 19:24:07 dvjoshi ship $ */
3:
4: g_log_level_rec fa_api_types.log_level_rec_type;
5:
6: FUNCTION fadtgl (
7: p_asset_id IN NUMBER,
8: p_book_type_code IN VARCHAR2,
12: ) RETURN NUMBER IS
13:
14: l_calling_fn varchar2(50) := 'FA_TERMINAL_GAIN_LOSS_PVT.fadtgl';
15: l_db_title varchar2(30) := 'fadtgl';
16: l_trans_rec FA_API_TYPES.trans_rec_type;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
13:
14: l_calling_fn varchar2(50) := 'FA_TERMINAL_GAIN_LOSS_PVT.fadtgl';
15: l_db_title varchar2(30) := 'fadtgl';
16: l_trans_rec FA_API_TYPES.trans_rec_type;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
21: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
14: l_calling_fn varchar2(50) := 'FA_TERMINAL_GAIN_LOSS_PVT.fadtgl';
15: l_db_title varchar2(30) := 'fadtgl';
16: l_trans_rec FA_API_TYPES.trans_rec_type;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
21: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
22: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
15: l_db_title varchar2(30) := 'fadtgl';
16: l_trans_rec FA_API_TYPES.trans_rec_type;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
21: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
22: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
23:
16: l_trans_rec FA_API_TYPES.trans_rec_type;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
21: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
22: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
23:
24: l_date_effective date;
17: l_asset_hdr_rec FA_API_TYPES.asset_hdr_rec_type;
18: l_asset_type_rec FA_API_TYPES.asset_type_rec_type;
19: l_asset_fin_rec FA_API_TYPES.asset_fin_rec_type;
20: l_period_rec FA_API_TYPES.period_rec_type;
21: l_asset_cat_rec FA_API_TYPES.asset_cat_rec_type;
22: l_adj FA_ADJUST_TYPE_PKG.FA_ADJ_ROW_STRUCT;
23:
24: l_date_effective date;
25: l_updated_by number;