APPS.JAI_CMN_RGM_TAX_DIST_PKG dependencies on JAI_RGM_REGISTRATIONS

Line 485: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;

481: ) is
482: /* Added by Ramananda for bug#4407165 */
483: lv_object_name CONSTANT VARCHAR2(61) := 'jai_cmn_rgm_tax_dist_pkg.calculate_balances_for_ou';
484: lv_source_trx_type jai_rgm_trx_records.source_trx_type%TYPE ;--rchandan for bug#4428980
485: lv_reg_type jai_rgm_registrations.registration_type%TYPE ;
486:
487: CURSOR c_regime_code IS
488: SELECT regime_code
489: FROM JAI_RGM_DEFINITIONS

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

1321: ln_transfer_Dest_id NUMBER;
1322: ln_transfer_dest_line_id NUMBER;
1323: lv_transfer_num VARCHAR2(30);
1324: lv_source VARCHAR2(30);
1325: v_register_type JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ;--Added by CSahoo, BUG#5073553
1326: lv_rep_register_type VARCHAR2(15);--added for bug#6773684
1327: ln_cess_credit_amt NUMBER;
1328: ln_cess_debit_amt NUMBER;
1329: ln_discounted_amt NUMBER;

Line 1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;

1335: ln_credit_amount NUMBER;
1336: ln_debit_amount NUMBER;
1337: lv_excise_cess CONSTANT varchar2(30) := 'EXCISE-CESS'; --rchandan for bug#4428980
1338: /*Added by CSahoo, BUG#5073553*/
1339: lv_io_register JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE;
1340: ln_receipt_id JAI_CMN_RG_23AC_II_TRXS.receipt_ref%TYPE;
1341: ld_receipt_date JAI_CMN_RG_23AC_II_TRXS.receipt_date%TYPE;
1342: lv_reference_num JAI_CMN_RG_23AC_II_TRXS.reference_num%TYPE;
1343: ln_ref_document_id JAI_CMN_RG_PLA_TRXS.ref_document_id%TYPE;

Line 2040: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,

2036:
2037:
2038: -- added, Harshita for Bug 5096787
2039: PROCEDURE create_io_register_entry (
2040: p_register_type IN JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE ,
2041: p_tax_type IN VARCHAR2 ,
2042: p_organization_id IN JAI_CMN_RG_23AC_II_TRXS.organization_id%TYPE ,
2043: p_location_id IN JAI_CMN_RG_23AC_II_TRXS.location_id%TYPE ,
2044: p_cr_basic_ed IN JAI_CMN_RG_23AC_II_TRXS.cr_basic_ed%TYPE ,

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

2254: organization_id = p_party_id
2255: AND regime_code = 'SERVICE'
2256: AND registration_type = 'OTHERS'
2257: AND attribute_code = 'DIST_PLA_RG';
2258: ln_attrval_dist_plarg JAI_RGM_REGISTRATIONS.ATTRIBUTE_VALUE%TYPE := NULL;
2259: BEGIN
2260: /*
2261: || Determine the register for the given OU based on the "Service Tax distribution in PLA/RG" attribute setup,
2262: || set it to PLA in case no setup is found