APPS.JAI_OM_RMA_PKG dependencies on JAI_OM_OE_RMA_LINES

Line 68: v_excise_duty_rate JAI_OM_OE_RMA_LINES.excise_duty_rate % TYPE;

64: v_tax_total NUMBER;
65: v_conf NUMBER;
66: v_test_id NUMBER;
67: v_exist_flag NUMBER := 0;
68: v_excise_duty_rate JAI_OM_OE_RMA_LINES.excise_duty_rate % TYPE;
69: v_rate_per_unit JAI_OM_OE_RMA_LINES.rate_per_unit % TYPE;
70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;

Line 69: v_rate_per_unit JAI_OM_OE_RMA_LINES.rate_per_unit % TYPE;

65: v_conf NUMBER;
66: v_test_id NUMBER;
67: v_exist_flag NUMBER := 0;
68: v_excise_duty_rate JAI_OM_OE_RMA_LINES.excise_duty_rate % TYPE;
69: v_rate_per_unit JAI_OM_OE_RMA_LINES.rate_per_unit % TYPE;
70: v_excise_total NUMBER;
71: v_rate_total NUMBER;
72: v_qty_total NUMBER;
73: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%type; --Added by Nagaraj.s for Bug3113027

Line 212: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------

208: THEN
209: v_rate_per_unit := ROUND((v_rate_total / v_qty_total), 2);
210: END IF;
211: END IF;
212: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
213:
214:
215: INSERT INTO JAI_OM_OE_RMA_LINES
216: (rma_line_id,

Line 215: INSERT INTO JAI_OM_OE_RMA_LINES

211: END IF;
212: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
213:
214:
215: INSERT INTO JAI_OM_OE_RMA_LINES
216: (rma_line_id,
217: rma_line_number,
218: rma_header_id,
219: rma_number,

Line 422: UPDATE JAI_OM_OE_RMA_LINES

418: THEN
419: v_tax_total := NVL(v_tax_total, 0) + v_round_tax;
420: END IF;
421: END LOOP;
422: UPDATE JAI_OM_OE_RMA_LINES
423: SET tax_amount = NVL(tax_amount, 0) + v_tax_total
424: WHERE rma_line_id = p_line_id;
425: END IF;
426: END IF;

Line 570: DELETE FROM JAI_OM_OE_RMA_LINES

566: -----------------------------------------------------------------------------------------------
567: PROCEDURE delete_data IS
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;

Line 671: FROM JAI_OM_OE_RMA_LINES

667: ELSIF p_old_cancelled_quantity <> p_new_cancelled_quantity
668: THEN
669:
670: FOR rma_rec IN (SELECT rma_line_id
671: FROM JAI_OM_OE_RMA_LINES
672: WHERE rma_line_id = p_line_id)
673: LOOP
674: v_test_id := rma_rec.rma_line_id;
675: END LOOP;

Line 719: v_rma_camount jai_om_oe_rma_lines.tax_amount % type;

715: p_transaction_quantity IN NUMBER
716: ) RETURN NUMBER
717: IS
718:
719: v_rma_camount jai_om_oe_rma_lines.tax_amount % type;
720: v_basic_ed jai_cmn_rg_23ac_ii_trxs.cr_basic_ed % type;
721: v_additional_ed jai_cmn_rg_23ac_ii_trxs.cr_additional_ed % type;
722: v_other_ed jai_cmn_rg_23ac_ii_trxs.cr_other_ed % type;
723: v_excise number;

Line 730: FROM JAI_OM_OE_RMA_LINES

726:
727: CURSOR c_get_quantity(p_rma_line_id IN NUMBER) IS
728: SELECT
729: NVL(quantity, 0) quantity
730: FROM JAI_OM_OE_RMA_LINES
731: WHERE rma_line_id = p_rma_line_id ;
732:
733: v_rma_quantity jai_om_oe_rma_lines.quantity % type;
734:

Line 733: v_rma_quantity jai_om_oe_rma_lines.quantity % type;

729: NVL(quantity, 0) quantity
730: FROM JAI_OM_OE_RMA_LINES
731: WHERE rma_line_id = p_rma_line_id ;
732:
733: v_rma_quantity jai_om_oe_rma_lines.quantity % type;
734:
735: BEGIN
736:
737: v_basic_ed := 0 ;