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_ADJ_AMORT_PKG dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 260: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;

256:
257: -- local variables
258: l_asset_id fa_books.asset_id%TYPE;
259: l_book_type_code fa_books.book_type_code%TYPE;
260: l_last_period_counter igi_iac_transaction_headers.period_counter%TYPE;
261: l_sob_id NUMBER;
262: l_coa_id NUMBER;
263: l_currency VARCHAR2(15);
264: l_precision NUMBER;

Line 266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

262: l_coa_id NUMBER;
263: l_currency VARCHAR2(15);
264: l_precision NUMBER;
265:
266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;

263: l_currency VARCHAR2(15);
264: l_precision NUMBER;
265:
266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

Line 268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;

264: l_precision NUMBER;
265:
266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

Line 269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

265:
266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:

Line 270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

266: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;

Line 271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

267: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;

Line 272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;

268: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
269: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
270: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
271: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
272: l_adj_id_out igi_iac_transaction_headers.adjustment_id_out%TYPE;
273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
276:

Line 277: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

273:
274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
276:
277: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
279: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
280:
281: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;

Line 278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;

274: l_fully_rsvd_pc fa_books.period_counter_fully_reserved%TYPE;
275: -- l_deprn_flag fa_books.depreciate_flag%TYPE;
276:
277: l_new_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
278: l_rsvd_pc igi_iac_transaction_headers.period_counter%TYPE;
279: l_iac_asset_bal c_iac_asset_bal%ROWTYPE;
280:
281: l_fa_deprn_adj_amount fa_deprn_detail.deprn_adjustment_amount%TYPE;
282: l_iac_new_deprn_adj_amt igi_iac_asset_balances.deprn_amount%TYPE;

Line 460: FROM igi_iac_transaction_headers

456: -- get the period counter associated with the latest adjustment
457: -- for the asset
458: SELECT period_counter
459: INTO l_rsvd_pc
460: FROM igi_iac_transaction_headers
461: WHERE adjustment_id = l_latest_adj_id;
462:
463: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
464: p_full_path => l_path_name,

Line 566: -- create a new row in igi_iac_transaction_headers with transaction type code

562: IF (l_fa_deprn_adj_amount = 0) THEN
563: RAISE e_curr_period_amort;
564: END IF;
565:
566: -- create a new row in igi_iac_transaction_headers with transaction type code
567: -- ADJUSTMENT and transaction sub type as COST
568: l_new_adj_id := null;
569:
570: IGI_IAC_TRANS_HEADERS_PKG.Insert_Row(

Line 593: -- update the previous active row for the asset in igi_iac_transaction_headers

589: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
590: p_full_path => l_path_name,
591: p_string => 'New adjustment id: '||l_new_adj_id);
592:
593: -- update the previous active row for the asset in igi_iac_transaction_headers
594: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
595: -- the active row in igi_iac_transaction_headers
596: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
597: x_prev_adjustment_id => l_adj_id_out,

Line 595: -- the active row in igi_iac_transaction_headers

591: p_string => 'New adjustment id: '||l_new_adj_id);
592:
593: -- update the previous active row for the asset in igi_iac_transaction_headers
594: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
595: -- the active row in igi_iac_transaction_headers
596: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
597: x_prev_adjustment_id => l_adj_id_out,
598: x_adjustment_id => l_new_adj_id
599: );