DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on OE_ORDER_LINES_ALL

Line 1600: FROM oe_order_lines_all

1596: -- Get the Org Id
1597:
1598: SELECT ORG_ID
1599: INTO l_org_id
1600: FROM oe_order_lines_all
1601: WHERE line_id = l_line_id;
1602:
1603: -- MOAC change DBMS_APPLICATION_INFO.Set_Client_Info(l_org_id);
1604: mo_global.set_policy_context('S',l_org_id);

Line 1711: FROM oe_order_lines_all

1707: BEGIN --bug 4503620
1708: IF l_top_model_line_id IS NOT NULL THEN
1709: SELECT '1'
1710: INTO l_dummy
1711: FROM oe_order_lines_all
1712: WHERE line_id= l_top_model_line_id
1713: FOR UPDATE; --Commented for bug 6415831 --nowait;
1714: END IF;
1715:

Line 1721: FROM oe_order_lines_all

1717: -- lock the row
1718:
1719: SELECT '1'
1720: INTO l_dummy
1721: FROM oe_order_lines_all
1722: WHERE line_id= l_line_id
1723: FOR UPDATE; --Commented for bug 6415831 --nowait;
1724: EXCEPTION
1725: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN