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 420: with the way JAI_CMN_RG_23AC_II_TRXS works.

416:
417: Code changes done in the package include calculating the cess amount for the current customer trx line id.
418:
419: Code changes done in the trigger include sending the customer trx line id when pla is hit . This is inline
420: with the way JAI_CMN_RG_23AC_II_TRXS works.
421:
422:
423: Dependency Due to thus bug:-
424: jai_om_rg.plb (120.4)

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

934:
935: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
936: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
937: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
939: UPDATE JAI_CMN_RG_I_TRXS
940: SET register_id_part_ii = v_rg23_part_ii_no,
941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)

Line 941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

937: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
938: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
939: UPDATE JAI_CMN_RG_I_TRXS
940: SET register_id_part_ii = v_rg23_part_ii_no,
941: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
942: WHERE register_id = v_rg23_part_ii_no)
943: WHERE register_id = v_rg23_part_i_no;
944: ELSIF l_rec.payment_register IN( 'PLA') THEN
945: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;

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

951: END IF;
952: ELSIF v_item_class IN ('RMIN','RMEX','CGIN','CGEX') THEN
953: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
954: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
956: UPDATE JAI_CMN_RG_23AC_I_TRXS
957: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)

Line 958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS

954: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
955: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
956: UPDATE JAI_CMN_RG_23AC_I_TRXS
957: SET REGISTER_ID_PART_II = v_rg23_part_ii_no,
958: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
959: WHERE register_id = v_rg23_part_ii_no)
960: WHERE register_id = v_rg23_part_i_no;
961: ELSIF l_rec.payment_register IN( 'PLA') THEN
962: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;