APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 160: Added the table jai_rgm_registrations table.

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
163: Added the condition jrr.organization_id=nvl(p_org_id,jrr.organization_id)
164: as per review comments

Line 899: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;

895: ) is
896: /* Added by Ramananda for bug#4407165 */
897: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_ou';
898: lv_source_trx_type jai_rgm_trx_records.source_trx_type%TYPE ;--rchandan for bug#4428980
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

Line 1856: JAI_RGM_REGISTRATIONS JOR --added for bug#9005474

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
1860: AND JOR.REGISTRATION_TYPE = 'TAX_TYPES'

Line 2153: v_register_type JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;--Added by CSahoo, BUG#5073553

2149: ln_transfer_Dest_id NUMBER;
2150: ln_transfer_dest_line_id NUMBER;
2151: lv_transfer_num VARCHAR2(30);
2152: lv_source VARCHAR2(30);
2153: v_register_type JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;--Added by CSahoo, BUG#5073553
2154: lv_rep_register_type VARCHAR2(15);--added for bug#6773684
2155: ln_cess_credit_amt NUMBER;
2156: ln_cess_debit_amt NUMBER;
2157: ln_discounted_amt NUMBER;

Line 2167: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

2163: ln_credit_amount NUMBER;
2164: ln_debit_amount NUMBER;
2165: lv_excise_cess CONSTANT varchar2(30) := 'EXCISE-CESS'; --rchandan for bug#4428980
2166: /*Added by CSahoo, BUG#5073553*/
2167: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
2168: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
2169: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
2170: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
2171: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;

Line 3013: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,

3009:
3010:
3011: -- added, Harshita for Bug 5096787
3012: PROCEDURE create_io_register_entry (
3013: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
3014: p_tax_type IN VARCHAR2 ,
3015: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
3016: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
3017: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,

Line 3248: ln_attrval_dist_plarg JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE := NULL;

3244: organization_id = p_party_id
3245: AND regime_code = 'SERVICE'
3246: AND registration_type = 'OTHERS'
3247: AND attribute_code = 'DIST_PLA_RG';
3248: ln_attrval_dist_plarg JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE := NULL;
3249: BEGIN
3250: /*
3251: || Determine the register for the given OU based on the "Service Tax distribution in PLA/RG" attribute setup,
3252: || set it to PLA in case no setup is found