eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_REINSTATE_PKG dependencies on IGI_IAC_DET_BALANCES

Line 110: -- from igi_iac_det_balances for an

106: AND iiab.book_type_code = n_book_type_code
107: AND iiab.period_counter = n_period_counter;
108:
109: -- cursor to get all distribution_ids
110: -- from igi_iac_det_balances for an
111: -- adjustment_id
112:
113: CURSOR c_det_bal(n_adjust_id NUMBER)
114: IS

Line 138: FROM igi_iac_det_balances iidb

134: iidb.last_reval_date,
135: iidb.current_reval_factor,
136: iidb.cumulative_reval_factor,
137: iidb.active_flag
138: FROM igi_iac_det_balances iidb
139: WHERE iidb.adjustment_id = n_adjust_id
140: AND iidb.active_flag IS NULL
141: ORDER BY iidb.distribution_id;
142:

Line 223: FROM igi_iac_det_balances iidb,

219: iidb.active_flag,
220: iidb.last_reval_date,
221: iidb.current_reval_factor,
222: iidb.cumulative_reval_factor
223: FROM igi_iac_det_balances iidb,
224: fa_distribution_history fdh
225: WHERE iidb.adjustment_id = cp_adjustment_id
226: AND iidb.book_type_code = cp_book_type_code
227: AND iidb.asset_id = cp_asset_id

Line 242: FROM igi_iac_det_balances iidb

238: SELECT iidb.deprn_period,
239: iidb.deprn_reserve,
240: iidb.general_fund_acc,
241: iidb.reval_reserve_gen_fund
242: FROM igi_iac_det_balances iidb
243: WHERE iidb.adjustment_id = n_adjust_id
244: AND iidb.distribution_id = n_dist_id;
245:
246: -- bug 2480915, start (1)

Line 485: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;

481: -- local variables
482: l_rowid ROWID;
483:
484: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
485: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
486: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
487:
488: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;
489: l_prorate_factor NUMBER;

Line 486: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;

482: l_rowid ROWID;
483:
484: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
485: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
486: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
487:
488: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;
489: l_prorate_factor NUMBER;
490: l_elapsed_periods NUMBER;

Line 548: l_active_flag igi_iac_det_balances.active_flag%TYPE;

544: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
545: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
546: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
547: -- bug 2480915 end(1)
548: l_active_flag igi_iac_det_balances.active_flag%TYPE;
549:
550: -- exceptions
551: e_no_corr_reinstatement EXCEPTION;
552: e_no_ccid_found EXCEPTION;

Line 719: -- insert into igi_iac_det_balances with reinstatement adjustment_id

715: l_tot_deprn_reserve_backlog := l_tot_deprn_reserve_backlog + l_deprn_reserve_backlog;
716: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
717: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
718:
719: -- insert into igi_iac_det_balances with reinstatement adjustment_id
720: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
721: x_rowid => l_rowid,
722: x_adjustment_id => p_adjust_id_reinstate,
723: x_asset_id => g_asset_id,

Line 720: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

716: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
717: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
718:
719: -- insert into igi_iac_det_balances with reinstatement adjustment_id
720: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
721: x_rowid => l_rowid,
722: x_adjustment_id => p_adjust_id_reinstate,
723: x_asset_id => g_asset_id,
724: x_book_type_code => g_book_type_code,

Line 943: -- insert into igi_iac_det_balances with reinstatement adjustment_id

939: l_get_ytd.general_fund_acc := 0;
940: END IF;
941: l_active_flag := 'N';
942:
943: -- insert into igi_iac_det_balances with reinstatement adjustment_id
944: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
945: x_rowid => l_rowid,
946: x_adjustment_id => p_adjust_id_reinstate,
947: x_asset_id => g_asset_id,

Line 944: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

940: END IF;
941: l_active_flag := 'N';
942:
943: -- insert into igi_iac_det_balances with reinstatement adjustment_id
944: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
945: x_rowid => l_rowid,
946: x_adjustment_id => p_adjust_id_reinstate,
947: x_asset_id => g_asset_id,
948: x_book_type_code => g_book_type_code,

Line 1414: -- insert into igi_iac_det_balances with reinstatement adjustment_id

1410: l_tot_deprn_reserve_backlog := l_tot_deprn_reserve_backlog + l_deprn_reserve_backlog;
1411: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
1412: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
1413:
1414: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1415: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1416: x_rowid => l_rowid,
1417: x_adjustment_id => p_adjust_id_reinstate,
1418: x_asset_id => g_asset_id,

Line 1415: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1411: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
1412: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
1413:
1414: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1415: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1416: x_rowid => l_rowid,
1417: x_adjustment_id => p_adjust_id_reinstate,
1418: x_asset_id => g_asset_id,
1419: x_book_type_code => g_book_type_code,

Line 1647: -- insert into igi_iac_det_balances with reinstatement adjustment_id

1643: FOR l_get_ytd IN c_get_ytd(cp_adjustment_id => l_prev_adj_id,
1644: cp_asset_id => g_asset_id,
1645: cp_book_type_code => g_book_type_code) LOOP
1646: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: dist id: '||l_get_ytd.distribution_id);
1647: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1648: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1649: x_rowid => l_rowid,
1650: x_adjustment_id => p_adjust_id_reinstate,
1651: x_asset_id => g_asset_id,

Line 1648: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1644: cp_asset_id => g_asset_id,
1645: cp_book_type_code => g_book_type_code) LOOP
1646: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: dist id: '||l_get_ytd.distribution_id);
1647: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1648: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1649: x_rowid => l_rowid,
1650: x_adjustment_id => p_adjust_id_reinstate,
1651: x_asset_id => g_asset_id,
1652: x_book_type_code => g_book_type_code,

