APPS.JAI_JAR_TRXS_TRIGGER_PKG dependencies on JAI_CMN_RG_23D_TRXS

Line 172: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b

168:
169: CURSOR matched_receipt_cur(p_customer_trx_line_id IN NUMBER) IS
170: SELECT a.receipt_id, a.quantity_applied, b.transaction_type,b.qty_to_adjust,
171: b.rate_per_unit,b.excise_duty_rate
172: FROM JAI_CMN_MATCH_RECEIPTS a, JAI_CMN_RG_23D_TRXS b
173: WHERE a.ref_line_id = p_customer_trx_line_id
174: AND a.receipt_id = b.register_id
175: AND a.quantity_applied > 0 ;
176: CURSOR tax_rate_cur(p_customer_trx_line_id IN NUMBER, p_receipt_id IN NUMBER)

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

916: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
917: END IF;
918: END LOOP;
919:
920: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
921: IF match_rec.transaction_type = 'R'
922: THEN
923: v_rg23d_receipt_id := match_rec.receipt_id;
924: ELSIF match_rec.transaction_type = 'CR'

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

943: v_trx_date,
944: v_ref_10,v_ref_23,v_ref_24,v_ref_25,v_ref_26);
945: vsqlstmt := '30';
946:
947: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id,match_rec.quantity_applied,
948: match_rec.qty_to_adjust
949: );
950:
951: lv_ship_status := 'CLOSED' ;