47:
48: SAVEPOINT Before_Lock;
49:
50: select top_model_line_id into l_top_model_line_id
51: from oe_order_lines_all where
52: line_id = to_number(itemkey);
53:
54: -- bug 4503620
55: BEGIN
54: -- bug 4503620
55: BEGIN
56: IF l_top_model_line_id is not null then
57: select '1' into l_dummy
58: from oe_order_lines_all
59: where line_id = l_top_model_line_id
60: for update; --commented for bug 6415831 -- nowait;
61: END IF;
62: EXCEPTION