APPS.FA_INVOICE_PVT dependencies on FA_ASSET_INVOICES

Line 620: from fa_asset_invoices

616: select decode(fixed_assets_cost + l_inv_rec.fixed_assets_cost,
617: 0, 'NO',
618: 'YES')
619: into l_create_new_row
620: from fa_asset_invoices
621: where source_line_id = l_inv_rec.source_line_id
622: and asset_id = px_asset_hdr_rec.asset_Id;
623:
624: else

Line 628: from fa_asset_invoices

624: else
625: if (l_inv_rec.source_line_id is not null) then
626: select 'YES'
627: into l_create_new_row
628: from fa_asset_invoices
629: where source_line_id = l_inv_rec.source_line_id
630: and asset_id = px_asset_hdr_rec.asset_id;
631: else
632: l_create_new_row := 'YES';

Line 642: update fa_asset_invoices

638:
639: if (px_inv_trans_rec.transaction_type <> 'MASS ADDITION' and
640: px_inv_trans_rec.transaction_type <> 'INVOICE ADDITION') then
641:
642: update fa_asset_invoices
643: set date_ineffective = sysdate,
644: invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
645: where source_line_id = l_inv_rec.source_line_id;
646:

Line 744: select FA_ASSET_INVOICES_S.nextval

740: if (l_inv_rec.source_line_id is not null) then
741: l_inv_rec.prior_source_line_id := l_inv_rec.source_line_id;
742: end if;
743:
744: select FA_ASSET_INVOICES_S.nextval
745: into l_inv_rec.source_line_id
746: from dual;
747:
748:

Line 1509: FA_ASSET_INVOICES_PKG.Insert_Row

1505: l_invoice_transaction_id_out := p_inv_trans_rec.invoice_transaction_id;
1506:
1507: end if;
1508:
1509: FA_ASSET_INVOICES_PKG.Insert_Row
1510: (X_Rowid => l_rowid,
1511: X_Asset_Id => px_asset_hdr_rec.asset_id,
1512: X_Po_Vendor_Id => px_inv_rec.po_vendor_id,
1513: X_Asset_Invoice_Id => px_inv_rec.asset_invoice_id, -- mass_add_id