DBA Data[Home] [Help]

APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_I_TRXS_S

Line 265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */

261: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
262: jrctl.customer_trx_line_id = cp_trx_line_id;
263:
264: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE; /* End of bug 4346220 */
265: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE; /* added by ssawant for bug 5989740 */
266:
267:
268: /* End of bug 4566054 */
269:

Line 714: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;

710: );
711:
712:
713: vsqlstmt := '20';
714: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
715: ELSIF v_item_class IN ('CGEX','CGIN') THEN
716: v_reg_type := 'C';
717: ELSIF v_item_class IN ('RMIN','RMEX') THEN
718: v_reg_type := 'A';

Line 830: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;

826: );
827: vsqlstmt := '26';
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,