APPS.IGI_IAC_COMMON_UTILS dependencies on FA_TRANSACTION_HEADERS

Line 341: l_transaction_type fa_transaction_headers.transaction_type_code%TYPE ;

337: P_Type OUT NOCOPY VARCHAR2
338: )
339: RETURN BOOLEAN AS
340: l_units NUMBER;
341: l_transaction_type fa_transaction_headers.transaction_type_code%TYPE ;
342: l_path_name VARCHAR2(150);
343: BEGIN
344: l_units := 0 ;
345: l_path_name := g_path||'get_retirement_type';

Line 349: FROM fa_transaction_headers t, fa_retirements r

345: l_path_name := g_path||'get_retirement_type';
346:
347: SELECT t.transaction_type_code
348: INTO l_transaction_type
349: FROM fa_transaction_headers t, fa_retirements r
350: WHERE t.transaction_header_id = r.transaction_header_id_in
351: AND r.retirement_id = P_retirement_id ;
352:
353: SELECT r.units

Line 595: FROM fa_transaction_headers ft ,

591: l_path_name := g_path||'any_txns_in_open_period';
592:
593: SELECT count(*)
594: INTO l_tot_records
595: FROM fa_transaction_headers ft ,
596: fa_deprn_periods dp
597: WHERE ft.book_type_Code = P_book_type_code
598: AND ft.asset_id = P_asset_id
599: AND dp.book_type_Code = P_book_type_code

Line 632: FROM fa_transaction_headers ft

628: l_path_name := g_path||'any_adj_in_book';
629:
630: SELECT count(*)
631: INTO l_tot_records
632: FROM fa_transaction_headers ft
633: WHERE ft.book_type_Code = P_book_type_code
634: AND ft.asset_id = P_asset_id
635: AND ft.transaction_type_Code = 'ADJUSTMENT';
636:

Line 665: FROM fa_transaction_headers ft

661: l_path_name := g_path||'any_reval_in_corp_book';
662:
663: SELECT count(*)
664: INTO l_tot_records
665: FROM fa_transaction_headers ft
666: WHERE ft.book_type_Code = P_book_type_code
667: AND ft.asset_id = P_asset_id
668: AND ft.transaction_type_Code = 'REVALUATION';
669:

Line 739: FROM fa_transaction_headers t

735: AND r.asset_id = P_asset_id
736: AND r.status IN ('PROCESSED' , 'PENDING', 'PARTIAL' , 'REINSTATE' )
737: AND r.date_retired >= l_fy_start_date
738: AND EXISTS ( SELECT 'x'
739: FROM fa_transaction_headers t
740: WHERE t.transaction_header_id = r.transaction_header_id_in
741: AND t.transaction_type_code = 'FULL RETIREMENT' );
742:
743: -- bug 2452521, end (1)

Line 2192: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,

2188: FUNCTION Is_Asset_Adjustment_Done(
2189: X_book_type_code IN VARCHAR2,
2190: X_asset_id IN NUMBER)
2191: RETURN BOOLEAN IS
2192: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
2193: p_asset_id fa_transaction_headers.asset_id%TYPE,
2194: p_period_counter number) is
2195: SELECT 1
2196: FROM dual

Line 2193: p_asset_id fa_transaction_headers.asset_id%TYPE,

2189: X_book_type_code IN VARCHAR2,
2190: X_asset_id IN NUMBER)
2191: RETURN BOOLEAN IS
2192: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
2193: p_asset_id fa_transaction_headers.asset_id%TYPE,
2194: p_period_counter number) is
2195: SELECT 1
2196: FROM dual
2197: WHERE EXISTS