abdeen-ahmad
3/3/2016 - 10:44 AM

PRE_INSERT in forms standard columns

PRE_INSERT in forms standard columns

:pur_invoices.entry_date := sysdate
gen_pkg.get_terminal_info(:pur_invoices.terminal, :pur_invoices.os_user);
--
:pur_invoices.user_id	:=	:parameter.p_user_id;
--
:pur_invoices.company_id	:=	:parameter.p_company_id;
--
select	nvl(max(invoice_no), 0) + 1
into		:pur_invoices.invoice_no
from		pur_invoices;