APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 848: 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

844:
845: Reason: -
846: ======
847: This was happening as the code that calls the jai_om_rg_pkg package to insert records into any of the amount
848: 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
849: a 'CT3' type of exemption.
850:
851: Fix :-
852: ======

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

2035:
2036: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no FROM dual;
2037: IF v_reg_type IN( 'RG23A','RG23C') THEN
2038: lv_statement_no := '36';
2039: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no FROM dual;
2040: lv_statement_no := '37';
2041: UPDATE
2042: JAI_CMN_RG_I_TRXS
2043: SET

Line 2048: JAI_CMN_RG_23AC_II_TRXS

2044: register_id_part_ii = v_rg23_part_ii_no,
2045: charge_account_id = (SELECT
2046: charge_account_id
2047: FROM
2048: JAI_CMN_RG_23AC_II_TRXS
2049: WHERE
2050: register_id = v_rg23_part_ii_no
2051: )
2052: WHERE

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

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

Line 2084: FROM JAI_CMN_RG_23AC_II_TRXS

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