APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_RG_23AC_I_TRXS

Line 533: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

529: v_customer_trx_id, SYSDATE, v_reg_code,
530: v_creation_date, v_created_by,v_last_update_date,
531: v_last_updated_by, v_last_update_login );
532: vsqlstmt := '22';
533: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
534: END IF;
535: END IF;
536: IF v_reg_code in ('DOMESTIC_EXCISE','EXPORT_EXCISE') THEN
537:

Line 650: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

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
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,

Line 653: UPDATE JAI_CMN_RG_23AC_I_TRXS

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)
657: WHERE register_id = v_rg23_part_i_no;

Line 660: UPDATE JAI_CMN_RG_23AC_I_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)
664: WHERE register_id = v_rg23_part_i_no;