details: https://code.openbravo.com/erp/devel/pi/rev/412c6541bb48
changeset: 23866:412c6541bb48
user: Sandra Huguet <sandra.huguet <at> openbravo.com>
date: Tue Jun 24 19:02:43 2014 +0200
summary: Related to issue 26928
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
| 23 ++++++---
1 files changed, 16 insertions(+), 7 deletions(-)
diffs (45 lines):
diff -r 01ad2c4839e0 -r 412c6541bb48
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 19:05:24 2014 +0530
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
Tue Jun 24 19:02:43 2014 +0200
@@ -33,7 +33,8 @@
TYPE RECORD IS REF CURSOR;
Cur_Dbprefix RECORD;
v_invoicepaidstatus VARCHAR2(32);
- v_fin_payment_schedule_invoice VARCHAR2(32);
+ v_fin_payment_schedule_invoice VARCHAR(32);
+ v_p_fin_psd_id VARCHAR(32);
BEGIN
-- Check if the status exists
SELECT count(*) INTO v_count FROM DUAL
@@ -44,17 +45,25 @@
IF (v_count = 0) THEN
RETURN 'N';
END IF;
+
+ v_p_fin_psd_id := p_fin_psd_id;
+ IF (v_p_fin_psd_id='') THEN
+ v_p_fin_psd_id := NULL;
+ END IF;
+
+ IF (v_p_fin_psd_id is not null ) THEN
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 <> '') or (p_fin_psd_id is not null)) AND
(v_fin_payment_schedule_invoice is not null))THEN
+ where fin_payment_scheduledetail_id=v_p_fin_psd_id;
+ END IF;
+
+ IF (v_fin_payment_schedule_invoice is not null)THEN
IF(v_isinvoicepaid='Y')THEN
- -- core intermediate statuses
- v_isPaymentConfirmed := 'Y';
+ -- core intermediate statuses
+ v_isPaymentConfirmed := 'Y';
ELSE
- -- core intermediate statuses
+ -- core intermediate statuses
v_isPaymentConfirmed := 'N';
END IF;
ELSE
------------------------------------------------------------------------------
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
