APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 262: ln_trx_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;

258: jrcttl.tax_id = jtc.tax_id AND
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:

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,

Line 636: UPDATE JAI_CMN_RG_I_TRXS

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,
638: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_23AC_II_TRXS
639: WHERE register_id = v_rg23_part_ii_no)
640: WHERE register_id = v_rg23_part_i_no;

Line 643: UPDATE JAI_CMN_RG_I_TRXS

639: WHERE register_id = v_rg23_part_ii_no)
640: WHERE register_id = v_rg23_part_i_no;
641: ELSIF l_rec.payment_register IN( 'PLA') THEN
642: SELECT JAI_CMN_RG_PLA_TRXS_S1.CURRVAL INTO v_pla_register_no from dual;
643: UPDATE JAI_CMN_RG_I_TRXS
644: SET register_id_part_ii = v_pla_register_no,
645: CHARGE_ACCOUNT_ID = (SELECT CHARGE_ACCOUNT_ID FROM JAI_CMN_RG_PLA_TRXS
646: WHERE register_id = v_pla_register_no)
647: WHERE register_id = v_rg23_part_i_no;