DBA Data[Home] [Help]

APPS.FA_ADJUSTMENT_PUB dependencies on DUAL

Line 366: from dual;

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:
369: -- also check if this is the period of addition - use absolute mode for adjustments
370: -- we will only clear cost outside period of addition

Line 488: from dual; */

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
491: (px_trans_rec => l_trans_rec, -- tax
492: px_asset_hdr_rec => l_asset_hdr_rec , -- tax

Line 870: from dual;

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;
873: px_trans_rec.who_info.last_update_date := sysdate;
874:

Line 1543: from dual;

1539: nvl(l_asset_fin_rec_adj.group_asset_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM) or
1540: (l_asset_fin_rec_old.group_asset_id <> l_asset_fin_rec_adj.group_asset_id) then
1541: select fa_trx_references_s.nextval
1542: into px_trans_rec.trx_reference_id
1543: from dual;
1544: end if;
1545:
1546: -- BUG# 2877651
1547: -- if this is or was a amember asset, force amortized subtype

Line 2305: from dual;

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;
2308:
2309: