APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_RG_I_TRXS_S

Line 263: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;

259: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess) AND
260: jrctl.customer_trx_line_id = cp_trx_line_id;
261:
262: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
263: ln_trx_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;
264:
265:
266:
267: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;

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

510: );
511:
512:
513: vsqlstmt := '20';
514: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id from dual;
515: ELSIF v_item_class IN ('CGEX','CGIN') THEN
516: v_reg_type := 'C';
517: ELSIF v_item_class IN ('RMIN','RMEX') THEN
518: v_reg_type := 'A';

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

629: );
630: vsqlstmt := '26';
631: END IF;
632: IF v_item_class IN ('FGIN','FGEX','CCIN','CCEX') THEN
633: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_rg23_part_i_no from dual;
634: IF l_rec.payment_register IN( 'RG23A','RG23C') THEN
635: SELECT JAI_CMN_RG_23AC_II_TRXS_S.CURRVAL INTO v_rg23_part_ii_no from dual;
636: UPDATE JAI_CMN_RG_I_TRXS
637: SET register_id_part_ii = v_rg23_part_ii_no,