APPS.JAI_OM_WSH_PKG dependencies on JAI_CMN_RG_PLA_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 2056: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

2052: WHERE
2053: register_id = v_rg23_part_i_no;
2054: ELSIF v_reg_type IN( 'PLA') THEN
2055: lv_statement_no := '38';
2056: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;
2057: lv_statement_no := '39';
2058: UPDATE
2059: JAI_CMN_RG_I_TRXS
2060: SET

Line 2065: JAI_CMN_RG_PLA_TRXS

2061: register_id_part_ii = v_pla_register_no,
2062: charge_account_id = (
2063: SELECT CHARGE_ACCOUNT_ID
2064: FROM
2065: JAI_CMN_RG_PLA_TRXS
2066: WHERE
2067: register_id = v_pla_register_no
2068: )
2069: WHERE

Line 2089: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no FROM dual;

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

Line 2098: FROM JAI_CMN_RG_PLA_TRXS

2094: REGISTER_ID_PART_II = v_pla_register_no,
2095: charge_account_id = (
2096: SELECT
2097: charge_account_id
2098: FROM JAI_CMN_RG_PLA_TRXS
2099: WHERE
2100: register_id = v_pla_register_no
2101: )
2102: WHERE register_id = v_rg23_part_i_no;