[Home] [Help]
1769: p_last_update_date DATE ,
1770: p_last_updated_by NUMBER ,
1771: p_last_update_login NUMBER ,
1772: p_assessable_value NUMBER ,
1773: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1774: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1775: 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 */
1776: ) IS
1777:
1770: p_last_updated_by NUMBER ,
1771: p_last_update_login NUMBER ,
1772: p_assessable_value NUMBER ,
1773: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1774: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1775: 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 */
1776: ) IS
1777:
1778: --parameter for assessable value added
1771: p_last_update_login NUMBER ,
1772: p_assessable_value NUMBER ,
1773: p_cess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE DEFAULT NULL ,
1774: p_sh_cess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE DEFAULT NULL , /*Bug 5989740 bduvarag*/
1775: 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 */
1776: ) IS
1777:
1778: --parameter for assessable value added
1779: v_serial_no NUMBER := 0;
1861: organization_id = p_org_id;
1862:
1863: CURSOR serial_no_cur IS
1864: SELECT NVL(MAX(slno),0), (NVL(MAX(slno),0) + 1)
1865: FROM JAI_CMN_RG_I_TRXS
1866: WHERE organization_id = p_org_id AND
1867: location_id = p_location_id AND
1868: inventory_item_id = p_inventory_item_id AND
1869: fin_year = p_fin_year;
1869: fin_year = p_fin_year;
1870:
1871: CURSOR packed_loose_qty_cur(p_previous_serial_no IN NUMBER) IS
1872: SELECT NVL(balance_packed,0), NVL(balance_loose,0)
1873: FROM JAI_CMN_RG_I_TRXS
1874: WHERE organization_id = p_org_id AND
1875: location_id = p_location_id AND
1876: inventory_item_id = p_inventory_item_id AND
1877: fin_year = p_fin_year AND
1964:
1965: 9. 09/02/2004 Vijay Shankar for Bug# 3408210, File Version: 618.1
1966: 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
1967: to hit To_other_factory_n_pay_ed_qty field with quantity. transactions is identified as CT3 by fetching data from
1968: 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
1969: in case of CT3 transaction. following fields are added in the procedure
1970: v_to_other_fact_n_pay_ed_qty NUMBER;
1971: v_to_other_fact_n_pay_ed_val NUMBER;
1972: v_exc_exempt_dtls_rec c_exc_exempt_dtls%ROWTYPE;
2036: Issue :-
2037: Rg does not show correct cess value in case of Shipment transactions.
2038:
2039: Fix:-
2040: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
2041: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
2042: as 'WSH' from jai_om_wsh.plb procedure Shipment.
2043: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
2044: 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
2040: Two fields cess_amt and source have been added in JAI_CMN_RG_I_TRXS table.
2041: The cess amt and source would be populated from jai_jar_t_aru_t1 (Source -> 'AR' ) and
2042: as 'WSH' from jai_om_wsh.plb procedure Shipment.
2043: Corresponding changes have been done in the form JAINIRGI.fmb and JAFRMRG1.rdf .
2044: 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
2045: exactly matches the jai_om_wsh_lines_all.delivery_detail_id and jai_ar_trxs.customer_trx_id the tracking of the source
2046: becomes very difficult hence to have a clear demarcation between WSh and AR sources hence the source field has been added.
2047:
2048: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.
2050:
2051: A migration script has been provided to migrate the value for cess and source.
2052:
2053: Dependency due to this bug:-
2054: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
2055: 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
2056: 3. Modified the trigger jai_jar_t_aru_t1
2057: 4. Procedure jai_om_wsh_pkg.process_delivery
2058: 5. Report JAICMNRG1.rdf
2051: A migration script has been provided to migrate the value for cess and source.
2052:
2053: Dependency due to this bug:-
2054: 1. Datamodel change in table JAI_CMN_RG_I_TRXS, added the cess_amt and source fields
2055: 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
2056: 3. Modified the trigger jai_jar_t_aru_t1
2057: 4. Procedure jai_om_wsh_pkg.process_delivery
2058: 5. Report JAICMNRG1.rdf
2059: 6. Created a migration script to populate cess_amt and source for Shipment and Receivable transactions.
2234: OPEN packed_loose_qty_cur(v_previous_serial_no);
2235: FETCH packed_loose_qty_cur INTO v_balance_packed, v_balance_loose;
2236: CLOSE packed_loose_qty_cur;
2237: */
2238: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
2239: v_balance_loose := ja_in_rgi_balance(p_org_id,p_location_id,p_inventory_item_id,p_fin_year,
2240: v_previous_serial_no,v_balance_packed);
2241:
2242: IF NVL(v_previous_serial_no,0) = 0 then
2294: END IF;
2295: END IF;
2296: */
2297:
2298: INSERT INTO JAI_CMN_RG_I_TRXS(
2299: Register_ID ,
2300: Fin_Year ,
2301: SLNO ,
2302: Organization_id ,
2346: sh_cess_amt , /*Bug 5989740 bduvarag*/
2347: source
2348:
2349: ) VALUES (
2350: jai_cmn_rg_i_trxs_s.nextval ,
2351: p_fin_year ,
2352: v_serial_no ,
2353: p_org_id ,
2354: p_location_id ,
4782: p_balance_packed out NOCOPY number) return number
4783: is
4784: Cursor c_yearslno is
4785: select fin_year,max(slno)
4786: from JAI_CMN_RG_I_TRXS
4787: where organization_id = p_organization_id
4788: and location_id = p_location_id
4789: and inventory_item_id = p_inventory_item_id
4790: group by fin_year
4791: order by fin_year desc;
4792:
4793: Cursor c_fetchbalance(cp_balyear number,cp_slno number) is
4794: select NVL(balance_packed,0), NVL(balance_loose,0)
4795: from JAI_CMN_RG_I_TRXS
4796: where organization_id = p_organization_id
4797: and location_id = p_location_id
4798: and inventory_item_id = p_inventory_item_id
4799: and fin_year = cp_balyear