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_REINSTATE_PKG dependencies on FA_TRANSACTION_HEADERS

Line 3318: -- cursor to retrieve information from fa_transaction_headers

3314: p_calling_function VARCHAR2,
3315: p_event_id NUMBER) --R12 uptake
3316: RETURN BOOLEAN
3317: IS
3318: -- cursor to retrieve information from fa_transaction_headers
3319: -- associated with a given transaction_header_id
3320: CURSOR c_fa_trx_headers(p_trx_hdr_id NUMBER)
3321: IS
3322: SELECT fth.transaction_header_id,

Line 3331: FROM fa_transaction_headers fth,

3327: fth.date_effective,
3328: fth.mass_reference_id,
3329: fth.transaction_subtype,
3330: fab.asset_category_id
3331: FROM fa_transaction_headers fth,
3332: fa_additions_b fab
3333: WHERE fth.asset_id = fab.asset_id
3334: AND fth.transaction_header_id = p_trx_hdr_id;
3335:

Line 3373: CURSOR C_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,

3369: X_Period_Counter IN NUMBER
3370: )
3371: RETURN BOOLEAN
3372: IS
3373: CURSOR C_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
3374: p_asset_id fa_transaction_headers.asset_id%TYPE,
3375: P_period_counter number)
3376: IS
3377: SELECT *

Line 3374: p_asset_id fa_transaction_headers.asset_id%TYPE,

3370: )
3371: RETURN BOOLEAN
3372: IS
3373: CURSOR C_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
3374: p_asset_id fa_transaction_headers.asset_id%TYPE,
3375: P_period_counter number)
3376: IS
3377: SELECT *
3378: FROM IGI_IAC_TRANSACTION_HEADERS

Line 3476: -- in fa_retirements, transaction_header_id_in is fa_transaction_headers.transaction_header_id

3472: THEN
3473: RAISE e_no_retire_effect;
3474: ELSE
3475: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Have retiremen info from fa_retirements');
3476: -- in fa_retirements, transaction_header_id_in is fa_transaction_headers.transaction_header_id
3477: -- of the retirement
3478: -- transaction_header_id_out is fa_transaction_headers.transaction_header_id of the
3479: -- reinstatement
3480:

Line 3478: -- transaction_header_id_out is fa_transaction_headers.transaction_header_id of the

3474: ELSE
3475: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Have retiremen info from fa_retirements');
3476: -- in fa_retirements, transaction_header_id_in is fa_transaction_headers.transaction_header_id
3477: -- of the retirement
3478: -- transaction_header_id_out is fa_transaction_headers.transaction_header_id of the
3479: -- reinstatement
3480:
3481: -- get the period info for the effective retirement date
3482: -- get the period counter value

Line 3535: -- retrieve information from fa_transaction_headers for the

3531: END IF;
3532: END IF;
3533: -- bug 2452521 end(2)
3534:
3535: -- retrieve information from fa_transaction_headers for the
3536: -- corresponding reinstatement row
3537: OPEN c_fa_trx_headers(l_ret_rec.detail_info.transaction_header_id_out);
3538: FETCH c_fa_trx_headers INTO l_fa_trx_headers;
3539: CLOSE c_fa_trx_headers;