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_ASSET_BALANCES

Line 69: FROM igi_iac_asset_balances

65: g_units_per_dist c_units_per_dist%ROWTYPE ;
66:
67: CURSOR c_asset_balances (p_c_asset_id NUMBER, p_c_book_type_code VARCHAR2, p_period_counter NUMBER) IS
68: SELECT *
69: FROM igi_iac_asset_balances
70: WHERE asset_id = p_c_asset_id
71: AND book_type_code = p_c_book_type_code
72: AND period_counter = p_period_counter ;
73:

Line 74: g_asset_balances_rec igi_iac_asset_balances%ROWTYPE ;

70: WHERE asset_id = p_c_asset_id
71: AND book_type_code = p_c_book_type_code
72: AND period_counter = p_period_counter ;
73:
74: g_asset_balances_rec igi_iac_asset_balances%ROWTYPE ;
75: CURSOR c_new_distribution (p_c_retirement_id NUMBER, p_old_distribution NUMBER ) IS
76: SELECT new.distribution_id
77: FROM fa_distribution_history NEW, fa_distribution_history old
78: WHERE old.retirement_id = p_c_retirement_id

Line 297: l_asset_balances igi_iac_asset_balances%ROWTYPE;

293: P_Event_Id IN NUMBER) --R12 uptake
294: RETURN BOOLEAN IS
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;

Line 298: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;

294: RETURN BOOLEAN IS
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;

Line 1226: FROM igi_iac_asset_balances

1222:
1223: -- Begin Fix for Bug 5049536
1224: SELECT max(period_counter)
1225: INTO l_max_period_counter
1226: FROM igi_iac_asset_balances
1227: WHERE asset_id = P_Asset_Id
1228: AND book_type_code = P_Book_Type_Code;
1229:
1230: OPEN c_asset_balances(P_Asset_Id, P_Book_Type_Code, l_max_period_counter) ;

Line 1238: igi_iac_asset_balances_pkg.insert_row(

1234: --End Fix for Bug 5049536
1235:
1236: END IF ;
1237:
1238: igi_iac_asset_balances_pkg.insert_row(
1239: X_rowid => l_rowid ,
1240: X_asset_id => p_asset_id,
1241: X_book_type_code => p_book_type_code ,
1242: X_period_counter => g_prd_rec.period_counter ,

Line 1259: igi_iac_asset_balances_pkg.update_row(

1255:
1256:
1257:
1258: ELSE
1259: igi_iac_asset_balances_pkg.update_row(
1260: X_asset_id => p_asset_id,
1261: X_book_type_code => p_book_type_code ,
1262: X_period_counter => g_prd_rec.period_counter ,
1263: X_net_book_value => l_asset_balances.net_book_value ,

Line 1301: l_asset_balances igi_iac_asset_balances%ROWTYPE;

1297:
1298: RETURN BOOLEAN IS
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;

Line 1302: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;

1298: RETURN BOOLEAN IS
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;

Line 2024: l_asset_balances igi_iac_asset_balances%ROWTYPE;

2020: RETURN BOOLEAN IS
2021:
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;

Line 2025: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;

2021:
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;

Line 3297: FROM igi_iac_asset_balances

3293:
3294: --Begin Fix for Bug 5049536
3295: SELECT max(period_counter)
3296: INTO l_max_period_counter
3297: FROM igi_iac_asset_balances
3298: WHERE asset_id = P_Asset_Id
3299: AND book_type_code = P_Book_Type_Code;
3300:
3301: OPEN c_asset_balances(P_Asset_Id, P_Book_Type_Code, l_max_period_counter) ;

Line 3307: igi_iac_asset_balances_pkg.insert_row(

3303: --RAISE e_no_asset_bals ;
3304: --End fix for Bug 5049536
3305: END IF ;
3306:
3307: igi_iac_asset_balances_pkg.insert_row(
3308: X_rowid => l_rowid ,
3309: X_asset_id => p_asset_id,
3310: X_book_type_code => p_book_type_code ,
3311: X_period_counter => g_prd_rec.period_counter ,

Line 3328: igi_iac_asset_balances_pkg.update_row(

3324:
3325:
3326:
3327: ELSE
3328: igi_iac_asset_balances_pkg.update_row(
3329: X_asset_id => p_asset_id,
3330: X_book_type_code => p_book_type_code ,
3331: X_period_counter => g_prd_rec.period_counter ,
3332: X_net_book_value => l_asset_balances.net_book_value ,

Line 3368: l_asset_balances igi_iac_asset_balances%ROWTYPE;

3364: P_Current_period IN NUMBER,
3365: P_Event_Id IN NUMBER ) --R12 uptake
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;

Line 3369: l_asset_balances_rec igi_iac_asset_balances%ROWTYPE;

3365: P_Event_Id IN NUMBER ) --R12 uptake
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;