[Home] [Help]
1723: p_last_update_date DATE ,
1724: p_last_updated_by NUMBER ,
1725: p_last_update_login NUMBER ,
1726: p_assessable_value NUMBER ,
1727: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1728: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1729: p_source JAI_CMN_RG_I_TRXS.SOURCE%TYPE DEFAULT NULL /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
1730: ) IS
1731:
1724: p_last_updated_by NUMBER ,
1725: p_last_update_login NUMBER ,
1726: p_assessable_value NUMBER ,
1727: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1728: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1729: p_source JAI_CMN_RG_I_TRXS.SOURCE%TYPE DEFAULT NULL /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
1730: ) IS
1731:
1732: --parameter for assessable value added
1725: p_last_update_login NUMBER ,
1726: p_assessable_value NUMBER ,
1727: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1728: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1729: p_source JAI_CMN_RG_I_TRXS.SOURCE%TYPE DEFAULT NULL /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
1730: ) IS
1731:
1732: --parameter for assessable value added
1733: v_serial_no NUMBER := 0;
1780: organization_id = p_org_id;
1781:
1782: CURSOR serial_no_cur IS
1783: SELECT NVL(MAX(slno),0), (NVL(MAX(slno),0) + 1)
1784: FROM JAI_CMN_RG_I_TRXS
1785: WHERE organization_id = p_org_id AND
1786: location_id = p_location_id AND
1787: inventory_item_id = p_inventory_item_id AND
1788: fin_year = p_fin_year;
1788: fin_year = p_fin_year;
1789:
1790: CURSOR packed_loose_qty_cur(p_previous_serial_no IN NUMBER) IS
1791: SELECT NVL(balance_packed,0), NVL(balance_loose,0)
1792: FROM JAI_CMN_RG_I_TRXS
1793: WHERE organization_id = p_org_id AND
1794: location_id = p_location_id AND
1795: inventory_item_id = p_inventory_item_id AND
1796: fin_year = p_fin_year AND
1871:
1872: 9. 09/02/2004 Vijay Shankar for Bug# 3408210, File Version: 618.1
1873: JA_IN_RG_I_ENTRY procedure:- CT3 Excise Exempted Issue transaction is hitting RG1 with Home Use fields, which is wrong and code is modified
1874: to hit To_other_factory_n_pay_ed_qty field with quantity. transactions is identified as CT3 by fetching data from
1875: JAI_OM_WSH_LINES_ALL through a cursor c_exc_exempt_dtls. Insert into JAI_CMN_RG_I_TRXS is modified to populate specified columns
1876: in case of CT3 transaction. following fields are added in the procedure
1877: v_to_other_fact_n_pay_ed_qty NUMBER;
1878: v_to_other_fact_n_pay_ed_val NUMBER;
1879: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
1943: Issue :-
1944: Rg does not show correct cess value in case of Shipment transactions.
1945:
1946: Fix:-
1947: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
1948: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
1949: as 'WSH' from jai_om_wsh.plb procedure Shipment.
1950: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
1951: 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
1947: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
1948: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
1949: as 'WSH' from jai_om_wsh.plb procedure Shipment.
1950: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
1951: 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
1952: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
1953: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
1954:
1955: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
1957:
1958: A migration script has been provided to migrate the value for cess and source.
1959:
1960: Dependency due to this bug:-
1961: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1962: 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
1963: 3. Modified the trigger jai_jar_t_aru_t1
1964: 4. Procedure jai_om_wsh_pkg.process_delivery
1965: 5. Report JAICMNRG1.rdf
1958: A migration script has been provided to migrate the value for cess and source.
1959:
1960: Dependency due to this bug:-
1961: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
1962: 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
1963: 3. Modified the trigger jai_jar_t_aru_t1
1964: 4. Procedure jai_om_wsh_pkg.process_delivery
1965: 5. Report JAICMNRG1.rdf
1966: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
2135: END IF;
2136: END IF;
2137: */
2138:
2139: INSERT INTO JAI_CMN_RG_I_TRXS(
2140: Register_ID ,
2141: Fin_Year ,
2142: SLNO ,
2143: Organization_id ,
2187: sh_cess_amt , /*Bug 5989740 bduvarag*/
2188: source
2189:
2190: ) VALUES (
2191: jai_cmn_rg_i_trxs_s.nextval ,
2192: p_fin_year ,
2193: v_serial_no ,
2194: p_org_id ,
2195: p_location_id ,