[Home] [Help]
150: Reason:
151: Issue is that jai_rgm_balance_tmp is popualted with double amount.
152: Issue is with the jai_cmn_rgm_tax_dist_pkg.CALCULATE_RGM_BALANCES procedure
153:
154: JAI_RGM_ORG_REGNS_V is retreiving 2 rows for TCS type of taxes.
155: This will occuer only if the organization is associated with more than one location.
156:
157: Fix:
158: Removed the JAI_RGM_ORG_REGNS_V in cursor for delta_rec in (
154: JAI_RGM_ORG_REGNS_V is retreiving 2 rows for TCS type of taxes.
155: This will occuer only if the organization is associated with more than one location.
156:
157: Fix:
158: Removed the JAI_RGM_ORG_REGNS_V in cursor for delta_rec in (
159:
160: Added the table jai_rgm_registrations table.
161:
162: 21 14-oct-2009 vkaranam for bug#9005474
369:
370:
371: --Added by Eric Ma for bug 8333082 on Dec-19-2009,begin
372: --------------------------------------------------------------------------------------
373: PROCEDURE populate_all_orgs_vat( p_regn_no jai_rgm_org_regns_v.attribute_value%TYPE,
374: p_regn_id jai_rgm_org_regns_v.registration_id%TYPE,
375: p_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,
376: p_request_id NUMBER,
377: p_balance_date DATE,
370:
371: --Added by Eric Ma for bug 8333082 on Dec-19-2009,begin
372: --------------------------------------------------------------------------------------
373: PROCEDURE populate_all_orgs_vat( p_regn_no jai_rgm_org_regns_v.attribute_value%TYPE,
374: p_regn_id jai_rgm_org_regns_v.registration_id%TYPE,
375: p_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,
376: p_request_id NUMBER,
377: p_balance_date DATE,
378: p_org_type VARCHAR2 default NULL,
389: which are not considered in the current settlement period .
390: */
391: --this cursor will fetch the credit balance from the organization which doesnot have transactions in the current settlement period
392: /*Added parameter cp_regime_id by mmurtuza for bug 12641455*/
393: CURSOR c_other_orgs(cp_regn_no jai_rgm_org_regns_v.attribute_value%TYPE,cp_regn_id jai_rgm_org_regns_v.registration_id%TYPE, cp_regime_id jai_rgm_org_regns_v.regime_id%type)
394: IS
395: SELECT organization_id,
396: location_id
397: FROM jai_rgm_org_regns_v
393: CURSOR c_other_orgs(cp_regn_no jai_rgm_org_regns_v.attribute_value%TYPE,cp_regn_id jai_rgm_org_regns_v.registration_id%TYPE, cp_regime_id jai_rgm_org_regns_v.regime_id%type)
394: IS
395: SELECT organization_id,
396: location_id
397: FROM jai_rgm_org_regns_v
398: WHERE --regime_code = jai_constants.vat_regime -- commneted by mmurtuza for bug 12641455
399: regime_id = cp_regime_id -- added by mmurtuza for bug 12641455
400: AND attribute_code ='REGISTRATION_NO'
401: AND attribute_value = cp_regn_no
850: UPDATE jai_Rgm_trx_records
851: SET settlement_id = p_settlement_id
852: WHERE (organization_id,location_id) in
853: (SELECT organization_id,location_id
854: FROM JAI_RGM_ORG_REGNS_V
855: WHERE registration_id = p_regn_id
856: AND attribute_value = nvl(p_regn_no, attribute_value) -- 6835541. Added by Lakshmi Gopalsami
857: AND regime_code = 'VAT'
858: AND organization_id = nvl(p_org_id,organization_id)
1182: --Percentage of Credit to be utilized for Service Tax Settlement
1183: Cursor get_crptg_utilize_st(cp_regime_id in number)
1184: is
1185: SELECT attribute_value
1186: FROM jai_rgm_org_regns_v
1187: WHERE regime_id = cp_regime_id
1188: AND attribute_code = 'CRPTG_UTILIZE_ST'
1189: AND attribute_type_code = 'OTHERS'
1190: AND registration_type = 'OTHERS';
1421: a.organization_type , /*6835541*/
1422: nvl(sum(a.debit_amount),0) debit_amt ,
1423: nvl(sum(a.credit_amount),0) credit_amt
1424: FROM
1425: jai_rgm_trx_records a, JAI_RGM_ORG_REGNS_V b
1426: WHERE trunc(transaction_date) <= p_balance_date --date condition changed for bug 9445836
1427: AND a.settlement_id IS NULL --added by csahoo for bug#6235971
1428: AND b.regime_id = p_regime_id/*5694855 bduvarag*/
1429: AND a.regime_code = lv_regime_code/*5694855 bduvarag*/
1597: FOR tax_types_rec in
1598: (
1599: SELECT regime_id,
1600: attribute_code tax_type
1601: FROM jai_rgm_org_regns_v
1602: WHERE organization_id = p_org_id
1603: AND location_id = p_location_id
1604: AND organization_type = p_org_type
1605: AND registration_type = jai_constants.regn_type_tax_types
1815: WHERE settlement_id = cp_stl_id;
1816:
1817: CURSOR c_get_organization_type(cp_organization_id NUMBER) IS
1818: SELECT DISTINCT organization_type
1819: FROM jai_rgm_org_regns_v
1820: WHERE regime_code = 'TCS'
1821: AND organization_id = cp_organization_id;
1822:
1823: r_last_settlement_dtls c_last_settlement_dtls%rowtype;
1827: cr_balance jai_rgm_stl_balances.credit_balance%type;
1828: dr_balance jai_rgm_stl_balances.debit_balance%type:= 0;
1829: ln_settled_debit_balance number:= 0;
1830: v_credit_exceeds_debit BOOLEAN :=FALSE;
1831: ln_organization_type jai_rgm_org_regns_v.organization_type%type;
1832: v_last_settlement_id NUMBER;
1833: ln_crbal_considered number;
1834:
1835: /*End addtions by mmurtuza for bug 12641455*/
1851: JRR.LOCATION_ID, --added by mmurtuza for bug 12641455
1852: JRR.REGIME_ID
1853: FROM JAI_RGM_REFS_ALL JRR,
1854: JAI_RGM_TAXES JRT,
1855: --JAI_RGM_ORG_REGNS_V JOR --commented for bug# 9005474
1856: JAI_RGM_REGISTRATIONS JOR --added for bug#9005474
1857: WHERE JRR.TRX_REF_ID = JRT.TRX_REF_ID
1858: -- AND JRR.ORGANIZATION_ID = JOR.ORGANIZATION_ID commented for bug# 9005474
1859: AND JOR.REGIME_ID = JRR.REGIME_ID
2076: END IF;
2077: FOR io_rec IN
2078: ( select distinct
2079: organization_id, location_id
2080: from JAI_RGM_ORG_REGNS_V
2081: where organization_type = 'IO'
2082: and regime_code = 'SERVICE'
2083: )
2084: LOOP
3237: IS
3238: SELECT
3239: attribute_value
3240: FROM
3241: jai_rgm_org_regns_v
3242: WHERE
3243: --organization_type = 'OU' /*commented by vkaranam for bug#6773684*/
3244: organization_id = p_party_id
3245: AND regime_code = 'SERVICE'