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 1026: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;

1022: v_match_tax_rate := v_match_tax_rate/v_tax_rate_counter;
1023: END IF;
1024: END LOOP;
1025:
1026: Select JAI_CMN_RG_23D_TRXS_S.NEXTVAL into v_register_id From Dual;
1027: IF match_rec.transaction_type = 'R'
1028: THEN
1029: v_rg23d_receipt_id := match_rec.receipt_id;
1030: ELSIF match_rec.transaction_type = 'CR'

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

1049: v_trx_date,
1050: v_ref_10,v_ref_23,v_ref_24,v_ref_25,v_ref_26);
1051: vsqlstmt := '30';
1052:
1053: jai_cmn_rg_23d_trxs_pkg.upd_receipt_qty_matched(match_rec.receipt_id,match_rec.quantity_applied,
1054: match_rec.qty_to_adjust
1055: );
1056:
1057: lv_ship_status := 'CLOSED' ;