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_RGM_DEFINITIONS

Line 375: p_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,

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,
379: p_settlement_id number,

Line 408: CURSOR cur_cr_bal(cp_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,cp_org_id number,cp_location_id number)

404: (SELECT party_id, location_id FROM JAI_RGM_BALANCE_T where request_id=p_request_id
405: );
406:
407: /*uncommeneted the code done in bug#8671217 for bug#12706846*/
408: CURSOR cur_cr_bal(cp_regime_id JAI_RGM_DEFINITIONS.regime_id%TYPE,cp_org_id number,cp_location_id number)
409: IS
410: SELECT
411: --(credit_balance - debit_balance) cr_balance, 8671217
412: ( sum(nvl(credit_balance,0))-sum(nvl(debit_balance,0))) cr_balance ,

Line 827: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784

823: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.punch_settlement_id';
824:
825: CURSOR cur_regime_code IS /* 4245365*/
826: SELECT regime_code
827: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784
828: WHERE regime_id = p_regime_id;
829: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;
830:
831: BEGIN

Line 829: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;

825: CURSOR cur_regime_code IS /* 4245365*/
826: SELECT regime_code
827: FROM JAI_RGM_DEFINITIONS -- ADDED BY SACSETHI ON 30-01-2007 FOR BUG 5631784
828: WHERE regime_id = p_regime_id;
829: lv_regime JAI_RGM_DEFINITIONS.regime_code%TYPE;
830:
831: BEGIN
832: OPEN cur_regime_code; /* 4245365*/
833: FETCH cur_regime_code INTO lv_regime;

Line 903: FROM JAI_RGM_DEFINITIONS

899: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;
900:
901: CURSOR c_regime_code IS
902: SELECT regime_code
903: FROM JAI_RGM_DEFINITIONS
904: WHERE regime_id = p_regime_id;
905: -- ld_trx_date DATE; /* commented by ssawant for bug 5662296*/
906: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
907:

Line 906: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

902: SELECT regime_code
903: FROM JAI_RGM_DEFINITIONS
904: WHERE regime_id = p_regime_id;
905: -- ld_trx_date DATE; /* commented by ssawant for bug 5662296*/
906: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
907:
908: /*Bug 5879769 bduvarag start*/
909:
910: CURSOR cur_inv_payment

Line 1037: jai_rgm_definitions jrg

