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 230: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------

226: THEN
227: v_rate_per_unit := ROUND((v_rate_total / v_qty_total), 2);
228: END IF;
229: END IF;
230: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
231:
232:
233: INSERT INTO JAI_OM_OE_RMA_LINES
234: (rma_line_id,

Line 233: INSERT INTO JAI_OM_OE_RMA_LINES

229: END IF;
230: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
231:
232:
233: INSERT INTO JAI_OM_OE_RMA_LINES
234: (rma_line_id,
235: rma_line_number,
236: rma_header_id,
237: rma_number,

Line 440: UPDATE JAI_OM_OE_RMA_LINES

436: THEN
437: v_tax_total := NVL(v_tax_total, 0) + v_round_tax;
438: END IF;
439: END LOOP;
440: UPDATE JAI_OM_OE_RMA_LINES
441: SET tax_amount = NVL(tax_amount, 0) + v_tax_total
442: WHERE rma_line_id = p_line_id;
443: END IF;
444:

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

491: v_vat_flag := 'N';
492: END IF; -- v_vat_return_days IS NULL OR ......
493: -- added by Allen Yang for bug 9691880 10-May-2010, end
494:
495: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
496: INSERT INTO JAI_OM_OE_RMA_LINES
497: (rma_line_id,
498: rma_line_number,
499: rma_header_id,

Line 496: INSERT INTO JAI_OM_OE_RMA_LINES

492: END IF; -- v_vat_return_days IS NULL OR ......
493: -- added by Allen Yang for bug 9691880 10-May-2010, end
494:
495: ---------------------- For inserting record in JAI_OM_OE_RMA_LINES --------------------
496: INSERT INTO JAI_OM_OE_RMA_LINES
497: (rma_line_id,
498: rma_line_number,
499: rma_header_id,
500: rma_number,

Line 657: UPDATE JAI_OM_OE_RMA_LINES

653: -- modified by Allen Yang for bug 9691880 10-May-2010, end
654: END IF; --tax_line_rec.tax_type <> 'TDS'
655: END LOOP; --tax_line_rec IN (SELECT tax_line_no ......
656:
657: UPDATE JAI_OM_OE_RMA_LINES
658: SET tax_amount = NVL(tax_amount, 0) + v_tax_total
659: WHERE rma_line_id = p_line_id;
660: END IF; -- p_new_ordered_quantity <> 0
661: END IF; -- v_delivery_detail_id IS NOT NULL

Line 806: DELETE FROM JAI_OM_OE_RMA_LINES

802: -----------------------------------------------------------------------------------------------
803: PROCEDURE delete_data IS
804: BEGIN
805:
806: DELETE FROM JAI_OM_OE_RMA_LINES
807: WHERE rma_line_id = p_line_id;
808: DELETE FROM JAI_OM_OE_RMA_TAXES
809: WHERE rma_line_id = p_line_id;
810: END delete_data;

Line 921: FROM JAI_OM_OE_RMA_LINES

917: ELSIF p_old_cancelled_quantity <> p_new_cancelled_quantity
918: THEN
919:
920: FOR rma_rec IN (SELECT rma_line_id
921: FROM JAI_OM_OE_RMA_LINES
922: WHERE rma_line_id = p_line_id)
923: LOOP
924: v_test_id := rma_rec.rma_line_id;
925: END LOOP;

Line 974: v_rma_camount jai_om_oe_rma_lines.tax_amount % type;

970: p_transaction_quantity IN NUMBER
971: ) RETURN NUMBER
972: IS
973:
974: v_rma_camount jai_om_oe_rma_lines.tax_amount % type;
975: v_basic_ed jai_cmn_rg_23ac_ii_trxs.cr_basic_ed % type;
976: v_additional_ed jai_cmn_rg_23ac_ii_trxs.cr_additional_ed % type;
977: v_other_ed jai_cmn_rg_23ac_ii_trxs.cr_other_ed % type;
978: v_excise number;

Line 985: FROM JAI_OM_OE_RMA_LINES

981:
982: CURSOR c_get_quantity(p_rma_line_id IN NUMBER) IS
983: SELECT
984: NVL(quantity, 0) quantity
985: FROM JAI_OM_OE_RMA_LINES
986: WHERE rma_line_id = p_rma_line_id ;
987:
988: v_rma_quantity jai_om_oe_rma_lines.quantity % type;
989:

Line 988: v_rma_quantity jai_om_oe_rma_lines.quantity % type;

984: NVL(quantity, 0) quantity
985: FROM JAI_OM_OE_RMA_LINES
986: WHERE rma_line_id = p_rma_line_id ;
987:
988: v_rma_quantity jai_om_oe_rma_lines.quantity % type;
989:
990: BEGIN
991:
992: v_basic_ed := 0 ;