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_PLA_TRXS

Line 642: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

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;
643: UPDATE JAI_CMN_RG_I_TRXS
644: SET register_id_part_ii = v_pla_register_no,
645: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
646: WHERE register_id = v_pla_register_no)

Line 645: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS

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;
643: UPDATE JAI_CMN_RG_I_TRXS
644: SET register_id_part_ii = v_pla_register_no,
645: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
646: WHERE register_id = v_pla_register_no)
647: WHERE register_id = v_rg23_part_i_no;
648: END IF;
649: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN

Line 659: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

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;
660: UPDATE JAI_CMN_RG_23AC_I_TRXS
661: SET REGISTER_ID_PART_II = v_pla_register_no,
662: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
663: WHERE register_id = v_pla_register_no)

Line 662: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS

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;
660: UPDATE JAI_CMN_RG_23AC_I_TRXS
661: SET REGISTER_ID_PART_II = v_pla_register_no,
662: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
663: WHERE register_id = v_pla_register_no)
664: WHERE register_id = v_rg23_part_i_no;
665: END IF;
666: END IF;