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 507: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;

503: -- local variables
504: l_rowid ROWID;
505:
506: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
507: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
508: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
509:
510: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;
511: l_prorate_factor NUMBER;

Line 508: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;

504: l_rowid ROWID;
505:
506: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
507: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
508: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
509:
510: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;
511: l_prorate_factor NUMBER;
512: l_elapsed_periods NUMBER;

Line 570: l_active_flag igi_iac_det_balances.active_flag%TYPE;

566: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
567: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
568: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
569: -- bug 2480915 end(1)
570: l_active_flag igi_iac_det_balances.active_flag%TYPE;
571:
572: -- exceptions
573: e_no_corr_reinstatement EXCEPTION;
574: e_no_ccid_found EXCEPTION;

Line 745: -- insert into igi_iac_det_balances with reinstatement adjustment_id

741: l_tot_deprn_reserve_backlog := l_tot_deprn_reserve_backlog + l_deprn_reserve_backlog;
742: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
743: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
744:
745: -- insert into igi_iac_det_balances with reinstatement adjustment_id
746: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
747: x_rowid => l_rowid,
748: x_adjustment_id => p_adjust_id_reinstate,
749: x_asset_id => g_asset_id,

Line 746: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

742: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
743: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
744:
745: -- insert into igi_iac_det_balances with reinstatement adjustment_id
746: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
747: x_rowid => l_rowid,
748: x_adjustment_id => p_adjust_id_reinstate,
749: x_asset_id => g_asset_id,
750: x_book_type_code => g_book_type_code,

Line 969: -- insert into igi_iac_det_balances with reinstatement adjustment_id

965: l_get_ytd.general_fund_acc := 0;
966: END IF;
967: l_active_flag := 'N';
968:
969: -- insert into igi_iac_det_balances with reinstatement adjustment_id
970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
971: x_rowid => l_rowid,
972: x_adjustment_id => p_adjust_id_reinstate,
973: x_asset_id => g_asset_id,

Line 970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

966: END IF;
967: l_active_flag := 'N';
968:
969: -- insert into igi_iac_det_balances with reinstatement adjustment_id
970: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
971: x_rowid => l_rowid,
972: x_adjustment_id => p_adjust_id_reinstate,
973: x_asset_id => g_asset_id,
974: x_book_type_code => g_book_type_code,

Line 1445: -- insert into igi_iac_det_balances with reinstatement adjustment_id

1441: l_tot_deprn_reserve_backlog := l_tot_deprn_reserve_backlog + l_deprn_reserve_backlog;
1442: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
1443: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
1444:
1445: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1446: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1447: x_rowid => l_rowid,
1448: x_adjustment_id => p_adjust_id_reinstate,
1449: x_asset_id => g_asset_id,

Line 1446: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1442: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
1443: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
1444:
1445: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1446: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1447: x_rowid => l_rowid,
1448: x_adjustment_id => p_adjust_id_reinstate,
1449: x_asset_id => g_asset_id,
1450: x_book_type_code => g_book_type_code,

Line 1679: -- insert into igi_iac_det_balances with reinstatement adjustment_id

1675: FOR l_get_ytd IN c_get_ytd(cp_adjustment_id => l_prev_adj_id,
1676: cp_asset_id => g_asset_id,
1677: cp_book_type_code => g_book_type_code) LOOP
1678: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: dist id: '||l_get_ytd.distribution_id);
1679: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1680: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1681: x_rowid => l_rowid,
1682: x_adjustment_id => p_adjust_id_reinstate,
1683: x_asset_id => g_asset_id,

Line 1680: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

1676: cp_asset_id => g_asset_id,
1677: cp_book_type_code => g_book_type_code) LOOP
1678: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'In YTD: dist id: '||l_get_ytd.distribution_id);
1679: -- insert into igi_iac_det_balances with reinstatement adjustment_id
1680: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
1681: x_rowid => l_rowid,
1682: x_adjustment_id => p_adjust_id_reinstate,
1683: x_asset_id => g_asset_id,
1684: x_book_type_code => g_book_type_code,

Line 1898: -- from igi_iac_det_balances for an

1894: RETURN BOOLEAN
1895: IS
1896:
1897: -- cursor to get all distribution_ids
1898: -- from igi_iac_det_balances for an
1899: -- adjustment_id and distribution id
1900: CURSOR c_dist_det_bal(n_adjust_id NUMBER,
1901: n_dist_id NUMBER,
1902: n_retirement_id NUMBER)

Line 1926: FROM igi_iac_det_balances iidb,

1922: iidb.last_reval_date,
1923: iidb.current_reval_factor,
1924: iidb.cumulative_reval_factor,
1925: iidb.active_flag
1926: FROM igi_iac_det_balances iidb,
1927: fa_distribution_history fdh
1928: WHERE iidb.adjustment_id = n_adjust_id
1929: AND iidb.distribution_id = n_dist_id
1930: AND fdh.distribution_id = iidb.distribution_id

Line 1949: FROM igi_iac_det_balances iidb

