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_RETIREMENT dependencies on IGI_IAC_DET_BALANCES

Line 55: FROM igi_iac_det_balances

51:
52:
53: CURSOR c_detail_balances (p_current_adjustment NUMBER) IS
54: SELECT *
55: FROM igi_iac_det_balances
56: WHERE adjustment_id = p_current_adjustment ;
57:
58: CURSOR c_units_per_dist (p_c_asset_id NUMBER, p_c_book_type_code VARCHAR2, p_dist_id NUMBER) IS
59: SELECT units_assigned, transaction_units

Line 209: FROM igi_iac_det_balances

205: p_book_type_code fa_books.book_type_code%TYPE,
206: p_distribution_id Number,
207: P_period_counter Number) IS
208: SELECT *
209: FROM igi_iac_det_balances
210: WHERE book_type_code = p_book_type_code
211: AND asset_id = p_asset_id
212: AND distribution_id = p_distribution_id
213: AND adjustment_id = (SELECT MAX(adjustment_id)

Line 218: FROM igi_iac_det_balances

214: FROM igi_iac_transaction_headers
215: WHERE asset_id = p_asset_id
216: AND book_type_code = p_book_type_code
217: AND period_counter = ( SELECT max(period_counter)
218: FROM igi_iac_det_balances
219: WHERE book_type_code = p_book_type_code
220: AND asset_id = p_asset_id
221: AND distribution_id = p_distribution_id
222: AND period_counter < p_period_counter )

Line 276: l_detail_balances igi_iac_det_balances%ROWTYPE;

272:
273: l_rowid ROWID;
274: l_asset_balances igi_iac_asset_balances%ROWTYPE;
275: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
276: l_detail_balances igi_iac_det_balances%ROWTYPE;
277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

273: l_rowid ROWID;
274: l_asset_balances igi_iac_asset_balances%ROWTYPE;
275: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
276: l_detail_balances igi_iac_det_balances%ROWTYPE;
277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

274: l_asset_balances igi_iac_asset_balances%ROWTYPE;
275: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
276: l_detail_balances igi_iac_det_balances%ROWTYPE;
277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

275: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
276: l_detail_balances igi_iac_det_balances%ROWTYPE;
277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
283: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

276: l_detail_balances igi_iac_det_balances%ROWTYPE;
277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
283: l_units_per_dist c_units_per_dist%ROWTYPE;
284: l_cost_account_ccid NUMBER ;

Line 281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

277: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
278: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
279: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
280: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
281: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
282: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
283: l_units_per_dist c_units_per_dist%ROWTYPE;
284: l_cost_account_ccid NUMBER ;
285: l_acc_deprn_account_ccid NUMBER ;

Line 302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

298: l_asset_units_count NUMBER ;
299: l_previous_per NUMBER ;
300: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
301: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

299: l_previous_per NUMBER ;
300: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
301: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
302: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
303: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
304: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
305: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
306: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
307: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 973: igi_iac_det_balances_pkg.insert_row(

969:
970: debug( g_state_level,l_path_name,'start insert det bal');
971: l_rowid := NULL ;
972:
973: igi_iac_det_balances_pkg.insert_row(
974: X_rowid => l_rowid ,
975: X_adjustment_id => l_retirement_adjustment_id ,
976: X_asset_id => P_Asset_Id ,
977: X_distribution_id => l_detail_balances.distribution_id ,

Line 1078: igi_iac_det_balances_pkg.insert_row(

1074: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
1075: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);
1076: END IF;
1077:
1078: igi_iac_det_balances_pkg.insert_row(
1079: X_rowid => l_rowid ,
1080: X_adjustment_id => l_retirement_adjustment_id ,
1081: X_asset_id => P_Asset_Id,
1082: X_distribution_id => l_detail_balances.distribution_id ,

Line 1230: l_detail_balances igi_iac_det_balances%ROWTYPE;

1226:
1227: l_rowid ROWID;
1228: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1229: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1230: l_detail_balances igi_iac_det_balances%ROWTYPE;
1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

1227: l_rowid ROWID;
1228: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1229: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1230: l_detail_balances igi_iac_det_balances%ROWTYPE;
1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

1228: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1229: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1230: l_detail_balances igi_iac_det_balances%ROWTYPE;
1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

1229: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1230: l_detail_balances igi_iac_det_balances%ROWTYPE;
1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1237: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

1230: l_detail_balances igi_iac_det_balances%ROWTYPE;
1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1237: l_units_per_dist c_units_per_dist%ROWTYPE;
1238: l_cost_account_ccid NUMBER ;

Line 1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

1231: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1232: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1233: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1234: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1235: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1236: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1237: l_units_per_dist c_units_per_dist%ROWTYPE;
1238: l_cost_account_ccid NUMBER ;
1239: l_acc_deprn_account_ccid NUMBER ;

Line 1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

1252: l_asset_units_count NUMBER ;
1253: l_previous_per NUMBER ;
1254: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1255: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

1253: l_previous_per NUMBER ;
1254: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1255: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1256: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1257: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1258: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1259: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1260: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1261: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1500: igi_iac_det_balances_pkg.insert_row(

1496:
1497: l_rowid := NULL ;
1498:
1499:
1500: igi_iac_det_balances_pkg.insert_row(
1501: X_rowid => l_rowid ,
1502: X_adjustment_id => l_retirement_adjustment_id ,
1503: X_asset_id => P_Asset_Id ,
1504: X_distribution_id => l_detail_balances.distribution_id ,

Line 1576: igi_iac_det_balances_pkg.insert_row(

1572: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1573:
1574: debug( g_state_level,l_path_name,'Inactive distributions');
1575: l_rowid := NULL ;
1576: igi_iac_det_balances_pkg.insert_row(
1577: X_rowid => l_rowid ,
1578: X_adjustment_id => l_retirement_adjustment_id ,
1579: X_asset_id => P_Asset_Id,
1580: X_distribution_id => l_detail_balances.distribution_id ,

Line 1797: igi_iac_det_balances_pkg.insert_row(

1793:
1794: l_rowid := NULL ;
1795:
1796:
1797: igi_iac_det_balances_pkg.insert_row(
1798: X_rowid => l_rowid ,
1799: X_adjustment_id => l_retirement_adjustment_id ,
1800: X_asset_id => P_Asset_Id ,
1801: X_distribution_id => l_detail_balances.distribution_id ,

Line 1874: igi_iac_det_balances_pkg.insert_row(

1870: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1871:
1872: debug( g_state_level,l_path_name,'Inactive distributions');
1873: l_rowid := NULL ;
1874: igi_iac_det_balances_pkg.insert_row(
1875: X_rowid => l_rowid ,
1876: X_adjustment_id => l_retirement_adjustment_id ,
1877: X_asset_id => P_Asset_Id,
1878: X_distribution_id => l_detail_balances.distribution_id ,

Line 1951: l_detail_balances igi_iac_det_balances%ROWTYPE;

1947:
1948: l_rowid ROWID;
1949: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1950: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1951: l_detail_balances igi_iac_det_balances%ROWTYPE;
1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

1948: l_rowid ROWID;
1949: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1950: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1951: l_detail_balances igi_iac_det_balances%ROWTYPE;
1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

1949: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1950: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1951: l_detail_balances igi_iac_det_balances%ROWTYPE;
1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

1950: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1951: l_detail_balances igi_iac_det_balances%ROWTYPE;
1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1958: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

1951: l_detail_balances igi_iac_det_balances%ROWTYPE;
1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1958: l_units_per_dist c_units_per_dist%ROWTYPE;
1959: l_cost_account_ccid NUMBER ;

Line 1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

1952: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1953: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1954: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1955: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1956: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1957: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1958: l_units_per_dist c_units_per_dist%ROWTYPE;
1959: l_cost_account_ccid NUMBER ;
1960: l_acc_deprn_account_ccid NUMBER ;

Line 1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

1973: l_asset_units_count NUMBER ;
1974: l_previous_per NUMBER ;
1975: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1976: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

1974: l_previous_per NUMBER ;
1975: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1976: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1977: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1978: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1979: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1980: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1981: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1982: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2665: igi_iac_det_balances_pkg.insert_row(

2661: END IF;
2662:
2663: l_rowid := NULL ;
2664:
2665: igi_iac_det_balances_pkg.insert_row(
2666: X_rowid => l_rowid ,
2667: X_adjustment_id => l_retirement_adjustment_id ,
2668: X_asset_id => P_Asset_Id ,
2669: X_distribution_id => l_detail_balances.distribution_id ,

Line 2935: igi_iac_det_balances_pkg.insert_row(

2931:
2932:
2933:
2934: l_rowid := NULL ;
2935: igi_iac_det_balances_pkg.insert_row(
2936: X_rowid => l_rowid ,
2937: X_adjustment_id => l_retirement_adjustment_id ,
2938: X_asset_id => P_Asset_Id ,
2939: X_distribution_id => l_new_fa_dist.distribution_id,

Line 3032: igi_iac_det_balances_pkg.insert_row(

3028:
3029: l_asset_units_count := l_asset_units_count + l_units_per_dist.units_assigned ;
3030:
3031: l_rowid := NULL ;
3032: igi_iac_det_balances_pkg.insert_row(
3033: X_rowid => l_rowid ,
3034: X_adjustment_id => l_retirement_adjustment_id ,
3035: X_asset_id => P_Asset_Id,
3036: X_distribution_id => l_detail_balances.distribution_id ,

Line 3100: igi_iac_det_balances_pkg.insert_row(

3096: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
3097: END IF;
3098:
3099: l_rowid:=NULL ;
3100: igi_iac_det_balances_pkg.insert_row(
3101: X_rowid => l_rowid ,
3102: X_adjustment_id => l_retirement_adjustment_id ,
3103: X_asset_id => P_Asset_Id,
3104: X_distribution_id => l_detail_balances.distribution_id ,

Line 3245: l_detail_balances igi_iac_det_balances%ROWTYPE;

3241: RETURN BOOLEAN IS
3242: l_rowid ROWID;
3243: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3244: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3245: l_detail_balances igi_iac_det_balances%ROWTYPE;
3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

3242: l_rowid ROWID;
3243: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3244: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3245: l_detail_balances igi_iac_det_balances%ROWTYPE;
3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

3243: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3244: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3245: l_detail_balances igi_iac_det_balances%ROWTYPE;
3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

3244: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3245: l_detail_balances igi_iac_det_balances%ROWTYPE;
3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3252: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

3245: l_detail_balances igi_iac_det_balances%ROWTYPE;
3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3252: l_units_per_dist c_units_per_dist%ROWTYPE;
3253: l_cost_account_ccid NUMBER ;

Line 3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

3246: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3247: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3248: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3249: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3250: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3251: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3252: l_units_per_dist c_units_per_dist%ROWTYPE;
3253: l_cost_account_ccid NUMBER ;
3254: l_acc_deprn_account_ccid NUMBER ;

Line 3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

3267: l_asset_units_count NUMBER ;
3268: l_previous_per NUMBER ;
3269: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3270: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

3268: l_previous_per NUMBER ;
3269: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3270: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3271: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3272: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3273: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3274: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3275: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3276: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3574: igi_iac_det_balances_pkg.insert_row(

3570:
3571: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
3572:
3573: l_rowid := NULL ;
3574: igi_iac_det_balances_pkg.insert_row(
3575: X_rowid => l_rowid ,
3576: X_adjustment_id => l_retirement_adjustment_id ,
3577: X_asset_id => P_Asset_Id ,
3578: X_distribution_id => l_detail_balances.distribution_id,

Line 3646: igi_iac_det_balances_pkg.insert_row(

3642:
3643: ELSE -- not impacted by retiretment -- active distribution
3644:
3645: l_rowid := NULL ;
3646: igi_iac_det_balances_pkg.insert_row(
3647: X_rowid => l_rowid ,
3648: X_adjustment_id => l_retirement_adjustment_id ,
3649: X_asset_id => P_Asset_Id ,
3650: X_distribution_id => l_detail_balances.distribution_id ,

Line 3699: igi_iac_det_balances_pkg.insert_row(

3695: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
3696:
3697: debug( g_state_level,l_path_name,'Inactive distributions');
3698: l_rowid := NULL ;
3699: igi_iac_det_balances_pkg.insert_row(
3700: X_rowid => l_rowid ,
3701: X_adjustment_id => l_retirement_adjustment_id ,
3702: X_asset_id => P_Asset_Id,
3703: X_distribution_id => l_detail_balances.distribution_id ,

Line 3967: igi_iac_det_balances_pkg.insert_row(

3963:
3964: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
3965:
3966: l_rowid := NULL ;
3967: igi_iac_det_balances_pkg.insert_row(
3968: X_rowid => l_rowid ,
3969: X_adjustment_id => l_retirement_adjustment_id ,
3970: X_asset_id => P_Asset_Id ,
3971: X_distribution_id => l_detail_balances.distribution_id,

Line 4040: igi_iac_det_balances_pkg.insert_row(

4036: x_mode => 'R');
4037: ELSE -- not impacted by retiretment -- active distribution
4038:
4039: l_rowid := NULL ;
4040: igi_iac_det_balances_pkg.insert_row(
4041: X_rowid => l_rowid ,
4042: X_adjustment_id => l_retirement_adjustment_id ,
4043: X_asset_id => P_Asset_Id ,
4044: X_distribution_id => l_detail_balances.distribution_id ,

Line 4093: igi_iac_det_balances_pkg.insert_row(

4089: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
4090:
4091: debug( g_state_level,l_path_name,'Inactive distributions');
4092: l_rowid := NULL ;
4093: igi_iac_det_balances_pkg.insert_row(
4094: X_rowid => l_rowid ,
4095: X_adjustment_id => l_retirement_adjustment_id ,
4096: X_asset_id => P_Asset_Id,
4097: X_distribution_id => l_detail_balances.distribution_id ,