DBA Data[Home] [Help]

APPS.AHL_ROUTE_APPROVAL_PVT dependencies on AHL_ROUTES_B

Line 1327: UPDATE AHL_ROUTES_B

1323: CLOSE GetRouteDet;
1324:
1325: if l_route_rec.REVISION_STATUS_CODE='APPROVAL_PENDING'
1326: THEN
1327: UPDATE AHL_ROUTES_B
1328: SET REVISION_STATUS_CODE = 'DRAFT',
1329: object_version_number =l_object_version_number+1
1330: WHERE route_id = l_object_id
1331: and object_Version_number=l_object_version_number;

Line 1333: UPDATE AHL_ROUTES_B

1329: object_version_number =l_object_version_number+1
1330: WHERE route_id = l_object_id
1331: and object_Version_number=l_object_version_number;
1332: ELSE
1333: UPDATE AHL_ROUTES_B
1334: SET REVISION_STATUS_CODE = 'COMPLETE',
1335: object_version_number =l_object_version_number+1
1336: WHERE route_id = l_object_id
1337: and object_Version_number=l_object_version_number;