details: https://code.openbravo.com/erp/devel/pi/rev/f3972fa0041b
changeset: 23864:f3972fa0041b
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Tue Jun 24 12:53:44 2014 +0200
summary: 26928: aprm_ispaymentconfirmed function return always 'N' when psd
have glitem
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
| 7 ++++---
1 files changed, 4 insertions(+), 3 deletions(-)
diffs (27 lines):
diff -r b3671e259f50 -r f3972fa0041b
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
---
a/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
Tue Jun 24 12:10:40 2014 +0200
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
Tue Jun 24 12:53:44 2014 +0200
@@ -33,6 +33,7 @@
TYPE RECORD IS REF CURSOR;
Cur_Dbprefix RECORD;
v_invoicepaidstatus VARCHAR2(32);
+ v_fin_payment_schedule_invoice VARCHAR2(32);
BEGIN
-- Check if the status exists
SELECT count(*) INTO v_count FROM DUAL
@@ -43,12 +44,12 @@
IF (v_count = 0) THEN
RETURN 'N';
END IF;
- select isinvoicepaid
- into v_isinvoicepaid
+ select isinvoicepaid , fin_payment_schedule_invoice
+ into v_isinvoicepaid , v_fin_payment_schedule_invoice
from fin_payment_scheduledetail
where fin_payment_scheduledetail_id=p_fin_psd_id;
- IF ((p_fin_psd_id <> '') AND (p_fin_psd_id is not null))THEN
+ IF (((p_fin_psd_id <> '') or (p_fin_psd_id is not null)) AND
(v_fin_payment_schedule_invoice is not null))THEN
IF(v_isinvoicepaid='Y')THEN
-- core intermediate statuses
v_isPaymentConfirmed := 'Y';
------------------------------------------------------------------------------
Open source business process management suite built on Java and Eclipse
Turn processes into business applications with Bonita BPM Community Edition
Quickly connect people, data, and systems into organized workflows
Winner of BOSSIE, CODIE, OW2 and Gartner awards
http://p.sf.net/sfu/Bonitasoft
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
