[Home] [Help]
553: jsptl.tax_id = jtc.tax_id AND
554: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND
555: jspl.delivery_detail_id = cp_delivery_detail_id;
556:
557: ln_del_det_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
558: /* End of bug 4566054 */
559:
560: /*START, Bgowrava for forward porting bug#5989740*/
561: CURSOR cur_get_del_det_sh_cess_amt (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
573: jai_constants.tax_type_sh_exc_edu_cess)
574: AND
575: jspl.delivery_detail_id = cp_delivery_detail_id;
576:
577: ln_del_det_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;
578:
579: /*END, Bgowrava for forward porting bug#5989740*/
580:
581: /* Bug4562791. Added by Lakshmi Gopalsami */
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
756: the values of fields being passed i.e basic_excise_duty_amount, add_excise_duty_amount, oth_excise_duty_amount and excise_amount
923: jai_om_wsh_pkg.get_excise_register_with_bal (version 115.1) also packaged as part of this bug.
924:
925: 42. 2005/02/16 ssumaith - bug# 4185392 - File version 115.4
926:
927: Excise Duty rate was going in as zero in JAI_CMN_RG_I_TRXS table. This was because the variable
928: corresponding to the excise_duty_rate parameter in the ja_in_rg_i_entry procedure was
929: explicitly set to zero.
930:
931: This has been changed and made as excise_duty_amount divided by (assessable value * shipped quantity).
946: 45. 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.5
947: GL Sources and GL Categories got changed. Refer bug for the details
948:
949: 46. 9-Aug-2005 Ramananda for bug#4543424. File version 120.2
950: Excise Duty rate was going as fractions in JAI_CMN_RG_I_TRXS table.
951: This is because the excise amount is rounded off at the shipment level and when the rate is recalculated
952: it is calculated as excise amount divided by assessable value * 100. This results in rounding issue.
953:
954: This has been resolved by making the following changes.
978: Issue :-
979: Rg does not show correct cess value in case of Shipment transactions.
980:
981: Fix:-
982: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
983: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
984: as 'WSH' from jai_om_wsh.plb procedure Shipment.
985: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
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
982: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
983: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
984: as 'WSH' from jai_om_wsh.plb procedure Shipment.
985: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
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.
992:
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
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.
1762:
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);
1783: lv_statement_no := '30';
1784:
1785: /*
1786: || Code modified by aiyer for the fix of the bug #3158282
1787: || The basic , additional and others amount in the JAI_CMN_RG_I_TRXS table should be
1788: || should be rounded off
1789: */
1790:
1791: /*
1848: jai_constants.source_wsh
1849: );
1850:
1851: lv_statement_no := '31';
1852: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1853: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.1 ja_in_rg_I_entry is made register_id -> ' || v_part_i_register_id );
1854: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1855: v_qty_reg_type := 'C';
1856:
2032: END IF;
2033:
2034: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2035:
2036: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2037: IF v_reg_type IN( 'RG23A','RG23C') THEN
2038: lv_statement_no := '36';
2039: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2040: lv_statement_no := '37';
2038: lv_statement_no := '36';
2039: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2040: lv_statement_no := '37';
2041: UPDATE
2042: JAI_CMN_RG_I_TRXS
2043: SET
2044: register_id_part_ii = v_rg23_part_ii_no,
2045: charge_account_id = (SELECT
2046: charge_account_id
2055: lv_statement_no := '38';
2056: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2057: lv_statement_no := '39';
2058: UPDATE
2059: JAI_CMN_RG_I_TRXS
2060: SET
2061: register_id_part_ii = v_pla_register_no,
2062: charge_account_id = (
2063: SELECT CHARGE_ACCOUNT_ID