APPS.JAI_AR_TRXS_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 182: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b

178:
179: CURSOR matched_receipt_cur(p_customer_trx_line_id IN NUMBER) IS
180: SELECT a.receipt_id, a.quantity_applied, b.transaction_type,b.qty_to_adjust,
181: b.rate_per_unit,b.excise_duty_rate
182: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b
183: WHERE a.ref_line_id = p_customer_trx_line_id
184: AND a.receipt_id = b.register_id
185: AND a.quantity_applied > 0 ;
186: CURSOR tax_rate_cur(p_customer_trx_line_id IN NUMBER, p_receipt_id IN NUMBER)

Line 716: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;

712: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
713: END IF;
714: END LOOP;
715:
716: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
717: IF match_rec.transaction_type = 'R'
718: THEN
719: v_rg23d_receipt_id := match_rec.receipt_id;
720: ELSIF match_rec.transaction_type = 'CR'

Line 743: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id,match_rec.quantity_applied,

739: v_trx_date,
740: v_ref_10,v_ref_23,v_ref_24,v_ref_25,v_ref_26);
741: vsqlstmt := '30';
742:
743: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id,match_rec.quantity_applied,
744: match_rec.qty_to_adjust
745: );
746:
747: lv_ship_status := 'CLOSED' ;