[Home] [Help]
537: /*
538: || Start of bug 4566054
539: ||Code added by aiyer for the bug 4566054
540: ||Get the total cess amount at the delivery detail level
541: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
542: */
543: CURSOR cur_get_del_det_cess_amt (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
544: IS
545: SELECT
710: None
711:
712: 29. 2003/07/31 SSUMAITH Bug # 2769440 File Version 616.3 (GL Link)
713:
714: As part of the GL Link Enhancement , added parameters in call to the jai_om_rg_pkg's procedures ja_in_rg23_part_II_entry ,
715: ja_in_pla_entry and Ja_In_Rg23d_Entry.
716:
717: Dependency Introduced Due to this Bug : -
718: This patch has dependency on all further patches using this object.
747:
748: Fix of Bug 3158282: -
749: 1. The values passed to the parameters p_basic_ed/p_dr_basic_ed,p_additional_ed/p_dr_additional_ed and p_other_ed/p_dr_other_ed
750: in the procedures ja_in_rg_I_entry and ja_in_rg23_part_I_entry of the package
751: jai_om_rg_pkg was rounded off (using a round function to 0 decimal values) so that all values of columns basic,
752: additional and other amounts passed to the tables JAI_CMN_RG_I_TRXS, JAI_CMN_RG_23AC_I_TRXS table
753: get rounded off.
754:
755: 2. For the calls to the procedure procedures ja_in_rg23_part_II_entry,ja_in_pla_entry,ja_in_regsiter_txn_entry in the jai_om_rg_pkg
751: jai_om_rg_pkg was rounded off (using a round function to 0 decimal values) so that all values of columns basic,
752: additional and other amounts passed to the tables JAI_CMN_RG_I_TRXS, JAI_CMN_RG_23AC_I_TRXS table
753: get rounded off.
754:
755: 2. For the calls to the procedure procedures ja_in_rg23_part_II_entry,ja_in_pla_entry,ja_in_regsiter_txn_entry in the jai_om_rg_pkg
756: the values of fields being passed i.e basic_excise_duty_amount, add_excise_duty_amount, oth_excise_duty_amount and excise_amount
757: have been rounded off at the cursor get_total_excise_amt level itself, as these values should always be in INR.
758:
759:
778:
779: For excise exempted transactions, modvat entry was happening only for the first line.
780: The reason this happens because the value being fetched was only of the first record.
781: This has been corrected by calculating the excise exempted amount correctly and passing
782: it to the jai_om_rg_pkg .
783:
784: 35. 11-Nov-2003 Aiyer - Bug #3249375 File Version 617.1
785: References to JA_IN_OE_ST_FORMS_HDR table, which has been obsolete post IN60105D1 patchset, was found
786: in this file in some cursors.
843: However, the same is not currently happening.
844:
845: Reason: -
846: ======
847: This was happening as the code that calls the jai_om_rg_pkg package to insert records into any of the amount
848: registers i.e either of JAI_CMN_RG_23AC_II_TRXS or JAI_CMN_RG_PLA_TRXS was bypassed if the first one was found to contain
849: a 'CT3' type of exemption.
850:
851: Fix :-
986: For shipment and Ar receivable transaction currently the transaction_id is 33 and in some cases where the jai_cmn_rg_i_trxs.ref_doc_id
987: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
988: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
989:
990: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
991: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
992:
993: A migration script has been provided to migrate the value for cess and source.
994:
993: A migration script has been provided to migrate the value for cess and source.
994:
995: Dependency due to this bug:-
996: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
997: 2. Added two new parameters in jai_om_rg_pkg.ja_in_rg_i_entry procedure to insert data into JAI_CMN_RG_I_TRXS table
998: 3. Modified the trigger jai_jar_t_aru_t1
999: 4. Procedure jai_om_wsh_pkg.process_delivery
1000: 5. Report JAICMNRG1.rdf
1001: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
1066: ----------------------------------------------------------------------------------------------------------------------------------------------------
1067: 616.1 3032569 IN60104D1 None -- Aiyer 24/07/2003 Row introduces to start dependency tracking
1068:
1069:
1070: 616.3 2769440 IN60104D1 + jai_om_rg_pkg.sql Ssumaith 31/07/2003 GL Link Enhancement.
1071: 2801751 + ja_in_gl_interface_new.sql
1072: 2769440
1073:
1074: 616.4 3021588 IN60104D1 + ssumaith 22/08/2003 Bond Register Enhancement
1186: The concurrent submission date needs to be the excise invoice date and
1187: transaction date in the rg registers and the same date should be
1188: the accounting date in gl_interface.
1189: */
1190: jai_om_rg_pkg.gl_accounting_date :=v_actual_shipment_date; --replaced v_date for bug#7591616
1191:
1192: --Anuradha Parthasarathy
1193: v_created_by := Each_record.created_by ;
1194: v_last_update_date := Each_record.last_update_date;
1763: /*
1764: || Start of bug 4566054
1765: ||Code added by aiyer for the bug 4566054
1766: ||The cess amount is also being maintained in JAI_CMN_RG_I_TRXS table at a delivery_detail_level
1767: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
1768: */
1769:
1770: OPEN cur_get_del_det_cess_amt (cp_delivery_detail_id => each_record.delivery_detail_id);
1771: FETCH cur_get_del_det_cess_amt INTO ln_del_det_totcess_amt;
1813:
1814: /*
1815: || Ends here additions by ssumaith - bug# 4185392
1816: */
1817: jai_om_rg_pkg.ja_in_rg_i_entry(
1818: v_fin_year ,
1819: v_organization_id ,
1820: v_location_id ,
1821: v_inventory_item_id ,
1866: The basic , additional and others amount in the JAI_CMN_RG_23AC_I_TRXS table should be
1867: should be rounded off
1868: */
1869:
1870: jai_om_rg_pkg.ja_in_rg23_part_i_entry(
1871: v_qty_reg_type ,
1872: v_fin_year ,
1873: v_organization_id ,
1874: v_location_id ,
1944: Shifted the conversion to INR currency and rounding off at the cursor level itself.
1945: refer cursor get_total_excise_amt.
1946: */
1947:
1948: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
1949: v_register_code ,
1950: v_rg_type ,
1951: v_fin_year ,
1952: v_organization_id ,
1993: Shifted the conversion to INR currency and rounding off at the cursor level itself.
1994: refer cursor get_total_excise_amt.
1995: */
1996:
1997: jai_om_rg_pkg.ja_in_pla_entry(
1998: v_organization_id ,
1999: v_location_id ,
2000: v_inventory_item_id ,
2001: v_fin_year ,
2116: Shifted the conversion to INR currency and rounding off at the cursor level itself.
2117: refer cursor get_total_excise_amt.
2118: */
2119:
2120: jai_om_rg_pkg.ja_in_register_txn_entry(
2121: v_organization_id ,
2122: v_location_id ,
2123: v_exc_invoice_no ,
2124: 'BOND SALES' ,
2266: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2267:
2268: lv_statement_no := '59';
2269:
2270: jai_om_rg_pkg.Ja_In_Rg23d_Entry(
2271: v_register_id ,
2272: v_organization_id ,
2273: v_location_id ,
2274: v_fin_year ,
2471: Otherwise the patch would certainly fail.
2472:
2473: 2. 2003/03/13 Sriram . Bug # 2796717
2474: Cenvat Reversal Accounting was not happening correctly.The reason was that if PLA is the
2475: preference , the call to the ja_in_pla_entry procedure of the jai_om_rg_pkg is being called.
2476: The PLA Entry does not consider different accounting for Excise Exempted transaction.
2477: This is the desired functionality . Hence added code to see that , if balance is available in
2478: the RG23A register , then hit the register and the accounting happens correctly for
2479: excise exempted transactions.If balances are not available for RG23A register , then