eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_CMN_RGM_SETTLEMENT_PKG

Line 8: CALLED FROM : jai_cmn_rgm_settlement_pkg , JAIRGMDT.fmb , JAIRGMDT.fmb

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:

Line 433: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date

429: /*Bug 5879769 bduvarag*/
430: WHERE organization_id = p_org_id
431: AND location_id = p_location_id
432: AND regime_code = lv_regime
433: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date
434: AND settlement_id IS NULL; /* added by ssawant for bug 5662296*/
435:
436: ELSIF lv_regime IN ('VAT') THEN /*6835541*/
437:

Line 449: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date

445: AND regime_code = 'VAT'
446: AND organization_id = nvl(p_org_id,organization_id)
447: AND location_id = nvl(p_location_id,location_id)
448: )
449: AND trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,organization_id,location_id),g_start_date) AND p_balance_date
450: AND settlement_id IS NULL;
451:
452: ELSIF lv_regime = jai_constants.tcs_regime THEN
453: UPDATE JAI_RGM_REFS_ALL

Line 665: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(cp_regime_id,cp_organization_id,cp_location_id),g_start_date) and p_balance_date

661: nvl(sum(debit_amount),0) debit_amt ,
662: nvl(sum(credit_amount),0) credit_amt
663: FROM
664: jai_rgm_trx_records
665: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(cp_regime_id,cp_organization_id,cp_location_id),g_start_date) and p_balance_date
666: AND settlement_id IS NULL
667: AND source_trx_type <> 'Invoice Payment'
668: AND organization_id = cp_organization_id
669: AND location_id = cp_location_id

Line 717: WHERE trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,a.organization_id,a.location_id),g_start_date)

713: a.tax_type ,
714: nvl(sum(a.debit_amount),0) debit_amt ,
715: nvl(sum(a.credit_amount),0) credit_amt
716: FROM jai_rgm_trx_records a
717: WHERE trunc(transaction_date) BETWEEN nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,a.organization_id,a.location_id),g_start_date)
718: /*rchandan for bug#5003538*//*rchandan for bug#5642053. Removed +1 from last settlement date*/
719: AND p_balance_date /*5694855.location_id is also passed to get_last_settlement_date*/
720: AND a.settlement_id IS NULL/*rchandan for bug#5642053*/
721: AND a.regime_code = lv_regime_code/*5694855*/

Line 739: --ld_trx_date := jai_cmn_rgm_settlement_pkg.get_last_settlement_date(delta_rec.organization_id) + 1;/* commented by ssawant for bug 5662296*/

735: get the debit balance and credit balance as on the last settlement for a given operating unit and tax type
736: and add the value in this table.
737: -- API call to settlement process.
738: */
739: --ld_trx_date := jai_cmn_rgm_settlement_pkg.get_last_settlement_date(delta_rec.organization_id) + 1;/* commented by ssawant for bug 5662296*/
740: ln_settled_debit_balance :=0;
741: ln_settled_credit_balance :=0;
742: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
743: pn_regime_id => p_regime_id , /*Bug 5879769 bduvarag*/

Line 742: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(

738: */
739: --ld_trx_date := jai_cmn_rgm_settlement_pkg.get_last_settlement_date(delta_rec.organization_id) + 1;/* commented by ssawant for bug 5662296*/
740: ln_settled_debit_balance :=0;
741: ln_settled_credit_balance :=0;
742: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
743: pn_regime_id => p_regime_id , /*Bug 5879769 bduvarag*/
744: pn_org_id => delta_rec.organization_id ,
745: pn_location_id => delta_rec.location_id , /*Bug 5879769 bduvarag*/
746: pv_service_type_code => delta_rec.service_type_code ,/*Bug 5879769 bduvarag*/

Line 831: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(b.regime_id,a.organization_id,a.location_id) ,g_start_date) and p_balance_date /+ 1 removed by ssawant for bug 5662296/

827: nvl(sum(a.debit_amount),0) debit_amt ,
828: nvl(sum(a.credit_amount),0) credit_amt
829: FROM
830: jai_rgm_trx_records a, JAI_RGM_ORG_REGNS_V b
831: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(b.regime_id,a.organization_id,a.location_id) ,g_start_date) and p_balance_date /*+ 1 removed by ssawant for bug 5662296*/
832: AND a.settlement_id IS NULL --added by csahoo for bug#6235971
833: AND b.regime_id = p_regime_id/*5694855 bduvarag*/
834: AND a.regime_code = lv_regime_code/*5694855 bduvarag*/
835: AND a.organization_id = b.organization_id

Line 855: --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*/

851: get the debit balance and credit balance as on the last settlement for a given IO , Location and tax type
852: and add the value in this table.
853: -- API call to settlement process.
854: */
855: --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*/
856: ln_settled_debit_balance :=0;
857: ln_settled_credit_balance :=0;
858: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
859: pn_regime_id => delta_rec.regime_id,

Line 858: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(

854: */
855: --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*/
856: ln_settled_debit_balance :=0;
857: ln_settled_credit_balance :=0;
858: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
859: pn_regime_id => delta_rec.regime_id,
860: pn_org_id => delta_rec.organization_id ,
861: pn_location_id => delta_rec.location_id ,
862: pv_tax_type => delta_rec.tax_type ,

Line 964: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(

960: CLOSE c_delta_rec;
961:
962: ln_settled_debit_balance :=0;
963: ln_settled_credit_balance :=0;
964: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
965: pn_regime_id => tax_types_rec.regime_id ,
966: pn_org_id => p_org_id ,
967: pn_location_id => p_location_id ,
968: pv_tax_type => tax_types_rec.tax_type ,

Line 1007: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,a.organization_id),g_start_date) and p_balance_date

1003: nvl(sum(credit_amount),0) credit_amt
1004: FROM
1005: /*Bug 5879769 bduvarag start*/
1006: jai_rgm_trx_records a
1007: WHERE trunc(transaction_date) between nvl(jai_cmn_rgm_settlement_pkg.get_last_settlement_date(p_regime_id,a.organization_id),g_start_date) and p_balance_date
1008: /*rchandan for bug#5003538*//*rchandan for bug#5642053. Removed +1 from last settlement date*/
1009: AND a.settlement_id IS NULL
1010: AND a.source_trx_type <> 'Invoice Payment'
1011: AND a.organization_id = p_org_id

Line 1022: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(

1018: )/*Bug 5879769 bduvarag end*/
1019: LOOP
1020: ln_settled_debit_balance :=0;
1021: ln_settled_credit_balance :=0;
1022: jai_cmn_rgm_settlement_pkg.GET_LAST_BALANCE_AMOUNT(
1023: pn_org_id => delta_rec.organization_id ,
1024: pv_tax_type => delta_rec.tax_type ,
1025: pn_debit_amount => ln_settled_debit_balance ,
1026: pn_credit_amount => ln_settled_credit_balance