details: https://code.openbravo.com/erp/devel/pi/rev/0a192b614081
changeset: 22286:0a192b614081
user: Atul Gaware <atul.gaware <at> openbravo.com>
date: Thu Feb 27 22:54:19 2014 +0530
summary: Fixes Issue 0025859: Enable to run Payment Aging Reports.
diffstat:
modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
| 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diffs (35 lines):
diff -r 9db69b2ea0a6 -r 0a192b614081
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
Mon Feb 24 17:54:36 2014 +0530
+++
b/modules/org.openbravo.advpaymentmngt/src-db/database/model/functions/APRM_ISPAYMENTCONFIRMED.xml
Thu Feb 27 22:54:19 2014 +0530
@@ -4,7 +4,7 @@
<parameter name="status" type="VARCHAR" mode="in">
<default/>
</parameter>
- <parameter name="fin_payment_scheduledetail_id" type="VARCHAR" mode="in">
+ <parameter name="p_fin_psd_id" type="VARCHAR" mode="in">
<default/>
</parameter>
<body><![CDATA[/*************************************************************************
@@ -45,10 +45,10 @@
END IF;
select isinvoicepaid
into v_isinvoicepaid
- from fin_payment_scheduledetail
- where fin_payment_scheduledetail_id=fin_payment_scheduledetail_id;
+ from fin_payment_scheduledetail
+ where fin_payment_scheduledetail_id=p_fin_psd_id;
- IF ((fin_payment_scheduledetail_id <> '') AND (fin_payment_scheduledetail_id
is not null))THEN
+ IF ((p_fin_psd_id <> '') AND (p_fin_psd_id is not null))THEN
IF(v_isinvoicepaid='Y')THEN
-- core intermediate statuses
v_isPaymentConfirmed := 'Y';
@@ -78,7 +78,7 @@
ORDER BY name)
LOOP
BEGIN
- v_Sql := 'SELECT ' || Cur_Dbprefix.dbprefix || '_ispaymentconfirmed'
|| '(''' || coalesce(status, '') || ''', ''' ||
coalesce(fin_payment_scheduledetail_id, '') || ''') FROM DUAL';
+ v_Sql := 'SELECT ' || Cur_Dbprefix.dbprefix || '_ispaymentconfirmed'
|| '(''' || coalesce(status, '') || ''', ''' || coalesce(p_fin_psd_id, '') ||
''') FROM DUAL';
EXECUTE IMMEDIATE v_Sql INTO v_isPaymentConfirmed;
IF (v_ispaymentconfirmed = 'Y') THEN
------------------------------------------------------------------------------
Flow-based real-time traffic analytics software. Cisco certified tool.
Monitor traffic, SLAs, QoS, Medianet, WAAS etc. with NetFlow Analyzer
Customize your own dashboards, set traffic alerts and generate reports.
Network behavioral analysis & security monitoring. All-in-one tool.
http://pubads.g.doubleclick.net/gampad/clk?id=126839071&iu=/4140/ostg.clktrk
_______________________________________________
Openbravo-commits mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/openbravo-commits
