756: BEGIN
757:
758: l_skip_flag := FALSE; /* Bug 2976994 */
759:
760: -- we shouldn't be locking oe_order_lines_all directly
761: -- this is tempoary until ONT provides a locking api
762: SELECT line_id
763: INTO l_line_id
764: FROM oe_order_lines_all
760: -- we shouldn't be locking oe_order_lines_all directly
761: -- this is tempoary until ONT provides a locking api
762: SELECT line_id
763: INTO l_line_id
764: FROM oe_order_lines_all
765: WHERE line_id = p_transaction_tbl(i).demand_source_line_id
766: FOR UPDATE;
767:
768:
1721: ----------------------------------
1722:
1723: BEGIN
1724:
1725: -- we shouldn't be locking oe_order_lines_all directly
1726: -- this is tempoary until ONT provides a locking api
1727: SELECT line_id
1728: INTO l_line_id
1729: FROM oe_order_lines_all
1725: -- we shouldn't be locking oe_order_lines_all directly
1726: -- this is tempoary until ONT provides a locking api
1727: SELECT line_id
1728: INTO l_line_id
1729: FROM oe_order_lines_all
1730: WHERE line_id = p_transaction_rec.demand_source_line_id ;
1731: -- FOR UPDATE;
1732:
1733: