DBA Data[Home] [Help]

APPS.ONT_ITM_PKG dependencies on OE_ORDER_LINES_ALL

Line 1368: FROM oe_order_lines_all

1364: -- Get the Org Id
1365:
1366: SELECT ORG_ID
1367: INTO l_org_id
1368: FROM oe_order_lines_all
1369: WHERE line_id = l_line_id;
1370:
1371: -- MOAC change DBMS_APPLICATION_INFO.Set_Client_Info(l_org_id);
1372: mo_global.set_policy_context('S',l_org_id);

Line 1387: FROM oe_order_lines_all

1383: BEGIN --bug 4503620
1384: IF l_top_model_line_id IS NOT NULL THEN
1385: SELECT '1'
1386: INTO l_dummy
1387: FROM oe_order_lines_all
1388: WHERE line_id= l_top_model_line_id
1389: FOR UPDATE; --Commented for bug 6415831 --nowait;
1390: END IF;
1391:

Line 1397: FROM oe_order_lines_all

1393: -- lock the row
1394:
1395: SELECT '1'
1396: INTO l_dummy
1397: FROM oe_order_lines_all
1398: WHERE line_id= l_line_id
1399: FOR UPDATE; --Commented for bug 6415831 --nowait;
1400: EXCEPTION
1401: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN