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

Line 306: | Procedure To Insert Data into IGI_IAC_TRANSACTION_HEADERS |

302: END; -- do validate asset
303:
304: /*
305: +===============================================================================+
306: | Procedure To Insert Data into IGI_IAC_TRANSACTION_HEADERS |
307: ================================================================================+
308: */
309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,

Line 309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,

305: +===============================================================================+
306: | Procedure To Insert Data into IGI_IAC_TRANSACTION_HEADERS |
307: ================================================================================+
308: */
309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,

Line 310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,

306: | Procedure To Insert Data into IGI_IAC_TRANSACTION_HEADERS |
307: ================================================================================+
308: */
309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,

Line 311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,

307: ================================================================================+
308: */
309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,

Line 312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,

308: */
309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,

Line 313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,

309: PROCEDURE Insert_data_trans_hdr(p_adjustment_id in out NOCOPY IGI_IAC_TRANSACTION_HEADERS.adjustment_id%type,
310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,

Line 314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,

310: p_transaction_header_id in IGI_IAC_TRANSACTION_HEADERS.transaction_header_id%type,
311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,

Line 315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,

311: p_adjustment_id_out in IGI_IAC_TRANSACTION_HEADERS.adjustment_id_out%type,
312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,

Line 316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,

312: p_transaction_type_code in IGI_IAC_TRANSACTION_HEADERS.transaction_type_code%type,
313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,
320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,

Line 317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,

313: p_transaction_date_entered in IGI_IAC_TRANSACTION_HEADERS.transaction_date_entered%type,
314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,
320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,
321: p_event_id in number

Line 318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,

314: p_mass_reference_id in IGI_IAC_TRANSACTION_HEADERS.mass_reference_id%type,
315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,
320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,
321: p_event_id in number
322: ) IS

Line 319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,

315: p_book_type_code in IGI_IAC_TRANSACTION_HEADERS.book_type_code%type,
316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,
320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,
321: p_event_id in number
322: ) IS
323:

Line 320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,

316: p_asset_id in IGI_IAC_TRANSACTION_HEADERS.asset_id%type,
317: p_revaluation_flag in IGI_IAC_TRANSACTION_HEADERS.revaluation_type_flag%type,
318: p_adjustment_status in IGI_IAC_TRANSACTION_HEADERS.adjustment_status%type,
319: p_category_id in IGI_IAC_TRANSACTION_HEADERS.category_id%type,
320: p_period_counter in IGI_IAC_TRANSACTION_HEADERS.period_counter%type,
321: p_event_id in number
322: ) IS
323:
324:

Line 335: /* Call the TBH for inserting data into IGI_IAC_TRANSACTION_HEADERS */

