mht_brerp10
.adempiere
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
cof_getcheckallocate(numeric, numeric)
Parameters
Name
Type
Mode
invoice_id
numeric
IN
invoicepayschedule_id
numeric
IN
Definition
DECLARE check_qty INTEGER; BEGIN BEGIN SELECT count(*) INTO check_qty FROM cof_c_checkallocate ca WHERE ca.c_invoice_id = invoice_id AND COALESCE(ca.c_invoicepayschedule_id, 0::numeric) = COALESCE(invoicepayschedule_id,0); EXCEPTION WHEN NO_DATA_FOUND THEN check_qty := 0; END; RETURN check_qty; END;