[Home] [Help]
361: v_round_func := 0;
362: END IF;
363:
364:
365: INSERT INTO JAI_OM_OE_RMA_TAXES
366: (rma_line_id,
367: delivery_detail_id,
368: tax_line_no,
369: precedence_1,
568: BEGIN
569:
570: DELETE FROM JAI_OM_OE_RMA_LINES
571: WHERE rma_line_id = p_line_id;
572: DELETE FROM JAI_OM_OE_RMA_TAXES
573: WHERE rma_line_id = p_line_id;
574: END delete_data;
575:
576: BEGIN
762: rtl.precedence_7,
763: rtl.precedence_8,
764: rtl.precedence_9,
765: rtl.precedence_10
766: FROM JAI_OM_OE_RMA_TAXES rtl,
767: JAI_CMN_TAXES_ALL jtc
768: WHERE rtl.rma_line_id = p_rma_line_id
769: AND jtc.tax_id = rtl.tax_id)
770: LOOP