331: BEGIN
332: l_path_name := g_path||'insert_data_trans_hdr';
333:
334:
335: /* Call the TBH for inserting data into IGI_IAC_TRANSACTION_HEADERS */
336:
337: IGI_IAC_TRANS_HEADERS_PKG.insert_row(
338: x_rowid =>l_rowid,
339: x_adjustment_id =>p_adjustment_id ,

Line 1423: FROM igi_iac_transaction_headers a

1419: /* Cursor to select adjustment_id or the previous transaction */
1420:
1421: CURSOR c_prev_data IS
1422: SELECT a.rowid,a.adjustment_id
1423: FROM igi_iac_transaction_headers a
1424: WHERE a.adjustment_id_out IS NULL
1425: AND a.asset_id = l_asset_hdr_rec.asset_id;
1426:
1427:

Line 1491: SELECT igi_iac_transaction_headers_s.nextval

1487:
1488: /* Cursor to select the adjustment_id from the sequence for a new record */
1489:
1490: CURSOR c_adj_id IS
1491: SELECT igi_iac_transaction_headers_s.nextval
1492: FROM dual;
1493:
1494: /* To select the asset's deprn_expense from fa_books */
1495:

Line 1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;

1591: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1592: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1593: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1594: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1595: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%TYPE;
1596: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%TYPE;
1597: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%TYPE;
1598: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%TYPE;
1599: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

Line 1784: UPDATE igi_iac_transaction_headers

1780: l_closing_det_balances.adjustment_id := l_adj_id;
1781: l_closing_det_balances.period_counter := l_current_period_counter;
1782: l_deprn_reserve_amount:= 0;
1783:
1784: UPDATE igi_iac_transaction_headers
1785: SET category_id = l_asset_cat_rec_old.category_id
1786: WHERE adjustment_id = l_adj_id;
1787:
1788: -- reverse the accounting entries for the existing dist ids

Line 1853: UPDATE igi_iac_transaction_headers

1849: END IF;
1850: CLOSE c_get_deprn_dist;
1851: -- enchancement 2480915 maintiain the ytd values ---
1852: -- before performing the new distribution entries update with new catgeory
1853: UPDATE igi_iac_transaction_headers
1854: SET category_id = l_asset_cat_rec_new.category_id
1855: WHERE adjustment_id = l_adj_id;
1856:
1857: -- create entries in igi_iac_det_balances for the new dist

Line 2093: FROM igi_iac_transaction_headers a

2089: /* Cursor to select adjustment_id or the previous transaction */
2090:
2091: CURSOR c_prev_data IS
2092: SELECT a.rowid,a.adjustment_id
2093: FROM igi_iac_transaction_headers a
2094: WHERE a.adjustment_id_out is null
2095: and a.asset_id = l_asset_hdr_rec.asset_id;
2096:
2097:

Line 2170: SELECT igi_iac_transaction_headers_s.nextval

2166:
2167: /* Cursor to select the adjustment_id from the sequence for a new record */
2168:
2169: CURSOR c_adj_id IS
2170: SELECT igi_iac_transaction_headers_s.nextval
2171: FROM dual;
2172:
2173: /* To select the asset's deprn_expense from fa_books */
2174:

Line 2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;

2269: l_gen_fund_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2270: l_backlog_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2271: l_deprn_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2272: l_cost_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2273: l_prior_period_counter IGI_IAC_TRANSACTION_HEADERS.period_counter%type;
2274: l_historic_deprn_expense FA_DEPRN_SUMMARY.deprn_amount%type;
2275: l_Expense_diff IGI_IAC_DET_BALANCES.deprn_period%type;
2276: l_expense_ccid IGI_IAC_ADJUSTMENTS.code_combination_id%type;
2277: l_closing_det_balances IGI_IAC_DET_BALANCES%ROWTYPE;

Line 2504: Update igi_iac_transaction_headers

2500: l_closing_det_balances.adjustment_id := l_adj_id;
2501: l_closing_det_balances.period_counter := l_current_period_counter;
2502: l_deprn_reserve_amount:= 0;
2503:
2504: Update igi_iac_transaction_headers
2505: set category_id = l_asset_cat_rec_old.category_id
2506: where adjustment_id = l_adj_id;
2507:
2508: if create_iac_acctg ( l_closing_det_balances,TRUE,'OLD',p_event_id => p_event_id) Then

Line 2582: Update igi_iac_transaction_headers

2578:
2579:
2580:
2581: -- before performing the new distribution account entries update with new catgeory
2582: Update igi_iac_transaction_headers
2583: set category_id = l_asset_cat_rec_new.category_id
2584: where adjustment_id = l_adj_id;
2585:
2586:

Line 3619: FROM IGI_IAC_TRANSACTION_HEADERS

3615: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
3616: AND ASSET_ID = P_ASSET_ID
3617: AND PERIOD_COUNTER = l_open_period.period_counter
3618: AND ADJUSTMENT_ID IN (SELECT ADJUSTMENT_ID
3619: FROM IGI_IAC_TRANSACTION_HEADERS
3620: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
3621: AND ASSET_ID = P_ASSET_ID
3622: AND PERIOD_COUNTER = l_open_period.period_counter
3623: AND TRANSACTION_TYPE_CODE = 'RECLASS'

Line 3626: UPDATE IGI_IAC_TRANSACTION_HEADERS

3622: AND PERIOD_COUNTER = l_open_period.period_counter
3623: AND TRANSACTION_TYPE_CODE = 'RECLASS'
3624: AND EVENT_ID IS NULL);
3625:
3626: UPDATE IGI_IAC_TRANSACTION_HEADERS
3627: SET EVENT_ID = P_EVENT_ID
3628: WHERE BOOK_TYPE_CODE = P_BOOK_TYPE_CODE
3629: AND ASSET_ID = P_ASSET_ID
3630: AND PERIOD_COUNTER = l_open_period.period_counter

Line 3660: FROM igi_iac_transaction_headers ith

3656:
3657: /* bug 2502128 need to update the reval rates ..only one record should have staus = 'Y' for an asset */
3658: Cursor C_Reval_Rates is
3659: SELECT max(adjustment_id)
3660: FROM igi_iac_transaction_headers ith
3661: WHERE ith.book_type_code =l_asset_hdr_rec.book_type_code
3662: AND ith.asset_id = l_asset_hdr_rec.asset_id
3663: AND (ith.transaction_type_code = 'RECLASS' AND ith.Transaction_sub_type ='REVALUATION');
3664: