[Home] [Help]
61:
62: -- Make sure the new category is defined in all the books the asset belongs to.
63: -- Get the number of books in which the new category is defined for the asset.
64: SELECT count(*) INTO l_count1
65: FROM FA_CATEGORY_BOOKS cb, FA_BOOKS bk, fa_book_controls bc
66: WHERE bk.asset_id = p_asset_id
67: AND bk.date_ineffective IS NULL
68: AND bk.book_type_code = cb.book_type_code
69: AND cb.category_id = p_new_category_id
71: AND nvl(bc.date_ineffective,sysdate) >= sysdate;
72:
73: -- Get the total number of books the asset belongs to.
74: SELECT count(*) INTO l_count2
75: FROM FA_BOOKS bk, FA_BOOK_CONTROLS bc
76: WHERE bk.asset_id = p_asset_id
77: AND bk.date_ineffective IS NULL
78: AND bk.book_type_code = bc.book_type_code
79: AND nvl(bc.date_ineffective,sysdate) >= sysdate;
300:
301: BEGIN
302: SELECT count(1)
303: INTO v_count
304: FROM FA_BOOKS BK,
305: FA_BOOK_CONTROLS BC
306: WHERE BK.ASSET_ID = p_asset_id AND
307: BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL AND
308: BK.DATE_INEFFECTIVE IS NULL AND
417: FROM FA_TRANSACTION_HEADERS
418: WHERE asset_id = p_asset_id
419: AND book_type_code = p_book;
420: BEGIN
421: /* Logic from FA_BOOKS_VAL5.Amortization_Start_Date from FAXASSET. */
422: -- Check another transaction between transaction date and current period.
423: OPEN get_prior_trans_date;
424: FETCH get_prior_trans_date INTO l_prior_trans_date;
425: CLOSE get_prior_trans_date;
486: SELECT 'x' FROM FA_BOOK_CONTROLS
487: WHERE book_type_code = p_book_type_code AND allow_mass_changes = 'NO'
488: AND p_mr_req_id <> -1;
489: CURSOR check_prior_amort IS
490: SELECT 'x' FROM FA_BOOKS
491: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
492: AND rate_adjustment_factor <> 1;
493: CURSOR check_cip IS
494: SELECT 'x' FROM FA_ADDITIONS