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);
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:
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