APPS.FA_INVOICE_PVT dependencies on FA_ASSET_INVOICES

Line 619: from fa_asset_invoices

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

Line 627: from fa_asset_invoices

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

Line 647: update fa_asset_invoices

643:
644: if (px_inv_trans_rec.transaction_type <> 'MASS ADDITION' and
645: px_inv_trans_rec.transaction_type <> 'INVOICE ADDITION') then
646:
647: update fa_asset_invoices
648: set date_ineffective = sysdate,
649: invoice_transaction_id_out = px_inv_trans_rec.invoice_transaction_id
650: where source_line_id = l_inv_rec.source_line_id;
651:

Line 752: select FA_ASSET_INVOICES_S.nextval

748: if (l_inv_rec.source_line_id is not null) then
749: l_inv_rec.prior_source_line_id := l_inv_rec.source_line_id;
750: end if;
751:
752: select FA_ASSET_INVOICES_S.nextval
753: into l_inv_rec.source_line_id
754: from dual;
755:
756: -- need to assign source lne id here

Line 970: from fa_asset_invoices_mrc_v

966: select fixed_assets_cost,
967: payables_cost
968: into l_current_fa_cost,
969: l_current_pa_cost
970: from fa_asset_invoices_mrc_v
971: where source_line_id = l_current_source_line_id;
972:
973: if (px_inv_trans_rec.transaction_type = 'INVOICE DELETE') then
974: l_inv_rec.Fixed_Assets_Cost := -l_current_fa_cost;

Line 1514: FA_ASSET_INVOICES_PKG.Insert_Row

1510: l_invoice_transaction_id_out := p_inv_trans_rec.invoice_transaction_id;
1511:
1512: end if;
1513:
1514: FA_ASSET_INVOICES_PKG.Insert_Row
1515: (X_Rowid => l_rowid,
1516: X_Asset_Id => px_asset_hdr_rec.asset_id,
1517: X_Po_Vendor_Id => px_inv_rec.po_vendor_id,
1518: X_Asset_Invoice_Id => px_inv_rec.asset_invoice_id, -- mass_add_id