[Home] [Help]
590: Issue: TST1213.NON SHIPPABLE: CONSOLIDATED PATCH FOR CORE PART AND RMA OF NON-SHIPPABLE
591: Fix: 1). modified logic of getting shippable flag variable lv_shippable_flag
592: 2). added logic to copy Indian taxes from orginal Sales Order line to RMA Order line when
593: copy is happening from 'Mixed' order type to 'Return' line type.
594: 3). added logic to validate VAT Return days for Order copying from 'Standard' / 'Mixed'
595: order type to 'Return' line type.
596: 20. 13-MAY-2010 vkaranam for bug#9436523
597: issue:
598: ORA-20001: APP--20110: Taxes are not matching in JAI_OM_OE_SO_LINES and
832:
833: /*
834: || Added by aiyer for the bug 5401180,
835: || Modified the IF condition. Original Condition
836: || IF v_item_type_code = 'STANDARD'
837: || AND
838: || ( (v_reference_line_id IS NOT NULL OR v_order_category = 'RETURN')
839: || AND
840: || ( NVL(pr_new.RETURN_CONTEXT, 'XX') <> 'LEGACY') -- and legacy condition added by Aparajita for bug # 2504184
842: || AND
843: || NVL(V_Source_Document_Type_Id,0) <> 2
844: || has been replaced by the new condition.
845: */
846: IF v_item_type_code = 'STANDARD' AND
847: ( ( v_reference_line_id IS NOT NULL OR
848: pr_new.line_category_code = 'RETURN'
849: ) AND
850: pr_new.return_context IS NOT NULL
853: THEN
854: /* End of bug 5401180 */
855:
856: IF v_debug = 'Y' THEN
857: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
858: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
859: utl_file.fclose(v_myfilehandle);
860: END IF; -- v_debug
861: RETURN;