143: where line_id = to_number(pr_old.interface_line_attribute6);
144:
145: cursor c_check_rma_line is
146: select 1
147: from JAI_OM_OE_RMA_LINES
148: where rma_line_id = to_number(pr_old.interface_line_attribute6);
149:
150: v_so_line_check Number :=0;
151: v_rma_line_check Number :=0;
4264: ||Added by Ramananda for the bug 4567935 (115 bug4404898)
4265: */
4266: CURSOR SO_RMA_LINES_INFO IS
4267: SELECT tax_category_id, assessable_value, service_type_code -- service_type_code added by csahoo for bug#5879769
4268: FROM JAI_OM_OE_RMA_LINES
4269: WHERE rma_line_id = v_interface_line_attribute7;
4270: /*
4271: ||End of bug 4567935
4272: */
4292:
4293: /* Cursor To Check Whether Interfaced Record Exist in JAI_OM_WSH_LINES_ALL */
4294: CURSOR SO_RMA_RECORD_CHECK IS
4295: SELECT 1
4296: FROM JAI_OM_OE_RMA_LINES
4297: WHERE rma_line_id = v_interface_line_attribute7;
4298:
4299:
4300: CURSOR SO_RMA_TAX_RECORD_CHECK IS
4313:
4314:
4315: CURSOR SO_RMA_QUANTITY_CHECK IS
4316: SELECT NVL(quantity,0)
4317: FROM JAI_OM_OE_RMA_LINES
4318: WHERE rma_line_id = v_interface_line_attribute7;
4319:
4320: /* bug 5243532. Added by Lakshmi Gopalsami
4321: Removed the reference to cursor set_of_books_cur