[Home] [Help]
670:
671: 19 2002/07/03 Nagaraj.s - For Enh#2415656.
672: Cursors pref_cur - Incorporated v_export_oriented_unit also in the select clause
673: RG Bal Cur- Incorporated basic,additional,other pla balance also in the select clause.
674: Functions jai_om_wsh_processing_pkg.excise_balance_check - for preference checks in case of EOU and Non-EOU for total excise amount
675: jai_om_wsh_pkg.get_excise_register_with_bal - for preference checks in case of EOU and Non-EOU
676: for exempted amount.
677: Before sending this patch it has to be taken care that, the alter scripts,functions should also
678: accompany the patch otherwise the patch would certainly fail.
939: The basic business logic validation is that both cess and excise should be available as
940: part of the same register type and the register preference setup at the organization additional information
941: needs to be considered for picking up the correct register .
942:
943: This code object calls the functions jai_om_wsh_processing_pkg.excise_balance_check_f and jai_om_wsh_pkg.get_excise_register_with_bal_f
944: which have had changes in their signature and hence the caller also needs to pass the correct
945: parameters.
946:
947: The change done in this object is to pass the additional parameters correctly to the functions.
946:
947: The change done in this object is to pass the additional parameters correctly to the functions.
948:
949: Dependency Due to this Bug:-
950: The current procedure becomes dependent on the functions jai_om_wsh_processing_pkg.excise_balance_check (version 115.1) and
951: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
952:
953: 42. 2005/02/16 ssumaith - bug# 4185392 - File version 115.4
954:
1162:
1163:
1164: 115.3 4171272 IN60106 +
1165: 4147608 jai_om_wsh_pkg.get_excise_register_with_bal_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1166: jai_om_wsh_processing_pkg.excise_balance_check_f.sql 115.1 ssumaith 11/02/2005 New parameters added to function.
1167:
1168: 12.0 4566054 jai_om_rg.pls 120.3 Aiyer 24-Aug-2005
1169: jai_om_rg.plb 120.4
1170: jai_om_wsh.plb (jai_om_wsh_pkg.process_delivery) 120.4
1580: open c_sh_cess_amount(p_delivery_id);
1581: fetch c_sh_cess_amount into ln_sh_cess_amount;
1582: close c_sh_cess_amount;
1583:
1584: v_reg_type:= jai_om_wsh_processing_pkg.excise_balance_check(
1585: v_pref_rg23a ,
1586: v_pref_rg23c ,
1587: v_pref_pla ,
1588: NVL(v_ssi_unit_flag,'N') ,