APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

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

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

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

1964: lv_statement_no := '32';
1965:
1966: /*
1967: Code modified by aiyer for the fix of the bug #3158282.
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(

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

2001: v_last_updated_by ,
2002: v_last_update_login
2003: );
2004: lv_statement_no := '33';
2005: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
2006: 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 );
2007: END IF;
2008: END IF;
2009: -- Start of Bug 3446362

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

2173: END IF;
2174:
2175: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') and nvl(v_excise_exempt_type,'$$$') not in ('CT3') THEN -- sriram - bug# 3368475
2176: lv_statement_no := '40';
2177: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2178: IF v_reg_type IN( 'RG23A','RG23C')
2179: THEN
2180: lv_statement_no := '41';
2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

Line 2183: UPDATE JAI_CMN_RG_23AC_I_TRXS

2179: THEN
2180: lv_statement_no := '41';
2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2182: lv_statement_no := '42';
2183: UPDATE JAI_CMN_RG_23AC_I_TRXS
2184: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
2185: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID
2186: FROM JAI_CMN_RG_23AC_II_TRXS
2187: WHERE register_id = v_rg23_part_ii_no)

Line 2194: JAI_CMN_RG_23AC_I_TRXS

2190: lv_statement_no := '43';
2191: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2192: lv_statement_no := '44';
2193: UPDATE
2194: JAI_CMN_RG_23AC_I_TRXS
2195: SET
2196: REGISTER_ID_PART_II = v_pla_register_no,
2197: charge_account_id = (
2198: SELECT