APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 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

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 :-
880: ======

Line 2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

2137:
2138: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2139: IF v_reg_type IN( 'RG23A','RG23C') THEN
2140: lv_statement_no := '36';
2141: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2142: lv_statement_no := '37';
2143: UPDATE
2144: JAI_CMN_RG_I_TRXS
2145: SET

Line 2150: JAI_CMN_RG_23AC_II_TRXS

2146: register_id_part_ii = v_rg23_part_ii_no,
2147: charge_account_id = (SELECT
2148: charge_account_id
2149: FROM
2150: JAI_CMN_RG_23AC_II_TRXS
2151: WHERE
2152: register_id = v_rg23_part_ii_no
2153: )
2154: WHERE

Line 2181: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;

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;
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

Line 2186: FROM JAI_CMN_RG_23AC_II_TRXS

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)
2188: WHERE register_id = v_rg23_part_i_no;
2189: ELSIF v_reg_type IN( 'PLA') THEN
2190: lv_statement_no := '43';