eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

631: END IF;
632: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
633: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
634: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
636: UPDATE JAI_CMN_RG_I_TRXS
637: SET register_id_part_ii = v_rg23_part_ii_no,
638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
639: WHERE register_id = v_rg23_part_ii_no)

Line 638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

634: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
636: UPDATE JAI_CMN_RG_I_TRXS
637: SET register_id_part_ii = v_rg23_part_ii_no,
638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
639: WHERE register_id = v_rg23_part_ii_no)
640: WHERE register_id = v_rg23_part_i_no;
641: ELSIF l_rec.payment_register IN( 'PLA') THEN
642: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

Line 652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;

648: END IF;
649: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
650: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
651: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
653: UPDATE JAI_CMN_RG_23AC_I_TRXS
654: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
655: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
656: WHERE register_id = v_rg23_part_ii_no)

Line 655: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

651: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
652: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
653: UPDATE JAI_CMN_RG_23AC_I_TRXS
654: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
655: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
656: WHERE register_id = v_rg23_part_ii_no)
657: WHERE register_id = v_rg23_part_i_no;
658: ELSIF l_rec.payment_register IN( 'PLA') THEN
659: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;