[Home] [Help]
743:
744: -- Validate that asset does not already exist in book.
745: select count(*)
746: into l_exists
747: from fa_books
748: where book_type_code = p_book_type_code
749: and asset_id = p_asset_id
750: and rownum <= 1;
751:
764: if (fa_cache_pkg.fazcbc_record.book_class <> 'CORPORATE') then
765:
766: select count(*)
767: into l_exists
768: from fa_books bks
769: where exists
770: (
771: select 'X'
772: from fa_book_controls bc
785: else
786: -- for non-addition trxs verify asset does exist in book
787: select count(*)
788: into l_exists
789: from fa_books
790: where book_type_code = p_book_type_code
791: and asset_id = p_asset_id
792: and rownum <= 1;
793:
976:
977: --bug# 5501090: following cursor and 1 varible
978: CURSOR c_check_member_exists is
979: select 'Y'
980: from fa_books
981: where group_asset_id = p_asset_id
982: and book_type_code = p_book_type_code
983: and transaction_header_id_out is null;
984:
1093: * place this in form, etc if we wish to keep it there. --bmr
1094: */
1095:
1096: -- Fix for Bug #2621438. Only validate this from FAXASSET
1097: if ((p_calling_fn in ('faxasset.fa_books_val2.dpis_val',
1098: 'faxasset.fa_addition_books.date_placed_in_service')
1099: or (p_calling_interface = 'FAMAPT') )
1100: ) then
1101:
1306: return FALSE;
1307: end if;
1308:
1309:
1310: -- ytd, ltd deprn validations from fa_books_trx3.when_validate_record
1311: -- in FAXASSET.
1312:
1313: /* Fix for Bug #2429665. Should not have this validation.
1314: -- verify no reserve for asset in first period of life
2290: /* Bug 2407786 - This is the consolidated select stmnt */
2291: /*
2292: select count(*)
2293: into l_count
2294: from fa_books bk
2295: where bk.book_type_code = p_book
2296: and bk.asset_id = p_asset_id
2297: and (bk.rate_Adjustment_factor <> 1 OR
2298: (bk.rate_adjustment_factor = 1 and
2475: BEGIN
2476:
2477: select count(*)
2478: into l_count
2479: FROM FA_BOOKS BK
2480: WHERE BK.ASSET_ID = p_asset_id
2481: AND BK.PERIOD_COUNTER_FULLY_RETIRED IS NOT NULL
2482: AND BK.DATE_INEFFECTIVE IS NULL
2483: AND BK.BOOK_TYPE_CODE = p_book
2761: end if;
2762:
2763: select count(1)
2764: into l_count
2765: from fa_books
2766: where book_type_code = l_corp_book
2767: and asset_id = p_parent_asset_id
2768: and date_ineffective is null;
2769:
2842: CURSOR C1 IS
2843: select currency_code
2844: from gl_sets_of_books sob,
2845: fa_book_controls bc,
2846: fa_books bk
2847: where bk.asset_id = p_asset_id
2848: and bk.date_ineffective is null
2849: and bk.book_type_code = bc.book_type_code
2850: and bc.set_of_books_id = sob.set_of_books_id;
2970: -- Following sql is too expensive
2971: --
2972: -- select count(*)
2973: -- into l_count
2974: -- from FA_BOOKS
2975: -- where ASSET_ID = p_group_asset_id
2976: -- and BOOK_TYPE_CODE = p_book_type_code;
2977: l_count := null;
2978: select 1
2978: select 1
2979: into l_count
2980: from dual
2981: where exists (select 'X'
2982: from FA_BOOKS
2983: where ASSET_ID = p_group_asset_id
2984: and BOOK_TYPE_CODE = p_book_type_code);
2985:
2986: if l_count is null then
3057: BEGIN
3058:
3059: SELECT count(1)
3060: INTO l_disabled
3061: FROM fa_books
3062: WHERE asset_id = p_group_asset_id
3063: AND book_type_code = p_book_type_code
3064: AND disabled_flag = 'Y'
3065: AND transaction_header_id_out is null;
3069: return true;
3070: else
3071: SELECT count(1)
3072: INTO l_has_members
3073: FROM fa_books
3074: WHERE group_asset_id = p_group_asset_id
3075: AND book_type_code = p_book_type_code
3076: AND transaction_header_id_out is null
3077: AND period_counter_fully_retired is null;
3124: -- remaining reserve handling
3125: --
3126: select count(transaction_header_id_in)
3127: into l_member_count
3128: from fa_books
3129: where group_asset_id = p_asset_hdr_rec.asset_id
3130: and book_type_code = p_asset_hdr_rec.book_type_code
3131: and transaction_header_id_out is null;
3132: else
3231: , sum(inbk.salvage_value - nvl(outbk.salvage_value, 0))
3232: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3233: nvl(outbk.allowed_deprn_limit_amount, 0))
3234: from fa_transaction_headers th,
3235: fa_books inbk,
3236: fa_books outbk
3237: where inbk.asset_id = p_asset_id
3238: and inbk.book_type_code = p_book_type_code
3239: and outbk.asset_id(+) = p_asset_id
3232: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3233: nvl(outbk.allowed_deprn_limit_amount, 0))
3234: from fa_transaction_headers th,
3235: fa_books inbk,
3236: fa_books outbk
3237: where inbk.asset_id = p_asset_id
3238: and inbk.book_type_code = p_book_type_code
3239: and outbk.asset_id(+) = p_asset_id
3240: and outbk.book_type_code(+) = p_book_type_code
3270: , sum(inbk.salvage_value - nvl(outbk.salvage_value, 0))
3271: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3272: nvl(outbk.allowed_deprn_limit_amount, 0))
3273: from fa_transaction_headers th,
3274: fa_books_mrc_v inbk,
3275: fa_books_mrc_v outbk
3276: where inbk.asset_id = p_asset_id
3277: and inbk.book_type_code = p_book_type_code
3278: and outbk.asset_id(+) = p_asset_id
3271: , sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
3272: nvl(outbk.allowed_deprn_limit_amount, 0))
3273: from fa_transaction_headers th,
3274: fa_books_mrc_v inbk,
3275: fa_books_mrc_v outbk
3276: where inbk.asset_id = p_asset_id
3277: and inbk.book_type_code = p_book_type_code
3278: and outbk.asset_id(+) = p_asset_id
3279: and outbk.book_type_code(+) = p_book_type_code
3734:
3735: CURSOR c_group_dpis (p_group_asset_id NUMBER,
3736: p_book_type_code VARCHAR2) is
3737: select date_placed_in_service
3738: from fa_books
3739: where asset_id = p_group_asset_id
3740: and book_type_code = p_book_type_code
3741: and transaction_header_id_out is null;
3742:
3964: ) RETURN BOOLEAN IS
3965:
3966: CURSOR c_mem_exists IS
3967: select 1
3968: from fa_books
3969: where group_asset_id = p_asset_hdr_rec.asset_id
3970: and book_type_code = p_asset_hdr_rec.book_type_code
3971: and transaction_header_id_out is null;
3972: