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_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_23AC_II_TRXS

Line 394: with the way JAI_CMN_RG_23AC_II_TRXS works.

390:
391: Code changes done in the package include calculating the cess amount for the current customer trx line id.
392:
393: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
394: with the way JAI_CMN_RG_23AC_II_TRXS works.
395:
396:
397: Dependency Due to thus bug:-
398: jai_om_rg.plb (120.4)

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

828: END IF;
829: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
831: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
833: UPDATE JAI_CMN_RG_I_TRXS
834: SET register_id_part_ii = v_rg23_part_ii_no,
835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
836: WHERE register_id = v_rg23_part_ii_no)

Line 835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

831: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
832: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
833: UPDATE JAI_CMN_RG_I_TRXS
834: SET register_id_part_ii = v_rg23_part_ii_no,
835: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
836: WHERE register_id = v_rg23_part_ii_no)
837: WHERE register_id = v_rg23_part_i_no;
838: ELSIF l_rec.payment_register IN( 'PLA') THEN
839: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

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

845: END IF;
846: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
847: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
848: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
849: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
850: UPDATE JAI_CMN_RG_23AC_I_TRXS
851: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)

Line 852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

848: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
849: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
850: UPDATE JAI_CMN_RG_23AC_I_TRXS
851: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
852: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
853: WHERE register_id = v_rg23_part_ii_no)
854: WHERE register_id = v_rg23_part_i_no;
855: ELSIF l_rec.payment_register IN( 'PLA') THEN
856: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;