eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OM_WSH_PKG dependencies on JAI_OM_RG_PKG

Line 569: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'

565: /*
566: || Start of bug 4566054
567: ||Code added by aiyer for the bug 4566054
568: ||Get the total cess amount at the delivery detail level
569: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'
570: */
571: CURSOR cur_get_del_det_cess_amt (cp_delivery_detail_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
572: IS
573: SELECT

Line 742: 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 ,

738: None
739:
740: 29. 2003/07/31 SSUMAITH Bug # 2769440 File Version 616.3 (GL Link)
741:
742: 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 ,
743: ja_in_pla_entry and Ja_In_Rg23d_Entry.
744:
745: Dependency Introduced Due to this Bug : -
746: This patch has dependency on all further patches using this object.

Line 779: jai_om_rg_pkg was rounded off (using a round function to 0 decimal values) so that all values of columns basic,

775:
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

Line 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

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
785: have been rounded off at the cursor get_total_excise_amt level itself, as these values should always be in INR.
786:
787:

Line 810: it to the jai_om_rg_pkg .

806:
807: For excise exempted transactions, modvat entry was happening only for the first line.
808: The reason this happens because the value being fetched was only of the first record.
809: This has been corrected by calculating the excise exempted amount correctly and passing
810: it to the jai_om_rg_pkg .
811:
812: 35. 11-Nov-2003 Aiyer - Bug #3249375 File Version 617.1
813: References to JA_IN_OE_ST_FORMS_HDR table, which has been obsolete post IN60105D1 patchset, was found
814: in this file in some cursors.

Line 875: This was happening as the code that calls the jai_om_rg_pkg package to insert records into any of the amount

871: However, the same is not currently happening.
872:
873: Reason: -
874: ======
875: This was happening as the code that calls the jai_om_rg_pkg package to insert records into any of the amount
876: 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
877: a 'CT3' type of exemption.
878:
879: Fix :-

Line 1018: Added 2 new parametes p_cess_amt and p_source to jai_om_rg_pkg.ja_in_rg_i_entry package.

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.
1019: This has been populated from this and jai_om_wsh_pkg.process_delivery procedure.
1020:
1021: A migration script has been provided to migrate the value for cess and source.
1022:

Line 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

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.

Line 1110: and pass the same to jai_om_rg_pkg.ja_in_rg_i_entry.

1106:
1107: 61. 17-Dec-2012 mmurtuza for bug 15971482
1108: Description: INDIA - RG1 REGISTER REPORT SHOWING THE EXCISE PERCENTAGE WRONGLY
1109: Fix: Commented the fix done for bug 4185392. Also added cursor c_excise_base_tax_amt to fetch base tax amount of excise tax
1110: and pass the same to jai_om_rg_pkg.ja_in_rg_i_entry.
1111:
1112:
1113: 62. 31-Dec-2012 nkodkan for the bug 16014905
1114: Description: RG1 REGISTER ENTRY FORM SHOWING THE ASSESSABLE VALUE IN FOREIGN CURRENCY

Line 1119: Fix : removed the v_converted_rate which is multiplying with ln_total_of_base_tax in a call jai_om_rg_pkg.ja_in_rg_i_entry

1115: Fix : Multiplied the Assessable Value and excise amount with conversion rate (v_converted_rate)
1116:
1117: 63. 21-Jan-2013 nkodakan for the bug 16197185
1118: Description: RG1 REGISTER ENTRY FORM SHOWING THE ASSESSABLE VALUE IN FOREIGN CURRENCY
1119: Fix : removed the v_converted_rate which is multiplying with ln_total_of_base_tax in a call jai_om_rg_pkg.ja_in_rg_i_entry
1120:
1121: 64. 19-FEB-2013 nkodakan for the bug 16353242
1122: Description : TIME STAMP FOR EXCISE INVOICE IS NOT COMING IN JAI_OM_WSH_LINES_ALL TABLE
1123: Fix : Removed the TRUNC function for v_actual_shipment_date

Line 1150: 616.3 2769440 IN60104D1 + jai_om_rg_pkg.sql Ssumaith 31/07/2003 GL Link Enhancement.

1146: ----------------------------------------------------------------------------------------------------------------------------------------------------
1147: 616.1 3032569 IN60104D1 None -- Aiyer 24/07/2003 Row introduces to start dependency tracking
1148:
1149:
1150: 616.3 2769440 IN60104D1 + jai_om_rg_pkg.sql Ssumaith 31/07/2003 GL Link Enhancement.
1151: 2801751 + ja_in_gl_interface_new.sql
1152: 2769440
1153:
1154: 616.4 3021588 IN60104D1 + ssumaith 22/08/2003 Bond Register Enhancement

Line 1270: jai_om_rg_pkg.gl_accounting_date :=v_actual_shipment_date; --replaced v_date for bug#7354983

1266: The concurrent submission date needs to be the excise invoice date and
1267: transaction date in the rg registers and the same date should be
1268: the accounting date in gl_interface.
1269: */
1270: jai_om_rg_pkg.gl_accounting_date :=v_actual_shipment_date; --replaced v_date for bug#7354983
1271:
1272:
1273: --Anuradha Parthasarathy
1274: v_created_by := Each_record.created_by ;

Line 1858: ||hence calculate the cess and pass it to the procedure jai_om_rg_pkg.ja_in_rg_i_entry with source as 'WSH'

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);
1862: FETCH cur_get_del_det_cess_amt INTO ln_del_det_totcess_amt;

Line 1917: jai_om_rg_pkg.ja_in_rg_i_entry(

1913:
1914: /*
1915: || Ends here additions by ssumaith - bug# 4185392
1916: */
1917: jai_om_rg_pkg.ja_in_rg_i_entry(
1918: v_fin_year ,
1919: v_organization_id ,
1920: v_location_id ,
1921: v_inventory_item_id ,

Line 1972: jai_om_rg_pkg.ja_in_rg23_part_i_entry(

1968: The basic , additional and others amount in the JAI_CMN_RG_23AC_I_TRXS table should be
1969: should be rounded off
1970: */
1971:
1972: jai_om_rg_pkg.ja_in_rg23_part_i_entry(
1973: v_qty_reg_type ,
1974: v_fin_year ,
1975: v_organization_id ,
1976: v_location_id ,

Line 2050: jai_om_rg_pkg.ja_in_rg23_part_II_entry(

2046: Shifted the conversion to INR currency and rounding off at the cursor level itself.
2047: refer cursor get_total_excise_amt.
2048: */
2049:
2050: jai_om_rg_pkg.ja_in_rg23_part_II_entry(
2051: v_register_code ,
2052: v_rg_type ,
2053: v_fin_year ,
2054: v_organization_id ,

Line 2099: jai_om_rg_pkg.ja_in_pla_entry(

2095: Shifted the conversion to INR currency and rounding off at the cursor level itself.
2096: refer cursor get_total_excise_amt.
2097: */
2098:
2099: jai_om_rg_pkg.ja_in_pla_entry(
2100: v_organization_id ,
2101: v_location_id ,
2102: v_inventory_item_id ,
2103: v_fin_year ,

Line 2222: jai_om_rg_pkg.ja_in_register_txn_entry(

2218: Shifted the conversion to INR currency and rounding off at the cursor level itself.
2219: refer cursor get_total_excise_amt.
2220: */
2221:
2222: jai_om_rg_pkg.ja_in_register_txn_entry(
2223: v_organization_id ,
2224: v_location_id ,
2225: v_exc_invoice_no ,
2226: 'BOND SALES' ,

Line 2393: jai_om_rg_pkg.Ja_In_Rg23d_Entry(

2389: SELECT JAI_CMN_RG_23D_TRXS_S.NEXTVAL INTO v_register_id FROM Dual;
2390:
2391: lv_statement_no := '59';
2392:
2393: jai_om_rg_pkg.Ja_In_Rg23d_Entry(
2394: v_register_id ,
2395: v_organization_id ,
2396: v_location_id ,
2397: v_fin_year ,

Line 2604: preference , the call to the ja_in_pla_entry procedure of the jai_om_rg_pkg is being called.

2600: Otherwise the patch would certainly fail.
2601:
2602: 2. 2003/03/13 Sriram . Bug # 2796717
2603: Cenvat Reversal Accounting was not happening correctly.The reason was that if PLA is the
2604: preference , the call to the ja_in_pla_entry procedure of the jai_om_rg_pkg is being called.
2605: The PLA Entry does not consider different accounting for Excise Exempted transaction.
2606: This is the desired functionality . Hence added code to see that , if balance is available in
2607: the RG23A register , then hit the register and the accounting happens correctly for
2608: excise exempted transactions.If balances are not available for RG23A register , then