111:
112: l_path_name VARCHAR2(150) := g_path||'do_record_adjustments';
113:
114: /* this function returns true if asset is revalued atleast once in iac else returns false */
115: FUNCTION is_asset_revalued_once(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
116: p_book_type_code igi_iac_asset_balances.book_type_code%TYPE )
117: RETURN boolean IS
118: /* this function returns true if asset is revalued atleast once in iac else returns false */
119: CURSOR c_asset_reval_info IS
112: l_path_name VARCHAR2(150) := g_path||'do_record_adjustments';
113:
114: /* this function returns true if asset is revalued atleast once in iac else returns false */
115: FUNCTION is_asset_revalued_once(p_asset_id igi_iac_asset_balances.asset_id%TYPE,
116: p_book_type_code igi_iac_asset_balances.book_type_code%TYPE )
117: RETURN boolean IS
118: /* this function returns true if asset is revalued atleast once in iac else returns false */
119: CURSOR c_asset_reval_info IS
120: SELECT COUNT(*)
117: RETURN boolean IS
118: /* this function returns true if asset is revalued atleast once in iac else returns false */
119: CURSOR c_asset_reval_info IS
120: SELECT COUNT(*)
121: FROM igi_iac_asset_balances
122: WHERE asset_id = p_asset_id
123: AND book_type_code = p_book_type_code ;
124:
125: l_reval_count number;