[Home] [Help]
1894: 8 03/07/2002 Nagaraj.s - For Enh#2415656.
1895: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
1896: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
1897: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
1898: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
1899: for exempted amount.
1900: Before sending this patch it has to be taken care that, the alter scripts,functions should also
1901: accompany the patch otherwise the patch would certainly fail.
1902:
2099: The change done in this object is to pass the additional parameters correctly to the functions.
2100:
2101: Dependency Due to this Bug:-
2102: The current trigger becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
2103: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
2104:
2105: 23. 2005/03/15 brathod - Bug#4215808- File version 115.5
2106: Trigger modified for VAT Implementation.
2107: New VAT fields in JAI_OM_WSH_LINES_ALL are populated by fetching them
3451: END IF;
3452: v_exempt_bal := (NVL(v_exempt_bal, 0) + v_shipped_quantity * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
3453: --*********************************************************************************************************
3454: IF v_debug_flag ='Y' THEN
3455: UTL_FILE.PUT_LINE(v_myfilehandle,'12 BEFORE the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_exempt_bal -> '|| v_exempt_bal);
3456: END IF;
3457: --Calling the Function by Nagaraj.s for Enh#2415656............................
3458:
3459: /*
3472: close c_sh_cess_amount;
3473: -- end Bgowrava for forward porting bug#5989740
3474:
3475:
3476: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal
3477: (v_pref_rg23a,
3478: v_pref_rg23c,
3479: v_pref_pla,
3480: NVL(v_ssi_unit_flag,'N'),
3499: lv_process_message
3500: );
3501: --Ends here......................................
3502: IF v_debug_flag ='Y' THEN
3503: UTL_FILE.PUT_LINE(v_myfilehandle,'13 AFTER the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_reg_type -> '|| v_reg_type);
3504: END IF;
3505: --*********************************************************************************************************
3506: v_basic_ed_amt := v_exempt_bal;
3507: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;