1033: AND source_trx_type = 'Invoice Payment'
1034: AND settlement_id = ( SELECT MAX(jbal.settlement_id)
1035: FROM jai_rgm_stl_balances jbal,
1036: jai_rgm_settlements jstl,
1037: jai_rgm_definitions jrg
1038: WHERE jbal.settlement_id = jstl.settlement_id
1039: AND jrg.regime_id = jstl.regime_id
1040: AND jrg.regime_code = 'VAT'
1041: AND jstl.primary_registration_no = p_regn_no

Line 1064: JAI_RGM_DEFINITIONS jrg

1060: FROM jai_rgm_stl_balances jrs,
1061: ( SELECT MAX(jbal.settlement_id) settlement_id,tax_type
1062: FROM jai_rgm_stl_balances jbal,
1063: jai_rgm_settlements jstl,
1064: JAI_RGM_DEFINITIONS jrg
1065: WHERE jbal.settlement_id = jstl.settlement_id
1066: AND jrg.regime_id = jstl.regime_id
1067: AND jrg.regime_code = 'VAT'
1068: AND jstl.primary_registration_no = p_regn_no

Line 1096: JAI_RGM_DEFINITIONS jrg

1092: /* added this cursor for bug 7606212 by vumaasha */
1093: SELECT MAX(jbal.settlement_id)
1094: FROM jai_rgm_stl_balances jbal,
1095: jai_rgm_settlements jstl,
1096: JAI_RGM_DEFINITIONS jrg
1097: WHERE jbal.settlement_id = jstl.settlement_id
1098: AND jrg.regime_id = jstl.regime_id
1099: AND jrg.regime_code = 'VAT'
1100: AND jstl.primary_registration_no = p_regn_no

Line 1744: FROM JAI_RGM_DEFINITIONS

1740: IS
1741:
1742: CURSOR C_REGIME_CODE IS
1743: SELECT REGIME_CODE
1744: FROM JAI_RGM_DEFINITIONS
1745: WHERE REGIME_ID = P_REGIME_ID;
1746: -- LD_TRX_DATE DATE; /*commented by ssawant for bug 5662296*/
1747: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1748:

Line 1747: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1743: SELECT REGIME_CODE
1744: FROM JAI_RGM_DEFINITIONS
1745: WHERE REGIME_ID = P_REGIME_ID;
1746: -- LD_TRX_DATE DATE; /*commented by ssawant for bug 5662296*/
1747: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1748:
1749: /*Start addtions by mmurtuza for bug 12641455*/
1750: CURSOR cur_balances_tcs(cp_organization_type VARCHAR2, cp_organization_id NUMBER, cp_location_id NUMBER) IS
1751: SELECT SUM(credit_balance) credit_balance,

Line 1761: jai_rgm_definitions jrg

1757: (SELECT MAX(jbal.settlement_id) settlement_id,
1758: tax_type
1759: FROM jai_rgm_stl_balances jbal,
1760: jai_rgm_settlements jstl,
1761: jai_rgm_definitions jrg
1762: WHERE jbal.settlement_id = jstl.settlement_id
1763: AND jrg.regime_id = jstl.regime_id
1764: AND jrg.regime_code = 'TCS'
1765: AND jstl.primary_registration_no = P_TAN_NO

Line 1782: jai_rgm_definitions jrg

1778: CURSOR cur_last_settlement_id_tcs(cp_organization_type VARCHAR2, cp_organization_id NUMBER, cp_location_id NUMBER) IS
1779: SELECT MAX(jbal.settlement_id)
1780: FROM jai_rgm_stl_balances jbal,
1781: jai_rgm_settlements jstl,
1782: jai_rgm_definitions jrg
1783: WHERE jbal.settlement_id = jstl.settlement_id
1784: AND jrg.regime_id = jstl.regime_id
1785: AND jrg.regime_code = 'TCS'
1786: AND jstl.primary_registration_no = P_TAN_NO

Line 1801: jai_rgm_definitions jrg

1797: AND settlement_id =
1798: (SELECT MAX(jbal.settlement_id)
1799: FROM jai_rgm_stl_balances jbal,
1800: jai_rgm_settlements jstl,
1801: jai_rgm_definitions jrg
1802: WHERE jbal.settlement_id = jstl.settlement_id
1803: AND jrg.regime_id = jstl.regime_id
1804: AND jrg.regime_code = 'TCS'
1805: AND jstl.primary_registration_no = P_TAN_NO

Line 1993: FROM JAI_RGM_DEFINITIONS

1989: -- for TCS
1990:
1991: CURSOR CUR_REGIME_CODE(CP_REGIME_ID NUMBER)
1992: IS SELECT REGIME_CODE
1993: FROM JAI_RGM_DEFINITIONS
1994: WHERE REGIME_ID = CP_REGIME_ID;
1995: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1996:
1997:

Line 1995: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;

1991: CURSOR CUR_REGIME_CODE(CP_REGIME_ID NUMBER)
1992: IS SELECT REGIME_CODE
1993: FROM JAI_RGM_DEFINITIONS
1994: WHERE REGIME_ID = CP_REGIME_ID;
1995: LV_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE;
1996:
1997:
1998:
1999: BEGIN

Line 2160: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;

2156: ln_cess_debit_amt NUMBER;
2157: ln_discounted_amt NUMBER;
2158: ln_charge_account_id NUMBER;
2159: ln_cess_amount NUMBER;
2160: lv_regime_code JAI_RGM_DEFINITIONS.regime_code%TYPE;
2161: ln_charge_accounting_id NUMBER;
2162: ln_balance_accounting_id NUMBER;
2163: ln_credit_amount NUMBER;
2164: ln_debit_amount NUMBER;