[Home] [Help]
581: jsptl.tax_id = jtc.tax_id AND
582: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND
583: jspl.delivery_detail_id = cp_delivery_detail_id;
584:
585: ln_del_det_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
586: /* End of bug 4566054 */
587:
588: /*START, Bgowrava for forward porting bug#5989740*/
589: CURSOR cur_get_del_det_sh_cess_amt (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
601: jai_constants.tax_type_sh_exc_edu_cess)
602: AND
603: jspl.delivery_detail_id = cp_delivery_detail_id;
604:
605: ln_del_det_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;
606:
607: /*END, Bgowrava for forward porting bug#5989740*/
608:
609: /* Bug4562791. Added by Lakshmi Gopalsami */
776: Fix of Bug 3158282: -
777: 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
778: in the procedures ja_in_rg_I_entry and ja_in_rg23_part_I_entry of the package
779: jai_om_rg_pkg was rounded off (using a round function to 0 decimal values) so that all values of columns basic,
780: additional and other amounts passed to the tables JAI_CMN_RG_I_TRXS, JAI_CMN_RG_23AC_I_TRXS table
781: get rounded off.
782:
783: 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
784: the values of fields being passed i.e basic_excise_duty_amount, add_excise_duty_amount, oth_excise_duty_amount and excise_amount
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:
955: Excise Duty rate was going in as zero in JAI_CMN_RG_I_TRXS table. This was because the variable
956: corresponding to the excise_duty_rate parameter in the ja_in_rg_i_entry procedure was
957: explicitly set to zero.
958:
959: This has been changed and made as excise_duty_amount divided by (assessable value * shipped quantity).
974: 45. 06-Jul-2005 Ramananda for bug#4477004. File Version: 116.5
975: GL Sources and GL Categories got changed. Refer bug for the details
976:
977: 46. 9-Aug-2005 Ramananda for bug#4543424. File version 120.2
978: Excise Duty rate was going as fractions in JAI_CMN_RG_I_TRXS table.
979: This is because the excise amount is rounded off at the shipment level and when the rate is recalculated
980: it is calculated as excise amount divided by assessable value * 100. This results in rounding issue.
981:
982: This has been resolved by making the following changes.
1006: Issue :-
1007: Rg does not show correct cess value in case of Shipment transactions.
1008:
1009: Fix:-
1010: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
1011: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
1012: as 'WSH' from jai_om_wsh.plb procedure Shipment.
1013: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
1014: 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
1010: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
1011: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
1012: as 'WSH' from jai_om_wsh.plb procedure Shipment.
1013: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
1014: 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
1015: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
1016: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
1017:
1018: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
1020:
1021: A migration script has been provided to migrate the value for cess and source.
1022:
1023: Dependency due to this bug:-
1024: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1025: 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
1026: 3. Modified the trigger jai_jar_t_aru_t1
1027: 4. Procedure jai_om_wsh_pkg.process_delivery
1028: 5. Report JAICMNRG1.rdf
1021: A migration script has been provided to migrate the value for cess and source.
1022:
1023: Dependency due to this bug:-
1024: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1025: 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
1026: 3. Modified the trigger jai_jar_t_aru_t1
1027: 4. Procedure jai_om_wsh_pkg.process_delivery
1028: 5. Report JAICMNRG1.rdf
1029: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
1853:
1854: /*
1855: || Start of bug 4566054
1856: ||Code added by aiyer for the bug 4566054
1857: ||The cess amount is also being maintained in JAI_CMN_RG_I_TRXS table at a delivery_detail_level
1858: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
1859: */
1860:
1861: OPEN cur_get_del_det_cess_amt (cp_delivery_detail_id => each_record.delivery_detail_id);
1874: lv_statement_no := '30';
1875:
1876: /*
1877: || Code modified by aiyer for the fix of the bug #3158282
1878: || The basic , additional and others amount in the JAI_CMN_RG_I_TRXS table should be
1879: || should be rounded off
1880: */
1881:
1882: /*
1950: jai_constants.source_wsh
1951: );
1952:
1953: lv_statement_no := '31';
1954: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1955: 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 );
1956: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1957: v_qty_reg_type := 'C';
1958:
2134: END IF;
2135:
2136: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2137:
2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2139: IF v_reg_type IN( 'RG23A','RG23C') THEN
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';
2143: UPDATE
2144: JAI_CMN_RG_I_TRXS
2145: SET
2146: register_id_part_ii = v_rg23_part_ii_no,
2147: charge_account_id = (SELECT
2148: charge_account_id
2157: lv_statement_no := '38';
2158: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2159: lv_statement_no := '39';
2160: UPDATE
2161: JAI_CMN_RG_I_TRXS
2162: SET
2163: register_id_part_ii = v_pla_register_no,
2164: charge_account_id = (
2165: SELECT CHARGE_ACCOUNT_ID