1945: iidb.deprn_ytd,
1946: iidb.last_reval_date,
1947: iidb.current_reval_factor,
1948: iidb.cumulative_reval_factor
1949: FROM igi_iac_det_balances iidb
1950: WHERE iidb.distribution_id = n_dist_id
1951: AND iidb.period_counter = (SELECT max(idb1.period_counter)
1952: FROM igi_iac_det_balances idb1
1953: WHERE idb1.distribution_id = n_dist_id

Line 1952: FROM igi_iac_det_balances idb1

1948: iidb.cumulative_reval_factor
1949: FROM igi_iac_det_balances iidb
1950: WHERE iidb.distribution_id = n_dist_id
1951: AND iidb.period_counter = (SELECT max(idb1.period_counter)
1952: FROM igi_iac_det_balances idb1
1953: WHERE idb1.distribution_id = n_dist_id
1954: AND active_flag IS NULL);
1955: -- bug 2485778, end 1
1956:

Line 1964: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;

1960:
1961: l_units_ren fa_distribution_history.units_assigned%TYPE;
1962: l_units_ret fa_distribution_history.units_assigned%TYPE;
1963: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1964: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;
1965:
1966: l_retire_effect NUMBER := 0;
1967: l_prorate_factor NUMBER;
1968: l_rsv_catchup NUMBER;

Line 1984: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;

1980:
1981: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1982: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1983:
1984: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1985: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
1986: l_adjustment_cost NUMBER;
1987: l_net_book_value NUMBER;
1988: l_reval_reserve_cost NUMBER;

Line 1985: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;

1981: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1982: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1983:
1984: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1985: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
1986: l_adjustment_cost NUMBER;
1987: l_net_book_value NUMBER;
1988: l_reval_reserve_cost NUMBER;
1989: l_reval_reserve_backlog NUMBER;

Line 2029: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;

2025: l_ab_deprn_reserve NUMBER;
2026: l_ab_backlog_deprn_reserve NUMBER;
2027: l_ab_general_fund NUMBER;
2028:
2029: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2030: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
2031: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2032: l_dist_units fa_distribution_history.transaction_units%TYPE;
2033: l_curr_units fa_distribution_history.units_assigned%TYPE;

Line 2030: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;

2026: l_ab_backlog_deprn_reserve NUMBER;
2027: l_ab_general_fund NUMBER;
2028:
2029: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2030: l_ret_dist_id igi_iac_det_balances.distribution_id%TYPE;
2031: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2032: l_dist_units fa_distribution_history.transaction_units%TYPE;
2033: l_curr_units fa_distribution_history.units_assigned%TYPE;
2034:

Line 2048: l_active_flag igi_iac_det_balances.active_flag%TYPE;

2044: l_fa_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
2045: l_fa_deprn_period igi_iac_fa_deprn.deprn_period%TYPE;
2046: l_fa_deprn_reserve igi_iac_fa_deprn.deprn_reserve%TYPE;
2047: -- bug 2480915 end(15)
2048: l_active_flag igi_iac_det_balances.active_flag%TYPE;
2049:
2050: -- exceptions
2051: e_no_corr_reinstatement EXCEPTION;
2052: e_no_ccid_found EXCEPTION;

Line 2089: -- from igi_iac_det_balances previous to the retirement

2085: CLOSE c_fully_reserved;
2086: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Asset fully reserved period counter: '||l_fully_reserved);
2087:
2088: -- get the active distributions for the transaction
2089: -- from igi_iac_det_balances previous to the retirement
2090: FOR l_det_bal IN c_det_bal(l_prev_adj_id) LOOP
2091: -- initialise to zero for each distribution_id
2092: l_rsv_catchup_amt := 0;
2093:

Line 2226: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2222: l_tot_general_fund_per := l_tot_general_fund_per + l_general_fund_per;
2223: l_tot_general_fund_acc := l_tot_general_fund_acc + l_general_fund_acc;
2224:
2225: -- insert into detail balances
2226: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2227: x_rowid => l_rowid,
2228: x_adjustment_id => p_adjust_id_reinstate,
2229: x_asset_id => g_asset_id,
2230: x_book_type_code => g_book_type_code,

Line 2463: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2459: END IF;
2460: CLOSE c_ret_ytd;
2461:
2462: -- insert into detail balances
2463: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2464: x_rowid => l_rowid,
2465: x_adjustment_id => p_adjust_id_reinstate,
2466: x_asset_id => g_asset_id,
2467: x_book_type_code => g_book_type_code,

Line 2718: -- insert into igi_iac_det_balances with reinstatement adjustment_id

2714: l_get_ytd.general_fund_acc := 0;
2715: END IF;
2716: l_active_flag := 'N';
2717:
2718: -- insert into igi_iac_det_balances with reinstatement adjustment_id
2719: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2720: x_rowid => l_rowid,
2721: x_adjustment_id => p_adjust_id_reinstate,
2722: x_asset_id => g_asset_id,

Line 2719: IGI_IAC_DET_BALANCES_PKG.Insert_Row(

2715: END IF;
2716: l_active_flag := 'N';
2717:
2718: -- insert into igi_iac_det_balances with reinstatement adjustment_id
2719: IGI_IAC_DET_BALANCES_PKG.Insert_Row(
2720: x_rowid => l_rowid,
2721: x_adjustment_id => p_adjust_id_reinstate,
2722: x_asset_id => g_asset_id,
2723: x_book_type_code => g_book_type_code,

Line 2956: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;

2952: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2953: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2954: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2955: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2956: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2957: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2958:
2959: l_path VARCHAR2(150);
2960: