APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 752: additional and other amounts passed to the tables JAI_CMN_RG_I_TRXS, JAI_CMN_RG_23AC_I_TRXS table

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

Line 1866: The basic , additional and others amount in the JAI_CMN_RG_23AC_I_TRXS table should be

1862: lv_statement_no := '32';
1863:
1864: /*
1865: Code modified by aiyer for the fix of the bug #3158282.
1866: The basic , additional and others amount in the JAI_CMN_RG_23AC_I_TRXS table should be
1867: should be rounded off
1868: */
1869:
1870: jai_om_rg_pkg.ja_in_rg23_part_i_entry(

Line 1903: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;

1899: v_last_updated_by ,
1900: v_last_update_login
1901: );
1902: lv_statement_no := '33';
1903: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1904: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.2 ja_in_rg23_part_I_entry is made, register_id -> ' || v_part_i_register_id );
1905: END IF;
1906: END IF;
1907: -- Start of Bug 3446362

Line 2075: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;

2071: END IF;
2072:
2073: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2074: lv_statement_no := '40';
2075: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2076: IF v_reg_type IN( 'RG23A','RG23C')
2077: THEN
2078: lv_statement_no := '41';
2079: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

Line 2081: UPDATE JAI_CMN_RG_23AC_I_TRXS

2077: THEN
2078: lv_statement_no := '41';
2079: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2080: lv_statement_no := '42';
2081: UPDATE JAI_CMN_RG_23AC_I_TRXS
2082: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
2083: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID
2084: FROM JAI_CMN_RG_23AC_II_TRXS
2085: WHERE register_id = v_rg23_part_ii_no)

Line 2092: JAI_CMN_RG_23AC_I_TRXS

2088: lv_statement_no := '43';
2089: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2090: lv_statement_no := '44';
2091: UPDATE
2092: JAI_CMN_RG_23AC_I_TRXS
2093: SET
2094: REGISTER_ID_PART_II = v_pla_register_no,
2095: charge_account_id = (
2096: SELECT