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 3355: -- cursor to retrieve information from fa_transaction_headers

3351: p_calling_function VARCHAR2,
3352: p_event_id NUMBER) --R12 uptake
3353: RETURN BOOLEAN
3354: IS
3355: -- cursor to retrieve information from fa_transaction_headers
3356: -- associated with a given transaction_header_id
3357: CURSOR c_fa_trx_headers(p_trx_hdr_id NUMBER)
3358: IS
3359: SELECT fth.transaction_header_id,

Line 3368: FROM fa_transaction_headers fth,

3364: fth.date_effective,
3365: fth.mass_reference_id,
3366: fth.transaction_subtype,
3367: fab.asset_category_id
3368: FROM fa_transaction_headers fth,
3369: fa_additions_b fab
3370: WHERE fth.asset_id = fab.asset_id
3371: AND fth.transaction_header_id = p_trx_hdr_id;
3372:

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

3406: X_Period_Counter IN NUMBER
3407: )
3408: RETURN BOOLEAN
3409: IS
3410: CURSOR C_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
3411: p_asset_id fa_transaction_headers.asset_id%TYPE,
3412: P_period_counter number)
3413: IS
3414: SELECT *

Line 3411: p_asset_id fa_transaction_headers.asset_id%TYPE,

3407: )
3408: RETURN BOOLEAN
3409: IS
3410: CURSOR C_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
3411: p_asset_id fa_transaction_headers.asset_id%TYPE,
3412: P_period_counter number)
3413: IS
3414: SELECT *
3415: FROM IGI_IAC_TRANSACTION_HEADERS

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

3511: THEN
3512: RAISE e_no_retire_effect;
3513: ELSE
3514: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Have retiremen info from fa_retirements');
3515: -- in fa_retirements, transaction_header_id_in is fa_transaction_headers.transaction_header_id
3516: -- of the retirement
3517: -- transaction_header_id_out is fa_transaction_headers.transaction_header_id of the
3518: -- reinstatement
3519:

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

3513: ELSE
3514: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Have retiremen info from fa_retirements');
3515: -- in fa_retirements, transaction_header_id_in is fa_transaction_headers.transaction_header_id
3516: -- of the retirement
3517: -- transaction_header_id_out is fa_transaction_headers.transaction_header_id of the
3518: -- reinstatement
3519:
3520: -- get the period info for the effective retirement date
3521: -- get the period counter value

Line 3574: -- retrieve information from fa_transaction_headers for the

3570: END IF;
3571: END IF;
3572: -- bug 2452521 end(2)
3573:
3574: -- retrieve information from fa_transaction_headers for the
3575: -- corresponding reinstatement row
3576: OPEN c_fa_trx_headers(l_ret_rec.detail_info.transaction_header_id_out);
3577: FETCH c_fa_trx_headers INTO l_fa_trx_headers;
3578: CLOSE c_fa_trx_headers;