[Home] [Help]
331: -- SLA: do not populate when this is called from an invoice transfer
332: -- and the id was already populated
333:
334: if (nvl(px_inv_trans_rec.transaction_type, 'X') <> 'INVOICE TRANSFER') then
335: select fa_transaction_headers_s.nextval
336: into px_trans_rec.transaction_header_id
337: from dual;
338: end if;
339:
436:
437: -- SLA: we need the thid or each tax book as well
438: -- note that we do it here rather than do_all
439: -- books because of invoice impacts in corp above
440: select fa_transaction_headers_s.nextval
441: into l_trans_rec.transaction_header_id
442: from dual;
443:
444: if not do_all_books
644:
645: cursor c_get_overlapping_ret (p_asset_id number,
646: p_book_type_code varchar2) is
647: select transaction_date_entered
648: from fa_transaction_headers
649: where asset_id = p_asset_id
650: and book_type_code = p_book_type_code
651: and transaction_type_code in
652: ('PARTIAL RETIREMENT','REINSTATEMENT'
1937: p_log_level_rec => p_log_level_rec)) then
1938: raise adj_err;
1939: end if;
1940:
1941: select fa_transaction_headers_s.nextval
1942: into l_src_trans_rec.transaction_header_id
1943: from dual;
1944:
1945: end if;