APPS.IGI_IAC_REINSTATE_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 104: FROM igi_iac_asset_balances iiab

100: iiab.general_fund,
101: iiab.last_reval_date,
102: iiab.current_reval_factor,
103: iiab.cumulative_reval_factor
104: FROM igi_iac_asset_balances iiab
105: WHERE iiab.asset_id = n_asset_id
106: AND iiab.book_type_code = n_book_type_code
107: AND iiab.period_counter = n_period_counter;
108:

Line 1040: FROM igi_iac_asset_balances

1036: -- update the asset balances table for the asset to reflect the full reinstatement
1037: -- if a row exists for the asset for the current period else create a new row
1038: SELECT count(*)
1039: INTO l_exists
1040: FROM igi_iac_asset_balances
1041: WHERE asset_id = g_asset_id
1042: AND book_type_code = g_book_type_code
1043: AND period_counter = p_period_counter;
1044:

Line 1080: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

1076:
1077: IF (l_exists > 0) THEN
1078: -- update the existing asset balances record
1079: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating asset balances');
1080: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1081: X_asset_id => g_asset_id,
1082: X_book_type_code => g_book_type_code,
1083: X_period_counter => p_period_counter,
1084: X_net_book_value => l_ab_net_book_value,

Line 1101: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1097: ELSE
1098: -- insert a new record for the reinstatement period by bringing forward the record previous to the
1099: -- retired with catchup values adjusted for account type RESERVE and GENERAL FUND
1100: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into asset balances');
1101: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1102: X_rowid => l_rowid,
1103: X_asset_id => g_asset_id,
1104: X_book_type_code => g_book_type_code,
1105: X_period_counter => p_period_counter,

Line 1749: FROM igi_iac_asset_balances

1745:
1746: -- if a row exists for the asset for the current period else create a new row
1747: SELECT count(*)
1748: INTO l_exists
1749: FROM igi_iac_asset_balances
1750: WHERE asset_id = g_asset_id
1751: AND book_type_code = g_book_type_code
1752: AND period_counter = p_period_counter;
1753:

Line 1788: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

1784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund: '||l_ab_general_fund);
1785:
1786: IF (l_exists > 0) THEN
1787: -- update the asset balances to reflect the reinstatement
1788: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1789: X_asset_id => g_asset_id,
1790: X_book_type_code => g_book_type_code,
1791: X_period_counter => p_period_counter,
1792: X_net_book_value => l_ab_net_book_value,

Line 1807: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1803: ) ;
1804: ELSE
1805: -- insert a row for the current period counter
1806:
1807: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1808: X_rowid => l_rowid,
1809: X_asset_id => g_asset_id,
1810: X_book_type_code => g_book_type_code,
1811: X_period_counter => p_period_counter,

Line 2789: FROM igi_iac_asset_balances

2785: -- update the existing asset balances record
2786: -- if a row exists for the asset for the current period else create a new row
2787: SELECT count(*)
2788: INTO l_exists
2789: FROM igi_iac_asset_balances
2790: WHERE asset_id = g_asset_id
2791: AND book_type_code = g_book_type_code
2792: AND period_counter = p_period_counter;
2793:

Line 2825: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

2821: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Blog deprn reserve: '||l_ab_backlog_deprn_reserve);
2822: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund: '||l_ab_general_fund);
2823:
2824: IF (l_exists > 0) THEN
2825: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
2826: X_asset_id => g_asset_id,
2827: X_book_type_code => g_book_type_code,
2828: X_period_counter => p_period_counter,
2829: X_net_book_value => l_ab_net_book_value,

Line 2843: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

2839: X_cumulative_reval_factor => l_ret_ass_bal.cumulative_reval_factor
2840: ) ;
2841: ELSE
2842: -- insert a row for the current period counter
2843: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
2844: X_rowid => l_rowid,
2845: X_asset_id => g_asset_id,
2846: X_book_type_code => g_book_type_code,
2847: X_period_counter => p_period_counter,