[Home] [Help]
360: -- SLA: do not populate when this is called from an invoice transfer
361: -- and the id was already populated
362: -- ER 14644811 / Bug 15877517 : Moved the code to do_all_books
363: /* if (nvl(px_inv_trans_rec.transaction_type, 'X') <> 'INVOICE TRANSFER') then
364: select fa_transaction_headers_s.nextval
365: into px_trans_rec.transaction_header_id
366: from dual;
367: end if; */
368:
482: -- SLA: we need the thid or each tax book as well
483: -- note that we do it here rather than do_all
484: -- books because of invoice impacts in corp above
485: -- ER 14644811 / Bug 15877517 : Moved the code to do_all_books
486: /*select fa_transaction_headers_s.nextval
487: into l_trans_rec.transaction_header_id
488: from dual; */
489:
490: if not do_all_books
689:
690: cursor c_get_overlapping_ret (p_asset_id number,
691: p_book_type_code varchar2) is
692: select transaction_date_entered
693: from fa_transaction_headers
694: where asset_id = p_asset_id
695: and book_type_code = p_book_type_code
696: and transaction_type_code in
697: ('PARTIAL RETIREMENT','REINSTATEMENT')
730: , FB.allowed_deprn_limit
731: , FB.deprn_limit_type
732: , FB.allowed_deprn_limit_amount
733: FROM FA_BOOKS FB
734: , FA_TRANSACTION_HEADERS FT
735: WHERE FB.BOOK_TYPE_CODE = p_book_type_code
736: AND FB.ASSET_ID = p_asset_id
737: AND FB.BOOK_TYPE_CODE = FT.BOOK_TYPE_CODE
738: AND FB.ASSET_ID = FT.ASSET_ID
765: p_book_type_code varchar2
766: ) is
767: Select 1
768: from
769: fa_transaction_headers fath
770: , fa_deprn_periods fadp
771: , fa_retirements faret
772: , fa_conventions facon
773: where fath.book_type_code = p_book_type_code
864: raise adj_err;
865: end if;
866:
867: -- Populate th_id and who_info after calling faxcat
868: select fa_transaction_headers_s.nextval
869: into px_trans_rec.transaction_header_id
870: from dual;
871:
872: px_trans_rec.who_info.creation_date := sysdate;
2299: else
2300: l_src_trans_rec.transaction_key := 'MJ';
2301: end if;
2302:
2303: select fa_transaction_headers_s.nextval
2304: into l_src_trans_rec.transaction_header_id
2305: from dual;
2306:
2307: end if;