Line 1866: -- from igi_iac_det_balances for an

1862: RETURN BOOLEAN
1863: IS
1864:
1865: -- cursor to get all distribution_ids
1866: -- from igi_iac_det_balances for an
1867: -- adjustment_id and distribution id
1868: CURSOR c_dist_det_bal(n_adjust_id NUMBER,
1869: n_dist_id NUMBER,
1870: n_retirement_id NUMBER)

Line 1894: FROM igi_iac_det_balances iidb,

1890: iidb.last_reval_date,
1891: iidb.current_reval_factor,
1892: iidb.cumulative_reval_factor,
1893: iidb.active_flag
1894: FROM igi_iac_det_balances iidb,
1895: fa_distribution_history fdh
1896: WHERE iidb.adjustment_id = n_adjust_id
1897: AND iidb.distribution_id = n_dist_id
1898: AND fdh.distribution_id = iidb.distribution_id

Line 1917: FROM igi_iac_det_balances iidb

1913: iidb.deprn_ytd,
1914: iidb.last_reval_date,
1915: iidb.current_reval_factor,
1916: iidb.cumulative_reval_factor
1917: FROM igi_iac_det_balances iidb
1918: WHERE iidb.distribution_id = n_dist_id
1919: AND iidb.period_counter = (SELECT max(idb1.period_counter)
1920: FROM igi_iac_det_balances idb1
1921: WHERE idb1.distribution_id = n_dist_id

Line 1920: FROM igi_iac_det_balances idb1

1916: iidb.cumulative_reval_factor
1917: FROM igi_iac_det_balances iidb
1918: WHERE iidb.distribution_id = n_dist_id
1919: AND iidb.period_counter = (SELECT max(idb1.period_counter)
1920: FROM igi_iac_det_balances idb1
1921: WHERE idb1.distribution_id = n_dist_id
1922: AND active_flag IS NULL);
1923: -- bug 2485778, end 1
1924:

Line 1932: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;

1928:
1929: l_units_ren fa_distribution_history.units_assigned%TYPE;
1930: l_units_ret fa_distribution_history.units_assigned%TYPE;
1931: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1932: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;
1933:
1934: l_retire_effect NUMBER := 0;
1935: l_prorate_factor NUMBER;
1936: l_rsv_catchup NUMBER;

Line 1952: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;

1948:
1949: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1950: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1951:
1952: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1953: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
1954: l_adjustment_cost NUMBER;
1955: l_net_book_value NUMBER;
1956: l_reval_reserve_cost NUMBER;

Line 1953: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;

1949: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1950: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1951:
1952: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1953: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
1954: l_adjustment_cost NUMBER;
1955: l_net_book_value NUMBER;
1956: l_reval_reserve_cost NUMBER;
1957: l_reval_reserve_backlog NUMBER;

Line 1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;

1993: l_ab_deprn_reserve NUMBER;
1994: l_ab_backlog_deprn_reserve NUMBER;
1995: l_ab_general_fund NUMBER;
1996:
1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;

Line 1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;

1994: l_ab_backlog_deprn_reserve NUMBER;
1995: l_ab_general_fund NUMBER;
1996:
1997: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
1998: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
1999: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2000: l_dist_units fa_distribution_history.transaction_units%TYPE;
2001: l_curr_units fa_distribution_history.units_assigned%TYPE;
2002:

Line 2016: l_active_flag igi_iac_det_balances.active_flag%TYPE;

2012: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2013: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2014: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2015: -- bug 2480915 end(15)
2016: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2017:
2018: -- exceptions
2019: e_no_corr_reinstatement EXCEPTION;
2020: e_no_ccid_found EXCEPTION;

Line 2057: -- from igi_iac_det_balances previous to the retirement

2053: CLOSE c_fully_reserved;
2054: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset fully reserved period counter: '||l_fully_reserved);
2055:
2056: -- get the active distributions for the transaction
2057: -- from igi_iac_det_balances previous to the retirement
2058: FOR l_det_bal IN c_det_bal(l_prev_adj_id) LOOP
2059: -- initialise to zero for each distribution_id
2060: l_rsv_catchup_amt := 0;
2061:

Line 2190: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2186: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
2187: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
2188:
2189: -- insert into detail balances
2190: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2191: x_rowid => l_rowid,
2192: x_adjustment_id => p_adjust_id_reinstate,
2193: x_asset_id => g_asset_id,
2194: x_book_type_code => g_book_type_code,

Line 2427: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2423: END IF;
2424: CLOSE c_ret_ytd;
2425:
2426: -- insert into detail balances
2427: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2428: x_rowid => l_rowid,
2429: x_adjustment_id => p_adjust_id_reinstate,
2430: x_asset_id => g_asset_id,
2431: x_book_type_code => g_book_type_code,

Line 2681: -- insert into igi_iac_det_balances with reinstatement adjustment_id

2677: l_get_ytd.general_fund_acc := 0;
2678: END IF;
2679: l_active_flag := 'N';
2680:
2681: -- insert into igi_iac_det_balances with reinstatement adjustment_id
2682: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2683: x_rowid => l_rowid,
2684: x_adjustment_id => p_adjust_id_reinstate,
2685: x_asset_id => g_asset_id,

Line 2682: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2678: END IF;
2679: l_active_flag := 'N';
2680:
2681: -- insert into igi_iac_det_balances with reinstatement adjustment_id
2682: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2683: x_rowid => l_rowid,
2684: x_adjustment_id => p_adjust_id_reinstate,
2685: x_asset_id => g_asset_id,
2686: x_book_type_code => g_book_type_code,

Line 2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;

2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2920: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2921:
2922: l_path VARCHAR2(150);
2923: