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 299: l_detail_balances igi_iac_det_balances%ROWTYPE;

295:
296: l_rowid ROWID;
297: l_asset_balances igi_iac_asset_balances%ROWTYPE;
298: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
299: l_detail_balances igi_iac_det_balances%ROWTYPE;
300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

296: l_rowid ROWID;
297: l_asset_balances igi_iac_asset_balances%ROWTYPE;
298: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
299: l_detail_balances igi_iac_det_balances%ROWTYPE;
300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

297: l_asset_balances igi_iac_asset_balances%ROWTYPE;
298: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
299: l_detail_balances igi_iac_det_balances%ROWTYPE;
300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

298: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
299: l_detail_balances igi_iac_det_balances%ROWTYPE;
300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
306: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

299: l_detail_balances igi_iac_det_balances%ROWTYPE;
300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
306: l_units_per_dist c_units_per_dist%ROWTYPE;
307: l_cost_account_ccid NUMBER ;

Line 304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

300: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
301: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
302: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
303: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
304: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
305: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
306: l_units_per_dist c_units_per_dist%ROWTYPE;
307: l_cost_account_ccid NUMBER ;
308: l_acc_deprn_account_ccid NUMBER ;

Line 325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

321: l_asset_units_count NUMBER ;
322: l_previous_per NUMBER ;
323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

322: l_previous_per NUMBER ;
323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
329: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
330: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1044: igi_iac_det_balances_pkg.insert_row(

1040:
1041: debug( g_state_level,l_path_name,'start insert det bal');
1042: l_rowid := NULL ;
1043:
1044: igi_iac_det_balances_pkg.insert_row(
1045: X_rowid => l_rowid ,
1046: X_adjustment_id => l_retirement_adjustment_id ,
1047: X_asset_id => P_Asset_Id ,
1048: X_distribution_id => l_detail_balances.distribution_id ,

Line 1151: igi_iac_det_balances_pkg.insert_row(

1147: l_ret:= igi_iac_common_utils.iac_round(l_detail_balances.deprn_ytd,P_Book_Type_Code);
1148: l_ret:= igi_iac_common_utils.iac_round(l_fa_deprn_ytd,P_Book_Type_Code);
1149: END IF;
1150:
1151: igi_iac_det_balances_pkg.insert_row(
1152: X_rowid => l_rowid ,
1153: X_adjustment_id => l_retirement_adjustment_id ,
1154: X_asset_id => P_Asset_Id,
1155: X_distribution_id => l_detail_balances.distribution_id ,

Line 1303: l_detail_balances igi_iac_det_balances%ROWTYPE;

1299:
1300: l_rowid ROWID;
1301: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1302: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1303: l_detail_balances igi_iac_det_balances%ROWTYPE;
1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

1300: l_rowid ROWID;
1301: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1302: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1303: l_detail_balances igi_iac_det_balances%ROWTYPE;
1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

1301: l_asset_balances igi_iac_asset_balances%ROWTYPE;
1302: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1303: l_detail_balances igi_iac_det_balances%ROWTYPE;
1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

1302: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
1303: l_detail_balances igi_iac_det_balances%ROWTYPE;
1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1310: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

1303: l_detail_balances igi_iac_det_balances%ROWTYPE;
1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1310: l_units_per_dist c_units_per_dist%ROWTYPE;
1311: l_cost_account_ccid NUMBER ;

Line 1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

1304: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
1305: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
1306: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
1307: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
1308: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
1309: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
1310: l_units_per_dist c_units_per_dist%ROWTYPE;
1311: l_cost_account_ccid NUMBER ;
1312: l_acc_deprn_account_ccid NUMBER ;

Line 1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

1325: l_asset_units_count NUMBER ;
1326: l_previous_per NUMBER ;
1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

1326: l_previous_per NUMBER ;
1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1333: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1334: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 1574: igi_iac_det_balances_pkg.insert_row(

1570:
1571: l_rowid := NULL ;
1572:
1573:
1574: igi_iac_det_balances_pkg.insert_row(
1575: X_rowid => l_rowid ,
1576: X_adjustment_id => l_retirement_adjustment_id ,
1577: X_asset_id => P_Asset_Id ,
1578: X_distribution_id => l_detail_balances.distribution_id ,

Line 1650: igi_iac_det_balances_pkg.insert_row(

1646: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1647:
1648: debug( g_state_level,l_path_name,'Inactive distributions');
1649: l_rowid := NULL ;
1650: igi_iac_det_balances_pkg.insert_row(
1651: X_rowid => l_rowid ,
1652: X_adjustment_id => l_retirement_adjustment_id ,
1653: X_asset_id => P_Asset_Id,
1654: X_distribution_id => l_detail_balances.distribution_id ,

Line 1872: igi_iac_det_balances_pkg.insert_row(

1868:
1869: l_rowid := NULL ;
1870:
1871:
1872: igi_iac_det_balances_pkg.insert_row(
1873: X_rowid => l_rowid ,
1874: X_adjustment_id => l_retirement_adjustment_id ,
1875: X_asset_id => P_Asset_Id ,
1876: X_distribution_id => l_detail_balances.distribution_id ,

Line 1949: igi_iac_det_balances_pkg.insert_row(

1945: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
1946:
1947: debug( g_state_level,l_path_name,'Inactive distributions');
1948: l_rowid := NULL ;
1949: igi_iac_det_balances_pkg.insert_row(
1950: X_rowid => l_rowid ,
1951: X_adjustment_id => l_retirement_adjustment_id ,
1952: X_asset_id => P_Asset_Id,
1953: X_distribution_id => l_detail_balances.distribution_id ,

Line 2026: l_detail_balances igi_iac_det_balances%ROWTYPE;

2022:
2023: l_rowid ROWID;
2024: l_asset_balances igi_iac_asset_balances%ROWTYPE;
2025: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
2026: l_detail_balances igi_iac_det_balances%ROWTYPE;
2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

2023: l_rowid ROWID;
2024: l_asset_balances igi_iac_asset_balances%ROWTYPE;
2025: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
2026: l_detail_balances igi_iac_det_balances%ROWTYPE;
2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

2024: l_asset_balances igi_iac_asset_balances%ROWTYPE;
2025: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
2026: l_detail_balances igi_iac_det_balances%ROWTYPE;
2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

2025: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
2026: l_detail_balances igi_iac_det_balances%ROWTYPE;
2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
2033: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

2026: l_detail_balances igi_iac_det_balances%ROWTYPE;
2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
2033: l_units_per_dist c_units_per_dist%ROWTYPE;
2034: l_cost_account_ccid NUMBER ;

Line 2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

2027: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
2028: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
2029: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
2030: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
2031: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
2032: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
2033: l_units_per_dist c_units_per_dist%ROWTYPE;
2034: l_cost_account_ccid NUMBER ;
2035: l_acc_deprn_account_ccid NUMBER ;

Line 2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

2048: l_asset_units_count NUMBER ;
2049: l_previous_per NUMBER ;
2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

2049: l_previous_per NUMBER ;
2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2056: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2057: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 2790: igi_iac_det_balances_pkg.insert_row(

2786: END IF;
2787:
2788: l_rowid := NULL ;
2789:
2790: igi_iac_det_balances_pkg.insert_row(
2791: X_rowid => l_rowid ,
2792: X_adjustment_id => l_retirement_adjustment_id ,
2793: X_asset_id => P_Asset_Id ,
2794: X_distribution_id => l_detail_balances.distribution_id ,

Line 3060: igi_iac_det_balances_pkg.insert_row(

3056:
3057:
3058:
3059: l_rowid := NULL ;
3060: igi_iac_det_balances_pkg.insert_row(
3061: X_rowid => l_rowid ,
3062: X_adjustment_id => l_retirement_adjustment_id ,
3063: X_asset_id => P_Asset_Id ,
3064: X_distribution_id => l_new_fa_dist.distribution_id,

Line 3157: igi_iac_det_balances_pkg.insert_row(

3153:
3154: l_asset_units_count := l_asset_units_count + l_units_per_dist.units_assigned ;
3155:
3156: l_rowid := NULL ;
3157: igi_iac_det_balances_pkg.insert_row(
3158: X_rowid => l_rowid ,
3159: X_adjustment_id => l_retirement_adjustment_id ,
3160: X_asset_id => P_Asset_Id,
3161: X_distribution_id => l_detail_balances.distribution_id ,

Line 3225: igi_iac_det_balances_pkg.insert_row(

3221: l_fa_deprn_ytd := l_fa_deprn.deprn_ytd;
3222: END IF;
3223:
3224: l_rowid:=NULL ;
3225: igi_iac_det_balances_pkg.insert_row(
3226: X_rowid => l_rowid ,
3227: X_adjustment_id => l_retirement_adjustment_id ,
3228: X_asset_id => P_Asset_Id,
3229: X_distribution_id => l_detail_balances.distribution_id ,

Line 3370: l_detail_balances igi_iac_det_balances%ROWTYPE;

3366: RETURN BOOLEAN IS
3367: l_rowid ROWID;
3368: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3369: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3370: l_detail_balances igi_iac_det_balances%ROWTYPE;
3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

Line 3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;

3367: l_rowid ROWID;
3368: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3369: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3370: l_detail_balances igi_iac_det_balances%ROWTYPE;
3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

Line 3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;

3368: l_asset_balances igi_iac_asset_balances%ROWTYPE;
3369: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3370: l_detail_balances igi_iac_det_balances%ROWTYPE;
3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;

Line 3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;

3369: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;
3370: l_detail_balances igi_iac_det_balances%ROWTYPE;
3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3377: l_units_per_dist c_units_per_dist%ROWTYPE;

Line 3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;

3370: l_detail_balances igi_iac_det_balances%ROWTYPE;
3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3377: l_units_per_dist c_units_per_dist%ROWTYPE;
3378: l_cost_account_ccid NUMBER ;

Line 3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;

3371: l_detail_balances_new igi_iac_det_balances%ROWTYPE;
3372: l_detail_balances_total_old igi_iac_det_balances%ROWTYPE;
3373: l_detail_balances_retire igi_iac_det_balances%ROWTYPE;
3374: l_detail_balances_retire_unrnd igi_iac_det_balances%ROWTYPE;
3375: l_detail_balances_rnd_tot igi_iac_det_balances%ROWTYPE;
3376: l_fa_deprn igi_iac_fa_deprn%ROWTYPE;
3377: l_units_per_dist c_units_per_dist%ROWTYPE;
3378: l_cost_account_ccid NUMBER ;
3379: l_acc_deprn_account_ccid NUMBER ;

Line 3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;

3392: l_asset_units_count NUMBER ;
3393: l_previous_per NUMBER ;
3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;

3393: l_previous_per NUMBER ;
3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3400: l_fa_unround_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3401: l_fa_total_old_acc_deprn igi_iac_fa_deprn.deprn_reserve%TYPE;

Line 3700: igi_iac_det_balances_pkg.insert_row(

3696:
3697: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
3698:
3699: l_rowid := NULL ;
3700: igi_iac_det_balances_pkg.insert_row(
3701: X_rowid => l_rowid ,
3702: X_adjustment_id => l_retirement_adjustment_id ,
3703: X_asset_id => P_Asset_Id ,
3704: X_distribution_id => l_detail_balances.distribution_id,

Line 3772: igi_iac_det_balances_pkg.insert_row(

3768:
3769: ELSE -- not impacted by retiretment -- active distribution
3770:
3771: l_rowid := NULL ;
3772: igi_iac_det_balances_pkg.insert_row(
3773: X_rowid => l_rowid ,
3774: X_adjustment_id => l_retirement_adjustment_id ,
3775: X_asset_id => P_Asset_Id ,
3776: X_distribution_id => l_detail_balances.distribution_id ,

Line 3825: igi_iac_det_balances_pkg.insert_row(

3821: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
3822:
3823: debug( g_state_level,l_path_name,'Inactive distributions');
3824: l_rowid := NULL ;
3825: igi_iac_det_balances_pkg.insert_row(
3826: X_rowid => l_rowid ,
3827: X_adjustment_id => l_retirement_adjustment_id ,
3828: X_asset_id => P_Asset_Id,
3829: X_distribution_id => l_detail_balances.distribution_id ,

Line 4094: igi_iac_det_balances_pkg.insert_row(

4090:
4091: l_detail_balances.net_book_value := l_detail_balances.adjustment_cost - l_detail_balances.deprn_reserve -l_detail_balances.deprn_reserve_backlog ;
4092:
4093: l_rowid := NULL ;
4094: igi_iac_det_balances_pkg.insert_row(
4095: X_rowid => l_rowid ,
4096: X_adjustment_id => l_retirement_adjustment_id ,
4097: X_asset_id => P_Asset_Id ,
4098: X_distribution_id => l_detail_balances.distribution_id,

Line 4167: igi_iac_det_balances_pkg.insert_row(

4163: x_mode => 'R');
4164: ELSE -- not impacted by retiretment -- active distribution
4165:
4166: l_rowid := NULL ;
4167: igi_iac_det_balances_pkg.insert_row(
4168: X_rowid => l_rowid ,
4169: X_adjustment_id => l_retirement_adjustment_id ,
4170: X_asset_id => P_Asset_Id ,
4171: X_distribution_id => l_detail_balances.distribution_id ,

Line 4220: igi_iac_det_balances_pkg.insert_row(

4216: ELSE -- Inactive distributions IF active_flag is not NULL. i.e. following code for active_flag = 'N'
4217:
4218: debug( g_state_level,l_path_name,'Inactive distributions');
4219: l_rowid := NULL ;
4220: igi_iac_det_balances_pkg.insert_row(
4221: X_rowid => l_rowid ,
4222: X_adjustment_id => l_retirement_adjustment_id ,
4223: X_asset_id => P_Asset_Id,
4224: X_distribution_id => l_detail_balances.distribution_id ,