DBA Data[Home] [Help]

APPS.WIP_SO_RESERVATIONS dependencies on OE_ORDER_LINES_ALL

Line 760: -- we shouldn't be locking oe_order_lines_all directly

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

Line 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:

Line 1725: -- we shouldn't be locking oe_order_lines_all directly

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

Line 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: