[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;
286:
287: BEGIN
288: SELECT count(1)
289: INTO v_count
290: FROM FA_BOOKS BK,
291: FA_BOOK_CONTROLS BC
292: WHERE BK.ASSET_ID = p_asset_id AND
293: BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL AND
294: BK.DATE_INEFFECTIVE IS NULL AND
398: FROM FA_TRANSACTION_HEADERS
399: WHERE asset_id = p_asset_id
400: AND book_type_code = p_book;
401: BEGIN
402: /* Logic from FA_BOOKS_VAL5.Amortization_Start_Date from FAXASSET. */
403: -- Check another transaction between transaction date and current period.
404: OPEN get_prior_trans_date;
405: FETCH get_prior_trans_date INTO l_prior_trans_date;
406: CLOSE get_prior_trans_date;
463: SELECT 'x' FROM FA_BOOK_CONTROLS
464: WHERE book_type_code = p_book_type_code AND allow_mass_changes = 'NO'
465: AND p_mr_req_id <> -1;
466: CURSOR check_prior_amort IS
467: SELECT 'x' FROM FA_BOOKS
468: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
469: AND rate_adjustment_factor <> 1;
470: CURSOR check_cip IS
471: SELECT 'x' FROM FA_ADDITIONS