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

Line 1184: FROM igi_iac_adjustments

1180: adjustment_type,
1181: asset_id,
1182: distribution_id,
1183: period_counter
1184: FROM igi_iac_adjustments
1185: WHERE book_type_code = p_book_type_code
1186: AND period_counter = p_period_counter
1187: AND adjustment_type IN ('COST','RESERVE','EXPENSE')
1188: AND adjustment_id = c_adjustment_id for update;

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

1242: l_path VARCHAR2(100);
1243:
1244: -- bulk fecthes
1245: TYPE rowed_type_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1246: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1247: INDEX BY BINARY_INTEGER;
1248: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1249: INDEX BY BINARY_INTEGER;
1250: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE

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

1244: -- bulk fecthes
1245: TYPE rowed_type_tbl_type IS TABLE OF ROWID INDEX BY BINARY_INTEGER;
1246: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1247: INDEX BY BINARY_INTEGER;
1248: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1249: INDEX BY BINARY_INTEGER;
1250: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1251: INDEX BY BINARY_INTEGER;
1252: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE

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

1246: TYPE adj_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_ID%TYPE
1247: INDEX BY BINARY_INTEGER;
1248: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1249: INDEX BY BINARY_INTEGER;
1250: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1251: INDEX BY BINARY_INTEGER;
1252: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1253: INDEX BY BINARY_INTEGER;
1254: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE

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

1248: TYPE book_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.BOOK_TYPE_CODE%TYPE
1249: INDEX BY BINARY_INTEGER;
1250: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1251: INDEX BY BINARY_INTEGER;
1252: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1253: INDEX BY BINARY_INTEGER;
1254: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1255: INDEX BY BINARY_INTEGER;
1256: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE

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

1250: TYPE code_comb_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.CODE_COMBINATION_ID%TYPE
1251: INDEX BY BINARY_INTEGER;
1252: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1253: INDEX BY BINARY_INTEGER;
1254: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1255: INDEX BY BINARY_INTEGER;
1256: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1257: INDEX BY BINARY_INTEGER;
1258: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE

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

1252: TYPE adjustment_type_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS. ADJUSTMENT_TYPE%TYPE
1253: INDEX BY BINARY_INTEGER;
1254: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1255: INDEX BY BINARY_INTEGER;
1256: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1257: INDEX BY BINARY_INTEGER;
1258: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE
1259: INDEX BY BINARY_INTEGER;
1260:

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

1254: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.ASSET_ID%TYPE
1255: INDEX BY BINARY_INTEGER;
1256: TYPE dist_id_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.DISTRIBUTION_ID%TYPE
1257: INDEX BY BINARY_INTEGER;
1258: TYPE period_counter_tbl_type IS TABLE OF IGI_IAC_ADJUSTMENTS.PERIOD_COUNTER%TYPE
1259: INDEX BY BINARY_INTEGER;
1260:
1261: l_row_id rowed_type_tbl_type;
1262: l_adj_id adj_id_tbl_type;

Line 1423: UPDATE igi_iac_adjustments

1419:
1420:
1421: IF l_account_ccid <> (l_code_comb_id(l_loop_count)) THEN
1422: -- Update the ccid for the adjustment
1423: UPDATE igi_iac_adjustments
1424: SET code_combination_id= l_account_ccid
1425: WHERE rowid=l_rowid;
1426:
1427: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,' Updated the adjusment with correct ccid' );