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_DEPRN_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

327: l_asset_balance igi_iac_asset_balances%ROWTYPE;
328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%TYPE;
335: l_asset_units fa_additions.current_units%TYPE;

Line 332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

328: l_asset_balance_next igi_iac_asset_balances%ROWTYPE;
329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%TYPE;
335: l_asset_units fa_additions.current_units%TYPE;
336: l_distribution_units fa_distribution_history.units_assigned%TYPE;

Line 333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;

329: l_asset_balance_curr igi_iac_asset_balances%ROWTYPE;
330: l_detail_balance igi_iac_det_balances%ROWTYPE;
331: l_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
332: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
333: l_prev_adjustment_id igi_iac_adjustments.adjustment_id%TYPE;
334: l_category_id fa_additions.asset_category_id%TYPE;
335: l_asset_units fa_additions.current_units%TYPE;
336: l_distribution_units fa_distribution_history.units_assigned%TYPE;
337: l_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE ;

Line 669: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Creating accounting entries in igi_iac_adjustments');

665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Prorated amount for the distribution :'||to_char(l_amount));
666:
667: IF (nvl(l_amount,0) <> 0) THEN
668: /* Create accounting entries for non zero values */
669: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Creating accounting entries in igi_iac_adjustments');
670: l_rowid := NULL;
671: l_account_ccid := NULL ;
672:
673: IF NOT (igi_iac_common_utils.get_account_ccid(p_book_type_code ,

Line 682: igi_iac_adjustments_pkg.insert_row(

678:
679: RETURN false;
680: END IF;
681: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Expense ccid :'||to_char(l_account_ccid));
682: igi_iac_adjustments_pkg.insert_row(
683: X_rowid => l_rowid ,
684: X_adjustment_id => l_adjustment_id ,
685: X_book_type_code => p_book_type_code ,
686: X_code_combination_id => l_account_ccid,

Line 713: igi_iac_adjustments_pkg.insert_row(

709:
710: RETURN false;
711: END IF;
712: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Deprn Reserve ccid :'||to_char(l_account_ccid));
713: igi_iac_adjustments_pkg.insert_row(
714: X_rowid => l_rowid ,
715: X_adjustment_id => l_adjustment_id ,
716: X_book_type_code => p_book_type_code ,
717: X_code_combination_id => l_account_ccid,

Line 748: igi_iac_adjustments_pkg.insert_row(

744: END IF;
745: l_reval_reserve_ccid := l_account_ccid;
746:
747: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Reval reserve ccid :'||to_char(l_account_ccid));
748: igi_iac_adjustments_pkg.insert_row(
749: X_rowid => l_rowid ,
750: X_adjustment_id => l_adjustment_id ,
751: X_book_type_code => p_book_type_code ,
752: X_code_combination_id => l_account_ccid,

Line 779: igi_iac_adjustments_pkg.insert_row(

775:
776: RETURN false;
777: END IF;
778: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' General Fund ccid :'||to_char(l_account_ccid));
779: igi_iac_adjustments_pkg.insert_row(
780: X_rowid => l_rowid ,
781: X_adjustment_id => l_adjustment_id ,
782: X_book_type_code => p_book_type_code ,
783: X_code_combination_id => l_account_ccid,

Line 1125: FROM igi_iac_adjustments

1121: adjustment_type,
1122: asset_id,
1123: distribution_id,
1124: period_counter
1125: FROM igi_iac_adjustments
1126: WHERE book_type_code = p_book_type_code
1127: AND period_counter = p_period_counter
1128: AND adjustment_type IN ('COST','RESERVE','EXPENSE')
1129: AND adjustment_id = c_adjustment_id for update;

Line 1211: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE

1207: l_acct_ccid NUMBER;
1208:
1209: -- bulk fecthes
1210: TYPE rowed_type_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1211: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1212: INDEX BY BINARY_INTEGER;
1213: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1214: INDEX BY BINARY_INTEGER;
1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE

Line 1213: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE

1209: -- bulk fecthes
1210: TYPE rowed_type_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1211: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1212: INDEX BY BINARY_INTEGER;
1213: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1214: INDEX BY BINARY_INTEGER;
1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1216: INDEX BY BINARY_INTEGER;
1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE

Line 1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE

1211: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1212: INDEX BY BINARY_INTEGER;
1213: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1214: INDEX BY BINARY_INTEGER;
1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1216: INDEX BY BINARY_INTEGER;
1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1218: INDEX BY BINARY_INTEGER;
1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE

Line 1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE

1213: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1214: INDEX BY BINARY_INTEGER;
1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1216: INDEX BY BINARY_INTEGER;
1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1218: INDEX BY BINARY_INTEGER;
1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1220: INDEX BY BINARY_INTEGER;
1221: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE

Line 1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE

1215: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1216: INDEX BY BINARY_INTEGER;
1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1218: INDEX BY BINARY_INTEGER;
1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1220: INDEX BY BINARY_INTEGER;
1221: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1222: INDEX BY BINARY_INTEGER;
1223: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE

Line 1221: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE

1217: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1218: INDEX BY BINARY_INTEGER;
1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1220: INDEX BY BINARY_INTEGER;
1221: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1222: INDEX BY BINARY_INTEGER;
1223: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE
1224: INDEX BY BINARY_INTEGER;
1225:

Line 1223: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE

1219: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1220: INDEX BY BINARY_INTEGER;
1221: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1222: INDEX BY BINARY_INTEGER;
1223: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE
1224: INDEX BY BINARY_INTEGER;
1225:
1226: l_row_id rowed_type_tbl_type;
1227: l_adj_id adj_id_tbl_type;

Line 1428: UPDATE igi_iac_adjustments

1424: return FALSE;
1425: END IF;
1426: IF l_account_ccid <> (l_code_comb_id(l_loop_count)) THEN
1427: -- Update the ccid for the adjustment
1428: UPDATE igi_iac_adjustments
1429: SET code_combination_id= l_account_ccid
1430: WHERE rowid=l_rowid;
1431:
1432: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updated the adjusment with correct ccid' );