[Home] [Help]
1654: 8 03/07/2002 Nagaraj.s - For Enh#2415656.
1655: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
1656: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
1657: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
1658: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
1659: for exempted amount.
1660: Before sending this patch it has to be taken care that, the alter scripts,functions should also
1661: accompany the patch otherwise the patch would certainly fail.
1662:
1859: The change done in this object is to pass the additional parameters correctly to the functions.
1860:
1861: Dependency Due to this Bug:-
1862: The current trigger becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
1863: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
1864:
1865: 23. 2005/03/15 brathod - Bug#4215808- File version 115.5
1866: Trigger modified for VAT Implementation.
1867: New VAT fields in JAI_OM_WSH_LINES_ALL are populated by fetching them
3078: END IF;
3079: v_exempt_bal := (NVL(v_exempt_bal, 0) + v_shipped_quantity * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
3080: --*********************************************************************************************************
3081: IF v_debug_flag ='Y' THEN
3082: 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);
3083: END IF;
3084: --Calling the Function by Nagaraj.s for Enh#2415656............................
3085:
3086: /*
3099: close c_sh_cess_amount;
3100: -- end Bgowrava for forward porting bug#5989740
3101:
3102:
3103: v_reg_type := jai_om_wsh_pkg.get_excise_register_with_bal
3104: (v_pref_rg23a,
3105: v_pref_rg23c,
3106: v_pref_pla,
3107: NVL(v_ssi_unit_flag,'N'),
3126: lv_process_message
3127: );
3128: --Ends here......................................
3129: IF v_debug_flag ='Y' THEN
3130: 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);
3131: END IF;
3132: --*********************************************************************************************************
3133: v_basic_ed_amt := v_exempt_bal;
3134: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;