[Home] [Help]
4: CREATED BY : ssumaith
5: CREATED DATE : 11-JAN-2005
6: ENHANCEMENT BUG : 4068911
7: PURPOSE : To get the balances , to insert records into repository
8: CALLED FROM : jai_cmn_rgm_settlement_pkg , JAIRGMDT.fmb , JAIRGMDT.fmb
9: /* -------------------------------------------------------------------------------------------------------------------
10: 1. 08-Jun-2005 File Version 116.2. Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
11: as required for CASE COMPLAINCE.
12:
1248: get the debit balance and credit balance as on the last settlement for a given operating unit and tax type
1249: and add the value in this table.
1250: -- API call to settlement process.
1251: */
1252: --ld_trx_date := jai_cmn_rgm_settlement_pkg.get_last_settlement_date(delta_rec.organization_id) + 1;/* commented by ssawant for bug 5662296*/
1253: ln_settled_debit_balance :=0;
1254: ln_settled_credit_balance :=0;
1255: ln_total_debit_balance :=0; --11821537
1256: ln_total_credit_balance :=0; --11821537
1259: /* Commented for bug#8289991
1260: v_credit_exceeds_debit:= FALSE;/* added by vumaasha for bug 7606212 */
1261:
1262: /* Modified below procedure call by vumaasha for bug 7606212
1263: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
1264: pn_regime_id => p_regime_id,
1265: pn_org_id => delta_rec.organization_id ,
1266: pn_location_id => delta_rec.location_id ,
1267: pv_tax_type => delta_rec.tax_type ,
1445: get the debit balance and credit balance as on the last settlement for a given IO , Location and tax type
1446: and add the value in this table.
1447: -- API call to settlement process.
1448: */
1449: --ld_trx_date := jai_cmn_rgm_settlement_pkg.get_last_settlement_date(delta_rec.regime_id,delta_rec.organization_id,delta_rec.location_id) + 1; /* commented by ssawant for bug 5662296*/
1450: ln_settled_debit_balance :=0;
1451: ln_settled_credit_balance :=0;
1452: v_credit_exceeds_debit:= FALSE;/* added by vumaasha for bug 7606212*/
1453:
1450: ln_settled_debit_balance :=0;
1451: ln_settled_credit_balance :=0;
1452: v_credit_exceeds_debit:= FALSE;/* added by vumaasha for bug 7606212*/
1453:
1454: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
1455: pn_regime_id => delta_rec.regime_id,
1456: pn_org_id => delta_rec.organization_id ,
1457: pn_location_id => delta_rec.location_id ,
1458: pv_tax_type => delta_rec.tax_type ,
1619: CLOSE c_delta_rec;
1620:
1621: ln_settled_debit_balance :=0;
1622: ln_settled_credit_balance :=0;
1623: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
1624: pn_regime_id => tax_types_rec.regime_id ,
1625: pn_org_id => p_org_id ,
1626: pn_location_id => p_location_id ,
1627: pv_tax_type => tax_types_rec.tax_type ,
1678: )/*Bug 5879769 bduvarag end*/
1679: LOOP
1680: ln_settled_debit_balance :=0;
1681: ln_settled_credit_balance :=0;
1682: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
1683: pn_org_id => delta_rec.organization_id ,
1684: pv_tax_type => delta_rec.tax_type ,
1685: pn_debit_amount => ln_settled_debit_balance ,
1686: pn_credit_amount => ln_settled_credit_balance
1874: ln_settled_debit_balance := 0;
1875: ln_settled_credit_balance := 0;
1876: v_credit_exceeds_debit := FALSE;
1877:
1878: jai_cmn_rgm_settlement_pkg.get_last_balance_amount(pn_regime_id => delta_rec.regime_id, pn_org_id => delta_rec.organization_id,
1879: pn_location_id => delta_rec.location_id, pv_tax_type => delta_rec.tax_type, pn_debit_amount => ln_settled_debit_balance,
1880: pn_credit_amount => ln_settled_credit_balance);
1881:
1882: ln_invoice_amount := 0;