Oracle EBS FA摊销调整框控制逻辑

Oracle EBS FA摊销调整框控制逻辑

cursor check_amort is 

  select 'YES'

  from fa_transaction_headers

  where  book_type_code = :fa_books_header.book_type_code

    and asset_id = :fa_books_header.asset_id

    and (transaction_subtype = 'AMORTIZED' OR transaction_key = 'UA')

    and rownum < 2;

摊销调整 check box 控制逻辑

    :fa_books_header.amortize_adj := 'NO';

       --

       OPEN  check_amort;

       FETCH check_amort INTO check_flag;

       if (check_amort%found) then

         :fa_books_header.amortize_adj := 'YES';

       end if;

       CLOSE check_amort;

--刘轶鹤