[Home] [Help]
498: l_line_rec.split_from_line_id);
499: BEGIN
500: SELECT orig_sys_line_ref, orig_sys_shipment_ref
501: INTO l_line_rec.split_from_line_ref, l_line_rec.split_from_shipment_ref
502: FROM OE_ORDER_LINES
503: WHERE line_id = l_line_rec.split_from_line_id;
504: EXCEPTION
505: WHEN OTHERS THEN
506: oe_debug_pub.add('bsadri failed to get the refernce for split line');
1831: --bsadri get the split reference
1832: Begin
1833: Select orig_sys_line_ref, orig_sys_shipment_ref
1834: Into l_line_tbl(i).split_from_line_ref, l_line_tbl(i).split_from_shipment_ref
1835: From OE_ORDER_LINES
1836: Where line_id = l_line_tbl(i).split_from_line_id;
1837: Exception
1838: When Others Then
1839: Null;