DBA Data[Home] [Help]

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 1014: FROM igi_iac_asset_balances

1010: -- update the asset balances table for the asset to reflect the full reinstatement
1011: -- if a row exists for the asset for the current period else create a new row
1012: SELECT count(*)
1013: INTO l_exists
1014: FROM igi_iac_asset_balances
1015: WHERE asset_id = g_asset_id
1016: AND book_type_code = g_book_type_code
1017: AND period_counter = p_period_counter;
1018:

Line 1054: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

1050:
1051: IF (l_exists > 0) THEN
1052: -- update the existing asset balances record
1053: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updating asset balances');
1054: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1055: X_asset_id => g_asset_id,
1056: X_book_type_code => g_book_type_code,
1057: X_period_counter => p_period_counter,
1058: X_net_book_value => l_ab_net_book_value,

Line 1075: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1071: ELSE
1072: -- insert a new record for the reinstatement period by bringing forward the record previous to the
1073: -- retired with catchup values adjusted for account type RESERVE and GENERAL FUND
1074: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserting into asset balances');
1075: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1076: X_rowid => l_rowid,
1077: X_asset_id => g_asset_id,
1078: X_book_type_code => g_book_type_code,
1079: X_period_counter => p_period_counter,

Line 1717: FROM igi_iac_asset_balances

1713:
1714: -- if a row exists for the asset for the current period else create a new row
1715: SELECT count(*)
1716: INTO l_exists
1717: FROM igi_iac_asset_balances
1718: WHERE asset_id = g_asset_id
1719: AND book_type_code = g_book_type_code
1720: AND period_counter = p_period_counter;
1721:

Line 1756: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

1752: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund: '||l_ab_general_fund);
1753:
1754: IF (l_exists > 0) THEN
1755: -- update the asset balances to reflect the reinstatement
1756: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
1757: X_asset_id => g_asset_id,
1758: X_book_type_code => g_book_type_code,
1759: X_period_counter => p_period_counter,
1760: X_net_book_value => l_ab_net_book_value,

Line 1775: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

1771: ) ;
1772: ELSE
1773: -- insert a row for the current period counter
1774:
1775: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
1776: X_rowid => l_rowid,
1777: X_asset_id => g_asset_id,
1778: X_book_type_code => g_book_type_code,
1779: X_period_counter => p_period_counter,

Line 2752: FROM igi_iac_asset_balances

2748: -- update the existing asset balances record
2749: -- if a row exists for the asset for the current period else create a new row
2750: SELECT count(*)
2751: INTO l_exists
2752: FROM igi_iac_asset_balances
2753: WHERE asset_id = g_asset_id
2754: AND book_type_code = g_book_type_code
2755: AND period_counter = p_period_counter;
2756:

Line 2788: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(

2784: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Blog deprn reserve: '||l_ab_backlog_deprn_reserve);
2785: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Gen Fund: '||l_ab_general_fund);
2786:
2787: IF (l_exists > 0) THEN
2788: IGI_IAC_ASSET_BALANCES_PKG.Update_Row(
2789: X_asset_id => g_asset_id,
2790: X_book_type_code => g_book_type_code,
2791: X_period_counter => p_period_counter,
2792: X_net_book_value => l_ab_net_book_value,

Line 2806: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(

2802: X_cumulative_reval_factor => l_ret_ass_bal.cumulative_reval_factor
2803: ) ;
2804: ELSE
2805: -- insert a row for the current period counter
2806: IGI_IAC_ASSET_BALANCES_PKG.Insert_Row(
2807: X_rowid => l_rowid,
2808: X_asset_id => g_asset_id,
2809: X_book_type_code => g_book_type_code,
2810: X_period_counter => p_period_counter,