[Home] [Help]
673:
674: ln_ex_cess_diff := nvl(ln_other_tax_credit,0) -
675: nvl(ln_other_tax_debit,0);
676:
677: UPDATE JAI_CMN_RG_OTHERS
678: SET credit = credit + ln_other_tax_credit,
679: debit = debit + ln_other_tax_debit,
680: opening_balance = opening_balance,
681: closing_balance = closing_balance + ln_ex_cess_diff
701:
702: ln_cvd_cess_diff := nvl(ln_other_tax_credit,0) -
703: nvl(ln_other_tax_debit,0);
704:
705: UPDATE JAI_CMN_RG_OTHERS
706: SET credit = credit + ln_other_tax_credit,
707: debit = debit + ln_other_tax_debit,
708: opening_balance = opening_balance,
709: closing_balance = closing_balance + ln_cvd_cess_diff
728:
729: ln_ex_sh_cess_diff := nvl(ln_other_tax_credit,0) -
730: nvl(ln_other_tax_debit,0);
731:
732: UPDATE JAI_CMN_RG_OTHERS
733: SET credit = credit + ln_other_tax_credit,
734: debit = debit + ln_other_tax_debit,
735: opening_balance = opening_balance,
736: closing_balance = closing_balance + ln_ex_sh_cess_diff
755:
756: ln_cvd_sh_cess_diff := nvl(ln_other_tax_credit,0) -
757: nvl(ln_other_tax_debit,0);
758:
759: UPDATE JAI_CMN_RG_OTHERS
760: SET credit = credit + ln_other_tax_credit,
761: debit = debit + ln_other_tax_debit,
762: opening_balance = opening_balance,
763: closing_balance = closing_balance + ln_cvd_sh_cess_diff
1007: that passes cenvat accounting and register entries. this change is made from an extensible perspective of breakup
1008: - added the following procedures
1009: - get_vendor_changed_dtls : Retuns the changed excise vendor details as OUT Parameters
1010: - post_cenvat_processor : Updates JAI_RCV_CENVAT_CLAIMS, JAI_RCV_LINES tables with claim details
1011: - other_cenvat_rg_recording : Inserts a record into JAI_CMN_RG_OTHERS table with the parameters passed to the call
1012: - added the parameters p_process_special_reason and qty in PROCESS_TRANSACTION. These are used incase the accounting
1013: and rg entries should consider these values for TAX_BREAUP instead of main transaction values.
1014: These parameters are mainly added for RECEIPTS DEPLUG to support second Claim functionality of CGIN items
1015: - COMMENTED the code related to AUTO Claim of 2nd 50% of RECEIVE transaction to the tune of RETURN TO VENDOR
2707: lv_statement_id VARCHAR2(5);
2708: ln_other_tax_credit NUMBER;
2709: ln_other_tax_debit NUMBER;
2710: lv_register_type JAI_CMN_RG_23AC_II_TRXS.register_type%TYPE;
2711: lv_source_register JAI_CMN_RG_OTHERS.source_register%TYPE;
2712:
2713: BEGIN
2714:
2715: if lb_rg_debug then
5043: ELSIF p_source_register = jai_constants.reg_receipt_cenvat THEN
5044: ln_source_type := jai_constants.reg_receipt_cenvat_code;
5045: END IF;
5046:
5047: INSERT INTO JAI_CMN_RG_OTHERS(
5048: rg_other_id, source_type, source_register,
5049: source_register_id, tax_type, credit, debit,
5050: created_by, creation_date, last_updated_by, last_update_date
5051: ) VALUES (
5048: rg_other_id, source_type, source_register,
5049: source_register_id, tax_type, credit, debit,
5050: created_by, creation_date, last_updated_by, last_update_date
5051: ) VALUES (
5052: JAI_CMN_RG_OTHERS_S.nextval, ln_source_type, p_source_register,
5053: p_source_register_id, p_tax_type, p_credit, p_debit,
5054: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate
5055: );
5056: EXCEPTION
5371: ELSIF lv_process_flag = jai_constants.successful THEN
5372:
5373: p_codepath := jai_general_pkg.plot_codepath(11, p_codepath);
5374: IF pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess <> 0 THEN /* This if condition and its else added by ssumaith - bug# 4187859*/
5375: jai_cmn_rg_others_pkg.check_balances(
5376: p_organization_id => p_organization_id ,
5377: p_location_id => p_location_id,
5378: p_register_type => lv_cess_pref1_register,
5379: p_trx_amount => pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess,
5397: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5398: --start
5399: ELSIF nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0) <> 0 THEN
5400:
5401: jai_cmn_rg_others_pkg.check_sh_balances(
5402: p_organization_id => p_organization_id ,
5403: p_location_id => p_location_id,
5404: p_register_type => lv_cess_pref1_register,
5405: p_trx_amount => nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0),
5467:
5468: p_codepath := jai_general_pkg.plot_codepath(19, p_codepath);
5469:
5470: IF pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess <> 0 THEN /* This if condition and its else added by ssumaith - bug# 4187859*/
5471: jai_cmn_rg_others_pkg.check_balances(
5472: p_organization_id => p_organization_id ,
5473: p_location_id => p_location_id,
5474: p_register_type => lv_cess_pref2_register,
5475: p_trx_amount => pr_tax.excise_edu_cess + pr_tax.cvd_edu_cess,
5496: /*added the following by vkaranam for budget 07 impact - bug#5989740*/
5497: --start
5498: ELSIF nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0) <> 0 THEN
5499:
5500: jai_cmn_rg_others_pkg.check_sh_balances(
5501: p_organization_id => p_organization_id ,
5502: p_location_id => p_location_id,
5503: p_register_type => lv_cess_pref2_register,
5504: p_trx_amount => nvl(pr_tax.sh_exc_edu_cess,0) + nvl(pr_tax.sh_cvd_edu_cess,0),